database/schema.sql

   1 -- Adminer 4.7.6 MySQL dump
   2
   3 SET NAMES utf8;
   4 SET time_zone = '+00:00';
   5 SET foreign_key_checks = 0;
   6 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
   7
   8 DROP TABLE IF EXISTS `admin_sessions`;
   9 CREATE TABLE `admin_sessions` (
  10   `id` int(11) NOT NULL AUTO_INCREMENT,
  11   `php_session` varchar(50) NOT NULL,
  12   `php_page` varchar(300) NOT NULL,
  13   `loaded_on_date` date NOT NULL,
  14   `action_on` timestamp NOT NULL,
  15   `username` varchar(50) NOT NULL,
  16   `ip` varchar(50) NOT NULL,
  17   `browser_string` varchar(400) NOT NULL,
  18   PRIMARY KEY (`id`)
  19 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  20
  21
  22 DROP TABLE IF EXISTS `follow_up`;
  23 CREATE TABLE `follow_up` (
  24   `id` int(11) NOT NULL AUTO_INCREMENT,
  25   `name` varchar(200) NOT NULL,
  26   `email` varchar(300) NOT NULL,
  27   `php_session` varchar(300) NOT NULL,
  28   `status` varchar(300) NOT NULL DEFAULT 'NEW',
  29   `petition_id` int(10) NOT NULL,
  30   `feedback_message` text NOT NULL,
  31   `system_response` text NOT NULL,
  32   `date_sent` date NOT NULL,
  33   PRIMARY KEY (`id`),
  34   UNIQUE KEY `email` (`email`)
  35 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  36
  37
  38 DROP TABLE IF EXISTS `groups`;
  39 CREATE TABLE `groups` (
  40   `id` int(11) NOT NULL AUTO_INCREMENT,
  41   `name` varchar(200) NOT NULL,
  42   `logo` varchar(250) NOT NULL,
  43   `background-color` varchar(10) NOT NULL,
  44   PRIMARY KEY (`id`)
  45 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  46
  47
  48 DROP TABLE IF EXISTS `petitions`;
  49 CREATE TABLE `petitions` (
  50   `petition_id` int(11) NOT NULL AUTO_INCREMENT,
  51   `admin_status` varchar(20) NOT NULL DEFAULT 'new',
  52   `admin_sort` int(5) NOT NULL,
  53   `web_short_name` varchar(200) NOT NULL,
  54   `web_color` varchar(20) NOT NULL,
  55   `web_color_text` varchar(20) NOT NULL DEFAULT '#000000',
  56   `group_id` int(11) NOT NULL,
  57   `signature_goal` int(100) NOT NULL,
  58   `petition_name` varchar(200) NOT NULL,
  59   `petition_pdf` varchar(250) NOT NULL,
  60   `petition_jpg` varchar(250) NOT NULL,
  61   `petition_jpg_page2` varchar(250) NOT NULL,
  62   `eligibleVoterListField` varchar(250) NOT NULL,
  63   `eligibleVoterListEquals` varchar(250) NOT NULL,
  64   `eligibleVoterListEnforce` varchar(5) NOT NULL,
  65   `eligibleVoterSigMatch` varchar(5) NOT NULL,
  66   `petition_sign_text_box` text NOT NULL,
  67   `petition_circulator_text_box` text NOT NULL,
  68   `eligibleVoterListWarning` text NOT NULL,
  69   `text_cord_county` varchar(50) NOT NULL,
  70   `text_cord_cityX` varchar(50) NOT NULL,
  71   `hide_county_on_petition` varchar(50) NOT NULL DEFAULT 'NO',
  72   `offset_x_cords` int(11) NOT NULL,
  73   `offset_x_cords_circulator` int(11) NOT NULL,
  74   `offset_y_cords` int(11) NOT NULL,
  75   `offset_y_cords_circulator` int(11) NOT NULL,
  76   `tab_name` varchar(200) NOT NULL,
  77   `text_title` varchar(200) NOT NULL,
  78   `text_block` text NOT NULL,
  79   `logo_url` varchar(300) NOT NULL,
  80   `landing_page` varchar(300) NOT NULL,
  81   `social_website` varchar(300) NOT NULL,
  82   `social_twitter` varchar(300) NOT NULL,
  83   `social_facebook` varchar(300) NOT NULL,
  84   `social_email` varchar(300) NOT NULL,
  85   `social_phone` varchar(300) NOT NULL,
  86   PRIMARY KEY (`petition_id`),
  87   UNIQUE KEY `web_short_name` (`web_short_name`),
  88   KEY `group_id` (`group_id`)
  89 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  90
  91
  92 DROP TABLE IF EXISTS `presign`;
  93 CREATE TABLE `presign` (
  94   `id` int(11) NOT NULL AUTO_INCREMENT,
  95   `action_on` varchar(100) NOT NULL,
  96   `only_date` date NOT NULL,
  97   `php_session_id` varchar(300) NOT NULL,
  98   `php_page` varchar(300) NOT NULL,
  99   `name` varchar(200) NOT NULL,
 100   `petition` varchar(200) NOT NULL,
 101   `invite` varchar(200) NOT NULL,
 102   `invite_error` varchar(200) NOT NULL,
 103   `email_for_follow_up` varchar(200) NOT NULL,
 104   `phone_for_validation` varchar(200) NOT NULL,
 105   `presign_status` varchar(200) DEFAULT 'NEW',
 106   `ip_address` varchar(300) NOT NULL,
 107   `browser_string` varchar(300) NOT NULL,
 108   PRIMARY KEY (`id`)
 109 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 110
 111
 112 DROP TABLE IF EXISTS `signatures`;
 113 CREATE TABLE `signatures` (
 114   `id` int(11) NOT NULL AUTO_INCREMENT,
 115   `VTRID` int(11) NOT NULL,
 116   `ip_address` varchar(200) NOT NULL,
 117   `date_of_birth` varchar(200) NOT NULL,
 118   `date_time_signed` datetime NOT NULL,
 119   `just_date` date NOT NULL,
 120   `petition_id` int(11) NOT NULL,
 121   `signed_name_as` varchar(250) NOT NULL,
 122   `signed_name_as_circulator` varchar(250) NOT NULL,
 123   `contact_phone` varchar(250) NOT NULL,
 124   `signature_status` varchar(250) NOT NULL,
 125   `printed_status` varchar(250) NOT NULL,
 126   `bot_check` text NOT NULL,
 127   `php_session_id` varchar(100) NOT NULL,
 128   PRIMARY KEY (`id`)
 129 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 130
 131
 132 DROP TABLE IF EXISTS `users`;
 133 CREATE TABLE `users` (
 134   `id` int(11) NOT NULL AUTO_INCREMENT,
 135   `petition_id` int(11) NOT NULL,
 136   `email` varchar(200) NOT NULL,
 137   `name` varchar(100) NOT NULL,
 138   `pass` varchar(250) NOT NULL,
 139   `group_id` int(5) NOT NULL,
 140   `sec_level` varchar(20) NOT NULL,
 141   PRIMARY KEY (`id`),
 142   UNIQUE KEY `email` (`email`)
 143 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 144
 145
 146 DROP TABLE IF EXISTS `VoterList`;
 147 CREATE TABLE `VoterList` (
 148   `VTRID` int(11) NOT NULL,
 149   `LASTNAME` varchar(200) NOT NULL,
 150   `FIRSTNAME` varchar(200) NOT NULL,
 151   `MIDDLENAME` varchar(200) NOT NULL,
 152   `SUFFIX` varchar(200) NOT NULL,
 153   `GENDER` varchar(200) NOT NULL,
 154   `PARTY` varchar(200) NOT NULL,
 155   `HOUSE_NUMBER` varchar(200) NOT NULL,
 156   `HOUSE_SUFFIX` varchar(200) NOT NULL,
 157   `STREET_PREDIRECTION` varchar(200) NOT NULL,
 158   `STREETNAME` varchar(200) NOT NULL,
 159   `STREETTYPE` varchar(200) NOT NULL,
 160   `STREET_POSTDIRECTION` varchar(200) NOT NULL,
 161   `UNITTYPE` varchar(200) NOT NULL,
 162   `UNITNUMBER` varchar(200) NOT NULL,
 163   `ADDRESS` varchar(200) NOT NULL,
 164   `NON_STD_ADDRESS` varchar(200) NOT NULL,
 165   `RESIDENTIALCITY` varchar(200) NOT NULL,
 166   `RESIDENTIALSTATE` varchar(200) NOT NULL,
 167   `RESIDENTIALZIP5` varchar(200) NOT NULL,
 168   `RESIDENTIALZIP4` varchar(200) NOT NULL,
 169   `MAILINGADDRESS` varchar(200) NOT NULL,
 170   `MAILINGCITY` varchar(200) NOT NULL,
 171   `MAILINGSTATE` varchar(200) NOT NULL,
 172   `MAILINGZIP5` varchar(200) NOT NULL,
 173   `MAILINGZIP4` varchar(200) NOT NULL,
 174   `COUNTRY` varchar(200) NOT NULL,
 175   `STATUS_CODE` varchar(200) NOT NULL,
 176   `STATE_REGISTRATION_DATE` varchar(200) NOT NULL,
 177   `COUNTY_REGISTRATION_DATE` varchar(200) NOT NULL,
 178   `PRECINCT` varchar(200) NOT NULL,
 179   `SPLIT` varchar(200) NOT NULL,
 180   `COUNTY` varchar(200) NOT NULL,
 181   `CONGRESSIONAL_DISTRICTS` varchar(200) NOT NULL,
 182   `LEGISLATIVE_DISTRICTS` varchar(200) NOT NULL,
 183   `COUNCILMANIC_DISTRICTS` varchar(200) NOT NULL,
 184   `WARD_DISTRICTS` varchar(200) NOT NULL,
 185   `MUNICIPAL_DISTRICTS` varchar(200) NOT NULL,
 186   `COMMISSIONER_DISTRICTS` varchar(200) NOT NULL,
 187   `SCHOOL_DISTRICTS` varchar(200) NOT NULL,
 188   UNIQUE KEY `VTRID` (`VTRID`),
 189   KEY `LASTNAME` (`LASTNAME`),
 190   KEY `FIRSTNAME` (`FIRSTNAME`),
 191   KEY `HOUSE_NUMBER` (`HOUSE_NUMBER`),
 192   KEY `RESIDENTIALZIP5` (`RESIDENTIALZIP5`)
 193 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 194
 195
 196 DROP TABLE IF EXISTS `website_text`;
 197 CREATE TABLE `website_text` (
 198   `id` int(10) NOT NULL AUTO_INCREMENT,
 199   `text_title` varchar(200) NOT NULL,
 200   `text_block` text NOT NULL,
 201   PRIMARY KEY (`id`)
 202 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 203
 204
 205 -- 2020-07-02 13:19:50