Changeset 7270ae0 for src/sql


Ignore:
Timestamp:
02/05/10 22:31:36 (12 years ago)
Author:
timkoma <timkoma@…>
Branches:
master, qt5
Children:
5d9409d
Parents:
ba3fc20
Message:

fix for import - ON CONFLICT REPLACE

File:
1 edited

Legend:

Unmodified
Added
Removed
  • src/sql/sqlengine.cpp

    rba3fc20 r7270ae0  
    294294            "favourite INTEGER DEFAULT 0, "
    295295            "alarm INTEGER DEFAULT 0, "
    296             "PRIMARY KEY (xid_conference,id), "
     296            "PRIMARY KEY (xid_conference,id) ON CONFLICT REPLACE, "
    297297            "FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id), "
    298298            "FOREIGN KEY(xid_track) REFERENCES TRACK(id));");
     
    302302            "xid_event INTEGER NOT NULL, "
    303303            "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, "
    305305            "FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id), "
    306306            "FOREIGN KEY(xid_event) REFERENCES EVENT(id), "
     
    311311            "xid_event INTEGER NOT NULL, "
    312312            "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, "
    314314            "FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id), "
    315315            "FOREIGN KEY(xid_event) REFERENCES EVENT(id), "
     
    322322            "name VARCHAR, "
    323323            "url VARCHAR NOT NULL, "
    324             "UNIQUE ( xid_conference, xid_event, url ) ON CONFLICT IGNORE, "
     324            "UNIQUE ( xid_conference, xid_event, url ) ON CONFLICT REPLACE, "
    325325            "FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id), "
    326326            "FOREIGN KEY(xid_event) REFERENCES EVENT(id));");
Note: See TracChangeset for help on using the changeset viewer.