]>
src.bluestatic.org Git - bugdar.git/blob - docs/schema_changes.sql
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`
)