Changeset 14c46c7 in confclerk_git for src

Timestamp:

09/25/12 20:27:42 (10 years ago)

Author:

Philipp Spitzer <philipp@…>

Branches:

master, qt5

Children:

5293ef0

Parents:

0ba2b59

Message:

Suggestion for database schema version 001.

File:

• src/dbschema001.sql (modified) (3 diffs)

src/dbschema001.sql

@@ -4 +4 @@
     , subtitle VARCHAR
     , venue VARCHAR
-    , city VARCHAR NOT NULL
-    , start INTEGER NOT NULL
-    , end INTEGER NOT NULL
-    , days INTEGER
+    , city VARCHAR
+    , start INTEGER NOT NULL -- timestamp (Unix Epoch)
+    , end INTEGER NOT NULL   -- timestamp (Unix Epoch)
     , day_change INTEGER
     , timeslot_duration INTEGER
@@ -14 +13 @@
 
 CREATE TABLE TRACK ( id INTEGER  PRIMARY KEY AUTOINCREMENT  NOT NULL
-    , xid_conference INTEGER NOT NULL
+    , xid_conference INTEGER NOT NULL REFERENCES CONFERENCE(id)
     , name VARCHAR NOT NULL
     , UNIQUE (xid_conference, name));
 
 CREATE TABLE ROOM ( id INTEGER PRIMARY KEY AUTOINCREMENT  NOT NULL
-    , xid_conference INTEGER NOT NULL
+    , xid_conference INTEGER NOT NULL REFERENCES CONFERENCE(id)
     , name VARCHAR NOT NULL
-    , picture VARCHAR NOT NULL
+    , picture VARCHAR
     , UNIQUE (xid_conference, name));
 
 CREATE TABLE PERSON ( id INTEGER NOT NULL
-    , xid_conference INTEGER NOT NULL
+    , xid_conference INTEGER NOT NULL REFERENCES CONFERENCE(id)
     , name VARCHAR NOT NULL
-    , UNIQUE (xid_conference, name)
     , PRIMARY KEY (id, xid_conference)); 
 
-CREATE TABLE EVENT ( xid_conference INTEGER  NOT NULL
+CREATE TABLE EVENT ( xid_conference INTEGER  NOT NULL REFERENCES CONFERENCE(id)
     , id INTEGER NOT NULL
     , start INTEGER NOT NULL
@@ -44 +42 @@
     , favourite INTEGER DEFAULT 0
     , alarm INTEGER DEFAULT 0
-    , PRIMARY KEY (xid_conference ,id)
-    , FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id)
-    , FOREIGN KEY(xid_track) REFERENCES TRACK(id));
+    , PRIMARY KEY (xid_conference ,id));
 
 CREATE TABLE EVENT_PERSON ( xid_conference INTEGER NOT NULL