[Summary view] [Print] [Text view]

   1  #####################################################
   2  #
   3  #  PHPWCMS SQL Update
   4  #  
   5  #  Upgrade release 1.1.9-DEV to 1.2.1-DEV
   6  #  2005.02.20
   7  #
   8  #####################################################
   9  
  10  
  11  
  12  CREATE TABLE `phpwcms_module` (
  13  `module_id` INT NOT NULL AUTO_INCREMENT ,
  14  `module_timestamp` TIMESTAMP NOT NULL ,
  15  `module_name` VARCHAR( 30 ) NOT NULL ,
  16  `module_mode` TINYINT( 1 ) NOT NULL ,
  17  `module_title` TEXT NOT NULL ,
  18  `module_description` TEXT NOT NULL ,
  19  PRIMARY KEY ( `module_id` ) 
  20  );
  21  
  22  ALTER TABLE `phpwcms_cache` DROP `cache_content` ;
  23  ALTER TABLE `phpwcms_cache` ADD `cache_uri` TEXT NOT NULL AFTER `cache_hash` ;
  24  ALTER TABLE `phpwcms_cache` ADD `cache_stripped` LONGTEXT NOT NULL ;
  25  ALTER TABLE `phpwcms_cache` ADD FULLTEXT (`cache_stripped`);
  26  ALTER TABLE `phpwcms_cache` ADD `cache_isprint` INT( 1 ) NOT NULL AFTER `cache_timeout` ;
  27  ALTER TABLE `phpwcms_forum` ADD `forum_ctopic` INT NOT NULL AFTER `forum_uid` ;
  28  ALTER TABLE `phpwcms_forum` ADD `forum_cpost` INT NOT NULL AFTER `forum_ctopic` ;
  29  ALTER TABLE `phpwcms_forum` ADD `forum_lastpost` MEDIUMTEXT NOT NULL ;