Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `state_boe` (
- `LASTNAME` varchar(255) DEFAULT NULL,
- `FIRSTNAME` varchar(255) DEFAULT NULL,
- `MIDDLENAME` varchar(255) DEFAULT NULL,
- `NAMESUFFIX` varchar(255) DEFAULT NULL,
- `RADDNUMBER` varchar(255) DEFAULT NULL,
- `RHALFCODE` varchar(255) DEFAULT NULL,
- `RAPARTMENT` varchar(255) DEFAULT NULL,
- `RPREDIRECTION` varchar(255) DEFAULT NULL,
- `RSTREETNAME` varchar(255) DEFAULT NULL,
- `RPOSTDIRECTION` varchar(255) DEFAULT NULL,
- `RCITY` varchar(255) DEFAULT NULL,
- `RZIP5` varchar(255) DEFAULT NULL,
- `RZIP4` varchar(255) DEFAULT NULL,
- `MAILADD1` varchar(255) DEFAULT NULL,
- `MAILADD2` varchar(255) DEFAULT NULL,
- `MAILADD3` varchar(255) DEFAULT NULL,
- `MAILADD4` varchar(255) DEFAULT NULL,
- `DOB` varchar(255) DEFAULT NULL,
- `GENDER` varchar(255) DEFAULT NULL,
- `ENROLLMENT` varchar(255) DEFAULT NULL,
- `OTHERPARTY` varchar(255) DEFAULT NULL,
- `COUNTYCODE` int(11) DEFAULT NULL,
- `ELECTION_DISTRICT` int(11) DEFAULT NULL,
- `LEGISLATIVE_DISTRICT` int(11) DEFAULT NULL,
- `TOWN` varchar(255) DEFAULT NULL,
- `WARD` varchar(255) DEFAULT NULL,
- `CONGRESS_DISTRICT` int(11) DEFAULT NULL,
- `SENATE_DISTRICT` int(11) DEFAULT NULL,
- `ASSEMBLY_DISTRICT` int(11) DEFAULT NULL,
- `LASTVOTEDATE` varchar(255) DEFAULT NULL,
- `PREVYEARVOTED` varchar(255) DEFAULT NULL,
- `PREVCOUNTY` varchar(255) DEFAULT NULL,
- `PREVADDRESS` varchar(255) DEFAULT NULL,
- `PREVNAME` varchar(255) DEFAULT NULL,
- `COUNTYVRNUMBER` varchar(255) DEFAULT NULL,
- `REGDATE` varchar(255) DEFAULT NULL,
- `VRSOURCE` varchar(255) DEFAULT NULL,
- `IDREQUIRED` varchar(255) DEFAULT NULL,
- `IDMET` varchar(255) DEFAULT NULL,
- `STATUS` varchar(255) DEFAULT NULL,
- `REASONCODE` varchar(255) DEFAULT NULL,
- `INACT_DATE` varchar(255) DEFAULT NULL,
- `PURGE_DATE` varchar(255) DEFAULT NULL,
- `SBOEID` varchar(255) DEFAULT NULL,
- `VOTER_HISTORY` varchar(32767) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement