· 7 years ago · Sep 08, 2018, 05:08 AM
1-- MySQL dump 10.13 Distrib 5.7.23, for Linux (x86_64)
2--
3-- Host: localhost Database: django_test
4-- ------------------------------------------------------
5-- Server version 5.7.23-0ubuntu0.16.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `auth_group`
20--
21
22DROP TABLE IF EXISTS `auth_group`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `auth_group` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `name` varchar(80) NOT NULL,
28 PRIMARY KEY (`id`),
29 UNIQUE KEY `name` (`name`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Dumping data for table `auth_group`
35--
36
37LOCK TABLES `auth_group` WRITE;
38/*!40000 ALTER TABLE `auth_group` DISABLE KEYS */;
39/*!40000 ALTER TABLE `auth_group` ENABLE KEYS */;
40UNLOCK TABLES;
41
42--
43-- Table structure for table `auth_group_permissions`
44--
45
46DROP TABLE IF EXISTS `auth_group_permissions`;
47/*!40101 SET @saved_cs_client = @@character_set_client */;
48/*!40101 SET character_set_client = utf8 */;
49CREATE TABLE `auth_group_permissions` (
50 `id` int(11) NOT NULL AUTO_INCREMENT,
51 `group_id` int(11) NOT NULL,
52 `permission_id` int(11) NOT NULL,
53 PRIMARY KEY (`id`),
54 UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
55 KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
56 CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
57 CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
58) ENGINE=InnoDB DEFAULT CHARSET=utf8;
59/*!40101 SET character_set_client = @saved_cs_client */;
60
61--
62-- Dumping data for table `auth_group_permissions`
63--
64
65LOCK TABLES `auth_group_permissions` WRITE;
66/*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */;
67/*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */;
68UNLOCK TABLES;
69
70--
71-- Table structure for table `auth_permission`
72--
73
74DROP TABLE IF EXISTS `auth_permission`;
75/*!40101 SET @saved_cs_client = @@character_set_client */;
76/*!40101 SET character_set_client = utf8 */;
77CREATE TABLE `auth_permission` (
78 `id` int(11) NOT NULL AUTO_INCREMENT,
79 `name` varchar(255) NOT NULL,
80 `content_type_id` int(11) NOT NULL,
81 `codename` varchar(100) NOT NULL,
82 PRIMARY KEY (`id`),
83 UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
84 CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
85) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
86/*!40101 SET character_set_client = @saved_cs_client */;
87
88--
89-- Dumping data for table `auth_permission`
90--
91
92LOCK TABLES `auth_permission` WRITE;
93/*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */;
94INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can view log entry',1,'view_logentry'),(5,'Can add permission',2,'add_permission'),(6,'Can change permission',2,'change_permission'),(7,'Can delete permission',2,'delete_permission'),(8,'Can view permission',2,'view_permission'),(9,'Can add group',3,'add_group'),(10,'Can change group',3,'change_group'),(11,'Can delete group',3,'delete_group'),(12,'Can view group',3,'view_group'),(13,'Can add user',4,'add_user'),(14,'Can change user',4,'change_user'),(15,'Can delete user',4,'delete_user'),(16,'Can view user',4,'view_user'),(17,'Can add content type',5,'add_contenttype'),(18,'Can change content type',5,'change_contenttype'),(19,'Can delete content type',5,'delete_contenttype'),(20,'Can view content type',5,'view_contenttype'),(21,'Can add session',6,'add_session'),(22,'Can change session',6,'change_session'),(23,'Can delete session',6,'delete_session'),(24,'Can view session',6,'view_session'),(25,'Can add choice',7,'add_choice'),(26,'Can change choice',7,'change_choice'),(27,'Can delete choice',7,'delete_choice'),(28,'Can view choice',7,'view_choice'),(29,'Can add question',8,'add_question'),(30,'Can change question',8,'change_question'),(31,'Can delete question',8,'delete_question'),(32,'Can view question',8,'view_question');
95/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */;
96UNLOCK TABLES;
97
98--
99-- Table structure for table `auth_user`
100--
101
102DROP TABLE IF EXISTS `auth_user`;
103/*!40101 SET @saved_cs_client = @@character_set_client */;
104/*!40101 SET character_set_client = utf8 */;
105CREATE TABLE `auth_user` (
106 `id` int(11) NOT NULL AUTO_INCREMENT,
107 `password` varchar(128) NOT NULL,
108 `last_login` datetime(6) DEFAULT NULL,
109 `is_superuser` tinyint(1) NOT NULL,
110 `username` varchar(150) NOT NULL,
111 `first_name` varchar(30) NOT NULL,
112 `last_name` varchar(150) NOT NULL,
113 `email` varchar(254) NOT NULL,
114 `is_staff` tinyint(1) NOT NULL,
115 `is_active` tinyint(1) NOT NULL,
116 `date_joined` datetime(6) NOT NULL,
117 PRIMARY KEY (`id`),
118 UNIQUE KEY `username` (`username`)
119) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
120/*!40101 SET character_set_client = @saved_cs_client */;
121
122--
123-- Dumping data for table `auth_user`
124--
125
126LOCK TABLES `auth_user` WRITE;
127/*!40000 ALTER TABLE `auth_user` DISABLE KEYS */;
128INSERT INTO `auth_user` VALUES (1,'pbkdf2_sha256$120000$r9ayZxCri3TY$WUvwsi3dDWxs4+KIbkNJ6wgp0ycUZCDdJMFDw2EBsyI=','2018-09-06 17:04:04.139099',1,'admin','','','benjamin.harris@conversica.com',1,1,'2018-09-06 17:03:09.661538');
129/*!40000 ALTER TABLE `auth_user` ENABLE KEYS */;
130UNLOCK TABLES;
131
132--
133-- Table structure for table `auth_user_groups`
134--
135
136DROP TABLE IF EXISTS `auth_user_groups`;
137/*!40101 SET @saved_cs_client = @@character_set_client */;
138/*!40101 SET character_set_client = utf8 */;
139CREATE TABLE `auth_user_groups` (
140 `id` int(11) NOT NULL AUTO_INCREMENT,
141 `user_id` int(11) NOT NULL,
142 `group_id` int(11) NOT NULL,
143 PRIMARY KEY (`id`),
144 UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
145 KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
146 CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
147 CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
148) ENGINE=InnoDB DEFAULT CHARSET=utf8;
149/*!40101 SET character_set_client = @saved_cs_client */;
150
151--
152-- Dumping data for table `auth_user_groups`
153--
154
155LOCK TABLES `auth_user_groups` WRITE;
156/*!40000 ALTER TABLE `auth_user_groups` DISABLE KEYS */;
157/*!40000 ALTER TABLE `auth_user_groups` ENABLE KEYS */;
158UNLOCK TABLES;
159
160--
161-- Table structure for table `auth_user_user_permissions`
162--
163
164DROP TABLE IF EXISTS `auth_user_user_permissions`;
165/*!40101 SET @saved_cs_client = @@character_set_client */;
166/*!40101 SET character_set_client = utf8 */;
167CREATE TABLE `auth_user_user_permissions` (
168 `id` int(11) NOT NULL AUTO_INCREMENT,
169 `user_id` int(11) NOT NULL,
170 `permission_id` int(11) NOT NULL,
171 PRIMARY KEY (`id`),
172 UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
173 KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`),
174 CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
175 CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
176) ENGINE=InnoDB DEFAULT CHARSET=utf8;
177/*!40101 SET character_set_client = @saved_cs_client */;
178
179--
180-- Dumping data for table `auth_user_user_permissions`
181--
182
183LOCK TABLES `auth_user_user_permissions` WRITE;
184/*!40000 ALTER TABLE `auth_user_user_permissions` DISABLE KEYS */;
185/*!40000 ALTER TABLE `auth_user_user_permissions` ENABLE KEYS */;
186UNLOCK TABLES;
187
188--
189-- Table structure for table `django_admin_log`
190--
191
192DROP TABLE IF EXISTS `django_admin_log`;
193/*!40101 SET @saved_cs_client = @@character_set_client */;
194/*!40101 SET character_set_client = utf8 */;
195CREATE TABLE `django_admin_log` (
196 `id` int(11) NOT NULL AUTO_INCREMENT,
197 `action_time` datetime(6) NOT NULL,
198 `object_id` longtext,
199 `object_repr` varchar(200) NOT NULL,
200 `action_flag` smallint(5) unsigned NOT NULL,
201 `change_message` longtext NOT NULL,
202 `content_type_id` int(11) DEFAULT NULL,
203 `user_id` int(11) NOT NULL,
204 PRIMARY KEY (`id`),
205 KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
206 KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`),
207 CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
208 CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
209) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
210/*!40101 SET character_set_client = @saved_cs_client */;
211
212--
213-- Dumping data for table `django_admin_log`
214--
215
216LOCK TABLES `django_admin_log` WRITE;
217/*!40000 ALTER TABLE `django_admin_log` DISABLE KEYS */;
218INSERT INTO `django_admin_log` VALUES (1,'2018-09-06 17:05:56.987839','1','What\'s up?',2,'[{\"changed\": {\"fields\": [\"pub_date\"]}}]',8,1),(2,'2018-09-06 20:10:40.119728','2','Is this question older than the last?',1,'[{\"added\": {}}, {\"added\": {\"object\": \"Yes\", \"name\": \"choice\"}}, {\"added\": {\"object\": \"No\", \"name\": \"choice\"}}, {\"added\": {\"object\": \"Of course\", \"name\": \"choice\"}}]',8,1);
219/*!40000 ALTER TABLE `django_admin_log` ENABLE KEYS */;
220UNLOCK TABLES;
221
222--
223-- Table structure for table `django_content_type`
224--
225
226DROP TABLE IF EXISTS `django_content_type`;
227/*!40101 SET @saved_cs_client = @@character_set_client */;
228/*!40101 SET character_set_client = utf8 */;
229CREATE TABLE `django_content_type` (
230 `id` int(11) NOT NULL AUTO_INCREMENT,
231 `app_label` varchar(100) NOT NULL,
232 `model` varchar(100) NOT NULL,
233 PRIMARY KEY (`id`),
234 UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
235) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
236/*!40101 SET character_set_client = @saved_cs_client */;
237
238--
239-- Dumping data for table `django_content_type`
240--
241
242LOCK TABLES `django_content_type` WRITE;
243/*!40000 ALTER TABLE `django_content_type` DISABLE KEYS */;
244INSERT INTO `django_content_type` VALUES (1,'admin','logentry'),(3,'auth','group'),(2,'auth','permission'),(4,'auth','user'),(5,'contenttypes','contenttype'),(7,'polls','choice'),(8,'polls','question'),(6,'sessions','session');
245/*!40000 ALTER TABLE `django_content_type` ENABLE KEYS */;
246UNLOCK TABLES;
247
248--
249-- Table structure for table `django_migrations`
250--
251
252DROP TABLE IF EXISTS `django_migrations`;
253/*!40101 SET @saved_cs_client = @@character_set_client */;
254/*!40101 SET character_set_client = utf8 */;
255CREATE TABLE `django_migrations` (
256 `id` int(11) NOT NULL AUTO_INCREMENT,
257 `app` varchar(255) NOT NULL,
258 `name` varchar(255) NOT NULL,
259 `applied` datetime(6) NOT NULL,
260 PRIMARY KEY (`id`)
261) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
262/*!40101 SET character_set_client = @saved_cs_client */;
263
264--
265-- Dumping data for table `django_migrations`
266--
267
268LOCK TABLES `django_migrations` WRITE;
269/*!40000 ALTER TABLE `django_migrations` DISABLE KEYS */;
270INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2018-09-05 23:07:07.329461'),(2,'auth','0001_initial','2018-09-05 23:07:08.211419'),(3,'admin','0001_initial','2018-09-05 23:07:08.431661'),(4,'admin','0002_logentry_remove_auto_add','2018-09-05 23:07:08.457802'),(5,'admin','0003_logentry_add_action_flag_choices','2018-09-05 23:07:08.491706'),(6,'contenttypes','0002_remove_content_type_name','2018-09-05 23:07:08.634458'),(7,'auth','0002_alter_permission_name_max_length','2018-09-05 23:07:08.722057'),(8,'auth','0003_alter_user_email_max_length','2018-09-05 23:07:08.819211'),(9,'auth','0004_alter_user_username_opts','2018-09-05 23:07:08.842846'),(10,'auth','0005_alter_user_last_login_null','2018-09-05 23:07:08.914293'),(11,'auth','0006_require_contenttypes_0002','2018-09-05 23:07:08.920596'),(12,'auth','0007_alter_validators_add_error_messages','2018-09-05 23:07:08.945688'),(13,'auth','0008_alter_user_username_max_length','2018-09-05 23:07:09.028592'),(14,'auth','0009_alter_user_last_name_max_length','2018-09-05 23:07:09.100603'),(15,'sessions','0001_initial','2018-09-05 23:07:09.148153'),(16,'polls','0001_initial','2018-09-06 00:03:32.229738');
271/*!40000 ALTER TABLE `django_migrations` ENABLE KEYS */;
272UNLOCK TABLES;
273
274--
275-- Table structure for table `django_session`
276--
277
278DROP TABLE IF EXISTS `django_session`;
279/*!40101 SET @saved_cs_client = @@character_set_client */;
280/*!40101 SET character_set_client = utf8 */;
281CREATE TABLE `django_session` (
282 `session_key` varchar(40) NOT NULL,
283 `session_data` longtext NOT NULL,
284 `expire_date` datetime(6) NOT NULL,
285 PRIMARY KEY (`session_key`),
286 KEY `django_session_expire_date_a5c62663` (`expire_date`)
287) ENGINE=InnoDB DEFAULT CHARSET=utf8;
288/*!40101 SET character_set_client = @saved_cs_client */;
289
290--
291-- Dumping data for table `django_session`
292--
293
294LOCK TABLES `django_session` WRITE;
295/*!40000 ALTER TABLE `django_session` DISABLE KEYS */;
296INSERT INTO `django_session` VALUES ('jn56yqyaobr0kzz9g4xx74myd6rssjhn','NmU0YWVhZDMxYmJmMzRkM2JiOTc1MWEzY2Y4ZTEzODFiM2NkYWQ2Mzp7Il9hdXRoX3VzZXJfaWQiOiIxIiwiX2F1dGhfdXNlcl9oYXNoIjoiNzY4NGNjZDZkYjcxMDFmM2IyODVlNTA5NjA1NmU2MzUzNWJhNTFhNCIsIl9hdXRoX3VzZXJfYmFja2VuZCI6ImRqYW5nby5jb250cmliLmF1dGguYmFja2VuZHMuTW9kZWxCYWNrZW5kIn0=','2018-09-20 17:04:04.144549');
297/*!40000 ALTER TABLE `django_session` ENABLE KEYS */;
298UNLOCK TABLES;
299
300--
301-- Table structure for table `polls_choice`
302--
303
304DROP TABLE IF EXISTS `polls_choice`;
305/*!40101 SET @saved_cs_client = @@character_set_client */;
306/*!40101 SET character_set_client = utf8 */;
307CREATE TABLE `polls_choice` (
308 `id` int(11) NOT NULL AUTO_INCREMENT,
309 `choice_text` varchar(200) NOT NULL,
310 `votes` int(11) NOT NULL,
311 `question_id` int(11) NOT NULL,
312 PRIMARY KEY (`id`),
313 KEY `polls_choice_question_id_c5b4b260_fk_polls_question_id` (`question_id`),
314 CONSTRAINT `polls_choice_question_id_c5b4b260_fk_polls_question_id` FOREIGN KEY (`question_id`) REFERENCES `polls_question` (`id`)
315) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
316/*!40101 SET character_set_client = @saved_cs_client */;
317
318--
319-- Dumping data for table `polls_choice`
320--
321
322LOCK TABLES `polls_choice` WRITE;
323/*!40000 ALTER TABLE `polls_choice` DISABLE KEYS */;
324INSERT INTO `polls_choice` VALUES (1,'Not much',4,1),(2,'The sky',5,1),(4,'Yes',9000,2),(5,'No',0,2),(6,'Of course',2,2);
325/*!40000 ALTER TABLE `polls_choice` ENABLE KEYS */;
326UNLOCK TABLES;
327
328--
329-- Table structure for table `polls_question`
330--
331
332DROP TABLE IF EXISTS `polls_question`;
333/*!40101 SET @saved_cs_client = @@character_set_client */;
334/*!40101 SET character_set_client = utf8 */;
335CREATE TABLE `polls_question` (
336 `id` int(11) NOT NULL AUTO_INCREMENT,
337 `question_text` varchar(200) NOT NULL,
338 `pub_date` datetime(6) NOT NULL,
339 PRIMARY KEY (`id`)
340) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
341/*!40101 SET character_set_client = @saved_cs_client */;
342
343--
344-- Dumping data for table `polls_question`
345--
346
347LOCK TABLES `polls_question` WRITE;
348/*!40000 ALTER TABLE `polls_question` DISABLE KEYS */;
349INSERT INTO `polls_question` VALUES (1,'What\'s up?','2018-09-06 17:05:55.000000'),(2,'Is this question older than the last?','2017-09-01 20:10:25.000000');
350/*!40000 ALTER TABLE `polls_question` ENABLE KEYS */;
351UNLOCK TABLES;
352/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
353
354/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
355/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
356/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
357/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
358/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
359/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
360/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
361
362-- Dump completed on 2018-09-06 18:24:01