docs/schema_changes.sql

   1 ## SVN $Id$
   2
   3 CREATE TABLE `favourite` (
   4   `userid` INT(10) UNSIGNED NOT NULL,
   5   `bugid` INT(10) UNSIGNED NOT NULL
   6 );
   7
   8 ALTER TABLE `favourite` ADD PRIMARY KEY (`userid`,`bugid`);
   9
  10 CREATE TABLE `vote` (
  11   `bugid` INT(10) UNSIGNED NOT NULL,
  12   `userids` MEDIUMTEXT NOT NULL,
  13   `votefor` INT(10) UNSIGNED NOT NULL,
  14   `voteagainst` INT(10) UNSIGNED NOT NULL,
  15   PRIMARY KEY (`bugid`)
  16 );
  17
  18 ALTER TABLE `language` DROP `filename`;
  19
  20 CREATE TABLE `search` (
  21   `userid` INT(10) UNSIGNED NOT NULL,
  22   `dateline` INT(20) UNSIGNED NOT NULL,
  23   `query` MEDIUMTEXT NOT NULL,
  24   `ids` MEDIUMTEXT NOT NULL
  25 );
  26
  27 ALTER TABLE `search` ADD PRIMARY KEY(`userid`);
  28
  29 ALTER TABLE `search` ADD `orderby` MEDIUMTEXT NOT NULL;
  30
  31 ALTER TABLE `search` ADD `hilight` VARCHAR(255) NOT NULL;