3 CREW_ID INT AUTO_INCREMENT PRIMARY KEY,
4 CREW VARCHAR(80) NOT NULL,
5 DESCRIPTION VARCHAR(160),
12 CREATE TABLE CREWS_PERSONS (
14 PERSON_ID INT NOT NULL,
20 CREATE TABLE PERSONS (
21 PERSON_ID INT AUTO_INCREMENT PRIMARY KEY,
22 NAME VARCHAR(80) NOT NULL,
23 DESCRIPTION VARCHAR(160),
26 KEYWORDS VARCHAR(160),
32 CREATE TABLE CONTACTS (
33 PERSON_ID INT PRIMARY KEY,
48 CREATE TABLE PERSONS_SETS (
49 PERSON_ID INT NOT NULL,
56 SET_ID INT AUTO_INCREMENT PRIMARY KEY,
57 SETSTART DATETIME NOT NULL,
59 DESCRIPTION VARCHAR(160),
60 KEYWORDS VARCHAR(160),
66 CREATE TABLE PERSONS_SHOWS (
67 PERSON_ID INT NOT NULL,
74 SHOW_ID INT AUTO_INCREMENT PRIMARY KEY,
76 SHOW VARCHAR(80) NOT NULL,
77 DESCRIPTION VARCHAR(160),
78 SHOWSTART DATETIME NOT NULL,
80 STUDIO_ID INT NOT NULL,
86 FILE_ID AUTO_INCREMENT PRIMARY KEY,
94 CREATE TABLE DOWNLOADS (
96 WHEN DATETIME NOT NULL,
101 CREATE TABLE STUDIOS (
102 STUDIO_ID INT AUTO_INCREMENT PRIMARY KEY,
108 GEAR_ID INT AUTO_INCREMENT PRIMARY KEY,
109 GEAR VARCHAR(80) NOT NULL,
110 DESCRIPTION VARCHAR(160),
115 CREATE TABLE PERSONS_GEARS (
116 GEAR_ID INT NOT NULL,
117 PERSON_ID INT NOT NULL,
122 CREATE TABLE CREWS_GEARS (
123 GEAR_ID INT NOT NULL,
124 CREW_ID INT NOT NULL,