Changeset 9cd5406df221063147bf5f431b095d649da0f721

Timestamp:

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

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[0dde3284defcb54d9a1e1cdba693040f9cfe061f]

git-author:

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

Message:

FK-Constraints fuer skn_visits eingebaut

Files:

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

db/tables/skn_visits.sql

@@ -7 +7 @@
-  KEY `user` (`user`, `channel`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Com-Net visits'; 
+
+ALTER TABLE skn_visits ADD CONSTRAINT skn_visits_fk_users FOREIGN KEY (user) REFERENCES users(id);
+ALTER TABLE skn_visits ADD CONSTRAINT skn_visits_fk_skn_channels FOREIGN KEY (channel) REFERENCES skn_channels(id);

db/updates.xml

@@ -191 +191 @@
-                ALTER TABLE ship_loot ADD CONSTRAINT ship_loot_fk_users1 FOREIGN KEY (owner) REFERENCES users(id);
-                ALTER TABLE ship_loot ADD CONSTRAINT ship_loot_fk_users2 FOREIGN KEY (targetuser) REFERENCES users(id);
+                ALTER TABLE skn_visits ADD CONSTRAINT skn_visits_fk_users FOREIGN KEY (user) REFERENCES users(id);
+                ALTER TABLE skn_visits ADD CONSTRAINT skn_visits_fk_skn_channels FOREIGN KEY (channel) REFERENCES skn_channels(id);
-        ]]></update>
-</updates>