-
Notifications
You must be signed in to change notification settings - Fork 3
/
Movie-DB.sql
57 lines (44 loc) · 1.05 KB
/
Movie-DB.sql
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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
use movies;
set table_type=myisam;
create table movies (
movieid int unsigned not NULL AUTO_INCREMENT,
title char(64) not NULL,
year smallint not NULL,
rating decimal,
plot blob default '',
downloaded int unsigned not NULL,
url char(64),
primary key (movieid),
unique index (title)
);
create table directors (
directorid int unsigned not NULL AUTO_INCREMENT,
director char(64) not NULL,
primary key (directorid),
unique index (director)
);
create table genres (
genreid int unsigned not NULL AUTO_INCREMENT,
genre char(64) not NULL,
primary key (genreid),
unique index (genre)
);
create table actors (
actorid int unsigned not NULL AUTO_INCREMENT,
actor char(64) not NULL,
primary key (actorid),
unique index (actor)
);
-- -------
create table director_data (
movieid int unsigned not NULL,
directorid int unsigned not NULL
);
create table genre_data (
movieid int unsigned not NULL,
genreid int unsigned not NULL
);
create table actor_data (
movieid int unsigned not NULL,
actorid int unsigned not NULL
);