Changeset 7e99ff16927867fcc50b042c253efe055f4fa955

Timestamp:

03/17/07 15:08:36 (1 year ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

Christopher Jung <bktheg@web.de> 1174140516 +0100

git-parent:

[0fca7a454394bfea4056f0bf509b22aadf2a608d]

git-author:

Christopher Jung <bktheg@web.de> 1174140516 +0100

Message:

FK-Constraints fuer quests_running eingebaut

Files:

• db/tables/quests_running.sql (modified) (1 diff)
• db/updates.xml (modified) (1 diff)

db/tables/quests_running.sql

@@ -11 +11 @@
-  KEY `questid` (`questid`,`userid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Die laufenden Quests'; 
+
+ALTER TABLE quests_running ADD CONSTRAINT quests_running_fk_users FOREIGN KEY (userid) REFERENCES users(id);
+ALTER TABLE quests_running ADD CONSTRAINT quests_running_fk_quests FOREIGN KEY (questid) REFERENCES quests(id);

db/updates.xml

@@ -186 +186 @@
-                ALTER TABLE quests_completed ADD CONSTRAINT quests_completed_fk_users FOREIGN KEY (userid) REFERENCES users(id);
-                ALTER TABLE quests_completed ADD CONSTRAINT quests_completed_fk_quests FOREIGN KEY (questid) REFERENCES quests(id);
+                ALTER TABLE quests_running ADD CONSTRAINT quests_running_fk_users FOREIGN KEY (userid) REFERENCES users(id);
+                ALTER TABLE quests_running ADD CONSTRAINT quests_running_fk_quests FOREIGN KEY (questid) REFERENCES quests(id);
-        ]]></update>
-</updates>