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

From ZCubes Wiki
Jump to navigation Jump to search
 1/*
 2REM
 3REM
 4REM MovieStar-cre.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "movies";
11
12CREATE TABLE MovieStar(name VARCHAR(24) NOT NULL,
13                       address VARCHAR(24),
14                       gender CHAR,
15                       birthdate CHAR(4),
16           PRIMARY KEY(name));