]>
src.bluestatic.org Git - bugdar.git/blob - install/schema.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 \*=====================================================================*/
13 $query['attachment'] = "
14 CREATE TABLE " . TABLE_PREFIX
. "attachment
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)
29 $query['autoaction'] = "
30 CREATE TABLE " . TABLE_PREFIX
. "autoaction
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)
41 CREATE TABLE " . TABLE_PREFIX
. "bug
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,
64 FULLTEXT KEY summary (summary)
67 $query['bugfield'] = "
68 CREATE TABLE " . TABLE_PREFIX
. "bugfield
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,
84 $query['bugfieldpermission'] = "
85 CREATE TABLE " . TABLE_PREFIX
. "bugfieldpermission
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)
93 $query['bugvaluefill'] = "
94 CREATE TABLE " . TABLE_PREFIX
. "bugvaluefill
96 bugid int(10) unsigned NOT NULL,
100 $query['comment'] = "
101 CREATE TABLE " . TABLE_PREFIX
. "comment
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)
114 $query['datastore'] = "
115 CREATE TABLE " . TABLE_PREFIX
. "datastore
117 title varchar(255) NOT NULL,
118 data mediumtext NOT NULL,
122 $query['dependency'] = "
123 CREATE TABLE " . TABLE_PREFIX
. "dependency
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)
131 $query['favourite'] = "
132 CREATE TABLE " . TABLE_PREFIX
. "favourite
134 userid int(10) unsigned NOT NULL,
135 bugid int(10) unsigned NOT NULL,
136 PRIMARY KEY (userid, bugid)
139 $query['fieldhelp'] = "
140 CREATE TABLE " . TABLE_PREFIX
. "fieldhelp
142 keystring varchar(255) NOT NULL,
143 title varchar(255) NOT NULL,
144 body mediumtext NOT NULL,
145 PRIMARY KEY (keystring)
148 $query['history'] = "
149 CREATE TABLE " . TABLE_PREFIX
. "history
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)
163 $query['language'] = "
164 CREATE TABLE " . TABLE_PREFIX
. "language
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)
178 $query['localization'] = "
179 CREATE TABLE " . TABLE_PREFIX
. "localization
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)
188 $query['permission'] = "
189 CREATE TABLE " . TABLE_PREFIX
. "permission
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)
197 $query['priority'] = "
198 CREATE TABLE " . TABLE_PREFIX
. "priority
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)
206 $query['product'] = "
207 CREATE TABLE " . TABLE_PREFIX
. "product
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)
217 $query['resolution'] = "
218 CREATE TABLE " . TABLE_PREFIX
. "resolution
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)
227 CREATE TABLE " . TABLE_PREFIX
. "search
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,
238 $query['setting'] = "
239 CREATE TABLE " . TABLE_PREFIX
. "setting
241 varname varchar(255) NOT NULL,
242 value mediumtext NOT NULL,
243 PRIMARY KEY (varname)
246 $query['severity'] = "
247 CREATE TABLE " . TABLE_PREFIX
. "severity
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)
256 CREATE TABLE " . TABLE_PREFIX
. "status
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)
266 CREATE TABLE " . TABLE_PREFIX
. "user
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,
282 $query['useractivation'] = "
283 CREATE TABLE " . TABLE_PREFIX
. "useractivation
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)
292 $query['usergroup'] = "
293 CREATE TABLE " . TABLE_PREFIX
. "usergroup
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)
302 $query['version'] = "
303 CREATE TABLE " . TABLE_PREFIX
. "version
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)
313 CREATE TABLE " . TABLE_PREFIX
. "vote
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,
322 /*=====================================================================*\
323 || ###################################################################
326 || ###################################################################
327 \*=====================================================================*/