File: /home/pengthai/domains/pengthaicurry.com/public_html/_db/pengthaicx_db.sql
-- phpMyAdmin SQL Dump
-- version 3.5.8.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 26, 2020 at 05:04 PM
-- Server version: 5.1.73
-- PHP Version: 5.3.28
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;
--
-- Database: `pengthaicx_db`
--
-- --------------------------------------------------------
--
-- Table structure for table `hits_counter`
--
CREATE TABLE IF NOT EXISTS `hits_counter` (
`id` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`today_date` date DEFAULT NULL,
`this_month` int(1) DEFAULT NULL,
`uip_today` bigint(20) DEFAULT NULL,
`pv_today` bigint(20) DEFAULT NULL,
`uip_month` bigint(20) DEFAULT NULL,
`pv_month` bigint(20) DEFAULT NULL,
`uip_all` bigint(20) DEFAULT NULL,
`pv_all` bigint(20) DEFAULT NULL,
`url` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `hits_counter`
--
INSERT INTO `hits_counter` (`id`, `today_date`, `this_month`, `uip_today`, `pv_today`, `uip_month`, `pv_month`, `uip_all`, `pv_all`, `url`, `ip`) VALUES
('0dbe8560086a8c52a982b12e265a40dd', '2020-11-26', 11, 13, 80, 71, 1288, 225, 27688, 'www.baanwebsite.com', '183.89.251.196');
-- --------------------------------------------------------
--
-- Table structure for table `hits_counter2`
--
CREATE TABLE IF NOT EXISTS `hits_counter2` (
`date` date NOT NULL DEFAULT '0000-00-00',
`uip` bigint(20) NOT NULL,
PRIMARY KEY (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `hits_counter2`
--
INSERT INTO `hits_counter2` (`date`, `uip`) VALUES
('2018-10-03', 1),
('2018-10-04', 1),
('2018-10-05', 1),
('2018-12-11', 1),
('2018-12-12', 1),
('2018-12-13', 1),
('2019-02-20', 1),
('2019-02-21', 1),
('2019-02-22', 2),
('2019-02-25', 1),
('2019-05-10', 1),
('2019-05-13', 1),
('2019-05-14', 2),
('2019-05-15', 2),
('2019-07-11', 1),
('2019-07-12', 1),
('2019-07-17', 2),
('2019-07-18', 1),
('2019-10-07', 1),
('2019-10-08', 2),
('2019-10-09', 2),
('2019-10-17', 1),
('2019-10-18', 4),
('2019-10-21', 9),
('2019-10-24', 1),
('2019-10-29', 1),
('2019-10-30', 2),
('2019-10-31', 2),
('2019-11-01', 2),
('2019-11-12', 1),
('2019-11-13', 1),
('2019-11-14', 1),
('2019-11-15', 1),
('2019-11-18', 1),
('2019-11-19', 1),
('2019-11-20', 1),
('2019-11-21', 1),
('2019-11-22', 1),
('2019-11-25', 1),
('2019-11-27', 1),
('2019-11-28', 1),
('2019-11-29', 1),
('2019-12-02', 1),
('2019-12-03', 1),
('2019-12-11', 1),
('2019-12-26', 1),
('2020-01-06', 3),
('2020-01-07', 2),
('2020-01-08', 4),
('2020-01-09', 1),
('2020-01-10', 1),
('2020-01-16', 1),
('2020-01-20', 1),
('2020-01-21', 2),
('2020-01-22', 2),
('2020-01-23', 1),
('2020-01-24', 2),
('2020-01-27', 3),
('2020-01-28', 3),
('2020-01-31', 2),
('2020-02-04', 2),
('2020-02-05', 1),
('2020-02-06', 1),
('2020-03-04', 3),
('2020-03-05', 2),
('2020-03-06', 1),
('2020-03-18', 1),
('2020-03-19', 1),
('2020-03-24', 1),
('2020-03-30', 1),
('2020-03-31', 1),
('2020-04-01', 1),
('2020-04-03', 1),
('2020-04-10', 1),
('2020-04-22', 1),
('2020-04-23', 3),
('2020-05-12', 1),
('2020-05-14', 1),
('2020-05-15', 2),
('2020-05-18', 1),
('2020-05-19', 1),
('2020-05-20', 1),
('2020-05-21', 2),
('2020-05-22', 1),
('2020-05-25', 1),
('2020-05-26', 1),
('2020-05-27', 1),
('2020-05-28', 4),
('2020-05-29', 6),
('2020-06-01', 1),
('2020-06-04', 1),
('2020-06-11', 2),
('2020-06-12', 3),
('2020-06-13', 1),
('2020-06-30', 1),
('2020-08-05', 1),
('2020-08-13', 1),
('2020-08-30', 1),
('2020-08-31', 1),
('2020-09-25', 3),
('2020-09-28', 3),
('2020-09-29', 2),
('2020-09-30', 2),
('2020-10-21', 1),
('2020-10-22', 2),
('2020-10-26', 1),
('2020-10-27', 2),
('2020-10-29', 2),
('2020-11-11', 1),
('2020-11-12', 1),
('2020-11-13', 1),
('2020-11-16', 2),
('2020-11-17', 6),
('2020-11-18', 2),
('2020-11-19', 3),
('2020-11-20', 6),
('2020-11-21', 10),
('2020-11-22', 1),
('2020-11-24', 18),
('2020-11-25', 12),
('2020-11-26', 13);
-- --------------------------------------------------------
--
-- Table structure for table `hits_useronline`
--
CREATE TABLE IF NOT EXISTS `hits_useronline` (
`id` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`time` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `hits_useronline`
--
INSERT INTO `hits_useronline` (`id`, `ip`, `time`) VALUES
('0dbe8560086a8c52a982b12e265a40dd', '183.89.251.196', 1606384187);
-- --------------------------------------------------------
--
-- Table structure for table `tb_banner`
--
CREATE TABLE IF NOT EXISTS `tb_banner` (
`bann_id` bigint(10) NOT NULL AUTO_INCREMENT,
`bann_name_th` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`bann_name_en` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`bann_link` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`bann_link_en` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`bann_image` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`bann_image_en` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`bann_detail_th` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT 'รายละเอียด',
`bann_detail_en` longtext COLLATE utf8_unicode_ci NOT NULL,
`bann_vdo` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`bann_vdo_en` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`bann_status` int(1) NOT NULL,
`bann_sort` int(1) NOT NULL,
`bann_date` date NOT NULL,
PRIMARY KEY (`bann_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
--
-- Dumping data for table `tb_banner`
--
INSERT INTO `tb_banner` (`bann_id`, `bann_name_th`, `bann_name_en`, `bann_link`, `bann_link_en`, `bann_image`, `bann_image_en`, `bann_detail_th`, `bann_detail_en`, `bann_vdo`, `bann_vdo_en`, `bann_status`, `bann_sort`, `bann_date`) VALUES
(1, '<div><p class="mb-3"> AUTHENTIC </p> <h1 class="mb-0"> THAI FAST FOOD </h1> </div>', '<div><p class="mb-3"> AUTHENTIC </p> <h1 class="mb-0"> THAI FAST FOOD </h1> </div>', 'http://www.baanwebsite.com/', 'http://www.baanwebsite.com/', '', '', '', '', '6a459cda41886cff3c7945d49d53e092.mov', '5b2fdb0dbbb67cb0af0416337dc0b39b.mov', 1, 1, '2020-11-17');
-- --------------------------------------------------------
--
-- Table structure for table `tb_config`
--
CREATE TABLE IF NOT EXISTS `tb_config` (
`conf_id` bigint(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`conf_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`conf_value` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`conf_id`),
UNIQUE KEY `conf_name` (`conf_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=82 ;
--
-- Dumping data for table `tb_config`
--
INSERT INTO `tb_config` (`conf_id`, `conf_name`, `conf_value`) VALUES
(0000000001, 'CONFIX_TITLE', 'ข้าวแกงเฮียเพ้ง'),
(0000000002, 'CONFIX_KEYWORD', 'ข้าวแกงเฮียเพ้ง'),
(0000000003, 'CONFIX_DESCRIPTION', 'ข้าวแกงเฮียเพ้ง'),
(0000000004, 'CONFIX_COPYRIGHT', '2020'),
(0000000005, 'CONFIX_COMPANY_TH', 'ข้าวแกงเฮียเพ้ง'),
(0000000006, 'CONFIX_COMPANY_EN', 'Peng Thai Curry'),
(0000000007, 'CONFIX_ADDRESS_TH', 'CONTACT'),
(0000000008, 'CONFIX_ADDRESS_EN', 'CONTACT'),
(0000000009, 'CONFIX_TELEPHONE_1', '02-2854988'),
(0000000010, 'CONFIX_TELEPHONE_2', '02-2854988'),
(0000000011, 'CONFIX_MOBILE_1', '02-2854988'),
(0000000012, 'CONFIX_MOBILE_2', '02-2854988'),
(0000000013, 'CONFIX_FAX', ''),
(0000000014, 'CONFIX_EMAIL_1', '[email protected]'),
(0000000015, 'CONFIX_EMAIL_2', '[email protected]'),
(0000000016, 'CONFIX_LOCATION', ''),
(0000000017, 'CONFIX_FACEBOOK_NAME', 'pengthaicurry'),
(0000000018, 'CONFIX_FACEBOOK_URL', 'https://www.facebook.com/pengthaicurry/'),
(0000000019, 'CONFIX_INSTAGRAM_NAME', 'instagram'),
(0000000020, 'CONFIX_INSTAGRAM_URL', 'https://www.instagram.com/pengthaicurry/'),
(0000000021, 'CONFIX_TWITTER_NAME', ''),
(0000000022, 'CONFIX_TWITTER_URL', ''),
(0000000023, 'CONFIX_LINEID_1', '@PENGTHAICURRY'),
(0000000024, 'CONFIX_LINEID_2', ''),
(0000000025, 'CONFIX_IMAGES_MAP', ''),
(0000000026, 'CONFIX_IMAGES_LINE', ''),
(0000000027, 'CONFIX_DETAIL_1', ''),
(0000000028, 'CONFIX_DETAIL_2', ''),
(0000000029, 'CONFIX_CODE_1', ''),
(0000000030, 'CONFIX_CODE_2', 'ห้ามคลิกขวานะคะ'),
(0000000031, 'CONFIX_DOMAINNAME', 'www.pengthaicurry.com'),
(0000000032, 'CONFIX_GOOGLE_NAME', ''),
(0000000033, 'CONFIX_GOOGLE_URL', ''),
(0000000034, 'CONFIX_WORKTIME_TH', ''),
(0000000035, 'CONFIX_WWW_NAME', ''),
(0000000036, 'CONFIX_WWW_URL', ''),
(0000000037, 'CONFIX_FAX_2', ''),
(0000000038, 'CONFIX_PINTEREST_NAME', ''),
(0000000039, 'CONFIX_PINTEREST_URL', ''),
(0000000040, 'CONFIX_YOUTUBE_NAME', ''),
(0000000041, 'CONFIX_YOUTUBE_URL', ''),
(0000000042, 'CONFIX_PAYPAL_2', ''),
(0000000043, 'CONFIX_PAYPAL_1', ''),
(0000000044, 'CONFIX_LINKEDIN_NAME', ''),
(0000000045, 'CONFIX_LINKEDIN_URL', ''),
(0000000046, 'CONFIX_FACEBOOK2_NAME', ''),
(0000000047, 'CONFIX_FACEBOOK2_URL', ''),
(0000000048, 'CONFIX_TAXPAYER', ''),
(0000000049, 'CONFIX_SHOP_TH', ''),
(0000000050, 'CONFIX_FACEBOOK_ID', ''),
(0000000051, 'CONFIX_CHATBOX_LINE_ID', ''),
(0000000052, 'CONFIX_CHATBOX_EMAIL', ''),
(0000000053, 'CONFIX_CHATBOX_CALL', ''),
(0000000054, 'CONFIX_CHATBOX_COLOR', '#000000'),
(0000000055, 'CONFIX_INTRO_1', '<ul>\n<li><strong><em>INNOVATION, CO-CREATION AND NEW PRODUCT DEVELOPMENT</em></strong></li>\n</ul>\n<p> We always love to create something “fresh”, “differentiated” and “distinctive”. Our relentless effort with our customers and manufacturers to innovatively co-create the new products to serve the global markets has seen us stepping up as a distinguished supplier who sources high-quality products, lives up to customers’ needs and provides long-term support and commitment to our partners. We believe in incorporating customers’ ideas into our process of new product development which is leading to something we call “innovation”. Every year, we closely collaborate with our clients and suppliers to launch newly engineered products to make sure there is always something new.</p>'),
(0000000056, 'CONFIX_INTRO_IMAGES', 'b5fe933b0c25327e4ea5ae4ea1b57ba8.jpg'),
(0000000057, 'CONFIX_HEADERSCRIPTS', ''),
(0000000058, 'CONFIX_FOOTERSCRIPTS', ''),
(0000000060, 'CONFIX_WORKTIME_EN', ''),
(0000000062, 'CONFIX_IMAGES_LOCATE', ''),
(0000000063, 'CONFIX_INTRO_DINING_TH', '<p>Let’s follow the silk thread and red roses enchanted by Cattle Queen, leading the wanderers to Labaris Restaurant where the finest cuisine and impressive service await.</p>'),
(0000000064, 'CONFIX_INTRO_DINING_EN', '<p>Let’s follow the silk thread and red roses enchanted by Cattle Queen, leading the wanderers to Labaris Restaurant where the finest cuisine and impressive service await.</p>'),
(0000000065, 'CONFIX_INTRO_CONFERENCE_TH', '<p>Labaris Town Hall (Conference Room) accommodate up to 200 guests. For smaller functions Labaris Royale is perfect for a group of 30 guests</p>'),
(0000000066, 'CONFIX_INTRO_CONFERENCE_EN', '<p>Labaris Town Hall (Conference Room) accommodate up to 200 guests. For smaller functions Labaris Royale is perfect for a group of 30 guests</p>'),
(0000000067, 'CONFIX_LINK_BOOKNOW', ''),
(0000000068, 'CONFIX_NAME_CONTACT', '8bbcfb10fdc6bcfe45ec3fb0899275e1.png'),
(0000000069, 'CONFIX_NAME_CALL', ''),
(0000000070, 'CONFIX_NAME_MAIL', ''),
(0000000071, 'CONFIX_NAME_CONTACT2', ''),
(0000000072, 'CONFIX_NAME_CALL2', ''),
(0000000073, 'CONFIX_NAME_MAIL2', ''),
(0000000074, 'CONFIX_NAME_CONTACT_EN', ''),
(0000000075, 'CONFIX_NAME_CALL_EN', ''),
(0000000076, 'CONFIX_NAME_MAIL_EN', ''),
(0000000077, 'CONFIX_NAME_CONTACT2_EN', ''),
(0000000078, 'CONFIX_NAME_CALL2_EN', ''),
(0000000079, 'CONFIX_NAME_MAIL2_EN', ''),
(0000000080, 'CONFIX_ADDRESS2_TH', ''),
(0000000081, 'CONFIX_ADDRESS2_EN', '');
-- --------------------------------------------------------
--
-- Table structure for table `tb_contact`
--
CREATE TABLE IF NOT EXISTS `tb_contact` (
`data_id` bigint(10) NOT NULL AUTO_INCREMENT,
`data_code` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'รหัสสินค้า',
`data_name_th` varchar(200) COLLATE utf8_unicode_ci NOT NULL COMMENT 'ชื่อสินค้า',
`data_name_en` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`data_price` float NOT NULL COMMENT 'ราคา',
`data_price2` float NOT NULL COMMENT 'ราคาลดแล้ว',
`data_title_th` varchar(250) COLLATE utf8_unicode_ci NOT NULL COMMENT 'รายละเอียดโดยย่อ',
`data_title_en` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`data_detail_th` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT 'รายละเอียดสินค้า',
`data_detail_en` longtext COLLATE utf8_unicode_ci NOT NULL,
`data_main_cate` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT 'หมวดหมู่หลัก',
`data_sub_cate` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT 'หมวดหมู่ย่อย',
`data_sub2_cate` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`data_status` int(1) NOT NULL COMMENT 'สถานะ 0=ไม่แสดง 1=แสดง',
`data_status2` int(1) NOT NULL COMMENT 'เช่น สินค้ามาใหม่ สินค้าแนะนำ',
`data_show` int(11) NOT NULL COMMENT 'การแสดงผลหน้าแรก',
`data_sort` int(1) NOT NULL COMMENT 'การจัดอันดับ',
`data_date` date NOT NULL COMMENT 'วันที่',
`data_pdf` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'ไฟล์ pdf',
`data_pdf_en` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`data_url` text COLLATE utf8_unicode_ci NOT NULL,
`data_vdo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`data_vdo_en` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`data_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
--
-- Dumping data for table `tb_contact`
--
INSERT INTO `tb_contact` (`data_id`, `data_code`, `data_name_th`, `data_name_en`, `data_price`, `data_price2`, `data_title_th`, `data_title_en`, `data_detail_th`, `data_detail_en`, `data_main_cate`, `data_sub_cate`, `data_sub2_cate`, `data_status`, `data_status2`, `data_show`, `data_sort`, `data_date`, `data_pdf`, `data_pdf_en`, `data_url`, `data_vdo`, `data_vdo_en`) VALUES
(1, '', 'ข้าวแกงเฮียเพ้ง (อาคาร อับดุลราฮิม เพลส)', 'Peng Thai Curry (Abdulrahim Place Building)', 0, 0, '02-116-9181', '02-116-9181', '<p>คำถามที่พบบ่อย</p>', '<p>คำถามที่พบบ่อย</p>', ',,', ',,', ',,', 1, 0, 0, 3, '2020-11-18', '', '', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3875.845356414324!2d100.5364780152739!3d13.727810801546418!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x0!2zMTPCsDQzJzQwLjEiTiAxMDDCsDMyJzE5LjIiRQ!5e0!3m2!1sth!2sth!4v1605684769215!5m2!1sth!2sth" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', ''),
(2, '', 'ข้าวแกงเฮียเพ้ง (อาคาร ยูเอ็ม ทาวเวอร์)', 'Peng Thai Curry ( UM Tower Building )', 0, 0, '02-115-8455', '02-115-8455', '<p>ขึ้นอยู่กับจำนวนและประเภทของสินค้า โดยปกติจะใช้เวลาประมาณ 20-30 วัน</p>', '<p>ขึ้นอยู่กับจำนวนและประเภทของสินค้า โดยปกติจะใช้เวลาประมาณ 20-30 วัน</p>', ',,', ',,', ',,', 1, 0, 0, 2, '2020-11-24', '', '', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d968.9012596727142!2d100.60121472603514!3d13.74234577994316!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x1d0aae39a2501769!2z4LiC4LmJ4Liy4Lin4LmB4LiB4LiH4LmA4Liu4Li14Lii4LmA4Lie4LmJ4LiH!5e0!3m2!1sth!2sth!4v1606192036608!5m2!1sth!2sth" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', ''),
(3, '', 'ข้าวแกงเฮียเพ้ง (อาคาร อื้อจือเหลียง)', 'Peng Thai Curry (U Chu Liang Building)', 0, 0, '02-116-7890 ', '02-116-7890 ', '', '', ',,', ',,', ',,', 1, 0, 0, 1, '2020-11-18', '', '', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3875.8545376171664!2d100.53845021527385!3d13.727255201559233!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x0!2zMTPCsDQzJzM4LjEiTiAxMDDCsDMyJzI2LjMiRQ!5e0!3m2!1sth!2sth!4v1605684133598!5m2!1sth!2sth" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', ''),
(4, '', 'ข้าวแกงเฮียเพ้ง (อาคารบางกอกซิตี้ ทาวเวอร์)', 'Peng Thai Curry (Bangkok City Tower Building)', 0, 0, '02-116-9089 ', '02-116-9089 ', '', '', ',,', ',,', ',,', 1, 0, 0, 4, '2020-11-18', '', '', '<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3875.9487017543347!2d100.52925035083761!3d13.721555590319777!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x0!2zMTPCsDQzJzE3LjYiTiAxMDDCsDMxJzUzLjIiRQ!5e0!3m2!1sth!2sth!4v1605165050392!5m2!1sth!2sth" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', ''),
(5, '', 'ข้าวแกงเฮียเพ้ง (อาคาร เดอะพาร์ค)', 'Peng Thai Curry ( The Parq Building )', 0, 0, '02-123-8789 ', '02-123-8789 ', '', '', ',,', ',,', ',,', 1, 0, 0, 5, '2020-11-18', '', '', ' <iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3875.944572270896!2d100.55622265083755!3d13.72180559031958!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x0!2zMTPCsDQzJzE4LjUiTiAxMDDCsDMzJzMwLjMiRQ!5e0!3m2!1sth!2sth!4v1605165129620!5m2!1sth!2sth" width="600" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `tb_contact_cate`
--
CREATE TABLE IF NOT EXISTS `tb_contact_cate` (
`cate_id` bigint(10) NOT NULL AUTO_INCREMENT,
`cate_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`cate_name_en` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`cate_sort` int(1) NOT NULL,
`cate_main` int(11) NOT NULL COMMENT 'หมวดหมู่หลัก',
`cate_mainsub1` int(11) NOT NULL,
`cate_images` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`cate_mainshow` int(1) NOT NULL DEFAULT '1',
`cate_mainshowindex` int(1) NOT NULL,
PRIMARY KEY (`cate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tb_contact_images`
--
CREATE TABLE IF NOT EXISTS `tb_contact_images` (
`imag_id` bigint(10) NOT NULL AUTO_INCREMENT,
`imag_mainID` int(1) NOT NULL,
`imag_file` text NOT NULL,
`imag_name` text NOT NULL,
`imag_name_en` text NOT NULL,
`imag_sort` int(1) NOT NULL,
PRIMARY KEY (`imag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tb_products`
--
CREATE TABLE IF NOT EXISTS `tb_products` (
`data_id` bigint(10) NOT NULL AUTO_INCREMENT,
`data_code` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'รหัสสินค้า',
`data_name_th` varchar(200) COLLATE utf8_unicode_ci NOT NULL COMMENT 'ชื่อสินค้า',
`data_name_en` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`data_title_th` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'รายละเอียดโดยย่อ',
`data_title_en` text COLLATE utf8_unicode_ci NOT NULL,
`data_detail_th` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT 'รายละเอียดสินค้า',
`data_detail_en` longtext COLLATE utf8_unicode_ci NOT NULL,
`data_main_cate` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT 'หมวดหมู่หลัก',
`data_sub_cate` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT 'หมวดหมู่ย่อย',
`data_sub2_cate` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`data_status` int(1) NOT NULL COMMENT 'สถานะ 0=ไม่แสดง 1=แสดง',
`data_status2` int(1) NOT NULL COMMENT 'เช่น สินค้ามาใหม่ สินค้าแนะนำ',
`data_show` int(11) NOT NULL COMMENT 'การแสดงผลหน้าแรก',
`data_sort` int(1) NOT NULL COMMENT 'การจัดอันดับ',
`data_date` date NOT NULL COMMENT 'วันที่',
`data_pdf` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'ไฟล์ pdf',
`data_pdf_en` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`data_vdo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`data_vdo_en` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`data_url` text COLLATE utf8_unicode_ci NOT NULL,
`data_type` int(10) NOT NULL,
`data_capacity_th` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`data_capacity_en` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`data_color_th` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`data_color_en` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`data_size_th` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`data_size_en` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`data_weight_th` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`data_weight_en` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`data_logo_th` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`data_logo_en` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`data_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;
--
-- Dumping data for table `tb_products`
--
INSERT INTO `tb_products` (`data_id`, `data_code`, `data_name_th`, `data_name_en`, `data_title_th`, `data_title_en`, `data_detail_th`, `data_detail_en`, `data_main_cate`, `data_sub_cate`, `data_sub2_cate`, `data_status`, `data_status2`, `data_show`, `data_sort`, `data_date`, `data_pdf`, `data_pdf_en`, `data_vdo`, `data_vdo_en`, `data_url`, `data_type`, `data_capacity_th`, `data_capacity_en`, `data_color_th`, `data_color_en`, `data_size_th`, `data_size_en`, `data_weight_th`, `data_weight_en`, `data_logo_th`, `data_logo_en`) VALUES
(1, 'KT-SC001', 'ผัดกะเพราหมูสับ', 'Stir fried thai basil with minced pork', '', '', '<p>Solic Crate 1</p>', '<p>Solic Crate 2</p>', ',1,', ',,', ',,', 1, 0, 1, 1, '2020-10-27', 'b228a2ff8588a019c37f18053cca7def.pdf', '', 'k18eUTN3cNk', '0b-EatqUvb4', '', 0, '', '', '', '', '', '', '', '', '', ''),
(2, '', 'ผัดผักรวมมิตร', 'Stir fried mixed vegetables', '', '', '', '', ',1,', ',,', ',,', 1, 0, 1, 2, '2020-10-29', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(3, '', 'หมูทอดเฮียเพ้ง', 'Deep fried pork', '', '', '', '', ',4,', ',,', ',,', 1, 0, 1, 1, '2020-11-17', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(4, '', 'ข้าวหมูทอดเฮียเพ้งและกระเพราหมูสับไข่ดาว', 'Deep fried pork and Stir fried thai basil with minced pork', '', '', '', '', ',4,', ',,', ',,', 0, 0, 1, 0, '2020-11-17', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(5, '', 'คั่วกลิ้งหมู', 'Stir fried pork with yellow curry paste in southern style', '', '', '', '', ',1,', ',,', ',,', 1, 0, 1, 3, '2020-11-17', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(6, '', 'ไข่พะโล้', 'Boiled eggs and pork in sweet brown sauce ', '', '', '', '', ',2,', ',,', ',,', 1, 0, 1, 1, '2020-11-17', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(7, '', 'ไข่ต้ม', 'Boiled egg', '', '', '', '', ',2,', ',,', ',,', 1, 0, 1, 2, '2020-11-17', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(8, '', 'แกงเขียวหวานไก่ใส่ฟัก', 'Green curry with chicken', '', '', '', '', ',3,', ',,', ',,', 1, 0, 1, 1, '2020-11-17', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(9, '', 'ผัดปลาดุกทอดกรอบ', 'Stir fried crispy cat fish with curry paste', '', '', '', '', ',1,', ',,', ',,', 1, 0, 1, 4, '2020-11-17', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(10, '', 'ไข่ลูกเขย', 'Fried boiled eggs in tamarind sauce', '', '', '', '', ',1,', ',,', ',,', 1, 0, 1, 5, '2020-11-17', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(11, '', 'กระหล่ำปลีน้ำปลา', 'Stir fried cabbage with fish sauce', '', '', '', '', ',1,', ',,', ',,', 1, 0, 1, 0, '2020-11-17', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(12, '', 'พะแนงหมู', 'Red curry with pork', '', '', '', '', ',3,', ',,', ',,', 1, 0, 1, 2, '2020-11-17', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(13, '', 'แกงเทโพหมู', 'Thai pork curry ', '', '', '', '', ',3,', ',,', ',,', 1, 0, 1, 3, '2020-11-17', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(14, '', 'ไก่ชุบแป้งทอด', 'Deep fried chicken', '', '', '', '', ',4,', ',,', ',,', 1, 0, 1, 2, '2020-11-24', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(15, '', 'ไข่ดาว', 'Deep fried egg', '', '', '', '', ',4,', ',,', ',,', 1, 0, 1, 3, '2020-11-24', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(16, '', 'ทอดมันปลากราย', 'Deep fried fish cake in Thai style', '', '', '', '', ',4,', ',,', ',,', 1, 0, 1, 4, '2020-11-24', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', ''),
(17, '', 'แหนมผัดไข่', 'Stir fried sour pork with eggs', '', '', '', '', ',1,', ',,', ',,', 1, 0, 1, 6, '2020-11-24', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `tb_products_cate`
--
CREATE TABLE IF NOT EXISTS `tb_products_cate` (
`cate_id` bigint(10) NOT NULL AUTO_INCREMENT,
`cate_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`cate_name_en` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`cate_title` text COLLATE utf8_unicode_ci,
`cate_title_en` text COLLATE utf8_unicode_ci,
`cate_sort` int(1) NOT NULL,
`cate_main` int(11) NOT NULL COMMENT 'หมวดหมู่หลัก',
`cate_mainsub1` int(11) NOT NULL,
`cate_images` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`cate_show` int(1) NOT NULL,
`cate_mainshowindex` int(1) NOT NULL,
`cate_type` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`cate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
--
-- Dumping data for table `tb_products_cate`
--
INSERT INTO `tb_products_cate` (`cate_id`, `cate_name`, `cate_name_en`, `cate_title`, `cate_title_en`, `cate_sort`, `cate_main`, `cate_mainsub1`, `cate_images`, `cate_show`, `cate_mainshowindex`, `cate_type`) VALUES
(1, 'ประเภทผัด', 'Stir fried ', '', '', 0, 0, 0, '', 1, 0, 1),
(2, 'ประเภทต้ม', 'Boiled', '', '', 0, 0, 0, '', 1, 0, 1),
(3, 'ประเภทแกง', 'Curry', '', '', 0, 0, 0, '', 1, 0, 1),
(4, 'ประเภททอด', 'Deep fried', '', '', 0, 0, 0, '', 1, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `tb_products_images`
--
CREATE TABLE IF NOT EXISTS `tb_products_images` (
`imag_id` bigint(10) NOT NULL AUTO_INCREMENT,
`imag_mainID` int(1) NOT NULL,
`imag_file` text NOT NULL,
`imag_name` text NOT NULL,
`imag_name_en` text NOT NULL,
`imag_sort` int(1) NOT NULL,
PRIMARY KEY (`imag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
--
-- Dumping data for table `tb_products_images`
--
INSERT INTO `tb_products_images` (`imag_id`, `imag_mainID`, `imag_file`, `imag_name`, `imag_name_en`, `imag_sort`) VALUES
(1, 1, '1fa83326ccc816af635f35f29a695eb8.jpg', '', '', 0),
(2, 2, '03f893d0dfcfaf0961247d65e5c15c5d.jpg', '', '', 0),
(3, 3, '6191752d6dac2eb4fc8d8a35c084738d.jpg', '', '', 1),
(4, 4, '08697113ccb90ddc82f25e564eb68a86.jpg', '', '', 0),
(5, 5, 'f43b20c2f232d1e976e0961de7400be2.jpg', '', '', 0),
(6, 6, '114f6529534f97ccbbd0ef5476e9db56.jpg', '', '', 1),
(8, 8, '1939e2e8cc46f0e4aa11e44e026d19bf.jpg', '', '', 1),
(9, 9, '352f3e7f824ea263cb333dd54b31f2ae.jpg', '', '', 0),
(10, 10, '07b6e4707fa76f9b1d5a1976f4477e1b.jpg', '', '', 0),
(11, 12, 'c7ce9634108f5126466ad2b6e5155944.jpg', '', '', 1),
(12, 13, 'b367c115a1bedfd70ce66143251a93d2.jpg', '', '', 1),
(13, 3, '4b3b966abfef45cdb73ee6137cd5c653.jpg', '', '', 2),
(14, 6, '948982aef2f86419c04437dcb34ed322.jpg', '', '', 2),
(15, 8, '038fc8ae1e3afac436c25878f35e7cc8.jpg', '', '', 2),
(16, 12, '1fbbce39d60c592f93ec074a180831b7.jpg', '', '', 2),
(17, 13, 'bd907500c71ff182205c3d9a4dd2d0c8.jpg', '', '', 2);
-- --------------------------------------------------------
--
-- Table structure for table `tb_products_title`
--
CREATE TABLE IF NOT EXISTS `tb_products_title` (
`data_id` bigint(10) NOT NULL AUTO_INCREMENT,
`data_name_th` varchar(200) COLLATE utf8_unicode_ci NOT NULL COMMENT 'ชื่อ',
`data_name_en` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`data_title_th` text COLLATE utf8_unicode_ci COMMENT 'รายละเอียดโดยย่อ',
`data_title_en` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`data_detail_th` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT 'รายละเอียด',
`data_detail_en` longtext COLLATE utf8_unicode_ci NOT NULL,
`lastedit_adm` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`lasttime_adm` datetime NOT NULL,
`data_status` int(1) NOT NULL DEFAULT '0',
`data_show` int(1) NOT NULL DEFAULT '0',
`data_date` date NOT NULL,
PRIMARY KEY (`data_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tb_products_title`
--
INSERT INTO `tb_products_title` (`data_id`, `data_name_th`, `data_name_en`, `data_title_th`, `data_title_en`, `data_detail_th`, `data_detail_en`, `lastedit_adm`, `lasttime_adm`, `data_status`, `data_show`, `data_date`) VALUES
(1, '', '', '', '', '<p> </p>\r\n<p> </p>', '<p> </p>\r\n<p> </p>', '', '0000-00-00 00:00:00', 1, 0, '2020-03-19');
-- --------------------------------------------------------
--
-- Table structure for table `tb_products_title_images`
--
CREATE TABLE IF NOT EXISTS `tb_products_title_images` (
`imag_id` bigint(10) NOT NULL AUTO_INCREMENT,
`imag_mainID` int(1) NOT NULL,
`imag_file` text NOT NULL,
`imag_name` text NOT NULL,
`imag_sort` int(1) NOT NULL,
PRIMARY KEY (`imag_id`),
KEY `imag_mainID` (`imag_mainID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
--
-- Dumping data for table `tb_products_title_images`
--
INSERT INTO `tb_products_title_images` (`imag_id`, `imag_mainID`, `imag_file`, `imag_name`, `imag_sort`) VALUES
(16, 1, '9f52ba806ce595930544f8de60f7de08.png', '', 0),
(17, 1, 'c90ba1f9e5ef259696d186fb27f42b15.png', '', 0),
(18, 1, '8f2c7c71ab7ccbf98403e540b5470d09.png', '', 0),
(19, 1, '2a9d0e5fbf3a75634840b5be44c31f59.png', '', 0);
-- --------------------------------------------------------
--
-- Table structure for table `tb_products_type`
--
CREATE TABLE IF NOT EXISTS `tb_products_type` (
`cate_id` bigint(10) NOT NULL AUTO_INCREMENT,
`cate_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`cate_name_en` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`cate_title` text COLLATE utf8_unicode_ci,
`cate_title_en` text COLLATE utf8_unicode_ci,
`cate_sort` int(1) NOT NULL,
`cate_main` int(11) NOT NULL COMMENT 'หมวดหมู่หลัก',
`cate_mainsub1` int(11) NOT NULL,
`cate_images` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`cate_show` int(1) NOT NULL,
`cate_mainshowindex` int(1) NOT NULL,
`cate_type` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`cate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;
--
-- Dumping data for table `tb_products_type`
--
INSERT INTO `tb_products_type` (`cate_id`, `cate_name`, `cate_name_en`, `cate_title`, `cate_title_en`, `cate_sort`, `cate_main`, `cate_mainsub1`, `cate_images`, `cate_show`, `cate_mainshowindex`, `cate_type`) VALUES
(1, 'IT Products', 'IT Products', '', '', 1, 0, 0, 'c0200c2d93337a0cecf01d85ccd5c9e9.png', 1, 0, 0),
(2, 'Everyday Items', 'Everyday Items', '', '', 0, 0, 0, 'd74d2a5d238c653023be928bd732980c.png', 1, 0, 0),
(3, 'Apparel and Others', 'Apparel and Others', '', '', 0, 0, 0, '1e9331259e714789604e51e93a3fba98.png', 1, 0, 0),
(4, 'Eco Drinkware', 'Eco Drinkware', '', '', 0, 0, 0, '43cbbe1b1bed72713ac71ba489992e11.png', 1, 0, 0),
(5, 'Cutlery Set', 'Cutlery Set', '', '', 0, 0, 0, '', 1, 0, 0),
(6, 'Bags', 'Bags', '', '', 2, 0, 0, '', 1, 0, 0),
(7, 'Travel Accessories', 'Travel Accessories', '', '', 0, 0, 0, '', 1, 0, 0),
(8, 'Eco-friendly Bag', 'Eco-friendly Bag', '', '', 0, 0, 0, '', 1, 0, 0),
(9, 'Eco Lunch Box', 'Eco Lunch Box', '', '', 0, 0, 0, '', 1, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `tb_product_status`
--
CREATE TABLE IF NOT EXISTS `tb_product_status` (
`stat_id` bigint(10) NOT NULL AUTO_INCREMENT,
`stat_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`stat_sort` int(1) DEFAULT NULL,
PRIMARY KEY (`stat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tb_product_status`
--
INSERT INTO `tb_product_status` (`stat_id`, `stat_name`, `stat_sort`) VALUES
(1, 'สินค้ายอดนิยม', 1);
-- --------------------------------------------------------
--
-- Table structure for table `tb_promotion`
--
CREATE TABLE IF NOT EXISTS `tb_promotion` (
`data_id` bigint(10) NOT NULL AUTO_INCREMENT,
`data_code` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'รหัสสินค้า',
`data_name_th` varchar(200) COLLATE utf8_unicode_ci NOT NULL COMMENT 'ชื่อสินค้า',
`data_name_en` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`data_price` float NOT NULL COMMENT 'ราคา',
`data_price2` float NOT NULL COMMENT 'ราคาลดแล้ว',
`data_title_th` varchar(250) COLLATE utf8_unicode_ci NOT NULL COMMENT 'รายละเอียดโดยย่อ',
`data_title_en` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`data_detail_th` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT 'รายละเอียดสินค้า',
`data_detail_en` longtext COLLATE utf8_unicode_ci NOT NULL,
`data_main_cate` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT 'หมวดหมู่หลัก',
`data_sub_cate` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT 'หมวดหมู่ย่อย',
`data_sub2_cate` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`data_status` int(1) NOT NULL COMMENT 'สถานะ 0=ไม่แสดง 1=แสดง',
`data_status2` int(1) NOT NULL COMMENT 'เช่น สินค้ามาใหม่ สินค้าแนะนำ',
`data_show` int(11) NOT NULL COMMENT 'การแสดงผลหน้าแรก',
`data_sort` int(1) NOT NULL COMMENT 'การจัดอันดับ',
`data_date` date NOT NULL COMMENT 'วันที่',
`data_pdf` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'ไฟล์ pdf',
`data_pdf_en` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`data_url` text COLLATE utf8_unicode_ci NOT NULL,
`data_vdo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`data_vdo_en` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`data_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
--
-- Dumping data for table `tb_promotion`
--
INSERT INTO `tb_promotion` (`data_id`, `data_code`, `data_name_th`, `data_name_en`, `data_price`, `data_price2`, `data_title_th`, `data_title_en`, `data_detail_th`, `data_detail_en`, `data_main_cate`, `data_sub_cate`, `data_sub2_cate`, `data_status`, `data_status2`, `data_show`, `data_sort`, `data_date`, `data_pdf`, `data_pdf_en`, `data_url`, `data_vdo`, `data_vdo_en`) VALUES
(1, '', 'พบกับเมนูเด็ดเฮียเพ้ง อยากให้ลอง!!', 'พบกับเมนูเด็ดเฮียเพ้ง อยากให้ลอง!!', 0, 0, '', '', '<div dir="auto">พบกับเมนูเด็ดเฮียเพ้ง อยากให้ลอง!!</div>\r\n<div dir="auto">ข้าวแกงกระหรี่หมูเยาวราชทีเด็ด</div>\r\n<div dir="auto">และเมนูอื่นอีกมากมาย</div>\r\n<div dir="auto">แต่ละวันความหลากหลายแตกต่างกันไป</div>\r\n<div dir="auto">แต่ความอร่อยเหมือนเดิม</div>', '<div dir="auto">พบกับเมนูเด็ดเฮียเพ้ง อยากให้ลอง!!</div>\r\n<div dir="auto">ข้าวแกงกระหรี่หมูเยาวราชทีเด็ด</div>\r\n<div dir="auto">และเมนูอื่นอีกมากมาย</div>\r\n<div dir="auto">แต่ละวันความหลากหลายแตกต่างกันไป</div>\r\n<div dir="auto">แต่ความอร่อยเหมือนเดิม</div>', ',,', ',,', ',,', 1, 0, 1, 1, '2020-11-24', '', '', '', '', ''),
(2, '', 'รับทำเมนูเพื่อการจัดเลี้ยง', 'catering', 0, 0, '', '', '<p>รับทำเมนูเพื่อการจัดเลี้ยง สนใจติดต่อที่สาขาได้เลยครับ</p>\r\n<p>สอบถามข้อมูลเพิ่มเติม ติดต่อ 02-285-4988 ต่อ 29-32</p>', '<p>รับทำเมนูเพื่อการจัดเลี้ยง สนใจติดต่อที่สาขาได้เลยครับ</p>\r\n<p>สอบถามข้อมูลเพิ่มเติม ติดต่อ 02-285-4988 ต่อ 29-32</p>', ',,', ',,', ',,', 1, 0, 1, 3, '2020-11-22', '', '', '', '', ''),
(3, '', 'Special Set A', 'Special Set A', 0, 0, '', '', '<p>Special Set A</p>', '<p>Special Set A</p>', ',,', ',,', ',,', 1, 0, 1, 2, '2020-11-16', '', '', '', '', ''),
(4, '', ' เริ่ม 1 ต.ค. - 31 ธ.ค. 63', ' เริ่ม 1 ต.ค. - 31 ธ.ค. 63', 0, 0, '', '', '<p>Special Set A เฮียเพ้งจัดให้<br />พิเศษ 99.- ปกติ 115.-</p>\r\n<p>Special Set A เฮียเพ้งจัด</p>', '<p>Special Set A เฮียเพ้งจัดให้<br />พิเศษ 99.- ปกติ 115.-</p>', ',,', ',,', ',,', 0, 0, 1, 0, '2020-11-16', '', '', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `tb_promotion_cate`
--
CREATE TABLE IF NOT EXISTS `tb_promotion_cate` (
`cate_id` bigint(10) NOT NULL AUTO_INCREMENT,
`cate_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`cate_name_en` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`cate_sort` int(1) NOT NULL,
`cate_main` int(11) NOT NULL COMMENT 'หมวดหมู่หลัก',
`cate_mainsub1` int(11) NOT NULL,
`cate_images` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`cate_mainshow` int(1) NOT NULL DEFAULT '1',
`cate_mainshowindex` int(1) NOT NULL,
PRIMARY KEY (`cate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tb_promotion_images`
--
CREATE TABLE IF NOT EXISTS `tb_promotion_images` (
`imag_id` bigint(10) NOT NULL AUTO_INCREMENT,
`imag_mainID` int(1) NOT NULL,
`imag_file` text NOT NULL,
`imag_name` text NOT NULL,
`imag_name_en` text NOT NULL,
`imag_sort` int(1) NOT NULL,
PRIMARY KEY (`imag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `tb_promotion_images`
--
INSERT INTO `tb_promotion_images` (`imag_id`, `imag_mainID`, `imag_file`, `imag_name`, `imag_name_en`, `imag_sort`) VALUES
(1, 1, '8f071cef32d32cf1cae6fb006493ecd2.jpg', '', '', 0),
(2, 3, 'd8a74724a9784628124729223f990433.jpg', '', '', 0),
(4, 2, '166c7926bba8c14767d4fe11330aa5ea.jpg', '', '', 0),
(5, 2, '1cb00053ae8ab356c04286cf4031cb16.jpg', '', '', 0);
/*!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 */;