#
# Table structure for table 'mantis_group_table'
#

CREATE TABLE mantis_group_table (
  id int(7) unsigned NOT NULL auto_increment,
  groupname varchar(32) NOT NULL default '',
  date_created datetime NOT NULL default '1970-01-01 00:00:01',
  enabled int(1) NOT NULL default '1',
  protected int(1) NOT NULL default '0',
  access_level int(2) NOT NULL default '10',
  cookie_string varchar(64) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY groupname (groupname),
  UNIQUE KEY cookie_string (cookie_string)
) TYPE=MyISAM;


#
# Table structure for table 'mantis_group_user_list_table'
#

CREATE TABLE mantis_group_user_list_table (
  group_id int(7) unsigned NOT NULL default '0',
  user_id int(7) unsigned NOT NULL default '0',
  PRIMARY KEY  (group_id,user_id)
) TYPE=MyISAM;


#
# Table structure for table 'mantis_bug_group_list_table'
#

CREATE TABLE mantis_bug_group_list_table (
  bug_id int(7) unsigned NOT NULL default '0',
  group_id int(7) unsigned NOT NULL default '0',
  PRIMARY KEY  (bug_id,group_id)
) TYPE=MyISAM;