docs/schema_changes.sql

   1 ## SVN $Id$
   2
   3 ALTER TABLE bug ADD username varchar(255) NOT NULL;
   4
   5 ALTER TABLE bug ADD lastpostbyname varchar(255) NOT NULL;
   6
   7 ALTER TABLE bug ADD hiddenlastpostbyname varchar(255) NOT NULL;
   8
   9 CREATE TABLE useremail
  10 (
  11         userid int unsigned not null,
  12         relation int unsigned not null,
  13         mask int unsigned not null
  14 );
  15
  16 DROP TABLE dependency;
  17
  18 ALTER TABLE user ADD usedst BOOL NOT NULL;
  19
  20 ALTER TABLE user ADD hidestatuses mediumtext NOT NULL;
  21
  22 ALTER TABLE bug CHANGE productid product INT(10) UNSIGNED NOT NULL DEFAULT '0';
  23
  24 ALTER TABLE bug CHANGE componentid component INT(10) UNSIGNED NOT NULL DEFAULT '0';
  25
  26 ALTER TABLE bug CHANGE versionid version INT(10) UNSIGNED NOT NULL DEFAULT '0';
  27
  28 DELETE FROM search;
  29
  30 ALTER TABLE user ADD defaultsortkey varchar(50) NULL;
  31
  32 ALTER TABLE user ADD defaultsortas varchar(10) NULL;