-- phpMyAdmin SQL Dump-- version 2.8.0.3-- http://www.phpmyadmin.net-- -- 主機(jī): localhost-- 生成日期: 2006 年 11 月 02 日 16:55-- 服務(wù)器版本: 3.23.58-- PHP 版本: 4.4.2-- -- 數(shù)據(jù)庫: `ecs_liuw`-- -- -- 導(dǎo)出表中的數(shù)據(jù) `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您已經(jīng)進(jìn)行了密碼重置的操作，請(qǐng)點(diǎn)擊以下鏈接(或者復(fù)制到您的瀏覽器):<br>\n<br>\n<a href="{$reset_email}" target="_blank">{$reset_email}</a><br>\n<br>\ n以確認(rèn)您的新密碼重置操作！<br>\n<br>\n{$shop_name}<br>\n{$ send_date}', 1194824789, 0, 'template'),(2, 'order_confirm', 0, '訂單確認(rèn)通知', '親愛的{$order.consignee}，你好！ \n\n我們已經(jīng)收到您於{$order.formated_add_time}提交的訂單，該訂單編號(hào)為：{$order.order_sn}請(qǐng)記住這個(gè)編號(hào)以便日後的查詢。\n\n{$shop_name}\n{$sent_date}\n\n\n', 1158226370, 0, 'template'),(3, 'deliver_notice', 1, '發(fā)貨通知', '親愛的{$order.consignee}。你好！</br></br>\n\n您的訂單{$ order.order_sn}已於{$send_time}按照您預(yù)定的配送方式給您發(fā)貨了。</br>\n</br>\n {if $order.invoice_no}發(fā)貨單號(hào)是{$order.invoice_no}。</ br>{/if}\n</br>\n在您收到貨物之後請(qǐng)點(diǎn)擊下面的鏈接確認(rèn)您已經(jīng)收到貨物：</br>\n<a href="{$confirm_url}" target= "_blank">{$confirm_url}</a></br></br>\n如果您還沒有收到貨物可以點(diǎn)擊以下鏈接給我們留言：</br></br>\n<a href ="{$send_msg_url}" target="_blank">{$send_msg_url}</a></br>\n<br>\n再次感謝您對(duì)我們的支持。歡迎您的再次光臨。 <br>\ n<br>\n{$shop_name} </br>\n{$send_date}', 1194823291, 0, 'template'),(4, 'order_cancel', 0, '訂單取消', '親愛的{$order.consignee}，你好！ \n\n您的編號(hào)為：{$order.order_sn}的訂單已取消。\n\ n{$shop_name}\n{$send_date}', 1156491130, 0, 'template'),(5, 'order_invalid', 0, '訂單無效', '親愛的{$order.consignee}，你好！\n\n您的編號(hào)為：{$order.order_sn}的訂單無效。\n\n {$shop_name}\n{$send_date}', 1156491164, 0, 'template'),(6, 'send_bonus', 0, '發(fā)紅包', '親愛的{$user_name}您好！\n\n恭喜您獲得了{(lán)$count}個(gè)紅包，金額{if $count > 1}分別{/ if}為{$money}\n\n{$shop_name}\n{$send_date}\n', 1156491184, 0, 'template'),(7, 'group_buy', 1, '團(tuán)購商品', '親愛的{$consignee}，您好！<br>\n<br>\n您於{$order_time}在本店參加團(tuán)購商品活動(dòng)，所購買的商品名稱為：{$goods_name}，數(shù)量：{$goods_number}，訂單號(hào)為：{$order_sn}，訂單金額為：{$ order_amount}<br>\n<br>\n此團(tuán)購商品現(xiàn)在已到結(jié)束日期，並達(dá)到最低價(jià)格，您現(xiàn)在可以對(duì)該訂單付款。 <br>\n<br>\n請(qǐng)點(diǎn)擊下面的鏈接：<br>\n<a href="{$shop_url} " target="_blank">{$shop_url}</a><br>\n<br>\n請(qǐng)盡快登錄到用戶中心，查看您的訂單詳情信息。 <br>\n<br>\n{ $shop_name} <br>\n<br>\n{$send_date}', 1194824668, 0, 'template'),(8, 'register_validate', 1, '郵件驗(yàn)證', '{$user_name}您好！<br><br>\r\n\r\n這封郵件是{$shop_name}發(fā)送的。你收到這封郵件是為了驗(yàn)證你註冊郵件地址是否有效。如果您已經(jīng)通過驗(yàn)證了，請(qǐng)忽略這封郵件。<br>\r\n請(qǐng)點(diǎn)擊以下鏈接(或者復(fù)製到您的瀏覽器)來驗(yà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}商品的詳細(xì)信息如下:\r\n{foreach from=$virtual_card item=card}\r\n{if $card.card_sn}卡號(hào)：{$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再次感謝您對(duì)我們的支持。歡迎您的再次光臨。\r\n\r\n{$shop_name} \r\n{$send_date}', 1162201031, 0, 'template'),(10, 'attention_list', 0, '關(guān)注商品', '親愛的{$user_name}您好~\n\n您關(guān)注的商品: {$goods_name}最近已經(jīng)更新,請(qǐng)您查看最新的商品信息\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               系統(tǒng)提醒\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, '內(nèi)蒙古', 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, '雲(yún)南', 1),(27, 1, '西藏', 1),(28, 1, '陝西', 1),(29, 1, '甘肅', 1),(30, 1, '青海', 1),(31, 1, '寧夏', 1),(32, 1, '新疆', 1),(33, 1, '香港', 1),(34, 1, '臺(tái)灣', 1),(35, 2, '北京', 2),(36, 3, '天津', 2),(37, 4, '石家莊', 2),(38, 4, '唐山', 2),(39, 4, '秦皇島', 2),(40, 4, '邯鄲', 2),(41, 4, '邢臺(tái)', 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, '運(yùn)城', 2),(56, 5, '忻州', 2),(57, 5, '臨汾', 2),(58, 5, '呂梁', 2),(59, 5, '侯馬', 2),(60, 5, '五臺(tái)山', 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, '七臺(tái)河', 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, '連雲(yún)港', 2),(118, 11, '淮安', 2),(119, 11, '鹽城', 2),(120, 11, '揚(yáng)州', 2),(121, 11, '鎮(zhèn)江', 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, '臺(tái)州', 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, '景德鎮(zhèn)', 2),(163, 15, '萍鄉(xiāng)', 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, '濟(jì)南', 2),(173, 16, '青島', 2),(174, 16, '淄博', 2),(175, 16, '棗莊', 2),(176, 16, '東營', 2),(177, 16, '煙臺(tái)', 2),(178, 16, '濰坊', 2),(179, 16, '濟(jì)寧', 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, '新鄉(xiāng)', 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, '韶關(guān)', 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, '清遠(yuǎn)', 2),(249, 20, '東莞', 2),(250, 20, '中山', 2),(251, 20, '潮州', 2),(252, 20, '揭陽', 2),