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`
)