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` mediumtext
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 `history`
(
107 `historyid`
int(20) unsigned
NOT NULL auto_increment
,
108 `bugid`
int(10) unsigned
NOT NULL default '0',
109 `dateline`
int(20) unsigned
NOT NULL default '0',
110 `userid`
int(10) unsigned
NOT NULL default '0',
111 `
language`
varchar(255) NOT NULL default '',
112 `arguments` mediumtext
NOT NULL,
113 `field`
varchar(255) NOT NULL default '',
114 `original` mediumtext
NOT NULL,
115 `changed` mediumtext
NOT NULL,
116 PRIMARY KEY (`historyid`
)
119 CREATE TABLE `
language`
(
120 `languageid`
int(10) unsigned
NOT NULL auto_increment
,
121 `title`
varchar(255) NOT NULL default '',
122 `languagecode`
varchar(5) NOT NULL default '',
123 `charset`
varchar(15) NOT NULL default '',
124 `direction`
char(3) NOT NULL default '',
125 `
default`
int(2) unsigned
NOT NULL default '0',
126 `userselect`
int(2) unsigned
NOT NULL default '0',
127 `filename`
varchar(30) NOT NULL default '',
128 PRIMARY KEY (`languageid`
),
129 UNIQUE KEY `languagecode`
(`languagecode`
),
130 UNIQUE KEY `filename`
(`filename`
)
133 CREATE TABLE `locale`
(
134 `languageid`
int(10) unsigned
NOT NULL default '0',
135 `varname`
varchar(255) NOT NULL default '',
136 `phrasetext` mediumtext
NOT NULL,
137 KEY `languageid`
(`languageid`
)
140 CREATE TABLE `phrase`
(
141 `varname`
varchar(255) NOT NULL default '',
142 `phrasetext` mediumtext
NOT NULL,
143 `imported`
int(20) unsigned
NOT NULL default '0',
144 UNIQUE KEY `varname`
(`varname`
)
147 CREATE TABLE `priority`
(
148 `priorityid`
int(10) unsigned
NOT NULL auto_increment
,
149 `priority`
varchar(255) NOT NULL default '',
150 `displayorder`
int(10) unsigned
NOT NULL default '0',
151 PRIMARY KEY (`priorityid`
)
154 CREATE TABLE `product`
(
155 `productid`
int(10) unsigned
NOT NULL auto_increment
,
156 `componentmother`
int(10) unsigned
NOT NULL default '0',
157 `shortname`
varchar(255) NOT NULL default '',
158 `displayorder`
int(10) unsigned
NOT NULL default '0',
159 `title`
varchar(255) NOT NULL default '',
160 `description` mediumtext
NOT NULL,
161 PRIMARY KEY (`productid`
)
164 CREATE TABLE `resolution`
(
165 `resolutionid`
int(10) unsigned
NOT NULL auto_increment
,
166 `resolution`
varchar(255) NOT NULL default '',
167 `displayorder`
int(10) unsigned
NOT NULL default '0',
168 PRIMARY KEY (`resolutionid`
)
171 CREATE TABLE `setting`
(
172 `varname`
varchar(255) NOT NULL default '',
173 `
value` mediumtext
NOT NULL,
174 PRIMARY KEY (`varname`
)
177 CREATE TABLE `severity`
(
178 `severityid`
int(10) unsigned
NOT NULL auto_increment
,
179 `severity`
varchar(255) NOT NULL default '',
180 `displayorder`
int(10) unsigned
NOT NULL default '0',
181 PRIMARY KEY (`severityid`
)
184 CREATE TABLE `status`
(
185 `statusid`
int(10) unsigned
NOT NULL auto_increment
,
186 `status`
varchar(255) NOT NULL default '',
187 `displayorder`
int(10) unsigned
NOT NULL default '0',
188 `color`
varchar(10) NOT NULL default '',
189 PRIMARY KEY (`statusid`
)
192 CREATE TABLE `
user`
(
193 `userid`
int(10) unsigned
NOT NULL auto_increment
,
194 `email`
varchar(255) NOT NULL default '',
195 `displayname`
varchar(255) NOT NULL default '',
196 `usergroupid`
int(10) unsigned
NOT NULL default '0',
197 `
password`
varchar(32) NOT NULL default '',
198 `salt`
varchar(15) NOT NULL default '',
199 `authkey`
varchar(65) NOT NULL default '',
200 `showemail`
int(2) unsigned
NOT NULL default '0',
201 `languageid`
int(10) unsigned
NOT NULL default '0',
202 `timezone`
int(4) NOT NULL default '0',
203 PRIMARY KEY (`userid`
)
206 CREATE TABLE `useractivation`
(
207 `activator`
varchar(25) NOT NULL default '',
208 `userid`
int(10) unsigned
NOT NULL default '0',
209 `dateline`
int(10) unsigned
NOT NULL default '0',
210 `usergroupid`
int(10) unsigned
NOT NULL default '0',
211 PRIMARY KEY (`activator`
)
214 CREATE TABLE `usergroup`
(
215 `usergroupid`
int(10) unsigned
NOT NULL auto_increment
,
216 `title`
varchar(255) NOT NULL default '',
217 `displaytitle`
varchar(255) NOT NULL default '',
218 `opentag`
varchar(255) NOT NULL default '',
219 `closetag`
varchar(255) NOT NULL default '',
220 `permissions`
int(10) unsigned
NOT NULL default '0',
221 PRIMARY KEY (`usergroupid`
)
224 CREATE TABLE `
version`
(
225 `versionid`
int(10) unsigned
NOT NULL auto_increment
,
226 `productid`
int(10) unsigned
NOT NULL default '0',
227 `
version`
varchar(255) NOT NULL default '',
228 `displayorder`
int(10) unsigned
NOT NULL default '0',
229 PRIMARY KEY (`versionid`
)