X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=schema.sql;h=7edac6f6f8fe93333a65efb257f3849b0f681458;hb=HEAD;hp=5fc2635d4f85a6d20e57f9d8eb92097b08e52392;hpb=59334ecde5ad866ad8937f002f1faee48c1906d6;p=technostate.git

diff --git a/schema.sql b/schema.sql
index 5fc2635..7edac6f 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,10 +1,48 @@
+//test change
+CREATE TABLE CREWS (
+  CREW_ID INT AUTO_INCREMENT PRIMARY KEY,
+  CREW VARCHAR(80) NOT NULL,
+  DESCRIPTION VARCHAR(160),
+  KEYWORDS VARCHAR(160),
+  URL VARCHAR(80),
+  INDEX ( CREW_ID ),
+  INDEX ( NAME )
+);
+
+CREATE TABLE CREWS_PERSONS (
+  CREW_ID INT NOT NULL,
+  PERSON_ID INT NOT NULL,
+  TITLE VARCHAR(80),
+  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),
+  URL VARCHAR(80),
+  KEYWORDS VARCHAR(160),
+  PICTURE LONGBLOB,
+  INDEX ( PERSON_ID ),
+  INDEX ( NAME )
+);
+
+CREATE TABLE CONTACTS (
+  PERSON_ID INT PRIMARY KEY,
+  TITLE VARCHAR(80),
+  PHONE VARCHAR(80),
+  PAGER VARCHAR(20),
+  CELL VARCHAR(20),
+  FAX VARCHAR(10),
   EMAIL VARCHAR(80),
-  AFFILIATION VARCHAR(80),
-  HOMEPAGE VARCHAR(80)
+  ADDRESS1 VARCHAR(80),
+  ADDRESS2 VARCHAR(80),
+  CITY VARCHAR(80),
+  STATE VARCHAR(80),
+  ZIP VARCHAR(10),
+  COUNTRY CHAR(2),
 );
 
 CREATE TABLE PERSONS_SETS (
@@ -18,20 +56,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 +82,48 @@ 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,
+  GEAR VARCHAR(80) NOT NULL,
+  DESCRIPTION VARCHAR(160),
+  PRICE FLOAT
+  URL VARCHAR(80),
+);
+
+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 )
+);
+