-- http://www.phpmyadmin.net
--




--
-- Database: `youbeauty_demo`
--

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

--
-- Table structure for table `attachment`
--

CREATE TABLE `attachment` (
  `a_id` bigint(20) UNSIGNED NOT NULL,
  `a_upload_id` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `a_crt_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `a_crt_ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `a_crt_usr_id` bigint(20) NOT NULL,
  `a_mod_dt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `a_mod_ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `a_mod_usr_id` bigint(20) NOT NULL,
  `a_sort_id` bigint(20) NOT NULL,
  `a_ref_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `a_ref_id` bigint(20) NOT NULL,
  `a_title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `a_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `a_path` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `a_file_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `a_file_size` int(10) UNSIGNED NOT NULL,
  `a_width` smallint(5) UNSIGNED NOT NULL,
  `a_height` smallint(5) UNSIGNED NOT NULL,
  `a_resize` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `a_st` tinyint(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `attachment`
--

REPLACE INTO `attachment` (`a_id`, `a_upload_id`, `a_crt_dt`, `a_crt_ip`, `a_crt_usr_id`, `a_mod_dt`, `a_mod_ip`, `a_mod_usr_id`, `a_sort_id`, `a_ref_type`, `a_ref_id`, `a_title`, `a_name`, `a_path`, `a_file_type`, `a_file_size`, `a_width`, `a_height`, `a_resize`, `a_st`) VALUES
(19, 'rLFp', '2017-09-07 11:42:29', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 3, 'news', 7, NULL, 'IMG_6963N.jpg', 'attachment/2017-09/1504784549ExXf.jpg', 'jpg', 2629051, 3473, 5209, '', 0),
(20, 'rLFp', '2017-09-07 11:42:38', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 4, 'news', 7, NULL, 'IMG_7069.JPG', 'attachment/2017-09/1504784558ISrD.JPG', 'JPG', 2279425, 5472, 3648, '', 0),
(21, 'rLFp', '2017-09-07 11:42:48', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 2, 'news', 7, NULL, 'IMG_7021N.JPG', 'attachment/2017-09/15047845686nXqU.JPG', 'JPG', 1599487, 4922, 3282, '', 0),
(22, 'rLFp', '2017-09-07 11:42:54', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 1, 'news', 7, NULL, 'IMG_6876N.JPG', 'attachment/2017-09/1504784574PAIDU.JPG', 'JPG', 1397166, 4273, 2849, '', 0),
(23, 'CaWG', '2017-09-07 11:49:20', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 13, NULL, 'You Beauty_Consumer Caring _貼心企業.png', 'attachment/2017-09/1504784960Mdoj4.png', 'png', 46066, 1442, 617, '', 0),
(27, 'Kazl', '2017-09-15 01:55:35', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 22, NULL, '未命名.jpg', 'attachment/2017-09/15054405352qT2w.jpg', 'jpg', 159313, 1037, 720, '', 0),
(26, 'hzTj', '2017-09-15 01:51:55', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 22, NULL, 'You Beauty Happy Company_開心企業.png', 'attachment/2017-09/1505440315oT3nv.png', 'png', 34323, 1442, 617, '', 0),
(28, '8Bvo', '2017-09-15 08:49:24', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 28, NULL, 'Sister Beauty Pro 2017.jpg', 'attachment/2017-09/1505465364PUQZI.jpg', 'jpg', 75640, 517, 729, '', 0),
(29, '0Ggy', '2017-09-15 09:06:06', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 31, NULL, 'DSC_0627.JPG', 'attachment/2017-09/1505466366nWPa3.JPG', 'JPG', 703250, 2992, 2000, '', 0),
(30, '0Ggy', '2017-09-15 09:06:45', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 31, NULL, 'DSC_0843-1.jpg', 'attachment/2017-09/1505466405bPvG.jpg', 'jpg', 421779, 2000, 2992, '', 0),
(31, 'm2ZG', '2017-09-15 09:37:43', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 34, NULL, 'IMG_8082.jpg', 'attachment/2017-09/1505468263D6hf5.jpg', 'jpg', 202921, 1328, 747, '', 0),
(32, 'm2ZG', '2017-09-15 09:37:53', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 34, NULL, 'IMG_8080.jpg', 'attachment/2017-09/1505468273WliXL.jpg', 'jpg', 548062, 1600, 1200, '', 0),
(33, 'm2ZG', '2017-09-15 09:38:05', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 34, NULL, 'IMG_8034.jpg', 'attachment/2017-09/1505468285tvadX.jpg', 'jpg', 310492, 1600, 1200, '', 0),
(34, 'PCzz', '2017-09-15 09:59:48', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 37, NULL, 'IMG_8237-1024x682.jpg', 'attachment/2017-09/1505469588Qjfda.jpg', 'jpg', 190423, 1024, 682, '', 0),
(35, 'PCzz', '2017-09-15 09:59:53', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 37, NULL, 'image1-1024x640.jpg', 'attachment/2017-09/1505469593Hd0gM.jpg', 'jpg', 256027, 1024, 640, '', 0),
(36, 'PCzz', '2017-09-15 09:59:56', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 37, NULL, 'IMG_8176-copy-1024x640.jpg', 'attachment/2017-09/1505469596amKS.jpg', 'jpg', 170196, 1024, 640, '', 0),
(37, 'NI2T', '2017-09-15 10:15:28', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 40, NULL, '10408915_901430483247644_2438261020804277463_n.jpg', 'attachment/2017-09/1505470528T8A5R.jpg', 'jpg', 95586, 960, 720, '', 0),
(38, 'NI2T', '2017-09-15 10:15:37', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 40, NULL, '11164615_901430129914346_6385688849917740261_n.jpg', 'attachment/2017-09/15054705370YVRq.jpg', 'jpg', 86366, 960, 720, '', 0),
(39, 'NI2T', '2017-09-15 10:15:45', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 40, NULL, '10525645_901430063247686_4012375533171239272_n.jpg', 'attachment/2017-09/1505470545pygfO.jpg', 'jpg', 93586, 720, 960, '', 0),
(40, 'NI2T', '2017-09-15 10:15:57', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 40, NULL, '19315_901429979914361_9204759435917642023_n.jpg', 'attachment/2017-09/1505470557pWlud.jpg', 'jpg', 65411, 720, 960, '', 0),
(41, 'NI2T', '2017-09-15 10:16:01', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 40, NULL, '11265195_901429943247698_257631223841881587_n.jpg', 'attachment/2017-09/1505470561G5J1S.jpg', 'jpg', 87429, 720, 960, '', 0),
(42, 'aSpf', '2017-09-15 10:23:26', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 43, NULL, 'cc14_17_4c.jpg', 'attachment/2017-09/1505471006f7jUH.jpg', 'jpg', 122147, 1198, 498, '', 0),
(43, 'RoCp', '2017-09-27 04:35:11', '116.48.156.216', 1, '0000-00-00 00:00:00', '', 0, 0, 'news', 19, NULL, '香港地品牌大獎_2.jpg', 'attachment/2017-09/1506486911PhzR.jpg', 'jpg', 738190, 500, 372, '', 0);

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

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `bnr_id` int(11) NOT NULL,
  `bnr_lang` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bnr_crt_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `bnr_crt_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bnr_crt_usr_id` int(11) DEFAULT NULL,
  `bnr_mod_dt` datetime DEFAULT NULL,
  `bnr_mod_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bnr_mod_usr_id` int(11) DEFAULT NULL,
  `bnr_sort_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '999',
  `bnr_path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `banner`
--

REPLACE INTO `banner` (`bnr_id`, `bnr_lang`, `bnr_crt_dt`, `bnr_crt_ip`, `bnr_crt_usr_id`, `bnr_mod_dt`, `bnr_mod_ip`, `bnr_mod_usr_id`, `bnr_sort_id`, `bnr_path`) VALUES
(13, NULL, '2017-08-29 04:32:31', '116.48.156.216', 1, '2017-09-02 00:28:18', '1.64.253.209', 1, 2, 'UB_Web11_Web_Banner_PICO.png|/attachment/banner/1504283298t6O4a.png'),
(14, NULL, '2017-08-29 06:11:49', '116.48.156.216', 1, '2017-09-04 10:11:45', '116.48.156.216', 1, 3, 'WEB banner_20170801-04.jpg|/attachment/banner/1504491105ceNfi.jpg'),
(6, NULL, '2017-08-25 10:20:06', '116.48.156.216', 1, '2017-09-25 11:50:05', '42.200.236.148', 1, 1, 'Head_Page_1.png|/attachment/banner/1506311405oiOdX.png'),
(16, NULL, '2017-08-29 11:01:26', '116.48.156.216', 1, '2017-09-18 17:30:46', '116.48.156.216', 1, 4, 'WEB banner_20170801-03.jpg|/attachment/banner/1504229776C7lbL.jpg'),
(18, NULL, '2017-08-31 09:21:50', '116.48.156.216', 1, '2017-08-31 17:56:09', '116.48.156.216', 1, 5, 'WEB banner_20170801-02.jpg|/attachment/banner/1504173369h0Nj4.jpg');

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

--
-- Table structure for table `coupon`
--

CREATE TABLE `coupon` (
  `cp_id` bigint(20) NOT NULL,
  `cp_crt_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `cp_crt_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cp_crt_usr_id` bigint(20) DEFAULT NULL,
  `cp_mod_dt` datetime DEFAULT NULL,
  `cp_mod_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cp_mod_usr_id` bigint(20) DEFAULT NULL,
  `cp_sort_id` bigint(20) DEFAULT '1',
  `cp_sort_lv` int(11) DEFAULT '0',
  `cp_sort_fix` enum('Y','N') COLLATE utf8_unicode_ci DEFAULT 'N',
  `cp_show` enum('Y','N') COLLATE utf8_unicode_ci DEFAULT 'Y',
  `cp_fixed` enum('Y','N') COLLATE utf8_unicode_ci DEFAULT 'N',
  `cp_st` varchar(4) COLLATE utf8_unicode_ci DEFAULT 'A',
  `cp_tp` tinyint(4) DEFAULT NULL,
  `cp_ref` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cp_cd` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cp_over_purchase` decimal(8,2) DEFAULT NULL,
  `cp_price` decimal(8,2) DEFAULT NULL,
  `cp_percent` int(11) DEFAULT NULL,
  `cp_eff_start_dt` datetime DEFAULT NULL,
  `cp_eff_end_dt` datetime DEFAULT NULL,
  `cp_use_limit` int(11) DEFAULT '0',
  `cp_no_expiry` tinyint(4) DEFAULT '0',
  `cp_over_qty` int(11) DEFAULT '0',
  `cp_amt_req` tinyint(4) DEFAULT '0',
  `cp_qty_req` tinyint(4) DEFAULT '0',
  `cp_multi_cp` tinyint(4) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `coupon`
--

REPLACE INTO `coupon` (`cp_id`, `cp_crt_dt`, `cp_crt_ip`, `cp_crt_usr_id`, `cp_mod_dt`, `cp_mod_ip`, `cp_mod_usr_id`, `cp_sort_id`, `cp_sort_lv`, `cp_sort_fix`, `cp_show`, `cp_fixed`, `cp_st`, `cp_tp`, `cp_ref`, `cp_cd`, `cp_over_purchase`, `cp_price`, `cp_percent`, `cp_eff_start_dt`, `cp_eff_end_dt`, `cp_use_limit`, `cp_no_expiry`, `cp_over_qty`, `cp_amt_req`, `cp_qty_req`, `cp_multi_cp`) VALUES
(1, '2017-09-12 09:52:41', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, 'test', 'TEST-698-2017SEP', NULL, '100.00', NULL, '2017-09-04 00:00:00', '2017-09-22 00:00:00', 1, 0, 0, 0, 0, 0),
(2, '2017-09-12 09:52:41', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, 'test', 'TEST-110-2017SEP', NULL, '100.00', NULL, '2017-09-04 00:00:00', '2017-09-22 00:00:00', 1, 0, 0, 0, 0, 0),
(3, '2017-09-12 09:52:41', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, 'test', 'TEST-646-2017SEP', NULL, '100.00', NULL, '2017-09-04 00:00:00', '2017-09-22 00:00:00', 1, 0, 0, 0, 0, 0),
(4, '2017-09-12 09:52:41', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, 'test', 'TEST-538-2017SEP', NULL, '100.00', NULL, '2017-09-04 00:00:00', '2017-09-22 00:00:00', 1, 0, 0, 0, 0, 0),
(5, '2017-09-12 09:52:41', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, 'test', 'TEST-892-2017SEP', NULL, '100.00', NULL, '2017-09-04 00:00:00', '2017-09-22 00:00:00', 1, 0, 0, 0, 0, 0),
(6, '2017-09-15 01:28:57', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', 'AA831BB', NULL, '100.00', NULL, '2017-09-13 00:00:00', '2017-09-14 00:00:00', 1, 0, 0, 0, 0, 0),
(7, '2017-09-15 01:28:57', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', 'AA054BB', NULL, '100.00', NULL, '2017-09-13 00:00:00', '2017-09-14 00:00:00', 1, 0, 0, 0, 0, 0),
(8, '2017-09-15 01:28:57', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', 'AA991BB', NULL, '100.00', NULL, '2017-09-13 00:00:00', '2017-09-14 00:00:00', 1, 0, 0, 0, 0, 0),
(9, '2017-09-15 01:28:57', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', 'AA088BB', NULL, '100.00', NULL, '2017-09-13 00:00:00', '2017-09-14 00:00:00', 1, 0, 0, 0, 0, 0),
(10, '2017-09-15 01:28:57', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', 'AA242BB', NULL, '100.00', NULL, '2017-09-13 00:00:00', '2017-09-14 00:00:00', 1, 0, 0, 0, 0, 0),
(11, '2017-09-15 01:28:57', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', 'AA988BB', NULL, '100.00', NULL, '2017-09-13 00:00:00', '2017-09-14 00:00:00', 1, 0, 0, 0, 0, 0),
(12, '2017-09-15 01:28:57', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', 'AA469BB', NULL, '100.00', NULL, '2017-09-13 00:00:00', '2017-09-14 00:00:00', 1, 0, 0, 0, 0, 0),
(13, '2017-09-15 01:28:57', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', 'AA627BB', NULL, '100.00', NULL, '2017-09-13 00:00:00', '2017-09-14 00:00:00', 1, 0, 0, 0, 0, 0),
(14, '2017-09-15 01:28:57', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', 'AA529BB', NULL, '100.00', NULL, '2017-09-13 00:00:00', '2017-09-14 00:00:00', 1, 0, 0, 0, 0, 0),
(15, '2017-09-15 01:28:57', '218.103.118.116', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', 'AA548BB', NULL, '100.00', NULL, '2017-09-13 00:00:00', '2017-09-14 00:00:00', 1, 0, 0, 0, 0, 0),
(16, '2017-09-20 06:30:40', '116.48.156.216', 1, '2017-09-20 14:36:46', '116.48.156.216', 1, 1, 0, 'N', 'Y', 'N', 'D', 1, 'HIFU', 'hifu680free', NULL, '680.00', NULL, '2017-09-19 00:00:00', '2017-09-21 00:00:00', 0, 0, 0, 0, 0, 0),
(17, '2017-09-20 06:43:29', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, 'HIFU', 'ABC2017CDE', NULL, '600.00', NULL, '2017-09-20 00:00:00', '2017-09-22 00:00:00', 0, 0, 0, 0, 0, 0),
(18, '2017-09-21 03:25:29', '116.48.156.216', 1, '2017-09-21 11:35:29', '116.48.156.216', 1, 1, 0, 'N', 'Y', 'N', 'A', 1, 'KunTest', 'ABCABC123', NULL, '600.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 0, 0, 0, 0, 0, 0),
(19, '2017-09-21 03:50:40', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '脫毛', '123ab123', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 0, 0, 0, 0, 0, 0),
(20, '2017-09-21 03:55:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '脫毛', '12394793321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(21, '2017-09-21 03:55:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '脫毛', '12307595321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(22, '2017-09-21 03:55:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '脫毛', '12315097321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(23, '2017-09-21 03:55:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '脫毛', '12361737321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(24, '2017-09-21 03:55:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '脫毛', '12361210321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(25, '2017-09-21 03:55:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '脫毛', '12380771321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(26, '2017-09-21 03:55:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '脫毛', '12337694321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(27, '2017-09-21 03:55:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '脫毛', '12347470321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(28, '2017-09-21 03:55:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '脫毛', '12395139321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(29, '2017-09-21 03:55:45', '116.48.156.216', 1, '2017-09-21 11:57:04', '116.48.156.216', 1, 1, 0, 'N', 'Y', 'N', 'A', 1, '脫毛', '12305617321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(30, '2017-09-21 04:42:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', '1237295342190321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(31, '2017-09-21 04:42:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', '1230203234177321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(32, '2017-09-21 04:42:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', '1239280052613321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(33, '2017-09-21 04:42:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', '1232865348757321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(34, '2017-09-21 04:42:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', '1231896136003321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(35, '2017-09-21 04:42:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', '1239040576284321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(36, '2017-09-21 04:42:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', '1236908414936321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(37, '2017-09-21 04:42:45', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, '', '1231215735902321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(38, '2017-09-21 04:42:45', '116.48.156.216', 1, '2017-09-21 12:43:09', '116.48.156.216', 1, 1, 0, 'N', 'Y', 'N', 'A', 1, '', '1234706380782321', NULL, '100.00', NULL, '2017-09-20 00:00:00', '2017-09-28 00:00:00', 1, 0, 0, 0, 0, 0),
(39, '2017-09-27 07:10:30', '116.48.156.216', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'A', 1, 'test', 'test1234test', NULL, '150.00', NULL, '2017-09-26 00:00:00', '2017-09-28 00:00:00', 0, 0, 0, 0, 0, 0);

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `news_sys_id` bigint(20) NOT NULL,
  `news_id` bigint(20) DEFAULT NULL,
  `news_nc_id` bigint(20) NOT NULL,
  `news_lang` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `news_crt_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `news_crt_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `news_crt_usr_id` int(11) DEFAULT NULL,
  `news_mod_dt` datetime DEFAULT NULL,
  `news_mod_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `news_mod_usr_id` int(11) DEFAULT NULL,
  `news_sort_id` int(11) NOT NULL DEFAULT '999',
  `news_sort_lv` int(11) DEFAULT '0',
  `news_dt` date NOT NULL,
  `news_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `news_cate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `news_content` mediumtext COLLATE utf8_unicode_ci,
  `news_photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `news_video` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `news_video_show` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `news`
--

REPLACE INTO `news` (`news_sys_id`, `news_id`, `news_nc_id`, `news_lang`, `news_crt_dt`, `news_crt_ip`, `news_crt_usr_id`, `news_mod_dt`, `news_mod_ip`, `news_mod_usr_id`, `news_sort_id`, `news_sort_lv`, `news_dt`, `news_title`, `news_cate`, `news_content`, `news_photo`, `news_video`, `news_video_show`) VALUES
(4, 4, 0, 'en', '2017-09-06 06:59:38', '::1', 1, '2017-09-15 19:05:59', '116.48.156.216', 1, 1, 0, '2017-09-05', 'Testing en', '4', '<p>Testing en</p>', NULL, 'https://www.youtube.com/embed/LcKqN5lHfcE', 1),
(5, 4, 0, 'tc', '2017-09-06 06:59:38', '::1', 1, '2017-09-15 19:05:59', '116.48.156.216', 1, 1, 0, '2017-09-05', 'Discovery PICO No. 1皮秒袪斑療程', '4', '<p><br />\r\n<img alt="" src="https://static.xx.fbcdn.net/images/emoji.php/v9/fbe/1/16/1f3c6.png" style="height:16px; width:16px" />第2代皮秒激光袪斑<br />\r\n<img alt="" src="https://static.xx.fbcdn.net/images/emoji.php/v9/f3d/1/16/1f3c5.png" style="height:16px; width:16px" />FDA及CE權威認可<br />\r\n<img alt="" src="https://static.xx.fbcdn.net/images/emoji.php/v9/fa8/1/16/1f396.png" style="height:16px; width:16px" />榮獲2017年「最佳皮秒技術大獎」<br />\r\n<img alt="" src="https://static.xx.fbcdn.net/images/emoji.php/v9/f94/1/16/1f947.png" style="height:16px; width:16px" />以最快激光震碎色斑，以更少治療次數達到更佳袪斑效果<br />\r\n<img alt="" src="https://static.xx.fbcdn.net/images/emoji.php/v9/f29/1/16/1f397.png" style="height:16px; width:16px" />雙激光系統，可治療深層(1064nm)及淺層(532nm)色斑，徹底袪斑，不易反黑<br />\r\n<img alt="" src="https://static.xx.fbcdn.net/images/emoji.php/v9/f3d/1/16/1f3c5.png" style="height:16px; width:16px" />特別針對深層色斑、荷爾蒙斑（黃褐斑／蝴蝶斑）等</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>', NULL, 'https://www.youtube.com/embed/LcKqN5lHfcE', 1),
(6, 4, 0, 'sc', '2017-09-06 06:59:38', '::1', 1, '2017-09-15 19:05:59', '116.48.156.216', 1, 1, 0, '2017-09-05', 'Testing tc', '4', '<p>Testing tc</p>', NULL, 'https://www.youtube.com/embed/LcKqN5lHfcE', 1),
(7, 7, 0, 'en', '2017-09-06 08:15:40', '::1', 1, '2017-09-11 09:37:36', '116.48.156.216', 1, 2, 0, '2017-07-29', 'testing 2', '1', '<p>testing 2</p>', NULL, '', 0),
(8, 7, 0, 'tc', '2017-09-06 08:15:40', '::1', 1, '2017-09-11 09:37:36', '116.48.156.216', 1, 2, 0, '2017-07-29', '尖沙咀美麗華分店開幕', '1', '<p>&nbsp;</p>\r\n\r\n<p>YOU BEAUTY尖沙咀美麗華分店開幕，星級代言人高海寧小姐與YOU BEAUTY一同以全新形象示人，連同集團管理層一齊參與簡單而隆重的開幕儀式！祝YOU BEAUTY生意興隆，分店愈開愈多！</p>', NULL, '', 0),
(9, 7, 0, 'sc', '2017-09-06 08:15:40', '::1', 1, '2017-09-11 09:37:36', '116.48.156.216', 1, 2, 0, '2017-07-29', 'testing 2 tc', '1', '<p>&nbsp;testing 2tc</p>', NULL, '', 0),
(13, 13, 0, 'en', '2017-09-07 11:49:22', '116.48.156.216', 1, '2017-09-07 19:49:54', '116.48.156.216', 1, 6, 0, '2016-12-01', 'Consumer Caring Award 2016', '1', '<p>香港貨品編碼協會舉辦的「貼心企業嘉許計劃」今年已踏入第六屆，旨在表揚一些企業藉著國際標準、優化供應鏈管理、應用資訊科技以及持續改善營運流程，大幅提升消費者的滿意程度。</p>\r\n\r\n<p>大會按照全面關愛消費者、心繫消費者、承諾實踐、品質監控與安全、專注服務質素、用心聆聽和關懷員工共七項的核心價值，評核參與企業。</p>', NULL, '', 0),
(14, 13, 0, 'tc', '2017-09-07 11:49:22', '116.48.156.216', 1, '2017-09-07 19:49:54', '116.48.156.216', 1, 6, 0, '2016-12-01', 'Consumer Caring Award 2016', '1', '<p>香港貨品編碼協會舉辦的「貼心企業嘉許計劃」今年已踏入第六屆，旨在表揚一些企業藉著國際標準、優化供應鏈管理、應用資訊科技以及持續改善營運流程，大幅提升消費者的滿意程度。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>大會按照全面關愛消費者、心繫消費者、承諾實踐、品質監控與安全、專注服務質素、用心聆聽和關懷員工共七項的核心價值，評核參與企業。</p>', NULL, '', 0),
(15, 13, 0, 'sc', '2017-09-07 11:49:22', '116.48.156.216', 1, '2017-09-07 19:49:54', '116.48.156.216', 1, 6, 0, '2016-12-01', 'Consumer Caring Award 2016', '1', '<p>香港货品编码协会举办的「贴心企业嘉许计划」今年已踏入第六届，旨在表扬一些企业藉着国际标准、优化供应链管理、应用资讯科技以及持续改善营运流程，大幅提升消费者的满意程度。</p>\r\n\r\n<p>大会按照全面关爱消费者、心繫消费者、承诺实践、品质监控与安全、专注服务质素、用心聆听和关怀员工共七项的核心价值，评核参与企业。</p>', NULL, '', 0),
(16, 16, 0, 'en', '2017-09-14 11:01:56', '116.48.156.216', 1, '2017-09-14 19:02:41', '116.48.156.216', 1, 2, 0, '2017-09-14', 'You Beauty 激光脫毛 永久保養 承諾保證', '4', '', NULL, 'https://www.youtube.com/embed/fXHIkeakQbY', 0),
(17, 16, 0, 'tc', '2017-09-14 11:01:56', '116.48.156.216', 1, '2017-09-14 19:02:41', '116.48.156.216', 1, 2, 0, '2017-09-14', 'You Beauty 激光脫毛 永久保養 承諾保證', '4', '', NULL, 'https://www.youtube.com/embed/fXHIkeakQbY', 0),
(18, 16, 0, 'sc', '2017-09-14 11:01:56', '116.48.156.216', 1, '2017-09-14 19:02:41', '116.48.156.216', 1, 2, 0, '2017-09-14', 'You Beauty 激光脱毛 永久保养 承诺保证', '4', '', NULL, 'https://www.youtube.com/embed/fXHIkeakQbY', 0),
(19, 19, 0, 'en', '2017-09-15 01:48:30', '116.48.156.216', 1, '2017-09-27 12:35:19', '116.48.156.216', 1, 1, 0, '2017-08-26', '恭喜YOU BEAUTY獲頒「香港地品牌大獎」', '1', '<p>&ldquo;香港地品牌大獎&rdquo;嘉許一眾傑出香港本地品牌，讓一眾富有心思、有誠意、能代表香港的卓越企業得到肯定及認同。</p>\r\n\r\n<p>You Beauty憑著優秀及專業的美容服務，創新推廣策略及發展理念，榮獲首屆&ldquo;香港地品牌大獎&rdquo;，期望為香港造就出擠身國際的優秀美容品牌。</p>', NULL, '', 0),
(20, 19, 0, 'tc', '2017-09-15 01:48:30', '116.48.156.216', 1, '2017-09-27 12:35:19', '116.48.156.216', 1, 1, 0, '2017-08-26', '恭喜YOU BEAUTY獲頒「香港地品牌大獎」', '1', '<p>&ldquo;香港地品牌大獎&rdquo;嘉許一眾傑出香港本地品牌，讓一眾富有心思、有誠意、能代表香港的卓越企業得到肯定及認同。</p>\r\n\r\n<p>You Beauty憑著優秀及專業的美容服務，創新推廣策略及發展理念，榮獲首屆&ldquo;香港地品牌大獎&rdquo;，期望為香港造就出擠身國際的優秀美容品牌。</p>', NULL, '', 0),
(21, 19, 0, 'sc', '2017-09-15 01:48:30', '116.48.156.216', 1, '2017-09-27 12:35:19', '116.48.156.216', 1, 1, 0, '2017-08-26', '恭喜YOU BEAUTY获颁「香港地品牌大奖」', '1', '<p>&ldquo;香港地品牌大奖&rdquo;嘉许一众杰出香港本地品牌，让一众富有心思、有诚意、能代表香港的卓越企业得到肯定及认同。</p>\r\n\r\n<p>You Beauty凭着优秀及专业的美容服务，创新推广策略及发展理念，荣获首届&ldquo;香港地品牌大奖&rdquo;，期望为香港造就出挤身国际的优秀美容品牌。</p>', NULL, '', 0),
(22, 22, 0, 'en', '2017-09-15 01:52:02', '116.48.156.216', 1, '2017-09-15 17:09:29', '116.48.156.216', 1, 4, 0, '2017-06-01', '開心企業', '1', '<p>You Beauty致力營造開心工作環境的文化，受到香港提升快樂指數基金及香港生產力促進局的認同，獲頒「開心企業2016」證書。</p>', NULL, '', 0),
(23, 22, 0, 'tc', '2017-09-15 01:52:02', '116.48.156.216', 1, '2017-09-15 17:09:29', '116.48.156.216', 1, 4, 0, '2017-06-01', '開心企業', '1', '<p>You Beauty致力營造開心工作環境的文化，受到香港提升快樂指數基金及香港生產力促進局的認同，獲頒「開心企業2017」證書。</p>', NULL, '', 0),
(24, 22, 0, 'sc', '2017-09-15 01:52:02', '116.48.156.216', 1, '2017-09-15 17:09:29', '116.48.156.216', 1, 4, 0, '2017-06-01', '开心企业', '1', '<p>You Beauty致力营造开心工作环境的文化，受到香港提升快乐指数基金及香港生产力促进局的认同，获颁「开心企业2016」证书。</p>', NULL, '', 0),
(25, 25, 0, 'en', '2017-09-15 02:59:17', '116.48.156.216', 1, '2017-09-15 13:52:30', '116.48.156.216', 1, 3, 0, '2017-09-15', 'Doublo S HIFU', '4', '', NULL, 'https://www.youtube.com/embed/XMSIRToQg1Y', 0),
(26, 25, 0, 'tc', '2017-09-15 02:59:17', '116.48.156.216', 1, '2017-09-15 13:52:30', '116.48.156.216', 1, 3, 0, '2017-09-15', 'Doublo S HIFU', '4', '', NULL, 'https://www.youtube.com/embed/XMSIRToQg1Y', 0),
(27, 25, 0, 'sc', '2017-09-15 02:59:17', '116.48.156.216', 1, '2017-09-15 13:52:30', '116.48.156.216', 1, 3, 0, '2017-09-15', 'Doublo S HIFU', '4', '', NULL, 'https://www.youtube.com/embed/XMSIRToQg1Y', 0),
(28, 28, 0, 'en', '2017-09-15 08:49:28', '116.48.156.216', 1, '2017-09-15 16:50:11', '116.48.156.216', 1, 3, 0, '2017-07-13', 'You Beauty 榮獲姊妹美容優秀專業美容院2017嘉許狀', '1', '<p>多謝各位支持！You Beauty 榮獲姊妹美容優秀專業美容院2017嘉許狀。<br />\r\n我們會繼續努力，履行&ldquo;專業，熱誠，令客人蛻變美麗&rdquo;的服務使命 。</p>', NULL, '', 0),
(29, 28, 0, 'tc', '2017-09-15 08:49:28', '116.48.156.216', 1, '2017-09-15 16:50:11', '116.48.156.216', 1, 3, 0, '2017-07-13', 'You Beauty 榮獲姊妹美容優秀專業美容院2017嘉許狀', '1', '<p>多謝各位支持！You Beauty 榮獲姊妹美容優秀專業美容院2017嘉許狀。<br />\r\n我們會繼續努力，履行&ldquo;專業，熱誠，令客人蛻變美麗&rdquo;的服務使命 。</p>', NULL, '', 0),
(30, 28, 0, 'sc', '2017-09-15 08:49:28', '116.48.156.216', 1, '2017-09-15 16:50:11', '116.48.156.216', 1, 3, 0, '2017-07-13', 'You Beauty 荣获姊妹美容优秀专业美容院2017嘉许状', '1', '<p>多谢各位支持！You Beauty 荣获姊妹美容优秀专业美容院2017嘉许状。<br />\r\n我们会继续努力，履行&ldquo;专业，热诚，令客人蜕变美丽&rdquo;的服务使命 。</p>', NULL, '', 0),
(31, 31, 0, 'en', '2017-09-15 09:07:25', '116.48.156.216', 1, NULL, NULL, NULL, 7, 0, '2016-01-04', '2016 屯門分店開幕', '1', '<p>YOU BEAUTY屯門分店開幕當日，集團領導團隊連同代言人高海寧小姐及葉文輝先生一同參與開幕儀式，慶祝集團強勢進駐屯門區開設第14間服務中心！</p>', NULL, '', 0),
(32, 31, 0, 'tc', '2017-09-15 09:07:25', '116.48.156.216', 1, NULL, NULL, NULL, 7, 0, '2016-01-04', '2016 屯門分店開幕', '1', '<p>YOU BEAUTY屯門分店開幕當日，集團領導團隊連同代言人高海寧小姐及葉文輝先生一同參與開幕儀式，慶祝集團強勢進駐屯門區開設第14間服務中心！</p>', NULL, '', 0),
(33, 31, 0, 'sc', '2017-09-15 09:07:25', '116.48.156.216', 1, NULL, NULL, NULL, 7, 0, '2016-01-04', '2016 屯门分店开幕', '1', '<p>YOU BEAUTY屯门分店开幕当日，集团领导团队连同代言人高海宁小姐及叶文辉先生一同参与开幕仪式，庆祝集团强势进驻屯门区开设第14间服务中心！</p>', NULL, '', 0),
(34, 34, 0, 'en', '2017-09-15 09:38:11', '116.48.156.216', 1, NULL, NULL, NULL, 8, 0, '2015-12-24', '第13屆香港冬季購物節', '1', '<p>YOU BEAUTY 每年都會參加此一年一度的大型展覽，而且每年展銷攤位內都係日日爆場！</p>', NULL, '', 0),
(35, 34, 0, 'tc', '2017-09-15 09:38:11', '116.48.156.216', 1, NULL, NULL, NULL, 8, 0, '2015-12-24', '第13屆香港冬季購物節', '1', '<p>YOU BEAUTY 每年都會參加此一年一度的大型展覽，而且每年展銷攤位內都係日日爆場！</p>', NULL, '', 0),
(36, 34, 0, 'sc', '2017-09-15 09:38:11', '116.48.156.216', 1, NULL, NULL, NULL, 8, 0, '2015-12-24', '第13届香港冬季购物节', '1', '<p>YOU BEAUTY 每年都会参加此一年一度的大型展览，而且每年展销摊位内都係日日爆场！</p>', NULL, '', 0),
(37, 37, 0, 'en', '2017-09-15 10:02:13', '116.48.156.216', 1, NULL, NULL, NULL, 9, 0, '2015-11-07', '「學前弱能兒童家長會」賣旗活動', '1', '<p>YOU BEAUTY 為履行「獻出關懷，建立和諧社會」的宗旨，於2015年11月7日積極動員約50位同事，於荃灣區為「學前弱能兒童家長會」進行賣旗活動！當日，集團創辦人兼行政總裁Janet Ip及董事總經理Stephen Cheng更與同事們並肩做義工，一齊為有關慈善機構積極籌款！</p>', NULL, '', 0),
(38, 37, 0, 'tc', '2017-09-15 10:02:13', '116.48.156.216', 1, NULL, NULL, NULL, 9, 0, '2015-11-07', '「學前弱能兒童家長會」賣旗活動', '1', '<p>YOU BEAUTY 為履行「獻出關懷，建立和諧社會」的宗旨，於2015年11月7日積極動員約50位同事，於荃灣區為「學前弱能兒童家長會」進行賣旗活動！當日，集團創辦人兼行政總裁Janet Ip及董事總經理Stephen Cheng更與同事們並肩做義工，一齊為有關慈善機構積極籌款！</p>', NULL, '', 0),
(39, 37, 0, 'sc', '2017-09-15 10:02:13', '116.48.156.216', 1, NULL, NULL, NULL, 9, 0, '2015-11-07', '「学前弱能儿童家长会」卖旗活动', '1', '<p>YOU BEAUTY 为履行「献出关怀，建立和谐社会」的宗旨，于2015年11月7日积极动员约50位同事，于荃湾区为「学前弱能儿童家长会」进行卖旗活动！当日，集团创办人兼行政总裁Janet Ip及董事总经理Stephen Cheng更与同事们并肩做义工，一齐为有关慈善机构积极筹款！</p>', NULL, '', 0),
(40, 40, 0, 'en', '2017-09-15 10:16:08', '116.48.156.216', 1, NULL, NULL, NULL, 10, 0, '2015-05-15', 'PEGABOO BB 展', '1', '<p>代言人高海寧小姐親臨BB展為集團銷售隊伍打氣，並與現場人客及Mascot合照，場面熱鬧非凡～&nbsp;</p>', NULL, '', 0),
(41, 40, 0, 'tc', '2017-09-15 10:16:08', '116.48.156.216', 1, NULL, NULL, NULL, 10, 0, '2015-05-15', 'PEGABOO BB 展', '1', '<p>代言人高海寧小姐親臨BB展為集團銷售隊伍打氣，並與現場人客及Mascot合照，場面熱鬧非凡～&nbsp;</p>', NULL, '', 0),
(42, 40, 0, 'sc', '2017-09-15 10:16:08', '116.48.156.216', 1, NULL, NULL, NULL, 10, 0, '2015-05-15', 'PEGABOO BB 展', '1', '<p>代言人高海宁小姐亲临BB展为集团销售队伍打气，并与现场人客及Mascot合照，场面热闹非凡～&nbsp;</p>', NULL, '', 0),
(43, 43, 0, 'en', '2017-09-15 10:23:33', '116.48.156.216', 1, NULL, NULL, NULL, 5, 0, '2017-03-15', '「商界展關懷2014-2017」', '1', '<p>恭喜YOU BEAUTY 獲頒「商界展關懷2014-2017」!&nbsp;集團必再接再厲，為公益獻上更多貢獻，繼續履行企業的社會責任!</p>', NULL, '', 0),
(44, 43, 0, 'tc', '2017-09-15 10:23:33', '116.48.156.216', 1, NULL, NULL, NULL, 5, 0, '2017-03-15', '「商界展關懷2014-2017」', '1', '<p>恭喜YOU BEAUTY 獲頒「商界展關懷2014-2017」!&nbsp;集團必再接再厲，為公益獻上更多貢獻，繼續履行企業的社會責任!</p>', NULL, '', 0),
(45, 43, 0, 'sc', '2017-09-15 10:23:33', '116.48.156.216', 1, NULL, NULL, NULL, 5, 0, '2017-03-15', '「商界展关怀2014-2017」', '1', '<p>恭喜YOU BEAUTY 获颁「商界展关怀2014-2017」!&nbsp;集团必再接再厉，为公益献上更多贡献，继续履行企业的社会责任!</p>', NULL, '', 0);

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

--
-- Table structure for table `news_cate`
--

CREATE TABLE `news_cate` (
  `cate_sys_id` bigint(20) NOT NULL,
  `cate_id` bigint(20) DEFAULT NULL,
  `cate_lang` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
  `cate_pid` bigint(20) NOT NULL DEFAULT '0',
  `cate_crt_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `cate_crt_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cate_crt_usr_id` bigint(20) DEFAULT NULL,
  `cate_mod_dt` datetime DEFAULT NULL,
  `cate_mod_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cate_mod_usr_id` bigint(20) DEFAULT NULL,
  `cate_sort_id` bigint(20) DEFAULT '999',
  `cate_sort_lv` int(11) DEFAULT '0',
  `cate_sort_fix` enum('Y','N') COLLATE utf8_unicode_ci DEFAULT 'N',
  `cate_show` enum('Y','N') COLLATE utf8_unicode_ci DEFAULT 'Y',
  `cate_fixed` enum('Y','N') COLLATE utf8_unicode_ci DEFAULT 'N',
  `cate_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `news_cate`
--

REPLACE INTO `news_cate` (`cate_sys_id`, `cate_id`, `cate_lang`, `cate_pid`, `cate_crt_dt`, `cate_crt_ip`, `cate_crt_usr_id`, `cate_mod_dt`, `cate_mod_ip`, `cate_mod_usr_id`, `cate_sort_id`, `cate_sort_lv`, `cate_sort_fix`, `cate_show`, `cate_fixed`, `cate_name`) VALUES
(1, 1, 'en', 0, '2017-09-06 08:58:27', '::1', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'News'),
(2, 1, 'tc', 0, '2017-09-06 08:58:27', '::1', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', '最新消息'),
(3, 1, 'sc', 0, '2017-09-06 08:58:27', '::1', 1, NULL, NULL, NULL, 1, 0, 'N', 'Y', 'N', 'News'),
(4, 4, 'en', 0, '2017-09-06 08:58:47', '::1', 1, NULL, NULL, NULL, 2, 0, 'N', 'Y', 'N', 'Video'),
(5, 4, 'tc', 0, '2017-09-06 08:58:47', '::1', 1, NULL, NULL, NULL, 2, 0, 'N', 'Y', 'N', '最新視頻'),
(6, 4, 'sc', 0, '2017-09-06 08:58:47', '::1', 1, NULL, NULL, NULL, 2, 0, 'N', 'Y', 'N', 'Video');

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

--
-- Table structure for table `popup`
--

CREATE TABLE `popup` (
  `popup_sys_id` bigint(20) NOT NULL,
  `popup_id` bigint(20) DEFAULT NULL,
  `popup_nc_id` bigint(20) NOT NULL,
  `popup_lang` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `popup_crt_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `popup_crt_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `popup_crt_usr_id` int(11) DEFAULT NULL,
  `popup_mod_dt` datetime DEFAULT NULL,
  `popup_mod_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `popup_mod_usr_id` int(11) DEFAULT NULL,
  `popup_sort_id` int(11) NOT NULL DEFAULT '999',
  `popup_sort_lv` int(11) DEFAULT '0',
  `popup_content` mediumtext COLLATE utf8_unicode_ci,
  `popup_photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `popup_show` int(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `popup`
--

REPLACE INTO `popup` (`popup_sys_id`, `popup_id`, `popup_nc_id`, `popup_lang`, `popup_crt_dt`, `popup_crt_ip`, `popup_crt_usr_id`, `popup_mod_dt`, `popup_mod_ip`, `popup_mod_usr_id`, `popup_sort_id`, `popup_sort_lv`, `popup_content`, `popup_photo`, `popup_show`) VALUES
(1, 1, 0, 'en', '2017-09-21 09:21:28', '::1', 1, '2017-09-27 11:20:25', '116.48.156.216', 1, 999, 0, 'testing pop up news', '_DSC6148LL.jpg|/attachment/popup/1506477653JB4X1.jpg', 0),
(2, 1, 0, 'tc', '2017-09-21 09:21:28', '::1', 1, '2017-09-27 11:20:25', '116.48.156.216', 1, 999, 0, 'testing pop up tc', '_DSC6148LL.jpg|/attachment/popup/1506477653JB4X1.jpg', 0),
(3, 1, 0, 'sc', '2017-09-21 09:21:28', '::1', 1, '2017-09-27 11:20:25', '116.48.156.216', 1, 999, 0, 'testing pop up testing pop up scsc', '_DSC6148LL.jpg|/attachment/popup/1506477653JB4X1.jpg', 0);

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

--
-- Table structure for table `po_mst`
--

CREATE TABLE `po_mst` (
  `po_id` bigint(20) NOT NULL,
  `po_mem_id` bigint(20) DEFAULT NULL,
  `po_dt` datetime DEFAULT NULL,
  `po_crt_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `po_crt_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `po_crt_usr_id` bigint(20) DEFAULT NULL,
  `po_mod_dt` datetime DEFAULT NULL,
  `po_mod_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `po_mod_usr_id` bigint(20) DEFAULT NULL,
  `po_st` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `po_st_dt` datetime DEFAULT NULL,
  `po_st_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `po_st_usr_id` bigint(20) DEFAULT NULL,
  `po_no` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `po_msg` text COLLATE utf8_unicode_ci,
  `po_track_no` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `po_gateway_response` text COLLATE utf8_unicode_ci,
  `po_invoice` text COLLATE utf8_unicode_ci,
  `po_pay_method` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `po_sub_total` decimal(8,2) DEFAULT NULL,
  `po_sub_total_cur` decimal(8,2) DEFAULT NULL,
  `po_shipping_charge` decimal(8,2) DEFAULT NULL,
  `po_shipping_charge_cur` decimal(8,2) DEFAULT NULL,
  `po_grant_total` decimal(8,2) DEFAULT NULL,
  `po_grant_total_cur` decimal(8,2) DEFAULT NULL,
  `po_discount_total` decimal(8,2) DEFAULT NULL,
  `po_discount_total_cur` decimal(8,2) DEFAULT NULL,
  `po_cur_id` bigint(20) DEFAULT NULL,
  `po_cur_symbol` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `po_cur_rate` decimal(8,4) DEFAULT NULL,
  `po_trace_shipping_url` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  `po_submit_lang` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `po_mst`
--

REPLACE INTO `po_mst` (`po_id`, `po_mem_id`, `po_dt`, `po_crt_dt`, `po_crt_ip`, `po_crt_usr_id`, `po_mod_dt`, `po_mod_ip`, `po_mod_usr_id`, `po_st`, `po_st_dt`, `po_st_ip`, `po_st_usr_id`, `po_no`, `po_msg`, `po_track_no`, `po_gateway_response`, `po_invoice`, `po_pay_method`, `po_sub_total`, `po_sub_total_cur`, `po_shipping_charge`, `po_shipping_charge_cur`, `po_grant_total`, `po_grant_total_cur`, `po_discount_total`, `po_discount_total_cur`, `po_cur_id`, `po_cur_symbol`, `po_cur_rate`, `po_trace_shipping_url`, `po_submit_lang`) VALUES
(1, NULL, '2017-09-11 00:00:00', '2017-09-11 08:56:52', NULL, NULL, NULL, NULL, NULL, 'PAID', '2017-09-11 20:17:43', '218.103.118.116:58974', 4, 'PO-T001', NULL, '2DX52849FK456335X', '{"TOKEN":"EC-6UM082023H8072930","SUCCESSPAGEREDIRECTREQUESTED":"false","TIMESTAMP":"2017-09-11T12:17:43Z","CORRELATIONID":"34fcb18630b94","ACK":"Success","VERSION":"64.0","BUILD":"38751304","TRANSACTIONID":"2DX52849FK456335X","TRANSACTIONTYPE":"expresscheckout","PAYMENTTYPE":"instant","ORDERTIME":"2017-09-11T12:17:42Z","AMT":"1000.00","TAXAMT":"0.00","CURRENCYCODE":"HKD","PAYMENTSTATUS":"Pending","PENDINGREASON":"multicurrency","REASONCODE":"None","PROTECTIONELIGIBILITY":"Ineligible","INSURANCEOPTIONSELECTED":"false","SHIPPINGOPTIONISDEFAULT":"false","PAYMENTINFO_0_TRANSACTIONID":"2DX52849FK456335X","PAYMENTINFO_0_TRANSACTIONTYPE":"expresscheckout","PAYMENTINFO_0_PAYMENTTYPE":"instant","PAYMENTINFO_0_ORDERTIME":"2017-09-11T12:17:42Z","PAYMENTINFO_0_AMT":"1000.00","PAYMENTINFO_0_TAXAMT":"0.00","PAYMENTINFO_0_CURRENCYCODE":"HKD","PAYMENTINFO_0_PAYMENTSTATUS":"Pending","PAYMENTINFO_0_PENDINGREASON":"multicurrency","PAYMENTINFO_0_REASONCODE":"None","PAYMENTINFO_0_PROTECTIONELIGIBILITY":"Ineligible","PAYMENTINFO_0_SELLERPAYPALACCOUNTID":"easttech.dev-facilitator@gmail.com","PAYMENTINFO_0_ERRORCODE":"0","PAYMENTINFO_0_ACK":"Success"}', NULL, 'PAYPAL', '100.00', '100.00', NULL, NULL, '90.00', '90.00', '10.00', '10.00', NULL, NULL, NULL, NULL, NULL),
(233, NULL, '2017-09-11 19:43:36', '2017-09-11 11:43:36', '218.103.118.116', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', '1000.00', NULL, NULL, NULL, '1000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(234, NULL, '2017-09-11 19:44:33', '2017-09-11 11:44:33', '218.103.118.116', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', '1000.00', NULL, NULL, NULL, '1000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(235, NULL, '2017-09-11 19:45:26', '2017-09-11 11:45:26', '218.103.118.116', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', '1000.00', NULL, NULL, NULL, '1000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(236, NULL, '2017-09-11 19:48:20', '2017-09-11 11:48:20', '218.103.118.116', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', '1000.00', NULL, NULL, NULL, '1000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(237, NULL, '2017-09-11 20:16:39', '2017-09-11 12:16:39', '218.103.118.116', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'online', '1000.00', NULL, NULL, NULL, '1000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(238, NULL, '2017-09-11 20:20:25', '2017-09-11 12:20:25', '218.103.118.116', NULL, NULL, NULL, NULL, 'PAID', '2017-09-11 20:20:52', '218.103.118.116:59516', 4, NULL, NULL, '5A630701DU5310216', '{"TOKEN":"EC-2AP95043U9581184X","SUCCESSPAGEREDIRECTREQUESTED":"false","TIMESTAMP":"2017-09-11T12:20:52Z","CORRELATIONID":"33508d1ac1a3f","ACK":"Success","VERSION":"64.0","BUILD":"38751304","TRANSACTIONID":"5A630701DU5310216","TRANSACTIONTYPE":"expresscheckout","PAYMENTTYPE":"instant","ORDERTIME":"2017-09-11T12:20:51Z","AMT":"1000.00","TAXAMT":"0.00","CURRENCYCODE":"HKD","PAYMENTSTATUS":"Pending","PENDINGREASON":"multicurrency","REASONCODE":"None","PROTECTIONELIGIBILITY":"Ineligible","INSURANCEOPTIONSELECTED":"false","SHIPPINGOPTIONISDEFAULT":"false","PAYMENTINFO_0_TRANSACTIONID":"5A630701DU5310216","PAYMENTINFO_0_TRANSACTIONTYPE":"expresscheckout","PAYMENTINFO_0_PAYMENTTYPE":"instant","PAYMENTINFO_0_ORDERTIME":"2017-09-11T12:20:51Z","PAYMENTINFO_0_AMT":"1000.00","PAYMENTINFO_0_TAXAMT":"0.00","PAYMENTINFO_0_CURRENCYCODE":"HKD","PAYMENTINFO_0_PAYMENTSTATUS":"Pending","PAYMENTINFO_0_PENDINGREASON":"multicurrency","PAYMENTINFO_0_REASONCODE":"None","PAYMENTINFO_0_PROTECTIONELIGIBILITY":"Ineligible","PAYMENTINFO_0_SELLERPAYPALACCOUNTID":"easttech.dev-facilitator@gmail.com","PAYMENTINFO_0_ERRORCODE":"0","PAYMENTINFO_0_ACK":"Success"}', NULL, 'online', '1000.00', NULL, NULL, NULL, '1000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(239, NULL, '2017-09-11 20:24:07', '2017-09-11 12:24:07', '218.103.118.116', NULL, NULL, NULL, NULL, 'PAID', '2017-09-11 20:24:56', '218.103.118.116:59662', 4, NULL, NULL, '5V670581CE236360L', '{"TOKEN":"EC-3G121325JG814370U","SUCCESSPAGEREDIRECTREQUESTED":"false","TIMESTAMP":"2017-09-11T12:24:56Z","CORRELATIONID":"f990e1e9123e9","ACK":"Success","VERSION":"64.0","BUILD":"38751304","TRANSACTIONID":"5V670581CE236360L","TRANSACTIONTYPE":"expresscheckout","PAYMENTTYPE":"instant","ORDERTIME":"2017-09-11T12:24:55Z","AMT":"1000.00","TAXAMT":"0.00","CURRENCYCODE":"HKD","PAYMENTSTATUS":"Pending","PENDINGREASON":"multicurrency","REASONCODE":"None","PROTECTIONELIGIBILITY":"Ineligible","INSURANCEOPTIONSELECTED":"false","SHIPPINGOPTIONISDEFAULT":"false","PAYMENTINFO_0_TRANSACTIONID":"5V670581CE236360L","PAYMENTINFO_0_TRANSACTIONTYPE":"expresscheckout","PAYMENTINFO_0_PAYMENTTYPE":"instant","PAYMENTINFO_0_ORDERTIME":"2017-09-11T12:24:55Z","PAYMENTINFO_0_AMT":"1000.00","PAYMENTINFO_0_TAXAMT":"0.00","PAYMENTINFO_0_CURRENCYCODE":"HKD","PAYMENTINFO_0_PAYMENTSTATUS":"Pending","PAYMENTINFO_0_PENDINGREASON":"multicurrency","PAYMENTINFO_0_REASONCODE":"None","PAYMENTINFO_0_PROTECTIONELIGIBILITY":"Ineligible","PAYMENTINFO_0_SELLERPAYPALACCOUNTID":"easttech.dev-facilitator@gmail.com","PAYMENTINFO_0_ERRORCODE":"0","PAYMENTINFO_0_ACK":"Success"}', NULL, 'online', '1000.00', NULL, NULL, NULL, '1000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(240, NULL, '2017-09-11 20:30:33', '2017-09-11 12:30:33', '218.103.118.116', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'shop', '3000.00', NULL, NULL, NULL, '3000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(241, NULL, '2017-09-12 09:52:27', '2017-09-12 01:52:27', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-12 09:52:27', '218.103.118.116', 3, NULL, NULL, NULL, NULL, NULL, 'shop', '3000.00', NULL, NULL, NULL, '3000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(242, NULL, '2017-09-12 09:53:01', '2017-09-12 01:53:01', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-12 09:53:01', '218.103.118.116', 3, NULL, NULL, NULL, NULL, NULL, 'shop', '999.00', NULL, NULL, NULL, '999.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(243, NULL, '2017-09-12 15:21:40', '2017-09-12 07:21:40', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-12 15:21:40', '218.103.118.116', 3, NULL, NULL, NULL, NULL, NULL, 'online', '1000.00', NULL, NULL, NULL, '1000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(244, NULL, '2017-09-12 15:22:10', '2017-09-12 07:22:10', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-12 15:22:10', '218.103.118.116', 3, NULL, NULL, NULL, NULL, NULL, 'online', '1000.00', NULL, NULL, NULL, '1000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(245, NULL, '2017-09-12 17:53:14', '2017-09-12 09:53:14', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-12 17:53:14', '218.103.118.116', 3, NULL, NULL, NULL, NULL, NULL, 'online', '1000.00', NULL, NULL, NULL, '900.00', NULL, '100.00', NULL, NULL, NULL, NULL, NULL, NULL),
(246, NULL, '2017-09-12 18:02:29', '2017-09-12 10:02:29', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-12 18:02:29', '218.103.118.116', 3, NULL, NULL, NULL, NULL, NULL, 'online', '1000.00', NULL, NULL, NULL, '900.00', NULL, '100.00', NULL, NULL, NULL, NULL, NULL, NULL),
(247, NULL, '2017-09-13 10:06:14', '2017-09-13 02:06:14', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-13 10:06:14', '218.103.118.116', 3, NULL, NULL, NULL, NULL, NULL, 'online', '1000.00', NULL, NULL, NULL, '900.00', NULL, '100.00', NULL, NULL, NULL, NULL, NULL, NULL),
(248, NULL, '2017-09-13 10:07:14', '2017-09-13 02:07:14', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-13 10:07:14', '218.103.118.116', 3, NULL, NULL, NULL, NULL, NULL, 'shop', '3000.00', NULL, NULL, NULL, '3000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(249, NULL, '2017-09-13 10:08:27', '2017-09-13 02:08:27', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-13 10:08:27', '218.103.118.116', 3, NULL, NULL, NULL, NULL, NULL, 'shop', '3000.00', NULL, NULL, NULL, '3000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(250, NULL, '2017-09-13 10:09:23', '2017-09-13 02:09:23', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-13 10:09:23', '218.103.118.116', 3, NULL, NULL, NULL, NULL, NULL, 'shop', '3000.00', NULL, NULL, NULL, '3000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(251, NULL, '2017-09-14 12:00:13', '2017-09-14 04:00:13', '116.48.156.216', NULL, NULL, NULL, NULL, 'PEND', '2017-09-14 12:00:13', '116.48.156.216', 3, NULL, NULL, NULL, NULL, NULL, 'online', '1000.00', NULL, NULL, NULL, '1000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(252, NULL, '2017-09-15 10:06:56', '2017-09-15 02:06:56', '116.48.156.216', NULL, NULL, NULL, NULL, 'PAID', '2017-09-15 10:20:29', '116.48.156.216:51868', 4, NULL, NULL, '3BA56611FN943072V', '{"TOKEN":"EC-46N33921NV1291052","SUCCESSPAGEREDIRECTREQUESTED":"false","TIMESTAMP":"2017-09-15T02:20:29Z","CORRELATIONID":"4646a324b5452","ACK":"Success","VERSION":"64.0","BUILD":"38929049","TRANSACTIONID":"3BA56611FN943072V","TRANSACTIONTYPE":"expresscheckout","PAYMENTTYPE":"instant","ORDERTIME":"2017-09-15T02:20:28Z","AMT":"1.00","FEEAMT":"1.00","TAXAMT":"0.00","CURRENCYCODE":"HKD","PAYMENTSTATUS":"Completed","PENDINGREASON":"None","REASONCODE":"None","PROTECTIONELIGIBILITY":"Eligible","INSURANCEOPTIONSELECTED":"false","SHIPPINGOPTIONISDEFAULT":"false","PAYMENTINFO_0_TRANSACTIONID":"3BA56611FN943072V","PAYMENTINFO_0_TRANSACTIONTYPE":"expresscheckout","PAYMENTINFO_0_PAYMENTTYPE":"instant","PAYMENTINFO_0_ORDERTIME":"2017-09-15T02:20:28Z","PAYMENTINFO_0_AMT":"1.00","PAYMENTINFO_0_FEEAMT":"1.00","PAYMENTINFO_0_TAXAMT":"0.00","PAYMENTINFO_0_CURRENCYCODE":"HKD","PAYMENTINFO_0_PAYMENTSTATUS":"Completed","PAYMENTINFO_0_PENDINGREASON":"None","PAYMENTINFO_0_REASONCODE":"None","PAYMENTINFO_0_PROTECTIONELIGIBILITY":"Eligible","PAYMENTINFO_0_SELLERPAYPALACCOUNTID":"milk@youbeauty.com.hk","PAYMENTINFO_0_ERRORCODE":"0","PAYMENTINFO_0_ACK":"Success"}', NULL, 'online', '1.00', NULL, NULL, NULL, '1.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(253, NULL, '2017-09-15 12:07:14', '2017-09-15 04:07:14', '116.48.156.216', NULL, NULL, NULL, NULL, 'PEND', '2017-09-15 12:07:14', '116.48.156.216', 3, NULL, NULL, NULL, NULL, NULL, 'shop', '3000.00', NULL, NULL, NULL, '3000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(254, NULL, '2017-09-19 11:13:12', '2017-09-19 03:13:12', '116.48.156.216', NULL, NULL, NULL, NULL, 'PEND', '2017-09-19 11:13:12', '116.48.156.216', 3, NULL, NULL, NULL, NULL, NULL, 'online', '2980.00', NULL, NULL, NULL, '2980.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(255, NULL, '2017-09-20 11:58:12', '2017-09-20 03:58:12', '116.48.156.216', NULL, NULL, NULL, NULL, 'PEND', '2017-09-20 11:58:12', '116.48.156.216', 3, NULL, NULL, NULL, NULL, NULL, 'online', '680.00', NULL, NULL, NULL, '680.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(256, NULL, '2017-09-20 14:32:59', '2017-09-20 06:32:59', '116.48.156.216', NULL, NULL, NULL, NULL, 'ERR', '2017-09-20 14:33:01', '116.48.156.216:34677', 4, NULL, NULL, NULL, NULL, NULL, 'online', '680.00', NULL, NULL, NULL, '0.00', NULL, '680.00', NULL, NULL, NULL, NULL, NULL, NULL),
(257, NULL, '2017-09-20 14:38:22', '2017-09-20 06:38:22', '116.48.156.216', NULL, NULL, NULL, NULL, 'PEND', '2017-09-20 14:38:22', '116.48.156.216', 3, NULL, NULL, NULL, NULL, NULL, 'online', '680.00', NULL, NULL, NULL, '680.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(258, NULL, '2017-09-20 14:44:54', '2017-09-20 06:44:54', '116.48.156.216', NULL, NULL, NULL, NULL, 'PEND', '2017-09-20 14:44:54', '116.48.156.216', 3, NULL, NULL, NULL, NULL, NULL, 'online', '680.00', NULL, NULL, NULL, '80.00', NULL, '600.00', NULL, NULL, NULL, NULL, NULL, NULL),
(259, NULL, '2017-09-21 11:48:46', '2017-09-21 03:48:46', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-21 11:48:46', '218.103.118.116', 3, NULL, NULL, NULL, NULL, NULL, 'online', '688.00', NULL, NULL, NULL, '88.00', NULL, '600.00', NULL, NULL, NULL, NULL, NULL, NULL),
(260, NULL, '2017-09-21 12:57:35', '2017-09-21 04:57:35', '116.48.156.216', NULL, NULL, NULL, NULL, 'PEND', '2017-09-21 12:57:35', '116.48.156.216', 3, NULL, NULL, NULL, NULL, NULL, 'online', '688.00', NULL, NULL, NULL, '688.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(261, NULL, '2017-09-25 09:49:30', '2017-09-25 01:49:30', '116.48.156.216', NULL, NULL, NULL, NULL, 'PEND', '2017-09-25 09:49:30', '116.48.156.216', 3, NULL, NULL, NULL, NULL, NULL, 'online', '688.00', NULL, NULL, NULL, '588.00', NULL, '100.00', NULL, NULL, NULL, NULL, NULL, NULL),
(262, NULL, '2017-09-25 09:52:09', '2017-09-25 01:52:09', '116.48.156.216', NULL, NULL, NULL, NULL, 'PEND', '2017-09-25 09:52:09', '116.48.156.216', 3, NULL, NULL, NULL, NULL, NULL, 'online', '688.00', NULL, NULL, NULL, '588.00', NULL, '100.00', NULL, NULL, NULL, NULL, NULL, NULL),
(263, NULL, '2017-09-26 16:12:40', '2017-09-26 08:12:40', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-26 16:12:40', '218.103.118.116', 3, NULL, NULL, NULL, NULL, NULL, 'shop', '3000.00', NULL, NULL, NULL, '3000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(264, NULL, '2017-09-26 16:35:45', '2017-09-26 08:35:45', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-26 16:35:45', '218.103.118.116', 3, NULL, NULL, NULL, NULL, NULL, 'shop', '3000.00', NULL, NULL, NULL, '3000.00', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL),
(265, NULL, '2017-09-27 15:14:10', '2017-09-27 07:14:10', '116.48.156.216', NULL, NULL, NULL, NULL, 'PEND', '2017-09-27 15:14:10', '116.48.156.216', 3, '12610', NULL, NULL, NULL, NULL, 'online', '688.00', NULL, NULL, NULL, '538.00', NULL, '150.00', NULL, NULL, NULL, NULL, NULL, NULL),
(266, NULL, '2017-09-27 16:03:45', '2017-09-27 08:03:45', '218.103.118.116', NULL, NULL, NULL, NULL, 'PEND', '2017-09-27 16:03:45', '218.103.118.116', 3, '12611', NULL, NULL, NULL, NULL, 'online', '688.00', NULL, NULL, NULL, '538.00', NULL, '150.00', NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `po_st_log`
--

CREATE TABLE `po_st_log` (
  `pslog_id` bigint(20) NOT NULL,
  `pslog_po_id` bigint(20) NOT NULL,
  `pslog_crt_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `pslog_crt_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pslog_crt_usr_id` bigint(20) DEFAULT NULL,
  `pslog_st_id` int(11) DEFAULT NULL,
  `pslog_st_dt` datetime DEFAULT NULL,
  `pslog_st_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pslog_st_usr_id` bigint(20) DEFAULT NULL,
  `pslog_msg` text COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `po_x_clientinfo_rltn`
--

CREATE TABLE `po_x_clientinfo_rltn` (
  `pxcr_id` int(11) NOT NULL,
  `pxcr_po_id` int(11) NOT NULL,
  `pxcr_crt_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `pxcr_crt_ip` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pxcr_crt_usr_id` int(11) DEFAULT NULL,
  `pxcr_mod_dt` datetime DEFAULT NULL,
  `pxcr_mod_ip` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pxcr_mod_usr_id` int(11) DEFAULT NULL,
  `pxcr_name` varchar(255) DEFAULT NULL,
  `pxcr_phone` int(8) DEFAULT NULL,
  `pxcr_email` varchar(255) DEFAULT NULL,
  `pxcr_booking_date` date DEFAULT NULL,
  `pxcr_booking_time` varchar(255) DEFAULT NULL,
  `pxcr_booking_shop` varchar(255) DEFAULT NULL,
  `pxcr_interested` varchar(255) DEFAULT NULL,
  `pxcr_findus` varchar(255) DEFAULT NULL,
  `pxcr_message` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `po_x_clientinfo_rltn`
--

REPLACE INTO `po_x_clientinfo_rltn` (`pxcr_id`, `pxcr_po_id`, `pxcr_crt_dt`, `pxcr_crt_ip`, `pxcr_crt_usr_id`, `pxcr_mod_dt`, `pxcr_mod_ip`, `pxcr_mod_usr_id`, `pxcr_name`, `pxcr_phone`, `pxcr_email`, `pxcr_booking_date`, `pxcr_booking_time`, `pxcr_booking_shop`, `pxcr_interested`, `pxcr_findus`, `pxcr_message`) VALUES
(1, 234, '2017-09-11 11:44:33', '218.103.118.116', NULL, NULL, NULL, NULL, 'Chan Tai Man', 99988999, 'easttech.dev@gmail.com', '2017-09-20', '11:30', '中環 - 都爹利街樂成行', '全面', 'Facebook', ''),
(2, 235, '2017-09-11 11:45:26', '218.103.118.116', NULL, NULL, NULL, NULL, 'Chan Tai Man', 99988999, 'easttech.dev@gmail.com', '2017-09-20', '11:30', '中環 - 都爹利街樂成行', '全面', 'Facebook', ''),
(3, 236, '2017-09-11 11:48:20', '218.103.118.116', NULL, NULL, NULL, NULL, 'Chan Tai Man', 99988999, 'easttech.dev@gmail.com', '2017-09-20', '11:30', '中環 - 都爹利街樂成行', '全面', 'Facebook', ''),
(4, 237, '2017-09-11 12:16:39', '218.103.118.116', NULL, NULL, NULL, NULL, 'Chan Tai Man', 99988999, 'easttech.dev@gmail.com', '2017-09-20', '11:30', '中環 - 都爹利街樂成行', '全面', 'Facebook', ''),
(5, 238, '2017-09-11 12:20:25', '218.103.118.116', NULL, NULL, NULL, NULL, 'Chan Tai Man', 99988999, 'easttech.dev@gmail.com', '2017-09-28', '11:30', '中環 - 都爹利街樂成行', '全面', 'Facebook', ''),
(6, 239, '2017-09-11 12:24:07', '218.103.118.116', NULL, NULL, NULL, NULL, 'Chan Tai Man', 99988999, 'easttech.dev@gmail.com', '2017-09-23', '11:30', '中環 - 都爹利街樂成行', '全面', 'Facebook', ''),
(7, 240, '2017-09-11 12:30:33', '218.103.118.116', NULL, NULL, NULL, NULL, 'dsfsdfs', 12345678, 'web20@easttech.com.hk', '2017-09-26', '13:30', '九龍灣 - 德福大廈', '全面', 'Facebook', 'sxfsdf'),
(8, 241, '2017-09-12 01:52:27', '218.103.118.116', NULL, NULL, NULL, NULL, 'Testing', 12345678, 'web20@easttech.com.hk', '2017-09-27', '14:00', '灣仔 - 灣仔中心', '全面', 'Google', 'testing'),
(9, 242, '2017-09-12 01:53:01', '218.103.118.116', NULL, NULL, NULL, NULL, 'tt Juno', 12345678, 'web20@easttech.com.hk', '2017-09-22', '11:30', '將軍澳 - 都會駅商場', '雙下巴', 'Google', 'daff'),
(10, 243, '2017-09-12 07:21:40', '218.103.118.116', NULL, NULL, NULL, NULL, 'asdasd', 12345678, 'web20@easttech.com.hk', '2017-09-26', '11:30', '旺角 - 柏裕商業中心', '全面', 'Facebook', 'ASDAD'),
(11, 244, '2017-09-12 07:22:10', '218.103.118.116', NULL, NULL, NULL, NULL, 'asdasd', 12345678, 'web20@easttech.com.hk', '2017-09-26', '11:30', '旺角 - 柏裕商業中心', '全面', 'Facebook', 'ASDAD'),
(12, 245, '2017-09-12 09:53:14', '218.103.118.116', NULL, NULL, NULL, NULL, 'Juno', 12345678, 'web20@easttech.com.hk', '2017-09-18', '11:30', '中環 - 都爹利街樂成行', '全面', 'Facebook', 'asd'),
(13, 246, '2017-09-12 10:02:29', '218.103.118.116', NULL, NULL, NULL, NULL, 'Juno', 12345678, 'web20@easttech.com.hk', '2017-09-19', '11:30', '中環 - 都爹利街樂成行', '全面', 'Facebook', 'asd'),
(14, 247, '2017-09-13 02:06:14', '218.103.118.116', NULL, NULL, NULL, NULL, 'Juno', 12345678, 'web30@easttech.com.hk', '2017-09-27', '11:30', '尖沙咀 - 美麗華大廈', '肚腩', 'Facebook', 'SDFSFD'),
(15, 248, '2017-09-13 02:07:14', '218.103.118.116', NULL, NULL, NULL, NULL, 'Juno', 12345678, 'web30@easttech.com.hk', '2017-09-19', '14:00', '尖沙咀 - 美麗華大廈', '肚腩', 'Facebook', 'ADS'),
(16, 249, '2017-09-13 02:08:27', '218.103.118.116', NULL, NULL, NULL, NULL, 'Juno', 12345678, 'web30@easttech.com.hk', '2017-09-19', '14:00', '尖沙咀 - 美麗華大廈', '肚腩', 'Facebook', 'ADS'),
(17, 250, '2017-09-13 02:09:23', '218.103.118.116', NULL, NULL, NULL, NULL, 'Juno', 12345678, 'web20@easttech.com.hk', '2017-09-27', '11:30', '尖沙咀 - 美麗華大廈', '肚腩', 'Facebook', 'ASF'),
(18, 251, '2017-09-14 04:00:13', '116.48.156.216', NULL, NULL, NULL, NULL, 'zoietesting', 12341234, 'zoie.leung@youbeauty.com', '2017-09-14', '11:30', '中環 - 都爹利街樂成行', '肚臍下方', 'Facebook', ''),
(19, 252, '2017-09-15 02:06:56', '116.48.156.216', NULL, NULL, NULL, NULL, 'zoietesting', 12341234, 'zoie.leung@youbeauty.com', '2017-09-16', '12:00', '銅鑼 - 信和廣場', '360°上手臂', 'Facebook', ''),
(20, 253, '2017-09-15 04:07:14', '116.48.156.216', NULL, NULL, NULL, NULL, 'zoietesting', 12341234, 'zoie.leung@youbeauty.com', '2017-09-16', '12:00', '銅鑼 - 信和廣場', '360°上手臂', 'Facebook', ''),
(21, 254, '2017-09-19 03:13:13', '116.48.156.216', NULL, NULL, NULL, NULL, 'tset', 22222222, '22@yahoo.com.hk', '2017-09-29', '11:30', '尖沙咀 - 美麗華大廈', '全面', 'IG', 'tet'),
(22, 255, '2017-09-20 03:58:12', '116.48.156.216', NULL, NULL, NULL, NULL, 'zoietesting', 23456789, 'zoie.leung@youbeauty.com', '2017-09-20', '19:00', '九龍灣 - 德福大廈', '面脥', 'Facebook', ''),
(23, 256, '2017-09-20 06:32:59', '116.48.156.216', NULL, NULL, NULL, NULL, 'zoietesting', 98745632, 'zoie.leung@youbeauty.com', '2017-09-21', '11:30', '中環 - 都爹利街樂成行', '額頭', 'IG', 'tesrting'),
(24, 257, '2017-09-20 06:38:22', '116.48.156.216', NULL, NULL, NULL, NULL, 'zoietesting', 98765432, 'zoie.leung@youbeauty.com', '2017-09-29', '18:30', '中環 - 都爹利街樂成行', '額頭', 'IG', 't'),
(25, 258, '2017-09-20 06:44:54', '116.48.156.216', NULL, NULL, NULL, NULL, 'zoietesting', 12345678, 'zoie.leung@youbeauty.com', '2017-09-21', '18:00', '尖沙咀 - 美麗華大廈', '蘋果肌', 'IG', 'testing'),
(26, 259, '2017-09-21 03:48:46', '218.103.118.116', NULL, NULL, NULL, NULL, 'Juno', 12345678, 'web20@easttech.com.hk', '2017-09-28', '11:30', '中環 - 都爹利街樂成行', '全面', 'IG', 'dadas'),
(27, 260, '2017-09-21 04:57:35', '116.48.156.216', NULL, NULL, NULL, NULL, 'zoietesting', 12345678, 'zoie.leung@youbeauty.com', '2017-09-21', '18:30', '九龍灣 - 德福大廈8樓', '全面', 'IG', ''),
(28, 261, '2017-09-25 01:49:31', '116.48.156.216', NULL, NULL, NULL, NULL, 'zoietesting', 12345678, 'zoie.leung@youbeauty.com', '2017-09-25', '11:30', '中環 - 都爹利街樂成行', '全面', 'IG', ''),
(29, 262, '2017-09-25 01:52:09', '116.48.156.216', NULL, NULL, NULL, NULL, 'zoietesting', 12345678, 'zoie.leung@youbeauty.com', '2017-09-25', '11:30', '中環 - 都爹利街樂成行', '全面', 'IG', ''),
(30, 263, '2017-09-26 08:12:40', '218.103.118.116', NULL, NULL, NULL, NULL, 'Juno', 12345678, 'web30@easttech.com.hk', '2017-09-27', '11:30', '中環 - 都爹利街樂成行', '全面', 'IG', 'sadasd'),
(31, 264, '2017-09-26 08:35:45', '218.103.118.116', NULL, NULL, NULL, NULL, 'Juno', 12345678, 'web20@easttech.com.hk', '2017-09-27', '11:30', '中環 - 都爹利街樂成行', '全面', 'IG', 'ytgf'),
(32, 265, '2017-09-27 07:14:10', '116.48.156.216', NULL, NULL, NULL, NULL, 'zoietesting', 12345678, 'zoie.leung@youbeauty.com', '2017-09-27', '18:00', '九龍灣 - 德福大廈', '心口', 'Google', ''),
(33, 266, '2017-09-27 08:03:45', '218.103.118.116', NULL, NULL, NULL, NULL, 'asdasd', 12345678, 'web30@easttech.com.hk', '2017-09-30', '11:30', '中環 - 都爹利街樂成行', '全面', 'IG', 'SDFDSFSD');

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

--
-- Table structure for table `po_x_coupon_rltn`
--

CREATE TABLE `po_x_coupon_rltn` (
  `poxcr_id` bigint(20) NOT NULL,
  `poxcr_po_id` bigint(20) NOT NULL,
  `poxcr_cp_id` bigint(20) NOT NULL,
  `poxcr_crt_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `poxcr_crt_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poxcr_crt_usr_id` bigint(20) DEFAULT NULL,
  `poxcr_mod_dt` datetime DEFAULT NULL,
  `poxcr_mod_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poxcr_mod_usr_id` bigint(20) DEFAULT NULL,
  `poxcr_cp_cd` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poxcr_discount_total` decimal(8,2) DEFAULT NULL,
  `poxcr_purchase` decimal(8,2) DEFAULT NULL,
  `poxcr_cp_tp` tinyint(4) DEFAULT NULL,
  `poxcr_cp_over_purchase` decimal(8,2) DEFAULT NULL,
  `poxcr_cp_price` decimal(8,2) DEFAULT NULL,
  `poxcr_cp_percent` int(11) DEFAULT NULL,
  `poxcr_cp_eff_start_dt` datetime DEFAULT NULL,
  `poxcr_cp_eff_end_dt` datetime DEFAULT NULL,
  `poxcr_cp_use_limit` int(11) DEFAULT NULL,
  `poxcr_cp_no_expiry` tinyint(4) DEFAULT NULL,
  `poxcr_cp_over_qty` int(11) DEFAULT NULL,
  `poxcr_cp_amt_req` tinyint(4) DEFAULT NULL,
  `poxcr_cp_qty_req` tinyint(4) DEFAULT NULL,
  `poxcr_cp_multi_cp` tinyint(4) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `po_x_coupon_rltn`
--

REPLACE INTO `po_x_coupon_rltn` (`poxcr_id`, `poxcr_po_id`, `poxcr_cp_id`, `poxcr_crt_dt`, `poxcr_crt_ip`, `poxcr_crt_usr_id`, `poxcr_mod_dt`, `poxcr_mod_ip`, `poxcr_mod_usr_id`, `poxcr_cp_cd`, `poxcr_discount_total`, `poxcr_purchase`, `poxcr_cp_tp`, `poxcr_cp_over_purchase`, `poxcr_cp_price`, `poxcr_cp_percent`, `poxcr_cp_eff_start_dt`, `poxcr_cp_eff_end_dt`, `poxcr_cp_use_limit`, `poxcr_cp_no_expiry`, `poxcr_cp_over_qty`, `poxcr_cp_amt_req`, `poxcr_cp_qty_req`, `poxcr_cp_multi_cp`) VALUES
(1, 0, 5, '2017-09-12 09:53:14', '218.103.118.116', 3, NULL, NULL, NULL, 'TEST-892-2017SEP', NULL, NULL, NULL, NULL, '100.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 0, 4, '2017-09-12 10:02:29', '218.103.118.116', 3, NULL, NULL, NULL, 'TEST-538-2017SEP', NULL, NULL, NULL, NULL, '100.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 0, 3, '2017-09-13 02:06:14', '218.103.118.116', 3, NULL, NULL, NULL, 'TEST-646-2017SEP', NULL, NULL, NULL, NULL, '100.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 0, 0, '2017-09-14 04:00:13', '116.48.156.216', 3, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 0, 0, '2017-09-15 02:06:56', '116.48.156.216', 3, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 0, 0, '2017-09-19 03:13:12', '116.48.156.216', 3, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 0, 0, '2017-09-20 03:58:12', '116.48.156.216', 3, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 0, 16, '2017-09-20 06:32:59', '116.48.156.216', 3, NULL, NULL, NULL, 'hifu680free', NULL, NULL, NULL, NULL, '680.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9, 0, 0, '2017-09-20 06:38:22', '116.48.156.216', 3, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10, 0, 17, '2017-09-20 06:44:54', '116.48.156.216', 3, NULL, NULL, NULL, 'ABC2017CDE', NULL, NULL, NULL, NULL, '600.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, 0, 18, '2017-09-21 03:48:46', '218.103.118.116', 3, NULL, NULL, NULL, 'ABCABC123', NULL, NULL, NULL, NULL, '600.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(12, 0, 0, '2017-09-21 04:57:35', '116.48.156.216', 3, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, 0, 29, '2017-09-25 01:49:30', '116.48.156.216', 3, NULL, NULL, NULL, '12305617321', NULL, NULL, NULL, NULL, '100.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(14, 0, 28, '2017-09-25 01:52:09', '116.48.156.216', 3, NULL, NULL, NULL, '12395139321', NULL, NULL, NULL, NULL, '100.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(15, 0, 39, '2017-09-27 07:14:10', '116.48.156.216', 3, NULL, NULL, NULL, 'test1234test', NULL, NULL, NULL, NULL, '150.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, 0, 39, '2017-09-27 08:03:45', '218.103.118.116', 3, NULL, NULL, NULL, 'test1234test', NULL, NULL, NULL, NULL, '150.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `po_x_prd_rltn`
--

CREATE TABLE `po_x_prd_rltn` (
  `poxpr_id` bigint(20) NOT NULL,
  `poxpr_po_id` bigint(20) NOT NULL,
  `poxpr_prd_id` bigint(20) NOT NULL,
  `poxpr_lang` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poxpr_sort_lv` int(11) DEFAULT '0',
  `poxpr_sort_id` bigint(20) DEFAULT '99999',
  `poxpr_crt_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `poxpr_crt_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poxpr_crt_usr_id` bigint(20) DEFAULT NULL,
  `poxpr_mod_dt` datetime DEFAULT NULL,
  `poxpr_mod_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poxpr_mod_usr_id` bigint(20) DEFAULT NULL,
  `poxpr_qty` int(11) DEFAULT NULL,
  `poxpr_unit_price` decimal(8,2) DEFAULT NULL,
  `poxpr_price` decimal(8,2) DEFAULT NULL,
  `poxpr_sp_price` decimal(8,2) DEFAULT NULL,
  `poxpr_pc_id` bigint(20) DEFAULT NULL,
  `poxpr_pc_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poxpr_prd_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poxpr_prd_code` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poxpr_disc_id` bigint(20) DEFAULT NULL,
  `poxpr_prd_sale_unit` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poxpr_online_price` decimal(8,2) DEFAULT NULL,
  `poxpr_shop_price` decimal(8,2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `po_x_prd_rltn`
--

REPLACE INTO `po_x_prd_rltn` (`poxpr_id`, `poxpr_po_id`, `poxpr_prd_id`, `poxpr_lang`, `poxpr_sort_lv`, `poxpr_sort_id`, `poxpr_crt_dt`, `poxpr_crt_ip`, `poxpr_crt_usr_id`, `poxpr_mod_dt`, `poxpr_mod_ip`, `poxpr_mod_usr_id`, `poxpr_qty`, `poxpr_unit_price`, `poxpr_price`, `poxpr_sp_price`, `poxpr_pc_id`, `poxpr_pc_name`, `poxpr_prd_name`, `poxpr_prd_code`, `poxpr_disc_id`, `poxpr_prd_sale_unit`, `poxpr_online_price`, `poxpr_shop_price`) VALUES
(650, 233, 11, NULL, 0, 99999, '2017-09-11 11:43:36', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(651, 234, 11, NULL, 0, 99999, '2017-09-11 11:44:33', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(652, 235, 11, NULL, 0, 99999, '2017-09-11 11:45:26', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(653, 236, 11, NULL, 0, 99999, '2017-09-11 11:48:20', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(654, 237, 11, NULL, 0, 99999, '2017-09-11 12:16:39', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(655, 238, 11, NULL, 0, 99999, '2017-09-11 12:20:25', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(656, 239, 11, NULL, 0, 99999, '2017-09-11 12:24:07', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(657, 240, 11, NULL, 0, 99999, '2017-09-11 12:30:33', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(658, 241, 11, NULL, 0, 99999, '2017-09-12 01:52:27', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(659, 242, 20, NULL, 0, 99999, '2017-09-12 01:53:01', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'HIFU立體輪廓', NULL, NULL, NULL, '99.00', '999.00'),
(660, 243, 11, NULL, 0, 99999, '2017-09-12 07:21:40', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(661, 244, 11, NULL, 0, 99999, '2017-09-12 07:22:10', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(662, 245, 11, NULL, 0, 99999, '2017-09-12 09:53:14', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(663, 246, 11, NULL, 0, 99999, '2017-09-12 10:02:29', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(664, 247, 17, NULL, 0, 99999, '2017-09-13 02:06:14', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '全方位擊脂程式', NULL, NULL, NULL, '1000.00', '3000.00'),
(665, 248, 17, NULL, 0, 99999, '2017-09-13 02:07:14', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '全方位擊脂程式', NULL, NULL, NULL, '1000.00', '3000.00'),
(666, 249, 17, NULL, 0, 99999, '2017-09-13 02:08:27', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '全方位擊脂程式', NULL, NULL, NULL, '1000.00', '3000.00'),
(667, 250, 17, NULL, 0, 99999, '2017-09-13 02:09:23', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '全方位擊脂程式', NULL, NULL, NULL, '1000.00', '3000.00'),
(668, 251, 11, NULL, 0, 99999, '2017-09-14 04:00:13', '116.48.156.216', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1000.00', '3000.00'),
(669, 252, 11, NULL, 0, 99999, '2017-09-15 02:06:56', '116.48.156.216', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1.00', '3000.00'),
(670, 253, 11, NULL, 0, 99999, '2017-09-15 04:07:14', '116.48.156.216', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '1.00', '3000.00'),
(671, 254, 8, NULL, 0, 99999, '2017-09-19 03:13:13', '116.48.156.216', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '皮秒袪斑療程', NULL, NULL, NULL, '2980.00', '6000.00'),
(672, 255, 20, NULL, 0, 99999, '2017-09-20 03:58:12', '116.48.156.216', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'HIFU立體輪廓', NULL, NULL, NULL, '680.00', '1800.00'),
(673, 256, 20, NULL, 0, 99999, '2017-09-20 06:32:59', '116.48.156.216', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'HIFU立體輪廓', NULL, NULL, NULL, '680.00', '1800.00'),
(674, 257, 20, NULL, 0, 99999, '2017-09-20 06:38:22', '116.48.156.216', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'HIFU立體輪廓', NULL, NULL, NULL, '680.00', '1800.00'),
(675, 258, 20, NULL, 0, 99999, '2017-09-20 06:44:54', '116.48.156.216', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'HIFU立體輪廓', NULL, NULL, NULL, '680.00', '1800.00'),
(676, 259, 11, NULL, 0, 99999, '2017-09-21 03:48:46', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '688.00', '3000.00'),
(677, 260, 11, NULL, 0, 99999, '2017-09-21 04:57:35', '116.48.156.216', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '688.00', '3000.00'),
(678, 261, 11, NULL, 0, 99999, '2017-09-25 01:49:30', '116.48.156.216', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '688.00', '3000.00'),
(679, 262, 11, NULL, 0, 99999, '2017-09-25 01:52:09', '116.48.156.216', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '688.00', '3000.00'),
(680, 263, 11, NULL, 0, 99999, '2017-09-26 08:12:40', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '688.00', '3000.00'),
(681, 264, 11, NULL, 0, 99999, '2017-09-26 08:35:45', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '688.00', '3000.00'),
(682, 265, 11, NULL, 0, 99999, '2017-09-27 07:14:10', '116.48.156.216', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '688.00', '3000.00'),
(683, 266, 11, NULL, 0, 99999, '2017-09-27 08:03:45', '218.103.118.116', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '激光脫毛', NULL, NULL, NULL, '688.00', '3000.00');

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

--
-- Table structure for table `promotion`
--

CREATE TABLE `promotion` (
  `promotion_sys_id` bigint(20) NOT NULL,
  `promotion_id` bigint(20) DEFAULT NULL,
  `promotion_lang` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `promotion_dt` varchar(18) COLLATE utf8_unicode_ci NOT NULL,
  `promotion_crt_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `promotion_crt_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `promotion_crt_usr_id` int(11) DEFAULT NULL,
  `promotion_mod_dt` datetime DEFAULT NULL,
  `promotion_mod_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `promotion_mod_usr_id` int(11) DEFAULT NULL,
  `promotion_sort_id` int(11) DEFAULT '999',
  `promotion_sort_lv` int(11) DEFAULT '0',
  `promotion_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `promotion_cate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `promotion_cover` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `promotion_content` mediumtext COLLATE utf8_unicode_ci,
  `promotion_online_price` decimal(8,2) NOT NULL,
  `promotion_shop_price` decimal(8,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `promotion`
--

REPLACE INTO `promotion` (`promotion_sys_id`, `promotion_id`, `promotion_lang`, `promotion_dt`, `promotion_crt_dt`, `promotion_crt_ip`, `promotion_crt_usr_id`, `promotion_mod_dt`, `promotion_mod_ip`, `promotion_mod_usr_id`, `promotion_sort_id`, `promotion_sort_lv`, `promotion_name`, `promotion_cate`, `promotion_cover`, `promotion_content`, `promotion_online_price`, `promotion_shop_price`) VALUES
(9, 7, 'sc', '', '2017-08-25 10:29:32', '116.48.156.216', 1, '2017-09-27 14:04:45', '116.48.156.216', 1, 2, 0, '皮秒袪斑療程', NULL, 'UB_Web_pROMOT1.png|/attachment/promotionCoverImg/1504237065ITvr3.png', '<p><span style="color:#333333; font-size:24px">全方位击脂程式，1个疗程 极速减吋<br />\r\n定位击脂 &nbsp;&nbsp; 隔空溶脂 &nbsp;&nbsp; 超频爆脂</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="color:#333333; font-size:18px"><strong>全球认可有效撃破脂肪细胞技术! 纤体要先歼灭脂肪细胞；瘦身，要由细胞开始瘦起</strong></span></p>\r\n\r\n<p><br />\r\n<img src="../img/promotion_detail_simple.jpg" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="color:#6b70a4">UltraShape V3 定位击脂程式，全球认可减少脂肪细胞数目击脂技术! 定位追踪、直接击破脂肪细胞而不伤肌肉。</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul style="list-style-type:disc; margin-left:0; margin-right:0">\r\n	<li>3D 引导摄像头，精确计算脂肪区域</li>\r\n	<li>聚焦超声传感器，深入脂肪层，直接将脂肪细胞击碎</li>\r\n	<li>RF真空负压，预热及击破脂肪细胞</li>\r\n	<li>全球57个国家，超过15份医学报告及文献证实，超过30 万个成功案例</li>\r\n	<li>无痛、无瘀青、无创伤、无须使用塑身衣、无需復原期</li>\r\n	<li>平均可减少3.3cm ~6.3cm，尤其针对腰腹、大腿顽固部位的赘肉</li>\r\n</ul>\r\n\r\n<p><br />\r\n<img src="../img/promotion_detail_simple_2.jpg" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="color:#6b70a4">Vanquish Me 隔空溶脂程式，世界首创非触式隔空溶脂设备，180度特大RF治疗板面，直击顽固脂肪层，30分钟达到即时、持久瘦身效果。</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul style="list-style-type:disc; margin-left:0; margin-right:0">\r\n	<li>荣获欧洲美容权威媒体The Aesthetic Guide颁发「最佳纤体塑形仪器」大奬</li>\r\n	<li>直击皮下5mm-15mm顽固性脂肪层</li>\r\n	<li>选择性射频技术及调谐专利技术，自动调节能量流，确保安全</li>\r\n	<li>医学临床个案一个月四次疗程最高可减达13cm</li>\r\n</ul>\r\n\r\n<p><br />\r\n<img src="../img/promotion_detail_simple_3.jpg" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="color:#6b70a4">X Wave 超频爆脂程式，以衝击波传递高能量，只需7分钟即可击散脂肪之间的钙化组织及加速爆脂程序。</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul style="list-style-type:disc; margin-left:0; margin-right:0">\r\n	<li>促进细胞自我修復</li>\r\n	<li>刺激胶原母细胞生长，重塑胶原</li>\r\n	<li>加促血液及淋巴循环，有效去水肿及排走代谢脂肪</li>\r\n	<li>经临床测试89% 的使用者会向其他人推荐X Wave</li>\r\n</ul>', '2980.00', '6000.00'),
(8, 7, 'tc', '', '2017-08-25 10:29:32', '116.48.156.216', 1, '2017-09-27 14:04:45', '116.48.156.216', 1, 2, 0, '皮秒袪斑療程', NULL, 'UB_Web_pROMOT1.png|/attachment/promotionCoverImg/1504237065ITvr3.png', '<p><span style="font-size:18px"><strong>皮秒激光如何激袪色斑</strong></span></p>\r\n\r\n<p><span style="font-size:16px">皮秒是比納秒快1000倍的時間單位。皮秒激光比傳統納秒激光的脈衝時間短10倍，能量於極短時間被黑色素吸收，尤其適合亞洲人皮膚。皮秒激光透過光機械衝擊壓力 (Photomechanical effect)，即以光震碎目標色素，而不是被熱能破壞，可以更少治療次數達更佳去斑效果。</span></p>\r\n\r\n<p><span style="font-size:16px">相比納秒激光對目標色素及周邊皮膚組織產生熱能而可能引發的肌膚傷害（反白、反黑），皮秒則減低了熱效應引起的副作用。被激光震碎的色素由於如塵般細小，能更快被皮膚代謝及清除。</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Doscovery PICO 3-2.jpg" style="height:242px; width:918px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:18px"><strong>皮秒激光VS其他技術</strong></span></p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/PICO_Table.png" style="height:376px; width:1000px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:18px"><strong>Discovery PICO激光優點：</strong></span></p>\r\n\r\n<ul>\r\n	<li><span style="font-size:14px">FDA及CE安全認可</span></li>\r\n	<li><span style="font-size:14px">榮獲2017年「最佳皮秒技術大獎」</span></li>\r\n	<li><span style="font-size:14px">以最快激光震碎色斑，以最少的治療次數達到更佳去斑效果</span></li>\r\n	<li><span style="font-size:14px">特設雙激光系統，可治療深層(1064nm)及淺層(532nm)色斑，徹底去斑，不易反黑</span></li>\r\n	<li><span style="font-size:14px">特別針對深層色斑、荷爾蒙斑（黃褐斑／蝴蝶斑）等</span></li>\r\n	<li><span style="font-size:14px">獨有平帽式方形激光治療頭，均勻覆蓋肌膚</span></li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:18px"><strong>獨有平帽式方形激光</strong></span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Discovery PICO 3-3.jpg" style="height:276px; width:910px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>', '2980.00', '6000.00'),
(7, 7, 'en', '', '2017-08-25 10:29:32', '116.48.156.216', 1, '2017-09-27 14:04:45', '116.48.156.216', 1, 2, 0, '皮秒袪斑療程 en', NULL, 'UB_Web_pROMOT1.png|/attachment/promotionCoverImg/1504237065ITvr3.png', '<p><span style="color:#333333; font-size:24px">全方位擊脂程式，1個療程 極速減吋<br />\r\n定位擊脂 &nbsp;&nbsp; 隔空溶脂 &nbsp;&nbsp; 超頻爆脂</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="color:#333333; font-size:18px"><strong>全球認可有效撃破脂肪細胞技術! 纖體要先殲滅脂肪細胞；瘦身，要由細胞開始瘦起</strong></span></p>\r\n\r\n<p><br />\r\n<img src="../img/promotion_detail_simple.jpg" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="color:#6b70a4">UltraShape V3 定位擊脂程式，全球認可減少脂肪細胞數目擊脂技術! 定位追蹤、直接擊破脂肪細胞而不傷肌肉。</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul style="list-style-type:disc; margin-left:0; margin-right:0">\r\n	<li>3D 引導攝像頭，精確計算脂肪區域</li>\r\n	<li>聚焦超聲傳感器，深入脂肪層，直接將脂肪細胞擊碎</li>\r\n	<li>RF真空負壓，預熱及擊破脂肪細胞</li>\r\n	<li>全球57個國家，超過15份醫學報告及文獻證實，超過30 萬個成功案例</li>\r\n	<li>無痛、無瘀青、無創傷、無須使用塑身衣、無需復原期</li>\r\n	<li>平均可減少3.3cm ~6.3cm，尤其針對腰腹、大腿頑固部位的贅肉</li>\r\n</ul>\r\n\r\n<p><br />\r\n<img src="../img/promotion_detail_simple_2.jpg" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="color:#6b70a4">Vanquish Me 隔空溶脂程式，世界首創非觸式隔空溶脂設備，180度特大RF治療板面，直擊頑固脂肪層，30分鐘達到即時、持久瘦身效果。</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul style="list-style-type:disc; margin-left:0; margin-right:0">\r\n	<li>榮獲歐洲美容權威媒體The Aesthetic Guide頒發「最佳纖體塑形儀器」大奬</li>\r\n	<li>直擊皮下5mm-15mm頑固性脂肪層</li>\r\n	<li>選擇性射頻技術及調諧專利技術，自動調節能量流，確保安全</li>\r\n	<li>醫學臨床個案一個月四次療程最高可減達13cm</li>\r\n</ul>\r\n\r\n<p><br />\r\n<img src="../img/promotion_detail_simple_3.jpg" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="color:#6b70a4">X Wave 超頻爆脂程式，以衝擊波傳遞高能量，只需7分鐘即可擊散脂肪之間的鈣化組織及加速爆脂程序。</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul style="list-style-type:disc; margin-left:0; margin-right:0">\r\n	<li>促進細胞自我修復</li>\r\n	<li>刺激膠原母細胞生長，重塑膠原</li>\r\n	<li>加促血液及淋巴循環，有效去水腫及排走代謝脂肪</li>\r\n	<li>經臨床測試89% 的使用者會向其他人推薦X Wave</li>\r\n</ul>', '2980.00', '6000.00'),
(17, 16, 'tc', '', '2017-08-29 11:10:25', '116.48.156.216', 1, '2017-09-18 17:31:47', '116.48.156.216', 1, 4, 0, '全方位擊脂程式', NULL, 'YOU WEB Sub Banner_Medical-10.jpg|/attachment/promotionCoverImg/1505727107BakFL.jpg', '<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:20px"><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</strong></span><span style="font-size:24px"><strong>&nbsp;全方位擊脂程式，1個療程 極速減吋</strong></span></p>\r\n\r\n<p><span style="font-size:24px"><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 定位擊脂&nbsp;&nbsp;&nbsp;&nbsp; 隔空溶脂 &nbsp; &nbsp;</strong></span></p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/YOU Promo for WEB_170602-05.jpg" style="height:435px; width:800px" /></p>\r\n\r\n<p>全球熱賣破壞脂肪細胞技術!&nbsp;纖體要先殲滅脂肪細胞；瘦身，要由細胞開始瘦起</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:14px"><strong>UltraShape V3 定位擊脂程式</strong>，</span>全球熱賣破壞脂肪細胞技術!&nbsp;<span style="font-size:14px"> 定位追蹤、直接擊破脂肪細胞而不傷肌肉。</span></p>\r\n\r\n<ul>\r\n	<li>\r\n	<p><span style="font-size:14px">3D 引導攝像頭，精確計算脂肪區域</span></p>\r\n	</li>\r\n	<li>\r\n	<p><span style="font-size:14px">聚焦超聲傳感器，深入脂肪層，直接將脂肪細胞擊碎</span></p>\r\n	</li>\r\n	<li>\r\n	<p><span style="font-size:14px">RF真空負壓，預熱及擊破脂肪細胞</span></p>\r\n	</li>\r\n	<li>\r\n	<p><span style="font-size:14px">全球57個國家，超過15份醫學報告及文獻證實，超過30 萬個成功案例</span></p>\r\n	</li>\r\n	<li>\r\n	<p><span style="font-size:14px">無痛、無瘀青、無創傷、無須使用塑身衣、無需復原期</span></p>\r\n	</li>\r\n	<li>\r\n	<p><span style="font-size:14px">平均可減少3.3cm ~6.3cm，尤其針對腰腹、大腿頑固部位的贅肉</span></p>\r\n	</li>\r\n</ul>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/YOU Promo for WEB_170602-04.jpg" style="height:435px; width:800px" /></p>\r\n\r\n<p><span style="font-size:14px"><strong>Vanquish Me 隔空溶脂程式</strong>，世界首創非觸式隔空溶脂設備，180度特大RF治療板面，直擊頑固脂肪層，30分鐘達到即時、持久瘦身效果。</span></p>\r\n\r\n<ul>\r\n	<li>\r\n	<p><span style="font-size:14px">榮獲歐洲美容權威媒體The Aesthetic Guide頒發「最佳纖體塑形儀器」大奬</span></p>\r\n	</li>\r\n	<li>\r\n	<p><span style="font-size:14px">直擊皮下5mm-15mm頑固性脂肪層</span></p>\r\n	</li>\r\n	<li>\r\n	<p><span style="font-size:14px">選擇性射頻技術及調諧專利技術，自動調節能量流，確保安全</span></p>\r\n	</li>\r\n	<li>\r\n	<p><span style="font-size:14px">醫學臨床個案一個月四次療程最高可減達13cm</span></p>\r\n	</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>', '1280.00', '3980.00'),
(16, 16, 'en', '', '2017-08-29 11:10:25', '116.48.156.216', 1, '2017-09-18 17:31:47', '116.48.156.216', 1, 4, 0, '全方位擊脂程式', NULL, 'YOU WEB Sub Banner_Medical-10.jpg|/attachment/promotionCoverImg/1505727107BakFL.jpg', '<p><span style="font-size:20px"><strong>全方位擊脂程式，1個療程 極速減吋</strong></span></p>\r\n\r\n<p><span style="font-size:20px"><strong>定位擊脂&nbsp;&nbsp;&nbsp;&nbsp; 隔空溶脂&nbsp;&nbsp;&nbsp;&nbsp; 超頻爆脂</strong></span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:14px">全球認可有效撃破脂肪細胞技術! 纖體要先殲滅脂肪細胞；瘦身，要由細胞開始瘦起</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>UltraShape V3 定位擊脂程式</strong>，全球認可減少脂肪細胞數目擊脂技術! 定位追蹤、直接擊破脂肪細胞而不傷肌肉。</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>3D 引導攝像頭，精確計算脂肪區域</p>\r\n	</li>\r\n	<li>\r\n	<p>聚焦超聲傳感器，深入脂肪層，直接將脂肪細胞擊碎</p>\r\n	</li>\r\n	<li>\r\n	<p>RF真空負壓，預熱及擊破脂肪細胞</p>\r\n	</li>\r\n	<li>\r\n	<p>全球57個國家，超過15份醫學報告及文獻證實，超過30 萬個成功案例</p>\r\n	</li>\r\n	<li>\r\n	<p>無痛、無瘀青、無創傷、無須使用塑身衣、無需復原期</p>\r\n	</li>\r\n	<li>\r\n	<p>平均可減少3.3cm ~6.3cm，尤其針對腰腹、大腿頑固部位的贅肉</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Vanquish Me 隔空溶脂程式</strong>，世界首創非觸式隔空溶脂設備，180度特大RF治療板面，直擊頑固脂肪層，30分鐘達到即時、持久瘦身效果。</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>榮獲歐洲美容權威媒體The Aesthetic Guide頒發「最佳纖體塑形儀器」大奬</p>\r\n	</li>\r\n	<li>\r\n	<p>直擊皮下5mm-15mm頑固性脂肪層</p>\r\n	</li>\r\n	<li>\r\n	<p>選擇性射頻技術及調諧專利技術，自動調節能量流，確保安全</p>\r\n	</li>\r\n	<li>\r\n	<p>醫學臨床個案一個月四次療程最高可減達13cm</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>X Wave 超頻爆脂程式</strong>，以衝擊波傳遞高能量，只需7分鐘即可擊散脂肪之間的鈣化組織及加速爆脂程序。</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>促進細胞自我修復</p>\r\n	</li>\r\n	<li>\r\n	<p>刺激膠原母細胞生長，重塑膠原</p>\r\n	</li>\r\n	<li>\r\n	<p>加促血液及淋巴循環，有效去水腫及排走代謝脂肪</p>\r\n	</li>\r\n	<li>\r\n	<p>經臨床測試89% 的使用者會向其他人推薦X Wave</p>\r\n	</li>\r\n</ul>', '1280.00', '3980.00'),
(10, 10, 'en', '', '2017-08-25 10:30:55', '116.48.156.216', 1, '2017-09-27 14:04:52', '116.48.156.216', 1, 1, 0, '激光脫毛', NULL, 'UB_Web_Web_Banner_Promot1.png|/attachment/promotionCoverImg/1504284203UcLQ8.png', '<p>採用808nm激光脫毛技術，此波長特別針對東方人皮膚，可深入毛根，黑色素吸收能量</p>\r\n\r\n<p><br />\r\n有效摧毀毛髮生長點，不傷皮膚</p>\r\n\r\n<p><br />\r\n毛髮變性萎縮令其細胞失去功能</p>\r\n\r\n<p><br />\r\n約1週後毛髮開始脫離細胞，被推至接近皮膚表面</p>\r\n\r\n<p><br />\r\n約2-3週後毛髮連根脫落</p>\r\n\r\n<p><br />\r\n重覆療程令肌膚白滑幼嫩</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/HRemoval-Grap.jpg" style="height:500px; width:338px" /></p>', '688.00', '3000.00'),
(11, 10, 'tc', '', '2017-08-25 10:30:55', '116.48.156.216', 1, '2017-09-27 14:04:52', '116.48.156.216', 1, 1, 0, '激光脫毛', NULL, 'UB_Web_Web_Banner_Promot1.png|/attachment/promotionCoverImg/1504284203UcLQ8.png', '<p><span style="font-size:14px">採用808nm激光脫毛技術，此波長特別針對東方人皮膚，可深入毛根，黑色素吸收能量</span></p>\r\n\r\n<p><br />\r\n<span style="font-size:14px">有效摧毀毛髮生長點，不傷皮膚</span></p>\r\n\r\n<p><br />\r\n<span style="font-size:14px">毛髮變性萎縮令其細胞失去功能</span></p>\r\n\r\n<p><br />\r\n<span style="font-size:14px">約1週後毛髮開始脫離細胞，被推至接近皮膚表面</span></p>\r\n\r\n<p><br />\r\n<span style="font-size:14px">約2-3週後毛髮連根脫落</span></p>\r\n\r\n<p><br />\r\n<span style="font-size:14px">重覆療程令肌膚白滑幼嫩</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong><span style="font-size:18px">可供選擇部位：</span></strong><br />\r\n&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/688 Hair Removal_Graphic-2-01.jpg" style="height:866px; width:900px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>', '688.00', '3000.00'),
(12, 10, 'sc', '', '2017-08-25 10:30:55', '116.48.156.216', 1, '2017-09-27 14:04:52', '116.48.156.216', 1, 1, 0, '激光脫毛', NULL, 'UB_Web_Web_Banner_Promot1.png|/attachment/promotionCoverImg/1504284203UcLQ8.png', '<p>test tc</p>', '688.00', '3000.00'),
(19, 19, 'en', '', '2017-09-01 07:48:41', '116.48.156.216', 1, '2017-09-27 14:04:38', '116.48.156.216', 1, 3, 0, 'HIFU', NULL, 'YOU WEB Sub Banner_Medical-11.jpg|/attachment/promotionCoverImg/15042538003lYzm.jpg', '<p>「淺表肌腱膜系統」Superficial Muscular Aponeurotic System</p>\r\n\r\n<ul>\r\n	<li>簡稱SMAS</li>\r\n	<li>覆蓋於真皮以下</li>\r\n	<li>連接脂肪與面部淺層結締組織</li>\r\n	<li>與表皮、真皮及脂肪緊密連繫成一體</li>\r\n	<li>鞏固面部輪廓</li>\r\n</ul>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/HIFU_1.jpg" style="height:266px; width:611px" /></p>\r\n\r\n<p><strong>可選擇部位：額頭/ 眼部/ 蘋果肌/ 面脥/ 雙下</strong><strong>巴</strong></p>', '680.00', '1800.00'),
(20, 19, 'tc', '', '2017-09-01 07:48:41', '116.48.156.216', 1, '2017-09-27 14:04:38', '116.48.156.216', 1, 3, 0, 'HIFU立體輪廓', NULL, 'YOU WEB Sub Banner_Medical-11.jpg|/attachment/promotionCoverImg/15042538003lYzm.jpg', '<p>HIFU是高效能聚焦超聲波技術，利用高強度超音波集中於肌膚不同層面；在細胞粒子中高速來回震動，將肌膚組織加熱，從而達致膠原增生、緊緻效果。YOUBEAUTY採用三種探頭，直達三層肌膚。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>「淺表肌腱膜系統」Superficial Muscular Aponeurotic System</p>\r\n\r\n<ul>\r\n	<li>簡稱SMAS</li>\r\n	<li>覆蓋於真皮以下</li>\r\n	<li>連接脂肪與面部淺層結締組織</li>\r\n	<li>與表皮、真皮及脂肪緊密連繫成一體</li>\r\n	<li>鞏固面部輪廓</li>\r\n</ul>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/HIFU_1.jpg" style="height:266px; width:611px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>可選擇部位：額頭/ 眼部/ 蘋果肌/ 面脥/ 雙下</strong><strong>巴</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>', '680.00', '1800.00'),
(21, 19, 'sc', '', '2017-09-01 07:48:41', '116.48.156.216', 1, '2017-09-27 14:04:38', '116.48.156.216', 1, 3, 0, 'HIFU', NULL, 'YOU WEB Sub Banner_Medical-11.jpg|/attachment/promotionCoverImg/15042538003lYzm.jpg', '<p>「浅表肌腱膜系统」Superficial Muscular Aponeurotic System</p>\r\n\r\n<ul>\r\n	<li>简称SMAS</li>\r\n	<li>覆盖于真皮以下</li>\r\n	<li>连接脂肪与面部浅层结缔组织</li>\r\n	<li>与表皮、真皮及脂肪紧密连繫成一体</li>\r\n	<li>巩固面部轮廓</li>\r\n</ul>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/HIFU_1.jpg" style="height:266px; width:611px" /></p>\r\n\r\n<p><strong>可选择部位：额头/ 眼部/ 苹果肌/ 面脥/ 双下</strong><strong>巴</strong></p>', '680.00', '1800.00'),
(18, 16, 'sc', '', '2017-08-29 11:10:25', '116.48.156.216', 1, '2017-09-18 17:31:47', '116.48.156.216', 1, 4, 0, '全方位击脂程式', NULL, 'YOU WEB Sub Banner_Medical-10.jpg|/attachment/promotionCoverImg/1505727107BakFL.jpg', '<p><img alt="" src="/youbeauty/attachment/upload/WEB banner_20170801-04.jpg" style="height:1312px; width:4370px" /></p>\r\n\r\n<p><span style="font-size:14px"><strong>全方位击脂程式，1个疗程 极速减吋</strong></span></p>\r\n\r\n<p><span style="font-size:14px"><strong>定位击脂&nbsp;&nbsp;&nbsp;&nbsp; 隔空溶脂&nbsp;&nbsp;&nbsp;&nbsp; 超频爆脂</strong></span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:14px">全球认可有效撃破脂肪细胞技术! 纤体要先歼灭脂肪细胞；瘦身，要由细胞开始瘦起</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:14px"><img alt="" src="/youbeauty/attachment/upload/YOU Promo for WEB_170602-05.jpg" style="height:1381px; width:2542px" /></span></p>\r\n\r\n<p><strong>UltraShape V3 定位击脂程式</strong>，全球认可减少脂肪细胞数目击脂技术! 定位追踪、直接击破脂肪细胞而不伤肌肉。</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>3D 引导摄像头，精确计算脂肪区域</p>\r\n	</li>\r\n	<li>\r\n	<p>聚焦超声传感器，深入脂肪层，直接将脂肪细胞击碎</p>\r\n	</li>\r\n	<li>\r\n	<p>RF真空负压，预热及击破脂肪细胞</p>\r\n	</li>\r\n	<li>\r\n	<p>全球57个国家，超过15份医学报告及文献证实，超过30 万个成功案例</p>\r\n	</li>\r\n	<li>\r\n	<p>无痛、无瘀青、无创伤、无须使用塑身衣、无需復原期</p>\r\n	</li>\r\n	<li>\r\n	<p>平均可减少3.3cm ~6.3cm，尤其针对腰腹、大腿顽固部位的赘肉</p>\r\n	</li>\r\n</ul>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/YOU Promo for WEB_170602-04.jpg" style="height:1381px; width:2542px" /></p>\r\n\r\n<p><strong>Vanquish Me 隔空溶脂程式</strong>，世界首创非触式隔空溶脂设备，180度特大RF治疗板面，直击顽固脂肪层，30分钟达到即时、持久瘦身效果。</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>荣获欧洲美容权威媒体The Aesthetic Guide颁发「最佳纤体塑形仪器」大奬</p>\r\n	</li>\r\n	<li>\r\n	<p>直击皮下5mm-15mm顽固性脂肪层</p>\r\n	</li>\r\n	<li>\r\n	<p>选择性射频技术及调谐专利技术，自动调节能量流，确保安全</p>\r\n	</li>\r\n	<li>\r\n	<p>医学临床个案一个月四次疗程最高可减达13cm</p>\r\n	</li>\r\n</ul>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/YOU Promo for WEB_170602-06.jpg" style="height:1381px; width:2542px" /></p>\r\n\r\n<p><strong>X Wave 超频爆脂程式</strong>，以衝击波传递高能量，只需7分钟即可击散脂肪之间的钙化组织及加速爆脂程序。</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>促进细胞自我修復</p>\r\n	</li>\r\n	<li>\r\n	<p>刺激胶原母细胞生长，重塑胶原</p>\r\n	</li>\r\n	<li>\r\n	<p>加促血液及淋巴循环，有效去水肿及排走代谢脂肪</p>\r\n	</li>\r\n	<li>\r\n	<p>经临床测试89% 的使用者会向其他人推荐X Wave</p>\r\n	</li>\r\n</ul>', '1280.00', '3980.00');

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

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `service_sys_id` bigint(20) NOT NULL,
  `service_id` bigint(20) DEFAULT NULL,
  `service_nc_id` bigint(20) NOT NULL,
  `service_lang` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `service_dt` varchar(18) COLLATE utf8_unicode_ci NOT NULL,
  `service_crt_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `service_crt_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `service_crt_usr_id` int(11) DEFAULT NULL,
  `service_mod_dt` datetime DEFAULT NULL,
  `service_mod_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `service_mod_usr_id` int(11) DEFAULT NULL,
  `service_sort_id` int(11) NOT NULL DEFAULT '999',
  `service_sort_lv` int(11) DEFAULT '0',
  `service_tp` tinyint(4) DEFAULT NULL,
  `service_cate` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `service_cover` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `service_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `service_content` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `service_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `service_ishow` int(1) NOT NULL,
  `service_homeImg` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `service_isfreeexp` int(1) NOT NULL,
  `service_homeFreeImg` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `service`
--

REPLACE INTO `service` (`service_sys_id`, `service_id`, `service_nc_id`, `service_lang`, `service_dt`, `service_crt_dt`, `service_crt_ip`, `service_crt_usr_id`, `service_mod_dt`, `service_mod_ip`, `service_mod_usr_id`, `service_sort_id`, `service_sort_lv`, `service_tp`, `service_cate`, `service_cover`, `service_title`, `service_content`, `service_url`, `service_ishow`, `service_homeImg`, `service_isfreeexp`, `service_homeFreeImg`) VALUES
(34, 34, 0, 'en', '', '2017-08-31 08:18:47', '218.103.118.116', 1, '2017-09-27 15:06:33', '116.48.156.216', 1, 2, 0, NULL, '7', 'YOU WEB Sub Banner_Medical-04.jpg|/attachment/serviceCoverImg/1506307643R9fO5.jpg', '輪廓重塑 en en', '<p>輪廓重塑 tctc</p>', '', 1, '2.png|/attachment/serviceHomeImg/1505901563zjK3P.png', 0, NULL),
(35, 34, 0, 'tc', '', '2017-08-31 08:18:47', '218.103.118.116', 1, '2017-09-27 15:06:33', '116.48.156.216', 1, 2, 0, NULL, '7', 'YOU WEB Sub Banner_Medical-04.jpg|/attachment/serviceCoverImg/1506307643R9fO5.jpg', 'Botox 瘦面', '<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:24px"><strong><img alt="" src="/youbeauty/attachment/upload/HIFU-1.png" style="height:40px; width:800px" /></strong></span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Botox&reg;是利用肉毒桿菌素萃取來阻斷神經末梢釋放乙醯膽鹼素，控制過度活躍的肌肉，放鬆繃緊肥大的肌肉組織，從而達致收緊及提升效果；在去皺方面，則能放鬆造成皺紋的肌肉，控制動態紋之餘，亦有助預防靜態紋的形成。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Botox 1.jpg" style="height:278px; width:710px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong><span style="font-size:24px">原裝正版入口Botox&reg;</span></strong></p>\r\n\r\n<p><img alt="BOTOX_01" src="http://www.youbeauty.com.hk/wp-content/uploads/2014/08/BOTOX_01.png" style="height:326px; width:303px" /></p>\r\n\r\n<p>Botox&reg;是首個獲得美國食品及藥物管理局(FDA)認可的治療產品，擁有超過25年的臨床經驗，過2800份醫學文獻及研究支持，能快速有效幫助撫平表情紋，已獲全球至少85個國家(包括香港及澳門)及地區的衛生部批准使用。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:24px"><strong><img alt="" src="/youbeauty/attachment/upload/BO-1.png" style="height:40px; width:800px" /></strong></span></p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>改善動態型皺紋</p>\r\n	</li>\r\n	<li>\r\n	<p>改善肌肉型肥胖 (V面、瘦手臂)</p>\r\n	</li>\r\n	<li>\r\n	<p>重點修飾腿形，改善小腿肌肉</p>\r\n	</li>\r\n	<li>\r\n	<p>改善多汗症</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:24px"><strong><img alt="" src="/youbeauty/attachment/upload/BO-2.png" style="height:40px; width:800px" /></strong></span></p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>所有項目由專業註冊醫生主理</p>\r\n	</li>\r\n	<li>\r\n	<p>專業判斷而決定劑量，絶不加劑</p>\r\n	</li>\r\n	<li>\r\n	<p>專業手法，避免造成肌肉僵硬等不自然效果</p>\r\n	</li>\r\n	<li>\r\n	<p>藥品原裝正版，安全可靠</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:24px"><strong><img alt="" src="/youbeauty/attachment/upload/BO-3.png" style="height:40px; width:800px" /></strong></span></p>\r\n\r\n<p>眼紋、眉部、額頭紋、皺眉紋、法令紋、下巴、咀嚼肌、腮位、頸紋</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:14px"><img alt="" src="/youbeauty/attachment/upload/Botox 3.jpg" style="height:352px; width:608px" /><img alt="" src="/youbeauty/attachment/upload/Botox 4.jpg" style="height:275px; width:591px" /></span></p>\r\n\r\n<p><span style="font-size:14px">圖片均取自真實個案，未經任何修飾或數碼處理</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>*效果因人而異</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:11px"><strong>歡迎致電/ Whatsapp 55611505 &nbsp;預約或查詢療程資料</strong></span></p>', '', 1, '2.png|/attachment/serviceHomeImg/1505901563zjK3P.png', 0, NULL),
(36, 34, 0, 'sc', '', '2017-08-31 08:18:47', '218.103.118.116', 1, '2017-09-27 15:06:33', '116.48.156.216', 1, 2, 0, NULL, '7', 'YOU WEB Sub Banner_Medical-04.jpg|/attachment/serviceCoverImg/1506307643R9fO5.jpg', '轮廓重塑 tctc', '<p>轮廓重塑 tctc&nbsp;轮廓重塑 tctc</p>', '', 1, '2.png|/attachment/serviceHomeImg/1505901563zjK3P.png', 0, NULL),
(37, 37, 0, 'en', '', '2017-08-31 08:18:56', '116.48.156.216', 1, '2017-09-27 15:06:57', '116.48.156.216', 1, 2, 0, NULL, '7', 'YOU WEB Sub Banner_Medical-05.jpg|/attachment/serviceCoverImg/15051241309fWfp.jpg', 'Botox瘦面', '<p>guoghopijnp</p>', '', 0, NULL, 0, NULL),
(38, 37, 0, 'tc', '', '2017-08-31 08:18:56', '116.48.156.216', 1, '2017-09-27 15:06:57', '116.48.156.216', 1, 2, 0, NULL, '7', 'YOU WEB Sub Banner_Medical-05.jpg|/attachment/serviceCoverImg/15051241309fWfp.jpg', 'Restylane 豐盈輪廓', '<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:24px"><strong>透明質酸對人體的重要性</strong></span></p>\r\n\r\n<p>透明質酸(Hyaluronic acid)是存在人體的一種天然物質，常見於皮膚、神經和關節。它的分子能攜帶<strong>500</strong>倍以上的水份，具有強大吸水、鎖水能力，可保持肌膚彈性及潤滑關節。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/HIFU-1.png" style="height:40px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:24px"><strong><img alt="" src="/youbeauty/attachment/upload/Restylane.jpg" style="height:257px; width:708px" /></strong></span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Restylane&reg;已獲美國FDA(食物及藥物管理局)認證，具13年臨床研究經驗，以<em>NASHA</em>&trade; 專利技術穩定透明質酸，與人體內的透明質酸相似度達99%，減少排斥及敏感；推出以來已超過2,000萬人次使用，成為全球公認的塑顏產品。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Restylane 4.jpg" style="height:477px; width:659px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/GP-1.png" style="height:40px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>填平幼紋、法令紋及皺紋</p>\r\n	</li>\r\n	<li>\r\n	<p>豐盈輪廓，改善凹陷位</p>\r\n	</li>\r\n	<li>\r\n	<p>提升肌膚光澤度</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:24px"><strong><img alt="" src="/youbeauty/attachment/upload/YOU WEB Sub BarVER2-20.png" style="height:40px; width:800px" /></strong></span></p>\r\n\r\n<p>太陽穴、下巴、蘋果肌、鼻樑、雙唇、頸部、面頰、魚尾紋、淚溝</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:24px"><strong><img alt="" src="/youbeauty/attachment/upload/YOU WEB Sub BarVER2-21.png" style="height:40px; width:800px" /></strong></span></p>\r\n\r\n<p><span style="font-size:24px"><strong><img alt="" src="/youbeauty/attachment/upload/Restylane 2.jpg" style="height:357px; width:443px" /></strong></span></p>\r\n\r\n<p><span style="font-size:24px"><strong><img alt="" src="/youbeauty/attachment/upload/Restylane 3.jpg" style="height:481px; width:565px" /></strong></span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>*效果因人而異</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>歡迎致電/ Whatsapp 55611505 &nbsp;預約或查詢療程資料</strong></p>', '', 0, NULL, 0, NULL),
(39, 37, 0, 'sc', '', '2017-08-31 08:18:56', '116.48.156.216', 1, '2017-09-27 15:06:57', '116.48.156.216', 1, 2, 0, NULL, '7', 'YOU WEB Sub Banner_Medical-05.jpg|/attachment/serviceCoverImg/15051241309fWfp.jpg', 'Botox', '<p>guoghopijnp</p>', '', 0, NULL, 0, NULL),
(4, 4, 0, 'en', '', '2017-08-25 04:12:31', '::1', 1, '2017-09-27 14:06:03', '116.48.156.216', 1, 1, 0, NULL, '1', 'UB_Web_Web_Banner_Promot1.png|/attachment/serviceCoverImg/1504162839Jz5h8.png', '激光脫毛', '<p><span style="font-size:72px">原理</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/HRemoval-Grap2.jpg" style="height:470px; width:812px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>流程</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/HRemoval-Grap3.jpg" style="height:224px; width:812px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>激光脫毛的注意事項</p>\r\n\r\n<p>脫毛前</p>\r\n\r\n<ul>\r\n	<li>切勿使用連根拔除的方法將毛髮清除(如拔毛機、蜜蠟、眉鉗等)，否則需等大約2&ndash;3週待毛髮再次生長方能進行脫毛。</li>\r\n	<li>切勿服用任何治療暗瘡藥物、抗生素或亞士匹靈。因為該等藥物將提高皮膚的吸光力，容易引致色素沉澱，浮現色斑。</li>\r\n	<li>用剃刀等把毛髮截斷的方法則不會影響脫毛效果。</li>\r\n	<li>如皮膚有發炎的情況出現，需要先治療皮膚發炎後才可以進行激光療程。</li>\r\n</ul>\r\n\r\n<p><br />\r\n脫毛後</p>\r\n\r\n<ul>\r\n	<li>請勿在陽光下曝曬或照射太陽燈</li>\r\n	<li>日間活動時應塗上SPF 30或以上的防曬產品</li>\r\n	<li>按照顧問指示依時塗抹補濕消炎精華，以減輕紅腫或減低毛囊發炎的風險</li>\r\n	<li>在任何情況下也不要使用任何拔毛的方法將毛髮拔掉，以免影響下次療程的效果</li>\r\n	<li>不要使用果酸性、酒精或刺激性的產品接觸脫毛位置</li>\r\n	<li>不要做會大量排汗的運動或焗桑拿</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>易久久激光脫毛10大承諾</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong><img alt="" src="/youbeauty/attachment/upload/HRemoval-Grap4.jpg" style="height:380px; width:812px" /></strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>激光脫毛問與答</strong></p>\r\n\r\n<p>Q: 需進行多少次療程？</p>\r\n\r\n<p>激光除毛並不是一次就可以完成，隨部位不同，通常需要4到5次的療程可去除明顯黑色毛髮，因為激光只能將處於生長期的毛髮破壞，每次大約除去3成到4成的明顯黑色毛髮。另外，激光無法處理隱藏在毛孔內休止期及退化期的毛髮，所以必須在數月內反覆治療，因而整個療程須耗時半年至一年以上，例如手腳及腋下一般需要4~5次治療，鬍鬚部位甚至需要10數次的治療。&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Q: 應多少天進行一次療程</p>\r\n\r\n<p>療程時間需配合毛髮生長週期，一般建議21-28日進行1次療程。效果會因個人毛髮生長進度不同而有所差異。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Q: 毛髮會否再生?&nbsp;</p>\r\n\r\n<p>若身體荷爾蒙分泌失衡或正值更年期，少量極幼細及淡色毛髮或會再生。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Q: 脫毛彼皮膚會否變得粗糙</p>\r\n\r\n<p>不會。因療程後毛根受破壞，毛孔本身會因萎縮而變小，皮膚反而會變得光滑細緻。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Q: 甚麼人士不適合進行療程?&nbsp;</p>\r\n\r\n<p>患有癌症、嚴重疾病、皮膚病或孕婦均不適合進行療程。治療師會於療程前先進行一對一的專業諮詢，以確定顧客是否適合接受療程。詳情可向治療師諮詢。</p>', 'http://www.etecom4.com/youbeauty/tc/promotion_detail.php?details_id=11', 1, '1.png|/attachment/serviceHomeImg/1505901506WmpJm.png', 0, NULL),
(5, 4, 0, 'tc', '', '2017-08-25 04:12:31', '::1', 1, '2017-09-27 14:06:03', '116.48.156.216', 1, 1, 0, NULL, '1', 'UB_Web_Web_Banner_Promot1.png|/attachment/serviceCoverImg/1504162839Jz5h8.png', '激光脫毛', '<p>&nbsp;</p>\r\n\r\n<p><strong><span style="font-size:24px"><img alt="" src="/youbeauty/attachment/upload/LS-1.png" style="height:40px; width:800px" /></span></strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/HRemoval-Grap2.jpg" style="height:463px; width:800px" /></p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/LS-2.png" style="height:40px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/HRemoval-Grap3.jpg" style="height:220px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/LS-3.png" style="height:40px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:18px">脫毛前</span></p>\r\n\r\n<ul>\r\n	<li>切勿使用連根拔除的方法將毛髮清除(如拔毛機、蜜蠟、眉鉗等)，否則需等大約2&ndash;3週待毛髮再次生長方能進行脫毛。</li>\r\n	<li>切勿服用任何治療暗瘡藥物、抗生素或亞士匹靈。因為該等藥物將提高皮膚的吸光力，容易引致色素沉澱，浮現色斑。</li>\r\n	<li>用剃刀等把毛髮截斷的方法則不會影響脫毛效果。</li>\r\n	<li>如皮膚有發炎的情況出現，需要先治療皮膚發炎後才可以進行激光療程。</li>\r\n</ul>\r\n\r\n<p><br />\r\n<span style="font-size:18px">脫毛後</span></p>\r\n\r\n<ul>\r\n	<li>請勿在陽光下曝曬或照射太陽燈</li>\r\n	<li>日間活動時應塗上SPF 30或以上的防曬產品</li>\r\n	<li>按照顧問指示依時塗抹補濕消炎精華，以減輕紅腫或減低毛囊發炎的風險</li>\r\n	<li>在任何情況下也不要使用任何拔毛的方法將毛髮拔掉，以免影響下次療程的效果</li>\r\n	<li>不要使用果酸性、酒精或刺激性的產品接觸脫毛位置</li>\r\n	<li>不要做會大量排汗的運動或焗桑拿</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:24px"><strong><img alt="" src="/youbeauty/attachment/upload/LS-5.png" style="height:40px; width:800px" /></strong></span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong><img alt="" src="/youbeauty/attachment/upload/HRemoval-Grap4.jpg" style="height:375px; width:800px" /></strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/LS-6.png" style="height:40px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Q: 需進行多少次療程？</p>\r\n\r\n<p>激光除毛並不是一次就可以完成，隨部位不同，通常需要4到5次的療程可去除明顯黑色毛髮，因為激光只能將處於生長期的毛髮破壞，每次大約除去3成到4成的明顯黑色毛髮。另外，激光無法處理隱藏在毛孔內休止期及退化期的毛髮，所以必須在數月內反覆治療，因而整個療程須耗時半年至一年以上，例如手腳及腋下一般需要4~5次治療，鬍鬚部位甚至需要10數次的治療。&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Q: 應多少天進行一次療程</p>\r\n\r\n<p>療程時間需配合毛髮生長週期，一般建議21-28日進行1次療程。效果會因個人毛髮生長進度不同而有所差異。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Q: 毛髮會否再生?&nbsp;</p>\r\n\r\n<p>若身體荷爾蒙分泌失衡或正值更年期，少量極幼細及淡色毛髮或會再生。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Q: 脫毛彼皮膚會否變得粗糙</p>\r\n\r\n<p>不會。因療程後毛根受破壞，毛孔本身會因萎縮而變小，皮膚反而會變得光滑細緻。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Q: 甚麼人士不適合進行療程?&nbsp;</p>\r\n\r\n<p>患有癌症、嚴重疾病、皮膚病或孕婦均不適合進行療程。治療師會於療程前先進行一對一的專業諮詢，以確定顧客是否適合接受療程。詳情可向治療師諮詢。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>*效果因人而異</p>', 'http://www.etecom4.com/youbeauty/tc/promotion_detail.php?details_id=11', 1, '1.png|/attachment/serviceHomeImg/1505901506WmpJm.png', 0, NULL),
(6, 4, 0, 'sc', '', '2017-08-25 04:12:31', '::1', 1, '2017-09-27 14:06:03', '116.48.156.216', 1, 1, 0, NULL, '1', 'UB_Web_Web_Banner_Promot1.png|/attachment/serviceCoverImg/1504162839Jz5h8.png', 'testing tctc', '<p><img alt="" src="/youbeauty/attachment/upload/Lion.jpg" style="height:200px; width:300px" /></p>\r\n\r\n<p>testing tctc</p>', 'http://www.etecom4.com/youbeauty/tc/promotion_detail.php?details_id=11', 1, '1.png|/attachment/serviceHomeImg/1505901506WmpJm.png', 0, NULL),
(7, 7, 0, 'en', '', '2017-08-25 04:20:22', '::1', 1, '2017-09-27 14:15:54', '116.48.156.216', 1, 4, 0, NULL, '4', 'YOU WEB Sub Banner_Medical-11.jpg|/attachment/serviceCoverImg/1504162594Gq4s2.jpg', 'HIFU', '<p>easttecheasttecheasttecheasttech</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Brushes.jpg" style="height:200px; width:300px" /></p>', 'http://www.etecom4.com/youbeauty/tc/promotion_detail.php?details_id=20', 1, '4.png|/attachment/serviceHomeImg/1505901616XK3fA.png', 0, NULL),
(8, 7, 0, 'tc', '', '2017-08-25 04:20:22', '::1', 1, '2017-09-27 14:15:54', '116.48.156.216', 1, 4, 0, NULL, '4', 'YOU WEB Sub Banner_Medical-11.jpg|/attachment/serviceCoverImg/1504162594Gq4s2.jpg', 'HIFU立體輪廓', '<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/HIFU-1.png" style="height:40px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>「淺表肌腱膜系統」Superficial Muscular Aponeurotic System</p>\r\n\r\n<ul>\r\n	<li>簡稱SMAS</li>\r\n	<li>覆蓋於真皮以下</li>\r\n	<li>連接脂肪與面部淺層結締組織</li>\r\n	<li>與表皮、真皮及脂肪緊密連繫成一體</li>\r\n	<li>鞏固面部輪廓</li>\r\n</ul>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/HIFU_1.jpg" style="height:266px; width:611px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:18px"><strong>可選擇部位：額頭/ 眼部/ 蘋果肌/ 面脥/ 雙下</strong><strong>巴</strong></span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><br />\r\n<a href="/youbeauty/attachment/upload/HIFU-2.png"><img alt="" src="/youbeauty/attachment/upload/HIFU-2.png" style="height:40px; width:800px" /></a>&nbsp;</p>\r\n\r\n<p><span style="font-size:14px">第1步：一對一的免費諮詢，針對性講解您的肌膚狀態，詳細解釋療程程序</span></p>\r\n\r\n<p><span style="font-size:14px">第2步：進行清潔程序後，治療師會為客人塗上IPL GEL</span></p>\r\n\r\n<p><span style="font-size:14px">第3步：開始HIFU治療，客人有機會感到微溫、發麻、局部肌肉酸軟無力的感覺</span></p>\r\n\r\n<p><span style="font-size:14px">第4步：塗上具有鎮靜、保濕效果的面膜及進行一般護理程序</span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:24px"><strong><img alt="" src="/youbeauty/attachment/upload/HIFU-3.png" style="height:40px; width:800px" /></strong></span></p>\r\n\r\n<p><strong>Q. </strong><strong>需要多少時間才見到成效？</strong></p>\r\n\r\n<p>當天治療後，皮膚就能有明顯的提升效果。<strong>兩、三星期後，效果更明顯。</strong>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Q. </strong><strong>有沒有副作用？</strong></p>\r\n\r\n<p>療程後皮膚有可能會出現短暫性灼熱、疼痛、繃緊、發麻、局部肌肉酸軟無力的感覺，皮膚有機會出現泛紅、微腫。但一般會於三至四天內消退，極少數人或會出現紅痕、紅腫、敏感等情況。以上均屬正常現象，只須遵照治療師的指示進行皮膚護理，即可自行消退。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Q. </strong><strong>什麼人仕不適合做HIFU?</strong></p>\r\n\r\n<p>皮下有金屬支架、植入式電子儀器、填充劑，&nbsp;開放式創傷/傷口，嚴重或囊腫形暗瘡，皮膚發炎，增生性疤痕等</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Q.</strong> <strong>HIFU</strong><strong>療程前要注意事項甚麼</strong><strong>?</strong></p>\r\n\r\n<p><strong>療程前</strong><strong>2</strong><strong>週請勿使用</strong>熱敷治療、<strong>去角質、果酸、</strong><strong>A</strong><strong>酸、光學、</strong>微針和射頻治療<strong>或曝曬，同時加強保濕</strong>。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Q. <strong>HIFU</strong></strong><strong>療程後要注意事項甚麼</strong><strong>?</strong></p>\r\n\r\n<p><strong>與療程前的注意事項一樣，同時使用</strong><strong>SPF 30</strong><strong>或以上之防曬產品。</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>*效果因人而異</p>', 'http://www.etecom4.com/youbeauty/tc/promotion_detail.php?details_id=20', 1, '4.png|/attachment/serviceHomeImg/1505901616XK3fA.png', 0, NULL),
(9, 7, 0, 'sc', '', '2017-08-25 04:20:22', '::1', 1, '2017-09-27 14:15:54', '116.48.156.216', 1, 4, 0, NULL, '4', 'YOU WEB Sub Banner_Medical-11.jpg|/attachment/serviceCoverImg/1504162594Gq4s2.jpg', 'easttech tc', '<p>easttecheasttecheasttecheasttech</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Brushes.jpg" style="height:200px; width:300px" /></p>', 'http://www.etecom4.com/youbeauty/tc/promotion_detail.php?details_id=20', 1, '4.png|/attachment/serviceHomeImg/1505901616XK3fA.png', 0, NULL),
(16, 16, 0, 'en', '', '2017-08-28 03:22:25', '::1', 1, '2017-09-27 14:16:36', '116.48.156.216', 1, 999, 0, NULL, '10', 'YOU WEB Sub Banner_Medical-10.jpg|/attachment/serviceCoverImg/1504229799CT5HL.jpg', '纖體瘦身', '<p>纖體瘦身</p>', 'http://www.etecom4.com/youbeauty/tc/promotion_detail.php?details_id=17', 1, '6.png|/attachment/serviceHomeImg/1505901699PG1Bu.png', 0, NULL),
(17, 16, 0, 'tc', '', '2017-08-28 03:22:25', '::1', 1, '2017-09-27 14:16:36', '116.48.156.216', 1, 999, 0, NULL, '10', 'YOU WEB Sub Banner_Medical-10.jpg|/attachment/serviceCoverImg/1504229799CT5HL.jpg', '全方位擊脂程式', '<p><strong><span style="font-size:24px"><img alt="" src="/youbeauty/attachment/upload/FDA-1.png" style="height:40px; width:800px" /></span></strong></p>\r\n\r\n<p>全球熱賣破壞脂肪細胞技術! 纖體要先殲滅脂肪細胞；瘦身，要由細胞開始瘦起</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/YOU Promo for WEB_170602-05.jpg" style="height:435px; width:800px" /></p>\r\n\r\n<p><strong>UltraShape V3 定位擊脂程式</strong>，全球熱賣破壞脂肪細胞技術!&nbsp; 定位追蹤、直接擊破脂肪細胞而不傷肌肉。</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>3D 引導攝像頭，精確計算脂肪區域</p>\r\n	</li>\r\n	<li>\r\n	<p>聚焦超聲傳感器，深入脂肪層，直接將脂肪細胞擊碎</p>\r\n	</li>\r\n	<li>\r\n	<p>RF真空負壓，預熱及擊破脂肪細胞</p>\r\n	</li>\r\n	<li>\r\n	<p>全球57個國家，超過15份醫學報告及文獻證實，超過30 萬個成功案例</p>\r\n	</li>\r\n	<li>\r\n	<p>無痛、無瘀青、無創傷、無須使用塑身衣、無需復原期</p>\r\n	</li>\r\n	<li>\r\n	<p>平均可減少3.3cm ~6.3cm，尤其針對腰腹、大腿頑固部位的贅肉</p>\r\n	</li>\r\n</ul>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/UltraShape_1_1.jpg" style="height:500px; width:500px" /></p>\r\n\r\n<p>高科技專利跟蹤與引導攝像頭，即時3D影像只追撃及破壞脂肪細胞同時完全不會傷害周邊的血管、神經組織和結締組織。</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/UltraShape_2_22.jpg" style="height:500px; width:500px" /></p>\r\n\r\n<p>聚焦超聲波穩定地針對皮下7MM , 10MM, 15MM三個不同深度脂肪層，直接將脂肪細胞震碎。</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/UltraShape_3_33.jpg" style="height:500px; width:500px" /></p>\r\n\r\n<p>RF真空負壓探頭，預熱脂肪細胞，使超聲波更有效擊破脂肪細胞。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/YOU Promo for WEB_170602-04.jpg" style="height:435px; width:800px" /></p>\r\n\r\n<p><strong>Vanquish Me 隔空溶脂程式</strong>，世界首創非觸式隔空溶脂設備，180度特大RF治療板面，直擊頑固脂肪層，30分鐘達到即時、持久瘦身效果。</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>榮獲歐洲美容權威媒體The Aesthetic Guide頒發「最佳纖體塑形儀器」大奬</p>\r\n	</li>\r\n	<li>\r\n	<p>直擊皮下5mm-15mm頑固性脂肪層</p>\r\n	</li>\r\n	<li>\r\n	<p>選擇性射頻技術及調諧專利技術，自動調節能量流，確保安全</p>\r\n	</li>\r\n	<li>\r\n	<p>醫學臨床個案一個月四次療程最高可減達13cm</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Vanquish_1_2.jpg" style="height:500px; width:500px" /></p>\r\n\r\n<p>傳統纖體機的治療範圍小，同一部位要較多次數才可達到效果。而VANQUISH ME 隔空溶脂前瞻性180度活動板面，廣達68 cm x 19cm，是史上可一次過治療最大範圍的溶脂機。而且每次只需30分鐘!</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>*效果因人而異</p>', 'http://www.etecom4.com/youbeauty/tc/promotion_detail.php?details_id=17', 1, '6.png|/attachment/serviceHomeImg/1505901699PG1Bu.png', 0, NULL),
(18, 16, 0, 'sc', '', '2017-08-28 03:22:25', '::1', 1, '2017-09-27 14:16:36', '116.48.156.216', 1, 999, 0, NULL, '10', 'YOU WEB Sub Banner_Medical-10.jpg|/attachment/serviceCoverImg/1504229799CT5HL.jpg', '纖體瘦身', '<p>纖體瘦身</p>', 'http://www.etecom4.com/youbeauty/tc/promotion_detail.php?details_id=17', 1, '6.png|/attachment/serviceHomeImg/1505901699PG1Bu.png', 0, NULL),
(19, 19, 0, 'en', '', '2017-08-28 03:22:59', '::1', 1, '2017-09-27 14:17:27', '116.48.156.216', 1, 999, 0, NULL, '16', 'YOU WEB Sub Banner_Medical-15.jpg|/attachment/serviceCoverImg/1505730003ijczo.jpg', '美肌養生', '<p>美肌養生</p>', 'http://www.etecom4.com/youbeauty/tc/index.php#index_section_3', 1, '5.png|/attachment/serviceHomeImg/15059017381jp4h.png', 1, 'WEB banner_20170801-05.jpg|/attachment/serviceHomeImg/150573000313NQs.jpg'),
(20, 19, 0, 'tc', '', '2017-08-28 03:22:59', '::1', 1, '2017-09-27 14:17:27', '116.48.156.216', 1, 999, 0, NULL, '16', 'YOU WEB Sub Banner_Medical-15.jpg|/attachment/serviceCoverImg/1505730003ijczo.jpg', 'Green Peel Plus 真空煥膚', '<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:20px"><strong><img alt="" src="/youbeauty/attachment/upload/HIFU-1.png" style="height:40px; width:800px" /></strong></span><strong> </strong></p>\r\n\r\n<p>以高濃度生長因子注入肌膚底層，極速啟動膠原自我修復引擎，獨有的液態打磨技術快速在皮膚上打磨，每次治療能溫和地帶走30-35mm的角質層，能帶走老化角細胞，令肌膚柔軟嫩滑。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>負壓的真空吸力有效清除毛孔內污垢、黑頭粉刺、油脂，幫你收細毛孔、擊退頑固暗粒，同時為肌膚補充水份及增添光澤，全日保持水潤亮麗。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:24px"><strong><img alt="" src="/youbeauty/attachment/upload/GP-1.png" style="height:40px; width:800px" /></strong></span></p>\r\n\r\n<p>&bull; 皮膚光滑</p>\r\n\r\n<p>&bull; 減淡幼紋</p>\r\n\r\n<p>&bull; 收細毛孔</p>\r\n\r\n<p>&bull; 鎖水補濕</p>\r\n\r\n<p>&bull; 改善過厚角質</p>\r\n\r\n<p>&bull; 改善粗糙暗啞</p>\r\n\r\n<p>&bull; 改善油性及暗瘡性皮膚</p>\r\n\r\n<p>&bull; 擊退頑固暗粒</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>*效果因人而異</p>', 'http://www.etecom4.com/youbeauty/tc/index.php#index_section_3', 1, '5.png|/attachment/serviceHomeImg/15059017381jp4h.png', 1, 'WEB banner_20170801-05.jpg|/attachment/serviceHomeImg/150573000313NQs.jpg'),
(21, 19, 0, 'sc', '', '2017-08-28 03:22:59', '::1', 1, '2017-09-27 14:17:27', '116.48.156.216', 1, 999, 0, NULL, '16', 'YOU WEB Sub Banner_Medical-15.jpg|/attachment/serviceCoverImg/1505730003ijczo.jpg', '美肌養生', '<p>美肌养生</p>', 'http://www.etecom4.com/youbeauty/tc/index.php#index_section_3', 1, '5.png|/attachment/serviceHomeImg/15059017381jp4h.png', 1, 'WEB banner_20170801-05.jpg|/attachment/serviceHomeImg/150573000313NQs.jpg'),
(22, 22, 0, 'en', '', '2017-08-28 04:14:54', '218.103.118.116', 1, '2017-09-27 14:49:22', '116.48.156.216', 1, 2, 0, NULL, '13', 'UB_Web_pROMOT1.png|/attachment/serviceCoverImg/1504237229ZLjzA.png', 'Discovery PICO No. 1', '<p><span style="font-size:17px"><strong>皮秒激光如何激袪色斑</strong></span></p>\r\n\r\n<p>皮秒是比納秒快1000倍的時間單位。皮秒激光比傳統納秒激光的脈衝時間短10倍，能量於極短時間被黑色素吸收，尤其適合亞洲人皮膚。皮秒激光透過光機械衝擊壓力 (Photomechanical effect)，即以光震碎目標色素，而不是被熱能破壞，可以更少治療次數達更佳去斑效果。</p>\r\n\r\n<p>相比納秒激光對目標色素及周邊皮膚組織產生熱能而可能引發的肌膚傷害（反白、反黑），皮秒則減低了熱效應引起的副作用。被激光震碎的色素由於如塵般細小，能更快被皮膚代謝及清除。</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Doscovery PICO 3-2.jpg" /></p>\r\n\r\n<table class="tg">\r\n	<tbody>\r\n		<tr>\r\n			<th>&nbsp;</th>\r\n			<th>Pico皮秒1064激光</th>\r\n			<th>Q-Switch納秒激光</th>\r\n			<th>755激光</th>\r\n			<th>IPL彩光</th>\r\n		</tr>\r\n		<tr>\r\n			<td>袪斑原理&nbsp;</td>\r\n			<td>Photomechanical effect光震碎效應</td>\r\n			<td>Photoacoustic Effect光震波效應</td>\r\n			<td>Photothermal Effect光熱效應</td>\r\n			<td>Photothermal Effect光熱效應</td>\r\n		</tr>\r\n		<tr>\r\n			<td>治療感覺</td>\r\n			<td>熱力少，感覺較輕</td>\r\n			<td>通常有少許刺痛</td>\r\n			<td>感覺較大</td>\r\n			<td>比較熱</td>\r\n		</tr>\r\n		<tr>\r\n			<td>治療次數*</td>\r\n			<td>能量較高通常次數較少</td>\r\n			<td>黑色素吸收少而能量溫和，須要次數較多</td>\r\n			<td>對淺層斑效果好，但深層斑較難處理</td>\r\n			<td>對淺層斑效果好，但深層斑較難處理</td>\r\n		</tr>\r\n		<tr>\r\n			<td>治療效果</td>\r\n			<td>更有效的美白袪斑</td>\r\n			<td>均勻膚色</td>\r\n			<td>袪表層斑</td>\r\n			<td>袪表層斑</td>\r\n		</tr>\r\n		<tr>\r\n			<td>深入度</td>\r\n			<td>可處理深層的色斑</td>\r\n			<td>可處理深層的色斑，但能量有限</td>\r\n			<td>穿透較淺，較難處理深層斑</td>\r\n			<td>能量分散而較難處理深層斑</td>\r\n		</tr>\r\n		<tr>\r\n			<td>安全性</td>\r\n			<td>熱力少，熱損傷機會少，獲美國FDA及歐盟CE認證</td>\r\n			<td>激光熱力有機會引起起砂、結焦</td>\r\n			<td>黑色素吸收強，亞洲人皮膚須小心使用</td>\r\n			<td>儀器質素參差，有機會結焦</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>皮秒激光VS其他技術<br />\r\n因應不同療程次數有差異</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Discovery PICO激光優點：</strong></p>\r\n\r\n<ul>\r\n	<li>FDA及CE安全認証</li>\r\n	<li>榮獲2017美國「最佳皮秒技術大獎」</li>\r\n	<li>以最快激光震碎色斑，以最少的治療次數達到更佳去斑效果</li>\r\n	<li>特設雙激光系統，同步治療深層(1064nm)及淺層(532nm)色斑，徹底去斑，不易反黑</li>\r\n	<li>特別針對深層色斑、荷爾蒙斑（黃褐斑／蝴蝶斑）等</li>\r\n	<li>獨有平帽式方形激光治療頭，均勻覆蓋肌膚</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>獨有平帽式方形激光</strong></p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Discovery PICO 3-3.jpg" style="height:276px; width:910px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Discovery PICO激袪色斑、荷爾蒙斑</strong></p>\r\n\r\n<p>荷爾蒙斑（黃褐斑／蝴蝶斑）成因：</p>\r\n\r\n<ul>\r\n	<li>沒有一個標準診斷，有可能與內分泌、女性荷爾蒙失調有關，促使黑色素細胞活性增高，黑色素分泌增多而引發</li>\r\n	<li>化妝品及護膚品的應用也可誘發荷爾蒙斑</li>\r\n	<li>皮膚衰老令皮膚變薄、過敏、皮膚表層血管增多亦有機會引致荷爾蒙斑</li>\r\n</ul>\r\n\r\n<p><strong>最新的治療技術如下：</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<table class="tg">\r\n	<tbody>\r\n		<tr>\r\n			<th>激光選擇</th>\r\n			<th>用途</th>\r\n		</tr>\r\n		<tr>\r\n			<td>分段Pico激光(Fractional Pico)</td>\r\n			<td>．令皮膚重組，刺激膠原增生，皮膚增厚．皮膚增厚，減少荷爾蒙斑復發</td>\r\n		</tr>\r\n		<tr>\r\n			<td>短脈衝激光(Photo-Thermal)</td>\r\n			<td>．利用激光熱力封閉過敏皮膚的表淺血管，從而斷絕荷爾蒙斑的根源</td>\r\n		</tr>\r\n		<tr>\r\n			<td>袪斑Pico激光</td>\r\n			<td>．利用光震技術激袪色素</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong><strong>療程效果*</strong></strong></p>\r\n\r\n<p><strong>圖片均取自真實個案，未經任何修飾或數碼處理</strong></p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/image4.jpg" style="float:left; height:258px; width:450px" /><img alt="" src="/youbeauty/attachment/upload/image6.jpg" style="height:258px; width:450px" /></p>\r\n\r\n<p><strong>皮膚護理指引：</strong></p>\r\n\r\n<table class="tg">\r\n	<tbody>\r\n		<tr>\r\n			<th>療程前的護膚建議：</th>\r\n			<th>&nbsp;</th>\r\n			<th>療程後的護膚建議：</th>\r\n		</tr>\r\n		<tr>\r\n			<td>1. 治療前3天最好使用含舒緩／補濕成份的面膜</td>\r\n			<td>&nbsp;</td>\r\n			<td>1. 在治療後當晚使用含舒緩成份的面膜，而且往後數天也要注意補濕</td>\r\n		</tr>\r\n		<tr>\r\n			<td>2. 四星期前不應使用含維他命A及果酸的護膚產品</td>\r\n			<td>&nbsp;</td>\r\n			<td>2. 四星期不應使用含維他命A及果酸的護膚產品</td>\r\n		</tr>\r\n		<tr>\r\n			<td>3. 四星期前亦避免曝曬</td>\r\n			<td>&nbsp;</td>\r\n			<td>3. 四星期內避免曝曬</td>\r\n		</tr>\r\n		<tr>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n			<td>4. 必須注重防曬</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p>&nbsp;</p>', 'http://www.etecom4.com/youbeauty/tc/promotion_detail.php?details_id=8', 1, '3.png|/attachment/serviceHomeImg/150590165815bEs.png', 0, NULL),
(23, 22, 0, 'tc', '', '2017-08-28 04:14:54', '218.103.118.116', 1, '2017-09-27 14:49:22', '116.48.156.216', 1, 2, 0, NULL, '13', 'UB_Web_pROMOT1.png|/attachment/serviceCoverImg/1504237229ZLjzA.png', 'Discovery PICO No. 1皮秒袪斑療程', '<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Pico-1.png" style="height:40px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>皮秒是比納秒快1000倍的時間單位。皮秒激光比傳統納秒激光的脈衝時間短10倍，能量於極短時間被黑色素吸收，尤其適合亞洲人皮膚。皮秒激光透過光機械衝擊壓力 (Photomechanical effect)，即以光震碎目標色素，而不是被熱能破壞，可以更少治療次數達更佳去斑效果。</p>\r\n\r\n<p>相比納秒激光對目標色素及周邊皮膚組織產生熱能而可能引發的肌膚傷害（反白、反黑），皮秒則減低了熱效應引起的副作用。被激光震碎的色素由於如塵般細小，能更快被皮膚代謝及清除。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Doscovery PICO 3-2.jpg" style="height:211px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Pico-2_2.png" style="height:45px; width:900px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/PICO_Table.png" style="height:376px; width:1000px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Pico-3.png" style="height:40px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul>\r\n	<li>FDA及CE安全認可</li>\r\n	<li>榮獲2017年「最佳皮秒技術大獎」</li>\r\n	<li>以最快激光震碎色斑，以最少的治療次數達到更佳去斑效果</li>\r\n	<li>特設雙激光系統，可治療深層(1064nm)及淺層(532nm)色斑，徹底去斑，不易反黑</li>\r\n	<li>特別針對深層色斑、荷爾蒙斑（黃褐斑／蝴蝶斑）等</li>\r\n	<li>獨有平帽式方形激光治療頭，均勻覆蓋肌膚</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:16px"><strong>獨有平帽式方形激光</strong></span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Discovery PICO 3-3.jpg" style="height:243px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Pico-4.png" style="height:40px; width:800px" /></p>\r\n\r\n<p>荷爾蒙斑（黃褐斑／蝴蝶斑）成因：</p>\r\n\r\n<ul>\r\n	<li>沒有一個標準診斷，有可能與內分泌、女性荷爾蒙失調有關，促使黑色素細胞活性增高，黑色素分泌增多而引發</li>\r\n	<li>化妝品及護膚品的應用也可誘發荷爾蒙斑</li>\r\n	<li>皮膚衰老令皮膚變薄、過敏、皮膚表層血管增多亦有機會引致荷爾蒙斑</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/0507_PICO.png" style="height:265px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-size:16px"><strong><strong>療程效果*</strong></strong></span></p>\r\n\r\n<p><span style="font-size:16px"><strong>圖片均取自真實個案，未經任何修飾或數碼處理</strong></span></p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/image4.jpg" style="float:left; height:212px; width:370px" />&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<img alt="" src="/youbeauty/attachment/upload/image6.jpg" style="height:212px; width:370px" /></p>\r\n\r\n<p>療程前 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;療程後 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 療程前 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 療程後</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Pico-5.png" style="height:40px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/0511_PICO_2.png" style="height:196px; width:800px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>*效果因人而異</p>', 'http://www.etecom4.com/youbeauty/tc/promotion_detail.php?details_id=8', 1, '3.png|/attachment/serviceHomeImg/150590165815bEs.png', 0, NULL),
(24, 22, 0, 'sc', '', '2017-08-28 04:14:54', '218.103.118.116', 1, '2017-09-27 14:49:22', '116.48.156.216', 1, 2, 0, NULL, '13', 'UB_Web_pROMOT1.png|/attachment/serviceCoverImg/1504237229ZLjzA.png', '皮秒碎斑療程', '<p><span style="font-size:15px"><strong>皮秒激光如何激袪色斑</strong></span></p>\r\n\r\n<p>皮秒是比納秒快1000倍的時間單位。皮秒激光比傳統納秒激光的脈衝時間短10倍，能量於極短時間被黑色素吸收，尤其適合亞洲人皮膚。皮秒激光透過光機械衝擊壓力 (Photomechanical effect)，即以光震碎目標色素，而不是被熱能破壞，可以更少治療次數達更佳去斑效果。</p>\r\n\r\n<p>相比納秒激光對目標色素及周邊皮膚組織產生熱能而可能引發的肌膚傷害（反白、反黑），皮秒則減低了熱效應引起的副作用。被激光震碎的色素由於如塵般細小，能更快被皮膚代謝及清除。</p>\r\n\r\n<p>xxxxx----table-----xxxxx</p>\r\n\r\n<p><strong>皮秒激光VS其他技術<br />\r\n因應不同療程次數有差異</strong></p>\r\n\r\n<p><strong>Discovery PICO激光優點：</strong></p>\r\n\r\n<ul>\r\n	<li>FDA及CE安全認証</li>\r\n	<li>榮獲2017美國「最佳皮秒技術大獎」</li>\r\n	<li>以最快激光震碎色斑，以最少的治療次數達到更佳去斑效果</li>\r\n	<li>特設雙激光系統，同步治療深層(1064nm)及淺層(532nm)色斑，徹底去斑，不易反黑</li>\r\n	<li>特別針對深層色斑、荷爾蒙斑（黃褐斑／蝴蝶斑）等</li>\r\n	<li>獨有平帽式方形激光治療頭，均勻覆蓋肌膚</li>\r\n</ul>\r\n\r\n<p><strong>獨有平帽式方形激光</strong></p>\r\n\r\n<p><strong>img</strong></p>\r\n\r\n<p><strong>Discovery PICO激袪色斑、荷爾蒙斑</strong></p>\r\n\r\n<p>荷爾蒙斑（黃褐斑／蝴蝶斑）成因：</p>\r\n\r\n<ul>\r\n	<li>沒有一個標準診斷，有可能與內分泌、女性荷爾蒙失調有關，促使黑色素細胞活性增高，黑色素分泌增多而引發</li>\r\n	<li>化妝品及護膚品的應用也可誘發荷爾蒙斑</li>\r\n	<li>皮膚衰老令皮膚變薄、過敏、皮膚表層血管增多亦有機會引致荷爾蒙斑</li>\r\n</ul>\r\n\r\n<p><strong>最新的治療技術如下：</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong><strong>療程效果*</strong></strong></p>\r\n\r\n<p><strong>圖片均取自真實個案，未經任何修飾或數碼處理</strong></p>\r\n\r\n<p><strong>img</strong></p>\r\n\r\n<p><strong>table</strong></p>', 'http://www.etecom4.com/youbeauty/tc/promotion_detail.php?details_id=8', 1, '3.png|/attachment/serviceHomeImg/150590165815bEs.png', 0, NULL),
(40, 40, 0, 'en', '', '2017-08-31 10:11:35', '116.48.156.216', 1, '2017-09-27 15:07:59', '116.48.156.216', 1, 999, 0, NULL, '16', 'UB_Web-23.png|/attachment/serviceCoverImg/1504284821FSgZ.png', '奧米加3鱘魚子抗衰老嫩膚護理', '<p>利用奧米加3脂肪酸、提升肌膚再生、保濕及排出細胞內的廢物與毒素、有效地把氧氣及維他命運送到每一個細胞內。奧米加3內含有天然維生素E和A，能活化新生皮膚，加速新陳代謝、改善粗糙。再加入另外5大抗老緊膚元素(茄紅素幹細胞、鱘魚子、人參、黑柳皮、咖啡因子)更有效地預防肌膚老化，使肌膚具有彈性、為肌膚提供生命能源。增加皮膚彈性、並能在皮膚上形成保護膜。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>手法：配合獨特的V Lift 按摩手法，力度較一般按摩深層而達到人手拉皮效果。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/0303.png" style="height:70px; width:1493px" /></p>\r\n\r\n<p>&nbsp;</p>', '', 0, NULL, 0, NULL),
(41, 40, 0, 'tc', '', '2017-08-31 10:11:35', '116.48.156.216', 1, '2017-09-27 15:07:59', '116.48.156.216', 1, 999, 0, NULL, '16', 'UB_Web-23.png|/attachment/serviceCoverImg/1504284821FSgZ.png', '奧米加3鱘魚子抗衰老嫩膚護理', '<p>利用奧米加3脂肪酸、提升肌膚再生、保濕及排出細胞內的廢物與毒素、有效地把氧氣及維他命運送到每一個細胞內。奧米加3內含有天然維生素E和A，能活化新生皮膚，加速新陳代謝、改善粗糙。再加入另外5大抗老緊膚元素(茄紅素幹細胞、鱘魚子、人參、黑柳皮、咖啡因子)更有效地預防肌膚老化，使肌膚具有彈性、為肌膚提供生命能源。增加皮膚彈性、並能在皮膚上形成保護膜。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>手法：配合獨特的V Lift 按摩手法，力度較一般按摩深層而達到人手拉皮效果。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/YOU WEB Sub BarVER2-23.png" style="height:40px; width:800px" /></p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/0304.png" style="height:481px; width:800px" /></p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/GP-1.png" style="height:40px; width:800px" /></p>\r\n\r\n<ul>\r\n	<li>修護、保濕、滋潤肌膚</li>\r\n	<li>增加皮膚彈性及抵抗力</li>\r\n	<li>緊緻及預防肌膚老化</li>\r\n	<li>為皮膚細胞重新注入水份</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>*效果因人而異</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>歡迎致電/ Whatsapp 55611505 &nbsp;預約或查詢療程資料</strong></p>', '', 0, NULL, 0, NULL),
(42, 40, 0, 'sc', '', '2017-08-31 10:11:35', '116.48.156.216', 1, '2017-09-27 15:07:59', '116.48.156.216', 1, 999, 0, NULL, '16', 'UB_Web-23.png|/attachment/serviceCoverImg/1504284821FSgZ.png', '奥米加3鲟鱼子抗衰老嫩肤护理', '<p>利用奥米加3脂肪酸、提升肌肤再生、保湿及排出细胞内的废物与毒素、有效地把氧气及维他命运送到每一个细胞内。奥米加3内含有天然维生素E和A，能活化新生皮肤，加速新陈代谢、改善粗糙。再加入另外5大抗老紧肤元素(茄红素干细胞、鲟鱼子、人参、黑柳皮、咖啡因子)更有效地预防肌肤老化，使肌肤具有弹性、为肌肤提供生命能源。增加皮肤弹性、并能在皮肤上形成保护膜。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>手法：配合独特的V Lift 按摩手法，力度较一般按摩深层而达到人手拉皮效果。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/0303.png" style="height:70px; width:1493px" /></p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/0304.png" style="height:897px; width:1493px" /></p>', '', 0, NULL, 0, NULL),
(43, 43, 0, 'en', '', '2017-08-31 10:19:45', '116.48.156.216', 1, '2017-09-27 15:08:13', '116.48.156.216', 1, 999, 0, NULL, '16', 'UB_Web-24.png|/attachment/serviceCoverImg/15042851585zQGQ.png', '冰川能量水漾療程', '<p>缺水 &ndash; 所有肌膚問題的根源。</p>\r\n\r\n<p><br />\r\n每當肌膚未能自行鎖緊水分的時候，便會出現粗糙、細紋、失去光澤等缺水現象。肌膚持續缺水，更會出現鬆弛欠缺彈性、皺紋等根蒂問題。療程以瑞士4,000米以上的冰川雪水作基底導入，即時為肌膚注入大量水分；加上甘油複合物、透明質酸鈉等強效保濕及鎖水成分，為細胞、皮脂提供水分外，更能加強肌膚屏障功能，減少水分流失，迅速修護及柔軟肌膚。</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Ice_0203.png" style="height:1285px; width:1494px" /><img alt="" src="/youbeauty/attachment/upload/0305.png" style="height:42px; width:900px" /></p>\r\n\r\n<ul>\r\n	<li>深層修復肌膚，增強皮膚彈性</li>\r\n	<li>強效保濕效能，即時為肌膚注入大量水分及迅速鎖水</li>\r\n	<li>舒緩皮膚不適，乾燥繃緊感覺</li>\r\n</ul>', '', 0, NULL, 0, NULL),
(44, 43, 0, 'tc', '', '2017-08-31 10:19:45', '116.48.156.216', 1, '2017-09-27 15:08:13', '116.48.156.216', 1, 999, 0, NULL, '16', 'UB_Web-24.png|/attachment/serviceCoverImg/15042851585zQGQ.png', '冰川能量水漾療程', '<p>缺水 &ndash; 所有肌膚問題的根源。</p>\r\n\r\n<p><br />\r\n每當肌膚未能自行鎖緊水分的時候，便會出現粗糙、細紋、失去光澤等缺水現象。肌膚持續缺水，更會出現鬆弛欠缺彈性、皺紋等根蒂問題。療程以瑞士4,000米以上的冰川雪水作基底導入，即時為肌膚注入大量水分；加上甘油複合物、透明質酸鈉等強效保濕及鎖水成分，為細胞、皮脂提供水分外，更能加強肌膚屏障功能，減少水分流失，迅速修護及柔軟肌膚。</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Ice_0203.png" style="height:688px; width:800px" /></p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/GP-1.png" style="height:40px; width:800px" /></p>\r\n\r\n<ul>\r\n	<li>深層修復肌膚，增強皮膚彈性</li>\r\n	<li>強效保濕效能，即時為肌膚注入大量水分及迅速鎖水</li>\r\n	<li>舒緩皮膚不適，乾燥繃緊感覺</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>*效果因人而異</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>歡迎致電/ Whatsapp 55611505 &nbsp;預約或查詢療程資料</strong></p>', '', 0, NULL, 0, NULL),
(45, 43, 0, 'sc', '', '2017-08-31 10:19:45', '116.48.156.216', 1, '2017-09-27 15:08:13', '116.48.156.216', 1, 999, 0, NULL, '16', 'UB_Web-24.png|/attachment/serviceCoverImg/15042851585zQGQ.png', '冰川能量水漾疗程', '<p>缺水 &ndash; 所有肌肤问题的根源。</p>\r\n\r\n<p><br />\r\n每当肌肤未能自行锁紧水分的时候，便会出现粗糙、细纹、失去光泽等缺水现象。肌肤持续缺水，更会出现鬆弛欠缺弹性、皱纹等根蒂问题。疗程以瑞士4,000米以上的冰川雪水作基底导入，即时为肌肤注入大量水分；加上甘油复合物、透明质酸钠等强效保湿及锁水成分，为细胞、皮脂提供水分外，更能加强肌肤屏障功能，减少水分流失，迅速修护及柔软肌肤。</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Ice_0203.png" style="height:1285px; width:1494px" /><img alt="" src="/youbeauty/attachment/upload/0305.png" style="height:42px; width:900px" /></p>\r\n\r\n<ul>\r\n	<li>深层修復肌肤，增强皮肤弹性</li>\r\n	<li>强效保湿效能，即时为肌肤注入大量水分及迅速锁水</li>\r\n	<li>舒缓皮肤不适，乾燥绷紧感觉</li>\r\n</ul>', '', 0, NULL, 0, NULL),
(49, 49, 0, 'en', '', '2017-09-06 02:43:42', '116.48.156.216', 1, '2017-09-27 15:08:25', '116.48.156.216', 1, 999, 0, NULL, '7', 'YOU WEB Sub Banner_Medical-07.jpg|/attachment/serviceCoverImg/1506307669QS6w7.jpg', 'Sculptra', '<p>Sculptra</p>', '', 0, NULL, 0, NULL),
(50, 49, 0, 'tc', '', '2017-09-06 02:43:42', '116.48.156.216', 1, '2017-09-27 15:08:25', '116.48.156.216', 1, 999, 0, NULL, '7', 'YOU WEB Sub Banner_Medical-07.jpg|/attachment/serviceCoverImg/1506307669QS6w7.jpg', 'Sculptra', '<p><strong>Sculptra&reg;</strong><strong>塑然雅</strong><strong>&reg; </strong><strong>原廠正貨</strong></p>\r\n\r\n<p>Sculptra蘊含骨膠原促生物聚左乳酸(Poly-L-Lactic Acid)，是一種與人體相融的物質，可逐步被人體自然分解，Sculptra&reg;深層膠原增生療程，能激發體內膠原蛋白增生，修復面部組織結構，有效補充骨膠原，填補凹陷的部位，改善由淺至深的面部皺紋及坑紋</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Sculptra5.png" style="height:442px; width:391px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>利用PLLA聚左旋乳酸來刺激自體的骨膠原增生；療程後立即發揮填充劑功效；但數天後經身體吸收，會暫時回復原形，其後膠原增生後，約六星期治療效果開始明顯。在完成首5天內，以每天5次，每次5分鐘按摩臉部，以達致最佳效果。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Sculptra-2.jpg" style="height:310px; width:689px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ol>\r\n	<li>治療前的皺紋與凹陷</li>\r\n	<li>PLLA聚左旋乳酸與水份經注射至皮膚深層後，立即發揮墳充劑的功效，填滿皺紋及凹陷位置</li>\r\n	<li>數天後水份被身體自然吸收</li>\r\n	<li>PLLA聚左旋乳酸逐漸分解，同時可刺激膠原自我增生</li>\r\n	<li>約6星期後治療效果更明顯</li>\r\n</ol>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>療程效果</strong></p>\r\n\r\n<p>刺激膠原再生</p>\r\n\r\n<p>激活肌膚，提升緊緻、彈性度</p>\r\n\r\n<p>撫平皺紋幼紋</p>\r\n\r\n<p>改善鬆弛下垂肌肉</p>\r\n\r\n<p>改善凹陷位</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><span style="font-family:arial,helvetica,sans-serif"><span class="marker"><span style="font-size:28px"><strong>You Medical 3大信心保證</strong></span></span></span></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Sculptra-3-01.jpg" style="height:337px; width:800px" /></p>\r\n\r\n<p><strong>針對位置</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>飽滿太陽穴、豐滿顴骨、撫平淚溝、提升面頰、褪減法令紋(笑紋)、褪減口角紋(木偶紋)</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><br />\r\n<img alt="" src="/youbeauty/attachment/upload/Sculptra-4.jpg" style="height:480px; width:638px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>*效果因人而異</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>歡迎致電/ Whatsapp 55611505 &nbsp;預約或查詢療程資料</strong></p>', '', 0, NULL, 0, NULL),
(51, 49, 0, 'sc', '', '2017-09-06 02:43:42', '116.48.156.216', 1, '2017-09-27 15:08:25', '116.48.156.216', 1, 999, 0, NULL, '7', 'YOU WEB Sub Banner_Medical-07.jpg|/attachment/serviceCoverImg/1506307669QS6w7.jpg', 'Sculptra', '<p><strong>Sculptra&reg;</strong><strong>塑然雅</strong><strong>&reg; </strong><strong>原厂正货</strong></p>\r\n\r\n<p>Sculptra蕴含骨胶原促生物聚左乳酸(Poly-L-Lactic Acid)，是一种与人体相融的物质，可逐步被人体自然分解，Sculptra&reg;深层胶原增生疗程，能激发体内胶原蛋白增生，修復面部组织结构，有效补充骨胶原，填补凹陷的部位，改善由浅至深的面部皱纹及坑纹</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Sculptra.png" style="height:442px; width:391px" /></p>\r\n\r\n<p>利用PLLA聚左旋乳酸来刺激自体的骨胶原增生；疗程后立即发挥填充剂功效；但数天后经身体吸收，会暂时回復原形，其后胶原增生后，约六星期治疗效果开始明显。在完成首5天内，以每天5次，每次5分钟按摩脸部，以达致最佳效果。</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Sculptra-2.jpg" style="height:310px; width:689px" /></p>\r\n\r\n<ol>\r\n	<li>治疗前的皱纹与凹陷</li>\r\n	<li>PLLA聚左旋乳酸与水份经注射至皮肤深层后，立即发挥坟充剂的功效，填满皱纹及凹陷位置</li>\r\n	<li>数天后水份被身体自然吸收</li>\r\n	<li>PLLA聚左旋乳酸逐渐分解，同时可刺激胶原自我增生</li>\r\n	<li>约6星期后治疗效果更明显</li>\r\n</ol>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>疗程效果</strong></p>\r\n\r\n<p>刺激胶原再生</p>\r\n\r\n<p>激活肌肤，提升紧緻、弹性度</p>\r\n\r\n<p>抚平皱纹幼纹</p>\r\n\r\n<p>改善鬆弛下垂肌肉</p>\r\n\r\n<p>改善凹陷位</p>\r\n\r\n<p><img alt="" src="/youbeauty/attachment/upload/Sculptra-3.jpg" style="float:left; height:365px; width:738px" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>针对位置</strong></p>\r\n\r\n<p>饱满太阳穴、丰满颧骨、抚平泪沟、提升面颊、褪减法令纹(笑纹)、褪减口角纹(木偶纹)</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>疗程功效</strong><br />\r\n<img alt="" src="/youbeauty/attachment/upload/Sculptra-4.jpg" style="height:480px; width:638px" /></p>', '', 0, NULL, 0, NULL),
(52, 52, 0, 'en', '', '2017-09-07 06:22:20', '116.48.156.216', 1, '2017-09-27 15:08:36', '116.48.156.216', 1, 999, 0, NULL, '37', 'YOU WEB Sub Banner_Medical-13.jpg|/attachment/serviceCoverImg/1506307684OMTKq.jpg', 'Soak Off 光療指甲', '<p>You Beauty 提供一系列美甲、護甲療程。其中Soak Off 光療指甲更採用高品質透薄物料，無須打磨真甲且顏色自然不易剝落，特別適合工作繁忙的辦公室女性。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>適合人士</p>\r\n\r\n<p>&ndash; 指甲容易折斷<br />\r\n&ndash; 追求指甲顏色持久者</p>', '', 0, NULL, 0, NULL),
(53, 52, 0, 'tc', '', '2017-09-07 06:22:20', '116.48.156.216', 1, '2017-09-27 15:08:36', '116.48.156.216', 1, 999, 0, NULL, '37', 'YOU WEB Sub Banner_Medical-13.jpg|/attachment/serviceCoverImg/1506307684OMTKq.jpg', 'Soak Off 光療指甲', '<p>You Beauty 提供一系列美甲、護甲療程。其中Soak Off 光療指甲更採用高品質透薄物料，無須打磨真甲且顏色自然不易剝落，特別適合工作繁忙的辦公室女性。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>歡迎致電/ Whatsapp 55611505 &nbsp;預約或查詢療程資料</strong></p>', '', 0, NULL, 0, NULL),
(54, 52, 0, 'sc', '', '2017-09-07 06:22:20', '116.48.156.216', 1, '2017-09-27 15:08:36', '116.48.156.216', 1, 999, 0, NULL, '37', 'YOU WEB Sub Banner_Medical-13.jpg|/attachment/serviceCoverImg/1506307684OMTKq.jpg', 'Soak Off 光疗指甲', '<p>You Beauty 提供一系列美甲、护甲疗程。其中Soak Off 光疗指甲更采用高品质透薄物料，无须打磨真甲且颜色自然不易剥落，特别适合工作繁忙的办公室女性。</p>', '', 0, NULL, 0, NULL),
(55, 55, 0, 'en', '', '2017-09-08 04:47:36', '116.48.156.216', 1, '2017-09-27 15:08:46', '116.48.156.216', 1, 999, 0, NULL, '37', 'YOU WEB Sub Banner_Medical-14.jpg|/attachment/serviceCoverImg/1506307699TealQ.jpg', '手部及腳部滋潤去紋護理', '<p>要建立專業形象，除了著重面部肌膚質素、妝容的細緻外，連手部及腳部的肌膚亦要一絲不苟。</p>\r\n\r\n<p>You Beauty對您呵護備至，由手到腳都為您提供貼心服務。定期為雙手及雙腳去除多餘角質，減少手部及腳部的幼紋，令肌膚保持滋潤、嬌嫩。</p>', '', 0, NULL, 0, NULL),
(56, 55, 0, 'tc', '', '2017-09-08 04:47:36', '116.48.156.216', 1, '2017-09-27 15:08:46', '116.48.156.216', 1, 999, 0, NULL, '37', 'YOU WEB Sub Banner_Medical-14.jpg|/attachment/serviceCoverImg/1506307699TealQ.jpg', '手部及腳部滋潤去紋護理', '<p>要建立專業形象，除了著重面部肌膚質素、妝容的細緻外，連手部及腳部的肌膚亦要一絲不苟。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>You Beauty對您呵護備至，由手到腳都為您提供貼心服務。定期為雙手及雙腳去除多餘角質，減少手部及腳部的幼紋，令肌膚保持滋潤、嬌嫩。</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>歡迎致電/ Whatsapp 55611505 &nbsp;預約或查詢療程資料</strong></p>', '', 0, NULL, 0, NULL),
(57, 55, 0, 'sc', '', '2017-09-08 04:47:36', '116.48.156.216', 1, '2017-09-27 15:08:46', '116.48.156.216', 1, 999, 0, NULL, '37', 'YOU WEB Sub Banner_Medical-14.jpg|/attachment/serviceCoverImg/1506307699TealQ.jpg', '手部及脚部滋润去纹护理', '<p>要建立专业形象，除了着重面部肌肤质素、妆容的细緻外，连手部及脚部的肌肤亦要一丝不苟。</p>\r\n\r\n<p>You Beauty对您呵护备至，由手到脚都为您提供贴心服务。定期为双手及双脚去除多余角质，减少手部及脚部的幼纹，令肌肤保持滋润、娇嫩。</p>', '', 0, NULL, 0, NULL);

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

--
-- Table structure for table `service_cate`
--

CREATE TABLE `service_cate` (
  `cate_sys_id` bigint(20) NOT NULL,
  `cate_id` bigint(20) DEFAULT NULL,
  `cate_lang` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
  `cate_pid` bigint(20) NOT NULL DEFAULT '0',
  `cate_crt_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `cate_crt_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cate_crt_usr_id` bigint(20) DEFAULT NULL,
  `cate_mod_dt` datetime DEFAULT NULL,
  `cate_mod_ip` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cate_mod_usr_id` bigint(20) DEFAULT NULL,
  `cate_sort_id` bigint(20) DEFAULT '999',
  `cate_sort_lv` int(11) DEFAULT '0',
  `cate_sort_fix` enum('Y','N') COLLATE utf8_unicode_ci DEFAULT 'N',
  `cate_show` enum('Y','N') COLLATE utf8_unicode_ci DEFAULT 'Y',
  `cate_fixed` enum('Y','N') COLLATE utf8_unicode_ci DEFAULT 'N',
  `cate_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `service_cate`
--

REPLACE INTO `service_cate` (`cate_sys_id`, `cate_id`, `cate_lang`, `cate_pid`, `cate_crt_dt`, `cate_crt_ip`, `cate_crt_usr_id`, `cate_mod_dt`, `cate_mod_ip`, `cate_mod_usr_id`, `cate_sort_id`, `cate_sort_lv`, `cate_sort_fix`, `cate_show`, `cate_fixed`, `cate_name`) VALUES
(1, 1, 'en', 0, '2017-08-25 02:37:10', '::1', 1, '2017-09-20 12:42:02', '116.48.156.216', 1, 1, 0, 'N', 'Y', 'N', '激光脫毛 en'),
(2, 1, 'tc', 0, '2017-08-25 02:37:10', '::1', 1, '2017-09-20 12:42:02', '116.48.156.216', 1, 1, 0, 'N', 'Y', 'N', '激光脫毛'),
(3, 1, 'sc', 0, '2017-08-25 02:37:10', '::1', 1, '2017-09-20 12:42:02', '116.48.156.216', 1, 1, 0, 'N', 'Y', 'N', '激光脫毛 en'),
(4, 4, 'en', 0, '2017-08-25 02:37:23', '::1', 1, '2017-09-20 12:42:44', '147.8.207.59', 1, 2, 0, 'N', 'Y', 'N', 'HIFU提升 en'),
(5, 4, 'tc', 0, '2017-08-25 02:37:23', '::1', 1, '2017-09-20 12:42:44', '147.8.207.59', 1, 2, 0, 'N', 'Y', 'N', 'HIFU提升'),
(6, 4, 'sc', 0, '2017-08-25 02:37:23', '::1', 1, '2017-09-20 12:42:44', '147.8.207.59', 1, 2, 0, 'N', 'Y', 'N', 'HIFU提升 en'),
(7, 7, 'en', 0, '2017-08-25 02:37:53', '::1', 1, NULL, NULL, NULL, 3, 0, 'N', 'Y', 'N', '輪廓重塑 en'),
(8, 7, 'tc', 0, '2017-08-25 02:37:53', '::1', 1, NULL, NULL, NULL, 3, 0, 'N', 'Y', 'N', '輪廓重塑'),
(9, 7, 'sc', 0, '2017-08-25 02:37:53', '::1', 1, NULL, NULL, NULL, 3, 0, 'N', 'Y', 'N', '輪廓重塑 en'),
(10, 10, 'en', 0, '2017-08-25 02:38:10', '::1', 1, NULL, NULL, NULL, 4, 0, 'N', 'Y', 'N', '纖體瘦身 en'),
(11, 10, 'tc', 0, '2017-08-25 02:38:10', '::1', 1, NULL, NULL, NULL, 4, 0, 'N', 'Y', 'N', '纖體瘦身'),
(12, 10, 'sc', 0, '2017-08-25 02:38:10', '::1', 1, NULL, NULL, NULL, 4, 0, 'N', 'Y', 'N', '纖體瘦身 en'),
(13, 13, 'en', 0, '2017-08-25 02:38:38', '::1', 1, '2017-08-28 12:15:16', '218.103.118.116', 1, 5, 0, 'N', 'Y', 'N', '光學嫩膚 en'),
(14, 13, 'tc', 0, '2017-08-25 02:38:38', '::1', 1, '2017-08-28 12:15:16', '218.103.118.116', 1, 5, 0, 'N', 'Y', 'N', '光學嫩膚'),
(15, 13, 'sc', 0, '2017-08-25 02:38:38', '::1', 1, '2017-08-28 12:15:16', '218.103.118.116', 1, 5, 0, 'N', 'Y', 'N', '光學嫩膚 en'),
(16, 16, 'en', 0, '2017-08-25 02:38:54', '::1', 1, NULL, NULL, NULL, 6, 0, 'N', 'Y', 'N', '美肌養生 en'),
(17, 16, 'tc', 0, '2017-08-25 02:38:54', '::1', 1, NULL, NULL, NULL, 6, 0, 'N', 'Y', 'N', '美肌養生'),
(18, 16, 'sc', 0, '2017-08-25 02:38:54', '::1', 1, NULL, NULL, NULL, 6, 0, 'N', 'Y', 'N', '美肌養生 en'),
(37, 37, 'en', 0, '2017-09-07 06:21:37', '116.48.156.216', 1, '2017-09-08 12:49:11', '116.48.156.216', 1, 999, 0, 'N', 'Y', 'N', '專業美甲'),
(38, 37, 'tc', 0, '2017-09-07 06:21:37', '116.48.156.216', 1, '2017-09-08 12:49:11', '116.48.156.216', 1, 999, 0, 'N', 'Y', 'N', '專業美甲'),
(39, 37, 'sc', 0, '2017-09-07 06:21:37', '116.48.156.216', 1, '2017-09-08 12:49:11', '116.48.156.216', 1, 999, 0, 'N', 'Y', 'N', '專業美甲');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `attachment`
--
ALTER TABLE `attachment`
  ADD PRIMARY KEY (`a_id`);

--
-- Indexes for table `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`bnr_id`);

--
-- Indexes for table `coupon`
--
ALTER TABLE `coupon`
  ADD PRIMARY KEY (`cp_id`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`news_sys_id`);

--
-- Indexes for table `news_cate`
--
ALTER TABLE `news_cate`
  ADD PRIMARY KEY (`cate_sys_id`),
  ADD UNIQUE KEY `IX_PrdCate_UniqueKey` (`cate_id`,`cate_lang`);

--
-- Indexes for table `popup`
--
ALTER TABLE `popup`
  ADD PRIMARY KEY (`popup_sys_id`);

--
-- Indexes for table `po_mst`
--
ALTER TABLE `po_mst`
  ADD PRIMARY KEY (`po_id`);

--
-- Indexes for table `po_st_log`
--
ALTER TABLE `po_st_log`
  ADD PRIMARY KEY (`pslog_id`);

--
-- Indexes for table `po_x_clientinfo_rltn`
--
ALTER TABLE `po_x_clientinfo_rltn`
  ADD PRIMARY KEY (`pxcr_id`);

--
-- Indexes for table `po_x_coupon_rltn`
--
ALTER TABLE `po_x_coupon_rltn`
  ADD PRIMARY KEY (`poxcr_id`);

--
-- Indexes for table `po_x_prd_rltn`
--
ALTER TABLE `po_x_prd_rltn`
  ADD PRIMARY KEY (`poxpr_id`),
  ADD KEY `IX_POxPr_PoID` (`poxpr_po_id`),
  ADD KEY `IX_POxPr_PoID_PoLang` (`poxpr_po_id`,`poxpr_lang`);

--
-- Indexes for table `promotion`
--
ALTER TABLE `promotion`
  ADD PRIMARY KEY (`promotion_sys_id`);

--
-- Indexes for table `service`
--
ALTER TABLE `service`
  ADD PRIMARY KEY (`service_sys_id`);

--
-- Indexes for table `service_cate`
--
ALTER TABLE `service_cate`
  ADD PRIMARY KEY (`cate_sys_id`),
  ADD UNIQUE KEY `IX_PrdCate_UniqueKey` (`cate_id`,`cate_lang`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `attachment`
--
ALTER TABLE `attachment`
  MODIFY `a_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
--
-- AUTO_INCREMENT for table `banner`
--
ALTER TABLE `banner`
  MODIFY `bnr_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `coupon`
--
ALTER TABLE `coupon`
  MODIFY `cp_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `news_sys_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;
--
-- AUTO_INCREMENT for table `news_cate`
--
ALTER TABLE `news_cate`
  MODIFY `cate_sys_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `popup`
--
ALTER TABLE `popup`
  MODIFY `popup_sys_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `po_mst`
--
ALTER TABLE `po_mst`
  MODIFY `po_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=267;
--
-- AUTO_INCREMENT for table `po_st_log`
--
ALTER TABLE `po_st_log`
  MODIFY `pslog_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=233;
--
-- AUTO_INCREMENT for table `po_x_clientinfo_rltn`
--
ALTER TABLE `po_x_clientinfo_rltn`
  MODIFY `pxcr_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
--
-- AUTO_INCREMENT for table `po_x_coupon_rltn`
--
ALTER TABLE `po_x_coupon_rltn`
  MODIFY `poxcr_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `po_x_prd_rltn`
--
ALTER TABLE `po_x_prd_rltn`
  MODIFY `poxpr_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=684;
--
-- AUTO_INCREMENT for table `promotion`
--
ALTER TABLE `promotion`
  MODIFY `promotion_sys_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT for table `service`
--
ALTER TABLE `service`
  MODIFY `service_sys_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;
--
-- AUTO_INCREMENT for table `service_cate`
--
ALTER TABLE `service_cate`
  MODIFY `cate_sys_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
