(253, 20, '雲浮', 2),(254, 21, '南寧', 2),(255, 21, '柳州', 2),(256, 21, '桂林', 2),(257, 21, '梧州', 2),(258, 21, '北海', 2),(259, 21, '防城港', 2),(260, 21, '欽州', 2),(261, 21, '貴港', 2),(262, 21, '玉林', 2),(263, 21, '百色', 2),(264, 21, '賀州', 2),(265, 21, '河池', 2),(266, 21, '來賓', 2),(267, 21, '崇左', 2),(268, 22, '海口', 2),(269, 22, '三亞', 2),(270, 22, '其他', 2),(271, 23, '重慶', 2),(272, 24, '成都', 2),(273, 24, '自貢', 2),(274, 24, '攀枝花', 2),(275, 24, '瀘州', 2),(276, 24, '德陽', 2),(277, 24, '綿陽', 2),(278, 24, '廣元', 2),(279, 24, '遂寧', 2),(280, 24, '內江', 2),(281, 24, '樂山', 2),(282, 24, '南充', 2),(283, 24, '宜賓', 2),(284, 24, '廣安', 2),(285, 24, '達州', 2),(286, 24, '眉山', 2),(287, 24, '雅安', 2),(288, 24, '巴中', 2),(289, 24, '資陽', 2),(290, 24, '阿壩', 2),(291, 24, '甘孜', 2),(292, 24, '涼山', 2),(293, 25, '貴陽', 2),(294, 25, '六盤水', 2),(295, 25, '遵義', 2),(296, 25, '安順', 2),(297, 25, '銅仁', 2),(298, 25, '畢節', 2),(299, 25, '黔西南', 2),(300, 25, '黔東南', 2),(301, 25, '黔南', 2),(302, 26, '昆明', 2),(303, 26, '曲靖', 2),(304, 26, '玉溪', 2),(305, 26, '保山', 2),(306, 26, '昭通', 2),(307, 26, '麗江', 2),(308, 26, '思茅', 2),(309, 26, '臨滄', 2),(310, 26, '文山', 2),(311, 26, '紅河', 2),(312, 26, '西雙版納', 2),(313, 26, '楚雄', 2),(314, 26, '大理', 2),(315, 26, '德宏', 2),(316, 26, '怒江', 2),(317, 26, '迪慶', 2),(318, 27, '拉薩', 2),(319, 27, '昌都', 2),(320, 27, '山南', 2),(321, 27, '日喀則', 2),(322, 27, '那曲', 2),(323, 27, '阿里', 2),(324, 27, '林芝', 2),(325, 28, '西安', 2),(326, 28, '銅川', 2),(327, 28, '寶雞', 2),(328, 28, '咸陽', 2),(329, 28, '渭南', 2),(330, 28, '延安', 2),(331, 28, '漢中', 2),(332, 28, '榆林', 2),(333, 28, '安康', 2),(334, 28, '商洛', 2),(335, 29, '蘭州', 2),(336, 29, '嘉峪關', 2),(337, 29, '金昌', 2),(338, 29, '白銀', 2),(339, 29, '天水', 2),(340, 29, '武威', 2),(341, 29, '張掖', 2),(342, 29, '平涼', 2),(343, 29, '酒泉', 2),(344, 29, '慶陽', 2),(345, 29, '定西', 2),(346, 29, '隴南', 2),(347, 29, '臨夏', 2),(348, 29, '甘南', 2),(349, 30, '西寧', 2),(350, 30, '海東', 2),(351, 30, '海北', 2),(352, 30, '黃南', 2),(353, 30, '海南', 2),(354, 30, '果洛', 2),(355, 30, '玉樹', 2),(356, 30, '海西', 2),(357, 31, '銀川', 2),(358, 31, '石嘴山', 2),(359, 31, '吳忠', 2),(360, 31, '固原', 2),(361, 31, '中衛市', 2),(362, 32, '烏魯木齊', 2),(363, 32, '克拉瑪依', 2),(364, 32, '吐露番', 2),(365, 32, '哈密', 2),(366, 32, '和田', 2),(367, 32, '阿克蘇地區', 2),(368, 32, '喀什', 2),(369, 32, '克孜勒蘇', 2),(370, 32, '巴音郭楞', 2),(371, 32, '昌吉', 2),(372, 32, '博爾塔拉', 2),(373, 32, '伊犁', 2),(374, 32, '塔城', 2),(375, 32, '阿勒泰', 2),(376, 33, '中西區', 2),(377, 33, '東區', 2),(378, 33, '九龍城區', 2),(379, 33, '觀塘區', 2),(380, 33, '南區', 2),(381, 33, '深水埠區', 2),(382, 33, '黃大仙區', 2),(383, 33, '灣仔區', 2),(384, 33, '油尖旺區', 2),(385, 33, '離島區', 2),(386, 33, '葵青區', 2),(387, 33, '北區', 2),(388, 33, '西貢區', 2),(389, 33, '沙田區', 2),(390, 33, '屯門區', 2),(391, 33, '大埔區', 2),(392, 33, '荃灣區', 2),(393, 33, '元朗區', 2),(394, 34, '臺北市', 2),(395, 34, '高雄市', 2),(396, 34, '基隆市', 2),(397, 34, '臺中市', 2),(398, 34, '臺南市', 2),(399, 34, '新竹市', 2),(400, 34, '嘉義市', 2),(401, 34, '臺北縣', 2),(402, 34, '宜蘭縣', 2),(403, 34, '桃園縣', 2),(404, 34, '新竹縣', 2),(405, 34, '苗栗縣', 2),(406, 34, '臺中縣', 2),(407, 34, '彰化縣', 2),(408, 34, '南投縣', 2),(409, 34, '雲林縣', 2),(410, 34, '嘉義縣', 2),(411, 34, '臺南縣', 2),(412, 34, '高雄縣', 2),(413, 34, '屏東縣', 2),(414, 34, '澎湖縣', 2),(415, 34, '臺東縣', 2),(416, 34, '花蓮縣', 2),(417, 35, '三環以內包括亞運村', 3),(418, 35, '三環外四環內', 3);-- -- ? `ecs_shop_config`-- INSERT INTO `ecs_shop_config` (`id`, `parent_id`, `code`, `type`, `store_range`, `store_dir`, `value`, `sort_order`) VALUES (1, 0, 'shop_info', 'group', '', '', '', '1'),(2, 0, 'basic', 'group', '', '', '', '1'),(3, 0, 'display', 'group', '', '', '', '1'),(4, 0, 'shopping_flow', 'group', '', '', '', '1'),(5, 0, 'smtp', 'group', '', '', '', '1'),(6, 0, 'hidden', 'hidden', '', '', '', '1'),(7, 0, 'goods', 'group', '', '', '', '1'),(8, 0, 'sms', 'group', '', '', '', '1'),(9, 0, 'wap', 'group', '', '', '', '1'),(101, 1, 'shop_name', 'text', '', '', 'ECSHOP', '1'),(102, 1, 'shop_title', 'text', '', '', 'ECSHOP演示站', '1'),(103, 1, 'shop_desc', 'text', '', '', '', '1'),(104, 1, 'shop_keywords', 'text', '', '', '', '1'),(105, 1, 'shop_country', 'manual', '', '', '1', '1'),(106, 1, 'shop_province', 'manual', '', '', '', '1'),(107, 1, 'shop_city', 'manual', '', '', '', '1'),(108, 1, 'shop_address', 'text', '', '', '', '1'),(109, 1, 'qq', 'text', '', '', '', '1'),(110, 1, 'ww', 'text', '', '', '', '1'),(111, 1, 'skype', 'text', '', '', '', '1'),(112, 1, 'ym', 'text', '', '', '', '1'),(113, 1, 'msn', 'text', '', '', '', '1'),(114, 1, 'service_email', 'text', '', '', '', '1'),(115, 1, 'service_phone', 'text', '', '', '', '1'),(116, 1, 'shop_closed', 'select', '0,1', '', '0', '1'),(117, 1, 'close_comment', 'textarea', '', '', '', '1'),(118, 1, 'shop_logo', 'file', '', '../themes/{$template}/images/', '', '1'),(120, 1, 'user_notice', 'textarea', '', '', '用戶中心公告！', '1'),(121, 1, 'shop_notice', 'textarea', '', '', '商店公告', '1'),(201, 2, 'lang', 'manual', '', '', 'zh_cn', '1'),(202, 2, 'icp_number', 'text', '', '', '', '1'),(203, 2, 'icp_file', 'file', '', '../cert/', '', '1'),(204, 2, 'watermark', 'file', '', '../images/', '', '1'),(205, 2, 'watermark_place', 'select', '0,1,2,3,4,5', '', '1', '1'),(206, 2, 'watermark_alpha', 'text', '', '', '65', '1'),(207, 2, 'use_storage', 'select', '1,0', '', '1', '1'),(208, 2, 'market_price_rate', 'text', '', '', '1.2', '1'),(209, 2, 'rewrite', 'select', '0,1,2', '', '0', '1'),(210, 2, 'integral_name', 'text', '', '', '積分', '1'),(211, 2, 'integral_scale', 'text', '', '', '100', '1'),(212, 2, 'integral_percent', 'text', '', '', '0', '1'),(213, 2, 'sn_prefix', 'text', '', '', 'ECS', '1'),(214, 2, 'comment_check', 'select', '0,1', '', '1', '1'),(215, 2, 'no_picture', 'file', '', '../images/', '', '1'),(218, 2, 'stats_code', 'textarea', '', '', '', '1'),(219, 2, 'cache_time', 'text', '', '', '3600', '1'),(220, 2, 'register_points', 'text', '', '', '0', '1'),(221, 2, 'enable_gzip', 'select', '0,1', '', '0', '1'),(222, 2, 'top10_time', 'select', '0,1,2,3,4', '', '0', '1'),(223, 2, 'timezone', 'options', '-12,-11,-10,-9,-8,-7,-6,-5,-4,-3.5,-3,-2,-1,0,1,2,3,3.5,4,4.5,5,5.5,5.75,6,6.5,7,8,9,9.5,10,11,12', '', '8', '1'),(224, 2, 'upload_size_limit', 'options', 'default,0,64,128,256,512,1024,2048,4096', '', '0', '1'),(226, 2, 'cron_method', 'select', '0,1', '', '0', '1'),(227, 2, 'comment_factor', 'select', '0,1,2,3', '', '0', '1'),(228, 2, 'enable_order_check', 'select', '0,1', '', '0', '1'),(229, 2, 'default_storage', 'text', '', '', '1', '1'),(230, 2, 'bgcolor', 'text', '', '', '#FFFFFF', '1'),(231, 2, 'visit_stats', 'select', 'on,off', '', 'on', '1'),(301, 3, 'date_format', 'text', '', '', 'Y-m-d', '1'),(302, 3, 'time_format', 'text', '', '', 'Y-m-d H:i:s', '1'),(303, 3, 'currency_format', 'text', '', '', '￥%s元', '1'),(304, 3, 'thumb_width', 'text', '', '', '100', '1'),(305, 3, 'thumb_height', 'text', '', '', '100', '1'),(306, 3, 'image_width', 'text', '', '', '200', '1'),(307, 3, 'image_height', 'text', '', '', '200', '1'),(312, 3, 'top_number', 'text', '', '', '10', '1'),(313, 3, 'history_number', 'text', '', '', '5', '1'),(314, 3, 'comments_number', 'text', '', '', '5', '1'),(315, 3, 'bought_goods', 'text', '', '', '3', '1'),(316, 3, 'article_number', 'text', '', '', '4', '1'),(317, 3, 'goods_name_length', 'text', '', '', '10', '1'),(318, 3, 'price_format', 'select', '0,1,2,3,4,5', '', '0', '1'),(319, 3, 'page_size', 'text', '', '', '10', '1'),(320, 3, 'sort_order_type', 'select', '0,1,2', '', '0', '1'),(321, 3, 'sort_order_method', 'select', '0,1', '', '0', '1'),(322, 3, 'show_order_type', 'select', '0,1,2', '', '0', '1'),(323, 3, 'attr_related_number', 'text', '', '', '5', '1'),(324, 3, 'goods_gallery_number', 'text', '', '', '5', '1'),(325, 3, 'article_title_length', 'text', '', '', '18', '1'),(326, 3, 'name_of_region_1', 'text', '', '', '國家', '1'),(327, 3, 'name_of_region_2', 'text', '', '', '省', '1'),(328, 3, 'name_of_region_3', 'text', '', '', '市', '1'),(329, 3, 'name_of_region_4', 'text', '', '', '區', '1'),(330, 3, 'search_keywords', 'text', '', '', '', '0'),(332, 3, 'related_goods_number', 'text', '', '', '4', '1'),(333, 3, 'help_open', 'select', '0,1', '', '1', '1'),(401, 4, 'can_invoice', 'select', '1,0', '', '0', '1'),(402, 4, 'use_integral', 'select', '1,0', '', '0', '1'),(403, 4, 'use_bonus', 'select', '1,0', '', '1', '1'),(404, 4, 'use_surplus', 'select', '1,0', '', '1', '1'),(405, 4, 'use_how_oos', 'select', '1,0', '', '0', '1'),(406, 4, 'send_confirm_email', 'select', '1,0', '', '0', '1'),(407, 4, 'send_ship_email', 'select', '1,0', '', '0', '1'),(408, 4, 'send_cancel_email', 'select', '1,0', '', '0', '1'),(409, 4, 'send_invalid_email', 'select', '1,0', '', '0', '1'),(410, 4, 'order_pay_note', 'select', '1,0', '', '1', '1'),(411, 4, 'order_unpay_note', 'select', '1,0', '', '1', '1'),(412, 4, 'order_ship_note', 'select', '1,0', '', '1', '1'),(413, 4, 'order_receive_note', 'select', '1,0', '', '1', '1'),(414, 4, 'order_unship_note', 'select', '1,0', '', '1', '1'),(415, 4, 'order_return_note', 'select', '1,0', '', '1', '1'),(416, 4, 'order_invalid_note', 'select', '1,0', '', '1', '1'),(417, 4, 'order_cancel_note', 'select', '1,0', '', '1', '1'),(418, 4, 'invoice_content', 'textarea', '', '', '', '1'),(419, 4, 'anonymous_buy', 'select', '1,0', '', '1', '1'),(420, 4, 'min_goods_amount', 'text', '', '', '0', '1'),(421, 4, 'one_step_buy', 'select', '1,0', '', '0', '1'),(422, 4, 'invoice_type', 'manual', '', '', '', '1'),(423, 4, 'stock_dec_time', 'select', '1,0', '', '0', '1'),(424, 4, 'cart_confirm', 'options', '1,2,3,4', '', '3', '0'),(501, 5, 'smtp_host', 'text', '', '', 'localhost', '1'),(502, 5, 'smtp_port', 'text', '', '', '25', '1'),(503, 5, 'smtp_user', 'text', '', '', '', '1'),(504, 5, 'smtp_pass', 'password', '', '', '', '1'),(505, 5, 'smtp_mail', 'text', '', '', '', '1'),(506, 5, 'mail_charset', 'select', 'UTF8,GB2312,BIG5', '', 'UTF8', '1'),(507, 5, 'mail_service', 'select', '0,1', '', '0', '0'),(601, 6, 'integrate_code', 'hidden', '', '', 'ecshop', '1'),(602, 6, 'integrate_config', 'hidden', '', '', '', '1'),(603, 6, 'hash_code', 'hidden', '', '', '', '1'),(604, 6, 'template', 'hidden', '', '', 'default', '1'),(605, 6, 'install_date', 'hidden', '', '', '1160981726', '1'),(606, 6, 'ecs_version', 'hidden', '', '', '', '1'),(607, 6, 'sms_user_name', 'hidden', '', '', '', '1'),(608, 6, 'sms_password', 'hidden', '', '', '', '1'),(609, 6, 'sms_auth_str', 'hidden', '', '', '', '1'),(610, 6, 'sms_domain', 'hidden', '', '', '', '1'),(611, 6, 'sms_count', 'hidden', '', '', '', '1'),(612, 6, 'sms_total_money', 'hidden', '', '', '', '1'),(613, 6, 'sms_balance', 'hidden', '', '', '', '1'),(614, 6, 'sms_last_request', 'hidden', '', '', '', '1'),(616, 6, 'affiliate', 'hidden', '', '', 'a:3:{s:6:"config";a:7:{s:6:"expire";d:24;s:11:"expire_unit";s:4:"hour";s:11:"separate_by";i:0;s:15:"level_point_all";s:2:"5%";s:15:"level_money_all";s:2:"1%";s:18:"level_register_all";i:2;s:17:"level_register_up";i:60;}s:4:"item";a:4:{i:0;a:2:{s:11:"level_point";s:3:"60%";s:11:"level_money";s:3:"60%";}i:1;a:2:{s:11:"level_point";s:3:"30%";s:11:"level_money";s:3:"30%";}i:2;a:2:{s:11:"level_point";s:2:"7%";s:11:"level_money";s:2:"7%";}i:3;a:2:{s:11:"level_point";s:2:"3%";s:11:"level_money";s:2:"3%";}}s:2:"on";i:0;}', '1'),(617, 6, 'captcha', 'hidden', '', '', '0', '1'),(618, 6, 'captcha_width', 'hidden', '', '', '100', '1'),(619, 6, 'captcha_height', 'hidden', '', '', '20', '1'),(620, 6, 'sitemap', 'hidden', '', '', 'a:6:{s:19:"homepage_changefreq";s:6:"hourly";s:17:"homepage_priority";s:3:"0.9";s:19:"category_changefreq";s:6:"hourly";s:17:"category_priority";s:3:"0.8";s:18:"content_changefreq";s:6:"weekly";s:16:"content_priority";s:3:"0.7";}', 0),(621, 6, 'points_rule', 'hidden', '', '', '', ''),(701, 7, 'show_goodssn', 'select', '1,0', '', '1', '1'),(702, 7, 'show_brand', 'select', '1,0', '', '1', '1'),(703, 7, 'show_goodsweight', 'select', '1,0', '', '1', '1'),(704, 7, 'show_goodsnumber', 'select', '1,0', '', '1', '1'),(705, 7, 'show_addtime', 'select', '1,0', '', '1', '1'),(706, 7, 'goodsattr_style', 'select', '1,0', '', '1', '1'),(707, 7, 'show_marketprice', 'select', '1,0', '', '1', '1'),(801, 8, 'sms_shop_mobile', 'text', '', '', '', '1'),(802, 8, 'sms_order_placed', 'select', '1,0', '', '0', '1'),(803, 8, 'sms_order_payed', 'select', '1,0', '', '0', '1'),(804, 8, 'sms_order_shipped', 'select', '1,0', '', '0', '1'),(901, 9, 'wap_config', 'select', '1,0', '', '0', 1),(902, 9, 'wap_logo', 'file', '', '../images/', '', 1);---- user_rank--INSERT INTO `ecs_user_rank` (`rank_id`, `rank_name`, `min_points`, `max_points`, `discount`, `show_price`, `special_rank`)VALUES (NULL, '註冊用戶', '0', '10000', '100', 1, 0);---- 自定義導航欄--INSERT INTO `ecs_nav` (`id`, `name`, `ifshow`, `vieworder`, `opennew`, `url`, `type`) VALUES (1, '用戶中心', 1, 1, 0, 'user.php', 'top'),(2, '選購中心', 1, 2, 0, 'pick_out.php', 'top'),(3, '查看購物車', 1, 0, 0, 'flow.php', 'top'),(4, '團購商品', 1, 3, 0, 'group_buy.php', 'top'),(5, '奪寶奇兵', 1, 4, 0, 'snatch.php', 'top'),(6, '標籤雲', 1, 5, 6, 'tag_cloud.php', 'top'),(7, '免責條款', 1, 1, 0, 'article.php?id=1', 'bottom'),(8, '隱私保護', 1, 2, 0, 'article.php?id=2', 'bottom'),(9, '咨詢熱點', 1, 3, 0, 'article.php?id=3', 'bottom'),(10, '聯繫我們', 1, 4, 0, 'article.php?id=4', 'bottom'),(11, '公司簡介', 1, 5, 0, 'article.php?id=5', 'bottom'),(12, '批發方案', 1, 6, 0, 'wholesale.php', 'bottom'),(13, '優惠活動', 1, 7, 0, 'activity.php', 'top'),(14, '配送方式', 1, 7, 0, 'myship.php', 'bottom');-- 文章默認分類INSERT INTO `ecs_article_cat` (`cat_id`, `cat_name`, `cat_type`, `keywords`, `cat_desc`, `sort_order`, `parent_id`) VALUES (1, '系統分類', 2, '', '系統保留分類', 0, 0);INSERT INTO `ecs_article_cat` (`cat_id`, `cat_name`, `cat_type`, `keywords`, `cat_desc`, `sort_order`, `parent_id`) VALUES (2, '網店信息', 3, '', '網店信息分類', 0, 1);INSERT INTO `ecs_article_cat` (`cat_id`, `cat_name`, `cat_type`, `keywords`, `cat_desc`, `sort_order`, `parent_id`) VALUES (3, '網店幫助分類', 4, '', '網店幫助分類', 0, 1);-- -- ? `ecs_article`-- INSERT INTO `ecs_article` (`article_id`, `cat_id`, `title`, `content`, `author`, `author_email`, `keywords`, `article_type`, `is_open`, `add_time`, `file_url`, `open_type`) VALUES(1, 2, '免責條款', '', '', '', '', 0, 1, 0, '', 0),(2, 2, '隱私保護', '', '', '', '', 0, 1, 0, '', 0),(3, 2, '咨詢熱點', '', '', '', '', 0, 1, 0, '', 0),(4, 2, '聯繫我們', '', '', '', '', 0, 1, 0, '', 0),(5, 2, '公司簡介', '', '', '', '', 0, 1, 0, '', 0),(6, -1, '用戶協議', '', '', '', '', 0, 1, 0, '', 0);