diff options
author | neoraider <devnull@localhost> | 2006-12-10 19:00:04 +0100 |
---|---|---|
committer | neoraider <devnull@localhost> | 2006-12-10 19:00:04 +0100 |
commit | 93e1133ee88b03e7cae7318cb19761e698e57b86 (patch) | |
tree | 825b0ca10c5b32f3ad03430ec8b427f99d3dc855 /config/SQL/users.sql | |
parent | 7be63518bdb86fb747dda20918ef6eab3d30e40c (diff) | |
download | neon-93e1133ee88b03e7cae7318cb19761e698e57b86.tar neon-93e1133ee88b03e7cae7318cb19761e698e57b86.zip |
SQL-Daten tabellenweise aufgeteilt;
config-Daten jetzt mit urlencode kodiert.
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'); |