]>
src.bluestatic.org Git - bugdar.git/blob - install/schema.php
2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Iris Studios, Inc.
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(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)
38 $query['autoaction'] = "
39 CREATE TABLE " . TABLE_PREFIX
. "autoaction
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)
50 CREATE TABLE " . TABLE_PREFIX
. "bug
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,
73 FULLTEXT KEY summary (summary)
76 $query['bugfield'] = "
77 CREATE TABLE " . TABLE_PREFIX
. "bugfield
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,
93 $query['bugfieldpermission'] = "
94 CREATE TABLE " . TABLE_PREFIX
. "bugfieldpermission
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)
102 $query['bugvaluefill'] = "
103 CREATE TABLE " . TABLE_PREFIX
. "bugvaluefill
105 bugid int(10) unsigned NOT NULL,
109 $query['comment'] = "
110 CREATE TABLE " . TABLE_PREFIX
. "comment
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)
123 $query['datastore'] = "
124 CREATE TABLE " . TABLE_PREFIX
. "datastore
126 title varchar(255) NOT NULL,
127 data mediumtext NOT NULL,
131 $query['dependency'] = "
132 CREATE TABLE " . TABLE_PREFIX
. "dependency
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)
140 $query['favourite'] = "
141 CREATE TABLE " . TABLE_PREFIX
. "favourite
143 userid int(10) unsigned NOT NULL,
144 bugid int(10) unsigned NOT NULL,
145 PRIMARY KEY (userid, bugid)
148 $query['fieldhelp'] = "
149 CREATE TABLE " . TABLE_PREFIX
. "fieldhelp
151 keystring varchar(255) NOT NULL,
152 title varchar(255) NOT NULL,
153 body mediumtext NOT NULL,
154 PRIMARY KEY (keystring)
157 $query['history'] = "
158 CREATE TABLE " . TABLE_PREFIX
. "history
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)
172 $query['language'] = "
173 CREATE TABLE " . TABLE_PREFIX
. "language
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)
187 $query['localization'] = "
188 CREATE TABLE " . TABLE_PREFIX
. "localization
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)
197 $query['permission'] = "
198 CREATE TABLE " . TABLE_PREFIX
. "permission
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)
206 $query['priority'] = "
207 CREATE TABLE " . TABLE_PREFIX
. "priority
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)
215 $query['product'] = "
216 CREATE TABLE " . TABLE_PREFIX
. "product
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)
226 $query['resolution'] = "
227 CREATE TABLE " . TABLE_PREFIX
. "resolution
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)
236 CREATE TABLE " . TABLE_PREFIX
. "search
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,
247 $query['setting'] = "
248 CREATE TABLE " . TABLE_PREFIX
. "setting
250 varname varchar(255) NOT NULL,
251 value mediumtext NOT NULL,
252 PRIMARY KEY (varname)
255 $query['severity'] = "
256 CREATE TABLE " . TABLE_PREFIX
. "severity
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)
265 CREATE TABLE " . TABLE_PREFIX
. "status
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)
275 CREATE TABLE " . TABLE_PREFIX
. "user
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,
291 $query['useractivation'] = "
292 CREATE TABLE " . TABLE_PREFIX
. "useractivation
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)
301 $query['usergroup'] = "
302 CREATE TABLE " . TABLE_PREFIX
. "usergroup
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)
311 $query['version'] = "
312 CREATE TABLE " . TABLE_PREFIX
. "version
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)
322 CREATE TABLE " . TABLE_PREFIX
. "vote
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,
331 /*=====================================================================*\
332 || ###################################################################
335 || ###################################################################
336 \*=====================================================================*/