Changeset 9f367eb for src/sql


Ignore:
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:
1 edited

Legend:

Unmodified
Added
Removed
  • src/sql/sqlengine.cpp

    r336fa33 r9f367eb  
    292292            "FOREIGN KEY(xid_room) REFERENCES ROOM(id));");
    293293
     294        query.exec("CREATE TABLE EVENT_CONFLICT ( "
     295            "xid_conference INTEGER NOT NULL, "
     296            "xid_event INTEGER NOT NULL, "
     297            "conflict_event INTEGER NOT NULL, "
     298            "UNIQUE ( xid_conference, xid_event, conflict_event ) ON CONFLICT IGNORE, "
     299            "FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id), "
     300            "FOREIGN KEY(xid_event) REFERENCES EVENT(id));");
     301
    294302        query.exec("CREATE TABLE LINK ( "
    295303            "id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "
     
    363371    }
    364372}
     373
Note: See TracChangeset for help on using the changeset viewer.