## SVN $Id$

CREATE TABLE `favourite` (
  `userid` INT(10) UNSIGNED NOT NULL, 
  `bugid` INT(10) UNSIGNED NOT NULL
);

ALTER TABLE `favourite` ADD PRIMARY KEY (`userid`,`bugid`);

CREATE TABLE `vote` (
  `bugid` INT(10) UNSIGNED NOT NULL, 
  `userids` MEDIUMTEXT NOT NULL, 
  `votefor` INT(10) UNSIGNED NOT NULL,
  `voteagainst` INT(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`bugid`)
);