--
-- Host: localhost    Database: gumnut
-- ------------------------------------------------------

--
-- Table structure for table `wbgroup`
--

CREATE TABLE wbgroup (
  gid int(11) NOT NULL default '0',
  groupname varchar(100) NOT NULL default '',
  PRIMARY KEY  (gid)
) TYPE=MyISAM COMMENT='wb group definition';

--
-- Dumping data for table `wbgroup`
--

INSERT INTO wbgroup VALUES (59,'native speaker');
INSERT INTO wbgroup VALUES (58,'Backpackers');
INSERT INTO wbgroup VALUES (55,'Members');
INSERT INTO wbgroup VALUES (57,'Locals');
INSERT INTO wbgroup VALUES (56,'GumNut');

--
-- Table structure for table `wbgroup_seq`
--

CREATE TABLE wbgroup_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `wbgroup_seq`
--

INSERT INTO wbgroup_seq VALUES (59);

--
-- Table structure for table `wbuser`
--

CREATE TABLE wbuser (
  uid int(10) unsigned NOT NULL default '0',
  user varchar(20) NOT NULL default '',
  password varchar(100) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  realname varchar(100) NOT NULL default '',
  flags set('new','enabled','deleted','admin','approved') NOT NULL default '',
  created datetime NOT NULL default '0000-00-00 00:00:00',
  recent datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (uid)
) TYPE=MyISAM COMMENT='wbUser table';

--
-- Dumping data for table `wbuser`
--

INSERT INTO wbuser VALUES (1,'gerd','7299eb4710a9021e8ce1fb00bfcbe246','gerd@gumnutsystems.com','gERD Schaufelberger','enabled,admin,approved','2004-08-11 12:00:00','2004-09-07 09:56:39');
INSERT INTO wbuser VALUES (2,'rob','8f53e82e508c96115551317048cba97e','rofarrel@gumnut.com.au','Robert O\'Farrell','enabled,admin,approved','2004-08-11 12:00:00','2004-08-18 18:26:05');
INSERT INTO wbuser VALUES (3,'saqib','683b66efc77f333c644c0f3d5558e8d0','sriaz@gumnut.com.au','Saqib Riaz','enabled,approved','2004-08-11 12:00:00','0000-00-00 00:00:00');
INSERT INTO wbuser VALUES (4,'david','55fc5b709962876903785fd64a6961e5','dquagleri@gumnut.com.au','David Quaglieri','enabled,approved','2004-08-11 12:00:00','0000-00-00 00:00:00');
INSERT INTO wbuser VALUES (7,'dampf','72e8a3090539a0a4ea6fad7dfb0749cb','xxx@bla.com','Hans Dampf','enabled,deleted','2004-08-12 12:13:51','2004-08-15 11:34:01');
INSERT INTO wbuser VALUES (15,'test','QTh3?P$:','test@bla.com','test Test','new','2004-09-06 10:55:55','2004-09-06 12:18:44');

--
-- Table structure for table `wbuser_seq`
--

CREATE TABLE wbuser_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `wbuser_seq`
--

INSERT INTO wbuser_seq VALUES (17);

--
-- Table structure for table `wbusergroup`
--

CREATE TABLE wbusergroup (
  ugid int(11) NOT NULL default '0',
  uid int(11) NOT NULL default '0',
  gid int(11) NOT NULL default '0',
  PRIMARY KEY  (ugid)
) TYPE=MyISAM COMMENT='wb relation table for users in groups';

--
-- Dumping data for table `wbusergroup`
--

INSERT INTO wbusergroup VALUES (24,4,58);
INSERT INTO wbusergroup VALUES (36,2,56);
INSERT INTO wbusergroup VALUES (35,2,58);
INSERT INTO wbusergroup VALUES (34,1,56);
INSERT INTO wbusergroup VALUES (33,1,57);
INSERT INTO wbusergroup VALUES (23,4,59);
INSERT INTO wbusergroup VALUES (32,1,58);
INSERT INTO wbusergroup VALUES (31,15,57);
INSERT INTO wbusergroup VALUES (28,4,57);
INSERT INTO wbusergroup VALUES (29,4,56);
INSERT INTO wbusergroup VALUES (30,15,59);

--
-- Table structure for table `wbusergroup_seq`
--

CREATE TABLE wbusergroup_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `wbusergroup_seq`
--

INSERT INTO wbusergroup_seq VALUES (36);

