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,
18 CREATE TABLE PERSONS (
19 PERSON_ID INT AUTO_INCREMENT PRIMARY KEY,
20 NAME VARCHAR(80) NOT NULL,
21 DESCRIPTION VARCHAR(160),
24 KEYWORDS VARCHAR(160),
30 CREATE TABLE PERSONS_SETS (
31 PERSON_ID INT NOT NULL,
38 SET_ID INT AUTO_INCREMENT PRIMARY KEY,
39 SETSTART DATETIME NOT NULL,
41 DESCRIPTION VARCHAR(160),
42 KEYWORDS VARCHAR(160),
48 CREATE TABLE PERSONS_SHOWS (
49 PERSON_ID INT NOT NULL,
56 SHOW_ID INT AUTO_INCREMENT PRIMARY KEY,
58 SHOW VARCHAR(80) NOT NULL,
59 DESCRIPTION VARCHAR(160),
60 SHOWSTART DATETIME NOT NULL,
62 STUDIO_ID INT NOT NULL,
68 FILE_ID AUTO_INCREMENT PRIMARY KEY,
76 CREATE TABLE DOWNLOADS (
78 WHEN DATETIME NOT NULL,
83 CREATE TABLE STUDIOS (
84 STUDIO_ID INT AUTO_INCREMENT PRIMARY KEY,
90 GEAR_ID INT AUTO_INCREMENT PRIMARY KEY,
93 CREATE TABLE PERSONS_GEARS (
95 PERSON_ID INT NOT NULL,
100 CREATE TABLE CREWS_GEARS (
101 GEAR_ID INT NOT NULL,
102 CREW_ID INT NOT NULL,