3 CREATE TABLE `favourite`
(
4 `userid`
INT(10) UNSIGNED
NOT NULL,
5 `bugid`
INT(10) UNSIGNED
NOT NULL
8 ALTER TABLE `favourite`
ADD PRIMARY KEY (`userid`
,`bugid`
);
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,
18 ALTER TABLE `
language`
DROP `filename`
;
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
27 ALTER TABLE `
search`
ADD PRIMARY KEY(`userid`
);
29 ALTER TABLE `
search`
ADD `orderby` MEDIUMTEXT
NOT NULL;
31 ALTER TABLE `
search`
ADD `hilight`
VARCHAR(255) NOT NULL;
33 ALTER TABLE `
language`
ADD `debug`
INT(2) UNSIGNED
NOT NULL;
35 ALTER TABLE `phrase`
DROP INDEX `varname`
;
37 ALTER TABLE `phrase` CHANGE `varname` `localkey` MEDIUMTEXT
NOT NULL;
39 ALTER TABLE `phrase`
DROP `imported`
;
43 ALTER TABLE `phrase`
RENAME `localization`
;
45 ALTER TABLE `localization`
ADD `languageid`
INT(10) UNSIGNED
NOT NULL;
47 ALTER TABLE `localization`
ADD `localid`
INT(10) UNSIGNED
NOT NULL AUTO_INCREMENT
PRIMARY KEY FIRST;
49 ALTER TABLE `localization` CHANGE `phrasetext` `localtext` MEDIUMTEXT
NOT NULL;
51 ALTER TABLE `
language`
ADD `filename`
VARCHAR(255) NOT NULL AFTER `direction`
;