docs/bugtrack.sql

   1 ## SVN $Id$
   2
   3 CREATE TABLE `bug` (
   4   `bugid` int(10) unsigned NOT NULL auto_increment,
   5   `userid` int(10) unsigned NOT NULL default '0',
   6   `dateline` int(20) unsigned NOT NULL default '0',
   7   `productid` int(10) unsigned NOT NULL default '0',
   8   `componentid` int(10) unsigned NOT NULL default '0',
   9   `versionid` int(10) unsigned NOT NULL default '0',
  10   `summary` varchar(255) NOT NULL default '',
  11   `priority` int(10) unsigned NOT NULL default '0',
  12   `severity` int(10) unsigned NOT NULL default '0',
  13   `status` int(10) unsigned NOT NULL default '0',
  14   `resolution` int(10) unsigned NOT NULL default '0',
  15   `assignedto` int(10) unsigned NOT NULL default '0',
  16   `initialreport` int(10) unsigned NOT NULL default '0',
  17   `lastposttime` int(20) unsigned NOT NULL default '0',
  18   `lastpostby` int(10) unsigned NOT NULL default '0',
  19   PRIMARY KEY  (`bugid`),
  20   FULLTEXT KEY `summary` (`summary`)
  21 ) ENGINE=MyISAM;
  22
  23 CREATE TABLE `comment` (
  24   `commentid` int(10) unsigned NOT NULL auto_increment,
  25   `bugid` int(10) unsigned NOT NULL default '0',
  26   `userid` int(10) unsigned NOT NULL default '0',
  27   `dateline` int(20) unsigned NOT NULL default '0',
  28   `comment` mediumtext NOT NULL,
  29   `comment_parsed` mediumtext NOT NULL,
  30   PRIMARY KEY  (`commentid`),
  31   FULLTEXT KEY `comment` (`comment`)
  32 ) ENGINE=MyISAM;
  33
  34 CREATE TABLE `datastore` (
  35   `title` varchar(255) NOT NULL default '',
  36   `data` mediumtext NOT NULL,
  37   PRIMARY KEY  (`title`)
  38 ) ENGINE=MyISAM;
  39
  40 CREATE TABLE `dependency` (
  41   `dependencyid` int(10) unsigned NOT NULL auto_increment,
  42   `bugid` int(10) unsigned NOT NULL default '0',
  43   `dependson` int(10) unsigned NOT NULL default '0',
  44   PRIMARY KEY  (`dependencyid`)
  45 ) ENGINE=MyISAM;
  46
  47 CREATE TABLE `language` (
  48   `languageid` int(10) unsigned NOT NULL auto_increment,
  49   `title` varchar(255) NOT NULL default '',
  50   `languagecode` varchar(5) NOT NULL default '',
  51   `charset` varchar(15) NOT NULL default '',
  52   `direction` char(3) NOT NULL default '',
  53   `default` int(2) unsigned NOT NULL default '0',
  54   `userselect` int(2) unsigned NOT NULL default '0',
  55   `filename` varchar(30) NOT NULL default '',
  56   PRIMARY KEY  (`languageid`),
  57   UNIQUE KEY `languagecode` (`languagecode`),
  58   UNIQUE KEY `filename` (`filename`)
  59 ) ENGINE=MyISAM;
  60
  61 CREATE TABLE `locale` (
  62   `languageid` int(10) unsigned NOT NULL default '0',
  63   `varname` varchar(255) NOT NULL default '',
  64   `phrasetext` mediumtext NOT NULL,
  65   KEY `languageid` (`languageid`)
  66 ) ENGINE=MyISAM;
  67
  68 CREATE TABLE `phrase` (
  69   `varname` varchar(255) NOT NULL default '',
  70   `phrasetext` mediumtext NOT NULL,
  71   `imported` int(20) unsigned NOT NULL default '0',
  72   UNIQUE KEY `varname` (`varname`)
  73 ) ENGINE=MyISAM;
  74
  75 CREATE TABLE `priority` (
  76   `priorityid` int(10) unsigned NOT NULL auto_increment,
  77   `priority` varchar(255) NOT NULL default '',
  78   `displayorder` int(10) unsigned NOT NULL default '0',
  79   PRIMARY KEY  (`priorityid`)
  80 ) ENGINE=MyISAM;
  81
  82 CREATE TABLE `product` (
  83   `productid` int(10) unsigned NOT NULL auto_increment,
  84   `componentmother` int(10) unsigned NOT NULL default '0',
  85   `shortname` varchar(255) NOT NULL default '',
  86   `displayorder` int(10) unsigned NOT NULL default '0',
  87   `title` varchar(255) NOT NULL default '',
  88   `description` mediumtext NOT NULL,
  89   PRIMARY KEY  (`productid`)
  90 ) ENGINE=MyISAM;
  91
  92 CREATE TABLE `resolution` (
  93   `resolutionid` int(10) unsigned NOT NULL auto_increment,
  94   `resolution` varchar(255) NOT NULL default '',
  95   `displayorder` int(10) unsigned NOT NULL default '0',
  96   PRIMARY KEY  (`resolutionid`)
  97 ) ENGINE=MyISAM;
  98
  99 CREATE TABLE `setting` (
 100   `varname` varchar(255) NOT NULL default '',
 101   `value` mediumtext NOT NULL,
 102   PRIMARY KEY  (`varname`)
 103 ) ENGINE=MyISAM;
 104
 105 CREATE TABLE `severity` (
 106   `severityid` int(10) unsigned NOT NULL auto_increment,
 107   `severity` varchar(255) NOT NULL default '',
 108   `displayorder` int(10) unsigned NOT NULL default '0',
 109   PRIMARY KEY  (`severityid`)
 110 ) ENGINE=MyISAM;
 111
 112 CREATE TABLE `status` (
 113   `statusid` int(10) unsigned NOT NULL auto_increment,
 114   `status` varchar(255) NOT NULL default '',
 115   `displayorder` int(10) unsigned NOT NULL default '0',
 116   PRIMARY KEY  (`statusid`)
 117 ) ENGINE=MyISAM;
 118
 119 CREATE TABLE `templateset` (
 120   `templatesetid` int(10) unsigned NOT NULL auto_increment,
 121   `title` varchar(255) NOT NULL default '',
 122   `shortname` varchar(50) NOT NULL default '',
 123   `default` int(2) unsigned NOT NULL default '0',
 124   `userselect` int(2) unsigned NOT NULL default '0',
 125   PRIMARY KEY  (`templatesetid`),
 126   UNIQUE KEY `title` (`title`)
 127 ) ENGINE=MyISAM;
 128
 129 CREATE TABLE `user` (
 130   `userid` int(10) unsigned NOT NULL auto_increment,
 131   `email` varchar(255) NOT NULL default '',
 132   `displayname` varchar(255) NOT NULL default '',
 133   `usergroupid` int(10) unsigned NOT NULL default '0',
 134   `password` varchar(32) NOT NULL default '',
 135   `salt` varchar(15) NOT NULL default '',
 136   `authkey` varchar(65) NOT NULL default '',
 137   `showemail` int(2) unsigned NOT NULL default '0',
 138   `languageid` int(10) unsigned NOT NULL default '0',
 139   `timezone` int(4) NOT NULL default '0',
 140   PRIMARY KEY  (`userid`)
 141 ) ENGINE=MyISAM;
 142
 143 CREATE TABLE `useractivation` (
 144   `activator` varchar(25) NOT NULL default '',
 145   `userid` int(10) unsigned NOT NULL default '0',
 146   `dateline` int(10) unsigned NOT NULL default '0',
 147   `usergroupid` int(10) unsigned NOT NULL default '0',
 148   PRIMARY KEY  (`activator`)
 149 ) ENGINE=MyISAM;
 150
 151 CREATE TABLE `usergroup` (
 152   `usergroupid` int(10) unsigned NOT NULL auto_increment,
 153   `title` varchar(255) NOT NULL default '',
 154   `displaytitle` varchar(255) NOT NULL default '',
 155   `opentag` varchar(255) NOT NULL default '',
 156   `closetag` varchar(255) NOT NULL default '',
 157   `permissions` int(10) unsigned NOT NULL default '0',
 158   PRIMARY KEY  (`usergroupid`)
 159 ) ENGINE=MyISAM;
 160
 161 CREATE TABLE `version` (
 162   `versionid` int(10) unsigned NOT NULL auto_increment,
 163   `productid` int(10) unsigned NOT NULL default '0',
 164   `version` varchar(255) NOT NULL default '',
 165   `displayorder` int(10) unsigned NOT NULL default '0',
 166   PRIMARY KEY  (`versionid`)
 167 ) ENGINE=MyISAM;