3 ALTER TABLE `
comment`
ADD parselinks BOOL
NULL;
5 ALTER TABLE user ADD columnoptions
TEXT NULL;
7 ALTER TABLE product CHANGE componentmother parentid
INT UNSIGNED
NULL;
9 ALTER TABLE search DROP PRIMARY KEY;
11 ALTER TABLE search ADD searchid
INT UNSIGNED
NOT NULL AUTO_INCREMENT
PRIMARY KEY;
13 ALTER TABLE search ADD name VARCHAR(250) NULL;
15 ALTER TABLE version ADD obsolete BOOL
NULL;
17 CREATE TABLE passwordreset
19 activatorid
VARCHAR(250) NOT NULL,
21 dateline
INT NOT NULL,
22 PRIMARY KEY (activatorid
)
25 CREATE TABLE adminsession
27 sessionid
VARCHAR(250) NOT NULL,
28 userid
INT UNSIGNED
NOT NULL,
29 dateline
INT UNSIGNED
NOT NULL,
30 PRIMARY KEY (sessionid
)
35 filename
VARCHAR(255) NOT NULL,
36 template TEXT NOT NULL,
37 timestamp INT(10) UNSIGNED
NOT NULL,
38 PRIMARY KEY (filename
)
41 ALTER TABLE user ADD authid
VARCHAR(255) NULL;