3 ALTER TABLE `status`
ADD `color`
VARCHAR(10) NOT NULL;
5 CREATE TABLE `attachment`
(
6 `attachmentid`
INT(10) UNSIGNED
NOT NULL AUTO_INCREMENT
,
7 `bugid`
INT(10) UNSIGNED
NOT NULL,
8 `filename`
VARCHAR(255) NOT NULL,
9 `mimetype`
VARCHAR(255) NOT NULL,
10 `filesize`
INT(20) UNSIGNED
NOT NULL,
11 `attachment` MEDIUMTEXT
NOT NULL,
12 `description`
VARCHAR(255) NOT NULL,
13 `dateline`
INT(20) UNSIGNED
NOT NULL,
14 `userid`
INT(10) UNSIGNED
NOT NULL,
15 `obsolete`
INT(1) UNSIGNED
NOT NULL,
16 PRIMARY KEY (`attachmentid`
)
19 CREATE TABLE `history`
(
20 `historyid`
INT(20) UNSIGNED
NOT NULL AUTO_INCREMENT
,
21 `bugid`
INT(10) UNSIGNED
NOT NULL,
22 `dateline`
INT(20) UNSIGNED
NOT NULL,
23 `userid`
INT(10) UNSIGNED
NOT NULL,
24 `
language`
VARCHAR(255) NOT NULL,
25 `arguments` MEDIUMTEXT
NOT NULL,
26 `field`
VARCHAR(255) NOT NULL,
27 `original` MEDIUMTEXT
NOT NULL,
28 `changed` MEDIUMTEXT
NOT NULL,
29 PRIMARY KEY (`historyid`
)
32 CREATE TABLE `bugfield`
(
33 `fieldid`
INT(10) UNSIGNED
NOT NULL AUTO_INCREMENT
,
34 `shortname`
VARCHAR(100) NOT NULL,
35 `
name`
VARCHAR(255) NOT NULL,
36 `description` MEDIUMTEXT
NOT NULL,
37 `
type`
VARCHAR(50) NOT NULL,
38 `selects` MEDIUMTEXT
NOT NULL,
39 `required`
INT(2) NOT NULL,
40 `private`
INT(2) NOT NULL,
41 `regexmatch` MEDIUMTEXT
NOT NULL,
42 `defaultvalue` MEDIUMTEXT
NOT NULL,
43 `usedefault`
INT(2) NOT NULL,
44 `maxlength`
INT(5) UNSIGNED
NOT NULL,
45 PRIMARY KEY (`fieldid`
)
48 CREATE TABLE `bugvaluefill`
(
49 `bugid`
INT(10) UNSIGNED
NOT NULL,
53 ALTER TABLE `bug`
ADD `hidden`
INT(2) UNSIGNED
NOT NULL AFTER `assignedto`
;
55 ALTER TABLE `
comment`
ADD `hidden`
INT(2) UNSIGNED
NOT NULL;
57 ALTER TABLE `bug`
ADD `hiddenlastposttime`
INT(10) UNSIGNED
NOT NULL, ADD `hiddenlastpostby`
INT(10) UNSIGNED
NOT NULL;
59 ALTER TABLE `bug`
ADD `duplicateof`
INT(10) UNSIGNED
NOT NULL AFTER `assignedto`
, ADD `dependency` MEDIUMTEXT
NOT NULL AFTER `duplicateof`
;
61 DROP TABLE IF EXISTS `templateset`
;
63 CREATE TABLE `bugfieldpermission`
(
64 `permissionid`
INT(10) UNSIGNED
NOT NULL,
65 `usergroupid`
INT(10) UNSIGNED
NOT NULL,
66 `fieldid`
INT(10) UNSIGNED
NOT NULL,
67 `mask`
INT(5) UNSIGNED
NOT NULL,
68 PRIMARY KEY (`permissionid`
, `fieldid`
)
71 ALTER TABLE `bugfield` CHANGE `private` `cansearch`
INT(2) DEFAULT '0' NOT NULL