Changeset 0d4ecc2 for src/sql

Timestamp:

01/25/10 09:02:15 (12 years ago)

Author:

timkoma <timkoma@…>

Branches:

master, qt5

Children:

6dc0dbc

Parents:

e7340e1

Message:

search update

File:

• src/sql/sqlengine.cpp (modified) (6 diffs)

src/sql/sqlengine.cpp

@@ -233 +233 @@
         query.exec("CREATE TABLE CONFERENCE ( \
             id INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL , \
-            title VARCHAR NOT NULL , \
+            title VARCHAR UNIQUE NOT NULL , \
             subtitle VARCHAR, \
             venue VARCHAR, \
@@ -249 +249 @@
         query.exec("CREATE TABLE ROOM ( \
             id INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL , \
-            name VARCHAR NOT NULL , \
+            name VARCHAR UNIQUE NOT NULL , \
             picture VARCHAR NOT NULL)");
 
         query.exec("CREATE TABLE PERSON ( \
             id INTEGER PRIMARY KEY  NOT NULL , \
-            name VARCHAR NOT NULL)");
+            name VARCHAR UNIQUE NOT NULL)");
 
         query.exec("CREATE TABLE EVENT ( \
@@ -278 +278 @@
             xid_event INTEGER NOT NULL , \
             xid_person INTEGER NOT NULL, \
-            FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id), \
+            FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id), \
+            FOREIGN KEY(xid_event) REFERENCES EVENT(id), \
             FOREIGN KEY(xid_person) REFERENCES PERSON(id))");
 
@@ -285 +286 @@
             xid_event INTEGER NOT NULL , \
             xid_room INTEGER NOT NULL, \
-            FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id), \
+            FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id), \
+            FOREIGN KEY(xid_event) REFERENCES EVENT(id), \
             FOREIGN KEY(xid_room) REFERENCES ROOM(id))");
 
@@ -294 +296 @@
             name VARCHAR, \
             url VARCHAR NOT NULL, \
-            FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id))");
+            FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id), \
+            FOREIGN KEY(xid_event) REFERENCES EVENT(id)");
     }
     else
@@ -315 +318 @@
     execQuery( db, "DROP TABLE IF EXISTS SEARCH_EVENT;");
     // CREATE
-    execQuery( db, "CREATE TABLE SEARCH_EVENT ( xid_conference INTEGER  NOT NULL, id INTEGER NOT NULL );");
+    execQuery( db, "CREATE TEMP TABLE SEARCH_EVENT ( xid_conference INTEGER  NOT NULL, id INTEGER NOT NULL );");
     // INSERT
     QString query = QString("INSERT INTO SEARCH_EVENT ( xid_conference, id) "