4 `bugid`
int(10) unsigned
NOT NULL auto_increment
,
5 `userid`
int(10) unsigned
NOT NULL default '0',
6 `dateline`
int(20) unsigned
NOT NULL default '0',
7 `productid`
int(10) unsigned
NOT NULL default '0',
8 `componentid`
int(10) unsigned
NOT NULL default '0',
9 `versionid`
int(10) unsigned
NOT NULL default '0',
10 `summary`
varchar(255) NOT NULL default '',
11 `priority`
int(10) unsigned
NOT NULL default '0',
12 `severity`
int(10) unsigned
NOT NULL default '0',
13 `status`
int(10) unsigned
NOT NULL default '0',
14 `resolution`
int(10) unsigned
NOT NULL default '0',
15 `assignedto`
int(10) unsigned
NOT NULL default '0',
16 `initialreport`
int(10) unsigned
NOT NULL default '0',
17 `lastposttime`
int(20) unsigned
NOT NULL default '0',
18 `lastpostby`
int(10) unsigned
NOT NULL default '0',
19 PRIMARY KEY (`bugid`
),
20 FULLTEXT
KEY `summary`
(`summary`
)
23 CREATE TABLE `
comment`
(
24 `commentid`
int(10) unsigned
NOT NULL auto_increment
,
25 `bugid`
int(10) unsigned
NOT NULL default '0',
26 `userid`
int(10) unsigned
NOT NULL default '0',
27 `dateline`
int(20) unsigned
NOT NULL default '0',
28 `
comment` mediumtext
NOT NULL,
29 `comment_parsed` mediumtext
NOT NULL,
30 PRIMARY KEY (`commentid`
),
31 FULLTEXT
KEY `
comment`
(`
comment`
)
34 CREATE TABLE `datastore`
(
35 `title`
varchar(255) NOT NULL default '',
36 `
data` mediumtext
NOT NULL,
40 CREATE TABLE `dependency`
(
41 `dependencyid`
int(10) unsigned
NOT NULL auto_increment
,
42 `bugid`
int(10) unsigned
NOT NULL default '0',
43 `dependson`
int(10) unsigned
NOT NULL default '0',
44 PRIMARY KEY (`dependencyid`
)
47 CREATE TABLE `
language`
(
48 `languageid`
int(10) unsigned
NOT NULL auto_increment
,
49 `title`
varchar(255) NOT NULL default '',
50 `languagecode`
varchar(5) NOT NULL default '',
51 `charset`
varchar(15) NOT NULL default '',
52 `direction`
char(3) NOT NULL default '',
53 `
default`
int(2) unsigned
NOT NULL default '0',
54 `userselect`
int(2) unsigned
NOT NULL default '0',
55 `filename`
varchar(30) NOT NULL default '',
56 PRIMARY KEY (`languageid`
),
57 UNIQUE KEY `languagecode`
(`languagecode`
),
58 UNIQUE KEY `filename`
(`filename`
)
61 CREATE TABLE `locale`
(
62 `languageid`
int(10) unsigned
NOT NULL default '0',
63 `varname`
varchar(255) NOT NULL default '',
64 `phrasetext` mediumtext
NOT NULL,
65 KEY `languageid`
(`languageid`
)
68 CREATE TABLE `phrase`
(
69 `varname`
varchar(255) NOT NULL default '',
70 `phrasetext` mediumtext
NOT NULL,
71 `imported`
int(20) unsigned
NOT NULL default '0',
72 UNIQUE KEY `varname`
(`varname`
)
75 CREATE TABLE `priority`
(
76 `priorityid`
int(10) unsigned
NOT NULL auto_increment
,
77 `priority`
varchar(255) NOT NULL default '',
78 `displayorder`
int(10) unsigned
NOT NULL default '0',
79 PRIMARY KEY (`priorityid`
)
82 CREATE TABLE `product`
(
83 `productid`
int(10) unsigned
NOT NULL auto_increment
,
84 `componentmother`
int(10) unsigned
NOT NULL default '0',
85 `shortname`
varchar(255) NOT NULL default '',
86 `displayorder`
int(10) unsigned
NOT NULL default '0',
87 `title`
varchar(255) NOT NULL default '',
88 `description` mediumtext
NOT NULL,
89 PRIMARY KEY (`productid`
)
92 CREATE TABLE `resolution`
(
93 `resolutionid`
int(10) unsigned
NOT NULL auto_increment
,
94 `resolution`
varchar(255) NOT NULL default '',
95 `displayorder`
int(10) unsigned
NOT NULL default '0',
96 PRIMARY KEY (`resolutionid`
)
99 CREATE TABLE `setting`
(
100 `varname`
varchar(255) NOT NULL default '',
101 `
value` mediumtext
NOT NULL,
102 PRIMARY KEY (`varname`
)
105 CREATE TABLE `severity`
(
106 `severityid`
int(10) unsigned
NOT NULL auto_increment
,
107 `severity`
varchar(255) NOT NULL default '',
108 `displayorder`
int(10) unsigned
NOT NULL default '0',
109 PRIMARY KEY (`severityid`
)
112 CREATE TABLE `status`
(
113 `statusid`
int(10) unsigned
NOT NULL auto_increment
,
114 `status`
varchar(255) NOT NULL default '',
115 `displayorder`
int(10) unsigned
NOT NULL default '0',
116 PRIMARY KEY (`statusid`
)
119 CREATE TABLE `templateset`
(
120 `templatesetid`
int(10) unsigned
NOT NULL auto_increment
,
121 `title`
varchar(255) NOT NULL default '',
122 `shortname`
varchar(50) NOT NULL default '',
123 `
default`
int(2) unsigned
NOT NULL default '0',
124 `userselect`
int(2) unsigned
NOT NULL default '0',
125 PRIMARY KEY (`templatesetid`
),
126 UNIQUE KEY `title`
(`title`
)
129 CREATE TABLE `
user`
(
130 `userid`
int(10) unsigned
NOT NULL auto_increment
,
131 `email`
varchar(255) NOT NULL default '',
132 `displayname`
varchar(255) NOT NULL default '',
133 `usergroupid`
int(10) unsigned
NOT NULL default '0',
134 `
password`
varchar(32) NOT NULL default '',
135 `salt`
varchar(15) NOT NULL default '',
136 `authkey`
varchar(65) NOT NULL default '',
137 `showemail`
int(2) unsigned
NOT NULL default '0',
138 `languageid`
int(10) unsigned
NOT NULL default '0',
139 `timezone`
int(4) NOT NULL default '0',
140 PRIMARY KEY (`userid`
)
143 CREATE TABLE `useractivation`
(
144 `activator`
varchar(25) NOT NULL default '',
145 `userid`
int(10) unsigned
NOT NULL default '0',
146 `dateline`
int(10) unsigned
NOT NULL default '0',
147 `usergroupid`
int(10) unsigned
NOT NULL default '0',
148 PRIMARY KEY (`activator`
)
151 CREATE TABLE `usergroup`
(
152 `usergroupid`
int(10) unsigned
NOT NULL auto_increment
,
153 `title`
varchar(255) NOT NULL default '',
154 `displaytitle`
varchar(255) NOT NULL default '',
155 `opentag`
varchar(255) NOT NULL default '',
156 `closetag`
varchar(255) NOT NULL default '',
157 `permissions`
int(10) unsigned
NOT NULL default '0',
158 PRIMARY KEY (`usergroupid`
)
159 ) ENGINE
=MyISAM
DEFAULT PACK_KEYS
=0;
161 CREATE TABLE `
version`
(
162 `versionid`
int(10) unsigned
NOT NULL auto_increment
,
163 `productid`
int(10) unsigned
NOT NULL default '0',
164 `
version`
varchar(255) NOT NULL default '',
165 `displayorder`
int(10) unsigned
NOT NULL default '0',
166 PRIMARY KEY (`versionid`
)