1.0.6.0.sql

一、修改产品详细页面的附件块 二、添加上浏览历史模块 三、在后台加入自定义首页、自定义页头、自定义页脚内容功能 四、在后台修改网站全局CSS样式文件功能 五、在后台修改每个模块的模板内容功能

/* PHP */
/* PHP:AttributeGroup::cleanDeadCombinations(); */;

/* STRUCTURE */
SET NAMES 'utf8';
ALTER TABLE `PREFIX_blockpermanentlink` 
				ADD `type` VARCHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1';
ALTER TABLE `PREFIX_blockpermanentlink_lang` 
				ADD `content` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;

CREATE TABLE `PREFIX_blockvariouslinks` (
  `id_link` int(2) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL,
  `new_window` tinyint(1) NOT NULL,
  `num_order` int(11) NOT NULL default '0',
  `type` varchar(1) NOT NULL default '1',
  PRIMARY KEY  (`id_link`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

CREATE TABLE `PREFIX_blockvariouslinks_lang` (
  `id_link` int(2) NOT NULL,
  `id_lang` int(2) NOT NULL,
  `text` varchar(64) NOT NULL,
  `content` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `PREFIX_cms` (
  `id_link` int(6) NOT NULL auto_increment,
  `order` int(11) NOT NULL default '0',
  `issuetime` varchar(20) NOT NULL,
  PRIMARY KEY  (`id_link`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `PREFIX_cms_lang` (
  `id_link` int(6) NOT NULL,
  `id_lang` int(2) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


/*  CONTENTS */
DELETE FROM `PREFIX_state` WHERE `id_state` = 53 LIMIT 1;
DELETE FROM `PREFIX_state` WHERE `id_state` = 54 LIMIT 1;
DELETE FROM `PREFIX_state` WHERE `id_state` = 56 LIMIT 1;

INSERT INTO `PREFIX_state` (`id_state`, `id_country`, `id_zone`, `name`, `iso_code`, `tax_behavior`, `active`) VALUES
(NULL, 68, 3, '山西省', 'SX', 0, 1),
(NULL, 68, 3, '青海省', 'QH', 0, 1),
(NULL, 68, 3, '黑龙江省', 'HLJ', 0, 1),
(NULL, 68, 3, '吉林省', 'JL', 0, 1),
(NULL, 68, 3, '辽宁省', 'LN', 0, 1),
(NULL, 68, 3, '河北省', 'HB', 0, 1),
(NULL, 68, 3, '山东省', 'SD', 0, 1),
(NULL, 68, 3, '河南省', 'HN', 0, 1),
(NULL, 68, 3, '江苏省', 'JS', 0, 1),
(NULL, 68, 3, '安徽省', 'AH', 0, 1),
(NULL, 68, 3, '浙江省', 'ZJ', 0, 1),
(NULL, 68, 3, '福建省', 'FJ', 0, 1),
(NULL, 68, 3, '江西省', 'JX', 0, 1),
(NULL, 68, 3, '湖南省', 'HN', 0, 1),
(NULL, 68, 3, '湖北省', 'HB', 0, 1),
(NULL, 68, 3, '广东省', 'GD', 0, 1),
(NULL, 68, 3, '台湾省', 'TW', 0, 1),
(NULL, 68, 3, '海南省', 'HN', 0, 1),
(NULL, 68, 3, '甘肃省', 'GS', 0, 1),
(NULL, 68, 3, '陕西省', 'SX', 0, 1),
(NULL, 68, 3, '四川省', 'SC', 0, 1),
(NULL, 68, 3, '贵州省', 'GZ', 0, 1),
(NULL, 68, 3, '云南省', 'YN', 0, 1),
(NULL, 68, 3, '北京', 'BJ', 0, 1),
(NULL, 68, 3, '天津', 'TJ', 0, 1),
(NULL, 68, 3, '上海', 'SH', 0, 1),
(NULL, 68, 3, '重庆', 'CQ', 0, 1),
(NULL, 68, 3, '内蒙古自治区', 'NMG', 0, 1),
(NULL, 68, 3, '维吾尔自治区', 'WWE', 0, 1),
(NULL, 68, 3, '西藏自治区', 'XZ', 0, 1),
(NULL, 68, 3, '宁夏回族自治区', 'NX', 0, 1),
(NULL, 68, 3, '广西壮族自治区', 'GX', 0, 1),
(NULL, 68, 3, '香港特别行政区', 'HK', 0, 1),
(NULL, 68, 3, '澳门特别行政区', 'AM', 0, 1);

INSERT INTO `PREFIX_blockvariouslinks` (`id_link`, `url`, `new_window`, `num_order`, `type`) VALUES
(1, '', 0, 1, '2'),
(2, '', 0, 2, '2'),
(3, 'sitemap.php', 0, 3, '1'),
(4, '', 0, 4, '2'),
(5, '', 0, 5, '2'),
(6, 'faq.php', 0, 6, '1');

INSERT INTO `PREFIX_blockvariouslinks_lang` (`id_link`, `id_lang`, `text`, `content`) VALUES
(1, 22, '关于我们', '<p>在这里任意编辑"关于我们"页的内容</p>'),
(1, 24, '關於我們', '<p>這裡任意編輯"關於我們"頁的內容</p>'),
(1, 1, 'about us', '<p>about us</p>'),
(1, 2, '关于我们', '<p>在这里任意编辑"关于我们"页的内容</p>'),
(1, 3, '关于我们', '<p>在这里任意编辑"关于我们"页的内容</p>'),
(1, 4, '关于我们', '<p>在这里任意编辑"关于我们"页的内容</p>'),
(1, 5, '关于我们', '<p>在这里任意编辑"关于我们"页的内容</p>'),
(1, 6, '关于我们', '<p>在这里任意编辑"关于我们"页的内容</p>'),
(1, 7, '关于我们', '<p>在这里任意编辑"关于我们"页的内容</p>'),
(1, 8, '关于我们', '<p>在这里任意编辑"关于我们"页的内容</p>'),
(2, 22, '配送货物', '<p>在这里任意编辑&ldquo;配送货物&rdquo;页内容</p>'),
(2, 24, '配送貨物', '<p>在這裡任意編輯"配送貨物"頁內容</p>'),
(2, 1, 'delivery', '<p>delivery</p>'),
(2, 2, '配送货物', '<p>在这里任意编辑&ldquo;配送货物&rdquo;页内容</p>'),
(2, 3, '配送货物', '<p>在这里任意编辑&ldquo;配送货物&rdquo;页内容</p>'),
(2, 4, '配送货物', '<p>在这里任意编辑&ldquo;配送货物&rdquo;页内容</p>'),
(2, 5, '配送货物', '<p>在这里任意编辑&ldquo;配送货物&rdquo;页内容</p>'),
(2, 6, '配送货物', '<p>在这里任意编辑&ldquo;配送货物&rdquo;页内容</p>'),
(2, 7, '配送货物', '<p>在这里任意编辑&ldquo;配送货物&rdquo;页内容</p>'),
(2, 8, '配送货物', '<p>在这里任意编辑&ldquo;配送货物&rdquo;页内容</p>'),
(3, 22, '网站地图', '<p>在这里任意编辑"网站地图"页内容</p>'),
(3, 24, '網站地圖', '<p>在這裡任意編輯"網站地圖"頁內容</p>'),
(3, 1, 'site map', '<p>site map</p>'),
(3, 2, '网站地图', ''),
(3, 3, '网站地图', ''),
(3, 4, '网站地图', ''),
(3, 5, '网站地图', ''),
(3, 6, '网站地图', ''),
(3, 7, '网站地图', ''),
(3, 8, '网站地图', ''),
(4, 22, '法律声明', '<p>在这里任意编辑&ldquo;法律声明&rdquo;页内容</p>'),
(4, 24, '法律聲明', '<p>在這裡任意紡輯"法律聲明"頁內容</p>'),
(4, 1, 'mentions', '<p>mentions</p>'),
(4, 2, '法律声明', '<p>在这里任意编辑&ldquo;法律声明&rdquo;页内容</p>'),
(4, 3, '法律声明', '<p>在这里任意编辑&ldquo;法律声明&rdquo;页内容</p>'),
(4, 4, '法律声明', '<p>在这里任意编辑&ldquo;法律声明&rdquo;页内容</p>'),
(4, 5, '法律声明', '<p>在这里任意编辑&ldquo;法律声明&rdquo;页内容</p>'),
(4, 6, '法律声明', '<p>在这里任意编辑&ldquo;法律声明&rdquo;页内容</p>'),
(4, 7, '法律声明', '<p>在这里任意编辑&ldquo;法律声明&rdquo;页内容</p>'),
(4, 8, '法律声明', '<p>在这里任意编辑&ldquo;法律声明&rdquo;页内容</p>'),
(5, 22, '服务条款', '<p>在这里任意编辑&ldquo;服务条款&rdquo;页内容</p>'),
(5, 24, '服務條款', '<p>在這裡任意編輯"服務條款"頁內容</p>'),
(5, 1, 'conditions', '<p>conditions</p>'),
(5, 2, '服务条款', '<p>在这里任意编辑&ldquo;服务条款&rdquo;页内容</p>'),
(5, 3, '服务条款', '<p>在这里任意编辑&ldquo;服务条款&rdquo;页内容</p>'),
(5, 4, '服务条款', '<p>在这里任意编辑&ldquo;服务条款&rdquo;页内容</p>'),
(5, 5, '服务条款', '<p>在这里任意编辑&ldquo;服务条款&rdquo;页内容</p>'),
(5, 6, '服务条款', '<p>在这里任意编辑&ldquo;服务条款&rdquo;页内容</p>'),
(5, 7, '服务条款', '<p>在这里任意编辑&ldquo;服务条款&rdquo;页内容</p>'),
(5, 8, '服务条款', '<p>在这里任意编辑&ldquo;服务条款&rdquo;页内容</p>'),
(6, 22, 'F & Q', ''),
(6, 24, 'F & Q', ''),
(6, 1, 'F & Q', ''),
(6, 2, 'F & Q', ''),
(6, 3, 'F & Q', ''),
(6, 4, 'F & Q', ''),
(6, 5, 'F & Q', ''),
(6, 6, 'F & Q', ''),
(6, 7, 'F & Q', ''),
(6, 8, 'F & Q', '');

UPDATE `PREFIX_hook_module` SET `position` = '3' WHERE `PREFIX_hook_module`.`id_module` =53 AND `PREFIX_hook_module`.`id_hook` =6 AND `PREFIX_hook_module`.`position` =2 LIMIT 1 ;
UPDATE `PREFIX_hook_module` SET `position` = '4' WHERE `PREFIX_hook_module`.`id_module` =122 AND `PREFIX_hook_module`.`id_hook` =6 AND `PREFIX_hook_module`.`position` =3 LIMIT 1 ;

INSERT INTO `PREFIX_hook_module` (`id_module`, `id_hook`, `position`) VALUES
(124, 6, 2);

INSERT INTO `PREFIX_module` (`id_module`, `name`, `active`) VALUES
(124, 'blockcms', 1);

UPDATE `PREFIX_image_type` SET `width` = '108',
`height` = '108' WHERE `PREFIX_image_type`.`id_image_type` =6 LIMIT 1 ;

/* CONFIGURATION VARIABLE */