-- phpMyAdmin SQL Dump -- version 4.9.5 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Oct 25, 2020 at 11:12 AM -- Server version: 10.2.33-MariaDB-log-cll-lve -- PHP Version: 7.3.6 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `vncode_star` -- -- -------------------------------------------------------- -- -- Table structure for table `counter` -- CREATE TABLE `counter` ( `id` int(11) NOT NULL, `tm` int(11) NOT NULL, `ip` varchar(16) NOT NULL DEFAULT '0.0.0.0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `counter` -- INSERT INTO `counter` (`id`, `tm`, `ip`) VALUES (1000, 1589592259, '::1'), (1001, 1589596814, '::1'), (1002, 1589598525, '::1'), (1003, 1589599594, '::1'), (1004, 1589600563, '::1'), (1005, 1589601502, '::1'), (1006, 1589602434, '::1'), (1007, 1589604992, '::1'), (1008, 1589765526, '::1'), (1009, 1589766621, '::1'), (1010, 1589768317, '::1'), (1011, 1589769274, '::1'), (1012, 1589771413, '::1'), (1013, 1589773815, '::1'), (1014, 1589775174, '::1'), (1015, 1589776194, '::1'), (1016, 1589777394, '::1'), (1017, 1589788917, '::1'), (1018, 1589789842, '::1'), (1019, 1589850370, '::1'), (1020, 1589851625, '::1'), (1021, 1589852546, '::1'), (1022, 1589854083, '::1'), (1023, 1589855079, '::1'), (1024, 1589856041, '::1'), (1025, 1589857658, '::1'), (1026, 1589870647, '::1'), (1027, 1589872333, '::1'), (1028, 1589875183, '::1'), (1029, 1589876661, '::1'), (1030, 1589878205, '::1'), (1031, 1589879199, '::1'), (1032, 1589881203, '::1'), (1033, 1589882156, '::1'), (1034, 1589910209, '::1'), (1035, 1589915133, '::1'), (1036, 1589916155, '::1'), (1037, 1590012134, '::1'), (1038, 1590014341, '::1'), (1039, 1590015736, '::1'), (1040, 1590016679, '::1'), (1041, 1590090227, '::1'), (1042, 1590092429, '::1'), (1043, 1590094520, '::1'), (1044, 1590096278, '::1'), (1045, 1590152669, '::1'), (1046, 1590293745, '::1'), (1047, 1590294735, '::1'), (1048, 1590297385, '::1'), (1049, 1590525174, '::1'), (1050, 1590528027, '::1'), (1051, 1590530239, '::1'), (1052, 1590617608, '::1'), (1053, 1590618949, '::1'), (1054, 1590620194, '::1'), (1055, 1590665430, '::1'), (1056, 1590666950, '::1'), (1057, 1590671249, '::1'), (1058, 1590687654, '::1'), (1059, 1590691020, '::1'), (1060, 1590691926, '::1'), (1061, 1590692851, '::1'), (1062, 1590693773, '::1'), (1063, 1590894370, '::1'), (1064, 1590912121, '::1'), (1065, 1590913026, '::1'), (1066, 1590924022, '::1'), (1067, 1590954262, '::1'), (1068, 1590958253, '::1'), (1069, 1591298894, '::1'), (1070, 1591300426, '::1'), (1071, 1591301836, '::1'), (1072, 1591309116, '::1'), (1073, 1591310089, '::1'), (1074, 1591311921, '::1'), (1075, 1591355058, '::1'), (1076, 1591356083, '::1'), (1077, 1591358849, '::1'), (1078, 1591359757, '::1'), (1079, 1591361137, '::1'), (1080, 1591428153, '::1'), (1081, 1591432633, '::1'), (1082, 1591433553, '::1'), (1083, 1591434586, '::1'), (1084, 1591435558, '::1'), (1085, 1591436517, '::1'), (1086, 1591438062, '::1'), (1087, 1591440481, '::1'), (1088, 1591441420, '::1'), (1089, 1591442547, '::1'), (1090, 1591443451, '::1'), (1091, 1591444493, '42.117.204.49'), (1092, 1591488085, '125.212.148.157'), (1093, 1591488095, '66.102.8.148'), (1094, 1591490263, '125.212.148.157'), (1095, 1591491913, '125.212.148.157'), (1096, 1591492841, '125.212.148.157'), (1097, 1591525941, '::1'), (1098, 1591527180, '::1'), (1099, 1591709026, '::1'), (1100, 1591710375, '::1'), (1101, 1591714160, '::1'), (1102, 1591716420, '::1'), (1103, 1591717401, '::1'), (1104, 1591720665, '::1'), (1105, 1591790494, '::1'), (1106, 1591792010, '::1'), (1107, 1591792998, '::1'), (1108, 1591793958, '::1'), (1109, 1591801640, '::1'), (1110, 1591803935, '::1'), (1111, 1591805336, '::1'), (1112, 1591806311, '::1'), (1113, 1591874573, '::1'), (1114, 1591875725, '::1'), (1115, 1591881184, '::1'), (1116, 1591883975, '::1'), (1117, 1591886190, '::1'), (1118, 1591887605, '::1'), (1119, 1591889614, '27.64.50.235'), (1120, 1591889629, '66.102.8.148'), (1121, 1591892385, '27.64.50.235'), (1122, 1591931517, '14.187.37.44'), (1123, 1591938321, '14.187.37.44'), (1124, 1591939614, '14.187.37.44'), (1125, 1591940618, '14.187.37.44'), (1126, 1591972067, '27.64.50.235'), (1127, 1591973315, '27.64.50.235'), (1128, 1591974306, '27.64.50.235'), (1129, 1591975757, '27.64.50.235'), (1130, 1591977002, '27.64.50.235'), (1131, 1591979057, '27.64.50.235'), (1132, 1591980016, '27.64.50.235'), (1133, 1591981083, '27.64.50.235'), (1134, 1592004005, '183.81.70.21'), (1135, 1592018043, '14.187.37.44'), (1136, 1592019419, '14.187.37.44'), (1137, 1592020401, '14.187.37.44'), (1138, 1592021424, '14.187.37.44'), (1139, 1592022335, '14.187.37.44'), (1140, 1592023708, '14.187.37.44'), (1141, 1592034549, '14.187.37.44'), (1142, 1592039981, '14.187.37.44'), (1143, 1592082518, '49.213.78.31'), (1144, 1592098946, '14.187.37.44'), (1145, 1592100455, '14.187.37.44'), (1146, 1592106202, '183.81.70.21'), (1147, 1592106584, '49.213.78.31'), (1148, 1592106939, '27.65.196.72'), (1149, 1592107459, '183.81.70.21'), (1150, 1592119282, '183.81.70.21'), (1151, 1592121136, '14.187.37.44'), (1152, 1592141643, '27.64.50.235'), (1153, 1592143730, '27.64.50.235'), (1154, 1592144897, '27.64.50.235'), (1155, 1592187251, '14.187.37.44'), (1156, 1592187253, '66.102.8.148'), (1157, 1592188202, '14.187.37.44'), (1158, 1592189161, '14.187.37.44'), (1159, 1592189163, '49.213.78.31'), (1160, 1592190125, '14.187.37.44'), (1161, 1592190806, '49.213.78.31'), (1162, 1592190919, '27.65.196.73'), (1163, 1592196600, '14.187.37.44'), (1164, 1592198919, '113.161.88.45'), (1165, 1592198988, '14.187.37.44'), (1166, 1592279151, '171.253.129.113'), (1167, 1592279737, '27.65.196.73'), (1168, 1592290809, '49.213.78.31'), (1169, 1592309029, '49.213.78.31'), (1170, 1592364267, '49.213.78.31'), (1171, 1592915673, '183.81.70.21'), (1172, 1592915692, '49.213.78.31'), (1173, 1592915702, '207.254.54.36'), (1174, 1592915922, '27.65.196.73'), (1175, 1592972513, '14.187.37.44'), (1176, 1592972521, '66.102.8.152'), (1177, 1592972817, '27.65.196.73'), (1178, 1593225063, '14.187.37.44'), (1179, 1593408624, '14.187.37.44'), (1180, 1593579572, '171.227.122.172'), (1181, 1593579581, '66.102.8.152'), (1182, 1594002747, '171.249.72.45'), (1183, 1594307274, '1.53.196.217'), (1184, 1594309596, '129.146.158.17'), (1185, 1594357809, '139.99.62.149'), (1186, 1594357813, '1.53.196.217'), (1187, 1594360992, '42.119.36.193'), (1188, 1594361190, '1.53.196.217'), (1189, 1594513783, '49.213.78.31'), (1190, 1594674294, '49.213.78.31'), (1191, 1594693482, '113.161.38.15'), (1192, 1594778231, '42.118.56.149'), (1193, 1594891264, '183.80.60.202'), (1194, 1596119442, '14.187.37.44'), (1195, 1596129108, '42.119.189.186'); -- -------------------------------------------------------- -- -- Table structure for table `table_about` -- CREATE TABLE `table_about` ( `id` int(10) UNSIGNED NOT NULL, `ten` varchar(225) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `mota` text NOT NULL, `noidung` text NOT NULL, `photo` varchar(100) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `ngaytao` int(11) NOT NULL DEFAULT 0, `ngaysua` int(11) NOT NULL DEFAULT 0, `title` varchar(100) NOT NULL, `description` varchar(1000) NOT NULL, `h3` varchar(200) NOT NULL, `h2` varchar(200) NOT NULL, `h1` varchar(200) NOT NULL, `keywords` varchar(200) NOT NULL, `type` varchar(100) NOT NULL, `tenen` varchar(225) NOT NULL, `motaen` text NOT NULL, `noidungen` text NOT NULL, `tencn` varchar(255) NOT NULL, `motacn` text NOT NULL, `noidungcn` text NOT NULL, `link` varchar(255) NOT NULL, `mota2` text NOT NULL, `mota2en` text NOT NULL, `mota2cn` text NOT NULL, `ten2` varchar(255) NOT NULL, `ten2en` varchar(255) NOT NULL, `ten2cn` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_about` -- INSERT INTO `table_about` (`id`, `ten`, `tenkhongdau`, `mota`, `noidung`, `photo`, `thumb`, `stt`, `hienthi`, `ngaytao`, `ngaysua`, `title`, `description`, `h3`, `h2`, `h1`, `keywords`, `type`, `tenen`, `motaen`, `noidungen`, `tencn`, `motacn`, `noidungcn`, `link`, `mota2`, `mota2en`, `mota2cn`, `ten2`, `ten2en`, `ten2cn`) VALUES (1, '', '', '', '

THƯ NGỎ

\r\n\r\n

\"Chúng tôi nâng tầm giá và chuyên nghiệp cho không gian bếp\"

\r\n\r\n
Theo nhịp phát triển của nền kinh tế và xã hội ngày nay, những dịch vụ phục vụ cho nhu cầu cuộc sống của con người ngày càng được chú trọng đầu tư, đặc biệt là mảng nhà hàng, khách sạn, khu nghỉ dưỡng, câu lạc bộ, ... Trong đó, việc trang bị thiết bị cho không gian bếp chuyên nghiệp và sang trọng đang là nhu cầu của nhiều nhà đầu tư. Nhận thấy được điều này, thương hiệu STAR QUALITY đã được hình thành với sứ mệnh mang đến khách hàng giải pháp tối ưu và thiết thực về các sản phẩm nhà bếp.
\r\n\r\n
 
\r\n\r\n
Trong bước đầu xây dựng thương hiệu trên thị trường, STAR QUALITY gặp nhiều khó khăn, do khách hàng yêu cầu cao không chỉ về chất lượng mà còn về thiết kế sản phẩm. Tuy nhiêu, chúng tôi xem thách thức này là một cơ hội thể hiện năng lực công ty và chất lượng sản phẩm. Cho đến nay, chúng tôi đã khẳng định được vị thế thương hiệu và đặt mục tiêu sẽ vươn lên vị trí hàng đầu trên thị trường thiết bị nhà bếp.
\r\n\r\n
 
\r\n\r\n
Dựa trên thế mạnh sở hữu đội ngũ kỹ sư thiết kế chuyên nghiệp, giàu kinh nghiệm và ý tưởng, chúng tôi tự tin cung cấp sản phẩm chất lượng tốt nhất với thiết kế hiện đại, tiện nghi. STAR QUALITY không ngừng nâng cao và sáng tạo hơn nữa để hoàn thiện sản phẩm; cải tiến quy trình, công nghệ hướng đến thỏa mãn nhu cầu đa dạng của khách hàng.
\r\n\r\n
 
\r\n\r\n
“Uy tín - Chất Lượng - Chuyên nghiệp” là những giá trị mà STAR QUALITY cam kết thưc hiện khi làm việc cùng khách hàng. Chúng tôi xin gửi lời tri ân sâu sắc đến khách hàng và đối tác cùng đồng hành với chúng tôi trong thời gian qua và mong nhận được sự quan tâm, ủng hộ của quý vị trong tương tại.\"
\r\n', 'untitled-3-2899.jpg', 'untitled-3-2899-9158_680x665.jpg', 0, 1, 1591712685, 1592024242, '', '', '', '', '', '', 'gioi-thieu', '', '', '', '', '', '', '', '

Chúng tôi là 

\r\n\r\n

STAR QUALITY

\r\n\r\n

\"Chúng tôi nâng tầm giá và chuyên nghiệp cho không gian bếp\"

\r\n\r\n

“Uy tín - Chất Lượng - Chuyên nghiệp” là những giá trị mà STAR QUALITY cam kết thưc hiện khi làm việc cùng khách hàng. Chúng tôi xin gửi lời tri ân sâu sắc đến khách hàng và đối tác cùng đồng hành với chúng tôi trong thời gian qua và mong nhận được sự quan tâm, ủng hộ của quý vị trong tương tại

\r\n\r\n

 

\r\n', '', '', '', '', ''), (2, '', '', '', '

Địa chỉ: Số 2/106 A, Đường Số 08, Phường Bình Hưng Hòa , Quận Bình Tân, TP Hồ Chí Minh
\r\nĐiện Thoại: (028) 7302 8499
\r\nEmail: hai.nguyen@qstar.com.vn
\r\nHotline : 0989 701 395

\r\n', '', '', 0, 1, 1591792168, 1591941066, '', '', '', '', '', '', 'footer', '', '', '', '', '', '', '', '', '', '', '', '', ''), (3, '', '', '', '

CÔNG TY TNHH CHẤT LƯỢNG SAO

\r\n\r\n

Địa chỉ : Số 2/106 A, Đường Số 08, Phường Bình Hưng Hòa , Quận Bình Tân, TP Hồ Chí Minh

\r\n\r\n

Điện thoại : 0989 701 395

\r\n\r\n

Email : hai.nguyen@qstar.com.vn

\r\n\r\n

Website : qstar.com.vn

\r\n', '', '', 1, 1, 1592145121, 1592145174, '', '', '', '', '', '', 'lienhe', '', '', '', '', '', '', '', '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_anhnen` -- CREATE TABLE `table_anhnen` ( `id` int(10) NOT NULL, `color` varchar(10) NOT NULL, `position_x` varchar(225) NOT NULL, `position_y` varchar(225) NOT NULL, `type` varchar(225) NOT NULL, `fixed` varchar(20) NOT NULL DEFAULT '0', `bgsize` varchar(225) NOT NULL, `photo` varchar(225) NOT NULL, `repea` varchar(225) NOT NULL, `hienthi` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_anhnen` -- INSERT INTO `table_anhnen` (`id`, `color`, `position_x`, `position_y`, `type`, `fixed`, `bgsize`, `photo`, `repea`, `hienthi`) VALUES (1, '', '', '', '', '', '', '', '', 1), (2, '#E81818', '', '', 'backgroundma', '', '', '', '', 0), (3, '', '', '', 'xbackgroundma', '', '', '', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `table_background` -- CREATE TABLE `table_background` ( `id` int(10) UNSIGNED NOT NULL, `ten` varchar(225) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `mota` text NOT NULL, `noidung` text NOT NULL, `photo` varchar(100) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `ngaytao` int(11) NOT NULL DEFAULT 0, `ngaysua` int(11) NOT NULL DEFAULT 0, `title` varchar(100) NOT NULL, `description` varchar(1000) NOT NULL, `keywords` varchar(200) NOT NULL, `type` varchar(100) NOT NULL, `tenen` varchar(255) NOT NULL, `motaen` text NOT NULL, `noidungen` text NOT NULL, `photoen` varchar(255) NOT NULL, `link` varchar(255) NOT NULL, `photocn` varchar(255) NOT NULL, `tencn` varchar(255) NOT NULL, `noidungcn` text NOT NULL, `motacn` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_background` -- INSERT INTO `table_background` (`id`, `ten`, `tenkhongdau`, `mota`, `noidung`, `photo`, `thumb`, `stt`, `hienthi`, `ngaytao`, `ngaysua`, `title`, `description`, `keywords`, `type`, `tenen`, `motaen`, `noidungen`, `photoen`, `link`, `photocn`, `tencn`, `noidungcn`, `motacn`) VALUES (1, '', '', '', '', '', '', 0, 1, 1564802013, 0, '', '', '', 'bgvisao', '', '', '', '', '', '', '', '', ''), (2, '', '', '', '', '', '', 0, 1, 1564802019, 0, '', '', '', 'bgdathen', '', '', '', '', '', '', '', '', ''), (3, '', '', '', '', 'untitled-10000logo-13.png', 'untitled-10000logo-13-5862_100x65.png', 0, 1, 1564803046, 1591712508, '', '', '', 'logo', '', '', '', 'untitled-10023logo-3870.png', '', '', '', '', ''), (4, '', '', '', '', 'untitled-2-3641.png', 'untitled-2-6990-1704_700x125.png', 0, 1, 1564803058, 1591299302, '', '', '', 'banner', '', '', '', 'untitled-2-6990.png', '', '', '', '', ''), (5, '', '', '', '', 'untitled-2-1738.jpg', 'untitled-2-1738-0348_1366x215.jpg', 0, 1, 1564803064, 1591299343, '', '', '', 'bgbn', '', '', '', '', '', '', '', '', ''), (6, '', '', '', '', 'untitled-10-6199.jpg', '', 0, 1, 1564996911, 1579505518, '', '', '', 'bgft', '', '', '', '', '', '', '', '', ''), (7, '', '', '', '', '', '', 0, 1, 1567676665, 0, '', '', '', '', '', '', '', '', '', '', '', '', ''), (8, '', '', '', '', 'untitled-23-6805.jpg', '', 0, 1, 1567997794, 1567997800, '', '', '', 'bg-dt', '', '', '', '', '', '', '', '', ''), (9, '', '', '', '', 'untitled-23-9037.png', '', 0, 1, 1567997803, 1567997809, '', '', '', 'logo-dt', '', '', '', '', '', '', '', '', ''), (10, '', '', '', '', '', '', 1, 1, 1568617059, 0, '', '', '', 'favicon', '', '', '', '', '', '', '', '', ''), (11, '', '', '', '', '550x480-2661.png', '', 1, 1, 1569811553, 1569812168, '', '', '', 'pupop', '', '', '', '', '', '', '', '', ''), (12, '', '', '', '', '', '', 1, 1, 1573696383, 0, '', '', '', 'bnbg', '', '', '', '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_chitietdonhang` -- CREATE TABLE `table_chitietdonhang` ( `id` int(10) UNSIGNED NOT NULL, `ten` varchar(225) NOT NULL, `gia` int(11) NOT NULL, `soluong` int(11) NOT NULL, `size` varchar(30) NOT NULL, `tonggia` int(11) NOT NULL, `photo` varchar(100) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `ngaytao` int(10) UNSIGNED NOT NULL DEFAULT 0, `ngaysua` int(10) UNSIGNED NOT NULL DEFAULT 0, `madonhang` varchar(50) NOT NULL, `masp` varchar(200) NOT NULL, `id_donhang` int(11) NOT NULL, `giacu` int(11) NOT NULL, `id_sanpham` int(11) NOT NULL, `mausac` varchar(50) NOT NULL, `ngaysinh` int(11) NOT NULL, `gioitinh` tinyint(1) NOT NULL, `loai` tinyint(1) NOT NULL, `tuoi` tinyint(1) NOT NULL, `phong` tinyint(1) NOT NULL, `visa` tinyint(1) NOT NULL, `giaphong` varchar(255) NOT NULL, `giavisa` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `table_com` -- CREATE TABLE `table_com` ( `id` int(10) UNSIGNED NOT NULL, `noibat` tinyint(4) NOT NULL, `ten` varchar(225) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `photo` varchar(100) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `ngaytao` int(10) UNSIGNED NOT NULL DEFAULT 0, `ngaysua` int(10) UNSIGNED NOT NULL DEFAULT 0, `link` varchar(255) NOT NULL, `tenen` varchar(255) NOT NULL, `com` varchar(100) NOT NULL, `act` varchar(100) NOT NULL, `type` varchar(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_com` -- INSERT INTO `table_com` (`id`, `noibat`, `ten`, `tenkhongdau`, `photo`, `thumb`, `stt`, `hienthi`, `ngaytao`, `ngaysua`, `link`, `tenen`, `com`, `act`, `type`) VALUES (2, 0, 'Quản lý danh mục 3', 'quan-ly-danh-muc-3', '', '', 3, 1, 1432955333, 1473908677, '', '', 'product', 'man_cat', 'sanpham'), (3, 0, 'Quản lý danh mục 2', 'quan-ly-danh-muc-2', '', '', 2, 1, 1432955365, 1473908619, '', '', 'product', 'man_list', 'sanpham'), (4, 0, 'Quản lý danh mục 1', 'quan-ly-danh-muc-1', '', '', 1, 1, 1432955410, 1473908550, '', '', 'product', 'man_danhmuc', 'sanpham'), (6, 0, 'Quản lý danh mục 4', 'quan-ly-danh-muc-4', '', '', 4, 1, 1473908704, 1473908715, '', '', 'product', 'man_item', 'sanpham'), (7, 0, 'Quản lý đơn hàng', 'quan-ly-don-hang', '', '', 5, 1, 1473908763, 0, '', '', 'order', 'man', ''), (8, 0, 'Quản lý sản phẩm', 'quan-ly-san-pham', '', '', 6, 1, 1473908796, 0, '', '', 'product', 'man', 'sanpham'), (9, 0, 'Video', 'video', '', '', 7, 1, 1473908842, 0, '', '', 'video', 'man', ''), (10, 0, 'Giới thiệu', 'gioi-thieu', '', '', 8, 1, 1473908876, 0, '', '', 'about', 'capnhat', 'about'), (11, 0, 'Cập nhật liên hệ', 'cap-nhat-lien-he', '', '', 9, 1, 1473908906, 0, '', '', 'about', 'capnhat', 'lienhe'), (12, 0, 'Cập nhật footer', 'cap-nhat-footer', '', '', 10, 1, 1473908930, 0, '', '', 'about', 'capnhat', 'footer'), (13, 0, 'Quản lý Danh mục', 'quan-ly-danh-muc', '', '', 11, 1, 1473908980, 0, '', '', 'news', 'man_cat', 'tintuc'), (14, 0, 'Quản lý tin tức', 'quan-ly-tin-tuc', '', '', 12, 1, 1473909001, 0, '', '', 'news', 'man', 'tintuc'), (15, 0, 'Lấy tin từ Vnexpress', 'lay-tin-tu-vnexpress', '', '', 13, 1, 1473909027, 0, '', '', 'vnexpress', 'man', ''), (16, 0, 'Quản lý liên kết web', 'quan-ly-lien-ket-web', '', '', 14, 1, 1473909057, 0, '', '', 'lkweb', 'man', ''), (17, 0, 'Quản lý hỗ trợ trực tuyến', 'quan-ly-ho-tro-truc-tuyen', '', '', 15, 1, 1473909073, 0, '', '', 'yahoo', 'man', ''), (18, 0, 'Quản lý Đăng ký nhận tin', 'quan-ly-dang-ky-nhan-tin', '', '', 16, 1, 1473909099, 0, '', '', 'newsletter', 'man', ''), (19, 0, 'Cập nhật banner', 'cap-nhat-banner', '', '', 17, 1, 1473909173, 0, '', '', 'background', 'capnhat', 'banner'), (20, 0, 'Cập nhật slider', 'cap-nhat-slider', '', '', 18, 1, 1473909201, 0, '', '', 'background', 'capnhat', 'slider'), (21, 0, 'Quản lý đối tác', 'quan-ly-doi-tac', '', '', 19, 1, 1473909223, 0, '', '', 'background', 'capnhat', 'doitac'), (22, 0, 'Quản lý quảng cáo', 'quan-ly-quang-cao', '', '', 20, 1, 1473909248, 0, '', '', 'background', 'capnhat', 'quangcao'), (23, 0, 'Quản lý quảng cáo 2 bên', 'quan-ly-quang-cao-2-ben', '', '', 21, 1, 1473909498, 0, '', '', 'background', 'capnhat', 'letruot'), (24, 0, 'Cập nhật pupop quảng cáo', 'cap-nhat-pupop-quang-cao', '', '', 22, 1, 1473909520, 0, '', '', 'background', 'capnhat', 'pupop'), (25, 0, 'Cập nhật background', 'cap-nhat-background', '', '', 23, 1, 1473909546, 0, '', '', 'anhnen', 'capnhat', 'background'), (26, 0, 'Quản lý Tỉnh thành', 'quan-ly-tinh-thanh', '', '', 24, 1, 1473909574, 0, '', '', 'place', 'man_city', ''), (27, 0, 'Quản lý Quận huyện', 'quan-ly-quan-huyen', '', '', 25, 1, 1473909601, 0, '', '', 'place', 'man_dist', ''), (28, 0, 'Quản lý Phường xã', 'quan-ly-phuong-xa', '', '', 26, 1, 1473909626, 0, '', '', 'place', 'man_ward', ''), (29, 0, 'Quản lý Đường', 'quan-ly-duong', '', '', 27, 1, 1473909647, 0, '', '', 'place', 'man_street', ''), (30, 0, 'Cập nhật thông tin công ty', 'cap-nhat-thong-tin-cong-ty', '', '', 28, 1, 1473909669, 0, '', '', 'company', 'capnhat', ''), (31, 0, 'Cập nhật thông tin SEO website', 'cap-nhat-thong-tin-seo-website', '', '', 29, 1, 1473909694, 0, '', '', 'meta', 'capnhat', ''), (32, 0, 'Quản lý Tài Khoản', 'quan-ly-tai-khoan', '', '', 30, 1, 1473909725, 0, '', '', 'user', 'admin_edit', ''), (33, 0, 'Quản lý thành viên', 'quan-ly-thanh-vien', '', '', 31, 1, 1473909741, 0, '', '', 'user', 'man', ''), (34, 0, 'Quản lý nhóm thành viên', 'quan-ly-nhom-thanh-vien', '', '', 32, 1, 1473909859, 1473916833, '', '', 'phanquyen', 'man', ''), (35, 0, 'Quản lý dịch vụ', 'quan-ly-dich-vu', '', '', 12, 1, 1473933552, 0, '', '', 'news', 'man', 'dichvu'); -- -------------------------------------------------------- -- -- Table structure for table `table_comment` -- CREATE TABLE `table_comment` ( `id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `parent_id` int(11) NOT NULL, `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `like` text COLLATE utf8_unicode_ci NOT NULL, `ngaytao` int(11) NOT NULL, `ngaysua` int(11) NOT NULL, `hienthi` tinyint(4) NOT NULL DEFAULT 1, `stt` int(11) NOT NULL DEFAULT 1, `type` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `ten` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `tenen` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `mota` text COLLATE utf8_unicode_ci NOT NULL, `motaen` text COLLATE utf8_unicode_ci NOT NULL, `noidung` text COLLATE utf8_unicode_ci NOT NULL, `noidungen` text COLLATE utf8_unicode_ci NOT NULL, `lang` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `thumb` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `photo` varchar(300) COLLATE utf8_unicode_ci NOT NULL, `tenkhongdau` varchar(300) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `table_company` -- CREATE TABLE `table_company` ( `id` int(10) NOT NULL, `ten` varchar(150) NOT NULL, `dienthoai` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `diachi` varchar(255) NOT NULL, `toado` varchar(50) NOT NULL, `fax` varchar(100) NOT NULL, `fanpage` varchar(255) NOT NULL, `website` varchar(50) NOT NULL, `giomo` varchar(255) NOT NULL, `tenen` varchar(255) NOT NULL, `diachien` varchar(500) NOT NULL, `favicon` varchar(255) NOT NULL, `faviconthumb` varchar(255) NOT NULL, `dongdau` varchar(255) NOT NULL, `dongdauthumb` varchar(255) NOT NULL, `codethem` text NOT NULL, `sitemap` varchar(20) NOT NULL, `soluong_sp` int(11) NOT NULL, `soluong_spk` int(11) NOT NULL, `soluong_tin` int(11) NOT NULL, `soluong_tink` int(11) NOT NULL, `lang_default` varchar(20) NOT NULL, `title` varchar(200) NOT NULL, `keywords` varchar(1000) NOT NULL, `description` varchar(300) NOT NULL, `h3` varchar(200) NOT NULL, `h2` varchar(200) NOT NULL, `h1` varchar(200) NOT NULL, `codethem2` text NOT NULL, `bando` text NOT NULL, `bct` varchar(255) NOT NULL, `slogan` varchar(200) NOT NULL, `sloganen` varchar(200) NOT NULL, `tencn` varchar(255) NOT NULL, `diachicn` varchar(255) NOT NULL, `slogancn` varchar(200) NOT NULL, `ngaytao` int(11) NOT NULL, `thuoctinh` text DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_company` -- INSERT INTO `table_company` (`id`, `ten`, `dienthoai`, `email`, `diachi`, `toado`, `fax`, `fanpage`, `website`, `giomo`, `tenen`, `diachien`, `favicon`, `faviconthumb`, `dongdau`, `dongdauthumb`, `codethem`, `sitemap`, `soluong_sp`, `soluong_spk`, `soluong_tin`, `soluong_tink`, `lang_default`, `title`, `keywords`, `description`, `h3`, `h2`, `h1`, `codethem2`, `bando`, `bct`, `slogan`, `sloganen`, `tencn`, `diachicn`, `slogancn`, `ngaytao`, `thuoctinh`) VALUES (1, 'CÔNG TY TNHH CHẤT LƯỢNG SAO', '0989 701 395', 'hai.nguyen@qstar.com.vn', 'Số 2/106 A, Đường Số 08, Phường Bình Hưng Hòa , Quận Bình Tân, TP Hồ Chí Minh', '10.853741418142036,106.62834708220907', '', 'https://www.facebook.com/thietbinhabepchatluongsao/', 'qstar.com.vn', '', 'DiO', '1358/28/159 Quang Trung, Phường 14, Quận Gò Vấp, Thành phố Hồ Chí Minh', 'facia-6587.jpg', 'untitled-24638_32x21.png', 'f00000-8245.png', 'f000005140_70x49.png', ' ', 'sitemap.xml', 8, 8, 6, 10, '', 'CÔNG TY TNHH CHẤT LƯỢNG SAO', 'CÔNG TY TNHH CHẤT LƯỢNG SAO', 'CÔNG TY TNHH CHẤT LƯỢNG SAO', 'CÔNG TY TNHH CHẤT LƯỢNG SAO', 'CÔNG TY TNHH CHẤT LƯỢNG SAO', 'CÔNG TY TNHH CHẤT LƯỢNG SAO', ' ', '', '', '', '', '', '', '', 0, '{\"tt_zalo\":\"0989 701 395\",\"tt_messenger\":\"https://www.facebook.com/thietbinhabepchatluongsao/\"}'); -- -------------------------------------------------------- -- -- Table structure for table `table_com_quyen` -- CREATE TABLE `table_com_quyen` ( `id` int(10) UNSIGNED NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `ngaytao` int(10) UNSIGNED NOT NULL DEFAULT 0, `ngaysua` int(10) UNSIGNED NOT NULL DEFAULT 0, `com` varchar(100) NOT NULL, `act` varchar(400) NOT NULL, `type` varchar(100) NOT NULL, `id_quyen` int(11) NOT NULL, `act_cap` varchar(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_com_quyen` -- INSERT INTO `table_com_quyen` (`id`, `stt`, `hienthi`, `ngaytao`, `ngaysua`, `com`, `act`, `type`, `id_quyen`, `act_cap`) VALUES (10, 1, 1, 1473947975, 1473957730, 'news', 'man,add,edit,delete,save', 'dichvu', 4, ''), (9, 1, 1, 1473947969, 1474627615, 'product', 'man_cat,add_cat,edit_cat,delete_cat,save_cat', 'sanpham', 4, 'man_cat'), (8, 1, 1, 1473947966, 1473958588, 'product', 'man_list,add_list,edit_list,delete_list,save_list', 'sanpham', 4, 'man_list'), (7, 1, 1, 1473947952, 1473958586, 'product', 'man_danhmuc,add_danhmuc,edit_danhmuc,delete_danhmuc,save_danhmuc', 'sanpham', 4, 'man_danhmuc'), (11, 1, 1, 1473947980, 1473958624, 'news', 'man,add,edit,delete,save', 'tintuc', 4, ''), (12, 1, 1, 1473948574, 0, 'video', 'man,add,edit,delete,save', '', 4, ''), (13, 1, 1, 1473949851, 1473958620, 'news', 'man_cat,add_cat,edit_cat,delete_cat,save_cat', 'tintuc', 4, 'man_cat'), (14, 1, 1, 1473954306, 1473958597, 'order', 'man,add,edit,delete,save', '', 4, ''), (15, 1, 1, 1473954736, 1473958612, 'about', 'capnhat,add,edit,delete,save', 'about', 4, ''), (16, 1, 1, 1473958279, 1473958602, 'product', 'man,add,edit,delete,save', 'sanpham', 4, ''), (17, 1, 1, 1473958594, 0, 'product', 'man_item,add_item,edit_item,delete_item,save_item', 'sanpham', 4, 'man_item'), (18, 1, 1, 1473958615, 0, 'about', 'capnhat,add,edit,delete,save', 'lienhe', 4, ''), (19, 1, 1, 1473958617, 0, 'about', 'capnhat,add,edit,delete,save', 'footer', 4, ''), (20, 1, 1, 1473958627, 0, 'vnexpress', 'man,add,edit,delete,save', '', 4, ''), (21, 1, 1, 1473958631, 0, 'lkweb', 'man,add,edit,delete,save', '', 4, ''), (22, 1, 1, 1473958634, 0, 'yahoo', 'man,add,edit,delete,save', '', 4, ''), (23, 1, 1, 1473958636, 0, 'newsletter', 'man,add,edit,delete,save', '', 4, ''), (24, 1, 1, 1473958638, 0, 'background', 'capnhat,add,edit,delete,save', 'banner', 4, ''), (25, 1, 1, 1473958642, 0, 'background', 'capnhat,add,edit,delete,save', 'slider', 4, ''), (26, 1, 1, 1473958645, 0, 'background', 'capnhat,add,edit,delete,save', 'doitac', 4, ''), (27, 1, 1, 1473958648, 0, 'background', 'capnhat,add,edit,delete,save', 'quangcao', 4, ''), (28, 1, 1, 1473958650, 0, 'background', 'capnhat,add,edit,delete,save', 'letruot', 4, ''), (29, 1, 1, 1473958652, 0, 'background', 'capnhat,add,edit,delete,save', 'pupop', 4, ''), (30, 1, 1, 1473958655, 0, 'anhnen', 'capnhat,add,edit,delete,save', 'background', 4, ''), (31, 1, 1, 1473958658, 0, 'place', 'man_city,add_city,edit_city,delete_city,save_city', '', 4, 'man_city'), (32, 1, 1, 1473958660, 0, 'place', 'man_dist,add_dist,edit_dist,delete_dist,save_dist', '', 4, 'man_dist'), (33, 1, 1, 1473958663, 0, 'place', 'man_ward,add_ward,edit_ward,delete_ward,save_ward', '', 4, 'man_ward'), (34, 1, 1, 1473958666, 0, 'place', 'man_street,add_street,edit_street,delete_street,save_street', '', 4, 'man_street'), (35, 1, 1, 1473958669, 0, 'company', 'capnhat,add,edit,delete,save', '', 4, ''), (36, 1, 1, 1473958671, 0, 'meta', 'capnhat,add,edit,delete,save', '', 4, ''), (37, 1, 1, 1473958674, 1473958677, 'user', 'admin_edit', '', 4, 'admin_edit'), (38, 1, 1, 1473958679, 0, 'user', 'man,add,edit,delete,save', '', 4, ''), (39, 1, 1, 1473958682, 0, 'phanquyen', 'man,add,edit,delete,save', '', 4, ''), (40, 1, 1, 1473958749, 1473992561, 'product', 'man_danhmuc,add_danhmuc,edit_danhmuc,delete_danhmuc,save_danhmuc', 'sanpham', 2, 'man_danhmuc'), (41, 1, 1, 1473958752, 1473992536, 'product', 'man_list,add_list,edit_list,delete_list,save_list', 'sanpham', 2, 'man_list'), (42, 1, 1, 1473958754, 0, 'product', 'man_cat,', 'sanpham', 2, 'man_cat'), (43, 1, 1, 1473958757, 0, 'product', 'man_item,', 'sanpham', 2, 'man_item'), (44, 1, 1, 1473958761, 0, 'order', 'man,', '', 2, ''), (45, 1, 1, 1473958764, 0, 'product', 'man,', 'sanpham', 2, ''); -- -------------------------------------------------------- -- -- Table structure for table `table_danhgiasao` -- CREATE TABLE `table_danhgiasao` ( `id` int(10) UNSIGNED NOT NULL, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `link` varchar(400) NOT NULL, `ip` varchar(100) NOT NULL, `time` int(11) NOT NULL, `giatri` int(11) NOT NULL, `code` varchar(100) NOT NULL, `id_sanpham` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_danhgiasao` -- INSERT INTO `table_danhgiasao` (`id`, `hienthi`, `link`, `ip`, `time`, `giatri`, `code`, `id_sanpham`) VALUES (1, 1, 'http://localhost/t1219/phamthiuyen_1769419/san-pham/doloremque-turpis-blandit-de-92.html', '', 1576825754, 4, 'vtb6ed2j12j4kc0bt17pqf0a9a', 92); -- -------------------------------------------------------- -- -- Table structure for table `table_donhang` -- CREATE TABLE `table_donhang` ( `id` int(11) NOT NULL, `madonhang` varchar(20) NOT NULL, `hoten` varchar(255) NOT NULL, `dienthoai` varchar(255) NOT NULL, `diachi` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `httt` int(11) NOT NULL, `tonggia` int(11) NOT NULL, `noidung` text NOT NULL, `ghichu` text NOT NULL, `ngaytao` varchar(30) NOT NULL, `tinhtrang` int(11) NOT NULL, `thanhpho` int(11) NOT NULL, `quan` int(11) NOT NULL, `htgh` int(11) NOT NULL DEFAULT 1, `nguongoc` varchar(255) NOT NULL, `ngaycapnhat` int(11) NOT NULL, `ngaydi` varchar(30) NOT NULL, `ip` varchar(50) NOT NULL, `ngayin` varchar(300) NOT NULL, `export` tinyint(4) NOT NULL, `gioin` varchar(20) NOT NULL, `phi` int(11) NOT NULL, `phithem` int(11) NOT NULL, `thuve` int(11) NOT NULL, `id_user` int(11) NOT NULL, `phuong` int(11) NOT NULL, `id_sanpham` int(11) NOT NULL, `quoctich` varchar(255) NOT NULL, `ten` varchar(255) NOT NULL, `didong` varchar(20) NOT NULL, `ngaysinh` int(11) NOT NULL, `coupon` varchar(255) NOT NULL, `coupon_cost` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `table_hinhanh` -- CREATE TABLE `table_hinhanh` ( `id` int(10) UNSIGNED NOT NULL, `photo` varchar(225) NOT NULL, `ten` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `mota` text NOT NULL, `link` varchar(255) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `thumb` varchar(255) NOT NULL, `type` varchar(100) NOT NULL, `id_hinhanh` int(11) NOT NULL, `noibat` tinyint(4) NOT NULL, `tenen` varchar(255) NOT NULL, `motaen` text NOT NULL, `tencn` varchar(255) NOT NULL, `motacn` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_hinhanh` -- INSERT INTO `table_hinhanh` (`id`, `photo`, `ten`, `mota`, `link`, `stt`, `hienthi`, `thumb`, `type`, `id_hinhanh`, `noibat`, `tenen`, `motaen`, `tencn`, `motacn`) VALUES (804, '550x370--copy-2-1601.jpg', '', '', '', 0, 1, '550x370--copy-2-1601-5526_550x370.jpg', 'gioi-thieu', 0, 0, '', '', '', ''), (805, '550x370--copy-3-8064.jpg', '', '', '', 0, 1, '550x370--copy-3-8064-4995_550x370.jpg', 'gioi-thieu', 0, 0, '', '', '', ''), (806, '550x370--copy-8022.jpg', '', '', '', 0, 1, '550x370--copy-8022-7266_550x370.jpg', 'gioi-thieu', 0, 0, '', '', '', ''), (807, '550x370-6365.jpg', '', '', '', 0, 1, '550x370-6365-6781_550x370.jpg', 'gioi-thieu', 0, 0, '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_hinhthucgiaohang` -- CREATE TABLE `table_hinhthucgiaohang` ( `id` int(10) UNSIGNED NOT NULL, `id_item` int(11) NOT NULL, `noibat` tinyint(4) NOT NULL, `ten` varchar(225) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `mota` text NOT NULL, `noidung` text NOT NULL, `photo` varchar(100) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `ngaytao` int(10) UNSIGNED NOT NULL DEFAULT 0, `ngaysua` int(10) UNSIGNED NOT NULL DEFAULT 0, `title` varchar(100) NOT NULL, `keywords` varchar(1000) NOT NULL, `description` varchar(200) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_hinhthucgiaohang` -- INSERT INTO `table_hinhthucgiaohang` (`id`, `id_item`, `noibat`, `ten`, `tenkhongdau`, `mota`, `noidung`, `photo`, `thumb`, `stt`, `hienthi`, `ngaytao`, `ngaysua`, `title`, `keywords`, `description`) VALUES (1, 0, 0, 'Giao Hàng Tận Nơi', 'giao-hang-tan-noi', '', '', '', '', 1, 1, 1408034136, 1436756823, '', '', ''), (2, 0, 0, 'Qua bưu điện', 'tu-giao-tan-nha', '', '', '', '', 2, 1, 1410860298, 0, '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_httt` -- CREATE TABLE `table_httt` ( `id` int(11) NOT NULL, `ten` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `hienthi` int(11) NOT NULL DEFAULT 1, `noibat` int(11) NOT NULL, `stt` int(11) NOT NULL, `tenen` varchar(100) CHARACTER SET utf8 NOT NULL, `noidung` text CHARACTER SET utf8 NOT NULL, `noidungen` text CHARACTER SET utf8 NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `table_httt` -- INSERT INTO `table_httt` (`id`, `ten`, `hienthi`, `noibat`, `stt`, `tenen`, `noidung`, `noidungen`) VALUES (1, 'Tiền mặt', 1, 0, 1, 'Cash', '

Tiền mặt Beatae tristique nulla, nesciunt veniam scelerisque non tempor proin feugiat tincidunt risus, turpis maiores proident laboriosam, hac turpis, dolor numquam eros, exercitation ipsa totam! Quisquam cubilia! Leo leo! Aperiam senectus curabit

\r\n', ''), (2, 'Chuyển khoản', 1, 0, 2, 'Bank transfer', '

Chuyển khoản eatae tristique nulla, nesciunt veniam scelerisque non tempor proin feugiat tincidunt risus, turpis maiores proident laboriosam, hac turpis, dolor numquam eros, exercitation ipsa totam! Quisquam cubilia! Leo leo! Aperiam senectus curabit

\r\n', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_lienhe` -- CREATE TABLE `table_lienhe` ( `id` int(10) UNSIGNED NOT NULL, `noibat` tinyint(4) NOT NULL, `ten` varchar(225) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `photo` varchar(100) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `ngaytao` int(10) UNSIGNED NOT NULL DEFAULT 0, `ngaysua` int(10) UNSIGNED NOT NULL DEFAULT 0, `link` varchar(255) NOT NULL, `tenen` varchar(255) NOT NULL, `type` varchar(100) NOT NULL, `diachi` varchar(200) NOT NULL, `dienthoai` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `chude` varchar(200) NOT NULL, `noidung` text NOT NULL, `diachien` varchar(200) NOT NULL, `noidungen` text NOT NULL, `chudeen` varchar(200) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `table_lkweb` -- CREATE TABLE `table_lkweb` ( `id` int(10) UNSIGNED NOT NULL, `noibat` tinyint(4) NOT NULL, `ten` varchar(225) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `photo` varchar(100) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `ngaytao` int(10) UNSIGNED NOT NULL DEFAULT 0, `ngaysua` int(10) UNSIGNED NOT NULL DEFAULT 0, `link` varchar(255) NOT NULL, `tenen` varchar(255) NOT NULL, `type` varchar(100) NOT NULL, `tencn` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_lkweb` -- INSERT INTO `table_lkweb` (`id`, `noibat`, `ten`, `tenkhongdau`, `photo`, `thumb`, `stt`, `hienthi`, `ngaytao`, `ngaysua`, `link`, `tenen`, `type`, `tencn`) VALUES (43, 0, 'Facebook', 'facebook', 'Untitled-1_0010_Layer-10.png.png', '', 1, 1, 1591792158, 1591974465, '', '', 'mxhft', ''), (34, 0, 'Youtube ++', 'youtube-', 'Untitled-1_0009_Layer-11.png.png', '', 2, 1, 1582861349, 1591974474, '', '', 'mxhft', ''), (36, 0, '', '', 'Untitled-1_0005_Layer-6.png.png', '', 1, 1, 1585554682, 1591791317, '', '', 'mxh', ''), (37, 0, 'Instagram', 'instagram', 'Untitled-1_0008_Layer-12.png.png', '', 4, 1, 1587180563, 1591974482, '', '', 'mxhft', ''), (38, 0, 'Twitter', 'twitter', 'Untitled-1_0007_Layer-13.png.png', '', 3, 1, 1587180578, 1591974491, '', '', 'mxhft', ''), (39, 0, 'Tiktok', 'tiktok', 'Untitled-1_0006_Layer-14.png.png', '', 5, 1, 1587180586, 1591974498, '', '', 'mxhft', ''), (40, 0, '', '', 'Untitled-1_0004_Layer-7.png.png', '', 1, 1, 1589878314, 1591791310, '', '', 'mxh', ''), (41, 0, '', '', 'Untitled-1_0003_Layer-8.png.png', '', 1, 1, 1591299469, 1591791302, '', '', 'mxh', ''), (42, 0, '', '', 'Untitled-1_0002_Layer-9.png.png', '', 1, 1, 1591299479, 1591791295, '', '', 'mxh', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_news` -- CREATE TABLE `table_news` ( `id` int(10) UNSIGNED NOT NULL, `id_list` int(11) NOT NULL, `id_item` int(10) NOT NULL, `id_cat` int(11) NOT NULL, `noibat` tinyint(4) NOT NULL, `photo` varchar(225) NOT NULL, `thumb` varchar(225) NOT NULL, `photo2` varchar(255) NOT NULL, `thumb2` varchar(255) NOT NULL, `taptin` varchar(255) NOT NULL, `ten` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `mota` text NOT NULL, `noidung` longtext NOT NULL, `luotxem` int(11) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `spmoi` int(11) NOT NULL, `ngaytao` int(11) NOT NULL, `ngaysua` int(11) NOT NULL, `title` varchar(100) NOT NULL, `keywords` varchar(1000) NOT NULL, `description` varchar(200) NOT NULL, `h3` varchar(200) NOT NULL, `h2` varchar(200) NOT NULL, `h1` varchar(200) NOT NULL, `id_danhmuc` int(11) NOT NULL, `tenen` varchar(255) NOT NULL, `motaen` text NOT NULL, `noidungen` text NOT NULL, `tencn` varchar(255) NOT NULL, `motacn` text NOT NULL, `noidungcn` text NOT NULL, `type` varchar(255) NOT NULL, `tag` text NOT NULL, `chucvu` varchar(255) NOT NULL, `chucvuen` varchar(255) NOT NULL, `chucvucn` varchar(255) NOT NULL, `link` varchar(255) NOT NULL, `linken` varchar(255) NOT NULL, `linkcn` varchar(255) NOT NULL, `color` varchar(10) NOT NULL, `mota2` text NOT NULL, `mota2en` text NOT NULL, `mota2cn` text NOT NULL, `ten2` varchar(255) NOT NULL, `ten2en` varchar(255) NOT NULL, `ten2cn` varchar(255) NOT NULL, `gia` varchar(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_news` -- INSERT INTO `table_news` (`id`, `id_list`, `id_item`, `id_cat`, `noibat`, `photo`, `thumb`, `photo2`, `thumb2`, `taptin`, `ten`, `tenkhongdau`, `mota`, `noidung`, `luotxem`, `stt`, `hienthi`, `spmoi`, `ngaytao`, `ngaysua`, `title`, `keywords`, `description`, `h3`, `h2`, `h1`, `id_danhmuc`, `tenen`, `motaen`, `noidungen`, `tencn`, `motacn`, `noidungcn`, `type`, `tag`, `chucvu`, `chucvuen`, `chucvucn`, `link`, `linken`, `linkcn`, `color`, `mota2`, `mota2en`, `mota2cn`, `ten2`, `ten2en`, `ten2cn`, `gia`) VALUES (116, 0, 0, 0, 0, '', '', '', '', '', 'Tên tag 1', 'ten-tag-1', '', '', 0, 1, 1, 0, 1571385454, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'tags', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (117, 0, 0, 0, 0, '', '', '', '', '', 'Tên tag 12', 'ten-tag-12', '', '', 0, 1, 1, 0, 1571385458, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'tags', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (118, 0, 0, 0, 0, '', '', '', '', '', 'Tên tag 123', 'ten-tag-123', '', '', 0, 1, 1, 0, 1571385461, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'tags', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (119, 0, 0, 0, 0, '', '', '', '', '', 'Tên tag 1234', 'ten-tag-1234', '', '', 0, 1, 1, 0, 1571385465, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'tags', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (205, 0, 0, 0, 0, '400x300-7013.png', '400x3001197_200x150.png', '', '', '', 'Nulla turpis faucibus purus quam ma', 'nulla-turpis-faucibus-purus-quam-ma', 'Nulla turpis faucibus purus quam magnam vivamus officiis, facilis hymenaeos, mollis parturient suscipit, mi harum dolores, duis ullamco torquent error culpa vitae laudantium donec accusantium aliquip voluptatum neque? Cursus tristique proin interdum cillum, mollis bibendum similique. Magnam do! Cras sit beatae aperiam repellendus enim, scelerisque sunt aliqua adip', '', 1, 1, 1, 0, 1573704253, 0, '', '', '', '', '', '', 9, '', '', '', '', '', '', 'muctieu', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (206, 0, 0, 0, 0, '400x300-4377.png', '400x3006185_200x150.png', '', '', '', 'Nulla turpis faucibus purus quam ma 1', 'nulla-turpis-faucibus-purus-quam-ma-1', 'Nulla turpis faucibus purus quam magnam vivamus officiis, facilis hymenaeos, mollis parturient suscipit, mi harum dolores, duis ullamco torquent error culpa vitae laudantium donec accusantium aliquip voluptatum neque? Cursus tristique proin interdum cillum, mollis bibendum similique. Magnam do! Cras sit beatae aperiam repellendus enim, scelerisque sunt aliqua adip', '', 0, 1, 1, 0, 1573704256, 0, '', '', '', '', '', '', 9, '', '', '', '', '', '', 'muctieu', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (207, 0, 0, 0, 0, '400x300-9458.png', '400x3007711_200x150.png', '', '', '', 'Nulla turpis faucibus purus quam ma 12', 'nulla-turpis-faucibus-purus-quam-ma-12', 'Nulla turpis faucibus purus quam magnam vivamus officiis, facilis hymenaeos, mollis parturient suscipit, mi harum dolores, duis ullamco torquent error culpa vitae laudantium donec accusantium aliquip voluptatum neque? Cursus tristique proin interdum cillum, mollis bibendum similique. Magnam do! Cras sit beatae aperiam repellendus enim, scelerisque sunt aliqua adip', '', 0, 1, 1, 0, 1573704259, 0, '', '', '', '', '', '', 9, '', '', '', '', '', '', 'muctieu', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (208, 0, 0, 0, 0, '400x300-1600.png', '400x3009214_200x150.png', '', '', '', 'Nulla turpis faucibus purus quam ma 123', 'nulla-turpis-faucibus-purus-quam-ma-123', 'Nulla turpis faucibus purus quam magnam vivamus officiis, facilis hymenaeos, mollis parturient suscipit, mi harum dolores, duis ullamco torquent error culpa vitae laudantium donec accusantium aliquip voluptatum neque? Cursus tristique proin interdum cillum, mollis bibendum similique. Magnam do! Cras sit beatae aperiam repellendus enim, scelerisque sunt aliqua adip', '', 0, 1, 1, 0, 1573704263, 0, '', '', '', '', '', '', 9, '', '', '', '', '', '', 'muctieu', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (209, 0, 0, 0, 0, '400x300-4135.png', '400x3007067_200x150.png', '', '', '', 'Nulla turpis faucibus purus quam ma 1234', 'nulla-turpis-faucibus-purus-quam-ma-1234', 'Nulla turpis faucibus purus quam magnam vivamus officiis, facilis hymenaeos, mollis parturient suscipit, mi harum dolores, duis ullamco torquent error culpa vitae laudantium donec accusantium aliquip voluptatum neque? Cursus tristique proin interdum cillum, mollis bibendum similique. Magnam do! Cras sit beatae aperiam repellendus enim, scelerisque sunt aliqua adip', '', 0, 1, 1, 0, 1573704269, 0, '', '', '', '', '', '', 9, '', '', '', '', '', '', 'muctieu', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (210, 0, 0, 0, 0, '400x300-7358.png', '400x3000043_200x150.png', '', '', '', 'Itaque aut elementum, vitae cursus, so', 'itaque-aut-elementum-vitae-cursus-so', 'Itaque aut elementum, vitae cursus, soluta incididunt numquam, ullamcorper eu tincidunt imperdiet, provident magnis, eum possimus lobortis metus ipsam laboriosam, dolores maiores gravida dis mattis malesuada, minima semper felis vivamus commodi voluptatibus blandit purus, diam quidem wisi', '', 0, 1, 1, 0, 1573704509, 0, '', '', '', '', '', '', 10, '', '', '', '', '', '', 'muctieu', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (211, 0, 0, 0, 0, '400x300-3749.png', '400x3003758_200x150.png', '', '', '', 'Itaque aut elementum, vitae cursus, so 1', 'itaque-aut-elementum-vitae-cursus-so-1', 'Itaque aut elementum, vitae cursus, soluta incididunt numquam, ullamcorper eu tincidunt imperdiet, provident magnis, eum possimus lobortis metus ipsam laboriosam, dolores maiores gravida dis mattis malesuada, minima semper felis vivamus commodi voluptatibus blandit purus, diam quidem wisi', '', 0, 1, 1, 0, 1573704512, 0, '', '', '', '', '', '', 10, '', '', '', '', '', '', 'muctieu', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (365, 0, 0, 0, 0, '', '', '', '', '', 'Catalogue', 'catalogue', '', '', 0, 1, 1, 0, 1576823393, 1576823924, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'catalogue', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (557, 0, 0, 0, 0, '', '', '', '', '', 'Iste wisi tenetur, q 1', 'iste-wisi-tenetur-q-1', '', '', 0, 1, 1, 0, 1582683900, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'chinhsach', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (558, 0, 0, 0, 0, '', '', '', '', '', 'Iste wisi tenetur, q 12', 'iste-wisi-tenetur-q-12', '', '', 0, 1, 1, 0, 1582683903, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'chinhsach', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (559, 0, 0, 0, 0, '', '', '', '', '', 'Iste wisi tenetur, q 123', 'iste-wisi-tenetur-q-123', '', '', 0, 1, 1, 0, 1582683906, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'chinhsach', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (560, 0, 0, 0, 0, '', '', '', '', '', 'Iste wisi tenetur, q 1234', 'iste-wisi-tenetur-q-1234', '', '', 0, 1, 1, 0, 1582683908, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'chinhsach', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (864, 0, 0, 0, 0, '', '', '', '', '', 'Tên a', 'ten-a', '', '', 0, 1, 1, 0, 1590529633, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'hotline', '', 'aaa@gmail.com', '', '', '0989898789', '', '', '', '', '', '', '', '', '', '0'), (865, 0, 0, 0, 0, '', '', '', '', '', 'Tên ab', 'ten-ab', '', '', 0, 1, 1, 0, 1590529637, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'hotline', '', 'aaa@gmail.com', '', '', '0989898789', '', '', '', '', '', '', '', '', '', '0'), (919, 0, 0, 0, 1, '1-9604.png', '1-9604-9895_780x580.png', '', '', '', 'THE NAM HAI - HỘI AN', 'the-nam-hai-hoi-an', '', '', 0, 1, 1, 0, 1591972445, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'du-an', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (920, 0, 0, 0, 1, '2-2521.png', '2-2521-5784_780x580.png', '', '', '', 'KHÁCH SẠN NEW WORLD - SẢI GÒN', 'khach-san-new-world-sai-gon', '', '', 0, 1, 1, 0, 1591972759, 1591972759, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'du-an', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (921, 0, 0, 0, 1, '3bee346ead4b877cc102d201ed1cb6aa-9604.jpg', '3bee346ead4b877cc102d201ed1cb6aa-9604-4091_780x580.jpg', '', '', '', 'sheraton saigon hotel', 'sheraton-saigon-hotel', '', '', 1, 1, 1, 0, 1591972715, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'du-an', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (922, 0, 0, 0, 1, 'vinpearl-phu-quoc-resort-spa-5557.jpg', 'vinpearl-phu-quoc-resort-spa-5557-5372_780x580.jpg', '', '', '', 'Vinpearl Phú Quốc Resort', 'vinpearl-phu-quoc-resort', '', '', 1, 1, 1, 0, 1591972841, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'du-an', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (923, 0, 0, 0, 1, '653453ahbl001-2076.jpg', '653453ahbl001-2076-8450_780x580.jpg', '', '', '', 'Khách sạn Paris Deli', 'khach-san-paris-deli', '', '', 2, 1, 1, 0, 1591972918, 0, 'Khách sạn Paris Deli', 'Khách sạn Paris Deli', 'Khách sạn Paris Deli', '', '', '', 0, '', '', '', '', '', '', 'du-an', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (924, 0, 0, 0, 0, '', '', '', '', '', 'Tư vấn thiết kế', 'tu-van-thiet-ke', '', '', 1, 1, 1, 0, 1591974234, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'ho-tro', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (925, 0, 0, 0, 0, '', '', '', '', '', 'Thi công lắp đặt', 'thi-cong-lap-dat', '', '', 0, 2, 1, 0, 1591974241, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'ho-tro', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (926, 0, 0, 0, 0, '', '', '', '', '', 'Bảo hành định kỳ', 'bao-hanh-dinh-ky', '', '', 0, 3, 1, 0, 1591974246, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'ho-tro', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (927, 0, 0, 0, 0, '', '', '', '', '', 'Sửa chữa theo yêu cầu', 'sua-chua-theo-yeu-cau', '', '', 0, 4, 1, 0, 1591974251, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'ho-tro', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (928, 0, 0, 0, 0, '', '', '', '', '', 'Quy định bảo hành', 'quy-dinh-bao-hanh', '', '', 0, 5, 1, 0, 1591974256, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'ho-tro', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (929, 0, 0, 0, 0, '', '', '', '', '', 'Chính sách đổi hàng & vận chuyển', 'chinh-sach-doi-hang-van-chuyen', '', '', 0, 1, 1, 0, 1591974276, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'chinh-sach', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (930, 0, 0, 0, 0, '', '', '', '', '', 'Hướng dẫn thanh toán', 'huong-dan-thanh-toan', '', '', 0, 2, 1, 0, 1591974283, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'chinh-sach', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (931, 0, 0, 0, 0, '', '', '', '', '', 'Quy định đổi hàng', 'quy-dinh-doi-hang', '', '', 0, 3, 1, 0, 1591974288, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'chinh-sach', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (932, 0, 0, 0, 0, '', '', '', '', '', 'Chính sách KH thân thiết', 'chinh-sach-kh-than-thiet', '', '', 0, 4, 1, 0, 1591974292, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'chinh-sach', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (933, 0, 0, 0, 0, '', '', '', '', '', 'Chính sách bảo mật thông tin', 'chinh-sach-bao-mat-thong-tin', '', '', 0, 5, 1, 0, 1591974298, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'chinh-sach', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (934, 0, 0, 0, 0, '1-7363.png', '1-7363-9089_400x300.png', '', '', '', 'Một thuyền viên về từ Malaysia nhiễm nCoV', 'mot-thuyen-vien-ve-tu-malaysia-nhiem-ncov', 'Bằng lối đá máu lửa cùng khả năng chớp thời cơ tốt, Sài Gòn giành trọn ba điểm trong trận derby với TP HCM. Chiến thắng quan trọng giúp thầy trò Vũ Tiến Thành chiếm đỉnh bảng V-League, sau bốn trận bất bại từ đầu mùa. \r\n\r\n', '', 0, 1, 1, 0, 1591976390, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'tin-tuc', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (935, 0, 0, 0, 0, '2-1948.png', '2-1948-3133_400x300.png', '', '', '', 'Sài Gòn hạ TP HCM, lên đỉnh bảng', 'sai-gon-ha-tp-hcm-len-dinh-bang', 'Tiền đạo Pedro Paulo ghi bàn duy nhất giúp Sài Gòn thắng TP HCM 1-0 ở vòng 4 V-League chiều 12/6. \r\n\r\n', '', 0, 1, 1, 0, 1591976406, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'tin-tuc', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'), (936, 0, 0, 0, 0, '2-1430.png', '2-1430-4129_400x300.png', '', '', '', 'Epoxy Tự Phăng', 'epoxy-tu-phang', 'ewfawefwaefwef', '', 1, 1, 1, 0, 1592100906, 0, '', '', '', '', '', '', 0, '', '', '', '', '', '', 'dich-vu', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0'); -- -------------------------------------------------------- -- -- Table structure for table `table_newsletter` -- CREATE TABLE `table_newsletter` ( `id` int(10) NOT NULL, `ten` varchar(200) NOT NULL, `noidung` text NOT NULL, `email` varchar(100) NOT NULL, `diachi` varchar(255) NOT NULL, `dienthoai` varchar(20) NOT NULL, `stt` int(10) NOT NULL, `hienthi` int(10) NOT NULL, `ngaytao` varchar(100) NOT NULL, `quantam` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `table_news_cat` -- CREATE TABLE `table_news_cat` ( `id` int(11) NOT NULL, `id_list` int(11) NOT NULL, `ten` varchar(255) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `photo` varchar(255) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(11) NOT NULL, `hienthi` int(11) NOT NULL, `ngaytao` int(11) NOT NULL, `ngaysua` int(11) NOT NULL, `id_danhmuc` int(11) NOT NULL, `noibat` tinyint(4) NOT NULL, `noidung` text NOT NULL, `title` varchar(100) NOT NULL, `keywords` varchar(1000) NOT NULL, `description` varchar(200) NOT NULL, `h3` varchar(200) NOT NULL, `h2` varchar(200) NOT NULL, `h1` varchar(200) NOT NULL, `tenen` varchar(255) NOT NULL, `noidungen` text NOT NULL, `type` varchar(255) NOT NULL, `mota` text NOT NULL, `motaen` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `table_news_danhmuc` -- CREATE TABLE `table_news_danhmuc` ( `id` int(11) NOT NULL, `keywords` varchar(1000) NOT NULL, `description` varchar(200) NOT NULL, `h3` varchar(200) NOT NULL, `h2` varchar(200) NOT NULL, `h1` varchar(200) NOT NULL, `ten` varchar(255) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `photo` varchar(255) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(11) NOT NULL, `hienthi` int(11) NOT NULL, `ngaytao` int(11) NOT NULL, `ngaysua` int(11) NOT NULL, `title` varchar(100) NOT NULL, `noibat` tinyint(4) NOT NULL, `noidung` text NOT NULL, `tenen` varchar(255) NOT NULL, `noidungen` text NOT NULL, `type` varchar(255) NOT NULL, `mota` text NOT NULL, `motaen` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_news_danhmuc` -- INSERT INTO `table_news_danhmuc` (`id`, `keywords`, `description`, `h3`, `h2`, `h1`, `ten`, `tenkhongdau`, `photo`, `thumb`, `stt`, `hienthi`, `ngaytao`, `ngaysua`, `title`, `noibat`, `noidung`, `tenen`, `noidungen`, `type`, `mota`, `motaen`) VALUES (9, '', '', '', '', '', 'Công ty', 'cong-ty', '', '', 1, 1, 1573704209, 0, '', 0, '', '', '', 'muctieu', '', ''), (10, '', '', '', '', '', 'Doanh nghiệp', 'doanh-nghiep', '', '', 1, 1, 1573704219, 0, '', 0, '', '', '', 'muctieu', '', ''), (11, '', '', '', '', '', 'Nhà hàng', 'nha-hang', '', '', 1, 1, 1573704225, 0, '', 0, '', '', '', 'muctieu', '', ''), (12, '', '', '', '', '', 'Đại lý miền bắc', 'dai-ly-mien-bac', '', '', 1, 1, 1575255111, 0, '', 0, '', '', '', 'daily', '', ''), (13, '', '', '', '', '', 'Đại lý miền nam', 'dai-ly-mien-nam', '', '', 1, 1, 1575255119, 0, '', 0, '', '', '', 'daily', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_news_item` -- CREATE TABLE `table_news_item` ( `id` int(10) UNSIGNED NOT NULL, `id_list` int(11) NOT NULL, `id_cat` int(10) NOT NULL, `ten` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tenkhongdau` varchar(255) COLLATE latin1_general_ci NOT NULL, `photo` varchar(20) COLLATE latin1_general_ci NOT NULL, `thumb` varchar(255) COLLATE latin1_general_ci NOT NULL, `stt` int(2) NOT NULL, `hienthi` int(2) NOT NULL, `ngaysua` int(10) NOT NULL, `ngaytao` int(10) NOT NULL, `id_danhmuc` int(11) NOT NULL, `tenen` varchar(255) CHARACTER SET utf8 NOT NULL, `noidung` text CHARACTER SET utf8 NOT NULL, `noidungen` text CHARACTER SET utf8 NOT NULL, `type` varchar(255) COLLATE latin1_general_ci NOT NULL, `mota` text COLLATE latin1_general_ci NOT NULL, `motaen` text COLLATE latin1_general_ci NOT NULL, `noibat` int(11) NOT NULL, `keywords` text COLLATE latin1_general_ci NOT NULL, `title` text COLLATE latin1_general_ci NOT NULL, `description` text COLLATE latin1_general_ci NOT NULL, `h3` varchar(200) COLLATE latin1_general_ci NOT NULL, `h2` varchar(200) COLLATE latin1_general_ci NOT NULL, `h1` varchar(200) COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `table_news_list` -- CREATE TABLE `table_news_list` ( `id` int(11) NOT NULL, `ten` varchar(255) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `photo` varchar(255) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(11) NOT NULL, `hienthi` int(11) NOT NULL, `ngaytao` int(11) NOT NULL, `ngaysua` int(11) NOT NULL, `id_danhmuc` int(11) NOT NULL, `title` varchar(100) NOT NULL, `description` varchar(200) NOT NULL, `h3` varchar(200) NOT NULL, `h2` varchar(200) NOT NULL, `h1` varchar(200) NOT NULL, `keywords` varchar(1000) NOT NULL, `noibat` tinyint(4) NOT NULL, `noidung` text NOT NULL, `tenen` varchar(255) NOT NULL, `noidungen` text NOT NULL, `type` varchar(255) NOT NULL, `mota` text NOT NULL, `motaen` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `table_online` -- CREATE TABLE `table_online` ( `id` int(10) UNSIGNED NOT NULL, `session_id` varchar(255) NOT NULL, `time` int(10) UNSIGNED NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_online` -- INSERT INTO `table_online` (`id`, `session_id`, `time`) VALUES (2351, '42qmpo6t25ls030gss331srlok', 1591791324); -- -------------------------------------------------------- -- -- Table structure for table `table_phanquyen` -- CREATE TABLE `table_phanquyen` ( `id` int(10) UNSIGNED NOT NULL, `noibat` tinyint(4) NOT NULL, `ten` varchar(225) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `photo` varchar(100) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `ngaytao` int(10) UNSIGNED NOT NULL DEFAULT 0, `ngaysua` int(10) UNSIGNED NOT NULL DEFAULT 0, `link` varchar(255) NOT NULL, `tenen` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_phanquyen` -- INSERT INTO `table_phanquyen` (`id`, `noibat`, `ten`, `tenkhongdau`, `photo`, `thumb`, `stt`, `hienthi`, `ngaytao`, `ngaysua`, `link`, `tenen`) VALUES (2, 0, 'Quyền nhân viên', 'quyen-nhan-vien', '', '', 2, 1, 1432955333, 1473910556, '', ''), (5, 0, 'Quyền thành viên', 'quyen-thanh-vien', '', '', 3, 1, 1432955365, 1473910538, '', ''), (4, 0, 'Quyền cấp cao', 'quyen-cap-cao', '', '', 1, 1, 1432955410, 1473910530, '', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_place_city` -- CREATE TABLE `table_place_city` ( `id` int(11) NOT NULL, `ten` varchar(255) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `stt` int(11) NOT NULL, `hienthi` int(11) NOT NULL, `ngaytao` int(11) NOT NULL, `ngaysua` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_place_city` -- INSERT INTO `table_place_city` (`id`, `ten`, `tenkhongdau`, `stt`, `hienthi`, `ngaytao`, `ngaysua`) VALUES (1, 'Hồ Chí Minh', 'ho-chi-minh', 1, 1, 1446429727, 1587721195), (2, 'Hà Nội', 'ha-noi', 1, 1, 1446429727, 0), (3, 'Bình Dương', 'binh-duong', 1, 1, 1446429727, 0), (4, 'Đà Nẵng', 'da-nang', 1, 1, 1446429727, 0), (5, 'Hải Phòng', 'hai-phong', 1, 1, 1446429727, 1587721513), (6, 'Long An', 'long-an', 1, 1, 1446429727, 0), (7, 'Bà Rịa Vũng Tàu', 'ba-ria-vung-tau', 1, 1, 1446429727, 0), (8, 'An Giang', 'an-giang', 1, 1, 1446429727, 0), (9, 'Bắc Giang', 'bac-giang', 1, 1, 1446429727, 0), (10, 'Bắc Kạn', 'bac-kan', 1, 1, 1446429727, 0), (11, 'Bạc Liêu', 'bac-lieu', 1, 1, 1446429727, 1459671825), (12, 'Bắc Ninh', 'bac-ninh', 1, 1, 1446429727, 0), (13, 'Bến Tre', 'ben-tre', 1, 1, 1446429727, 0), (14, 'Bình Định', 'binh-dinh', 1, 1, 1446429727, 0), (15, 'Bình Phước', 'binh-phuoc', 1, 1, 1446429727, 0), (16, 'Bình Thuận ', 'binh-thuan', 1, 1, 1446429727, 1558757794), (17, 'Cà Mau', 'ca-mau', 1, 1, 1446429727, 0), (18, 'Cần Thơ', 'can-tho', 1, 1, 1446429727, 0), (19, 'Cao Bằng', 'cao-bang', 1, 1, 1446429727, 0), (20, 'Đắk Lắk', 'dak-lak', 1, 1, 1446429727, 0), (21, 'Đắk Nông', 'dak-nong', 1, 1, 1446429727, 0), (22, 'Điện Biên', 'dien-bien', 1, 1, 1446429727, 0), (23, 'Đồng Nai', 'dong-nai', 1, 1, 1446429727, 1587721244), (24, 'Đồng Tháp', 'dong-thap', 1, 1, 1446429727, 1587721518), (25, 'Gia Lai', 'gia-lai', 1, 1, 1446429727, 0), (26, 'Hà Giang', 'ha-giang', 1, 1, 1446429727, 1587721532), (27, 'Hà Nam', 'ha-nam', 1, 1, 1446429727, 0), (28, 'Hà Tĩnh', 'ha-tinh', 1, 1, 1446429727, 0), (29, 'Hải Dương', 'hai-duong', 1, 1, 1446429727, 0), (30, 'Hậu Giang', 'hau-giang', 1, 1, 1446429727, 0), (31, 'Hòa Bình', 'hoa-binh', 1, 1, 1446429727, 0), (32, 'Hưng Yên', 'hung-yen', 1, 1, 1446429727, 0), (33, 'Khánh Hòa', 'khanh-hoa', 1, 1, 1446429727, 0), (34, 'Kiên Giang', 'kien-giang', 1, 1, 1446429727, 0), (35, 'Kon Tum', 'kon-tum', 1, 1, 1446429727, 0), (36, 'Lai Châu', 'lai-chau', 1, 1, 1446429727, 0), (37, 'Lâm Đồng', 'lam-dong', 1, 1, 1446429727, 0), (38, 'Lạng Sơn', 'lang-son', 1, 1, 1446429727, 1587721441), (39, 'Lào Cai', 'lao-cai', 1, 1, 1446429727, 0), (40, 'Nam Định', 'nam-dinh', 1, 1, 1446429727, 0), (41, 'Nghệ An', 'nghe-an', 1, 1, 1446429727, 0), (42, 'Ninh Bình', 'ninh-binh', 1, 1, 1446429727, 0), (43, 'Ninh Thuận', 'ninh-thuan', 1, 1, 1446429727, 0), (44, 'Phú Thọ', 'phu-tho', 1, 1, 1446429727, 0), (45, 'Phú Yên', 'phu-yen', 1, 1, 1446429727, 0), (46, 'Quảng Bình', 'quang-binh', 1, 1, 1446429727, 0), (47, 'Quảng Nam', 'quang-nam', 1, 1, 1446429727, 0), (48, 'Quảng Ngãi', 'quang-ngai', 1, 1, 1446429727, 0), (49, 'Quảng Ninh', 'quang-ninh', 1, 1, 1446429727, 0), (50, 'Quảng Trị', 'quang-tri', 1, 1, 1446429727, 0), (51, 'Sóc Trăng', 'soc-trang', 1, 1, 1446429727, 0), (52, 'Sơn La', 'son-la', 1, 1, 1446429727, 0), (53, 'Tây Ninh', 'tay-ninh', 1, 1, 1446429727, 0), (54, 'Thái Bình', 'thai-binh', 1, 1, 1446429727, 0), (55, 'Thái Nguyên', 'thai-nguyen', 1, 1, 1446429727, 0), (56, 'Thanh Hóa', 'thanh-hoa', 1, 1, 1446429727, 0), (57, 'Thừa Thiên Huế', 'thua-thien-hue', 1, 1, 1446429727, 0), (58, 'Tiền Giang', 'tien-giang', 1, 1, 1446429727, 0), (59, 'Trà Vinh', 'tra-vinh', 1, 1, 1446429727, 0), (60, 'Tuyên Quang', 'tuyen-quang', 1, 1, 1446429727, 0), (61, 'Vĩnh Long', 'vinh-long', 1, 1, 1446429727, 0), (62, 'Vĩnh Phúc', 'vinh-phuc', 1, 1, 1446429727, 1587721536), (63, 'Yên Bái', 'yen-bai', 1, 1, 1446429727, 0); -- -------------------------------------------------------- -- -- Table structure for table `table_place_dist` -- CREATE TABLE `table_place_dist` ( `id` int(11) NOT NULL, `id_city` int(11) NOT NULL, `ten` varchar(255) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `stt` int(11) NOT NULL, `hienthi` int(11) NOT NULL, `ngaytao` int(11) NOT NULL, `ngaysua` int(11) NOT NULL, `gia` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_place_dist` -- INSERT INTO `table_place_dist` (`id`, `id_city`, `ten`, `tenkhongdau`, `stt`, `hienthi`, `ngaytao`, `ngaysua`, `gia`) VALUES (1, 1, 'Bình Chánh', 'binh-chanh', 1, 1, 1446429779, 1553570486, 30000), (2, 1, 'Bình Tân', 'binh-tan', 1, 1, 1446429779, 0, 0), (3, 1, 'Bình Thạnh', 'binh-thanh', 1, 1, 1446429779, 1558920093, 0), (4, 1, 'Cần Giờ', 'can-gio', 1, 1, 1446429779, 0, 0), (5, 1, 'Củ Chi', 'cu-chi', 1, 1, 1446429779, 0, 0), (6, 1, 'Gò Vấp', 'go-vap', 1, 1, 1446429779, 0, 0), (7, 1, 'Hóc Môn', 'hoc-mon', 1, 1, 1446429779, 0, 0), (8, 1, 'Nhà Bè', 'nha-be', 1, 1, 1446429779, 0, 0), (9, 1, 'Phú Nhuận', 'phu-nhuan', 1, 1, 1446429779, 0, 0), (10, 1, 'Quận 1', 'quan-1', 1, 1, 1446429779, 0, 0), (11, 1, 'Quận 10', 'quan-10', 1, 1, 1446429779, 0, 0), (12, 1, 'Quận 11', 'quan-11', 1, 1, 1446429779, 0, 0), (13, 1, 'Quận 12', 'quan-12', 1, 1, 1446429779, 0, 0), (14, 1, 'Quận 2', 'quan-2', 1, 1, 1446429779, 0, 0), (15, 1, 'Quận 3', 'quan-3', 1, 1, 1446429779, 0, 0), (16, 1, 'Quận 4', 'quan-4', 1, 1, 1446429779, 0, 0), (17, 1, 'Quận 5', 'quan-5', 1, 1, 1446429779, 0, 0), (18, 1, 'Quận 6', 'quan-6', 1, 1, 1446429779, 0, 0), (19, 1, 'Quận 7', 'quan-7', 1, 1, 1446429779, 0, 0), (20, 1, 'Quận 8', 'quan-8', 1, 1, 1446429779, 0, 0), (21, 1, 'Quận 9', 'quan-9', 1, 1, 1446429779, 0, 0), (22, 1, 'Thủ Đức', 'thu-duc', 1, 1, 1446429779, 0, 0), (23, 1, 'Tân Bình', 'tan-binh', 1, 1, 1446429779, 0, 0), (24, 1, 'Tân Phú', 'tan-phu', 1, 1, 1446429779, 0, 0), (25, 2, 'Ba Đình', 'ba-dinh', 1, 1, 1446429779, 0, 0), (26, 2, 'Ba Vì', 'ba-vi', 1, 1, 1446429779, 0, 0), (27, 2, 'Bắc Từ Liêm', 'bac-tu-liem', 1, 1, 1446429779, 0, 0), (28, 2, 'Cầu Giấy', 'cau-giay', 1, 1, 1446429779, 0, 0), (29, 2, 'Chương Mỹ', 'chuong-my', 1, 1, 1446429779, 0, 0), (30, 2, 'Đan Phượng', 'dan-phuong', 1, 1, 1446429779, 0, 0), (31, 2, 'Đông Anh', 'dong-anh', 1, 1, 1446429779, 0, 0), (32, 2, 'Đống Đa', 'dong-da', 1, 1, 1446429779, 0, 0), (33, 2, 'Gia Lâm', 'gia-lam', 1, 1, 1446429779, 0, 0), (34, 2, 'Hà Đông', 'ha-dong', 1, 1, 1446429779, 1558921827, 0), (35, 2, 'Hai Bà Trưng', 'hai-ba-trung', 1, 1, 1446429779, 0, 0), (36, 2, 'Hoài Đức', 'hoai-duc', 1, 1, 1446429779, 0, 0), (37, 2, 'Hoàn Kiếm', 'hoan-kiem', 1, 1, 1446429779, 0, 0), (38, 2, 'Hoàng Mai', 'hoang-mai', 1, 1, 1446429779, 0, 0), (39, 2, 'Long Biên', 'long-bien', 1, 1, 1446429779, 0, 0), (40, 2, 'Mê Linh', 'me-linh', 1, 1, 1446429779, 0, 0), (41, 2, 'Mỹ Đức', 'my-duc', 1, 1, 1446429779, 0, 0), (42, 2, 'Nam Từ Liêm', 'nam-tu-liem', 1, 1, 1446429779, 0, 0), (43, 2, 'Phú Xuyên', 'phu-xuyen', 1, 1, 1446429779, 0, 0), (44, 2, 'Phúc Thọ', 'phuc-tho', 1, 1, 1446429779, 0, 0), (45, 2, 'Quốc Oai', 'quoc-oai', 1, 1, 1446429779, 0, 0), (46, 2, 'Sóc Sơn', 'soc-son', 1, 1, 1446429779, 0, 0), (47, 2, 'Sơn Tây', 'son-tay', 1, 1, 1446429779, 0, 0), (48, 2, 'Tây Hồ', 'tay-ho', 1, 1, 1446429779, 0, 0), (49, 2, 'Thạch Thất', 'thach-that', 1, 1, 1446429779, 0, 0), (50, 2, 'Thanh Oai', 'thanh-oai', 1, 1, 1446429779, 0, 0), (51, 2, 'Thanh Trì', 'thanh-tri', 1, 1, 1446429779, 0, 0), (52, 2, 'Thanh Xuân', 'thanh-xuan', 1, 1, 1446429779, 0, 0), (53, 2, 'Thường Tín', 'thuong-tin', 1, 1, 1446429779, 0, 0), (54, 2, 'Ứng Hòa', 'ung-hoa', 1, 1, 1446429779, 1558920099, 0), (55, 3, 'Bàu Bàng', 'bau-bang', 1, 1, 1446429779, 0, 0), (56, 3, 'Bến Cát', 'ben-cat', 1, 1, 1446429779, 0, 0), (57, 3, 'Dầu Tiếng', 'dau-tieng', 1, 1, 1446429779, 0, 0), (58, 3, 'Tân Uyên', 'tan-uyen', 1, 1, 1446429779, 0, 0), (59, 3, 'Dĩ An', 'di-an', 1, 1, 1446429779, 0, 0), (60, 3, 'Phú Giáo', 'phu-giao', 1, 1, 1446429779, 0, 0), (61, 3, 'Thủ Dầu Một', 'thu-dau-mot', 1, 1, 1446429779, 0, 0), (62, 3, 'Thuận An', 'thuan-an', 1, 1, 1446429779, 0, 0), (63, 4, 'Cẩm Lệ', 'cam-le', 1, 1, 1446429779, 0, 0), (64, 4, 'Hải Châu', 'hai-chau', 1, 1, 1446429779, 0, 0), (65, 4, 'Hòa Vang', 'hoa-vang', 1, 1, 1446429779, 0, 0), (66, 4, 'Hoàng Sa', 'hoang-sa', 1, 1, 1446429779, 0, 0), (67, 4, 'Liên Chiểu', 'lien-chieu', 1, 1, 1446429779, 0, 0), (68, 4, 'Ngũ Hành Sơn', 'ngu-hanh-son', 1, 1, 1446429779, 0, 0), (69, 4, 'Sơn Trà', 'son-tra', 1, 1, 1446429779, 0, 0), (70, 4, 'Thanh Khê', 'thanh-khe', 1, 1, 1446429779, 0, 0), (71, 5, 'An Dương', 'an-duong', 1, 1, 1446429779, 0, 0), (72, 5, 'An Lão', 'an-lao', 1, 1, 1446429779, 0, 0), (73, 5, 'Bạch Long Vĩ', 'bach-long-vi', 1, 1, 1446429779, 0, 0), (74, 5, 'Cát Hải', 'cat-hai', 1, 1, 1446429779, 0, 0), (75, 5, 'Đồ Sơn', 'do-son', 1, 1, 1446429779, 0, 0), (76, 5, 'Dương Kinh', 'duong-kinh', 1, 1, 1446429779, 0, 0), (77, 5, 'Hải An', 'hai-an', 1, 1, 1446429779, 0, 0), (78, 5, 'Hồng Bàng', 'hong-bang', 1, 1, 1446429779, 0, 0), (79, 5, 'Kiến An', 'kien-an', 1, 1, 1446429779, 0, 0), (80, 5, 'Kiến Thụy', 'kien-thuy', 1, 1, 1446429779, 0, 0), (81, 5, 'Lê Chân', 'le-chan', 1, 1, 1446429779, 0, 0), (82, 5, 'Ngô Quyền', 'ngo-quyen', 1, 1, 1446429779, 0, 0), (83, 5, 'Thủy Nguyên', 'thuy-nguyen', 1, 1, 1446429779, 0, 0), (84, 5, 'Tiên Lãng', 'tien-lang', 1, 1, 1446429779, 0, 0), (85, 5, 'Vĩnh Bảo', 'vinh-bao', 1, 1, 1446429779, 0, 0), (86, 6, 'Bến Lức', 'ben-luc', 1, 1, 1446429779, 0, 0), (87, 6, 'Cần Đước', 'can-duoc', 1, 1, 1446429779, 0, 0), (88, 6, 'Cần Giuộc', 'can-giuoc', 1, 1, 1446429779, 0, 0), (89, 6, 'Châu Thành', 'chau-thanh', 1, 1, 1446429779, 0, 0), (90, 6, 'Đức Hòa', 'duc-hoa', 1, 1, 1446429779, 0, 0), (91, 6, 'Đức Huệ', 'duc-hue', 1, 1, 1446429779, 0, 0), (92, 6, 'Kiến Tường', 'kien-tuong', 1, 1, 1446429779, 0, 0), (93, 6, 'Mộc Hóa', 'moc-hoa', 1, 1, 1446429779, 0, 0), (94, 6, 'Tân An', 'tan-an', 1, 1, 1446429779, 0, 0), (95, 6, 'Tân Hưng', 'tan-hung', 1, 1, 1446429779, 0, 0), (96, 6, 'Tân Thạnh', 'tan-thanh', 1, 1, 1446429779, 0, 0), (97, 6, 'Tân Trụ', 'tan-tru', 1, 1, 1446429779, 0, 0), (98, 6, 'Thạnh Hóa', 'thanh-hoa', 1, 1, 1446429779, 0, 0), (99, 6, 'Thủ Thừa', 'thu-thua', 1, 1, 1446429779, 0, 0), (100, 6, 'Vĩnh Hưng', 'vinh-hung', 1, 1, 1446429779, 0, 0), (101, 7, 'Bà Rịa', 'ba-ria', 1, 1, 1446429779, 0, 0), (102, 7, 'Châu Đức', 'chau-duc', 1, 1, 1446429779, 0, 0), (103, 7, 'Côn Đảo', 'con-dao', 1, 1, 1446429779, 0, 0), (104, 7, 'Đất Đỏ', 'dat-do', 1, 1, 1446429779, 0, 0), (105, 7, 'Long Điền', 'long-dien', 1, 1, 1446429779, 0, 0), (106, 7, 'Tân Thành', 'tan-thanh', 1, 1, 1446429779, 0, 0), (107, 7, 'Vũng Tàu', 'vung-tau', 1, 1, 1446429779, 0, 0), (108, 7, 'Xuyên Mộc', 'xuyen-moc', 1, 1, 1446429779, 0, 0), (109, 8, 'An Phú', 'an-phu', 1, 1, 1446429779, 0, 0), (110, 8, 'Châu Đốc', 'chau-doc', 1, 1, 1446429779, 0, 0), (111, 8, 'Châu Phú', 'chau-phu', 1, 1, 1446429779, 0, 0), (112, 8, 'Châu Thành', 'chau-thanh', 1, 1, 1446429779, 0, 0), (113, 8, 'Chợ Mới', 'cho-moi', 1, 1, 1446429779, 0, 0), (114, 8, 'Long Xuyên', 'long-xuyen', 1, 1, 1446429779, 0, 0), (115, 8, 'Phú Tân', 'phu-tan', 1, 1, 1446429779, 0, 0), (116, 8, 'Tân Châu', 'tan-chau', 1, 1, 1446429779, 0, 0), (117, 8, 'Thoại Sơn', 'thoai-son', 1, 1, 1446429779, 0, 0), (118, 8, 'Tịnh Biên', 'tinh-bien', 1, 1, 1446429779, 0, 0), (119, 8, 'Tri Tôn', 'tri-ton', 1, 1, 1446429779, 0, 0), (120, 9, 'Bắc Giang', 'bac-giang', 1, 1, 1446429779, 0, 0), (121, 9, 'Hiệp Hòa', 'hiep-hoa', 1, 1, 1446429779, 0, 0), (122, 9, 'Lạng Giang', 'lang-giang', 1, 1, 1446429779, 0, 0), (123, 9, 'Lục Nam', 'luc-nam', 1, 1, 1446429779, 0, 0), (124, 9, 'Lục Ngạn', 'luc-ngan', 1, 1, 1446429779, 0, 0), (125, 9, 'Sơn Động', 'son-dong', 1, 1, 1446429779, 0, 0), (126, 9, 'Tân Yên', 'tan-yen', 1, 1, 1446429779, 0, 0), (127, 9, 'Việt Yên', 'viet-yen', 1, 1, 1446429779, 0, 0), (128, 9, 'Yên Dũng', 'yen-dung', 1, 1, 1446429779, 0, 0), (129, 9, 'Yên Thế', 'yen-the', 1, 1, 1446429779, 0, 0), (130, 10, 'Ba Bể', 'ba-be', 1, 1, 1446429779, 0, 0), (131, 10, 'Bắc Kạn', 'bac-kan', 1, 1, 1446429779, 0, 0), (132, 10, 'Bạch Thông', 'bach-thong', 1, 1, 1446429779, 0, 0), (133, 10, 'Chợ Đồn', 'cho-don', 1, 1, 1446429779, 0, 0), (134, 10, 'Chợ Mới', 'cho-moi', 1, 1, 1446429779, 0, 0), (135, 10, 'Na Rì', 'na-ri', 1, 1, 1446429779, 0, 0), (136, 10, 'Ngân Sơn', 'ngan-son', 1, 1, 1446429779, 0, 0), (137, 10, 'Pác Nặm', 'pac-nam', 1, 1, 1446429779, 0, 0), (138, 11, 'Bạc Liêu', 'bac-lieu', 1, 1, 1446429779, 0, 0), (139, 11, 'Đông Hải', 'dong-hai', 1, 1, 1446429779, 0, 0), (140, 11, 'Giá Rai', 'gia-rai', 1, 1, 1446429779, 0, 0), (141, 11, 'Hòa Bình', 'hoa-binh', 1, 1, 1446429779, 0, 0), (142, 11, 'Hồng Dân', 'hong-dan', 1, 1, 1446429779, 0, 0), (143, 11, 'Phước Long', 'phuoc-long', 1, 1, 1446429779, 0, 0), (144, 11, 'Vĩnh Lợi', 'vinh-loi', 1, 1, 1446429779, 0, 0), (145, 12, 'Bắc Ninh', 'bac-ninh', 1, 1, 1446429779, 0, 0), (146, 12, 'Gia Bình', 'gia-binh', 1, 1, 1446429779, 0, 0), (147, 12, 'Quế Võ', 'que-vo', 1, 1, 1446429779, 0, 0), (148, 12, 'Thuận Thành', 'thuan-thanh', 1, 1, 1446429779, 0, 0), (149, 12, 'Lương Tài', 'luong-tai', 1, 1, 1446429779, 0, 0), (150, 12, 'Tiên Du', 'tien-du', 1, 1, 1446429779, 0, 0), (151, 12, 'Từ Sơn', 'tu-son', 1, 1, 1446429779, 0, 0), (152, 12, 'Yên Phong', 'yen-phong', 1, 1, 1446429779, 0, 0), (153, 13, 'Ba Tri', 'ba-tri', 1, 1, 1446429779, 0, 0), (154, 13, 'Bến Tre', 'ben-tre', 1, 1, 1446429779, 0, 0), (155, 13, 'Bình Đại', 'binh-dai', 1, 1, 1446429779, 0, 0), (156, 13, 'Châu Thành', 'chau-thanh', 1, 1, 1446429779, 0, 0), (157, 13, 'Chợ Lách', 'cho-lach', 1, 1, 1446429779, 0, 0), (158, 13, 'Giồng Trôm', 'giong-trom', 1, 1, 1446429779, 0, 0), (159, 13, 'Mỏ Cày Bắc', 'mo-cay-bac', 1, 1, 1446429779, 0, 0), (160, 13, 'Mỏ Cày Nam', 'mo-cay-nam', 1, 1, 1446429779, 0, 0), (161, 13, 'Thạnh Phú', 'thanh-phu', 1, 1, 1446429779, 0, 0), (162, 14, 'An Lão', 'an-lao', 1, 1, 1446429779, 0, 0), (163, 14, 'An Nhơn', 'an-nhon', 1, 1, 1446429779, 0, 0), (164, 14, 'Hoài Ân', 'hoai-an', 1, 1, 1446429779, 0, 0), (165, 14, 'Phù Mỹ', 'phu-my', 1, 1, 1446429779, 0, 0), (166, 14, 'Phù Cát', 'phu-cat', 1, 1, 1446429779, 0, 0), (167, 14, 'Hoài Nhơn', 'hoai-nhon', 1, 1, 1446429779, 0, 0), (168, 14, 'Quy Nhơn', 'quy-nhon', 1, 1, 1446429779, 0, 0), (169, 14, 'Tây Sơn', 'tay-son', 1, 1, 1446429779, 0, 0), (170, 14, 'Tuy Phước', 'tuy-phuoc', 1, 1, 1446429779, 0, 0), (171, 14, 'Vân Canh', 'van-canh', 1, 1, 1446429779, 0, 0), (172, 14, 'Vĩnh Thạnh', 'vinh-thanh', 1, 1, 1446429779, 0, 0), (173, 15, 'Bình Long', 'binh-long', 1, 1, 1446429779, 0, 0), (174, 15, 'Bù Đăng', 'bu-dang', 1, 1, 1446429779, 0, 0), (175, 15, 'Bù Đốp', 'bu-dop', 1, 1, 1446429779, 0, 0), (176, 15, 'Bù Gia Mập', 'bu-gia-map', 1, 1, 1446429779, 0, 0), (177, 15, 'Chơn Thành', 'chon-thanh', 1, 1, 1446429779, 0, 0), (178, 15, 'Đồng Phú', 'dong-phu', 1, 1, 1446429779, 0, 0), (179, 15, 'Đồng Xoài', 'dong-xoai', 1, 1, 1446429779, 0, 0), (180, 15, 'Hớn Quản', 'hon-quan', 1, 1, 1446429779, 0, 0), (181, 15, 'Lộc Ninh', 'loc-ninh', 1, 1, 1446429779, 0, 0), (182, 15, 'Phú Riềng', 'phu-rieng', 1, 1, 1446429779, 0, 0), (183, 15, 'Phước Long', 'phuoc-long', 1, 1, 1446429779, 0, 0), (184, 16, 'Bắc Bình', 'bac-binh', 1, 1, 1446429779, 0, 0), (185, 16, 'Đảo Phú Quý', 'dao-phu-quy', 1, 1, 1446429779, 0, 0), (186, 16, 'Đức Linh', 'duc-linh', 1, 1, 1446429779, 0, 0), (187, 16, 'Hàm Thuận Bắc', 'ham-thuan-bac', 1, 1, 1446429779, 0, 0), (188, 16, 'Hàm Thuận Nam', 'ham-thuan-nam', 1, 1, 1446429779, 0, 0), (189, 16, 'Hàm Tân', 'ham-tan', 1, 1, 1446429779, 0, 0), (190, 16, 'La Gi', 'la-gi', 1, 1, 1446429779, 0, 0), (191, 16, 'Phan Thiết', 'phan-thiet', 1, 1, 1446429779, 0, 0), (192, 16, 'Tánh Linh', 'tanh-linh', 1, 1, 1446429779, 0, 0), (193, 16, 'Tuy Phong', 'tuy-phong', 1, 1, 1446429779, 0, 0), (194, 17, 'Cà Mau', 'ca-mau', 1, 1, 1446429779, 0, 0), (195, 17, 'Cái Nước', 'cai-nuoc', 1, 1, 1446429779, 0, 0), (196, 17, 'Đầm Dơi', 'dam-doi', 1, 1, 1446429779, 0, 0), (197, 17, 'Năm Căn', 'nam-can', 1, 1, 1446429779, 0, 0), (198, 17, 'Ngọc Hiển', 'ngoc-hien', 1, 1, 1446429779, 0, 0), (199, 17, 'Phú Tân', 'phu-tan', 1, 1, 1446429779, 0, 0), (200, 17, 'Thới Bình', 'thoi-binh', 1, 1, 1446429779, 0, 0), (201, 17, 'Trần Văn Thời', 'tran-van-thoi', 1, 1, 1446429779, 0, 0), (202, 17, 'U Minh', 'u-minh', 1, 1, 1446429779, 0, 0), (203, 18, ' Thới Lai', 'thoi-lai', 1, 1, 1446429779, 0, 0), (204, 18, 'Bình Thủy', 'binh-thuy', 1, 1, 1446429779, 0, 0), (205, 18, 'Cái Răng', 'cai-rang', 1, 1, 1446429779, 0, 0), (206, 18, 'Ô Môn', 'o-mon', 1, 1, 1446429779, 0, 0), (207, 18, 'Cờ Đỏ', 'co-do', 1, 1, 1446429779, 0, 0), (208, 18, 'Phong Điền', 'phong-dien', 1, 1, 1446429779, 0, 0), (209, 18, 'Ninh Kiều', 'ninh-kieu', 1, 1, 1446429779, 0, 0), (210, 18, 'Thốt Nốt', 'thot-not', 1, 1, 1446429779, 0, 0), (211, 18, 'Vĩnh Thạnh', 'vinh-thanh', 1, 1, 1446429779, 0, 0), (212, 19, 'Bảo Lạc', 'bao-lac', 1, 1, 1446429779, 0, 0), (213, 19, 'Bảo Lâm', 'bao-lam', 1, 1, 1446429779, 0, 0), (214, 19, 'Cao Bằng', 'cao-bang', 1, 1, 1446429779, 0, 0), (215, 19, 'Hạ Lang', 'ha-lang', 1, 1, 1446429779, 0, 0), (216, 19, 'Hà Quảng', 'ha-quang', 1, 1, 1446429779, 0, 0), (217, 19, 'Hòa An', 'hoa-an', 1, 1, 1446429779, 0, 0), (218, 19, 'Nguyên Bình', 'nguyen-binh', 1, 1, 1446429779, 0, 0), (219, 19, 'Phục Hòa', 'phuc-hoa', 1, 1, 1446429779, 0, 0), (220, 19, 'Quảng Uyên', 'quang-uyen', 1, 1, 1446429779, 0, 0), (221, 19, 'Thạch An', 'thach-an', 1, 1, 1446429779, 0, 0), (222, 19, 'Thông Nông', 'thong-nong', 1, 1, 1446429779, 0, 0), (223, 19, 'Trà Lĩnh', 'tra-linh', 1, 1, 1446429779, 0, 0), (224, 19, 'Trùng Khánh', 'trung-khanh', 1, 1, 1446429779, 0, 0), (225, 20, 'Buôn Đôn', 'buon-don', 1, 1, 1446429779, 0, 0), (226, 20, 'Buôn Hồ', 'buon-ho', 1, 1, 1446429779, 0, 0), (227, 20, 'Buôn Ma Thuột', 'buon-ma-thuot', 1, 1, 1446429779, 0, 0), (228, 20, 'Cư Kuin', 'cu-kuin', 1, 1, 1446429779, 0, 0), (229, 20, 'Ea Kar', 'ea-kar', 1, 1, 1446429779, 0, 0), (230, 20, 'Ea Súp', 'ea-sup', 1, 1, 1446429779, 0, 0), (231, 20, 'Krông Ana', 'krong-ana', 1, 1, 1446429779, 0, 0), (232, 20, 'Krông Bông', 'krong-bong', 1, 1, 1446429779, 0, 0), (233, 20, 'Krông Buk', 'krong-buk', 1, 1, 1446429779, 0, 0), (234, 20, 'Krông Năng', 'krong-nang', 1, 1, 1446429779, 0, 0), (235, 20, 'Krông Pắc', 'krong-pac', 1, 1, 1446429779, 0, 0), (236, 20, 'Lăk', 'lak', 1, 1, 1446429779, 0, 0), (237, 21, 'Cư Jút', 'cu-jut', 1, 1, 1446429779, 0, 0), (238, 21, 'Dăk GLong', 'dak-glong', 1, 1, 1446429779, 0, 0), (239, 21, 'Dăk Mil', 'dak-mil', 1, 1, 1446429779, 0, 0), (240, 21, 'Dăk Song', 'dak-song', 1, 1, 1446429779, 0, 0), (241, 21, 'Gia Nghĩa', 'gia-nghia', 1, 1, 1446429779, 0, 0), (242, 21, 'Krông Nô', 'krong-no', 1, 1, 1446429779, 0, 0), (243, 21, 'Tuy Đức', 'tuy-duc', 1, 1, 1446429779, 0, 0), (244, 22, 'Điện Biên', 'dien-bien', 1, 1, 1446429779, 0, 0), (245, 22, 'Điện Biên Đông', 'dien-bien-dong', 1, 1, 1446429779, 0, 0), (246, 22, 'Mường Ảng', 'muong-ang', 1, 1, 1446429779, 0, 0), (247, 22, 'Mường Chà', 'muong-cha', 1, 1, 1446429779, 0, 0), (248, 22, 'Mường Lay', 'muong-lay', 1, 1, 1446429779, 0, 0), (249, 22, 'Điện Biên Phủ', 'dien-bien-phu', 1, 1, 1446429779, 0, 0), (250, 22, 'Mường Nhé', 'muong-nhe', 1, 1, 1446429779, 0, 0), (251, 22, 'Nậm Pồ', 'nam-po', 1, 1, 1446429779, 0, 0), (252, 22, 'Tủa Chùa', 'tua-chua', 1, 1, 1446429779, 0, 0), (253, 22, 'Tuần Giáo', 'tuan-giao', 1, 1, 1446429779, 0, 0), (254, 23, 'Biên Hòa', 'bien-hoa', 1, 1, 1446429779, 0, 0), (255, 23, 'Cẩm Mỹ', 'cam-my', 1, 1, 1446429779, 0, 0), (256, 23, 'Định Quán', 'dinh-quan', 1, 1, 1446429779, 0, 0), (257, 23, 'Long Thành', 'long-thanh', 1, 1, 1446429779, 0, 0), (258, 23, 'Nhơn Trạch', 'nhon-trach', 1, 1, 1446429779, 0, 0), (259, 23, 'Long Khánh', 'long-khanh', 1, 1, 1446429779, 0, 0), (260, 23, 'Tân Phú', 'tan-phu', 1, 1, 1446429779, 0, 0), (261, 23, 'Thống Nhất', 'thong-nhat', 1, 1, 1446429779, 0, 0), (262, 23, 'Trảng Bom', 'trang-bom', 1, 1, 1446429779, 0, 0), (263, 23, 'Vĩnh Cửu', 'vinh-cuu', 1, 1, 1446429779, 0, 0), (264, 23, 'Xuân Lộc', 'xuan-loc', 1, 1, 1446429779, 0, 0), (265, 24, 'Châu Thành', 'chau-thanh', 1, 1, 1446429779, 0, 0), (266, 24, 'Huyện Cao Lãnh', 'huyen-cao-lanh', 1, 1, 1446429779, 0, 0), (267, 24, 'Huyện Hồng Ngự', 'huyen-hong-ngu', 1, 1, 1446429779, 0, 0), (268, 24, 'Lai Vung', 'lai-vung', 1, 1, 1446429779, 0, 0), (269, 24, 'Lấp Vò', 'lap-vo', 1, 1, 1446429779, 0, 0), (270, 24, 'Sa Đéc', 'sa-dec', 1, 1, 1446429779, 0, 0), (271, 24, 'Tam Nông', 'tam-nong', 1, 1, 1446429779, 0, 0), (272, 24, 'Tân Hồng', 'tan-hong', 1, 1, 1446429779, 0, 0), (273, 24, 'Thanh Bình', 'thanh-binh', 1, 1, 1446429779, 0, 0), (274, 24, 'Tháp Mười', 'thap-muoi', 1, 1, 1446429779, 0, 0), (275, 24, 'Thị xã Hồng Ngự', 'thi-xa-hong-ngu', 1, 1, 1446429779, 0, 0), (276, 24, 'Tp. Cao Lãnh', 'tp-cao-lanh', 1, 1, 1446429779, 0, 0), (277, 25, 'An Khê', 'an-khe', 1, 1, 1446429779, 0, 0), (278, 25, 'AYun Pa', 'ayun-pa', 1, 1, 1446429779, 0, 0), (279, 25, 'Chư Păh', 'chu-pah', 1, 1, 1446429779, 0, 0), (280, 25, 'Chư Pưh', 'chu-puh', 1, 1, 1446429779, 0, 0), (281, 25, 'Chư Sê', 'chu-se', 1, 1, 1446429779, 0, 0), (282, 25, 'ChưPRông', 'chuprong', 1, 1, 1446429779, 0, 0), (283, 25, 'Đăk Đoa', 'dak-doa', 1, 1, 1446429779, 0, 0), (284, 25, 'Đăk Pơ', 'dak-po', 1, 1, 1446429779, 0, 0), (285, 25, 'Đức Cơ', 'duc-co', 1, 1, 1446429779, 0, 0), (286, 25, 'Ia Grai', 'ia-grai', 1, 1, 1446429779, 0, 0), (287, 25, 'Ia Pa', 'ia-pa', 1, 1, 1446429779, 0, 0), (288, 25, 'KBang', 'kbang', 1, 1, 1446429779, 0, 0), (289, 25, 'Kông Chro', 'kong-chro', 1, 1, 1446429779, 0, 0), (290, 25, 'Krông Pa', 'krong-pa', 1, 1, 1446429779, 0, 0), (291, 25, 'Mang Yang', 'mang-yang', 1, 1, 1446429779, 0, 0), (292, 25, 'Phú Thiện', 'phu-thien', 1, 1, 1446429779, 0, 0), (293, 25, 'Plei Ku', 'plei-ku', 1, 1, 1446429779, 0, 0), (294, 26, 'Bắc Mê', 'bac-me', 1, 1, 1446429779, 0, 0), (295, 26, 'Bắc Quang', 'bac-quang', 1, 1, 1446429779, 0, 0), (296, 26, 'Đồng Văn', 'dong-van', 1, 1, 1446429779, 0, 0), (297, 26, 'Hà Giang', 'ha-giang', 1, 1, 1446429779, 0, 0), (298, 26, 'Hoàng Su Phì', 'hoang-su-phi', 1, 1, 1446429779, 0, 0), (299, 26, 'Mèo Vạc', 'meo-vac', 1, 1, 1446429779, 0, 0), (300, 26, 'Quản Bạ', 'quan-ba', 1, 1, 1446429779, 0, 0), (301, 26, 'Quang Bình', 'quang-binh', 1, 1, 1446429779, 0, 0), (302, 26, 'Vị Xuyên', 'vi-xuyen', 1, 1, 1446429779, 0, 0), (303, 26, 'Xín Mần', 'xin-man', 1, 1, 1446429779, 0, 0), (304, 26, 'Yên Minh', 'yen-minh', 1, 1, 1446429779, 0, 0), (305, 27, 'Bình Lục', 'binh-luc', 1, 1, 1446429779, 0, 0), (306, 27, 'Duy Tiên', 'duy-tien', 1, 1, 1446429779, 0, 0), (307, 27, 'Kim Bảng', 'kim-bang', 1, 1, 1446429779, 0, 0), (308, 27, 'Lý Nhân', 'ly-nhan', 1, 1, 1446429779, 0, 0), (309, 27, 'Phủ Lý', 'phu-ly', 1, 1, 1446429779, 0, 0), (310, 27, 'Thanh Liêm', 'thanh-liem', 1, 1, 1446429779, 0, 0), (311, 28, 'Cẩm Xuyên', 'cam-xuyen', 1, 1, 1446429779, 0, 0), (312, 28, 'Can Lộc', 'can-loc', 1, 1, 1446429779, 0, 0), (313, 28, 'Đức Thọ', 'duc-tho', 1, 1, 1446429779, 0, 0), (314, 28, 'Hà Tĩnh', 'ha-tinh', 1, 1, 1446429779, 0, 0), (315, 28, 'Hồng Lĩnh', 'hong-linh', 1, 1, 1446429779, 0, 0), (316, 28, 'Hương Khê', 'huong-khe', 1, 1, 1446429779, 0, 0), (317, 28, 'Hương Sơn', 'huong-son', 1, 1, 1446429779, 0, 0), (318, 28, 'Kỳ Anh', 'ky-anh', 1, 1, 1446429779, 0, 0), (319, 28, 'Lộc Hà', 'loc-ha', 1, 1, 1446429779, 0, 0), (320, 28, 'Nghi Xuân', 'nghi-xuan', 1, 1, 1446429779, 0, 0), (321, 28, 'Thạch Hà', 'thach-ha', 1, 1, 1446429779, 0, 0), (322, 28, 'Vũ Quang', 'vu-quang', 1, 1, 1446429779, 0, 0), (323, 29, 'Bình Giang', 'binh-giang', 1, 1, 1446429779, 0, 0), (324, 29, 'Cẩm Giàng', 'cam-giang', 1, 1, 1446429779, 0, 0), (325, 29, 'Chí Linh', 'chi-linh', 1, 1, 1446429779, 0, 0), (326, 29, 'Gia Lộc', 'gia-loc', 1, 1, 1446429779, 0, 0), (327, 29, 'Kim Thành', 'kim-thanh', 1, 1, 1446429779, 0, 0), (328, 29, 'Kinh Môn', 'kinh-mon', 1, 1, 1446429779, 0, 0), (329, 29, 'Hải Dương', 'hai-duong', 1, 1, 1446429779, 0, 0), (330, 29, 'Nam Sách', 'nam-sach', 1, 1, 1446429779, 0, 0), (331, 29, 'Ninh Giang', 'ninh-giang', 1, 1, 1446429779, 0, 0), (332, 29, 'Thanh Hà', 'thanh-ha', 1, 1, 1446429779, 0, 0), (333, 29, 'Thanh Miện', 'thanh-mien', 1, 1, 1446429779, 0, 0), (334, 29, 'Tứ Kỳ', 'tu-ky', 1, 1, 1446429779, 0, 0), (335, 30, 'Châu Thành', 'chau-thanh', 1, 1, 1446429779, 0, 0), (336, 30, 'Châu Thành A', 'chau-thanh-a', 1, 1, 1446429779, 0, 0), (337, 30, 'Long Mỹ', 'long-my', 1, 1, 1446429779, 0, 0), (338, 30, 'Ngã Bảy', 'nga-bay', 1, 1, 1446429779, 0, 0), (339, 30, 'Phụng Hiệp', 'phung-hiep', 1, 1, 1446429779, 0, 0), (340, 30, 'Vị Thanh', 'vi-thanh', 1, 1, 1446429779, 0, 0), (341, 30, 'Vị Thủy', 'vi-thuy', 1, 1, 1446429779, 0, 0), (342, 31, 'Cao Phong', 'cao-phong', 1, 1, 1446429779, 0, 0), (343, 31, 'Đà Bắc', 'da-bac', 1, 1, 1446429779, 0, 0), (344, 31, 'Hòa Bình', 'hoa-binh', 1, 1, 1446429779, 0, 0), (345, 31, 'Kim Bôi', 'kim-boi', 1, 1, 1446429779, 0, 0), (346, 31, 'Kỳ Sơn', 'ky-son', 1, 1, 1446429779, 0, 0), (347, 31, 'Lạc Sơn', 'lac-son', 1, 1, 1446429779, 0, 0), (348, 31, 'Lạc Thủy', 'lac-thuy', 1, 1, 1446429779, 0, 0), (349, 31, 'Lương Sơn', 'luong-son', 1, 1, 1446429779, 0, 0), (350, 31, 'Mai Châu', 'mai-chau', 1, 1, 1446429779, 0, 0), (351, 31, 'Tân Lạc', 'tan-lac', 1, 1, 1446429779, 0, 0), (352, 31, 'Yên Thủy', 'yen-thuy', 1, 1, 1446429779, 0, 0), (353, 32, 'Ân Thi', 'an-thi', 1, 1, 1446429779, 0, 0), (354, 32, 'Hưng Yên', 'hung-yen', 1, 1, 1446429779, 0, 0), (355, 32, 'Khoái Châu', 'khoai-chau', 1, 1, 1446429779, 0, 0), (356, 32, 'Mỹ Hào', 'my-hao', 1, 1, 1446429779, 0, 0), (357, 32, 'Kim Động', 'kim-dong', 1, 1, 1446429779, 0, 0), (358, 32, 'Phù Cừ', 'phu-cu', 1, 1, 1446429779, 0, 0), (359, 32, 'Tiên Lữ', 'tien-lu', 1, 1, 1446429779, 0, 0), (360, 32, 'Văn Giang', 'van-giang', 1, 1, 1446429779, 0, 0), (361, 32, 'Văn Lâm', 'van-lam', 1, 1, 1446429779, 0, 0), (362, 32, 'Yên Mỹ', 'yen-my', 1, 1, 1446429779, 0, 0), (363, 33, 'Cam Lâm', 'cam-lam', 1, 1, 1446429779, 0, 0), (364, 33, 'Cam Ranh', 'cam-ranh', 1, 1, 1446429779, 0, 0), (365, 33, 'Diên Khánh', 'dien-khanh', 1, 1, 1446429779, 0, 0), (366, 33, 'Khánh Sơn', 'khanh-son', 1, 1, 1446429779, 0, 0), (367, 33, 'Khánh Vĩnh', 'khanh-vinh', 1, 1, 1446429779, 0, 0), (368, 33, 'Nha Trang', 'nha-trang', 1, 1, 1446429779, 0, 0), (369, 33, 'Ninh Hòa', 'ninh-hoa', 1, 1, 1446429779, 0, 0), (370, 33, 'Trường Sa', 'truong-sa', 1, 1, 1446429779, 0, 0), (371, 33, 'Vạn Ninh', 'van-ninh', 1, 1, 1446429779, 0, 0), (372, 34, 'An Biên', 'an-bien', 1, 1, 1446429779, 0, 0), (373, 34, 'An Minh', 'an-minh', 1, 1, 1446429779, 0, 0), (374, 34, 'Châu Thành', 'chau-thanh', 1, 1, 1446429779, 0, 0), (375, 34, 'Giang Thành', 'giang-thanh', 1, 1, 1446429779, 0, 0), (376, 34, 'Giồng Riềng', 'giong-rieng', 1, 1, 1446429779, 0, 0), (377, 34, 'Gò Quao', 'go-quao', 1, 1, 1446429779, 0, 0), (378, 34, 'Hà Tiên', 'ha-tien', 1, 1, 1446429779, 0, 0), (379, 34, 'Kiên Hải', 'kien-hai', 1, 1, 1446429779, 0, 0), (380, 34, 'Hòn Đất', 'hon-dat', 1, 1, 1446429779, 0, 0), (381, 34, 'Kiên Lương', 'kien-luong', 1, 1, 1446429779, 0, 0), (382, 34, 'Phú Quốc', 'phu-quoc', 1, 1, 1446429779, 0, 0), (383, 34, 'Rạch Giá', 'rach-gia', 1, 1, 1446429779, 0, 0), (384, 34, 'Tân Hiệp', 'tan-hiep', 1, 1, 1446429779, 0, 0), (385, 34, 'U minh Thượng', 'u-minh-thuong', 1, 1, 1446429779, 0, 0), (386, 34, 'Vĩnh Thuận', 'vinh-thuan', 1, 1, 1446429779, 0, 0), (387, 35, 'Đăk Glei', 'dak-glei', 1, 1, 1446429779, 0, 0), (388, 35, 'Đăk Hà', 'dak-ha', 1, 1, 1446429779, 0, 0), (389, 35, 'Kon Rẫy', 'kon-ray', 1, 1, 1446429779, 0, 0), (390, 35, 'Đăk Tô', 'dak-to', 1, 1, 1446429779, 0, 0), (391, 35, 'Kon Plông', 'kon-plong', 1, 1, 1446429779, 0, 0), (392, 35, 'KonTum', 'kontum', 1, 1, 1446429779, 0, 0), (393, 35, 'Ngọc Hồi', 'ngoc-hoi', 1, 1, 1446429779, 0, 0), (394, 35, 'Sa Thầy', 'sa-thay', 1, 1, 1446429779, 0, 0), (395, 35, 'Tu Mơ Rông', 'tu-mo-rong', 1, 1, 1446429779, 0, 0), (396, 36, 'Lai Châu', 'lai-chau', 1, 1, 1446429779, 0, 0), (397, 36, 'Mường Tè', 'muong-te', 1, 1, 1446429779, 0, 0), (398, 36, 'Nậm Nhùn', 'nam-nhun', 1, 1, 1446429779, 0, 0), (399, 36, 'Phong Thổ', 'phong-tho', 1, 1, 1446429779, 0, 0), (400, 36, 'Sìn Hồ', 'sin-ho', 1, 1, 1446429779, 0, 0), (401, 36, 'Tam Đường', 'tam-duong', 1, 1, 1446429779, 0, 0), (402, 36, 'Tân Uyên', 'tan-uyen', 1, 1, 1446429779, 0, 0), (403, 36, 'Than Uyên', 'than-uyen', 1, 1, 1446429779, 0, 0), (404, 37, 'Bảo Lâm', 'bao-lam', 1, 1, 1446429779, 0, 0), (405, 37, 'Bảo Lộc', 'bao-loc', 1, 1, 1446429779, 0, 0), (406, 37, 'Cát Tiên', 'cat-tien', 1, 1, 1446429779, 0, 0), (407, 37, 'Đam Rông', 'dam-rong', 1, 1, 1446429779, 0, 0), (408, 37, 'Đạ Tẻh', 'da-teh', 1, 1, 1446429779, 0, 0), (409, 37, 'Đà Lạt', 'da-lat', 1, 1, 1446429779, 0, 0), (410, 37, 'Di Linh', 'di-linh', 1, 1, 1446429779, 0, 0), (411, 37, 'Đạ Huoai', 'da-huoai', 1, 1, 1446429779, 0, 0), (412, 37, 'Đơn Dương', 'don-duong', 1, 1, 1446429779, 0, 0), (413, 37, 'Đức Trọng', 'duc-trong', 1, 1, 1446429779, 0, 0), (414, 37, 'Lạc Dương', 'lac-duong', 1, 1, 1446429779, 0, 0), (415, 37, 'Lâm Hà', 'lam-ha', 1, 1, 1446429779, 0, 0), (416, 38, 'Bắc Sơn', 'bac-son', 1, 1, 1446429779, 0, 0), (417, 38, 'Bình Gia', 'binh-gia', 1, 1, 1446429779, 0, 0), (418, 38, 'Cao Lộc', 'cao-loc', 1, 1, 1446429779, 0, 0), (419, 38, 'Chi Lăng', 'chi-lang', 1, 1, 1446429779, 0, 0), (420, 38, 'Đình Lập', 'dinh-lap', 1, 1, 1446429779, 0, 0), (421, 38, 'Lạng Sơn', 'lang-son', 1, 1, 1446429779, 0, 0), (422, 38, 'Hữu Lũng', 'huu-lung', 1, 1, 1446429779, 0, 0), (423, 38, 'Lộc Bình', 'loc-binh', 1, 1, 1446429779, 0, 0), (424, 38, 'Tràng Định', 'trang-dinh', 1, 1, 1446429779, 0, 0), (425, 38, 'Văn Lãng', 'van-lang', 1, 1, 1446429779, 0, 0), (426, 38, 'Văn Quan', 'van-quan', 1, 1, 1446429779, 0, 0), (427, 39, 'Bắc Hà', 'bac-ha', 1, 1, 1446429779, 0, 0), (428, 39, 'Bảo Thắng', 'bao-thang', 1, 1, 1446429779, 0, 0), (429, 39, 'Lào Cai', 'lao-cai', 1, 1, 1446429779, 0, 0), (430, 39, 'Bát Xát', 'bat-xat', 1, 1, 1446429779, 0, 0), (431, 39, 'Bảo Yên', 'bao-yen', 1, 1, 1446429779, 0, 0), (432, 39, 'Mường Khương', 'muong-khuong', 1, 1, 1446429779, 0, 0), (433, 39, 'Sa Pa', 'sa-pa', 1, 1, 1446429779, 0, 0), (434, 39, 'Văn Bàn', 'van-ban', 1, 1, 1446429779, 0, 0), (435, 39, 'Xi Ma Cai', 'xi-ma-cai', 1, 1, 1446429779, 0, 0), (436, 40, 'Giao Thủy', 'giao-thuy', 1, 1, 1446429779, 0, 0), (437, 40, 'Hải Hậu', 'hai-hau', 1, 1, 1446429779, 0, 0), (438, 40, 'Mỹ Lộc', 'my-loc', 1, 1, 1446429779, 0, 0), (439, 40, 'Trực Ninh', 'truc-ninh', 1, 1, 1446429779, 0, 0), (440, 40, 'Nghĩa Hưng', 'nghia-hung', 1, 1, 1446429779, 0, 0), (441, 40, 'Nam Trực', 'nam-truc', 1, 1, 1446429779, 0, 0), (442, 40, 'Nam Định', 'nam-dinh', 1, 1, 1446429779, 0, 0), (443, 40, 'Vụ Bản', 'vu-ban', 1, 1, 1446429779, 0, 0), (444, 40, 'Xuân Trường', 'xuan-truong', 1, 1, 1446429779, 0, 0), (445, 40, 'Ý Yên', 'y-yen', 1, 1, 1446429779, 0, 0), (446, 41, 'Anh Sơn', 'anh-son', 1, 1, 1446429779, 0, 0), (447, 41, 'Con Cuông', 'con-cuong', 1, 1, 1446429779, 0, 0), (448, 41, 'Cửa Lò', 'cua-lo', 1, 1, 1446429779, 0, 0), (449, 41, 'Diễn Châu', 'dien-chau', 1, 1, 1446429779, 0, 0), (450, 41, 'Đô Lương', 'do-luong', 1, 1, 1446429779, 0, 0), (451, 41, 'Hoàng Mai', 'hoang-mai', 1, 1, 1446429779, 0, 0), (452, 41, 'Hưng Nguyên', 'hung-nguyen', 1, 1, 1446429779, 0, 0), (453, 41, 'Kỳ Sơn', 'ky-son', 1, 1, 1446429779, 0, 0), (454, 41, 'Nam Đàn', 'nam-dan', 1, 1, 1446429779, 0, 0), (455, 41, 'Nghi Lộc', 'nghi-loc', 1, 1, 1446429779, 0, 0), (456, 41, 'Nghĩa Đàn', 'nghia-dan', 1, 1, 1446429779, 0, 0), (457, 41, 'Quế Phong', 'que-phong', 1, 1, 1446429779, 0, 0), (458, 41, 'Quỳ Châu', 'quy-chau', 1, 1, 1446429779, 0, 0), (459, 41, 'Quỳ Hợp', 'quy-hop', 1, 1, 1446429779, 0, 0), (460, 41, 'Quỳnh Lưu', 'quynh-luu', 1, 1, 1446429779, 0, 0), (461, 41, 'Tân Kỳ', 'tan-ky', 1, 1, 1446429779, 0, 0), (462, 41, 'Thái Hòa', 'thai-hoa', 1, 1, 1446429779, 0, 0), (463, 41, 'Thanh Chương', 'thanh-chuong', 1, 1, 1446429779, 0, 0), (464, 41, 'Tương Dương', 'tuong-duong', 1, 1, 1446429779, 0, 0), (465, 41, 'Vinh', 'vinh', 1, 1, 1446429779, 0, 0), (466, 41, 'Yên Thành', 'yen-thanh', 1, 1, 1446429779, 0, 0), (467, 42, 'Gia Viễn', 'gia-vien', 1, 1, 1446429779, 0, 0), (468, 42, 'Hoa Lư', 'hoa-lu', 1, 1, 1446429779, 0, 0), (469, 42, 'Kim Sơn', 'kim-son', 1, 1, 1446429779, 0, 0), (470, 42, 'Nho Quan', 'nho-quan', 1, 1, 1446429779, 0, 0), (471, 42, 'Ninh Bình', 'ninh-binh', 1, 1, 1446429779, 0, 0), (472, 42, 'Tam Điệp', 'tam-diep', 1, 1, 1446429779, 0, 0), (473, 42, 'Yên Khánh', 'yen-khanh', 1, 1, 1446429779, 0, 0), (474, 42, 'Yên Mô', 'yen-mo', 1, 1, 1446429779, 0, 0), (475, 43, 'Bác Ái', 'bac-ai', 1, 1, 1446429779, 0, 0), (476, 43, 'Ninh Hải', 'ninh-hai', 1, 1, 1446429779, 0, 0), (477, 43, 'Ninh Phước', 'ninh-phuoc', 1, 1, 1446429779, 0, 0), (478, 43, 'Ninh Sơn', 'ninh-son', 1, 1, 1446429779, 0, 0), (479, 43, 'Phan Rang - Tháp Chàm', 'phan-rang-thap-cham', 1, 1, 1446429779, 0, 0), (480, 43, 'Thuận Bắc', 'thuan-bac', 1, 1, 1446429779, 0, 0), (481, 43, 'Thuận Nam', 'thuan-nam', 1, 1, 1446429779, 0, 0), (482, 44, 'Cẩm Khê', 'cam-khe', 1, 1, 1446429779, 0, 0), (483, 44, 'Đoan Hùng', 'doan-hung', 1, 1, 1446429779, 0, 0), (484, 44, 'Hạ Hòa', 'ha-hoa', 1, 1, 1446429779, 0, 0), (485, 44, 'Lâm Thao', 'lam-thao', 1, 1, 1446429779, 0, 0), (486, 44, 'Phù Ninh', 'phu-ninh', 1, 1, 1446429779, 0, 0), (487, 44, 'Phú Thọ', 'phu-tho', 1, 1, 1446429779, 0, 0), (488, 44, 'Tam Nông', 'tam-nong', 1, 1, 1446429779, 0, 0), (489, 44, 'Tân Sơn', 'tan-son', 1, 1, 1446429779, 0, 0), (490, 44, 'Thanh Ba', 'thanh-ba', 1, 1, 1446429779, 0, 0), (491, 44, 'Thanh Sơn', 'thanh-son', 1, 1, 1446429779, 0, 0), (492, 44, 'Thanh Thủy', 'thanh-thuy', 1, 1, 1446429779, 0, 0), (493, 44, 'Việt Trì', 'viet-tri', 1, 1, 1446429779, 0, 0), (494, 44, 'Yên Lập', 'yen-lap', 1, 1, 1446429779, 0, 0), (495, 45, 'Đông Hòa', 'dong-hoa', 1, 1, 1446429779, 0, 0), (496, 45, 'Đồng Xuân', 'dong-xuan', 1, 1, 1446429779, 0, 0), (497, 45, 'Sơn Hòa', 'son-hoa', 1, 1, 1446429779, 0, 0), (498, 45, 'Sông Cầu', 'song-cau', 1, 1, 1446429779, 0, 0), (499, 45, 'Sông Hinh', 'song-hinh', 1, 1, 1446429779, 0, 0), (500, 45, 'Phú Hòa', 'phu-hoa', 1, 1, 1446429779, 0, 0), (501, 45, 'Tây Hòa', 'tay-hoa', 1, 1, 1446429779, 0, 0), (502, 45, 'Tuy An', 'tuy-an', 1, 1, 1446429779, 0, 0), (503, 45, 'Tuy Hòa', 'tuy-hoa', 1, 1, 1446429779, 0, 0), (504, 46, 'Ba Đồn', 'ba-don', 1, 1, 1446429779, 0, 0), (505, 46, 'Bố Trạch', 'bo-trach', 1, 1, 1446429779, 0, 0), (506, 46, 'Đồng Hới', 'dong-hoi', 1, 1, 1446429779, 0, 0), (507, 46, 'Lệ Thủy', 'le-thuy', 1, 1, 1446429779, 0, 0), (508, 46, 'Minh Hóa', 'minh-hoa', 1, 1, 1446429779, 0, 0), (509, 46, 'Quảng Ninh', 'quang-ninh', 1, 1, 1446429779, 0, 0), (510, 46, 'Quảng Trạch', 'quang-trach', 1, 1, 1446429779, 0, 0), (511, 46, 'Tuyên Hóa', 'tuyen-hoa', 1, 1, 1446429779, 0, 0), (512, 47, 'Bắc Trà My', 'bac-tra-my', 1, 1, 1446429779, 0, 0), (513, 47, 'Đại Lộc', 'dai-loc', 1, 1, 1446429779, 0, 0), (514, 47, 'Điện Bàn', 'dien-ban', 1, 1, 1446429779, 0, 0), (515, 47, 'Đông Giang', 'dong-giang', 1, 1, 1446429779, 0, 0), (516, 47, 'Hiệp Đức', 'hiep-duc', 1, 1, 1446429779, 0, 0), (517, 47, 'Duy Xuyên', 'duy-xuyen', 1, 1, 1446429779, 0, 0), (518, 47, 'Hội An', 'hoi-an', 1, 1, 1446429779, 0, 0), (519, 47, 'Nam Giang', 'nam-giang', 1, 1, 1446429779, 0, 0), (520, 47, 'Nam Trà My', 'nam-tra-my', 1, 1, 1446429779, 0, 0), (521, 47, 'Nông Sơn', 'nong-son', 1, 1, 1446429779, 0, 0), (522, 47, 'Núi Thành', 'nui-thanh', 1, 1, 1446429779, 0, 0), (523, 47, 'Phú Ninh', 'phu-ninh', 1, 1, 1446429779, 0, 0), (524, 47, 'Phước Sơn', 'phuoc-son', 1, 1, 1446429779, 0, 0), (525, 47, 'Quế Sơn', 'que-son', 1, 1, 1446429779, 0, 0), (526, 47, 'Tam Kỳ', 'tam-ky', 1, 1, 1446429779, 0, 0), (527, 47, 'Tây Giang', 'tay-giang', 1, 1, 1446429779, 0, 0), (528, 47, 'Thăng Bình', 'thang-binh', 1, 1, 1446429779, 0, 0), (529, 47, 'Tiên Phước', 'tien-phuoc', 1, 1, 1446429779, 0, 0), (530, 48, 'Ba Tơ', 'ba-to', 1, 1, 1446429779, 0, 0), (531, 48, 'Bình Sơn', 'binh-son', 1, 1, 1446429779, 0, 0), (532, 48, 'Đức Phổ', 'duc-pho', 1, 1, 1446429779, 0, 0), (533, 48, 'Lý Sơn', 'ly-son', 1, 1, 1446429779, 0, 0), (534, 48, 'Minh Long', 'minh-long', 1, 1, 1446429779, 0, 0), (535, 48, 'Mộ Đức', 'mo-duc', 1, 1, 1446429779, 0, 0), (536, 48, 'Nghĩa Hành', 'nghia-hanh', 1, 1, 1446429779, 0, 0), (537, 48, 'Quảng Ngãi', 'quang-ngai', 1, 1, 1446429779, 0, 0), (538, 48, 'Sơn Hà', 'son-ha', 1, 1, 1446429779, 0, 0), (539, 48, 'Sơn Tây', 'son-tay', 1, 1, 1446429779, 0, 0), (540, 48, 'Sơn Tịnh', 'son-tinh', 1, 1, 1446429779, 0, 0), (541, 48, 'Tây Trà', 'tay-tra', 1, 1, 1446429779, 0, 0), (542, 48, 'Trà Bồng', 'tra-bong', 1, 1, 1446429779, 0, 0), (543, 48, 'Tư Nghĩa', 'tu-nghia', 1, 1, 1446429779, 0, 0), (544, 49, 'Ba Chẽ', 'ba-che', 1, 1, 1446429779, 0, 0), (545, 49, 'Cẩm Phả', 'cam-pha', 1, 1, 1446429779, 0, 0), (546, 49, 'Bình Liêu', 'binh-lieu', 1, 1, 1446429779, 0, 0), (547, 49, 'Cô Tô', 'co-to', 1, 1, 1446429779, 0, 0), (548, 49, 'Đầm Hà', 'dam-ha', 1, 1, 1446429779, 0, 0), (549, 49, 'Đông Triều', 'dong-trieu', 1, 1, 1446429779, 0, 0), (550, 49, 'Hạ Long', 'ha-long', 1, 1, 1446429779, 0, 0), (551, 49, 'Hải Hà', 'hai-ha', 1, 1, 1446429779, 0, 0), (552, 49, 'Hoành Bồ', 'hoanh-bo', 1, 1, 1446429779, 0, 0), (553, 49, 'Móng Cái', 'mong-cai', 1, 1, 1446429779, 0, 0), (554, 49, 'Quảng Yên', 'quang-yen', 1, 1, 1446429779, 0, 0), (555, 49, 'Tiên Yên', 'tien-yen', 1, 1, 1446429779, 0, 0), (556, 49, 'Uông Bí', 'uong-bi', 1, 1, 1446429779, 0, 0), (557, 49, 'Vân Đồn', 'van-don', 1, 1, 1446429779, 0, 0), (558, 50, 'Cam Lộ', 'cam-lo', 1, 1, 1446429779, 0, 0), (559, 50, 'Đảo Cồn cỏ', 'dao-con-co', 1, 1, 1446429779, 0, 0), (560, 50, 'Đăk Rông', 'dak-rong', 1, 1, 1446429779, 0, 0), (561, 50, 'Đông Hà', 'dong-ha', 1, 1, 1446429779, 0, 0), (562, 50, 'Gio Linh', 'gio-linh', 1, 1, 1446429779, 0, 0), (563, 50, 'Hải Lăng', 'hai-lang', 1, 1, 1446429779, 0, 0), (564, 50, 'Hướng Hóa', 'huong-hoa', 1, 1, 1446429779, 0, 0), (565, 50, 'Quảng Trị', 'quang-tri', 1, 1, 1446429779, 0, 0), (566, 50, 'Triệu Phong', 'trieu-phong', 1, 1, 1446429779, 0, 0), (567, 50, 'Vĩnh Linh', 'vinh-linh', 1, 1, 1446429779, 0, 0), (568, 51, 'Châu Thành', 'chau-thanh', 1, 1, 1446429779, 0, 0), (569, 51, 'Cù Lao Dung', 'cu-lao-dung', 1, 1, 1446429779, 0, 0), (570, 51, 'Mỹ Xuyên', 'my-xuyen', 1, 1, 1446429779, 0, 0), (571, 51, 'Mỹ Tú', 'my-tu', 1, 1, 1446429779, 0, 0), (572, 51, 'Long Phú', 'long-phu', 1, 1, 1446429779, 0, 0), (573, 51, 'Kế Sách', 'ke-sach', 1, 1, 1446429779, 0, 0), (574, 51, 'Ngã Năm', 'nga-nam', 1, 1, 1446429779, 0, 0), (575, 51, 'Sóc Trăng', 'soc-trang', 1, 1, 1446429779, 0, 0), (576, 51, 'Thạnh Trị', 'thanh-tri', 1, 1, 1446429779, 0, 0), (577, 51, 'Trần Đề', 'tran-de', 1, 1, 1446429779, 0, 0), (578, 51, 'Vĩnh Châu', 'vinh-chau', 1, 1, 1446429779, 0, 0), (579, 52, 'Mai Sơn', 'mai-son', 1, 1, 1446429779, 0, 0), (580, 52, 'Bắc Yên', 'bac-yen', 1, 1, 1446429779, 0, 0), (581, 52, 'Mộc Châu', 'moc-chau', 1, 1, 1446429779, 0, 0), (582, 52, 'Mường La', 'muong-la', 1, 1, 1446429779, 0, 0), (583, 52, 'Quỳnh Nhai', 'quynh-nhai', 1, 1, 1446429779, 0, 0), (584, 52, 'Phù Yên', 'phu-yen', 1, 1, 1446429779, 0, 0), (585, 52, 'Sơn La', 'son-la', 1, 1, 1446429779, 0, 0), (586, 52, 'Sông Mã', 'song-ma', 1, 1, 1446429779, 0, 0), (587, 52, 'Sốp Cộp', 'sop-cop', 1, 1, 1446429779, 0, 0), (588, 52, 'Thuận Châu', 'thuan-chau', 1, 1, 1446429779, 0, 0), (589, 52, 'Vân Hồ', 'van-ho', 1, 1, 1446429779, 0, 0), (590, 52, 'Yên Châu', 'yen-chau', 1, 1, 1446429779, 0, 0), (591, 53, 'Bến Cầu', 'ben-cau', 1, 1, 1446429779, 0, 0), (592, 53, 'Châu Thành', 'chau-thanh', 1, 1, 1446429779, 0, 0), (593, 53, 'Gò Dầu', 'go-dau', 1, 1, 1446429779, 0, 0), (594, 53, 'Dương Minh Châu', 'duong-minh-chau', 1, 1, 1446429779, 0, 0), (595, 53, 'Tân Biên', 'tan-bien', 1, 1, 1446429779, 0, 0), (596, 53, 'Hòa Thành', 'hoa-thanh', 1, 1, 1446429779, 0, 0), (597, 53, 'Tân Châu', 'tan-chau', 1, 1, 1446429779, 0, 0), (598, 53, 'Tây Ninh', 'tay-ninh', 1, 1, 1446429779, 0, 0), (599, 53, 'Trảng Bàng', 'trang-bang', 1, 1, 1446429779, 0, 0), (600, 54, 'Đông Hưng', 'dong-hung', 1, 1, 1446429779, 0, 0), (601, 54, 'Thái Bình', 'thai-binh', 1, 1, 1446429779, 0, 0), (602, 54, 'Hưng Hà', 'hung-ha', 1, 1, 1446429779, 0, 0), (603, 54, 'Kiến Xương', 'kien-xuong', 1, 1, 1446429779, 0, 0), (604, 54, 'Quỳnh Phụ', 'quynh-phu', 1, 1, 1446429779, 0, 0), (605, 54, 'Thái Thuỵ', 'thai-thuy', 1, 1, 1446429779, 0, 0), (606, 54, 'Tiền Hải', 'tien-hai', 1, 1, 1446429779, 0, 0), (607, 54, 'Vũ Thư', 'vu-thu', 1, 1, 1446429779, 0, 0), (608, 55, 'Định Hóa', 'dinh-hoa', 1, 1, 1446429779, 0, 0), (609, 55, 'Đại Từ', 'dai-tu', 1, 1, 1446429779, 0, 0), (610, 55, 'Đồng Hỷ', 'dong-hy', 1, 1, 1446429779, 0, 0), (611, 55, 'Phổ Yên', 'pho-yen', 1, 1, 1446429779, 0, 0), (612, 55, 'Phú Lương', 'phu-luong', 1, 1, 1446429779, 0, 0), (613, 55, 'Phú Bình', 'phu-binh', 1, 1, 1446429779, 0, 0), (614, 55, 'Sông Công', 'song-cong', 1, 1, 1446429779, 0, 0), (615, 55, 'Thái Nguyên', 'thai-nguyen', 1, 1, 1446429779, 0, 0), (616, 55, 'Võ Nhai', 'vo-nhai', 1, 1, 1446429779, 0, 0), (617, 56, 'Bá Thước', 'ba-thuoc', 1, 1, 1446429779, 0, 0), (618, 56, 'Bỉm Sơn', 'bim-son', 1, 1, 1446429779, 0, 0), (619, 56, 'Cẩm Thủy', 'cam-thuy', 1, 1, 1446429779, 0, 0), (620, 56, 'Đông Sơn', 'dong-son', 1, 1, 1446429779, 0, 0), (621, 56, 'Hà Trung', 'ha-trung', 1, 1, 1446429779, 0, 0), (622, 56, 'Hậu Lộc', 'hau-loc', 1, 1, 1446429779, 0, 0), (623, 56, 'Hoằng Hóa', 'hoang-hoa', 1, 1, 1446429779, 0, 0), (624, 56, 'Lang Chánh', 'lang-chanh', 1, 1, 1446429779, 0, 0), (625, 56, 'Mường Lát', 'muong-lat', 1, 1, 1446429779, 0, 0), (626, 56, 'Nga Sơn', 'nga-son', 1, 1, 1446429779, 0, 0), (627, 56, 'Ngọc Lặc', 'ngoc-lac', 1, 1, 1446429779, 0, 0), (628, 56, 'Như Thanh', 'nhu-thanh', 1, 1, 1446429779, 0, 0), (629, 56, 'Như Xuân', 'nhu-xuan', 1, 1, 1446429779, 0, 0), (630, 56, 'Nông Cống', 'nong-cong', 1, 1, 1446429779, 0, 0), (631, 56, 'Quan Hóa', 'quan-hoa', 1, 1, 1446429779, 0, 0), (632, 56, 'Quan Sơn', 'quan-son', 1, 1, 1446429779, 0, 0), (633, 56, 'Quảng Xương', 'quang-xuong', 1, 1, 1446429779, 0, 0), (634, 56, 'Sầm Sơn', 'sam-son', 1, 1, 1446429779, 0, 0), (635, 56, 'Thạch Thành', 'thach-thanh', 1, 1, 1446429779, 0, 0), (636, 56, 'Thanh Hóa', 'thanh-hoa', 1, 1, 1446429779, 0, 0), (637, 56, 'Thiệu Hóa', 'thieu-hoa', 1, 1, 1446429779, 0, 0), (638, 56, 'Thọ Xuân', 'tho-xuan', 1, 1, 1446429779, 0, 0), (639, 56, 'Thường Xuân', 'thuong-xuan', 1, 1, 1446429779, 0, 0), (640, 56, 'Tĩnh Gia', 'tinh-gia', 1, 1, 1446429779, 0, 0), (641, 56, 'Triệu Sơn', 'trieu-son', 1, 1, 1446429779, 0, 0), (642, 56, 'Vĩnh Lộc', 'vinh-loc', 1, 1, 1446429779, 0, 0), (643, 56, 'Yên Định', 'yen-dinh', 1, 1, 1446429779, 0, 0), (644, 57, 'A Lưới', 'a-luoi', 1, 1, 1446429779, 0, 0), (645, 57, 'Hương Thủy', 'huong-thuy', 1, 1, 1446429779, 0, 0), (646, 57, 'Phong Điền', 'phong-dien', 1, 1, 1446429779, 0, 0), (647, 57, 'Hương Trà', 'huong-tra', 1, 1, 1446429779, 0, 0), (648, 57, 'Huế', 'hue', 1, 1, 1446429779, 0, 0), (649, 57, 'Nam Đông', 'nam-dong', 1, 1, 1446429779, 0, 0), (650, 57, 'Phú Lộc', 'phu-loc', 1, 1, 1446429779, 0, 0), (651, 57, 'Phú Vang', 'phu-vang', 1, 1, 1446429779, 0, 0), (652, 57, 'Quảng Điền', 'quang-dien', 1, 1, 1446429779, 0, 0), (653, 58, 'Cái Bè', 'cai-be', 1, 1, 1446429779, 0, 0), (654, 58, 'Gò Công Đông', 'go-cong-dong', 1, 1, 1446429779, 0, 0), (655, 58, 'Chợ Gạo', 'cho-gao', 1, 1, 1446429779, 0, 0), (656, 58, 'Gò Công', 'go-cong', 1, 1, 1446429779, 0, 0), (657, 58, 'Châu Thành', 'chau-thanh', 1, 1, 1446429779, 0, 0), (658, 58, 'Gò Công Tây', 'go-cong-tay', 1, 1, 1446429779, 0, 0), (659, 58, 'Huyện Cai Lậy', 'huyen-cai-lay', 1, 1, 1446429779, 0, 0), (660, 58, 'Mỹ Tho', 'my-tho', 1, 1, 1446429779, 0, 0), (661, 58, 'Tân Phú Đông', 'tan-phu-dong', 1, 1, 1446429779, 0, 0), (662, 58, 'Tân Phước', 'tan-phuoc', 1, 1, 1446429779, 0, 0), (663, 58, 'Thị Xã Cai Lậy', 'thi-xa-cai-lay', 1, 1, 1446429779, 0, 0), (664, 59, 'Càng Long', 'cang-long', 1, 1, 1446429779, 0, 0), (665, 59, 'Cầu Ngang', 'cau-ngang', 1, 1, 1446429779, 0, 0), (666, 59, 'Cầu Kè', 'cau-ke', 1, 1, 1446429779, 0, 0), (667, 59, 'Duyên Hải', 'duyen-hai', 1, 1, 1446429779, 0, 0), (668, 59, 'Tiểu Cần', 'tieu-can', 1, 1, 1446429779, 0, 0), (669, 59, 'Châu Thành', 'chau-thanh', 1, 1, 1446429779, 0, 0), (670, 59, 'Trà Cú', 'tra-cu', 1, 1, 1446429779, 0, 0), (671, 59, 'Trà Vinh', 'tra-vinh', 1, 1, 1446429779, 0, 0), (672, 60, 'Chiêm Hóa', 'chiem-hoa', 1, 1, 1446429779, 0, 0), (673, 60, 'Sơn Dương', 'son-duong', 1, 1, 1446429779, 0, 0), (674, 60, 'Na Hang', 'na-hang', 1, 1, 1446429779, 0, 0), (675, 60, 'Tuyên Quang', 'tuyen-quang', 1, 1, 1446429779, 0, 0), (676, 60, 'Hàm Yên', 'ham-yen', 1, 1, 1446429779, 0, 0), (677, 60, 'Lâm Bình', 'lam-binh', 1, 1, 1446429779, 0, 0), (678, 60, 'Yên Sơn', 'yen-son', 1, 1, 1446429779, 0, 0), (679, 61, 'Bình Tân', 'binh-tan', 1, 1, 1446429779, 0, 0), (680, 61, 'Bình Minh', 'binh-minh', 1, 1, 1446429779, 0, 0), (681, 61, 'Long Hồ', 'long-ho', 1, 1, 1446429779, 0, 0), (682, 61, 'Mang Thít', 'mang-thit', 1, 1, 1446429779, 0, 0), (683, 61, 'Tam Bình', 'tam-binh', 1, 1, 1446429779, 0, 0), (684, 61, 'Trà Ôn', 'tra-on', 1, 1, 1446429779, 0, 0), (685, 61, 'Vĩnh Long', 'vinh-long', 1, 1, 1446429779, 0, 0), (686, 61, 'Vũng Liêm', 'vung-liem', 1, 1, 1446429779, 0, 0), (687, 62, 'Bình Xuyên', 'binh-xuyen', 1, 1, 1446429779, 0, 0), (688, 62, 'Lập Thạch', 'lap-thach', 1, 1, 1446429779, 0, 0), (689, 62, 'Phúc Yên', 'phuc-yen', 1, 1, 1446429779, 0, 0), (690, 62, 'Sông Lô', 'song-lo', 1, 1, 1446429779, 0, 0), (691, 62, 'Tam Dương', 'tam-duong', 1, 1, 1446429779, 0, 0), (692, 62, 'Tam Đảo', 'tam-dao', 1, 1, 1446429779, 0, 0), (693, 62, 'Vĩnh Tường', 'vinh-tuong', 1, 1, 1446429779, 0, 0), (694, 62, 'Vĩnh Yên', 'vinh-yen', 1, 1, 1446429779, 0, 0), (695, 62, 'Yên Lạc', 'yen-lac', 1, 1, 1446429779, 0, 0), (696, 63, 'Lục Yên', 'luc-yen', 1, 1, 1446429779, 0, 0), (697, 63, 'Mù Cang Chải', 'mu-cang-chai', 1, 1, 1446429779, 0, 0), (698, 63, 'Văn Chấn', 'van-chan', 1, 1, 1446429779, 0, 0), (699, 63, 'Nghĩa Lộ', 'nghia-lo', 1, 1, 1446429779, 0, 0), (700, 63, 'Trấn Yên', 'tran-yen', 1, 1, 1446429779, 0, 0), (701, 63, 'Trạm Tấu', 'tram-tau', 1, 1, 1446429779, 0, 0), (702, 63, 'Văn Yên', 'van-yen', 1, 1, 1446429779, 0, 0), (703, 63, 'Yên Bái', 'yen-bai', 1, 1, 1446429779, 0, 0), (704, 63, 'Yên Bình', 'yen-binh', 1, 1, 1446429779, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `table_product` -- CREATE TABLE `table_product` ( `id` int(10) UNSIGNED NOT NULL, `id_danhmuc` int(11) NOT NULL, `id_list` int(11) NOT NULL, `id_item` int(10) NOT NULL, `id_cat` int(11) NOT NULL, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `noibat` tinyint(4) NOT NULL, `tieubieu` tinyint(4) NOT NULL, `spmoi` int(11) NOT NULL, `spbanchay` tinyint(4) NOT NULL, `photo` varchar(225) NOT NULL, `thumb` varchar(225) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `ten` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tenen` varchar(255) NOT NULL, `tencn` varchar(255) NOT NULL, `mota` text NOT NULL, `motaen` text NOT NULL, `motacn` text NOT NULL, `mota2` text NOT NULL, `mota2en` text NOT NULL, `mota2cn` text NOT NULL, `ten2` varchar(255) NOT NULL, `ten2en` varchar(255) NOT NULL, `ten2cn` varchar(255) NOT NULL, `noidung` text NOT NULL, `noidungen` text NOT NULL, `noidungcn` text NOT NULL, `masp` varchar(100) NOT NULL, `gia` bigint(100) NOT NULL, `giakm` int(100) NOT NULL, `luotxem` int(11) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `type` varchar(255) NOT NULL, `soluong` int(11) NOT NULL, `tag` text NOT NULL, `size` varchar(200) NOT NULL, `size2` varchar(200) NOT NULL, `mausac2` varchar(200) NOT NULL, `mausac` varchar(200) NOT NULL, `ngaytao` int(11) NOT NULL, `ngaysua` int(11) NOT NULL, `title` varchar(100) NOT NULL, `keywords` varchar(1000) NOT NULL, `description` varchar(200) NOT NULL, `h3` varchar(200) NOT NULL, `h2` varchar(200) NOT NULL, `h1` varchar(200) NOT NULL, `thuonghieu` int(11) NOT NULL, `id_nhasanxuat` int(11) NOT NULL, `dientich` varchar(255) NOT NULL, `id_huong` int(11) NOT NULL, `id_hientrang` int(11) NOT NULL, `phaply` varchar(255) NOT NULL, `mattien` varchar(255) NOT NULL, `id_city` int(11) NOT NULL, `id_dist` int(11) NOT NULL, `id_street` int(11) NOT NULL, `id_ward` int(11) NOT NULL, `id_thanhvien` int(11) NOT NULL, `thuoctinh` text NOT NULL, `toado` varchar(255) NOT NULL, `diachi` varchar(255) NOT NULL, `diachien` int(255) NOT NULL, `diachicn` varchar(255) NOT NULL, `vitri` text NOT NULL, `vitrien` text NOT NULL, `matbang` text NOT NULL, `matbangen` text NOT NULL, `tiendo` text NOT NULL, `tiendoen` text NOT NULL, `thuoctinh_danhmuc` varchar(255) NOT NULL, `thuoctinh_list` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_product` -- INSERT INTO `table_product` (`id`, `id_danhmuc`, `id_list`, `id_item`, `id_cat`, `hienthi`, `noibat`, `tieubieu`, `spmoi`, `spbanchay`, `photo`, `thumb`, `tenkhongdau`, `ten`, `tenen`, `tencn`, `mota`, `motaen`, `motacn`, `mota2`, `mota2en`, `mota2cn`, `ten2`, `ten2en`, `ten2cn`, `noidung`, `noidungen`, `noidungcn`, `masp`, `gia`, `giakm`, `luotxem`, `stt`, `type`, `soluong`, `tag`, `size`, `size2`, `mausac2`, `mausac`, `ngaytao`, `ngaysua`, `title`, `keywords`, `description`, `h3`, `h2`, `h1`, `thuonghieu`, `id_nhasanxuat`, `dientich`, `id_huong`, `id_hientrang`, `phaply`, `mattien`, `id_city`, `id_dist`, `id_street`, `id_ward`, `id_thanhvien`, `thuoctinh`, `toado`, `diachi`, `diachien`, `diachicn`, `vitri`, `vitrien`, `matbang`, `matbangen`, `tiendo`, `tiendoen`, `thuoctinh_danhmuc`, `thuoctinh_list`) VALUES (315, 244, 130, 0, 0, 1, 0, 0, 0, 0, 'bep-au-2-hong-msm-1038.jpg', 'bep-au-2-hong-msm-1038-9212_600x600.jpg', 'bep-au-2-hong-berjaya', 'BẾP ÂU 2 HỌNG BERJAYA OB2', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'OB2', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592187498, 1592187830, 'BẾP ÂU 2 HỌNG BERJAYA', 'BẾP ÂU 2 HỌNG BERJAYA', 'BẾP ÂU 2 HỌNG BERJAYA', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (316, 244, 130, 0, 0, 1, 0, 0, 0, 0, 'bep-au-4-berjaya-co-chan-berjaya-toanphatcorp15513238211088-2795.jpg', 'bep-au-4-berjaya-co-chan-berjaya-toanphatcorp15513238211088-2795-9467_600x600.jpg', 'bep-au-2-hong-berjaya', 'BẾP ÂU 2 HỌNG BERJAYA OB4FS', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'OB4FS', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592187616, 1592187659, 'BẾP ÂU 2 HỌNG BERJAYA', 'BẾP ÂU 2 HỌNG BERJAYA', 'BẾP ÂU 2 HỌNG BERJAYA', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (317, 244, 130, 0, 0, 1, 0, 0, 0, 0, 'berjaya-ob-6fs-600x600-3935.jpg', 'berjaya-ob-6fs-600x600-3935-6886_600x600.jpg', 'bep-au-2-hong-berjaya-ob6sfs', 'BẾP ÂU 2 HỌNG BERJAYA OB6SFS', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'OB6SFS', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592187720, 1592187793, 'BẾP ÂU 2 HỌNG BERJAYA OB6SFS', 'BẾP ÂU 2 HỌNG BERJAYA OB6SFS', 'BẾP ÂU 2 HỌNG BERJAYA OB6SFS', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (318, 244, 130, 0, 0, 1, 0, 0, 0, 0, 'bep-au-4-berjaya-toanphatcorp1548306255263-1191.jpg', 'bep-au-4-berjaya-toanphatcorp1548306255263-1191-3485_600x600.jpg', 'bep-au-2-hong-berjaya-ob4', 'BẾP ÂU 2 HỌNG BERJAYA OB4', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'OB4', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592187884, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (319, 244, 130, 0, 0, 1, 0, 0, 0, 0, 'bep-au-2-hong-berjaya-ob2fs-2018-01-27-08-50-05-3576.jpg', 'bep-au-2-hong-berjaya-ob2fs-2018-01-27-08-50-05-3576-3849_600x600.jpg', 'bep-au-2-hong-berjaya-ob2fs', 'BẾP ÂU 2 HỌNG BERJAYA OB2FS', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'OB2FS', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592187961, 1592188010, 'BẾP ÂU 2 HỌNG BERJAYA OB2FS', 'BẾP ÂU 2 HỌNG BERJAYA OB2FS', 'BẾP ÂU 2 HỌNG BERJAYA OB2FS', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (320, 244, 130, 0, 0, 1, 0, 0, 0, 0, 'bep-au-co-lo-nuong-co-go-dro4h-berjaya-toanphatcorp154873212362-5998.jpg', 'bep-au-co-lo-nuong-co-go-dro4h-berjaya-toanphatcorp154873212362-5998-2385_600x600.jpg', 'bep-au-4-hong-co-lo-nuong-berjaya-dro4h', 'BẾP ÂU 4 HỌNG CÓ LÒ NƯỚNG BERJAYA DRO4H', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'DRO4H', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592188064, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (321, 244, 130, 0, 0, 1, 0, 0, 0, 0, 'bep-au-sau-co-lo-nuong-berjaya-9561.png', 'bep-au-sau-co-lo-nuong-berjaya-9561-8571_600x600.png', 'bep-au-6-hong-co-lo-nuong-berjaya-dro6h', 'BẾP ÂU 6 HỌNG CÓ LÒ NƯỚNG BERJAYA DRO6H', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'DRO6H', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592188133, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (322, 244, 130, 0, 0, 1, 0, 0, 0, 0, 'bep-au-4-co-lo-nuong-berjaya-toanphatcorp15513252211094-6469.jpg', 'bep-au-4-co-lo-nuong-berjaya-toanphatcorp15513252211094-6469-9267_600x600.jpg', 'bep-au-4-hong-co-lo-nuong-berjaya-dro4l', 'BẾP ÂU 4 HỌNG CÓ LÒ NƯỚNG BERJAYA DRO4L', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'DRO4L', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592188202, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (323, 244, 129, 0, 0, 1, 0, 0, 0, 0, 'unnamed-1389.jpg', 'unnamed-1389-5770_600x600.jpg', 'bep-ham-than-da-co-gay', 'BẾP HẦM THAN ĐÁ CÓ GÁY', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592188330, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (324, 244, 129, 0, 0, 1, 0, 0, 0, 0, 'bep-ham-than-da-khong-gay-3610.jpg', 'bep-ham-than-da-khong-gay-3610-3749_600x600.jpg', 'bep-ham-than-da-khong-gay', 'BẾP HẦM THAN ĐÁ KHÔNG GÁY', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592188390, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (325, 244, 129, 0, 0, 1, 0, 0, 0, 0, 'c61f315c509509f97938fb4975df3dc3-2349.jpg', 'c61f315c509509f97938fb4975df3dc3-2349-4720_600x600.jpg', 'bep-kieng-to-4-hong-co-ke-duoi', 'BẾP KIỀNG TÔ 4 HỌNG CÓ KỆ DƯỚI', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592188449, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (326, 244, 129, 0, 0, 1, 0, 0, 0, 0, 'bep-ham-don-khong-gay-1-733.jpg', 'bep-ham-don-khong-gay-1-733-8508_600x600.jpg', 'bep-ham-don-khong-gay', 'BẾP HÂM ĐƠN KHÔNG GÁY', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592188514, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (327, 244, 129, 0, 0, 1, 0, 0, 0, 0, 'bep-a-doi-kieng-to-noi-644.jpg', 'bep-a-doi-kieng-to-noi-644-7139_600x600.jpg', 'bep-doi-kieng-to-noi', 'BẾP ĐÔI KIỀNG TÔ NỔI', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592188556, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (328, 244, 129, 0, 0, 1, 0, 0, 0, 0, 'unnamed-1-3176.jpg', 'unnamed-1-3176-8239_600x600.jpg', 'bep-a-don-co-quat-thoi-co-voi-nuoc', 'Bếp á đơn có quạt thôi có vòi nước ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592188852, 0, 'Bếp á đơn có quạt thôi có vòi nước ', 'Bếp á đơn có quạt thôi có vòi nước ', 'Bếp á đơn có quạt thôi có vòi nước ', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (329, 244, 129, 0, 0, 1, 0, 0, 0, 0, 'bep-a-1-hong-kieng-to-2-6573.jpg', 'bep-a-1-hong-kieng-to-2-6573-0334_600x600.jpg', 'bep-a-1-hong', 'Bếp á 1 họng', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592188916, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (330, 244, 129, 0, 0, 1, 0, 0, 0, 0, 'bep-a-3-hong-2-voi-nuoc-1903.jpg', 'bep-a-3-hong-2-voi-nuoc-1903-5528_600x600.jpg', 'bep-a-3-hong-2-voi-nuoc', 'Bếp Á 3 họng 2 vòi nước', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592188959, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (331, 245, 131, 0, 0, 1, 0, 0, 0, 0, 'tu-lanh-cong-nghiep-berjaya-7489.jpg', 'tu-lanh-cong-nghiep-berjaya-7489-7816_600x600.jpg', 'tu-mat-06-canh-berjaya-malaysia', 'TỦ MÁT 06 CÁNH BERJAYA (MALAYSIA)', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592189066, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (332, 245, 131, 0, 0, 1, 0, 0, 0, 0, 'tu-mat-4-canh-berjaya-toanphatcorp1548301696211-6691.jpg', 'tu-mat-4-canh-berjaya-toanphatcorp1548301696211-6691-2477_600x600.jpg', 'tu-mat-04-canh-berjaya-malaysia', 'TỦ MÁT 04 CÁNH BERJAYA (MALAYSIA)', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592189119, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (333, 244, 129, 0, 0, 1, 0, 0, 0, 0, 'tu-mat-2-canh-berjaya-toanphatcorp1548663221771-2825.jpg', 'tu-mat-2-canh-berjaya-toanphatcorp1548663221771-2825-6677_600x600.jpg', 'tu-mat-02-canh-berjaya-malaysia', 'TỦ MÁT 02 CÁNH BERJAYA (MALAYSIA)', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 5, 1, 'san-pham', 0, '', '', '', '', '', 1592189158, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (334, 245, 131, 0, 0, 1, 0, 0, 0, 0, 'green-1400-8596.jpg', 'green-1400-8596-7732_600x600.jpg', 'tu-mat-2-canh-berjaya', 'TỦ MÁT 2 CÁNH BERJAYA ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592189394, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (335, 245, 131, 0, 0, 1, 0, 0, 0, 0, 'berjaya-display-chiller-500x500-5453.jpg', 'berjaya-display-chiller-500x500-5453-8744_600x600.jpg', 'tu-mat-1-canh-berjaya', 'TỦ MÁT 1 CÁNH BERJAYA', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592189408, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (336, 245, 132, 0, 0, 1, 0, 0, 0, 0, 'bs2dc4z-3595.jpg', 'bs2dc4z-3595-0898_600x600.jpg', 'ban-mat-nam-ngang', 'BÀN MÁT NẰM NGANG', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592189655, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (337, 245, 132, 0, 0, 1, 0, 0, 0, 0, 'ban-mat-canh-inox-600x600-7960.jpg', 'ban-mat-canh-inox-600x600-7960-0723_600x600.jpg', 'ban-mat-canh-inox-co-gay', 'Bàn mát cánh inox có gáy', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592189717, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (338, 245, 132, 0, 0, 1, 0, 0, 0, 0, 'unnamed-2-360.jpg', 'unnamed-2-360-8929_600x600.jpg', 'ban-mat-cua-kinh-nam', 'BÀN MÁT CỬA KÍNH NẰM', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592189774, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (339, 245, 132, 0, 0, 1, 0, 0, 0, 0, 'ban-dong-3-canh-thai-lan-pc21500-cl-pk-intertrade-toanphatcorp1548750840752-7163.jpg', 'ban-dong-3-canh-thai-lan-pc21500-cl-pk-intertrade-toanphatcorp1548750840752-7163-6880_600x600.jpg', 'ban-mat-3-canh-thai-lan', 'BÀN MÁT 3 CÁNH THÁI LAN', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592189876, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (340, 248, 148, 0, 0, 1, 0, 0, 0, 0, 'unnamed-3-3016.jpg', 'unnamed-3-3016-1196_600x600.jpg', 'may-xay-sinh-to-fb', 'Máy xay sinh tố F&B', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592190194, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (341, 248, 149, 0, 0, 1, 0, 0, 0, 0, '597daef6aa6081501409014-8495.png', '597daef6aa6081501409014-8495-7839_600x600.png', 'tu-nau-nuoc-nong-cong-nghiep', 'Tủ Nấu Nước Nóng Công Nghiệp', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592190277, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (342, 248, 152, 0, 0, 1, 0, 0, 0, 0, 'hd-108-1-987.jpg', 'hd-108-1-987-4192_600x600.jpg', 'may-bao-da', 'MÁY BÀO ĐÁ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592190353, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''), (343, 248, 152, 0, 0, 1, 0, 0, 0, 0, '7b1cf2b0502852a462fab10ce9375ab6-3420.jpg', '7b1cf2b0502852a462fab10ce9375ab6-3420-8827_600x600.jpg', 'may-bao-da', 'MÁY BÀO ĐÁ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 1, 'san-pham', 0, '', '', '', '', '', 1592190781, 0, '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', 0, 0, 0, 0, 0, '', '', '', 0, '', '', '', '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_product_cat` -- CREATE TABLE `table_product_cat` ( `id` int(11) NOT NULL, `id_list` int(11) NOT NULL, `ten` varchar(255) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `photo` varchar(255) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(11) NOT NULL, `hienthi` int(11) NOT NULL, `ngaytao` int(11) NOT NULL, `ngaysua` int(11) NOT NULL, `id_danhmuc` int(11) NOT NULL, `noibat` tinyint(4) NOT NULL, `noidung` text NOT NULL, `title` varchar(100) NOT NULL, `keywords` varchar(1000) NOT NULL, `description` varchar(200) NOT NULL, `h3` varchar(200) NOT NULL, `h2` varchar(200) NOT NULL, `h1` varchar(200) NOT NULL, `tenen` varchar(255) NOT NULL, `noidungen` text NOT NULL, `type` varchar(255) NOT NULL, `mota` text NOT NULL, `motaen` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `table_product_danhmuc` -- CREATE TABLE `table_product_danhmuc` ( `id` int(11) NOT NULL, `keywords` varchar(1000) NOT NULL, `description` varchar(200) NOT NULL, `h3` varchar(200) NOT NULL, `h2` varchar(200) NOT NULL, `h1` varchar(200) NOT NULL, `ten` varchar(255) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `photo` varchar(255) NOT NULL, `thumb` varchar(255) NOT NULL, `photo2` varchar(255) NOT NULL, `thumb2` varchar(255) NOT NULL, `stt` int(11) NOT NULL, `hienthi` int(11) NOT NULL, `ngaytao` int(11) NOT NULL, `ngaysua` int(11) NOT NULL, `title` varchar(100) NOT NULL, `noibat` tinyint(4) NOT NULL, `tieubieu` tinyint(4) NOT NULL, `noidung` text NOT NULL, `tenen` varchar(255) NOT NULL, `noidungen` text NOT NULL, `type` varchar(255) NOT NULL, `mota` text NOT NULL, `motaen` text NOT NULL, `tencn` varchar(255) NOT NULL, `motacn` text NOT NULL, `noidungcn` text NOT NULL, `maunen` varchar(20) NOT NULL, `loc1` varchar(255) NOT NULL, `loc2` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_product_danhmuc` -- INSERT INTO `table_product_danhmuc` (`id`, `keywords`, `description`, `h3`, `h2`, `h1`, `ten`, `tenkhongdau`, `photo`, `thumb`, `photo2`, `thumb2`, `stt`, `hienthi`, `ngaytao`, `ngaysua`, `title`, `noibat`, `tieubieu`, `noidung`, `tenen`, `noidungen`, `type`, `mota`, `motaen`, `tencn`, `motacn`, `noidungcn`, `maunen`, `loc1`, `loc2`) VALUES (244, 'THIẾT BỊ ÂU Á', 'THIẾT BỊ ÂU Á', '', '', '', 'THIẾT BỊ ÂU Á', 'thiet-bi-au-a', '1-9116.png', '1-9116-8561_300x300.png', '', '', 1, 1, 1591939115, 1591979259, 'THIẾT BỊ ÂU Á', 0, 0, '', '', '', 'san-pham', '', '', '', '', '', '', '', ''), (245, 'THIẾT BỊ LẠNH', 'THIẾT BỊ LẠNH', '', '', '', 'THIẾT BỊ LẠNH', 'thiet-bi-lanh', '6-725.png', '6-725-7797_300x300.png', '', '', 2, 1, 1591939132, 1591979189, 'THIẾT BỊ LẠNH', 0, 0, '', '', '', 'san-pham', '', '', '', '', '', '', '', ''), (246, 'THIẾT BỊ SƠ CHẾ', 'THIẾT BỊ SƠ CHẾ', '', '', '', 'THIẾT BỊ SƠ CHẾ', 'thiet-bi-so-che', '8-2152.png', '8-2152-0305_300x300.png', '', '', 3, 1, 1591939143, 1591979770, 'THIẾT BỊ SƠ CHẾ', 0, 0, '', '', '', 'san-pham', '', '', '', '', '', '', '', ''), (247, 'THIẾT BỊ RỬA CHÉN LY', 'THIẾT BỊ RỬA CHÉN LY', '', '', '', 'THIẾT BỊ RỬA CHÉN LY', 'thiet-bi-rua-chen-ly', '7-7797.png', '7-7797-7067_300x300.png', '', '', 4, 1, 1591939152, 1591979638, 'THIẾT BỊ RỬA CHÉN LY', 0, 0, '', '', '', 'san-pham', '', '', '', '', '', '', '', ''), (248, 'THIẾT BỊ F & B', 'THIẾT BỊ F & B', '', '', '', 'THIẾT BỊ F & B', 'thiet-bi-f-b', '3-8394.png', '3-8394-1388_300x300.png', '', '', 5, 1, 1591939162, 1591979355, 'THIẾT BỊ F & B', 0, 0, '', '', '', 'san-pham', '', '', '', '', '', '', '', ''), (249, 'THIẾT BỊ TRƯNG BÀY', 'THIẾT BỊ TRƯNG BÀY', '', '', '', 'THIẾT BỊ TRƯNG BÀY', 'thiet-bi-trung-bay', '5-2164.png', '5-2164-7506_300x300.png', '', '', 6, 1, 1591939171, 1591979409, 'THIẾT BỊ TRƯNG BÀY', 0, 0, '', '', '', 'san-pham', '', '', '', '', '', '', '', ''), (250, 'THIẾT BỊ LÀM ĐÁ', 'THIẾT BỊ LÀM ĐÁ', '', '', '', 'THIẾT BỊ LÀM ĐÁ', 'thiet-bi-lam-da', '4-1574.png', '4-1574-9697_300x300.png', '', '', 7, 1, 1591939180, 1591979379, 'THIẾT BỊ LÀM ĐÁ', 0, 0, '', '', '', 'san-pham', '', '', '', '', '', '', '', ''), (251, 'THIẾT BỊ LÀM BÁNH', 'THIẾT BỊ LÀM BÁNH', '', '', '', 'THIẾT BỊ LÀM BÁNH', 'thiet-bi-lam-banh', '11-4285.png', '11-4285-8434_300x300.png', '', '', 8, 1, 1591939205, 1591980215, 'THIẾT BỊ LÀM BÁNH', 0, 0, '', '', '', 'san-pham', '', '', '', '', '', '', '', ''), (252, 'THIẾT BỊ GIẶT ỦI', 'THIẾT BỊ GIẶT ỦI', '', '', '', 'THIẾT BỊ GIẶT ỦI', 'thiet-bi-giat-ui', '9-1069.png', '9-1069-5871_300x300.png', '', '', 9, 1, 1591939214, 1591979935, 'THIẾT BỊ GIẶT ỦI', 0, 0, '', '', '', 'san-pham', '', '', '', '', '', '', '', ''), (253, 'THIẾT BỊ INOX', 'THIẾT BỊ INOX', '', '', '', 'THIẾT BỊ INOX', 'thiet-bi-inox', '2-1880.png', '2-1880-1961_300x300.png', '', '', 10, 1, 1591939227, 1591979316, 'THIẾT BỊ INOX', 0, 0, '', '', '', 'san-pham', '', '', '', '', '', '', '', ''), (254, 'LINH PHỤ KIỆN', 'LINH PHỤ KIỆN', '', '', '', 'LINH PHỤ KIỆN', 'linh-phu-kien', '10-4091.png', '10-4091-1857_300x300.png', '', '', 11, 1, 1591939236, 1591980015, 'LINH PHỤ KIỆN', 0, 0, '', '', '', 'san-pham', '', '', '', '', '', '', '', ''), (255, 'HÓA CHẤT TẨY RỬA', 'HÓA CHẤT TẨY RỬA', '', '', '', 'HÓA CHẤT TẨY RỬA', 'hoa-chat-tay-rua', '12-8898.png', '12-8898-9064_300x300.png', '', '', 12, 1, 1591939244, 1591980338, 'HÓA CHẤT TẨY RỬA', 0, 0, '', '', '', 'san-pham', '', '', '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_product_item` -- CREATE TABLE `table_product_item` ( `id` int(10) UNSIGNED NOT NULL, `id_list` int(11) NOT NULL, `id_cat` int(10) NOT NULL, `ten` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tenkhongdau` varchar(255) COLLATE latin1_general_ci NOT NULL, `photo` varchar(20) COLLATE latin1_general_ci NOT NULL, `thumb` varchar(255) COLLATE latin1_general_ci NOT NULL, `stt` int(2) NOT NULL, `hienthi` int(2) NOT NULL, `ngaysua` int(10) NOT NULL, `ngaytao` int(10) NOT NULL, `id_danhmuc` int(11) NOT NULL, `tenen` varchar(255) CHARACTER SET utf8 NOT NULL, `noidung` text CHARACTER SET utf8 NOT NULL, `noidungen` text CHARACTER SET utf8 NOT NULL, `type` varchar(255) COLLATE latin1_general_ci NOT NULL, `mota` text COLLATE latin1_general_ci NOT NULL, `motaen` text COLLATE latin1_general_ci NOT NULL, `noibat` int(11) NOT NULL, `keywords` text COLLATE latin1_general_ci NOT NULL, `title` text COLLATE latin1_general_ci NOT NULL, `description` text COLLATE latin1_general_ci NOT NULL, `h3` varchar(200) COLLATE latin1_general_ci NOT NULL, `h2` varchar(200) COLLATE latin1_general_ci NOT NULL, `h1` varchar(200) COLLATE latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `table_product_list` -- CREATE TABLE `table_product_list` ( `id` int(11) NOT NULL, `ten` varchar(255) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `photo` varchar(255) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(11) NOT NULL, `hienthi` int(11) NOT NULL, `ngaytao` int(11) NOT NULL, `ngaysua` int(11) NOT NULL, `id_danhmuc` int(11) NOT NULL, `title` varchar(100) NOT NULL, `description` varchar(200) NOT NULL, `h3` varchar(200) NOT NULL, `h2` varchar(200) NOT NULL, `h1` varchar(200) NOT NULL, `keywords` varchar(1000) NOT NULL, `noibat` tinyint(4) NOT NULL, `noidung` text NOT NULL, `tenen` varchar(255) NOT NULL, `noidungen` text NOT NULL, `type` varchar(255) NOT NULL, `mota` text NOT NULL, `motaen` text NOT NULL, `tencn` varchar(255) NOT NULL, `motacn` text NOT NULL, `noidungcn` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_product_list` -- INSERT INTO `table_product_list` (`id`, `ten`, `tenkhongdau`, `photo`, `thumb`, `stt`, `hienthi`, `ngaytao`, `ngaysua`, `id_danhmuc`, `title`, `description`, `h3`, `h2`, `h1`, `keywords`, `noibat`, `noidung`, `tenen`, `noidungen`, `type`, `mota`, `motaen`, `tencn`, `motacn`, `noidungcn`) VALUES (129, 'THIẾT BỊ BẾP Á ', 'thiet-bi-bep-a', 'bep-a-don-co-quat-thoi-6263.jpg', 'bep-a-don-co-quat-thoi-6263-5319_300x300.jpg', 1, 1, 1592018323, 0, 244, 'THIẾT BỊ BẾP Á ', 'THIẾT BỊ BẾP Á ', '', '', '', 'THIẾT BỊ BẾP Á ', 0, '', '', '', 'san-pham', '', '', '', '', ''), (130, 'THIẾT BỊ BẾP ÂU', 'thiet-bi-bep-au', 'image53-2787.jpg', 'image53-2787-6867_300x300.jpg', 1, 1, 1592018489, 0, 244, 'THIẾT BỊ BẾP ÂU', 'THIẾT BỊ BẾP ÂU', '', '', '', 'THIẾT BỊ BẾP ÂU', 0, '', '', '', 'san-pham', '', '', '', '', ''), (131, 'TỦ MÁT', 'tu-mat', 'oav1490691801-8160.jpg', 'oav1490691801-8160-9910_300x300.jpg', 1, 1, 1592018533, 0, 245, 'TỦ MÁT', 'TỦ MÁT', '', '', '', 'TỦ MÁT', 0, '', '', '', 'san-pham', '', '', '', '', ''), (132, 'BÀN MÁT', 'ban-mat', 'ban-mat-berjaya-2-canh-15m-bs-2dc5c-1-3799.jpg', 'ban-mat-berjaya-2-canh-15m-bs-2dc5c-1-3799-3458_300x300.jpg', 2, 1, 1592018575, 0, 245, 'BÀN MÁT', 'BÀN MÁT', '', '', '', 'BÀN MÁT', 0, '', '', '', 'san-pham', '', '', '', '', ''), (133, 'MÁY LÀM ĐÁ VIÊN', 'may-lam-da-vien', 'may-lam-da-vien-scotsman-ac176-1-5788.jpg', 'may-lam-da-vien-scotsman-ac176-1-5788-8281_300x300.jpg', 3, 1, 1592019017, 0, 245, 'MÁY LÀM ĐÁ VIÊN', 'MÁY LÀM ĐÁ VIÊN', '', '', '', 'MÁY LÀM ĐÁ VIÊN', 0, '', '', '', 'san-pham', '', '', '', '', ''), (134, 'TỦ TRƯNG BÀY SUSHI', 'tu-trung-bay-sushi', 'unnamed-1750.jpg', 'unnamed-1750-7640_300x300.jpg', 4, 1, 1592019416, 0, 245, 'TỦ TRƯNG BÀY SUSHI', 'TỦ TRƯNG BÀY SUSHI', '', '', '', 'TỦ TRƯNG BÀY SUSHI', 0, '', '', '', 'san-pham', '', '', '', '', ''), (135, 'TỦ TRƯNG BÀY RƯỢU VANG', 'tu-trung-bay-ruou-vang', '1023vintecalv40sg2e-8850.jpg', '1023vintecalv40sg2e-8850-1643_300x300.jpg', 5, 1, 1592019482, 0, 245, 'TỦ TRƯNG BÀY RƯỢU VANG', 'TỦ TRƯNG BÀY RƯỢU VANG', '', '', '', 'TỦ TRƯNG BÀY RƯỢU VANG', 0, '', '', '', 'san-pham', '', '', '', '', ''), (136, 'TỦ TRƯNG BÀY BÁNH', 'tu-trung-bay-banh', '8-9450.jpg', '8-9450-4093_300x300.jpg', 6, 1, 1592019815, 0, 245, 'TỦ TRƯNG BÀY BÁNH', 'TỦ TRƯNG BÀY BÁNH', '', '', '', 'TỦ TRƯNG BÀY BÁNH', 0, '', '', '', 'san-pham', '', '', '', '', ''), (137, 'TỦ TRƯNG BÀY KEM', 'tu-trung-bay-kem', 'image515-9400.jpg', 'image515-9400-6830_300x300.jpg', 7, 1, 1592019891, 0, 245, 'TỦ TRƯNG BÀY KEM', 'TỦ TRƯNG BÀY KEM', '', '', '', 'TỦ TRƯNG BÀY KEM', 0, '', '', '', 'san-pham', '', '', '', '', ''), (138, 'MÁY XAY THỊT', 'may-xay-thit', 'may-xay-thit-8373.png', 'may-xay-thit-8373-4852_300x300.png', 1, 1, 1592020000, 0, 246, 'MÁY XAY THỊT', 'MÁY XAY THỊT', '', '', '', 'MÁY XAY THỊT', 0, '', '', '', 'san-pham', '', '', '', '', ''), (139, 'MÁY THÁI LÁT', 'may-thai-lat', '2336624ms-250-st-7144.jpg', '2336624ms-250-st-7144-8298_300x300.jpg', 1, 1, 1592020085, 0, 246, 'MÁY THÁI LÁT', 'MÁY THÁI LÁT', '', '', '', 'MÁY THÁI LÁT', 0, '', '', '', 'san-pham', '', '', '', '', ''), (140, 'MÁY SƠ CHẾ RAU', 'may-so-che-rau', '41hivrjzf6l-3708.jpg', '41hivrjzf6l-3708-2904_300x300.jpg', 1, 1, 1592020397, 0, 246, 'MÁY SƠ CHẾ RAU', 'MÁY SƠ CHẾ RAU', '', '', '', 'MÁY SƠ CHẾ RAU', 0, '', '', '', 'san-pham', '', '', '', '', ''), (141, 'MÁY CƯA XƯƠNG', 'may-cua-xuong', 'may-cua-xuong-inox-jg210-239.png', 'may-cua-xuong-inox-jg210-239-2067_300x300.png', 1, 1, 1592020474, 0, 246, 'MÁY CƯA XƯƠNG', 'MÁY CƯA XƯƠNG', '', '', '', 'MÁY CƯA XƯƠNG', 0, '', '', '', 'san-pham', '', '', '', '', ''), (142, 'MÁY HÚT CHÂN KHÔNG', 'may-hut-chan-khong', '43280851521445541601-7920.jpg', '43280851521445541601-7920-2151_300x300.jpg', 1, 1, 1592020513, 0, 246, 'MÁY HÚT CHÂN KHÔNG', 'MÁY HÚT CHÂN KHÔNG', '', '', '', 'MÁY HÚT CHÂN KHÔNG', 0, '', '', '', 'san-pham', '', '', '', '', ''), (143, 'TỦ DIỆT TRÙNG DAO', 'tu-diet-trung-dao', 'tu-khu-trung-uv-ozone-gia-dung-uo061471-115.jpg', 'tu-khu-trung-uv-ozone-gia-dung-uo061471-115-6085_300x300.jpg', 1, 1, 1592020593, 0, 246, 'TỦ DIỆT TRÙNG DAO', 'TỦ DIỆT TRÙNG DAO', '', '', '', 'TỦ DIỆT TRÙNG DAO', 0, '', '', '', 'san-pham', '', '', '', '', ''), (144, 'MÁY RỬA CHÉN (DẠNG HOODTYPE)', 'may-rua-chen-dang-hoodtype', 'meiko-ecostar-545d-350x350-323.gif', 'meiko-ecostar-545d-350x350-323-9489_300x300.gif', 1, 1, 1592020684, 0, 247, 'MÁY RỬA CHÉN (DẠNG HOODTYPE)', 'MÁY RỬA CHÉN (DẠNG HOODTYPE)', '', '', '', 'MÁY RỬA CHÉN (DẠNG HOODTYPE)', 0, '', '', '', 'san-pham', '', '', '', '', ''), (145, 'MÁY RỬA CHÉN (DẠNG BĂNG TẢI)', 'may-rua-chen-dang-bang-tai', 'may-rua-bat-cong-nghiep-loai-bang-tai-6654.jpg', 'may-rua-bat-cong-nghiep-loai-bang-tai-6654-7147_300x300.jpg', 1, 1, 1592020719, 0, 247, 'MÁY RỬA CHÉN (DẠNG BĂNG TẢI)', 'MÁY RỬA CHÉN (DẠNG BĂNG TẢI)', '', '', '', 'MÁY RỬA CHÉN (DẠNG BĂNG TẢI)', 0, '', '', '', 'san-pham', '', '', '', '', ''), (146, 'MÁY RỬA LY', 'may-rua-ly', 'may-rua-ly-chen-cong-nghiep-b10-ata1-145.jpg', 'may-rua-ly-chen-cong-nghiep-b10-ata1-145-1243_300x300.jpg', 1, 1, 1592020756, 0, 247, 'MÁY RỬA LY', 'MÁY RỬA LY', '', '', '', 'MÁY RỬA LY', 0, '', '', '', 'san-pham', '', '', '', '', ''), (147, 'RACK LY, CHÉN', 'rack-ly-chen', 'unnamed-1-4166.jpg', 'unnamed-1-4166-3860_300x300.jpg', 1, 1, 1592020857, 0, 247, 'RACK LY, CHÉN', 'RACK LY, CHÉN', '', '', '', 'RACK LY, CHÉN', 0, '', '', '', 'san-pham', '', '', '', '', ''), (148, 'Máy xay sinh tố', 'may-xay-sinh-to', 'nag0811-8371.jpg', 'nag0811-8371-2625_300x300.jpg', 1, 1, 1592020995, 0, 248, 'Máy xay sinh tố', 'Máy xay sinh tố', '', '', '', 'Máy xay sinh tố', 0, '', '', '', 'san-pham', '', '', '', '', ''), (149, ' Thiết bị đun sôi nước ', 'thiet-bi-dun-soi-nuoc', '20170620111540675-4999.jpg', '20170620111540675-4999-3145_300x300.jpg', 1, 1, 1592021184, 0, 248, ' Thiết bị đun sôi nước ', ' Thiết bị đun sôi nước ', '', '', '', ' Thiết bị đun sôi nước ', 0, '', '', '', 'san-pham', '', '', '', '', ''), (150, 'MÁY ÉP TRÁI CÂY', 'may-ep-trai-cay', '3-ab9acc12-6428-4dd6-8995-0cb9d7e58131-3418.jpg', '3-ab9acc12-6428-4dd6-8995-0cb9d7e58131-3418-5912_300x300.jpg', 1, 1, 1592021363, 0, 248, 'MÁY ÉP TRÁI CÂY', 'MÁY ÉP TRÁI CÂY', '', '', '', 'MÁY ÉP TRÁI CÂY', 0, '', '', '', 'san-pham', '', '', '', '', ''), (151, 'MÁY VẮT CAM', 'may-vat-cam', 'unnamed-2-363.jpg', 'unnamed-2-363-8486_300x300.jpg', 1, 1, 1592021423, 0, 248, 'MÁY VẮT CAM', 'MÁY VẮT CAM', '', '', '', 'MÁY VẮT CAM', 0, '', '', '', 'san-pham', '', '', '', '', ''), (152, 'MÁY BÀO ĐÁ ', 'may-bao-da', '4322121075c260f57883ca64f415b4da9229d831-2542.jpeg', '4322121075c260f57883ca64f415b4da9229d831-2542-1311_300x300.jpeg', 1, 1, 1592021488, 0, 248, 'MÁY BÀO ĐÁ ', 'MÁY BÀO ĐÁ ', '', '', '', 'MÁY BÀO ĐÁ ', 0, '', '', '', 'san-pham', '', '', '', '', ''), (153, 'MÁY XAY ĐÁ ', 'may-xay-da', 'unnamed-3-8719.jpg', 'unnamed-3-8719-9268_300x300.jpg', 1, 1, 1592021549, 0, 248, 'MÁY XAY ĐÁ ', 'MÁY XAY ĐÁ ', '', '', '', 'MÁY XAY ĐÁ ', 0, '', '', '', 'san-pham', '', '', '', '', ''), (154, 'LÒ NƯỚNG BÁNH', 'lo-nuong-banh', 'unnamed-8994.png', 'unnamed-8994-5498_300x300.png', 1, 1, 1592021655, 0, 251, 'LÒ NƯỚNG BÁNH', 'LÒ NƯỚNG BÁNH', '', '', '', 'LÒ NƯỚNG BÁNH', 0, '', '', '', 'san-pham', '', '', '', '', ''), (155, 'MÁY CẮT LÁT BÁNH MỲ', 'may-cat-lat-banh-my', 'may-cat-banh-my-sanwich-cm-302-8335.jpg', 'may-cat-banh-my-sanwich-cm-302-8335-7458_300x300.jpg', 1, 1, 1592021752, 0, 251, 'MÁY CẮT LÁT BÁNH MỲ', 'MÁY CẮT LÁT BÁNH MỲ', '', '', '', 'MÁY CẮT LÁT BÁNH MỲ', 0, '', '', '', 'san-pham', '', '', '', '', ''), (156, 'MÁY TRỘN BỘT', 'may-tron-bot', 'may-lam-bep-da-nang-mdimori-kitchen-machine-mdmr-8918-5466.png', 'may-lam-bep-da-nang-mdimori-kitchen-machine-mdmr-8918-5466-2863_300x300.png', 1, 1, 1592021864, 0, 251, 'MÁY TRỘN BỘT', 'MÁY TRỘN BỘT', '', '', '', 'MÁY TRỘN BỘT', 0, '', '', '', 'san-pham', '', '', '', '', ''), (157, 'LÒ NƯỚNG ĐỐI LƯU', 'lo-nuong-doi-luu', 'lo-nuong-doi-luu-3-4143.jpg', 'lo-nuong-doi-luu-3-4143-4831_300x300.jpg', 1, 1, 1592021937, 0, 251, 'LÒ NƯỚNG ĐỐI LƯU', 'LÒ NƯỚNG ĐỐI LƯU', '', '', '', 'LÒ NƯỚNG ĐỐI LƯU', 0, '', '', '', 'san-pham', '', '', '', '', ''), (158, 'LÒ NƯỚNG BÁNH PIZZA', 'lo-nuong-banh-pizza', '2bljgqsimgde2fe0500x500maxb-2548.jpg', '2bljgqsimgde2fe0500x500maxb-2548-0591_300x300.jpg', 1, 1, 1592022013, 0, 251, 'LÒ NƯỚNG BÁNH PIZZA', 'LÒ NƯỚNG BÁNH PIZZA', '', '', '', 'LÒ NƯỚNG BÁNH PIZZA', 0, '', '', '', 'san-pham', '', '', '', '', ''), (159, 'Máy giặt là có lồng đứng', 'may-giat-la-co-long-dung', 'nhung-thiet-bi-gia-dinh-khong-thieu-trong-gia-dinh-cua-ban-4534.jpg', 'nhung-thiet-bi-gia-dinh-khong-thieu-trong-gia-dinh-cua-ban-4534-2725_300x300.jpg', 1, 1, 1592022154, 0, 252, 'Máy giặt là có lồng đứng', 'Máy giặt là có lồng đứng', '', '', '', 'Máy giặt là có lồng đứng', 0, '', '', '', 'san-pham', '', '', '', '', ''), (160, 'Máy giặt là có lồng ngang', 'may-giat-la-co-long-ngang', 'uu-va-nhuoc-diem-cua-may-giat-cua-ngang-1-5094.jpg', 'uu-va-nhuoc-diem-cua-may-giat-cua-ngang-1-5094-9669_300x300.jpg', 1, 1, 1592022244, 0, 252, 'Máy giặt là có lồng ngang', 'Máy giặt là có lồng ngang', '', '', '', 'Máy giặt là có lồng ngang', 0, '', '', '', 'san-pham', '', '', '', '', ''), (161, 'Máy giặt là có lồng nghiêng', 'may-giat-la-co-long-nghieng', 'may-giat-thung-nghieng-co-tot-khong-6-600x340-1-4337.jpg', 'may-giat-thung-nghieng-co-tot-khong-6-600x340-1-4337-5760_300x300.jpg', 1, 1, 1592022333, 1592022365, 252, 'Máy giặt là có lồng nghiêng', 'Máy giặt là có lồng nghiêng', '', '', '', 'Máy giặt là có lồng nghiêng', 0, '', '', '', 'san-pham', '', '', '', '', ''), (162, 'KỆ INOX', 'ke-inox', 'ke-thanh-4-tang-1200-7180.jpg', 'ke-thanh-4-tang-1200-7180-7873_300x300.jpg', 1, 1, 1592022455, 0, 253, 'KỆ INOX', 'KỆ INOX', '', '', '', 'KỆ INOX', 0, '', '', '', 'san-pham', '', '', '', '', ''), (163, 'BÀN INOX', 'ban-inox', 'ban-khong-gay-1369.png', 'ban-khong-gay-1369-8521_300x300.png', 1, 1, 1592022486, 1592022506, 253, 'BÀN INOX', 'BÀN INOX', '', '', '', 'BÀN INOX', 0, '', '', '', 'san-pham', '', '', '', '', ''), (164, 'CHỤP HÚT KHÓI BẾP', 'chup-hut-khoi-bep', 'hut-khoi-khong-cap-gio-tuoi-3431.jpg', 'hut-khoi-khong-cap-gio-tuoi-3431-7506_300x300.jpg', 1, 1, 1592022606, 0, 253, 'CHỤP HÚT KHÓI BẾP', 'CHỤP HÚT KHÓI BẾP', '', '', '', 'CHỤP HÚT KHÓI BẾP', 0, '', '', '', 'san-pham', '', '', '', '', ''), (165, 'XE CHỞ KHAY THỨC ĂN', 'xe-cho-thuc-an', 'bi-quyet-lua-chon-xe-day-cong-nghiep-inox-chinh-hang-o-dau-o-ha-noi-278x300-2148.png', 'bi-quyet-lua-chon-xe-day-cong-nghiep-inox-chinh-hang-o-dau-o-ha-noi-278x300-2148-6188_300x300.png', 1, 1, 1592022699, 1592022750, 253, 'XE CHỞ KHAY THỨC ĂN', 'XE CHỞ KHAY THỨC ĂN', '', '', '', 'XE CHỞ KHAY THỨC ĂN', 0, '', '', '', 'san-pham', '', '', '', '', ''), (166, 'XE ĐẨY INOX', 'xe-day-inox', 'xe-day-hang-inox-304-nm-ts1nm16-304-1-5208.png', 'xe-day-hang-inox-304-nm-ts1nm16-304-1-5208-3017_300x300.png', 1, 1, 1592022789, 0, 253, 'XE ĐẨY INOX', 'XE ĐẨY INOX', '', '', '', 'XE ĐẨY INOX', 0, '', '', '', 'san-pham', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_protag` -- CREATE TABLE `table_protag` ( `id` int(10) UNSIGNED NOT NULL, `id_pro` int(10) NOT NULL, `id_tag` int(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `table_pushonesignal` -- CREATE TABLE `table_pushonesignal` ( `id` int(10) UNSIGNED NOT NULL, `stt` int(5) NOT NULL DEFAULT 1, `ten_vi` varchar(255) NOT NULL, `ten_en` varchar(255) NOT NULL, `link` varchar(255) NOT NULL, `photo_en` varchar(255) NOT NULL, `photo_vi` varchar(255) NOT NULL, `thumb_en` varchar(255) NOT NULL, `thumb_vi` varchar(255) NOT NULL, `mota_vi` text NOT NULL, `mota_en` text NOT NULL, `hienthi` int(10) NOT NULL, `ngaytao` int(11) NOT NULL, `thoigianbatdau` int(11) NOT NULL, `thoigianketthuc` int(11) NOT NULL, `gio` int(11) NOT NULL, `phut` int(11) NOT NULL, `giay` int(11) NOT NULL, `muigio` varchar(255) NOT NULL, `solangui` int(11) NOT NULL, `conlai` int(11) NOT NULL, `mathongbao` varchar(255) NOT NULL, `lichgui` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_pushonesignal` -- INSERT INTO `table_pushonesignal` (`id`, `stt`, `ten_vi`, `ten_en`, `link`, `photo_en`, `photo_vi`, `thumb_en`, `thumb_vi`, `mota_vi`, `mota_en`, `hienthi`, `ngaytao`, `thoigianbatdau`, `thoigianketthuc`, `gio`, `phut`, `giay`, `muigio`, `solangui`, `conlai`, `mathongbao`, `lichgui`) VALUES (1, 0, 'rdfas', '', '', '', '', '', '', '', '', 0, 1563766178, 1554866940, 0, 0, 0, 0, '', 1, 0, '', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_slider` -- CREATE TABLE `table_slider` ( `id` int(10) UNSIGNED NOT NULL, `photo` varchar(225) NOT NULL, `ten` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `mota` text NOT NULL, `link` varchar(255) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `thumb` varchar(255) NOT NULL, `type` varchar(100) NOT NULL, `id_slider` int(11) NOT NULL, `noibat` tinyint(4) NOT NULL, `tenen` varchar(255) NOT NULL, `motaen` text NOT NULL, `vitri` varchar(20) NOT NULL, `tencn` varchar(255) NOT NULL, `motacn` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_slider` -- INSERT INTO `table_slider` (`id`, `photo`, `ten`, `mota`, `link`, `stt`, `hienthi`, `thumb`, `type`, `id_slider`, `noibat`, `tenen`, `motaen`, `vitri`, `tencn`, `motacn`) VALUES (25, '540x560-3750.png', '', '', '', 1, 1, '540x5605763_530x550.png', 'menu', 0, 0, '', '', '', '', ''), (26, 'untitled-24-3197.jpg', '', '', '', 1, 1, 'untitled-242394_1366x390.jpg', 'slidercf', 0, 0, '', '', '', '', ''), (93, 'untitled-10006layer-10-3700.png', '', '', '', 1, 1, 'untitled-1_0006_layer-109212_150x390.png', 'letruot', 0, 0, '', '', 'left', '', ''), (94, 'untitled-10006layer-10-6073.png', '', '', '', 1, 1, 'untitled-1_0006_layer-106176_150x390.png', 'letruot', 0, 0, '', '', 'right', '', ''), (95, 'untitled-10007layer-11-8509.png', '', '', '', 1, 1, 'untitled-1_0007_layer-114973_150x390.png', 'letruot', 0, 0, '', '', 'left', '', ''), (96, 'untitled-10007layer-11-6770.png', '', '', '', 1, 1, 'untitled-1_0007_layer-112768_150x390.png', 'letruot', 0, 0, '', '', 'right', '', ''), (225, '1-9002.png', '1', '', '', 1, 1, '1-9002-0040_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (226, '630x355-8811.png', '2', '', '', 1, 1, '630x355-8811-3853_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (227, '120617064812-9047.png', '3', '', '', 1, 1, '120617064812-9047-5210_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (228, '1565594080947-hotel-logo-1-3222.png', '4', '', '', 1, 1, '1565594080947-hotel-logo-1-3222-2979_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (229, 'lemeridienlogo-1934.png', '5', '', '', 1, 1, 'lemeridienlogo-1934-2372_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (230, 'foody-paris-deli-beach-hotel-706995-542-636484598082448804-6754.png', '6', '', '', 1, 1, 'foody-paris-deli-beach-hotel-706995-542-636484598082448804-6754-3587_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (231, 'logolibertycentralnhatrang-08-2951.png', '7', '', '', 1, 1, 'logolibertycentralnhatrang-08-2951-3643_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (232, 'logocara-9185.png', '8', '', '', 1, 1, 'logocara-9185-5140_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (233, 'logo-fagor-5288.png', '9', '', '', 1, 1, 'logo-fagor-5288-6454_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (234, 'logo-vinpearl-2830.png', '10', '', '', 1, 1, 'logo-vinpearl-2830-8991_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (235, 'xdongkhanh0-7863.png', '11', '', '', 1, 1, 'xdongkhanh0-7863-7732_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (236, 'unnamed-1-3145.png', '12', '', '', 1, 1, 'unnamed-1-3145-9639_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (237, 'the-reverie-logo-6649.png', '13', '', '', 1, 1, 'the-reverie-logo-6649-8610_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (238, 'sirman-banner-7478.png', '14', '', '', 1, 1, 'sirman-banner-7478-1235_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (239, 'sheraton-hotels-resorts-vector-logo-2999.png', '15', '', '', 1, 1, 'sheraton-hotels-resorts-vector-logo-2999-3589_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (240, 'saigonsoul-newworld-3326.png', '16', '', '', 1, 1, 'saigonsoul-newworld-3326-7576_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (241, 'renaissance-1965.png', '17', '', '', 1, 1, 'renaissance-1965-8552_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (242, 'lottehotelsresortslogo-806.png', '18', '', '', 1, 1, 'lottehotelsresortslogo-806-1592_200x200.png', 'doi-tac', 0, 0, '', '', '', '', ''), (243, '11-2044.png', '2', '', '', 3, 1, '11-2044-9757_1366x660.png', 'slider', 0, 0, '', '', '', '', ''), (244, '222-7186.png', '3', '', '', 2, 1, '222-7186-9511_1366x660.png', 'slider', 0, 0, '', '', '', '', ''), (245, '333-8601.png', '4', '', '', 1, 1, '333-8601-6419_1366x660.png', 'slider', 0, 0, '', '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_tags` -- CREATE TABLE `table_tags` ( `id` int(10) UNSIGNED NOT NULL, `ten` varchar(225) CHARACTER SET utf8 NOT NULL, `type` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT 'product', `id_danhmuc` int(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `table_tinhtrang` -- CREATE TABLE `table_tinhtrang` ( `id` int(11) NOT NULL, `trangthai` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_tinhtrang` -- INSERT INTO `table_tinhtrang` (`id`, `trangthai`) VALUES (1, 'Mới đặt'), (2, 'Đã xác nhận'), (3, 'Đang giao hàng'), (4, 'Đã giao'), (5, 'Đã hủy'); -- -------------------------------------------------------- -- -- Table structure for table `table_title` -- CREATE TABLE `table_title` ( `id` int(10) NOT NULL, `type` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `keywords` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `ngaytao` int(11) NOT NULL DEFAULT 0, `ngaysua` int(11) NOT NULL DEFAULT 0, `photo` varchar(255) DEFAULT NULL, `thumb` varchar(255) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `table_user` -- CREATE TABLE `table_user` ( `id` int(10) UNSIGNED NOT NULL, `username` varchar(225) NOT NULL, `password` varchar(225) NOT NULL, `ten` varchar(225) NOT NULL, `dienthoai` varchar(225) NOT NULL, `email` varchar(225) NOT NULL, `diachi` varchar(225) NOT NULL, `sex` tinyint(1) NOT NULL DEFAULT 0, `nick_yahoo` varchar(225) NOT NULL, `nick_skype` varchar(225) NOT NULL, `congty` varchar(225) NOT NULL, `country` varchar(225) NOT NULL, `city` varchar(225) NOT NULL, `role` tinyint(3) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `com` varchar(225) NOT NULL DEFAULT 'user', `quyen` varchar(255) NOT NULL, `ngaysinh` int(11) NOT NULL, `gioitinh` varchar(10) NOT NULL, `ngaytao` int(11) NOT NULL, `ngaysua` int(11) NOT NULL, `active` tinyint(4) NOT NULL DEFAULT 1, `nhom` int(11) NOT NULL, `id_facebook` varchar(100) NOT NULL, `id_google` varchar(100) NOT NULL, `stt` int(11) NOT NULL DEFAULT 1, `ho` varchar(255) NOT NULL, `quoctich` varchar(255) NOT NULL, `didong` varchar(255) NOT NULL, `curjob` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `table_user` -- INSERT INTO `table_user` (`id`, `username`, `password`, `ten`, `dienthoai`, `email`, `diachi`, `sex`, `nick_yahoo`, `nick_skype`, `congty`, `country`, `city`, `role`, `hienthi`, `com`, `quyen`, `ngaysinh`, `gioitinh`, `ngaytao`, `ngaysua`, `active`, `nhom`, `id_facebook`, `id_google`, `stt`, `ho`, `quoctich`, `didong`, `curjob`) VALUES (3, 'admin', 'bd49f9c4f0c03abb27c0d3309ebcb16e', '', '', '', '', 0, '', '', '', '', '', 3, 1, 'admin', '', 0, '', 0, 0, 1, 0, '', '', 1, '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `table_video` -- CREATE TABLE `table_video` ( `id` int(10) UNSIGNED NOT NULL, `noibat` tinyint(4) NOT NULL, `ten` varchar(225) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `photo` varchar(100) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `ngaytao` int(10) UNSIGNED NOT NULL DEFAULT 0, `ngaysua` int(10) UNSIGNED NOT NULL DEFAULT 0, `link` varchar(255) NOT NULL, `tenen` varchar(255) NOT NULL, `type` varchar(100) NOT NULL, `tencn` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `table_vnexpress` -- CREATE TABLE `table_vnexpress` ( `id` int(10) UNSIGNED NOT NULL, `id_item` int(11) NOT NULL, `noibat` tinyint(4) NOT NULL, `ten` varchar(225) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `mota` text NOT NULL, `noidung` text NOT NULL, `photo` varchar(100) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `ngaytao` int(10) UNSIGNED NOT NULL DEFAULT 0, `ngaysua` int(10) UNSIGNED NOT NULL DEFAULT 0, `title` varchar(100) NOT NULL, `keywords` varchar(1000) NOT NULL, `description` varchar(200) NOT NULL, `tenen` varchar(255) NOT NULL, `motaen` text NOT NULL, `noidungen` text NOT NULL, `type` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `table_yahoo` -- CREATE TABLE `table_yahoo` ( `id` int(10) UNSIGNED NOT NULL, `noibat` tinyint(4) NOT NULL, `ten` varchar(225) NOT NULL, `tenkhongdau` varchar(255) NOT NULL, `photo` varchar(100) NOT NULL, `thumb` varchar(255) NOT NULL, `stt` int(10) UNSIGNED NOT NULL DEFAULT 1, `hienthi` tinyint(1) NOT NULL DEFAULT 1, `ngaytao` int(10) UNSIGNED NOT NULL DEFAULT 0, `ngaysua` int(10) UNSIGNED NOT NULL DEFAULT 0, `yahoo` varchar(50) NOT NULL, `skype` varchar(50) NOT NULL, `dienthoai` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `tenen` varchar(255) NOT NULL, `type` varchar(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Indexes for dumped tables -- -- -- Indexes for table `counter` -- ALTER TABLE `counter` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_about` -- ALTER TABLE `table_about` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_anhnen` -- ALTER TABLE `table_anhnen` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_background` -- ALTER TABLE `table_background` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_chitietdonhang` -- ALTER TABLE `table_chitietdonhang` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_com` -- ALTER TABLE `table_com` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_comment` -- ALTER TABLE `table_comment` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_company` -- ALTER TABLE `table_company` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_com_quyen` -- ALTER TABLE `table_com_quyen` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_danhgiasao` -- ALTER TABLE `table_danhgiasao` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_donhang` -- ALTER TABLE `table_donhang` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_hinhanh` -- ALTER TABLE `table_hinhanh` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_hinhthucgiaohang` -- ALTER TABLE `table_hinhthucgiaohang` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_httt` -- ALTER TABLE `table_httt` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_lienhe` -- ALTER TABLE `table_lienhe` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_lkweb` -- ALTER TABLE `table_lkweb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_news` -- ALTER TABLE `table_news` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_newsletter` -- ALTER TABLE `table_newsletter` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_news_cat` -- ALTER TABLE `table_news_cat` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_news_danhmuc` -- ALTER TABLE `table_news_danhmuc` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_news_item` -- ALTER TABLE `table_news_item` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_news_list` -- ALTER TABLE `table_news_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_online` -- ALTER TABLE `table_online` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_phanquyen` -- ALTER TABLE `table_phanquyen` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_place_city` -- ALTER TABLE `table_place_city` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_place_dist` -- ALTER TABLE `table_place_dist` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_product` -- ALTER TABLE `table_product` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_product_cat` -- ALTER TABLE `table_product_cat` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_product_danhmuc` -- ALTER TABLE `table_product_danhmuc` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_product_item` -- ALTER TABLE `table_product_item` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_product_list` -- ALTER TABLE `table_product_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_protag` -- ALTER TABLE `table_protag` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_pushonesignal` -- ALTER TABLE `table_pushonesignal` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_slider` -- ALTER TABLE `table_slider` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_tags` -- ALTER TABLE `table_tags` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_tinhtrang` -- ALTER TABLE `table_tinhtrang` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_title` -- ALTER TABLE `table_title` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_user` -- ALTER TABLE `table_user` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_video` -- ALTER TABLE `table_video` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_vnexpress` -- ALTER TABLE `table_vnexpress` ADD PRIMARY KEY (`id`); -- -- Indexes for table `table_yahoo` -- ALTER TABLE `table_yahoo` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `counter` -- ALTER TABLE `counter` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1196; -- -- AUTO_INCREMENT for table `table_about` -- ALTER TABLE `table_about` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `table_anhnen` -- ALTER TABLE `table_anhnen` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `table_background` -- ALTER TABLE `table_background` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `table_chitietdonhang` -- ALTER TABLE `table_chitietdonhang` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `table_com` -- ALTER TABLE `table_com` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36; -- -- AUTO_INCREMENT for table `table_comment` -- ALTER TABLE `table_comment` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `table_company` -- ALTER TABLE `table_company` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `table_com_quyen` -- ALTER TABLE `table_com_quyen` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46; -- -- AUTO_INCREMENT for table `table_danhgiasao` -- ALTER TABLE `table_danhgiasao` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `table_donhang` -- ALTER TABLE `table_donhang` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `table_hinhanh` -- ALTER TABLE `table_hinhanh` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=832; -- -- AUTO_INCREMENT for table `table_hinhthucgiaohang` -- ALTER TABLE `table_hinhthucgiaohang` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `table_httt` -- ALTER TABLE `table_httt` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `table_lienhe` -- ALTER TABLE `table_lienhe` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `table_lkweb` -- ALTER TABLE `table_lkweb` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44; -- -- AUTO_INCREMENT for table `table_news` -- ALTER TABLE `table_news` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=937; -- -- AUTO_INCREMENT for table `table_newsletter` -- ALTER TABLE `table_newsletter` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `table_news_cat` -- ALTER TABLE `table_news_cat` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `table_news_danhmuc` -- ALTER TABLE `table_news_danhmuc` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75; -- -- AUTO_INCREMENT for table `table_news_item` -- ALTER TABLE `table_news_item` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `table_news_list` -- ALTER TABLE `table_news_list` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `table_online` -- ALTER TABLE `table_online` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2352; -- -- AUTO_INCREMENT for table `table_phanquyen` -- ALTER TABLE `table_phanquyen` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `table_place_city` -- ALTER TABLE `table_place_city` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64; -- -- AUTO_INCREMENT for table `table_place_dist` -- ALTER TABLE `table_place_dist` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=705; -- -- AUTO_INCREMENT for table `table_product` -- ALTER TABLE `table_product` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=344; -- -- AUTO_INCREMENT for table `table_product_cat` -- ALTER TABLE `table_product_cat` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `table_product_danhmuc` -- ALTER TABLE `table_product_danhmuc` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=256; -- -- AUTO_INCREMENT for table `table_product_item` -- ALTER TABLE `table_product_item` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `table_product_list` -- ALTER TABLE `table_product_list` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=167; -- -- AUTO_INCREMENT for table `table_protag` -- ALTER TABLE `table_protag` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2599; -- -- AUTO_INCREMENT for table `table_pushonesignal` -- ALTER TABLE `table_pushonesignal` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `table_slider` -- ALTER TABLE `table_slider` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=246; -- -- AUTO_INCREMENT for table `table_tags` -- ALTER TABLE `table_tags` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `table_tinhtrang` -- ALTER TABLE `table_tinhtrang` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `table_title` -- ALTER TABLE `table_title` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `table_user` -- ALTER TABLE `table_user` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- AUTO_INCREMENT for table `table_video` -- ALTER TABLE `table_video` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=235; -- -- AUTO_INCREMENT for table `table_vnexpress` -- ALTER TABLE `table_vnexpress` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `table_yahoo` -- ALTER TABLE `table_yahoo` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;