-- 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),