docs/schema_changes.sql

   1 ## SVN $Id$
   2
   3 CREATE TABLE field
   4 (
   5         title varchar(255) NOT NULL,
   6         description varchar(255) NOT NULL,
   7         type varchar(16) NOT NULL,
   8         validator_pattern varchar(255) NOT NULL,
   9         required bool NOT NULL,
  10         default_value varchar(255) NOT NULL,
  11         can_search bool NOT NULL,
  12         color_foreground varchar(6) NOT NULL,
  13         color_background varchar(6) NOT NULL,
  14         PRIMARY KEY (title)
  15 );
  16
  17 CREATE TABLE bugfield2
  18 (
  19         bugid int unsigned NOT NULL,
  20         title varchar(255) NOT NULL,
  21         value varchar(255) NOT NULL,
  22         PRIMARY KEY (bugid, title)
  23 );