- Timestamp:
- 06/22/11 22:35:29 (12 years ago)
- Branches:
- master, qt5
- Children:
- 63b2343
- Parents:
- f657e9c
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
src/create_tables.sql
rf657e9c r865aab6 15 15 16 16 CREATE TABLE TRACK ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL 17 , xid_conference INTEGER --NOT NULL17 , xid_conference INTEGER NOT NULL 18 18 , name VARCHAR NOT NULL 19 19 , UNIQUE (xid_conference, name)); 20 20 21 CREATE TABLE ROOM ( id INTEGER PRIMARY KEY 22 , xid_conference INTEGER --NOT NULL21 CREATE TABLE ROOM ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL 22 , xid_conference INTEGER NOT NULL 23 23 , name VARCHAR NOT NULL 24 24 , picture VARCHAR NOT NULL 25 25 , UNIQUE (xid_conference, name)); 26 26 27 CREATE TABLE PERSON ( id INTEGER PRIMARY KEYNOT NULL28 , xid_conference INTEGER --NOT NULL27 CREATE TABLE PERSON ( id INTEGER NOT NULL 28 , xid_conference INTEGER NOT NULL 29 29 , name VARCHAR NOT NULL 30 , UNIQUE (xid_conference, name)); 30 , UNIQUE (xid_conference, name) 31 , PRIMARY KEY (id, xid_conference)); 31 32 32 33 CREATE TABLE EVENT ( xid_conference INTEGER NOT NULL … … 54 55 , FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id) 55 56 , FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id) 56 , FOREIGN KEY(xid_person) REFERENCES PERSON(id)); 57 57 , FOREIGN KEY(xid_conference, xid_person) REFERENCES PERSON(xid_conference, id)); 58 58 59 59 CREATE TABLE EVENT_ROOM ( xid_conference INTEGER NOT NULL … … 63 63 , FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id) 64 64 , FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id) 65 , FOREIGN KEY(xid_ room) REFERENCES ROOM(id));65 , FOREIGN KEY(xid_conference, xid_room) REFERENCES ROOM(xid_conference, id)); 66 66 67 67 CREATE TABLE LINK ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL
Note: See TracChangeset
for help on using the changeset viewer.