Changeset dc5a1a307c15713fb396963fee21cb0c197cb698

Timestamp:

03/17/07 15:44:19 (2 years ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[374bc132d70b500bf0593f579511045525d756ec]

git-author:

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

Message:

FK-Constraint fuer user_values.user_id eingebaut

Files:

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

db/tables/user_values.sql

@@ -7 +7 @@
-  KEY `id` (`user_id`,`name`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
+
+ALTER TABLE user_values ADD CONSTRAINT user_values_fk_users FOREIGN KEY (`user_id`) REFERENCES users(id);
-
-INSERT INTO `user_values` (`id`, `user_id`, `name`, `value`) VALUES (607, 0, 'GAMEPLAY/bases/maxtiles', '500');

db/updates.xml

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