## SVN $Id$

CREATE TABLE `bug` (
  `bugid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `dateline` int(20) unsigned NOT NULL default '0',
  `productid` int(10) unsigned NOT NULL default '0',
  `componentid` int(10) unsigned NOT NULL default '0',
  `versionid` int(10) unsigned NOT NULL default '0',
  `summary` varchar(255) NOT NULL default '',
  `priority` int(10) unsigned NOT NULL default '0',
  `severity` int(10) unsigned NOT NULL default '0',
  `status` int(10) unsigned NOT NULL default '0',
  `resolution` int(10) unsigned NOT NULL default '0',
  `assignedto` int(10) unsigned NOT NULL default '0',
  `initialreport` int(10) unsigned NOT NULL default '0',
  `lastposttime` int(20) unsigned NOT NULL default '0',
  `lastpostby` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`bugid`),
  FULLTEXT KEY `summary` (`summary`)
) ENGINE=MyISAM;

CREATE TABLE `comment` (
  `commentid` int(10) unsigned NOT NULL auto_increment,
  `bugid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `dateline` int(20) unsigned NOT NULL default '0',
  `comment` mediumtext NOT NULL,
  `comment_parsed` mediumtext NOT NULL,
  PRIMARY KEY  (`commentid`),
  FULLTEXT KEY `comment` (`comment`)
) ENGINE=MyISAM;

CREATE TABLE `datastore` (
  `title` varchar(255) NOT NULL default '',
  `data` mediumtext NOT NULL,
  PRIMARY KEY  (`title`)
) ENGINE=MyISAM;

CREATE TABLE `dependency` (
  `dependencyid` int(10) unsigned NOT NULL auto_increment,
  `bugid` int(10) unsigned NOT NULL default '0',
  `dependson` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`dependencyid`)
) ENGINE=MyISAM;

CREATE TABLE `language` (
  `languageid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `languagecode` varchar(5) NOT NULL default '',
  `charset` varchar(15) NOT NULL default '',
  `direction` char(3) NOT NULL default '',
  `default` int(2) unsigned NOT NULL default '0',
  `userselect` int(2) unsigned NOT NULL default '0',
  `filename` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`languageid`),
  UNIQUE KEY `languagecode` (`languagecode`),
  UNIQUE KEY `filename` (`filename`)
) ENGINE=MyISAM;

CREATE TABLE `locale` (
  `languageid` int(10) unsigned NOT NULL default '0',
  `varname` varchar(255) NOT NULL default '',
  `phrasetext` mediumtext NOT NULL,
  KEY `languageid` (`languageid`)
) ENGINE=MyISAM;

CREATE TABLE `phrase` (
  `varname` varchar(255) NOT NULL default '',
  `phrasetext` mediumtext NOT NULL,
  `imported` int(20) unsigned NOT NULL default '0',
  UNIQUE KEY `varname` (`varname`)
) ENGINE=MyISAM;

CREATE TABLE `priority` (
  `priorityid` int(10) unsigned NOT NULL auto_increment,
  `priority` varchar(255) NOT NULL default '',
  `displayorder` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`priorityid`)
) ENGINE=MyISAM;

CREATE TABLE `product` (
  `productid` int(10) unsigned NOT NULL auto_increment,
  `componentmother` int(10) unsigned NOT NULL default '0',
  `shortname` varchar(255) NOT NULL default '',
  `displayorder` int(10) unsigned NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` mediumtext NOT NULL,
  PRIMARY KEY  (`productid`)
) ENGINE=MyISAM;

CREATE TABLE `resolution` (
  `resolutionid` int(10) unsigned NOT NULL auto_increment,
  `resolution` varchar(255) NOT NULL default '',
  `displayorder` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`resolutionid`)
) ENGINE=MyISAM;

CREATE TABLE `setting` (
  `varname` varchar(255) NOT NULL default '',
  `value` mediumtext NOT NULL,
  PRIMARY KEY  (`varname`)
) ENGINE=MyISAM;

CREATE TABLE `severity` (
  `severityid` int(10) unsigned NOT NULL auto_increment,
  `severity` varchar(255) NOT NULL default '',
  `displayorder` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`severityid`)
) ENGINE=MyISAM;

CREATE TABLE `status` (
  `statusid` int(10) unsigned NOT NULL auto_increment,
  `status` varchar(255) NOT NULL default '',
  `displayorder` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`statusid`)
) ENGINE=MyISAM;

CREATE TABLE `templateset` (
  `templatesetid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `shortname` varchar(50) NOT NULL default '',
  `default` int(2) unsigned NOT NULL default '0',
  `userselect` int(2) unsigned NOT NULL default '0',
  PRIMARY KEY  (`templatesetid`),
  UNIQUE KEY `title` (`title`)
) ENGINE=MyISAM;

CREATE TABLE `user` (
  `userid` int(10) unsigned NOT NULL auto_increment,
  `email` varchar(255) NOT NULL default '',
  `displayname` varchar(255) NOT NULL default '',
  `usergroupid` int(10) unsigned NOT NULL default '0',
  `password` varchar(32) NOT NULL default '',
  `salt` varchar(15) NOT NULL default '',
  `authkey` varchar(65) NOT NULL default '',
  `showemail` int(2) unsigned NOT NULL default '0',
  `languageid` int(10) unsigned NOT NULL default '0',
  `timezone` int(4) NOT NULL default '0',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM;

CREATE TABLE `useractivation` (
  `activator` varchar(25) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `usergroupid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`activator`)
) ENGINE=MyISAM;

CREATE TABLE `usergroup` (
  `usergroupid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `displaytitle` varchar(255) NOT NULL default '',
  `opentag` varchar(255) NOT NULL default '',
  `closetag` varchar(255) NOT NULL default '',
  `permissions` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`usergroupid`)
) ENGINE=MyISAM DEFAULT  PACK_KEYS=0;

CREATE TABLE `version` (
  `versionid` int(10) unsigned NOT NULL auto_increment,
  `productid` int(10) unsigned NOT NULL default '0',
  `version` varchar(255) NOT NULL default '',
  `displayorder` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`versionid`)
) ENGINE=MyISAM;