· 8 years ago · Jun 03, 2018, 05:34 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.7.14 - MySQL Community Server (GPL)
4-- Server OS: Win64
5-- HeidiSQL Version: 9.4.0.5174
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for table os_aceglove_2.wb_product
15CREATE TABLE IF NOT EXISTS `wb_product` (
16 `id` int(11) NOT NULL AUTO_INCREMENT,
17 `tmp_cate_name` varchar(50) DEFAULT NULL,
18 `tmp_link` varchar(150) DEFAULT NULL,
19 `price` double DEFAULT '0' COMMENT 'Giá',
20 `avatar` varchar(250) DEFAULT NULL,
21 `list_images` varchar(1000) DEFAULT NULL COMMENT 'Json list images product',
22 `product_no` varchar(250) DEFAULT NULL,
23 `color` varchar(100) DEFAULT NULL,
24 `size` varchar(100) DEFAULT NULL,
25 `note_feature` varchar(1000) DEFAULT NULL,
26 `product_ce` varchar(50) DEFAULT NULL,
27 `product_type` tinyint(4) DEFAULT NULL,
28 `status` tinyint(4) DEFAULT '1' COMMENT '1: Enable ; 0:Disable',
29 `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
30 `created_id` int(11) DEFAULT NULL,
31 `updated_at` datetime DEFAULT NULL,
32 `updated_id` int(11) DEFAULT NULL,
33 PRIMARY KEY (`id`)
34) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='Quản lý sản phẩm';
35
36-- Dumping data for table os_aceglove_2.wb_product: 1 rows
37/*!40000 ALTER TABLE `wb_product` DISABLE KEYS */;
38INSERT INTO `wb_product` (`id`, `tmp_cate_name`, `tmp_link`, `price`, `avatar`, `list_images`, `product_no`, `color`, `size`, `note_feature`, `product_ce`, `product_type`, `status`, `created_at`, `created_id`, `updated_at`, `updated_id`) VALUES
39 (1, NULL, NULL, 6868, '/web_intro/avatar/2018/05/24/03/1527131827_1.jpg', '["\\/web_intro\\/image\\/2018\\/05\\/24\\/03\\/1527133220_2.jpg","\\/web_intro\\/image\\/2018\\/05\\/24\\/03\\/1527133220_3.jpg"]', 'J68No', 'test', 'tes', '<p>Note<strong> Feature 1</strong></p>\r\n', NULL, NULL, 1, '2018-05-24 10:05:36', 1, '2018-05-28 03:13:45', 1),
40 (2, 'PU Coating', 'product/pucoating/pu_01.php?section=02&act=view1', 0, 'img/product/SJNT-01.jpg', '[]', 'SJ800', 'White', 'S, M, L, XL, XXL', NULL, 'EN388 1131', NULL, 1, '2018-06-03 11:42:51', NULL, NULL, NULL),
41 (3, 'PU Coating', 'product/pucoating/pu_01.php?section=02&act=view2', 0, 'img/product/SJNT-02.jpg', '[]', 'SJ801', 'Gray', 'S, M, L, XL, XXL', NULL, 'EN388 1131', NULL, 1, '2018-06-03 11:42:51', NULL, NULL, NULL),
42 (4, 'PU Coating', 'product/pucoating/pu_01.php?section=02&act=view3', 0, 'img/product/SJNT-D1.jpg', '[]', 'SJ802', 'White', 'S, M, L, XL, XXL', NULL, 'EN388 1131', NULL, 1, '2018-06-03 11:42:51', NULL, NULL, NULL),
43 (5, 'PU Coating', 'product/pucoating/pu_01.php?section=02&act=view4', 0, 'img/product/SJNP-01.jpg', '["img/product/1/SJNP-01-01.jpg"]', 'SJ700', 'White', 'XS, S, M, L, XL, XXL', NULL, '', NULL, 1, '2018-06-03 11:42:51', NULL, NULL, NULL),
44 (6, 'PU Coating', 'product/pucoating/pu_01.php?section=02&act=view5', 0, 'img/product/SJNP-04.jpg', '["img/product/1/SJNP-04-01.jpg"]', 'SJ701', 'Gray', 'XS, S, M, L, XL, XXL', NULL, '', NULL, 1, '2018-06-03 11:42:51', NULL, NULL, NULL),
45 (7, 'PU Coating', 'product/pucoating/pu_01.php?section=02&act=view6', 0, 'img/product/SJNP-03.jpg', '["img/product/1/SJNP-03-01.jpg"]', 'SJ702', 'Black', 'XS, S, M, L, XL, XXL', NULL, '', NULL, 1, '2018-06-03 11:42:51', NULL, NULL, NULL),
46 (8, 'PU Coating', 'product/pucoating/pu_01.php?section=02&act=view7', 0, 'img/product/SJNP-02.jpg', '["img/product/1/SJNP-02-01.jpg"]', 'SJ703', 'Sky Blue', 'XS, S, M, L, XL, XXL', NULL, '', NULL, 1, '2018-06-03 11:42:51', NULL, NULL, NULL),
47 (9, 'PU Coating', 'product/pucoating/pu_01.php?section=02&act=view8', 0, 'img/product/SJNP-L1.jpg', '["img/product/1/SJNP-L1-01.jpg", "img/product/1/SJNP-L2-01.jpg"]', 'SJ710,711', 'White, Blue', 'XS, S, M, L, XL, XXL', NULL, '', NULL, 1, '2018-06-03 11:42:51', NULL, NULL, NULL),
48 (10, 'PU Coating', 'product/pucoating/pu_01.php?section=02&act=view9', 0, 'img/product/SJNP-U1.jpg', '["img/product/1/SJNP-U1-01.jpg", "img/product/1/SJDP-U4-01.jpg", "img/product/1/SJNP-U3-01.jpg"]', 'SJ730,731,732', 'White, Blue, Black', 'XS, S, M, L, XL, XXL', NULL, '', NULL, 1, '2018-06-03 11:42:51', NULL, NULL, NULL);
49/*!40000 ALTER TABLE `wb_product` ENABLE KEYS */;
50
51-- Dumping structure for table os_aceglove_2.wb_product_translation
52CREATE TABLE IF NOT EXISTS `wb_product_translation` (
53 `id` int(11) NOT NULL AUTO_INCREMENT,
54 `name` varchar(250) NOT NULL,
55 `sapo` varchar(100) DEFAULT NULL,
56 `description` text,
57 `product_features` text,
58 `product_id` int(11) NOT NULL,
59 `language` tinyint(4) DEFAULT '1' COMMENT '1: Tiếng Anh, 2:Tiếng Việt, 3:Tiếng Hà n',
60 PRIMARY KEY (`id`)
61) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='Bang language cua Product';
62
63-- Dumping data for table os_aceglove_2.wb_product_translation: 3 rows
64/*!40000 ALTER TABLE `wb_product_translation` DISABLE KEYS */;
65INSERT INTO `wb_product_translation` (`id`, `name`, `sapo`, `description`, `product_features`, `product_id`, `language`) VALUES
66 (1, 'Name En 1', '<p>Sapo En 1</p>\r\n', '<p>Des En 1</p>\r\n', NULL, 1, 1),
67 (2, 'Name vi1', '<p>Sapo Vi 1</p>\r\n', '<p>Des En 1</p>\r\n', NULL, 1, 2),
68 (3, 'Name Kr1', '<p>Sapo Kr 1</p>\r\n', '<p>Des En 1</p>\r\n', NULL, 1, 3),
69 (4, 'PU TOP FIT_WHITE', NULL, '', '', 2, 1),
70 (5, 'PU TOP FIT_GRAY', NULL, '', '', 3, 1),
71 (6, 'PU TOP FIT_DOT', NULL, '', '', 4, 1),
72 (7, 'PU PALM FIT_WHITE', NULL, '13/15-guage seamless knitted nylon glove with polyurethane coating on palm', 'Light & sensitive\nGood dexterity & abration resistance\nWell ventilated surface\nHarmless poyurethane coating material', 5, 1),
73 (8, 'PU PALM FIT_GRAY', NULL, '13/15-guage seamless knitted nylon glove with polyurethane coating on palm', 'Light & sensitive\nGood dexterity & abration resistance\nWell ventilated surface\nHarmless poyurethane coating material', 6, 1),
74 (9, 'PU PALM FIT_BLACK', NULL, '13/15-guage seamless knitted nylon glove with polyurethane coating on palm', 'Light & sensitive\nGood dexterity & abration resistance\nWell ventilated surface\nHarmless poyurethane coating material', 7, 1),
75 (10, 'PU PALM FIT_SKY BLUE', NULL, '13/15-guage seamless knitted nylon glove with polyurethane coating on palm', 'Light & sensitive\nGood dexterity & abration resistance\nWell ventilated surface\nHarmless poyurethane coating material', 8, 1),
76 (11, 'PU PALM FIT_LONG', NULL, '13/15-guage seamless knitted nylon glove with polyurethane coating on palm', 'Light & sensitive\nGood dexterity & abration resistance\nWell ventilated surface\nHarmless poyurethane coating material', 9, 1),
77 (12, 'PU PALM FIT_U3', NULL, '13/15-guage seamless knitted nylon glove with polyurethane coating on palm', 'Light & sensitive\nGood dexterity & abration resistance\nWell ventilated surface\nHarmless poyurethane coating material', 10, 1),
78 (13, '나ì¼ë¡ 탑_í™”ì´íŠ¸(SJNT)', NULL, '', '', 2, 2),
79 (14, '나ì¼ë¡ 탑_ê·¸ë ˆì´(SJNT)', NULL, '', '', 3, 2),
80 (15, '나ì¼ë¡ 탑_ì ë°•ì´(SJNT)', NULL, '', '', 4, 2),
81 (16, '나ì¼ë¡ 팜_í™”ì´íŠ¸(SJNP)', NULL, 'ì†ë°”ë‹¥ í´ë¦¬ìš°ë ˆíƒ„ ì½”íŒ…ì œí’ˆìž…ë‹ˆë‹¤. \r\n ë°˜ë„ì²´ ì¡°ë¦½ìž‘ì—…ë° LCD조립, ì „ìžì œí’ˆì¡°ë¦½, í¬ë¦°ë£¸, ì „ê¸°íšŒë¡œìž‘ì—…, ì»´íŽ™íŠ¸ë””ìŠ¤í¬ ìž‘ì—…ì‹œ 아주 ì í•©í•œ 장갑입니다.\r\n í†µê¸°ì„±ì´ ìš°ìˆ˜í•˜ì—¬ ë•€ì´ ë°œìƒí•˜ì§€ 않으며 ì°©ìš©ê°ì´ 우수하여 장시간 ì°©ìš©í•˜ì—¬ë„ ì†ì´ 피로하지 않으며 ì •ë°€ìž‘ì—…ì— ìœ ë¦¬í•©ë‹ˆë‹¤.\r\n ë˜í•œ 과수ì›, ë†ì—…ì˜ ì—¬ëŸ¬ë¶„ì•¼ì—ì„œ ì´ìš©ë˜ê³ 있습니다.', 'ì²´ 조립, LCD조립, ì „ìžì œí’ˆì¡°ë¦½, í´ë¦°ë£¸, ì „ê¸°íšŒë¡œìž‘ì—…, 컴펙트디스í¬ìž‘ì—…\nì •ë°€í•˜ê³ ì„¸ë°€í•œ ìž‘ì—…\nê³¼ìˆ˜ì› ë° ë†ì—…, ìž„ì—…, 축산업, 어업등 다양한 분야ì—ì„œ 사용\n통기성 우수, ì°©ìš©ê° ìš°ìˆ˜', 5, 2),
82 (17, '나ì¼ë¡ 팜_ê·¸ë ˆì´(SJNP)', NULL, 'ì†ë°”ë‹¥ í´ë¦¬ìš°ë ˆíƒ„ ì½”íŒ…ì œí’ˆìž…ë‹ˆë‹¤. \r\n ë°˜ë„ì²´ ì¡°ë¦½ìž‘ì—…ë° LCD조립, ì „ìžì œí’ˆì¡°ë¦½, í¬ë¦°ë£¸, ì „ê¸°íšŒë¡œìž‘ì—…, ì»´íŽ™íŠ¸ë””ìŠ¤í¬ ìž‘ì—…ì‹œ 아주 ì í•©í•œ 장갑입니다.\r\n í†µê¸°ì„±ì´ ìš°ìˆ˜í•˜ì—¬ ë•€ì´ ë°œìƒí•˜ì§€ 않으며 ì°©ìš©ê°ì´ 우수하여 장시간 ì°©ìš©í•˜ì—¬ë„ ì†ì´ 피로하지 않으며 ì •ë°€ìž‘ì—…ì— ìœ ë¦¬í•©ë‹ˆë‹¤.\r\n ë˜í•œ 과수ì›, ë†ì—…ì˜ ì—¬ëŸ¬ë¶„ì•¼ì—ì„œ ì´ìš©ë˜ê³ 있습니다.', 'ì²´ 조립, LCD조립, ì „ìžì œí’ˆì¡°ë¦½, í´ë¦°ë£¸, ì „ê¸°íšŒë¡œìž‘ì—…, 컴펙트디스í¬ìž‘ì—…\nì •ë°€í•˜ê³ ì„¸ë°€í•œ ìž‘ì—…\nê³¼ìˆ˜ì› ë° ë†ì—…, ìž„ì—…, 축산업, 어업등 다양한 분야ì—ì„œ 사용\n통기성 우수, ì°©ìš©ê° ìš°ìˆ˜', 6, 2),
83 (18, '나ì¼ë¡ 팜_블랙(SJNP)', NULL, 'ì†ë°”ë‹¥ í´ë¦¬ìš°ë ˆíƒ„ ì½”íŒ…ì œí’ˆìž…ë‹ˆë‹¤. \r\n ë°˜ë„ì²´ ì¡°ë¦½ìž‘ì—…ë° LCD조립, ì „ìžì œí’ˆì¡°ë¦½, í¬ë¦°ë£¸, ì „ê¸°íšŒë¡œìž‘ì—…, ì»´íŽ™íŠ¸ë””ìŠ¤í¬ ìž‘ì—…ì‹œ 아주 ì í•©í•œ 장갑입니다.\r\n í†µê¸°ì„±ì´ ìš°ìˆ˜í•˜ì—¬ ë•€ì´ ë°œìƒí•˜ì§€ 않으며 ì°©ìš©ê°ì´ 우수하여 장시간 ì°©ìš©í•˜ì—¬ë„ ì†ì´ 피로하지 않으며 ì •ë°€ìž‘ì—…ì— ìœ ë¦¬í•©ë‹ˆë‹¤.\r\n ë˜í•œ 과수ì›, ë†ì—…ì˜ ì—¬ëŸ¬ë¶„ì•¼ì—ì„œ ì´ìš©ë˜ê³ 있습니다.', 'ì²´ 조립, LCD조립, ì „ìžì œí’ˆì¡°ë¦½, í´ë¦°ë£¸, ì „ê¸°íšŒë¡œìž‘ì—…, 컴펙트디스í¬ìž‘ì—…\nì •ë°€í•˜ê³ ì„¸ë°€í•œ ìž‘ì—…\nê³¼ìˆ˜ì› ë° ë†ì—…, ìž„ì—…, 축산업, 어업등 다양한 분야ì—ì„œ 사용\n통기성 우수, ì°©ìš©ê° ìš°ìˆ˜', 7, 2),
84 (19, '나ì¼ë¡ _SKY BLUE(SJNP)', NULL, 'ì†ë°”ë‹¥ í´ë¦¬ìš°ë ˆíƒ„ ì½”íŒ…ì œí’ˆìž…ë‹ˆë‹¤. \r\n ë°˜ë„ì²´ ì¡°ë¦½ìž‘ì—…ë° LCD조립, ì „ìžì œí’ˆì¡°ë¦½, í¬ë¦°ë£¸, ì „ê¸°íšŒë¡œìž‘ì—…, ì»´íŽ™íŠ¸ë””ìŠ¤í¬ ìž‘ì—…ì‹œ 아주 ì í•©í•œ 장갑입니다.\r\n í†µê¸°ì„±ì´ ìš°ìˆ˜í•˜ì—¬ ë•€ì´ ë°œìƒí•˜ì§€ 않으며 ì°©ìš©ê°ì´ 우수하여 장시간 ì°©ìš©í•˜ì—¬ë„ ì†ì´ 피로하지 않으며 ì •ë°€ìž‘ì—…ì— ìœ ë¦¬í•©ë‹ˆë‹¤.\r\n ë˜í•œ 과수ì›, ë†ì—…ì˜ ì—¬ëŸ¬ë¶„ì•¼ì—ì„œ ì´ìš©ë˜ê³ 있습니다.', 'ì²´ 조립, LCD조립, ì „ìžì œí’ˆì¡°ë¦½, í´ë¦°ë£¸, ì „ê¸°íšŒë¡œìž‘ì—…, 컴펙트디스í¬ìž‘ì—…\nì •ë°€í•˜ê³ ì„¸ë°€í•œ ìž‘ì—…\nê³¼ìˆ˜ì› ë° ë†ì—…, ìž„ì—…, 축산업, 어업등 다양한 분야ì—ì„œ 사용\n통기성 우수, ì°©ìš©ê° ìš°ìˆ˜', 8, 2),
85 (20, '나ì¼ë¡ 팜_LONG(SJNP)', NULL, 'ì†ë°”ë‹¥ í´ë¦¬ìš°ë ˆíƒ„ ì½”íŒ…ì œí’ˆìž…ë‹ˆë‹¤. \r\n ë°˜ë„ì²´ ì¡°ë¦½ìž‘ì—…ë° LCD조립, ì „ìžì œí’ˆì¡°ë¦½, í¬ë¦°ë£¸, ì „ê¸°íšŒë¡œìž‘ì—…, ì»´íŽ™íŠ¸ë””ìŠ¤í¬ ìž‘ì—…ì‹œ 아주 ì í•©í•œ 장갑입니다.\r\n í†µê¸°ì„±ì´ ìš°ìˆ˜í•˜ì—¬ ë•€ì´ ë°œìƒí•˜ì§€ 않으며 ì°©ìš©ê°ì´ 우수하여 장시간 ì°©ìš©í•˜ì—¬ë„ ì†ì´ 피로하지 않으며 ì •ë°€ìž‘ì—…ì— ìœ ë¦¬í•©ë‹ˆë‹¤.\r\n ë˜í•œ 과수ì›, ë†ì—…ì˜ ì—¬ëŸ¬ë¶„ì•¼ì—ì„œ ì´ìš©ë˜ê³ 있습니다.', 'ì²´ 조립, LCD조립, ì „ìžì œí’ˆì¡°ë¦½, í´ë¦°ë£¸, ì „ê¸°íšŒë¡œìž‘ì—…, 컴펙트디스í¬ìž‘ì—…\nì •ë°€í•˜ê³ ì„¸ë°€í•œ ìž‘ì—…\nê³¼ìˆ˜ì› ë° ë†ì—…, ìž„ì—…, 축산업, 어업등 다양한 분야ì—ì„œ 사용\n통기성 우수, ì°©ìš©ê° ìš°ìˆ˜', 9, 2),
86 (21, '나ì¼ë¡ 팜_U3(SJNP)', NULL, 'ì†ë°”ë‹¥ í´ë¦¬ìš°ë ˆíƒ„ ì½”íŒ…ì œí’ˆìž…ë‹ˆë‹¤. \r\n ë°˜ë„ì²´ ì¡°ë¦½ìž‘ì—…ë° LCD조립, ì „ìžì œí’ˆì¡°ë¦½, í¬ë¦°ë£¸, ì „ê¸°íšŒë¡œìž‘ì—…, ì»´íŽ™íŠ¸ë””ìŠ¤í¬ ìž‘ì—…ì‹œ 아주 ì í•©í•œ 장갑입니다.\r\n í†µê¸°ì„±ì´ ìš°ìˆ˜í•˜ì—¬ ë•€ì´ ë°œìƒí•˜ì§€ 않으며 ì°©ìš©ê°ì´ 우수하여 장시간 ì°©ìš©í•˜ì—¬ë„ ì†ì´ 피로하지 않으며 ì •ë°€ìž‘ì—…ì— ìœ ë¦¬í•©ë‹ˆë‹¤.\r\n ë˜í•œ 과수ì›, ë†ì—…ì˜ ì—¬ëŸ¬ë¶„ì•¼ì—ì„œ ì´ìš©ë˜ê³ 있습니다.', 'ì²´ 조립, LCD조립, ì „ìžì œí’ˆì¡°ë¦½, í´ë¦°ë£¸, ì „ê¸°íšŒë¡œìž‘ì—…, 컴펙트디스í¬ìž‘ì—…\nì •ë°€í•˜ê³ ì„¸ë°€í•œ ìž‘ì—…\nê³¼ìˆ˜ì› ë° ë†ì—…, ìž„ì—…, 축산업, 어업등 다양한 분야ì—ì„œ 사용\n통기성 우수, ì°©ìš©ê° ìš°ìˆ˜', 10, 2);
87/*!40000 ALTER TABLE `wb_product_translation` ENABLE KEYS */;
88
89/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
90/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
91/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;