]> src.bluestatic.org Git - bugdar.git/blob - docs/schema_changes.sql
r1406: Moving the rest of the email body texts (from class_notification.php) to templates
[bugdar.git] / docs / schema_changes.sql
1 ## SVN $Id$
2
3 ALTER TABLE `comment` ADD parselinks BOOL NULL;
4
5 ALTER TABLE user ADD columnoptions TEXT NULL;
6
7 ALTER TABLE product CHANGE componentmother parentid INT UNSIGNED NULL;
8
9 ALTER TABLE search DROP PRIMARY KEY;
10
11 ALTER TABLE search ADD searchid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY;
12
13 ALTER TABLE search ADD name VARCHAR(250) NULL;
14
15 ALTER TABLE version ADD obsolete BOOL NULL;
16
17 CREATE TABLE passwordreset
18 (
19 activatorid VARCHAR(250) NOT NULL,
20 userid INT NOT NULL,
21 dateline INT NOT NULL,
22 PRIMARY KEY (activatorid)
23 );