From df2a7c9e88e74e862aa0e4abd612b7d8eaead236 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Wed, 27 Jan 1999 09:55:05 +0000
Subject: new project

---
 schema.sql | 46 ++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 46 insertions(+)
 create mode 100644 schema.sql

(limited to 'schema.sql')

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)
+);
+
-- 
cgit v1.2.1

