Yurttas/PL/DBL/mysql/F/01/00/Movies/Movie-cre.sql
Revision as of 16:23, 3 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Movie-cre.sql REM REM: \. set-db.sql CREATE TABLE Movie(title VARCHAR(24) NOT NULL, ...")
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));