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 );