From 683bc671aad2f1bc8c0c6068bd65b9fa3b5ed2a3 Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Mon, 12 Mar 2007 00:09:27 +0000 Subject: [PATCH] r1455: Removing all the queries we have added to the upgrade script --- docs/schema_changes.sql | 39 --------------------------------------- 1 file changed, 39 deletions(-) diff --git a/docs/schema_changes.sql b/docs/schema_changes.sql index 59dc1fb..9de1d44 100644 --- a/docs/schema_changes.sql +++ b/docs/schema_changes.sql @@ -1,41 +1,2 @@ ## 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; \ No newline at end of file -- 2.22.5