dEarbkgt

1create schema test;
2use test;
3-- MySQL dump 10.13  Distrib 8.0.17, for Linux (x86_64)
4--
5-- Host: localhost    Database: test
6-- ------------------------------------------------------
7-- Server version	8.0.17
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!50503 SET NAMES utf8mb4 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `Article2Imgs`
22--
23
24DROP TABLE IF EXISTS `Article2Imgs`;
25/*!40101 SET @saved_cs_client     = @@character_set_client */;
26/*!50503 SET character_set_client = utf8mb4 */;
27CREATE TABLE `Article2Imgs` (
28  `id` int(11) NOT NULL AUTO_INCREMENT,
29  `initiatedDate` date NOT NULL,
30  `article` int(11) NOT NULL,
31  `image` int(11) NOT NULL,
32  PRIMARY KEY (`id`),
33  KEY `article` (`article`),
34  KEY `image` (`image`),
35  CONSTRAINT `Article2Imgs_ibfk_1` FOREIGN KEY (`article`) REFERENCES `Articles` (`id`),
36  CONSTRAINT `Article2Imgs_ibfk_2` FOREIGN KEY (`image`) REFERENCES `Images` (`id`)
37) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Dumping data for table `Article2Imgs`
42--
43
44LOCK TABLES `Article2Imgs` WRITE;
45/*!40000 ALTER TABLE `Article2Imgs` DISABLE KEYS */;
46INSERT INTO `Article2Imgs` VALUES (1,'2018-05-23',1,1),(2,'2018-05-23',2,2),(3,'2018-05-23',3,3),(4,'2018-05-23',4,4),(5,'2018-05-23',5,5),(6,'2018-05-23',6,6),(7,'2018-05-23',7,7),(8,'2018-05-23',8,8),(9,'2018-05-23',9,9);
47/*!40000 ALTER TABLE `Article2Imgs` ENABLE KEYS */;
48UNLOCK TABLES;
49
50--
51-- Table structure for table `Articles`
52--
53
54DROP TABLE IF EXISTS `Articles`;
55/*!40101 SET @saved_cs_client     = @@character_set_client */;
56/*!50503 SET character_set_client = utf8mb4 */;
57CREATE TABLE `Articles` (
58  `id` int(11) NOT NULL AUTO_INCREMENT,
59  `username` varchar(50) NOT NULL,
60  `caption` varchar(200) NOT NULL,
61  `text` text NOT NULL,
62  PRIMARY KEY (`id`)
63) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
64/*!40101 SET character_set_client = @saved_cs_client */;
65
66--
67-- Dumping data for table `Articles`
68--
69
70LOCK TABLES `Articles` WRITE;
71/*!40000 ALTER TABLE `Articles` DISABLE KEYS */;
72INSERT INTO `Articles` VALUES (1,'art1','cap1','ssdf sf sdf sdf s sdf gsf sdf sf'),(2,'art1','cap1','ssdf sf sdf sdf s sdf gsf sdf sf'),(3,'art1','cap1','ssdf sf sdf sdf s sdf gsf sdf sf'),(4,'art1','cap1','ssdf sf sdf sdf s sdf gsf sdf sf'),(5,'art1','cap1','ssdf sf sdf sdf s sdf gsf sdf sf'),(6,'art1','cap1','ssdf sf sdf sdf s sdf gsf sdf sf'),(7,'art1','cap1','ssdf sf sdf sdf s sdf gsf sdf sf'),(8,'art1','cap1','ssdf sf sdf sdf s sdf gsf sdf sf'),(9,'art1','cap1','ssdf sf sdf sdf s sdf gsf sdf sf');
73/*!40000 ALTER TABLE `Articles` ENABLE KEYS */;
74UNLOCK TABLES;
75
76--
77-- Table structure for table `CUSTOMER`
78--
79
80DROP TABLE IF EXISTS `CUSTOMER`;
81/*!40101 SET @saved_cs_client     = @@character_set_client */;
82/*!50503 SET character_set_client = utf8mb4 */;
83CREATE TABLE `CUSTOMER` (
84  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
85  `ACCOUNT` double DEFAULT NULL,
86  `ADDRESS` varchar(255) DEFAULT NULL,
87  `NAME` varchar(255) DEFAULT NULL,
88  PRIMARY KEY (`ID`)
89) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
90/*!40101 SET character_set_client = @saved_cs_client */;
91
92--
93-- Dumping data for table `CUSTOMER`
94--
95
96LOCK TABLES `CUSTOMER` WRITE;
97/*!40000 ALTER TABLE `CUSTOMER` DISABLE KEYS */;
98INSERT INTO `CUSTOMER` VALUES (1,90000,'Rolighedsvej 13','Henriette Halvorsen'),(2,43000,'Rolighedsvej 18','Halbert Hilleman');
99/*!40000 ALTER TABLE `CUSTOMER` ENABLE KEYS */;
100UNLOCK TABLES;
101
102--
103-- Table structure for table `Cities`
104--
105
106DROP TABLE IF EXISTS `Cities`;
107/*!40101 SET @saved_cs_client     = @@character_set_client */;
108/*!50503 SET character_set_client = utf8mb4 */;
109CREATE TABLE `Cities` (
110  `id` int(11) NOT NULL AUTO_INCREMENT,
111  `name` varchar(50) NOT NULL,
112  PRIMARY KEY (`id`)
113) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
114/*!40101 SET character_set_client = @saved_cs_client */;
115
116--
117-- Dumping data for table `Cities`
118--
119
120LOCK TABLES `Cities` WRITE;
121/*!40000 ALTER TABLE `Cities` DISABLE KEYS */;
122INSERT INTO `Cities` VALUES (1,'St. Petersburg'),(2,'Munich'),(3,'St. Petersburg'),(4,'Munich'),(5,'St. Petersburg'),(6,'Munich'),(7,'St. Petersburg'),(8,'Munich'),(9,'St. Petersburg'),(10,'Munich'),(11,'St. Petersburg'),(12,'Munich'),(13,'St. Petersburg'),(14,'Munich'),(15,'St. Petersburg'),(16,'Munich');
123/*!40000 ALTER TABLE `Cities` ENABLE KEYS */;
124UNLOCK TABLES;
125
126--
127-- Table structure for table `Customers`
128--
129
130DROP TABLE IF EXISTS `Customers`;
131/*!40101 SET @saved_cs_client     = @@character_set_client */;
132/*!50503 SET character_set_client = utf8mb4 */;
133CREATE TABLE `Customers` (
134  `id` int(11) NOT NULL AUTO_INCREMENT,
135  `name` varchar(50) NOT NULL,
136  `city` int(11) NOT NULL,
137  `age` int(11) NOT NULL,
138  PRIMARY KEY (`id`),
139  KEY `city` (`city`),
140  KEY `Customers_name` (`name`),
141  CONSTRAINT `Customers_ibfk_1` FOREIGN KEY (`city`) REFERENCES `Cities` (`id`)
142) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
143/*!40101 SET character_set_client = @saved_cs_client */;
144
145--
146-- Dumping data for table `Customers`
147--
148
149LOCK TABLES `Customers` WRITE;
150/*!40000 ALTER TABLE `Customers` DISABLE KEYS */;
151INSERT INTO `Customers` VALUES (1,'a',15,5),(2,'b',15,27),(3,'c',16,42);
152/*!40000 ALTER TABLE `Customers` ENABLE KEYS */;
153UNLOCK TABLES;
154
155--
156-- Table structure for table `Images`
157--
158
159DROP TABLE IF EXISTS `Images`;
160/*!40101 SET @saved_cs_client     = @@character_set_client */;
161/*!50503 SET character_set_client = utf8mb4 */;
162CREATE TABLE `Images` (
163  `id` int(11) NOT NULL AUTO_INCREMENT,
164  `username` varchar(50) NOT NULL,
165  `path` varchar(50) NOT NULL,
166  PRIMARY KEY (`id`)
167) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
168/*!40101 SET character_set_client = @saved_cs_client */;
169
170--
171-- Dumping data for table `Images`
172--
173
174LOCK TABLES `Images` WRITE;
175/*!40000 ALTER TABLE `Images` DISABLE KEYS */;
176INSERT INTO `Images` VALUES (1,'img1','path1'),(2,'img1','path1'),(3,'img1','path1'),(4,'img1','path1'),(5,'img1','path1'),(6,'img1','path1'),(7,'img1','path1'),(8,'img1','path1'),(9,'img1','path1');
177/*!40000 ALTER TABLE `Images` ENABLE KEYS */;
178UNLOCK TABLES;
179
180--
181-- Table structure for table `Orders`
182--
183
184DROP TABLE IF EXISTS `Orders`;
185/*!40101 SET @saved_cs_client     = @@character_set_client */;
186/*!50503 SET character_set_client = utf8mb4 */;
187CREATE TABLE `Orders` (
188  `id` int(11) NOT NULL AUTO_INCREMENT,
189  `orderdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
190  `shippingdate` timestamp NULL DEFAULT NULL,
191  `Customers_id` int(11) NOT NULL,
192  PRIMARY KEY (`id`),
193  KEY `fk_Orders_Customers1_idx` (`Customers_id`),
194  CONSTRAINT `fk_Orders_Customers1` FOREIGN KEY (`Customers_id`) REFERENCES `Customers` (`id`)
195) ENGINE=InnoDB DEFAULT CHARSET=latin1;
196/*!40101 SET character_set_client = @saved_cs_client */;
197
198--
199-- Dumping data for table `Orders`
200--
201
202LOCK TABLES `Orders` WRITE;
203/*!40000 ALTER TABLE `Orders` DISABLE KEYS */;
204/*!40000 ALTER TABLE `Orders` ENABLE KEYS */;
205UNLOCK TABLES;
206
207--
208-- Table structure for table `PERSON`
209--
210
211DROP TABLE IF EXISTS `PERSON`;
212/*!40101 SET @saved_cs_client     = @@character_set_client */;
213/*!50503 SET character_set_client = utf8mb4 */;
214CREATE TABLE `PERSON` (
215  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
216  `CREATIONDATE` datetime DEFAULT NULL,
217  `DATEOFBIRTH` date DEFAULT NULL,
218  `HOBBIES` longblob,
219  `MEDAL` varchar(255) DEFAULT NULL,
220  `NAME` varchar(255) DEFAULT NULL,
221  PRIMARY KEY (`ID`)
222) ENGINE=InnoDB DEFAULT CHARSET=latin1;
223/*!40101 SET character_set_client = @saved_cs_client */;
224
225--
226-- Dumping data for table `PERSON`
227--
228
229LOCK TABLES `PERSON` WRITE;
230/*!40000 ALTER TABLE `PERSON` DISABLE KEYS */;
231/*!40000 ALTER TABLE `PERSON` ENABLE KEYS */;
232UNLOCK TABLES;
233
234--
235-- Table structure for table `PERSONCOMPLEX`
236--
237
238DROP TABLE IF EXISTS `PERSONCOMPLEX`;
239/*!40101 SET @saved_cs_client     = @@character_set_client */;
240/*!50503 SET character_set_client = utf8mb4 */;
241CREATE TABLE `PERSONCOMPLEX` (
242  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
243  `CREATIONDATE` datetime DEFAULT NULL,
244  `DATEOFBIRTH` date DEFAULT NULL,
245  `MEDAL` varchar(255) DEFAULT NULL,
246  `NAME` varchar(255) DEFAULT NULL,
247  PRIMARY KEY (`ID`)
248) ENGINE=InnoDB DEFAULT CHARSET=latin1;
249/*!40101 SET character_set_client = @saved_cs_client */;
250
251--
252-- Dumping data for table `PERSONCOMPLEX`
253--
254
255LOCK TABLES `PERSONCOMPLEX` WRITE;
256/*!40000 ALTER TABLE `PERSONCOMPLEX` DISABLE KEYS */;
257/*!40000 ALTER TABLE `PERSONCOMPLEX` ENABLE KEYS */;
258UNLOCK TABLES;
259
260--
261-- Table structure for table `PersonComplex_HOBBIES`
262--
263
264DROP TABLE IF EXISTS `PersonComplex_HOBBIES`;
265/*!40101 SET @saved_cs_client     = @@character_set_client */;
266/*!50503 SET character_set_client = utf8mb4 */;
267CREATE TABLE `PersonComplex_HOBBIES` (
268  `PersonComplex_ID` bigint(20) DEFAULT NULL,
269  `HOBBIES` varchar(255) DEFAULT NULL,
270  KEY `FK_PersonComplex_HOBBIES_PersonComplex_ID` (`PersonComplex_ID`),
271  CONSTRAINT `FK_PersonComplex_HOBBIES_PersonComplex_ID` FOREIGN KEY (`PersonComplex_ID`) REFERENCES `PERSONCOMPLEX` (`ID`)
272) ENGINE=InnoDB DEFAULT CHARSET=latin1;
273/*!40101 SET character_set_client = @saved_cs_client */;
274
275--
276-- Dumping data for table `PersonComplex_HOBBIES`
277--
278
279LOCK TABLES `PersonComplex_HOBBIES` WRITE;
280/*!40000 ALTER TABLE `PersonComplex_HOBBIES` DISABLE KEYS */;
281/*!40000 ALTER TABLE `PersonComplex_HOBBIES` ENABLE KEYS */;
282UNLOCK TABLES;
283
284--
285-- Table structure for table `PersonComplex_PHONES`
286--
287
288DROP TABLE IF EXISTS `PersonComplex_PHONES`;
289/*!40101 SET @saved_cs_client     = @@character_set_client */;
290/*!50503 SET character_set_client = utf8mb4 */;
291CREATE TABLE `PersonComplex_PHONES` (
292  `PersonComplex_ID` bigint(20) DEFAULT NULL,
293  `Description` varchar(255) DEFAULT NULL,
294  `PHONE` varchar(255) DEFAULT NULL,
295  KEY `FK_PersonComplex_PHONES_PersonComplex_ID` (`PersonComplex_ID`),
296  CONSTRAINT `FK_PersonComplex_PHONES_PersonComplex_ID` FOREIGN KEY (`PersonComplex_ID`) REFERENCES `PERSONCOMPLEX` (`ID`)
297) ENGINE=InnoDB DEFAULT CHARSET=latin1;
298/*!40101 SET character_set_client = @saved_cs_client */;
299
300--
301-- Dumping data for table `PersonComplex_PHONES`
302--
303
304LOCK TABLES `PersonComplex_PHONES` WRITE;
305/*!40000 ALTER TABLE `PersonComplex_PHONES` DISABLE KEYS */;
306/*!40000 ALTER TABLE `PersonComplex_PHONES` ENABLE KEYS */;
307UNLOCK TABLES;
308
309--
310-- Table structure for table `SEQUENCE`
311--
312
313DROP TABLE IF EXISTS `SEQUENCE`;
314/*!40101 SET @saved_cs_client     = @@character_set_client */;
315/*!50503 SET character_set_client = utf8mb4 */;
316CREATE TABLE `SEQUENCE` (
317  `SEQ_NAME` varchar(50) NOT NULL,
318  `SEQ_COUNT` decimal(38,0) DEFAULT NULL,
319  PRIMARY KEY (`SEQ_NAME`)
320) ENGINE=InnoDB DEFAULT CHARSET=latin1;
321/*!40101 SET character_set_client = @saved_cs_client */;
322
323--
324-- Dumping data for table `SEQUENCE`
325--
326
327LOCK TABLES `SEQUENCE` WRITE;
328/*!40000 ALTER TABLE `SEQUENCE` DISABLE KEYS */;
329INSERT INTO `SEQUENCE` VALUES ('SEQ_GEN',150);
330/*!40000 ALTER TABLE `SEQUENCE` ENABLE KEYS */;
331UNLOCK TABLES;
332
333--
334-- Table structure for table `Users`
335--
336
337DROP TABLE IF EXISTS `Users`;
338/*!40101 SET @saved_cs_client     = @@character_set_client */;
339/*!50503 SET character_set_client = utf8mb4 */;
340CREATE TABLE `Users` (
341  `id` int(11) NOT NULL AUTO_INCREMENT,
342  `username` varchar(50) NOT NULL,
343  `email` varchar(50) NOT NULL,
344  `password` varchar(80) NOT NULL,
345  PRIMARY KEY (`id`),
346  KEY `Users_username` (`username`)
347) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
348/*!40101 SET character_set_client = @saved_cs_client */;
349
350--
351-- Dumping data for table `Users`
352--
353
354LOCK TABLES `Users` WRITE;
355/*!40000 ALTER TABLE `Users` DISABLE KEYS */;
356INSERT INTO `Users` VALUES (1,'demouser','test@mail.com','test123'),(2,'demouser','test@mail.com','test123'),(3,'demouser','test@mail.com','test123'),(4,'demouser','test@mail.com','test123'),(5,'demouser','test@mail.com','test123'),(6,'demouser','test@mail.com','test123'),(7,'demouser','test@mail.com','test123'),(8,'demouser','test@mail.com','test123'),(9,'demouser','test@mail.com','test123'),(10,'demouser','test@mail.com','test123');
357/*!40000 ALTER TABLE `Users` ENABLE KEYS */;
358UNLOCK TABLES;
359
360--
361-- Table structure for table `cars`
362--
363
364DROP TABLE IF EXISTS `cars`;
365/*!40101 SET @saved_cs_client     = @@character_set_client */;
366/*!50503 SET character_set_client = utf8mb4 */;
367CREATE TABLE `cars` (
368  `make` text,
369  `model` text,
370  `year` bigint(20) DEFAULT NULL,
371  `price` bigint(20) DEFAULT NULL
372) ENGINE=InnoDB DEFAULT CHARSET=latin1;
373/*!40101 SET character_set_client = @saved_cs_client */;
374
375--
376-- Dumping data for table `cars`
377--
378
379LOCK TABLES `cars` WRITE;
380/*!40000 ALTER TABLE `cars` DISABLE KEYS */;
381INSERT INTO `cars` VALUES ('vw','up',2018,123000),('audi','a6',2011,85000),('citroen','c3',2019,143000);
382/*!40000 ALTER TABLE `cars` ENABLE KEYS */;
383UNLOCK TABLES;
384
385--
386-- Table structure for table `person`
387--
388
389DROP TABLE IF EXISTS `person`;
390/*!40101 SET @saved_cs_client     = @@character_set_client */;
391/*!50503 SET character_set_client = utf8mb4 */;
392CREATE TABLE `person` (
393  `personId` int(11) NOT NULL AUTO_INCREMENT,
394  `firstName` varchar(45) DEFAULT NULL,
395  `lastName` varchar(45) DEFAULT NULL,
396  PRIMARY KEY (`personId`)
397) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;
398/*!40101 SET character_set_client = @saved_cs_client */;
399
400--
401-- Dumping data for table `person`
402--
403
404LOCK TABLES `person` WRITE;
405/*!40000 ALTER TABLE `person` DISABLE KEYS */;
406INSERT INTO `person` VALUES (51,'Holger','Danske'),(101,'Henriette','Dellerup'),(102,'Kasandra','Black'),(103,'Kunta','Kinte');
407/*!40000 ALTER TABLE `person` ENABLE KEYS */;
408UNLOCK TABLES;
409
410--
411-- Table structure for table `phone`
412--
413
414DROP TABLE IF EXISTS `phone`;
415/*!40101 SET @saved_cs_client     = @@character_set_client */;
416/*!50503 SET character_set_client = utf8mb4 */;
417CREATE TABLE `phone` (
418  `phoneId` int(11) NOT NULL AUTO_INCREMENT,
419  `number` varchar(45) DEFAULT NULL,
420  `description` varchar(45) DEFAULT NULL,
421  `personId` int(11) NOT NULL,
422  PRIMARY KEY (`phoneId`,`personId`),
423  KEY `fk_phone_person_idx` (`personId`),
424  CONSTRAINT `fk_phone_person` FOREIGN KEY (`personId`) REFERENCES `person` (`personId`)
425) ENGINE=InnoDB DEFAULT CHARSET=latin1;
426/*!40101 SET character_set_client = @saved_cs_client */;
427
428--
429-- Dumping data for table `phone`
430--
431
432LOCK TABLES `phone` WRITE;
433/*!40000 ALTER TABLE `phone` DISABLE KEYS */;
434/*!40000 ALTER TABLE `phone` ENABLE KEYS */;
435UNLOCK TABLES;
436
437--
438-- Table structure for table `pythondemo`
439--
440
441DROP TABLE IF EXISTS `pythondemo`;
442/*!40101 SET @saved_cs_client     = @@character_set_client */;
443/*!50503 SET character_set_client = utf8mb4 */;
444CREATE TABLE `pythondemo` (
445  `id` int(11) NOT NULL AUTO_INCREMENT,
446  `firstname` varchar(45) DEFAULT NULL,
447  `lastname` varchar(45) DEFAULT NULL,
448  `startdate` datetime DEFAULT NULL,
449  `enddate` timestamp NULL DEFAULT NULL,
450  `salary` varchar(45) DEFAULT NULL,
451  PRIMARY KEY (`id`)
452) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
453/*!40101 SET character_set_client = @saved_cs_client */;
454
455--
456-- Dumping data for table `pythondemo`
457--
458
459LOCK TABLES `pythondemo` WRITE;
460/*!40000 ALTER TABLE `pythondemo` DISABLE KEYS */;
461INSERT INTO `pythondemo` VALUES (1,'Henny','Petersen','2002-02-02 00:00:00','2002-02-03 23:00:00','23000'),(3,'Hassan','Hassani','2018-07-07 00:00:00','2020-11-12 23:00:00','43000'),(4,'Hanne','Hansen','2002-04-03 00:00:00',NULL,'94446'),(5,'Jesper','Fårekylling','2002-04-03 00:00:00','2018-07-06 22:00:00','23000'),(6,'Janni','Spiser','2011-05-23 00:00:00',NULL,'180149'),(7,'aa','bb','2003-04-04 00:00:00','2003-05-05 00:00:00','31400'),(9,'Helga','Juhlborg','2003-01-17 00:00:00','2004-04-11 00:00:00','34100'),(10,'Helga','Juhlborg','2003-01-17 00:00:00','2004-04-11 00:00:00','34100'),(11,'Helga','Juhlborg','2003-01-17 00:00:00','2004-04-11 00:00:00','34100'),(12,'Ulrik','Volborg','2003-03-03 00:00:00','2005-08-20 00:00:00','21000'),(13,'Ulla','Willman','2001-05-04 00:00:00','2005-12-24 00:00:00','32000'),(14,'Ulfred','Valberg','2001-01-04 00:00:00','2006-10-30 00:00:00','43000');
462/*!40000 ALTER TABLE `pythondemo` ENABLE KEYS */;
463UNLOCK TABLES;
464/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
465
466/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
467/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
468/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
469/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
470/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
471/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
472/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
473
474-- Dump completed on 2020-03-14  9:51:16