[Summary view] [Print] [Text view]

   1  #####################################################
   2  #
   3  #  PHPWCMS SQL Update
   4  #  
   5  #  Upgrade release 1.3.5 to 1.3.5.1
   6  #
   7  #####################################################
   8  
   9  DROP TABLE IF EXISTS `phpwcms_log` ;
  10  CREATE TABLE `phpwcms_log` (
  11    `log_id` int(11) NOT NULL auto_increment,
  12    `log_type` varchar(255) NOT NULL,
  13    `log_timestamp` timestamp NOT NULL,
  14    `log_message` text NOT NULL,
  15    `log_ip` varchar(50) NOT NULL,
  16    `log_userid` varchar(255) NOT NULL,
  17    PRIMARY KEY  (`log_id`)
  18  ) TYPE=MyISAM ;
  19  
  20  ALTER TABLE `phpwcms_guestbook` CHANGE `guestbook_created` `guestbook_created` INT(11) NOT NULL ;
  21  ALTER TABLE `phpwcms_userlog` CHANGE `logged_change` `logged_change` INT(11) DEFAULT '0' NOT NULL ;
  22  ALTER TABLE `phpwcms_userlog` CHANGE `logged_start` `logged_start` INT(11) DEFAULT '0' NOT NULL ;
  23  
  24  ALTER TABLE `phpwcms_articlecat` CHANGE `acat_alias` `acat_alias` VARCHAR(255) NOT NULL ;
  25  ALTER TABLE `phpwcms_articlecat` DROP INDEX `acat_alias`;
  26  ALTER TABLE `phpwcms_articlecat` ADD INDEX `acat_alias` (`acat_alias`);
  27  
  28  ALTER TABLE `phpwcms_file` DROP INDEX `f_name`;
  29  ALTER TABLE `phpwcms_file` ADD INDEX `f_name` (`f_name`);
  30  ALTER TABLE `phpwcms_file` DROP INDEX `f_shortinfo`;
  31  ALTER TABLE `phpwcms_file` ADD INDEX `f_shortinfo` (`f_shortinfo`);