-- http://www.phpmyadmin.net
-- 
-- 
-- Database: `corporatewear`
-- 

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

-- 
-- Table structure for table `tbl_banner`
-- 

CREATE TABLE `tbl_banner` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(225) collate utf8_unicode_ci default NULL,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `name_en` varchar(255) collate utf8_unicode_ci NOT NULL,
  `parent` int(11) NOT NULL default '0',
  `subject` text collate utf8_unicode_ci,
  `detail_short` text collate utf8_unicode_ci,
  `detail` longtext collate utf8_unicode_ci,
  `image` varchar(255) collate utf8_unicode_ci default NULL,
  `image_large` varchar(255) collate utf8_unicode_ci default NULL,
  `sort` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `lang` varchar(5) collate utf8_unicode_ci default NULL,
  `price` int(15) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=122 ;

-- 
-- Dumping data for table `tbl_banner`
-- 

INSERT INTO `tbl_banner` VALUES (113, '', 'Banner', 'Banner', 5, '', '', '', 'images/banner/banner_s113.jpg', '', 0, 0, '2016-01-04 11:19:04', '2016-11-15 16:10:13', 'vn', NULL);
INSERT INTO `tbl_banner` VALUES (120, '', 'Banner', 'Banner', 5, '', '', '', 'images/banner/banner_s120.jpg', NULL, 0, 0, '2016-11-15 16:10:20', '2016-11-15 16:10:20', 'vn', NULL);
INSERT INTO `tbl_banner` VALUES (121, '', 'Banner', 'Banner', 5, '', '', '', 'images/banner/banner_s121.jpg', NULL, 0, 0, '2016-11-15 16:10:27', '2016-11-15 16:10:27', 'vn', NULL);
INSERT INTO `tbl_banner` VALUES (111, '', 'Banner', 'Banner', 5, '', '', '', 'images/banner/banner_s111.jpg', '', 0, 0, '2016-01-04 11:15:26', '2016-11-15 16:10:06', 'vn', NULL);

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

-- 
-- Table structure for table `tbl_config`
-- 

CREATE TABLE `tbl_config` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `detail` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `tbl_config`
-- 

INSERT INTO `tbl_config` VALUES (1, 'total_visits', 'Tên truy cập', '24488', '0000-00-00 00:00:00', '2013-07-29 16:53:46');
INSERT INTO `tbl_config` VALUES (2, 'currencyUnit', 'Đơn vị tiền tệ', 'VND', '0000-00-00 00:00:00', '2008-12-18 10:11:18');
INSERT INTO `tbl_config` VALUES (3, 'adminEmail', 'Email', 'nguyenxuantien100691@gmail.com', '0000-00-00 00:00:00', '2016-11-02 15:24:41');

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

-- 
-- Table structure for table `tbl_contact`
-- 

CREATE TABLE `tbl_contact` (
  `id` int(11) NOT NULL auto_increment,
  `email` varchar(255) collate utf8_unicode_ci NOT NULL,
  `date_added` datetime NOT NULL,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL,
  `title` varchar(255) collate utf8_unicode_ci default NULL,
  `detail` longtext collate utf8_unicode_ci,
  `tel` varchar(255) collate utf8_unicode_ci NOT NULL,
  `address` text collate utf8_unicode_ci,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `tbl_contact`
-- 

INSERT INTO `tbl_contact` VALUES (5, 'nguyenxuantien100691@gmail.com', '2016-07-21 16:01:11', 'Nguyễn Xuân Tiến', 'PUM | Bán mỹ phẩm giá sỉ', 'Test', '0932 114 124', '614 Điện Biên Phủ, F11, Q10, TP.HCM');

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

-- 
-- Table structure for table `tbl_content`
-- 

CREATE TABLE `tbl_content` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(225) collate utf8_unicode_ci default NULL,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `name_en` varchar(255) collate utf8_unicode_ci NOT NULL,
  `subject_en` text collate utf8_unicode_ci NOT NULL,
  `detail_short_en` longtext collate utf8_unicode_ci NOT NULL,
  `detail_en` longtext collate utf8_unicode_ci NOT NULL,
  `parent` int(11) NOT NULL default '0',
  `subject` text collate utf8_unicode_ci,
  `detail_short` longtext collate utf8_unicode_ci NOT NULL,
  `detail` longtext collate utf8_unicode_ci NOT NULL,
  `image` varchar(255) collate utf8_unicode_ci default NULL,
  `image_large` varchar(255) collate utf8_unicode_ci default NULL,
  `sort` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `lang` varchar(5) collate utf8_unicode_ci default NULL,
  `news` tinyint(4) default NULL,
  `km` tinyint(4) default NULL,
  `meo` tinyint(4) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=818 ;

-- 
-- Dumping data for table `tbl_content`
-- 

INSERT INTO `tbl_content` VALUES (705, '', 'Corporate Wear', 'Corporate Wear', '', '', '', 6, '', 'Corporate Wear', 'Corporate Wear', 'images/post/admin_s705.png', NULL, 0, 0, '2015-12-05 15:03:36', '2016-11-15 16:08:45', 'vn', NULL, NULL, NULL);
INSERT INTO `tbl_content` VALUES (813, '', 'Quality', 'Quality', '', '<p>Our uniforms utilise an extensive range of fabrics and accessories of only the best quality. We hand pick all materials and carefully monitor it throughout the manufacturing</p>', '<p>Updating...</p>', 10, '', '<p>Our uniforms utilise an extensive range of fabrics and accessories of only the best quality. We hand pick all materials and carefully monitor it throughout the manufacturing</p>', '<p>Đang cập nhật...</p>', 'images/post/information_s813.jpg', NULL, 0, 0, '2016-11-16 15:31:42', '2016-11-16 15:31:42', 'vn', 1, NULL, NULL);
INSERT INTO `tbl_content` VALUES (761, '', 'Tin tức 2', 'Tin tức 2E', '', '<p>Updating...</p>', '<p>Updating...</p>', 16, '', '<p>Đang cập nhật...</p>', '<p>Đang cập nhật...</p>', 'images/post/news_event_s761.jpg', NULL, 0, 0, '2015-12-29 22:46:16', '2016-11-02 15:33:00', 'vn', 1, NULL, 0);
INSERT INTO `tbl_content` VALUES (762, '', 'Tin tức 3', 'Tin tức 3E', '', '<p>Updating...</p>', '<p>Updating...</p>', 16, '', '<p>Đang cập nhật...</p>', '<p>Đang cập nhật...</p>', 'images/post/news_event_s762.jpg', NULL, 0, 0, '2015-12-29 22:47:59', '2016-11-02 15:33:07', 'vn', 1, 0, NULL);
INSERT INTO `tbl_content` VALUES (760, '', 'Tin tức 1', 'Tin tức 1E', '', '<p>Updating...</p>', '<p>Updating...</p>', 16, '', '<p>Đang cập nhật...</p>', '<p>Đang cập nhật...</p>', 'images/post/news_event_s760.jpg', NULL, 0, 0, '2015-12-29 22:44:20', '2016-11-02 15:32:53', 'vn', 1, 0, 0);
INSERT INTO `tbl_content` VALUES (808, '', 'Footer', 'Footer', '', '', '<ul class="menu-footer">\r\n	<li>64B Cong Lo Road, Ward 15, Tan Binh District, Ho Chi Minh City, Vietnam.</li>\r\n	<li>ĐT : +84 8 38152209 &ndash; +84 8 38152204</li>\r\n	<li>Website : www.corporatewear.com.vn</li>\r\n	<li>Email : sales@corporatewear.com.vn</li>\r\n</ul>', 4, '', '', '<ul class="menu-footer">\r\n	<li>64B Cong Lo Road, Ward 15, Tan Binh District, Ho Chi Minh City, Vietnam.</li>\r\n	<li>ĐT : +84 8 38152209 &ndash; +84 8 38152204</li>\r\n	<li>Website : www.corporatewear.com.vn</li>\r\n	<li>Email : sales@corporatewear.com.vn</li>\r\n</ul>', NULL, NULL, 0, 0, '2016-11-02 15:17:11', '2016-11-16 16:24:55', 'vn', NULL, NULL, NULL);
INSERT INTO `tbl_content` VALUES (812, '', 'Material', 'Material', '', '<p>Our uniforms utilise an extensive range of fabrics and accessories of only the best quality. We hand pick all materials and carefully monitor it throughout the manufacturing</p>', '<p>Updating...</p>', 10, '', '<p>Our uniforms utilise an extensive range of fabrics and accessories of only the best quality. We hand pick all materials and carefully monitor it throughout the manufacturing</p>', '<p>Đang cập nhật...</p>', 'images/post/information_s812.jpg', NULL, 0, 0, '2016-11-16 15:27:47', '2016-11-16 15:30:18', 'vn', 1, NULL, NULL);
INSERT INTO `tbl_content` VALUES (811, '', 'Sáng tác', 'Manufacture', '', '', '<p>Updating...</p>', 8, '', '', '<p>Đang cập nhật...</p>', NULL, NULL, 0, 0, '2016-11-15 20:26:47', '2016-11-15 20:26:47', 'vn', NULL, NULL, NULL);
INSERT INTO `tbl_content` VALUES (809, '', 'Giới thiệu', 'About us', '', '', '<p>Updating...</p>', 3, '', '', '<p>Đang cập nhật...</p>', NULL, NULL, 0, 0, '2016-11-15 20:25:08', '2016-11-15 20:25:08', 'vn', NULL, NULL, NULL);
INSERT INTO `tbl_content` VALUES (810, '', 'Chuyên môn thiết kế', 'Design Expertise', '', '', '<p>Updating...</p>', 9, '', '', '<p>Đang cập nhật...</p>', NULL, NULL, 0, 0, '2016-11-15 20:25:43', '2016-11-15 20:25:43', 'vn', NULL, NULL, NULL);
INSERT INTO `tbl_content` VALUES (770, '0937 905 165', 'Hotline', '', '', '', '', 7, '', '', '', NULL, NULL, 0, 0, '2016-06-07 10:36:40', '2016-07-20 17:06:36', 'vn', NULL, NULL, NULL);
INSERT INTO `tbl_content` VALUES (805, '0932 114 124', 'Hotline', '', '', '', '', 7, '', '', '', NULL, NULL, 0, 0, '2016-07-20 22:28:02', '2016-07-20 22:28:02', 'vn', NULL, NULL, NULL);
INSERT INTO `tbl_content` VALUES (814, '', 'Service', 'Service', '', '<p>Our uniforms utilise an extensive range of fabrics and accessories of only the best quality. We hand pick all materials and carefully monitor it throughout the manufacturing</p>', '<p>Updating...</p>', 10, '', '<p>Our uniforms utilise an extensive range of fabrics and accessories of only the best quality. We hand pick all materials and carefully monitor it throughout the manufacturing</p>', '<p>Đang cập nhật...</p>', 'images/post/information_s814.jpg', NULL, 0, 0, '2016-11-16 15:32:08', '2016-11-16 15:32:08', 'vn', 1, NULL, NULL);
INSERT INTO `tbl_content` VALUES (815, '', 'Value', 'Value', '', '<p>Our uniforms utilise an extensive range of fabrics and accessories of only the best quality. We hand pick all materials and carefully monitor it throughout the manufacturing</p>', '<p>Updating...</p>', 10, '', '<p>Our uniforms utilise an extensive range of fabrics and accessories of only the best quality. We hand pick all materials and carefully monitor it throughout the manufacturing</p>', '<p>Đang cập nhật...</p>', 'images/post/information_s815.jpg', NULL, 0, 0, '2016-11-16 15:32:33', '2016-11-16 15:32:33', 'vn', 1, NULL, NULL);
INSERT INTO `tbl_content` VALUES (816, '', 'Research & Development', 'Research & Development E', '', '<p>Updating...</p>', '<p>Updating...</p>', 10, '', '<p>Đang cập nhật...</p>', '<p>Đang cập nhật...</p>', NULL, NULL, 0, 0, '2016-11-16 15:33:01', '2016-11-16 15:33:01', 'vn', 0, NULL, NULL);
INSERT INTO `tbl_content` VALUES (817, '', 'Thông tin liên hệ', 'Contact us', '', '', '<div class="col-sm-7 contact-us">\r\n<h2 class="entry-title">Contact Information</h2>\r\n\r\n<p>For more information, please feel free to contact us by using the following form.</p>\r\n\r\n<div class="col-md-6">\r\n<h5 class="entry-title-info">Head Office</h5>\r\n\r\n<ul>\r\n	<li>GENERAL INVESTMENTS &amp; CO PTY LTD (PSU AUSTRALIA).</li>\r\n	<li>Level 1, 38 &ndash; 40 Byron Street<br />\r\n	Footscray, VIC 3011<br />\r\n	Australia</li>\r\n	<li>+ 61 3 96877466</li>\r\n	<li><a href="mailto:enquires@psuaustralia.com">enquires@psuaustralia.com</a></li>\r\n	<li><i class="fa fa-abn">ABN</i>19138783285</li>\r\n</ul>\r\n</div>\r\n\r\n<div class="col-md-6">\r\n<h5 class="entry-title-info">Vietnam manufacture</h5>\r\n\r\n<ul>\r\n	<li>64B Cong Lo Road,<br />\r\n	Ward 15, Tan Binh District,<br />\r\n	Ho Chi Minh City, Vietnam.</li>\r\n	<li>+ 84 8 38152209</li>\r\n	<li><a href="mailto:sales@ corporatewear.com.vn">sales@corporatewear.com.vn</a></li>\r\n</ul>\r\n</div>\r\n\r\n<div class="col-md-12">\r\n<h5 class="entry-title-info">management</h5>\r\n\r\n<div class="col-md-6">\r\n<h4>Mr Danh Van Phan</h4>\r\n\r\n<p>Managing Director</p>\r\n\r\n<ul>\r\n	<li>+ 61 4 1933 1136</li>\r\n</ul>\r\n</div>\r\n\r\n<div class="col-md-6">\r\n<h4>Ms Tina Mai Thuy</h4>\r\n\r\n<p>Operations &amp; Business Development Manager</p>\r\n\r\n<ul>\r\n	<li>+ 84 913 914 484.(Vietnam)</li>\r\n	<li>+ 61 451 939 868.</li>\r\n</ul>\r\n</div>\r\n\r\n<div class="col-md-6">\r\n<h4>Ms Marianne Phan</h4>\r\n\r\n<p>Sales &amp; Marketing Executive</p>\r\n\r\n<ul>\r\n	<li>+61 4 1137 1957.</li>\r\n</ul>\r\n</div>\r\n</div>\r\n</div>', 4, '', '', '<div class="col-sm-7 contact-us">\r\n<h2 class="entry-title">Contact Information</h2>\r\n\r\n<p>For more information, please feel free to contact us by using the following form.</p>\r\n\r\n<div class="col-md-6">\r\n<h5 class="entry-title-info">Head Office</h5>\r\n\r\n<ul>\r\n	<li>GENERAL INVESTMENTS &amp; CO PTY LTD (PSU AUSTRALIA).</li>\r\n	<li>Level 1, 38 &ndash; 40 Byron Street<br />\r\n	Footscray, VIC 3011<br />\r\n	Australia</li>\r\n	<li>+ 61 3 96877466</li>\r\n	<li><a href="mailto:enquires@psuaustralia.com">enquires@psuaustralia.com</a></li>\r\n	<li><i class="fa fa-abn">ABN</i>19138783285</li>\r\n</ul>\r\n</div>\r\n\r\n<div class="col-md-6">\r\n<h5 class="entry-title-info">Vietnam manufacture</h5>\r\n\r\n<ul>\r\n	<li>64B Cong Lo Road,<br />\r\n	Ward 15, Tan Binh District,<br />\r\n	Ho Chi Minh City, Vietnam.</li>\r\n	<li>+ 84 8 38152209</li>\r\n	<li><a href="mailto:sales@ corporatewear.com.vn">sales@corporatewear.com.vn</a></li>\r\n</ul>\r\n</div>\r\n\r\n<div class="col-md-12">\r\n<h5 class="entry-title-info">management</h5>\r\n\r\n<div class="col-md-6">\r\n<h4>Mr Danh Van Phan</h4>\r\n\r\n<p>Managing Director</p>\r\n\r\n<ul>\r\n	<li>+ 61 4 1933 1136</li>\r\n</ul>\r\n</div>\r\n\r\n<div class="col-md-6">\r\n<h4>Ms Tina Mai Thuy</h4>\r\n\r\n<p>Operations &amp; Business Development Manager</p>\r\n\r\n<ul>\r\n	<li>+ 84 913 914 484.(Vietnam)</li>\r\n	<li>+ 61 451 939 868.</li>\r\n</ul>\r\n</div>\r\n\r\n<div class="col-md-6">\r\n<h4>Ms Marianne Phan</h4>\r\n\r\n<p>Sales &amp; Marketing Executive</p>\r\n\r\n<ul>\r\n	<li>+61 4 1137 1957.</li>\r\n</ul>\r\n</div>\r\n</div>\r\n</div>', NULL, NULL, 0, 0, '2016-11-16 16:26:15', '2016-11-16 16:26:15', 'vn', NULL, NULL, NULL);

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

-- 
-- Table structure for table `tbl_content_category`
-- 

CREATE TABLE `tbl_content_category` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(225) character set utf8 collate utf8_unicode_ci default NULL,
  `name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `name_en` varchar(255) NOT NULL,
  `parent` int(11) NOT NULL default '0',
  `subject` text character set utf8 collate utf8_unicode_ci,
  `detail_short` text character set utf8 collate utf8_unicode_ci,
  `detail` longtext character set utf8 collate utf8_unicode_ci,
  `image` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
  `image_large` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
  `sort` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `lang` varchar(5) character set utf8 collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=176 ;

-- 
-- Dumping data for table `tbl_content_category`
-- 

INSERT INTO `tbl_content_category` VALUES (1, '', 'Danh mục gốc', '', 0, '', '', '', NULL, NULL, 0, 0, '2010-06-16 08:48:28', '2010-06-16 08:48:28', '');
INSERT INTO `tbl_content_category` VALUES (2, 'vn', 'Nội dung', '', 1, '', '', '', NULL, NULL, 0, 0, '2010-06-16 08:48:28', '2010-06-16 08:48:28', 'vn');
INSERT INTO `tbl_content_category` VALUES (3, 'vn_introduction', 'Giới thiệu', 'About us', 2, '', '', '', NULL, NULL, 0, 0, '2010-06-16 08:48:28', '2010-06-16 08:48:28', 'vn');
INSERT INTO `tbl_content_category` VALUES (4, 'vn_contact', 'Liên hệ', 'Contact', 2, '', '', '', NULL, NULL, 0, 0, '2010-06-16 08:48:28', '2010-06-16 08:48:28', 'vn');
INSERT INTO `tbl_content_category` VALUES (5, 'vn_banner', 'Banner', '', 2, NULL, NULL, NULL, NULL, NULL, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'vn');
INSERT INTO `tbl_content_category` VALUES (9, 'vn_expertise', 'Chuyên môn', '', 2, NULL, NULL, NULL, NULL, NULL, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'vn');
INSERT INTO `tbl_content_category` VALUES (6, 'vn_admin', 'Admin', 'Admin', 2, NULL, NULL, NULL, NULL, NULL, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'vn');
INSERT INTO `tbl_content_category` VALUES (7, 'vn_hotline', 'Hotline', 'Hotline', 2, NULL, NULL, NULL, NULL, NULL, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'vn');
INSERT INTO `tbl_content_category` VALUES (8, 'vn_manufacture', 'Sáng tác', '', 2, NULL, NULL, NULL, NULL, NULL, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'vn');
INSERT INTO `tbl_content_category` VALUES (16, 'vn_news_event', 'Tin tức', 'News', 2, NULL, NULL, NULL, NULL, NULL, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'vn');
INSERT INTO `tbl_content_category` VALUES (10, 'vn_information', 'Thông tin', '', 2, NULL, NULL, NULL, NULL, NULL, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'vn');

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

-- 
-- Table structure for table `tbl_information_order`
-- 

CREATE TABLE `tbl_information_order` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `address` varchar(255) collate utf8_unicode_ci default NULL,
  `ward` varchar(255) collate utf8_unicode_ci default NULL,
  `district` varchar(255) collate utf8_unicode_ci default NULL,
  `tel` varchar(20) collate utf8_unicode_ci default NULL,
  `email` varchar(100) collate utf8_unicode_ci default NULL,
  `detail` text collate utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `code` varchar(10) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=69 ;

-- 
-- Dumping data for table `tbl_information_order`
-- 

INSERT INTO `tbl_information_order` VALUES (68, 'Nguyễn Xuân Tiến', '650 Điện Biên Phủ, F11, Q10, TP.HCM', NULL, NULL, '0932114124', 'nguyenxuantien100691@gmail.com', 'Test', 1, '2016-11-18 23:56:15', '0000-00-00 00:00:00', 'gC1lZ');

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

-- 
-- Table structure for table `tbl_order`
-- 

CREATE TABLE `tbl_order` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(255) collate utf8_unicode_ci NOT NULL default '0',
  `member_id` int(11) NOT NULL default '0',
  `payment` tinyint(4) NOT NULL default '1',
  `paypol` tinyint(4) NOT NULL default '1',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=166 ;

-- 
-- Dumping data for table `tbl_order`
-- 


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

-- 
-- Table structure for table `tbl_order_detail`
-- 

CREATE TABLE `tbl_order_detail` (
  `id` int(11) NOT NULL auto_increment,
  `order_code` varchar(255) collate utf8_unicode_ci NOT NULL,
  `member_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL default '0',
  `product_id` int(11) NOT NULL default '0',
  `quantity` int(11) NOT NULL default '0',
  `payment` tinyint(4) NOT NULL default '1',
  `price` float default NULL,
  `status` int(11) NOT NULL default '0',
  `paypol` tinyint(4) NOT NULL default '1',
  `date_added` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=64 ;

-- 
-- Dumping data for table `tbl_order_detail`
-- 

INSERT INTO `tbl_order_detail` VALUES (63, 'DHTSP68', 68, 0, 1774, 8, 1, 67890, 0, 1, '2016-11-18 23:56:15');

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

-- 
-- Table structure for table `tbl_product`
-- 

CREATE TABLE `tbl_product` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(225) character set utf8 collate utf8_unicode_ci default NULL,
  `name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `name_en` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `parent` int(11) NOT NULL default '0',
  `subject` text character set utf8 collate utf8_unicode_ci,
  `detail_short` text character set utf8 collate utf8_unicode_ci,
  `price` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `price_en` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `detail_short_en` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `detail` longtext character set utf8 collate utf8_unicode_ci,
  `detail_en` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `title_tab` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `keywords` text character set utf8 collate utf8_unicode_ci,
  `description` text character set utf8 collate utf8_unicode_ci,
  `image` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
  `image_large` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
  `sort` int(11) NOT NULL default '0',
  `hot` int(11) NOT NULL default '1',
  `new` int(11) NOT NULL default '1',
  `promotion` int(11) NOT NULL default '1',
  `status` int(11) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `lang` varchar(5) character set utf8 collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1775 ;

-- 
-- Dumping data for table `tbl_product`
-- 

INSERT INTO `tbl_product` VALUES (1771, '', 'Sản phẩm 1', 'Sản phẩm 1E', 375, '', '<p>Đang cập nhật...</p>\r\n', '09876', '67890', '<p>Updating...</p>\r\n', '<p>Đang cập nhật...</p>', '<p>Updating...</p>', '', '', '', 'images/product/product_s1771.jpg', NULL, 0, 1, 1, 1, 0, '2016-11-02 14:56:04', '2016-11-15 20:10:44', 'vn');
INSERT INTO `tbl_product` VALUES (1772, '', 'Sản phẩm 2', 'Sản phẩm 2E', 373, '', '<p>Đang cập nhật...</p>\r\n', '54321', '12345', '<p>Updating...</p>\r\n', '<p>Đang cập nhật...</p>', '<p>Updating...</p>', '', '', '', 'images/product/product_s1772.jpg', NULL, 0, 1, 1, 1, 0, '2016-11-02 14:56:13', '2016-11-15 20:10:14', 'vn');
INSERT INTO `tbl_product` VALUES (1773, '', 'Sản phẩm 3', 'Sản phẩm 3E', 374, '', '<p>Đang cập nhật...</p>\r\n', '12345', '54321', '<p>Updating...</p>\r\n', '<p>Đang cập nhật...</p>', '<p>Updating...</p>', '', '', '', 'images/product/product_s1773.jpg', NULL, 0, 1, 1, 1, 0, '2016-11-02 14:56:22', '2016-11-15 20:11:09', 'vn');
INSERT INTO `tbl_product` VALUES (1774, '', 'Sản phẩm 4', 'Sản phẩm 4E', 375, '', '<p>Đang cập nhật...</p>\r\n', '67890', '09876', '<p>Updating...</p>\r\n', '<p>Đang cập nhật...</p>', '<p>Updating...</p>', '', '', '', 'images/product/product_s1774.jpg', NULL, 0, 1, 1, 1, 0, '2016-11-02 14:56:33', '2016-11-18 22:34:32', 'vn');

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

-- 
-- Table structure for table `tbl_product_category`
-- 

CREATE TABLE `tbl_product_category` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(225) character set utf8 collate utf8_unicode_ci default NULL,
  `name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `name_en` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  `subject_en` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `detail_short_en` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `detail_en` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `parent` int(11) NOT NULL default '0',
  `subject` text character set utf8 collate utf8_unicode_ci,
  `detail_short` text character set utf8 collate utf8_unicode_ci,
  `detail` longtext character set utf8 collate utf8_unicode_ci,
  `image` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
  `image_large` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
  `sort` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `news` int(11) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `lang` varchar(5) character set utf8 collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=380 ;

-- 
-- Dumping data for table `tbl_product_category`
-- 

INSERT INTO `tbl_product_category` VALUES (1, NULL, 'Danh mục gốc', '', '', '', '', 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
INSERT INTO `tbl_product_category` VALUES (2, 'vn', 'Sản phẩm', 'Product', '', '', '', 1, '', '', '', NULL, NULL, 0, 0, 0, '2008-03-24 08:36:30', '2008-03-27 10:29:34', 'vn');
INSERT INTO `tbl_product_category` VALUES (372, '', 'AAA', 'AAAE', '', '', '', 2, '', '', '', '', NULL, 0, 0, 0, '2016-11-02 14:51:50', '2016-11-15 20:04:13', 'vn');
INSERT INTO `tbl_product_category` VALUES (373, '', 'BBB', 'BBBE', '', '', '', 2, '', '', '', '', NULL, 0, 0, 0, '2016-11-02 14:51:56', '2016-11-15 20:04:17', 'vn');
INSERT INTO `tbl_product_category` VALUES (374, '', 'CCC', 'CCCE', '', '', '', 2, '', '', '', '', NULL, 0, 0, 0, '2016-11-02 14:53:25', '2016-11-15 20:04:21', 'vn');
INSERT INTO `tbl_product_category` VALUES (375, '', 'DDD', 'DDDE', '', '', '', 2, '', '', '', '', NULL, 0, 0, 0, '2016-11-02 14:53:31', '2016-11-15 20:04:24', 'vn');
INSERT INTO `tbl_product_category` VALUES (376, '', 'AAAa', 'AAAaE', '', '', '', 372, '', '', '', NULL, NULL, 0, 0, 0, '2016-11-15 19:58:29', '2016-11-15 20:02:10', 'vn');
INSERT INTO `tbl_product_category` VALUES (377, '', 'BBBb', 'BBBbE', '', '', '', 373, '', '', '', NULL, NULL, 0, 0, 0, '2016-11-15 20:02:02', '2016-11-15 20:02:14', 'vn');
INSERT INTO `tbl_product_category` VALUES (378, '', 'CCCc', 'CCCcE', '', '', '', 374, '', '', '', NULL, NULL, 0, 0, 0, '2016-11-15 20:03:16', '2016-11-15 20:03:16', 'vn');
INSERT INTO `tbl_product_category` VALUES (379, '', 'DDDd', 'DDDdE', '', '', '', 375, '', '', '', NULL, NULL, 0, 0, 0, '2016-11-15 20:03:28', '2016-11-15 20:03:28', 'vn');

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

-- 
-- Table structure for table `tbl_product_special`
-- 

CREATE TABLE `tbl_product_special` (
  `id` int(11) NOT NULL auto_increment,
  `product_id` int(11) NOT NULL default '0',
  `sort` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `lang` varchar(5) character set utf8 collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=364 ;
