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