Yurttas/PL/DBL/mysql-f-2010/01/Movies/Movie-cre.sql

 1/*
 2REM
 3REM
 4REM Movie-cre.sql
 5REM
 6REM
 7*/
 8
 9\. set-db.sql
10
11CREATE TABLE Movie(title VARCHAR(24) NOT NULL,
12                   year INTEGER NOT NULL,
13                   length INTEGER,
14                   filmtype VARCHAR(5),
15                   studioname VARCHAR(36) NOT NULL,
16                   producercn INTEGER NOT NULL,
17       PRIMARY KEY(title, year),
18       FOREIGN KEY(studioname) REFERENCES Studio(name),
19       FOREIGN KEY(producercn) REFERENCES MovieExec(cn));