bnbweb/db.sql

-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- 主機： localhost
-- 產生時間： 2024 年 07 月 13 日 10:10
-- 伺服器版本： 8.0.24
-- PHP 版本： 7.2.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 資料庫： `nantoubnb`
--

-- --------------------------------------------------------

--
-- 資料表結構 `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(40) NOT NULL DEFAULT '',
  `relevance` varchar(40) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- 傾印資料表的資料 `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', ''),
(9, 0, 'templates_manage', ''),
(10, 0, 'db_manage', ''),
(11, 0, 'sms_manage', ''),
(21, 1, 'games_manage', ''),
(22, 1, 'remove_back', ''),
(23, 1, 'cat_manage', ''),
(24, 1, 'cat_drop', 'cat_manage'),
(30, 2, 'article_cat', ''),
(31, 2, 'article_manage', ''),
(32, 2, 'shopinfo_manage', ''),
(33, 2, 'shophelp_manage', ''),
(35, 7, 'topic_manage', ''),
(74, 4, 'template_manage', ''),
(40, 3, 'users_manage', ''),
(41, 3, 'users_drop', 'users_manage'),
(42, 3, 'user_rank', ''),
(85, 3, 'surplus_manage', 'account_manage'),
(43, 4, 'admin_manage', ''),
(44, 4, 'admin_drop', 'admin_manage'),
(45, 4, 'allot_priv', 'admin_manage'),
(46, 4, 'logs_manage', ''),
(47, 4, 'logs_drop', 'logs_manage'),
(48, 5, 'shop_config', ''),
(50, 5, 'payment', ''),
(51, 5, 'shiparea_manage', ''),
(52, 5, 'area_manage', ''),
(53, 6, 'od_transfer_manage', ''),
(54, 6, 'od_withdraw_manage', ''),
(55, 6, 'od_deposit_manage', ''),
(61, 6, 'sale_order_stats', ''),
(62, 6, 'client_flow_stats', ''),
(83, 7, 'ad_manage', ''),
(79, 7, 'bonus_manage', ''),
(75, 5, 'friendlink', ''),
(76, 5, 'db_backup', ''),
(77, 5, 'db_renew', 'db_backup'),
(87, 3, 'account_manage', ''),
(88, 5, 'flash_manage', ''),
(89, 5, 'navigator', ''),
(92, 7, 'favourable', ''),
(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', ''),
(109, 5, 'sitemap', ''),
(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', ''),
(124, 11, 'sms_send', ''),
(131, 5, 'reg_fields', ''),
(133, 5, 'webcollect_manage', ''),
(135, 4, 'role_manage', ''),
(136, 2, 'news_manage', ''),
(137, 2, 'marq_manage', ''),
(138, 6, 'od_deposit_edit', 'od_deposit_manage'),
(139, 6, 'od_withdraw_edit', 'od_withdraw_manage'),
(140, 6, 'od_transfer_edit', 'od_transfer_manage'),
(141, 1, 'games_view', ''),
(142, 0, 'finance', ''),
(143, 142, 'user_account_report', ''),
(144, 142, 'user_winorlose_report', '');

-- --------------------------------------------------------

--
-- 資料表結構 `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=MyISAM DEFAULT CHARSET=utf8mb3;


-- --------------------------------------------------------

--
-- 資料表結構 `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,
  `nav_list` text,
  `lang_type` varchar(50) NOT NULL DEFAULT '',
  `agency_id` smallint UNSIGNED NOT NULL DEFAULT '0',
  `suppliers_id` smallint UNSIGNED DEFAULT '0',
  `todolist` longtext,
  `role_id` smallint DEFAULT NULL,
  `passport_uid` varchar(20) NOT NULL DEFAULT '',
  `yq_create_time` smallint NOT NULL DEFAULT '0',
  `tawk_id` varbinary(100) NOT NULL DEFAULT '',
  `tawk_pwd` varbinary(100) NOT NULL DEFAULT '',
  `on_duty` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- 傾印資料表的資料 `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`, `passport_uid`, `yq_create_time`, `tawk_id`, `tawk_pwd`, `on_duty`) VALUES
(1, 'root', '', 'c3df28bc43581f946a731340b01eeb31', '3277', 1573097843, 1594462869, '203.204.185.20', 'all', '會員清單|users.php?act=list', '', 0, 0, NULL, 2, '', 0, '', '', 0),
(2, 'admin', '', '915c8db09a9a7e1712486095601f9b32', '975', 1491821305, 1720836043, '220.129.6.52', 'all', '會員清單|users.php?act=list,入口清單|portal.php?act=list', '', 0, 0, NULL, NULL, '', 0, 0x253218bb2931752bdadcd34831d236ac, 0x253218bb2931752bdadcd34831d236ac, 0);

-- --------------------------------------------------------

--
-- 資料表結構 `ecs_facility`
--

CREATE TABLE `ecs_facility` (
  `id` smallint NOT NULL,
  `name` varchar(90) NOT NULL DEFAULT '',
  `image` varchar(255) NOT NULL DEFAULT '',
  `sort_order` tinyint NOT NULL DEFAULT '0',
  `is_show` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- 傾印資料表的資料 `ecs_facility`
--

INSERT INTO `ecs_facility` (`id`, `name`, `image`, `sort_order`, `is_show`) VALUES
(1, '浴缸', 'images/202009/1599447930910111203.png', 50, 1),
(2, '客房', 'images/202009/1599447970382201544.png', 50, 1),
(3, '空調', 'images/202009/1599447994997277276.png', 50, 1),
(4, '液晶電視', 'images/202009/1599448018745282681.png', 50, 1),
(5, '無線網路', 'images/202009/1599448043707823113.png', 50, 1),
(6, '淋浴', 'images/202009/1599448061513098718.png', 50, 1),
(7, '盥洗用品', 'images/202009/1599448128479781609.png', 50, 1),
(8, '吹風機', 'images/202009/1599448142591534241.png', 50, 1),
(9, '牙膏牙刷', 'images/202009/1599448166425726420.png', 50, 1),
(10, '毛巾浴巾', 'images/202009/1599448186790602719.png', 50, 1),
(11, '免洗脫鞋', 'images/202009/1599448211441193761.png', 50, 1),
(12, '熨斗', 'images/202009/1599448237635937708.png', 50, 1),
(13, '充電器', 'images/202009/1599448251138203737.png', 50, 1),
(14, '鬧鐘', 'images/202009/1599448270529911216.png', 50, 1),
(15, '洗衣機', 'images/202009/1599448288058431892.png', 50, 1),
(16, '冰箱', 'images/202009/1599448307299865278.png', 50, 1),
(17, '電話', 'images/202009/1599448334895995805.png', 50, 1),
(18, '免費早餐', 'images/202009/1599448358343381653.png', 50, 1),
(19, '卡拉OK', 'images/202009/1599448374950599448.png', 50, 1),
(20, '麻將', 'images/202009/1599448398357031025.png', 50, 1),
(21, '電梯', 'images/202009/1599448410952201664.png', 50, 1),
(22, '餐廳', 'images/202009/1599448433703345195.png', 50, 1),
(23, '吧台', 'images/202009/1599448444302556380.png', 50, 1),
(24, '停車場', 'images/202009/1599448468963870869.png', 50, 1),
(25, '游泳池', 'images/202009/1599448489911253267.png', 50, 1),
(26, '烤肉場地', 'images/202009/1599448506919043659.png', 50, 1),
(27, '寵物有善', 'images/202009/1599448524473792353.png', 50, 1),
(28, '親子友善', 'images/202009/1599448546858767696.png', 50, 1),
(29, '禁止吸菸', 'images/202009/1599448568750873395.png', 50, 1),
(30, '露營', 'images/202110/1635234561226467800.png', 50, 1),
(32, '戲水池', 'images/202110/1635234599746435036.png', 50, 1);

-- --------------------------------------------------------

--
-- 資料表結構 `ecs_hs_gallery`
--

CREATE TABLE `ecs_hs_gallery` (
  `img_id` mediumint UNSIGNED NOT NULL,
  `hs_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 '',
  `hs_attr_id` int UNSIGNED NOT NULL DEFAULT '0',
  `is_attr_image` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `img_sort` tinyint NOT NULL DEFAULT '0' COMMENT '商品图片显示顺序'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- 資料表結構 `ecs_hs_news`
--

CREATE TABLE `ecs_hs_news` (
  `id` mediumint UNSIGNED NOT NULL,
  `hs_id` mediumint NOT NULL,
  `subject` varchar(255) NOT NULL DEFAULT '',
  `content` text,
  `image` varchar(255) NOT NULL DEFAULT '',
  `start_time` date DEFAULT '0000-00-00',
  `end_time` date DEFAULT '0000-00-00',
  `cstamp` int DEFAULT NULL,
  `ustamp` int DEFAULT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- 資料表結構 `ecs_hs_room`
--

CREATE TABLE `ecs_hs_room` (
  `id` mediumint UNSIGNED NOT NULL,
  `hs_id` mediumint NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `price` varchar(255) NOT NULL DEFAULT '',
  `intro` text,
  `notice` text,
  `image1` varchar(255) NOT NULL DEFAULT '',
  `cstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ustamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sort_order` int NOT NULL DEFAULT '0',
  `enable` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- 資料表結構 `ecs_hs_web`
--

CREATE TABLE `ecs_hs_web` (
  `id` mediumint UNSIGNED NOT NULL,
  `hs_id` mediumint NOT NULL,
  `domain` varchar(255) NOT NULL DEFAULT '',
  `cname` varchar(255) NOT NULL DEFAULT '',
  `ename` varchar(255) NOT NULL DEFAULT '',
  `tel` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `address` varchar(255) NOT NULL DEFAULT '',
  `facebook` varchar(100) NOT NULL DEFAULT '',
  `line` varchar(100) NOT NULL DEFAULT '' COMMENT 'Line連結',
  `banner_text` varchar(255) NOT NULL DEFAULT '',
  `slogon` varchar(255) NOT NULL DEFAULT '',
  `index_banner` varchar(255) NOT NULL DEFAULT '',
  `index_ytb` varchar(255) NOT NULL DEFAULT '',
  `vrmap` text,
  `vrmap2` text,
  `location_map` text,
  `location_desc` text,
  `aboutus` text,
  `mdesc` varchar(255) NOT NULL DEFAULT '',
  `mkeyword` varchar(255) NOT NULL DEFAULT '',
  `logo` varchar(255) NOT NULL DEFAULT '',
  `slogo` varchar(255) NOT NULL DEFAULT '',
  `inbanner` varchar(255) NOT NULL DEFAULT '',
  `about_image` varchar(255) NOT NULL DEFAULT '',
  `image1` varchar(255) NOT NULL DEFAULT '',
  `image2` varchar(255) NOT NULL DEFAULT '',
  `image3` varchar(255) NOT NULL DEFAULT '',
  `image4` varchar(255) NOT NULL DEFAULT '',
  `images` varchar(255) NOT NULL DEFAULT '',
  `ad_text2` text,
  `facility` text,
  `rm_fac` int NOT NULL DEFAULT '0',
  `cstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ustamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cf_iden` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- 傾印資料表的資料 `ecs_hs_web`
--

-- --------------------------------------------------------

--
-- 資料表結構 `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=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- 資料表結構 `ecs_portal`
--

CREATE TABLE `ecs_portal` (
  `id` smallint UNSIGNED NOT NULL,
  `name` varchar(90) NOT NULL DEFAULT '',
  `domain` varchar(255) NOT NULL DEFAULT '',
  `mtitle` varchar(255) NOT NULL DEFAULT '',
  `mkeyword` text,
  `mdesc` text,
  `logo` varchar(255) NOT NULL DEFAULT '',
  `slogo` varchar(255) NOT NULL DEFAULT '',
  `type` tinyint NOT NULL DEFAULT '1',
  `cf_iden` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;


-- --------------------------------------------------------

--
-- 資料表結構 `ecs_rm_gallery`
--

CREATE TABLE `ecs_rm_gallery` (
  `img_id` mediumint UNSIGNED NOT NULL,
  `rm_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 '',
  `img_sort` tinyint NOT NULL DEFAULT '0' COMMENT '商品图片显示顺序'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;


--
-- 資料表結構 `ecs_role`
--

CREATE TABLE `ecs_role` (
  `role_id` smallint UNSIGNED NOT NULL,
  `role_name` varchar(60) NOT NULL DEFAULT '',
  `action_list` text,
  `role_describe` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- 傾印資料表的資料 `ecs_role`
--

INSERT INTO `ecs_role` (`role_id`, `role_name`, `action_list`, `role_describe`) VALUES
(1, '客服人員', 'goods_manage,remove_back,cat_manage,cat_drop,shopinfo_manage,shophelp_manage,news_manage,marq_manage,users_manage,users_drop,user_rank,surplus_manage,account_manage,template_manage,admin_manage,admin_drop,allot_priv,logs_manage,logs_drop,role_manage,shop_config,payment,shiparea_manage,area_manage,friendlink,flash_manage,navigator,cron,affiliate,affiliate_ck,sitemap,reg_fields,webcollect_manage,od_transfer_manage,od_withdraw_manage,od_deposit_manage,sale_order_stats,client_flow_stats,topic_manage,ad_manage,bonus_manage,favourable,sms_send', '客服人員   '),
(2, '系統管理員', 'goods_manage,remove_back,cat_manage,cat_drop,article_cat,article_manage,shopinfo_manage,shophelp_manage,article_auto,news_manage,marq_manage,users_manage,users_drop,user_rank,surplus_manage,account_manage,template_manage,admin_manage,admin_drop,allot_priv,logs_manage,logs_drop,role_manage,shop_config,payment,shiparea_manage,area_manage,friendlink,db_backup,db_renew,flash_manage,navigator,cron,affiliate,affiliate_ck,sitemap,reg_fields,webcollect_manage,od_transfer_manage,od_withdraw_manage,od_deposit_manage,order_edit,order_view,order_view_finished,repay_manage,booking,sale_order_stats,client_flow_stats,delivery_view,back_view,topic_manage,ad_manage,bonus_manage,favourable,template_select,template_setup,library_manage,lang_edit,backup_setting,mail_template,db_backup,db_renew,db_optimize,sms_send', '系統管理員 '),
(3, '管理人員', 'goods_manage,remove_back,cat_manage,cat_drop,article_cat,article_manage,shopinfo_manage,shophelp_manage,article_auto,news_manage,marq_manage,users_manage,users_drop,user_rank,surplus_manage,account_manage,template_manage,admin_manage,admin_drop,allot_priv,logs_manage,logs_drop,role_manage,shop_config,payment,shiparea_manage,area_manage,friendlink,db_backup,db_renew,flash_manage,navigator,cron,affiliate,affiliate_ck,sitemap,reg_fields,webcollect_manage,od_transfer_manage,od_withdraw_manage,od_deposit_manage,order_edit,order_view,order_view_finished,repay_manage,booking,sale_order_stats,client_flow_stats,delivery_view,back_view,topic_manage,ad_manage,bonus_manage,favourable,template_select,template_setup,library_manage,lang_edit,backup_setting,mail_template,db_backup,db_renew,db_optimize,sms_send', '管理人員  ');

-- --------------------------------------------------------

--
-- 資料表結構 `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',
  `agentid` mediumint NOT NULL DEFAULT '0',
  `adminid` mediumint UNSIGNED NOT NULL DEFAULT '0',
  `ip` char(15) NOT NULL DEFAULT '',
  `user_name` varchar(60) NOT NULL DEFAULT '',
  `user_rank` tinyint NOT NULL DEFAULT '0',
  `discount` decimal(3,2) NOT NULL DEFAULT '0.00',
  `email` varchar(60) NOT NULL DEFAULT '',
  `data` char(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- 資料表結構 `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=MyISAM DEFAULT CHARSET=utf8mb3;


--
-- 資料表結構 `ecs_shop_config`
--

CREATE TABLE `ecs_shop_config` (
  `id` smallint UNSIGNED NOT NULL,
  `parent_id` smallint UNSIGNED NOT NULL DEFAULT '0',
  `code` varchar(50) 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,
  `sort_order` tinyint UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- 傾印資料表的資料 `ecs_shop_config`
--

INSERT INTO `ecs_shop_config` (`id`, `parent_id`, `code`, `type`, `store_range`, `store_dir`, `value`, `sort_order`) VALUES
(2, 0, 'basic', 'group', '', '', '', 1),
(6, 0, 'hidden', 'hidden', '', '', '', 1),
(210, 2, 'expire_day', 'text', '', '', '7', 1),
(601, 6, 'integrate_code', 'hidden', '', '', 'ecshop', 1),
(602, 6, 'integrate_config', 'hidden', '', '', '', 1),
(603, 6, 'hash_code', 'hidden', '', '', 'e2e4a5689a1db1e1480182ae14e3d65e', 1),
(604, 6, 'template', 'hidden', '', '', 'vr', 1),
(605, 6, 'install_date', 'hidden', '', '', '1491803307', 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:3:\"10%\";s:18:\"level_register_all\";i:500;s:17:\"level_register_up\";i:500000;}s:4:\"item\";a:3:{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:3:\"10%\";s:11:\"level_money\";s:3:\"10%\";}}s:2:\"on\";i:1;}', 1),
(617, 6, 'captcha', 'hidden', '', '', '9', 1),
(618, 6, 'captcha_width', 'hidden', '', '', '65', 1),
(619, 6, 'captcha_height', 'hidden', '', '', '30', 1),
(620, 6, 'sitemap', 'hidden', '', '', 'a:6:{s:19:\"homepage_changefreq\";s:6:\"always\";s:17:\"homepage_priority\";s:1:\"1\";s:19:\"category_changefreq\";s:6:\"always\";s:17:\"category_priority\";s:1:\"1\";s:18:\"content_changefreq\";s:6:\"always\";s:16:\"content_priority\";s:1:\"1\";}', 0),
(621, 6, 'points_rule', 'hidden', '', '', '', 0),
(622, 6, 'flash_theme', 'hidden', '', '', 'default', 1),
(623, 6, 'stylename', 'hidden', '', '', '', 1),
(9058, 2, 'cf_api_key', 'text', '', '', 'aa5f24dcd03807bf386b7545040a1fdcbf3cb', 1),
(9059, 2, 'cf_domain', 'text', '', '', 'nantoubnb.com.tw', 1),
(9060, 2, 'cf_email', 'text', '', '', '510@cityagogo.com.tw', 1),
(9061, 2, 'cf_ip', 'text', '', '', '149.248.5.15', 1),
(9057, 2, 'cf_site_id', 'text', '', '', 'f0abf130c2c1cedd4578983388c8caa8', 1),
(9062, 2, 'footer_text', 'textarea', '', '', '<ul class=\"hotelsInfo\" clearfix\">\r\n<li>\r\n<h3><a href=\"https://www.yilanbnb.com.tw\" target=\"_blank\" style=\"color: #242734;\">宜蘭好宿網｜宜蘭民宿推薦</a></h3>\r\n<p class=\"information\">民宿刊登專線<br>電話：02-66008966<br>傳真：02-66003683</p>\r\n</li>\r\n<li>\r\n<h3><a href=\"https://www.ryukyubnb.com.tw\" target=\"_blank\" style=\"color: #242734;\">小琉球好宿網｜小琉球民宿推薦</a></h3>\r\n<p class=\"information\">民宿刊登專線<br>電話：02-66008966<br>傳真：02-66003683</p>\r\n</li>\r\n<li>\r\n<h3><a href=\"https://www.thmbnb.com.tw\" target=\"_blank\" style=\"color: #242734;\">桃竹苗好宿網｜桃竹苗民宿推薦</a></h3>\r\n<p class=\"information\">民宿刊登專線<br>電話：02-66008966<br>傳真：02-66003683</p>\r\n</li>\r\n<li>\r\n<h3><a href=\"https://www.hualienbnb.com.tw\" target=\"_blank\" style=\"color: #242734;\">花蓮好宿網｜花蓮民宿推薦</a></h3>\r\n<p class=\"information\">民宿刊登專線<br>電話：02-66008966<br>傳真：02-66003683</p>\r\n</li>\r\n</ul>', 1);

-- --------------------------------------------------------

--
-- 資料表結構 `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=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- 資料表結構 `ecs_users`
--

CREATE TABLE `ecs_users` (
  `user_id` mediumint UNSIGNED NOT NULL,
  `user_name` varchar(60) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `tel` varchar(50) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `address` varchar(255) NOT NULL DEFAULT '',
  `reg_time` int UNSIGNED NOT NULL DEFAULT '0',
  `last_login` int UNSIGNED NOT NULL DEFAULT '0',
  `last_time` datetime DEFAULT NULL,
  `last_ip` varchar(50) NOT NULL DEFAULT '',
  `ec_salt` varchar(10) DEFAULT NULL,
  `salt` varchar(10) NOT NULL DEFAULT '0',
  `flag` varchar(10) DEFAULT '',
  `alias` varchar(60) NOT NULL DEFAULT '',
  `status` int NOT NULL DEFAULT '0',
  `image1` varchar(255) NOT NULL DEFAULT '',
  `image2` varchar(255) NOT NULL DEFAULT '',
  `image3` varchar(255) NOT NULL DEFAULT '',
  `note` text,
  `enable` tinyint NOT NULL DEFAULT '0',
  `expire` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;


--
-- 資料表結構 `ecs_user_ad`
--

CREATE TABLE `ecs_user_ad` (
  `id` mediumint UNSIGNED NOT NULL,
  `user_id` mediumint UNSIGNED NOT NULL,
  `pt_id` mediumint NOT NULL DEFAULT '0',
  `block` int NOT NULL DEFAULT '0',
  `cstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `dstamp` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

尸--
-- 資料表結構 `ecs_user_log`
--

CREATE TABLE `ecs_user_log` (
  `log_id` int UNSIGNED NOT NULL,
  `log_time` int UNSIGNED NOT NULL DEFAULT '0',
  `user_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `log_type` tinyint(1) NOT NULL DEFAULT '0',
  `log_info` varchar(255) NOT NULL DEFAULT '',
  `ip_address` varchar(15) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- 已傾印資料表的索引
--

--
-- 資料表索引 `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_user`
--
ALTER TABLE `ecs_admin_user`
  ADD PRIMARY KEY (`user_id`),
  ADD KEY `user_name` (`user_name`),
  ADD KEY `agency_id` (`agency_id`);

--
-- 資料表索引 `ecs_facility`
--
ALTER TABLE `ecs_facility`
  ADD PRIMARY KEY (`id`);

--
-- 資料表索引 `ecs_hs_gallery`
--
ALTER TABLE `ecs_hs_gallery`
  ADD PRIMARY KEY (`img_id`),
  ADD KEY `hs_id` (`hs_id`,`hs_attr_id`);

--
-- 資料表索引 `ecs_hs_news`
--
ALTER TABLE `ecs_hs_news`
  ADD PRIMARY KEY (`id`);

--
-- 資料表索引 `ecs_hs_room`
--
ALTER TABLE `ecs_hs_room`
  ADD PRIMARY KEY (`id`);

--
-- 資料表索引 `ecs_hs_web`
--
ALTER TABLE `ecs_hs_web`
  ADD PRIMARY KEY (`id`);

--
-- 資料表索引 `ecs_plugins`
--
ALTER TABLE `ecs_plugins`
  ADD PRIMARY KEY (`code`);

--
-- 資料表索引 `ecs_portal`
--
ALTER TABLE `ecs_portal`
  ADD PRIMARY KEY (`id`);

--
-- 資料表索引 `ecs_rm_gallery`
--
ALTER TABLE `ecs_rm_gallery`
  ADD PRIMARY KEY (`img_id`),
  ADD KEY `rm_id` (`rm_id`);

--
-- 資料表索引 `ecs_role`
--
ALTER TABLE `ecs_role`
  ADD PRIMARY KEY (`role_id`),
  ADD KEY `user_name` (`role_name`);

--
-- 資料表索引 `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_shop_config`
--
ALTER TABLE `ecs_shop_config`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `parent_id` (`parent_id`);

--
-- 資料表索引 `ecs_users`
--
ALTER TABLE `ecs_users`
  ADD PRIMARY KEY (`user_id`),
  ADD UNIQUE KEY `user_name` (`user_name`),
  ADD KEY `flag` (`flag`);

--
-- 資料表索引 `ecs_user_ad`
--
ALTER TABLE `ecs_user_ad`
  ADD PRIMARY KEY (`id`);

--
-- 資料表索引 `ecs_user_log`
--
ALTER TABLE `ecs_user_log`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `log_time` (`log_time`),
  ADD KEY `user_id` (`user_id`);

--
-- 在傾印的資料表使用自動遞增(AUTO_INCREMENT)
--

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_admin_action`
--
ALTER TABLE `ecs_admin_action`
  MODIFY `action_id` tinyint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=145;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_admin_log`
--
ALTER TABLE `ecs_admin_log`
  MODIFY `log_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_admin_user`
--
ALTER TABLE `ecs_admin_user`
  MODIFY `user_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_facility`
--
ALTER TABLE `ecs_facility`
  MODIFY `id` smallint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_hs_gallery`
--
ALTER TABLE `ecs_hs_gallery`
  MODIFY `img_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_hs_news`
--
ALTER TABLE `ecs_hs_news`
  MODIFY `id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_hs_room`
--
ALTER TABLE `ecs_hs_room`
  MODIFY `id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_hs_web`
--
ALTER TABLE `ecs_hs_web`
  MODIFY `id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_portal`
--
ALTER TABLE `ecs_portal`
  MODIFY `id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_rm_gallery`
--
ALTER TABLE `ecs_rm_gallery`
  MODIFY `img_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_role`
--
ALTER TABLE `ecs_role`
  MODIFY `role_id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_shop_config`
--
ALTER TABLE `ecs_shop_config`
  MODIFY `id` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9063;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_users`
--
ALTER TABLE `ecs_users`
  MODIFY `user_id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_user_ad`
--
ALTER TABLE `ecs_user_ad`
  MODIFY `id` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

--
-- 使用資料表自動遞增(AUTO_INCREMENT) `ecs_user_log`
--
ALTER TABLE `ecs_user_log`
  MODIFY `log_id` int 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 */;