data_zh_cn.sql

ECSHOP是一款开源免费的通用电子商务平台构建软件

-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2006 年 11 月 02 日 16:55
-- 服务器版本: 3.23.58
-- PHP 版本: 4.4.2
--
-- 数据库: `ecs_liuw`
--


--
-- 导出表中的数据 `ecs_admin_action`
--

INSERT INTO `ecs_admin_action` (`action_id`, `parent_id`, `action_code`) VALUES (1, 0, 'goods'),
(2, 0, 'cms_manage'),
(3, 0, 'users_manage'),
(4, 0, 'priv_manage'),
(5, 0, 'sys_manage'),
(6, 0, 'order_manage'),
(7, 0, 'promotion'),
(8, 0, 'email'),
(9, 0, 'templates_manage'),
(10, 0, 'db_manage'),
(11, 0, 'sms_manage'),
(21, 1, 'goods_manage'),
(22, 1, 'remove_back'),
(23, 1, 'cat_manage'),
(24, 1, 'cat_drop'),
(25, 1, 'attr_manage'),
(26, 1, 'brand_manage'),
(27, 1, 'comment_priv'),
(84, 1, 'tag_manage'),
(30, 2, 'article_cat'),
(31, 2, 'article_manage'),
(32, 2, 'shopinfo_manage'),
(33, 2, 'shophelp_manage'),
(34, 2, 'vote_priv'),
(35, 7, 'topic_manage'),
(74, 4, 'template_manage'),
(73, 3, 'feedback_priv'),
(38, 3, 'integrate_users'),
(39, 3, 'sync_users'),
(40, 3, 'users_manage'),
(41, 3, 'users_drop'),
(42, 3, 'user_rank'),
(85, 3, 'surplus_manage'),
(43, 4, 'admin_manage'),
(44, 4, 'admin_drop'),
(45, 4, 'allot_priv'),
(46, 4, 'logs_manage'),
(47, 4, 'logs_drop'),
(48, 5, 'shop_config'),
(49, 5, 'ship_manage'),
(50, 5, 'payment'),
(51, 5, 'shiparea_manage'),
(52, 5, 'area_manage'),
(53, 6, 'order_os_edit'),
(54, 6, 'order_ps_edit'),
(55, 6, 'order_ss_edit'),
(56, 6, 'order_edit'),
(57, 6, 'order_view'),
(58, 6, 'order_view_finished'),
(59, 6, 'repay_manage'),
(60, 6, 'booking'),
(61, 6, 'sale_order_stats'),
(62, 6, 'client_flow_stats'),
(78, 7, 'snatch_manage'),
(83, 7, 'ad_manage'),
(80, 7, 'gift_manage'),
(81, 7, 'card_manage'),
(70, 1, 'goods_type'),
(82, 7, 'pack'),
(79, 7, 'bonus_manage'),
(75, 5, 'friendlink'),
(76, 5, 'db_backup'),
(77, 5, 'db_renew'),
(86, 4, 'agency_manage'),
(87, 3, 'account_manage'),
(88 ,5, 'flash_manage'),
(89 ,5, 'navigator'),
(90 ,7, 'auction'),
(91 ,7, 'group_by'),
(92 ,7, 'favourable'),
(93 ,7, 'whole_sale'),
(94 ,1, 'goods_auto'),
(95 ,2, 'article_auto'),
(96 ,5, 'cron'),
(97 ,5, 'affiliate'),
(98 ,5, 'affiliate_ck'),
(99 ,8, 'attention_list'),
(100 ,8, 'email_list'),
(101 ,8, 'magazine_list'),
(102 ,8, 'view_sendlist'),
(103, 1, 'virualcard'),
(104, 7, 'package_manage'),
(105, 1, 'picture_batch'),
(106, 1, 'goods_export'),
(107, 1, 'goods_batch'),
(108, 1, 'gen_goods_script'),
(109, 5, 'sitemap'),
(110, 5, 'file_priv'),
(111, 5, 'file_check'),
(112, 9, 'template_select'),
(113, 9, 'template_setup'),
(114, 9, 'library_manage'),
(115, 9, 'lang_edit'),
(116, 9, 'backup_setting'),
(117, 9, 'mail_template'),
(118, 10, 'db_backup'),
(119, 10, 'db_renew'),
(120, 10, 'db_optimize'),
(121, 10, 'sql_query'),
(122, 10, 'convert'),
(123, 11, 'my_info'),
(124, 11, 'sms_send'),
(125, 11, 'sms_charge'),
(126, 11, 'send_history'),
(127, 11, 'charge_history'),
(128, 7, 'exchange_goods');

--
--  `ecs_mail_templates`
--
INSERT INTO `ecs_mail_templates` (`template_id`, `template_code`, `is_html`, `template_subject`, `template_content`, `last_modify`, `last_send`, `type`) VALUES
(1, 'send_password', 1, '密码找回', '{$user_name}您好！<br>\n<br>\n您已经进行了密码重置的操作，请点击以下链接(或者复制到您的浏览器):<br>\n<br>\n<a href="{$reset_email}" target="_blank">{$reset_email}</a><br>\n<br>\n以确认您的新密码重置操作！<br>\n<br>\n{$shop_name}<br>\n{$send_date}', 1194824789, 0, 'template'),
(2, 'order_confirm', 0, '订单确认通知', '亲爱的{$order.consignee}，你好！ \n\n我们已经收到您于 {$order.formated_add_time} 提交的订单，该订单编号为：{$order.order_sn} 请记住这个编号以便日后的查询。\n\n{$shop_name}\n{$sent_date}\n\n\n', 1158226370, 0, 'template'),
(3, 'deliver_notice', 1, '发货通知', '亲爱的{$order.consignee}。你好！</br></br>\n\n您的订单{$order.order_sn}已于{$send_time}按照您预定的配送方式给您发货了。</br>\n</br>\n{if $order.invoice_no}发货单号是{$order.invoice_no}。</br>{/if}\n</br>\n在您收到货物之后请点击下面的链接确认您已经收到货物：</br>\n<a href="{$confirm_url}" target="_blank">{$confirm_url}</a></br></br>\n如果您还没有收到货物可以点击以下链接给我们留言：</br></br>\n<a href="{$send_msg_url}" target="_blank">{$send_msg_url}</a></br>\n<br>\n再次感谢您对我们的支持。欢迎您的再次光临。 <br>\n<br>\n{$shop_name} </br>\n{$send_date}', 1194823291, 0, 'template'),
(4, 'order_cancel', 0, '订单取消', '亲爱的{$order.consignee}，你好！ \n\n您的编号为：{$order.order_sn}的订单已取消。\n\n{$shop_name}\n{$send_date}', 1156491130, 0, 'template'),
(5, 'order_invalid', 0, '订单无效', '亲爱的{$order.consignee}，你好！\n\n您的编号为：{$order.order_sn}的订单无效。\n\n{$shop_name}\n{$send_date}', 1156491164, 0, 'template'),
(6, 'send_bonus', 0, '发红包', '亲爱的{$user_name}您好！\n\n恭喜您获得了{$count}个红包，金额{if $count > 1}分别{/if}为{$money}\n\n{$shop_name}\n{$send_date}\n', 1156491184, 0, 'template'),
(7, 'group_buy', 1, '团购商品', '亲爱的{$consignee}，您好！<br>\n<br>\n您于{$order_time}在本店参加团购商品活动，所购买的商品名称为：{$goods_name}，数量：{$goods_number}，订单号为：{$order_sn}，订单金额为：{$order_amount}<br>\n<br>\n此团购商品现在已到结束日期，并达到最低价格，您现在可以对该订单付款。<br>\n<br>\n请点击下面的链接：<br>\n<a href="{$shop_url}" target="_blank">{$shop_url}</a><br>\n<br>\n请尽快登录到用户中心，查看您的订单详情信息。 <br>\n<br>\n{$shop_name} <br>\n<br>\n{$send_date}', 1194824668, 0, 'template'),
(8, 'register_validate', 1, '邮件验证', '{$user_name}您好！<br><br>\r\n\r\n这封邮件是 {$shop_name} 发送的。你收到这封邮件是为了验证你注册邮件地址是否有效。如果您已经通过验证了，请忽略这封邮件。<br>\r\n请点击以下链接(或者复制到您的浏览器)来验证你的邮件地址:<br>\r\n<a href="{$validate_email}" target="_blank">{$validate_email}</a><br><br>\r\n\r\n{$shop_name}<br>\r\n{$send_date}', 1162201031, 0, 'template'),
(9, 'virtual_card', 0, '虚拟卡片', '亲爱的{$order.consignee}\r\n你好！您的订单{$order.order_sn}中{$goods.goods_name} 商品的详细信息如下:\r\n{foreach from=$virtual_card item=card}\r\n{if $card.card_sn}卡号：{$card.card_sn}{/if}{if $card.card_password}卡片密码：{$card.card_password}{/if}{if $card.end_date}截至日期：{$card.end_date}{/if}\r\n{/foreach}\r\n再次感谢您对我们的支持。欢迎您的再次光临。\r\n\r\n{$shop_name} \r\n{$send_date}', 1162201031, 0, 'template'),
(10, 'attention_list', 0, '关注商品', '亲爱的{$user_name}您好~\n\n您关注的商品 : {$goods_name} 最近已经更新,请您查看最新的商品信息\n\n{$goods_url}\r\n\r\n{$shop_name} \r\n{$send_date}', 1183851073, 0, 'template'),
(11, 'remind_of_new_order', 0, '新订单通知', '亲爱的店长，您好：\n   快来看看吧，又有新订单了。\n    订单号:{$order.order_sn} \n 订单金额:{$order.order_amount}，\n 用户购买商品:{foreach from=$goods_list item=goods_data}{$goods_data.goods_name}(货号:{$goods_data.goods_sn})    {/foreach} \n\n 收货人:{$order.consignee}， \n 收货人地址:{$order.address}，\n 收货人电话:{$order.tel} {$order.mobile}, \n 配送方式:{$order.shipping_name}(费用:{$order.shipping_fee}), \n 付款方式:{$order.pay_name}(费用:{$order.pay_fee})。\n\n               系统提醒\n               {$send_date}', 1196239170, 0, 'template');

--
--  `ecs_region`
--

INSERT INTO `ecs_region` (`region_id`, `parent_id`, `region_name`, `region_type`, `agency_id`) VALUES (1, 0, '中国', 0, 0),
(2, 1, '北京', 1, 0),
(3, 1, '安徽', 1, 0),
(4, 1, '福建', 1, 0),
(5, 1, '甘肃', 1, 0),
(6, 1, '广东', 1, 0),
(7, 1, '广西', 1, 0),
(8, 1, '贵州', 1, 0),
(9, 1, '海南', 1, 0),
(10, 1, '河北', 1, 0),
(11, 1, '河南', 1, 0),
(12, 1, '黑龙江', 1, 0),
(13, 1, '湖北', 1, 0),
(14, 1, '湖南', 1, 0),
(15, 1, '吉林', 1, 0),
(16, 1, '江苏', 1, 0),
(17, 1, '江西', 1, 0),
(18, 1, '辽宁', 1, 0),
(19, 1, '内蒙古', 1, 0),
(20, 1, '宁夏', 1, 0),
(21, 1, '青海', 1, 0),
(22, 1, '山东', 1, 0),
(23, 1, '山西', 1, 0),
(24, 1, '陕西', 1, 0),
(25, 1, '上海', 1, 0),
(26, 1, '四川', 1, 0),
(27, 1, '天津', 1, 0),
(28, 1, '西藏', 1, 0),
(29, 1, '新疆', 1, 0),
(30, 1, '云南', 1, 0),
(31, 1, '浙江', 1, 0),
(32, 1, '重庆', 1, 0),
(33, 1, '香港', 1, 0),
(34, 1, '澳门', 1, 0),
(35, 1, '台湾', 1, 0),
(36, 3, '安庆', 2, 0),
(37, 3, '蚌埠', 2, 0),
(38, 3, '巢湖', 2, 0),
(39, 3, '池州', 2, 0),
(40, 3, '滁州', 2, 0),
(41, 3, '阜阳', 2, 0),
(42, 3, '淮北', 2, 0),
(43, 3, '淮南', 2, 0),
(44, 3, '黄山', 2, 0),
(45, 3, '六安', 2, 0),
(46, 3, '马鞍山', 2, 0),
(47, 3, '宿州', 2, 0),
(48, 3, '铜陵', 2, 0),
(49, 3, '芜湖', 2, 0),
(50, 3, '宣城', 2, 0),
(51, 3, '亳州', 2, 0),
(52, 2, '北京', 2, 0),
(53, 4, '福州', 2, 0),
(54, 4, '龙岩', 2, 0),
(55, 4, '南平', 2, 0),
(56, 4, '宁德', 2, 0),
(57, 4, '莆田', 2, 0),
(58, 4, '泉州', 2, 0),
(59, 4, '三明', 2, 0),
(60, 4, '厦门', 2, 0),
(61, 4, '漳州', 2, 0),
(62, 5, '兰州', 2, 0),
(63, 5, '白银', 2, 0),
(64, 5, '定西', 2, 0),
(65, 5, '甘南', 2, 0),
(66, 5, '嘉峪关', 2, 0),
(67, 5, '金昌', 2, 0),
(68, 5, '酒泉', 2, 0),
(69, 5, '临夏', 2, 0),
(70, 5, '陇南', 2, 0),
(71, 5, '平凉', 2, 0),
(72, 5, '庆阳', 2, 0),
(73, 5, '天水', 2, 0),
(74, 5, '武威', 2, 0),
(75, 5, '张掖', 2, 0),
(76, 6, '广州', 2, 0),
(77, 6, '深圳', 2, 0),
(78, 6, '潮州', 2, 0),
(79, 6, '东莞', 2, 0),
(80, 6, '佛山', 2, 0),
(81, 6, '河源', 2, 0),
(82, 6, '惠州', 2, 0),
(83, 6, '江门', 2, 0),
(84, 6, '揭阳', 2, 0),
(85, 6, '茂名', 2, 0),
(86, 6, '梅州', 2, 0),
(87, 6, '清远', 2, 0),
(88, 6, '汕头', 2, 0),
(89, 6, '汕尾', 2, 0),
(90, 6, '韶关', 2, 0),
(91, 6, '阳江', 2, 0),
(92, 6, '云浮', 2, 0),
(93, 6, '湛江', 2, 0),
(94, 6, '肇庆', 2, 0),
(95, 6, '中山', 2, 0),
(96, 6, '珠海', 2, 0),
(97, 7, '南宁', 2, 0),
(98, 7, '桂林', 2, 0),
(99, 7, '百色', 2, 0),
(100, 7, '北海', 2, 0),
(101, 7, '崇左', 2, 0),
(102, 7, '防城港', 2, 0),
(103, 7, '贵港', 2, 0),
(104, 7, '河池', 2, 0),
(105, 7, '贺州', 2, 0),
(106, 7, '来宾', 2, 0),
(107, 7, '柳州', 2, 0),
(108, 7, '钦州', 2, 0),
(109, 7, '梧州', 2, 0),
(110, 7, '玉林', 2, 0),
(111, 8, '贵阳', 2, 0),
(112, 8, '安顺', 2, 0),
(113, 8, '毕节', 2, 0),
(114, 8, '六盘水', 2, 0),
(115, 8, '黔东南', 2, 0),
(116, 8, '黔南', 2, 0),
(117, 8, '黔西南', 2, 0),
(118, 8, '铜仁', 2, 0),
(119, 8, '遵义', 2, 0),
(120, 9, '海口', 2, 0),
(121, 9, '三亚', 2, 0),
(122, 9, '白沙', 2, 0),
(123, 9, '保亭', 2, 0),
(124, 9, '昌江', 2, 0),
(125, 9, '澄迈县', 2, 0),
(126, 9, '定安县', 2, 0),
(127, 9, '东方', 2, 0),
(128, 9, '乐东', 2, 0),
(129, 9, '临高县', 2, 0),
(130, 9, '陵水', 2, 0),
(131, 9, '琼海', 2, 0),
(132, 9, '琼中', 2, 0),
(133, 9, '屯昌县', 2, 0),
(134, 9, '万宁', 2, 0),
(135, 9, '文昌', 2, 0),
(136, 9, '五指山', 2, 0),
(137, 9, '儋州', 2, 0),
(138, 10, '石家庄', 2, 0),
(139, 10, '保定', 2, 0),
(140, 10, '沧州', 2, 0),
(141, 10, '承德', 2, 0),
(142, 10, '邯郸', 2, 0),
(143, 10, '衡水', 2, 0),
(144, 10, '廊坊', 2, 0),
(145, 10, '秦皇岛', 2, 0),
(146, 10, '唐山', 2, 0),
(147, 10, '邢台', 2, 0),
(148, 10, '张家口', 2, 0),
(149, 11, '郑州', 2, 0),
(150, 11, '洛阳', 2, 0),
(151, 11, '开封', 2, 0),
(152, 11, '安阳', 2, 0),
(153, 11, '鹤壁', 2, 0),
(154, 11, '济源', 2, 0),
(155, 11, '焦作', 2, 0),
(156, 11, '南阳', 2, 0),
(157, 11, '平顶山', 2, 0),
(158, 11, '三门峡', 2, 0),
(159, 11, '商丘', 2, 0),
(160, 11, '新乡', 2, 0),
(161, 11, '信阳', 2, 0),
(162, 11, '许昌', 2, 0),
(163, 11, '周口', 2, 0),
(164, 11, '驻马店', 2, 0),
(165, 11, '漯河', 2, 0),
(166, 11, '濮阳', 2, 0),
(167, 12, '哈尔滨', 2, 0),
(168, 12, '大庆', 2, 0),
(169, 12, '大兴安岭', 2, 0),
(170, 12, '鹤岗', 2, 0),
(171, 12, '黑河', 2, 0),
(172, 12, '鸡西', 2, 0),
(173, 12, '佳木斯', 2, 0),
(174, 12, '牡丹江', 2, 0),
(175, 12, '七台河', 2, 0),
(176, 12, '齐齐哈尔', 2, 0),
(177, 12, '双鸭山', 2, 0),
(178, 12, '绥化', 2, 0),
(179, 12, '伊春', 2, 0),
(180, 13, '武汉', 2, 0),
(181, 13, '仙桃', 2, 0),
(182, 13, '鄂州', 2, 0),
(183, 13, '黄冈', 2, 0),
(184, 13, '黄石', 2, 0),
(185, 13, '荆门', 2, 0),
(186, 13, '荆州', 2, 0),
(187, 13, '潜江', 2, 0),
(188, 13, '神农架林区', 2, 0),
(189, 13, '十堰', 2, 0),
(190, 13, '随州', 2, 0),
(191, 13, '天门', 2, 0),
(192, 13, '咸宁', 2, 0),
(193, 13, '襄樊', 2, 0),
(194, 13, '孝感', 2, 0),
(195, 13, '宜昌', 2, 0),
(196, 13, '恩施', 2, 0),
(197, 14, '长沙', 2, 0),
(198, 14, '张家界', 2, 0),
(199, 14, '常德', 2, 0),
(200, 14, '郴州', 2, 0),
(201, 14, '衡阳', 2, 0),
(202, 14, '怀化', 2, 0),
(203, 14, '娄底', 2, 0),
(204, 14, '邵阳', 2, 0),
(205, 14, '湘潭', 2, 0),
(206, 14, '湘西', 2, 0),
(207, 14, '益阳', 2, 0),
(208, 14, '永州', 2, 0),
(209, 14, '岳阳', 2, 0),
(210, 14, '株洲', 2, 0),
(211, 15, '长春', 2, 0),
(212, 15, '吉林', 2, 0),
(213, 15, '白城', 2, 0),
(214, 15, '白山', 2, 0),
(215, 15, '辽源', 2, 0),
(216, 15, '四平', 2, 0),
(217, 15, '松原', 2, 0),
(218, 15, '通化', 2, 0),
(219, 15, '延边', 2, 0),
(220, 16, '南京', 2, 0),
(221, 16, '苏州', 2, 0),
(222, 16, '无锡', 2, 0),
(223, 16, '常州', 2, 0),
(224, 16, '淮安', 2, 0),
(225, 16, '连云港', 2, 0),
(226, 16, '南通', 2, 0),
(227, 16, '宿迁', 2, 0),
(228, 16, '泰州', 2, 0),
(229, 16, '徐州', 2, 0),
(230, 16, '盐城', 2, 0),
(231, 16, '扬州', 2, 0),
(232, 16, '镇江', 2, 0),
(233, 17, '南昌', 2, 0),
(234, 17, '抚州', 2, 0),
(235, 17, '赣州', 2, 0),
(236, 17, '吉安', 2, 0),
(237, 17, '景德镇', 2, 0),
(238, 17, '九江', 2, 0),
(239, 17, '萍乡', 2, 0),
(240, 17, '上饶', 2, 0),
(241, 17, '新余', 2, 0),
(242, 17, '宜春', 2, 0),
(243, 17, '鹰潭', 2, 0),
(244, 18, '沈阳', 2, 0),
(245, 18, '大连', 2, 0),
(246, 18, '鞍山', 2, 0),
(247, 18, '本溪', 2, 0),
(248, 18, '朝阳', 2, 0),
(249, 18, '丹东', 2, 0),
(250, 18, '抚顺', 2, 0),
(251, 18, '阜新', 2, 0),
(252, 18, '葫芦岛', 2, 0),
(253, 18, '锦州', 2, 0),
(254, 18, '辽阳', 2, 0),
(255, 18, '盘锦', 2, 0),
(256, 18, '铁岭', 2, 0),
(257, 18, '营口', 2, 0),
(258, 19, '呼和浩特', 2, 0),
(259, 19, '阿拉善盟', 2, 0),
(260, 19, '巴彦淖尔盟', 2, 0),
(261, 19, '包头', 2, 0),
(262, 19, '赤峰', 2, 0),
(263, 19, '鄂尔多斯', 2, 0),
(264, 19, '呼伦贝尔', 2, 0),
(265, 19, '通辽', 2, 0),