Changeset 412cef6 for src/sql/sqlengine.cpp

Timestamp:

01/28/10 13:43:19 (12 years ago)

Author:

pavelpa <pavelpa@…>

Branches:

master, qt5

Children:

8cb5c4f

Parents:

438699c

Message:

some 'delegate' drawing optimizations

• removed EVENT_CONFLICT table - used one SQL SELECT instead

File:

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

src/sql/sqlengine.cpp

@@ -152 +152 @@
     }
 }
-
 
 void SqlEngine::addPersonToDB(QHash<QString,QString> &aPerson)
@@ -290 +289 @@
             "FOREIGN KEY(xid_room) REFERENCES ROOM(id));");
 
-        query.exec("CREATE TABLE EVENT_CONFLICT ( "
-            "xid_conference INTEGER NOT NULL, "
-            "xid_event INTEGER NOT NULL, "
-            "conflict_event INTEGER NOT NULL, "
-            "UNIQUE ( xid_conference, xid_event, conflict_event ) ON CONFLICT IGNORE, "
-            "FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id), "
-            "FOREIGN KEY(xid_event) REFERENCES EVENT(id));");
-
         query.exec("CREATE TABLE LINK ( "
             "id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "