}
}
-
void SqlEngine::addPersonToDB(QHash<QString,QString> &aPerson)
{
QSqlDatabase db = QSqlDatabase::database();
"FOREIGN KEY(xid_event) REFERENCES EVENT(id), "
"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, "
"xid_conference INTEGER NOT NULL, "