install/schema.php

   1 <?php
   2 /*=====================================================================*\
   3 || ################################################################### ||
   4 || # Bugdar [#]version[#]
   5 || # --------------------------------------------------------------- # ||
   6 || # Copyright ©2002-[#]year[#] by Iris Studios, Inc. All Rights Reserved. # ||
   7 || # This file may not be reproduced in any way without permission.  # ||
   8 || # --------------------------------------------------------------- # ||
   9 || # User License Agreement at http://www.iris-studios.com/license/  # ||
  10 || ################################################################### ||
  11 \*=====================================================================*/
  12
  13 $query['attachment'] = "
  14 CREATE TABLE `attachment` (
  15   `attachmentid` int(10) unsigned NOT NULL auto_increment,
  16   `bugid` int(10) unsigned NOT NULL default '0',
  17   `filename` varchar(255) NOT NULL default '',
  18   `mimetype` varchar(255) NOT NULL default '',
  19   `filesize` int(20) unsigned NOT NULL default '0',
  20   `attachment` mediumblob NOT NULL,
  21   `description` varchar(255) NOT NULL default '',
  22   `dateline` int(20) unsigned NOT NULL default '0',
  23   `userid` int(10) unsigned NOT NULL default '0',
  24   `obsolete` int(1) unsigned NOT NULL default '0',
  25   PRIMARY KEY  (`attachmentid`)
  26 ) ENGINE=MyISAM;
  27 ";
  28
  29 $query['autoaction'] = "
  30 CREATE TABLE `autoaction` (
  31   `actionid` int(10) unsigned NOT NULL auto_increment,
  32   `name` varchar(255) NOT NULL default '',
  33   `description` mediumtext NOT NULL,
  34   `fieldchanges` mediumtext NOT NULL,
  35   `comment` mediumtext NOT NULL,
  36   PRIMARY KEY  (`actionid`)
  37 ) ENGINE=MyISAM;
  38 ";
  39
  40 $query['bug'] = "
  41 CREATE TABLE `bug` (
  42   `bugid` int(10) unsigned NOT NULL auto_increment,
  43   `userid` int(10) unsigned NOT NULL default '0',
  44   `dateline` int(20) unsigned NOT NULL default '0',
  45   `productid` int(10) unsigned NOT NULL default '0',
  46   `componentid` int(10) unsigned NOT NULL default '0',
  47   `versionid` int(10) unsigned NOT NULL default '0',
  48   `summary` varchar(255) NOT NULL default '',
  49   `priority` int(10) unsigned NOT NULL default '0',
  50   `severity` int(10) unsigned NOT NULL default '0',
  51   `status` int(10) unsigned NOT NULL default '0',
  52   `resolution` int(10) unsigned NOT NULL default '0',
  53   `assignedto` int(10) unsigned NOT NULL default '0',
  54   `duplicateof` int(10) unsigned NOT NULL default '0',
  55   `dependency` mediumtext NOT NULL,
  56   `hidden` int(2) unsigned NOT NULL default '0',
  57   `initialreport` int(10) unsigned NOT NULL default '0',
  58   `lastposttime` int(20) unsigned NOT NULL default '0',
  59   `lastpostby` int(10) unsigned NOT NULL default '0',
  60   `hiddenlastposttime` int(10) unsigned NOT NULL default '0',
  61   `hiddenlastpostby` int(10) unsigned NOT NULL default '0',
  62   PRIMARY KEY  (`bugid`),
  63   FULLTEXT KEY `summary` (`summary`)
  64 ) ENGINE=MyISAM;
  65 ";
  66
  67 $query['bugfield'] = "
  68 CREATE TABLE `bugfield` (
  69   `fieldid` int(10) unsigned NOT NULL auto_increment,
  70   `name` varchar(255) NOT NULL default '',
  71   `description` mediumtext NOT NULL,
  72   `type` varchar(50) NOT NULL default '',
  73   `selects` mediumtext NOT NULL,
  74   `required` int(2) NOT NULL default '0',
  75   `cansearch` int(2) NOT NULL default '0',
  76   `regexmatch` mediumtext NOT NULL,
  77   `defaultvalue` mediumtext NOT NULL,
  78   `usedefault` int(2) NOT NULL default '0',
  79   `maxlength` int(5) unsigned NOT NULL default '0',
  80   PRIMARY KEY  (`fieldid`)
  81 ) ENGINE=MyISAM;
  82 ";
  83
  84 $query['bugfieldpermission'] = "
  85 CREATE TABLE `bugfieldpermission` (
  86   `usergroupid` int(10) unsigned NOT NULL default '0',
  87   `fieldid` int(10) unsigned NOT NULL default '0',
  88   `mask` int(5) unsigned NOT NULL default '0',
  89   PRIMARY KEY  (`usergroupid`,`fieldid`)
  90 ) ENGINE=MyISAM;
  91 ";
  92
  93 $query['bugvaluefill'] = "
  94 CREATE TABLE `bugvaluefill` (
  95   `bugid` int(10) unsigned NOT NULL default '0',
  96   `field2` mediumtext,
  97   `field4` mediumtext,
  98   `field5` mediumtext,
  99   PRIMARY KEY  (`bugid`)
 100 ) ENGINE=MyISAM;
 101 ";
 102
 103 $query['comment'] = "
 104 CREATE TABLE `comment` (
 105   `commentid` int(10) unsigned NOT NULL auto_increment,
 106   `bugid` int(10) unsigned NOT NULL default '0',
 107   `userid` int(10) unsigned NOT NULL default '0',
 108   `dateline` int(20) unsigned NOT NULL default '0',
 109   `comment` mediumtext NOT NULL,
 110   `comment_parsed` mediumtext NOT NULL,
 111   `hidden` int(2) unsigned NOT NULL default '0',
 112   PRIMARY KEY  (`commentid`),
 113   FULLTEXT KEY `comment` (`comment`)
 114 ) ENGINE=MyISAM;
 115 ";
 116
 117 $query['datastore'] = "
 118 CREATE TABLE `datastore` (
 119   `title` varchar(255) NOT NULL default '',
 120   `data` mediumtext NOT NULL,
 121   PRIMARY KEY  (`title`)
 122 ) ENGINE=MyISAM;
 123 ";
 124
 125 $query['dependency'] = "
 126 CREATE TABLE `dependency` (
 127   `dependencyid` int(10) unsigned NOT NULL auto_increment,
 128   `bugid` int(10) unsigned NOT NULL default '0',
 129   `dependson` int(10) unsigned NOT NULL default '0',
 130   PRIMARY KEY  (`dependencyid`)
 131 ) ENGINE=MyISAM;
 132 ";
 133
 134 $query['favourite'] = "
 135 CREATE TABLE `favourite` (
 136   `userid` int(10) unsigned NOT NULL default '0',
 137   `bugid` int(10) unsigned NOT NULL default '0',
 138   PRIMARY KEY  (`userid`,`bugid`)
 139 ) ENGINE=MyISAM;
 140 ";
 141
 142 $query['history'] = "
 143 CREATE TABLE `history` (
 144   `historyid` int(20) unsigned NOT NULL auto_increment,
 145   `bugid` int(10) unsigned NOT NULL default '0',
 146   `attachmentid` int(10) unsigned NOT NULL default '0',
 147   `commentid` int(10) unsigned NOT NULL default '0',
 148   `dateline` int(20) unsigned NOT NULL default '0',
 149   `userid` int(10) unsigned NOT NULL default '0',
 150   `field` varchar(255) NOT NULL default '',
 151   `original` mediumtext NOT NULL,
 152   `changed` mediumtext NOT NULL,
 153   PRIMARY KEY  (`historyid`)
 154 ) ENGINE=MyISAM;
 155 ";
 156
 157 $query['language'] = "
 158 CREATE TABLE `language` (
 159   `languageid` int(10) unsigned NOT NULL auto_increment,
 160   `title` varchar(255) NOT NULL default '',
 161   `languagecode` varchar(5) NOT NULL default '',
 162   `charset` varchar(15) NOT NULL default '',
 163   `direction` char(3) NOT NULL default '',
 164   `filename` varchar(255) NOT NULL default '',
 165   `default` int(2) unsigned NOT NULL default '0',
 166   `userselect` int(2) unsigned NOT NULL default '0',
 167   `debug` int(2) unsigned NOT NULL default '0',
 168   PRIMARY KEY  (`languageid`),
 169   UNIQUE KEY `languagecode` (`languagecode`)
 170 ) ENGINE=MyISAM;
 171 ";
 172
 173 $query['localization'] = "
 174 CREATE TABLE `localization` (
 175   `localid` int(10) unsigned NOT NULL auto_increment,
 176   `localkey` mediumtext NOT NULL,
 177   `localtext` mediumtext NOT NULL,
 178   `languageid` int(10) unsigned NOT NULL default '0',
 179   PRIMARY KEY  (`localid`)
 180 ) ENGINE=MyISAM;
 181 ";
 182
 183 $query['permission'] = "
 184 CREATE TABLE `permission` (
 185   `usergroupid` int(10) unsigned NOT NULL default '0',
 186   `productid` int(10) unsigned NOT NULL default '0',
 187   `mask` int(5) NOT NULL default '0',
 188   PRIMARY KEY  (`usergroupid`,`productid`)
 189 ) ENGINE=MyISAM;
 190 ";
 191
 192 $query['priority'] = "
 193 CREATE TABLE `priority` (
 194   `priorityid` int(10) unsigned NOT NULL auto_increment,
 195   `priority` varchar(255) NOT NULL default '',
 196   `displayorder` int(10) unsigned NOT NULL default '0',
 197   PRIMARY KEY  (`priorityid`)
 198 ) ENGINE=MyISAM;
 199 ";
 200
 201 $query['product'] = "
 202 CREATE TABLE `product` (
 203   `productid` int(10) unsigned NOT NULL auto_increment,
 204   `componentmother` int(10) unsigned NOT NULL default '0',
 205   `shortname` varchar(255) NOT NULL default '',
 206   `displayorder` int(10) unsigned NOT NULL default '0',
 207   `title` varchar(255) NOT NULL default '',
 208   `description` mediumtext NOT NULL,
 209   PRIMARY KEY  (`productid`)
 210 ) ENGINE=MyISAM;
 211 ";
 212
 213 $query['resolution'] = "
 214 CREATE TABLE `resolution` (
 215   `resolutionid` int(10) unsigned NOT NULL auto_increment,
 216   `resolution` varchar(255) NOT NULL default '',
 217   `displayorder` int(10) unsigned NOT NULL default '0',
 218   PRIMARY KEY  (`resolutionid`)
 219 ) ENGINE=MyISAM;
 220 ";
 221
 222 $query['search'] = "
 223 CREATE TABLE `search` (
 224   `userid` int(10) unsigned NOT NULL default '0',
 225   `dateline` int(20) unsigned NOT NULL default '0',
 226   `query` mediumtext NOT NULL,
 227   `ids` mediumtext NOT NULL,
 228   `orderby` mediumtext NOT NULL,
 229   `hilight` varchar(255) NOT NULL default '',
 230   PRIMARY KEY  (`userid`)
 231 ) ENGINE=MyISAM;
 232 ";
 233
 234 $query['setting'] = "
 235 CREATE TABLE `setting` (
 236   `varname` varchar(255) NOT NULL default '',
 237   `value` mediumtext NOT NULL,
 238   PRIMARY KEY  (`varname`)
 239 ) ENGINE=MyISAM;
 240 ";
 241
 242 $query['severity'] = "
 243 CREATE TABLE `severity` (
 244   `severityid` int(10) unsigned NOT NULL auto_increment,
 245   `severity` varchar(255) NOT NULL default '',
 246   `displayorder` int(10) unsigned NOT NULL default '0',
 247   PRIMARY KEY  (`severityid`)
 248 ) ENGINE=MyISAM;
 249 ";
 250
 251 $query['status'] = "
 252 CREATE TABLE `status` (
 253   `statusid` int(10) unsigned NOT NULL auto_increment,
 254   `status` varchar(255) NOT NULL default '',
 255   `displayorder` int(10) unsigned NOT NULL default '0',
 256   `color` varchar(10) NOT NULL default '',
 257   PRIMARY KEY  (`statusid`)
 258 ) ENGINE=MyISAM;
 259 ";
 260
 261 $query['user'] = "
 262 CREATE TABLE `user` (
 263   `userid` int(10) unsigned NOT NULL auto_increment,
 264   `email` varchar(255) NOT NULL default '',
 265   `displayname` varchar(255) NOT NULL default '',
 266   `usergroupid` int(10) unsigned NOT NULL default '0',
 267   `password` varchar(32) NOT NULL default '',
 268   `salt` varchar(15) NOT NULL default '',
 269   `authkey` varchar(65) NOT NULL default '',
 270   `showemail` int(2) unsigned NOT NULL default '0',
 271   `showcolours` int(2) unsigned NOT NULL default '0',
 272   `languageid` int(10) unsigned NOT NULL default '0',
 273   `timezone` int(4) NOT NULL default '0',
 274   PRIMARY KEY  (`userid`)
 275 ) ENGINE=MyISAM;
 276 ";
 277
 278 $query['useractivation'] = "
 279 CREATE TABLE `useractivation` (
 280   `activator` varchar(25) NOT NULL default '',
 281   `userid` int(10) unsigned NOT NULL default '0',
 282   `dateline` int(10) unsigned NOT NULL default '0',
 283   `usergroupid` int(10) unsigned NOT NULL default '0',
 284   PRIMARY KEY  (`activator`)
 285 ) ENGINE=MyISAM;
 286 ";
 287
 288 $query['usergroup'] = "
 289 CREATE TABLE `usergroup` (
 290   `usergroupid` int(10) unsigned NOT NULL auto_increment,
 291   `title` varchar(255) NOT NULL default '',
 292   `displaytitle` varchar(255) NOT NULL default '',
 293   `opentag` varchar(255) NOT NULL default '',
 294   `closetag` varchar(255) NOT NULL default '',
 295   `permissions` int(10) unsigned NOT NULL default '0',
 296   PRIMARY KEY  (`usergroupid`)
 297 ) ENGINE=MyISAM;
 298 ";
 299
 300 $query['version'] = "
 301 CREATE TABLE `version` (
 302   `versionid` int(10) unsigned NOT NULL auto_increment,
 303   `productid` int(10) unsigned NOT NULL default '0',
 304   `version` varchar(255) NOT NULL default '',
 305   `displayorder` int(10) unsigned NOT NULL default '0',
 306   PRIMARY KEY  (`versionid`)
 307 ) ENGINE=MyISAM;
 308 ";
 309
 310 $query['vote'] = "
 311 CREATE TABLE `vote` (
 312   `bugid` int(10) unsigned NOT NULL default '0',
 313   `userids` mediumtext NOT NULL,
 314   `votefor` int(10) unsigned NOT NULL default '0',
 315   `voteagainst` int(10) unsigned NOT NULL default '0',
 316   PRIMARY KEY  (`bugid`)
 317 ) ENGINE=MyISAM;
 318 ";
 319
 320 /*=====================================================================*\
 321 || ###################################################################
 322 || # $HeadURL$
 323 || # $Id$
 324 || ###################################################################
 325 \*=====================================================================*/
 326 ?>