Changeset 531dfa9ceec735e06c58c592a55c64c22be0a356

Timestamp:

03/17/07 14:09:36 (2 years ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[9fb8056ff864da28c09ae3d4f345a43c0a6ec6ed]

git-author:

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

Message:

FK-Constraints fuer commander(1,2) eingebaut

Files:

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

db/tables/battles.sql

@@ -6 +6 @@
-  `ally1` smallint(6) NOT NULL default '0',
-  `ally2` smallint(6) NOT NULL default '0',
-smallint(6
+int(11
-  `com1Points` smallint(6) NOT NULL default '0',
-smallint(6
+int(11
-  `com2Points` smallint(6) NOT NULL default '0',
-  `ready1` tinyint(1) unsigned NOT NULL default '0',
@@ -29 +29 @@
-  KEY `coords` (`x`,`y`,`system`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Aktuelle Schlachten'; 
+
+ALTER TABLE battles ADD CONSTRAINT battles_fk_users1 FOREIGN KEY (commander1) REFERENCES users(id);
+ALTER TABLE battles ADD CONSTRAINT battles_fk_users2 FOREIGN KEY (commander2) REFERENCES users(id);

db/updates.xml

@@ -165 +165 @@
-                ALTER TABLE battles_ships CHANGE shipid shipid INT NOT NULL DEFAULT '0';
-                ALTER TABLE battles_ships ADD CONSTRAINT battles_ships_fk_ships FOREIGN KEY (shipid) REFERENCES ships(id);
+                ALTER TABLE battles CHANGE commander1 commander1 INT NOT NULL DEFAULT '0';
+                ALTER TABLE battles CHANGE commander2 commander2 INT NOT NULL DEFAULT '0';
+                ALTER TABLE battles ADD CONSTRAINT battles_fk_users1 FOREIGN KEY (commander1) REFERENCES users(id);
+                ALTER TABLE battles ADD CONSTRAINT battles_fk_users2 FOREIGN KEY (commander2) REFERENCES users(id);
-        ]]></update>
-</updates>