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;
  32
  33 ALTER TABLE `language` ADD `debug` INT(2) UNSIGNED NOT NULL;
  34
  35 ALTER TABLE `phrase` DROP INDEX `varname`;
  36
  37 ALTER TABLE `phrase` CHANGE `varname` `localkey` MEDIUMTEXT NOT NULL;
  38
  39 ALTER TABLE `phrase` DROP `imported`;
  40
  41 DROP TABLE `locale`;
  42
  43 ALTER TABLE `phrase` RENAME `localization`;
  44
  45 ALTER TABLE `localization` ADD `languageid` INT(10) UNSIGNED NOT NULL;
  46
  47 ALTER TABLE `localization` ADD `localid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
  48
  49 ALTER TABLE `localization` CHANGE `phrasetext` `localtext` MEDIUMTEXT NOT NULL;
  50
  51 ALTER TABLE `language` ADD `filename` VARCHAR(255) NOT NULL AFTER `direction`;