Navigation

Changeset ade629dcb7905221b363d55bd44a2d174b6feac2

Timestamp:

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

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[9cd5406df221063147bf5f431b095d649da0f721]

git-author:

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

Message:

FK-Constraints fuer skn eingebaut

Files:

r0e4736f	rade629d
13	13	KEY `channel` (`channel`)
14	14	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	15
	16	ALTER TABLE skn ADD CONSTRAINT skn_fk_skn_channels FOREIGN KEY (channel) REFERENCES skn_channels(id);
	17	ALTER TABLE skn ADD CONSTRAINT skn_fk_users FOREIGN KEY (userid) REFERENCES users(id);

r9cd5406	rade629d
193	193	ALTER TABLE skn_visits ADD CONSTRAINT skn_visits_fk_users FOREIGN KEY (user) REFERENCES users(id);
194	194	ALTER TABLE skn_visits ADD CONSTRAINT skn_visits_fk_skn_channels FOREIGN KEY (channel) REFERENCES skn_channels(id);
	195	ALTER TABLE skn ADD CONSTRAINT skn_fk_skn_channels FOREIGN KEY (channel) REFERENCES skn_channels(id);
	196	ALTER TABLE skn ADD CONSTRAINT skn_fk_users FOREIGN KEY (userid) REFERENCES users(id);
195	197	]]></update>
196	198	</updates>

rb139234	rade629d
157	157	echo.append("Entferne comnet-visits...<br />\n");
158	158	db.update("DELETE FROM skn_visits WHERE user="+userid);
	159
	160	echo.append("Ordne Comnet-Posts ID 0 zu...<br />\n");
	161	db.update("UPDATE skn SET userid=0 WHERE userid="+userid);
159	162
160	163	echo.append("Entferne user-forschungen...<br />\n");