-- MySQL dump 9.09
--
-- Host: localhost    Database: gumnut
-- ------------------------------------------------------
-- Server version	4.0.16-max-debug

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

DROP TABLE IF EXISTS 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';

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

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

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

DROP TABLE IF EXISTS 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';

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

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

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

DROP TABLE IF EXISTS 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';

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

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

