[Summary view] [Print] [Text view]

   1  #####################################################
   2  #
   3  #  PHPWCMS SQL Update
   4  #  
   5  #  Upgrade release 1.4 to 1.5
   6  #
   7  #####################################################
   8  
   9  
  10  # 2008-12-15
  11  CREATE TABLE IF NOT EXISTS `phpwcms_log_seo` (
  12    `id` int(11) NOT NULL auto_increment,
  13    `create_date` timestamp NOT NULL,
  14    `domain` varchar(255) NOT NULL DEFAULT '',
  15    `query` varchar(255) NOT NULL DEFAULT '',
  16    `pos` int(11) NOT NULL DEFAULT 0,
  17    `referrer` text NOT NULL,
  18    PRIMARY KEY  (`id`)
  19  ) TYPE=MyISAM ;
  20  
  21  #2008-12-22
  22  ALTER TABLE `phpwcms_article` ADD `article_menutitle` VARCHAR( 255 ) NOT NULL DEFAULT '' ;
  23  
  24  #2009-01-18
  25  ALTER TABLE `phpwcms_crossreference` ADD `cref_module` VARCHAR( 255 ) NOT NULL DEFAULT '' AFTER `cref_type`;
  26  ALTER TABLE `phpwcms_crossreference` ADD INDEX ( `cref_module` );
  27  
  28  #2009-01-30
  29  ALTER TABLE `phpwcms_file` ADD `f_sort` INT NOT NULL DEFAULT '0';
  30  ALTER TABLE `phpwcms_file` ADD INDEX ( f_sort );
  31  
  32  #2009-06-26
  33  ALTER TABLE `phpwcms_userdetail` ADD `detail_regkey` VARCHAR( 255 ) NOT NULL DEFAULT '' AFTER `detail_id`;
  34  ALTER TABLE `phpwcms_userdetail` ADD `detail_salutation` VARCHAR( 255 ) NOT NULL DEFAULT '' AFTER `detail_title`;
  35  ALTER TABLE `phpwcms_userdetail` ADD INDEX ( detail_regkey );
  36  
  37  #2009-07-29
  38  ALTER TABLE `phpwcms_shop_products` ADD `shopprod_track_view` INT( 11 ) NOT NULL DEFAULT '0';
  39  ALTER TABLE `phpwcms_shop_products` ADD INDEX ( `shopprod_track_view` );
  40  
  41  CREATE TABLE IF NOT EXISTS `phpwcms_log` (
  42    `log_id` int(11) NOT NULL AUTO_INCREMENT,
  43    `log_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  44    `log_type` varchar(50) NOT NULL DEFAULT '',
  45    `log_ip` varchar(30) NOT NULL DEFAULT '',
  46    `log_user_agent` varchar(255) NOT NULL,
  47    `log_user_id` int(11) NOT NULL DEFAULT '0',
  48    `log_user_name` varchar(255) NOT NULL,
  49    `log_referrer_id` int(11) NOT NULL DEFAULT '0',
  50    `log_referrer_url` text NOT NULL,
  51    `log_data1` varchar(255) NOT NULL DEFAULT '',
  52    `log_data2` varchar(255) NOT NULL DEFAULT '',
  53    `log_data3` varchar(255) NOT NULL DEFAULT '',
  54    `log_msg` text NOT NULL,
  55    PRIMARY KEY (`log_id`),
  56    KEY `log_referrer_id` (`log_referrer_id`),
  57    KEY `log_type` (`log_type`)
  58  ) TYPE=MyISAM ;
  59  
  60  #2009-08-19
  61  ALTER TABLE `phpwcms_calendar` CHANGE `calendar_refid` `calendar_refid` VARCHAR( 255 ) NOT NULL DEFAULT '';