Navigation

Changeset 0041fabfb63f5477f54e09b761a298668c9fd108

Timestamp:

02/03/08 16:15:50 (7 months ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[4f9d99ff91a7f80ff17940b1e62171f3cb4a680a]

git-author:

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

Message:

Datenbankdefinition gefixt

Files:

r3924571	r0041fab
42	42	ALTER TABLE users ADD CONSTRAINT users_fk_ally FOREIGN KEY (ally) REFERENCES ally(id);
43	43	ALTER TABLE users ADD CONSTRAINT users_fk_ships FOREIGN KEY (flagschiff) REFERENCES ships(id);
	44	ALTER TABLE users ADD CONSTRAINT users_fk_ally_posten FOREIGN KEY (allyposten) REFERENCES ally_posten(id);
44	45
45	46	INSERT INTO `users` (`id`, `un`, `name`, `passwort`, `race`, `inakt`, `signup`, `history`, `medals`, `rang`, `ally`, `konto`, `cargo`, `nstat`, `email`, `log_fail`, `accesslevel`, `npcpunkte`, `nickname`, `plainname`, `allyposten`, `gtudropzone`, `npcorderloc`, `imgpath`, `flagschiff`, `disabled`, `flags`, `vaccount`, `wait4vac`, `lostBattles`, `wonBattles`, `destroyedShips`, `lostShips`, `knownItems`) VALUES (-26, 'niemandundnochnichtniemand', 'Ito Kitami - sales agent', '98f6bcd4621d373cade4e832627b4f6', 2, 44, 0, 'Dabei seit dem 25. Tick in DS1', '', 0, NULL, 308442632, '100000000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '1000', 'ito@localhost', 4, 0, 10, 'Ito Kitami - sales agent', 'Ito Kitami - sales agent', null, 2, '', 'http://ds.drifting-souls.net/', null, 0, ' NO_IP_SESS NO_AUTOLOGOUT execnotes superdock miljumps', 0, 0, 0, 2, 2, 0, '');