## SVN $Id$

ALTER TABLE `comment` ADD parselinks BOOL NULL;

ALTER TABLE user ADD columnoptions TEXT NULL;

ALTER TABLE product CHANGE componentmother parentid INT UNSIGNED NULL;

ALTER TABLE search DROP PRIMARY KEY;

ALTER TABLE search ADD searchid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY;

ALTER TABLE search ADD name VARCHAR(250) NULL;

ALTER TABLE version ADD obsolete BOOL NULL;

CREATE TABLE passwordreset
(
	activatorid VARCHAR(250) NOT NULL, 
	userid INT NOT NULL, 
	dateline INT NOT NULL,
	PRIMARY KEY (activatorid)
);

CREATE TABLE adminsession
(
	sessionid VARCHAR(250) NOT NULL, 
	userid INT UNSIGNED NOT NULL, 
	dateline INT UNSIGNED NOT NULL,
	PRIMARY KEY (sessionid)
);

CREATE TABLE template
(
	filename VARCHAR(255) NOT NULL,
	template TEXT NOT NULL,
	timestamp INT(10) UNSIGNED NOT NULL,
	PRIMARY KEY  (filename)
);

ALTER TABLE user ADD authid VARCHAR(255) NULL;