diff options
Diffstat (limited to 'config/SQL/users.sql')
-rw-r--r-- | config/SQL/users.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/config/SQL/users.sql b/config/SQL/users.sql new file mode 100644 index 0000000..7e784f9 --- /dev/null +++ b/config/SQL/users.sql @@ -0,0 +1,22 @@ +-- +-- Tabellenstruktur für Tabelle `users` +-- + +CREATE TABLE `users` ( + `id` bigint(20) NOT NULL auto_increment, + `sid` varchar(32) NOT NULL default '', + `gid` smallint(6) NOT NULL default '0', + `user` varchar(32) NOT NULL default '', + `password` varchar(32) NOT NULL default '', + `lastaccess` timestamp NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `user` (`user`) +) TYPE=MyISAM AUTO_INCREMENT=6 ; + +-- +-- Daten für Tabelle `users` +-- + +INSERT INTO `users` (`id`, `sid`, `gid`, `user`, `password`, `lastaccess`) VALUES (1, '', -1, 'NeoRaider', 'gamezock', '2006-12-09 02:15:08'); +INSERT INTO `users` (`id`, `sid`, `gid`, `user`, `password`, `lastaccess`) VALUES (3, '', -1, 'sicarius', 'armleuchter', '2006-12-02 22:46:58'); +INSERT INTO `users` (`id`, `sid`, `gid`, `user`, `password`, `lastaccess`) VALUES (4, '', -1, 'morti', 'return', '2006-12-02 22:46:58'); |