3 CREATE TABLE `attachment`
(
4 `attachmentid`
int(10) unsigned
NOT NULL auto_increment
,
5 `bugid`
int(10) unsigned
NOT NULL default '0',
6 `filename`
varchar(255) NOT NULL default '',
7 `mimetype`
varchar(255) NOT NULL default '',
8 `filesize`
int(20) unsigned
NOT NULL default '0',
9 `attachment` mediumblob
NOT NULL,
10 `description`
varchar(255) NOT NULL default '',
11 `dateline`
int(20) unsigned
NOT NULL default '0',
12 `userid`
int(10) unsigned
NOT NULL default '0',
13 `obsolete`
int(1) unsigned
NOT NULL default '0',
14 PRIMARY KEY (`attachmentid`
)
17 CREATE TABLE `autoaction`
(
18 `actionid`
int(10) unsigned
NOT NULL auto_increment
,
19 `
name`
varchar(255) NOT NULL default '',
20 `description` mediumtext
NOT NULL,
21 `fieldchanges` mediumtext
NOT NULL,
22 `
comment` mediumtext
NOT NULL,
23 PRIMARY KEY (`actionid`
)
27 `bugid`
int(10) unsigned
NOT NULL auto_increment
,
28 `userid`
int(10) unsigned
NOT NULL default '0',
29 `dateline`
int(20) unsigned
NOT NULL default '0',
30 `productid`
int(10) unsigned
NOT NULL default '0',
31 `componentid`
int(10) unsigned
NOT NULL default '0',
32 `versionid`
int(10) unsigned
NOT NULL default '0',
33 `summary`
varchar(255) NOT NULL default '',
34 `priority`
int(10) unsigned
NOT NULL default '0',
35 `severity`
int(10) unsigned
NOT NULL default '0',
36 `status`
int(10) unsigned
NOT NULL default '0',
37 `resolution`
int(10) unsigned
NOT NULL default '0',
38 `assignedto`
int(10) unsigned
NOT NULL default '0',
39 `duplicateof`
int(10) unsigned
NOT NULL default '0',
40 `dependency` mediumtext
NOT NULL,
41 `hidden`
int(2) unsigned
NOT NULL default '0',
42 `initialreport`
int(10) unsigned
NOT NULL default '0',
43 `lastposttime`
int(20) unsigned
NOT NULL default '0',
44 `lastpostby`
int(10) unsigned
NOT NULL default '0',
45 `hiddenlastposttime`
int(10) unsigned
NOT NULL default '0',
46 `hiddenlastpostby`
int(10) unsigned
NOT NULL default '0',
47 PRIMARY KEY (`bugid`
),
48 FULLTEXT
KEY `summary`
(`summary`
)
51 CREATE TABLE `bugfield`
(
52 `fieldid`
int(10) unsigned
NOT NULL auto_increment
,
53 `
name`
varchar(255) NOT NULL default '',
54 `description` mediumtext
NOT NULL,
55 `
type`
varchar(50) NOT NULL default '',
56 `selects` mediumtext
NOT NULL,
57 `required`
int(2) NOT NULL default '0',
58 `cansearch`
int(2) NOT NULL default '0',
59 `regexmatch` mediumtext
NOT NULL,
60 `defaultvalue` mediumtext
NOT NULL,
61 `usedefault`
int(2) NOT NULL default '0',
62 `maxlength`
int(5) unsigned
NOT NULL default '0',
63 PRIMARY KEY (`fieldid`
)
66 CREATE TABLE `bugfieldpermission`
(
67 `usergroupid`
int(10) unsigned
NOT NULL default '0',
68 `fieldid`
int(10) unsigned
NOT NULL default '0',
69 `mask`
int(5) unsigned
NOT NULL default '0',
70 PRIMARY KEY (`usergroupid`
,`fieldid`
)
73 CREATE TABLE `bugvaluefill`
(
74 `bugid`
int(10) unsigned
NOT NULL default '0',
81 CREATE TABLE `
comment`
(
82 `commentid`
int(10) unsigned
NOT NULL auto_increment
,
83 `bugid`
int(10) unsigned
NOT NULL default '0',
84 `userid`
int(10) unsigned
NOT NULL default '0',
85 `dateline`
int(20) unsigned
NOT NULL default '0',
86 `
comment` mediumtext
NOT NULL,
87 `comment_parsed` mediumtext
NOT NULL,
88 `hidden`
int(2) unsigned
NOT NULL default '0',
89 PRIMARY KEY (`commentid`
),
90 FULLTEXT
KEY `
comment`
(`
comment`
)
93 CREATE TABLE `datastore`
(
94 `title`
varchar(255) NOT NULL default '',
95 `
data` mediumtext
NOT NULL,
99 CREATE TABLE `dependency`
(
100 `dependencyid`
int(10) unsigned
NOT NULL auto_increment
,
101 `bugid`
int(10) unsigned
NOT NULL default '0',
102 `dependson`
int(10) unsigned
NOT NULL default '0',
103 PRIMARY KEY (`dependencyid`
)
106 CREATE TABLE `favourite`
(
107 `userid`
int(10) unsigned
NOT NULL default '0',
108 `bugid`
int(10) unsigned
NOT NULL default '0',
109 PRIMARY KEY (`userid`
,`bugid`
)
112 CREATE TABLE `history`
(
113 `historyid`
int(20) unsigned
NOT NULL auto_increment
,
114 `bugid`
int(10) unsigned
NOT NULL default '0',
115 `attachmentid`
int(10) unsigned
NOT NULL default '0',
116 `commentid`
int(10) unsigned
NOT NULL default '0',
117 `dateline`
int(20) unsigned
NOT NULL default '0',
118 `userid`
int(10) unsigned
NOT NULL default '0',
119 `field`
varchar(255) NOT NULL default '',
120 `original` mediumtext
NOT NULL,
121 `changed` mediumtext
NOT NULL,
122 PRIMARY KEY (`historyid`
)
125 CREATE TABLE `
language`
(
126 `languageid`
int(10) unsigned
NOT NULL auto_increment
,
127 `title`
varchar(255) NOT NULL default '',
128 `languagecode`
varchar(5) NOT NULL default '',
129 `charset`
varchar(15) NOT NULL default '',
130 `direction`
char(3) NOT NULL default '',
131 `filename`
varchar(255) NOT NULL default '',
132 `
default`
int(2) unsigned
NOT NULL default '0',
133 `userselect`
int(2) unsigned
NOT NULL default '0',
134 `debug`
int(2) unsigned
NOT NULL default '0',
135 PRIMARY KEY (`languageid`
),
136 UNIQUE KEY `languagecode`
(`languagecode`
)
139 CREATE TABLE `localization`
(
140 `localid`
int(10) unsigned
NOT NULL auto_increment
,
141 `localkey` mediumtext
NOT NULL,
142 `localtext` mediumtext
NOT NULL,
143 `languageid`
int(10) unsigned
NOT NULL default '0',
144 PRIMARY KEY (`localid`
)
147 CREATE TABLE `
permission`
(
148 `usergroupid`
int(10) unsigned
NOT NULL default '0',
149 `productid`
int(10) unsigned
NOT NULL default '0',
150 `mask`
int(5) NOT NULL default '0',
151 PRIMARY KEY (`usergroupid`
,`productid`
)
154 CREATE TABLE `priority`
(
155 `priorityid`
int(10) unsigned
NOT NULL auto_increment
,
156 `priority`
varchar(255) NOT NULL default '',
157 `displayorder`
int(10) unsigned
NOT NULL default '0',
158 PRIMARY KEY (`priorityid`
)
161 CREATE TABLE `product`
(
162 `productid`
int(10) unsigned
NOT NULL auto_increment
,
163 `componentmother`
int(10) unsigned
NOT NULL default '0',
164 `shortname`
varchar(255) NOT NULL default '',
165 `displayorder`
int(10) unsigned
NOT NULL default '0',
166 `title`
varchar(255) NOT NULL default '',
167 `description` mediumtext
NOT NULL,
168 PRIMARY KEY (`productid`
)
171 CREATE TABLE `resolution`
(
172 `resolutionid`
int(10) unsigned
NOT NULL auto_increment
,
173 `resolution`
varchar(255) NOT NULL default '',
174 `displayorder`
int(10) unsigned
NOT NULL default '0',
175 PRIMARY KEY (`resolutionid`
)
178 CREATE TABLE `
search`
(
179 `userid`
int(10) unsigned
NOT NULL default '0',
180 `dateline`
int(20) unsigned
NOT NULL default '0',
181 `query` mediumtext
NOT NULL,
182 `ids` mediumtext
NOT NULL,
183 `orderby` mediumtext
NOT NULL,
184 `hilight`
varchar(255) NOT NULL default '',
185 PRIMARY KEY (`userid`
)
188 CREATE TABLE `setting`
(
189 `varname`
varchar(255) NOT NULL default '',
190 `
value` mediumtext
NOT NULL,
191 PRIMARY KEY (`varname`
)
194 CREATE TABLE `severity`
(
195 `severityid`
int(10) unsigned
NOT NULL auto_increment
,
196 `severity`
varchar(255) NOT NULL default '',
197 `displayorder`
int(10) unsigned
NOT NULL default '0',
198 PRIMARY KEY (`severityid`
)
201 CREATE TABLE `status`
(
202 `statusid`
int(10) unsigned
NOT NULL auto_increment
,
203 `status`
varchar(255) NOT NULL default '',
204 `displayorder`
int(10) unsigned
NOT NULL default '0',
205 `color`
varchar(10) NOT NULL default '',
206 PRIMARY KEY (`statusid`
)
209 CREATE TABLE `
user`
(
210 `userid`
int(10) unsigned
NOT NULL auto_increment
,
211 `email`
varchar(255) NOT NULL default '',
212 `displayname`
varchar(255) NOT NULL default '',
213 `usergroupid`
int(10) unsigned
NOT NULL default '0',
214 `
password`
varchar(32) NOT NULL default '',
215 `salt`
varchar(15) NOT NULL default '',
216 `authkey`
varchar(65) NOT NULL default '',
217 `showemail`
int(2) unsigned
NOT NULL default '0',
218 `showcolours`
int(2) unsigned
NOT NULL default '0',
219 `languageid`
int(10) unsigned
NOT NULL default '0',
220 `timezone`
int(4) NOT NULL default '0',
221 PRIMARY KEY (`userid`
)
224 CREATE TABLE `useractivation`
(
225 `activator`
varchar(25) NOT NULL default '',
226 `userid`
int(10) unsigned
NOT NULL default '0',
227 `dateline`
int(10) unsigned
NOT NULL default '0',
228 `usergroupid`
int(10) unsigned
NOT NULL default '0',
229 PRIMARY KEY (`activator`
)
232 CREATE TABLE `usergroup`
(
233 `usergroupid`
int(10) unsigned
NOT NULL auto_increment
,
234 `title`
varchar(255) NOT NULL default '',
235 `displaytitle`
varchar(255) NOT NULL default '',
236 `opentag`
varchar(255) NOT NULL default '',
237 `closetag`
varchar(255) NOT NULL default '',
238 `permissions`
int(10) unsigned
NOT NULL default '0',
239 PRIMARY KEY (`usergroupid`
)
242 CREATE TABLE `
version`
(
243 `versionid`
int(10) unsigned
NOT NULL auto_increment
,
244 `productid`
int(10) unsigned
NOT NULL default '0',
245 `
version`
varchar(255) NOT NULL default '',
246 `displayorder`
int(10) unsigned
NOT NULL default '0',
247 PRIMARY KEY (`versionid`
)
250 CREATE TABLE `vote`
(
251 `bugid`
int(10) unsigned
NOT NULL default '0',
252 `userids` mediumtext
NOT NULL,
253 `votefor`
int(10) unsigned
NOT NULL default '0',
254 `voteagainst`
int(10) unsigned
NOT NULL default '0',
255 PRIMARY KEY (`bugid`
)