[Summary view] [Print] [Text view]

   1  #####################################################
   2  #
   3  #  PHPWCMS SQL Update
   4  #  
   5  #  Upgrade release 1.2.1-DEV to 1.2.2-DEV
   6  #  2005.03.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 '0' NOT NULL ;
  22  ALTER TABLE `phpwcms_articlecat` ADD `acat_nositemap` INT( 1 ) DEFAULT '0' NOT NULL ;