Changeset a0b8978


Ignore:
Timestamp:
04/15/10 13:47:53 (12 years ago)
Author:
kirilma <kirilma@…>
Branches:
master, qt5
Children:
be9b645
Parents:
bf3bbb9
Message:

fix references in SQL

File:
1 edited

Legend:

Unmodified
Added
Removed
  • src/fosdem.sql

    rbf3bbb9 ra0b8978  
    12901290    , UNIQUE ( xid_conference , xid_event , xid_person ) ON CONFLICT REPLACE
    12911291    , FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id)
    1292     , FOREIGN KEY(xid_event) REFERENCES EVENT(id)
     1292    , FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id)
    12931293    , FOREIGN KEY(xid_person) REFERENCES PERSON(id));
    12941294INSERT INTO "EVENT_PERSON" VALUES(1,819,46);
     
    16221622    , UNIQUE ( xid_conference , xid_event , xid_room ) ON CONFLICT REPLACE
    16231623    , FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id)
    1624     , FOREIGN KEY(xid_event) REFERENCES EVENT(id)
     1624    , FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id)
    16251625    , FOREIGN KEY(xid_room) REFERENCES ROOM(id));
    16261626INSERT INTO "EVENT_ROOM" VALUES(1,819,1);
     
    19311931    , UNIQUE ( xid_conference , xid_event , url ) ON CONFLICT REPLACE
    19321932    , FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id)
    1933     , FOREIGN KEY(xid_event) REFERENCES EVENT(id));
     1933    , FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id));
    19341934INSERT INTO "LINK" VALUES(1421,1,809,'Homepage','http://sourceware.org/systemtap/');
    19351935INSERT INTO "LINK" VALUES(1422,1,808,'Flapjack','http://flapjack-project.com/');
Note: See TracChangeset for help on using the changeset viewer.