[Summary view] [Print] [Text view]

   1  #####################################################
   2  #
   3  #  PHPWCMS SQL Update
   4  #  
   5  #  Upgrade release 1.2.5-DEV to 1.2.6-DEV
   6  #  2005.11.05
   7  #
   8  #####################################################
   9  
  10  ALTER TABLE `phpwcms_user` ADD `usr_vars` MEDIUMTEXT NOT NULL ;
  11  ALTER TABLE `phpwcms_usergroup` ADD `group_name` VARCHAR( 200 ) NOT NULL AFTER `group_id` ;
  12  ALTER TABLE `phpwcms_usergroup` ADD `group_member` MEDIUMTEXT NOT NULL AFTER `group_name` ;
  13  ALTER TABLE `phpwcms_usergroup` ADD `group_timestamp` TIMESTAMP NOT NULL ;
  14  ALTER TABLE `phpwcms_usergroup` ADD `group_trash` INT( 1 ) NOT NULL ;
  15  ALTER TABLE `phpwcms_usergroup` ADD `group_active` INT( 1 ) NOT NULL ;
  16  
  17  ALTER TABLE `phpwcms_articlecontent` ADD `acontent_anchor` INT( 1 ) NOT NULL ;
  18  
  19  CREATE TABLE `phpwcms_keyword` (
  20    `keyword_id` int(11) NOT NULL auto_increment,
  21    `keyword_name` varchar(255) NOT NULL default '',
  22    `keyword_trash` int(1) NOT NULL default '0',
  23    PRIMARY KEY  (`keyword_id`)
  24  ) TYPE=MyISAM AUTO_INCREMENT=1 ;