big changes

diff --git a/schema.sql b/schema.sql
index 5fc2635..bb3c482 100644 (file)
--- a/schema.sql
+++ b/schema.sql
@@ -1,10 +1,30 @@
+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 )
+);
 
 CREATE TABLE PERSONS (
   PERSON_ID INT AUTO_INCREMENT PRIMARY KEY,
   NAME VARCHAR(80) NOT NULL,
+  DESCRIPTION VARCHAR(160),
   EMAIL VARCHAR(80),
-  AFFILIATION VARCHAR(80),
-  HOMEPAGE VARCHAR(80)
+  HOMEPAGE VARCHAR(80),
+  KEYWORDS VARCHAR(160),
+  PICTURE LONGBLOB,
+  INDEX ( PERSON_ID ),
+  INDEX ( NAME )
 );
 
 CREATE TABLE PERSONS_SETS (
@@ -18,20 +38,25 @@ CREATE TABLE SETS (
   SET_ID INT AUTO_INCREMENT PRIMARY KEY,
   SETSTART DATETIME NOT NULL,
   DURATION INT,
-  FILENAME VARCHAR(80),
-  FILESIZE INT,
-  DESCRIPTION VARCHAR(80),
-  INFO TEXT,
+  DESCRIPTION VARCHAR(160),
   KEYWORDS VARCHAR(160),
-  DOWNLOADS INT,
   SHOW_ID INT NOT NULL,
   INDEX ( SETSTART ),
   INDEX ( SHOW_ID )
 );
 
+CREATE TABLE PERSONS_SHOWS (
+  PERSON_ID INT NOT NULL,
+  SHOW_ID INT NOT NULL,
+  INDEX ( PERSON_ID ),
+  INDEX ( SET_ID )
+);
+
 CREATE TABLE SHOWS (
   SHOW_ID INT AUTO_INCREMENT PRIMARY KEY,
-  PERSON_ID INT,
+  REPEAT_SHOW_ID INT,
+  SHOW VARCHAR(80) NOT NULL,
+  DESCRIPTION VARCHAR(160),
   SHOWSTART DATETIME NOT NULL,
   DURATION INT,
   STUDIO_ID INT NOT NULL,
@@ -39,10 +64,44 @@ CREATE TABLE SHOWS (
   INDEX ( STUDIO_ID )
 );
 
+CREATE TABLE FILE (
+  FILE_ID AUTO_INCREMENT PRIMARY KEY,
+  FILENAME VARCHAR(80),
+  FILESIZE INT,
+  SHOW_ID INT,
+  INDEX ( FILE_ID ),
+  INDEX ( SHOW_ID )
+);
+
+CREATE TABLE DOWNLOADS (
+  FILE_ID INT NOT NULL,
+  WHEN DATETIME NOT NULL,
+  INDEX ( FILE_ID ),
+  INDEX ( WHEN )
+);
+
 CREATE TABLE STUDIOS (
   STUDIO_ID INT AUTO_INCREMENT PRIMARY KEY,
   NAME VARCHAR(80),
   ISLIVE CHAR(1)
 );
 
+CREATE TABLE GEARS (
+  GEAR_ID INT AUTO_INCREMENT PRIMARY KEY,
+);
+
+CREATE TABLE PERSONS_GEARS (
+  GEAR_ID INT NOT NULL,
+  PERSON_ID INT NOT NULL,
+  INDEX ( GEAR_ID ),
+  INDEX ( PERSON_ID )
+);
+
+CREATE TABLE CREWS_GEARS (
+  GEAR_ID INT NOT NULL,
+  CREW_ID INT NOT NULL,
+  INDEX ( GEAR_ID ),
+  INDEX ( CREW_ID )
+);
+