2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Blue Static
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.
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
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 \*=====================================================================*/
22 $query['attachment'] = "
23 CREATE TABLE " . TABLE_PREFIX
. "attachment
25 attachmentid int unsigned NOT NULL AUTO_INCREMENT,
26 bugid int unsigned NOT NULL,
27 filename varchar(255) NOT NULL,
28 mimetype varchar(255) NOT NULL,
29 filesize bigint unsigned NOT NULL,
30 attachment blob NOT NULL,
31 description varchar(255) NOT NULL,
32 dateline bigint unsigned NOT NULL,
33 userid int unsigned NOT NULL,
34 obsolete bool unsigned NOT NULL,
35 PRIMARY KEY (attachmentid)
38 $query['autoaction'] = "
39 CREATE TABLE " . TABLE_PREFIX
. "autoaction
41 actionid int unsigned NOT NULL AUTO_INCREMENT,
42 name varchar(255) NOT NULL,
43 description text NOT NULL,
44 fieldchanges text NOT NULL,
45 comment text NOT NULL,
46 PRIMARY KEY (actionid)
50 CREATE TABLE " . TABLE_PREFIX
. "bug
52 bugid int unsigned NOT NULL AUTO_INCREMENT,
53 userid int unsigned NOT NULL,
54 dateline bigint unsigned NOT NULL,
55 product int unsigned NOT NULL,
56 component int unsigned NOT NULL,
57 version int unsigned NOT NULL,
58 summary varchar(255) NOT NULL,
59 priority int unsigned NOT NULL,
60 severity int unsigned NOT NULL,
61 status int unsigned NOT NULL,
62 resolution int unsigned NOT NULL,
63 assignedto int unsigned NOT NULL,
64 duplicateof int unsigned NOT NULL,
65 dependency text NOT NULL,
66 hidden smallint unsigned NOT NULL,
67 initialreport int unsigned NOT NULL,
68 lastposttime bigint unsigned NOT NULL,
69 lastpostby int unsigned NOT NULL,
70 hiddenlastposttime int unsigned NOT NULL,
71 hiddenlastpostby int unsigned NOT NULL,
72 username varchar(255) NOT NULL,
73 lastpostbyname varchar(255) NOT NULL,
74 hiddenlastpostbyname varchar(255) NOT NULL,
76 FULLTEXT KEY summary (summary)
79 $query['bugfield'] = "
80 CREATE TABLE " . TABLE_PREFIX
. "bugfield
82 fieldid int unsigned NOT NULL AUTO_INCREMENT,
83 name varchar(255) NOT NULL,
84 description text NOT NULL,
85 type varchar(50) NOT NULL,
86 selects text NOT NULL,
87 required smallint NOT NULL,
88 cansearch smallint NOT NULL,
89 regexmatch text NOT NULL,
90 defaultvalue text NOT NULL,
91 usedefault smallint NOT NULL,
92 maxlength smallint unsigned NOT NULL,
96 $query['bugfieldpermission'] = "
97 CREATE TABLE " . TABLE_PREFIX
. "bugfieldpermission
99 usergroupid int unsigned NOT NULL,
100 fieldid int unsigned NOT NULL,
101 mask smallint unsigned NOT NULL,
102 PRIMARY KEY (usergroupid, fieldid)
105 $query['bugvaluefill'] = "
106 CREATE TABLE " . TABLE_PREFIX
. "bugvaluefill
108 bugid int unsigned NOT NULL,
115 $query['comment'] = "
116 CREATE TABLE " . TABLE_PREFIX
. "comment
118 commentid int unsigned NOT NULL AUTO_INCREMENT,
119 bugid int unsigned NOT NULL,
120 userid int unsigned NOT NULL,
121 dateline bigint unsigned NOT NULL,
122 comment text NOT NULL,
123 comment_parsed text NOT NULL,
124 hidden smallint unsigned NOT NULL,
125 PRIMARY KEY (commentid),
126 FULLTEXT KEY comment (comment)
129 $query['datastore'] = "
130 CREATE TABLE " . TABLE_PREFIX
. "datastore
132 title varchar(255) NOT NULL,
137 $query['favourite'] = "
138 CREATE TABLE " . TABLE_PREFIX
. "favourite
140 userid int unsigned NOT NULL,
141 bugid int unsigned NOT NULL,
142 PRIMARY KEY (userid, bugid)
145 $query['fieldhelp'] = "
146 CREATE TABLE " . TABLE_PREFIX
. "fieldhelp
148 keystring varchar(255) NOT NULL,
149 title varchar(255) NOT NULL,
151 PRIMARY KEY (keystring)
154 $query['history'] = "
155 CREATE TABLE " . TABLE_PREFIX
. "history
157 historyid bigint unsigned NOT NULL AUTO_INCREMENT,
158 bugid int unsigned NOT NULL,
159 attachmentid int unsigned NOT NULL,
160 commentid int unsigned NOT NULL,
161 dateline bigint unsigned NOT NULL,
162 userid int unsigned NOT NULL,
163 field varchar(255) NOT NULL,
164 original text NOT NULL,
165 changed text NOT NULL,
166 PRIMARY KEY (historyid)
169 $query['language'] = "
170 CREATE TABLE " . TABLE_PREFIX
. "language
172 languageid int unsigned NOT NULL AUTO_INCREMENT,
173 title varchar(255) NOT NULL,
174 languagecode varchar(5) NOT NULL,
175 charset varchar(15) NOT NULL,
176 direction char(3) NOT NULL,
177 filename varchar(255) NOT NULL,
178 userselect smallint unsigned NOT NULL,
179 debug smallint unsigned NOT NULL,
180 PRIMARY KEY (languageid),
181 UNIQUE KEY languagecode (languagecode)
184 $query['localization'] = "
185 CREATE TABLE " . TABLE_PREFIX
. "localization
187 localid int unsigned NOT NULL AUTO_INCREMENT,
188 localkey text NOT NULL,
189 localtext text NOT NULL,
190 languageid int unsigned NOT NULL,
191 PRIMARY KEY (localid)
194 $query['permission'] = "
195 CREATE TABLE " . TABLE_PREFIX
. "permission
197 usergroupid int unsigned NOT NULL,
198 productid int unsigned NOT NULL,
199 mask smallint NOT NULL,
200 PRIMARY KEY (usergroupid, productid)
203 $query['priority'] = "
204 CREATE TABLE " . TABLE_PREFIX
. "priority
206 priorityid int unsigned NOT NULL AUTO_INCREMENT,
207 priority varchar(255) NOT NULL,
208 displayorder int unsigned NOT NULL,
209 PRIMARY KEY (priorityid)
212 $query['product'] = "
213 CREATE TABLE " . TABLE_PREFIX
. "product
215 productid int unsigned NOT NULL AUTO_INCREMENT,
216 componentmother int unsigned NOT NULL,
217 displayorder int unsigned NOT NULL,
218 title varchar(255) NOT NULL,
219 description text NOT NULL,
220 PRIMARY KEY (productid)
223 $query['resolution'] = "
224 CREATE TABLE " . TABLE_PREFIX
. "resolution
226 resolutionid int unsigned NOT NULL AUTO_INCREMENT,
227 resolution varchar(255) NOT NULL,
228 displayorder int unsigned NOT NULL,
229 PRIMARY KEY (resolutionid)
233 CREATE TABLE " . TABLE_PREFIX
. "search
235 userid int unsigned NOT NULL,
236 dateline bigint unsigned NOT NULL,
239 orderby text NOT NULL,
240 hilight varchar(255) NOT NULL,
241 resultcount int NULL,
245 $query['setting'] = "
246 CREATE TABLE " . TABLE_PREFIX
. "setting
248 varname varchar(255) NOT NULL,
250 PRIMARY KEY (varname)
253 $query['severity'] = "
254 CREATE TABLE " . TABLE_PREFIX
. "severity
256 severityid int unsigned NOT NULL AUTO_INCREMENT,
257 severity varchar(255) NOT NULL,
258 displayorder int unsigned NOT NULL,
259 PRIMARY KEY (severityid)
263 CREATE TABLE " . TABLE_PREFIX
. "status
265 statusid int unsigned NOT NULL AUTO_INCREMENT,
266 status varchar(255) NOT NULL,
267 displayorder int unsigned NOT NULL,
268 color varchar(10) NOT NULL,
269 PRIMARY KEY (statusid)
273 CREATE TABLE " . TABLE_PREFIX
. "user
275 userid int unsigned NOT NULL AUTO_INCREMENT,
276 email varchar(255) NOT NULL,
277 displayname varchar(255) NOT NULL,
278 usergroupid int unsigned NOT NULL,
279 password varchar(32) NOT NULL,
280 salt varchar(15) NOT NULL,
281 authkey varchar(65) NOT NULL,
282 showemail smallint unsigned NOT NULL,
283 showcolours smallint unsigned NOT NULL,
284 languageid int unsigned NOT NULL,
285 timezone smallint NOT NULL,
286 usedst bool NOT NULL,
287 hidestatuses text NOT NULL,
288 defaultsortkey varchar(50) NULL,
289 defaultsortas varchar(10) NULL,
293 $query['useractivation'] = "
294 CREATE TABLE " . TABLE_PREFIX
. "useractivation
296 activator varchar(25) NOT NULL,
297 userid int unsigned NOT NULL,
298 dateline int unsigned NOT NULL,
299 usergroupid int unsigned NOT NULL,
300 PRIMARY KEY (activator)
303 $query['useremail'] = "
304 CREATE TABLE " . TABLE_PREFIX
. "useremail
306 userid int unsigned NOT NULL,
307 mask int unsigned NOT NULL,
308 relation int unsigned NOT NULL
311 $query['usergroup'] = "
312 CREATE TABLE " . TABLE_PREFIX
. "usergroup
314 usergroupid int unsigned NOT NULL AUTO_INCREMENT,
315 title varchar(255) NOT NULL,
316 displaytitle varchar(255) NOT NULL,
317 permissions int unsigned NOT NULL,
318 PRIMARY KEY (usergroupid)
321 $query['version'] = "
322 CREATE TABLE " . TABLE_PREFIX
. "version
324 versionid int unsigned NOT NULL AUTO_INCREMENT,
325 productid int unsigned NOT NULL,
326 version varchar(255) NOT NULL,
327 displayorder int unsigned NOT NULL,
328 PRIMARY KEY (versionid)
332 CREATE TABLE " . TABLE_PREFIX
. "vote
334 bugid int unsigned NOT NULL,
335 userids text NOT NULL,
336 votefor int unsigned NOT NULL,
337 voteagainst int unsigned NOT NULL,
341 /*=====================================================================*\
342 || ###################################################################
345 || ###################################################################
346 \*=====================================================================*/