Changeset a0b8978

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:

• src/fosdem.sql (modified) (3 diffs)

src/fosdem.sql

@@ -1290 +1290 @@
     , UNIQUE ( xid_conference , xid_event , xid_person ) ON CONFLICT REPLACE
     , FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id)
-    , FOREIGN KEY(xid_event) REFERENCES EVENT(id)
+    , FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id)
     , FOREIGN KEY(xid_person) REFERENCES PERSON(id));
 INSERT INTO "EVENT_PERSON" VALUES(1,819,46);
@@ -1622 +1622 @@
     , UNIQUE ( xid_conference , xid_event , xid_room ) ON CONFLICT REPLACE
     , FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id)
-    , FOREIGN KEY(xid_event) REFERENCES EVENT(id)
+    , FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id)
     , FOREIGN KEY(xid_room) REFERENCES ROOM(id));
 INSERT INTO "EVENT_ROOM" VALUES(1,819,1);
@@ -1931 +1931 @@
     , UNIQUE ( xid_conference , xid_event , url ) ON CONFLICT REPLACE
     , FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id)
-    , FOREIGN KEY(xid_event) REFERENCES EVENT(id));
+    , FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id));
 INSERT INTO "LINK" VALUES(1421,1,809,'Homepage','http://sourceware.org/systemtap/');
 INSERT INTO "LINK" VALUES(1422,1,808,'Flapjack','http://flapjack-project.com/');