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 );
  18
  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`)
  30 );
  31
  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`)
  46 );
  47
  48 CREATE TABLE `bugvaluefill` (
  49   `bugid` INT(10) UNSIGNED NOT NULL,
  50   PRIMARY KEY (`bugid`)
  51 );
  52
  53 ALTER TABLE `bug` ADD `hidden` INT(2) UNSIGNED NOT NULL AFTER `assignedto`;
  54
  55 ALTER TABLE `comment` ADD `hidden` INT(2) UNSIGNED NOT NULL;