Changeset c118afd89ea838de9f57061b0403228faf8a9193

Timestamp:

03/17/07 15:46:39 (1 year ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[5b632cf6660131a1699ecfc565e3f96aaa298a30]

git-author:

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

Message:

FK-Constraint fuer versteigerungen.bieter eingebaut

Files:

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

db/tables/versteigerungen.sql

@@ -9 +9 @@
-  PRIMARY KEY  (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
+
+ALTER TABLE versteigerungen ADD CONSTRAINT versteigerungen_fk_users FOREIGN KEY (bieter) REFERENCES users(id);

db/updates.xml

@@ -210 +210 @@
-                ALTER TABLE user_values ADD CONSTRAINT user_values_fk_users FOREIGN KEY (`user_id`) REFERENCES users(id);
-                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);
-        ]]></update>
-</updates>