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 );