wayne
/
crm
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'main'
${ noResults }
crm/app/shop.sql.bak2

4922 lines
219 KiB
Raw Permalink Blame History Escape

This file contains invisible Unicode characters!

This file contains invisible Unicode characters that may be processed differently from what appears below. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to reveal hidden characters.

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

--
-- 資料庫： `shop_h888_fun`
--
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_account_log`
--
CREATE TABLE `ecs_account_log` (
`log_id` mediumint UNSIGNED NOT NULL,
`user_id` mediumint UNSIGNED NOT NULL,
`user_money` decimal(10,2) NOT NULL,
`frozen_money` decimal(10,2) NOT NULL,
`rank_points` mediumint NOT NULL,
`pay_points` mediumint NOT NULL,
`change_time` int UNSIGNED NOT NULL,
`change_desc` varchar(255) NOT NULL,
`change_type` tinyint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_account_log`
--
INSERT INTO `ecs_account_log` (`log_id`, `user_id`, `user_money`, `frozen_money`, `rank_points`, `pay_points`, `change_time`, `change_desc`, `change_type`) VALUES
(1, 259, '0.00', '0.00', 5, 5, 1669837842, '註冊送積分', 99),
(2, 260, '0.00', '0.00', 5, 5, 1670350996, '註冊送積分', 99);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_ad`
--
CREATE TABLE `ecs_ad` (
`ad_id` smallint UNSIGNED NOT NULL,
`position_id` smallint UNSIGNED NOT NULL DEFAULT '0',
`media_type` tinyint 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 NOT NULL DEFAULT '0',
`end_time` int 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 UNSIGNED NOT NULL DEFAULT '0',
`enabled` tinyint UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `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, 0, '首頁Default', '', '1670976930626391414.jpg', 1670918400, 1673510400, '', '', '', 0, 1);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_admin_action`
--
CREATE TABLE `ecs_admin_action` (
`action_id` tinyint UNSIGNED NOT NULL,
`parent_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
`action_code` varchar(20) NOT NULL DEFAULT '',
`relevance` varchar(20) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `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', ''),
(30, 2, 'article_cat', ''),
(31, 2, 'article_manage', ''),
(32, 2, 'shopinfo_manage', ''),
(33, 2, 'shophelp_manage', ''),
(34, 2, 'vote_priv', ''),
(35, 7, 'topic_manage', ''),
(38, 3, 'integrate_users', ''),
(39, 3, 'sync_users', 'integrate_users'),
(40, 3, 'users_manage', ''),
(41, 3, 'users_drop', 'users_manage'),
(42, 3, 'user_rank', ''),
(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', ''),
(70, 1, 'goods_type', ''),
(73, 3, 'feedback_priv', ''),
(74, 4, 'template_manage', ''),
(75, 5, 'friendlink', ''),
(76, 5, 'db_backup', ''),
(77, 5, 'db_renew', 'db_backup'),
(78, 7, 'snatch_manage', ''),
(79, 7, 'bonus_manage', ''),
(80, 7, 'gift_manage', ''),
(81, 7, 'card_manage', ''),
(82, 7, 'pack', ''),
(83, 7, 'ad_manage', ''),
(84, 1, 'tag_manage', ''),
(85, 3, 'surplus_manage', 'account_manage'),
(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', ''),
(136, 7, 'pre_sale', '');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_admin_log`
--
CREATE TABLE `ecs_admin_log` (
`log_id` int UNSIGNED NOT NULL,
`log_time` int UNSIGNED NOT NULL DEFAULT '0',
`user_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
`log_info` varchar(255) NOT NULL DEFAULT '',
`ip_address` varchar(15) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_admin_log`
--
INSERT INTO `ecs_admin_log` (`log_id`, `log_time`, `user_id`, `log_info`, `ip_address`) VALUES
(1, 1669804869, 1, '編輯商店設置: ', '220.129.48.248'),
(2, 1670169896, 1, '添加產品分類: 電子名片', '220.129.53.27'),
(3, 1670169908, 1, '刪除產品分類: 電子名片', '220.129.53.27'),
(4, 1670169921, 1, '添加產品分類: 智能家居', '220.129.53.27'),
(5, 1670170003, 1, '添加產品分類: 高CP產品', '220.129.53.27'),
(6, 1670884155, 1, '編輯文章: 註冊新客戶', '220.129.68.240'),
(7, 1670884261, 1, '編輯文章: 註冊新客戶', '220.129.68.240'),
(8, 1670976812, 1, '添加廣告位置: 首頁Banner', '220.129.57.87'),
(9, 1670976930, 1, '添加廣告: 首頁Default', '220.129.57.87'),
(10, 1670981861, 1, '添加廣告位置: 第二廣告位', '220.129.57.87'),
(11, 1670981936, 1, '添加廣告位置: 第二廣告位1', '220.129.57.87');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_admin_message`
--
CREATE TABLE `ecs_admin_message` (
`message_id` smallint UNSIGNED NOT NULL,
`sender_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
`receiver_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
`sent_time` int UNSIGNED NOT NULL DEFAULT '0',
`read_time` int UNSIGNED NOT NULL DEFAULT '0',
`readed` tinyint UNSIGNED NOT NULL DEFAULT '0',
`deleted` tinyint UNSIGNED NOT NULL DEFAULT '0',
`title` varchar(150) NOT NULL DEFAULT '',
`message` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_admin_user`
--
CREATE TABLE `ecs_admin_user` (
`user_id` smallint UNSIGNED NOT NULL,
`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 NOT NULL DEFAULT '0',
`last_login` int 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 UNSIGNED NOT NULL,
`suppliers_id` smallint UNSIGNED DEFAULT '0',
`todolist` longtext,
`role_id` smallint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `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, 'admin', 'admin@jixun.net', '915c8db09a9a7e1712486095601f9b32', '975', 1447698148, 1670975172, '220.129.57.87', '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, '', 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_adsense`
--
CREATE TABLE `ecs_adsense` (
`from_ad` smallint NOT NULL DEFAULT '0',
`referer` varchar(255) NOT NULL DEFAULT '',
`clicks` int UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_adsense`
--
INSERT INTO `ecs_adsense` (`from_ad`, `referer`, `clicks`) VALUES
(5, '本站', 1),
(6, '本站', 2),
(9, '本站', 1),
(8, '本站', 1),
(16, '本站', 1),
(7, 'wap站', 23),
(5, 'wap站', 16),
(11, 'wap站', 22),
(8, 'pc站', 10),
(9, 'pc站', 15),
(3, 'pc站', 4),
(16, 'wap站', 23),
(1, 'pc站', 10),
(2, 'pc站', 2),
(7, 'pc站', 5),
(9, 'wap站', 13),
(15, 'wap站', 27),
(14, 'wap站', 28),
(4, 'pc站', 7),
(5, 'pc站', 9),
(6, 'wap站', 12),
(13, 'wap站', 29),
(1, 'wap站', 6),
(12, 'wap站', 36),
(10, 'wap站', 8),
(4, 'wap站', 32),
(2, 'wap站', 27),
(8, 'wap站', 20),
(10, 'pc站', 10),
(28, 'wap站', 1),
(17, 'pc站', 20),
(15, 'pc站', 17),
(11, 'pc站', 14),
(18, 'pc站', 17),
(16, 'pc站', 20),
(25, 'pc站', 6),
(24, 'pc站', 8),
(42, 'pc站', 9),
(23, 'pc站', 19),
(21, 'pc站', 25),
(27, 'pc站', 8),
(28, 'pc站', 10),
(22, 'pc站', 13),
(14, 'pc站', 14),
(41, 'pc站', 6),
(13, 'pc站', 15),
(33, 'pc站', 12),
(19, 'pc站', 10),
(12, 'pc站', 21),
(26, 'pc站', 9),
(40, 'pc站', 5),
(34, 'pc站', 4),
(35, 'pc站', 5),
(46, 'pc站', 4),
(31, 'pc站', 5),
(29, 'pc站', 5),
(36, 'pc站', 6),
(38, 'pc站', 6),
(44, 'pc站', 5),
(20, 'pc站', 11),
(45, 'pc站', 7),
(30, 'pc站', 6),
(32, 'pc站', 6),
(43, 'pc站', 5),
(39, 'pc站', 8),
(37, 'pc站', 5),
(17, 'wap站', 1),
(21, 'wap站', 1),
(33, 'wap站', 1),
(42, 'wap站', 1),
(24, 'wap站', 3),
(48, 'pc站', 7),
(49, 'pc站', 5),
(47, 'pc站', 5),
(6, 'pc站', 1),
(29, 'wap站', 1);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_ad_custom`
--
CREATE TABLE `ecs_ad_custom` (
`ad_id` mediumint UNSIGNED NOT NULL,
`ad_type` tinyint UNSIGNED NOT NULL DEFAULT '1',
`ad_name` varchar(60) DEFAULT NULL,
`add_time` int UNSIGNED NOT NULL DEFAULT '0',
`content` mediumtext,
`url` varchar(255) DEFAULT NULL,
`ad_status` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_ad_position`
--
CREATE TABLE `ecs_ad_position` (
`position_id` tinyint UNSIGNED NOT NULL COMMENT '自增ID',
`position_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '廣告位名稱',
`ad_width` smallint UNSIGNED NOT NULL DEFAULT '0' COMMENT '寬度',
`ad_height` smallint UNSIGNED NOT NULL DEFAULT '0' COMMENT '高度',
`position_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '廣告位描述'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_ad_position`
--
INSERT INTO `ecs_ad_position` (`position_id`, `position_name`, `ad_width`, `ad_height`, `position_desc`) VALUES
(1, '首頁Banner', 750, 300, '');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_affiliate_log`
--
CREATE TABLE `ecs_affiliate_log` (
`log_id` mediumint NOT NULL,
`order_id` mediumint NOT NULL,
`time` int NOT NULL,
`user_id` mediumint NOT NULL,
`user_name` varchar(60) DEFAULT NULL,
`money` decimal(10,2) NOT NULL DEFAULT '0.00',
`point` int NOT NULL DEFAULT '0',
`separate_type` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_agency`
--
CREATE TABLE `ecs_agency` (
`agency_id` smallint UNSIGNED NOT NULL,
`agency_name` varchar(255) NOT NULL,
`agency_desc` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_area_region`
--
CREATE TABLE `ecs_area_region` (
`shipping_area_id` smallint UNSIGNED NOT NULL DEFAULT '0',
`region_id` smallint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_area_region`
--
INSERT INTO `ecs_area_region` (`shipping_area_id`, `region_id`) VALUES
(1, 1),
(2, 1),
(4, 1),
(5, 1),
(7, 3199),
(8, 3),
(8, 4),
(8, 6),
(8, 7),
(8, 8),
(8, 10),
(8, 11),
(8, 13),
(8, 14),
(8, 16),
(8, 17),
(8, 22),
(8, 23),
(8, 24),
(8, 25),
(8, 26),
(8, 27),
(8, 30),
(8, 31),
(8, 32),
(8, 52);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_article`
--
CREATE TABLE `ecs_article` (
`article_id` mediumint UNSIGNED NOT NULL,
`cat_id` smallint 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 UNSIGNED NOT NULL DEFAULT '2',
`is_open` tinyint UNSIGNED NOT NULL DEFAULT '1',
`add_time` int UNSIGNED NOT NULL DEFAULT '0',
`file_url` varchar(255) NOT NULL DEFAULT '',
`open_type` tinyint UNSIGNED NOT NULL DEFAULT '0',
`link` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) DEFAULT NULL,
`pic` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `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`, `pic`) VALUES
(1, 2, '免責條款', '', '', '', '', 0, 1, 1291604914, '', 0, '', '', ''),
(2, 2, '隱私保護', '', '', '', '', 0, 1, 1291604914, '', 0, '', '', ''),
(4, 2, '聯繫我們', '', '', '', '', 0, 1, 1291604914, '', 0, '', '', ''),
(5, 2, '公司簡介', '', '', '', '', 0, 1, 1291604914, '', 0, '', '', ''),
(6, -1, '用户協議', '用户協議用户協議用户協議用户協議用户協議<br />', '', '', '', 0, 1, 1291604914, '', 0, 'http://', '', ''),
(9, 5, '售後流程', '', '', '', '', 0, 1, 1242576700, '', 0, '', '', ''),
(10, 5, '購物流程', '<p><img height=\"4587\" width=\"813\" alt=\"\" src=\"/ec273cn/utf/360buy2013/images/upload/Image/11111.jpg\" /></p>', '', '', '', 0, 1, 1242576717, '', 0, '', '', ''),
(11, 5, '訂購方式', '<p>1、增加用户體驗、提高工作效率，高效率就是高收益</p>\r\n<p>2、後台操作時經常迷失在點了哪個分類菜單，現在你不用怕了，選哪個就標註哪個，用了68shop模板你還用愁嗎？</p>\r\n<p><br />\r\n&nbsp;</p>', '', '', '', 0, 1, 1242576727, '', 0, '', '', ''),
(15, 7, '貨到付款區域', '', '', '', '', 0, 1, 1242577023, '', 0, '', '', ''),
(16, 7, '配送支付查詢 ', '', '', '', '', 0, 1, 1242577032, '', 0, '', '', ''),
(17, 7, '支付方式説明', '', '', '', '', 0, 1, 1242577041, '', 0, '', '', ''),
(20, 10, '訂購流程', '', '', '', '', 0, 1, 1242577199, '', 0, '', '', ''),
(21, 8, '退換貨原則', '', '', '', '服務', 0, 1, 1242577293, '', 0, '', '', ''),
(22, 8, '售後服務保證 ', '', '', '', '售後', 0, 1, 1242577308, '', 0, '', '', ''),
(26, 9, '投訴與建議 ', '', '', '', '', 0, 1, 1242577459, '', 0, '', '', ''),
(42, 8, '換貨流程', '', '', '', '', 0, 1, 1292315950, '', 0, '', '', ''),
(46, 10, '註冊新客戶', '<img src=\"/images/upload/image/20221213/20221213143058_25440.jpg\" alt=\"\" />', '', '', '', 0, 1, 1292316080, '', 0, 'http://', '', ''),
(68, 10, '聯繫客服', '', '', '', '', 0, 1, 1365745238, '', 0, '', '', ''),
(73, 8, '退款説明', '', '', '', '', 0, 1, 1365745287, '', 0, '', '', ''),
(135, 16, '生鮮電商成長要跨過的那些坑', '一家生鮮電商的成熟發展要經過多少道“坑”？成本效率提升路徑又在哪裏？\r\n<p>\r\n 　　本來生活聯合創始人、副總裁戴山輝在《商業觀察家》主辦的2016中國新零售峯會上，詳解市場脈絡，滿滿乾貨分享市場。\r\n</p>\r\n<p>\r\n 　　戴山輝的核心觀點有三點值得關注：\r\n</p>\r\n<p>\r\n 　　1、生鮮零售的發展在經歷2012年以前以線下店為主的傳統零售階段，2012-2016年間的生鮮零售的變革期後，將在2016年之後步入線上線下融合的新階段。\r\n</p>\r\n<p>\r\n 　　2、萬億的生鮮市場蛋糕的攫取，取決於以什麼渠道方式去分切。對於本地化屬性更強的生鮮領域，必定會是線上線下結合的方式來解決大流通問題。純電商模式有天然的五大方面的瓶頸。\r\n</p>\r\n<p>\r\n 　　3、就生鮮領域而言，新零售主要有兩點：“到店的”要把線下體驗做好，“到家的”要把線上的配送服務做好。傳統零售企業、電商企業以及雙線併發的新進力量都在圍繞社區做新嘗試，線下業態的升級必定會成為下一個風口。\r\n</p>', '', '', '', 0, 1, 1487353252, '', 0, 'http://', '本來生活聯合創始人、副總裁戴山輝在《商業觀察家》主辦的2016中國新零售峯會上，詳解市場脈絡，滿滿乾貨分享市場。', 'data/article/1491358111728544003.jpg'),
(136, 16, '消費體驗難提高，細數生鮮電商三大槽點', '生於“高大上”的互聯網背景中，和所有的O2O平台一樣，生鮮電商帶着改變行業現狀的使命而來，卻始終難以逃脱各種行業亂象。像網約車和外賣平台一樣，生鮮電商也有着難以道盡槽點。\r\n<p>\r\n 　　目前國內包括生鮮電商在內的農產品電商接近4000家，其中僅有1%盈利、7%鉅額虧損、88%略虧、4%持平，總體上95%的都在賠。根據市場調研機構尼爾森的報告，中國生鮮電子商務市場將在未來三年內呈現爆發式增長。2018年有望超過1500億，年均複合增長率達到50%。到2016年底，生鮮食品在我國的電商滲透率不到1%，相比服裝和3C數碼產品20%的電商滲透率，生鮮的提升空間還非常的大。\r\n</p>\r\n<p>\r\n 　　就在新年的第一個月，每日優鮮以1億美元融資打響第一槍，騰訊、聯想等巨頭也紛紛入局。然而在這個爆發前的關鍵節點，仍然沒有人敢説自己探索除了生鮮電商的正確模式。除了各家極力完善的後端供應鏈，消費者也面臨很多頭疼的問題，在各大生鮮電商之間遊離不定，難以找到一個擁有接近完美體驗的平台。\r\n</p>', '', '', '', 0, 1, 1487353284, '', 0, 'http://', '生於“高大上”的互聯網背景中，和所有的O2O平台一樣，生鮮電商帶着改變行業現狀的使命而來，卻始終難以逃脱各種行業亂象。像網約車和外賣平台一樣，生鮮電商也有着難以道盡槽點。', 'data/article/1491357993483349294.jpg'),
(137, 16, '電商年貨盤點網購生鮮增幅猛', '春節假期結束了，許多人感嘆“每逢佳節胖三斤”，而各電商平台的大數據也印證了這一點。京東、阿里等大平台的年貨網購統計顯示，吃仍是春節消費的主旋律，其中生鮮類產品異軍突起。', '', '', '', 0, 1, 1487353314, '', 0, 'http://', '春節假期結束了，許多人感嘆“每逢佳節胖三斤”，而各電商平台的大數據也印證了這一點。京東、阿里等大平台的年貨網購統計顯示，吃仍是春節消費的主旋律，其中生鮮類產品異軍突起。', 'data/article/1491357803993410045.jpg'),
(138, 16, '生鮮電商的九大邏輯', '<p>\r\n 開篇之際，先確定下本文所探討的核心：生鮮電商。讀者不能拿本文所講的邏輯去套線下生鮮實體零售店，或者線下的經銷商，也不要去套以生產為主的產地商。\r\n</p>\r\n<p>\r\n 一個新的商業模式，表面沒啥，但是其背後卻是由一道一道的邏輯框定，每一道邏輯都有可能決定項目生死，所以透過表象看到本質很重要，也許沉下去看到的還是迷霧，只能多研究，多悟，儘量接近真實，這樣可以避免走彎路，降低損失。\r\n</p>\r\n<p>\r\n 易果號稱是中國第一家生鮮電商，2005年在上海成立，在12年生鮮電商爆發之前，默默耕耘了好多年，最近融資C+輪，是生鮮電商這個賽道的領跑者。\r\n</p>\r\n<p>\r\n 2012年是生鮮電商的爆發年，那一年有5家電商公司涉足生鮮領域，本來生活、順豐優選、亞馬遜、京東生鮮還有淘寶生態農業頻道。\r\n</p>\r\n<p>\r\n 然後就是2016年，生鮮電商集體進入寒冬期，很多項目業務增長不明顯或者滑坡，甚至傳出不少倒閉的消息。\r\n</p>\r\n<p>\r\n 行業內基本形成了一個普遍看法：生鮮電商太TM難做了。\r\n</p>\r\n<p>\r\n 生鮮電商為何這麼難做，背後肯定有一些不易察覺的原因，筆者也算是從業者，研究和實操都有過一些經歷，就試圖理一理裏面的邏輯。每一個邏輯都是環環相扣，一層套一層。\r\n</p>\r\n<h2>\r\n 邏輯1：\r\n</h2>\r\n<blockquote>\r\n <p>\r\n 生鮮是非見面式交易，對體驗的要求比線下高，對供應鏈和配送服務是一個巨大考驗。\r\n </p>\r\n</blockquote>\r\n<p>\r\n 生鮮電商的非見面式交易，這個場景帶來體驗方式和購買方式的巨大變化，將傳統線下生鮮產品簡單搬上線，那是絕不可能成功的，圖片P的再漂亮，文案寫的再感人也沒用，反而提高了預期，容易起反作用。\r\n</p>\r\n<p>\r\n 打個比方，顧客在水果店或者超市裏親自挑選了5斤橙子買了回去，有售後嗎？一般是不會的；但是如果把相同品種的5斤橙子通過配送的方式送到家裏去，顧客這個時候的體驗就跟在實體店完全不一樣了。退貨索賠事件居高不下。\r\n</p>\r\n<p>\r\n 要做到滿意度高，對供應鏈要求和配送要求非常高，不是説做不到，而是做到的成本很高，線下的生鮮市場，多年的充分競爭，基本可以説是在現有條件下達到了成本最優，相比較電商的運營成本應該是高於線下的。\r\n</p>\r\n<p>\r\n 所以，這個因素決定了生鮮電商需要非常專業的標準化程度較高的供應鏈以及配送的配套服務商，傳統的供應鏈和運輸主要是為線下生鮮市場服務的，還沒能完全轉變為對口生鮮電商的專業服務。特別是是產地生產方式的轉變，更加艱難。\r\n</p>\r\n<h2>\r\n 邏輯2：\r\n</h2>\r\n<blockquote>\r\n <p>\r\n 生鮮電商，是服務於消費升級的增量需求顧客羣體，而不是傳統型的存量需求消費羣體\r\n </p>\r\n</blockquote>\r\n<p>\r\n 基於第一個商業邏輯，決定了生鮮電商的需求方不是平日裏主要在菜市場和超市消費的顧客羣體，也就是説菜市場和超市不應該成為生鮮電商的競爭對手。\r\n</p>\r\n<p>\r\n 為什麼這麼説，一方面體驗沒有線下好，二方面沒有線下的成本優勢。看看那些開始喊着口號要顛覆菜市場的生鮮電商，現在還有幾個活着的？在社區邊上開一個實體生鮮店，做O2O的這種模式，都沒看到哪個做成功了，何況是B2C模式呢。\r\n</p>\r\n<p>\r\n 生鮮電商，應該是服務於消費升級的顧客羣體，這些顧客在線下環境裏，買不到他們希望買到的生鮮產品，滿足不了他們的消費新需求。\r\n</p>\r\n<p>\r\n 線下生鮮市場的優點是種類繁多，價格便宜，購買方便；但是它最大的毛病就是生鮮產品的質量不可靠，不可信，顧客想買點優質優價的產品，不太容易。有這個需求的顧客儘管在人羣中佔比不大，但是總量不小，只是比較分散，散佈在各個城市裏的角角落落，很不集中。線下生鮮業態不容易滿足。\r\n</p>\r\n<p>\r\n 所以，生鮮電商目前主要對接的需求，應該是消費升級的新需求，而不是主要在菜市場超市消費的過平常日子的老百姓。產業鏈優化成本下降後，再逐步擴張到普通羣體。\r\n</p>\r\n<h2>\r\n 邏輯3：\r\n</h2>\r\n<blockquote>\r\n <p>\r\n 生鮮電商主要就是做好通路，一頭連產地，一頭連顧客，是端到端的通路\r\n </p>\r\n</blockquote>\r\n<p>\r\n 前一個邏輯講清楚了，生鮮電商是應對消費升級需求的商業模式，並且要對口的供應鏈，所以找批發市場肯定是不對路的，批發市場的產品主要是對接城市裏的大小線下零售市場的。\r\n</p>\r\n<p>\r\n 有一些做水果電商的，通過在批發市場拿貨，配送給顧客。就是做了個搬運工的事，顧客對這種事情是有感知的，不透明的供應鏈，在顧客那頭基本沒有溢價能力。\r\n</p>\r\n<p>\r\n 所以，很多鮮字輩的水果電商，熱熱鬧鬧一陣子後，就逐漸沒有聲音了。\r\n</p>\r\n<p>\r\n 生鮮電商作為一個新的商業模式，需要自己推動供貨商轉型，專門為電商生產生鮮產品，最主要的是，需要冒出來一批專門為消費升級顧客生產生鮮產品的生產商。\r\n</p>\r\n<p>\r\n 這項工作，要從產地做起來，生鮮電商需要通過自己的力量在產地和顧客之間把這個橋樑搭建起來，形成端到端的供應流通體系，然後形成一整套的供應鏈體系。\r\n</p>\r\n<h2>\r\n 邏輯4：\r\n</h2>\r\n<blockquote>\r\n <p>\r\n 生鮮電商首要當做平台為主，一開始就要以做入口為目標，垂直做得再好，也會被將來的平台擠掉。\r\n </p>\r\n</blockquote>\r\n<p>\r\n 創立一個生鮮電商項目，立即會面臨一個比較嚴肅的選擇，到底是做平台還是做垂直。消費者在日常生活中對生鮮農產品的需求是種類繁多的，蔬菜、水果、畜禽肉、蛋、水產、海鮮、糧油、乾貨，隨便上一個超市去看看就知道了。\r\n</p>\r\n<p>\r\n 目前生鮮電商還是屬於早期，是有出平台的大機會。要保持更多的供給，然後才會撬動更多的需求。早期可能會由於資源的問題，暫時選擇做垂直，但是一旦條件具備就應該向平台擴張。不然，最後垂直一定會被平台擠死的。就如噹噹做圖書那會兒，沒有擴到全品類，結果錯失良機。\r\n</p>\r\n<p>\r\n 就拿線下的百果園和北京華聯連鎖超市來對比，百果園屬於水果垂直行業，北京華聯屬於平台。在百果園買水果，只要買到幾次品質不好，那麼下次就有可能不去了；但是在家旁邊的華聯買到品質不好的水果，下次還是會去買，因為它那邊產品更加豐富，下次還可能會買到品質稍好的水果，價格也沒百果園貴。\r\n</p>\r\n<p>\r\n 平台是入口型的商業模式，垂直不可能成為入口，這一點在線上就表現的更加明顯。就如淘寶和京東，一個是開放平台一個自營平台，都成了某一類顧客的入口型平台。\r\n</p>\r\n<p>\r\n 生鮮電商行業到現在為止，還沒有出現入口級的平台，這個入口未來到底屬於誰，現在還很難説清楚，不過易果和天天果園的戰略目標應該是入口沒錯，就是不知道他們的銀子能不能撐到適配電商體系的生鮮供應鏈的改造成功之日。\r\n</p>\r\n<h2>\r\n 邏輯5：\r\n</h2>\r\n<blockquote>\r\n <p>\r\n 生鮮電商平台，品類越多越好，太少，就不是入口級平台了。\r\n </p>\r\n</blockquote>\r\n<p>\r\n 確定了要做平台，就要捨命狂奔擴充品類，產品越豐富越好，説淘寶是網購第一入口不為過吧。只要買東西，不管最後在哪裏買，總是會想起來在淘寶查查看，查一下的時候也許就把東西買了。\r\n</p>\r\n<p>\r\n 淘寶成為這個入口，就是因為產品極其豐富，價格透明，選擇程度高。淘寶裏的生鮮農產品品類也很多，可惜就是品控做的不行，買到低質產品的概率比較大，所以淘寶生鮮這塊離一個生鮮入口也還遠，這個任務阿里是打算交給易果來完成了。\r\n</p>\r\n<p>\r\n 每日優鮮據説SKU不多，才幾百個，這樣的確可以降低管理難度，成本可以少很多，可是時間一長，顧客看來看去就那幾樣，也買不到啥誠心的東西，要想成為入口還遠遠不夠。\r\n</p>\r\n<h2>\r\n 邏輯6：\r\n</h2>\r\n<blockquote>\r\n <p>\r\n 做生鮮電商平台，現在首要當做開放平台，而非自營，儘量別介入控貨\r\n </p>\r\n</blockquote>\r\n<p>\r\n 做平台，品類要多，但是品類多了，運營成本劇增。這個矛盾怎麼處理呢？\r\n</p>\r\n<p>\r\n 其實，只要是做自營，速度就不可能快的起來。生鮮是嚴重非標品類，在目前這個生產水平下，要做到顧客要求的標準化程度，用自營的方式基本辦不到。生鮮電商目前最多也就介入到產後標準化，對於產前的標準化無能為力。\r\n</p>\r\n<p>\r\n 非標的產品，和自營電商的標準化管理模式之間是一對不可調和的矛盾，誰做誰知道。\r\n</p>\r\n<p>\r\n 這方面就要學習淘寶的模式，用入駐的方式將非標的問題分解到千千萬萬的商家身上解決擴品類的問題。然後，生鮮平台的主要任務就是要統一做好品控和引流。\r\n</p>\r\n<p>\r\n 拼好貨和拼多多的案例，就説明瞭這個問題。現在拼多多的SKU增長非常迅猛，平台跡象明顯，入口現象也產生了，生鮮引流帶動其他品類銷售增長效果還是不錯吧。它在生鮮的問題，也還是一個品控問題沒法妥善解決。\r\n</p>\r\n<h2>\r\n 邏輯7：\r\n</h2>\r\n<blockquote>\r\n <p>\r\n 能與入口級平台匹配的基本需求，就質量、服務和價格這三條。\r\n </p>\r\n</blockquote>\r\n<p>\r\n 入口級平台的基本供給，基本也就質量、服務和價格這三個維度了。\r\n</p>\r\n<p>\r\n 調性重要麼，重要，但是對平台沒啥用，情懷呢，也重要，還有故事，都重要。它們更重要的作用是在營銷上，引流沒問題，但是如果沒有質量、服務和價格這三個基本因素做基本的支撐，流量來了也是託不住，存不下，流過來還是會流走的。\r\n</p>\r\n<p>\r\n 觀察現有的電商平台，淘寶佔據了價格這個入口，京東佔據了服務這個入口，質量入口目前是各家必爭之地。生鮮平台也是平台，它的發展也可以參考這幾個脈絡去考察。\r\n</p>\r\n<p>\r\n 平台的流量重要，但是流量的來源更重要，流量的成本更重要，還有流量的轉化也是一個需要重點考量的要素。參考第二個邏輯，即會明白生鮮電商轉化之難，一味的低價其實招徠的不是目標客户，也不是忠誠客户，不可長久。生鮮電商的價值鏈，在於產品質量和平台的服務，而限制因素在價格。\r\n</p>\r\n<p>\r\n 這幾個維度，各有各的特殊性，不可一概而論。並且互相之間關聯密切，有因有果，要非常精妙處理這幾者之間的關係，平台的走向才可清楚。\r\n</p>\r\n<h2>\r\n 邏輯8：\r\n</h2>\r\n<blockquote>\r\n <p>\r\n 要使消費者自然改變消費習慣，質量、服務和價格三個維度的總價值提升要30%以上。\r\n </p>\r\n</blockquote>\r\n<p>\r\n 在生鮮電商出現之前，消費者只有一個生鮮購物的場景，就是線下。現在要想把目標客户的消費場景和習慣從線下轉變到線上來，按照一般的理論，這個新的模式必須要有30%以上的價值提升，甚至更高，否則目標客户不會輕易轉變。\r\n</p>\r\n<p>\r\n 30%的價值提升代表什麼呢\r\n</p>\r\n<p>\r\n 如果在價格上要提升30%的價值，那麼價格就要比線下同類產品便宜30%，明顯高成本的生鮮電商是很難做到這點的。但是現在拼多多和淘寶上出現很多價格非常低的生鮮產品，其原因何在？無非是在產品質量上打了折扣，或者是由於一些資本強推的補貼造成的假象。\r\n</p>\r\n<p>\r\n 如果在服務上要提升30%的價值，那麼就需要做到使生鮮產品安全無憂及時無誤妥善配送到家，節省顧客很多采購的時間，讓顧客基本可以不用再跑菜場和超市了。要做到這樣的服務，是需要成本的。中國消費者大部分是不願意為網購單獨掏運費的，最近以配送服務見長的京東也提高了免費包郵的門檻，最終運費其實還是由整體產品溢價承擔的。\r\n</p>\r\n<p>\r\n 如果在質量上要提升30%的價值，生鮮產品就要有線下產品沒有或者明顯不足的特性。比如在安全上更有保證，更好的品質，更豐富的營養。\r\n</p>\r\n<p>\r\n 三個維度，價格直降不現實，服務沒有人買單，質量才是真正的壓艙石。\r\n</p>', '', '', '', 0, 1, 1487353383, '', 0, 'http://', '一個新的商業模式，表面沒啥，但是其背後卻是由一道一道的邏輯框定，每一道邏輯都有可能決定項目生死，所以透過表象看到本質很重要，也許沉下去看到的還是迷霧，只能多研究，多悟，儘量接近真實，這樣可以避免走彎路，降低損失。', 'data/article/1491357691006189330.jpg'),
(139, 16, '美國藝術家用蔬菜打造微型景觀', '&nbsp;&nbsp;&nbsp; 在這些照片中，麥考密克使用辣椒、胡蘿蔔以及櫻桃等蔬果創造日常生活場景，裏面的人物模型只有2.5釐米高，他們似乎在如山的美食景觀中緊張忙碌着。在一個場景中，麥考密克使用蘆筍、芹菜等蔬菜代替叢林，供探險家們探索。在另一個場景中，麥考密克將五顏六色的辣椒變成巨大岩石，微小的登山者們利用繩索正在攀登。\r\n<p>\r\n 　　作為曾獲獎的旅行和藝術攝影師，麥考密克從2011年就開始創造這些微觀作品。她稱：“多年來，我一直對微觀藝術痴迷不已，希望將它們融入到自己的藝術中。2014年我的腳踝摔斷後身體發胖，參加減肥班之際，我開始創作微觀作品。在一個月中，我就創作了30個場景，它們實在令人着迷。”\r\n</p>\r\n<p>\r\n 　　儘管麥考密克從兒時起就收集微型人物模型，她估計自己已經為此花費了數千美元。\r\n</p>', '', '', '', 0, 1, 1491842681, '', 0, 'http://', '美國洛杉磯63歲藝術家勞麗·麥考密克（Laurie McCormick）將水果、蔬菜變成藝術品，以它們為背景為各種微型人物模型建造日常景觀，惟妙惟肖。', 'data/article/1491842681577448444.jpg'),
(140, 16, '草莓成熟季帶旺農家樂', '隨着農家樂越來越受歡迎，相比採摘難度較大的砂糖橘、沙田柚，較易採摘的草莓成為市民到近郊開展農家樂的熱門選擇。這一市場需求也讓梧州城郊及周邊縣（市）的種植户熱衷於將鮮嫩多汁、香甜可口的草莓，作為農家樂的主打項目。', '', '', '', 0, 1, 1491842772, '', 0, 'http://', '隨着農家樂越來越受歡迎，相比採摘難度較大的砂糖橘、沙田柚，較易採摘的草莓成為市民到近郊開展農家樂的熱門選擇。這一市場需求也讓梧州城郊及周邊縣（市）的種植户熱衷於將鮮嫩多汁、香甜可口的草莓，作為農家樂的主打項目。', 'data/article/1491842772417564921.jpg'),
(141, 16, '廣西融安金桔農超對接助農增收', '<p>\r\n 當日，廣西柳州市融安縣在浙江杭州市舉行融安金桔推介會，現場推介和展銷優質金桔。廣西融安縣政府部門組織推介人員通過走進沿海發達城市舉辦推介會，與商超建立合作關係，實現農超無縫對接，拓展農產品銷售渠道，促進農民增產增收。廣西融安縣金桔種植面積目前達11.5萬畝，年產金桔9.5萬噸，產值近5億元。\r\n</p>\r\n<p>\r\n 當日，廣西柳州市融安縣在浙江杭州市舉行融安金桔推介會，現場推介和展銷優質金桔。廣西融安縣政府部門組織推介人員通過走進沿海發達城市舉辦推介會，與商超建立合作關係，實現農超無縫對接，拓展農產品銷售渠道，促進農民增產增收。廣西融安縣金桔種植面積目前達11.5萬畝，年產金桔9.5萬噸，產值近5億元。\r\n</p>', '', '', '', 0, 1, 1491842847, '', 0, 'http://', '當日，廣西柳州市融安縣在浙江杭州市舉行融安金桔推介會，現場推介和展銷優質金桔。廣西融安縣政府部門組織推介人員通過走進沿海發達城市舉辦推介會，與商超建立合作關係，實現農超無縫對接，拓展農產品銷售渠道，促進農民增產增收。廣西融安縣金桔種植面積目前達11.5萬畝，年產金桔9.5萬噸，產值近5億元。', 'data/article/1491842847840276283.jpg'),
(142, 16, '重慶梁平曲水鎮：柑橘豐收果農樂', '眼下，柑橘進入銷售旺季，曲水鎮的柑橘因品質好，早早引得客商及遊客來訂購採摘。預計全鎮果農栽植的2500畝椪柑、紅桔等產量將達到325萬公斤，產值約1600餘萬元，讓農民鼓起“錢袋子”。眼下，柑橘進入銷售旺季，曲水鎮的柑橘因品質好，早早引得客商及遊客來訂購採摘。預計全鎮果農栽植的2500畝椪柑、紅桔等產量將達到325萬公斤，產值約1600餘萬元，讓農民鼓起“錢袋子”。眼下，柑橘進入銷售旺季，曲水鎮的柑橘因品質好，早早引得客商及遊客來訂購採摘。預計全鎮果農栽植的2500畝椪柑、紅桔等產量將達到325萬公斤，產值約1600餘萬元，讓農民鼓起“錢袋子”。', '', '', '', 0, 1, 1491842903, '', 0, 'http://', '眼下，柑橘進入銷售旺季，曲水鎮的柑橘因品質好，早早引得客商及遊客來訂購採摘。預計全鎮果農栽植的2500畝椪柑、紅桔等產量將達到325萬公斤，產值約1600餘萬元，讓農民鼓起“錢袋子”。', 'data/article/1491842903754131447.jpg'),
(143, 16, '廣西環江毛南族自治縣砂糖橘喜獲豐收', '　雙樂屯是集苗族文化集中展示、民族團結示範點、民族風情旅遊於一體的移民新村。近年來，該屯26户羣眾積極落實富民惠民政策，大力種植砂糖橘近300畝，如今掛果的有80多畝。“我們村今年第一批採收的砂糖橘有近8萬公斤，收入約50多萬元，最後一批還有12萬公斤左右，將在春節前後上市，收入不錯。”該屯果農劉秀蘭大姐喜笑顏開。　雙樂屯是集苗族文化集中展示、民族團結示範點、民族風情旅遊於一體的移民新村。近年來，該屯26户羣眾積極落實富民惠民政策，大力種植砂糖橘近300畝，如今掛果的有80多畝。“我們村今年第一批採收的砂糖橘有近8萬公斤，收入約50多萬元，最後一批還有12萬公斤左右，將在春節前後上市，收入不錯。”該屯果農劉秀蘭大姐喜笑顏開。', '', '', '', 0, 1, 1491842962, 'data/article/1494957561194347178.jpg', 2, 'http://', '　雙樂屯是集苗族文化集中展示、民族團結示範點、民族風情旅遊於一體的移民新村。近年來，該屯26户羣眾積極落實富民惠民政策，大力種植砂糖橘近300畝，如今掛果的有80多畝。“我們村今年第一批採收的砂糖橘有近8萬公斤，收入約50多萬元，最後一批還有12萬公斤左右，將在春節前後上市，收入不錯。”該屯果農劉秀蘭大姐喜笑顏開。', 'data/article/1491842962102738778.jpg');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_article_cat`
--
CREATE TABLE `ecs_article_cat` (
`cat_id` smallint NOT NULL,
`cat_name` varchar(255) NOT NULL DEFAULT '',
`cat_type` tinyint UNSIGNED NOT NULL DEFAULT '1',
`keywords` varchar(255) NOT NULL DEFAULT '',
`cat_desc` varchar(255) NOT NULL DEFAULT '',
`sort_order` tinyint UNSIGNED NOT NULL DEFAULT '50',
`show_in_nav` tinyint UNSIGNED NOT NULL DEFAULT '0',
`parent_id` smallint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `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, '新手上路 ', 5, '', '', 50, 0, 3),
(7, '配送方式 ', 5, '', '配送與支付 ', 50, 1, 3),
(8, '售後服務', 5, '', '', 50, 0, 3),
(9, '關於我們 ', 5, '', '聯繫我們 ', 50, 0, 3),
(10, '購物指南', 5, '', '', 50, 0, 3),
(16, '生鮮資訊', 1, '農產品供求信息', '', 1, 0, 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_attribute`
--
CREATE TABLE `ecs_attribute` (
`attr_id` smallint UNSIGNED NOT NULL,
`cat_id` smallint UNSIGNED NOT NULL DEFAULT '0',
`attr_name` varchar(60) NOT NULL DEFAULT '',
`attr_input_type` tinyint UNSIGNED NOT NULL DEFAULT '1',
`attr_type` tinyint UNSIGNED NOT NULL DEFAULT '1',
`attr_values` text NOT NULL,
`attr_index` tinyint UNSIGNED NOT NULL DEFAULT '0',
`sort_order` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_linked` tinyint UNSIGNED NOT NULL DEFAULT '0',
`attr_group` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `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
(1, 1, '容量', 1, 1, '1.8L\r\n5L', 0, 0, 0, 0),
(2, 1, '產地', 1, 0, '泰國\r\n海南\r\n四川\r\n廣西\r\n河北\r\n台灣\r\n埃及\r\n新西蘭\r\n智利\r\n澳大利亞\r\n甘肅', 0, 0, 1, 0),
(3, 1, '品種', 1, 0, '熱帶水果\r\n柑桔\r\n提子葡萄\r\n蘋果\r\n進口榴蓮\r\n柚子\r\n桃\r\n桃杏李\r\n梨\r\n橙', 0, 0, 1, 0),
(4, 1, '來源', 1, 0, '國產\r\n進口', 0, 0, 1, 0),
(5, 1, '等級', 1, 1, '一級\r\n二級\r\n三級', 0, 0, 0, 0),
(6, 1, '部位', 0, 1, '', 0, 0, 0, 0),
(7, 1, '規格', 0, 1, '', 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_auction_log`
--
CREATE TABLE `ecs_auction_log` (
`log_id` mediumint UNSIGNED NOT NULL,
`act_id` mediumint UNSIGNED NOT NULL,
`bid_user` mediumint UNSIGNED NOT NULL,
`bid_price` decimal(10,2) UNSIGNED NOT NULL,
`bid_time` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_auto_manage`
--
CREATE TABLE `ecs_auto_manage` (
`item_id` mediumint NOT NULL,
`type` varchar(10) NOT NULL,
`starttime` int NOT NULL,
`endtime` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_auto_manage`
--
INSERT INTO `ecs_auto_manage` (`item_id`, `type`, `starttime`, `endtime`) VALUES
(1, 'goods', 1495008000, 0),
(2, 'goods', 1495008000, 0),
(3, 'goods', 1495008000, 0),
(4, 'goods', 1495008000, 0),
(5, 'goods', 1495008000, 0),
(6, 'goods', 1495008000, 0),
(7, 'goods', 1495008000, 0),
(8, 'goods', 1495008000, 0),
(9, 'goods', 1495008000, 0),
(10, 'goods', 1495008000, 0),
(11, 'goods', 1495008000, 0),
(12, 'goods', 1495008000, 0),
(13, 'goods', 1495008000, 0),
(14, 'goods', 1495008000, 0),
(15, 'goods', 1495008000, 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_back_action`
--
CREATE TABLE `ecs_back_action` (
`action_id` mediumint UNSIGNED NOT NULL,
`back_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`action_user` varchar(30) NOT NULL DEFAULT '',
`status_back` tinyint UNSIGNED NOT NULL DEFAULT '0',
`status_refund` tinyint UNSIGNED NOT NULL DEFAULT '0',
`action_note` varchar(255) NOT NULL DEFAULT '',
`log_time` int UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_back_action`
--
INSERT INTO `ecs_back_action` (`action_id`, `back_id`, `action_user`, `status_back`, `status_refund`, `action_note`, `log_time`) VALUES
(1, 3, 'shenlong', 5, 1, '退款成功', 1494973454),
(2, 3, 'shenlong', 5, 1, '', 1494973464),
(3, 3, 'shenlong', 3, 1, '', 1494973513),
(4, 4, 'admin', 5, 0, '', 1499210883),
(5, 4, 'admin', 4, 1, '1', 1499210919),
(6, 4, 'admin', 3, 1, '', 1499210929),
(7, 5, 'admin', 5, 0, '', 1499211045),
(8, 5, 'admin', 4, 1, '111', 1499211057),
(9, 5, 'admin', 3, 1, '', 1499211061),
(10, 6, 'admin', 5, 0, '', 1499211619),
(11, 6, 'admin', 4, 1, '1', 1499211628);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_back_goods`
--
CREATE TABLE `ecs_back_goods` (
`rec_id` mediumint UNSIGNED NOT NULL,
`back_id` mediumint UNSIGNED DEFAULT '0',
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`product_id` mediumint 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 UNSIGNED DEFAULT '0',
`send_number` smallint UNSIGNED DEFAULT '0',
`goods_attr` text,
`back_type` tinyint UNSIGNED NOT NULL DEFAULT '0',
`parent_id` int UNSIGNED NOT NULL,
`back_goods_price` decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
`back_goods_number` smallint UNSIGNED NOT NULL,
`status_back` tinyint(1) NOT NULL DEFAULT '0',
`status_refund` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_back_goods`
--
INSERT INTO `ecs_back_goods` (`rec_id`, `back_id`, `goods_id`, `product_id`, `product_sn`, `goods_name`, `brand_name`, `goods_sn`, `is_real`, `send_number`, `goods_attr`, `back_type`, `parent_id`, `back_goods_price`, `back_goods_number`, `status_back`, `status_refund`) VALUES
(4, 4, 18, 0, NULL, '江西臍橙', NULL, 'MDZ000018', 0, 0, '', 4, 0, '17.64', 1, 3, 1),
(5, 5, 18, 0, NULL, '江西臍橙', NULL, 'MDZ000018', 0, 0, '', 4, 0, '17.64', 1, 3, 1),
(6, 6, 19, 0, NULL, '福建蜜柚', NULL, 'MDZ000019', 0, 0, '', 4, 0, '10.73', 1, 4, 1);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_back_order`
--
CREATE TABLE `ecs_back_order` (
`back_id` mediumint UNSIGNED NOT NULL,
`delivery_sn` varchar(20) NOT NULL,
`order_sn` varchar(20) NOT NULL,
`order_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`invoice_no` varchar(50) DEFAULT NULL,
`add_time` int UNSIGNED DEFAULT '0',
`shipping_id` tinyint UNSIGNED DEFAULT '0',
`shipping_name` varchar(120) DEFAULT NULL,
`user_id` mediumint UNSIGNED DEFAULT '0',
`action_user` varchar(30) DEFAULT NULL,
`consignee` varchar(60) DEFAULT NULL,
`address` varchar(250) DEFAULT NULL,
`country` smallint UNSIGNED DEFAULT '0',
`province` smallint UNSIGNED DEFAULT '0',
`city` smallint UNSIGNED DEFAULT '0',
`district` smallint 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 UNSIGNED DEFAULT '0',
`suppliers_id` smallint DEFAULT '0',
`status` tinyint UNSIGNED NOT NULL DEFAULT '0',
`return_time` int UNSIGNED DEFAULT '0',
`agency_id` smallint UNSIGNED DEFAULT '0',
`refund_type` tinyint(1) NOT NULL DEFAULT '0',
`refund_desc` varchar(255) NOT NULL,
`refund_money_1` decimal(10,2) NOT NULL DEFAULT '0.00',
`refund_money_2` decimal(10,2) NOT NULL DEFAULT '0.00',
`back_reason` varchar(255) NOT NULL DEFAULT '',
`goods_id` int UNSIGNED NOT NULL,
`goods_name` varchar(255) NOT NULL DEFAULT '',
`status_back` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:審核通過,1:收到寄回產品,2:換回產品已寄出,3:完成退貨/返修,4:退款(無需退貨),5:審核中,6:申請被拒絕,7:管理員取消,8:用户自己取消',
`status_refund` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:未退款,1:已退款',
`imgs` text NOT NULL,
`back_pay` tinyint(1) NOT NULL DEFAULT '0',
`back_type` varchar(1) NOT NULL DEFAULT '0',
`supplier_id` int UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_back_order`
--
INSERT INTO `ecs_back_order` (`back_id`, `delivery_sn`, `order_sn`, `order_id`, `invoice_no`, `add_time`, `shipping_id`, `shipping_name`, `user_id`, `action_user`, `consignee`, `address`, `country`, `province`, `city`, `district`, `sign_building`, `email`, `zipcode`, `tel`, `mobile`, `best_time`, `postscript`, `how_oos`, `insure_fee`, `shipping_fee`, `update_time`, `suppliers_id`, `status`, `return_time`, `agency_id`, `refund_type`, `refund_desc`, `refund_money_1`, `refund_money_2`, `back_reason`, `goods_id`, `goods_name`, `status_back`, `status_refund`, `imgs`, `back_pay`, `back_type`, `supplier_id`) VALUES
(4, '', '2017070338759', 213, NULL, 1499210813, 0, NULL, 245, NULL, '測試', '測試測試測試測試', 1, 6, 79, 715, NULL, NULL, '', NULL, '13800138000', NULL, '哈哈哈', NULL, '0.00', '15.00', 0, 0, 0, 0, 0, 2, '', '17.64', '17.64', '不要了', 18, '江西臍橙', 3, 1, '/www/demo/shop/shop0691shengxian/images/upload/image/20170705/20170705072643_28550.jpg', 1, '4', 0),
(5, '', '2017070392755', 214, NULL, 1499211028, 0, NULL, 245, NULL, '測試', '測試測試測試測試', 1, 6, 79, 715, NULL, NULL, '', NULL, '13800138000', NULL, '', NULL, '0.00', '15.00', 0, 0, 0, 0, 0, 1, '', '17.64', '17.64', '', 18, '江西臍橙', 3, 1, '', 2, '4', 0),
(6, '', '2017070392755', 214, NULL, 1499211406, 0, NULL, 245, NULL, '測試', '測試測試測試測試', 1, 6, 79, 715, NULL, NULL, '', NULL, '13800138000', NULL, '', NULL, '0.00', '15.00', 0, 0, 0, 0, 0, 1, '', '10.73', '10.73', '', 19, '福建蜜柚', 4, 1, '', 1, '4', 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_back_replay`
--
CREATE TABLE `ecs_back_replay` (
`id` mediumint NOT NULL,
`back_id` mediumint NOT NULL DEFAULT '0',
`message` text NOT NULL,
`add_time` int NOT NULL DEFAULT '0',
`type` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_back_replay`
--
INSERT INTO `ecs_back_replay` (`id`, `back_id`, `message`, `add_time`, `type`) VALUES
(1, 3, '退款很快嘛', 1494973602, 1);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_bonus_type`
--
CREATE TABLE `ecs_bonus_type` (
`type_id` smallint UNSIGNED NOT NULL,
`type_name` varchar(60) NOT NULL DEFAULT '',
`type_money` decimal(10,2) NOT NULL DEFAULT '0.00',
`send_type` tinyint 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 NOT NULL DEFAULT '0',
`send_end_date` int NOT NULL DEFAULT '0',
`use_start_date` int NOT NULL DEFAULT '0',
`use_end_date` int NOT NULL DEFAULT '0',
`min_goods_amount` decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
`user_bonus_max` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_bonus_type`
--
INSERT INTO `ecs_bonus_type` (`type_id`, `type_name`, `type_money`, `send_type`, `min_amount`, `max_amount`, `send_start_date`, `send_end_date`, `use_start_date`, `use_end_date`, `min_goods_amount`, `user_bonus_max`) VALUES
(2, '新用户註冊紅包', '5.00', 5, '0.00', '0.00', 1499068800, 1501747200, 1498809600, 1944633600, '100.00', 0),
(3, '指定用户紅包', '20.00', 0, '0.00', '0.00', 1499068800, 1501747200, 1498809600, 1851235200, '200.00', 0),
(4, '產品紅包', '10.00', 1, '0.00', '0.00', 1498809600, 1911974400, 1499068800, 2101276800, '100.00', 0),
(5, '訂單紅包', '20.00', 2, '200.00', '0.00', 1498809600, 1911974400, 1499068800, 2070259200, '200.00', 0),
(6, '線下紅包', '20.00', 3, '0.00', '0.00', 1499068800, 1501747200, 1498809600, 2069827200, '200.00', 0),
(7, '10元線上優惠券', '10.00', 4, '0.00', '0.00', 1498809600, 1914307200, 1498896000, 2101276800, '100.00', 2),
(8, '20元線上優惠券', '20.00', 4, '0.00', '0.00', 1498809600, 1911974400, 1498896000, 1974873600, '200.00', 1),
(9, '50元線上優惠券', '50.00', 4, '0.00', '0.00', 1498809600, 1911974400, 1498896000, 2069740800, '500.00', 1),
(10, '100元線上優惠券', '100.00', 4, '0.00', '0.00', 1498809600, 1944460800, 1498809600, 2069827200, '1000.00', 1);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_booking_goods`
--
CREATE TABLE `ecs_booking_goods` (
`rec_id` mediumint UNSIGNED NOT NULL,
`user_id` mediumint 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 UNSIGNED NOT NULL DEFAULT '0',
`goods_desc` varchar(255) NOT NULL DEFAULT '',
`goods_number` smallint UNSIGNED NOT NULL DEFAULT '0',
`booking_time` int UNSIGNED NOT NULL DEFAULT '0',
`is_dispose` tinyint UNSIGNED NOT NULL DEFAULT '0',
`dispose_user` varchar(30) NOT NULL DEFAULT '',
`dispose_time` int UNSIGNED NOT NULL DEFAULT '0',
`dispose_note` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_brand`
--
CREATE TABLE `ecs_brand` (
`brand_id` smallint UNSIGNED NOT NULL,
`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 UNSIGNED NOT NULL DEFAULT '50',
`is_show` tinyint UNSIGNED NOT NULL DEFAULT '1',
`brand_banner` varchar(80) NOT NULL COMMENT '產品品牌banner'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_card`
--
CREATE TABLE `ecs_card` (
`card_id` tinyint UNSIGNED NOT NULL,
`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 ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_cart`
--
CREATE TABLE `ecs_cart` (
`rec_id` mediumint UNSIGNED NOT NULL,
`user_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`session_id` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_sn` varchar(60) NOT NULL DEFAULT '',
`product_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`group_id` varchar(255) NOT NULL,
`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 UNSIGNED NOT NULL DEFAULT '0',
`goods_attr` text NOT NULL,
`is_real` tinyint UNSIGNED NOT NULL DEFAULT '0',
`extension_code` varchar(30) NOT NULL DEFAULT '',
`parent_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`rec_type` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_gift` smallint UNSIGNED NOT NULL DEFAULT '0',
`is_shipping` tinyint UNSIGNED NOT NULL DEFAULT '0',
`can_handsel` tinyint UNSIGNED NOT NULL DEFAULT '0',
`goods_attr_id` varchar(255) NOT NULL DEFAULT '',
`fencheng` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_cart_combo`
--
CREATE TABLE `ecs_cart_combo` (
`rec_id` mediumint UNSIGNED NOT NULL,
`user_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`session_id` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_sn` varchar(60) NOT NULL DEFAULT '',
`product_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`group_id` varchar(255) NOT NULL,
`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 UNSIGNED NOT NULL DEFAULT '0',
`goods_attr` text NOT NULL,
`is_real` tinyint UNSIGNED NOT NULL DEFAULT '0',
`extension_code` varchar(30) NOT NULL DEFAULT '',
`parent_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`rec_type` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_gift` smallint UNSIGNED NOT NULL DEFAULT '0',
`is_shipping` tinyint UNSIGNED NOT NULL DEFAULT '0',
`can_handsel` tinyint UNSIGNED NOT NULL DEFAULT '0',
`goods_attr_id` varchar(255) NOT NULL DEFAULT '',
`fencheng` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_cart_combo`
--
INSERT INTO `ecs_cart_combo` (`rec_id`, `user_id`, `session_id`, `goods_id`, `goods_sn`, `product_id`, `group_id`, `goods_name`, `market_price`, `goods_price`, `goods_number`, `goods_attr`, `is_real`, `extension_code`, `parent_id`, `rec_type`, `is_gift`, `is_shipping`, `can_handsel`, `goods_attr_id`, `fencheng`) VALUES
(1, 0, '7eeb5ef498b357f3f5ac1f3409342a6f', 102, 'MDZ000102', 1, 'm_goods_0_102', '新鮮豬扒肉', '45.60', '30.00', 1, '部位:大腿肉 \n規格:500G \n', 1, '', 0, 0, 0, 0, 0, '3,5', '0');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_category`
--
CREATE TABLE `ecs_category` (
`cat_id` smallint UNSIGNED NOT NULL,
`cat_name` varchar(90) NOT NULL DEFAULT '',
`keywords` varchar(255) NOT NULL DEFAULT '',
`cat_desc` varchar(255) NOT NULL DEFAULT '',
`parent_id` smallint UNSIGNED NOT NULL DEFAULT '0',
`sort_order` tinyint 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 UNSIGNED NOT NULL DEFAULT '1',
`grade` tinyint NOT NULL DEFAULT '0',
`filter_attr` varchar(255) NOT NULL DEFAULT '0',
`is_top_style` int UNSIGNED NOT NULL DEFAULT '0',
`is_top_show` int UNSIGNED NOT NULL DEFAULT '0',
`cat_ico` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `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`, `is_top_style`, `is_top_show`, `cat_ico`) VALUES
(356, '智能家居', '', '', 0, 50, '', '', 0, '', 1, 0, '', 0, 0, ''),
(357, '高CP產品', '', '', 0, 50, '', '', 0, '', 1, 0, '', 0, 0, '');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_cat_recommend`
--
CREATE TABLE `ecs_cat_recommend` (
`cat_id` smallint NOT NULL,
`recommend_type` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_cat_recommend`
--
INSERT INTO `ecs_cat_recommend` (`cat_id`, `recommend_type`) VALUES
(7, 1),
(7, 2),
(7, 3),
(8, 1),
(8, 2),
(8, 3),
(9, 1),
(9, 2),
(9, 3),
(10, 1),
(10, 2),
(10, 3),
(11, 1),
(11, 2),
(11, 3),
(12, 1),
(12, 2),
(12, 3),
(13, 1),
(13, 2),
(13, 3),
(14, 1),
(14, 2),
(14, 3),
(15, 1),
(15, 2),
(15, 3),
(16, 1),
(16, 2),
(16, 3),
(17, 1),
(17, 2),
(17, 3),
(18, 1),
(18, 2),
(18, 3),
(19, 1),
(19, 2),
(19, 3),
(20, 1),
(20, 2),
(20, 3),
(21, 1),
(21, 2),
(21, 3),
(22, 1),
(22, 2),
(22, 3),
(23, 1),
(23, 2),
(23, 3),
(24, 1),
(24, 2),
(24, 3),
(25, 1),
(25, 2),
(25, 3),
(26, 1),
(26, 2),
(26, 3),
(27, 1),
(27, 2),
(27, 3),
(28, 1),
(28, 2),
(28, 3),
(29, 1),
(29, 2),
(29, 3),
(30, 1),
(30, 2),
(30, 3),
(31, 1),
(31, 2),
(31, 3),
(32, 1),
(32, 2),
(32, 3),
(33, 1),
(33, 2),
(33, 3),
(34, 1),
(34, 2),
(34, 3),
(35, 1),
(35, 2),
(35, 3),
(36, 1),
(36, 2),
(36, 3),
(37, 1),
(37, 2),
(37, 3),
(38, 1),
(38, 2),
(38, 3),
(39, 1),
(39, 2),
(39, 3),
(40, 1),
(40, 2),
(40, 3),
(41, 1),
(41, 2),
(41, 3),
(42, 1),
(42, 2),
(42, 3),
(43, 1),
(43, 2),
(43, 3),
(44, 1),
(44, 2),
(44, 3),
(45, 1),
(45, 2),
(45, 3),
(46, 1),
(46, 2),
(46, 3),
(47, 1),
(47, 2),
(47, 3);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_collect_goods`
--
CREATE TABLE `ecs_collect_goods` (
`rec_id` mediumint UNSIGNED NOT NULL,
`user_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`add_time` int UNSIGNED NOT NULL DEFAULT '0',
`is_attention` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_comment`
--
CREATE TABLE `ecs_comment` (
`comment_id` int UNSIGNED NOT NULL,
`comment_type` tinyint UNSIGNED NOT NULL DEFAULT '0',
`id_value` mediumint 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 UNSIGNED NOT NULL DEFAULT '0',
`add_time` int UNSIGNED NOT NULL DEFAULT '0',
`ip_address` varchar(15) NOT NULL DEFAULT '',
`status` tinyint UNSIGNED NOT NULL DEFAULT '0',
`parent_id` int UNSIGNED NOT NULL DEFAULT '0',
`user_id` int UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_crons`
--
CREATE TABLE `ecs_crons` (
`cron_id` tinyint UNSIGNED NOT NULL,
`cron_code` varchar(20) NOT NULL,
`cron_name` varchar(120) NOT NULL,
`cron_desc` text,
`cron_order` tinyint UNSIGNED NOT NULL DEFAULT '0',
`cron_config` text NOT NULL,
`thistime` int NOT NULL DEFAULT '0',
`nextime` int NOT NULL,
`day` tinyint 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_delivery_goods`
--
CREATE TABLE `ecs_delivery_goods` (
`rec_id` mediumint UNSIGNED NOT NULL,
`delivery_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`product_id` mediumint 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 UNSIGNED DEFAULT '0',
`extension_code` varchar(30) DEFAULT NULL,
`parent_id` mediumint UNSIGNED DEFAULT '0',
`send_number` smallint UNSIGNED DEFAULT '0',
`goods_attr` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_delivery_goods`
--
INSERT INTO `ecs_delivery_goods` (`rec_id`, `delivery_id`, `goods_id`, `product_id`, `product_sn`, `goods_name`, `brand_name`, `goods_sn`, `is_real`, `extension_code`, `parent_id`, `send_number`, `goods_attr`) VALUES
(40, 36, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(41, 37, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 3, ''),
(42, 38, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(43, 39, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 3, ''),
(44, 40, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(45, 41, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(46, 42, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 5, ''),
(47, 43, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(48, 44, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 5, ''),
(49, 45, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 10, ''),
(50, 46, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 2, ''),
(51, 47, 64, 0, '', '【坤七】山楂粉', '', 'MDZ000064', 1, '', 0, 1, ''),
(52, 48, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(53, 49, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 3, ''),
(54, 50, 64, 0, '', '【坤七】山楂粉', '', 'MDZ000064', 1, '', 0, 1, ''),
(55, 51, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(56, 52, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(57, 53, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(58, 54, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(59, 55, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(60, 56, 70, 0, '', '黑羽烏雞', '', 'MDZ000070', 1, '', 0, 1, ''),
(61, 57, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(62, 58, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(63, 59, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(64, 60, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 3, ''),
(65, 61, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 5, ''),
(66, 62, 69, 0, '', '測試', '', 'MDZ000069', 1, '', 0, 1, ''),
(67, 63, 70, 0, '', '黑羽烏雞', '', 'MDZ000070', 1, '', 0, 1, ''),
(68, 64, 85, 0, '', '勁牌中國勁酒禮盒500ML*2', '', 'MDZ000085', 1, NULL, 0, 1, ''),
(69, 64, 1, 0, '', '新鮮檳榔芋頭', '', 'MDZ000000', 1, NULL, 0, 3, ''),
(70, 64, 102, 4, 'sp000102g_p84240', '新鮮豬扒肉', '', 'MDZ000102', 1, NULL, 0, 1, '部位:小腿肉[5] \n規格:500G \n'),
(71, 65, 102, 1, 'sp000102g_p46724', '新鮮豬扒肉', '', 'MDZ000102', 1, NULL, 0, 1, '部位:大腿肉 \n規格:500G \n'),
(72, 65, 102, 2, 'sp000102g_p82663', '新鮮豬扒肉', '', 'MDZ000102', 1, NULL, 0, 1, '部位:大腿肉 \n規格:1000G[28] \n');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_delivery_order`
--
CREATE TABLE `ecs_delivery_order` (
`delivery_id` mediumint UNSIGNED NOT NULL,
`delivery_sn` varchar(20) NOT NULL,
`order_sn` varchar(20) NOT NULL,
`order_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`invoice_no` varchar(50) DEFAULT NULL,
`add_time` int UNSIGNED DEFAULT '0',
`shipping_id` tinyint UNSIGNED DEFAULT '0',
`shipping_name` varchar(120) DEFAULT NULL,
`user_id` mediumint UNSIGNED DEFAULT '0',
`action_user` varchar(30) DEFAULT NULL,
`consignee` varchar(60) DEFAULT NULL,
`address` varchar(250) DEFAULT NULL,
`country` smallint UNSIGNED DEFAULT '0',
`province` smallint UNSIGNED DEFAULT '0',
`city` smallint UNSIGNED DEFAULT '0',
`district` smallint 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 UNSIGNED DEFAULT '0',
`suppliers_id` smallint DEFAULT '0',
`status` tinyint UNSIGNED NOT NULL DEFAULT '0',
`agency_id` smallint UNSIGNED DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_delivery_order`
--
INSERT INTO `ecs_delivery_order` (`delivery_id`, `delivery_sn`, `order_sn`, `order_id`, `invoice_no`, `add_time`, `shipping_id`, `shipping_name`, `user_id`, `action_user`, `consignee`, `address`, `country`, `province`, `city`, `district`, `sign_building`, `email`, `zipcode`, `tel`, `mobile`, `best_time`, `postscript`, `how_oos`, `insure_fee`, `shipping_fee`, `update_time`, `suppliers_id`, `status`, `agency_id`) VALUES
(64, '20170705161978875', '2017070516483', 219, '1111111111111', 1499213926, 13, '順豐速運', 245, 'admin', '測試', '測試測試測試測試', 1, 6, 79, 715, '', '7828697792@qq.com', '', '', '13800138000', '', '', '等待所有產品備齊後再發', '0.00', '0.00', 1499213951, 0, 0, 0),
(65, '20170705162302999', '2017070518460', 220, '33333333', 1499213995, 13, '順豐速運', 245, 'admin', '測試', '測試測試測試測試', 1, 6, 79, 715, '', '7828697792@qq.com', '', '', '13800138000', '', '', '等待所有產品備齊後再發', '0.00', '15.00', 1499214203, 0, 0, 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_email_list`
--
CREATE TABLE `ecs_email_list` (
`id` mediumint NOT NULL,
`email` varchar(60) NOT NULL,
`stat` tinyint(1) NOT NULL DEFAULT '0',
`hash` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_email_sendlist`
--
CREATE TABLE `ecs_email_sendlist` (
`id` mediumint NOT NULL,
`email` varchar(100) NOT NULL,
`template_id` mediumint NOT NULL,
`email_content` text NOT NULL,
`error` tinyint(1) NOT NULL DEFAULT '0',
`pri` tinyint NOT NULL,
`last_send` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_email_sendlist`
--
INSERT INTO `ecs_email_sendlist` (`id`, `email`, `template_id`, `email_content`, `error`, `pri`, `last_send`) VALUES
(1, '7828697792@qq.com', 6, '', 0, 1, 1499150239),
(2, '7828697792@qq.com', 6, '', 0, 1, 1499150253),
(3, '7828697792@qq.com', 6, '', 0, 1, 1499150256),
(4, '7828697792@qq.com', 6, '', 0, 1, 1499150446),
(5, '7828697792@qq.com', 6, '', 0, 1, 1499150807),
(6, '7828697792@qq.com', 6, '', 0, 1, 1499150818),
(7, '7828697792@qq.com', 6, '', 0, 1, 1499151003),
(8, '7828697792@qq.com', 6, '', 0, 1, 1499154154),
(9, '7828697792@qq.com', 6, '', 0, 1, 1499155212);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_error_log`
--
CREATE TABLE `ecs_error_log` (
`id` int NOT NULL,
`info` varchar(255) NOT NULL,
`file` varchar(100) NOT NULL,
`time` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_exchange_goods`
--
CREATE TABLE `ecs_exchange_goods` (
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`exchange_integral` int UNSIGNED NOT NULL DEFAULT '0',
`is_exchange` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_hot` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_exchange_goods`
--
INSERT INTO `ecs_exchange_goods` (`goods_id`, `exchange_integral`, `is_exchange`, `is_hot`) VALUES
(1, 300, 1, 1),
(17, 500, 1, 1),
(19, 600, 1, 1),
(20, 600, 1, 1),
(65, 600, 1, 1);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_favourable_activity`
--
CREATE TABLE `ecs_favourable_activity` (
`act_id` smallint UNSIGNED NOT NULL,
`act_name` varchar(255) NOT NULL,
`start_time` int UNSIGNED NOT NULL,
`end_time` int UNSIGNED NOT NULL,
`user_rank` varchar(255) NOT NULL,
`act_range` tinyint 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 UNSIGNED NOT NULL,
`act_type_ext` decimal(10,2) UNSIGNED NOT NULL,
`gift` text NOT NULL,
`sort_order` tinyint UNSIGNED NOT NULL DEFAULT '50',
`logo` varchar(255) NOT NULL COMMENT '活動代表圖'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_feedback`
--
CREATE TABLE `ecs_feedback` (
`msg_id` mediumint UNSIGNED NOT NULL,
`parent_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`user_id` mediumint 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 UNSIGNED NOT NULL DEFAULT '0',
`msg_status` tinyint UNSIGNED NOT NULL DEFAULT '0',
`msg_content` text NOT NULL,
`msg_time` int UNSIGNED NOT NULL DEFAULT '0',
`message_img` varchar(255) NOT NULL DEFAULT '0',
`order_id` int UNSIGNED NOT NULL DEFAULT '0',
`msg_area` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_friend_link`
--
CREATE TABLE `ecs_friend_link` (
`link_id` smallint UNSIGNED NOT NULL,
`link_name` varchar(255) NOT NULL DEFAULT '',
`link_url` varchar(255) NOT NULL DEFAULT '',
`link_logo` varchar(255) NOT NULL DEFAULT '',
`show_order` tinyint UNSIGNED NOT NULL DEFAULT '50'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_goods`
--
CREATE TABLE `ecs_goods` (
`goods_id` mediumint UNSIGNED NOT NULL COMMENT '自增ID',
`cat_id` smallint UNSIGNED NOT NULL DEFAULT '0' COMMENT '類別ID',
`goods_sn` varchar(60) NOT NULL DEFAULT '' COMMENT '貨號',
`goods_name` varchar(120) NOT NULL DEFAULT '' COMMENT '產品名稱',
`goods_name_style` varchar(60) NOT NULL DEFAULT '+' COMMENT '產品名Style',
`click_count` int UNSIGNED NOT NULL DEFAULT '0' COMMENT '點擊次數',
`brand_id` smallint UNSIGNED NOT NULL DEFAULT '0' COMMENT '品牌ID',
`provider_name` varchar(100) NOT NULL DEFAULT '',
`goods_number` smallint 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 UNSIGNED NOT NULL DEFAULT '0',
`promote_end_date` int UNSIGNED NOT NULL DEFAULT '0',
`sale_price` decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
`sale_start_date` int UNSIGNED NOT NULL DEFAULT '0',
`sale_end_date` int UNSIGNED NOT NULL DEFAULT '0',
`warn_number` tinyint 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 '' COMMENT '產品縮圖',
`goods_img` varchar(255) NOT NULL DEFAULT '' COMMENT '產品圖片',
`original_img` varchar(255) NOT NULL DEFAULT '' COMMENT '產品原始圖片',
`is_real` tinyint UNSIGNED NOT NULL DEFAULT '1',
`extension_code` varchar(30) NOT NULL DEFAULT '',
`is_on_sale` tinyint UNSIGNED NOT NULL DEFAULT '1',
`is_alone_sale` tinyint UNSIGNED NOT NULL DEFAULT '1',
`is_shipping` tinyint UNSIGNED NOT NULL DEFAULT '0',
`integral` int UNSIGNED NOT NULL DEFAULT '0',
`add_time` int UNSIGNED NOT NULL DEFAULT '0',
`sort_order` smallint UNSIGNED NOT NULL DEFAULT '100',
`is_delete` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_best` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_new` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_hot` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_promote` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_sale` tinyint UNSIGNED NOT NULL DEFAULT '0',
`bonus_type_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
`last_update` int UNSIGNED NOT NULL DEFAULT '0',
`goods_type` smallint UNSIGNED NOT NULL DEFAULT '0',
`seller_note` varchar(255) NOT NULL DEFAULT '',
`give_integral` int NOT NULL DEFAULT '-1',
`rank_integral` int NOT NULL DEFAULT '-1',
`suppliers_id` smallint UNSIGNED DEFAULT NULL,
`is_check` tinyint UNSIGNED DEFAULT NULL,
`sales_volume` int UNSIGNED NOT NULL DEFAULT '0',
`comments_number` int UNSIGNED NOT NULL DEFAULT '0',
`bb_chicun` char(28) NOT NULL,
`mobile_desc` text,
`fencheng` varchar(255) DEFAULT NULL,
`sales_count` int UNSIGNED NOT NULL DEFAULT '0',
`goods_shipai` text NOT NULL,
`sales_volume_base` int UNSIGNED NOT NULL DEFAULT '0' COMMENT '銷量基數',
`buymax` int UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_goods_activity`
--
CREATE TABLE `ecs_goods_activity` (
`act_id` mediumint UNSIGNED NOT NULL,
`act_name` varchar(255) NOT NULL,
`act_desc` text NOT NULL,
`act_type` tinyint UNSIGNED NOT NULL,
`goods_id` mediumint UNSIGNED NOT NULL,
`product_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_name` varchar(255) NOT NULL,
`start_time` int UNSIGNED NOT NULL,
`end_time` int UNSIGNED NOT NULL,
`is_finished` tinyint UNSIGNED NOT NULL,
`ext_info` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_goods_article`
--
CREATE TABLE `ecs_goods_article` (
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`article_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`admin_id` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_goods_attr`
--
CREATE TABLE `ecs_goods_attr` (
`goods_attr_id` int UNSIGNED NOT NULL,
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`attr_id` smallint UNSIGNED NOT NULL DEFAULT '0',
`attr_value` text NOT NULL,
`attr_price` varchar(255) NOT NULL DEFAULT '',
`attr_sort_order` tinyint UNSIGNED NOT NULL DEFAULT '0',
`thumb_url` varchar(255) NOT NULL DEFAULT '',
`img_url` varchar(255) NOT NULL DEFAULT '',
`img_original` varchar(255) NOT NULL DEFAULT '',
`hex_color` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_goods_cat`
--
CREATE TABLE `ecs_goods_cat` (
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`cat_id` smallint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_goods_gallery`
--
CREATE TABLE `ecs_goods_gallery` (
`img_id` mediumint UNSIGNED NOT NULL,
`goods_id` mediumint 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 ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_goods_type`
--
CREATE TABLE `ecs_goods_type` (
`cat_id` smallint UNSIGNED NOT NULL,
`cat_name` varchar(60) NOT NULL DEFAULT '',
`enabled` tinyint UNSIGNED NOT NULL DEFAULT '1',
`attr_group` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_group_goods`
--
CREATE TABLE `ecs_group_goods` (
`parent_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_price` decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
`admin_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
`group_id` mediumint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_ip_log`
--
CREATE TABLE `ecs_ip_log` (
`id` int NOT NULL,
`ip` varchar(20) DEFAULT NULL,
`u_id` int DEFAULT NULL,
`state` int DEFAULT '0',
`phone_state` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_keywords`
--
CREATE TABLE `ecs_keywords` (
`date` date NOT NULL DEFAULT '0000-00-00',
`searchengine` varchar(20) NOT NULL DEFAULT '',
`keyword` varchar(90) NOT NULL DEFAULT '',
`count` mediumint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_keywords`
--
INSERT INTO `ecs_keywords` (`date`, `searchengine`, `keyword`, `count`) VALUES
('2017-04-01', 'shop', '北極', 1),
('2017-04-04', 'shop', '肉', 2),
('2017-04-05', 'shop', '750ml', 1),
('2017-04-05', 'shop', '法國進口拉菲傳奇乾紅葡萄酒', 1),
('2017-04-05', 'shop', '華', 1),
('2017-04-05', 'shop', '譜', 1),
('2017-04-20', 'shop', '11111', 4),
('2017-04-20', 'shop', '菜', 8),
('2017-04-24', 'shop', '台灣青檸檬4粒', 1),
('2017-04-24', 'shop', '鮮檸檬青檸檬片', 1),
('2017-05-16', 'shop', '彩椒', 1),
('2017-05-16', 'shop', '牛奶', 1),
('2017-05-16', 'shop', '蔬菜', 2),
('2017-05-17', 'BAIDU', 'www.huadezhao.com', 3),
('2017-05-17', 'shop', '問卷調查', 1),
('2017-05-17', 'shop', '大米', 1),
('2017-05-17', 'shop', '廣西', 1),
('2017-05-17', 'shop', '榴蓮', 1),
('2017-05-17', 'shop', '水果', 1),
('2017-05-17', 'shop', '海外直採', 1),
('2017-05-17', 'shop', '牛奶', 1),
('2017-05-17', 'shop', '獼猴桃', 1),
('2017-05-17', 'shop', '白菜', 4),
('2017-05-17', 'shop', '白蝦', 1),
('2017-05-17', 'shop', '肉', 2),
('2017-05-17', 'shop', '葡萄酒', 1),
('2017-05-17', 'shop', '蘋果', 2),
('2017-05-17', 'shop', '豬', 2),
('2017-05-17', 'shop', '鱈魚', 1),
('2017-05-18', 'BAIDU', 'www.huadezhao.com', 1),
('2017-05-18', 'shop', '123', 2),
('2017-05-18', 'shop', '快易捷', 3),
('2017-05-22', 'shop', '小米辣', 2),
('2017-05-22', 'shop', '聽湖', 1),
('2017-05-28', 'shop', '大米', 3),
('2017-05-28', 'shop', '榴蓮', 3),
('2017-05-28', 'shop', '海外直採', 3),
('2017-05-28', 'shop', '牛奶', 3),
('2017-05-28', 'shop', '獼猴桃', 3),
('2017-05-28', 'shop', '白蝦', 3),
('2017-05-28', 'shop', '鱈魚', 3),
('2017-05-31', 'shop', '蜂蜜', 2),
('2017-06-09', 'shop', '大米↙', 2),
('2017-06-09', 'shop', '雞', 2),
('2017-06-11', 'shop', '測試', 2),
('2017-06-12', 'shop', '測試', 4),
('2017-06-12', 'shop', '維摩', 1),
('2017-07-03', 'shop', '大米', 1),
('2017-07-03', 'shop', '榴蓮', 2),
('2017-07-03', 'shop', '海外直採', 1),
('2017-07-03', 'shop', '白蝦', 1),
('2017-07-03', 'shop', '鱈魚', 1),
('2017-07-05', 'shop', '肉', 1),
('2017-07-05', 'shop', '豬肉', 1),
('2017-07-07', 'shop', '測試', 9),
('2022-12-08', 'shop', '海外直採', 1),
('2022-12-10', 'shop', '大米', 1),
('2022-12-10', 'shop', '猕猴桃', 1),
('2022-12-11', 'shop', '獼猴桃', 1);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_link_goods`
--
CREATE TABLE `ecs_link_goods` (
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`link_goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`is_double` tinyint UNSIGNED NOT NULL DEFAULT '0',
`admin_id` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_link_goods`
--
INSERT INTO `ecs_link_goods` (`goods_id`, `link_goods_id`, `is_double`, `admin_id`) VALUES
(65, 62, 0, 1),
(65, 63, 0, 1),
(65, 64, 0, 1);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_mail_templates`
--
CREATE TABLE `ecs_mail_templates` (
`template_id` tinyint UNSIGNED NOT NULL,
`template_code` varchar(30) NOT NULL DEFAULT '',
`is_html` tinyint UNSIGNED NOT NULL DEFAULT '0',
`template_subject` varchar(200) NOT NULL DEFAULT '',
`template_content` text NOT NULL,
`last_modify` int UNSIGNED NOT NULL DEFAULT '0',
`last_send` int UNSIGNED NOT NULL DEFAULT '0',
`type` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_mail_templates`
--
INSERT INTO `ecs_mail_templates` (`template_id`, `template_code`, `is_html`, `template_subject`, `template_content`, `last_modify`, `last_send`, `type`) VALUES
(1, 'send_password', 1, '密碼找回', '{$user_name}您好！<br>\n<br>\n您已經進行了密碼重置的操作，請點擊以下鏈接(或者複製到您的瀏覽器):<br>\n<br>\n<a href=\"{$reset_email}\" target=\"_blank\">{$reset_email}</a><br>\n<br>\n以確認您的新密碼重置操作！<br>\n<br>\n{$shop_name}<br>\n{$send_date}', 1194824789, 0, 'template'),
(2, 'order_confirm', 0, '訂單確認通知', '親愛的{$order.consignee}，你好！ \n\n我們已經收到您於 {$order.formated_add_time} 提交的訂單，該訂單編號為：{$order.order_sn} 請記住這個編號以便日後的查詢。\n\n{$shop_name}\n{$sent_date}\n\n\n', 1158226370, 0, 'template'),
(3, 'deliver_notice', 1, '發貨通知', '親愛的{$order.consignee}。你好！</br></br>\n\n您的訂單{$order.order_sn}已於{$send_time}按照您預定的配送方式給您發貨了。</br>\n</br>\n{if $order.invoice_no}發貨單號是{$order.invoice_no}。</br>{/if}\n</br>\n在您收到貨物之後請點擊下面的鏈接確認您已經收到貨物：</br>\n<a href=\"{$confirm_url}\" target=\"_blank\">{$confirm_url}</a></br></br>\n如果您還沒有收到貨物可以點擊以下鏈接給我們留言：</br></br>\n<a href=\"{$send_msg_url}\" target=\"_blank\">{$send_msg_url}</a></br>\n<br>\n再次感謝您對我們的支持。歡迎您的再次光臨。 <br>\n<br>\n{$shop_name} </br>\n{$send_date}', 1194823291, 0, 'template'),
(4, 'order_cancel', 0, '訂單取消', '親愛的{$order.consignee}，你好！ \n\n您的編號為：{$order.order_sn}的訂單已取消。\n\n{$shop_name}\n{$send_date}', 1156491130, 0, 'template'),
(5, 'order_invalid', 0, '訂單無效', '親愛的{$order.consignee}，你好！\n\n您的編號為：{$order.order_sn}的訂單無效。\n\n{$shop_name}\n{$send_date}', 1156491164, 0, 'template'),
(6, 'send_bonus', 0, '發紅包', '親愛的{$user_name}您好！\n\n恭喜您獲得了{$count}個紅包，金額{if $count > 1}分別{/if}為{$money}\n\n{$shop_name}\n{$send_date}\n', 1156491184, 0, 'template'),
(7, 'group_buy', 1, '團購產品', '親愛的{$consignee}，您好！<br>\n<br>\n您於{$order_time}在本店參加團購產品活動，所購買的產品名稱為：{$goods_name}，數量：{$goods_number}，訂單號為：{$order_sn}，訂單金額為：{$order_amount}<br>\n<br>\n此團購產品現在已到結束日期，並達到最低價格，您現在可以對該訂單付款。<br>\n<br>\n請點擊下面的鏈接：<br>\n<a href=\"{$shop_url}\" target=\"_blank\">{$shop_url}</a><br>\n<br>\n請儘快登錄到用户中心，查看您的訂單詳情信息。 <br>\n<br>\n{$shop_name} <br>\n<br>\n{$send_date}', 1194824668, 0, 'template'),
(8, 'register_validate', 1, '郵件驗證', '{$user_name}您好！<br><br>\r\n\r\n這封郵件是 {$shop_name} 發送的。你收到這封郵件是為了驗證你註冊郵件地址是否有效。如果您已經通過驗證了，請忽略這封郵件。<br>\r\n請點擊以下鏈接(或者複製到您的瀏覽器)來驗證你的郵件地址:<br>\r\n<a href=\"{$validate_email}\" target=\"_blank\">{$validate_email}</a><br><br>\r\n\r\n{$shop_name}<br>\r\n{$send_date}', 1162201031, 0, 'template'),
(9, 'virtual_card', 0, '虛擬卡片', '親愛的{$order.consignee}\r\n你好！您的訂單{$order.order_sn}中{$goods.goods_name} 產品的詳細信息如下:\r\n{foreach from=$virtual_card item=card}\r\n{if $card.card_sn}卡號：{$card.card_sn}{/if}{if $card.card_password}卡片密碼：{$card.card_password}{/if}{if $card.end_date}截至日期：{$card.end_date}{/if}\r\n{/foreach}\r\n再次感謝您對我們的支持。歡迎您的再次光臨。\r\n\r\n{$shop_name} \r\n{$send_date}', 1162201031, 0, 'template'),
(10, 'attention_list', 0, '關注產品', '親愛的{$user_name}您好~\n\n您關注的產品 : {$goods_name} 最近已經更新,請您查看最新的產品信息\n\n{$goods_url}\r\n\r\n{$shop_name} \r\n{$send_date}', 1183851073, 0, 'template'),
(11, 'remind_of_new_order', 0, '新訂單通知', '親愛的店長，您好：\n 快來看看吧，又有新訂單了。\n 訂單號:{$order.order_sn} \n 訂單金額:{$order.order_amount}，\n 用户購買產品:{foreach from=$goods_list item=goods_data}{$goods_data.goods_name}(貨號:{$goods_data.goods_sn}) {/foreach} \n\n 收貨人:{$order.consignee}， \n 收貨人地址:{$order.address}，\n 收貨人電話:{$order.tel} {$order.mobile}, \n 配送方式:{$order.shipping_name}(費用:{$order.shipping_fee}), \n 付款方式:{$order.pay_name}(費用:{$order.pay_fee})。\n\n 系統提醒\n {$send_date}', 1196239170, 0, 'template'),
(12, 'goods_booking', 1, '缺貨回覆', '親愛的{$user_name}。你好！</br></br>{$dispose_note}</br></br>您提交的缺貨產品鏈接為</br></br><a href=\"{$goods_link}\" target=\"_blank\">{$goods_name}</a></br><br>{$shop_name} </br>{$send_date}', 0, 0, 'template'),
(13, 'user_message', 1, '留言回覆', '親愛的{$user_name}。你好！</br></br>對您的留言：</br>{$message_content}</br></br>店主作了如下回復：</br>{$message_note}</br></br>您可以隨時回到店中和店主繼續溝通。</br>{$shop_name}</br>{$send_date}', 0, 0, 'template'),
(14, 'recomment', 1, '用户評論回覆', '親愛的{$user_name}。你好！</br></br>對您的評論：</br>“{$comment}”</br></br>店主作了如下回復：</br>“{$recomment}”</br></br>您可以隨時回到店中和店主繼續溝通。</br>{$shop_name}</br>{$send_date}', 0, 0, 'template');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_member_price`
--
CREATE TABLE `ecs_member_price` (
`price_id` mediumint UNSIGNED NOT NULL,
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`user_rank` tinyint NOT NULL DEFAULT '0',
`user_price` decimal(10,2) NOT NULL DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_nav`
--
CREATE TABLE `ecs_nav` (
`id` mediumint NOT NULL,
`ctype` varchar(10) DEFAULT NULL,
`cid` smallint 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_nav`
--
INSERT INTO `ecs_nav` (`id`, `ctype`, `cid`, `name`, `ifshow`, `vieworder`, `opennew`, `url`, `type`) VALUES
(2, '', 0, '積分兑換', 0, 4, 0, 'exchange.php', 'middle'),
(5, '', 0, '免責條款', 1, 1, 0, 'article.php?id=1', 'bottom'),
(6, '', 0, '隱私保護', 1, 2, 0, 'article.php?id=2', 'bottom'),
(7, '', 0, '諮詢熱點', 1, 3, 0, 'article.php?id=3', 'bottom'),
(8, '', 0, '聯繫我們', 1, 4, 0, 'article.php?id=4', 'bottom'),
(9, '', 0, '公司簡介', 0, 5, 0, 'article.php?id=5', 'bottom'),
(10, '', 0, '批發方案', 0, 6, 0, 'wholesale.php', 'bottom'),
(11, '', 0, '配送方式', 0, 7, 0, 'myship.php', 'bottom'),
(12, '', 0, '預售活動', 0, 5, 0, 'pre_sale.php', 'middle'),
(24, '', 0, 'UTEL介紹', 1, 10, 0, 'https://shop.h888.fun/article.php?id=143', 'middle'),
(25, '', 0, '分銷分潤', 1, 20, 0, 'https://shop.h888.fun/article.php?id=46', 'middle'),
(26, 'a', 7, '購買方案', 1, 30, 0, 'article_cat.php?id=7', 'middle');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_order_action`
--
CREATE TABLE `ecs_order_action` (
`action_id` mediumint UNSIGNED NOT NULL,
`order_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`action_user` varchar(30) NOT NULL DEFAULT '',
`order_status` tinyint UNSIGNED NOT NULL DEFAULT '0',
`shipping_status` tinyint UNSIGNED NOT NULL DEFAULT '0',
`pay_status` tinyint UNSIGNED NOT NULL DEFAULT '0',
`action_place` tinyint UNSIGNED NOT NULL DEFAULT '0',
`action_note` varchar(255) NOT NULL DEFAULT '',
`log_time` int UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_order_action`
--
INSERT INTO `ecs_order_action` (`action_id`, `order_id`, `action_user`, `order_status`, `shipping_status`, `pay_status`, `action_place`, `action_note`, `log_time`) VALUES
(1, 11, 'buyer', 2, 0, 0, 0, '用户取消', 1447996110),
(2, 19, 'buyer', 2, 0, 0, 0, '用户取消', 1447996115),
(3, 23, 'buyer', 2, 0, 0, 0, '用户取消', 1448162926),
(4, 25, 'buyer', 2, 0, 0, 0, '用户取消', 1448163700),
(5, 24, 'buyer', 2, 0, 0, 0, '用户取消', 1448163888),
(6, 27, '買家', 1, 0, 2, 0, '', 1448164384),
(7, 27, 'sclzz', 5, 5, 2, 0, '', 1448164506),
(8, 27, 'sclzz', 1, 1, 2, 1, '', 1448164517),
(9, 26, 'sclzz', 1, 0, 2, 0, '111', 1448164584),
(10, 26, 'sclzz', 1, 3, 2, 0, '', 1448164588),
(11, 27, '買家', 5, 2, 2, 0, '', 1448164652),
(12, 26, 'sclzz', 5, 5, 2, 0, '', 1448165909),
(13, 26, 'sclzz', 1, 1, 2, 1, '', 1448165915),
(14, 26, '買家', 5, 2, 2, 0, '', 1448165988),
(15, 28, '買家', 1, 0, 2, 0, '', 1448166241),
(16, 29, '買家', 1, 0, 2, 0, '', 1448166384),
(17, 30, '買家', 1, 0, 2, 0, '', 1448166652),
(18, 31, '買家', 1, 0, 2, 0, '', 1448166818),
(19, 31, 'sclzz', 5, 5, 2, 0, '', 1448166999),
(20, 31, 'sclzz', 1, 1, 2, 1, '', 1448167013),
(21, 31, '買家', 5, 2, 2, 0, '', 1448167030),
(22, 33, '買家', 1, 0, 2, 0, '', 1448167608),
(23, 34, '買家', 1, 0, 2, 0, '', 1448168010),
(24, 35, '買家', 1, 0, 2, 0, '', 1448168276),
(25, 36, '買家', 1, 0, 2, 0, '', 1448169770),
(26, 37, '買家', 1, 0, 2, 0, '', 1448170362),
(27, 51, '買家', 1, 0, 2, 0, '', 1448172749),
(28, 52, '買家', 1, 0, 2, 0, '', 1448173068),
(29, 53, '買家', 1, 0, 2, 0, '', 1448173153),
(30, 54, '買家', 1, 0, 2, 0, '', 1448173268),
(31, 55, '買家', 1, 0, 2, 0, '', 1448173324),
(32, 56, '買家', 1, 0, 2, 0, '', 1448173375),
(33, 57, '買家', 1, 0, 2, 0, '', 1448173457),
(34, 58, '買家', 1, 0, 2, 0, '', 1448173517),
(35, 59, '買家', 1, 0, 2, 0, '', 1448173586),
(36, 60, '買家', 1, 0, 2, 0, '', 1448173656),
(37, 61, '買家', 1, 0, 2, 0, '', 1448173702),
(38, 62, '買家', 1, 0, 2, 0, '', 1448173762),
(39, 63, '買家', 1, 0, 2, 0, '', 1448173911),
(40, 64, '買家', 1, 0, 2, 0, '', 1448173969),
(41, 65, '買家', 1, 0, 2, 0, '', 1448174014),
(42, 66, '買家', 1, 0, 2, 0, '', 1448174120),
(43, 67, '買家', 1, 0, 2, 0, '', 1448174205),
(44, 68, '買家', 1, 0, 2, 0, '', 1448174257),
(45, 69, '買家', 1, 0, 2, 0, '', 1448174406),
(46, 70, '買家', 1, 0, 2, 0, '', 1448174744),
(47, 71, 'buyer', 2, 0, 0, 0, '用户取消', 1448232116),
(48, 73, 'sclzz', 1, 3, 0, 0, '', 1448232764),
(49, 73, 'sclzz', 5, 5, 0, 0, '', 1448232926),
(50, 73, 'sclzz', 1, 1, 0, 1, '', 1448232942),
(51, 73, '買家', 5, 2, 0, 0, '', 1448233314),
(52, 82, '買家', 1, 0, 2, 0, '', 1448237596),
(53, 83, '買家', 1, 0, 2, 0, '', 1448237675),
(54, 84, '買家', 1, 0, 2, 0, '', 1448238879),
(55, 85, '買家', 1, 0, 2, 0, '', 1448239080),
(56, 86, '買家', 1, 0, 2, 0, '', 1448239341),
(57, 87, '買家', 1, 0, 2, 0, '', 1448239705),
(58, 88, '買家', 1, 0, 2, 0, '', 1448239985),
(59, 89, '買家', 1, 0, 2, 0, '', 1448240341),
(60, 90, '買家', 1, 0, 2, 0, '', 1448240443),
(61, 91, '買家', 1, 0, 2, 0, '', 1448241017),
(62, 92, '買家', 1, 0, 2, 0, '', 1448241185),
(63, 93, '買家', 1, 0, 2, 0, '', 1448241358),
(64, 94, '買家', 1, 0, 2, 0, '', 1448241731),
(65, 95, '買家', 1, 0, 2, 0, '', 1448241875),
(66, 96, '買家', 1, 0, 2, 0, '', 1448242033),
(67, 97, '買家', 1, 0, 2, 0, '', 1448242130),
(68, 98, 'buyer', 2, 0, 0, 0, '用户取消', 1448242231),
(69, 97, 'sclzz', 5, 5, 2, 0, '', 1448242314),
(70, 97, 'sclzz', 1, 1, 2, 1, '', 1448242320),
(71, 97, '買家', 5, 2, 2, 0, '', 1448242329),
(72, 96, 'sclzz', 1, 0, 2, 0, '1111', 1448247381),
(73, 96, 'sclzz', 5, 5, 2, 0, '', 1448247510),
(74, 96, 'sclzz', 1, 1, 2, 1, '', 1448247519),
(75, 95, 'sclzz', 1, 3, 2, 0, '', 1448250039),
(76, 95, 'sclzz', 5, 5, 2, 0, '', 1448250050),
(77, 95, 'sclzz', 1, 1, 2, 1, '', 1448250063),
(78, 94, 'sclzz', 5, 5, 2, 0, '', 1448409424),
(79, 94, 'sclzz', 1, 1, 2, 1, '', 1448409431),
(80, 100, '買家', 1, 0, 2, 0, '', 1448409922),
(81, 100, 'sclzz', 5, 5, 2, 0, '', 1448409967),
(82, 100, 'sclzz', 1, 1, 2, 1, '', 1448409980),
(83, 103, 'sclzz', 5, 5, 2, 0, '', 1449032516),
(84, 103, 'sclzz', 1, 1, 2, 1, '', 1449032601),
(85, 103, '買家', 5, 2, 2, 0, '', 1449032610),
(86, 109, 'sclzz', 5, 5, 2, 0, '', 1456351481),
(87, 110, 'sclzz', 5, 5, 2, 0, '', 1457815397),
(88, 110, 'sclzz', 1, 1, 2, 1, '', 1457815404),
(89, 111, 'sclzz', 5, 5, 2, 0, '', 1457815501),
(90, 111, 'sclzz', 1, 1, 2, 1, '', 1457815508),
(91, 112, '買家', 1, 0, 2, 0, '', 1457820141),
(92, 119, '買家', 1, 0, 2, 0, '', 1457826231),
(93, 120, 'sclzz', 5, 5, 2, 0, '', 1457986028),
(94, 120, 'sclzz', 1, 1, 2, 1, '', 1457986039),
(95, 121, 'sclzz', 1, 3, 2, 0, '', 1457987342),
(96, 121, 'sclzz', 5, 5, 2, 0, '', 1457987348),
(97, 121, 'sclzz', 1, 1, 2, 1, '', 1457987365),
(100, 139, 'buyer', 2, 0, 0, 0, '用户取消', 1469513921),
(101, 138, 'buyer', 2, 0, 0, 0, '用户取消', 1469513924),
(102, 147, 'sclzz', 1, 0, 2, 0, '111', 1471981154),
(103, 147, 'sclzz', 5, 5, 2, 0, '', 1471981167),
(104, 147, 'sclzz', 1, 1, 2, 1, '', 1471981167),
(110, 161, '買家', 1, 0, 2, 0, '', 1494913347),
(111, 161, 'admin', 5, 5, 2, 0, '', 1494913499),
(112, 161, 'admin', 1, 1, 2, 1, '', 1494913547),
(113, 162, 'buyer', 2, 0, 0, 0, '用户取消', 1494913690),
(114, 163, 'buyer', 2, 0, 0, 0, '用户取消', 1494914331),
(115, 161, '買家', 5, 2, 2, 0, '', 1494914343),
(116, 164, 'buyer', 2, 0, 0, 0, '用户取消', 1494916460),
(117, 167, 'buyer', 2, 0, 0, 0, '用户取消', 1494927445),
(118, 172, '買家', 1, 0, 2, 0, '', 1496969434),
(119, 174, '買家', 1, 0, 2, 0, '', 1496972413),
(120, 177, '買家', 1, 0, 2, 0, '', 1496973430),
(121, 176, 'buyer', 2, 0, 0, 0, '用户取消', 1496973457),
(122, 177, 'admin', 5, 5, 2, 0, '', 1497037407),
(123, 177, 'admin', 1, 1, 2, 1, '', 1497037407),
(124, 174, 'admin', 5, 5, 2, 0, '', 1497037488),
(125, 174, 'admin', 1, 1, 2, 1, '', 1497037488),
(126, 180, '買家', 1, 0, 2, 0, '', 1497147296),
(127, 180, 'mdz01', 5, 5, 2, 0, '', 1497152031),
(128, 180, 'mdz01', 1, 1, 2, 1, '', 1497152031),
(129, 180, '買家', 1, 0, 2, 0, '', 1497153930),
(130, 181, '買家', 1, 0, 2, 0, '', 1497154162),
(131, 182, '買家', 1, 0, 2, 0, '', 1497154852),
(132, 185, '買家', 1, 0, 2, 0, '', 1497155438),
(133, 185, 'mdz01', 5, 5, 2, 0, '', 1497155466),
(134, 185, 'mdz01', 1, 1, 2, 1, '', 1497155466),
(135, 185, '買家', 5, 2, 2, 0, '', 1497155504),
(136, 189, 'buyer', 2, 0, 0, 0, '用户取消', 1497204944),
(137, 191, '買家', 1, 0, 2, 0, '', 1497205133),
(138, 190, 'buyer', 2, 0, 0, 0, '用户取消', 1497205229),
(139, 191, 'mdz01', 1, 3, 2, 0, '', 1497205493),
(140, 191, 'mdz01', 5, 5, 2, 0, '123', 1497205542),
(141, 182, 'mdz01', 5, 5, 2, 0, '789', 1497205866),
(142, 192, '買家', 1, 0, 2, 0, '', 1497206168),
(143, 192, 'mdz01', 1, 3, 2, 0, '配貨', 1497206223),
(144, 192, 'mdz01', 5, 5, 2, 0, '生成發貨單', 1497206296),
(145, 181, 'mdz01', 5, 5, 2, 0, '', 1497206378),
(146, 181, 'mdz01', 1, 1, 2, 1, '', 1497206378),
(147, 192, 'mdz01', 1, 1, 2, 1, '', 1497206529),
(148, 191, 'mdz01', 1, 1, 2, 1, '', 1497206542),
(149, 191, '買家', 5, 2, 2, 0, '', 1497206563),
(150, 192, '買家', 5, 2, 2, 0, '', 1497206567),
(151, 182, 'mdz01', 1, 1, 2, 1, '', 1497206579),
(152, 193, '買家', 1, 0, 2, 0, '', 1497206710),
(153, 193, 'mdz01', 1, 3, 2, 0, '', 1497206770),
(154, 193, 'mdz01', 5, 5, 2, 0, '生成發貨單', 1497206812),
(155, 193, 'mdz01', 1, 1, 2, 1, '確認發貨', 1497206867),
(156, 193, '買家', 5, 2, 2, 0, '', 1497206896),
(157, 194, 'mdz01', 1, 0, 0, 0, '', 1497207999),
(158, 194, 'mdz01', 1, 0, 2, 0, '已付款', 1497208026),
(159, 194, 'mdz01', 5, 5, 2, 0, '', 1497208062),
(160, 194, 'mdz01', 1, 1, 2, 1, '', 1497208062),
(161, 194, '買家', 5, 2, 2, 0, '', 1497208116),
(162, 183, 'mdz01', 1, 0, 0, 0, '', 1497208140),
(163, 183, 'mdz01', 1, 0, 2, 0, '已付款', 1497208157),
(164, 183, 'mdz01', 5, 5, 2, 0, '', 1497208163),
(165, 183, 'mdz01', 1, 1, 2, 1, '', 1497208163),
(166, 174, '買家', 5, 2, 2, 0, '', 1497208254),
(167, 177, '買家', 5, 2, 2, 0, '', 1497208258),
(168, 181, '買家', 5, 2, 2, 0, '', 1497208261),
(169, 182, 'mdz01', 5, 2, 2, 0, '已收貨', 1497208395),
(170, 183, 'mdz01', 5, 2, 2, 0, '已收貨', 1497208441),
(171, 180, 'mdz01', 1, 2, 2, 0, '已收貨', 1497208537),
(172, 197, '買家', 1, 0, 2, 0, '', 1497209527),
(173, 198, '買家', 1, 0, 2, 0, '', 1497211675),
(174, 199, '買家', 1, 0, 2, 0, '', 1497211913),
(175, 200, '買家', 1, 0, 2, 0, '', 1497211921),
(176, 200, 'mdz01', 5, 5, 2, 0, '', 1497211975),
(177, 200, 'mdz01', 1, 1, 2, 1, '', 1497211975),
(178, 201, '買家', 1, 0, 2, 0, '', 1497211983),
(179, 200, '買家', 5, 2, 2, 0, '', 1497212071),
(180, 202, '買家', 1, 0, 2, 0, '', 1497212119),
(181, 203, '買家', 1, 0, 2, 0, '', 1497212202),
(182, 204, '買家', 1, 0, 2, 0, '', 1497212511),
(183, 205, '買家', 1, 0, 2, 0, '', 1497212617),
(184, 205, '物流配送', 5, 5, 2, 0, '', 1497212650),
(185, 205, '物流配送', 1, 1, 2, 1, '', 1497212650),
(186, 206, '買家', 1, 0, 2, 0, '', 1497212716),
(187, 206, '物流配送', 5, 5, 2, 0, '', 1497212743),
(188, 206, '物流配送', 1, 1, 2, 1, '', 1497212743),
(189, 207, '買家', 1, 0, 2, 0, '', 1497212785),
(190, 207, '物流配送', 5, 5, 2, 0, '', 1497212816),
(191, 207, '物流配送', 1, 1, 2, 1, '', 1497212816),
(192, 208, '買家', 1, 0, 2, 0, '', 1497212863),
(193, 208, 'admin', 5, 5, 2, 0, '', 1497212925),
(194, 208, 'admin', 1, 1, 2, 1, '', 1497212925),
(195, 204, 'mdz01', 5, 5, 2, 0, '', 1497213268),
(196, 204, 'mdz01', 1, 1, 2, 1, '', 1497213268),
(197, 203, 'mdz01', 5, 5, 2, 0, '', 1497213301),
(198, 203, 'mdz01', 1, 1, 2, 1, '', 1497213301),
(199, 202, 'mdz01', 5, 5, 2, 0, '', 1497213330),
(200, 202, 'mdz01', 1, 1, 2, 1, '', 1497213330),
(201, 207, '買家', 5, 2, 2, 0, '', 1497213455),
(202, 206, '買家', 5, 2, 2, 0, '', 1497213458),
(203, 210, '買家', 1, 0, 2, 0, '', 1497213510),
(204, 201, '物流配送', 5, 5, 2, 0, '', 1497213557),
(205, 201, '物流配送', 1, 1, 2, 1, '', 1497213557),
(206, 210, '物流配送', 1, 3, 2, 0, '', 1497213678),
(207, 210, '物流配送', 5, 5, 2, 0, '生成發貨單', 1497213767),
(208, 210, '物流配送', 1, 1, 2, 1, '', 1497213831),
(209, 210, '買家', 5, 2, 2, 0, '', 1497213849),
(210, 199, 'mdz01', 5, 5, 2, 0, '', 1497214008),
(211, 199, 'mdz01', 1, 1, 2, 1, '', 1497214008),
(212, 198, 'mdz01', 5, 5, 2, 0, '', 1497214037),
(213, 198, 'mdz01', 1, 1, 2, 1, '', 1497214037),
(214, 197, 'mdz01', 5, 5, 2, 0, '', 1497214052),
(215, 197, 'mdz01', 1, 1, 2, 1, '', 1497214052),
(216, 211, '買家', 1, 0, 2, 0, '', 1497214501),
(217, 211, 'mdz01', 5, 5, 2, 0, '', 1497215749),
(218, 211, 'mdz01', 1, 1, 2, 1, '', 1497215749),
(219, 211, '買家', 5, 2, 2, 0, '', 1497216044),
(220, 196, 'mdz01', 1, 0, 0, 0, '', 1497216078),
(221, 196, 'mdz01', 1, 0, 2, 0, '123', 1497216088),
(222, 196, 'mdz01', 5, 5, 2, 0, '', 1497216094),
(223, 196, 'mdz01', 1, 1, 2, 1, '', 1497216094),
(224, 196, '買家', 5, 2, 2, 0, '', 1497216113),
(225, 195, 'mdz01', 1, 0, 0, 0, '', 1497216159),
(226, 195, 'mdz01', 1, 0, 2, 0, '123', 1497216170),
(227, 195, 'mdz01', 5, 5, 2, 0, '', 1497216175),
(228, 195, 'mdz01', 1, 1, 2, 1, '', 1497216175),
(229, 212, '買家', 1, 0, 2, 0, '', 1497221724),
(230, 212, 'mdz01', 5, 5, 2, 0, '', 1497221818),
(231, 212, 'mdz01', 1, 1, 2, 1, '', 1497221818),
(232, 212, '買家', 5, 2, 2, 0, '', 1497221856),
(233, 219, 'admin', 5, 5, 2, 0, '', 1499213951),
(234, 219, 'admin', 1, 1, 2, 1, '', 1499213951),
(235, 220, 'admin', 5, 5, 2, 0, '', 1499214203),
(236, 220, 'admin', 1, 1, 2, 1, '', 1499214203),
(237, 221, '買家', 1, 0, 2, 0, '', 1499390933),
(238, 222, '買家', 1, 0, 2, 0, '', 1499391161),
(239, 223, '買家', 1, 0, 2, 0, '', 1499391757),
(240, 224, '買家', 1, 0, 2, 0, '', 1499393598);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_order_goods`
--
CREATE TABLE `ecs_order_goods` (
`rec_id` mediumint UNSIGNED NOT NULL,
`order_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_name` varchar(120) NOT NULL DEFAULT '',
`goods_sn` varchar(60) NOT NULL DEFAULT '',
`product_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_number` smallint 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 UNSIGNED NOT NULL DEFAULT '0',
`is_real` tinyint UNSIGNED NOT NULL DEFAULT '0',
`extension_code` varchar(30) NOT NULL DEFAULT '',
`parent_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`is_gift` smallint UNSIGNED NOT NULL DEFAULT '0',
`goods_attr_id` varchar(255) NOT NULL DEFAULT '',
`is_back` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_order_goods`
--
INSERT INTO `ecs_order_goods` (`rec_id`, `order_id`, `goods_id`, `goods_name`, `goods_sn`, `product_id`, `goods_number`, `market_price`, `goods_price`, `goods_attr`, `send_number`, `is_real`, `extension_code`, `parent_id`, `is_gift`, `goods_attr_id`, `is_back`) VALUES
(1, 210, 15, '特級庫爾勒香梨（大果）', 'MDZ000015', 0, 1, '19.04', '10.00', '', 0, 1, 'pre_sale', 0, 0, '', 0),
(2, 211, 20, '國產黑布林', 'MDZ000020', 0, 2, '17.95', '14.96', '', 0, 1, '', 0, 0, '', 0),
(3, 211, 19, '福建蜜柚', 'MDZ000019', 0, 1, '12.87', '10.73', '', 0, 1, '', 0, 0, '', 0),
(4, 211, 18, '江西臍橙', 'MDZ000018', 0, 3, '21.16', '17.64', '', 0, 1, '', 0, 0, '', 0),
(5, 212, 20, '國產黑布林', 'MDZ000020', 0, 1, '17.95', '14.96', '', 0, 1, '', 0, 0, '', 0),
(6, 212, 19, '福建蜜柚', 'MDZ000019', 0, 1, '12.87', '10.73', '', 0, 1, '', 0, 0, '', 0),
(7, 213, 19, '福建蜜柚', 'MDZ000019', 0, 1, '12.87', '10.73', '', 0, 1, '', 0, 0, '', 0),
(8, 213, 18, '江西臍橙', 'MDZ000018', 0, 1, '21.16', '17.64', '', 0, 1, '', 0, 0, '', 1),
(9, 214, 19, '福建蜜柚', 'MDZ000019', 0, 1, '12.87', '10.73', '', 0, 1, '', 0, 0, '', 0),
(10, 214, 18, '江西臍橙', 'MDZ000018', 0, 1, '21.16', '17.64', '', 0, 1, '', 0, 0, '', 1),
(11, 215, 20, '國產黑布林', 'MDZ000020', 0, 1, '17.95', '14.96', '', 0, 1, '', 0, 0, '', 0),
(12, 216, 14, '煙台紅富士5斤禮盒裝', 'MDZ000014', 0, 1, '47.76', '10.00', '', 0, 1, 'pre_sale', 0, 0, '', 0),
(13, 217, 14, '煙台紅富士5斤禮盒裝', 'MDZ000014', 0, 1, '47.76', '10.00', '', 0, 1, 'pre_sale', 0, 0, '', 0),
(14, 218, 102, '新鮮豬扒肉', 'MDZ000102', 6, 2, '108.60', '93.00', '部位:小腿肉[5] \n規格:2000G[58] \n', 0, 1, '', 0, 0, '4,7', 0),
(15, 219, 85, '勁牌中國勁酒禮盒500ML*2', 'MDZ000085', 0, 1, '89.90', '98.00', '', 1, 1, '', 0, 0, '', 0),
(16, 219, 1, '新鮮檳榔芋頭', 'MDZ000000', 0, 3, '15.00', '12.50', '', 3, 1, '', 0, 0, '', 0),
(17, 219, 102, '新鮮豬扒肉', 'MDZ000102', 4, 1, '50.60', '35.00', '部位:小腿肉[5] \n規格:500G \n', 1, 1, '', 0, 0, '4,5', 0),
(18, 220, 102, '新鮮豬扒肉', 'MDZ000102', 1, 1, '45.60', '30.00', '部位:大腿肉 \n規格:500G \n', 1, 1, '', 0, 0, '3,5', 0),
(19, 220, 102, '新鮮豬扒肉', 'MDZ000102', 2, 1, '73.60', '58.00', '部位:大腿肉 \n規格:1000G[28] \n', 1, 1, '', 0, 0, '3,6', 0),
(20, 221, 111, '測試', 'MDZ000111', 0, 1, '0.01', '0.01', '', 0, 1, '', 0, 0, '', 0),
(21, 222, 111, '測試', 'MDZ000111', 0, 1, '0.01', '0.01', '', 0, 1, '', 0, 0, '', 0),
(22, 223, 111, '測試', 'MDZ000111', 0, 1, '0.01', '0.01', '', 0, 1, '', 0, 0, '', 0),
(23, 224, 111, '測試', 'MDZ000111', 0, 1, '0.01', '0.01', '', 0, 1, '', 0, 0, '', 0),
(24, 225, 11, '生薑', 'MDZ000011', 0, 1, '2.92', '2.44', '', 0, 1, '', 0, 0, '', 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_order_info`
--
CREATE TABLE `ecs_order_info` (
`order_id` mediumint UNSIGNED NOT NULL,
`order_sn` varchar(20) NOT NULL DEFAULT '',
`user_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`order_status` tinyint UNSIGNED NOT NULL DEFAULT '0',
`shipping_status` tinyint UNSIGNED NOT NULL DEFAULT '0',
`pay_status` tinyint UNSIGNED NOT NULL DEFAULT '0',
`consignee` varchar(60) NOT NULL DEFAULT '',
`country` smallint UNSIGNED NOT NULL DEFAULT '0',
`province` smallint UNSIGNED NOT NULL DEFAULT '0',
`city` smallint UNSIGNED NOT NULL DEFAULT '0',
`district` smallint 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 NOT NULL DEFAULT '0',
`shipping_name` varchar(120) NOT NULL DEFAULT '',
`pay_id` tinyint 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 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 NOT NULL DEFAULT '0',
`referer` varchar(255) NOT NULL DEFAULT '',
`add_time` int UNSIGNED NOT NULL DEFAULT '0',
`confirm_time` int UNSIGNED NOT NULL DEFAULT '0',
`pay_time` int UNSIGNED NOT NULL DEFAULT '0',
`shipping_time` int UNSIGNED NOT NULL DEFAULT '0',
`pack_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
`card_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
`bonus_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`invoice_no` varchar(255) NOT NULL DEFAULT '',
`extension_code` varchar(30) NOT NULL DEFAULT '',
`extension_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`to_buyer` varchar(255) NOT NULL DEFAULT '',
`pay_note` varchar(255) NOT NULL DEFAULT '',
`agency_id` smallint 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 UNSIGNED NOT NULL DEFAULT '0',
`discount` decimal(10,2) NOT NULL,
`fencheng` varchar(255) DEFAULT NULL,
`shipping_time_end` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_pack`
--
CREATE TABLE `ecs_pack` (
`pack_id` tinyint UNSIGNED NOT NULL,
`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 UNSIGNED NOT NULL DEFAULT '0',
`pack_desc` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_pack`
--
INSERT INTO `ecs_pack` (`pack_id`, `pack_name`, `pack_img`, `pack_fee`, `free_money`, `pack_desc`) VALUES
(1, '禮盒包裝', '1492983617236638435.jpg', '10.00', 180, '禮盒包裝');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_package_goods`
--
CREATE TABLE `ecs_package_goods` (
`package_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`product_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_number` smallint UNSIGNED NOT NULL DEFAULT '1',
`admin_id` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_package_goods`
--
INSERT INTO `ecs_package_goods` (`package_id`, `goods_id`, `product_id`, `goods_number`, `admin_id`) VALUES
(15, 37, 0, 1, 1),
(15, 38, 0, 1, 1),
(15, 39, 5, 1, 1),
(15, 41, 0, 1, 1),
(15, 43, 0, 1, 1),
(15, 44, 0, 1, 1),
(15, 45, 0, 1, 1);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_payment`
--
CREATE TABLE `ecs_payment` (
`pay_id` tinyint UNSIGNED NOT NULL,
`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 UNSIGNED NOT NULL DEFAULT '0',
`pay_config` text NOT NULL,
`enabled` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_cod` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_online` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_pay_log`
--
CREATE TABLE `ecs_pay_log` (
`log_id` int UNSIGNED NOT NULL,
`order_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`order_amount` decimal(10,2) UNSIGNED NOT NULL,
`order_type` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_paid` tinyint UNSIGNED NOT NULL DEFAULT '0',
`user_account_id` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_pay_log`
--
INSERT INTO `ecs_pay_log` (`log_id`, `order_id`, `order_amount`, `order_type`, `is_paid`, `user_account_id`) VALUES
(1, 161, '22.44', 0, 1, 0),
(2, 162, '15.96', 0, 0, 0),
(3, 163, '17.16', 0, 0, 0),
(4, 164, '40.00', 0, 0, 0),
(5, 165, '2.40', 0, 0, 0),
(6, 166, '1.20', 0, 0, 0),
(7, 167, '46.20', 0, 0, 0),
(8, 168, '2.46', 0, 1, 0),
(9, 168, '1.00', 0, 0, 0),
(10, 169, '1.36', 0, 0, 0),
(11, 170, '1.36', 0, 0, 0),
(12, 171, '0.86', 0, 1, 0),
(13, 172, '7.20', 0, 0, 0),
(14, 173, '137.55', 0, 0, 0),
(15, 174, '2.00', 0, 1, 0),
(16, 175, '2.20', 1, 0, 14),
(17, 176, '17.20', 0, 0, 0),
(18, 177, '2.20', 0, 1, 0),
(19, 178, '1.40', 0, 1, 0),
(20, 179, '2.20', 0, 1, 0),
(21, 180, '154.83', 0, 1, 0),
(22, 181, '1.01', 0, 1, 0),
(23, 182, '1.01', 0, 1, 0),
(24, 182, '0.00', 0, 0, 0),
(25, 183, '1.52', 0, 0, 0),
(26, 184, '0.00', 0, 0, 0),
(27, 185, '0.00', 0, 0, 0),
(28, 186, '40.49', 0, 0, 0),
(31, 189, '0.50', 0, 1, 0),
(32, 190, '5.50', 0, 1, 0),
(33, 191, '0.00', 0, 0, 0),
(34, 192, '0.50', 0, 0, 0),
(35, 193, '0.50', 0, 1, 0),
(36, 194, '0.50', 0, 1, 0),
(37, 195, '0.00', 0, 0, 0),
(38, 196, '65.00', 0, 0, 0),
(39, 168, '2.20', 0, 0, 0),
(40, 169, '1.50', 0, 0, 0),
(41, 170, '1.50', 0, 0, 0),
(42, 171, '308.00', 0, 0, 0),
(43, 172, '0.10', 0, 1, 0),
(44, 173, '0.10', 0, 0, 0),
(45, 174, '0.24', 0, 1, 0),
(46, 175, '0.10', 0, 0, 0),
(47, 176, '1.28', 0, 0, 0),
(48, 177, '0.08', 0, 1, 0),
(49, 178, '0.10', 0, 0, 0),
(50, 179, '0.10', 0, 0, 0),
(51, 180, '0.10', 0, 1, 0),
(52, 181, '0.10', 0, 1, 0),
(53, 182, '0.10', 0, 1, 0),
(54, 183, '0.20', 0, 0, 0),
(55, 184, '0.10', 0, 0, 0),
(56, 185, '0.30', 0, 1, 0),
(57, 186, '0.10', 0, 0, 0),
(60, 189, '0.20', 0, 0, 0),
(61, 190, '0.10', 0, 0, 0),
(62, 191, '0.10', 0, 1, 0),
(63, 192, '0.50', 0, 1, 0),
(64, 193, '1.00', 0, 1, 0),
(65, 194, '1.50', 0, 0, 0),
(66, 195, '0.10', 0, 0, 0),
(67, 196, '1.00', 0, 0, 0),
(68, 197, '0.10', 0, 1, 0),
(69, 198, '0.10', 0, 1, 0),
(70, 199, '0.10', 0, 1, 0),
(71, 200, '39.30', 0, 1, 0),
(72, 201, '0.10', 0, 1, 0),
(73, 202, '0.10', 0, 1, 0),
(74, 203, '0.10', 0, 1, 0),
(75, 204, '0.10', 0, 1, 0),
(76, 205, '0.10', 0, 1, 0),
(77, 206, '0.80', 0, 1, 0),
(78, 207, '39.30', 0, 1, 0),
(79, 208, '0.10', 0, 1, 0),
(80, 204, '0.00', 0, 0, 0),
(81, 209, '0.00', 0, 0, 0),
(82, 210, '148.50', 0, 1, 0),
(83, 211, '0.80', 0, 1, 0),
(84, 212, '183.00', 0, 1, 0),
(85, 210, '0.00', 0, 0, 0),
(86, 211, '0.00', 0, 0, 0),
(87, 212, '0.00', 0, 0, 0),
(88, 213, '0.00', 0, 0, 0),
(89, 214, '0.00', 0, 0, 0),
(90, 215, '29.96', 0, 0, 0),
(91, 216, '0.00', 0, 0, 0),
(92, 217, '10.00', 0, 0, 0),
(93, 218, '186.00', 0, 0, 0),
(94, 219, '0.00', 0, 0, 0),
(95, 220, '0.00', 0, 0, 0),
(96, 221, '0.01', 0, 1, 0),
(97, 222, '0.01', 0, 1, 0),
(98, 223, '0.01', 0, 1, 0),
(99, 224, '0.01', 0, 1, 0),
(100, 225, '2.44', 0, 0, 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_plugins`
--
CREATE TABLE `ecs_plugins` (
`code` varchar(30) NOT NULL DEFAULT '',
`version` varchar(10) NOT NULL DEFAULT '',
`library` varchar(255) NOT NULL DEFAULT '',
`assign` tinyint UNSIGNED NOT NULL DEFAULT '0',
`install_date` int UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_products`
--
CREATE TABLE `ecs_products` (
`product_id` mediumint UNSIGNED NOT NULL,
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_attr` varchar(50) DEFAULT NULL,
`product_sn` varchar(60) DEFAULT NULL,
`product_number` smallint UNSIGNED DEFAULT '0',
`is_check` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_products`
--
INSERT INTO `ecs_products` (`product_id`, `goods_id`, `goods_attr`, `product_sn`, `product_number`, `is_check`) VALUES
(1, 102, '3|5', 'sp000102g_p46724', 499, 1),
(2, 102, '3|6', 'sp000102g_p82663', 499, 1),
(3, 102, '3|7', 'sp000102g_p10486', 500, 1),
(4, 102, '4|5', 'sp000102g_p84240', 499, 1),
(5, 102, '4|6', 'sp000102g_p72641', 500, 1),
(6, 102, '4|7', 'sp000102g_p33214', 500, 1);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_region`
--
CREATE TABLE `ecs_region` (
`region_id` smallint UNSIGNED NOT NULL,
`parent_id` smallint UNSIGNED NOT NULL DEFAULT '0',
`region_name` varchar(120) NOT NULL DEFAULT '',
`region_type` tinyint(1) NOT NULL DEFAULT '2',
`agency_id` smallint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_region`
--
INSERT INTO `ecs_region` (`region_id`, `parent_id`, `region_name`, `region_type`, `agency_id`) VALUES
(1, 0, '台灣', 0, 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_reg_extend_info`
--
CREATE TABLE `ecs_reg_extend_info` (
`Id` int UNSIGNED NOT NULL,
`user_id` mediumint UNSIGNED NOT NULL,
`reg_field_id` int UNSIGNED NOT NULL,
`content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_reg_fields`
--
CREATE TABLE `ecs_reg_fields` (
`id` tinyint UNSIGNED NOT NULL,
`reg_field_name` varchar(60) NOT NULL,
`dis_order` tinyint UNSIGNED NOT NULL DEFAULT '100',
`display` tinyint UNSIGNED NOT NULL DEFAULT '1',
`type` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_need` tinyint UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_reg_fields`
--
INSERT INTO `ecs_reg_fields` (`id`, `reg_field_name`, `dis_order`, `display`, `type`, `is_need`) VALUES
(1, 'LINE', 0, 0, 1, 0),
(2, 'FACEBOOK', 0, 0, 1, 0),
(3, '辦公電話', 0, 0, 1, 0),
(4, '家庭電話', 0, 0, 1, 0),
(5, '手機', 0, 1, 1, 1),
(6, '密碼找回問題', 0, 0, 1, 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_role`
--
CREATE TABLE `ecs_role` (
`role_id` smallint UNSIGNED NOT NULL,
`role_name` varchar(60) NOT NULL DEFAULT '',
`action_list` text NOT NULL,
`role_describe` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_searchengine`
--
CREATE TABLE `ecs_searchengine` (
`date` date NOT NULL DEFAULT '0000-00-00',
`searchengine` varchar(20) NOT NULL DEFAULT '',
`count` mediumint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_searchengine`
--
INSERT INTO `ecs_searchengine` (`date`, `searchengine`, `count`) VALUES
('2015-12-16', 'GOOGLE ADSENSE', 1),
('2016-03-14', 'GOOGLE', 1),
('2016-03-15', 'GOOGLE', 3),
('2016-03-17', 'GOOGLE', 1),
('2016-05-16', 'GOOGLE', 9),
('2016-05-17', 'GOOGLE', 7),
('2016-05-18', 'GOOGLE', 2),
('2016-05-19', 'GOOGLE', 3),
('2016-05-20', 'GOOGLE', 4),
('2016-05-21', 'GOOGLE', 4),
('2016-05-22', 'GOOGLE', 11),
('2016-05-23', 'GOOGLE', 6),
('2016-05-24', 'GOOGLE', 6),
('2016-05-25', 'GOOGLE', 5),
('2016-05-26', 'GOOGLE', 3),
('2016-05-27', 'GOOGLE', 5),
('2016-05-28', 'GOOGLE', 3),
('2016-05-29', 'GOOGLE', 6),
('2016-05-30', 'GOOGLE', 5),
('2016-05-31', 'GOOGLE', 9),
('2016-06-01', 'GOOGLE', 6),
('2016-06-02', 'GOOGLE', 6),
('2016-06-03', 'GOOGLE', 3),
('2016-06-04', 'GOOGLE', 6),
('2016-06-05', 'GOOGLE', 3),
('2016-06-06', 'GOOGLE', 6),
('2016-06-07', 'GOOGLE', 5),
('2016-06-08', 'GOOGLE', 4),
('2016-06-09', 'GOOGLE', 13),
('2016-06-10', 'GOOGLE', 8),
('2016-06-11', 'GOOGLE', 11),
('2016-06-12', 'GOOGLE', 7),
('2016-06-13', 'GOOGLE', 5),
('2016-06-14', 'GOOGLE', 6),
('2016-06-15', 'GOOGLE', 11),
('2016-06-16', 'GOOGLE', 19),
('2016-06-17', 'GOOGLE', 7),
('2016-06-18', 'GOOGLE', 11),
('2016-06-19', 'GOOGLE', 9),
('2016-06-20', 'GOOGLE', 5),
('2016-07-28', 'GOOGLE', 300),
('2016-07-31', 'GOOGLE', 1),
('2016-08-03', 'GOOGLE', 1),
('2016-08-06', 'GOOGLE', 1),
('2016-08-08', 'GOOGLE', 4),
('2016-08-09', 'GOOGLE', 3),
('2017-05-18', 'GOOGLE', 25),
('2017-05-19', 'GOOGLE', 39),
('2017-05-20', 'GOOGLE', 13),
('2017-05-21', 'GOOGLE', 23),
('2017-05-22', 'GOOGLE', 23),
('2017-05-23', 'GOOGLE', 22),
('2017-05-24', 'GOOGLE', 32),
('2017-05-25', 'GOOGLE', 25),
('2017-05-26', 'GOOGLE', 25),
('2017-05-27', 'GOOGLE', 9),
('2017-05-27', 'SOGOU', 1),
('2017-05-28', 'GOOGLE', 20),
('2017-05-29', 'GOOGLE', 19),
('2017-05-31', 'GOOGLE', 19),
('2017-06-01', 'GOOGLE', 57),
('2017-06-02', 'GOOGLE', 84),
('2017-06-03', 'GOOGLE', 121),
('2017-06-04', 'GOOGLE', 5),
('2017-06-09', 'GOOGLE', 2),
('2017-06-10', 'GOOGLE', 19),
('2017-06-11', 'GOOGLE', 14),
('2017-06-12', 'GOOGLE', 28),
('2017-07-11', 'SOGOU', 95),
('2017-07-12', 'SOGOU', 159),
('2022-12-01', 'GOOGLE', 3),
('2022-12-02', 'GOOGLE', 4),
('2022-12-04', 'GOOGLE', 15),
('2022-12-07', 'GOOGLE', 8),
('2022-12-12', 'GOOGLE', 5);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_sessions`
--
CREATE TABLE `ecs_sessions` (
`sesskey` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`expiry` int UNSIGNED NOT NULL DEFAULT '0',
`userid` mediumint UNSIGNED NOT NULL DEFAULT '0',
`adminid` mediumint UNSIGNED NOT NULL DEFAULT '0',
`ip` char(15) NOT NULL DEFAULT '',
`user_name` varchar(60) NOT NULL,
`user_rank` tinyint NOT NULL,
`discount` decimal(3,2) NOT NULL,
`email` varchar(60) NOT NULL,
`data` char(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_sessions`
--
INSERT INTO `ecs_sessions` (`sesskey`, `expiry`, `userid`, `adminid`, `ip`, `user_name`, `user_rank`, `discount`, `email`, `data`) VALUES
('e9575d4d0c9fe92537caefa570288a29', 1671011308, 0, 1, '220.129.57.87', '0', 0, '0.00', '0', 'a:3:{s:10:\"admin_name\";s:5:\"admin\";s:11:\"action_list\";s:3:\"all\";s:10:\"last_check\";i:1670982508;}');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_sessions_data`
--
CREATE TABLE `ecs_sessions_data` (
`sesskey` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`expiry` int UNSIGNED NOT NULL DEFAULT '0',
`data` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_shipping`
--
CREATE TABLE `ecs_shipping` (
`shipping_id` tinyint UNSIGNED NOT NULL,
`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 UNSIGNED NOT NULL DEFAULT '0',
`enabled` tinyint 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 UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_shipping_area`
--
CREATE TABLE `ecs_shipping_area` (
`shipping_area_id` smallint UNSIGNED NOT NULL,
`shipping_area_name` varchar(150) NOT NULL DEFAULT '',
`shipping_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
`configure` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_shipping_area`
--
INSERT INTO `ecs_shipping_area` (`shipping_area_id`, `shipping_area_name`, `shipping_id`, `configure`) VALUES
(1, '中國', 1, 'a:3:{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:\"\";}i:2;a:2:{s:4:\"name\";s:7:\"pay_fee\";s:5:\"value\";s:0:\"\";}}'),
(2, '中國', 2, '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:\"\";}}'),
(4, '中國', 4, 'a:6:{i:0;a:2:{s:4:\"name\";s:8:\"item_fee\";s:5:\"value\";s:2:\"10\";}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:\"5\";}i:3;a:2:{s:4:\"name\";s:10:\"free_money\";s:5:\"value\";s:0:\"\";}i:4;a:2:{s:4:\"name\";s:16:\"fee_compute_mode\";s:5:\"value\";s:9:\"by_weight\";}i:5;a:2:{s:4:\"name\";s:7:\"pay_fee\";s:5:\"value\";s:0:\"\";}}'),
(5, '中國', 6, 'a:5:{i:0;a:2:{s:4:\"name\";s:8:\"item_fee\";s:5:\"value\";s:2:\"15\";}i:1;a:2:{s:4:\"name\";s:8:\"base_fee\";s:5:\"value\";s:2:\"15\";}i:2;a:2:{s:4:\"name\";s:8:\"step_fee\";s:5:\"value\";s:1:\"5\";}i:3;a:2:{s:4:\"name\";s:10:\"free_money\";s:5:\"value\";s:0:\"\";}i:4;a:2:{s:4:\"name\";s:16:\"fee_compute_mode\";s:5:\"value\";s:9:\"by_weight\";}}'),
(7, '縣內快送', 12, 'a:4:{i:0;a:2:{s:4:\"name\";s:8:\"base_fee\";s:5:\"value\";s:2:\"15\";}i:1;a:2:{s:4:\"name\";s:10:\"free_money\";s:5:\"value\";s:0:\"\";}i:2;a:2:{s:4:\"name\";s:16:\"fee_compute_mode\";s:5:\"value\";s:0:\"\";}i:3;a:2:{s:4:\"name\";s:7:\"pay_fee\";s:5:\"value\";s:0:\"\";}}'),
(8, '順豐快遞', 13, 'a:5:{i:0;a:2:{s:4:\"name\";s:8:\"item_fee\";s:5:\"value\";s:2:\"20\";}i:1;a:2:{s:4:\"name\";s:8:\"base_fee\";s:5:\"value\";s:2:\"15\";}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:10:\"free_money\";s:5:\"value\";s:3:\"100\";}i:4;a:2:{s:4:\"name\";s:16:\"fee_compute_mode\";s:5:\"value\";s:9:\"by_weight\";}}');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_shop_config`
--
CREATE TABLE `ecs_shop_config` (
`id` smallint UNSIGNED NOT NULL,
`parent_id` smallint 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 UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `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),
(90, 0, 'ecsdxt', 'group', '', '', '', 1),
(101, 1, 'shop_name', 'text', '', '', '電商', 1),
(102, 1, 'shop_title', 'text', '', '', '電商網站', 1),
(103, 1, 'shop_desc', 'text', '', '', '電商網站', 1),
(104, 1, 'shop_keywords', 'text', '', '', '', 1),
(105, 1, 'shop_country', 'manual', '', '', '1', 1),
(106, 1, 'shop_province', 'manual', '', '', '', 1),
(107, 1, 'shop_city', 'manual', '', '', '', 1),
(108, 1, 'shop_address', 'text', '', '', '', 1),
(112, 1, 'line', 'text', '', '', '', 1),
(114, 1, 'service_email', 'text', '', '', '', 1),
(115, 1, 'service_phone', 'text', '', '', '', 1),
(116, 1, 'shop_closed', 'select', '0,1', '', '0', 1),
(117, 1, 'close_comment', 'textarea', '', '', '商店盤點中，請稍後', 1),
(118, 1, 'shop_logo', 'file', '', '../themes/{$template}/images/', '../themes/mb5_com_cn/images/logo.gif', 1),
(120, 1, 'user_notice', 'textarea', '', '', '用户中心公告！', 1),
(121, 1, 'shop_notice', 'textarea', '', '', '', 1),
(122, 1, 'shop_reg_closed', 'select', '1,0', '', '0', 1),
(201, 2, 'lang', 'manual', '', '', 'zh_tw', 1),
(204, 2, 'watermark', 'file', '', '../images/', '../images/watermark.gif', 1),
(205, 2, 'watermark_place', 'select', '0,1,2,3,4,5', '', '5', 1),
(206, 2, 'watermark_alpha', 'text', '', '', '50', 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', '', '', '1', 1),
(212, 2, 'integral_percent', 'text', '', '', '100', 1),
(213, 2, 'sn_prefix', 'text', '', '', 'MDZ', 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', '', '', '1800', 1),
(220, 2, 'register_points', 'text', '', '', '5', 1),
(221, 2, 'enable_gzip', 'select', '0,1', '', '1', 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', '', '4096', 1),
(226, 2, 'cron_method', 'select', '0,1', '', '0', 1),
(227, 2, 'comment_factor', 'select', '0,1,2,3', '', '3', 1),
(228, 2, 'enable_order_check', 'select', '0,1', '', '1', 1),
(229, 2, 'default_storage', 'text', '', '', '500', 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', '', '1', 1),
(234, 2, 'retain_original_img', 'select', '1,0', '', '1', 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', '', '', '1089132730', 1),
(240, 2, 'token', 'hidden', '', '', '1d825bf072672566d6961b48d26b44378a5aff73417223d90a4a43327b17bfdc', 1),
(241, 2, 'certi', 'hidden', '', '', 'http://www.mb5.com.cn/', 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', '', '', '<font>NT$%s</font>', 1),
(304, 3, 'thumb_width', 'text', '', '', '400', 1),
(305, 3, 'thumb_height', 'text', '', '', '400', 1),
(306, 3, 'image_width', 'text', '', '', '230', 1),
(307, 3, 'image_height', 'text', '', '', '230', 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', '', '', '5', 1),
(316, 3, 'article_number', 'text', '', '', '5', 1),
(317, 3, 'goods_name_length', 'text', '', '', '30', 1),
(318, 3, 'price_format', 'select', '0,1,2,3,4,5', '', '0', 1),
(319, 3, 'page_size', 'text', '', '', '11', 1),
(320, 3, 'sort_order_type', 'select', '0,1,2', '', '0', 1),
(321, 3, 'sort_order_method', 'select', '0,1', '', '0', 1),
(322, 3, 'show_order_type', 'select', '0,1,2', '', '1', 1),
(323, 3, 'attr_related_number', 'text', '', '', '5', 1),
(324, 3, 'goods_gallery_number', 'text', '', '', '5', 1),
(325, 3, 'article_title_length', 'text', '', '', '15', 1),
(326, 3, 'name_of_region_1', 'text', '', '', '國家', 1),
(327, 3, 'name_of_region_2', 'text', '', '', '省', 1),
(328, 3, 'name_of_region_3', 'text', '', '', '市', 1),
(329, 3, 'name_of_region_4', 'text', '', '', '區', 1),
(330, 3, 'search_keywords', 'text', '', '', '', 0),
(332, 3, 'related_goods_number', 'text', '', '', '4', 1),
(333, 3, 'help_open', 'select', '0,1', '', '1', 1),
(334, 3, 'article_page_size', 'text', '', '', '5', 1),
(335, 3, 'page_style', 'select', '0,1', '', '1', 1),
(336, 3, 'recommend_order', 'select', '0,1', '', '0', 1),
(337, 3, 'index_ad', 'hidden', '', '', 'sys', 1),
(401, 4, 'can_invoice', 'select', '1,0', '', '1', 1),
(402, 4, 'use_integral', 'select', '1,0', '', '1', 1),
(403, 4, 'use_bonus', 'select', '1,0', '', '1', 1),
(404, 4, 'use_surplus', 'select', '1,0', '', '1', 1),
(405, 4, 'use_how_oos', 'select', '1,0', '', '1', 1),
(406, 4, 'send_confirm_email', 'select', '1,0', '', '0', 1),
(407, 4, 'send_ship_email', 'select', '1,0', '', '0', 1),
(408, 4, 'send_cancel_email', 'select', '1,0', '', '0', 1),
(409, 4, 'send_invalid_email', 'select', '1,0', '', '0', 1),
(410, 4, 'order_pay_note', 'select', '1,0', '', '1', 1),
(411, 4, 'order_unpay_note', 'select', '1,0', '', '1', 1),
(412, 4, 'order_ship_note', 'select', '1,0', '', '1', 1),
(413, 4, 'order_receive_note', 'select', '1,0', '', '1', 1),
(414, 4, 'order_unship_note', 'select', '1,0', '', '1', 1),
(415, 4, 'order_return_note', 'select', '1,0', '', '1', 1),
(416, 4, 'order_invalid_note', 'select', '1,0', '', '1', 1),
(417, 4, 'order_cancel_note', 'select', '1,0', '', '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:41:\"增值税普通發票(小規模納税人)\";i:1;s:38:\"增值税專用發票(一般納税人)\";i:2;s:0:\"\";}s:4:\"rate\";a:3:{i:0;d:1.5;i:1;d:3;i:2;d:0;}}', 1),
(423, 4, 'stock_dec_time', 'select', '1,0', '', '0', 1),
(424, 4, 'cart_confirm', 'options', '1,2,3,4', '', '4', 0),
(425, 4, 'send_service_email', 'select', '1,0', '', '0', 1),
(426, 4, 'show_goods_in_cart', 'select', '1,2,3', '', '3', 1),
(427, 4, 'show_attr_in_cart', 'select', '1,0', '', '1', 1),
(501, 5, 'smtp_host', 'text', '', '', 'smtp.qq.com', 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', '', '1', 0),
(508, 5, 'smtp_ssl', 'select', '0,1', '', '0', 0),
(601, 6, 'integrate_code', 'hidden', '', '', 'shop', 1),
(602, 6, 'integrate_config', 'hidden', '', '', '', 1),
(603, 6, 'hash_code', 'hidden', '', '', '2aab9f77cc5ab4694b2b6009f5785883', 1),
(604, 6, 'template', 'hidden', '', '', 'shengxian', 1),
(605, 6, 'install_date', 'hidden', '', '', '1447726949', 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:50;}s:4:\"item\";a:4:{i:0;a:2:{s:11:\"level_point\";s:3:\"60%\";s:11:\"level_money\";s:3:\"60%\";}i:1;a:2:{s:11:\"level_point\";s:3:\"30%\";s:11:\"level_money\";s:3:\"30%\";}i:2;a:2:{s:11:\"level_point\";s:2:\"7%\";s:11:\"level_money\";s:2:\"7%\";}i:3;a:2:{s:11:\"level_point\";s:2:\"3%\";s:11:\"level_money\";s:2:\"3%\";}}s:2:\"on\";i:0;}', 1),
(617, 6, 'captcha', 'hidden', '', '', '47', 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', '', '', 'dynfocus', 1),
(623, 6, 'stylename', 'hidden', '', '', '', 1),
(701, 7, 'show_goodssn', 'select', '1,0', '', '0', 1),
(702, 7, 'show_brand', 'select', '1,0', '', '1', 1),
(703, 7, 'show_goodsweight', 'select', '1,0', '', '0', 1),
(704, 7, 'show_goodsnumber', 'select', '1,0', '', '1', 1),
(705, 7, 'show_addtime', 'select', '1,0', '', '0', 1),
(706, 7, 'goodsattr_style', 'select', '1,0', '', '1', 1),
(707, 7, 'show_marketprice', 'select', '1,0', '', '1', 1),
(903, 2, 'message_check', 'select', '1,0', '', '1', 1),
(1019, 1, 'okback_time', 'text', '', '', '3', 1),
(1020, 1, 'delback_time', 'text', '', '', '3', 1),
(1021, 1, 'weixiu_time', 'text', '', '', '2', 1),
(9001, 9011, 'ecsdxt_gateway', 'options', '1,2', '', '1', 1),
(9002, 90, 'ecsdxt_user_name', 'text', '', '', 'limingsheng', 1),
(9003, 90, 'ecsdxt_pass_word', 'password', '', '', '111222', 1),
(9004, 90, 'ecsdxt_shop_mobile', 'text', '', '', '15916852053', 1),
(9005, 90, 'ecsdxt_smsgap', 'text', '', '', '60', 1),
(9006, 90, 'ecsdxt_mobile_reg', 'select', '1,0', '', '0', 1),
(9007, 90, 'ecsdxt_mobile_reg_value', 'textarea', '', '', '您的手機號：{$user_mobile}，註冊驗證碼：{$verify_code}，24小時內提交有效。感謝您的註冊！', 1),
(9008, 90, 'ecsdxt_mobile_log', 'select', '1,0', '', '0', 1),
(9009, 90, 'ecsdxt_mobile_pwd', 'select', '1,0', '', '0', 1),
(9010, 90, 'ecsdxt_mobile_pwd_value', 'textarea', '', '', '您的用户名：{$user_name}，新密碼：{$new_password}。請及時登陸修改密碼！', 1),
(9011, 90, 'ecsdxt_mobile_changepwd', 'select', '1,0', '', '0', 1),
(9012, 90, 'ecsdxt_mobile_changepwd_value', 'textarea', '', '', '您的用户名：{$user_name}，密碼已修改，新密碼：{$new_password}。請牢記新密碼！', 1),
(9013, 90, 'ecsdxt_mobile_bind', 'select', '1,0', '', '0', 1),
(9014, 90, 'ecsdxt_mobile_bind_value', 'textarea', '', '', '您的手機號：{$user_mobile}，綁定驗證碼：{$verify_code}。一天內提交有效！', 1),
(9015, 90, 'ecsdxt_mobile_cons', 'select', '1,0', '', '0', 1),
(9016, 90, 'ecsdxt_customer_registed', 'select', '1,0', '', '0', 1),
(9017, 90, 'ecsdxt_customer_registed_value', 'textarea', '', '', '您註冊的用户名：{$user_name}，密碼：{$user_pwd}。感謝您的註冊！', 1),
(9018, 90, 'ecsdxt_order_placed', 'select', '1,0', '', '0', 1),
(9019, 90, 'ecsdxt_order_placed_value', 'textarea', '', '', '您有新的訂單：{$order_sn}，收貨人：{$consignee}，電話：{$tel}，請及時確認訂單！', 1),
(9020, 90, 'ecsdxt_order_canceled', 'select', '1,0', '', '0', 1),
(9021, 90, 'ecsdxt_order_canceled_value', 'textarea', '', '', '訂單號 ：{$order_sn} 買家已取消訂單！', 1),
(9022, 90, 'ecsdxt_order_payed', 'select', '1,0', '', '0', 1),
(9023, 90, 'ecsdxt_order_payed_value', 'textarea', '', '', '訂單號 ：{$order_sn} 買家付款了。收貨人：{$consignee}，電話：{$tel}。請及時安排發貨！', 1),
(9024, 90, 'ecsdxt_order_confirm', 'select', '1,0', '', '0', 1),
(9025, 90, 'ecsdxt_order_confirm_value', 'textarea', '', '', '訂單號 ：{$order_sn} 買家已確認收貨！', 1),
(9026, 90, 'ecsdxt_customer_placed', 'select', '1,0', '', '0', 1),
(9027, 90, 'ecsdxt_customer_placed_value', 'textarea', '', '', '您的訂單：{$order_sn}，收貨人：{$consignee} 電話：{$tel}，已經成功提交。感謝您的購買！', 1),
(9028, 90, 'ecsdxt_customer_canceled', 'select', '1,0', '', '0', 1),
(9029, 90, 'ecsdxt_customer_canceled_value', 'textarea', '', '', '您的訂單：{$order_sn}，已取消！', 1),
(9030, 90, 'ecsdxt_customer_payed', 'select', '1,0', '', '0', 1),
(9031, 90, 'ecsdxt_customer_payed_value', 'textarea', '', '', '您的訂單：{$order_sn}，已於{$time}付款成功。感謝您的購買！', 1),
(9032, 90, 'ecsdxt_customer_confirm', 'select', '1,0', '', '0', 1),
(9033, 90, 'ecsdxt_customer_confirm_value', 'textarea', '', '', '您的訂單：{$order_sn}，確認收貨成功。感謝您購買與支持，歡迎您下次光臨！', 1),
(9034, 90, 'ecsdxt_order_picking', 'select', '1,0', '', '0', 1),
(9035, 90, 'ecsdxt_order_picking_value', 'textarea', '', '', '訂單號：{$order_sn} 已於{$time}配貨。如有問題請及時聯繫！', 1),
(9036, 90, 'ecsdxt_order_shipped', 'select', '1,0', '', '0', 1),
(9037, 90, 'ecsdxt_order_shipped_value', 'textarea', '', '', '訂單號：{$order_sn} 已於{$time}發貨，如有問題請及時聯繫！', 1),
(9038, 3, 'show_sales_type', 'select', '1,0', '', '0', 1);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_snatch_log`
--
CREATE TABLE `ecs_snatch_log` (
`log_id` mediumint UNSIGNED NOT NULL,
`snatch_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
`user_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`bid_price` decimal(10,2) NOT NULL DEFAULT '0.00',
`bid_time` int UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_stats`
--
CREATE TABLE `ecs_stats` (
`access_time` int UNSIGNED NOT NULL DEFAULT '0',
`ip_address` varchar(15) NOT NULL DEFAULT '',
`visit_times` smallint UNSIGNED NOT NULL DEFAULT '1',
`browser` varchar(60) NOT NULL DEFAULT '',
`os` 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 ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_stats`
--
INSERT INTO `ecs_stats` (`access_time`, `ip_address`, `visit_times`, `browser`, `os`, `language`, `area`, `referer_domain`, `referer_path`, `access_url`) VALUES
(1669822053, '220.129.48.248', 49, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', 'https://shop.h888.fun', '/category.php?id=7', '/category.php'),
(1669837792, '220.129.48.248', 50, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1669839601, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/category.php'),
(1669840299, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1669842423, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1669853561, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1669903008, '220.129.48.248', 51, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1669909374, '220.129.48.248', 52, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1669981784, '220.129.48.248', 53, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1670085443, '220.129.53.27', 54, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1670097801, '0.0.0.0', 4, 'Safari 604.1', 'Unknown', 'zh-TW,zh-Hant', 'IANA', '', '', '/index.php'),
(1670103057, '0.0.0.0', 5, 'Safari 604.1', 'Unknown', 'zh-TW,zh-Hant', 'IANA', '', '', '/index.php'),
(1670107414, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1670107936, '220.129.53.27', 1, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', 'https://shop.h888.fun', '/admin/captcha_manage.php?act=main', '/captcha.php'),
(1670121470, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1670121726, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1670123164, '123.194.170.81', 1, 'Safari 605.1.15', 'Unknown', 'zh-TW,zh-Hant', '̨??ʡ', '', '', '/index.php'),
(1670156735, '220.129.53.27', 5, 'Safari 604.1', 'Unknown', 'zh-TW,zh-Hant', '̨??ʡ', '', '', '/index.php'),
(1670180841, '220.129.53.27', 2, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1670198911, '220.129.53.27', 3, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1670244629, '220.129.53.27', 4, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', 'https://shop.h888.fun', '/admin/captcha_manage.php?act=main', '/captcha.php'),
(1670261224, '220.129.53.27', 5, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1670323283, '220.129.53.27', 6, 'Safari 604.1', 'Unknown', 'zh-TW,zh', '̨??ʡ', 'https://shop.h888.fun', '/', '/article_cat.php'),
(1670331573, '185.191.171.37', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670331989, '185.191.171.16', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670332132, '185.191.171.4', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article.php'),
(1670334315, '185.191.171.44', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article.php'),
(1670334404, '185.191.171.4', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670336955, '185.191.171.33', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670337618, '185.191.171.43', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670337655, '185.191.171.11', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670337766, '185.191.171.4', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670338963, '185.191.171.4', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670339903, '185.191.171.4', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670340338, '185.191.171.9', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article_cat.php'),
(1670340866, '185.191.171.24', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670341311, '185.191.171.18', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/goods.php'),
(1670341318, '185.191.171.16', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670342005, '220.129.68.209', 7, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1670342696, '185.191.171.38', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670343944, '185.191.171.22', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670344031, '185.191.171.36', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670345091, '185.191.171.22', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670345273, '220.129.68.209', 8, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1670346384, '185.191.171.36', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670348641, '185.191.171.19', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670349584, '185.191.171.8', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article.php'),
(1670349920, '185.191.171.34', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670351050, '220.129.68.209', 9, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', 'https://shop.h888.fun', '/user.php?act=logout', '/user.php'),
(1670351693, '185.191.171.12', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/user.php'),
(1670352442, '220.129.68.209', 10, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', 'https://shop.h888.fun', '/user.php?act=logout', '/index.php'),
(1670352629, '185.191.171.24', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670353422, '185.191.171.43', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/user.php'),
(1670355070, '185.191.171.14', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670355269, '220.129.68.209', 11, 'Safari 604.1', 'Unknown', 'zh-TW,zh', '̨??ʡ', 'https://shop.h888.fun', '/user.php?act=register', '/user.php'),
(1670355920, '185.191.171.3', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670356392, '185.191.171.40', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670356482, '185.191.171.38', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670357962, '185.191.171.36', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670358777, '185.191.171.40', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670358819, '185.191.171.37', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670359513, '185.191.171.44', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670360730, '185.191.171.44', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670361346, '185.191.171.1', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670361783, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1670362609, '185.191.171.45', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670363048, '185.191.171.20', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670363658, '185.191.171.14', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670364441, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1670365236, '185.191.171.6', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article.php'),
(1670365487, '185.191.171.20', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article.php'),
(1670367123, '185.191.171.1', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670367345, '185.191.171.40', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/index.php'),
(1670367966, '185.191.171.44', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article.php'),
(1670369917, '185.191.171.35', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670370653, '185.191.171.43', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670371189, '185.191.171.19', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670372849, '185.191.171.21', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670373249, '185.191.171.41', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/goods.php'),
(1670373717, '185.191.171.17', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670374314, '185.191.171.11', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670374856, '185.191.171.22', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670375131, '185.191.171.44', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670376240, '185.191.171.15', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670377259, '185.191.171.4', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670378111, '185.191.171.8', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670378993, '185.191.171.11', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670379660, '185.191.171.36', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670381350, '185.191.171.19', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670384351, '185.191.171.21', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670384636, '185.191.171.44', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article.php'),
(1670385062, '185.191.171.25', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670385615, '185.191.171.42', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670385895, '185.191.171.23', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670386051, '185.191.171.44', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670387364, '185.191.171.16', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670387537, '185.191.171.7', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670389588, '185.191.171.42', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670389651, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1670390005, '185.191.171.11', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670391907, '185.191.171.9', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670393893, '185.191.171.38', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670394384, '185.191.171.9', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670397657, '185.191.171.39', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670398502, '185.191.171.43', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670399466, '185.191.171.43', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670399697, '185.191.171.34', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670400196, '185.191.171.1', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670400675, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1670400784, '185.191.171.19', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article_cat.php'),
(1670401000, '185.191.171.22', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670401039, '185.191.171.26', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670402049, '185.191.171.45', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670402986, '185.191.171.36', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/user.php'),
(1670404346, '185.191.171.8', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670404439, '185.191.171.33', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670404943, '185.191.171.37', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670406806, '185.191.171.38', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670408789, '185.191.171.36', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670409724, '185.191.171.15', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670410024, '185.191.171.1', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670410750, '185.191.171.16', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670410762, '185.191.171.4', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article_cat.php'),
(1670411641, '185.191.171.21', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670415399, '185.191.171.21', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670415504, '185.191.171.8', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670415670, '185.191.171.35', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670415693, '185.191.171.19', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670416253, '185.191.171.9', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article.php'),
(1670416589, '185.191.171.23', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670416998, '185.191.171.22', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670417204, '185.191.171.12', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article.php'),
(1670417687, '185.191.171.4', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670417997, '185.191.171.16', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670418022, '185.191.171.7', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670418471, '185.191.171.43', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670419258, '185.191.171.40', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670421118, '185.191.171.41', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670423310, '185.191.171.34', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670424612, '185.191.171.37', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670425907, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1670426822, '185.191.171.44', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670427834, '185.191.171.40', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670431418, '185.191.171.20', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670432756, '185.191.171.39', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670433190, '185.191.171.20', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670433352, '185.191.171.16', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670435615, '185.191.171.44', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670435865, '185.191.171.11', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670436622, '185.191.171.24', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670438686, '185.191.171.36', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670439075, '185.191.171.41', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670439217, '185.191.171.9', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670439917, '185.191.171.23', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670440255, '185.191.171.11', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670442098, '185.191.171.9', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670443024, '185.191.171.37', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670445061, '185.191.171.38', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670446434, '185.191.171.45', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article.php'),
(1670449042, '185.191.171.10', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670449180, '185.191.171.6', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/category.php'),
(1670465890, '220.129.68.209', 12, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1670466216, '220.129.68.209', 13, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/user.php'),
(1670544519, '220.129.68.209', 14, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1670600010, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1670605839, '185.191.171.36', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/article_cat.php'),
(1670605841, '185.191.171.35', 1, 'Unknow browser', 'Unknown', '', '[δ֪IP0801]', '', '', '/index.php'),
(1670611927, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1670675656, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/article_cat.php'),
(1670843449, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/goods.php'),
(1670883365, '220.129.68.240', 15, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1670952447, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/index.php'),
(1670976423, '220.129.57.87', 16, 'Safari 537.36', 'Linux', 'zh-TW,zh', '̨??ʡ', '', '', '/index.php'),
(1670978390, '216.244.66.246', 1, 'Unknow browser', 'Unknown', '', '????', '', '', '/affiche.php');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_suppliers`
--
CREATE TABLE `ecs_suppliers` (
`suppliers_id` smallint UNSIGNED NOT NULL,
`suppliers_name` varchar(255) DEFAULT NULL,
`suppliers_desc` mediumtext,
`is_check` tinyint UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_tag`
--
CREATE TABLE `ecs_tag` (
`tag_id` mediumint NOT NULL,
`user_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`tag_words` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_template`
--
CREATE TABLE `ecs_template` (
`filename` varchar(30) NOT NULL DEFAULT '',
`region` varchar(40) NOT NULL DEFAULT '',
`library` varchar(40) NOT NULL DEFAULT '',
`sort_order` tinyint UNSIGNED NOT NULL DEFAULT '0',
`id` smallint UNSIGNED NOT NULL DEFAULT '0',
`number` tinyint UNSIGNED NOT NULL DEFAULT '5',
`type` tinyint UNSIGNED NOT NULL DEFAULT '0',
`theme` varchar(60) NOT NULL DEFAULT '',
`remarks` varchar(30) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_template`
--
INSERT INTO `ecs_template` (`filename`, `region`, `library`, `sort_order`, `id`, `number`, `type`, `theme`, `remarks`) VALUES
('index', '首頁圖片文章列表', '/library/cat_articles.lbi', 0, 16, 4, 3, 'shengxian', ''),
('index', '分類下產品區域', '/library/cat_goods.lbi', 5, 6, 8, 1, 'shengxian', ''),
('index', '分類下產品區域', '/library/cat_goods.lbi', 4, 5, 8, 1, 'shengxian', ''),
('index', '分類下產品區域', '/library/cat_goods.lbi', 3, 4, 8, 1, 'shengxian', ''),
('index', '分類下產品區域', '/library/cat_goods.lbi', 2, 3, 8, 1, 'shengxian', ''),
('index', '分類下產品區域', '/library/cat_goods.lbi', 1, 2, 8, 1, 'shengxian', ''),
('index', '分類下產品區域', '/library/cat_goods.lbi', 0, 1, 8, 1, 'shengxian', ''),
('index', '', '/library/brands.lbi', 0, 0, 16, 0, 'shengxian', ''),
('index', '', '/library/auction.lbi', 0, 0, 5, 0, 'shengxian', ''),
('index', '', '/library/group_buy.lbi', 0, 0, 5, 0, 'shengxian', ''),
('index', '', '/library/recommend_promotion.lbi', 0, 0, 5, 0, 'shengxian', ''),
('index', '', '/library/recommend_hot.lbi', 0, 0, 5, 0, 'shengxian', ''),
('index', '', '/library/recommend_new.lbi', 0, 0, 5, 0, 'shengxian', ''),
('index', '', '/library/recommend_best.lbi', 0, 0, 5, 0, 'shengxian', '');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_topic`
--
CREATE TABLE `ecs_topic` (
`topic_id` int UNSIGNED NOT NULL,
`title` varchar(255) NOT NULL DEFAULT '''''',
`intro` text NOT NULL,
`start_time` int NOT NULL DEFAULT '0',
`end_time` int 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_users`
--
CREATE TABLE `ecs_users` (
`user_id` mediumint UNSIGNED NOT NULL COMMENT '自增ID',
`aite_id` text,
`email` varchar(60) NOT NULL DEFAULT '',
`user_name` varchar(60) NOT NULL DEFAULT '' COMMENT '用戶帳號',
`password` varchar(32) NOT NULL DEFAULT '' COMMENT '用戶密碼',
`question` varchar(255) NOT NULL DEFAULT '',
`answer` varchar(255) NOT NULL DEFAULT '',
`sex` tinyint 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 UNSIGNED NOT NULL DEFAULT '0',
`rank_points` int UNSIGNED NOT NULL DEFAULT '0',
`address_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`reg_time` int UNSIGNED NOT NULL DEFAULT '0',
`last_login` int 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 UNSIGNED NOT NULL DEFAULT '0',
`user_rank` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_special` tinyint UNSIGNED NOT NULL DEFAULT '0',
`ec_salt` varchar(10) DEFAULT NULL,
`salt` varchar(10) NOT NULL DEFAULT '0',
`refer_code` varchar(20) NULL COMMENT '推薦代碼',
`parent_id` mediumint NOT NULL DEFAULT '0',
`flag` tinyint UNSIGNED NOT NULL DEFAULT '0',
`alias` varchar(60) NOT NULL DEFAULT '',
`line` varchar(60) NOT NULL DEFAULT '',
`facebook` varchar(60) NOT NULL DEFAULT '',
`office_phone` varchar(20) NOT NULL DEFAULT '',
`home_phone` varchar(20) NOT NULL DEFAULT '',
`mobile_phone` varchar(20) NOT NULL COMMENT '行動電話',
`is_validated` tinyint UNSIGNED NOT NULL DEFAULT '0',
`credit_line` decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
`passwd_question` varchar(50) DEFAULT NULL,
`passwd_answer` varchar(255) DEFAULT NULL,
`line_id` varchar(60) DEFAULT NULL COMMENT 'Line ID',
`line_name` varchar(255) DEFAULT NULL COMMENT 'Line NickName',
`line_picture` varchar(255) DEFAULT NULL COMMENT 'Line頭像'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_users_auth`
--
CREATE TABLE `ecs_users_auth` (
`id` int UNSIGNED NOT NULL,
`user_id` int UNSIGNED NOT NULL DEFAULT '0',
`user_name` varchar(60) NOT NULL,
`identity_type` varchar(32) NOT NULL,
`identifier` varchar(128) NOT NULL,
`credential` varchar(128) NOT NULL,
`verified` tinyint UNSIGNED NOT NULL DEFAULT '0',
`add_time` int UNSIGNED NOT NULL DEFAULT '0',
`update_time` int NOT NULL DEFAULT '0',
`type` tinyint(1) DEFAULT '1' COMMENT '1=PC 或者 手機'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_user_account`
--
CREATE TABLE `ecs_user_account` (
`id` mediumint UNSIGNED NOT NULL,
`user_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`admin_user` varchar(255) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`add_time` int NOT NULL DEFAULT '0',
`paid_time` int 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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_user_account`
--
INSERT INTO `ecs_user_account` (`id`, `user_id`, `admin_user`, `amount`, `add_time`, `paid_time`, `admin_note`, `user_note`, `process_type`, `payment`, `is_paid`) VALUES
(1, 245, 'admin', '-10.00', 1499140264, 1499140385, '111', '真實姓名:【黎銘生】開户行:【115645545455】銀行賬户:【農業銀行】手機:【13800138000】留言:【111】', 1, '', 1),
(2, 245, '', '-10.00', 1499231197, 0, '', '真實姓名:【黎銘生】開户行:【支付寶】銀行賬户:【15916852053】手機:【15916852053】留言:【儘快】', 1, '', 0),
(3, 245, '', '-10.00', 1499231771, 0, '', '真實姓名:【黎銘生】開户行:【微信】銀行賬户:【dglimingsheng】手機:【15916852053】留言:【哈哈哈】', 1, '', 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_user_address`
--
CREATE TABLE `ecs_user_address` (
`address_id` mediumint UNSIGNED NOT NULL,
`address_name` varchar(50) NOT NULL DEFAULT '',
`user_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`consignee` varchar(60) NOT NULL DEFAULT '',
`email` varchar(60) NOT NULL DEFAULT '',
`country` smallint NOT NULL DEFAULT '0',
`province` smallint NOT NULL DEFAULT '0',
`city` smallint NOT NULL DEFAULT '0',
`district` smallint 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 ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `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
(1, '', 245, '測試', '7828697792@qq.com', 1, 6, 79, 715, '測試測試測試測試', '', '', '13800138000', '', ''),
(2, '', 256, 'twetewt', '', 1, 2, 52, 500, 'werweqrqwr', '', '', '13333333333', '', ''),
(3, '', 257, 'aaasa', '', 1, 2, 52, 500, 'hhhhh', '', '', '13311111111', '', ''),
(4, '', 257, 'aaasa', '', 1, 2, 52, 500, 'hhhhh', '', '', '13311111111', '', ''),
(5, '', 257, 'aaasa', '', 1, 2, 52, 500, 'hhhhh', '', '', '13311111111', '', '');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_user_bonus`
--
CREATE TABLE `ecs_user_bonus` (
`bonus_id` mediumint UNSIGNED NOT NULL,
`bonus_type_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
`bonus_sn` bigint UNSIGNED NOT NULL DEFAULT '0',
`user_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`used_time` int UNSIGNED NOT NULL DEFAULT '0',
`order_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`emailed` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_user_bonus`
--
INSERT INTO `ecs_user_bonus` (`bonus_id`, `bonus_type_id`, `bonus_sn`, `user_id`, `used_time`, `order_id`, `emailed`) VALUES
(4, 2, 0, 249, 0, 0, 0),
(18, 7, 0, 249, 0, 0, 0),
(19, 7, 0, 249, 0, 0, 0),
(20, 8, 0, 249, 0, 0, 0),
(21, 10, 0, 245, 0, 0, 0),
(22, 6, 1000005095, 0, 0, 0, 0),
(23, 6, 1000018563, 0, 0, 0, 0),
(24, 6, 1000021290, 0, 0, 0, 0),
(25, 6, 1000039143, 0, 0, 0, 0),
(26, 6, 1000047250, 0, 0, 0, 0),
(27, 6, 1000054706, 0, 0, 0, 0),
(28, 6, 1000060857, 0, 0, 0, 0),
(29, 6, 1000074686, 0, 0, 0, 0),
(30, 6, 1000082709, 0, 0, 0, 0),
(31, 6, 1000096922, 0, 0, 0, 0),
(32, 6, 1000104675, 0, 0, 0, 0),
(33, 6, 1000111851, 0, 0, 0, 0),
(34, 6, 1000120884, 0, 0, 0, 0),
(35, 6, 1000138958, 0, 0, 0, 0),
(36, 6, 1000143015, 0, 0, 0, 0),
(37, 6, 1000157085, 0, 0, 0, 0),
(38, 6, 1000162363, 0, 0, 0, 0),
(39, 6, 1000176935, 0, 0, 0, 0),
(40, 6, 1000188100, 0, 0, 0, 0),
(41, 6, 1000192871, 0, 0, 0, 0),
(42, 6, 1000200844, 0, 0, 0, 0),
(43, 6, 1000215578, 0, 0, 0, 0),
(44, 6, 1000221651, 0, 0, 0, 0),
(45, 6, 1000232537, 0, 0, 0, 0),
(46, 6, 1000246840, 0, 0, 0, 0),
(47, 6, 1000258643, 0, 0, 0, 0),
(48, 6, 1000262499, 0, 0, 0, 0),
(49, 6, 1000274514, 0, 0, 0, 0),
(50, 6, 1000280014, 0, 0, 0, 0),
(51, 6, 1000293261, 0, 0, 0, 0),
(52, 6, 1000304338, 0, 0, 0, 0),
(53, 6, 1000310539, 0, 0, 0, 0),
(54, 6, 1000329245, 0, 0, 0, 0),
(55, 6, 1000335337, 0, 0, 0, 0),
(56, 6, 1000344263, 0, 0, 0, 0),
(57, 6, 1000353158, 0, 0, 0, 0),
(58, 6, 1000367777, 0, 0, 0, 0),
(59, 6, 1000378197, 0, 0, 0, 0),
(60, 6, 1000387895, 0, 0, 0, 0),
(61, 6, 1000391363, 0, 0, 0, 0),
(62, 6, 1000407715, 0, 0, 0, 0),
(63, 6, 1000415751, 0, 0, 0, 0),
(64, 6, 1000429900, 0, 0, 0, 0),
(65, 6, 1000435048, 0, 0, 0, 0),
(66, 6, 1000448090, 0, 0, 0, 0),
(67, 6, 1000459090, 0, 0, 0, 0),
(68, 6, 1000469249, 0, 0, 0, 0),
(69, 6, 1000470926, 0, 0, 0, 0),
(70, 6, 1000480040, 0, 0, 0, 0),
(71, 6, 1000499609, 0, 0, 0, 0),
(72, 6, 1000509303, 0, 0, 0, 0),
(73, 6, 1000510280, 0, 0, 0, 0),
(74, 6, 1000521556, 0, 0, 0, 0),
(75, 6, 1000531091, 0, 0, 0, 0),
(76, 6, 1000540227, 0, 0, 0, 0),
(77, 6, 1000555342, 0, 0, 0, 0),
(78, 6, 1000566308, 0, 0, 0, 0),
(79, 6, 1000573094, 0, 0, 0, 0),
(80, 6, 1000584758, 0, 0, 0, 0),
(81, 6, 1000597566, 0, 0, 0, 0),
(82, 6, 1000608339, 0, 0, 0, 0),
(83, 6, 1000617856, 0, 0, 0, 0),
(84, 6, 1000623801, 0, 0, 0, 0),
(85, 6, 1000634647, 0, 0, 0, 0),
(86, 6, 1000649331, 0, 0, 0, 0),
(87, 6, 1000658022, 0, 0, 0, 0),
(88, 6, 1000663780, 0, 0, 0, 0),
(89, 6, 1000672838, 0, 0, 0, 0),
(90, 6, 1000683494, 0, 0, 0, 0),
(91, 6, 1000696050, 0, 0, 0, 0),
(92, 6, 1000700021, 0, 0, 0, 0),
(93, 6, 1000710734, 0, 0, 0, 0),
(94, 6, 1000726868, 0, 0, 0, 0),
(95, 6, 1000733818, 0, 0, 0, 0),
(96, 6, 1000743624, 0, 0, 0, 0),
(97, 6, 1000755282, 0, 0, 0, 0),
(98, 6, 1000765019, 0, 0, 0, 0),
(99, 6, 1000772294, 0, 0, 0, 0),
(100, 6, 1000784556, 0, 0, 0, 0),
(101, 6, 1000793680, 0, 0, 0, 0),
(102, 6, 1000805428, 0, 0, 0, 0),
(103, 6, 1000818518, 0, 0, 0, 0),
(104, 6, 1000821629, 0, 0, 0, 0),
(105, 6, 1000834208, 0, 0, 0, 0),
(106, 6, 1000841524, 0, 0, 0, 0),
(107, 6, 1000854186, 0, 0, 0, 0),
(108, 6, 1000864231, 0, 0, 0, 0),
(109, 6, 1000877102, 0, 0, 0, 0),
(110, 6, 1000882689, 0, 0, 0, 0),
(111, 6, 1000898987, 0, 0, 0, 0),
(112, 6, 1000901560, 0, 0, 0, 0),
(113, 6, 1000912271, 0, 0, 0, 0),
(114, 6, 1000924507, 0, 0, 0, 0),
(115, 6, 1000939652, 0, 0, 0, 0),
(116, 6, 1000946260, 0, 0, 0, 0),
(117, 6, 1000953410, 0, 0, 0, 0),
(118, 6, 1000967176, 0, 0, 0, 0),
(119, 6, 1000979729, 0, 0, 0, 0),
(120, 6, 1000989771, 0, 0, 0, 0),
(121, 6, 1000997342, 0, 0, 0, 0),
(122, 2, 0, 256, 0, 0, 0),
(123, 2, 0, 257, 0, 0, 0),
(124, 2, 0, 258, 0, 0, 0),
(125, 2, 0, 259, 0, 0, 0),
(126, 2, 0, 260, 0, 0, 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_user_card`
--
CREATE TABLE `ecs_user_card` (
`id` int UNSIGNED NOT NULL,
`user_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`ct_id` int UNSIGNED NOT NULL DEFAULT '0',
`card_level` varchar(60) NOT NULL DEFAULT '',
`card_no` varchar(60) NOT NULL DEFAULT '',
`card_pass` varchar(60) NOT NULL DEFAULT '',
`card_status` tinyint UNSIGNED NOT NULL DEFAULT '0',
`send_type` varchar(60) NOT NULL DEFAULT '',
`add_time` int UNSIGNED NOT NULL DEFAULT '0',
`bind_time` int UNSIGNED NOT NULL DEFAULT '0',
`user_money` decimal(10,2) NOT NULL DEFAULT '0.00',
`pay_points` int UNSIGNED NOT NULL DEFAULT '0',
`rank_points` int UNSIGNED NOT NULL DEFAULT '0',
`true_name` varchar(60) NOT NULL DEFAULT '',
`address` varchar(255) NOT NULL DEFAULT '',
`mobile` varchar(60) NOT NULL DEFAULT '',
`email` varchar(60) NOT NULL DEFAULT '',
`sex` varchar(10) NOT NULL DEFAULT '',
`is_show` int UNSIGNED NOT NULL DEFAULT '0',
`des` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_user_card`
--
INSERT INTO `ecs_user_card` (`id`, `user_id`, `ct_id`, `card_level`, `card_no`, `card_pass`, `card_status`, `send_type`, `add_time`, `bind_time`, `user_money`, `pay_points`, `rank_points`, `true_name`, `address`, `mobile`, `email`, `sex`, `is_show`, `des`) VALUES
(1, 245, 1, '', 'beebee000002', '61966805', 1, '', 1499386956, 1499386977, '0.00', 0, 0, '', '', '', '', '', 1, ''),
(2, 0, 1, '', 'beebee000003', '56875223', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(3, 0, 1, '', 'beebee000004', '65048565', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(4, 0, 1, '', 'beebee000005', '46998579', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(5, 0, 1, '', 'beebee000006', '55781985', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(6, 0, 1, '', 'beebee000007', '35372549', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(7, 0, 1, '', 'beebee000008', '15664036', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(8, 0, 1, '', 'beebee000009', '49564196', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(9, 0, 1, '', 'beebee000010', '34309082', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(10, 0, 1, '', 'beebee000011', '60140673', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(11, 0, 1, '', 'beebee000012', '22300167', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(12, 0, 1, '', 'beebee000013', '45641267', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(13, 0, 1, '', 'beebee000014', '39939177', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(14, 0, 1, '', 'beebee000015', '43430965', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(15, 0, 1, '', 'beebee000016', '53551208', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(16, 0, 1, '', 'beebee000017', '13894033', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(17, 0, 1, '', 'beebee000018', '70679146', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(18, 0, 1, '', 'beebee000019', '44555615', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(19, 0, 1, '', 'beebee000020', '62597790', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(20, 0, 1, '', 'beebee000021', '84601029', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(21, 0, 1, '', 'beebee000022', '42323721', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(22, 0, 1, '', 'beebee000023', '33501303', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(23, 0, 1, '', 'beebee000024', '17011793', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(24, 0, 1, '', 'beebee000025', '37910892', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(25, 0, 1, '', 'beebee000026', '46179793', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(26, 0, 1, '', 'beebee000027', '81129407', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(27, 0, 1, '', 'beebee000028', '22457185', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(28, 0, 1, '', 'beebee000029', '53997558', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(29, 0, 1, '', 'beebee000030', '31314217', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(30, 0, 1, '', 'beebee000031', '36120987', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(31, 0, 1, '', 'beebee000032', '22533801', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(32, 0, 1, '', 'beebee000033', '37930727', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(33, 0, 1, '', 'beebee000034', '45420394', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(34, 0, 1, '', 'beebee000035', '56598995', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(35, 0, 1, '', 'beebee000036', '77720970', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(36, 0, 1, '', 'beebee000037', '43807815', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(37, 0, 1, '', 'beebee000038', '57904152', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(38, 0, 1, '', 'beebee000039', '58933680', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(39, 0, 1, '', 'beebee000040', '10156031', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(40, 0, 1, '', 'beebee000041', '45787722', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(41, 0, 1, '', 'beebee000042', '96855106', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(42, 0, 1, '', 'beebee000043', '45541880', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(43, 0, 1, '', 'beebee000044', '40075731', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(44, 0, 1, '', 'beebee000045', '23407107', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(45, 0, 1, '', 'beebee000046', '83814483', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(46, 0, 1, '', 'beebee000047', '79197680', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(47, 0, 1, '', 'beebee000048', '10788093', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(48, 0, 1, '', 'beebee000049', '24525826', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(49, 0, 1, '', 'beebee000050', '93086925', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(50, 0, 1, '', 'beebee000051', '77264384', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(51, 0, 1, '', 'beebee000052', '27364890', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(52, 0, 1, '', 'beebee000053', '98914394', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(53, 0, 1, '', 'beebee000054', '47653323', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(54, 0, 1, '', 'beebee000055', '60936833', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(55, 0, 1, '', 'beebee000056', '73926590', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(56, 0, 1, '', 'beebee000057', '99450276', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(57, 0, 1, '', 'beebee000058', '25497218', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(58, 0, 1, '', 'beebee000059', '29571605', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(59, 0, 1, '', 'beebee000060', '11939885', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(60, 0, 1, '', 'beebee000061', '24249120', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(61, 0, 1, '', 'beebee000062', '66008271', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(62, 0, 1, '', 'beebee000063', '49118177', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(63, 0, 1, '', 'beebee000064', '70603297', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(64, 0, 1, '', 'beebee000065', '67125391', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(65, 0, 1, '', 'beebee000066', '92607316', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(66, 0, 1, '', 'beebee000067', '89147706', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(67, 0, 1, '', 'beebee000068', '40677051', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(68, 0, 1, '', 'beebee000069', '35143363', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(69, 0, 1, '', 'beebee000070', '34978332', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(70, 0, 1, '', 'beebee000071', '22263016', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(71, 0, 1, '', 'beebee000072', '99468396', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(72, 0, 1, '', 'beebee000073', '86126285', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(73, 0, 1, '', 'beebee000074', '42096390', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(74, 0, 1, '', 'beebee000075', '10331063', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(75, 0, 1, '', 'beebee000076', '34192136', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(76, 0, 1, '', 'beebee000077', '42544622', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(77, 0, 1, '', 'beebee000078', '73980761', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(78, 0, 1, '', 'beebee000079', '47675279', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(79, 0, 1, '', 'beebee000080', '33401113', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(80, 0, 1, '', 'beebee000081', '82914533', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(81, 0, 1, '', 'beebee000082', '88341331', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(82, 0, 1, '', 'beebee000083', '45034878', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(83, 0, 1, '', 'beebee000084', '53614507', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(84, 0, 1, '', 'beebee000085', '49298328', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(85, 0, 1, '', 'beebee000086', '21091630', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(86, 0, 1, '', 'beebee000087', '57311457', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(87, 0, 1, '', 'beebee000088', '38029861', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(88, 0, 1, '', 'beebee000089', '18438844', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(89, 0, 1, '', 'beebee000090', '61733486', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(90, 0, 1, '', 'beebee000091', '26226413', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(91, 0, 1, '', 'beebee000092', '43427131', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(92, 0, 1, '', 'beebee000093', '66700093', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(93, 0, 1, '', 'beebee000094', '54736264', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(94, 0, 1, '', 'beebee000095', '41167332', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(95, 0, 1, '', 'beebee000096', '27704983', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(96, 0, 1, '', 'beebee000097', '40557373', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(97, 0, 1, '', 'beebee000098', '55699406', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(98, 0, 1, '', 'beebee000099', '44330052', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(99, 0, 1, '', 'beebee000100', '64051528', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, ''),
(100, 0, 1, '', 'beebee000101', '52788766', 0, '', 1499386956, 0, '100.00', 100, 100, '', '', '', '', '', 1, '');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_user_card_type`
--
CREATE TABLE `ecs_user_card_type` (
`ct_id` int UNSIGNED NOT NULL,
`ct_name` varchar(60) NOT NULL DEFAULT '',
`des` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_user_card_type`
--
INSERT INTO `ecs_user_card_type` (`ct_id`, `ct_name`, `des`) VALUES
(1, '100元卡', '');
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_user_feed`
--
CREATE TABLE `ecs_user_feed` (
`feed_id` mediumint UNSIGNED NOT NULL,
`user_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`value_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`feed_type` tinyint UNSIGNED NOT NULL DEFAULT '0',
`is_feed` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_user_rank`
--
CREATE TABLE `ecs_user_rank` (
`rank_id` tinyint UNSIGNED NOT NULL,
`rank_name` varchar(30) NOT NULL DEFAULT '',
`min_points` int UNSIGNED NOT NULL DEFAULT '0',
`max_points` int UNSIGNED NOT NULL DEFAULT '0',
`discount` tinyint UNSIGNED NOT NULL DEFAULT '0',
`show_price` tinyint UNSIGNED NOT NULL DEFAULT '1',
`special_rank` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_user_rank`
--
INSERT INTO `ecs_user_rank` (`rank_id`, `rank_name`, `min_points`, `max_points`, `discount`, `show_price`, `special_rank`) VALUES
(6, '一星用户', 1000, 1999, 95, 1, 0),
(7, '二星用户', 2000, 2999, 90, 1, 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_verifycode`
--
CREATE TABLE `ecs_verifycode` (
`id` mediumint UNSIGNED NOT NULL,
`mobile` char(12) NOT NULL,
`getip` char(15) NOT NULL,
`verifycode` char(6) NOT NULL,
`dateline` int UNSIGNED NOT NULL DEFAULT '0',
`reguid` mediumint UNSIGNED DEFAULT '0',
`regdateline` int UNSIGNED DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_virtual_card`
--
CREATE TABLE `ecs_virtual_card` (
`card_id` mediumint NOT NULL,
`goods_id` mediumint UNSIGNED NOT NULL DEFAULT '0',
`card_sn` varchar(60) NOT NULL DEFAULT '',
`card_password` varchar(60) NOT NULL DEFAULT '',
`add_date` int NOT NULL DEFAULT '0',
`end_date` int 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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_volume_price`
--
CREATE TABLE `ecs_volume_price` (
`price_type` tinyint UNSIGNED NOT NULL,
`goods_id` mediumint UNSIGNED NOT NULL,
`volume_number` smallint UNSIGNED NOT NULL DEFAULT '0',
`volume_price` decimal(10,2) NOT NULL DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_vote`
--
CREATE TABLE `ecs_vote` (
`vote_id` smallint UNSIGNED NOT NULL,
`vote_name` varchar(250) NOT NULL DEFAULT '',
`start_time` int UNSIGNED NOT NULL DEFAULT '0',
`end_time` int UNSIGNED NOT NULL DEFAULT '0',
`can_multi` tinyint UNSIGNED NOT NULL DEFAULT '0',
`vote_count` int UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 傾印資料表的資料 `ecs_vote`
--
INSERT INTO `ecs_vote` (`vote_id`, `vote_name`, `start_time`, `end_time`, `can_multi`, `vote_count`) VALUES
(2, '對商城的還滿意嗎？', 1495008000, 1496217600, 0, 0);
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_vote_log`
--
CREATE TABLE `ecs_vote_log` (
`log_id` mediumint UNSIGNED NOT NULL,
`vote_id` smallint UNSIGNED NOT NULL DEFAULT '0',
`ip_address` varchar(15) NOT NULL DEFAULT '',
`vote_time` int UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_vote_option`
--
CREATE TABLE `ecs_vote_option` (
`option_id` smallint UNSIGNED NOT NULL,
`vote_id` smallint UNSIGNED NOT NULL DEFAULT '0',
`option_name` varchar(250) NOT NULL DEFAULT '',
`option_count` int UNSIGNED NOT NULL DEFAULT '0',
`option_order` tinyint UNSIGNED NOT NULL DEFAULT '100'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- 資料表結構 `ecs_wholesale`
--
CREATE TABLE `ecs_wholesale` (
`act_id` mediumint UNSIGNED NOT NULL,
`goods_id` mediumint UNSIGNED NOT NULL,
`goods_name` varchar(255) NOT NULL,
`rank_ids` varchar(255) NOT NULL,
`prices` text NOT NULL,
`enabled` tinyint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 已傾印資料表的索引
--
--
-- 資料表索引 `ecs_account_log`
--
ALTER TABLE `ecs_account_log`
ADD PRIMARY KEY (`log_id`),
ADD KEY `user_id` (`user_id`);
--
-- 資料表索引 `ecs_ad`
--
ALTER TABLE `ecs_ad`
ADD PRIMARY KEY (`ad_id`),
ADD KEY `position_id` (`position_id`),
ADD KEY `enabled` (`enabled`);
--
-- 資料表索引 `ecs_admin_action`
--
ALTER TABLE `ecs_admin_action`
ADD PRIMARY KEY (`action_id`),
ADD KEY `parent_id` (`parent_id`);
--
-- 資料表索引 `ecs_admin_log`
--
ALTER TABLE `ecs_admin_log`
ADD PRIMARY KEY (`log_id`),
ADD KEY `log_time` (`log_time`),
ADD KEY `user_id` (`user_id`);
--
-- 資料表索引 `ecs_admin_message`
--
ALTER TABLE `ecs_admin_message`
ADD PRIMARY KEY (`message_id`),
ADD KEY `sender_id` (`sender_id`,`receiver_id`),
ADD KEY `receiver_id` (`receiver_id`);
--
-- 資料表索引 `ecs_admin_user`
--
ALTER TABLE `ecs_admin_user`
ADD PRIMARY KEY (`user_id`),
ADD KEY `user_name` (`user_name`),
ADD KEY `agency_id` (`agency_id`);
--
-- 資料表索引 `ecs_adsense`
--
ALTER TABLE `ecs_adsense`
ADD KEY `from_ad` (`from_ad`);
--
-- 資料表索引 `ecs_ad_custom`
--
ALTER TABLE `ecs_ad_custom`
ADD PRIMARY KEY (`ad_id`);
--
-- 資料表索引 `ecs_ad_position`
--
ALTER TABLE `ecs_ad_position`
ADD PRIMARY KEY (`position_id`);
--
-- 資料表索引 `ecs_affiliate_log`
--
ALTER TABLE `ecs_affiliate_log`
ADD PRIMARY KEY (`log_id`);
--
-- 資料表索引 `ecs_agency`
--
ALTER TABLE `ecs_agency`
ADD PRIMARY KEY (`agency_id`),
ADD KEY `agency_name` (`agency_name`);
--
-- 資料表索引 `ecs_area_region`
--
ALTER TABLE `ecs_area_region`
ADD PRIMARY KEY (`shipping_area_id`,`region_id`);
--
-- 資料表索引 `ecs_article`
--
ALTER TABLE `ecs_article`
ADD PRIMARY KEY (`article_id`),
ADD KEY `cat_id` (`cat_id`);
--
-- 資料表索引 `ecs_article_cat`
--
ALTER TABLE `ecs_article_cat`
ADD PRIMARY KEY (`cat_id`),
ADD KEY `cat_type` (`cat_type`),
ADD KEY `sort_order` (`sort_order`),
ADD KEY `parent_id` (`parent_id`);
--
-- 資料表索引 `ecs_attribute`
--
ALTER TABLE `ecs_attribute`
ADD PRIMARY KEY (`attr_id`),
ADD KEY `cat_id` (`cat_id`);
--
-- 資料表索引 `ecs_auction_log`
--
ALTER TABLE `ecs_auction_log`
ADD PRIMARY KEY (`log_id`),
ADD KEY `act_id` (`act_id`);
--
-- 資料表索引 `ecs_auto_manage`
--
ALTER TABLE `ecs_auto_manage`
ADD PRIMARY KEY (`item_id`,`type`);
--
-- 資料表索引 `ecs_back_action`
--
ALTER TABLE `ecs_back_action`
ADD PRIMARY KEY (`action_id`),
ADD KEY `back_id` (`back_id`);
--
-- 資料表索引 `ecs_back_goods`
--
ALTER TABLE `ecs_back_goods`
ADD PRIMARY KEY (`rec_id`),
ADD KEY `back_id` (`back_id`),
ADD KEY `goods_id` (`goods_id`);
--
-- 資料表索引 `ecs_back_order`
--
ALTER TABLE `ecs_back_order`
ADD PRIMARY KEY (`back_id`),
ADD KEY `user_id` (`user_id`),
ADD KEY `order_id` (`order_id`),
ADD KEY `goods_id` (`goods_id`);
--
-- 資料表索引 `ecs_back_replay`
--
ALTER TABLE `ecs_back_replay`
ADD PRIMARY KEY (`id`);
--
-- 資料表索引 `ecs_bonus_type`
--
ALTER TABLE `ecs_bonus_type`
ADD PRIMARY KEY (`type_id`);
--
-- 資料表索引 `ecs_booking_goods`
--
ALTER TABLE `ecs_booking_goods`
ADD PRIMARY KEY (`rec_id`),
ADD KEY `user_id` (`user_id`);
--
-- 資料表索引 `ecs_brand`
--
ALTER TABLE `ecs_brand`
ADD PRIMARY KEY (`brand_id`),
ADD KEY `is_show` (`is_show`);
--
-- 資料表索引 `ecs_card`
--
ALTER TABLE `ecs_card`
ADD PRIMARY KEY (`card_id`);
--
-- 資料表索引 `ecs_cart`
--
ALTER TABLE `ecs_cart`
ADD PRIMARY KEY (`rec_id`),
ADD KEY `session_id` (`session_id`);
--
-- 資料表索引 `ecs_cart_combo`
--
ALTER TABLE `ecs_cart_combo`
ADD PRIMARY KEY (`rec_id`),
ADD KEY `session_id` (`session_id`);
--
-- 資料表索引 `ecs_category`
--
ALTER TABLE `ecs_category`
ADD PRIMARY KEY (`cat_id`),
ADD KEY `parent_id` (`parent_id`);
--
-- 資料表索引 `ecs_cat_recommend`
--
ALTER TABLE `ecs_cat_recommend`
ADD PRIMARY KEY (`cat_id`,`recommend_type`);
--
-- 資料表索引 `ecs_collect_goods`
--
ALTER TABLE `ecs_collect_goods`
ADD PRIMARY KEY (`rec_id`),
ADD KEY `user_id` (`user_id`),
ADD KEY `goods_id` (`goods_id`),
ADD KEY `is_attention` (`is_attention`);
--
-- 資料表索引 `ecs_comment`
--
ALTER TABLE `ecs_comment`
ADD PRIMARY KEY (`comment_id`),
ADD KEY `parent_id` (`parent_id`),
ADD KEY `id_value` (`id_value`);
--
-- 資料表索引 `ecs_crons`
--
ALTER TABLE `ecs_crons`
ADD PRIMARY KEY (`cron_id`),
ADD KEY `nextime` (`nextime`),
ADD KEY `enable` (`enable`),
ADD KEY `cron_code` (`cron_code`);
--
-- 資料表索引 `ecs_delivery_goods`
--
ALTER TABLE `ecs_delivery_goods`
ADD PRIMARY KEY (`rec_id`),
ADD KEY `delivery_id` (`delivery_id`,`goods_id`),
ADD KEY `goods_id` (`goods_id`);
--
-- 資料表索引 `ecs_delivery_order`
--
ALTER TABLE `ecs_delivery_order`
ADD PRIMARY KEY (`delivery_id`),
ADD KEY `user_id` (`user_id`),
ADD KEY `order_id` (`order_id`);
--
-- 資料表索引 `ecs_email_list`
--
ALTER TABLE `ecs_email_list`
ADD PRIMARY KEY (`id`);
--
-- 資料表索引 `ecs_email_sendlist`
--
ALTER TABLE `ecs_email_sendlist`
ADD PRIMARY KEY (`id`);
--
-- 資料表索引 `ecs_error_log`
--
ALTER TABLE `ecs_error_log`
ADD PRIMARY KEY (`id`),
ADD KEY `time` (`time`);
--
-- 資料表索引 `ecs_exchange_goods`
--
ALTER TABLE `ecs_exchange_goods`
ADD PRIMARY KEY (`goods_id`);
--
-- 資料表索引 `ecs_favourable_activity`
--
ALTER TABLE `ecs_favourable_activity`
ADD PRIMARY KEY (`act_id`),
ADD KEY `act_name` (`act_name`);
--
-- 資料表索引 `ecs_feedback`
--
ALTER TABLE `ecs_feedback`
ADD PRIMARY KEY (`msg_id`),
ADD KEY `user_id` (`user_id`);
--
-- 資料表索引 `ecs_friend_link`
--
ALTER TABLE `ecs_friend_link`
ADD PRIMARY KEY (`link_id`),
ADD KEY `show_order` (`show_order`);
--
-- 資料表索引 `ecs_goods`
--
ALTER TABLE `ecs_goods`
ADD PRIMARY KEY (`goods_id`),
ADD KEY `goods_sn` (`goods_sn`),
ADD KEY `cat_id` (`cat_id`),
ADD KEY `last_update` (`last_update`),
ADD KEY `brand_id` (`brand_id`),
ADD KEY `goods_weight` (`goods_weight`),
ADD KEY `promote_end_date` (`promote_end_date`),
ADD KEY `promote_start_date` (`promote_start_date`),
ADD KEY `goods_number` (`goods_number`),
ADD KEY `sort_order` (`sort_order`);
--
-- 資料表索引 `ecs_goods_activity`
--
ALTER TABLE `ecs_goods_activity`
ADD PRIMARY KEY (`act_id`),
ADD KEY `act_name` (`act_name`,`act_type`,`goods_id`);
--
-- 資料表索引 `ecs_goods_article`
--
ALTER TABLE `ecs_goods_article`
ADD PRIMARY KEY (`goods_id`,`article_id`,`admin_id`);
--
-- 資料表索引 `ecs_goods_attr`
--
ALTER TABLE `ecs_goods_attr`
ADD PRIMARY KEY (`goods_attr_id`),
ADD KEY `goods_id` (`goods_id`),
ADD KEY `attr_id` (`attr_id`);
--
-- 資料表索引 `ecs_goods_cat`
--
ALTER TABLE `ecs_goods_cat`
ADD PRIMARY KEY (`goods_id`,`cat_id`);
--
-- 資料表索引 `ecs_goods_gallery`
--
ALTER TABLE `ecs_goods_gallery`
ADD PRIMARY KEY (`img_id`),
ADD KEY `goods_id` (`goods_id`);
--
-- 資料表索引 `ecs_goods_type`
--
ALTER TABLE `ecs_goods_type`
ADD PRIMARY KEY (`cat_id`);
--
-- 資料表索引 `ecs_group_goods`
--
ALTER TABLE `ecs_group_goods`
ADD PRIMARY KEY (`parent_id`,`goods_id`,`admin_id`);
--
-- 資料表索引 `ecs_ip_log`
--
ALTER TABLE `ecs_ip_log`
ADD PRIMARY KEY (`id`);
--
-- 資料表索引 `ecs_keywords`
--
ALTER TABLE `ecs_keywords`
ADD PRIMARY KEY (`date`,`searchengine`,`keyword`);
--
-- 資料表索引 `ecs_link_goods`
--
ALTER TABLE `ecs_link_goods`
ADD PRIMARY KEY (`goods_id`,`link_goods_id`,`admin_id`);
--
-- 資料表索引 `ecs_mail_templates`
--
ALTER TABLE `ecs_mail_templates`
ADD PRIMARY KEY (`template_id`),
ADD UNIQUE KEY `template_code` (`template_code`),
ADD KEY `type` (`type`);
--
-- 資料表索引 `ecs_member_price`
--
ALTER TABLE `ecs_member_price`
ADD PRIMARY KEY (`price_id`),
ADD KEY `goods_id` (`goods_id`,`user_rank`);
--
-- 資料表索引 `ecs_nav`
--
ALTER TABLE `ecs_nav`
ADD PRIMARY KEY (`id`),
ADD KEY `type` (`type`),
ADD KEY `ifshow` (`ifshow`);
--
-- 資料表索引 `ecs_order_action`
--
ALTER TABLE `ecs_order_action`
ADD PRIMARY KEY (`action_id`),
ADD KEY `order_id` (`order_id`);
--
-- 資料表索引 `ecs_order_goods`
--
ALTER TABLE `ecs_order_goods`
ADD PRIMARY KEY (`rec_id`),
ADD KEY `order_id` (`order_id`),
ADD KEY `goods_id` (`goods_id`);
--
-- 資料表索引 `ecs_order_info`
--
ALTER TABLE `ecs_order_info`
ADD PRIMARY KEY (`order_id`),
ADD UNIQUE KEY `order_sn` (`order_sn`),
ADD KEY `user_id` (`user_id`),
ADD KEY `order_status` (`order_status`),
ADD KEY `shipping_status` (`shipping_status`),
ADD KEY `pay_status` (`pay_status`),
ADD KEY `shipping_id` (`shipping_id`),
ADD KEY `pay_id` (`pay_id`),
ADD KEY `extension_code` (`extension_code`,`extension_id`),
ADD KEY `agency_id` (`agency_id`);
--
-- 資料表索引 `ecs_pack`
--
ALTER TABLE `ecs_pack`
ADD PRIMARY KEY (`pack_id`);
--
-- 資料表索引 `ecs_package_goods`
--
ALTER TABLE `ecs_package_goods`
ADD PRIMARY KEY (`package_id`,`goods_id`,`admin_id`,`product_id`);
--
-- 資料表索引 `ecs_payment`
--
ALTER TABLE `ecs_payment`
ADD PRIMARY KEY (`pay_id`),
ADD UNIQUE KEY `pay_code` (`pay_code`);
--
-- 資料表索引 `ecs_pay_log`
--
ALTER TABLE `ecs_pay_log`
ADD PRIMARY KEY (`log_id`);
--
-- 資料表索引 `ecs_plugins`
--
ALTER TABLE `ecs_plugins`
ADD PRIMARY KEY (`code`);
--
-- 資料表索引 `ecs_products`
--
ALTER TABLE `ecs_products`
ADD PRIMARY KEY (`product_id`);
--
-- 資料表索引 `ecs_region`
--
ALTER TABLE `ecs_region`
ADD PRIMARY KEY (`region_id`),
ADD KEY `parent_id` (`parent_id`),
ADD KEY `region_type` (`region_type`),
ADD KEY `agency_id` (`agency_id`);
--
-- 資料表索引 `ecs_reg_extend_info`
--
ALTER TABLE `ecs_reg_extend_info`
ADD PRIMARY KEY (`Id`);
--
-- 資料表索引 `ecs_reg_fields`
--
ALTER TABLE `ecs_reg_fields`
ADD PRIMARY KEY (`id`);
--
-- 資料表索引 `ecs_role`
--
ALTER TABLE `ecs_role`
ADD PRIMARY KEY (`role_id`),
ADD KEY `user_name` (`role_name`);
--
-- 資料表索引 `ecs_searchengine`
--
ALTER TABLE `ecs_searchengine`
ADD PRIMARY KEY (`date`,`searchengine`);
--
-- 資料表索引 `ecs_sessions`
--
ALTER TABLE `ecs_sessions`
ADD PRIMARY KEY (`sesskey`),
ADD KEY `expiry` (`expiry`);
--
-- 資料表索引 `ecs_sessions_data`
--
ALTER TABLE `ecs_sessions_data`
ADD PRIMARY KEY (`sesskey`),
ADD KEY `expiry` (`expiry`);
--
-- 資料表索引 `ecs_shipping`
--
ALTER TABLE `ecs_shipping`
ADD PRIMARY KEY (`shipping_id`),
ADD KEY `shipping_code` (`shipping_code`,`enabled`);
--
-- 資料表索引 `ecs_shipping_area`
--
ALTER TABLE `ecs_shipping_area`
ADD PRIMARY KEY (`shipping_area_id`),
ADD KEY `shipping_id` (`shipping_id`);
--
-- 資料表索引 `ecs_shop_config`
--
ALTER TABLE `ecs_shop_config`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `code` (`code`),
ADD KEY `parent_id` (`parent_id`);
--
-- 資料表索引 `ecs_snatch_log`
--
ALTER TABLE `ecs_snatch_log`
ADD PRIMARY KEY (`log_id`),
ADD KEY `snatch_id` (`snatch_id`);
--
-- 資料表索引 `ecs_stats`
--
ALTER TABLE `ecs_stats`
ADD KEY `access_time` (`access_time`);
--
-- 資料表索引 `ecs_suppliers`
--
ALTER TABLE `ecs_suppliers`
ADD PRIMARY KEY (`suppliers_id`);
--
-- 資料表索引 `ecs_tag`
--
ALTER TABLE `ecs_tag`
ADD PRIMARY KEY (`tag_id`),
ADD KEY `user_id` (`user_id`),
ADD KEY `goods_id` (`goods_id`);
--
-- 資料表索引 `ecs_template`
--
ALTER TABLE `ecs_template`
ADD KEY `filename` (`filename`,`region`),
ADD KEY `theme` (`theme`),
ADD KEY `remarks` (`remarks`);
--
-- 資料表索引 `ecs_topic`
--
ALTER TABLE `ecs_topic`
ADD KEY `topic_id` (`topic_id`);
--
-- 資料表索引 `ecs_users`
--
ALTER TABLE `ecs_users`
ADD PRIMARY KEY (`user_id`),
ADD UNIQUE KEY `user_name` (`user_name`),
ADD KEY `email` (`email`),
ADD KEY `parent_id` (`parent_id`),
ADD KEY `flag` (`flag`),
ADD KEY `line_id` (`line_id`),
;
--
-- 資料表索引 `ecs_users_auth`
--
ALTER TABLE `ecs_users_auth`
ADD PRIMARY KEY (`id`),
ADD KEY `identifier` (`identifier`);
--
-- 資料表索引 `ecs_user_account`
--
ALTER TABLE `ecs_user_account`
ADD PRIMARY KEY (`id`),
ADD KEY `user_id` (`user_id`),
ADD KEY `is_paid` (`is_paid`);
--
-- 資料表索引 `ecs_user_address`
--
ALTER TABLE `ecs_user_address`
ADD PRIMARY KEY (`address_id`),
ADD KEY `user_id` (`user_id`);
--
-- 資料表索引 `ecs_user_bonus`
--
ALTER TABLE `ecs_user_bonus`
ADD PRIMARY KEY (`bonus_id`),
ADD KEY `user_id` (`user_id`);
--
-- 資料表索引 `ecs_user_card`
--
ALTER TABLE `ecs_user_card`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `card_no` (`card_no`),
ADD KEY `user_id` (`user_id`);
--
-- 資料表索引 `ecs_user_card_type`
--
ALTER TABLE `ecs_user_card_type`
ADD PRIMARY KEY (`ct_id`),
ADD UNIQUE KEY `ct_name` (`ct_name`);
--
-- 資料表索引 `ecs_user_feed`
--
ALTER TABLE `ecs_user_feed`
ADD PRIMARY KEY (`feed_id`);
--
-- 資料表索引 `ecs_user_rank`
--
ALTER TABLE `ecs_user_rank`
ADD PRIMARY KEY (`rank_id`);
--
-- 資料表索引 `ecs_verifycode`
--
ALTER TABLE `ecs_verifycode`
ADD PRIMARY KEY (`id`);
--
-- 資料表索引 `ecs_virtual_card`
--
ALTER TABLE `ecs_virtual_card`
ADD PRIMARY KEY (`card_id`),
ADD KEY `goods_id` (`goods_id`),
ADD KEY `car_sn` (`card_sn`),
ADD KEY `is_saled` (`is_saled`);
--
-- 資料表索引 `ecs_volume_price`
--
ALTER TABLE `ecs_volume_price`
ADD PRIMARY KEY (`price_type`,`goods_id`,`volume_number`);
--
-- 資料表索引 `ecs_vote`
--
ALTER TABLE `ecs_vote`
ADD PRIMARY KEY (`vote_id`);
--
-- 資料表索引 `ecs_vote_log`
--
ALTER TABLE `ecs_vote_log`
ADD PRIMARY KEY (`log_id`),
ADD KEY `vote_id` (`vote_id`);
--
-- 資料表索引 `ecs_vote_option`
--
ALTER TABLE `ecs_vote_option`
ADD PRIMARY KEY (`option_id`),
ADD KEY `vote_id` (`vote_id`);
--
-- 資料表索引 `ecs_wholesale`
--
ALTER TABLE `ecs_wholesale`
ADD PRIMARY KEY (`act_id`),
ADD KEY `goods_id` (`goods_id`);
--
-- 在傾印的資料表使用自動遞增(AUTO_INCREMENT)
--
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_account_log`
--
ALTER TABLE `ecs_account_log`
MODIFY `log_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_ad`
--
ALTER TABLE `ecs_ad`
MODIFY `ad_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_admin_action`
--
ALTER TABLE `ecs_admin_action`
MODIFY `action_id` tinyint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=137;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_admin_log`
--
ALTER TABLE `ecs_admin_log`
MODIFY `log_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_admin_message`
--
ALTER TABLE `ecs_admin_message`
MODIFY `message_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_admin_user`
--
ALTER TABLE `ecs_admin_user`
MODIFY `user_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_ad_custom`
--
ALTER TABLE `ecs_ad_custom`
MODIFY `ad_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_ad_position`
--
ALTER TABLE `ecs_ad_position`
MODIFY `position_id` tinyint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID', AUTO_INCREMENT=2;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_affiliate_log`
--
ALTER TABLE `ecs_affiliate_log`
MODIFY `log_id` mediumint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_agency`
--
ALTER TABLE `ecs_agency`
MODIFY `agency_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_article`
--
ALTER TABLE `ecs_article`
MODIFY `article_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=145;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_article_cat`
--
ALTER TABLE `ecs_article_cat`
MODIFY `cat_id` smallint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_attribute`
--
ALTER TABLE `ecs_attribute`
MODIFY `attr_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_auction_log`
--
ALTER TABLE `ecs_auction_log`
MODIFY `log_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_back_action`
--
ALTER TABLE `ecs_back_action`
MODIFY `action_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_back_goods`
--
ALTER TABLE `ecs_back_goods`
MODIFY `rec_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_back_order`
--
ALTER TABLE `ecs_back_order`
MODIFY `back_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_back_replay`
--
ALTER TABLE `ecs_back_replay`
MODIFY `id` mediumint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_bonus_type`
--
ALTER TABLE `ecs_bonus_type`
MODIFY `type_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_booking_goods`
--
ALTER TABLE `ecs_booking_goods`
MODIFY `rec_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_brand`
--
ALTER TABLE `ecs_brand`
MODIFY `brand_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_card`
--
ALTER TABLE `ecs_card`
MODIFY `card_id` tinyint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_cart`
--
ALTER TABLE `ecs_cart`
MODIFY `rec_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=128;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_cart_combo`
--
ALTER TABLE `ecs_cart_combo`
MODIFY `rec_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_category`
--
ALTER TABLE `ecs_category`
MODIFY `cat_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=358;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_collect_goods`
--
ALTER TABLE `ecs_collect_goods`
MODIFY `rec_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_comment`
--
ALTER TABLE `ecs_comment`
MODIFY `comment_id` int UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_crons`
--
ALTER TABLE `ecs_crons`
MODIFY `cron_id` tinyint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_delivery_goods`
--
ALTER TABLE `ecs_delivery_goods`
MODIFY `rec_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_delivery_order`
--
ALTER TABLE `ecs_delivery_order`
MODIFY `delivery_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_email_list`
--
ALTER TABLE `ecs_email_list`
MODIFY `id` mediumint NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_email_sendlist`
--
ALTER TABLE `ecs_email_sendlist`
MODIFY `id` mediumint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_error_log`
--
ALTER TABLE `ecs_error_log`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_favourable_activity`
--
ALTER TABLE `ecs_favourable_activity`
MODIFY `act_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_feedback`
--
ALTER TABLE `ecs_feedback`
MODIFY `msg_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_friend_link`
--
ALTER TABLE `ecs_friend_link`
MODIFY `link_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_goods`
--
ALTER TABLE `ecs_goods`
MODIFY `goods_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_goods_activity`
--
ALTER TABLE `ecs_goods_activity`
MODIFY `act_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_goods_attr`
--
ALTER TABLE `ecs_goods_attr`
MODIFY `goods_attr_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_goods_gallery`
--
ALTER TABLE `ecs_goods_gallery`
MODIFY `img_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=118;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_goods_type`
--
ALTER TABLE `ecs_goods_type`
MODIFY `cat_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_ip_log`
--
ALTER TABLE `ecs_ip_log`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=275;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_mail_templates`
--
ALTER TABLE `ecs_mail_templates`
MODIFY `template_id` tinyint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_member_price`
--
ALTER TABLE `ecs_member_price`
MODIFY `price_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_nav`
--
ALTER TABLE `ecs_nav`
MODIFY `id` mediumint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_order_action`
--
ALTER TABLE `ecs_order_action`
MODIFY `action_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=241;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_order_goods`
--
ALTER TABLE `ecs_order_goods`
MODIFY `rec_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_order_info`
--
ALTER TABLE `ecs_order_info`
MODIFY `order_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=226;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_pack`
--
ALTER TABLE `ecs_pack`
MODIFY `pack_id` tinyint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_payment`
--
ALTER TABLE `ecs_payment`
MODIFY `pay_id` tinyint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_pay_log`
--
ALTER TABLE `ecs_pay_log`
MODIFY `log_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_products`
--
ALTER TABLE `ecs_products`
MODIFY `product_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_region`
--
ALTER TABLE `ecs_region`
MODIFY `region_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3409;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_reg_extend_info`
--
ALTER TABLE `ecs_reg_extend_info`
MODIFY `Id` int UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_reg_fields`
--
ALTER TABLE `ecs_reg_fields`
MODIFY `id` tinyint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_role`
--
ALTER TABLE `ecs_role`
MODIFY `role_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_shipping`
--
ALTER TABLE `ecs_shipping`
MODIFY `shipping_id` tinyint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_shipping_area`
--
ALTER TABLE `ecs_shipping_area`
MODIFY `shipping_area_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_shop_config`
--
ALTER TABLE `ecs_shop_config`
MODIFY `id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9101;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_snatch_log`
--
ALTER TABLE `ecs_snatch_log`
MODIFY `log_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_suppliers`
--
ALTER TABLE `ecs_suppliers`
MODIFY `suppliers_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_tag`
--
ALTER TABLE `ecs_tag`
MODIFY `tag_id` mediumint NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_topic`
--
ALTER TABLE `ecs_topic`
MODIFY `topic_id` int UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_users`
--
ALTER TABLE `ecs_users`
MODIFY `user_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=261;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_users_auth`
--
ALTER TABLE `ecs_users_auth`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_user_account`
--
ALTER TABLE `ecs_user_account`
MODIFY `id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_user_address`
--
ALTER TABLE `ecs_user_address`
MODIFY `address_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_user_bonus`
--
ALTER TABLE `ecs_user_bonus`
MODIFY `bonus_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=127;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_user_card`
--
ALTER TABLE `ecs_user_card`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_user_card_type`
--
ALTER TABLE `ecs_user_card_type`
MODIFY `ct_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_user_feed`
--
ALTER TABLE `ecs_user_feed`
MODIFY `feed_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_user_rank`
--
ALTER TABLE `ecs_user_rank`
MODIFY `rank_id` tinyint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_verifycode`
--
ALTER TABLE `ecs_verifycode`
MODIFY `id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_virtual_card`
--
ALTER TABLE `ecs_virtual_card`
MODIFY `card_id` mediumint NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_vote`
--
ALTER TABLE `ecs_vote`
MODIFY `vote_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_vote_log`
--
ALTER TABLE `ecs_vote_log`
MODIFY `log_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_vote_option`
--
ALTER TABLE `ecs_vote_option`
MODIFY `option_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_wholesale`
--
ALTER TABLE `ecs_wholesale`
MODIFY `act_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;
/*!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 */;
Reference in new issue View Git Blame Copy Permalink