-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `cms_admin_attr`
--

CREATE TABLE `cms_admin_attr` (
  `aRef` int(11) NOT NULL,
  `RefID` int(11) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Company` varchar(255) DEFAULT NULL,
  `NRIC` varchar(25) DEFAULT NULL,
  `DOB` varchar(25) DEFAULT NULL,
  `Tel` mediumtext DEFAULT NULL,
  `Mobile` varchar(30) DEFAULT NULL,
  `Fax` mediumtext DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `Address` longtext DEFAULT NULL,
  `PostCode` varchar(15) DEFAULT NULL,
  `State` varchar(50) DEFAULT NULL,
  `City` varchar(50) DEFAULT NULL,
  `Country` varchar(50) DEFAULT NULL,
  `Remark` text NOT NULL,
  `Note` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_banner`
--

CREATE TABLE `cms_banner` (
  `ref` int(11) NOT NULL,
  `subcat` int(11) NOT NULL,
  `photo` text NOT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_banner`
--

INSERT INTO `cms_banner` (`ref`, `subcat`, `photo`, `active`, `datecreate`, `dateupdate`) VALUES
(1, 1, '1691937985Asset 2.png|', 1, 1582704093, 1691937985);

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

--
-- Table structure for table `cms_banner_attr`
--

CREATE TABLE `cms_banner_attr` (
  `aRef` int(11) NOT NULL,
  `RefID` int(11) NOT NULL,
  `Title` varchar(50) NOT NULL,
  `ShortDesc` text NOT NULL,
  `PhotoDesc` varchar(200) NOT NULL,
  `lang` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_banner_attr`
--

INSERT INTO `cms_banner_attr` (`aRef`, `RefID`, `Title`, `ShortDesc`, `PhotoDesc`, `lang`) VALUES
(1, 1, 'home', '', '', '');

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

--
-- Table structure for table `cms_banner_cat`
--

CREATE TABLE `cms_banner_cat` (
  `ref` int(11) NOT NULL,
  `Title` varchar(250) NOT NULL,
  `ShortDesc` text NOT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_banner_cat`
--

INSERT INTO `cms_banner_cat` (`ref`, `Title`, `ShortDesc`, `active`, `datecreate`, `dateupdate`) VALUES
(1, 'Home', '', 1, 1582704086, 1582704086);

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

--
-- Table structure for table `cms_brand`
--

CREATE TABLE `cms_brand` (
  `ref` int(11) NOT NULL,
  `subcat` varchar(50) NOT NULL,
  `photo` text NOT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL,
  `Extension` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_brand_cat`
--

CREATE TABLE `cms_brand_cat` (
  `ref` int(11) NOT NULL,
  `photo` text NOT NULL,
  `Discount` int(11) NOT NULL,
  `Price` int(20) NOT NULL,
  `Title` varchar(250) NOT NULL,
  `ShortDesc` text NOT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL,
  `dateexp` int(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_content`
--

CREATE TABLE `cms_content` (
  `ref` int(11) NOT NULL,
  `Project` varchar(11) DEFAULT NULL,
  `photo` text DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  `datecreate` int(11) DEFAULT NULL,
  `dateupdate` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_content`
--

INSERT INTO `cms_content` (`ref`, `Project`, `photo`, `active`, `datecreate`, `dateupdate`) VALUES
(86, '', '', 1, 1692009814, 1692009814),
(83, '', '', 1, 1692004481, 1692004481),
(84, '', '', 1, 1692005021, 1692005021),
(85, '', '1692006533Asset 3.png|', 1, 1692006533, 1692006669),
(82, '', '', 1, 1692002058, 1692002058),
(81, '', '', 1, 1692001164, 1692001164),
(80, '', '', 1, 1691999581, 1691999581),
(79, '', '1691996902Asset 5.png|', 1, 1691996902, 1691996938);

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

--
-- Table structure for table `cms_content_attr`
--

CREATE TABLE `cms_content_attr` (
  `aRef` int(11) NOT NULL,
  `RefID` int(11) DEFAULT NULL,
  `Title` varchar(250) DEFAULT NULL,
  `Content` text DEFAULT NULL,
  `ShortDesc` varchar(250) DEFAULT NULL,
  `PhotoDesc` varchar(200) DEFAULT NULL,
  `link` text DEFAULT NULL,
  `lang` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_content_attr`
--

INSERT INTO `cms_content_attr` (`aRef`, `RefID`, `Title`, `Content`, `ShortDesc`, `PhotoDesc`, `link`, `lang`) VALUES
(187, 62, '', ' ', '', NULL, NULL, 'cn'),
(188, 62, '', ' ', '', NULL, NULL, 'my'),
(189, 63, 'PARTNER BRAND COMPANIES', ' ', '', '|||||||', 'companies', 'en'),
(190, 63, '', '   ', '', NULL, NULL, 'cn'),
(191, 63, '', '   ', '', NULL, NULL, 'my'),
(62, 20, '', ' ', '', NULL, NULL, 'cn'),
(63, 20, '', ' ', '', NULL, NULL, 'my'),
(64, 21, '', ' ', '', NULL, NULL, 'cn'),
(65, 21, '', ' ', '', NULL, NULL, 'my'),
(71, 23, '', '     ', '', NULL, NULL, 'my'),
(70, 23, '', '     ', '', NULL, NULL, 'cn'),
(255, 85, 'CONTACT US', ' ', 'We Love to Heard You', '|', 'contactus', 'en'),
(253, 84, '', ' ', '', NULL, NULL, 'cn'),
(254, 84, '', ' ', '', NULL, NULL, 'my'),
(186, 62, 'Business Hours:', 'Mon - Sat: 10am - 6pm', '', NULL, 'hours', 'en'),
(185, 61, '', ' ', '', NULL, NULL, 'my'),
(184, 61, '', ' ', '', NULL, NULL, 'cn'),
(181, 60, '', '  ', '', NULL, NULL, 'cn'),
(182, 60, '', '  ', '', NULL, NULL, 'my'),
(252, 84, 'INSTAGRAM', ' ', 'Connect With Us', NULL, 'instagram', 'en'),
(58, 18, '', ' ', '', NULL, NULL, 'cn'),
(59, 18, '', ' ', '', NULL, NULL, 'my'),
(60, 19, '', ' ', '', NULL, NULL, 'cn'),
(61, 19, '', ' ', '', NULL, NULL, 'my'),
(179, 59, '', '           ', '', NULL, NULL, 'my'),
(180, 60, 'Phone Number', '016 500 9022', '', '|', 'phone', 'en'),
(178, 59, '', '           ', '', NULL, NULL, 'cn'),
(175, 58, '', ' ', '', NULL, NULL, 'cn'),
(176, 58, '', ' ', '', NULL, NULL, 'my'),
(174, 58, 'contact us bg', ' ', '', NULL, 'contactusbg', 'en'),
(192, 64, 'Founder', 'Master who has been in painting industry for 20 years, from the age of 14 to the present seen and met numerous masters learned a lot from them. When I was 17 years old, I became a partner with a friend by chance accumulated a lot of experience from an ordinary employee slowly upgraded to a partner at that time is already a good start\r\n\r\nIn 2014, another opportunity to be a boss came around We took over the paint department of an auto repair company. That\'s how Colourful Painting was born \"1 September 2014\" this is the birth date at the beginning, the business was run in the traditional way. After doing so, we felt that it did not meet the needs of modern people. In order to let customers have better service and experience\r\n\r\n2015, officially transformed started to study what modern people want for their cars make different adjustments to each customer\'s requirements\r\n\r\n2016, three thing achieved, which is created the All Horse Painting Exchange Group Every year, I will lead a group of painters to learn and communicate together. In order to improve our work standard and let customers get a better experience Every year, we will go to major brand paint factory training to learn more knowledge\r\n\r\nSecondly, make a short film with many details of the work steps let customers know the value of their money spend on\r\n\r\nThirdly, learn more techniques and knowledge from the most difficult polishing problems of paint specialists to the various details of work\r\nto more detailed selection of materials\r\n \r\nAt the beginning of 2019, AIKKA PAINT held a painting carnival. We also got the title of VIP WORKSHOP at that time We selected professional workshops in dozens of paint shops', '<span class=\"red\">FOUNDER</span> KOK LEE', '|||||', 'founder', 'en'),
(166, 55, '', '  ', '', NULL, NULL, 'cn'),
(167, 55, '', '  ', '', NULL, NULL, 'my'),
(177, 59, 'location', '<span class=\"locationf\">4, Jalan Bakawali 72, \r\nTaman Johor Jaya , \r\n81100 Johor Bahru, Johor.</span>', 'Colourful Painting Workshop', '', 'location', 'en'),
(171, 57, 'CALL US FOR BOOKING', ' ', '', NULL, 'contactus', 'en'),
(172, 57, '', ' ', '', NULL, NULL, 'cn'),
(173, 57, '', ' ', '', NULL, NULL, 'my'),
(193, 64, '', '  ', '', NULL, NULL, 'cn'),
(194, 64, '', '  ', '', NULL, NULL, 'my'),
(195, 65, 'Founder BG', ' ', '', NULL, 'founderbg', 'en'),
(196, 65, '', ' ', '', NULL, NULL, 'cn'),
(197, 65, '', ' ', '', NULL, NULL, 'my'),
(198, 66, 'CAR PAINTING', 'Normal Car Painting Job\r\nTouch -up Paint Job\r\nSpecial Colour Repaint', '', '', 'painting', 'en'),
(199, 66, '', '   ', '', NULL, NULL, 'cn'),
(200, 66, '', '   ', '', NULL, NULL, 'my'),
(201, 67, 'CAR POLISHING', 'Normal Car Polishing\r\nCar Coating Service\r\nWindsrceen Coating', '', '', 'polishing', 'en'),
(202, 67, '', '  ', '', NULL, NULL, 'cn'),
(203, 67, '', '  ', '', NULL, NULL, 'my'),
(204, 68, 'CAR BODYKIT', 'Car Bodykit Supply\r\nBodykit Convertion\r\nCar Paint Supply\r\nSpecial Colour Supply', '', '', 'bodykit', 'en'),
(205, 68, '', '    ', '', NULL, NULL, 'cn'),
(206, 68, '', '    ', '', NULL, NULL, 'my'),
(207, 69, 'brief bg', ' ', '', '|', 'briefbg', 'en'),
(208, 69, '', '  ', '', NULL, NULL, 'cn'),
(209, 69, '', '  ', '', NULL, NULL, 'my'),
(210, 70, 'ABOUT', 'The company was founded in 2014 for the convenience of our customers, our company is located in johor bahru center point, tampoi district has been in the industry for more than 20 years there are more than 2+++ cars sprayed on hand ​more than 3+++ cars have been polished ​more than 200k screw clips for disassembly and assembly', 'COLOURFUL PAINTING WORKSHOP', '|', 'aboutus', 'en'),
(211, 70, '', '  ', '', NULL, NULL, 'cn'),
(212, 70, '', '  ', '', NULL, NULL, 'my'),
(213, 71, 'CORE VALUES', 'Colorful Car Painting Excellence Keep Learning More New Knowledge And New Technology Do The Best In Every Step Of Painting Let You Get Better Serviceut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci ', '', '', 'values', 'en'),
(214, 71, '', '  ', '', NULL, NULL, 'cn'),
(215, 71, '', '  ', '', NULL, NULL, 'my'),
(216, 72, 'VISION', 'We Will Do One-stop Service In The Future Will Allow Customers To Get Better Service All Customers Who Come Here Will Think Of Colorful Cars As Long As They Think Of Cars.', '', NULL, 'vision', 'en'),
(217, 72, '', ' ', '', NULL, NULL, 'cn'),
(218, 72, '', ' ', '', NULL, NULL, 'my'),
(219, 73, 'WHAT WE DO', 'Whole Car Shell Painting\r\nWhole Car Color Change Painting\r\nWhole Car Bodykit Modification\r\n​Car Accident Repair\r\nPartial Car Repair Spray Paint\r\nCar Polish\r\nAutomotive Coating\r\nSpraying Material Buying And Selling Service', '', '||', 'whatwedo', 'en'),
(220, 73, '', '       ', '', NULL, NULL, 'cn'),
(221, 73, '', '       ', '', NULL, NULL, 'my'),
(222, 74, 'OUR PORTFOLIO', ' ', '', '|||||', 'portfolio', 'en'),
(223, 74, '', '   ', '', NULL, NULL, 'cn'),
(224, 74, '', '   ', '', NULL, NULL, 'my'),
(225, 75, 'aboutusbg', ' ', '', NULL, 'aboutusbg', 'en'),
(226, 75, '', ' ', '', NULL, NULL, 'cn'),
(227, 75, '', ' ', '', NULL, NULL, 'my'),
(228, 76, 'whatsapp', '+6012-751 9022', '', NULL, 'whatsapp', 'en'),
(229, 76, '', ' ', '', NULL, NULL, 'cn'),
(230, 76, '', ' ', '', NULL, NULL, 'my'),
(231, 77, 'messenger', 'colourfulpaintingworkshop/', '', '', 'messenger', 'en'),
(232, 77, '', '  ', '', NULL, NULL, 'cn'),
(233, 77, '', '  ', '', NULL, NULL, 'my'),
(234, 78, 'brief bg xs', ' ', '', NULL, 'xsbriefbg', 'en'),
(235, 78, '', ' ', '', NULL, NULL, 'cn'),
(236, 78, '', ' ', '', NULL, NULL, 'my'),
(237, 79, 'WHO WE ARE', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. \r\n\r\nDuis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi.', 'About Us', '|', 'aboutus', 'en'),
(238, 79, '', '  ', '', NULL, NULL, 'cn'),
(239, 79, '', '  ', '', NULL, NULL, 'my'),
(240, 80, 'STYLIST', ' ', 'Our Team', NULL, 'stylist', 'en'),
(241, 80, '', ' ', '', NULL, NULL, 'cn'),
(242, 80, '', ' ', '', NULL, NULL, 'my'),
(243, 81, 'PRICE LIST & SERVICES', '', 'We Serve You Better', NULL, 'service', 'en'),
(244, 81, '', ' ', '', NULL, NULL, 'cn'),
(245, 81, '', ' ', '', NULL, NULL, 'my'),
(246, 82, 'PROMOTION', ' ', 'Enjoy Quality Service', NULL, 'promotion', 'en'),
(247, 82, '', ' ', '', NULL, NULL, 'cn'),
(248, 82, '', ' ', '', NULL, NULL, 'my'),
(249, 83, 'GOOGLE REVIEWS', '', 'Client Love', NULL, 'review', 'en'),
(250, 83, '', ' ', '', NULL, NULL, 'cn'),
(251, 83, '', ' ', '', NULL, NULL, 'my'),
(256, 85, '', '  ', '', NULL, NULL, 'cn'),
(257, 85, '', '  ', '', NULL, NULL, 'my'),
(258, 86, 'copyright', '©2023 Zoca Hair. All Rights Reserved Powered By B&C Design', '', NULL, 'copyright', 'en'),
(259, 86, '', ' ', '', NULL, NULL, 'cn'),
(260, 86, '', ' ', '', NULL, NULL, 'my');

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

--
-- Table structure for table `cms_courier`
--

CREATE TABLE `cms_courier` (
  `ref` int(11) NOT NULL,
  `subcat` varchar(50) NOT NULL,
  `photo` text NOT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL,
  `Extension` varchar(250) NOT NULL,
  `SKU` varchar(255) NOT NULL,
  `Stock` varchar(255) NOT NULL,
  `remark` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_courier_attr`
--

CREATE TABLE `cms_courier_attr` (
  `aRef` int(11) NOT NULL,
  `RefID` int(11) NOT NULL,
  `Title` varchar(50) NOT NULL,
  `ShortDesc` text NOT NULL,
  `Price` double DEFAULT NULL,
  `PriceSG` double DEFAULT NULL,
  `OfferPrice` double DEFAULT NULL,
  `OfferPriceSG` double DEFAULT NULL,
  `Discount` int(11) DEFAULT NULL,
  `Weight` double DEFAULT NULL,
  `Dimension` varchar(50) NOT NULL,
  `PhotoDesc` varchar(200) NOT NULL,
  `lang` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_courier_cat`
--

CREATE TABLE `cms_courier_cat` (
  `ref` int(11) NOT NULL,
  `subcat` int(11) DEFAULT NULL,
  `Title` varchar(250) NOT NULL,
  `ShortDesc` text NOT NULL,
  `photo` text DEFAULT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL,
  `link` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_job_seeker`
--

CREATE TABLE `cms_job_seeker` (
  `ref` int(11) NOT NULL,
  `photo` longtext DEFAULT NULL,
  `passport` longtext DEFAULT NULL,
  `cert` longtext DEFAULT NULL,
  `others` longtext DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `cName` varchar(255) DEFAULT NULL,
  `NRIC` varchar(25) DEFAULT NULL,
  `DOB` varchar(25) DEFAULT NULL,
  `Gender` varchar(11) DEFAULT NULL,
  `Mobile` varchar(100) DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `Address` longtext DEFAULT NULL,
  `PostCode` varchar(15) DEFAULT NULL,
  `State` varchar(50) DEFAULT NULL,
  `City` varchar(50) DEFAULT NULL,
  `Country` varchar(50) DEFAULT NULL,
  `Wechat` varchar(50) DEFAULT NULL,
  `Maritial` varchar(50) DEFAULT NULL,
  `Child` varchar(11) DEFAULT NULL,
  `Height` varchar(11) DEFAULT NULL,
  `Weight` varchar(11) DEFAULT NULL,
  `Position` varchar(100) DEFAULT NULL,
  `Education` longtext DEFAULT NULL,
  `Working` longtext DEFAULT NULL,
  `Lang` longtext DEFAULT NULL,
  `License` varchar(50) DEFAULT NULL,
  `License_Type` varchar(50) DEFAULT NULL,
  `Skilling` varchar(11) DEFAULT NULL,
  `Skill` longtext DEFAULT NULL,
  `Salary` varchar(50) DEFAULT NULL,
  `av` varchar(11) DEFAULT NULL,
  `datecreate` int(11) DEFAULT NULL,
  `dateupdate` int(11) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member_attr`
--

CREATE TABLE `cms_member_attr` (
  `aRef` int(11) NOT NULL,
  `RefID` int(11) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Nationality` varchar(50) NOT NULL,
  `Company` varchar(255) DEFAULT NULL,
  `RegID` varchar(30) NOT NULL,
  `NRIC` varchar(25) DEFAULT NULL,
  `DOB` varchar(25) DEFAULT NULL,
  `Gender` varchar(1) NOT NULL,
  `Tel` mediumtext DEFAULT NULL,
  `Mobile` varchar(100) DEFAULT NULL,
  `Fax` mediumtext DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `Address` longtext DEFAULT NULL,
  `PostCode` varchar(15) DEFAULT NULL,
  `State` varchar(50) DEFAULT NULL,
  `City` varchar(50) DEFAULT NULL,
  `Country` varchar(50) DEFAULT NULL,
  `Remark` text NOT NULL,
  `Note` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member_cart`
--

CREATE TABLE `cms_member_cart` (
  `ref` int(11) NOT NULL,
  `mem` varchar(50) NOT NULL,
  `cart` text DEFAULT NULL,
  `cart2` text DEFAULT NULL,
  `info` text DEFAULT NULL,
  `datecreate` int(20) NOT NULL,
  `dateupdate` int(20) NOT NULL,
  `remark` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member_course`
--

CREATE TABLE `cms_member_course` (
  `ref` int(11) NOT NULL,
  `cat` int(11) NOT NULL,
  `active` int(2) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member_course_attr`
--

CREATE TABLE `cms_member_course_attr` (
  `ref` int(11) NOT NULL,
  `RefID` int(11) NOT NULL,
  `Title` varchar(50) NOT NULL,
  `Price` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member_course_cat`
--

CREATE TABLE `cms_member_course_cat` (
  `ref` int(11) NOT NULL,
  `Title` varchar(250) NOT NULL,
  `ShortDesc` text NOT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member_emergency`
--

CREATE TABLE `cms_member_emergency` (
  `aRef` int(11) NOT NULL,
  `RefID` int(11) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Company` varchar(255) DEFAULT NULL,
  `Occupation` varchar(100) DEFAULT NULL,
  `NRIC` varchar(25) DEFAULT NULL,
  `DOB` varchar(25) DEFAULT NULL,
  `Tel` mediumtext DEFAULT NULL,
  `Mobile` varchar(100) DEFAULT NULL,
  `Fax` mediumtext DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `Address` longtext DEFAULT NULL,
  `PostCode` varchar(15) DEFAULT NULL,
  `State` varchar(50) DEFAULT NULL,
  `City` varchar(50) DEFAULT NULL,
  `Country` varchar(50) DEFAULT NULL,
  `Remark` text NOT NULL,
  `Note` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member_orders`
--

CREATE TABLE `cms_member_orders` (
  `ref` int(11) NOT NULL,
  `inv` int(50) NOT NULL,
  `user` int(11) NOT NULL,
  `mem` int(11) NOT NULL,
  `Currency` varchar(5) NOT NULL,
  `Cart` longtext NOT NULL,
  `ShippingInfo` mediumtext NOT NULL,
  `ShippingService` mediumtext NOT NULL,
  `PaymentService` tinytext NOT NULL,
  `Amount` double NOT NULL,
  `dateCreate` int(11) NOT NULL,
  `dateUpdate` int(11) NOT NULL,
  `Status` int(11) NOT NULL DEFAULT 1,
  `PaymentStatus` tinyint(4) NOT NULL,
  `Remark` text NOT NULL,
  `TrackingNumber` tinytext NOT NULL,
  `expdate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member_orders_backup`
--

CREATE TABLE `cms_member_orders_backup` (
  `ref` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `mem` int(11) NOT NULL,
  `Currency` varchar(5) NOT NULL,
  `Cart` longtext NOT NULL,
  `ShippingInfo` mediumtext NOT NULL,
  `ShippingService` mediumtext NOT NULL,
  `PaymentService` tinytext NOT NULL,
  `Amount` double NOT NULL,
  `dateCreate` int(11) NOT NULL,
  `dateUpdate` int(11) NOT NULL,
  `Status` int(11) NOT NULL DEFAULT 1,
  `PaymentStatus` tinyint(4) NOT NULL,
  `Remark` text NOT NULL,
  `TrackingNumber` tinytext NOT NULL,
  `expdate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member_parent`
--

CREATE TABLE `cms_member_parent` (
  `aRef` int(11) NOT NULL,
  `RefID` int(11) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Company` varchar(255) DEFAULT NULL,
  `Occupation` varchar(100) DEFAULT NULL,
  `NRIC` varchar(25) DEFAULT NULL,
  `DOB` varchar(25) DEFAULT NULL,
  `Tel` mediumtext DEFAULT NULL,
  `Mobile` varchar(100) DEFAULT NULL,
  `Fax` mediumtext DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `Address` longtext DEFAULT NULL,
  `PostCode` varchar(15) DEFAULT NULL,
  `State` varchar(50) DEFAULT NULL,
  `City` varchar(50) DEFAULT NULL,
  `Country` varchar(50) DEFAULT NULL,
  `Remark` text NOT NULL,
  `Note` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member_referer`
--

CREATE TABLE `cms_member_referer` (
  `ref` int(11) NOT NULL,
  `RefID` int(11) NOT NULL,
  `referer` varchar(50) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member_rfid`
--

CREATE TABLE `cms_member_rfid` (
  `ref` int(11) NOT NULL,
  `RefID` int(11) NOT NULL,
  `cardID` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member_time`
--

CREATE TABLE `cms_member_time` (
  `ref` int(11) NOT NULL,
  `RefID` int(11) NOT NULL,
  `checkin` int(11) NOT NULL,
  `checkout` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_menu`
--

CREATE TABLE `cms_menu` (
  `ref` int(11) NOT NULL,
  `subcat` varchar(40) DEFAULT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `queue` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_menu`
--

INSERT INTO `cms_menu` (`ref`, `subcat`, `active`, `datecreate`, `queue`) VALUES
(1, '', 1, 1582704227, 1),
(2, '', 1, 1582704231, 2),
(3, '', 1, 1582704235, 3),
(4, '', 1, 1582704240, 4),
(5, '', 1, 1629787587, 5),
(7, '', 1, 1679969603, 6),
(8, '', 1, 1691941050, 7);

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

--
-- Table structure for table `cms_menu_attr`
--

CREATE TABLE `cms_menu_attr` (
  `aRef` int(11) NOT NULL,
  `RefID` int(11) NOT NULL,
  `Title` varchar(250) NOT NULL,
  `dropdown` text NOT NULL,
  `link` text NOT NULL,
  `lang` varchar(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_menu_attr`
--

INSERT INTO `cms_menu_attr` (`aRef`, `RefID`, `Title`, `dropdown`, `link`, `lang`) VALUES
(1, 1, 'HOME', '', '', 'en'),
(2, 1, '', '', '', 'cn'),
(3, 1, '', '', '', 'my'),
(4, 2, 'ABOUT', '', '', 'en'),
(5, 2, '', '', '', 'cn'),
(6, 2, '', '', '', 'my'),
(7, 3, 'STYLIST', '', '', 'en'),
(8, 3, '', '', '', 'cn'),
(9, 3, '', '', '', 'my'),
(10, 4, 'PRICE LIST & SERVICES', '', '', 'en'),
(11, 4, '', '', '', 'cn'),
(12, 4, '', '', '', 'my'),
(19, 7, 'PROMOTION', '', '', 'en'),
(20, 7, '', '', '', 'cn'),
(21, 7, '', '', '', 'my'),
(22, 8, 'CONTACT', '', '', 'en'),
(23, 8, '', '', '', 'cn'),
(24, 8, '', '', '', 'my');

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

--
-- Table structure for table `cms_news`
--

CREATE TABLE `cms_news` (
  `ref` int(11) NOT NULL,
  `subcat` varchar(50) DEFAULT NULL,
  `photo` varchar(450) DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  `datecreate` int(11) DEFAULT NULL,
  `dateupdate` int(11) DEFAULT NULL,
  `remark` varchar(11) DEFAULT NULL,
  `style` varchar(11) DEFAULT NULL,
  `queue` varchar(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_news`
--

INSERT INTO `cms_news` (`ref`, `subcat`, `photo`, `active`, `datecreate`, `dateupdate`, `remark`, `style`, `queue`) VALUES
(1, 'c4ca4238a0b923820dcc509a6f75849b', '1672409528cmd.php.jpg|', 1, 1606706159, 1672409528, '', NULL, NULL),
(2, 'c4ca4238a0b923820dcc509a6f75849b', '', 1, 1607055760, 1607055760, '', NULL, NULL),
(3, 'c81e728d9d4c2f636f067f89cc14862c', '', 1, 1692002694, 1692002694, '', NULL, NULL),
(4, 'c81e728d9d4c2f636f067f89cc14862c', '', 1, 1692002909, 1692002909, '', NULL, NULL),
(5, 'c81e728d9d4c2f636f067f89cc14862c', '', 1, 1692002923, 1692002923, '', NULL, NULL),
(6, 'c81e728d9d4c2f636f067f89cc14862c', '', 1, 1692002938, 1692002938, '', NULL, NULL);

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

--
-- Table structure for table `cms_news_attr`
--

CREATE TABLE `cms_news_attr` (
  `aRef` int(11) NOT NULL,
  `RefID` int(11) NOT NULL,
  `Title` varchar(200) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Phone` varchar(50) DEFAULT NULL,
  `ShortDesc` text DEFAULT NULL,
  `PhotoDesc` varchar(200) DEFAULT NULL,
  `datenews` int(11) DEFAULT NULL,
  `lang` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_news_attr`
--

INSERT INTO `cms_news_attr` (`aRef`, `RefID`, `Title`, `Name`, `Phone`, `ShortDesc`, `PhotoDesc`, `datenews`, `lang`) VALUES
(1, 0, 'De Organcy Sdn Bhd (HQ)', NULL, NULL, 'No 1-1, Jalan Rahmat 2, \r\nTaman Malim Jaya 75250 Melaka.', NULL, 1606665600, 'en'),
(2, 0, '', NULL, NULL, '', NULL, 1606665600, 'cn'),
(3, 0, '', NULL, NULL, '', NULL, 1606665600, 'my'),
(4, 0, 'De Organcy Sdn Bhd (HQ)', NULL, NULL, 'No 1-1, Jalan Rahmat 2, \r\nTaman Malim Jaya 75250 Melaka.', NULL, 1606665600, 'en'),
(5, 0, '', NULL, NULL, '', NULL, 1606665600, 'cn'),
(6, 0, '', NULL, NULL, '', NULL, 1606665600, 'my'),
(7, 1, 'De Organcy Sdn Bhd (HQ)', 'KVEN', '014-314 5931', 'No 1-1, Jalan Rahmat 2, \r\nTaman Malim Jaya 75250 Melaka.', '', 1606665600, 'en'),
(8, 1, '', NULL, NULL, '', NULL, 1606665600, 'cn'),
(9, 1, '', NULL, NULL, '', NULL, 1606665600, 'my'),
(10, 2, 'Johor Bahru ', 'Kelly', '016 333 2211', '43-02, Jalan Permas 11\r\nBandar Baru Permas Jaya 81750 Masai', NULL, 1607011200, 'en'),
(11, 2, '', NULL, NULL, '', NULL, 1607011200, 'cn'),
(12, 2, '', NULL, NULL, '', NULL, 1607011200, 'my'),
(13, 3, 'Promotion 1', '', '', 'Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla ', NULL, 1691942400, 'en'),
(14, 3, '', NULL, NULL, '', NULL, 1691942400, 'cn'),
(15, 3, '', NULL, NULL, '', NULL, 1691942400, 'my'),
(16, 4, 'Promotion 2', '', '', 'Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla ', NULL, 1691942400, 'en'),
(17, 4, '', NULL, NULL, '', NULL, 1691942400, 'cn'),
(18, 4, '', NULL, NULL, '', NULL, 1691942400, 'my'),
(19, 5, 'Promotion 3', '', '', 'Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla ', NULL, 1691942400, 'en'),
(20, 5, '', NULL, NULL, '', NULL, 1691942400, 'cn'),
(21, 5, '', NULL, NULL, '', NULL, 1691942400, 'my'),
(22, 6, 'Promotion 4', '', '', 'Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla ', NULL, 1691942400, 'en'),
(23, 6, '', NULL, NULL, '', NULL, 1691942400, 'cn'),
(24, 6, '', NULL, NULL, '', NULL, 1691942400, 'my');

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

--
-- Table structure for table `cms_news_cat`
--

CREATE TABLE `cms_news_cat` (
  `ref` int(11) NOT NULL,
  `Title` varchar(250) NOT NULL,
  `ShortDesc` text NOT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_news_cat`
--

INSERT INTO `cms_news_cat` (`ref`, `Title`, `ShortDesc`, `active`, `datecreate`, `dateupdate`) VALUES
(2, 'Promotion', '', 1, 1692002626, 1692002626);

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

--
-- Table structure for table `cms_prod`
--

CREATE TABLE `cms_prod` (
  `ref` int(11) NOT NULL,
  `subcat` varchar(40) NOT NULL,
  `Brand` varchar(40) DEFAULT NULL,
  `photo` text DEFAULT NULL,
  `file` longtext DEFAULT NULL,
  `descphoto` text DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  `datecreate` int(11) DEFAULT NULL,
  `dateupdate` int(11) DEFAULT NULL,
  `Extension` varchar(250) DEFAULT NULL,
  `SKU` varchar(255) DEFAULT NULL,
  `Stock` varchar(255) DEFAULT NULL,
  `Ext` text DEFAULT NULL,
  `remark` int(11) DEFAULT NULL,
  `first` text DEFAULT NULL,
  `feature` int(11) DEFAULT NULL,
  `queue` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_prod`
--

INSERT INTO `cms_prod` (`ref`, `subcat`, `Brand`, `photo`, `file`, `descphoto`, `active`, `datecreate`, `dateupdate`, `Extension`, `SKU`, `Stock`, `Ext`, `remark`, `first`, `feature`, `queue`) VALUES
(1, 'c4ca4238a0b923820dcc509a6f75849b', NULL, '15827188700.png|', '15827999270.pdf', '', 1, 1582718723, 1582799927, '', '', '0|', NULL, 0, '', 1, NULL),
(2, 'c4ca4238a0b923820dcc509a6f75849b', NULL, '15827189390.jpg|', '15828000000.pdf', '', 1, 1582718913, 1582800000, '', '', '0|', NULL, 0, '', 1, NULL),
(3, 'c4ca4238a0b923820dcc509a6f75849b', NULL, '15827189700.jpg|', '15828000580.pdf', '', 1, 1582718962, 1582800058, '', '', '0|', NULL, 0, '', 1, NULL),
(4, 'c4ca4238a0b923820dcc509a6f75849b', NULL, '15827190010.jpg|', '15828000980.pdf', '', 1, 1582718995, 1582800098, '', '', '0|', NULL, 0, '', 1, NULL),
(5, 'c4ca4238a0b923820dcc509a6f75849b', NULL, '15827190480.png|', '', '', 1, 1582719027, 1583226924, '', '', '0|', NULL, 0, '', 0, NULL),
(6, 'c4ca4238a0b923820dcc509a6f75849b', NULL, '15827190690.jpg|', '', '', 1, 1582719069, 1583226929, '', '', '0|', NULL, 0, '', 0, NULL),
(7, 'c4ca4238a0b923820dcc509a6f75849b', NULL, '15827190860.png|', '', '', 1, 1582719086, 1583226933, '', '', '0|', NULL, 0, '', 0, NULL),
(8, 'c4ca4238a0b923820dcc509a6f75849b', NULL, '15832150480.jpg|', '', '', 1, 1583215048, 1583215048, '', '', '0|', NULL, 0, NULL, 0, NULL),
(9, 'c4ca4238a0b923820dcc509a6f75849b', NULL, '15832152250.jpg|', '', '', 1, 1583215225, 1583215225, '', '', '0|', NULL, 0, NULL, 0, NULL);

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

--
-- Table structure for table `cms_prod_attr`
--

CREATE TABLE `cms_prod_attr` (
  `aRef` int(11) NOT NULL,
  `RefID` int(11) DEFAULT NULL,
  `Title` varchar(255) DEFAULT NULL,
  `SubTitle` varchar(255) DEFAULT NULL,
  `ShortDesc` text DEFAULT NULL,
  `OriPrice` double DEFAULT NULL,
  `Price` double DEFAULT NULL,
  `PriceSG` double DEFAULT NULL,
  `OfferPrice` double DEFAULT NULL,
  `OfferPriceSG` double DEFAULT NULL,
  `Discount` int(11) DEFAULT NULL,
  `Weight` int(30) DEFAULT NULL,
  `Dimension` varchar(50) DEFAULT NULL,
  `Age` varchar(255) DEFAULT NULL,
  `PhotoDesc` varchar(200) DEFAULT NULL,
  `PhotoDesc2` text DEFAULT NULL,
  `Link` longtext DEFAULT NULL,
  `Redirect` longtext DEFAULT NULL,
  `Remark` longtext DEFAULT NULL,
  `lang` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_prod_attr`
--

INSERT INTO `cms_prod_attr` (`aRef`, `RefID`, `Title`, `SubTitle`, `ShortDesc`, `OriPrice`, `Price`, `PriceSG`, `OfferPrice`, `OfferPriceSG`, `Discount`, `Weight`, `Dimension`, `Age`, `PhotoDesc`, `PhotoDesc2`, `Link`, `Redirect`, `Remark`, `lang`) VALUES
(1, 1, 'ApeosPort-IV 3065 / 3060 / 2060\r\nDigital Black and\r\nWhite Multifunction Device', 'Productivity, flexibility and simplicity', '', 0, 0, NULL, 0, NULL, 0, 0, '0*0*0', NULL, '|', '', '', '', '', 'en'),
(2, 2, 'ApeosPort-IV 5070 / 4070 / 3070\r\nDigital Black and\r\nWhite Multifunction Device', 'Raise your productivity, Reduce Costs. Stay secure', '', 0, 0, NULL, 0, NULL, 0, 0, '0*0*0', NULL, '|', '', '', '', '', 'en'),
(3, 3, 'ApeosPort-IV C5570 / C4470 /\r\nC3370/ C2270\r\nDigital Colour Multifunction Device', 'Colourful Innovation', '', 0, 0, NULL, 0, NULL, 0, 0, '0*0*0', NULL, '|', '', '', '', '', 'en'),
(4, 4, 'XEROR D95A / D110 / D125\r\nCopier / Printer', 'The power to print more for less, and excite your customers', '', 0, 0, NULL, 0, NULL, 0, 0, '0*0*0', NULL, '|', '', '', '', '', 'en'),
(5, 5, 'Fuji Xerox DocuCentre/ApeosPort-VII /\r\nC2273 / C3372 / C3373 / C4473 /\r\n C5573 / C6673 / C7773', '', '', 0, 0, NULL, 0, NULL, 0, 0, '0*0*0', NULL, '|', '', '', '', '', 'en'),
(6, 6, 'Fuji Xerox DocuCentre-V C2263 / C2265', '', '', 0, 0, NULL, 0, NULL, 0, 0, '0*0*0', NULL, '|', '', '', '', '', 'en'),
(7, 7, 'Fuji Xerox DocuCentre SC2022', '', '', 0, 0, NULL, 0, NULL, 0, 0, '0*0*0', NULL, '|', '', '', '', '', 'en'),
(8, 8, 'ApeosPort-IV 3065 / 3060 / 2060 Digital Black and White Multifunction Device', '', '', 0, 0, NULL, 0, NULL, 0, 0, '0*0*0', NULL, NULL, NULL, '', '', '', 'en'),
(9, 9, 'ApeosPort-IV 5070 / 4070 / 3070 Digital Black and White Multifunction Device', '', '', 0, 0, NULL, 0, NULL, 0, 0, '0*0*0', NULL, NULL, NULL, '', '', '', 'en');

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

--
-- Table structure for table `cms_prod_backup`
--

CREATE TABLE `cms_prod_backup` (
  `ref` int(11) NOT NULL,
  `subcat` varchar(40) NOT NULL,
  `Brand` varchar(40) DEFAULT NULL,
  `photo` text DEFAULT NULL,
  `descphoto` text DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  `datecreate` int(11) DEFAULT NULL,
  `dateupdate` int(11) DEFAULT NULL,
  `Extension` varchar(250) DEFAULT NULL,
  `SKU` varchar(255) DEFAULT NULL,
  `Stock` varchar(255) DEFAULT NULL,
  `Ext` text DEFAULT NULL,
  `remark` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_prod_cat`
--

CREATE TABLE `cms_prod_cat` (
  `ref` int(11) NOT NULL,
  `subcat` varchar(40) DEFAULT NULL,
  `menu` varchar(40) DEFAULT NULL,
  `Title` varchar(250) NOT NULL,
  `ShortDesc` text NOT NULL,
  `Price` double DEFAULT NULL,
  `photo` text DEFAULT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL,
  `queue` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_prod_cat`
--

INSERT INTO `cms_prod_cat` (`ref`, `subcat`, `menu`, `Title`, `ShortDesc`, `Price`, `photo`, `active`, `datecreate`, `dateupdate`, `queue`) VALUES
(1, NULL, 'eccbc87e4b5ce2fe28308fd9f2a7baf3', 'ïƒ˜MFP & Printer Services', '', NULL, '', 1, 1582718587, 1583219817, 0),
(2, NULL, 'eccbc87e4b5ce2fe28308fd9f2a7baf3', 'IT Products / Services / Trading', '', NULL, '1672409442.jpg|', 1, 1583214916, 1672409442, 0),
(3, NULL, 'eccbc87e4b5ce2fe28308fd9f2a7baf3', 'Office Setup / Renovation', '', NULL, '', 1, 1583214929, 1583214929, 0),
(4, NULL, 'eccbc87e4b5ce2fe28308fd9f2a7baf3', 'Tinted Film Services', '', NULL, '', 1, 1583214942, 1583214942, 0);

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

--
-- Table structure for table `cms_promotion`
--

CREATE TABLE `cms_promotion` (
  `ref` int(11) NOT NULL,
  `subcat` varchar(50) NOT NULL,
  `photo` text NOT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL,
  `Brand` text DEFAULT NULL,
  `Extension` text NOT NULL,
  `Extension_Cat` text NOT NULL,
  `Extension_SubCat` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_promotion_cat`
--

CREATE TABLE `cms_promotion_cat` (
  `ref` int(11) NOT NULL,
  `Discount` int(11) NOT NULL,
  `Price` float DEFAULT NULL,
  `OfferPrice` double DEFAULT NULL,
  `Title` varchar(250) NOT NULL,
  `ShortDesc` text NOT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL,
  `datestart` int(50) DEFAULT NULL,
  `dateexp` int(50) NOT NULL,
  `remark` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_pwp`
--

CREATE TABLE `cms_pwp` (
  `ref` int(11) NOT NULL,
  `subcat` varchar(50) NOT NULL,
  `photo` text NOT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL,
  `Extension` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_pwp_cat`
--

CREATE TABLE `cms_pwp_cat` (
  `ref` int(11) NOT NULL,
  `Discount` int(11) NOT NULL,
  `Price` int(20) NOT NULL,
  `Title` varchar(250) NOT NULL,
  `ShortDesc` text NOT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL,
  `dateexp` int(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_sys`
--

CREATE TABLE `cms_sys` (
  `ref` int(11) NOT NULL,
  `Currency` float NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Indexes for table `cms_admin_attr`
--
ALTER TABLE `cms_admin_attr`
  ADD PRIMARY KEY (`aRef`),
  ADD KEY `RefID` (`RefID`);

--
-- Indexes for table `cms_banner`
--
ALTER TABLE `cms_banner`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`),
  ADD KEY `subcat` (`subcat`);

--
-- Indexes for table `cms_banner_attr`
--
ALTER TABLE `cms_banner_attr`
  ADD PRIMARY KEY (`aRef`),
  ADD KEY `RefID` (`RefID`),
  ADD KEY `lang` (`lang`);

--
-- Indexes for table `cms_banner_cat`
--
ALTER TABLE `cms_banner_cat`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`);

--
-- Indexes for table `cms_brand`
--
ALTER TABLE `cms_brand`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`),
  ADD KEY `subcat` (`subcat`);

--
-- Indexes for table `cms_brand_cat`
--
ALTER TABLE `cms_brand_cat`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`);

--
-- Indexes for table `cms_content`
--
ALTER TABLE `cms_content`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`);

--
-- Indexes for table `cms_content_attr`
--
ALTER TABLE `cms_content_attr`
  ADD PRIMARY KEY (`aRef`),
  ADD KEY `RefID` (`RefID`),
  ADD KEY `lang` (`lang`);

--
-- Indexes for table `cms_courier`
--
ALTER TABLE `cms_courier`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`),
  ADD KEY `subcat` (`subcat`);

--
-- Indexes for table `cms_courier_attr`
--
ALTER TABLE `cms_courier_attr`
  ADD PRIMARY KEY (`aRef`),
  ADD KEY `RefID` (`RefID`),
  ADD KEY `lang` (`lang`);

--
-- Indexes for table `cms_courier_cat`
--
ALTER TABLE `cms_courier_cat`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`);

--
-- Indexes for table `cms_job_seeker`
--
ALTER TABLE `cms_job_seeker`
  ADD PRIMARY KEY (`ref`);

--
-- Indexes for table `cms_member_attr`
--
ALTER TABLE `cms_member_attr`
  ADD PRIMARY KEY (`aRef`),
  ADD KEY `RefID` (`RefID`);

--
-- Indexes for table `cms_member_cart`
--
ALTER TABLE `cms_member_cart`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `mem` (`mem`);

--
-- Indexes for table `cms_member_course`
--
ALTER TABLE `cms_member_course`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`),
  ADD KEY `cat` (`cat`);

--
-- Indexes for table `cms_member_course_attr`
--
ALTER TABLE `cms_member_course_attr`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `RefID` (`RefID`);

--
-- Indexes for table `cms_member_course_cat`
--
ALTER TABLE `cms_member_course_cat`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`);

--
-- Indexes for table `cms_member_emergency`
--
ALTER TABLE `cms_member_emergency`
  ADD PRIMARY KEY (`aRef`),
  ADD KEY `RefID` (`RefID`);

--
-- Indexes for table `cms_member_orders`
--
ALTER TABLE `cms_member_orders`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `memID` (`mem`),
  ADD KEY `Status` (`Status`),
  ADD KEY `Sub` (`user`),
  ADD KEY `expdate` (`expdate`);

--
-- Indexes for table `cms_member_orders_backup`
--
ALTER TABLE `cms_member_orders_backup`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `memID` (`mem`),
  ADD KEY `Status` (`Status`),
  ADD KEY `Sub` (`user`),
  ADD KEY `expdate` (`expdate`);

--
-- Indexes for table `cms_member_parent`
--
ALTER TABLE `cms_member_parent`
  ADD PRIMARY KEY (`aRef`),
  ADD KEY `RefID` (`RefID`);

--
-- Indexes for table `cms_member_referer`
--
ALTER TABLE `cms_member_referer`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `RefID` (`RefID`),
  ADD KEY `referer` (`referer`);

--
-- Indexes for table `cms_member_rfid`
--
ALTER TABLE `cms_member_rfid`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `RefID` (`RefID`),
  ADD KEY `cardNo` (`cardID`);

--
-- Indexes for table `cms_member_time`
--
ALTER TABLE `cms_member_time`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `RefID` (`RefID`);

--
-- Indexes for table `cms_menu`
--
ALTER TABLE `cms_menu`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`),
  ADD KEY `subcat` (`subcat`);

--
-- Indexes for table `cms_menu_attr`
--
ALTER TABLE `cms_menu_attr`
  ADD PRIMARY KEY (`aRef`),
  ADD KEY `RefID` (`RefID`);

--
-- Indexes for table `cms_news`
--
ALTER TABLE `cms_news`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `subcat` (`subcat`),
  ADD KEY `active` (`active`);

--
-- Indexes for table `cms_news_attr`
--
ALTER TABLE `cms_news_attr`
  ADD PRIMARY KEY (`aRef`),
  ADD KEY `RefID` (`RefID`);

--
-- Indexes for table `cms_news_cat`
--
ALTER TABLE `cms_news_cat`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`);

--
-- Indexes for table `cms_prod`
--
ALTER TABLE `cms_prod`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `ref` (`ref`),
  ADD KEY `ref_2` (`ref`);

--
-- Indexes for table `cms_prod_attr`
--
ALTER TABLE `cms_prod_attr`
  ADD PRIMARY KEY (`aRef`),
  ADD KEY `aRef` (`aRef`);

--
-- Indexes for table `cms_prod_cat`
--
ALTER TABLE `cms_prod_cat`
  ADD PRIMARY KEY (`ref`);

--
-- Indexes for table `cms_promotion`
--
ALTER TABLE `cms_promotion`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`),
  ADD KEY `subcat` (`subcat`);

--
-- Indexes for table `cms_promotion_cat`
--
ALTER TABLE `cms_promotion_cat`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`);

--
-- Indexes for table `cms_pwp`
--
ALTER TABLE `cms_pwp`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`),
  ADD KEY `subcat` (`subcat`);

--
-- Indexes for table `cms_pwp_cat`
--
ALTER TABLE `cms_pwp_cat`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`);

--
-- Indexes for table `cms_sys`
--
ALTER TABLE `cms_sys`
  ADD PRIMARY KEY (`ref`);

--
-- AUTO_INCREMENT for table `cms_admin_attr`
--
ALTER TABLE `cms_admin_attr`
  MODIFY `aRef` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_banner`
--
ALTER TABLE `cms_banner`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cms_banner_attr`
--
ALTER TABLE `cms_banner_attr`
  MODIFY `aRef` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cms_banner_cat`
--
ALTER TABLE `cms_banner_cat`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cms_brand`
--
ALTER TABLE `cms_brand`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_brand_cat`
--
ALTER TABLE `cms_brand_cat`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_content`
--
ALTER TABLE `cms_content`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=87;

--
-- AUTO_INCREMENT for table `cms_content_attr`
--
ALTER TABLE `cms_content_attr`
  MODIFY `aRef` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=261;

--
-- AUTO_INCREMENT for table `cms_courier`
--
ALTER TABLE `cms_courier`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_courier_attr`
--
ALTER TABLE `cms_courier_attr`
  MODIFY `aRef` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_courier_cat`
--
ALTER TABLE `cms_courier_cat`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_job_seeker`
--
ALTER TABLE `cms_job_seeker`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_member_attr`
--
ALTER TABLE `cms_member_attr`
  MODIFY `aRef` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_member_cart`
--
ALTER TABLE `cms_member_cart`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_member_course`
--
ALTER TABLE `cms_member_course`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_member_course_attr`
--
ALTER TABLE `cms_member_course_attr`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_member_course_cat`
--
ALTER TABLE `cms_member_course_cat`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_member_emergency`
--
ALTER TABLE `cms_member_emergency`
  MODIFY `aRef` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_member_orders`
--
ALTER TABLE `cms_member_orders`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_member_orders_backup`
--
ALTER TABLE `cms_member_orders_backup`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_member_parent`
--
ALTER TABLE `cms_member_parent`
  MODIFY `aRef` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_member_referer`
--
ALTER TABLE `cms_member_referer`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_member_rfid`
--
ALTER TABLE `cms_member_rfid`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_member_time`
--
ALTER TABLE `cms_member_time`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_menu`
--
ALTER TABLE `cms_menu`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `cms_menu_attr`
--
ALTER TABLE `cms_menu_attr`
  MODIFY `aRef` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `cms_news`
--
ALTER TABLE `cms_news`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `cms_news_attr`
--
ALTER TABLE `cms_news_attr`
  MODIFY `aRef` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `cms_news_cat`
--
ALTER TABLE `cms_news_cat`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `cms_prod`
--
ALTER TABLE `cms_prod`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `cms_prod_attr`
--
ALTER TABLE `cms_prod_attr`
  MODIFY `aRef` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `cms_prod_cat`
--
ALTER TABLE `cms_prod_cat`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cms_promotion`
--
ALTER TABLE `cms_promotion`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_promotion_cat`
--
ALTER TABLE `cms_promotion_cat`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_pwp`
--
ALTER TABLE `cms_pwp`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_pwp_cat`
--
ALTER TABLE `cms_pwp_cat`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_sys`
--
ALTER TABLE `cms_sys`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

