Navigation

Changeset 59f888b22dd5f4173222dfb1d40720aae122d1b2

Timestamp:

03/17/07 14:16:44 (2 years ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[ea0fd609352fc15a07097b02cc805935a9a18c1c]

git-author:

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

Message:

FK-Contraint factions_shop_orders.user_id eingebaut

Files:

rea0fd60	r59f888b
14	14
15	15	ALTER TABLE factions_shop_orders ADD CONSTRAINT factions_shop_orders_fk_factions_shop_entries FOREIGN KEY (shopentry_id) REFERENCES factions_shop_entries(id);
	16	ALTER TABLE factions_shop_orders ADD CONSTRAINT factions_shop_orders_fk_users FOREIGN KEY (user_id) REFERENCES users(id);

rea0fd60	r59f888b
170	170	ALTER TABLE battles ADD CONSTRAINT battles_fk_users2 FOREIGN KEY (commander2) REFERENCES users(id);
171	171	ALTER TABLE factions_shop_orders ADD CONSTRAINT factions_shop_orders_fk_factions_shop_entries FOREIGN KEY (shopentry_id) REFERENCES factions_shop_entries(id);
	172	ALTER TABLE factions_shop_orders ADD CONSTRAINT factions_shop_orders_fk_users FOREIGN KEY (user_id) REFERENCES users(id);
172	173	]]></update>
173	174	</updates>

r2a7339d	r59f888b
245	245	echo.append("Lösche PM-Ordner...<br />\n");
246	246	db.update("DELETE FROM ordner WHERE playerid="+userid);
	247
	248	echo.append("Lösche Shop-Auftraege...<br />\n");
	249	db.update("DELETE FROM factions_shop_orders WHERE user_id="+userid);
247	250
248	251	db.tCommit();