Difference between revisions of "Yurttas/PL/DBL/mysql-f-2010/01/Movies/StarsIn-cre.sql"
Jump to navigation
Jump to search
(Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM StarsIn-cre.sql REM REM: \. set-db.sql CREATE TABLE StarsIn(title VARCHAR(24) NOT NULL, ...") |
(No difference)
|
Latest revision as of 02:08, 4 November 2013
1/*
2REM
3REM
4REM StarsIn-cre.sql
5REM
6REM
7*/
8
9\. set-db.sql
10
11CREATE TABLE StarsIn(title VARCHAR(24) NOT NULL,
12 year INTEGER NOT NULL,
13 name VARCHAR(24) NOT NULL,
14 PRIMARY KEY(title, year, name),
15 FOREIGN KEY(title, year) REFERENCES Movie(title, year),
16 FOREIGN KEY(name) REFERENCES MovieStar(name));