docs/schema_changes.sql

   1 ## SVN $Id$
   2
   3 ALTER TABLE `status` ADD `color` VARCHAR(10) NOT NULL;
   4
   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`)
  17 );