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'),
(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');

-- 
--  `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   快来看看吧，又有新订单了。订单金额为{$order.order_amount}，收货人是{$order.consignee}，地址是{$order.address}，电话是{$order.tel} {$order.mobile}。\n\n               系统提醒\n               {$send_date}', 1196239170, 0, 'template');

-- 
--  `ecs_region`
-- 

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