Changeset 38b61bc in confclerk_git for src

Timestamp:

09/25/12 21:10:30 (10 years ago)

Author:

Philipp Spitzer <philipp@…>

Branches:

master, qt5

Children:

9bbd5ae

Parents:

4403ab4

Message:

Changed table names to have small letters.

File:

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

src/dbschema001.sql

@@ -1 +1 @@
 BEGIN TRANSACTION;
 
-CREATE TABLE CONFERENCE (
+CREATE TABLE conference (
         id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
         title VARCHAR NOT NULL,
@@ -15 +15 @@
 );
 
-CREATE TABLE TRACK (
+CREATE TABLE track (
         id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
-        xid_conference INTEGER NOT NULL REFERENCES CONFERENCE(id),
+        xid_conference INTEGER NOT NULL REFERENCES conference(id),
         name VARCHAR NOT NULL,
         UNIQUE (xid_conference, name)
 );
 
-CREATE TABLE ROOM (
+CREATE TABLE room (
         id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
-        xid_conference INTEGER NOT NULL REFERENCES CONFERENCE(id),
+        xid_conference INTEGER NOT NULL REFERENCES conference(id),
         name VARCHAR NOT NULL,
         picture VARCHAR,
@@ -30 +30 @@
 );
 
-CREATE TABLE PERSON (
+CREATE TABLE person (
         id INTEGER NOT NULL,
-        xid_conference INTEGER NOT NULL REFERENCES CONFERENCE(id),
+        xid_conference INTEGER NOT NULL REFERENCES conference(id),
         name VARCHAR NOT NULL,
         PRIMARY KEY (id, xid_conference)
 ); 
 
-CREATE TABLE EVENT (
-        xid_conference INTEGER NOT NULL REFERENCES CONFERENCE(id),
+CREATE TABLE event (
+        xid_conference INTEGER NOT NULL REFERENCES conference(id),
         id INTEGER NOT NULL,
         start INTEGER NOT NULL,
         duration INTEGER NOT NULL, -- duration of the event in seconds
-        xid_track INTEGER NOT NULL REFERENCES TRACK(id),
+        xid_track INTEGER NOT NULL REFERENCES track(id),
         type VARCHAR,
         language VARCHAR,
@@ -55 +55 @@
 );
 
-CREATE TABLE EVENT_PERSON (
+CREATE TABLE event_person (
         xid_conference INTEGER NOT NULL,
         xid_event INTEGER NOT NULL,
         xid_person INTEGER NOT NULL,
         UNIQUE (xid_conference, xid_event, xid_person ) ON CONFLICT REPLACE,
-        FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id),
-        FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id),
-        FOREIGN KEY(xid_conference, xid_person) REFERENCES PERSON(xid_conference, id)
+        FOREIGN KEY(xid_conference) REFERENCES conference(id),
+        FOREIGN KEY(xid_conference, xid_event) REFERENCES event(xid_conference, id),
+        FOREIGN KEY(xid_conference, xid_person) REFERENCES person(xid_conference, id)
 );
 
-CREATE TABLE EVENT_ROOM (
+CREATE TABLE event_room (
         xid_conference INTEGER NOT NULL,
         xid_event INTEGER NOT NULL,
         xid_room INTEGER NOT NULL,
         UNIQUE (xid_conference, xid_event, xid_room) ON CONFLICT REPLACE,
-        FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id),
-        FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id),
-        FOREIGN KEY(xid_conference, xid_room) REFERENCES ROOM(xid_conference, id)
+        FOREIGN KEY(xid_conference) REFERENCES conference(id),
+        FOREIGN KEY(xid_conference, xid_event) REFERENCES event(xid_conference, id),
+        FOREIGN KEY(xid_conference, xid_room) REFERENCES room(xid_conference, id)
 );
 
-CREATE TABLE LINK (
+CREATE TABLE link (
         id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
         xid_conference INTEGER NOT NULL,
@@ -82 +82 @@
         url VARCHAR NOT NULL,
         UNIQUE (xid_conference, xid_event , url) ON CONFLICT REPLACE,
-        FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id),
-        FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id)
+        FOREIGN KEY(xid_conference) REFERENCES conference(id),
+        FOREIGN KEY(xid_conference, xid_event) REFERENCES event(xid_conference, id)
 );