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` mediumblob 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 `favourite` (
 107   `userid` int(10) unsigned NOT NULL default '0',
 108   `bugid` int(10) unsigned NOT NULL default '0',
 109   PRIMARY KEY  (`userid`,`bugid`)
 110 ) ENGINE=MyISAM;
 111
 112 CREATE TABLE `history` (
 113   `historyid` int(20) unsigned NOT NULL auto_increment,
 114   `bugid` int(10) unsigned NOT NULL default '0',
 115   `attachmentid` int(10) unsigned NOT NULL default '0',
 116   `commentid` int(10) unsigned NOT NULL default '0',
 117   `dateline` int(20) unsigned NOT NULL default '0',
 118   `userid` int(10) unsigned NOT NULL default '0',
 119   `field` varchar(255) NOT NULL default '',
 120   `original` mediumtext NOT NULL,
 121   `changed` mediumtext NOT NULL,
 122   PRIMARY KEY  (`historyid`)
 123 ) ENGINE=MyISAM;
 124
 125 CREATE TABLE `language` (
 126   `languageid` int(10) unsigned NOT NULL auto_increment,
 127   `title` varchar(255) NOT NULL default '',
 128   `languagecode` varchar(5) NOT NULL default '',
 129   `charset` varchar(15) NOT NULL default '',
 130   `direction` char(3) NOT NULL default '',
 131   `filename` varchar(255) NOT NULL default '',
 132   `default` int(2) unsigned NOT NULL default '0',
 133   `userselect` int(2) unsigned NOT NULL default '0',
 134   `debug` int(2) unsigned NOT NULL default '0',
 135   PRIMARY KEY  (`languageid`),
 136   UNIQUE KEY `languagecode` (`languagecode`)
 137 ) ENGINE=MyISAM;
 138
 139 CREATE TABLE `localization` (
 140   `localid` int(10) unsigned NOT NULL auto_increment,
 141   `localkey` mediumtext NOT NULL,
 142   `localtext` mediumtext NOT NULL,
 143   `languageid` int(10) unsigned NOT NULL default '0',
 144   PRIMARY KEY  (`localid`)
 145 ) ENGINE=MyISAM;
 146
 147 CREATE TABLE `permission` (
 148   `usergroupid` int(10) unsigned NOT NULL default '0',
 149   `productid` int(10) unsigned NOT NULL default '0',
 150   `mask` int(5) NOT NULL default '0',
 151   PRIMARY KEY  (`usergroupid`,`productid`)
 152 ) ENGINE=MyISAM;
 153
 154 CREATE TABLE `priority` (
 155   `priorityid` int(10) unsigned NOT NULL auto_increment,
 156   `priority` varchar(255) NOT NULL default '',
 157   `displayorder` int(10) unsigned NOT NULL default '0',
 158   PRIMARY KEY  (`priorityid`)
 159 ) ENGINE=MyISAM;
 160
 161 CREATE TABLE `product` (
 162   `productid` int(10) unsigned NOT NULL auto_increment,
 163   `componentmother` int(10) unsigned NOT NULL default '0',
 164   `shortname` varchar(255) NOT NULL default '',
 165   `displayorder` int(10) unsigned NOT NULL default '0',
 166   `title` varchar(255) NOT NULL default '',
 167   `description` mediumtext NOT NULL,
 168   PRIMARY KEY  (`productid`)
 169 ) ENGINE=MyISAM;
 170
 171 CREATE TABLE `resolution` (
 172   `resolutionid` int(10) unsigned NOT NULL auto_increment,
 173   `resolution` varchar(255) NOT NULL default '',
 174   `displayorder` int(10) unsigned NOT NULL default '0',
 175   PRIMARY KEY  (`resolutionid`)
 176 ) ENGINE=MyISAM;
 177
 178 CREATE TABLE `search` (
 179   `userid` int(10) unsigned NOT NULL default '0',
 180   `dateline` int(20) unsigned NOT NULL default '0',
 181   `query` mediumtext NOT NULL,
 182   `ids` mediumtext NOT NULL,
 183   `orderby` mediumtext NOT NULL,
 184   `hilight` varchar(255) NOT NULL default '',
 185   PRIMARY KEY  (`userid`)
 186 ) ENGINE=MyISAM;
 187
 188 CREATE TABLE `setting` (
 189   `varname` varchar(255) NOT NULL default '',
 190   `value` mediumtext NOT NULL,
 191   PRIMARY KEY  (`varname`)
 192 ) ENGINE=MyISAM;
 193
 194 CREATE TABLE `severity` (
 195   `severityid` int(10) unsigned NOT NULL auto_increment,
 196   `severity` varchar(255) NOT NULL default '',
 197   `displayorder` int(10) unsigned NOT NULL default '0',
 198   PRIMARY KEY  (`severityid`)
 199 ) ENGINE=MyISAM;
 200
 201 CREATE TABLE `status` (
 202   `statusid` int(10) unsigned NOT NULL auto_increment,
 203   `status` varchar(255) NOT NULL default '',
 204   `displayorder` int(10) unsigned NOT NULL default '0',
 205   `color` varchar(10) NOT NULL default '',
 206   PRIMARY KEY  (`statusid`)
 207 ) ENGINE=MyISAM;
 208
 209 CREATE TABLE `user` (
 210   `userid` int(10) unsigned NOT NULL auto_increment,
 211   `email` varchar(255) NOT NULL default '',
 212   `displayname` varchar(255) NOT NULL default '',
 213   `usergroupid` int(10) unsigned NOT NULL default '0',
 214   `password` varchar(32) NOT NULL default '',
 215   `salt` varchar(15) NOT NULL default '',
 216   `authkey` varchar(65) NOT NULL default '',
 217   `showemail` int(2) unsigned NOT NULL default '0',
 218   `showcolours` int(2) unsigned NOT NULL default '0',
 219   `languageid` int(10) unsigned NOT NULL default '0',
 220   `timezone` int(4) NOT NULL default '0',
 221   PRIMARY KEY  (`userid`)
 222 ) ENGINE=MyISAM;
 223
 224 CREATE TABLE `useractivation` (
 225   `activator` varchar(25) NOT NULL default '',
 226   `userid` int(10) unsigned NOT NULL default '0',
 227   `dateline` int(10) unsigned NOT NULL default '0',
 228   `usergroupid` int(10) unsigned NOT NULL default '0',
 229   PRIMARY KEY  (`activator`)
 230 ) ENGINE=MyISAM;
 231
 232 CREATE TABLE `usergroup` (
 233   `usergroupid` int(10) unsigned NOT NULL auto_increment,
 234   `title` varchar(255) NOT NULL default '',
 235   `displaytitle` varchar(255) NOT NULL default '',
 236   `opentag` varchar(255) NOT NULL default '',
 237   `closetag` varchar(255) NOT NULL default '',
 238   `permissions` int(10) unsigned NOT NULL default '0',
 239   PRIMARY KEY  (`usergroupid`)
 240 ) ENGINE=MyISAM;
 241
 242 CREATE TABLE `version` (
 243   `versionid` int(10) unsigned NOT NULL auto_increment,
 244   `productid` int(10) unsigned NOT NULL default '0',
 245   `version` varchar(255) NOT NULL default '',
 246   `displayorder` int(10) unsigned NOT NULL default '0',
 247   PRIMARY KEY  (`versionid`)
 248 ) ENGINE=MyISAM;
 249
 250 CREATE TABLE `vote` (
 251   `bugid` int(10) unsigned NOT NULL default '0',
 252   `userids` mediumtext NOT NULL,
 253   `votefor` int(10) unsigned NOT NULL default '0',
 254   `voteagainst` int(10) unsigned NOT NULL default '0',
 255   PRIMARY KEY  (`bugid`)
 256 ) ENGINE=MyISAM;