Yurttas/PL/DBL/postgres/F/01/Movies/Studio-cre.sql

 1/*
 2REM
 3REM
 4REM Studio-cre.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "movies";
11
12CREATE TABLE Studio(name VARCHAR(36) NOT NULL,
13                    address VARCHAR(24),
14                    prescn INTEGER NOT NULL,
15        PRIMARY KEY(name),
16        FOREIGN KEY(prescn) REFERENCES MovieExec(cn));