· 8 years ago · Jun 03, 2018, 12:24 AM
1-- MySQL dump 10.13 Distrib 5.7.22, for osx10.13 (x86_64)
2--
3-- Host: 127.0.0.1 Database: new_streamit
4-- ------------------------------------------------------
5-- Server version 5.7.22
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 `cast`
20--
21
22DROP TABLE IF EXISTS `cast`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `cast` (
26 `Video ID` int(11) NOT NULL,
27 `Person ID` int(11) NOT NULL,
28 `Cast Role ID` int(11) NOT NULL,
29 PRIMARY KEY (`Person ID`,`Video ID`),
30 KEY `cast_videos_ID_fk` (`Video ID`),
31 KEY `cast_cast_role_Cast Role ID_fk` (`Cast Role ID`),
32 CONSTRAINT `cast_cast_role_Cast Role ID_fk` FOREIGN KEY (`Cast Role ID`) REFERENCES `cast_role` (`Cast Role ID`),
33 CONSTRAINT `cast_peoples_Person ID_fk` FOREIGN KEY (`Person ID`) REFERENCES `people` (`Person ID`),
34 CONSTRAINT `cast_videos_ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Dumping data for table `cast`
40--
41
42LOCK TABLES `cast` WRITE;
43/*!40000 ALTER TABLE `cast` DISABLE KEYS */;
44/*!40000 ALTER TABLE `cast` ENABLE KEYS */;
45UNLOCK TABLES;
46
47--
48-- Table structure for table `cast_role`
49--
50
51DROP TABLE IF EXISTS `cast_role`;
52/*!40101 SET @saved_cs_client = @@character_set_client */;
53/*!40101 SET character_set_client = utf8 */;
54CREATE TABLE `cast_role` (
55 `Cast Role ID` int(11) NOT NULL AUTO_INCREMENT,
56 PRIMARY KEY (`Cast Role ID`)
57) ENGINE=InnoDB DEFAULT CHARSET=utf8;
58/*!40101 SET character_set_client = @saved_cs_client */;
59
60--
61-- Dumping data for table `cast_role`
62--
63
64LOCK TABLES `cast_role` WRITE;
65/*!40000 ALTER TABLE `cast_role` DISABLE KEYS */;
66/*!40000 ALTER TABLE `cast_role` ENABLE KEYS */;
67UNLOCK TABLES;
68
69--
70-- Table structure for table `cast_role_names`
71--
72
73DROP TABLE IF EXISTS `cast_role_names`;
74/*!40101 SET @saved_cs_client = @@character_set_client */;
75/*!40101 SET character_set_client = utf8 */;
76CREATE TABLE `cast_role_names` (
77 `Cast Role ID` int(11) DEFAULT NULL,
78 `Language ID` int(11) DEFAULT NULL,
79 `Name` varchar(255) DEFAULT NULL,
80 KEY `cast_role_names_cast_role_Cast Role ID_fk` (`Cast Role ID`),
81 KEY `cast_role_names_language_Language ID_fk` (`Language ID`),
82 CONSTRAINT `cast_role_names_cast_role_Cast Role ID_fk` FOREIGN KEY (`Cast Role ID`) REFERENCES `cast_role` (`Cast Role ID`),
83 CONSTRAINT `cast_role_names_language_Language ID_fk` FOREIGN KEY (`Language ID`) REFERENCES `language` (`Language ID`)
84) ENGINE=InnoDB DEFAULT CHARSET=utf8;
85/*!40101 SET character_set_client = @saved_cs_client */;
86
87--
88-- Dumping data for table `cast_role_names`
89--
90
91LOCK TABLES `cast_role_names` WRITE;
92/*!40000 ALTER TABLE `cast_role_names` DISABLE KEYS */;
93/*!40000 ALTER TABLE `cast_role_names` ENABLE KEYS */;
94UNLOCK TABLES;
95
96--
97-- Table structure for table `episodes`
98--
99
100DROP TABLE IF EXISTS `episodes`;
101/*!40101 SET @saved_cs_client = @@character_set_client */;
102/*!40101 SET character_set_client = utf8 */;
103CREATE TABLE `episodes` (
104 `Episode ID` int(11) NOT NULL AUTO_INCREMENT,
105 `Season ID` int(11) DEFAULT NULL,
106 `Video ID` int(11) NOT NULL,
107 `Episode` int(11) NOT NULL,
108 PRIMARY KEY (`Episode ID`),
109 KEY `episodes_seasons_Season ID_fk` (`Season ID`),
110 KEY `episodes_videos_ID_fk` (`Video ID`),
111 CONSTRAINT `episodes_seasons_Season ID_fk` FOREIGN KEY (`Season ID`) REFERENCES `seasons` (`Season ID`),
112 CONSTRAINT `episodes_videos_ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`)
113) ENGINE=InnoDB DEFAULT CHARSET=utf8;
114/*!40101 SET character_set_client = @saved_cs_client */;
115
116--
117-- Dumping data for table `episodes`
118--
119
120LOCK TABLES `episodes` WRITE;
121/*!40000 ALTER TABLE `episodes` DISABLE KEYS */;
122/*!40000 ALTER TABLE `episodes` ENABLE KEYS */;
123UNLOCK TABLES;
124
125--
126-- Table structure for table `genre`
127--
128
129DROP TABLE IF EXISTS `genre`;
130/*!40101 SET @saved_cs_client = @@character_set_client */;
131/*!40101 SET character_set_client = utf8 */;
132CREATE TABLE `genre` (
133 `Genre ID` int(11) NOT NULL AUTO_INCREMENT,
134 PRIMARY KEY (`Genre ID`)
135) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
136/*!40101 SET character_set_client = @saved_cs_client */;
137
138--
139-- Dumping data for table `genre`
140--
141
142LOCK TABLES `genre` WRITE;
143/*!40000 ALTER TABLE `genre` DISABLE KEYS */;
144INSERT INTO `genre` VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23),(24),(25),(26);
145/*!40000 ALTER TABLE `genre` ENABLE KEYS */;
146UNLOCK TABLES;
147
148--
149-- Table structure for table `genre_name`
150--
151
152DROP TABLE IF EXISTS `genre_name`;
153/*!40101 SET @saved_cs_client = @@character_set_client */;
154/*!40101 SET character_set_client = utf8 */;
155CREATE TABLE `genre_name` (
156 `Genre ID` int(11) NOT NULL,
157 `Language ID` int(11) NOT NULL,
158 `Name` varchar(255) NOT NULL,
159 PRIMARY KEY (`Genre ID`,`Language ID`),
160 KEY `genre_name_language_Language ID_fk` (`Language ID`),
161 CONSTRAINT `genre_name_genre_Genre ID_fk` FOREIGN KEY (`Genre ID`) REFERENCES `genre` (`Genre ID`),
162 CONSTRAINT `genre_name_language_Language ID_fk` FOREIGN KEY (`Language ID`) REFERENCES `language` (`Language ID`)
163) ENGINE=InnoDB DEFAULT CHARSET=utf8;
164/*!40101 SET character_set_client = @saved_cs_client */;
165
166--
167-- Dumping data for table `genre_name`
168--
169
170LOCK TABLES `genre_name` WRITE;
171/*!40000 ALTER TABLE `genre_name` DISABLE KEYS */;
172INSERT INTO `genre_name` VALUES (1,1,'Action'),(1,2,'Action'),(2,1,'Abenteuer'),(2,2,'Adventure'),(3,1,'Animation'),(3,2,'Animation'),(4,1,'Biographie'),(4,2,'Biography'),(5,1,'Komödie'),(5,2,'Comedey'),(6,1,'Krimi'),(6,2,'Crime'),(7,1,'Dokumentation'),(7,2,'Documentary'),(8,1,'Drama'),(8,2,'Drama'),(9,1,'Familie'),(9,2,'Family'),(10,1,'Fantasie'),(10,2,'Fantasy'),(11,1,'Film-Noir'),(11,2,'Film-Noir'),(12,1,'Spieleshow'),(12,2,'Gameshow'),(13,1,'Geschichte'),(13,2,'History'),(14,1,'Horror'),(14,2,'Horror'),(15,1,'Musik'),(15,2,'Music'),(16,1,'Musical'),(16,2,'Musical'),(17,1,'Mystery'),(17,2,'Mystery'),(18,1,'Nachrichten'),(18,2,'News'),(19,1,'Reality-TV'),(19,2,'Reality-TV'),(20,1,'Romanze'),(20,2,'Romance'),(21,1,'Sci-Fi'),(21,2,'Sci-Fi'),(22,1,'Sport'),(22,2,'Sport'),(23,1,'Talk-Show'),(23,2,'Talk-Show'),(24,1,'Thriller'),(24,2,'Thriller'),(25,1,'Krieg'),(25,2,'War'),(26,1,'Western'),(26,2,'Western');
173/*!40000 ALTER TABLE `genre_name` ENABLE KEYS */;
174UNLOCK TABLES;
175
176--
177-- Table structure for table `genre_video`
178--
179
180DROP TABLE IF EXISTS `genre_video`;
181/*!40101 SET @saved_cs_client = @@character_set_client */;
182/*!40101 SET character_set_client = utf8 */;
183CREATE TABLE `genre_video` (
184 `Genre ID` int(11) NOT NULL,
185 `Video ID` int(11) NOT NULL,
186 PRIMARY KEY (`Genre ID`,`Video ID`),
187 CONSTRAINT `genre_video_genre_Genre ID_fk` FOREIGN KEY (`Genre ID`) REFERENCES `genre` (`Genre ID`),
188 CONSTRAINT `genre_video_videos_ID_fk` FOREIGN KEY (`Genre ID`) REFERENCES `videos` (`Video ID`)
189) ENGINE=InnoDB DEFAULT CHARSET=utf8;
190/*!40101 SET character_set_client = @saved_cs_client */;
191
192--
193-- Dumping data for table `genre_video`
194--
195
196LOCK TABLES `genre_video` WRITE;
197/*!40000 ALTER TABLE `genre_video` DISABLE KEYS */;
198/*!40000 ALTER TABLE `genre_video` ENABLE KEYS */;
199UNLOCK TABLES;
200
201--
202-- Table structure for table `language`
203--
204
205DROP TABLE IF EXISTS `language`;
206/*!40101 SET @saved_cs_client = @@character_set_client */;
207/*!40101 SET character_set_client = utf8 */;
208CREATE TABLE `language` (
209 `Language ID` int(11) NOT NULL AUTO_INCREMENT,
210 `Language` varchar(50) NOT NULL,
211 `Language Code` varchar(10) NOT NULL,
212 PRIMARY KEY (`Language ID`),
213 UNIQUE KEY `language_Language Code_uindex` (`Language Code`),
214 UNIQUE KEY `language_Language_uindex` (`Language`)
215) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
216/*!40101 SET character_set_client = @saved_cs_client */;
217
218--
219-- Dumping data for table `language`
220--
221
222LOCK TABLES `language` WRITE;
223/*!40000 ALTER TABLE `language` DISABLE KEYS */;
224INSERT INTO `language` VALUES (1,'Deutsch','de'),(2,'English','en');
225/*!40000 ALTER TABLE `language` ENABLE KEYS */;
226UNLOCK TABLES;
227
228--
229-- Table structure for table `people`
230--
231
232DROP TABLE IF EXISTS `people`;
233/*!40101 SET @saved_cs_client = @@character_set_client */;
234/*!40101 SET character_set_client = utf8 */;
235CREATE TABLE `people` (
236 `Person ID` int(11) NOT NULL AUTO_INCREMENT,
237 `Name` varchar(100) NOT NULL,
238 `Last Name` varchar(100) DEFAULT NULL,
239 PRIMARY KEY (`Person ID`)
240) ENGINE=InnoDB DEFAULT CHARSET=utf8;
241/*!40101 SET character_set_client = @saved_cs_client */;
242
243--
244-- Dumping data for table `people`
245--
246
247LOCK TABLES `people` WRITE;
248/*!40000 ALTER TABLE `people` DISABLE KEYS */;
249/*!40000 ALTER TABLE `people` ENABLE KEYS */;
250UNLOCK TABLES;
251
252--
253-- Table structure for table `roles`
254--
255
256DROP TABLE IF EXISTS `roles`;
257/*!40101 SET @saved_cs_client = @@character_set_client */;
258/*!40101 SET character_set_client = utf8 */;
259CREATE TABLE `roles` (
260 `Role ID` int(11) NOT NULL AUTO_INCREMENT,
261 `Name` varchar(255) NOT NULL,
262 PRIMARY KEY (`Role ID`),
263 UNIQUE KEY `roles_Name_uindex` (`Name`)
264) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
265/*!40101 SET character_set_client = @saved_cs_client */;
266
267--
268-- Dumping data for table `roles`
269--
270
271LOCK TABLES `roles` WRITE;
272/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
273INSERT INTO `roles` VALUES (1,'Admin'),(2,'Uploader'),(3,'User');
274/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
275UNLOCK TABLES;
276
277--
278-- Table structure for table `search_tags`
279--
280
281DROP TABLE IF EXISTS `search_tags`;
282/*!40101 SET @saved_cs_client = @@character_set_client */;
283/*!40101 SET character_set_client = utf8 */;
284CREATE TABLE `search_tags` (
285 `Video ID` int(11) NOT NULL AUTO_INCREMENT,
286 `Search Tag` varchar(255) NOT NULL,
287 PRIMARY KEY (`Video ID`),
288 CONSTRAINT `search_tags_videos_ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`)
289) ENGINE=InnoDB DEFAULT CHARSET=utf8;
290/*!40101 SET character_set_client = @saved_cs_client */;
291
292--
293-- Dumping data for table `search_tags`
294--
295
296LOCK TABLES `search_tags` WRITE;
297/*!40000 ALTER TABLE `search_tags` DISABLE KEYS */;
298/*!40000 ALTER TABLE `search_tags` ENABLE KEYS */;
299UNLOCK TABLES;
300
301--
302-- Table structure for table `seasons`
303--
304
305DROP TABLE IF EXISTS `seasons`;
306/*!40101 SET @saved_cs_client = @@character_set_client */;
307/*!40101 SET character_set_client = utf8 */;
308CREATE TABLE `seasons` (
309 `Season ID` int(11) NOT NULL AUTO_INCREMENT,
310 `Series ID` int(11) NOT NULL,
311 `Video ID` int(11) DEFAULT NULL,
312 PRIMARY KEY (`Season ID`),
313 KEY `seasons_video_series_ID_fk` (`Series ID`),
314 KEY `seasons_videos_ID_fk` (`Video ID`),
315 CONSTRAINT `seasons_video_series_ID_fk` FOREIGN KEY (`Series ID`) REFERENCES `video_series` (`Series ID`),
316 CONSTRAINT `seasons_videos_ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`)
317) ENGINE=InnoDB DEFAULT CHARSET=utf8;
318/*!40101 SET character_set_client = @saved_cs_client */;
319
320--
321-- Dumping data for table `seasons`
322--
323
324LOCK TABLES `seasons` WRITE;
325/*!40000 ALTER TABLE `seasons` DISABLE KEYS */;
326/*!40000 ALTER TABLE `seasons` ENABLE KEYS */;
327UNLOCK TABLES;
328
329--
330-- Table structure for table `similiar_videos`
331--
332
333DROP TABLE IF EXISTS `similiar_videos`;
334/*!40101 SET @saved_cs_client = @@character_set_client */;
335/*!40101 SET character_set_client = utf8 */;
336CREATE TABLE `similiar_videos` (
337 `Video ID` int(11) DEFAULT NULL,
338 `Similiar Video ID` int(11) DEFAULT NULL,
339 KEY `similiar_videos_videos_Video ID_fk` (`Video ID`),
340 KEY `similiar_videos_videos_Video ID_fk_2` (`Similiar Video ID`),
341 CONSTRAINT `similiar_videos_videos_Video ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`),
342 CONSTRAINT `similiar_videos_videos_Video ID_fk_2` FOREIGN KEY (`Similiar Video ID`) REFERENCES `videos` (`Video ID`)
343) ENGINE=InnoDB DEFAULT CHARSET=utf8;
344/*!40101 SET character_set_client = @saved_cs_client */;
345
346--
347-- Dumping data for table `similiar_videos`
348--
349
350LOCK TABLES `similiar_videos` WRITE;
351/*!40000 ALTER TABLE `similiar_videos` DISABLE KEYS */;
352/*!40000 ALTER TABLE `similiar_videos` ENABLE KEYS */;
353UNLOCK TABLES;
354
355--
356-- Table structure for table `title_type`
357--
358
359DROP TABLE IF EXISTS `title_type`;
360/*!40101 SET @saved_cs_client = @@character_set_client */;
361/*!40101 SET character_set_client = utf8 */;
362CREATE TABLE `title_type` (
363 `Title Type ID` int(11) NOT NULL AUTO_INCREMENT,
364 `Name` varchar(255) NOT NULL,
365 PRIMARY KEY (`Title Type ID`)
366) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
367/*!40101 SET character_set_client = @saved_cs_client */;
368
369--
370-- Dumping data for table `title_type`
371--
372
373LOCK TABLES `title_type` WRITE;
374/*!40000 ALTER TABLE `title_type` DISABLE KEYS */;
375INSERT INTO `title_type` VALUES (1,'Normal'),(2,'Original'),(3,'Alternative');
376/*!40000 ALTER TABLE `title_type` ENABLE KEYS */;
377UNLOCK TABLES;
378
379--
380-- Table structure for table `users`
381--
382
383DROP TABLE IF EXISTS `users`;
384/*!40101 SET @saved_cs_client = @@character_set_client */;
385/*!40101 SET character_set_client = utf8 */;
386CREATE TABLE `users` (
387 `User ID` int(11) NOT NULL AUTO_INCREMENT,
388 `E-Mail` varchar(255) NOT NULL,
389 `Username` varchar(255) NOT NULL,
390 `Password` varchar(255) NOT NULL,
391 `Role ID` int(11) DEFAULT NULL,
392 PRIMARY KEY (`User ID`),
393 UNIQUE KEY `user_E-Mail_uindex` (`E-Mail`),
394 UNIQUE KEY `user_Username_uindex` (`Username`),
395 KEY `users_roles_Role ID_fk` (`Role ID`),
396 CONSTRAINT `users_roles_Role ID_fk` FOREIGN KEY (`Role ID`) REFERENCES `roles` (`Role ID`)
397) ENGINE=InnoDB DEFAULT CHARSET=utf8;
398/*!40101 SET character_set_client = @saved_cs_client */;
399
400--
401-- Dumping data for table `users`
402--
403
404LOCK TABLES `users` WRITE;
405/*!40000 ALTER TABLE `users` DISABLE KEYS */;
406/*!40000 ALTER TABLE `users` ENABLE KEYS */;
407UNLOCK TABLES;
408
409--
410-- Table structure for table `video_background`
411--
412
413DROP TABLE IF EXISTS `video_background`;
414/*!40101 SET @saved_cs_client = @@character_set_client */;
415/*!40101 SET character_set_client = utf8 */;
416CREATE TABLE `video_background` (
417 `Video ID` int(11) DEFAULT NULL,
418 `Background` varchar(255) NOT NULL,
419 KEY `video_background_videos_ID_fk` (`Video ID`),
420 CONSTRAINT `video_background_videos_ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`)
421) ENGINE=InnoDB DEFAULT CHARSET=utf8;
422/*!40101 SET character_set_client = @saved_cs_client */;
423
424--
425-- Dumping data for table `video_background`
426--
427
428LOCK TABLES `video_background` WRITE;
429/*!40000 ALTER TABLE `video_background` DISABLE KEYS */;
430/*!40000 ALTER TABLE `video_background` ENABLE KEYS */;
431UNLOCK TABLES;
432
433--
434-- Table structure for table `video_banner`
435--
436
437DROP TABLE IF EXISTS `video_banner`;
438/*!40101 SET @saved_cs_client = @@character_set_client */;
439/*!40101 SET character_set_client = utf8 */;
440CREATE TABLE `video_banner` (
441 `Video ID` int(11) DEFAULT NULL,
442 `Banner` varchar(255) NOT NULL,
443 KEY `video_banner_videos_ID_fk` (`Video ID`),
444 CONSTRAINT `video_banner_videos_ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`)
445) ENGINE=InnoDB DEFAULT CHARSET=utf8;
446/*!40101 SET character_set_client = @saved_cs_client */;
447
448--
449-- Dumping data for table `video_banner`
450--
451
452LOCK TABLES `video_banner` WRITE;
453/*!40000 ALTER TABLE `video_banner` DISABLE KEYS */;
454/*!40000 ALTER TABLE `video_banner` ENABLE KEYS */;
455UNLOCK TABLES;
456
457--
458-- Table structure for table `video_description`
459--
460
461DROP TABLE IF EXISTS `video_description`;
462/*!40101 SET @saved_cs_client = @@character_set_client */;
463/*!40101 SET character_set_client = utf8 */;
464CREATE TABLE `video_description` (
465 `Video ID` int(11) DEFAULT NULL,
466 `Language ID` int(11) NOT NULL,
467 `Description` text NOT NULL,
468 KEY `movie_description_movies_ID_fk` (`Video ID`),
469 KEY `video_description_language_Language ID_fk` (`Language ID`),
470 CONSTRAINT `movie_description_movies_ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`),
471 CONSTRAINT `video_description_language_Language ID_fk` FOREIGN KEY (`Language ID`) REFERENCES `language` (`Language ID`)
472) ENGINE=InnoDB DEFAULT CHARSET=utf8;
473/*!40101 SET character_set_client = @saved_cs_client */;
474
475--
476-- Dumping data for table `video_description`
477--
478
479LOCK TABLES `video_description` WRITE;
480/*!40000 ALTER TABLE `video_description` DISABLE KEYS */;
481/*!40000 ALTER TABLE `video_description` ENABLE KEYS */;
482UNLOCK TABLES;
483
484--
485-- Table structure for table `video_imdb`
486--
487
488DROP TABLE IF EXISTS `video_imdb`;
489/*!40101 SET @saved_cs_client = @@character_set_client */;
490/*!40101 SET character_set_client = utf8 */;
491CREATE TABLE `video_imdb` (
492 `Video ID` int(11) NOT NULL AUTO_INCREMENT,
493 `IMDB ID` int(11) NOT NULL,
494 PRIMARY KEY (`Video ID`),
495 UNIQUE KEY `movies_imdb_IMDB_uindex` (`IMDB ID`),
496 CONSTRAINT `movies_imdb_movies_ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`)
497) ENGINE=InnoDB DEFAULT CHARSET=utf8;
498/*!40101 SET character_set_client = @saved_cs_client */;
499
500--
501-- Dumping data for table `video_imdb`
502--
503
504LOCK TABLES `video_imdb` WRITE;
505/*!40000 ALTER TABLE `video_imdb` DISABLE KEYS */;
506/*!40000 ALTER TABLE `video_imdb` ENABLE KEYS */;
507UNLOCK TABLES;
508
509--
510-- Table structure for table `video_links`
511--
512
513DROP TABLE IF EXISTS `video_links`;
514/*!40101 SET @saved_cs_client = @@character_set_client */;
515/*!40101 SET character_set_client = utf8 */;
516CREATE TABLE `video_links` (
517 `Video ID` int(11) NOT NULL AUTO_INCREMENT,
518 `Language ID` int(11) NOT NULL,
519 `Link` varchar(255) NOT NULL,
520 PRIMARY KEY (`Video ID`),
521 KEY `video_links_language_Language ID_fk` (`Language ID`),
522 CONSTRAINT `video_links_language_Language ID_fk` FOREIGN KEY (`Language ID`) REFERENCES `language` (`Language ID`),
523 CONSTRAINT `video_links_videos_ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`)
524) ENGINE=InnoDB DEFAULT CHARSET=utf8;
525/*!40101 SET character_set_client = @saved_cs_client */;
526
527--
528-- Dumping data for table `video_links`
529--
530
531LOCK TABLES `video_links` WRITE;
532/*!40000 ALTER TABLE `video_links` DISABLE KEYS */;
533/*!40000 ALTER TABLE `video_links` ENABLE KEYS */;
534UNLOCK TABLES;
535
536--
537-- Table structure for table `video_poster`
538--
539
540DROP TABLE IF EXISTS `video_poster`;
541/*!40101 SET @saved_cs_client = @@character_set_client */;
542/*!40101 SET character_set_client = utf8 */;
543CREATE TABLE `video_poster` (
544 `Video ID` int(11) DEFAULT NULL,
545 `Poster` varchar(255) NOT NULL,
546 KEY `video_poster_videos_ID_fk` (`Video ID`),
547 CONSTRAINT `video_poster_videos_ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`)
548) ENGINE=InnoDB DEFAULT CHARSET=utf8;
549/*!40101 SET character_set_client = @saved_cs_client */;
550
551--
552-- Dumping data for table `video_poster`
553--
554
555LOCK TABLES `video_poster` WRITE;
556/*!40000 ALTER TABLE `video_poster` DISABLE KEYS */;
557/*!40000 ALTER TABLE `video_poster` ENABLE KEYS */;
558UNLOCK TABLES;
559
560--
561-- Table structure for table `video_series`
562--
563
564DROP TABLE IF EXISTS `video_series`;
565/*!40101 SET @saved_cs_client = @@character_set_client */;
566/*!40101 SET character_set_client = utf8 */;
567CREATE TABLE `video_series` (
568 `Series ID` int(11) NOT NULL AUTO_INCREMENT,
569 `Video ID` int(11) DEFAULT NULL,
570 PRIMARY KEY (`Series ID`),
571 KEY `video_series_videos_ID_fk` (`Video ID`),
572 CONSTRAINT `video_series_videos_ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`)
573) ENGINE=InnoDB DEFAULT CHARSET=utf8;
574/*!40101 SET character_set_client = @saved_cs_client */;
575
576--
577-- Dumping data for table `video_series`
578--
579
580LOCK TABLES `video_series` WRITE;
581/*!40000 ALTER TABLE `video_series` DISABLE KEYS */;
582/*!40000 ALTER TABLE `video_series` ENABLE KEYS */;
583UNLOCK TABLES;
584
585--
586-- Table structure for table `video_title`
587--
588
589DROP TABLE IF EXISTS `video_title`;
590/*!40101 SET @saved_cs_client = @@character_set_client */;
591/*!40101 SET character_set_client = utf8 */;
592CREATE TABLE `video_title` (
593 `Video ID` int(11) DEFAULT NULL,
594 `Language ID` int(11) NOT NULL,
595 `Title Type ID` int(11) DEFAULT NULL,
596 `Title` varchar(255) NOT NULL,
597 KEY `movie_title_movies_ID_fk` (`Video ID`),
598 KEY `video_title_title_type_Title Type ID_fk` (`Title Type ID`),
599 CONSTRAINT `movie_title_movies_ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`),
600 CONSTRAINT `video_title_title_type_Title Type ID_fk` FOREIGN KEY (`Title Type ID`) REFERENCES `title_type` (`Title Type ID`)
601) ENGINE=InnoDB DEFAULT CHARSET=utf8;
602/*!40101 SET character_set_client = @saved_cs_client */;
603
604--
605-- Dumping data for table `video_title`
606--
607
608LOCK TABLES `video_title` WRITE;
609/*!40000 ALTER TABLE `video_title` DISABLE KEYS */;
610/*!40000 ALTER TABLE `video_title` ENABLE KEYS */;
611UNLOCK TABLES;
612
613--
614-- Table structure for table `video_tmdb`
615--
616
617DROP TABLE IF EXISTS `video_tmdb`;
618/*!40101 SET @saved_cs_client = @@character_set_client */;
619/*!40101 SET character_set_client = utf8 */;
620CREATE TABLE `video_tmdb` (
621 `Video ID` int(11) DEFAULT NULL,
622 `TMDb ID` int(11) NOT NULL,
623 UNIQUE KEY `video_tmdb_TMDb ID_uindex` (`TMDb ID`),
624 KEY `video_tmdb_videos_Video ID_fk` (`Video ID`),
625 CONSTRAINT `video_tmdb_videos_Video ID_fk` FOREIGN KEY (`Video ID`) REFERENCES `videos` (`Video ID`)
626) ENGINE=InnoDB DEFAULT CHARSET=utf8;
627/*!40101 SET character_set_client = @saved_cs_client */;
628
629--
630-- Dumping data for table `video_tmdb`
631--
632
633LOCK TABLES `video_tmdb` WRITE;
634/*!40000 ALTER TABLE `video_tmdb` DISABLE KEYS */;
635/*!40000 ALTER TABLE `video_tmdb` ENABLE KEYS */;
636UNLOCK TABLES;
637
638--
639-- Table structure for table `videos`
640--
641
642DROP TABLE IF EXISTS `videos`;
643/*!40101 SET @saved_cs_client = @@character_set_client */;
644/*!40101 SET character_set_client = utf8 */;
645CREATE TABLE `videos` (
646 `Video ID` int(11) NOT NULL AUTO_INCREMENT,
647 `Age Rating` int(11) DEFAULT '0',
648 `Duration` float DEFAULT '0',
649 `Rating` float DEFAULT '0',
650 `Upload Date` date NOT NULL,
651 `Year` int(11) NOT NULL DEFAULT '0',
652 PRIMARY KEY (`Video ID`)
653) ENGINE=InnoDB DEFAULT CHARSET=utf8;
654/*!40101 SET character_set_client = @saved_cs_client */;
655
656--
657-- Dumping data for table `videos`
658--
659
660LOCK TABLES `videos` WRITE;
661/*!40000 ALTER TABLE `videos` DISABLE KEYS */;
662/*!40000 ALTER TABLE `videos` ENABLE KEYS */;
663UNLOCK TABLES;
664/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
665
666/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
667/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
668/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
669/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
670/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
671/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
672/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
673
674-- Dump completed on 2018-06-03 2:19:06