## SVN $Id$

ALTER TABLE `status` ADD `color` VARCHAR(10) NOT NULL;

CREATE TABLE `attachment` (
  `attachmentid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, 
  `bugid` INT(10) UNSIGNED NOT NULL, 
  `filename` VARCHAR(255) NOT NULL, 
  `mimetype` VARCHAR(255) NOT NULL, 
  `filesize` INT(20) UNSIGNED NOT NULL, 
  `attachment` MEDIUMTEXT NOT NULL, 
  `description` VARCHAR(255) NOT NULL, 
  `dateline` INT(20) UNSIGNED NOT NULL, 
  `userid` INT(10) UNSIGNED NOT NULL, 
  `obsolete` INT(1) UNSIGNED NOT NULL,
  PRIMARY KEY (`attachmentid`)
);

CREATE TABLE `history` (
  `historyid` INT(20) UNSIGNED NOT NULL AUTO_INCREMENT, 
  `bugid` INT(10) UNSIGNED NOT NULL, 
  `dateline` INT(20) UNSIGNED NOT NULL, 
  `userid` INT(10) UNSIGNED NOT NULL, 
  `language` VARCHAR(255) NOT NULL, 
  `arguments` MEDIUMTEXT NOT NULL,
  PRIMARY KEY (`historyid`)
);