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

From ZCubes Wiki
Jump to navigation Jump to search
 1/*
 2REM
 3REM
 4REM Studio-cre.sql
 5REM
 6REM
 7*/
 8
 9\. set-db.sql
10
11CREATE TABLE Studio(name VARCHAR(36) NOT NULL,
12                    address VARCHAR(24),
13                    prescn INTEGER NOT NULL,
14        PRIMARY KEY(name),
15        FOREIGN KEY(prescn) REFERENCES MovieExec(cn));