Changeset 8a27e17991ff14e210aaae0caadb6b411ae65727

Timestamp:

03/17/07 15:41:41 (2 years ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[ffdcdec6f05858332a4e1ab7559169f4109bfe1a]

git-author:

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

Message:

FK-Constraints fuer user_moneytransfer eingebaut

Files:

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

db/tables/user_moneytransfer.sql

@@ -11 +11 @@
-  KEY `from` (`from`,`to`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='RE-Ueberweisungen'; 
+
+ALTER TABLE user_moneytransfer ADD CONSTRAINT user_moneytransfer_fk_users1 FOREIGN KEY (`from`) REFERENCES users(id);
+ALTER TABLE user_moneytransfer ADD CONSTRAINT user_moneytransfer_fk_users2 FOREIGN KEY (`to`) REFERENCES users(id);

db/updates.xml

@@ -204 +204 @@
-                ALTER TABLE transmissionen ADD CONSTRAINT transmissionen_fk_users2 FOREIGN KEY (empfaenger) REFERENCES users(id);
-                ALTER TABLE user_f ADD CONSTRAINT user_f_fk_users FOREIGN KEY (id) REFERENCES users(id);
+                ALTER TABLE user_moneytransfer ADD CONSTRAINT user_moneytransfer_fk_users1 FOREIGN KEY (`from`) REFERENCES users(id);
+                ALTER TABLE user_moneytransfer ADD CONSTRAINT user_moneytransfer_fk_users2 FOREIGN KEY (`to`) REFERENCES users(id);
-        ]]></update>
-</updates>