Changeset 9f367eb for src/sql

Timestamp:

01/27/10 07:41:47 (12 years ago)

Author:

pavelpa <pavelpa@…>

Branches:

master, qt5

Children:

001c8cf

Parents:

336fa33

Message:

'conflicts' modifications

• preparing for the dialog showing also list of events in the conflict
• created 'EVENT_CONFLICT' for flaging events in conflict state
• TODO: not finished

File:

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

src/sql/sqlengine.cpp

@@ -292 +292 @@
             "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, "
@@ -363 +371 @@
     }
 }
+