Changeset ffdcdec6f05858332a4e1ab7559169f4109bfe1a

Timestamp:

03/17/07 15:38:31 (1 year ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[45b342c3a66ff0fde23d5d3aabbd9ca8b2cc2b51]

git-author:

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

Message:

FK-Constraint fuer user_f.id eingebaut

Files:

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

db/tables/user_f.sql

@@ -104 +104 @@
-) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
-
+ALTER TABLE user_f ADD CONSTRAINT user_f_fk_users FOREIGN KEY (id) REFERENCES users(id);
+
-INSERT INTO `user_f` (`id`, `r0`, `r1`, `r2`, `r3`, `r4`, `r5`, `r6`, `r7`, `r8`, `r9`, `r10`, `r11`, `r12`, `r13`, `r14`, `r15`, `r16`, `r17`, `r18`, `r19`, `r20`, `r21`, `r22`, `r23`, `r24`, `r25`, `r26`, `r27`, `r28`, `r29`, `r30`, `r31`, `r32`, `r33`, `r34`, `r35`, `r36`, `r37`, `r38`, `r39`, `r40`, `r41`, `r42`, `r43`, `r44`, `r45`, `r46`, `r47`, `r48`, `r49`, `r50`, `r51`, `r52`, `r53`, `r54`, `r55`, `r56`, `r57`, `r58`, `r59`, `r60`, `r61`, `r62`, `r63`, `r64`, `r65`, `r66`, `r67`, `r68`, `r69`, `r70`, `r71`, `r72`, `r73`, `r74`, `r75`, `r76`, `r77`, `r78`, `r79`, `r80`, `r81`, `r82`, `r83`, `r84`, `r85`, `r86`, `r87`, `r88`, `r89`, `r90`, `r91`, `r92`, `r93`, `r94`, `r95`, `r96`, `r97`, `r98`, `r99`) VALUES (-26, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 1, 1, 1, 0, 1, 0, 1, 1, 0, 1, 0, 1, 0, 0, 0, 1, 0, 1, 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
-INSERT INTO `user_f` (`id`, `r0`, `r1`, `r2`, `r3`, `r4`, `r5`, `r6`, `r7`, `r8`, `r9`, `r10`, `r11`, `r12`, `r13`, `r14`, `r15`, `r16`, `r17`, `r18`, `r19`, `r20`, `r21`, `r22`, `r23`, `r24`, `r25`, `r26`, `r27`, `r28`, `r29`, `r30`, `r31`, `r32`, `r33`, `r34`, `r35`, `r36`, `r37`, `r38`, `r39`, `r40`, `r41`, `r42`, `r43`, `r44`, `r45`, `r46`, `r47`, `r48`, `r49`, `r50`, `r51`, `r52`, `r53`, `r54`, `r55`, `r56`, `r57`, `r58`, `r59`, `r60`, `r61`, `r62`, `r63`, `r64`, `r65`, `r66`, `r67`, `r68`, `r69`, `r70`, `r71`, `r72`, `r73`, `r74`, `r75`, `r76`, `r77`, `r78`, `r79`, `r80`, `r81`, `r82`, `r83`, `r84`, `r85`, `r86`, `r87`, `r88`, `r89`, `r90`, `r91`, `r92`, `r93`, `r94`, `r95`, `r96`, `r97`, `r98`, `r99`) VALUES (-19, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 0, 0, 0, 1, 0, 0, 1, 1, 1, 0, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

db/updates.xml

@@ -203 +203 @@
-                ALTER TABLE transmissionen ADD CONSTRAINT transmissionen_fk_users1 FOREIGN KEY (sender) REFERENCES users(id);
-                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);
-        ]]></update>
-</updates>