LOAD       Version 11.01.00      Date 1999-09-10
/ *
CREATE TABLE "ENGLISH"."Genres"             (
"GID" INTEGER ,
"GNAME" VARCHAR(50) ASCII NOT NULL,
"GTEXT" VARCHAR(200) ASCII
, PRIMARY KEY ("GID"
))
/ *
CREATE TABLE "ENGLISH"."Actors"             (
"AID" INTEGER ,
"ANAME" VARCHAR(50) ASCII NOT NULL,
"ATEXT" VARCHAR(1000) ASCII
, PRIMARY KEY ("AID"
))
/ *
CREATE TABLE "ENGLISH"."Tapes"              (
"TID" INTEGER ,
"TNAME" VARCHAR(50) ASCII NOT NULL,
"TLENGTH" INTEGER NOT NULL
, PRIMARY KEY ("TID"
))
/ *
CREATE TABLE "ENGLISH"."Movies"             (
"MID" INTEGER ,
"MNAME" VARCHAR(50) ASCII NOT NULL,
"MLENGTH" INTEGER NOT NULL,
"MTEXT" VARCHAR(500) ASCII ,
"GID" INTEGER NOT NULL,
"TID" INTEGER ,
"MIMAGE" LONG BYTE ,
"MDIRECTOR" VARCHAR(50) ASCII ,
"MYEAR" INTEGER
, PRIMARY KEY ("MID"
))
/ *
ALTER TABLE "ENGLISH"."Movies"             FOREIGN KEY "Genres_Movies"
("GID"
) REFERENCES "ENGLISH"."Genres"
("GID"
) ON DELETE RESTRICT
/ *
ALTER TABLE "ENGLISH"."Movies"             FOREIGN KEY "Tapes_Movies"
("TID"
) REFERENCES "ENGLISH"."Tapes"
("TID"
) ON DELETE RESTRICT
/ *
CREATE TABLE "ENGLISH"."Movies_Actors"      (
"RID" INTEGER ,
"MID" INTEGER NOT NULL,
"AID" INTEGER NOT NULL
, PRIMARY KEY ("RID"
))
/ *
ALTER TABLE "ENGLISH"."Movies_Actors"      FOREIGN KEY "Actors_Movies_Acto"
("AID"
) REFERENCES "ENGLISH"."Actors"
("AID"
) ON DELETE RESTRICT
/ *
ALTER TABLE "ENGLISH"."Movies_Actors"      FOREIGN KEY "Movies_Movies_Acto"
("MID"
) REFERENCES "ENGLISH"."Movies"
("MID"
) ON DELETE RESTRICT
/ *
/ *