HqFUWwQE

1# ************************************************************
2# Sequel Pro SQL dump
3# Version 4499
4#
5# http://www.sequelpro.com/
6# https://github.com/sequelpro/sequelpro
7#
8# Host: 127.0.0.1 (MySQL 5.7.17-0ubuntu0.16.04.1)
9# Database: automated
10# Generation Time: 2017-01-23 13:46:31 +0000
11# ************************************************************
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
21
22
23# Dump of table languages
24# ------------------------------------------------------------
25
26DROP TABLE IF EXISTS `languages`;
27
28CREATE TABLE `languages` (
29  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
30  `language` varchar(200) DEFAULT NULL,
31  `file` varchar(20) DEFAULT NULL,
32  PRIMARY KEY (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
34
35LOCK TABLES `languages` WRITE;
36/*!40000 ALTER TABLE `languages` DISABLE KEYS */;
37
38INSERT INTO `languages` (`id`, `language`, `file`)
39VALUES
40	(1,'U.S. English','en-us.php'),
41	(2,'Español','es-mx.php');
42
43/*!40000 ALTER TABLE `languages` ENABLE KEYS */;
44UNLOCK TABLES;
45
46
47# Dump of table mail_log
48# ------------------------------------------------------------
49
50DROP TABLE IF EXISTS `mail_log`;
51
52CREATE TABLE `mail_log` (
53  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
54  `recipient` varchar(255) DEFAULT NULL,
55  `date_sent` timestamp NULL DEFAULT NULL,
56  PRIMARY KEY (`id`)
57) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
58
59LOCK TABLES `mail_log` WRITE;
60/*!40000 ALTER TABLE `mail_log` DISABLE KEYS */;
61
62INSERT INTO `mail_log` (`id`, `recipient`, `date_sent`)
63VALUES
64	(1,NULL,NULL);
65
66/*!40000 ALTER TABLE `mail_log` ENABLE KEYS */;
67UNLOCK TABLES;
68
69
70# Dump of table poll_choice_translations
71# ------------------------------------------------------------
72
73DROP TABLE IF EXISTS `poll_choice_translations`;
74
75CREATE TABLE `poll_choice_translations` (
76  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
77  `language_id` int(11) unsigned DEFAULT NULL,
78  `poll_choice_id` int(11) unsigned DEFAULT NULL,
79  `display` varchar(255) DEFAULT NULL,
80  `description` mediumtext,
81  PRIMARY KEY (`id`),
82  KEY `poll_choice_id` (`poll_choice_id`),
83  CONSTRAINT `poll_choice_translations_ibfk_1` FOREIGN KEY (`poll_choice_id`) REFERENCES `poll_choices` (`id`) ON DELETE CASCADE
84) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
85
86
87
88# Dump of table poll_choices
89# ------------------------------------------------------------
90
91DROP TABLE IF EXISTS `poll_choices`;
92
93CREATE TABLE `poll_choices` (
94  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
95  `poll_id` int(11) unsigned DEFAULT NULL,
96  `nota` tinyint(1) DEFAULT NULL COMMENT 'flag if this option represents a none of the above option (prevents votes for other options)',
97  PRIMARY KEY (`id`),
98  KEY `poll_id` (`poll_id`),
99  CONSTRAINT `poll_choices_ibfk_1` FOREIGN KEY (`poll_id`) REFERENCES `poll_info` (`id`) ON DELETE CASCADE
100) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
101
102
103
104# Dump of table poll_info
105# ------------------------------------------------------------
106
107DROP TABLE IF EXISTS `poll_info`;
108
109CREATE TABLE `poll_info` (
110  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
111  `type` varchar(15) DEFAULT NULL,
112  `date_added` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
113  `date_opens` timestamp NULL DEFAULT NULL,
114  `date_closes` timestamp NULL DEFAULT NULL,
115  `date_activated` timestamp NULL DEFAULT NULL,
116  PRIMARY KEY (`id`)
117) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
118
119
120
121# Dump of table poll_translations
122# ------------------------------------------------------------
123
124DROP TABLE IF EXISTS `poll_translations`;
125
126CREATE TABLE `poll_translations` (
127  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
128  `poll_id` int(11) unsigned NOT NULL,
129  `language_id` int(11) DEFAULT NULL,
130  `title` varchar(255) DEFAULT NULL,
131  `description` mediumtext,
132  PRIMARY KEY (`id`),
133  KEY `poll_id` (`poll_id`),
134  CONSTRAINT `poll_translations_ibfk_1` FOREIGN KEY (`poll_id`) REFERENCES `poll_info` (`id`) ON DELETE CASCADE
135) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
136
137
138
139# Dump of table users
140# ------------------------------------------------------------
141
142DROP TABLE IF EXISTS `users`;
143
144CREATE TABLE `users` (
145  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
146  `email` varchar(255) DEFAULT NULL,
147  `name` varchar(60) DEFAULT NULL,
148  `zipcode` varchar(10) DEFAULT NULL,
149  `password` varchar(255) DEFAULT NULL,
150  `is_admin` tinyint(1) DEFAULT NULL,
151  `validated` tinyint(1) DEFAULT NULL,
152  `validation_key` varchar(36) DEFAULT NULL,
153  `reset_key` varchar(36) DEFAULT NULL,
154  PRIMARY KEY (`id`),
155  KEY `email` (`email`(191)),
156  KEY `validated` (`validated`),
157  KEY `validation_key` (`validation_key`),
158  KEY `reset_key` (`reset_key`)
159) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
160
161
162
163# Dump of table users_to_polls
164# ------------------------------------------------------------
165
166DROP TABLE IF EXISTS `users_to_polls`;
167
168CREATE TABLE `users_to_polls` (
169  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
170  `user_id` int(11) unsigned DEFAULT NULL,
171  `poll_id` int(11) unsigned DEFAULT NULL,
172  `date_voted` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
173  PRIMARY KEY (`id`),
174  KEY `user_id` (`user_id`),
175  KEY `poll_id` (`poll_id`),
176  CONSTRAINT `users_to_polls_ibfk_1` FOREIGN KEY (`poll_id`) REFERENCES `poll_info` (`id`) ON DELETE CASCADE,
177  CONSTRAINT `users_to_polls_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
178) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
179
180
181
182# Dump of table users_to_polls_to_location
183# ------------------------------------------------------------
184
185DROP TABLE IF EXISTS `users_to_polls_to_location`;
186
187CREATE TABLE `users_to_polls_to_location` (
188  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
189  `users_to_polls_id` int(11) unsigned DEFAULT NULL,
190  `ip` varchar(200) DEFAULT NULL,
191  `country_code` varchar(200) DEFAULT NULL,
192  `country_name` varchar(200) DEFAULT NULL,
193  `region_code` varchar(200) DEFAULT NULL,
194  `region_name` varchar(200) DEFAULT NULL,
195  `city` varchar(200) DEFAULT NULL,
196  `zip_code` varchar(200) DEFAULT NULL,
197  `time_zone` varchar(200) DEFAULT NULL,
198  `latitude` decimal(11,8) DEFAULT NULL,
199  `longitude` decimal(11,8) DEFAULT NULL,
200  `metro_code` varchar(200) DEFAULT NULL,
201  PRIMARY KEY (`id`),
202  KEY `users_to_polls_id` (`users_to_polls_id`),
203  CONSTRAINT `users_to_polls_to_location_ibfk_1` FOREIGN KEY (`users_to_polls_id`) REFERENCES `users_to_polls` (`id`) ON DELETE CASCADE
204) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
205
206
207
208# Dump of table users_to_polls_to_votes
209# ------------------------------------------------------------
210
211DROP TABLE IF EXISTS `users_to_polls_to_votes`;
212
213CREATE TABLE `users_to_polls_to_votes` (
214  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
215  `users_to_polls_id` int(11) unsigned DEFAULT NULL,
216  `choice_id` int(11) unsigned DEFAULT NULL,
217  `votes` int(11) DEFAULT NULL,
218  PRIMARY KEY (`id`),
219  KEY `users_to_polls_id` (`users_to_polls_id`),
220  KEY `choice_id` (`choice_id`),
221  CONSTRAINT `users_to_polls_to_votes_ibfk_1` FOREIGN KEY (`users_to_polls_id`) REFERENCES `users_to_polls` (`id`) ON DELETE CASCADE
222) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
223
224
225
226
227/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
228/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
229/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
230/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
231/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
232/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;