1.0.7.1.sql

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

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

/* STRUCTURE */
SET NAMES 'utf8';

/*  CONTENTS */

INSERT INTO `PREFIX_customer` (`id_gender`,`secure_key`,`email`,`passwd`,`birthday`,`lastname`,`newsletter`,`optin`,`firstname`,`active`,`date_add`,`date_upd`)VALUES(9, 'f3110bdc312c091f05c07213c982dbd3', '[e-mail]', 'a5ad01a84ffbde7413aba5f54da6768f', NULL, '游', 0, 0, '客', 1, '2008-11-21 13:48:57', '2008-11-21 13:48:57') ;

UPDATE `PREFIX_address` SET id_state=66 WHERE id_state=53;
UPDATE `PREFIX_address` SET id_state=63 WHERE id_state=54;
UPDATE `PREFIX_address` SET id_state=73 WHERE id_state=56;

ALTER TABLE `PREFIX_product_attribute` DROP `ecotax`; 
DROP TABLE `PREFIX_zone`;
DROP TABLE `PREFIX_state`;

CREATE TABLE `PREFIX_state` (
  `id_state` int(10) unsigned NOT NULL auto_increment,
  `id_country` int(11) NOT NULL,
  `id_zone` int(11) NOT NULL,
  `iso_code` varchar(3) NOT NULL,
  `tax_behavior` smallint(1) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id_state`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=92 ;

INSERT INTO `PREFIX_state` (`id_state`, `id_country`, `id_zone`, `iso_code`, `tax_behavior`, `active`) VALUES
(1, 21, 2, 'AL', 0, 1),
(2, 21, 2, 'AK', 0, 1),
(3, 21, 2, 'AZ', 0, 1),
(4, 21, 2, 'AR', 0, 1),
(5, 21, 2, 'CA', 0, 1),
(6, 21, 2, 'CO', 0, 1),
(7, 21, 2, 'CT', 0, 1),
(8, 21, 2, 'DE', 0, 1),
(9, 21, 2, 'FL', 0, 1),
(10, 21, 2, 'GA', 0, 1),
(11, 21, 2, 'HI', 0, 1),
(12, 21, 2, 'ID', 0, 1),
(13, 21, 2, 'IL', 0, 1),
(14, 21, 2, 'IN', 0, 1),
(15, 21, 2, 'IA', 0, 1),
(16, 21, 2, 'KS', 0, 1),
(17, 21, 2, 'KY', 0, 1),
(18, 21, 2, 'LA', 0, 1),
(19, 21, 2, 'ME', 0, 1),
(20, 21, 2, 'MD', 0, 1),
(21, 21, 2, 'MA', 0, 1),
(22, 21, 2, 'MI', 0, 1),
(23, 21, 2, 'MN', 0, 1),
(24, 21, 2, 'MS', 0, 1),
(25, 21, 2, 'MO', 0, 1),
(26, 21, 2, 'MT', 0, 1),
(27, 21, 2, 'NE', 0, 1),
(28, 21, 2, 'NV', 0, 1),
(29, 21, 2, 'NH', 0, 1),
(30, 21, 2, 'NJ', 0, 1),
(31, 21, 2, 'NM', 0, 1),
(32, 21, 2, 'NY', 0, 1),
(33, 21, 2, 'NC', 0, 1),
(34, 21, 2, 'ND', 0, 1),
(35, 21, 2, 'OH', 0, 1),
(36, 21, 2, 'OK', 0, 1),
(37, 21, 2, 'OR', 0, 1),
(38, 21, 2, 'PA', 0, 1),
(39, 21, 2, 'RI', 0, 1),
(40, 21, 2, 'SC', 0, 1),
(41, 21, 2, 'SD', 0, 1),
(42, 21, 2, 'TN', 0, 1),
(43, 21, 2, 'TX', 0, 1),
(44, 21, 2, 'UT', 0, 1),
(45, 21, 2, 'VT', 0, 1),
(46, 21, 2, 'VA', 0, 1),
(47, 21, 2, 'WA', 0, 1),
(48, 21, 2, 'WV', 0, 1),
(49, 21, 2, 'WI', 0, 1),
(50, 21, 2, 'WY', 0, 1),
(51, 21, 2, 'PR', 0, 1),
(52, 21, 2, 'VI', 0, 1),
(61, 68, 3, 'SX', 0, 1),
(62, 68, 3, 'QH', 0, 1),
(57, 68, 3, 'HLJ', 0, 1),
(58, 68, 3, 'JL', 0, 1),
(59, 68, 3, 'LN', 0, 1),
(60, 68, 3, 'HB', 0, 1),
(63, 68, 3, 'SD', 0, 1),
(64, 68, 3, 'HN', 0, 1),
(65, 68, 3, 'JS', 0, 1),
(66, 68, 3, 'AH', 0, 1),
(67, 68, 3, 'ZJ', 0, 1),
(68, 68, 3, 'FJ', 0, 1),
(69, 68, 3, 'JX', 0, 1),
(70, 68, 3, 'HN', 0, 1),
(71, 68, 3, 'HB', 0, 1),
(72, 68, 3, 'GD', 0, 1),
(73, 68, 3, 'TW', 0, 1),
(74, 68, 3, 'HN', 0, 1),
(75, 68, 3, 'GS', 0, 1),
(76, 68, 3, 'SX', 0, 1),
(77, 68, 3, 'SC', 0, 1),
(78, 68, 3, 'GZ', 0, 1),
(79, 68, 3, 'YN', 0, 1),
(80, 68, 3, 'BJ', 0, 1),
(81, 68, 3, 'TJ', 0, 1),
(82, 68, 3, 'SH', 0, 1),
(83, 68, 3, 'CQ', 0, 1),
(84, 68, 3, 'NMG', 0, 1),
(85, 68, 3, 'WWE', 0, 1),
(86, 68, 3, 'XZ', 0, 1),
(87, 68, 3, 'NX', 0, 1),
(88, 68, 3, 'GX', 0, 1),
(89, 68, 3, 'HK', 0, 1),
(90, 68, 3, 'AM', 0, 1);

CREATE TABLE `PREFIX_state_lang` (
  `id_state` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(64) NOT NULL,
  UNIQUE KEY `state_lang_index` (`id_state`,`id_lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `PREFIX_state_lang` (`id_state`, `id_lang`, `name`) VALUES
(1, 22, 'Alabama'),
(1, 24, 'Alabama'),
(1, 1, 'Alabama'),
(2, 22, 'Alaska'),
(2, 24, 'Alaska'),
(2, 1, 'Alaska'),
(3, 22, 'Arizona'),
(3, 24, 'Arizona'),
(3, 1, 'Arizona'),
(4, 22, 'Arkansas'),
(4, 24, 'Arkansas'),
(4, 1, 'Arkansas'),
(5, 22, 'California'),
(5, 24, 'California'),
(5, 1, 'California'),
(6, 22, 'Colorado'),
(6, 24, 'Colorado'),
(6, 1, 'Colorado'),
(7, 22, 'Connecticut'),
(7, 24, 'Connecticut'),
(7, 1, 'Connecticut'),
(8, 22, 'Delaware'),
(8, 24, 'Delaware'),
(8, 1, 'Delaware'),
(9, 22, 'Florida'),
(9, 24, 'Florida'),
(9, 1, 'Florida'),
(10, 22, 'Georgia'),
(10, 24, 'Georgia'),
(10, 1, 'Georgia'),
(11, 22, 'Hawaii'),
(11, 24, 'Hawaii'),
(11, 1, 'Hawaii'),
(12, 22, 'Idaho'),
(12, 24, 'Idaho'),
(12, 1, 'Idaho'),
(13, 22, 'Illinois'),
(13, 24, 'Illinois'),
(13, 1, 'Illinois'),
(14, 22, 'Indiana'),
(14, 24, 'Indiana'),
(14, 1, 'Indiana'),
(15, 22, 'Iowa'),
(15, 24, 'Iowa'),
(15, 1, 'Iowa'),
(16, 22, 'Kansas'),
(16, 24, 'Kansas'),
(16, 1, 'Kansas'),
(17, 22, 'Kentucky'),
(17, 24, 'Kentucky'),
(17, 1, 'Kentucky'),
(18, 22, 'Louisiana'),
(18, 24, 'Louisiana'),
(18, 1, 'Louisiana'),
(19, 22, 'Maine'),
(19, 24, 'Maine'),
(19, 1, 'Maine'),
(20, 22, 'Maryland'),
(20, 24, 'Maryland'),
(20, 1, 'Maryland'),
(21, 22, 'Massachusetts'),
(21, 24, 'Massachusetts'),
(21, 1, 'Massachusetts'),
(22, 22, 'Michigan'),
(22, 24, 'Michigan'),
(22, 1, 'Michigan'),
(23, 22, 'Minnesota'),
(23, 24, 'Minnesota'),
(23, 1, 'Minnesota'),
(24, 22, 'Mississippi'),
(24, 24, 'Mississippi'),
(24, 1, 'Mississippi'),
(25, 22, 'Missouri'),
(25, 24, 'Missouri'),
(25, 1, 'Missouri'),
(26, 22, 'Montana'),
(26, 24, 'Montana'),
(26, 1, 'Montana'),
(27, 22, 'Nebraska'),
(27, 24, 'Nebraska'),
(27, 1, 'Nebraska'),
(28, 22, 'Nevada'),
(28, 24, 'Nevada'),
(28, 1, 'Nevada'),
(29, 22, 'New Hampshire'),
(29, 24, 'New Hampshire'),
(29, 1, 'New Hampshire'),
(30, 22, 'New Jersey'),
(30, 24, 'New Jersey'),
(30, 1, 'New Jersey'),
(31, 22, 'New Mexico'),
(31, 24, 'New Mexico'),
(31, 1, 'New Mexico'),
(32, 22, 'New York'),
(32, 24, 'New York'),
(32, 1, 'New York'),
(33, 22, 'North Carolina'),
(33, 24, 'North Carolina'),
(33, 1, 'North Carolina'),
(34, 22, 'North Dakota'),
(34, 24, 'North Dakota'),
(34, 1, 'North Dakota'),
(35, 22, 'Ohio'),
(35, 24, 'Ohio'),
(35, 1, 'Ohio'),
(36, 22, 'Oklahoma'),
(36, 24, 'Oklahoma'),
(36, 1, 'Oklahoma'),
(37, 22, 'Oregon'),
(37, 24, 'Oregon'),
(37, 1, 'Oregon'),
(38, 22, 'Pennsylvania'),
(38, 24, 'Pennsylvania'),
(38, 1, 'Pennsylvania'),
(39, 22, 'Rhode Island'),
(39, 24, 'Rhode Island'),
(39, 1, 'Rhode Island'),
(40, 22, 'South Carolina'),
(40, 24, 'South Carolina'),
(40, 1, 'South Carolina'),
(41, 22, 'South Dakota'),
(41, 24, 'South Dakota'),
(41, 1, 'South Dakota'),
(42, 22, 'Tennessee'),
(42, 24, 'Tennessee'),
(42, 1, 'Tennessee'),
(43, 22, 'Texas'),
(43, 24, 'Texas'),
(43, 1, 'Texas'),
(44, 22, 'Utah'),
(44, 24, 'Utah'),
(44, 1, 'Utah'),
(45, 22, 'Vermont'),
(45, 24, 'Vermont'),
(45, 1, 'Vermont'),
(46, 22, 'Virginia'),
(46, 24, 'Virginia'),
(46, 1, 'Virginia'),
(47, 22, 'Washington'),
(47, 24, 'Washington'),
(47, 1, 'Washington'),
(48, 22, 'West Virginia'),
(48, 24, 'West Virginia'),
(48, 1, 'West Virginia'),
(49, 22, 'Wisconsin'),
(49, 24, 'Wisconsin'),
(49, 1, 'Wisconsin'),
(50, 22, 'Wyoming'),
(50, 24, 'Wyoming'),
(50, 1, 'Wyoming'),
(51, 22, 'Puerto Rico'),
(51, 24, 'Puerto Rico'),
(51, 1, 'Puerto Rico'),
(52, 22, 'US Virgin Islands'),
(52, 24, 'US Virgin Islands'),
(52, 1, 'US Virgin Islands'),
(57, 22, '黑龙江省'),
(57, 24, '黑龙江省'),
(57, 1, '黑龙江省'),
(58, 22, '吉林省'),
(58, 24, '吉林省'),
(58, 1, '吉林省'),
(59, 22, '辽宁省'),
(59, 24, '辽宁省'),
(59, 1, '辽宁省'),
(60, 22, '河北省'),
(60, 24, '河北省'),
(60, 1, '河北省'),
(61, 22, '山西省'),
(61, 24, '山西省'),
(61, 1, '山西省'),
(62, 22, '青海省'),
(62, 24, '青海省'),
(62, 1, '青海省'),
(63, 22, '山东省'),
(63, 24, '山东省'),
(63, 1, '山东省'),
(64, 22, '河南省'),
(64, 24, '河南省'),
(64, 1, '河南省'),
(65, 22, '江苏省'),
(65, 24, '江苏省'),
(65, 1, '江苏省'),
(66, 22, '安徽省'),
(66, 24, '安徽省'),
(66, 1, '安徽省'),
(67, 22, '浙江省'),
(67, 24, '浙江省'),
(67, 1, '浙江省'),
(68, 22, '福建省'),
(68, 24, '福建省'),
(68, 1, '福建省'),
(69, 22, '江西省'),
(69, 24, '江西省'),
(69, 1, '江西省'),
(70, 22, '湖南省'),
(70, 24, '湖南省'),
(70, 1, '湖南省'),
(71, 22, '湖北省'),
(71, 24, '湖北省'),
(71, 1, '湖北省'),
(72, 22, '广东省'),
(72, 24, '广东省'),
(72, 1, '广东省'),
(73, 22, '台湾省'),
(73, 24, '台湾省'),
(73, 1, '台湾省'),
(74, 22, '海南省'),
(74, 24, '海南省'),
(74, 1, '海南省'),
(75, 22, '甘肃省'),
(75, 24, '甘肃省'),
(75, 1, '甘肃省'),
(76, 22, '陕西省'),
(76, 24, '陕西省'),
(76, 1, '陕西省'),
(77, 22, '四川省'),
(77, 24, '四川省'),
(77, 1, '四川省'),
(78, 22, '贵州省'),
(78, 24, '贵州省'),
(78, 1, '贵州省'),
(79, 22, '云南省'),
(79, 24, '云南省'),
(79, 1, '云南省'),
(80, 22, '北京'),
(80, 24, '北京'),
(80, 1, '北京'),
(81, 22, '天津'),
(81, 24, '天津'),
(81, 1, '天津'),
(82, 22, '上海'),
(82, 24, '上海'),
(82, 1, '上海'),
(83, 22, '重庆'),
(83, 24, '重庆'),
(83, 1, '重庆'),
(84, 22, '内蒙古自治区'),
(84, 24, '内蒙古自治区'),
(84, 1, '内蒙古自治区'),
(85, 22, '维吾尔自治区'),
(85, 24, '维吾尔自治区'),
(85, 1, '维吾尔自治区'),
(86, 22, '西藏自治区'),
(86, 24, '西藏自治区'),
(86, 1, '西藏自治区'),
(87, 22, '宁夏回族自治区'),
(87, 24, '宁夏回族自治区'),
(87, 1, '宁夏回族自治区'),
(88, 22, '广西壮族自治区'),
(88, 24, '广西壮族自治区'),
(88, 1, '广西壮族自治区'),
(89, 22, '香港特别行政区'),
(89, 24, '香港特别行政区'),
(89, 1, '香港特别行政区'),
(90, 22, '澳门特别行政区'),
(90, 24, '澳门特别行政区'),
(90, 1, '澳门特别行政区');

CREATE TABLE `PREFIX_zone` (
  `id_zone` int(10) unsigned NOT NULL auto_increment,
  `active` tinyint(1) unsigned NOT NULL default '0',
  `enabled` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id_zone`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

INSERT INTO `PREFIX_zone` (`id_zone`, `active`, `enabled`) VALUES
(1, 1, 1),
(2, 1, 1),
(3, 1, 1),
(4, 1, 1),
(5, 1, 1);

CREATE TABLE `PREFIX_zone_lang` (
  `id_zone` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(64) NOT NULL,
  UNIQUE KEY `zone_lang_index` (`id_zone`,`id_lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `PREFIX_zone_lang` (`id_zone`, `id_lang`, `name`) VALUES
(1, 22, '欧洲'),
(1, 24, '歐洲'),
(1, 1, 'Europe'),
(2, 22, '美洲'),
(2, 24, '美洲'),
(2, 1, 'US'),
(3, 22, '亚洲'),
(3, 24, '亞洲'),
(3, 1, 'Asia'),
(4, 22, '非洲'),
(4, 24, '非洲'),
(4, 1, 'Africa'),
(5, 22, '大洋洲'),
(5, 24, '大洋洲'),
(5, 1, 'Oceania');



/* CONFIGURATION VARIABLE */