- Timestamp:
- 02/05/10 22:31:36 (13 years ago)
- Branches:
- master, qt5
- Children:
- 5d9409d
- Parents:
- ba3fc20
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
src/sql/sqlengine.cpp
rba3fc20 r7270ae0 294 294 "favourite INTEGER DEFAULT 0, " 295 295 "alarm INTEGER DEFAULT 0, " 296 "PRIMARY KEY (xid_conference,id) , "296 "PRIMARY KEY (xid_conference,id) ON CONFLICT REPLACE, " 297 297 "FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id), " 298 298 "FOREIGN KEY(xid_track) REFERENCES TRACK(id));"); … … 302 302 "xid_event INTEGER NOT NULL, " 303 303 "xid_person INTEGER NOT NULL, " 304 "UNIQUE ( xid_conference, xid_event, xid_person ) ON CONFLICT IGNORE, "304 "UNIQUE ( xid_conference, xid_event, xid_person ) ON CONFLICT REPLACE, " 305 305 "FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id), " 306 306 "FOREIGN KEY(xid_event) REFERENCES EVENT(id), " … … 311 311 "xid_event INTEGER NOT NULL, " 312 312 "xid_room INTEGER NOT NULL, " 313 "UNIQUE ( xid_conference, xid_event, xid_room ) ON CONFLICT IGNORE, "313 "UNIQUE ( xid_conference, xid_event, xid_room ) ON CONFLICT REPLACE, " 314 314 "FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id), " 315 315 "FOREIGN KEY(xid_event) REFERENCES EVENT(id), " … … 322 322 "name VARCHAR, " 323 323 "url VARCHAR NOT NULL, " 324 "UNIQUE ( xid_conference, xid_event, url ) ON CONFLICT IGNORE, "324 "UNIQUE ( xid_conference, xid_event, url ) ON CONFLICT REPLACE, " 325 325 "FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id), " 326 326 "FOREIGN KEY(xid_event) REFERENCES EVENT(id));");
Note: See TracChangeset
for help on using the changeset viewer.