Changeset 0fca7a454394bfea4056f0bf509b22aadf2a608d

Timestamp:

03/17/07 15:07:02 (1 year ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[d912d44645998a2066916946fa396cce03bc69ee]

git-author:

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

Message:

FK-Constraints fuer quests_completed eingebaut

Files:

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

db/tables/quests_completed.sql

@@ -2 +2 @@
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `questid` mediumint(8) unsigned NOT NULL default '0',
-mediumint(8
+int(11
-  PRIMARY KEY  (`id`),
-  KEY `questid` (`questid`,`userid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Beendete Quests'; 
+
+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);

db/updates.xml

@@ -183 +183 @@
-                ALTER TABLE orders_ships ADD CONSTRAINT orders_ships_fk_ship_types FOREIGN KEY (type) REFERENCES ship_types(id);
-                ALTER TABLE ordner ADD CONSTRAINT ordner_fk_users FOREIGN KEY (playerid) REFERENCES users(id);
+                ALTER TABLE quests_completed CHANGE userid userid INT NOT NULL DEFAULT '0';
+                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);
-        ]]></update>
-</updates>