[Summary view] [Print] [Text view]

   1  #####################################################
   2  #
   3  #  PHPWCMS SQL Update
   4  #  
   5  #  Upgrade release 1.3.3 to 1.3.4
   6  #
   7  #####################################################
   8  
   9  
  10  ALTER TABLE `phpwcms_article` ADD `article_priorize` INT( 5 ) NOT NULL DEFAULT '0';
  11  ALTER TABLE `phpwcms_article` ADD INDEX ( `article_priorize` ) ;
  12  ALTER TABLE `phpwcms_article` ADD INDEX ( `article_sort` ) ;
  13  
  14  UPDATE `phpwcms_articlecontent` SET acontent_html='', acontent_tstamp=acontent_tstamp WHERE acontent_type=7 ;
  15  
  16  ALTER TABLE `phpwcms_article` ADD `article_norss` INT( 1 ) NOT NULL DEFAULT '1';
  17  ALTER TABLE `phpwcms_article` ADD `article_alias` VARCHAR(255) NOT NULL AFTER `article_title`;
  18  ALTER TABLE `phpwcms_article` CHANGE `article_username` `article_username` VARCHAR(255) NOT NULL;
  19  ALTER TABLE `phpwcms_article` ADD INDEX `article_alias` (`article_alias`);