
CREATE SEQUENCE wbuser_seq START 1;

CREATE TABLE wbuser (
    uid INTEGER PRIMARY KEY DEFAULT nextval('wbuser_seq')
     , nickname VARCHAR(255) NOT NULL
     , password CHAR(32)
     , emaillocal VARCHAR(200) NOT NULL
     , emaildomain VARCHAR(125) NOT NULL
     , approved SMALLINT NOT NULL DEFAULT 0
     , enabled SMALLINT NOT NULL DEFAULT 0
     , deleted SMALLINT NOT NULL DEFAULT 0
     , forename VARCHAR(255) NOT NULL DEFAULT ''
     , surname VARCHAR(255) NOT NULL DEFAULT ''
     , lang CHAR(5) NOT NULL DEFAULT 'C'
     , country CHAR(2) NOT NULL DEFAULT 'C'
     , created TIMESTAMP NOT NULL DEFAULT '1970-01-01 00:00:00'
     , changed TIMESTAMP NOT NULL DEFAULT '1970-01-01 00:00:00'
     , lastlogin TIMESTAMP NOT NULL DEFAULT '1970-01-01 00:00:00'
);

CREATE INDEX nickname_idx ON wbuser (nickname);
CREATE INDEX email_idx ON wbuser (emaillocal, emaildomain);


INSERT INTO wbuser VALUES (1,'gerd','00ee340c1c4dbcb35a41435dac13046d','gerd','php-tools.net',1,1,0,'gERD','Schaufelberger','C','C','2009-01-16 19:58:42','2011-10-06 22:17:11','2011-10-06 22:17:11'),(2,'asa','8538698978e61ebd7feebad7a344a8ac','axel','example.com',1,0,0,'Axel','Sauerhöfer','C','C','2009-01-16 19:58:42','2009-01-16 19:58:42','1970-01-01 00:00:00'),(3,'joedoe','8554162b97f9303d99b47c6c68c67b6b','joedoe','example.com',1,0,0,'Joe','Doe','C','C','2009-01-16 19:58:42','2009-01-16 19:58:42','1970-01-01 00:00:00'),(4,'mandy','87304e57c0d759083bda65a46fc0db4b','mandymueller','example.com',1,0,0,'Mandy','Müller','C','C','2009-01-16 19:58:42','2010-04-06 19:40:40','2010-04-06 19:40:40'),(5,'ronny','fb52263b732763cc4a9cd14be6a74f08','ronnyschmidt','example.com',1,0,0,'Ronny','Schmidt','C','C','2009-01-16 19:58:42','2009-01-16 19:58:42','1970-01-01 00:00:00'),(6,'fred','c139b14fec2b662b67d869eac517d1ad','firstfreddy','gmail.com',1,1,0,'Fred','Blüthner','C','C','2010-04-09 09:51:22','2010-04-20 14:23:29','2010-04-20 14:23:29'),(7,'jochen','765ad6488d1a2ed2ed2ce82e82a36a54','jochen','lena.sub.org',1,1,0,'duran','jochen','C','C','2010-09-06 16:33:02','2010-09-06 16:33:02','1970-01-01 00:00:00'),(8,'steff','1f5adffd2da34c143bc9c8c6b4889eaf','steffi.hirth','googlemail.com',1,0,0,'Stefanie','Hirth','C','C','2010-09-06 17:35:24','2010-09-06 17:35:24','1970-01-01 00:00:00'),(9,'heiko','e5768bee0df42c2d581ce88f71b56653','heiko','ist.eigentlich.net',1,0,0,'Heiko','Hund','C','C','2010-09-06 17:35:24','2010-09-06 17:35:24','1970-01-01 00:00:00'),(10,'serap','d4147270d96ecefef9118f69384d7e18','serapyazici','gmx.de',1,0,0,'Serap','Yazici','C','C','2010-09-06 17:35:24','2010-09-06 17:35:24','1970-01-01 00:00:00'),(11,'chris','2c71d113b8dd3d9c9d480cdad7896a05','chris.petersen','web.de',1,0,0,'Christian','Petersen','C','C','2010-09-06 17:35:24','2010-09-06 17:35:24','1970-01-01 00:00:00'),(12,'vanessa','f24d9057c092943a6cbbb06e907b6ad6','v.polke','gmx.de',1,0,0,'Polke','Vanessa','C','C','2010-09-06 17:35:24','2010-09-06 17:35:24','1970-01-01 00:00:00'),(13,'fastjack','23a558871448a4acd1510a1fc7a58c5b','oliver','regelmann.ch',1,0,0,'Oliver','Regelmann','C','C','2010-09-06 17:35:24','2010-09-06 17:35:24','1970-01-01 00:00:00'),(14,'nicole','52baa4c105cdf7e7eaff5541a5bf062b','nstiefel','metrix.de',1,0,0,'Nicole','Stiefel','C','C','2010-09-06 17:35:24','2010-09-06 17:35:24','1970-01-01 00:00:00'),(15,'lulu','ccd1a6d66db8b85141be943eb1709faf','lulu116','freenet.de',1,0,0,'Mariella','Schneider','C','C','2010-09-06 17:35:24','2010-09-06 17:35:24','1970-01-01 00:00:00'),(16,'sabrina','c1714806d6b945a340aed921a8257b09','sabrina.reuther','web.de',1,0,0,'Sabrina','Reuther','C','C','2010-09-06 17:35:24','2010-09-06 17:35:24','1970-01-01 00:00:00'),(17,'luckec','22d96bddfcdbfa8e6e34377e470b06f2','luckec','php-tools.net',1,0,0,'Carsten','Lucke','C','C','2010-09-06 17:35:24','2010-09-06 17:35:24','1970-01-01 00:00:00'),(18,'vfs','no login','vfs','schaufelberger.de',0,0,0,'','Virtual File System','C','C','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00'),(19,'webmaster','no login','webmaster','schaufelberger.de',0,0,0,'','Webmaster','C','C','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00'),(20,'Stefan','0e36dd21ba7736014a44b3ac8827ebaf','stefan.lacheim','gmx.de',1,0,0,'','','de_DE','C','2011-01-06 21:43:51','2011-01-07 09:30:11','1970-01-01 00:00:00'),(21,'michi','90e645e1abc130ae3bb6b2741252be02','mib','orino.ch',1,0,0,'','','en_GB','C','2011-01-31 21:39:18','2011-01-31 21:39:42','1970-01-01 00:00:00'),(22,'frank','bdf97806b467c7c182616b5000160fd6','frank.steinert','airclip.de',1,1,0,'Frank','Steinert','de_DE','C','2011-06-16 18:21:45','2011-06-17 07:21:27','2011-06-17 07:21:27');

