install/schema.php

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