-- phpMyAdmin SQL Dump -- version 4.0.10.7 -- http://www.phpmyadmin.net -- -- 主機: localhost -- 建立日期: 2015 年 04 月 06 日 14:41 -- 伺服器版本: 5.6.23 -- PHP 版本: 5.4.23 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- 資料庫: `dozqyhpa_test03` -- CREATE DATABASE IF NOT EXISTS `dozqyhpa_test03` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci; USE `dozqyhpa_test06`; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_account_log` -- DROP TABLE IF EXISTS `ecs_account_log`; CREATE TABLE IF NOT EXISTS `ecs_account_log` ( `log_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `user_id` mediumint(8) unsigned NOT NULL, `user_money` decimal(10,2) NOT NULL, `frozen_money` decimal(10,2) NOT NULL, `rank_points` mediumint(9) NOT NULL, `pay_points` mediumint(9) NOT NULL, `change_time` int(10) unsigned NOT NULL, `change_desc` varchar(255) NOT NULL, `change_type` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`log_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_ad` -- DROP TABLE IF EXISTS `ecs_ad`; CREATE TABLE IF NOT EXISTS `ecs_ad` ( `ad_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `position_id` smallint(5) unsigned NOT NULL DEFAULT '0', `media_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `ad_name` varchar(60) NOT NULL DEFAULT '', `ad_link` varchar(255) NOT NULL DEFAULT '', `ad_code` text NOT NULL, `start_time` int(11) NOT NULL DEFAULT '0', `end_time` int(11) NOT NULL DEFAULT '0', `link_man` varchar(60) NOT NULL DEFAULT '', `link_email` varchar(60) NOT NULL DEFAULT '', `link_phone` varchar(60) NOT NULL DEFAULT '', `click_count` mediumint(8) unsigned NOT NULL DEFAULT '0', `enabled` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`ad_id`), KEY `position_id` (`position_id`), KEY `enabled` (`enabled`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ; -- -- 資料表的匯出資料 `ecs_ad` -- INSERT INTO `ecs_ad` (`ad_id`, `position_id`, `media_type`, `ad_name`, `ad_link`, `ad_code`, `start_time`, `end_time`, `link_man`, `link_email`, `link_phone`, `click_count`, `enabled`) VALUES (1, 1, 2, '首頁輪撥', '', '\r\n\r\n\r\n\r\n \r\n \r\n \r\n\r\n
\r\n\r\n \r\n
\r\n
\r\n
\r\n
    \r\n
  • \r\n Joomla模板与内容的融合设计
  • \r\n
  • \r\n 野草工作室一直在用心建站
  • \r\n
  • \r\n 利用Joomla+SEO提升网络营销竞争力
  • \r\n
\r\n
\r\n \r\n
\r\n
\r\n \r\n \r\n\r\n\r\n', 1421827200, 1711785600, '', '', '', 0, 1), (2, 2, 2, '大梁', '', '\r\n \r\n \r\n \r\n
 
\r\n', 1422604800, 1648627200, '', '', '', 0, 1), (3, 0, 2, '推薦套書', '', ' \r\n \r\n \r\n \r\n \r\n \r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n
推薦套書
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
  
\r\n

 

\r\n \r\n\r\n \r\n \r\n \r\n ', 1422604800, 1585555200, '', '', '', 0, 1), (7, 5, 2, 'facebook', '', '', 1425024000, 1711699200, '', '', '', 0, 1), (5, 3, 2, '親子分享園地', '', ' \r\n \r\n \r\n\r\n \r\n \r\n\r\n\r\n \r\n \r\n \r\n
\r\n
\r\n
親子分享園地
\r\n
\r\n
影片
\r\n
\r\n
\r\n
\r\n
相簿
\r\n
\r\n
\r\n
\r\n
文章
\r\n
\r\n
\r\n \r\n
\r\n\r\n \r\n\r\n \r\n \r\n \r\n ', 1423382400, 1806393600, '', '', '', 0, 1), (4, 0, 3, '官方菜單', '', '\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n \r\n
\r\n
商品分類
\r\n
\r\n
小鼠波波
\r\n
\r\n
\r\n
\r\n
推薦套書
\r\n
\r\n
\r\n
\r\n
成人叢書
\r\n
\r\n
\r\n \r\n
\r\n', 1422691200, 1425283200, '', '', '', 0, 1), (6, 4, 2, '關於博勝', '', ' \r\n \r\n \r\n\r\n \r\n \r\n\r\n\r\n \r\n \r\n \r\n
\r\n
\r\n
關於博勝
\r\n
\r\n
博勝國際文化教育機構
\r\n
\r\n
\r\n
\r\n
活動花絮
\r\n
\r\n
\r\n
\r\n
人才招募
\r\n
\r\n
\r\n \r\n
\r\n\r\n \r\n\r\n \r\n \r\n \r\n ', 1423641600, 1680163200, '', '', '', 0, 1), (8, 6, 2, '首頁模組', '', '
\r\n
\r\n

精選系列

\r\n \r\n \r\n \r\n \r\n
 
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
   
\r\n \r\n
\r\n
\r\n', 1427529600, 1651046400, '', '', '', 0, 1); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_admin_action` -- DROP TABLE IF EXISTS `ecs_admin_action`; CREATE TABLE IF NOT EXISTS `ecs_admin_action` ( `action_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `parent_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `action_code` varchar(20) NOT NULL DEFAULT '', `relevance` varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (`action_id`), KEY `parent_id` (`parent_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=136 ; -- -- 資料表的匯出資料 `ecs_admin_action` -- INSERT INTO `ecs_admin_action` (`action_id`, `parent_id`, `action_code`, `relevance`) 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', 'cat_manage'), (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', 'integrate_users'), (40, 3, 'users_manage', ''), (41, 3, 'users_drop', 'users_manage'), (42, 3, 'user_rank', ''), (85, 3, 'surplus_manage', 'account_manage'), (43, 4, 'admin_manage', ''), (44, 4, 'admin_drop', 'admin_manage'), (45, 4, 'allot_priv', 'admin_manage'), (46, 4, 'logs_manage', ''), (47, 4, 'logs_drop', 'logs_manage'), (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', 'order_os_edit'), (55, 6, 'order_ss_edit', 'order_os_edit'), (56, 6, 'order_edit', 'order_os_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', 'db_backup'), (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', ''), (124, 11, 'sms_send', ''), (128, 7, 'exchange_goods', ''), (129, 6, 'delivery_view', ''), (130, 6, 'back_view', ''), (131, 5, 'reg_fields', ''), (132, 5, 'shop_authorized', ''), (133, 5, 'webcollect_manage', ''), (134, 4, 'suppliers_manage', ''), (135, 4, 'role_manage', ''); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_admin_log` -- DROP TABLE IF EXISTS `ecs_admin_log`; CREATE TABLE IF NOT EXISTS `ecs_admin_log` ( `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `log_time` int(10) unsigned NOT NULL DEFAULT '0', `user_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `log_info` varchar(255) NOT NULL DEFAULT '', `ip_address` varchar(15) NOT NULL DEFAULT '', PRIMARY KEY (`log_id`), KEY `log_time` (`log_time`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=325 ; -- -- 資料表的匯出資料 `ecs_admin_log` -- INSERT INTO `ecs_admin_log` (`log_id`, `log_time`, `user_id`, `log_info`, `ip_address`) VALUES (1, 1422561369, 1, '編輯文章: 聯系我們', '111.254.209.75'), (2, 1422561377, 1, '編輯文章: 關於我們', '111.254.209.75'), (3, 1422561396, 1, '編輯文章: 關於我們', '111.254.209.75'), (4, 1422561414, 1, '編輯文章: 關於我們', '111.254.209.75'), (5, 1422561439, 1, '刪除文章: 公司簡介', '111.254.209.75'), (6, 1422564629, 1, '編輯文章: 隱私保護', '111.254.209.75'), (7, 1422564636, 1, '編輯文章: 最新消息', '111.254.209.75'), (8, 1422568546, 1, '編輯商店設置: ', '59.127.75.54'), (9, 1422569790, 1, '添加商品分類: 建置網站', '59.127.75.54'), (10, 1422569833, 1, '添加商品: 放圖', '59.127.75.54'), (11, 1422570556, 1, '添加商品分類: 育兒精選系列', '59.127.75.54'), (12, 1422570572, 1, '添加商品分類: 推薦套書', '59.127.75.54'), (13, 1422570582, 1, '添加商品分類: 成人叢書', '59.127.75.54'), (14, 1422572308, 1, '編輯商品: 放圖', '59.127.75.54'), (15, 1422572390, 1, '編輯商品: 放圖', '59.127.75.54'), (16, 1422572441, 1, '編輯商品: 放圖', '59.127.75.54'), (17, 1422577162, 1, '編輯商品: 放圖', '59.127.75.54'), (18, 1422577241, 1, '編輯商品: 放圖', '59.127.75.54'), (19, 1422577427, 1, '編輯商品: 放圖', '59.127.75.54'), (20, 1422578197, 1, '編輯商品: 放圖', '59.127.75.54'), (21, 1422580130, 1, '添加廣告位置: js', '59.127.75.54'), (22, 1422580161, 1, '添加廣告: js', '59.127.75.54'), (23, 1422580601, 1, '編輯廣告: js', '59.127.75.54'), (24, 1422580664, 1, '編輯廣告位置: js', '59.127.75.54'), (25, 1422580671, 1, '編輯廣告位置: js', '59.127.75.54'), (26, 1422581131, 1, '編輯廣告位置: 首頁輪撥', '59.127.75.54'), (27, 1422581146, 1, '編輯廣告: 首頁輪撥', '59.127.75.54'), (28, 1422581171, 1, '編輯廣告: 首頁輪撥', '59.127.75.54'), (29, 1422581246, 1, '編輯廣告: 首頁輪撥', '59.127.75.54'), (30, 1422581928, 1, '編輯商品: 放圖', '59.127.75.54'), (31, 1422583132, 1, '添加文章分類: 育兒分享', '59.127.75.54'), (32, 1422583172, 1, '刪除商品分類: ', '59.127.75.54'), (33, 1422583196, 1, '添加文章: 育兒分享', '59.127.75.54'), (34, 1422583809, 1, '編輯文章: 育兒分享', '59.127.75.54'), (35, 1422583861, 1, '添加文章分類: 育兒分享', '59.127.75.54'), (36, 1422583923, 1, '編輯文章: 育兒分享', '59.127.75.54'), (37, 1422584005, 1, '編輯文章: 美小兒科學會:嬰兒也 需要陪讀', '59.127.75.54'), (38, 1422584044, 1, '編輯文章: 美小兒科學會:嬰兒也 需要陪讀', '59.127.75.54'), (39, 1422584150, 1, '編輯商店設置: ', '59.127.75.54'), (40, 1422586156, 1, '添加文章分類: 推薦套書', '59.127.75.54'), (41, 1422586216, 1, '添加文章: 推薦套書', '59.127.75.54'), (42, 1422586233, 1, '編輯文章: 套書列表', '59.127.75.54'), (43, 1422586407, 1, '添加文章: 推薦套書', '59.127.75.54'), (44, 1422586421, 1, '刪除文章: 推薦套書', '59.127.75.54'), (45, 1422586430, 1, '刪除文章: 套書列表', '59.127.75.54'), (46, 1422586445, 1, '編輯文章分類: 推薦套書', '59.127.75.54'), (47, 1422586497, 1, '刪除商品分類: ', '59.127.75.54'), (48, 1422586523, 1, '添加文章: 套書列表', '59.127.75.54'), (49, 1422586628, 1, '添加商品: 00', '59.127.75.54'), (50, 1422586686, 1, '回收商品: 00', '59.127.75.54'), (51, 1422588978, 1, '編輯文章: 關於博勝', '59.127.75.54'), (52, 1422589105, 1, '添加文章: 寒流來了,各位小朋友要多穿幾件衣服免得著涼喲( • ̀ω•́ )', '59.127.75.54'), (53, 1422682166, 1, '編輯商品: 放圖', '118.232.173.101'), (54, 1422685381, 1, '添加廣告位置: 大樑', '118.232.173.101'), (55, 1422685407, 1, '添加廣告: 大梁', '118.232.173.101'), (56, 1422685587, 1, '編輯廣告: 大梁', '118.232.173.101'), (57, 1422685637, 1, '編輯廣告: 大梁', '118.232.173.101'), (58, 1422689159, 1, '添加廣告: 推薦套書', '118.232.173.101'), (59, 1422690026, 1, '刪除文章: 套書列表', '118.232.173.101'), (60, 1422693172, 1, '編輯文章: 關於博勝', '118.232.173.101'), (61, 1422693916, 1, '添加廣告: 官方菜單', '118.232.173.101'), (62, 1422700137, 1, '編輯廣告: 官方菜單', '118.232.173.101'), (63, 1422700616, 1, '編輯前台語言項: ', '118.232.173.101'), (64, 1422700718, 1, '編輯前台語言項: ', '118.232.173.101'), (65, 1422700794, 1, '編輯會員註冊項: 連絡方式', '118.232.173.101'), (66, 1422700843, 1, '編輯會員註冊項: 信箱', '118.232.173.101'), (67, 1422700866, 1, '編輯會員註冊項: 連絡方式', '118.232.173.101'), (68, 1422701047, 1, '編輯商店設置: ', '118.232.173.101'), (69, 1422701272, 1, '添加商品: 範例', '118.232.173.101'), (70, 1422701304, 1, '編輯商品: 範例', '118.232.173.101'), (71, 1422701332, 1, '編輯商店設置: ', '118.232.173.101'), (72, 1422701368, 1, '編輯商品: 範例', '118.232.173.101'), (73, 1422701437, 1, '編輯商店設置: ', '118.232.173.101'), (74, 1422701459, 1, '編輯商品: 範例', '118.232.173.101'), (75, 1422701533, 1, '編輯商店設置: ', '118.232.173.101'), (76, 1422701589, 1, '編輯商店設置: ', '118.232.173.101'), (77, 1422701612, 1, '編輯商店設置: ', '118.232.173.101'), (78, 1422702718, 1, '編輯商品: 範例', '118.232.173.101'), (79, 1422774959, 1, '編輯商店設置: ', '118.232.173.101'), (80, 1422775329, 1, '編輯商品: 範例', '118.232.173.101'), (81, 1422775429, 1, '編輯前台語言項: ', '118.232.173.101'), (82, 1422776338, 1, '安裝支付方式: 銀行匯款/轉帳', '118.232.173.101'), (83, 1422776356, 1, '安裝支付方式: 貨到付款', '118.232.173.101'), (84, 1422776366, 1, '安裝支付方式: 郵局匯款', '118.232.173.101'), (85, 1422776381, 1, '安裝配送方式: 運費到付', '118.232.173.101'), (86, 1422776465, 1, '添加配送區域: 台灣', '118.232.173.101'), (87, 1422776481, 1, '安裝配送方式: 郵政快遞包裹', '118.232.173.101'), (88, 1422776502, 1, '添加配送區域: 台灣', '118.232.173.101'), (89, 1422776645, 1, '添加屬性: 規格', '118.232.173.101'), (90, 1422776653, 1, '添加屬性: 出版日期', '118.232.173.101'), (91, 1422776660, 1, '添加屬性: 作者', '118.232.173.101'), (92, 1422776666, 1, '添加屬性: 譯者', '118.232.173.101'), (93, 1422776736, 1, '編輯前台語言項: ', '118.232.173.101'), (94, 1422776752, 1, '編輯前台語言項: ', '118.232.173.101'), (95, 1422776985, 1, '編輯商店設置: ', '118.232.173.101'), (96, 1422777130, 1, '編輯前台語言項: ', '118.232.173.101'), (97, 1422777278, 1, '編輯前台語言項: ', '118.232.173.101'), (98, 1422777392, 1, '編輯商品: 範例', '118.232.173.101'), (99, 1422778078, 1, '編輯地區: 台灣', '118.232.173.101'), (100, 1422778082, 1, '刪除地區: 北京', '118.232.173.101'), (101, 1422778084, 1, '刪除地區: 安徽', '118.232.173.101'), (102, 1422778085, 1, '刪除地區: 福建', '118.232.173.101'), (103, 1422778086, 1, '刪除地區: 甘肅', '118.232.173.101'), (104, 1422778087, 1, '刪除地區: 廣東', '118.232.173.101'), (105, 1422778088, 1, '刪除地區: 廣西', '118.232.173.101'), (106, 1422778088, 1, '刪除地區: 貴州', '118.232.173.101'), (107, 1422778089, 1, '刪除地區: 海南', '118.232.173.101'), (108, 1422778090, 1, '刪除地區: 河北', '118.232.173.101'), (109, 1422778091, 1, '刪除地區: 河南', '118.232.173.101'), (110, 1422778092, 1, '刪除地區: 黑龍江', '118.232.173.101'), (111, 1422778092, 1, '刪除地區: 湖北', '118.232.173.101'), (112, 1422778093, 1, '刪除地區: 湖南', '118.232.173.101'), (113, 1422778094, 1, '刪除地區: 吉林', '118.232.173.101'), (114, 1422778095, 1, '刪除地區: 江蘇', '118.232.173.101'), (115, 1422778095, 1, '刪除地區: 江西', '118.232.173.101'), (116, 1422778096, 1, '刪除地區: 遼寧', '118.232.173.101'), (117, 1422778097, 1, '刪除地區: 內蒙古', '118.232.173.101'), (118, 1422778098, 1, '刪除地區: 寧夏', '118.232.173.101'), (119, 1422778099, 1, '刪除地區: 青海', '118.232.173.101'), (120, 1422778100, 1, '刪除地區: 山東', '118.232.173.101'), (121, 1422778101, 1, '刪除地區: 山西', '118.232.173.101'), (122, 1422778102, 1, '刪除地區: 陜西', '118.232.173.101'), (123, 1422778103, 1, '刪除地區: 上海', '118.232.173.101'), (124, 1422778106, 1, '刪除地區: 四川', '118.232.173.101'), (125, 1422778107, 1, '刪除地區: 天津', '118.232.173.101'), (126, 1422778109, 1, '刪除地區: 西藏', '118.232.173.101'), (127, 1422778110, 1, '刪除地區: 新疆', '118.232.173.101'), (128, 1422778112, 1, '刪除地區: 雲南', '118.232.173.101'), (129, 1422778112, 1, '刪除地區: 浙江', '118.232.173.101'), (130, 1422778113, 1, '刪除地區: 重慶', '118.232.173.101'), (131, 1422778115, 1, '刪除地區: 香港', '118.232.173.101'), (132, 1422778116, 1, '刪除地區: 澳門', '118.232.173.101'), (133, 1422778195, 1, '編輯地區: 台灣', '118.232.173.101'), (134, 1422778278, 1, '編輯商店設置: ', '118.232.173.101'), (135, 1422778326, 1, '編輯地區: 臺北', '118.232.173.101'), (136, 1422778341, 1, '編輯地區: 臺中', '118.232.173.101'), (137, 1422778346, 1, '編輯地區: 臺中', '118.232.173.101'), (138, 1422778414, 1, '添加地區: 臺北', '118.232.173.101'), (139, 1422778419, 1, '添加地區: 臺中', '118.232.173.101'), (140, 1422778423, 1, '添加地區: 高雄', '118.232.173.101'), (141, 1422778430, 1, '添加地區: 台南', '118.232.173.101'), (142, 1422778435, 1, '添加地區: 屏東', '118.232.173.101'), (143, 1422778437, 1, '刪除地區: 臺灣', '118.232.173.101'), (144, 1422778706, 1, '編輯商品: 範例', '118.232.173.101'), (145, 1422778774, 1, '添加地區: 鳳山', '118.232.173.101'), (146, 1422779036, 1, '編輯商店設置: ', '118.232.173.101'), (147, 1422821858, 1, '編輯商店設置: ', '59.127.75.54'), (148, 1422829365, 1, '編輯廣告: 推薦套書', '59.127.75.54'), (149, 1422833800, 1, '編輯文章: 關於博勝', '59.127.75.54'), (150, 1422833900, 1, '編輯文章: 關於博勝', '59.127.75.54'), (151, 1422833920, 1, '編輯文章: 關於博勝', '59.127.75.54'), (152, 1422833931, 1, '編輯文章: 關於博勝', '59.127.75.54'), (153, 1422833980, 1, '編輯文章: 關於博勝', '59.127.75.54'), (154, 1422834019, 1, '編輯文章: 關於博勝', '59.127.75.54'), (155, 1422834974, 1, '編輯文章: 關於博勝', '59.127.75.54'), (156, 1423119167, 1, '編輯商店設置: ', '59.125.248.253'), (157, 1423206375, 1, '編輯前台語言項: ', '59.125.248.253'), (158, 1423206418, 1, '編輯前台語言項: ', '59.125.248.253'), (159, 1423206445, 1, '編輯前台語言項: ', '59.125.248.253'), (160, 1423206508, 1, '編輯商店設置: ', '59.125.248.253'), (161, 1423206903, 1, '編輯商品分類: 精選系列', '59.125.248.253'), (162, 1423206923, 1, '編輯商品分類: 親子分享園地', '59.125.248.253'), (163, 1423206935, 1, '編輯商品分類: 好讚連結', '59.125.248.253'), (164, 1423207198, 1, '編輯商店設置: ', '59.125.248.253'), (165, 1423207289, 1, '編輯商店設置: ', '59.125.248.253'), (166, 1423207318, 1, '編輯商店設置: ', '59.125.248.253'), (167, 1423207346, 1, '編輯前台語言項: ', '59.125.248.253'), (168, 1423207811, 1, '添加商品賀卡: 00', '59.125.248.253'), (169, 1423207818, 1, '刪除商品賀卡: 00', '59.125.248.253'), (170, 1423207901, 1, '編輯前台語言項: ', '59.125.248.253'), (171, 1423210466, 1, '編輯商店設置: ', '59.125.248.253'), (172, 1423210806, 1, '編輯商店設置: ', '59.125.248.253'), (173, 1423210889, 1, '編輯商品: 範例', '59.125.248.253'), (174, 1423213331, 1, '編輯前台語言項: ', '59.125.248.253'), (175, 1423214721, 1, '編輯前台語言項: ', '59.125.248.253'), (176, 1423214838, 1, '編輯前台語言項: ', '59.125.248.253'), (177, 1423214907, 1, '編輯商店設置: ', '59.125.248.253'), (178, 1423215110, 1, '編輯前台語言項: ', '59.125.248.253'), (179, 1423215143, 1, '編輯前台語言項: ', '59.125.248.253'), (180, 1423215157, 1, '編輯前台語言項: ', '59.125.248.253'), (181, 1423215170, 1, '編輯前台語言項: ', '59.125.248.253'), (182, 1423215218, 1, '編輯商店設置: ', '59.125.248.253'), (183, 1423215241, 1, '編輯前台語言項: ', '59.125.248.253'), (184, 1423215381, 1, '編輯前台語言項: ', '59.125.248.253'), (185, 1423215662, 1, '編輯商店設置: ', '59.125.248.253'), (186, 1423215676, 1, '編輯商店設置: ', '59.125.248.253'), (187, 1423459406, 1, '編輯商店設置: ', '59.125.248.253'), (188, 1423459763, 1, '編輯前台語言項: ', '59.125.248.253'), (189, 1423459805, 1, '編輯前台語言項: ', '59.125.248.253'), (190, 1423459845, 1, '編輯前台語言項: ', '59.125.248.253'), (191, 1423460225, 1, '添加商品分類: 巷簿', '59.125.248.253'), (192, 1423460237, 1, '編輯商品分類: 相簿', '59.125.248.253'), (193, 1423460269, 1, '添加商品分類: 影片', '59.125.248.253'), (194, 1423460391, 1, '添加廣告: 親子分享園地', '59.125.248.253'), (195, 1423460417, 1, '添加廣告位置: 親子分享園地', '59.125.248.253'), (196, 1423460535, 1, '編輯廣告: 親子分享園地', '59.125.248.253'), (197, 1423460595, 1, '編輯廣告: 親子分享園地', '59.125.248.253'), (198, 1423460606, 1, '編輯廣告位置: 親子分享園地', '59.125.248.253'), (199, 1423460664, 1, '編輯廣告: 親子分享園地', '59.125.248.253'), (200, 1423460890, 1, '編輯廣告: 親子分享園地', '59.125.248.253'), (201, 1423461257, 1, '編輯商品: 範例', '59.125.248.253'), (202, 1423461340, 1, '編輯廣告位置: 親子分享園地', '59.125.248.253'), (203, 1423461377, 1, '編輯廣告位置: 親子分享園地', '59.125.248.253'), (204, 1423461421, 1, '編輯廣告: 親子分享園地', '59.125.248.253'), (205, 1423461486, 1, '編輯前台語言項: ', '59.125.248.253'), (206, 1423461524, 1, '編輯前台語言項: ', '59.125.248.253'), (207, 1423461543, 1, '編輯前台語言項: ', '59.125.248.253'), (208, 1423461712, 1, '編輯商品: 範例', '59.125.248.253'), (209, 1423461801, 1, '添加商品: 育兒影片-範例', '59.125.248.253'), (210, 1423461871, 1, '編輯商品: 育兒影片-範例', '59.125.248.253'), (211, 1423461937, 1, '編輯商品: 育兒影片-範例', '59.125.248.253'), (212, 1423462005, 1, '編輯商品: 相片分享-範例', '59.125.248.253'), (213, 1423462264, 1, '編輯文章: 關於博勝', '59.125.248.253'), (214, 1423463273, 1, '編輯商品: 放圖', '59.125.248.253'), (215, 1423463561, 1, '編輯商品: 放圖', '59.125.248.253'), (216, 1423464136, 1, '編輯商品: 放圖', '59.125.248.253'), (217, 1423468966, 1, '編輯商品: 育兒影片-範例', '59.125.248.253'), (218, 1423469017, 1, '編輯商品: 育兒影片-範例', '59.125.248.253'), (219, 1423469130, 1, '編輯商店設置: ', '59.125.248.253'), (220, 1423469222, 1, '編輯商品類型: 影片', '59.125.248.253'), (221, 1423469251, 1, '編輯屬性: 連結', '59.125.248.253'), (222, 1423469262, 1, '編輯商品分類: 影片', '59.125.248.253'), (223, 1423469281, 1, '編輯商品: 育兒影片-範例', '59.125.248.253'), (224, 1423955578, 1, '編輯商品: 相片分享-範例', '59.125.248.253'), (225, 1423955636, 1, '編輯商店設置: ', '59.125.248.253'), (226, 1423955765, 1, '編輯商品: 相片分享-範例', '59.125.248.253'), (227, 1423957428, 1, '添加品牌管理: 博勝國際文化教育機構', '59.125.248.253'), (228, 1423957456, 1, '編輯商品: 育兒影片-範例', '59.125.248.253'), (229, 1423958121, 1, '添加商品分類: 員工旅遊', '59.125.248.253'), (230, 1423958199, 1, '添加商品: 谷關溫泉養生會館', '59.125.248.253'), (231, 1423958213, 1, '編輯商品: 育兒影片-範例', '59.125.248.253'), (232, 1423959059, 1, '添加商品分類: 關於博勝', '59.125.248.253'), (233, 1423959067, 1, '編輯商品分類: 員工旅遊', '59.125.248.253'), (234, 1423959089, 1, '編輯商品分類: 影片', '59.125.248.253'), (235, 1423959103, 1, '編輯商品分類: 相簿', '59.125.248.253'), (236, 1423959129, 1, '添加商品分類: 博勝家族', '59.125.248.253'), (237, 1423959181, 1, '添加商品: 拉拉山', '59.125.248.253'), (238, 1423959225, 1, '編輯商品: 拉拉山', '59.125.248.253'), (239, 1423959270, 1, '編輯商品: 拉拉山', '59.125.248.253'), (240, 1423959316, 1, '編輯商品: 拉拉山', '59.125.248.253'), (241, 1423959327, 1, '編輯商品: 拉拉山', '59.125.248.253'), (242, 1423959791, 1, '添加商品分類: 博勝相本', '59.125.248.253'), (243, 1423959803, 1, '編輯商品分類: 員工旅遊', '59.125.248.253'), (244, 1423961007, 1, '編輯商品分類: 員工旅遊', '59.125.248.253'), (245, 1423961011, 1, '刪除商品分類: 博勝相本', '59.125.248.253'), (246, 1423961900, 1, '編輯前台語言項: ', '59.125.248.253'), (247, 1423961920, 1, '編輯前台語言項: ', '59.125.248.253'), (248, 1423961935, 1, '編輯前台語言項: ', '59.125.248.253'), (249, 1423961950, 1, '編輯前台語言項: ', '59.125.248.253'), (250, 1423961972, 1, '編輯前台語言項: ', '59.125.248.253'), (251, 1423962004, 1, '編輯前台語言項: ', '59.125.248.253'), (252, 1423962048, 1, '編輯前台語言項: ', '59.125.248.253'), (253, 1423966750, 1, '添加廣告位置: 關於博勝', '59.125.248.253'), (254, 1423966768, 1, '添加廣告: 關於博勝', '59.125.248.253'), (255, 1423966783, 1, '編輯廣告: 首頁輪撥', '59.125.248.253'), (256, 1423966872, 1, '編輯廣告: 關於博勝', '59.125.248.253'), (257, 1423967042, 1, '編輯文章: 關於博勝', '59.125.248.253'), (258, 1423967414, 1, '添加文章: 人才招募', '59.125.248.253'), (259, 1423967452, 1, '編輯文章: 人才招募', '59.125.248.253'), (260, 1423967490, 1, '編輯廣告: 關於博勝', '59.125.248.253'), (261, 1423967520, 1, '編輯文章: 關於博勝', '59.125.248.253'), (262, 1423967895, 1, '添加商品: 薰衣草森林', '59.125.248.253'), (263, 1423967920, 1, '編輯商品: 薰衣草森林', '59.125.248.253'), (264, 1423977467, 1, '編輯商品: 薰衣草森林', '59.125.248.253'), (265, 1423978557, 1, '編輯商品: 育兒影片', '59.125.248.253'), (266, 1423978729, 1, '添加商品: 旅遊花絮', '59.125.248.253'), (267, 1423978792, 1, '編輯商品: 旅遊花絮', '59.125.248.253'), (268, 1423978978, 1, '編輯商品: 育兒影片', '59.125.248.253'), (269, 1424732775, 1, '編輯廣告: 關於博勝', '111.254.215.127'), (270, 1424732914, 1, '編輯廣告: 官方菜單', '111.254.215.127'), (271, 1424733030, 1, '編輯廣告: 親子分享園地', '111.254.215.127'), (272, 1424733096, 1, '編輯廣告: 推薦套書', '111.254.215.127'), (273, 1424733182, 1, '編輯文章: 關於博勝', '111.254.215.127'), (274, 1425090409, 1, '添加廣告位置: facebook', '59.125.248.253'), (275, 1425090441, 1, '添加廣告: facebook', '59.125.248.253'), (276, 1425090593, 1, '編輯廣告位置: 213', '59.125.248.253'), (277, 1425090599, 1, '編輯廣告: facebook', '59.125.248.253'), (278, 1425090789, 1, '編輯廣告: facebook', '59.125.248.253'), (279, 1425090797, 1, '編輯廣告位置: 300', '59.125.248.253'), (280, 1425160563, 1, '編輯商品: 育兒影片', '59.125.248.253'), (281, 1425160867, 1, '編輯商品: 相片分享', '59.125.248.253'), (282, 1425161565, 1, '編輯商品: 育兒影片', '59.125.248.253'), (283, 1425161641, 1, '編輯商品: 寶貝快樂使用產品分享', '59.125.248.253'), (284, 1425161656, 1, '編輯商品: 寶貝快樂使用產品分享', '59.125.248.253'), (285, 1425161823, 1, '編輯文章: 關於博勝', '59.125.248.253'), (286, 1425161867, 1, '編輯文章: 關於博勝', '59.125.248.253'), (287, 1425162018, 1, '添加商品: 尾牙旅遊', '59.125.248.253'), (288, 1425162027, 1, '編輯商品: 尾牙旅遊', '59.125.248.253'), (289, 1425162049, 1, '編輯商品: 尾牙旅遊', '59.125.248.253'), (290, 1425162114, 1, '編輯商品: 旅遊花絮', '59.125.248.253'), (291, 1425162298, 1, '添加商品: 員工國外旅遊-日本', '59.125.248.253'), (292, 1425162317, 1, '編輯商品: 員工國外旅遊-日本', '59.125.248.253'), (293, 1425162347, 1, '回收商品: 旅遊花絮', '59.125.248.253'), (294, 1425162525, 1, '編輯商品: 寶貝快樂使用產品分享-相片', '59.125.248.253'), (295, 1425162600, 1, '添加商品: 親子講座', '59.125.248.253'), (296, 1425440036, 1, '添加文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (297, 1425440409, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (298, 1425440431, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (299, 1425440454, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (300, 1425440496, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (301, 1425440520, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (302, 1425440538, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (303, 1425440732, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (304, 1425440791, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (305, 1425440849, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (306, 1425440903, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (307, 1425440917, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (308, 1425696975, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (309, 1425697091, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (310, 1425701905, 1, '編輯文章: 家長們,讀故事書給孩子聽吧!', '59.125.248.253'), (311, 1426465424, 1, '添加商品: 寶貝快樂使用產品分享2', '59.127.75.54'), (312, 1426465439, 1, '編輯商品: 寶貝快樂使用產品分享2', '59.127.75.54'), (313, 1427588874, 1, '編輯商店設置: ', '60.249.144.253'), (314, 1427589097, 1, '編輯商店設置: ', '60.249.144.253'), (315, 1427589106, 1, '編輯商店設置: ', '60.249.144.253'), (316, 1427593350, 1, '添加廣告位置: 首頁模組', '60.249.144.253'), (317, 1427593372, 1, '添加廣告: 首頁模組', '60.249.144.253'), (318, 1427593451, 1, '編輯廣告: 首頁模組', '60.249.144.253'), (319, 1427593525, 1, '編輯廣告: 關於博勝', '60.249.144.253'), (320, 1427593717, 1, '編輯廣告: 首頁模組', '60.249.144.253'), (321, 1427593781, 1, '編輯廣告: 首頁模組', '60.249.144.253'), (322, 1427593948, 1, '編輯廣告: 首頁模組', '60.249.144.253'), (323, 1427593969, 1, '編輯廣告: 首頁模組', '60.249.144.253'), (324, 1427593990, 1, '編輯廣告: 首頁模組', '60.249.144.253'); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_admin_message` -- DROP TABLE IF EXISTS `ecs_admin_message`; CREATE TABLE IF NOT EXISTS `ecs_admin_message` ( `message_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `sender_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `receiver_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `sent_time` int(11) unsigned NOT NULL DEFAULT '0', `read_time` int(11) unsigned NOT NULL DEFAULT '0', `readed` tinyint(1) unsigned NOT NULL DEFAULT '0', `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0', `title` varchar(150) NOT NULL DEFAULT '', `message` text NOT NULL, PRIMARY KEY (`message_id`), KEY `sender_id` (`sender_id`,`receiver_id`), KEY `receiver_id` (`receiver_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_admin_user` -- DROP TABLE IF EXISTS `ecs_admin_user`; CREATE TABLE IF NOT EXISTS `ecs_admin_user` ( `user_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `user_name` varchar(60) NOT NULL DEFAULT '', `email` varchar(60) NOT NULL DEFAULT '', `password` varchar(32) NOT NULL DEFAULT '', `ec_salt` varchar(10) DEFAULT NULL, `add_time` int(11) NOT NULL DEFAULT '0', `last_login` int(11) NOT NULL DEFAULT '0', `last_ip` varchar(15) NOT NULL DEFAULT '', `action_list` text NOT NULL, `nav_list` text NOT NULL, `lang_type` varchar(50) NOT NULL DEFAULT '', `agency_id` smallint(5) unsigned NOT NULL, `suppliers_id` smallint(5) unsigned DEFAULT '0', `todolist` longtext, `role_id` smallint(5) DEFAULT NULL, PRIMARY KEY (`user_id`), KEY `user_name` (`user_name`), KEY `agency_id` (`agency_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- 資料表的匯出資料 `ecs_admin_user` -- INSERT INTO `ecs_admin_user` (`user_id`, `user_name`, `email`, `password`, `ec_salt`, `add_time`, `last_login`, `last_ip`, `action_list`, `nav_list`, `lang_type`, `agency_id`, `suppliers_id`, `todolist`, `role_id`) VALUES (1, 'fatbear', 'fatbear09@fatbear.com.tw', '33de7384919b3b68fa422075b7930529', '5328', 1422326816, 1428100542, '59.125.248.253', 'all', '商品列表|goods.php?act=list,訂單列表|order.php?act=list,用戶評論|comment_manage.php?act=list,會員列表|users.php?act=list,商店設置|shop_config.php?act=list_edit', '', 0, 0, NULL, NULL); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_adsense` -- DROP TABLE IF EXISTS `ecs_adsense`; CREATE TABLE IF NOT EXISTS `ecs_adsense` ( `from_ad` smallint(5) NOT NULL DEFAULT '0', `referer` varchar(255) NOT NULL DEFAULT '', `clicks` int(10) unsigned NOT NULL DEFAULT '0', KEY `from_ad` (`from_ad`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_ad_custom` -- DROP TABLE IF EXISTS `ecs_ad_custom`; CREATE TABLE IF NOT EXISTS `ecs_ad_custom` ( `ad_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `ad_type` tinyint(1) unsigned NOT NULL DEFAULT '1', `ad_name` varchar(60) DEFAULT NULL, `add_time` int(10) unsigned NOT NULL DEFAULT '0', `content` mediumtext, `url` varchar(255) DEFAULT NULL, `ad_status` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ad_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- 資料表的匯出資料 `ecs_ad_custom` -- INSERT INTO `ecs_ad_custom` (`ad_id`, `ad_type`, `ad_name`, `add_time`, `content`, `url`, `ad_status`) VALUES (1, 2, 'test', 1422327616, '\r\n\r\n\r\n \r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n \r\n\r\n
\r\n\r\n \r\n
\r\n ', 'http://', 0), (2, 2, 'test2', 1422580740, '\r\n\r\n\r\n\r\n \r\n \r\n \r\n\r\n\r\n\r\n \r\n
\r\n
\r\n
\r\n
    \r\n
  • \r\n
  • \r\n \r\n
  • \r\n
  • \r\n
  • \r\n \r\n \r\n
\r\n
\r\n \r\n
\r\n
\r\n \r\n \r\n\r\n', 'http://', 1); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_ad_position` -- DROP TABLE IF EXISTS `ecs_ad_position`; CREATE TABLE IF NOT EXISTS `ecs_ad_position` ( `position_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `position_name` varchar(60) NOT NULL DEFAULT '', `ad_width` smallint(5) unsigned NOT NULL DEFAULT '0', `ad_height` smallint(5) unsigned NOT NULL DEFAULT '0', `position_desc` varchar(255) NOT NULL DEFAULT '', `position_style` text NOT NULL, PRIMARY KEY (`position_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; -- -- 資料表的匯出資料 `ecs_ad_position` -- INSERT INTO `ecs_ad_position` (`position_id`, `position_name`, `ad_width`, `ad_height`, `position_desc`, `position_style`) VALUES (1, '首頁輪撥', 1000, 500, '', '\r\n{foreach from=$ads item=ad}\r\n\r\n{/foreach}\r\n
{$ad}
'), (2, '大樑', 30, 500, '', '\r\n{foreach from=$ads item=ad}\r\n\r\n{/foreach}\r\n
{$ad}
'), (3, '親子分享園地', 220, 155, '', '\r\n{foreach from=$ads item=ad}\r\n\r\n{/foreach}\r\n
{$ad}
'), (4, '關於博勝', 200, 200, '', '\r\n{foreach from=$ads item=ad}\r\n\r\n{/foreach}\r\n
{$ad}
'), (5, 'facebook', 213, 300, '', '\r\n{foreach from=$ads item=ad}\r\n\r\n{/foreach}\r\n
{$ad}
'), (6, '首頁模組', 1000, 110, '', '\r\n{foreach from=$ads item=ad}\r\n\r\n{/foreach}\r\n
{$ad}
'); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_affiliate_log` -- DROP TABLE IF EXISTS `ecs_affiliate_log`; CREATE TABLE IF NOT EXISTS `ecs_affiliate_log` ( `log_id` mediumint(8) NOT NULL AUTO_INCREMENT, `order_id` mediumint(8) NOT NULL, `time` int(10) NOT NULL, `user_id` mediumint(8) NOT NULL, `user_name` varchar(60) DEFAULT NULL, `money` decimal(10,2) NOT NULL DEFAULT '0.00', `point` int(10) NOT NULL DEFAULT '0', `separate_type` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`log_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_agency` -- DROP TABLE IF EXISTS `ecs_agency`; CREATE TABLE IF NOT EXISTS `ecs_agency` ( `agency_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `agency_name` varchar(255) NOT NULL, `agency_desc` text NOT NULL, PRIMARY KEY (`agency_id`), KEY `agency_name` (`agency_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_area_region` -- DROP TABLE IF EXISTS `ecs_area_region`; CREATE TABLE IF NOT EXISTS `ecs_area_region` ( `shipping_area_id` smallint(5) unsigned NOT NULL DEFAULT '0', `region_id` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`shipping_area_id`,`region_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 資料表的匯出資料 `ecs_area_region` -- INSERT INTO `ecs_area_region` (`shipping_area_id`, `region_id`) VALUES (1, 3384), (1, 3385), (1, 3387), (1, 3388), (1, 3397), (2, 3385), (2, 3387), (2, 3388), (2, 3397); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_article` -- DROP TABLE IF EXISTS `ecs_article`; CREATE TABLE IF NOT EXISTS `ecs_article` ( `article_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `cat_id` smallint(5) NOT NULL DEFAULT '0', `title` varchar(150) NOT NULL DEFAULT '', `content` longtext NOT NULL, `author` varchar(30) NOT NULL DEFAULT '', `author_email` varchar(60) NOT NULL DEFAULT '', `keywords` varchar(255) NOT NULL DEFAULT '', `article_type` tinyint(1) unsigned NOT NULL DEFAULT '2', `is_open` tinyint(1) unsigned NOT NULL DEFAULT '1', `add_time` int(10) unsigned NOT NULL DEFAULT '0', `file_url` varchar(255) NOT NULL DEFAULT '', `open_type` tinyint(1) unsigned NOT NULL DEFAULT '0', `link` varchar(255) NOT NULL DEFAULT '', `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`article_id`), KEY `cat_id` (`cat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ; -- -- 資料表的匯出資料 `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`, `link`, `description`) VALUES (1, 2, '免責條款', '', '', '', '', 0, 1, 1422355616, '', 0, '', NULL), (2, 2, '隱私保護', '', '', '', '', 0, 1, 1422355616, '', 0, '', NULL), (3, 2, '最新消息', '', '', '', '', 0, 1, 1422355616, '', 0, '', NULL), (4, 2, '關於博勝', '

\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n
\r\n
 \r\n

\r\n

我們為一多元智能文教機構,提供孩童完整的學習系統,並進行行銷網路整合,提供更資訊化服務,讓貼心的服務沒有距離。

\r\n

溫馨的家庭,快樂的工作,生動的學習,活潑的成長,為我們成立的主要使命。
\r\n
\r\n 我們秉持著穩健發展、追求企業永續經營及成長為理念、重視每一位員工,除了有良好工作環境、也提供學習及成長的空間,

\r\n

歡迎優秀的朋友一起加入我們的工作行列。

\r\n

 

\r\n

高雄市三民區九如一路807號7F           TEL:(07)396-2378   FAX:(07)387-6460 

\r\n

 

\r\n

產品簡介

\r\n


\r\n 幼兒教具、玩具書、CD、DVD、遊戲教學網站、語言學習機、電子書、九年一貫教學軟體光碟、各類百科、繪本、故事書、英文、數學、作文

\r\n

、歷史、藝術、旅遊.....等叢書。

\r\n

\r\n

 

\r\n
\r\n', '', '', '', 0, 1, 1422355616, '', 0, 'http://', ''), (7, 5, '美小兒科學會:嬰兒也 需要陪讀', '

法新社 – 2014年6月25

\r\n

日 上午10:35

\r\n

 

\r\n
\r\n

(法新社華盛頓24日電) 美國小兒科學會 今天呼籲為人父母者,自孩子出生後便開 始親子共讀,期能在3C產品充斥的時代提 升兒童語言能力。

\r\n

小兒科醫師長期以來都鼓勵父母陪孩子閱 讀,但這是這項建議首度成為美國小兒科 學會(AmericanAcademy of Pediatrics) 的正式推行政策。小兒科學會告訴醫師, 必須向家長提倡陪幼兒閱讀,希望能從孩 子出生起持續到幼稚園。

\r\n

根據學會指南,陪幼兒閱讀能「激發大腦 發育的最佳模式,以及在兒童成長的關鍵 時期強化親子關係,而這段期間建立的語 言、讀寫能力與社交情緒能力會持續終 身」。

\r\n

學會同時呼籲醫師和政策制定者,贈送童 書給需要的家庭,以減少低收入或勞動階 層家庭的負擔。

\r\n

學會表示,研究已發現家庭所得造成明顯 的共讀差異,只有1/3低收入家庭會每天親 子共讀,導致孩子就學後出現「明顯的學 習弱勢」。

\r\n

學會先前表示,2歲以下幼童應該盡量不要 接觸到各種電子螢幕,最好的學習時機是 在接觸他人或玩玩具時的非結構式互動遊 戲。

\r\n

美國小兒科學會會士、紐約北韋斯切斯特 醫院(Northern Westchester Hospital) 小兒科主任李希(Peter Richel)表示,就 算小孩看起來不是很有興趣,但即便是非 常小的寶寶,也可以從閱讀獲益。

\r\n

李希說:「我確實看到有些孩子會提前認 字、組成詞彙和句子,這種情況總出現在 每天有人唸書給他們聽的孩子身上。」 (譯者:中央社陳怡君)

\r\n
\r\n

 

', '', '', '', 0, 1, 1422583196, '', 0, 'http://', ''), (6, -1, '用戶協議', '', '', '', '', 0, 1, 1422355616, '', 0, '', NULL), (11, 5, '寒流來了,各位小朋友要多穿幾件衣服免得著涼喲( • ̀ω•́ )', '

 

', '', '', '', 0, 1, 1422589105, '', 0, 'http://', ''), (12, 2, '人才招募', ' \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n
\r\n
\r\n
關於博勝
\r\n
\r\n
博勝國際文化教育機構
\r\n
\r\n
\r\n
\r\n
活動花絮
\r\n
\r\n
\r\n
\r\n
人才招募
\r\n
\r\n
\r\n
 


\r\n

\r\n

我們為一多元智能文教機構,提供孩童完整的學習系統,並進行行銷網路整合,提供更資訊化服務,讓貼心的服務沒有距離。

\r\n

溫馨的家庭,快樂的工作,生動的學習,活潑的成長,為我們成立的主要使命。
\r\n
\r\n 我們秉持著穩健發展、追求企業永續經營及成長為理念、重視每一位員工,除了有良好工作環境、也提供學習及成長的空間,

\r\n

歡迎優秀的朋友一起加入我們的工作行列。

\r\n

 

\r\n

高雄市三民區九如一路807號7F           TEL:(07)396-2378   FAX:(07)387-6460 

\r\n

 

\r\n

產品簡介

\r\n


\r\n 幼兒教具、玩具書、CD、DVD、遊戲教學網站、語言學習機、電子書、九年一貫教學軟體光碟、各類百科、繪本、故事書、英文、數學、作文

\r\n

、歷史、藝術、旅遊.....等叢書。

\r\n

\r\n

 

\r\n \r\n\r\n \r\n \r\n \r\n ', '', '', '', 0, 1, 1423967414, '', 0, 'http://', ''), (13, 5, '家長們,讀故事書給孩子聽吧!', '

\r\n

您今天讀故事書給孩子聽了嗎?
\r\n

\r\n

文章轉自親子天下雜誌/文/黃瑽寧      

\r\n

http://m.parenting.com.tw/article/article.action?id=5064113

\r\n

 

\r\n

美國有一次調查有三歲以下孩童的家庭,發現有16%的家長從來沒有唸故事書給孩子聽,
\r\n另外23%則一週只讀不到兩次。

\r\n

 

\r\n

您可能會問,「三歲以下?他們連字都不會認呢!何必浪費時間呢?」如果您這樣認為,就大錯特錯了。
\r\n有一項長達二十年的研究證明,學齡前的的親子共讀,可以讓孩子進入小學時更加順利,並且影響日後
\r\n的閱讀能力,口語表達能力可以比其他孩子高兩倍,讀得越多,效果越顯著。而這兩項能力,是學習最
\r\n重要的基本功夫。

\r\n

這麼長期的研究觀察,開始於1989年發起於美國波士頓的一個兒科診所。

\r\n


\r\n就像台灣現在的景況,因為疫苗打的很好,公共衛生做的很好,所以大部分的小朋友其實都沒什麼嚴重
\r\n的疾病。這位醫師並不以此為自滿,他覺得小兒科醫師應該負責照顧孩子的「身心」健康,身體顧好了
\r\n,還有心靈的健康需要努力。

\r\n

 

\r\n

他聯合了一群熱心的醫師和教育學者,開始在健兒門診提醒媽媽親子共讀,甚至贈書給貧窮的家庭。
\r\n雖然親子共讀的觀念常常被提及,但是會得到資訊的家庭,多數還是高教育水準的家長。

\r\n

 

\r\n

這個運動特別之處,是由醫師主動出擊,因為每個孩子都會來打疫苗,趁這個機會,將親子共讀的資訊,
\r\n提供給資源比較貧乏的家庭,讓他們的孩子得到更好的幫助。

\r\n

 

\r\n

因此醫師稱這個活動為Reach Out and Read (ROR),意思是主動伸出醫師的手,而不是由家長主動詢問。

\r\n

這項運動得到了熱烈的回應,二十年下來,全美國共有四千多家診所參與,他們每一年給出570萬本童書,
\r\n幫助350萬名以上的兒童。

\r\n

更重要的是,藉由這項活動的追蹤,證實親子共讀的確可以給孩子未來極大的幫助,絕不是憑空論述而已。

\r\n

 

\r\n

一開始這些家長對於親子共讀有一些疑慮,
\r\n第一:住家附近沒有書店(尤其是鄉下地方)
\r\n第二:不知道怎麼讀(以前小時候也沒人讀給他聽,或者是家長本身識字不多,教育程度不高)
\r\n第三:兒童繪本太貴了
\r\n第四:雖然嘗試過親子共讀,可是小朋友聽一聽就跑掉了,搞的很不愉快。

\r\n

 

\r\n

基於以上四個疑慮,ROR運動給醫師三個方式來幫助家長:
\r\n第一:由醫師主動告知家長親子共讀的重要性(正如我第一段所述)
\r\n第二:送給六個月至五歲的「健兒」一本好的圖畫書
\r\n第三:請志工在診所外面示範讀書給孩子聽,讓家長知道訣竅所在。

\r\n

事實上,家長不用學習太多,只要有一本書在家就夠了。

\r\n

 

\r\n

就算每天讀同一本書,就算家長認不得半個字,都可以藉由書中的圖畫和口語,給孩子足夠的語言刺激。

\r\n

要知道,我們日常生活中使用的辭彙是很簡單的,因為我們的生活週遭也許相對很單純;但是繪本裡的文字,
\r\n有時候是平常不會使用的,因此可以給孩子更多樣化,更豐富的語言經驗。

\r\n

 

\r\n

為什麼六個月就開始親子共讀?根據研究顯示,越早開始唸書給寶寶聽,語言發展越好,這個影響可以持續到小學的年齡。

\r\n

 

\r\n

至於較大的小孩,可以以「我問你答」的方式進行故事,甚至請孩子反過來講故事給家長聽。

\r\n

 

\r\n

不同年齡的孩子,對於共讀有不同的發展階段,列於下表讓家長們參考
\r\n 

\r\n

\r\n

 

\r\n

雖然您的孩子一開始可能對親子共讀興趣缺缺,但是不要氣餒,也不要給孩子壓力。

\r\n

 

\r\n

每天睡前,或者孩子玩累的時候,問他要不要唸故事書,或者拿兩本書在面前晃晃,由他挑選自己喜歡的書,就算老是挑同一本也好。

\r\n

久而久之,親子共讀會變成你們之間最快樂的時光,孩子在語言上的進步,也會令您驚喜萬分!

\r\n

 

\r\n

 

\r\n

 

\r\n

 

', '', '', '', 0, 1, 1425440036, '', 0, 'http://', ''); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_article_cat` -- DROP TABLE IF EXISTS `ecs_article_cat`; CREATE TABLE IF NOT EXISTS `ecs_article_cat` ( `cat_id` smallint(5) NOT NULL AUTO_INCREMENT, `cat_name` varchar(255) NOT NULL DEFAULT '', `cat_type` tinyint(1) unsigned NOT NULL DEFAULT '1', `keywords` varchar(255) NOT NULL DEFAULT '', `cat_desc` varchar(255) NOT NULL DEFAULT '', `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '50', `show_in_nav` tinyint(1) unsigned NOT NULL DEFAULT '0', `parent_id` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`cat_id`), KEY `cat_type` (`cat_type`), KEY `sort_order` (`sort_order`), KEY `parent_id` (`parent_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; -- -- 資料表的匯出資料 `ecs_article_cat` -- INSERT INTO `ecs_article_cat` (`cat_id`, `cat_name`, `cat_type`, `keywords`, `cat_desc`, `sort_order`, `show_in_nav`, `parent_id`) VALUES (1, '系統分類', 2, '', '系統保留分類', 50, 0, 0), (2, '網店信息', 3, '', '網店信息分類', 50, 0, 1), (3, '網店幫助分類', 4, '', '網店幫助分類', 50, 0, 1), (5, '育兒分享', 1, '', '', 50, 1, 0); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_attribute` -- DROP TABLE IF EXISTS `ecs_attribute`; CREATE TABLE IF NOT EXISTS `ecs_attribute` ( `attr_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `cat_id` smallint(5) unsigned NOT NULL DEFAULT '0', `attr_name` varchar(60) NOT NULL DEFAULT '', `attr_input_type` tinyint(1) unsigned NOT NULL DEFAULT '1', `attr_type` tinyint(1) unsigned NOT NULL DEFAULT '1', `attr_values` text NOT NULL, `attr_index` tinyint(1) unsigned NOT NULL DEFAULT '0', `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '0', `is_linked` tinyint(1) unsigned NOT NULL DEFAULT '0', `attr_group` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`attr_id`), KEY `cat_id` (`cat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; -- -- 資料表的匯出資料 `ecs_attribute` -- INSERT INTO `ecs_attribute` (`attr_id`, `cat_id`, `attr_name`, `attr_input_type`, `attr_type`, `attr_values`, `attr_index`, `sort_order`, `is_linked`, `attr_group`) VALUES (4, 1, '連結', 0, 0, '', 0, 0, 0, 0); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_auction_log` -- DROP TABLE IF EXISTS `ecs_auction_log`; CREATE TABLE IF NOT EXISTS `ecs_auction_log` ( `log_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `act_id` mediumint(8) unsigned NOT NULL, `bid_user` mediumint(8) unsigned NOT NULL, `bid_price` decimal(10,2) unsigned NOT NULL, `bid_time` int(10) unsigned NOT NULL, PRIMARY KEY (`log_id`), KEY `act_id` (`act_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_auto_manage` -- DROP TABLE IF EXISTS `ecs_auto_manage`; CREATE TABLE IF NOT EXISTS `ecs_auto_manage` ( `item_id` mediumint(8) NOT NULL, `type` varchar(10) NOT NULL, `starttime` int(10) NOT NULL, `endtime` int(10) NOT NULL, PRIMARY KEY (`item_id`,`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_back_goods` -- DROP TABLE IF EXISTS `ecs_back_goods`; CREATE TABLE IF NOT EXISTS `ecs_back_goods` ( `rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `back_id` mediumint(8) unsigned DEFAULT '0', `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `product_sn` varchar(60) DEFAULT NULL, `goods_name` varchar(120) DEFAULT NULL, `brand_name` varchar(60) DEFAULT NULL, `goods_sn` varchar(60) DEFAULT NULL, `is_real` tinyint(1) unsigned DEFAULT '0', `send_number` smallint(5) unsigned DEFAULT '0', `goods_attr` text, PRIMARY KEY (`rec_id`), KEY `back_id` (`back_id`), KEY `goods_id` (`goods_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_back_order` -- DROP TABLE IF EXISTS `ecs_back_order`; CREATE TABLE IF NOT EXISTS `ecs_back_order` ( `back_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `delivery_sn` varchar(20) NOT NULL, `order_sn` varchar(20) NOT NULL, `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `invoice_no` varchar(50) DEFAULT NULL, `add_time` int(10) unsigned DEFAULT '0', `shipping_id` tinyint(3) unsigned DEFAULT '0', `shipping_name` varchar(120) DEFAULT NULL, `user_id` mediumint(8) unsigned DEFAULT '0', `action_user` varchar(30) DEFAULT NULL, `consignee` varchar(60) DEFAULT NULL, `address` varchar(250) DEFAULT NULL, `country` smallint(5) unsigned DEFAULT '0', `province` smallint(5) unsigned DEFAULT '0', `city` smallint(5) unsigned DEFAULT '0', `district` smallint(5) unsigned DEFAULT '0', `sign_building` varchar(120) DEFAULT NULL, `email` varchar(60) DEFAULT NULL, `zipcode` varchar(60) DEFAULT NULL, `tel` varchar(60) DEFAULT NULL, `mobile` varchar(60) DEFAULT NULL, `best_time` varchar(120) DEFAULT NULL, `postscript` varchar(255) DEFAULT NULL, `how_oos` varchar(120) DEFAULT NULL, `insure_fee` decimal(10,2) unsigned DEFAULT '0.00', `shipping_fee` decimal(10,2) unsigned DEFAULT '0.00', `update_time` int(10) unsigned DEFAULT '0', `suppliers_id` smallint(5) DEFAULT '0', `status` tinyint(1) unsigned NOT NULL DEFAULT '0', `return_time` int(10) unsigned DEFAULT '0', `agency_id` smallint(5) unsigned DEFAULT '0', PRIMARY KEY (`back_id`), KEY `user_id` (`user_id`), KEY `order_id` (`order_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_bonus_type` -- DROP TABLE IF EXISTS `ecs_bonus_type`; CREATE TABLE IF NOT EXISTS `ecs_bonus_type` ( `type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `type_name` varchar(60) NOT NULL DEFAULT '', `type_money` decimal(10,2) NOT NULL DEFAULT '0.00', `send_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `min_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00', `max_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00', `send_start_date` int(11) NOT NULL DEFAULT '0', `send_end_date` int(11) NOT NULL DEFAULT '0', `use_start_date` int(11) NOT NULL DEFAULT '0', `use_end_date` int(11) NOT NULL DEFAULT '0', `min_goods_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00', PRIMARY KEY (`type_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_booking_goods` -- DROP TABLE IF EXISTS `ecs_booking_goods`; CREATE TABLE IF NOT EXISTS `ecs_booking_goods` ( `rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `email` varchar(60) NOT NULL DEFAULT '', `link_man` varchar(60) NOT NULL DEFAULT '', `tel` varchar(60) NOT NULL DEFAULT '', `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_desc` varchar(255) NOT NULL DEFAULT '', `goods_number` smallint(5) unsigned NOT NULL DEFAULT '0', `booking_time` int(10) unsigned NOT NULL DEFAULT '0', `is_dispose` tinyint(1) unsigned NOT NULL DEFAULT '0', `dispose_user` varchar(30) NOT NULL DEFAULT '', `dispose_time` int(10) unsigned NOT NULL DEFAULT '0', `dispose_note` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`rec_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_brand` -- DROP TABLE IF EXISTS `ecs_brand`; CREATE TABLE IF NOT EXISTS `ecs_brand` ( `brand_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `brand_name` varchar(60) NOT NULL DEFAULT '', `brand_logo` varchar(80) NOT NULL DEFAULT '', `brand_desc` text NOT NULL, `site_url` varchar(255) NOT NULL DEFAULT '', `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '50', `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`brand_id`), KEY `is_show` (`is_show`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- 資料表的匯出資料 `ecs_brand` -- INSERT INTO `ecs_brand` (`brand_id`, `brand_name`, `brand_logo`, `brand_desc`, `site_url`, `sort_order`, `is_show`) VALUES (1, '博勝國際文化教育機構', '1423957428322951328.png', '', 'http://test03.fbook.com.tw/', 50, 1); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_card` -- DROP TABLE IF EXISTS `ecs_card`; CREATE TABLE IF NOT EXISTS `ecs_card` ( `card_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `card_name` varchar(120) NOT NULL DEFAULT '', `card_img` varchar(255) NOT NULL DEFAULT '', `card_fee` decimal(6,2) unsigned NOT NULL DEFAULT '0.00', `free_money` decimal(6,2) unsigned NOT NULL DEFAULT '0.00', `card_desc` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`card_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_cart` -- DROP TABLE IF EXISTS `ecs_cart`; CREATE TABLE IF NOT EXISTS `ecs_cart` ( `rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `session_id` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_sn` varchar(60) NOT NULL DEFAULT '', `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_name` varchar(120) NOT NULL DEFAULT '', `market_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00', `goods_price` decimal(10,2) NOT NULL DEFAULT '0.00', `goods_number` smallint(5) unsigned NOT NULL DEFAULT '0', `goods_attr` text NOT NULL, `is_real` tinyint(1) unsigned NOT NULL DEFAULT '0', `extension_code` varchar(30) NOT NULL DEFAULT '', `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `rec_type` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_gift` smallint(5) unsigned NOT NULL DEFAULT '0', `is_shipping` tinyint(1) unsigned NOT NULL DEFAULT '0', `can_handsel` tinyint(3) unsigned NOT NULL DEFAULT '0', `goods_attr_id` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`rec_id`), KEY `session_id` (`session_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_category` -- DROP TABLE IF EXISTS `ecs_category`; CREATE TABLE IF NOT EXISTS `ecs_category` ( `cat_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `cat_name` varchar(90) NOT NULL DEFAULT '', `keywords` varchar(255) NOT NULL DEFAULT '', `cat_desc` varchar(255) NOT NULL DEFAULT '', `parent_id` smallint(5) unsigned NOT NULL DEFAULT '0', `sort_order` tinyint(1) unsigned NOT NULL DEFAULT '50', `template_file` varchar(50) NOT NULL DEFAULT '', `measure_unit` varchar(15) NOT NULL DEFAULT '', `show_in_nav` tinyint(1) NOT NULL DEFAULT '0', `style` varchar(150) NOT NULL, `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1', `grade` tinyint(4) NOT NULL DEFAULT '0', `filter_attr` varchar(255) NOT NULL DEFAULT '0', PRIMARY KEY (`cat_id`), KEY `parent_id` (`parent_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ; -- -- 資料表的匯出資料 `ecs_category` -- INSERT INTO `ecs_category` (`cat_id`, `cat_name`, `keywords`, `cat_desc`, `parent_id`, `sort_order`, `template_file`, `measure_unit`, `show_in_nav`, `style`, `is_show`, `grade`, `filter_attr`) VALUES (1, '建置網站', '', '', 0, 50, '', '', 0, '', 0, 0, ''), (2, '精選系列', '', '', 0, 1, '', '', 0, '', 1, 0, ''), (3, '親子分享園地', '', '', 0, 2, '', '', 0, '', 0, 0, ''), (4, '好讚連結', '', '', 0, 5, '', '', 0, '', 1, 0, ''), (5, '相簿', '', '', 3, 4, '', '', 0, '', 0, 0, ''), (6, '影片', '', '', 3, 3, '', '', 0, '', 0, 0, ''), (7, '員工旅遊', '', '', 8, 50, '', '', 0, '', 1, 0, ''), (8, '關於博勝', '', '', 0, 50, '', '', 0, '', 1, 0, ''), (9, '博勝家族', '', '', 8, 50, '', '', 0, '', 1, 0, ''); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_cat_recommend` -- DROP TABLE IF EXISTS `ecs_cat_recommend`; CREATE TABLE IF NOT EXISTS `ecs_cat_recommend` ( `cat_id` smallint(5) NOT NULL, `recommend_type` tinyint(1) NOT NULL, PRIMARY KEY (`cat_id`,`recommend_type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_collect_goods` -- DROP TABLE IF EXISTS `ecs_collect_goods`; CREATE TABLE IF NOT EXISTS `ecs_collect_goods` ( `rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `add_time` int(11) unsigned NOT NULL DEFAULT '0', `is_attention` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`rec_id`), KEY `user_id` (`user_id`), KEY `goods_id` (`goods_id`), KEY `is_attention` (`is_attention`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_comment` -- DROP TABLE IF EXISTS `ecs_comment`; CREATE TABLE IF NOT EXISTS `ecs_comment` ( `comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `comment_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `id_value` mediumint(8) unsigned NOT NULL DEFAULT '0', `email` varchar(60) NOT NULL DEFAULT '', `user_name` varchar(60) NOT NULL DEFAULT '', `content` text NOT NULL, `comment_rank` tinyint(1) unsigned NOT NULL DEFAULT '0', `add_time` int(10) unsigned NOT NULL DEFAULT '0', `ip_address` varchar(15) NOT NULL DEFAULT '', `status` tinyint(3) unsigned NOT NULL DEFAULT '0', `parent_id` int(10) unsigned NOT NULL DEFAULT '0', `user_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`comment_id`), KEY `parent_id` (`parent_id`), KEY `id_value` (`id_value`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_crons` -- DROP TABLE IF EXISTS `ecs_crons`; CREATE TABLE IF NOT EXISTS `ecs_crons` ( `cron_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `cron_code` varchar(20) NOT NULL, `cron_name` varchar(120) NOT NULL, `cron_desc` text, `cron_order` tinyint(3) unsigned NOT NULL DEFAULT '0', `cron_config` text NOT NULL, `thistime` int(10) NOT NULL DEFAULT '0', `nextime` int(10) NOT NULL, `day` tinyint(2) NOT NULL, `week` varchar(1) NOT NULL, `hour` varchar(2) NOT NULL, `minute` varchar(255) NOT NULL, `enable` tinyint(1) NOT NULL DEFAULT '1', `run_once` tinyint(1) NOT NULL DEFAULT '0', `allow_ip` varchar(100) NOT NULL DEFAULT '', `alow_files` varchar(255) NOT NULL, PRIMARY KEY (`cron_id`), KEY `nextime` (`nextime`), KEY `enable` (`enable`), KEY `cron_code` (`cron_code`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_delivery_goods` -- DROP TABLE IF EXISTS `ecs_delivery_goods`; CREATE TABLE IF NOT EXISTS `ecs_delivery_goods` ( `rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `delivery_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `product_id` mediumint(8) unsigned DEFAULT '0', `product_sn` varchar(60) DEFAULT NULL, `goods_name` varchar(120) DEFAULT NULL, `brand_name` varchar(60) DEFAULT NULL, `goods_sn` varchar(60) DEFAULT NULL, `is_real` tinyint(1) unsigned DEFAULT '0', `extension_code` varchar(30) DEFAULT NULL, `parent_id` mediumint(8) unsigned DEFAULT '0', `send_number` smallint(5) unsigned DEFAULT '0', `goods_attr` text, PRIMARY KEY (`rec_id`), KEY `delivery_id` (`delivery_id`,`goods_id`), KEY `goods_id` (`goods_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_delivery_order` -- DROP TABLE IF EXISTS `ecs_delivery_order`; CREATE TABLE IF NOT EXISTS `ecs_delivery_order` ( `delivery_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `delivery_sn` varchar(20) NOT NULL, `order_sn` varchar(20) NOT NULL, `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `invoice_no` varchar(50) DEFAULT NULL, `add_time` int(10) unsigned DEFAULT '0', `shipping_id` tinyint(3) unsigned DEFAULT '0', `shipping_name` varchar(120) DEFAULT NULL, `user_id` mediumint(8) unsigned DEFAULT '0', `action_user` varchar(30) DEFAULT NULL, `consignee` varchar(60) DEFAULT NULL, `address` varchar(250) DEFAULT NULL, `country` smallint(5) unsigned DEFAULT '0', `province` smallint(5) unsigned DEFAULT '0', `city` smallint(5) unsigned DEFAULT '0', `district` smallint(5) unsigned DEFAULT '0', `sign_building` varchar(120) DEFAULT NULL, `email` varchar(60) DEFAULT NULL, `zipcode` varchar(60) DEFAULT NULL, `tel` varchar(60) DEFAULT NULL, `mobile` varchar(60) DEFAULT NULL, `best_time` varchar(120) DEFAULT NULL, `postscript` varchar(255) DEFAULT NULL, `how_oos` varchar(120) DEFAULT NULL, `insure_fee` decimal(10,2) unsigned DEFAULT '0.00', `shipping_fee` decimal(10,2) unsigned DEFAULT '0.00', `update_time` int(10) unsigned DEFAULT '0', `suppliers_id` smallint(5) DEFAULT '0', `status` tinyint(1) unsigned NOT NULL DEFAULT '0', `agency_id` smallint(5) unsigned DEFAULT '0', PRIMARY KEY (`delivery_id`), KEY `user_id` (`user_id`), KEY `order_id` (`order_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_email_list` -- DROP TABLE IF EXISTS `ecs_email_list`; CREATE TABLE IF NOT EXISTS `ecs_email_list` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `email` varchar(60) NOT NULL, `stat` tinyint(1) NOT NULL DEFAULT '0', `hash` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_email_sendlist` -- DROP TABLE IF EXISTS `ecs_email_sendlist`; CREATE TABLE IF NOT EXISTS `ecs_email_sendlist` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `email` varchar(100) NOT NULL, `template_id` mediumint(8) NOT NULL, `email_content` text NOT NULL, `error` tinyint(1) NOT NULL DEFAULT '0', `pri` tinyint(10) NOT NULL, `last_send` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_error_log` -- DROP TABLE IF EXISTS `ecs_error_log`; CREATE TABLE IF NOT EXISTS `ecs_error_log` ( `id` int(10) NOT NULL AUTO_INCREMENT, `info` varchar(255) NOT NULL, `file` varchar(100) NOT NULL, `time` int(10) NOT NULL, PRIMARY KEY (`id`), KEY `time` (`time`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_exchange_goods` -- DROP TABLE IF EXISTS `ecs_exchange_goods`; CREATE TABLE IF NOT EXISTS `ecs_exchange_goods` ( `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `exchange_integral` int(10) unsigned NOT NULL DEFAULT '0', `is_exchange` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`goods_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_favourable_activity` -- DROP TABLE IF EXISTS `ecs_favourable_activity`; CREATE TABLE IF NOT EXISTS `ecs_favourable_activity` ( `act_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `act_name` varchar(255) NOT NULL, `start_time` int(10) unsigned NOT NULL, `end_time` int(10) unsigned NOT NULL, `user_rank` varchar(255) NOT NULL, `act_range` tinyint(3) unsigned NOT NULL, `act_range_ext` varchar(255) NOT NULL, `min_amount` decimal(10,2) unsigned NOT NULL, `max_amount` decimal(10,2) unsigned NOT NULL, `act_type` tinyint(3) unsigned NOT NULL, `act_type_ext` decimal(10,2) unsigned NOT NULL, `gift` text NOT NULL, `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '50', PRIMARY KEY (`act_id`), KEY `act_name` (`act_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_feedback` -- DROP TABLE IF EXISTS `ecs_feedback`; CREATE TABLE IF NOT EXISTS `ecs_feedback` ( `msg_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `user_name` varchar(60) NOT NULL DEFAULT '', `user_email` varchar(60) NOT NULL DEFAULT '', `msg_title` varchar(200) NOT NULL DEFAULT '', `msg_type` tinyint(1) unsigned NOT NULL DEFAULT '0', `msg_status` tinyint(1) unsigned NOT NULL DEFAULT '0', `msg_content` text NOT NULL, `msg_time` int(10) unsigned NOT NULL DEFAULT '0', `message_img` varchar(255) NOT NULL DEFAULT '0', `order_id` int(11) unsigned NOT NULL DEFAULT '0', `msg_area` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`msg_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_friend_link` -- DROP TABLE IF EXISTS `ecs_friend_link`; CREATE TABLE IF NOT EXISTS `ecs_friend_link` ( `link_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `link_name` varchar(255) NOT NULL DEFAULT '', `link_url` varchar(255) NOT NULL DEFAULT '', `link_logo` varchar(255) NOT NULL DEFAULT '', `show_order` tinyint(3) unsigned NOT NULL DEFAULT '50', PRIMARY KEY (`link_id`), KEY `show_order` (`show_order`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- 資料表的匯出資料 `ecs_friend_link` -- INSERT INTO `ecs_friend_link` (`link_id`, `link_name`, `link_url`, `link_logo`, `show_order`) VALUES (1, 'ECSHOP 网上商店管理系统', 'http://www.ecshop.com/', 'http://www.ecshop.com/images/logo/ecshop_logo.gif', 50), (2, '免费申请网店', 'http://www.maifou.net/', '', 51), (3, '免费开独立网店', 'http://www.wdwd.com/', '', 52); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_goods` -- DROP TABLE IF EXISTS `ecs_goods`; CREATE TABLE IF NOT EXISTS `ecs_goods` ( `goods_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `cat_id` smallint(5) unsigned NOT NULL DEFAULT '0', `goods_sn` varchar(60) NOT NULL DEFAULT '', `goods_name` varchar(120) NOT NULL DEFAULT '', `goods_name_style` varchar(60) NOT NULL DEFAULT '+', `click_count` int(10) unsigned NOT NULL DEFAULT '0', `brand_id` smallint(5) unsigned NOT NULL DEFAULT '0', `provider_name` varchar(100) NOT NULL DEFAULT '', `goods_number` smallint(5) unsigned NOT NULL DEFAULT '0', `goods_weight` decimal(10,3) unsigned NOT NULL DEFAULT '0.000', `market_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00', `shop_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00', `promote_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00', `promote_start_date` int(11) unsigned NOT NULL DEFAULT '0', `promote_end_date` int(11) unsigned NOT NULL DEFAULT '0', `warn_number` tinyint(3) unsigned NOT NULL DEFAULT '1', `keywords` varchar(255) NOT NULL DEFAULT '', `goods_brief` varchar(255) NOT NULL DEFAULT '', `goods_desc` text NOT NULL, `goods_thumb` varchar(255) NOT NULL DEFAULT '', `goods_img` varchar(255) NOT NULL DEFAULT '', `original_img` varchar(255) NOT NULL DEFAULT '', `is_real` tinyint(3) unsigned NOT NULL DEFAULT '1', `extension_code` varchar(30) NOT NULL DEFAULT '', `is_on_sale` tinyint(1) unsigned NOT NULL DEFAULT '1', `is_alone_sale` tinyint(1) unsigned NOT NULL DEFAULT '1', `is_shipping` tinyint(1) unsigned NOT NULL DEFAULT '0', `integral` int(10) unsigned NOT NULL DEFAULT '0', `add_time` int(10) unsigned NOT NULL DEFAULT '0', `sort_order` smallint(4) unsigned NOT NULL DEFAULT '100', `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_best` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_new` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_promote` tinyint(1) unsigned NOT NULL DEFAULT '0', `bonus_type_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `last_update` int(10) unsigned NOT NULL DEFAULT '0', `goods_type` smallint(5) unsigned NOT NULL DEFAULT '0', `seller_note` varchar(255) NOT NULL DEFAULT '', `give_integral` int(11) NOT NULL DEFAULT '-1', `rank_integral` int(11) NOT NULL DEFAULT '-1', `suppliers_id` smallint(5) unsigned DEFAULT NULL, `is_check` tinyint(1) unsigned DEFAULT NULL, PRIMARY KEY (`goods_id`), KEY `goods_sn` (`goods_sn`), KEY `cat_id` (`cat_id`), KEY `last_update` (`last_update`), KEY `brand_id` (`brand_id`), KEY `goods_weight` (`goods_weight`), KEY `promote_end_date` (`promote_end_date`), KEY `promote_start_date` (`promote_start_date`), KEY `goods_number` (`goods_number`), KEY `sort_order` (`sort_order`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; -- -- 資料表的匯出資料 `ecs_goods` -- INSERT INTO `ecs_goods` (`goods_id`, `cat_id`, `goods_sn`, `goods_name`, `goods_name_style`, `click_count`, `brand_id`, `provider_name`, `goods_number`, `goods_weight`, `market_price`, `shop_price`, `promote_price`, `promote_start_date`, `promote_end_date`, `warn_number`, `keywords`, `goods_brief`, `goods_desc`, `goods_thumb`, `goods_img`, `original_img`, `is_real`, `extension_code`, `is_on_sale`, `is_alone_sale`, `is_shipping`, `integral`, `add_time`, `sort_order`, `is_delete`, `is_best`, `is_new`, `is_hot`, `is_promote`, `bonus_type_id`, `last_update`, `goods_type`, `seller_note`, `give_integral`, `rank_integral`, `suppliers_id`, `is_check`) VALUES (1, 1, 'ECS000000', '放圖', '+', 26, 0, '', 1, '0.000', '0.00', '0.00', '0.00', 0, 0, 1, '', '', '', '', '', '', 1, '', 1, 1, 0, 0, 1422569833, 100, 0, 0, 0, 0, 0, 0, 1423464136, 0, '', -1, -1, 0, NULL), (2, 3, 'ECS000002', '00', '+', 1, 0, '', 1, '0.000', '0.00', '0.00', '0.00', 0, 0, 1, '', '', '', '', '', '', 1, '', 1, 1, 0, 0, 1422586628, 100, 1, 0, 0, 0, 0, 0, 1422586628, 0, '', -1, -1, 0, NULL), (3, 5, 'ECS000003', '寶貝快樂使用產品分享-相片', '+', 225, 0, '', 30, '0.000', '24180248.40', '20150207.00', '0.00', 0, 0, 1, '', '', '

\r\n

\r\n

\r\n

\r\n


\r\n 

', 'images/201503/thumb_img/3_thumb_G_1425162525026.jpg', 'images/201503/goods_img/3_G_1425162525085.jpg', '', 1, '', 1, 1, 0, 0, 1422701272, 100, 0, 0, 0, 0, 0, 0, 1425162525, 0, '', 0, 0, 0, NULL), (7, 7, 'ECS000007', '薰衣草森林', '+', 9, 1, '', 1, '0.000', '24180258.00', '20150215.00', '0.00', 0, 0, 1, '', '', '

 

\r\n

\r\n

', 'images/201502/thumb_img/7_thumb_G_1423967895882.jpg', 'images/201502/goods_img/7_G_1423967895385.jpg', '', 1, '', 1, 1, 0, 0, 1423967895, 100, 0, 0, 0, 0, 0, 0, 1423977467, 0, '', -1, -1, 0, NULL), (8, 9, 'ECS000008', '旅遊花絮', '+', 5, 1, '', 1, '0.000', '24180258.00', '20150215.00', '0.00', 0, 0, 1, '', '', '

 

\r\n

\r\n

', 'images/201502/thumb_img/8_thumb_G_1423978729875.jpg', 'images/201502/goods_img/8_G_1423978729649.jpg', '', 1, '', 1, 1, 0, 0, 1423978729, 100, 1, 0, 0, 0, 0, 0, 1425162114, 0, '', -1, -1, 0, NULL), (9, 7, 'ECS000009', '尾牙旅遊', '+', 6, 1, '', 1, '0.000', '24156361.20', '20130301.00', '0.00', 0, 0, 1, '', '', '

 

\r\n


\r\n

\r\n

\r\n

 

', 'images/201503/thumb_img/9_thumb_G_1425162018741.jpg', 'images/201503/goods_img/9_G_1425162018616.jpg', '', 1, '', 1, 1, 0, 0, 1425162018, 100, 0, 0, 0, 0, 0, 0, 1425162049, 0, '', -1, -1, 0, NULL), (10, 7, 'ECS000010', '員工國外旅遊-日本', '+', 6, 1, '', 1, '0.000', '24180361.20', '20150301.00', '0.00', 0, 0, 1, '', '', '

 

\r\n

\r\n

\r\n

\r\n

\r\n

\r\n

\r\n


\r\n 

', 'images/201503/thumb_img/10_thumb_G_1425162298821.jpg', 'images/201503/goods_img/10_G_1425162298933.jpg', '', 1, '', 1, 1, 0, 0, 1425162298, 100, 0, 0, 0, 0, 0, 0, 1425162317, 0, '', -1, -1, 0, NULL), (4, 6, 'ECS000004', '寶貝快樂使用產品分享-影片', '+', 93, 0, '', 1, '0.000', '24180250.80', '20150209.00', '0.00', 0, 0, 1, '', '', '

博勝國際文化教育機構-寶貝快樂使用產品分享
\r\n
\r\n
\r\n
\r\n

\r\n

', 'images/201503/thumb_img/4_thumb_G_1425161565275.jpg', 'images/201503/goods_img/4_G_1425161565329.jpg', '', 1, '', 1, 1, 0, 0, 1423461801, 100, 0, 1, 1, 1, 0, 0, 1425162442, 1, '', -1, -1, 0, NULL), (5, 7, 'ECS000005', '谷關溫泉養生會館', '+', 29, 1, '', 1, '0.000', '24180258.00', '20150215.00', '0.00', 0, 0, 1, '', '', '', 'images/201502/thumb_img/5_thumb_G_1423958199075.jpg', 'images/201502/goods_img/5_G_1423958199791.jpg', '', 1, '', 1, 1, 0, 0, 1423958199, 100, 0, 0, 0, 0, 0, 0, 1423958199, 0, '', -1, -1, 0, NULL), (6, 7, 'ECS000006', '拉拉山', '+', 18, 1, '', 1, '0.000', '24168258.00', '20140215.00', '0.00', 0, 0, 1, '', '', '

 

\r\n

\r\n

 

\r\n

', 'images/201502/thumb_img/6_thumb_G_1423959225665.jpg', 'images/201502/goods_img/6_G_1423959225253.jpg', '', 1, '', 1, 1, 0, 0, 1423959181, 100, 0, 0, 0, 0, 0, 0, 1423959327, 0, '', -1, -1, 0, NULL), (11, 5, 'ECS000011', '親子講座', '+', 7, 0, '', 1, '0.000', '24180361.20', '20150301.00', '0.00', 0, 0, 1, '', '', '

\r\n

 

\r\n

 

\r\n

 

', 'images/201503/thumb_img/11_thumb_G_1425162600612.jpg', 'images/201503/goods_img/11_G_1425162600716.jpg', '', 1, '', 1, 1, 0, 0, 1425162600, 100, 0, 0, 0, 0, 0, 0, 1425162600, 0, '', -1, -1, 0, NULL), (12, 5, 'ECS000012', '寶貝快樂使用產品分享2', '+', 4, 0, '', 1, '0.000', '24168376.80', '20140314.00', '0.00', 0, 0, 1, '', '', '


\r\n

\r\n

\r\n

\r\n

 

\r\n

 

', 'images/201503/thumb_img/12_thumb_G_1426465439245.jpg', 'images/201503/goods_img/12_G_1426465439891.jpg', '', 1, '', 1, 1, 0, 0, 1426465424, 100, 0, 0, 0, 0, 0, 0, 1426465439, 0, '', -1, -1, 0, NULL); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_goods_activity` -- DROP TABLE IF EXISTS `ecs_goods_activity`; CREATE TABLE IF NOT EXISTS `ecs_goods_activity` ( `act_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `act_name` varchar(255) NOT NULL, `act_desc` text NOT NULL, `act_type` tinyint(3) unsigned NOT NULL, `goods_id` mediumint(8) unsigned NOT NULL, `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_name` varchar(255) NOT NULL, `start_time` int(10) unsigned NOT NULL, `end_time` int(10) unsigned NOT NULL, `is_finished` tinyint(3) unsigned NOT NULL, `ext_info` text NOT NULL, PRIMARY KEY (`act_id`), KEY `act_name` (`act_name`,`act_type`,`goods_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_goods_article` -- DROP TABLE IF EXISTS `ecs_goods_article`; CREATE TABLE IF NOT EXISTS `ecs_goods_article` ( `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `article_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `admin_id` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`goods_id`,`article_id`,`admin_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_goods_attr` -- DROP TABLE IF EXISTS `ecs_goods_attr`; CREATE TABLE IF NOT EXISTS `ecs_goods_attr` ( `goods_attr_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `attr_id` smallint(5) unsigned NOT NULL DEFAULT '0', `attr_value` text NOT NULL, `attr_price` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`goods_attr_id`), KEY `goods_id` (`goods_id`), KEY `attr_id` (`attr_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- 資料表的匯出資料 `ecs_goods_attr` -- INSERT INTO `ecs_goods_attr` (`goods_attr_id`, `goods_id`, `attr_id`, `attr_value`, `attr_price`) VALUES (2, 4, 4, 'https://www.youtube.com/watch?v=j9RICoPP5cc&feature=youtu.be', '0'); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_goods_cat` -- DROP TABLE IF EXISTS `ecs_goods_cat`; CREATE TABLE IF NOT EXISTS `ecs_goods_cat` ( `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `cat_id` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`goods_id`,`cat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_goods_gallery` -- DROP TABLE IF EXISTS `ecs_goods_gallery`; CREATE TABLE IF NOT EXISTS `ecs_goods_gallery` ( `img_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `img_url` varchar(255) NOT NULL DEFAULT '', `img_desc` varchar(255) NOT NULL DEFAULT '', `thumb_url` varchar(255) NOT NULL DEFAULT '', `img_original` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`img_id`), KEY `goods_id` (`goods_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ; -- -- 資料表的匯出資料 `ecs_goods_gallery` -- INSERT INTO `ecs_goods_gallery` (`img_id`, `goods_id`, `img_url`, `img_desc`, `thumb_url`, `img_original`) VALUES (12, 1, 'images/201501/goods_img/1_P_1422581928365.jpg', '', 'images/201501/thumb_img/1_thumb_P_1422581928901.jpg', ''), (6, 1, 'images/201501/goods_img/1_P_1422572390342.jpg', '', 'images/201501/thumb_img/1_thumb_P_1422572390726.jpg', ''), (7, 1, 'images/201501/goods_img/1_P_1422572441470.jpg', '', 'images/201501/thumb_img/1_thumb_P_1422572441654.jpg', ''), (22, 1, 'images/201502/goods_img/1_P_1423463273621.jpg', '', 'images/201502/thumb_img/1_thumb_P_1423463273541.jpg', ''), (13, 1, 'images/201501/goods_img/1_P_1422682166917.jpg', '', 'images/201501/thumb_img/1_thumb_P_1422682166920.jpg', ''), (10, 1, 'images/201501/goods_img/1_P_1422577427894.jpg', '', 'images/201501/thumb_img/1_thumb_P_1422577427798.jpg', ''), (11, 1, 'images/201501/goods_img/1_P_1422578197822.png', '', 'images/201501/thumb_img/1_thumb_P_1422578197674.jpg', ''), (21, 1, 'images/201502/goods_img/1_P_1423463273047.jpg', '', 'images/201502/thumb_img/1_thumb_P_1423463273882.jpg', ''), (20, 1, 'images/201502/goods_img/1_P_1423463273551.jpg', '', 'images/201502/thumb_img/1_thumb_P_1423463273765.jpg', ''), (23, 1, 'images/201502/goods_img/1_P_1423463273550.jpg', '', 'images/201502/thumb_img/1_thumb_P_1423463273016.jpg', ''), (31, 5, 'images/201502/goods_img/5_P_1423958199837.jpg', '', 'images/201502/thumb_img/5_thumb_P_1423958199063.jpg', ''); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_goods_type` -- DROP TABLE IF EXISTS `ecs_goods_type`; CREATE TABLE IF NOT EXISTS `ecs_goods_type` ( `cat_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `cat_name` varchar(60) NOT NULL DEFAULT '', `enabled` tinyint(1) unsigned NOT NULL DEFAULT '1', `attr_group` varchar(255) NOT NULL, PRIMARY KEY (`cat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- 資料表的匯出資料 `ecs_goods_type` -- INSERT INTO `ecs_goods_type` (`cat_id`, `cat_name`, `enabled`, `attr_group`) VALUES (1, '影片', 1, ''); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_group_goods` -- DROP TABLE IF EXISTS `ecs_group_goods`; CREATE TABLE IF NOT EXISTS `ecs_group_goods` ( `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00', `admin_id` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`parent_id`,`goods_id`,`admin_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_keywords` -- DROP TABLE IF EXISTS `ecs_keywords`; CREATE TABLE IF NOT EXISTS `ecs_keywords` ( `date` date NOT NULL DEFAULT '0000-00-00', `searchengine` varchar(20) NOT NULL DEFAULT '', `keyword` varchar(90) NOT NULL DEFAULT '', `count` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`date`,`searchengine`,`keyword`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_link_goods` -- DROP TABLE IF EXISTS `ecs_link_goods`; CREATE TABLE IF NOT EXISTS `ecs_link_goods` ( `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `link_goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `is_double` tinyint(1) unsigned NOT NULL DEFAULT '0', `admin_id` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`goods_id`,`link_goods_id`,`admin_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_mail_templates` -- DROP TABLE IF EXISTS `ecs_mail_templates`; CREATE TABLE IF NOT EXISTS `ecs_mail_templates` ( `template_id` tinyint(1) unsigned NOT NULL AUTO_INCREMENT, `template_code` varchar(30) NOT NULL DEFAULT '', `is_html` tinyint(1) unsigned NOT NULL DEFAULT '0', `template_subject` varchar(200) NOT NULL DEFAULT '', `template_content` text NOT NULL, `last_modify` int(10) unsigned NOT NULL DEFAULT '0', `last_send` int(10) unsigned NOT NULL DEFAULT '0', `type` varchar(10) NOT NULL, PRIMARY KEY (`template_id`), UNIQUE KEY `template_code` (`template_code`), KEY `type` (`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; -- -- 資料表的匯出資料 `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}您好!
\n
\n您已經進行了密碼重置的操作,請點擊以下鏈接(或者復制到您的瀏覽器):
\n
\n{$reset_email}
\n
\n以確認您的新密碼重置操作!
\n
\n{$shop_name}
\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}。妳好!

\n\n您的訂單{$order.order_sn}已於{$send_time}按照您預定的配送方式給您發貨了。
\n
\n{if $order.invoice_no}發貨單號是{$order.invoice_no}。
{/if}\n
\n在您收到貨物之後請點擊下面的鏈接確認您已經收到貨物:
\n{$confirm_url}

\n如果您還沒有收到貨物可以點擊以下鏈接給我們留言:

\n{$send_msg_url}
\n
\n再次感謝您對我們的支持。歡迎您的再次光臨。
\n
\n{$shop_name}
\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},您好!
\n
\n您於{$order_time}在本店參加團購商品活動,所購買的商品名稱為:{$goods_name},數量:{$goods_number},訂單號為:{$order_sn},訂單金額為:{$order_amount}
\n
\n此團購商品現在已到結束日期,並達到最低價格,您現在可以對該訂單付款。
\n
\n請點擊下面的鏈接:
\n{$shop_url}
\n
\n請盡快登錄到用戶中心,查看您的訂單詳情信息。
\n
\n{$shop_name}
\n
\n{$send_date}', 1194824668, 0, 'template'), (8, 'register_validate', 1, '郵件驗證', '{$user_name}您好!

\r\n\r\n這封郵件是 {$shop_name} 發送的。妳收到這封郵件是為了驗證妳註冊郵件地址是否有效。如果您已經通過驗證了,請忽略這封郵件。
\r\n請點擊以下鏈接(或者復制到您的瀏覽器)來驗證妳的郵件地址:
\r\n{$validate_email}

\r\n\r\n{$shop_name}
\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'), (12, 'goods_booking', 1, '缺貨回復', '親愛的{$user_name}。你好!

{$dispose_note}

您提交的缺貨商品鏈接為

{$goods_name}

{$shop_name}
{$send_date}', 0, 0, 'template'), (13, 'user_message', 1, '留言回復', '親愛的{$user_name}。你好!

對您的留言:
{$message_content}

店主作了如下回復:
{$message_note}

您可以隨時回到店中和店主繼續溝通。
{$shop_name}
{$send_date}', 0, 0, 'template'), (14, 'recomment', 1, '用戶評論回復', '親愛的{$user_name}。你好!

對您的評論:
“{$comment}”

店主作了如下回復:
“{$recomment}”

您可以隨時回到店中和店主繼續溝通。
{$shop_name}
{$send_date}', 0, 0, 'template'); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_member_price` -- DROP TABLE IF EXISTS `ecs_member_price`; CREATE TABLE IF NOT EXISTS `ecs_member_price` ( `price_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `user_rank` tinyint(3) NOT NULL DEFAULT '0', `user_price` decimal(10,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`price_id`), KEY `goods_id` (`goods_id`,`user_rank`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_nav` -- DROP TABLE IF EXISTS `ecs_nav`; CREATE TABLE IF NOT EXISTS `ecs_nav` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `ctype` varchar(10) DEFAULT NULL, `cid` smallint(5) unsigned DEFAULT NULL, `name` varchar(255) NOT NULL, `ifshow` tinyint(1) NOT NULL, `vieworder` tinyint(1) NOT NULL, `opennew` tinyint(1) NOT NULL, `url` varchar(255) NOT NULL, `type` varchar(10) NOT NULL, PRIMARY KEY (`id`), KEY `type` (`type`), KEY `ifshow` (`ifshow`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- 資料表的匯出資料 `ecs_nav` -- INSERT INTO `ecs_nav` (`id`, `ctype`, `cid`, `name`, `ifshow`, `vieworder`, `opennew`, `url`, `type`) VALUES (3, 'a', 5, '育兒分享', 1, 2, 0, 'article_cat.php?id=5', 'middle'); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_order_action` -- DROP TABLE IF EXISTS `ecs_order_action`; CREATE TABLE IF NOT EXISTS `ecs_order_action` ( `action_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `action_user` varchar(30) NOT NULL DEFAULT '', `order_status` tinyint(1) unsigned NOT NULL DEFAULT '0', `shipping_status` tinyint(1) unsigned NOT NULL DEFAULT '0', `pay_status` tinyint(1) unsigned NOT NULL DEFAULT '0', `action_place` tinyint(1) unsigned NOT NULL DEFAULT '0', `action_note` varchar(255) NOT NULL DEFAULT '', `log_time` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`action_id`), KEY `order_id` (`order_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_order_goods` -- DROP TABLE IF EXISTS `ecs_order_goods`; CREATE TABLE IF NOT EXISTS `ecs_order_goods` ( `rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_name` varchar(120) NOT NULL DEFAULT '', `goods_sn` varchar(60) NOT NULL DEFAULT '', `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_number` smallint(5) unsigned NOT NULL DEFAULT '1', `market_price` decimal(10,2) NOT NULL DEFAULT '0.00', `goods_price` decimal(10,2) NOT NULL DEFAULT '0.00', `goods_attr` text NOT NULL, `send_number` smallint(5) unsigned NOT NULL DEFAULT '0', `is_real` tinyint(1) unsigned NOT NULL DEFAULT '0', `extension_code` varchar(30) NOT NULL DEFAULT '', `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `is_gift` smallint(5) unsigned NOT NULL DEFAULT '0', `goods_attr_id` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`rec_id`), KEY `order_id` (`order_id`), KEY `goods_id` (`goods_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_order_info` -- DROP TABLE IF EXISTS `ecs_order_info`; CREATE TABLE IF NOT EXISTS `ecs_order_info` ( `order_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `order_sn` varchar(20) NOT NULL DEFAULT '', `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `order_status` tinyint(1) unsigned NOT NULL DEFAULT '0', `shipping_status` tinyint(1) unsigned NOT NULL DEFAULT '0', `pay_status` tinyint(1) unsigned NOT NULL DEFAULT '0', `consignee` varchar(60) NOT NULL DEFAULT '', `country` smallint(5) unsigned NOT NULL DEFAULT '0', `province` smallint(5) unsigned NOT NULL DEFAULT '0', `city` smallint(5) unsigned NOT NULL DEFAULT '0', `district` smallint(5) unsigned NOT NULL DEFAULT '0', `address` varchar(255) NOT NULL DEFAULT '', `zipcode` varchar(60) NOT NULL DEFAULT '', `tel` varchar(60) NOT NULL DEFAULT '', `mobile` varchar(60) NOT NULL DEFAULT '', `email` varchar(60) NOT NULL DEFAULT '', `best_time` varchar(120) NOT NULL DEFAULT '', `sign_building` varchar(120) NOT NULL DEFAULT '', `postscript` varchar(255) NOT NULL DEFAULT '', `shipping_id` tinyint(3) NOT NULL DEFAULT '0', `shipping_name` varchar(120) NOT NULL DEFAULT '', `pay_id` tinyint(3) NOT NULL DEFAULT '0', `pay_name` varchar(120) NOT NULL DEFAULT '', `how_oos` varchar(120) NOT NULL DEFAULT '', `how_surplus` varchar(120) NOT NULL DEFAULT '', `pack_name` varchar(120) NOT NULL DEFAULT '', `card_name` varchar(120) NOT NULL DEFAULT '', `card_message` varchar(255) NOT NULL DEFAULT '', `inv_payee` varchar(120) NOT NULL DEFAULT '', `inv_content` varchar(120) NOT NULL DEFAULT '', `goods_amount` decimal(10,2) NOT NULL DEFAULT '0.00', `shipping_fee` decimal(10,2) NOT NULL DEFAULT '0.00', `insure_fee` decimal(10,2) NOT NULL DEFAULT '0.00', `pay_fee` decimal(10,2) NOT NULL DEFAULT '0.00', `pack_fee` decimal(10,2) NOT NULL DEFAULT '0.00', `card_fee` decimal(10,2) NOT NULL DEFAULT '0.00', `money_paid` decimal(10,2) NOT NULL DEFAULT '0.00', `surplus` decimal(10,2) NOT NULL DEFAULT '0.00', `integral` int(10) unsigned NOT NULL DEFAULT '0', `integral_money` decimal(10,2) NOT NULL DEFAULT '0.00', `bonus` decimal(10,2) NOT NULL DEFAULT '0.00', `order_amount` decimal(10,2) NOT NULL DEFAULT '0.00', `from_ad` smallint(5) NOT NULL DEFAULT '0', `referer` varchar(255) NOT NULL DEFAULT '', `add_time` int(10) unsigned NOT NULL DEFAULT '0', `confirm_time` int(10) unsigned NOT NULL DEFAULT '0', `pay_time` int(10) unsigned NOT NULL DEFAULT '0', `shipping_time` int(10) unsigned NOT NULL DEFAULT '0', `pack_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `card_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `bonus_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `invoice_no` varchar(255) NOT NULL DEFAULT '', `extension_code` varchar(30) NOT NULL DEFAULT '', `extension_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `to_buyer` varchar(255) NOT NULL DEFAULT '', `pay_note` varchar(255) NOT NULL DEFAULT '', `agency_id` smallint(5) unsigned NOT NULL, `inv_type` varchar(60) NOT NULL, `tax` decimal(10,2) NOT NULL, `is_separate` tinyint(1) NOT NULL DEFAULT '0', `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `discount` decimal(10,2) NOT NULL, PRIMARY KEY (`order_id`), UNIQUE KEY `order_sn` (`order_sn`), KEY `user_id` (`user_id`), KEY `order_status` (`order_status`), KEY `shipping_status` (`shipping_status`), KEY `pay_status` (`pay_status`), KEY `shipping_id` (`shipping_id`), KEY `pay_id` (`pay_id`), KEY `extension_code` (`extension_code`,`extension_id`), KEY `agency_id` (`agency_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_pack` -- DROP TABLE IF EXISTS `ecs_pack`; CREATE TABLE IF NOT EXISTS `ecs_pack` ( `pack_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `pack_name` varchar(120) NOT NULL DEFAULT '', `pack_img` varchar(255) NOT NULL DEFAULT '', `pack_fee` decimal(6,2) unsigned NOT NULL DEFAULT '0.00', `free_money` smallint(5) unsigned NOT NULL DEFAULT '0', `pack_desc` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`pack_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_package_goods` -- DROP TABLE IF EXISTS `ecs_package_goods`; CREATE TABLE IF NOT EXISTS `ecs_package_goods` ( `package_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_number` smallint(5) unsigned NOT NULL DEFAULT '1', `admin_id` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`package_id`,`goods_id`,`admin_id`,`product_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_payment` -- DROP TABLE IF EXISTS `ecs_payment`; CREATE TABLE IF NOT EXISTS `ecs_payment` ( `pay_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `pay_code` varchar(20) NOT NULL DEFAULT '', `pay_name` varchar(120) NOT NULL DEFAULT '', `pay_fee` varchar(10) NOT NULL DEFAULT '0', `pay_desc` text NOT NULL, `pay_order` tinyint(3) unsigned NOT NULL DEFAULT '0', `pay_config` text NOT NULL, `enabled` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_cod` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_online` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`pay_id`), UNIQUE KEY `pay_code` (`pay_code`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- 資料表的匯出資料 `ecs_payment` -- INSERT INTO `ecs_payment` (`pay_id`, `pay_code`, `pay_name`, `pay_fee`, `pay_desc`, `pay_order`, `pay_config`, `enabled`, `is_cod`, `is_online`) VALUES (1, 'bank', '銀行匯款/轉帳', '0', '銀行名稱\r\n收款人信息:全稱 ××× ;帳號或地址 ××× ;開戶行 ×××。\r\n注意事項:辦理電匯時,請在電匯單「匯款用途」一欄處註明您的訂單號。', 0, 'a:0:{}', 1, 0, 0), (2, 'cod', '貨到付款', '0', '開通城市:×××\r\n貨到付款區域:×××', 0, 'a:0:{}', 1, 1, 0), (3, 'post', '郵局匯款', '0', '收款人信息:姓名 ××× ;地址 ××× ;郵編 ××× 。\r\n注意事項: 請在匯款單背面的附言中註明您的訂單號,只填寫後6位即可。', 0, 'a:0:{}', 1, 0, 0); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_pay_log` -- DROP TABLE IF EXISTS `ecs_pay_log`; CREATE TABLE IF NOT EXISTS `ecs_pay_log` ( `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `order_amount` decimal(10,2) unsigned NOT NULL, `order_type` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_paid` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`log_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_plugins` -- DROP TABLE IF EXISTS `ecs_plugins`; CREATE TABLE IF NOT EXISTS `ecs_plugins` ( `code` varchar(30) NOT NULL DEFAULT '', `version` varchar(10) NOT NULL DEFAULT '', `library` varchar(255) NOT NULL DEFAULT '', `assign` tinyint(1) unsigned NOT NULL DEFAULT '0', `install_date` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`code`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_products` -- DROP TABLE IF EXISTS `ecs_products`; CREATE TABLE IF NOT EXISTS `ecs_products` ( `product_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_attr` varchar(50) DEFAULT NULL, `product_sn` varchar(60) DEFAULT NULL, `product_number` smallint(5) unsigned DEFAULT '0', PRIMARY KEY (`product_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_region` -- DROP TABLE IF EXISTS `ecs_region`; CREATE TABLE IF NOT EXISTS `ecs_region` ( `region_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `parent_id` smallint(5) unsigned NOT NULL DEFAULT '0', `region_name` varchar(120) NOT NULL DEFAULT '', `region_type` tinyint(1) NOT NULL DEFAULT '2', `agency_id` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`region_id`), KEY `parent_id` (`parent_id`), KEY `region_type` (`region_type`), KEY `agency_id` (`agency_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3415 ; -- -- 資料表的匯出資料 `ecs_region` -- INSERT INTO `ecs_region` (`region_id`, `parent_id`, `region_name`, `region_type`, `agency_id`) VALUES (1, 0, '台灣', 0, 0), (3411, 1, '高雄', 1, 0), (3410, 1, '臺中', 1, 0), (3413, 1, '屏東', 1, 0), (3412, 1, '台南', 1, 0), (3409, 1, '臺北', 1, 0), (3414, 3411, '鳳山', 2, 0); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_reg_extend_info` -- DROP TABLE IF EXISTS `ecs_reg_extend_info`; CREATE TABLE IF NOT EXISTS `ecs_reg_extend_info` ( `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` mediumint(8) unsigned NOT NULL, `reg_field_id` int(10) unsigned NOT NULL, `content` text NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_reg_fields` -- DROP TABLE IF EXISTS `ecs_reg_fields`; CREATE TABLE IF NOT EXISTS `ecs_reg_fields` ( `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `reg_field_name` varchar(60) NOT NULL, `dis_order` tinyint(3) unsigned NOT NULL DEFAULT '100', `display` tinyint(1) unsigned NOT NULL DEFAULT '1', `type` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_need` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=100 ; -- -- 資料表的匯出資料 `ecs_reg_fields` -- INSERT INTO `ecs_reg_fields` (`id`, `reg_field_name`, `dis_order`, `display`, `type`, `is_need`) VALUES (1, 'MSN', 0, 0, 1, 1), (2, 'QQ', 0, 0, 1, 1), (3, '辦公電話', 0, 0, 1, 1), (4, '連絡方式', 0, 1, 1, 0), (5, '手機', 0, 0, 1, 1), (6, '密碼找回問題', 0, 0, 1, 1); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_role` -- DROP TABLE IF EXISTS `ecs_role`; CREATE TABLE IF NOT EXISTS `ecs_role` ( `role_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `role_name` varchar(60) NOT NULL DEFAULT '', `action_list` text NOT NULL, `role_describe` text, PRIMARY KEY (`role_id`), KEY `user_name` (`role_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_searchengine` -- DROP TABLE IF EXISTS `ecs_searchengine`; CREATE TABLE IF NOT EXISTS `ecs_searchengine` ( `date` date NOT NULL DEFAULT '0000-00-00', `searchengine` varchar(20) NOT NULL DEFAULT '', `count` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`date`,`searchengine`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_sessions` -- DROP TABLE IF EXISTS `ecs_sessions`; CREATE TABLE IF NOT EXISTS `ecs_sessions` ( `sesskey` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `expiry` int(10) unsigned NOT NULL DEFAULT '0', `userid` mediumint(8) unsigned NOT NULL DEFAULT '0', `adminid` mediumint(8) unsigned NOT NULL DEFAULT '0', `ip` char(15) NOT NULL DEFAULT '', `user_name` varchar(60) NOT NULL, `user_rank` tinyint(3) NOT NULL, `discount` decimal(3,2) NOT NULL, `email` varchar(60) NOT NULL, `data` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`sesskey`), KEY `expiry` (`expiry`) ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -- 資料表的匯出資料 `ecs_sessions` -- INSERT INTO `ecs_sessions` (`sesskey`, `expiry`, `userid`, `adminid`, `ip`, `user_name`, `user_rank`, `discount`, `email`, `data`) VALUES ('dfc676acfb31e452a262b0b1ee61a2d9', 1428301983, 0, 0, '111.254.197.130', '0', 0, '1.00', '0', 'a:3:{s:7:"from_ad";i:0;s:7:"referer";s:6:"本站";s:10:"login_fail";i:0;}'), ('c682d814dc586cb9d11035e4b0fcb5b1', 1428157001, 0, 0, '180.217.21.182', '0', 0, '1.00', '0', 'a:3:{s:7:"from_ad";i:0;s:7:"referer";s:6:"本站";s:10:"login_fail";i:0;}'); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_sessions_data` -- DROP TABLE IF EXISTS `ecs_sessions_data`; CREATE TABLE IF NOT EXISTS `ecs_sessions_data` ( `sesskey` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `expiry` int(10) unsigned NOT NULL DEFAULT '0', `data` longtext NOT NULL, PRIMARY KEY (`sesskey`), KEY `expiry` (`expiry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 資料表的匯出資料 `ecs_sessions_data` -- INSERT INTO `ecs_sessions_data` (`sesskey`, `expiry`, `data`) VALUES ('34c136b21bb34d9cec7c92f6fe070cdd', 4294967295, 'a:9:{s:7:"from_ad";i:0;s:7:"referer";s:6:"本站";s:10:"login_fail";i:0;s:12:"captcha_word";s:16:"M2NiN2E4MTQ2Nw==";s:9:"flow_type";i:0;s:10:"flow_order";a:8:{s:14:"extension_code";s:0:"";s:11:"shipping_id";i:0;s:6:"pay_id";i:0;s:7:"pack_id";i:0;s:7:"card_id";i:0;s:5:"bonus";i:0;s:8:"integral";i:0;s:7:"surplus";i:0;}s:9:"last_time";s:10:"1422777247";s:7:"last_ip";s:15:"118.232.173.101";s:14:"flow_consignee";a:14:{s:10:"address_id";i:0;s:9:"consignee";s:3:"000";s:7:"country";s:1:"1";s:8:"province";s:4:"3411";s:4:"city";s:4:"3414";s:8:"district";s:0:"";s:5:"email";s:24:"fatbear09@fatbear.com.tw";s:7:"address";s:6:"000000";s:7:"zipcode";s:7:"0000000";s:3:"tel";s:9:"000000000";s:6:"mobile";s:0:"";s:13:"sign_building";s:0:"";s:9:"best_time";s:0:"";s:7:"user_id";s:1:"1";}}'); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_shipping` -- DROP TABLE IF EXISTS `ecs_shipping`; CREATE TABLE IF NOT EXISTS `ecs_shipping` ( `shipping_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `shipping_code` varchar(20) NOT NULL DEFAULT '', `shipping_name` varchar(120) NOT NULL DEFAULT '', `shipping_desc` varchar(255) NOT NULL DEFAULT '', `insure` varchar(10) NOT NULL DEFAULT '0', `support_cod` tinyint(1) unsigned NOT NULL DEFAULT '0', `enabled` tinyint(1) unsigned NOT NULL DEFAULT '0', `shipping_print` text NOT NULL, `print_bg` varchar(255) DEFAULT NULL, `config_lable` text, `print_model` tinyint(1) DEFAULT '0', `shipping_order` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`shipping_id`), KEY `shipping_code` (`shipping_code`,`enabled`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- 資料表的匯出資料 `ecs_shipping` -- INSERT INTO `ecs_shipping` (`shipping_id`, `shipping_code`, `shipping_name`, `shipping_desc`, `insure`, `support_cod`, `enabled`, `shipping_print`, `print_bg`, `config_lable`, `print_model`, `shipping_order`) VALUES (1, 'fpd', '運費到付', '所購商品到達即付運費', '0', 0, 1, '', '', '', 2, 0), (2, 'post_express', '郵政快遞包裹', '郵政快遞包裹的描述內容。', '1%', 0, 1, '', '', '', 2, 0); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_shipping_area` -- DROP TABLE IF EXISTS `ecs_shipping_area`; CREATE TABLE IF NOT EXISTS `ecs_shipping_area` ( `shipping_area_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `shipping_area_name` varchar(150) NOT NULL DEFAULT '', `shipping_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `configure` text NOT NULL, PRIMARY KEY (`shipping_area_id`), KEY `shipping_id` (`shipping_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- 資料表的匯出資料 `ecs_shipping_area` -- INSERT INTO `ecs_shipping_area` (`shipping_area_id`, `shipping_area_name`, `shipping_id`, `configure`) VALUES (1, '台灣', 1, 'a:2:{i:0;a:2:{s:4:"name";s:10:"free_money";s:5:"value";s:0:"";}i:1;a:2:{s:4:"name";s:16:"fee_compute_mode";s:5:"value";s:0:"";}}'), (2, '台灣', 2, 'a:6:{i:0;a:2:{s:4:"name";s:8:"item_fee";s:5:"value";s:1:"5";}i:1;a:2:{s:4:"name";s:8:"base_fee";s:5:"value";s:1:"5";}i:2;a:2:{s:4:"name";s:8:"step_fee";s:5:"value";s:1:"2";}i:3;a:2:{s:4:"name";s:9:"step_fee1";s:5:"value";s:1:"1";}i:4;a:2:{s:4:"name";s:10:"free_money";s:5:"value";s:0:"";}i:5;a:2:{s:4:"name";s:16:"fee_compute_mode";s:5:"value";s:9:"by_weight";}}'); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_shop_config` -- DROP TABLE IF EXISTS `ecs_shop_config`; CREATE TABLE IF NOT EXISTS `ecs_shop_config` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `parent_id` smallint(5) unsigned NOT NULL DEFAULT '0', `code` varchar(30) NOT NULL DEFAULT '', `type` varchar(10) NOT NULL DEFAULT '', `store_range` varchar(255) NOT NULL DEFAULT '', `store_dir` varchar(255) NOT NULL DEFAULT '', `value` text NOT NULL, `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`), KEY `parent_id` (`parent_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=904 ; -- -- 資料表的匯出資料 `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', '', '', 'Booxor博勝國際文化機構', 1), (102, 1, 'shop_title', 'text', '', '', 'Booxor博勝國際文化機構', 1), (103, 1, 'shop_desc', 'text', '', '', '零售幼兒教具、玩具書、CD、DVD、遊戲教學網站、語言學習機、電子書、九年一貫教學軟體光碟、各類百科、繪本、故事書、英文、數學、作文、歷史、藝術、旅遊.....等叢書。', 1), (104, 1, 'shop_keywords', 'text', '', '', 'Booxor博勝國際文化機構、零售幼兒教具、玩具書、CD、DVD、遊戲教學網站、語言學習機、電子書、繪本', 1), (105, 1, 'shop_country', 'manual', '', '', '1', 1), (106, 1, 'shop_province', 'manual', '', '', '3411', 1), (107, 1, 'shop_city', 'manual', '', '', '', 1), (108, 1, 'shop_address', 'text', '', '', '高雄市三民區九一路807號7樓', 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', '', '', 'fatbear@fatbear.com.tw', 1), (115, 1, 'service_phone', 'text', '', '', '07-555-5938', 1), (116, 1, 'shop_closed', 'select', '0,1', '', '0', 1), (117, 1, 'close_comment', 'textarea', '', '', '', 1), (118, 1, 'shop_logo', 'file', '', '../themes/{$template}/images/', '../themes/themes/images/logo.gif', 1), (119, 1, 'licensed', 'select', '0,1', '', '1', 1), (120, 1, 'user_notice', 'textarea', '', '', '零售幼兒教具、玩具書、CD、DVD、遊戲教學網站、語言學習機、電子書、九年一貫教學軟體光碟、各類百科、繪本、故事書、英文、數學、作文、歷史、藝術、旅遊.....等叢書。', 1), (121, 1, 'shop_notice', 'textarea', '', '', '', 1), (122, 1, 'shop_reg_closed', 'select', '1,0', '', '0', 1), (201, 2, 'lang', 'manual', '', '', 'zh_tw', 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', '', '', '0', 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', '-1,0,64,128,256,512,1024,2048,4096', '', '64', 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', '', '1', 1), (229, 2, 'default_storage', 'text', '', '', '1', 1), (230, 2, 'bgcolor', 'text', '', '', '#FFFFFF', 1), (231, 2, 'visit_stats', 'select', 'on,off', '', 'on', 1), (232, 2, 'send_mail_on', 'select', 'on,off', '', 'off', 1), (233, 2, 'auto_generate_gallery', 'select', '1,0', '', '0', 1), (234, 2, 'retain_original_img', 'select', '1,0', '', '0', 1), (235, 2, 'member_email_validate', 'select', '1,0', '', '0', 1), (236, 2, 'message_board', 'select', '1,0', '', '1', 1), (239, 2, 'certificate_id', 'hidden', '', '', '1172159137', 1), (240, 2, 'token', 'hidden', '', '', '32934e6988a498a47a404aaf306344bee30432d190800b56ae0d1f15e6503e7e', 1), (241, 2, 'certi', 'hidden', '', '', 'http://service.shopex.cn/openapi/api.php', 1), (242, 2, 'send_verify_email', 'select', '1,0', '', '0', 1), (243, 2, 'ent_id', 'hidden', '', '', '', 1), (244, 2, 'ent_ac', 'hidden', '', '', '', 1), (245, 2, 'ent_sign', 'hidden', '', '', '', 1), (246, 2, 'ent_email', 'hidden', '', '', '', 1), (301, 3, 'date_format', 'hidden', '', '', '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', '', '', '500', 1), (305, 3, 'thumb_height', 'text', '', '', '500', 1), (306, 3, 'image_width', 'text', '', '', '500', 1), (307, 3, 'image_height', 'text', '', '', '500', 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', '', '', '8', 1), (317, 3, 'goods_name_length', 'text', '', '', '10', 1), (318, 3, 'price_format', 'select', '0,1,2,3,4,5', '', '5', 1), (319, 3, 'page_size', 'text', '', '', '10', 1), (320, 3, 'sort_order_type', 'select', '0,1,2', '', '2', 1), (321, 3, 'sort_order_method', 'select', '0,1', '', '1', 1), (322, 3, 'show_order_type', 'select', '0,1,2', '', '1', 1), (323, 3, 'attr_related_number', 'text', '', '', '5', 1), (324, 3, 'goods_gallery_number', 'text', '', '', '4', 1), (325, 3, 'article_title_length', 'text', '', '', '16', 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', '', '0', 1), (334, 3, 'article_page_size', 'text', '', '', '10', 1), (335, 3, 'page_style', 'select', '0,1', '', '0', 1), (336, 3, 'recommend_order', 'select', '0,1', '', '0', 1), (337, 3, 'index_ad', 'hidden', '', '', 'cus', 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', '', '0', 1), (404, 4, 'use_surplus', 'select', '1,0', '', '0', 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', '', '0', 1), (411, 4, 'order_unpay_note', 'select', '1,0', '', '0', 1), (412, 4, 'order_ship_note', 'select', '1,0', '', '0', 1), (413, 4, 'order_receive_note', 'select', '1,0', '', '0', 1), (414, 4, 'order_unship_note', 'select', '1,0', '', '0', 1), (415, 4, 'order_return_note', 'select', '1,0', '', '0', 1), (416, 4, 'order_invalid_note', 'select', '1,0', '', '0', 1), (417, 4, 'order_cancel_note', 'select', '1,0', '', '0', 1), (418, 4, 'invoice_content', 'textarea', '', '', '', 1), (419, 4, 'anonymous_buy', 'select', '1,0', '', '0', 1), (420, 4, 'min_goods_amount', 'text', '', '', '0', 1), (421, 4, 'one_step_buy', 'select', '1,0', '', '0', 1), (422, 4, 'invoice_type', 'manual', '', '', 'a:2:{s:4:"type";a:3:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:0:"";}s:4:"rate";a:3:{i:0;d:1;i:1;d:1.5;i:2;d:0;}}', 1), (423, 4, 'stock_dec_time', 'select', '1,0', '', '0', 1), (424, 4, 'cart_confirm', 'options', '1,2,3,4', '', '3', 0), (425, 4, 'send_service_email', 'select', '1,0', '', '0', 1), (426, 4, 'show_goods_in_cart', 'select', '1,2,3', '', '2', 1), (427, 4, 'show_attr_in_cart', 'select', '1,0', '', '0', 1), (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), (508, 5, 'smtp_ssl', 'select', '0,1', '', '0', 0), (601, 6, 'integrate_code', 'hidden', '', '', 'ecshop', 1), (602, 6, 'integrate_config', 'hidden', '', '', '', 1), (603, 6, 'hash_code', 'hidden', '', '', '31693422540744c0a6b6da635b7a5a93', 1), (604, 6, 'template', 'hidden', '', '', 'themes', 1), (605, 6, 'install_date', 'hidden', '', '', '1422355617', 1), (606, 6, 'ecs_version', 'hidden', '', '', 'v2.7.3', 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:1;}', 1), (617, 6, 'captcha', 'hidden', '', '', '1', 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', '', '', '', 0), (622, 6, 'flash_theme', 'hidden', '', '', 'pinkfocus', 1), (623, 6, 'stylename', 'hidden', '', '', '', 1), (701, 7, 'show_goodssn', 'select', '1,0', '', '1', 1), (702, 7, 'show_brand', 'select', '1,0', '', '0', 1), (703, 7, 'show_goodsweight', 'select', '1,0', '', '0', 1), (704, 7, 'show_goodsnumber', 'select', '1,0', '', '0', 1), (705, 7, 'show_addtime', 'select', '1,0', '', '1', 1), (706, 7, 'goodsattr_style', 'select', '1,0', '', '0', 1), (707, 7, 'show_marketprice', 'select', '1,0', '', '0', 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), (903, 2, 'message_check', 'select', '1,0', '', '0', 1); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_snatch_log` -- DROP TABLE IF EXISTS `ecs_snatch_log`; CREATE TABLE IF NOT EXISTS `ecs_snatch_log` ( `log_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `snatch_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `bid_price` decimal(10,2) NOT NULL DEFAULT '0.00', `bid_time` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`log_id`), KEY `snatch_id` (`snatch_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_stats` -- DROP TABLE IF EXISTS `ecs_stats`; CREATE TABLE IF NOT EXISTS `ecs_stats` ( `access_time` int(10) unsigned NOT NULL DEFAULT '0', `ip_address` varchar(15) NOT NULL DEFAULT '', `visit_times` smallint(5) unsigned NOT NULL DEFAULT '1', `browser` varchar(60) NOT NULL DEFAULT '', `system` varchar(20) NOT NULL DEFAULT '', `language` varchar(20) NOT NULL DEFAULT '', `area` varchar(30) NOT NULL DEFAULT '', `referer_domain` varchar(100) NOT NULL DEFAULT '', `referer_path` varchar(200) NOT NULL DEFAULT '', `access_url` varchar(255) NOT NULL DEFAULT '', KEY `access_time` (`access_time`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 資料表的匯出資料 `ecs_stats` -- INSERT INTO `ecs_stats` (`access_time`, `ip_address`, `visit_times`, `browser`, `system`, `language`, `area`, `referer_domain`, `referer_path`, `access_url`) VALUES (1422326983, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422326985, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422327002, '111.254.196.129', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://test03.fbook.com.tw', '/', '/index.php'), (1422327528, '111.254.196.129', 13, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422327539, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422331829, '111.254.196.129', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422331855, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422331868, '111.254.196.129', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1422332129, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422393105, '111.254.209.75', 14, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422393136, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422402973, '66.249.84.173', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/index.php'), (1422402973, '66.249.84.179', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/index.php'), (1422471938, '111.254.209.75', 15, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422472208, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422472312, '111.254.209.75', 3, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1422483626, '111.254.209.75', 16, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422495459, '66.249.84.185', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/index.php'), (1422496155, '111.254.209.75', 17, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422496198, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422496223, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422496239, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422496242, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422496720, '111.254.209.75', 4, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1422553073, '111.254.209.75', 18, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422553722, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422554337, '111.254.209.75', 5, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1422564452, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422567909, '223.143.137.210', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422568054, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422568057, '59.127.75.54', 1, 'Safari 537.36', 'Windows XP', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1422568203, '111.254.209.75', 6, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://test03.fbook.com.tw', '/admin/article.php?act=list', '/article.php'), (1422568913, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422571301, '111.254.209.75', 7, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://test03.fbook.com.tw', '/article.php?id=3', '/index.php'), (1422581107, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422588735, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422600550, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422600550, '118.232.173.101', 1, 'Safari 537.36', 'Windows XP', 'zh-TW,zh', 'APNIC', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1422602471, '118.232.173.101', 2, 'Safari 537.36', 'Windows XP', 'zh-TW,zh', 'APNIC', '', '', '/category.php'), (1422608713, '118.232.173.101', 3, 'Safari 537.36', 'Windows XP', 'zh-TW,zh', 'APNIC', 'http://test03.fbook.com.tw', '/', '/index.php'), (1422655443, '114.35.145.29', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422655485, '49.219.185.164', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/article.php'), (1422679368, '223.143.176.163', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422681402, '118.232.173.101', 4, 'Safari 537.36', 'Windows XP', 'zh-TW,zh', 'APNIC', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1422681403, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422687943, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422689124, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422697919, '118.232.173.101', 1, '', 'Unknown', '', 'APNIC', '', '', '/topic.php'), (1422726386, '49.219.187.153', 2, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/article.php'), (1422726387, '101.8.156.143', 1, 'Unknow browser', 'Unknown', 'zh-tw', 'IANA', '', '', '/article.php'), (1422729462, '49.219.187.153', 3, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/article.php'), (1422729945, '101.8.156.143', 1, 'Unknow browser', 'Windows NT', 'zh-TW', 'IANA', '', '', '/article.php'), (1422730732, '222.251.2.11', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', '', '', '/article.php'), (1422730732, '222.251.2.11', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', '', '', '/article.php'), (1422738612, '106.120.160.119', 1, 'Internet Explorer 8.0', 'Windows NT', '', 'IANA', 'http://test03.fbook.com.tw', '/', '/index.php'), (1422738731, '101.199.112.54', 1, 'Safari 536.11', '', 'en-us,en', 'IANA', '', '', '/index.php'), (1422744536, '49.215.152.178', 2, 'Unknow browser', 'Unknown', 'zh-tw', 'IANA', '', '', '/article.php'), (1422748461, '223.143.4.235', 3, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422774022, '118.232.173.101', 5, 'Safari 537.36', 'Windows XP', 'zh-TW,zh', 'APNIC', '', '', '/topic.php'), (1422774123, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422776529, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422776532, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422782128, '118.232.173.101', 6, 'Safari 537.36', 'Windows XP', 'zh-TW,zh', 'APNIC', 'http://test03.fbook.com.tw', '/user.php', '/index.php'), (1422785326, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422809439, '101.15.144.98', 4, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/article.php'), (1422810204, '175.182.29.41', 1, 'Internet Explorer 7.0', 'Windows NT', '', '[δ֪IP0801]', '', '', '/article.php'), (1422810215, '175.182.29.41', 2, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/index.php'), (1422810231, '175.182.29.41', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/index.php'), (1422810235, '175.182.29.41', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/index.php'), (1422810255, '175.182.29.41', 3, 'Internet Explorer 7.0', 'Windows NT', '', '[δ֪IP0801]', '', '', '/article.php'), (1422810256, '175.182.29.41', 4, 'Internet Explorer 7.0', 'Windows NT', '', '[δ֪IP0801]', '', '', '/article.php'), (1422810275, '175.182.29.41', 5, 'Internet Explorer 7.0', 'Windows NT', '', '[δ֪IP0801]', '', '', '/article.php'), (1422810277, '175.182.29.41', 6, 'Internet Explorer 7.0', 'Windows NT', '', '[δ֪IP0801]', '', '', '/article.php'), (1422810299, '175.182.29.41', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '[δ֪IP0801]', '', '', '/article.php'), (1422811090, '114.40.183.86', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422813049, '223.138.35.239', 1, 'Unknow browser', 'Unknown', 'zh-tw', 'IANA', '', '', '/index.php'), (1422816459, '66.249.84.185', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/index.php'), (1422818100, '36.238.0.198', 1, 'Unknow browser', 'Windows NT', 'zh-TW', 'IANA', '', '', '/article.php'), (1422821808, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1422821808, '59.127.75.54', 1, 'Safari 537.36', 'Windows XP', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1422827413, '59.127.75.54', 2, 'Safari 537.36', 'Windows XP', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/topic.php?topic_id=7', '/category.php'), (1422829943, '36.238.0.198', 2, 'Unknow browser', 'Windows NT', 'zh-TW', 'IANA', 'http://test03.fbook.com.tw', '/', '/topic.php'), (1422830041, '36.238.0.198', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/article.php'), (1422834451, '49.219.190.205', 5, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422834580, '59.127.75.54', 1, 'Internet Explorer 8.0', 'Windows XP', 'zh-tw', '̨', '', '', '/article.php'), (1422839343, '222.251.12.6', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', '', '', '/article.php'), (1422839669, '36.238.0.198', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422839868, '36.238.0.198', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://www.test03.fbook.com.tw', '/index.php', '/topic.php'), (1422841096, '218.164.129.82', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', '', '', '/index.php'), (1422841539, '39.11.152.217', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422841540, '223.139.86.164', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422841738, '114.40.183.86', 1, 'Unknow browser', 'Windows NT', 'zh-TW', 'IANA', '', '', '/index.php'), (1422842414, '111.254.225.209', 19, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422842415, '27.245.26.143', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422842761, '175.96.126.53', 1, 'Safari 537.36', 'Linux', 'zh-TW,en-US', '[δ֪IP0801]', '', '', '/index.php'), (1422843401, '218.164.129.82', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨', '', '', '/index.php'), (1422844083, '180.217.58.59', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', '', '', '/index.php'), (1422844260, '101.11.5.122', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422844350, '211.249.40.20', 1, 'Unknow browser', 'Linux', 'en-US,en', '', '', '', '/category.php'), (1422844480, '218.164.129.82', 1, 'Unknow browser', 'Unknown', 'zh-tw', '̨', '', '', '/index.php'), (1422844548, '180.217.49.173', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', '', '', '/index.php'), (1422846085, '39.13.201.181', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422846594, '180.217.60.104', 1, 'Safari 537.36', 'Linux', 'zh-TW,en-US', '[δ֪IP0801]', '', '', '/index.php'), (1422847077, '180.217.50.202', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', '', '', '/index.php'), (1422852470, '49.219.190.205', 6, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422852959, '180.217.50.202', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', '', '', '/index.php'), (1422852974, '110.26.178.197', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422853645, '111.83.124.162', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422856441, '180.217.49.173', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', '', '', '/index.php'), (1422861325, '27.246.142.27', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422861347, '27.246.142.27', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422862980, '180.217.50.236', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', '', '', '/category.php'), (1422892802, '101.11.5.122', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422897227, '42.76.26.237', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422898520, '111.254.225.209', 20, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1422899304, '218.164.129.82', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', '', '', '/index.php'), (1422903458, '111.254.225.209', 8, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://www.test03.fbook.com.tw', '/index.php', '/category.php'), (1422906894, '110.26.65.3', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422916755, '101.8.159.24', 3, 'Unknow browser', 'Unknown', 'zh-tw', 'IANA', '', '', '/article.php'), (1422916761, '61.223.102.139', 1, 'Internet Explorer 9.0', 'Windows NT', 'zh-TW', '̨', '', '', '/article.php'), (1422918747, '101.11.84.61', 6, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/article.php'), (1422919060, '101.15.131.148', 3, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1422921143, '180.204.36.44', 4, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', '', '', '/index.php'), (1422924755, '111.254.225.209', 1, 'FireFox 34.0', 'Windows NT', 'zh-tw,zh', 'IANA', 'http://114.35.205.98:1688', '/panpan_new/booxor/firstpage/FirstPage.php', '/index.php'), (1422925267, '66.249.84.179', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/index.php'), (1422925964, '106.120.160.119', 1, 'Internet Explorer 8.0', 'Windows NT', '', 'IANA', 'http://test03.fbook.com.tw', '/', '/index.php'), (1422926138, '101.199.108.50', 1, 'Safari 536.11', '', 'en-us,en', 'IANA', '', '', '/index.php'), (1422946712, '180.204.36.44', 5, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', '', '', '/index.php'), (1422982637, '101.11.82.4', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://114.35.205.98:1688', '/panpan_new/booxor/firstpage/FirstPage.php', '/index.php'), (1423022534, '222.251.10.178', 3, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', '', '', '/article.php'), (1423118638, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1423118640, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1423119111, '66.249.84.161', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/article_cat.php'), (1423119112, '66.249.84.167', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/index.php'), (1423119177, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1423122427, '59.125.248.253', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/', '/index.php'), (1423127470, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1423155641, '101.15.144.3', 7, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1423156591, '180.217.53.233', 3, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', '', '', '/category.php'), (1423157953, '180.217.62.143', 2, 'Safari 537.36', 'Linux', 'zh-TW,en-US', '[δ֪IP0801]', '', '', '/index.php'), (1423175352, '223.139.97.35', 2, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1423180365, '101.15.145.166', 8, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/article.php'), (1423180681, '223.142.235.9', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/article.php'), (1423182251, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1423182252, '114.40.176.220', 3, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1423182297, '173.252.74.113', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/index.php'), (1423182497, '27.245.146.165', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', 'http://114.35.205.98:1688', '/panpan_new/booxor/about/about.php', '/index.php'), (1423182507, '180.217.59.159', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', 'http://114.35.205.98:1688', '/panpan_new/booxor/firstpage/FirstPage.php', '/index.php'), (1423182539, '27.245.146.165', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', 'http://www.test03.fbook.com.tw', '/index.php', '/article_cat.php'), (1423182791, '54.187.222.253', 1, 'Internet Explorer 6.0', 'Windows XP', 'zh-CN,zh', '', '', '', '/index.php'), (1423182883, '180.217.59.159', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', 'http://www.test03.fbook.com.tw', '/index.php', '/topic.php'), (1423183034, '114.40.176.220', 3, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1423183122, '114.40.176.220', 3, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1423183215, '54.191.244.153', 1, 'Internet Explorer 6.0', 'Windows XP', 'zh-CN,zh', '', '', '', '/article_cat.php'), (1423183232, '101.15.145.166', 2, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://114.35.205.98:1688', '/panpan_new/booxor/firstpage/FirstPage.php', '/index.php'), (1423183479, '114.40.176.220', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1423183985, '114.40.176.220', 1, 'Unknow browser', 'Windows NT', 'zh-TW', 'IANA', '', '', '/index.php'), (1423188083, '114.40.176.220', 4, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1423188671, '114.40.176.220', 4, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://test03.fbook.com.tw', '/', '/index.php'), (1423203511, '223.142.1.212', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1423205823, '59.125.248.253', 1, 'Internet Explorer 10.0', 'Windows NT', 'zh-TW', '̨', '', '', '/article.php'), (1423205866, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1423205867, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1423207079, '59.125.248.253', 2, 'Internet Explorer 10.0', 'Windows NT', 'zh-TW', '̨', '', '', '/category.php'), (1423207103, '59.125.248.253', 3, 'Internet Explorer 10.0', 'Windows NT', 'zh-TW', '̨', '', '', '/article_cat.php'), (1423270121, '110.26.76.105', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1423289019, '222.251.0.221', 4, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', '', '', '/article.php'), (1423371109, '180.217.28.204', 4, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', '', '', '/index.php'), (1423459094, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1423459110, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1423468331, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1423468920, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1423468921, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1423770843, '222.251.17.112', 5, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', '', '', '/article.php'), (1423796495, '39.9.160.141', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1423796714, '54.68.97.166', 1, 'Internet Explorer 6.0', 'Windows XP', 'zh-CN,zh', '', '', '', '/index.php'), (1423884458, '182.235.203.178', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', '', '', '/index.php'), (1423949218, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1423949220, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1423951886, '59.125.248.253', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/', '/topic.php'), (1423958889, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1423958896, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1423961724, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1423961726, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1423966358, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1423973029, '59.125.248.253', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/article.php?id=12', '/index.php'), (1423975723, '59.125.248.253', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/topic.php?topic_id=3', '/topic.php'), (1424038601, '111.254.205.88', 1, 'Unknow browser', 'Windows NT', 'zh-TW', 'IANA', '', '', '/article.php'), (1424038647, '101.226.51.229', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', 'IANA', '', '', '/topic.php'), (1424038650, '180.153.163.189', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', '[δ֪IP0801]', '', '', '/category.php'), (1424038682, '101.226.66.173', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', 'IANA', 'http://test03.fbook.com.tw', '/category.php?id=6', '/category.php'), (1424038691, '101.226.65.106', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', 'IANA', 'http://test03.fbook.com.tw', '/category.php?id=5', '/article_cat.php'), (1424038761, '180.153.201.217', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', '[δ֪IP0801]', 'http://test03.fbook.com.tw', '/category.php?id=5', '/goods.php'), (1424038808, '119.147.146.189', 1, 'Safari 537.36', 'Windows NT', 'zh-CN,zh', 'APNIC', '', '', '/topic.php'), (1424038891, '180.153.206.38', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', '[δ֪IP0801]', '', '', '/topic.php'), (1424038926, '112.64.235.247', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', 'IANA', '', '', '/article.php'), (1424039173, '223.141.11.131', 3, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/article.php'), (1424039315, '101.226.66.187', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', 'IANA', '', '', '/index.php'), (1424039320, '101.226.66.187', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', 'IANA', '', '', '/index.php'), (1424039374, '101.226.33.202', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', 'IANA', 'http://test03.fbook.com.tw', '/article.php?id=4', '/article.php'), (1424040052, '112.64.235.247', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', 'IANA', '', '', '/article.php'), (1424040180, '222.73.77.54', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', '', '', '', '/topic.php'), (1424040852, '101.226.102.97', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', 'IANA', 'http://test03.fbook.com.tw', '/article.php?id=12', '/brand.php'), (1424046202, '111.254.205.88', 21, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424046243, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1424048463, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1424048975, '220.142.122.6', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1424049962, '180.153.201.215', 1, 'Unknow browser', 'Unknown', 'zh-cn, zh', '[δ֪IP0801]', 'http://test03.fbook.com.tw', '/category.php?id=6', '/category.php'), (1424067091, '220.142.122.6', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', '', '', '/category.php'), (1424110724, '114.40.183.77', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424112172, '49.219.186.252', 9, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/article.php'), (1424113726, '66.249.84.198', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/index.php'), (1424117317, '49.219.186.252', 10, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/article.php'), (1424121859, '36.237.207.90', 3, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424121876, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1424716278, '111.254.215.127', 22, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424718424, '111.254.215.127', 23, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424728337, '111.254.215.127', 24, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424728924, '36.231.117.85', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424728929, '36.231.117.85', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://funkid.com.tw', '/', '/category.php'), (1424729715, '111.254.215.127', 9, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://www.test03.fbook.com.tw', '/index.php', '/article.php'), (1424729740, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1424730586, '66.249.84.186', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/index.php'), (1424731488, '111.254.215.127', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424732393, '111.254.215.127', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424732397, '111.254.215.127', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://funkid.com.tw', '/', '/category.php'), (1424732451, '111.254.215.127', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424732727, '111.254.215.127', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://funkid.com.tw', '/article.php?id=4', '/article.php'), (1424748739, '101.15.16.94', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424748796, '101.15.16.94', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://www.funkid.com.tw', '/', '/category.php'), (1424749670, '222.251.28.49', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', '', '', '/index.php'), (1424749744, '222.251.28.49', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', 'http://www.funkid.com.tw', '/', '/topic.php'), (1424750402, '54.191.60.194', 1, 'Internet Explorer 6.0', 'Windows XP', 'zh-CN,zh', '', '', '', '/topic.php'), (1424750510, '54.187.222.253', 1, 'Internet Explorer 6.0', 'Windows XP', 'zh-CN,zh', '', '', '', '/index.php'), (1424848021, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', '', '', '/index.php'), (1424848097, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/topic.php?topic_id=3', '/topic.php'), (1424893192, '223.141.0.74', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1424893518, '218.164.129.13', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', '', '', '/index.php'), (1424893543, '218.164.129.13', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', 'http://www.funkid.com.tw', '/', '/article.php'), (1424893677, '223.139.112.171', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1424894784, '223.139.112.171', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1424894791, '223.139.112.171', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', 'http://www.funkid.com.tw', '/', '/category.php'), (1424894949, '39.10.6.44', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1424894961, '114.40.177.51', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424894972, '39.10.6.44', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', 'http://www.funkid.com.tw', '/', '/topic.php'), (1424895005, '114.40.177.51', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://www.funkid.com.tw', '/', '/article.php'), (1424895138, '39.10.6.44', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', 'http://funkid.com.tw', '/topic.php?topic_id=3', '/topic.php'), (1424895755, '180.217.58.153', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', '', '', '/index.php'), (1424895802, '180.217.58.153', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '[δ֪IP0801]', 'http://www.funkid.com.tw', '/', '/article.php'), (1424895859, '223.140.19.95', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424897060, '39.13.137.133', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1424897090, '39.13.137.133', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/topic.php'), (1424897109, '39.13.137.133', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/topic.php'), (1424898911, '223.138.149.160', 1, 'Unknow browser', 'Unknown', 'zh-tw', 'IANA', '', '', '/index.php'), (1424898975, '27.246.160.51', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424899087, '27.246.160.51', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://www.funkid.com.tw', '/', '/topic.php'), (1424900444, '27.52.139.239', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1424900486, '27.52.139.239', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', 'http://www.funkid.com.tw', '/', '/topic.php'), (1424902248, '27.246.160.51', 2, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1424902266, '27.246.160.51', 2, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://www.funkid.com.tw', '/', '/topic.php'), (1424904350, '66.249.84.251', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/index.php'), (1424905712, '222.251.29.10', 1, 'Safari 537.36', 'Linux', 'zh-TW,en-US', '̨', '', '', '/index.php'), (1424912148, '222.251.29.10', 2, 'Safari 537.36', 'Linux', 'zh-TW,en-US', '̨', '', '', '/index.php'), (1424912161, '222.251.29.10', 1, 'Safari 537.36', 'Linux', 'zh-TW,en-US', '̨', 'http://www.funkid.com.tw', '/', '/topic.php'), (1424912328, '218.164.129.13', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', '', '', '/index.php'), (1424912339, '218.164.129.13', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', 'http://www.funkid.com.tw', '/', '/category.php'), (1424917266, '222.251.16.75', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', '', '', '/index.php'), (1424921232, '222.251.29.10', 3, 'Safari 537.36', 'Linux', 'zh-TW,en-US', '̨', '', '', '/index.php'), (1424921267, '222.251.29.10', 2, 'Safari 537.36', 'Linux', 'zh-TW,en-US', '̨', 'http://www.funkid.com.tw', '/', '/article.php'), (1425070003, '39.15.14.64', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1425070009, '27.241.207.172', 1, 'Unknow browser', 'Unknown', 'zh-tw', 'IANA', '', '', '/index.php'), (1425070011, '39.15.14.64', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', 'http://www.funkid.com.tw', '/', '/article.php'), (1425070033, '27.241.207.172', 1, 'Unknow browser', 'Unknown', 'zh-tw', 'IANA', 'http://www.funkid.com.tw', '/', '/category.php'), (1425074847, '66.249.84.176', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/brand.php'), (1425090205, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1425090205, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1425090224, '223.140.222.67', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1425090520, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/topic.php?topic_id=3', '/topic.php'), (1425094298, '59.125.248.253', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/', '/index.php'), (1425094315, '59.125.248.253', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/topic.php?topic_id=3', '/topic.php'), (1425157183, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1425157183, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1425157939, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', '', '', '/index.php'), (1425158642, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/topic.php?topic_id=3', '/topic.php'), (1425158702, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1425160784, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1425160798, '121.196.43.130', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1425160927, '59.125.248.253', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/topic.php?topic_id=3', '/topic.php'), (1425167407, '1.175.246.17', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1425167465, '1.175.246.17', 3, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1425167513, '1.175.246.17', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://www.funkid.com.tw', '/', '/topic.php'), (1425167522, '1.175.246.17', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://funkid.com.tw', '/topic.php?topic_id=3', '/topic.php'), (1425167868, '54.191.244.94', 1, 'Internet Explorer 6.0', 'Windows XP', 'zh-CN,zh', '', '', '', '/index.php'), (1425174728, '59.125.248.253', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/topic.php?topic_id=13', '/index.php'), (1425178631, '59.125.248.253', 3, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/topic.php?topic_id=3', '/category.php'), (1425180315, '101.15.18.99', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1425180330, '101.15.18.99', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://www.funkid.com.tw', '/', '/category.php'), (1425180426, '101.15.18.99', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://funkid.com.tw', '/category.php?id=5', '/topic.php'), (1425231958, '223.140.184.183', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1425231988, '223.140.184.183', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://www.funkid.com.tw', '/', '/topic.php'), (1425245833, '122.117.156.173', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', '', '', '/index.php'), (1425247604, '110.26.168.113', 2, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/category.php'), (1425247617, '110.26.168.113', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://test03.fbook.com.tw', '/category.php?id=2', '/article_cat.php'), (1425274975, '218.164.188.245', 1, 'Unknow browser', 'Windows NT', 'zh-TW', '̨', '', '', '/index.php'), (1425275010, '218.164.188.245', 1, 'Unknow browser', 'Windows NT', 'zh-TW', '̨', 'http://www.funkid.com.tw', '/', '/topic.php'), (1425275025, '218.164.188.245', 1, 'Unknow browser', 'Windows NT', 'zh-TW', '̨', 'http://funkid.com.tw', '/topic.php?topic_id=4', '/topic.php'), (1425403566, '180.217.26.106', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', '[δ֪IP0801]', '', '', '/category.php'), (1425403592, '180.217.26.106', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', '[δ֪IP0801]', 'http://test03.fbook.com.tw', '/category.php?id=2', '/category.php'), (1425439827, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1425439828, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1425444980, '59.125.248.253', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/article.php?id=13', '/index.php'), (1425445934, '66.249.84.169', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/brand.php'), (1425446756, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/category.php?id=5', '/topic.php'), (1425491800, '49.219.188.8', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/article.php'), (1425517814, '114.40.174.5', 2, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1425519773, '222.251.19.203', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', '', '', '/index.php'), (1425519781, '114.40.174.5', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1425519871, '222.251.19.203', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', '̨', 'http://www.funkid.com.tw', '/', '/topic.php'), (1425519906, '114.40.174.5', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', 'http://www.funkid.com.tw', '/', '/topic.php'), (1425520049, '54.191.217.102', 1, 'Internet Explorer 6.0', 'Windows XP', 'zh-CN,zh', '', '', '', '/index.php'), (1425522405, '101.11.81.144', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1425593360, '101.15.18.55', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1425593387, '101.15.18.55', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://www.funkid.com.tw', '/', '/category.php'), (1425593652, '101.15.18.55', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://www.funkid.com.tw', '/', '/topic.php'), (1425667580, '223.138.167.248', 4, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1425691934, '66.249.84.169', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/brand.php'), (1425696685, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1425697000, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1425697119, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/article.php?id=13', '/topic.php'), (1425703211, '59.125.248.253', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1425929578, '223.139.139.67', 5, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1425929660, '114.40.176.148', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1425929683, '114.40.176.148', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', 'http://www.funkid.com.tw', '/', '/category.php'), (1425929771, '114.40.176.148', 3, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', 'http://funkid.com.tw', '/topic.php?topic_id=3', '/topic.php'), (1426146235, '64.233.172.137', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/brand.php'), (1426231920, '54.191.212.73', 1, 'Internet Explorer 6.0', 'Windows XP', 'zh-CN,zh', '', '', '', '/topic.php'), (1426231922, '54.191.212.73', 1, 'Internet Explorer 6.0', 'Windows XP', 'zh-CN,zh', '', '', '', '/index.php'), (1426461247, '59.127.75.54', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1426461249, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1426461270, '59.127.75.54', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/category.php?id=5', '/topic.php'), (1426463452, '66.102.6.140', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/brand.php'), (1426465458, '59.127.75.54', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/', '/message.php'), (1426469161, '121.196.43.131', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1426469198, '59.127.75.54', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1426469203, '59.127.75.54', 3, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/topic.php?topic_id=3', '/topic.php'), (1426563507, '66.102.6.131', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/brand.php'), (1426623472, '39.11.7.121', 3, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1426638809, '101.11.84.100', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1426638913, '101.11.84.100', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://www.funkid.com.tw', '/', '/topic.php'), (1426638947, '101.11.84.100', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://test03.fbook.com.tw', '/topic.php?topic_id=13', '/category.php'), (1426650700, '66.102.6.140', 1, 'FireFox 6.0', 'Windows NT', '', '', '', '', '/brand.php'), (1426718083, '101.11.4.111', 1, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1426737901, '101.15.34.12', 2, 'Safari 534.30', 'Linux', 'zh-TW, en-US', 'IANA', '', '', '/index.php'), (1426790476, '111.254.216.238', 1, 'Safari 537.36', 'Windows XP', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1427073740, '223.138.157.254', 2, 'Unknow browser', 'Unknown', 'zh-tw', 'IANA', '', '', '/index.php'), (1427073765, '223.138.157.254', 1, 'Unknow browser', 'Unknown', 'zh-tw', 'IANA', 'http://www.funkid.com.tw', '/', '/article.php'), (1427073846, '223.138.157.254', 2, 'Unknow browser', 'Unknown', 'zh-tw', 'IANA', 'http://funkid.com.tw', '/topic.php?topic_id=3', '/topic.php'), (1427323448, '49.219.187.78', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1427325482, '49.219.187.78', 2, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1427325719, '49.219.187.78', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', 'http://www.funkid.com.tw', '/', '/topic.php'), (1427346621, '111.254.209.6', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', '', '', '/index.php'), (1427346700, '111.254.209.6', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', 'IANA', 'http://funkid.com.tw', '/topic.php?topic_id=3', '/topic.php'), (1427588794, '122.144.135.142', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1427588794, '60.249.144.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1427588994, '60.249.144.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/article.php?id=12', '/brand.php'), (1427594260, '60.249.144.253', 2, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://funkid.com.tw', '/topic.php?topic_id=3', '/topic.php'), (1427953952, '27.240.50.156', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', 'IANA', '', '', '/category.php'), (1428100544, '59.125.248.253', 1, 'Safari 537.36', 'Windows NT', 'zh-TW,zh', '̨', 'http://test03.fbook.com.tw', '/admin/index.php?act=top', '/index.php'), (1428100554, '122.144.135.142', 1, 'Unknow browser', 'Unknown', '', '', '', '', '/certi.php'), (1428128107, '180.217.21.182', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', '[δ֪IP0801]', '', '', '/article_cat.php'), (1428273182, '111.254.197.130', 2, 'Safari 537.36', 'Windows XP', 'zh-TW,zh', 'IANA', '', '', '/index.php'); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_suppliers` -- DROP TABLE IF EXISTS `ecs_suppliers`; CREATE TABLE IF NOT EXISTS `ecs_suppliers` ( `suppliers_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `suppliers_name` varchar(255) DEFAULT NULL, `suppliers_desc` mediumtext, `is_check` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`suppliers_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_tag` -- DROP TABLE IF EXISTS `ecs_tag`; CREATE TABLE IF NOT EXISTS `ecs_tag` ( `tag_id` mediumint(8) NOT NULL AUTO_INCREMENT, `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `tag_words` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`tag_id`), KEY `user_id` (`user_id`), KEY `goods_id` (`goods_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_template` -- DROP TABLE IF EXISTS `ecs_template`; CREATE TABLE IF NOT EXISTS `ecs_template` ( `filename` varchar(30) NOT NULL DEFAULT '', `region` varchar(40) NOT NULL DEFAULT '', `library` varchar(40) NOT NULL DEFAULT '', `sort_order` tinyint(1) unsigned NOT NULL DEFAULT '0', `id` smallint(5) unsigned NOT NULL DEFAULT '0', `number` tinyint(1) unsigned NOT NULL DEFAULT '5', `type` tinyint(1) unsigned NOT NULL DEFAULT '0', `theme` varchar(60) NOT NULL DEFAULT '', `remarks` varchar(30) NOT NULL DEFAULT '', KEY `filename` (`filename`,`region`), KEY `theme` (`theme`), KEY `remarks` (`remarks`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- 資料表的匯出資料 `ecs_template` -- INSERT INTO `ecs_template` (`filename`, `region`, `library`, `sort_order`, `id`, `number`, `type`, `theme`, `remarks`) VALUES ('index', '左邊區域', '/library/vote_list.lbi', 8, 0, 0, 0, 'default', ''), ('index', '左邊區域', '/library/email_list.lbi', 9, 0, 0, 0, 'default', ''), ('index', '左邊區域', '/library/order_query.lbi', 6, 0, 0, 0, 'default', ''), ('index', '左邊區域', '/library/cart.lbi', 0, 0, 0, 0, 'default', ''), ('index', '左邊區域', '/library/promotion_info.lbi', 3, 0, 0, 0, 'default', ''), ('index', '左邊區域', '/library/auction.lbi', 4, 0, 3, 0, 'default', ''), ('index', '左邊區域', '/library/group_buy.lbi', 5, 0, 3, 0, 'default', ''), ('index', '', '/library/recommend_promotion.lbi', 0, 0, 4, 0, 'default', ''), ('index', '右邊主區域', '/library/recommend_hot.lbi', 2, 0, 10, 0, 'default', ''), ('index', '右邊主區域', '/library/recommend_new.lbi', 1, 0, 10, 0, 'default', ''), ('index', '右邊主區域', '/library/recommend_best.lbi', 0, 0, 10, 0, 'default', ''), ('index', '左邊區域', '/library/invoice_query.lbi', 7, 0, 0, 0, 'default', ''), ('index', '左邊區域', '/library/top10.lbi', 2, 0, 0, 0, 'default', ''), ('index', '左邊區域', '/library/category_tree.lbi', 1, 0, 0, 0, 'default', ''), ('index', '', '/library/brands.lbi', 0, 0, 11, 0, 'default', ''), ('category', '左邊區域', '/library/category_tree.lbi', 1, 0, 0, 0, 'default', ''), ('category', '右邊區域', '/library/recommend_best.lbi', 0, 0, 5, 0, 'default', ''), ('category', '右邊區域', '/library/goods_list.lbi', 1, 0, 0, 0, 'default', ''), ('category', '右邊區域', '/library/pages.lbi', 2, 0, 0, 0, 'default', ''), ('category', '左邊區域', '/library/cart.lbi', 0, 0, 0, 0, 'default', ''), ('category', '左邊區域', '/library/price_grade.lbi', 3, 0, 0, 0, 'default', ''), ('category', '左邊區域', '/library/filter_attr.lbi', 2, 0, 0, 0, 'default', ''), ('index', '', '/library/cat_articles.lbi', 0, 5, 5, 3, 'themes', '2015-02-07 00:01:39'), ('article', '左边广告区域(宽200px)', '/library/cat_articles.lbi', 2, 5, 5, 3, 'themes', ''), ('brand', '右边区域', '/library/pages.lbi', 1, 0, 0, 0, 'themes', ''), ('index', '主区域', '/library/ad_position.lbi', 1, 6, 1, 4, 'themes', ''), ('index', '主区域', '/library/cat_articles.lbi', 2, 5, 5, 3, 'themes', ''), ('index', '', '/library/brands.lbi', 0, 0, 3, 0, 'themes', ''), ('article', '', '/library/recommend_best.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('goods', '右边可编辑区域', '/library/comments.lbi', 1, 0, 0, 0, 'themes', ''), ('index', '', '/library/auction.lbi', 0, 0, 3, 0, 'themes', ''), ('index', '', '/library/group_buy.lbi', 0, 0, 3, 0, 'themes', ''), ('article', '', '/library/recommend_promotion.lbi', 0, 0, 3, 0, 'themes', ''), ('article', '', '/library/recommend_hot.lbi', 0, 0, 3, 0, 'themes', ''), ('article', '', '/library/recommend_best.lbi', 0, 0, 3, 0, 'themes', ''), ('article_cat', '左边广告区域(宽200px)', '/library/cat_articles.lbi', 2, 5, 1, 3, 'themes', ''), ('article_cat', '左边广告区域(宽200px)', '/library/ad_position.lbi', 1, 3, 1, 4, 'themes', ''), ('article_cat', '', '/library/recommend_promotion.lbi', 0, 0, 3, 0, 'themes', ''), ('message_board', '', '/library/message_list.lbi', 0, 0, 10, 0, 'themes', ''), ('article_cat', '', '/library/recommend_best.lbi', 0, 0, 3, 0, 'themes', ''), ('article_cat', '', '/library/recommend_hot.lbi', 0, 0, 3, 0, 'themes', ''), ('brand', '', '/library/recommend_promotion.lbi', 0, 0, 3, 0, 'themes', ''), ('message_board', '左边区域', '/library/ad_position.lbi', 0, 5, 1, 4, 'themes', ''), ('article', '左边广告区域(宽200px)', '/library/ad_position.lbi', 1, 3, 1, 4, 'themes', ''), ('index', '', '/library/recommend_hot.lbi', 0, 0, 3, 0, 'themes', ''), ('index', '', '/library/recommend_promotion.lbi', 0, 0, 4, 0, 'themes', ''), ('category', '左边区域', '/library/ad_position.lbi', 0, 3, 1, 4, 'themes', ''), ('category', '左边区域', '/library/ad_position.lbi', 1, 5, 1, 4, 'themes', ''), ('category', '', '/library/brands.lbi', 0, 0, 3, 0, 'themes', ''), ('index', '', '/library/recommend_new.lbi', 0, 0, 3, 0, 'themes', ''), ('index', '', '/library/brands.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('index', '', '/library/group_buy.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('index', '', '/library/auction.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('index', '', '/library/recommend_promotion.lbi', 0, 0, 4, 0, 'themes', '2015-02-07 00:01:39'), ('goods', '右边可编辑区域', '/library/comments.lbi', 0, 0, 0, 0, 'themes', '2015-02-07 00:01:39'), ('goods', '左边区域', '/library/category_tree.lbi', 1, 0, 0, 0, 'themes', '2015-02-07 00:01:39'), ('index', '', '/library/recommend_hot.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('index', '', '/library/recommend_new.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('article', '', '/library/recommend_hot.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('article', '', '/library/recommend_promotion.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('article', '左边广告区域(宽200px)', '/library/cat_articles.lbi', 0, 5, 5, 3, 'themes', '2015-02-07 00:01:39'), ('article_cat', '', '/library/ad_position.lbi', 1, 2, 1, 4, 'themes', '2015-02-07 00:01:39'), ('article_cat', '左边广告区域(宽200px)', '/library/cat_articles.lbi', 0, 5, 5, 3, 'themes', '2015-02-07 00:01:39'), ('article_cat', '', '/library/recommend_hot.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('article_cat', '', '/library/recommend_promotion.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('message_board', '左边区域', '/library/category_tree.lbi', 0, 0, 0, 0, 'themes', '2015-02-07 00:01:39'), ('message_board', '', '/library/message_list.lbi', 0, 0, 10, 0, 'themes', '2015-02-07 00:01:39'), ('article_cat', '', '/library/recommend_best.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('category', '', '/library/brands.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('category', '左边区域', '/library/ad_position.lbi', 50, 2, 1, 4, 'themes', '2015-02-07 00:01:39'), ('category', '', '/library/recommend_promotion.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('category', '', '/library/recommend_hot.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('category', '右边区域', '/library/goods_list.lbi', 0, 0, 0, 0, 'themes', '2015-02-07 00:01:39'), ('category', '右边区域', '/library/pages.lbi', 1, 0, 0, 0, 'themes', '2015-02-07 00:01:39'), ('category', '', '/library/recommend_best.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('category', '左边区域', '/library/category_tree.lbi', 1, 0, 0, 0, 'themes', '2015-02-07 00:01:39'), ('index', '', '/library/recommend_best.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:39'), ('article', '', '/library/recommend_best.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('index', '', '/library/cat_articles.lbi', 0, 5, 5, 3, 'themes', '2015-02-07 00:01:47'), ('index', '', '/library/brands.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('index', '', '/library/group_buy.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('index', '', '/library/auction.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('index', '', '/library/recommend_promotion.lbi', 0, 0, 4, 0, 'themes', '2015-02-07 00:01:47'), ('goods', '右边可编辑区域', '/library/comments.lbi', 0, 0, 0, 0, 'themes', '2015-02-07 00:01:47'), ('goods', '左边区域', '/library/category_tree.lbi', 1, 0, 0, 0, 'themes', '2015-02-07 00:01:47'), ('index', '', '/library/recommend_hot.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('index', '', '/library/recommend_new.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('article', '', '/library/recommend_hot.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('article', '', '/library/recommend_promotion.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('article', '左边广告区域(宽200px)', '/library/cat_articles.lbi', 0, 5, 5, 3, 'themes', '2015-02-07 00:01:47'), ('article_cat', '', '/library/ad_position.lbi', 1, 2, 1, 4, 'themes', '2015-02-07 00:01:47'), ('article_cat', '左边广告区域(宽200px)', '/library/cat_articles.lbi', 0, 5, 5, 3, 'themes', '2015-02-07 00:01:47'), ('article_cat', '', '/library/recommend_hot.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('article_cat', '', '/library/recommend_promotion.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('message_board', '左边区域', '/library/category_tree.lbi', 0, 0, 0, 0, 'themes', '2015-02-07 00:01:47'), ('message_board', '', '/library/message_list.lbi', 0, 0, 10, 0, 'themes', '2015-02-07 00:01:47'), ('article_cat', '', '/library/recommend_best.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('category', '', '/library/brands.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('category', '左边区域', '/library/ad_position.lbi', 50, 2, 1, 4, 'themes', '2015-02-07 00:01:47'), ('category', '', '/library/recommend_promotion.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('category', '', '/library/recommend_hot.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('category', '右边区域', '/library/goods_list.lbi', 0, 0, 0, 0, 'themes', '2015-02-07 00:01:47'), ('category', '右边区域', '/library/pages.lbi', 1, 0, 0, 0, 'themes', '2015-02-07 00:01:47'), ('category', '', '/library/recommend_best.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('category', '左边区域', '/library/category_tree.lbi', 1, 0, 0, 0, 'themes', '2015-02-07 00:01:47'), ('index', '', '/library/recommend_best.lbi', 0, 0, 3, 0, 'themes', '2015-02-07 00:01:47'), ('goods', '左边区域', '/library/ad_position.lbi', 0, 5, 1, 4, 'themes', ''), ('category', '右边区域', '/library/pages.lbi', 1, 0, 0, 0, 'themes', ''), ('category', '', '/library/recommend_promotion.lbi', 0, 0, 3, 0, 'themes', ''), ('category', '右边区域', '/library/goods_list.lbi', 0, 0, 0, 0, 'themes', ''), ('brand', '左边区域', '/library/ad_position.lbi', 2, 5, 1, 4, 'themes', ''), ('goods', '右边可编辑区域', '/library/bought_goods.lbi', 0, 0, 0, 0, 'themes', ''), ('brand', '右边区域', '/library/goods_list.lbi', 0, 0, 0, 0, 'themes', ''), ('brand', '', '/library/recommend_best.lbi', 0, 0, 3, 0, 'themes', ''), ('brand', '左边区域', '/library/ad_position.lbi', 0, 4, 1, 4, 'themes', ''), ('category', '', '/library/recommend_hot.lbi', 0, 0, 3, 0, 'themes', ''), ('category', '', '/library/recommend_best.lbi', 0, 0, 3, 0, 'themes', ''), ('index', '', '/library/recommend_best.lbi', 0, 0, 3, 0, 'themes', ''); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_topic` -- DROP TABLE IF EXISTS `ecs_topic`; CREATE TABLE IF NOT EXISTS `ecs_topic` ( `topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL DEFAULT '''''', `intro` text NOT NULL, `start_time` int(11) NOT NULL DEFAULT '0', `end_time` int(10) NOT NULL DEFAULT '0', `data` text NOT NULL, `template` varchar(255) NOT NULL DEFAULT '''''', `css` text NOT NULL, `topic_img` varchar(255) DEFAULT NULL, `title_pic` varchar(255) DEFAULT NULL, `base_style` char(6) DEFAULT NULL, `htmls` mediumtext, `keywords` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, KEY `topic_id` (`topic_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ; -- -- 資料表的匯出資料 `ecs_topic` -- INSERT INTO `ecs_topic` (`topic_id`, `title`, `intro`, `start_time`, `end_time`, `data`, `template`, `css`, `topic_img`, `title_pic`, `base_style`, `htmls`, `keywords`, `description`) VALUES (4, '多元智能', '', 1422604800, 1580371200, 'O:8:"stdClass":1:{s:7:"default";a:0:{}}', '', '', '', '', '', ' \r\n \r\n \r\n\r\n \r\n \r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n
\r\n
精選系列
\r\n
\r\n
全腦開發
\r\n
\r\n
\r\n
\r\n
多元智能
\r\n
\r\n
\r\n
\r\n
成長系列
\r\n
\r\n
\r\n \r\n
\r\n
\r\n
 

\r\n

 

\r\n

 

\r\n \r\n\r\n \r\n \r\n \r\n ', '', ''), (3, '全腦開發', '', 1421136000, 1611993600, 'O:8:"stdClass":1:{s:12:"套書推薦";a:0:{}}', '', '', '', '', '', ' \r\n \r\n \r\n\r\n \r\n \r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n
\r\n
精選系列
\r\n
\r\n
全腦開發
\r\n
\r\n
\r\n
\r\n
多元智能
\r\n
\r\n
\r\n
\r\n
成長系列
\r\n
\r\n
\r\n \r\n
\r\n
\r\n
 

\r\n

 

\r\n

 

\r\n \r\n\r\n \r\n \r\n \r\n ', '', ''), (6, '成長系列', '', 1422691200, 1614412800, 'O:8:"stdClass":1:{s:7:"default";a:0:{}}', '', '', '', '', '', ' \r\n \r\n \r\n\r\n \r\n \r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n
\r\n
精選系列
\r\n
\r\n
全腦開發
\r\n
\r\n
\r\n
\r\n
多元智能
\r\n
\r\n
\r\n
\r\n
成長系列
\r\n
\r\n
\r\n \r\n
\r\n
\r\n
 

\r\n

 

\r\n

 

\r\n \r\n\r\n \r\n \r\n \r\n ', '', ''), (13, '好讚連結', '', 1425110400, 1648195200, 'O:8:"stdClass":1:{s:7:"default";a:0:{}}', '', '', '', '', '', '\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
  
教育部全球資訊網 衛生福利部社會及家庭署保母登記管理資訊網 中華民國發展遲緩兒童基金會
    
台灣母乳協會    
\r\n', '', ''); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_users` -- DROP TABLE IF EXISTS `ecs_users`; CREATE TABLE IF NOT EXISTS `ecs_users` ( `user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(60) NOT NULL DEFAULT '', `user_name` varchar(60) NOT NULL DEFAULT '', `password` varchar(32) NOT NULL DEFAULT '', `question` varchar(255) NOT NULL DEFAULT '', `answer` varchar(255) NOT NULL DEFAULT '', `sex` tinyint(1) unsigned NOT NULL DEFAULT '0', `birthday` date NOT NULL DEFAULT '0000-00-00', `user_money` decimal(10,2) NOT NULL DEFAULT '0.00', `frozen_money` decimal(10,2) NOT NULL DEFAULT '0.00', `pay_points` int(10) unsigned NOT NULL DEFAULT '0', `rank_points` int(10) unsigned NOT NULL DEFAULT '0', `address_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `reg_time` int(10) unsigned NOT NULL DEFAULT '0', `last_login` int(11) unsigned NOT NULL DEFAULT '0', `last_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_ip` varchar(15) NOT NULL DEFAULT '', `visit_count` smallint(5) unsigned NOT NULL DEFAULT '0', `user_rank` tinyint(3) unsigned NOT NULL DEFAULT '0', `is_special` tinyint(3) unsigned NOT NULL DEFAULT '0', `ec_salt` varchar(10) DEFAULT NULL, `salt` varchar(10) NOT NULL DEFAULT '0', `parent_id` mediumint(9) NOT NULL DEFAULT '0', `flag` tinyint(3) unsigned NOT NULL DEFAULT '0', `alias` varchar(60) NOT NULL, `msn` varchar(60) NOT NULL, `qq` varchar(20) NOT NULL, `office_phone` varchar(20) NOT NULL, `home_phone` varchar(20) NOT NULL, `mobile_phone` varchar(20) NOT NULL, `is_validated` tinyint(3) unsigned NOT NULL DEFAULT '0', `credit_line` decimal(10,2) unsigned NOT NULL, `passwd_question` varchar(50) DEFAULT NULL, `passwd_answer` varchar(255) DEFAULT NULL, PRIMARY KEY (`user_id`), UNIQUE KEY `user_name` (`user_name`), KEY `email` (`email`), KEY `parent_id` (`parent_id`), KEY `flag` (`flag`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- 資料表的匯出資料 `ecs_users` -- INSERT INTO `ecs_users` (`user_id`, `email`, `user_name`, `password`, `question`, `answer`, `sex`, `birthday`, `user_money`, `frozen_money`, `pay_points`, `rank_points`, `address_id`, `reg_time`, `last_login`, `last_time`, `last_ip`, `visit_count`, `user_rank`, `is_special`, `ec_salt`, `salt`, `parent_id`, `flag`, `alias`, `msn`, `qq`, `office_phone`, `home_phone`, `mobile_phone`, `is_validated`, `credit_line`, `passwd_question`, `passwd_answer`) VALUES (1, 'fatbear09@fatbear.com.tw', 'fatbear09', '45dca4348f0b5c05812e7f41088c5d28', '', '', 0, '0000-00-00', '0.00', '0.00', 0, 0, 6, 1422777247, 1422822185, '0000-00-00 00:00:00', '59.127.75.54', 3, 0, 0, '7771', '0', 0, 0, '', '', '', '', '07-5555938', '', 0, '0.00', NULL, NULL); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_user_account` -- DROP TABLE IF EXISTS `ecs_user_account`; CREATE TABLE IF NOT EXISTS `ecs_user_account` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `admin_user` varchar(255) NOT NULL, `amount` decimal(10,2) NOT NULL, `add_time` int(10) NOT NULL DEFAULT '0', `paid_time` int(10) NOT NULL DEFAULT '0', `admin_note` varchar(255) NOT NULL, `user_note` varchar(255) NOT NULL, `process_type` tinyint(1) NOT NULL DEFAULT '0', `payment` varchar(90) NOT NULL, `is_paid` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `is_paid` (`is_paid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_user_address` -- DROP TABLE IF EXISTS `ecs_user_address`; CREATE TABLE IF NOT EXISTS `ecs_user_address` ( `address_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `address_name` varchar(50) NOT NULL DEFAULT '', `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `consignee` varchar(60) NOT NULL DEFAULT '', `email` varchar(60) NOT NULL DEFAULT '', `country` smallint(5) NOT NULL DEFAULT '0', `province` smallint(5) NOT NULL DEFAULT '0', `city` smallint(5) NOT NULL DEFAULT '0', `district` smallint(5) NOT NULL DEFAULT '0', `address` varchar(120) NOT NULL DEFAULT '', `zipcode` varchar(60) NOT NULL DEFAULT '', `tel` varchar(60) NOT NULL DEFAULT '', `mobile` varchar(60) NOT NULL DEFAULT '', `sign_building` varchar(120) NOT NULL DEFAULT '', `best_time` varchar(120) NOT NULL DEFAULT '', PRIMARY KEY (`address_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; -- -- 資料表的匯出資料 `ecs_user_address` -- INSERT INTO `ecs_user_address` (`address_id`, `address_name`, `user_id`, `consignee`, `email`, `country`, `province`, `city`, `district`, `address`, `zipcode`, `tel`, `mobile`, `sign_building`, `best_time`) VALUES (6, '', 1, '000', 'fatbear09@fatbear.com.tw', 1, 3411, 3414, 0, '000000', '0000000', '000000000', '', '', ''); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_user_bonus` -- DROP TABLE IF EXISTS `ecs_user_bonus`; CREATE TABLE IF NOT EXISTS `ecs_user_bonus` ( `bonus_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `bonus_type_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `bonus_sn` bigint(20) unsigned NOT NULL DEFAULT '0', `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `used_time` int(10) unsigned NOT NULL DEFAULT '0', `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `emailed` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`bonus_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_user_feed` -- DROP TABLE IF EXISTS `ecs_user_feed`; CREATE TABLE IF NOT EXISTS `ecs_user_feed` ( `feed_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `value_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `feed_type` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_feed` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`feed_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_user_rank` -- DROP TABLE IF EXISTS `ecs_user_rank`; CREATE TABLE IF NOT EXISTS `ecs_user_rank` ( `rank_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `rank_name` varchar(30) NOT NULL DEFAULT '', `min_points` int(10) unsigned NOT NULL DEFAULT '0', `max_points` int(10) unsigned NOT NULL DEFAULT '0', `discount` tinyint(3) unsigned NOT NULL DEFAULT '0', `show_price` tinyint(1) unsigned NOT NULL DEFAULT '1', `special_rank` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`rank_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- 資料表的匯出資料 `ecs_user_rank` -- INSERT INTO `ecs_user_rank` (`rank_id`, `rank_name`, `min_points`, `max_points`, `discount`, `show_price`, `special_rank`) VALUES (1, '註冊用戶', 0, 10000, 100, 1, 0); -- -------------------------------------------------------- -- -- 資料表結構 `ecs_virtual_card` -- DROP TABLE IF EXISTS `ecs_virtual_card`; CREATE TABLE IF NOT EXISTS `ecs_virtual_card` ( `card_id` mediumint(8) NOT NULL AUTO_INCREMENT, `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `card_sn` varchar(60) NOT NULL DEFAULT '', `card_password` varchar(60) NOT NULL DEFAULT '', `add_date` int(11) NOT NULL DEFAULT '0', `end_date` int(11) NOT NULL DEFAULT '0', `is_saled` tinyint(1) NOT NULL DEFAULT '0', `order_sn` varchar(20) NOT NULL DEFAULT '', `crc32` varchar(12) NOT NULL DEFAULT '0', PRIMARY KEY (`card_id`), KEY `goods_id` (`goods_id`), KEY `car_sn` (`card_sn`), KEY `is_saled` (`is_saled`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_volume_price` -- DROP TABLE IF EXISTS `ecs_volume_price`; CREATE TABLE IF NOT EXISTS `ecs_volume_price` ( `price_type` tinyint(1) unsigned NOT NULL, `goods_id` mediumint(8) unsigned NOT NULL, `volume_number` smallint(5) unsigned NOT NULL DEFAULT '0', `volume_price` decimal(10,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`price_type`,`goods_id`,`volume_number`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_vote` -- DROP TABLE IF EXISTS `ecs_vote`; CREATE TABLE IF NOT EXISTS `ecs_vote` ( `vote_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `vote_name` varchar(250) NOT NULL DEFAULT '', `start_time` int(11) unsigned NOT NULL DEFAULT '0', `end_time` int(11) unsigned NOT NULL DEFAULT '0', `can_multi` tinyint(1) unsigned NOT NULL DEFAULT '0', `vote_count` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`vote_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_vote_log` -- DROP TABLE IF EXISTS `ecs_vote_log`; CREATE TABLE IF NOT EXISTS `ecs_vote_log` ( `log_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `vote_id` smallint(5) unsigned NOT NULL DEFAULT '0', `ip_address` varchar(15) NOT NULL DEFAULT '', `vote_time` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`log_id`), KEY `vote_id` (`vote_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_vote_option` -- DROP TABLE IF EXISTS `ecs_vote_option`; CREATE TABLE IF NOT EXISTS `ecs_vote_option` ( `option_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `vote_id` smallint(5) unsigned NOT NULL DEFAULT '0', `option_name` varchar(250) NOT NULL DEFAULT '', `option_count` int(8) unsigned NOT NULL DEFAULT '0', `option_order` tinyint(3) unsigned NOT NULL DEFAULT '100', PRIMARY KEY (`option_id`), KEY `vote_id` (`vote_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 資料表結構 `ecs_wholesale` -- DROP TABLE IF EXISTS `ecs_wholesale`; CREATE TABLE IF NOT EXISTS `ecs_wholesale` ( `act_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `goods_id` mediumint(8) unsigned NOT NULL, `goods_name` varchar(255) NOT NULL, `rank_ids` varchar(255) NOT NULL, `prices` text NOT NULL, `enabled` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`act_id`), KEY `goods_id` (`goods_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;