Changeset 5fac4d5dc42212c785d7ed7f9b66e5e5a3df0cd2

Timestamp:

03/17/07 15:49:16 (1 year ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[c118afd89ea838de9f57061b0403228faf8a9193]

git-author:

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

Message:

FK-Constraint fuer weaponfactory.col eingebaut

Files:

• db/tables/weaponfactory.sql (modified) (2 diffs)
• db/updates.xml (modified) (1 diff)

db/tables/weaponfactory.sql

@@ -1 +1 @@
-CREATE TABLE `weaponfactory` (
-  `id` mediumint(8) unsigned NOT NULL auto_increment,
-0) unsigned
+1)
-  `count` tinyint(3) unsigned NOT NULL default '0',
-  `produces` text NOT NULL,
@@ -7 +7 @@
-  KEY `col` (`col`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Die Waffenfabriken'; 
+
+ALTER TABLE weaponfactory ADD CONSTRAINT weaponfactory_fk_bases FOREIGN KEY (col) REFERENCES bases(id);

db/updates.xml

@@ -211 +211 @@
-                ALTER TABLE versteigerungen_pakete ADD CONSTRAINT versteigerungen_pakete_fk_users FOREIGN KEY (bieter) REFERENCES users(id);
-                ALTER TABLE versteigerungen ADD CONSTRAINT versteigerungen_fk_users FOREIGN KEY (bieter) REFERENCES users(id);
+                ALTER TABLE weaponfactory CHANGE col col INT NOT NULL DEFAULT '0';
+                ALTER TABLE weaponfactory ADD CONSTRAINT weaponfactory_fk_bases FOREIGN KEY (col) REFERENCES bases(id);
-        ]]></update>
-</updates>