new projectstart

1 files changed, 46 insertions, 0 deletions

diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..de827ea
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,46 @@
+
+CREATE TABLE PERSONS (
+  ID INT AUTO_INCREMENT PRIMARY KEY,
+  NAME VARCHAR(80) NOT NULL,
+  EMAIL VARCHAR(80),
+  AFFILIATION VARCHAR(80)
+);
+
+CREATE TABLE PERSONS_SETS (
+  PERSON_ID INT NOT NULL,
+  SET_ID INT NOT NULL,
+  INDEX ( PERSON_ID ),
+  INDEX ( SET_ID )
+);
+
+CREATE TABLE SETS (
+  ID INT AUTO_INCREMENT PRIMARY KEY,
+  SETSTART DATETIME NOT NULL,
+  DURATION INT,
+  FILENAME VARCHAR(80),
+  FILESIZE INT,
+  DESCRIPTION VARCHAR(80),
+  INFO TEXT,
+  KEYWORDS VARCHAR(160),
+  DOWNLOADS INT,
+  SHOW_ID INT NOT NULL,
+  INDEX ( SETSTART ),
+  INDEX ( SHOW_ID )
+);
+
+CREATE TABLE SHOWS (
+  ID INT AUTO_INCREMENT PRIMARY KEY,
+  PERSON_ID INT,
+  SHOWSTART DATETIME NOT NULL,
+  DURATION INT,
+  STUDIO_ID INT NOT NULL,
+  INDEX ( SHOWSTART ),
+  INDEX ( STUDIO_ID )
+);
+
+CREATE TABLE STUDIOS (
+  ID INT AUTO_INCREMENT PRIMARY KEY,
+  NAME VARCHAR(80),
+  ISLIVE CHAR(1)
+);
+