Changeset 60cbaf0f84249b945db95d93c7d1821afd330da7

Timestamp:

03/17/07 14:48:41 (1 year ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[9c3918a503ac0e821f5745c6e2d66e28ba9e5773]

git-author:

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

Message:

FK-Constraint orders_ships.type eingebaut

Files:

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

db/tables/orders_ships.sql

@@ -5 +5 @@
-) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
-
+ALTER TABLE orders_ships ADD CONSTRAINT orders_ships_fk_ship_types FOREIGN KEY (type) REFERENCES ship_types(id);
+
-INSERT INTO `orders_ships` (`type`, `cost`) VALUES (1, 8);
-INSERT INTO `orders_ships` (`type`, `cost`) VALUES (2, 1);

db/updates.xml

@@ -181 +181 @@
-                ALTER TABLE offiziere CHANGE userid userid INT NOT NULL DEFAULT '0';
-                ALTER TABLE offiziere ADD CONSTRAINT offiziere_fk_users FOREIGN KEY (userid) REFERENCES users(id);
+                ALTER TABLE orders_ships ADD CONSTRAINT orders_ships_fk_ship_types FOREIGN KEY (type) REFERENCES ship_types(id);
-        ]]></update>
-</updates>