2 CREW_ID INT AUTO_INCREMENT PRIMARY KEY,
3 CREW VARCHAR(80) NOT NULL,
4 DESCRIPTION VARCHAR(160),
11 CREATE TABLE CREWS_PERSONS (
13 PERSON_ID INT NOT NULL,
19 CREATE TABLE PERSONS (
20 PERSON_ID INT AUTO_INCREMENT PRIMARY KEY,
21 NAME VARCHAR(80) NOT NULL,
22 DESCRIPTION VARCHAR(160),
25 KEYWORDS VARCHAR(160),
31 CREATE TABLE CONTACTS (
32 PERSON_ID INT PRIMARY KEY,
47 CREATE TABLE PERSONS_SETS (
48 PERSON_ID INT NOT NULL,
55 SET_ID INT AUTO_INCREMENT PRIMARY KEY,
56 SETSTART DATETIME NOT NULL,
58 DESCRIPTION VARCHAR(160),
59 KEYWORDS VARCHAR(160),
65 CREATE TABLE PERSONS_SHOWS (
66 PERSON_ID INT NOT NULL,
73 SHOW_ID INT AUTO_INCREMENT PRIMARY KEY,
75 SHOW VARCHAR(80) NOT NULL,
76 DESCRIPTION VARCHAR(160),
77 SHOWSTART DATETIME NOT NULL,
79 STUDIO_ID INT NOT NULL,
85 FILE_ID AUTO_INCREMENT PRIMARY KEY,
93 CREATE TABLE DOWNLOADS (
95 WHEN DATETIME NOT NULL,
100 CREATE TABLE STUDIOS (
101 STUDIO_ID INT AUTO_INCREMENT PRIMARY KEY,
107 GEAR_ID INT AUTO_INCREMENT PRIMARY KEY,
108 GEAR VARCHAR(80) NOT NULL,
109 DESCRIPTION VARCHAR(160),
114 CREATE TABLE PERSONS_GEARS (
115 GEAR_ID INT NOT NULL,
116 PERSON_ID INT NOT NULL,
121 CREATE TABLE CREWS_GEARS (
122 GEAR_ID INT NOT NULL,
123 CREW_ID INT NOT NULL,