Yurttas/PL/DBL/mysql-f-2010/01/Movies/Studio-cre.sql
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));