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 );
  24
  25 CREATE TABLE adminsession
  26 (
  27         sessionid VARCHAR(250) NOT NULL,
  28         userid INT UNSIGNED NOT NULL,
  29         dateline INT UNSIGNED NOT NULL,
  30         PRIMARY KEY (sessionid)
  31 );
  32
  33 CREATE TABLE template
  34 (
  35         filename VARCHAR(255) NOT NULL,
  36         template TEXT NOT NULL,
  37         timestamp INT(10) UNSIGNED NOT NULL,
  38         PRIMARY KEY  (filename)
  39 );