summaryrefslogtreecommitdiffstats
path: root/config/SQL/users.sql
blob: 7e784f98150326ce30f3ec96b05926c4bb63fd14 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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');