+CREATE TABLE CREWS (
+ CREW_ID INT AUTO_INCREMENT PRIMARY KEY,
+ CREW VARCHAR(80) NOT NULL,
+ DESCRIPTION VARCHAR(160),
+ KEYWORDS VARCHAR(160),
+ HOMEPAGE VARCHAR(80),
+ INDEX ( CREW_ID ),
+ INDEX ( NAME )
+);
+
+CREATE TABLE CREWS_PERSONS (
+ CREW_ID INT NOT NULL,
+ PERSON_ID INT NOT NULL,
+ INDEX ( CREW_ID ),
+ INDEX ( PERSON_ID )
+);