--
-- 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_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);

