[Summary view] [Print] [Text view]

   1  #####################################################
   2  #
   3  #  PHPWCMS SQL Update
   4  #  
   5  #  Upgrade release 1.2.2-DEV to 1.2.3-DEV
   6  #  2005.30.05
   7  #
   8  #####################################################
   9  
  10  #ALTER TABLE `phpwcms_user` ADD `usr_wysiwyg` INT( 2 ) NOT NULL ;
  11  #ALTER TABLE `phpwcms_user` ADD `usr_fe` INT( 1 ) NOT NULL ;
  12  #UPDATE `phpwcms_user` SET usr_fe =2 ;
  13  #ALTER TABLE `phpwcms_userlog` ADD `logged_section` INT( 1 ) NOT NULL ;
  14  #CREATE TABLE `phpwcms_sysvalue` (
  15  #    `sysvalue_key` VARCHAR( 255 ) NOT NULL ,
  16  #    `sysvalue_tstamp` TIMESTAMP NOT NULL ,
  17  #    `sysvalue_value` MEDIUMBLOB NOT NULL ,
  18  #    PRIMARY KEY ( `sysvalue_key` ) ,
  19  #    FULLTEXT ( `sysvalue_key` )
  20  #);
  21  ALTER TABLE `phpwcms_article` ADD `article_nositemap` INT( 1 ) DEFAULT '1' NOT NULL ;
  22  ALTER TABLE `phpwcms_articlecat` ADD `acat_nositemap` INT( 1 ) DEFAULT '1' NOT NULL ;
  23  UPDATE `phpwcms_article` SET article_nositemap=1 ;
  24  UPDATE `phpwcms_articlecat` SET acat_nositemap=1 ;
  25  ALTER TABLE `phpwcms_file` ADD `f_dlstart` INT NOT NULL ;
  26  ALTER TABLE `phpwcms_file` ADD `f_dlfinal` INT NOT NULL ;