## SVN $Id$

ALTER TABLE bug ADD username varchar(255) NOT NULL;

ALTER TABLE bug ADD lastpostbyname varchar(255) NOT NULL;

ALTER TABLE bug ADD hiddenlastpostbyname varchar(255) NOT NULL;

CREATE TABLE useremail
(
	userid int unsigned not null,
	relation int unsigned not null,
	mask int unsigned not null
);

DROP TABLE dependency;

ALTER TABLE user ADD usedst BOOL NOT NULL;

ALTER TABLE user ADD hidestatuses mediumtext NOT NULL;

ALTER TABLE bug CHANGE productid product INT(10) UNSIGNED NOT NULL DEFAULT '0';

ALTER TABLE bug CHANGE componentid component INT(10) UNSIGNED NOT NULL DEFAULT '0';

ALTER TABLE bug CHANGE versionid version INT(10) UNSIGNED NOT NULL DEFAULT '0';

DELETE FROM search;

ALTER TABLE user ADD defaultsortkey varchar(50) NULL;

ALTER TABLE user ADD defaultsortas varchar(10) NULL;
