docs/bugtrack.sql

   1 ## SVN $Id$
   2
   3 CREATE TABLE `attachment` (
   4   `attachmentid` int(10) unsigned NOT NULL auto_increment,
   5   `bugid` int(10) unsigned NOT NULL default '0',
   6   `filename` varchar(255) NOT NULL default '',
   7   `mimetype` varchar(255) NOT NULL default '',
   8   `filesize` int(20) unsigned NOT NULL default '0',
   9   `attachment` mediumtext NOT NULL,
  10   `description` varchar(255) NOT NULL default '',
  11   `dateline` int(20) unsigned NOT NULL default '0',
  12   `userid` int(10) unsigned NOT NULL default '0',
  13   `obsolete` int(1) unsigned NOT NULL default '0',
  14   PRIMARY KEY  (`attachmentid`)
  15 ) ENGINE=MyISAM;
  16
  17 CREATE TABLE `autoaction` (
  18   `actionid` int(10) unsigned NOT NULL auto_increment,
  19   `name` varchar(255) NOT NULL default '',
  20   `description` mediumtext NOT NULL,
  21   `fieldchanges` mediumtext NOT NULL,
  22   `comment` mediumtext NOT NULL,
  23   PRIMARY KEY  (`actionid`)
  24 ) ENGINE=MyISAM;
  25
  26 CREATE TABLE `bug` (
  27   `bugid` int(10) unsigned NOT NULL auto_increment,
  28   `userid` int(10) unsigned NOT NULL default '0',
  29   `dateline` int(20) unsigned NOT NULL default '0',
  30   `productid` int(10) unsigned NOT NULL default '0',
  31   `componentid` int(10) unsigned NOT NULL default '0',
  32   `versionid` int(10) unsigned NOT NULL default '0',
  33   `summary` varchar(255) NOT NULL default '',
  34   `priority` int(10) unsigned NOT NULL default '0',
  35   `severity` int(10) unsigned NOT NULL default '0',
  36   `status` int(10) unsigned NOT NULL default '0',
  37   `resolution` int(10) unsigned NOT NULL default '0',
  38   `assignedto` int(10) unsigned NOT NULL default '0',
  39   `duplicateof` int(10) unsigned NOT NULL default '0',
  40   `dependency` mediumtext NOT NULL,
  41   `hidden` int(2) unsigned NOT NULL default '0',
  42   `initialreport` int(10) unsigned NOT NULL default '0',
  43   `lastposttime` int(20) unsigned NOT NULL default '0',
  44   `lastpostby` int(10) unsigned NOT NULL default '0',
  45   `hiddenlastposttime` int(10) unsigned NOT NULL default '0',
  46   `hiddenlastpostby` int(10) unsigned NOT NULL default '0',
  47   PRIMARY KEY  (`bugid`),
  48   FULLTEXT KEY `summary` (`summary`)
  49 ) ENGINE=MyISAM;
  50
  51 CREATE TABLE `bugfield` (
  52   `fieldid` int(10) unsigned NOT NULL auto_increment,
  53   `name` varchar(255) NOT NULL default '',
  54   `description` mediumtext NOT NULL,
  55   `type` varchar(50) NOT NULL default '',
  56   `selects` mediumtext NOT NULL,
  57   `required` int(2) NOT NULL default '0',
  58   `cansearch` int(2) NOT NULL default '0',
  59   `regexmatch` mediumtext NOT NULL,
  60   `defaultvalue` mediumtext NOT NULL,
  61   `usedefault` int(2) NOT NULL default '0',
  62   `maxlength` int(5) unsigned NOT NULL default '0',
  63   PRIMARY KEY  (`fieldid`)
  64 ) ENGINE=MyISAM;
  65
  66 CREATE TABLE `bugfieldpermission` (
  67   `usergroupid` int(10) unsigned NOT NULL default '0',
  68   `fieldid` int(10) unsigned NOT NULL default '0',
  69   `mask` int(5) unsigned NOT NULL default '0',
  70   PRIMARY KEY  (`usergroupid`,`fieldid`)
  71 ) ENGINE=MyISAM;
  72
  73 CREATE TABLE `bugvaluefill` (
  74   `bugid` int(10) unsigned NOT NULL default '0',
  75   `field2` mediumtext,
  76   `field4` mediumtext,
  77   `field5` mediumtext,
  78   PRIMARY KEY  (`bugid`)
  79 ) ENGINE=MyISAM;
  80
  81 CREATE TABLE `comment` (
  82   `commentid` int(10) unsigned NOT NULL auto_increment,
  83   `bugid` int(10) unsigned NOT NULL default '0',
  84   `userid` int(10) unsigned NOT NULL default '0',
  85   `dateline` int(20) unsigned NOT NULL default '0',
  86   `comment` mediumtext NOT NULL,
  87   `comment_parsed` mediumtext NOT NULL,
  88   `hidden` int(2) unsigned NOT NULL default '0',
  89   PRIMARY KEY  (`commentid`),
  90   FULLTEXT KEY `comment` (`comment`)
  91 ) ENGINE=MyISAM;
  92
  93 CREATE TABLE `datastore` (
  94   `title` varchar(255) NOT NULL default '',
  95   `data` mediumtext NOT NULL,
  96   PRIMARY KEY  (`title`)
  97 ) ENGINE=MyISAM;
  98
  99 CREATE TABLE `dependency` (
 100   `dependencyid` int(10) unsigned NOT NULL auto_increment,
 101   `bugid` int(10) unsigned NOT NULL default '0',
 102   `dependson` int(10) unsigned NOT NULL default '0',
 103   PRIMARY KEY  (`dependencyid`)
 104 ) ENGINE=MyISAM;
 105
 106 CREATE TABLE `history` (
 107   `historyid` int(20) unsigned NOT NULL auto_increment,
 108   `bugid` int(10) unsigned NOT NULL default '0',
 109   `dateline` int(20) unsigned NOT NULL default '0',
 110   `userid` int(10) unsigned NOT NULL default '0',
 111   `language` varchar(255) NOT NULL default '',
 112   `arguments` mediumtext NOT NULL,
 113   `field` varchar(255) NOT NULL default '',
 114   `original` mediumtext NOT NULL,
 115   `changed` mediumtext NOT NULL,
 116   PRIMARY KEY  (`historyid`)
 117 ) ENGINE=MyISAM;
 118
 119 CREATE TABLE `language` (
 120   `languageid` int(10) unsigned NOT NULL auto_increment,
 121   `title` varchar(255) NOT NULL default '',
 122   `languagecode` varchar(5) NOT NULL default '',
 123   `charset` varchar(15) NOT NULL default '',
 124   `direction` char(3) NOT NULL default '',
 125   `default` int(2) unsigned NOT NULL default '0',
 126   `userselect` int(2) unsigned NOT NULL default '0',
 127   `filename` varchar(30) NOT NULL default '',
 128   PRIMARY KEY  (`languageid`),
 129   UNIQUE KEY `languagecode` (`languagecode`),
 130   UNIQUE KEY `filename` (`filename`)
 131 ) ENGINE=MyISAM;
 132
 133 CREATE TABLE `locale` (
 134   `languageid` int(10) unsigned NOT NULL default '0',
 135   `varname` varchar(255) NOT NULL default '',
 136   `phrasetext` mediumtext NOT NULL,
 137   KEY `languageid` (`languageid`)
 138 ) ENGINE=MyISAM;
 139
 140 CREATE TABLE `phrase` (
 141   `varname` varchar(255) NOT NULL default '',
 142   `phrasetext` mediumtext NOT NULL,
 143   `imported` int(20) unsigned NOT NULL default '0',
 144   UNIQUE KEY `varname` (`varname`)
 145 ) ENGINE=MyISAM;
 146
 147 CREATE TABLE `priority` (
 148   `priorityid` int(10) unsigned NOT NULL auto_increment,
 149   `priority` varchar(255) NOT NULL default '',
 150   `displayorder` int(10) unsigned NOT NULL default '0',
 151   PRIMARY KEY  (`priorityid`)
 152 ) ENGINE=MyISAM;
 153
 154 CREATE TABLE `product` (
 155   `productid` int(10) unsigned NOT NULL auto_increment,
 156   `componentmother` int(10) unsigned NOT NULL default '0',
 157   `shortname` varchar(255) NOT NULL default '',
 158   `displayorder` int(10) unsigned NOT NULL default '0',
 159   `title` varchar(255) NOT NULL default '',
 160   `description` mediumtext NOT NULL,
 161   PRIMARY KEY  (`productid`)
 162 ) ENGINE=MyISAM;
 163
 164 CREATE TABLE `resolution` (
 165   `resolutionid` int(10) unsigned NOT NULL auto_increment,
 166   `resolution` varchar(255) NOT NULL default '',
 167   `displayorder` int(10) unsigned NOT NULL default '0',
 168   PRIMARY KEY  (`resolutionid`)
 169 ) ENGINE=MyISAM;
 170
 171 CREATE TABLE `setting` (
 172   `varname` varchar(255) NOT NULL default '',
 173   `value` mediumtext NOT NULL,
 174   PRIMARY KEY  (`varname`)
 175 ) ENGINE=MyISAM;
 176
 177 CREATE TABLE `severity` (
 178   `severityid` int(10) unsigned NOT NULL auto_increment,
 179   `severity` varchar(255) NOT NULL default '',
 180   `displayorder` int(10) unsigned NOT NULL default '0',
 181   PRIMARY KEY  (`severityid`)
 182 ) ENGINE=MyISAM;
 183
 184 CREATE TABLE `status` (
 185   `statusid` int(10) unsigned NOT NULL auto_increment,
 186   `status` varchar(255) NOT NULL default '',
 187   `displayorder` int(10) unsigned NOT NULL default '0',
 188   `color` varchar(10) NOT NULL default '',
 189   PRIMARY KEY  (`statusid`)
 190 ) ENGINE=MyISAM;
 191
 192 CREATE TABLE `user` (
 193   `userid` int(10) unsigned NOT NULL auto_increment,
 194   `email` varchar(255) NOT NULL default '',
 195   `displayname` varchar(255) NOT NULL default '',
 196   `usergroupid` int(10) unsigned NOT NULL default '0',
 197   `password` varchar(32) NOT NULL default '',
 198   `salt` varchar(15) NOT NULL default '',
 199   `authkey` varchar(65) NOT NULL default '',
 200   `showemail` int(2) unsigned NOT NULL default '0',
 201   `languageid` int(10) unsigned NOT NULL default '0',
 202   `timezone` int(4) NOT NULL default '0',
 203   PRIMARY KEY  (`userid`)
 204 ) ENGINE=MyISAM;
 205
 206 CREATE TABLE `useractivation` (
 207   `activator` varchar(25) NOT NULL default '',
 208   `userid` int(10) unsigned NOT NULL default '0',
 209   `dateline` int(10) unsigned NOT NULL default '0',
 210   `usergroupid` int(10) unsigned NOT NULL default '0',
 211   PRIMARY KEY  (`activator`)
 212 ) ENGINE=MyISAM;
 213
 214 CREATE TABLE `usergroup` (
 215   `usergroupid` int(10) unsigned NOT NULL auto_increment,
 216   `title` varchar(255) NOT NULL default '',
 217   `displaytitle` varchar(255) NOT NULL default '',
 218   `opentag` varchar(255) NOT NULL default '',
 219   `closetag` varchar(255) NOT NULL default '',
 220   `permissions` int(10) unsigned NOT NULL default '0',
 221   PRIMARY KEY  (`usergroupid`)
 222 ) ENGINE=MyISAM;
 223
 224 CREATE TABLE `version` (
 225   `versionid` int(10) unsigned NOT NULL auto_increment,
 226   `productid` int(10) unsigned NOT NULL default '0',
 227   `version` varchar(255) NOT NULL default '',
 228   `displayorder` int(10) unsigned NOT NULL default '0',
 229   PRIMARY KEY  (`versionid`)
 230 ) ENGINE=MyISAM;