a guest Feb 24th, 2020 65 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand