· 8 years ago · Aug 16, 2018, 11:56 AM
1-- MySQL dump 10.13 Distrib 5.7.23, for Linux (x86_64)
2--
3-- Host: localhost Database: Jumpsocks
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 `barcode`
20--
21
22DROP TABLE IF EXISTS `barcode`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `barcode` (
26 `id` int(10) NOT NULL AUTO_INCREMENT,
27 `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
28 `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
29 `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
30 PRIMARY KEY (`id`),
31 UNIQUE KEY `barcodes_code_unique` (`code`)
32) ENGINE=InnoDB AUTO_INCREMENT=184 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `barcode`
37--
38
39LOCK TABLES `barcode` WRITE;
40/*!40000 ALTER TABLE `barcode` DISABLE KEYS */;
41INSERT INTO `barcode` VALUES (1,'teeest','2018-08-01 15:07:28','2018-08-02 00:34:38'),(177,'3','2018-08-05 16:52:28','2018-08-05 16:52:28'),(178,'wtf','2018-08-05 16:55:23','2018-08-05 16:55:23'),(179,'dolor','2018-08-13 09:19:44','2018-08-13 09:19:44'),(180,'5000','2018-08-14 13:42:53','2018-08-14 13:42:53'),(181,'50001','2018-08-14 13:46:54','2018-08-14 13:46:54'),(182,'50002','2018-08-14 13:48:02','2018-08-14 13:48:02'),(183,'5220185','2018-08-14 15:06:39','2018-08-14 15:06:39');
42/*!40000 ALTER TABLE `barcode` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `position`
47--
48
49DROP TABLE IF EXISTS `position`;
50/*!40101 SET @saved_cs_client = @@character_set_client */;
51/*!40101 SET character_set_client = utf8 */;
52CREATE TABLE `position` (
53 `id` int(10) NOT NULL AUTO_INCREMENT,
54 `cameraIpAddress` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
55 `videoDuration` int(11) DEFAULT '10',
56 `recordAfter` int(11) DEFAULT '10',
57 `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
58 `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
59 PRIMARY KEY (`id`),
60 UNIQUE KEY `RFID_id_UNIQUE` (`id`),
61 UNIQUE KEY `positions_camera_id_unique` (`cameraIpAddress`)
62) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
63/*!40101 SET character_set_client = @saved_cs_client */;
64
65--
66-- Dumping data for table `position`
67--
68
69LOCK TABLES `position` WRITE;
70/*!40000 ALTER TABLE `position` DISABLE KEYS */;
71INSERT INTO `position` VALUES (1,'192.168.0.253',9,6,'2018-08-05 18:24:55','2018-08-13 14:32:19'),(2,'192.168.0.253.2',-63222777,83738267,'2018-08-13 09:09:13','2018-08-13 09:54:19'),(3,'192.168.0.253.3',79516971,-74184818,'2018-08-13 09:26:22','2018-08-13 09:54:19'),(6,'192.168.0.253.40',50,60,'2018-08-16 09:20:12','2018-08-16 09:31:36');
72/*!40000 ALTER TABLE `position` ENABLE KEYS */;
73UNLOCK TABLES;
74
75--
76-- Table structure for table `setting`
77--
78
79DROP TABLE IF EXISTS `setting`;
80/*!40101 SET @saved_cs_client = @@character_set_client */;
81/*!40101 SET character_set_client = utf8 */;
82CREATE TABLE `setting` (
83 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
84 `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
85 `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
86 `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
87 PRIMARY KEY (`name`)
88) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
89/*!40101 SET character_set_client = @saved_cs_client */;
90
91--
92-- Dumping data for table `setting`
93--
94
95LOCK TABLES `setting` WRITE;
96/*!40000 ALTER TABLE `setting` DISABLE KEYS */;
97INSERT INTO `setting` VALUES ('max_videos_per_user','2','2018-07-31 14:50:06','2018-08-13 09:19:33'),('video_experiation_days','2','2018-07-31 14:51:04','2018-08-16 07:14:04');
98/*!40000 ALTER TABLE `setting` ENABLE KEYS */;
99UNLOCK TABLES;
100
101--
102-- Table structure for table `user`
103--
104
105DROP TABLE IF EXISTS `user`;
106/*!40101 SET @saved_cs_client = @@character_set_client */;
107/*!40101 SET character_set_client = utf8 */;
108CREATE TABLE `user` (
109 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
110 `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
111 `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
112 `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
113 `createdAt` timestamp NULL DEFAULT NULL,
114 `updatedAt` timestamp NULL DEFAULT NULL,
115 PRIMARY KEY (`id`),
116 UNIQUE KEY `users_email_unique` (`email`)
117) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
118/*!40101 SET character_set_client = @saved_cs_client */;
119
120--
121-- Dumping data for table `user`
122--
123
124LOCK TABLES `user` WRITE;
125/*!40000 ALTER TABLE `user` DISABLE KEYS */;
126INSERT INTO `user` VALUES (1,'heycopsi','info@heycopsi.nl','$2y$10$Y7bZPC6clVDHI3l09ryS5OGU.LFJmj30vJlwipNPIByT9qwW9q/pW','2018-04-25 11:50:24','2018-04-25 11:50:24');
127/*!40000 ALTER TABLE `user` ENABLE KEYS */;
128UNLOCK TABLES;
129
130--
131-- Table structure for table `video`
132--
133
134DROP TABLE IF EXISTS `video`;
135/*!40101 SET @saved_cs_client = @@character_set_client */;
136/*!40101 SET character_set_client = utf8 */;
137CREATE TABLE `video` (
138 `id` int(10) NOT NULL AUTO_INCREMENT,
139 `positionId` int(10) NOT NULL,
140 `barcodeId` int(10) NOT NULL,
141 `fileName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
142 `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
143 `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
144 `deletedAt` timestamp NULL DEFAULT NULL,
145 PRIMARY KEY (`id`),
146 KEY `video_position_idx` (`positionId`),
147 KEY `video_barcode_idx` (`barcodeId`),
148 CONSTRAINT `video_barcode` FOREIGN KEY (`barcodeId`) REFERENCES `barcode` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
149 CONSTRAINT `video_position` FOREIGN KEY (`positionId`) REFERENCES `position` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
150) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
151/*!40101 SET character_set_client = @saved_cs_client */;
152
153--
154-- Dumping data for table `video`
155--
156
157LOCK TABLES `video` WRITE;
158/*!40000 ALTER TABLE `video` DISABLE KEYS */;
159INSERT INTO `video` VALUES (7,1,1,'d1a96880-9ee5-11e8-8bea-2e9379cc4032.mp4','2018-08-13 08:44:38','2018-08-13 08:44:38',NULL),(8,1,1,'dfab9c80-9ee7-11e8-8dc8-7b30776cfe5f.mp4','2018-08-13 08:59:25','2018-08-13 08:59:25',NULL),(9,1,1,'062d1820-9ee8-11e8-8aa8-0e00d98e0a12.mp4','2018-08-13 09:00:22','2018-08-13 09:00:22',NULL),(10,1,1,'d5b6b9c0-9eed-11e8-889f-50e2edf91ead.mp4','2018-08-13 09:41:55','2018-08-13 09:41:55',NULL),(11,1,1,'f9377880-9eed-11e8-8d08-1bb6e980af0e.mp4','2018-08-13 09:42:50','2018-08-13 09:42:50',NULL),(12,1,1,'1fc5ec70-9eee-11e8-86ce-56e30a2d3b03.mp4','2018-08-13 09:43:50','2018-08-13 09:43:50',NULL),(13,1,1,'321e8240-9ef0-11e8-80a4-30efc38bb50c.mp4','2018-08-13 09:58:39','2018-08-13 09:58:39',NULL),(14,1,1,'65ea8c90-9ef0-11e8-86c1-4c4c7577dabc.mp4','2018-08-13 10:00:21','2018-08-13 10:00:21',NULL),(15,1,1,'28b8a070-9ef3-11e8-8015-1c2905bd8b99.mp4','2018-08-13 10:20:06','2018-08-13 10:20:06',NULL),(16,1,1,'5ff98630-9ef3-11e8-84b2-85205b37ecee.mp4','2018-08-13 10:21:42','2018-08-13 10:21:42',NULL),(17,1,1,'96d63670-9ef4-11e8-8582-c665fab423a7.mp4','2018-08-13 10:30:18','2018-08-13 10:30:18',NULL),(18,1,1,'dd82b620-9ef4-11e8-8fd1-9d26939dfce1.mp4','2018-08-13 10:32:26','2018-08-13 10:32:26',NULL),(19,1,1,'0ffec0d0-9ef5-11e8-87d6-497c8e943d85.mp4','2018-08-13 10:33:42','2018-08-13 10:33:42',NULL),(20,1,1,'5fb147b0-9ef5-11e8-8770-51ecf3ab2532.mp4','2018-08-13 10:35:53','2018-08-13 10:35:53',NULL),(21,1,1,'9d0d49b0-9ef5-11e8-8a1a-d1012bb09bc2.mp4','2018-08-13 10:37:39','2018-08-13 10:37:39',NULL),(22,1,1,'17c092c0-9ef6-11e8-8747-453703c2eb31.mp4','2018-08-13 10:41:03','2018-08-13 10:41:03',NULL),(23,1,1,'b8d76f30-9ef6-11e8-86cd-895406b5ea57.mp4','2018-08-13 10:45:35','2018-08-13 10:45:35',NULL),(24,1,1,'0e69b700-9ef7-11e8-8668-80dad02f319e.mp4','2018-08-13 10:48:00','2018-08-13 10:48:00',NULL),(25,1,1,'367d6b60-9ef7-11e8-8255-49b7d26ccb33.mp4','2018-08-13 10:49:08','2018-08-13 10:49:08',NULL),(26,1,1,'644b0930-9ef7-11e8-8e07-fc1226a84146.mp4','2018-08-13 10:50:18','2018-08-13 10:50:18',NULL),(27,1,1,'a71126f0-9ef7-11e8-81bc-a8d6dd2ba9d4.mp4','2018-08-13 10:52:17','2018-08-13 10:52:17',NULL),(28,1,1,'ec31af70-9ef7-11e8-8ccd-cea1a2609607.mp4','2018-08-13 10:54:10','2018-08-13 10:54:10',NULL),(29,1,1,'a7ade6b0-9ef8-11e8-84e3-674b9969b083.mp4','2018-08-13 10:59:25','2018-08-13 10:59:25',NULL),(30,1,1,'1cf94170-9efa-11e8-81b2-f69c7713c194.mp4','2018-08-13 11:09:56','2018-08-13 11:09:56',NULL),(31,1,1,'60500670-9efa-11e8-8681-93183dd3ead7.mp4','2018-08-13 11:11:45','2018-08-13 11:11:45',NULL),(32,1,1,'b25c0db0-9efa-11e8-83ab-631f0420a21a.mp4','2018-08-13 11:14:01','2018-08-13 11:14:01',NULL),(33,1,1,'e01a4230-9efa-11e8-808d-ca3cca7c1cf6.mp4','2018-08-13 11:15:26','2018-08-13 11:15:26',NULL),(34,1,1,'83622f70-9efb-11e8-8d07-2fea86cc7935.mp4','2018-08-13 11:19:41','2018-08-13 11:19:41',NULL),(35,1,1,'54904b90-9efc-11e8-8b8b-9631764c0c0d.mp4','2018-08-13 11:25:39','2018-08-13 11:25:39',NULL),(36,1,1,'859aa860-9efd-11e8-859e-5d53739bb595.mp4','2018-08-13 11:34:20','2018-08-13 11:34:20',NULL),(37,1,1,'bcc03df0-9efd-11e8-8d8e-a56ebdf2f1cc.mp4','2018-08-13 11:35:58','2018-08-13 11:35:58',NULL),(38,1,1,'0f52b340-9efe-11e8-84bf-65258b11b112.mp4','2018-08-13 11:38:12','2018-08-13 11:38:12',NULL),(39,1,1,'4e76f220-9efe-11e8-8000-a9466dbd11a4.mp4','2018-08-13 11:39:52','2018-08-13 11:39:52',NULL),(40,1,1,'ded5b770-9efe-11e8-872f-06a63dc92b36.mp4','2018-08-13 11:43:54','2018-08-13 11:43:54',NULL),(41,1,1,'44e02730-9eff-11e8-8d9c-7461e896fc6a.mp4','2018-08-13 11:46:54','2018-08-13 11:46:54',NULL),(42,1,1,'8d9e21c0-9eff-11e8-88d4-28776f64b44b.mp4','2018-08-13 11:48:52','2018-08-13 11:48:52',NULL),(43,1,1,'e7adbee0-9f00-11e8-821a-7876476246be.mp4','2018-08-13 11:58:21','2018-08-13 11:58:21',NULL),(44,1,1,'320ff390-9f01-11e8-808c-5f613e3bc5fd.mp4','2018-08-13 12:00:44','2018-08-13 12:00:44',NULL),(45,1,1,'a4b90fb0-9f03-11e8-81ba-36e0949e8ca1.mp4','2018-08-13 12:18:05','2018-08-13 12:18:05',NULL),(46,1,1,'bc769120-9f05-11e8-81b7-814d942a64b7.mp4','2018-08-13 12:33:07','2018-08-13 12:33:07',NULL),(47,1,1,'56b25cb0-9f06-11e8-8a20-fcd1dd6ebb34.mp4','2018-08-13 12:37:20','2018-08-13 12:37:20',NULL),(48,1,1,'9b12f090-9f06-11e8-88d4-91b1ba83bac1.mp4','2018-08-13 12:39:23','2018-08-13 12:39:23',NULL),(49,1,1,'9718ea20-9f07-11e8-828c-a2ccc2a8522a.mp4','2018-08-13 12:46:22','2018-08-13 12:46:22',NULL),(50,1,1,'c4f61850-9f07-11e8-81fb-7af86851a295.mp4','2018-08-13 12:47:41','2018-08-13 12:47:41',NULL),(51,1,1,'ee05b8e0-9f07-11e8-8659-3413be61d335.mp4','2018-08-13 12:48:51','2018-08-13 12:48:51',NULL),(52,1,1,'3c690370-9f08-11e8-8743-6cd41282bf4f.mp4','2018-08-13 12:51:03','2018-08-13 12:51:03',NULL),(53,1,1,'af6bea40-9f08-11e8-80f1-f634bd6fe528.mp4','2018-08-13 12:54:12','2018-08-13 12:54:12',NULL),(54,1,1,'43ffff60-9f0a-11e8-8342-ccb74d2cc64b.mp4','2018-08-13 13:05:35','2018-08-13 13:05:35',NULL),(55,1,1,'91825fd0-9f0a-11e8-819c-e771d8cb30d5.mp4','2018-08-13 13:07:31','2018-08-13 13:07:31',NULL),(56,1,1,'b37552a0-9f0a-11e8-8947-49f203ff5995.mp4','2018-08-13 13:08:34','2018-08-13 13:08:34',NULL),(57,1,1,'84d88880-9f0b-11e8-8228-dc98293cc21b.mp4','2018-08-13 13:14:33','2018-08-13 13:14:33',NULL),(58,1,1,'39bdee60-9f0d-11e8-8dbc-fb2d25e05c7a.mp4','2018-08-13 13:28:38','2018-08-13 13:28:38',NULL),(59,1,1,'a5d07cb0-9f0f-11e8-8d1e-83c8ba6cdddc.mp4','2018-08-13 13:46:03','2018-08-13 13:46:03',NULL),(60,1,1,'c9b537f0-9f10-11e8-85c6-0feb95d6f2ae.mp4','2018-08-13 13:52:45','2018-08-13 13:52:45',NULL),(61,1,1,'62efe730-9f11-11e8-872f-1e6f13b06e3a.mp4','2018-08-13 13:56:27','2018-08-13 13:56:27',NULL),(62,1,1,'9cf03b10-9f11-11e8-825a-b61ed098aca0.mp4','2018-08-13 13:58:25','2018-08-13 13:58:25',NULL),(63,1,1,'3a5966e0-9f14-11e8-86f9-e0f94293331c.mp4','2018-08-13 14:17:32','2018-08-13 14:17:32',NULL),(64,1,1,'cf59a0c0-9f14-11e8-87a3-29e267e98182.mp4','2018-08-13 14:21:40','2018-08-13 14:21:40',NULL),(65,1,1,'5592e520-9f15-11e8-8888-16cf33e66d62.mp4','2018-08-13 14:25:21','2018-08-13 14:25:21',NULL),(66,1,1,'aa75e4b0-9f16-11e8-8bb5-f40fcbb2fc1a.mp4','2018-08-13 14:34:55','2018-08-13 14:34:55',NULL),(67,1,1,'5806b960-9f17-11e8-8419-e71a12c41e65.mp4','2018-08-13 14:39:49','2018-08-13 14:39:49',NULL),(68,1,1,'b6fda320-9f17-11e8-8883-b5d9271ed1e5.mp4','2018-08-13 14:42:25','2018-08-13 14:42:25',NULL),(69,1,1,'2d26d030-9f18-11e8-83af-59a37a1772fe.mp4','2018-08-13 14:46:10','2018-08-13 14:46:10',NULL),(70,1,1,'89cd6150-9f18-11e8-8367-3ffc83b00ce4.mp4','2018-08-13 14:48:35','2018-08-13 14:48:35',NULL),(71,1,1,'e00e38a0-9f18-11e8-8211-13f99685418b.mp4','2018-08-13 14:51:06','2018-08-13 14:51:06',NULL);
160/*!40000 ALTER TABLE `video` ENABLE KEYS */;
161UNLOCK TABLES;
162/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
163
164/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
165/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
166/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
167/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
168/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
169/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
170/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
171
172-- Dump completed on 2018-08-16 13:51:13