BEGIN TRANSACTION;insert into BallotLog_T select * from BallotLog;drop table BallotLog;CREATE TABLE 'BallotLog' ('StateVoterID' varchar(20) DEFAULT NULL,'CountyCode' varchar(20) DEFAULT NULL,'Operator' varchar(100) DEFAULT NULL,'PrecinctComboID' int(11) DEFAULT NULL,'BeginTranTS' varchar(20) DEFAULT NULL,'EndTranTS' varchar(20) DEFAULT NULL,'VoteType' varchar(1) DEFAULT NULL,'BallotType' varchar(1) DEFAULT NULL,'BallotStyle' varchar(30) DEFAULT NULL,'BallotNo' varchar(20) DEFAULT NULL,'Provisional' char(1) DEFAULT NULL,'Challenged' char(1) DEFAULT NULL,'Spoiled' char(1) DEFAULT NULL,'SearchType' char(1) DEFAULT NULL,'Signature' char(1) DEFAULT NULL,'SigFileName' varchar(50) DEFAULT NULL,'ErrType' varchar(15) DEFAULT '','ErrorTS' varchar(20) DEFAULT NULL,'ProvReason' varchar(40) DEFAULT NULL,'AssetID' mediumint(9) DEFAULT NULL,'SeqNo' mediumint(9) DEFAULT NULL,'VoterUpdates' char(1) DEFAULT NULL,'Language' varchar(20) DEFAULT NULL,'AbsSurrendered' varchar(1) DEFAULT NULL,'PWIFileName' varchar(55) DEFAULT NULL,'ProvTrackingNo' varchar(8) DEFAULT NULL,'IDType' varchar(1) NOT NULL DEFAULT '','RecordID' varchar(200) DEFAULT NULL,'NameChangeDoc' varchar(200) DEFAULT NULL,'NoPhotoIDReason' varchar(200) DEFAULT NULL,'CheckInStreetAddr' varchar(100) DEFAULT NULL,'CheckInCity' varchar(50) DEFAULT NULL,'CheckInZip' varchar(5) DEFAULT NULL,'RequestHelp' varchar(1) DEFAULT NULL,'PartyDeclared' varchar(20) DEFAULT NULL,'PrecinctID' int(11) DEFAULT NULL,'ProofOfResidence' varchar(200) DEFAULT NULL,'SpoiledPages' varchar(50) DEFAULT NULL,'AvidNo' varchar(20) DEFAULT NULL );insert into BallotLog select * from BallotLog_T;END TRANSACTION;