Commit | Line | Data |
---|---|---|
b3d23594 PM |
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 |