Changeset 5b632cf6660131a1699ecfc565e3f96aaa298a30

Timestamp:

03/17/07 15:45:58 (2 years ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[dc5a1a307c15713fb396963fee21cb0c197cb698]

git-author:

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

Message:

FK-Constraint fuer versteigerungen_pakete.bieter eingebaut

Files:

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

db/tables/versteigerungen_pakete.sql

@@ -9 +9 @@
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='gtu - pakete';
- 
+ALTER TABLE versteigerungen_pakete ADD CONSTRAINT versteigerungen_pakete_fk_users FOREIGN KEY (bieter) REFERENCES users(id);

db/updates.xml

@@ -209 +209 @@
-                ALTER TABLE user_relations ADD CONSTRAINT user_relations_fk_users2 FOREIGN KEY (`target_id`) REFERENCES users(id);
-                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);
-        ]]></update>
-</updates>