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

START TRANSACTION;



--
-- Database: `cms1_jw55`
--

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

--
-- Table structure for table `cms_admin`
--

CREATE TABLE `cms_admin` (
  `ref` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `userpwd` varchar(50) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `level` int(2) NOT NULL,
  `datecreate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_admin`
--

INSERT INTO `cms_admin` (`ref`, `username`, `userpwd`, `active`, `level`, `datecreate`) VALUES
(9, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 1, 99, 1548754770);

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

--
-- 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
(5, 3, '1683022314jwbanner.png|1683022350jwbanner2.png|1683022528jw55banner3.png|', 1, 1631953426, 1683022528);

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

--
-- 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` text NOT NULL,
  `PhotoLink` varchar(100) 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`, `PhotoLink`, `lang`) VALUES
(3, 3, 'Home', '', '<h3 class=\"white-a bwelcome\">WELCOME TO OUR</h3>\r\n\r\n<h1 class=\"yellow-a btitle\">KQ PASAR ONLINE VARIETY GROCERY CHOOSES ARE WAITING FOR YOU</h1>|', 'index/all|', ''),
(5, 5, 'Home', '', '||', '||', ''),
(4, 4, 'Contact Us', '', '', '', '');

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

--
-- 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
(3, 'Home', 'Home', 1, 1622880787, 1623218521);

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

--
-- Table structure for table `cms_booking`
--

CREATE TABLE `cms_booking` (
  `ref` int(11) NOT NULL,
  `Transport` varchar(255) DEFAULT NULL,
  `Vehicle` varchar(255) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Contact` varchar(255) DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `json` longtext DEFAULT NULL,
  `datecreate` varchar(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_booking`
--

INSERT INTO `cms_booking` (`ref`, `Transport`, `Vehicle`, `Name`, `Contact`, `Email`, `json`, `datecreate`) VALUES
(1, 'One Way Transfer', 'Toyota Alphard (7 Seater)', 'Belly Gan', '+60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Toyota Alphard (7 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"country\":\"Malaysia\",\"number\":\"+60167301955\",\"pickup_date\":\"09-05-2023\",\"pickup_time\":\"12:30am\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"09-05-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"2 Adult\",\"children\":\"\",\"luggage\":\"2\",\"specialrequest\":\"\"}', '1683050106'),
(10001, 'One Way Transfer', 'Hyundai Starex (11 Seater)', 'Belly Gan', '+60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Hyundai Starex (11 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"country\":\"Malaysia\",\"number\":\"+60167301955\",\"pickup_date\":\"03-05-2023\",\"pickup_time\":\"1:30am\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"03-05-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"2 Adult\",\"children\":\"\",\"luggage\":\"2\",\"specialrequest\":\"\"}', '1683080573'),
(10002, 'One Way Transfer', 'Hyundai Starex (11 Seater)', 'Belly Gan', '+60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Hyundai Starex (11 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"country\":\"Malaysia\",\"number\":\"+60167301955\",\"pickup_date\":\"03-05-2023\",\"pickup_time\":\"1:30am\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"03-05-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"2 Adult\",\"children\":\"\",\"luggage\":\"2\",\"specialrequest\":\"\"}', '1683080673'),
(10003, 'One Way Transfer', 'Hyundai Starex (11 Seater)', 'Belly Gan', '+60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Hyundai Starex (11 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"country\":\"Malaysia\",\"number\":\"+60167301955\",\"pickup_date\":\"03-05-2023\",\"pickup_time\":\"1:30am\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"03-05-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"2 Adult\",\"children\":\"\",\"luggage\":\"2\",\"specialrequest\":\"\"}', '1683080696'),
(10004, 'One Way Transfer', 'Toyota Innova (7 Seater)', 'Belly Gan', '+60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Toyota Innova (7 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"country\":\"Malaysia\",\"number\":\"+60167301955\",\"pickup_date\":\"30-05-2023\",\"pickup_time\":\"15:01\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"30-05-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"5\",\"children\":\"2\",\"luggage\":\"1\",\"specialrequest\":\"no\"}', '1685380145'),
(10005, 'One Way Transfer', 'Toyota Innova (7 Seater)', 'Belly Gan', '+60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Toyota Innova (7 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"country\":\"Malaysia\",\"number\":\"+60167301955\",\"pickup_date\":\"30-05-2023\",\"pickup_time\":\"15:01\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"30-05-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"5\",\"children\":\"2\",\"luggage\":\"1\",\"specialrequest\":\"no\"}', '1685380203'),
(10006, 'One Way Transfer', 'Toyota Innova (7 Seater)', 'Belly Gan', '167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Toyota Innova (7 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"country\":\"Malaysia\",\"number\":\"167301955\",\"pickup_date\":\"30-06-2023\",\"pickup_time\":\"05:41\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"30-06-2023\",\"return_time\":\"01:43\",\"return_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"return_dropoff_address\":\"Bandar Baru Permas Jaya\",\"return_flightdetail\":\"\",\"adult\":\"2\",\"children\":\"3\",\"luggage\":\"4\",\"specialrequest\":\"\"}', '1685814173'),
(10007, 'Two Way Transfer', 'Toyota Alphard (7 Seater)', 'Belly Gan', '123231', 'bellygan@hotmail.com', '{\"transportation\":\"Two Way Transfer\",\"Vehicle\":\"Toyota Alphard (7 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"country\":\"Malaysia\",\"number\":\"123231\",\"pickup_date\":\"12-06-2023\",\"pickup_time\":\"03:46\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"12-06-2023\",\"return_time\":\"07:46\",\"return_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"return_dropoff_address\":\"Bandar Baru Permas Jaya\",\"return_flightdetail\":\"\",\"adult\":\"5\",\"children\":\"5\",\"luggage\":\"1\",\"specialrequest\":\"\"}', '1685814435'),
(10008, 'One Way Transfer', 'Toyota Innova (7 Seater)', 'Belly Gan', '60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Toyota Innova (7 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"number\":\"60167301955\",\"pickup_date\":\"05-07-2023\",\"pickup_time\":\"03:16\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"05-07-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"4\",\"children\":\"4\",\"luggage\":\"3\",\"specialrequest\":\"\"}', '1688541359'),
(10009, 'One Way Transfer', 'Toyota Innova (7 Seater)', 'Belly Gan', '60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Toyota Innova (7 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"number\":\"60167301955\",\"pickup_date\":\"05-07-2023\",\"pickup_time\":\"03:16\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya . &*^^%^&*(\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"05-07-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"4\",\"children\":\"4\",\"luggage\":\"3\",\"specialrequest\":\"\"}', '1688541410'),
(10010, 'One Way Transfer', 'Toyota Innova (7 Seater)', 'Belly Gan', '60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Toyota Innova (7 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"number\":\"60167301955\",\"pickup_date\":\"05-07-2023\",\"pickup_time\":\"03:16\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya . &*^^%^&*(\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"05-07-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"4\",\"children\":\"4\",\"luggage\":\"3\",\"specialrequest\":\"\"}', '1688541500'),
(10011, 'One Way Transfer', 'Toyota Innova (7 Seater)', 'Belly Gan', '60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Toyota Innova (7 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"number\":\"60167301955\",\"pickup_date\":\"05-07-2023\",\"pickup_time\":\"03:16\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya . &*^^%^&*(\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"05-07-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"4\",\"children\":\"4\",\"luggage\":\"3\",\"specialrequest\":\"\"}', '1688541577'),
(10012, 'One Way Transfer', 'Toyota Innova (7 Seater)', 'Belly Gan', '+60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Toyota Innova (7 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"number\":\"+60167301955\",\"pickup_date\":\"05-07-2023\",\"pickup_time\":\"18:20\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"05-07-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"5\",\"children\":\"5\",\"luggage\":\"4\",\"specialrequest\":\"\"}', '1688541669'),
(10013, 'One Way Transfer', 'Toyota Innova (7 Seater)', 'Belly Gan', '+60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Toyota Innova (7 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"number\":\"+60167301955\",\"pickup_date\":\"05-07-2023\",\"pickup_time\":\"18:20\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"05-07-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"5\",\"children\":\"5\",\"luggage\":\"4\",\"specialrequest\":\"\"}', '1688541698'),
(10014, 'One Way Transfer', 'Toyota Innova (7 Seater)', 'Belly Gan', '+60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Toyota Innova (7 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"number\":\"+60167301955\",\"pickup_date\":\"05-07-2023\",\"pickup_time\":\"18:20\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"05-07-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"5\",\"children\":\"5\",\"luggage\":\"4\",\"specialrequest\":\"\"}', '1688541733'),
(10015, 'One Way Transfer', 'Toyota Innova (7 Seater)', 'Belly Gan', '+60167301955', 'bellygan@hotmail.com', '{\"transportation\":\"One Way Transfer\",\"Vehicle\":\"Toyota Innova (7 Seater)\",\"name\":\"Belly Gan\",\"email\":\"bellygan@hotmail.com\",\"number\":\"+60167301955\",\"pickup_date\":\"05-07-2023\",\"pickup_time\":\"18:20\",\"pickup_address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"pickup_dropoff_address\":\"Bandar Baru Permas Jaya\",\"pickup_flightdetail\":\"\",\"return_date\":\"05-07-2023\",\"return_time\":\"\",\"return_address\":\"\",\"return_dropoff_address\":\"\",\"return_flightdetail\":\"\",\"adult\":\"5\",\"children\":\"5\",\"luggage\":\"4\",\"specialrequest\":\"\"}', '1688542107');

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

--
-- 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` longtext DEFAULT 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;

--
-- Dumping data for table `cms_brand_cat`
--

INSERT INTO `cms_brand_cat` (`ref`, `photo`, `Discount`, `Price`, `Title`, `ShortDesc`, `active`, `datecreate`, `dateupdate`, `dateexp`) VALUES
(8, '1631179762brand1.png|', 0, 0, 'Farm Fresh', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet', 1, 1631179762, 1631179762, 0),
(9, '1631179802brand2.png|', 0, 0, 'Nutri Plus', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet', 1, 1631179802, 1631179860, 0),
(10, '1631179817brand3.png|', 0, 0, 'Figo', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet', 1, 1631179817, 1631179817, 0),
(11, '1631179873brand1.png|', 0, 0, 'Farm Fresh', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet', 1, 1631179873, 1631179873, 0),
(12, '1631180582brand2.png|', 0, 0, 'Nutri Plus', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet', 1, 1631180582, 1631180582, 0),
(13, '1631180595brand3.png|', 0, 0, 'Figo', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet', 1, 1631180595, 1631180595, 0);

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

--
-- Table structure for table `cms_car`
--

CREATE TABLE `cms_car` (
  `ref` int(11) NOT NULL,
  `photo` longtext DEFAULT NULL,
  `Title` varchar(250) DEFAULT NULL,
  `Description` longtext DEFAULT NULL,
  `Remark` longtext DEFAULT NULL,
  `datecreate` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_car`
--

INSERT INTO `cms_car` (`ref`, `photo`, `Title`, `Description`, `Remark`, `datecreate`) VALUES
(1, '1682501650inova.png|16825014261680883329a1.png|16825014261680883329a2.png|16825014261680883329a3.png|16825014261680883329a4.png|16825014261680883329a5.png|16825014261680883329a6.png|', 'Toyota Innova (7 Seater)', '<b>Trust For Smoother Journey Ahead</b>\r\nThe Innova’s Exciting Exterior Is Backed By Unshakeable Toughness – Its Combination Of Functional Elegance And Power Is Sure To Catch Anyone’s Attention.', 'Able to fit 6 Passengers with 0 Luggage\r\nAble to fit 4 Passengers with 4 Luggage\r\nBudget MPV', '1682501391'),
(2, '1682504213alphad.png|16825043001680868079b1.png|16825043001680868079b2.png|16825043001680868079b3.png|16825043001680868079b4.png|16825043001680868079b5.png|16825043001680868079b6.png|', 'Toyota Alphard (7 Seater)', '<b>The Ideal Luxury MPV</b>\r\nEngrave Your Every Path With A True Leader That Exudes Pure Luxury And Elegance In Its Every Form.', 'Able to fit 6 Passengers\r\nAble to fit 2 Luggage + 4 Hand Carry\r\nLuxury MPV', '1682504206'),
(3, '1682504387starex.png|16825044301680870351c1.png|16825044301680870351c2.png|16825044301680870351c4.png|16825044301680870351c5.png|16825044301680870351c6.png|', 'Hyundai Starex (11 Seater)', '<b>Space, Style & Substance</b>\r\nWith Its Enhanced Exterior Features, The Hyundai Starex Takes Things To A Whole New Level Of Grandeur. The Strong And Reliable Exterior Is Complemented By A Comfortable, Conve- nient And Spacious Interior To Meet All Your Needs.', 'Able to fit 10 Passenger with 0 Luggage\r\nAble to fit 7 Passenger with 6 Medium Luggage \r\nComfort MPV', '1682504387');

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

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

CREATE TABLE `cms_content` (
  `ref` int(11) NOT 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`, `photo`, `active`, `datecreate`, `dateupdate`) VALUES
(158, '1683081770wechat.png|1683081699car-rental.png|', 1, 1683081677, 1683081777),
(148, '1680870351c.png|1680870351c1.png|1680870351c2.png|1680870657c3.png|1680870351c4.png|1680870351c5.png|1680870351c6.png|', 1, 1680870351, 1681200575),
(126, '', 1, 1680585747, 1680585747),
(127, '1680596598cover.png|', 1, 1680596598, 1680596598),
(128, '', 1, 1680596951, 1680596951),
(130, '1680709570cover.png|', 1, 1680709398, 1680709570),
(131, '1680710124p1.png|', 1, 1680710124, 1680710124),
(132, '1680710145p2.png|', 1, 1680710145, 1680710145),
(133, '1680710172p3.png|', 1, 1680710172, 1680710172),
(134, '1680710189p4.png|', 1, 1680710189, 1680710189),
(135, '1680857062cover.png|', 1, 1680857062, 1680857062),
(66, '1680585241cover.png|', 1, 1644914577, 1680585241),
(81, '1680497060a1.png|1680497060a2.png|1680497060a3.png|1680497060a4.png|1680497060a5.png|', 1, 1652258529, 1680502321),
(122, '1680573590instagram.png|', 1, 1680573590, 1680573590),
(147, '1680869840b7.png|1680868079b1.png|1680868079b2.png|1680868079b3.png|1680868079b4.png|1680868079b5.png|1680868079b6.png|', 1, 1680868079, 1681200600),
(116, '', 1, 1657014180, 1657014180),
(149, '1681189066hab.png|1681190044hbg.png|', 1, 1681188859, 1681190044),
(145, '1680865493cover.png|', 1, 1680865493, 1680865493),
(146, '1680868480a7.png|1680883329a1.png|1680883329a2.png|1680883329a3.png|1680883329a4.png|1680883329a5.png|1680883329a6.png|', 1, 1680865731, 1681200539),
(157, '1683021513ezgif.com-webp-to-jpg (1).jpg|', 1, 1683021458, 1683021513),
(120, '1680497429as.png|', 1, 1680497429, 1680576440),
(123, '1680573709xhs.png|', 1, 1680573709, 1680635182),
(124, '1680573747whatsapp.png|', 1, 1680573747, 1680573747),
(125, '1680573770mail.png|', 1, 1680573770, 1680573770),
(119, '1680501223cover.png|', 1, 1680496581, 1680501223),
(121, '1680573557fb.png|', 1, 1680573557, 1680573557),
(150, '1681193256why.png|1681193094why1.png|1681193350why2.png|', 1, 1681192520, 1681195090),
(151, '1681205286d1.png|', 1, 1681205286, 1681205286),
(152, '1681205311d2.png|', 1, 1681205311, 1681205340),
(153, '1681205332d3.png|', 1, 1681205332, 1681205332),
(154, '1681205365d4.png|', 1, 1681205365, 1681205365),
(155, '1681205386d2.png|', 1, 1681205386, 1681205386),
(156, '1681206443d3.png|', 1, 1681206443, 1681206443);

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

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

CREATE TABLE `cms_content_attr` (
  `aRef` int(11) NOT NULL,
  `RefID` int(11) NOT 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
(243, 81, '', '           ', '', '', '', 'my'),
(242, 81, '', '           ', '', '', '', 'cn'),
(359, 121, '', ' ', '', NULL, NULL, 'cn'),
(360, 121, '', ' ', '', NULL, NULL, 'my'),
(361, 122, 'Instagram', 'https://www.instagram.com/jw55transportagency/?hl=en', 'JW 55 Transport Agency 新马客运包车服务', NULL, 'insta', 'en'),
(362, 122, '', ' ', '', NULL, NULL, 'cn'),
(363, 122, '', ' ', '', NULL, NULL, 'my'),
(364, 123, 'XHS', 'https://www.xiaohongshu.com/user/profile/59fc91a34eacab1e49ad872c?xhsshare=CopyLink&appuid=61687fdb0000000002027c0c&apptime=1680635125', 'JW7718590', '|', 'xhs', 'en'),
(365, 123, '', '  ', '', NULL, NULL, 'cn'),
(366, 123, '', '  ', '', NULL, NULL, 'my'),
(367, 124, 'Whatsapp', '+6014-373 2335', '', NULL, 'whatsapp', 'en'),
(368, 124, '', ' ', '', NULL, NULL, 'cn'),
(369, 124, '', ' ', '', NULL, NULL, 'my'),
(370, 125, 'email', 'jwwong924@gmail.com', '', NULL, 'email', 'en'),
(371, 125, '', ' ', '', NULL, NULL, 'cn'),
(372, 125, '', ' ', '', NULL, NULL, 'my'),
(471, 158, '', '     ', '', NULL, NULL, 'my'),
(470, 158, '', '     ', '', NULL, NULL, 'cn'),
(467, 157, '', '  ', '', NULL, NULL, 'cn'),
(468, 157, '', '  ', '', NULL, NULL, 'my'),
(469, 158, 'Wechat', ' ', '', '||', 'wechat', 'en'),
(466, 157, 'Customer Reviews From Whatsapp', '', '', '', 'whatsapp_testi', 'en'),
(430, 145, 'Fleet Cover', ' ', '', NULL, 'fcover', 'en'),
(431, 145, '', ' ', '', NULL, NULL, 'cn'),
(432, 145, '', ' ', '', NULL, NULL, 'my'),
(433, 146, 'Toyota Innova (7 Seater)', 'The Innova’s Exciting Exterior Is Backed By Unshakeable Toughness – Its Combination Of Functional Elegance And Power Is Sure To Catch Anyone’s Attention.\r\n<ul><li>Able to fit 6 Passengers with 0 Luggage</li><li>Able to fit 4 Passengers with 4 Luggage</li><li>Budget MPV</li></ul>', 'Trust For Smoother Journey Ahead', '|||||||', 'f1', 'en'),
(434, 146, '', '              ', '', NULL, NULL, 'cn'),
(435, 146, '', '              ', '', NULL, NULL, 'my'),
(436, 147, 'Toyota Alphard (7 Seater)', 'Engrave Your Every Path With A True Leader That Exudes Pure Luxury And Elegance In Its Every Form.\r\n<ul><li>Able to fit 6 Passengers</li><li>Able to fit 2 Luggage + 4 Hand Carry</li><li>Luxury MPV</li></ul>', 'The Ideal Luxury Mpv', '|||||||', 'f2', 'en'),
(437, 147, '', '                 ', '', NULL, NULL, 'cn'),
(438, 147, '', '                 ', '', NULL, NULL, 'my'),
(439, 148, 'Hyundai Starex (11 Seater)', 'With Its Enhanced Exterior Features, The Hyundai Starex Takes Things To A Whole New Level Of Grandeur. The Strong And Reliable Exterior Is Complemented By A Comfortable, Convenient And Spacious Interior To Meet All Your Needs. \r\n<ul><li>Able to fit 10 Passenger with 0 Luggage</li><li>Able to fit 7 Passenger with 6 Medium Luggage</li><li>Comfort MPV</li></ul>', 'Space, Style & Substance', '|||||||', 'f3', 'en'),
(440, 148, '', '      ', '', NULL, NULL, 'cn'),
(441, 148, '', '      ', '', NULL, NULL, 'my'),
(442, 149, 'Welcome To \r\nJW 55 Transport Agency', 'Singapore And Malaysia Professional Chartered Car Transfer Service SGMY\r\n\r\nWe Can Provide You With Chartered Car Services For Different Destinations\r\n\r\nFamily Trave  ·  Group Travel  ·  Business Attendance\r\n\r\nCompared With Public Transportation, It Can Reach The Destination More Efficiently And Enjoy The Comfort Of Private Air', '', '|', 'haboutus', 'en'),
(443, 149, '', '    ', '', NULL, NULL, 'cn'),
(444, 149, '', '    ', '', NULL, NULL, 'my'),
(445, 150, 'Why Choose Us', 'Singapore-Malaysia One-Way / Round-trip Transfer Service\r\nOne-day Tour/ Multi-day Tour Chartered Vehicle Delivery Service\r\nEven The Whole West Malaysia As Long As You Want To Go\r\nWe Can All Get You To Your Destination Safely\r\n<span class=\"smbb red-a bold-a\">24 hours</span> Service\r\nReasonably Priced With <span class=\"smbb red-a\">No Hidden Charges</span>', '', '|||', 'hwhy', 'en'),
(446, 150, '', '          ', '', NULL, NULL, 'cn'),
(447, 150, '', '          ', '', NULL, NULL, 'my'),
(448, 151, 'D1', ' SDG 1XX', '', NULL, 'd1', 'en'),
(449, 151, '', ' ', '', NULL, NULL, 'cn'),
(450, 151, '', ' ', '', NULL, NULL, 'my'),
(451, 152, 'D2', ' SDG 1X2', '', '|', 'd2', 'en'),
(452, 152, '', '  ', '', NULL, NULL, 'cn'),
(453, 152, '', '  ', '', NULL, NULL, 'my'),
(454, 153, 'D3', ' SDG 12X', '', NULL, 'd3', 'en'),
(455, 153, '', ' ', '', NULL, NULL, 'cn'),
(456, 153, '', ' ', '', NULL, NULL, 'my'),
(457, 154, 'D4', ' SDG 2XX', '', NULL, 'd4', 'en'),
(458, 154, '', ' ', '', NULL, NULL, 'cn'),
(373, 126, 'We Look Forward\r\nTo Your Booking', ' ', '', NULL, 'contactus', 'en'),
(374, 126, '', ' ', '', NULL, NULL, 'cn'),
(375, 126, '', ' ', '', NULL, NULL, 'my'),
(376, 127, 'Booking Cover', ' ', '', NULL, 'bcover', 'en'),
(377, 127, '', ' ', '', NULL, NULL, 'cn'),
(378, 127, '', ' ', '', NULL, NULL, 'my'),
(379, 128, 'Booking Form', 'Thank You For Booking With Us, \r\nWe Will Reply You As Soonest As Possible.', '', NULL, 'booking', 'en'),
(380, 128, '', ' ', '', NULL, NULL, 'cn'),
(381, 128, '', ' ', '', NULL, NULL, 'my'),
(385, 130, 'Pricing Cover', ' ', '', '', 'pcover', 'en'),
(386, 130, '', '   ', '', NULL, NULL, 'cn'),
(387, 130, '', '   ', '', NULL, NULL, 'my'),
(388, 131, 'Travelling\r\nSINGAPORE to JOHOR BAHRU (JB)', ' ', '', NULL, 'p1', 'en'),
(389, 131, '', ' ', '', NULL, NULL, 'cn'),
(390, 131, '', ' ', '', NULL, NULL, 'my'),
(391, 132, 'AIRPORT TRANSFER', ' ', '', NULL, 'p2', 'en'),
(392, 132, '', ' ', '', NULL, NULL, 'cn'),
(393, 132, '', ' ', '', NULL, NULL, 'my'),
(394, 133, 'Traveling\r\nSINGAPORE to MALAYSIA', ' ', '', NULL, 'p3', 'en'),
(395, 133, '', ' ', '', NULL, NULL, 'cn'),
(396, 133, '', ' ', '', NULL, NULL, 'my'),
(397, 134, 'VIP DAY TRIP', ' ', '', NULL, 'p4', 'en'),
(398, 134, '', ' ', '', NULL, NULL, 'cn'),
(399, 134, '', ' ', '', NULL, NULL, 'my'),
(400, 135, 'Testimonials Cover', ' ', '', NULL, 'tcover', 'en'),
(401, 135, '', ' ', '', NULL, NULL, 'cn'),
(402, 135, '', ' ', '', NULL, NULL, 'my'),
(356, 120, '', '  ', '', NULL, NULL, 'cn'),
(357, 120, '', '  ', '', NULL, NULL, 'my'),
(459, 154, '', ' ', '', NULL, NULL, 'my'),
(460, 155, 'D5', ' SDG 3XX', '', NULL, 'd5', 'en'),
(461, 155, '', ' ', '', NULL, NULL, 'cn'),
(462, 155, '', ' ', '', NULL, NULL, 'my'),
(463, 156, 'D6', ' SDG 6XX', '', NULL, 'd6', 'en'),
(464, 156, '', ' ', '', NULL, NULL, 'cn'),
(465, 156, '', ' ', '', NULL, NULL, 'my'),
(196, 66, 'Contact Us Cover', ' ', '', '', 'ccover', 'en'),
(197, 66, '', '     ', '', '', '', 'cn'),
(198, 66, '', '     ', '', '', '', 'my'),
(241, 81, 'About \r\nJW55 Transport Agency', 'TravelSGMY.com by JW 55 Transport Agency was founded in 2015. We are your trusted provider for your Airport Transfer, Event, Business Investigation, One Day or Multi Day Touring Service in Malaysia or Singapore. ', '', '8 Years Of Experience|Safe Driver|Comfort MPV Car|Quality Service|On Time Arrangement|', 'aboutus', 'en'),
(358, 121, 'Facebook', ' https://www.facebook.com/profile.php?id=100054570933970', 'JW 55 Transport Agency 新马客运包车服务', NULL, 'facebook', 'en'),
(355, 120, 'Our Services', 'Airport Transfer Services\r\nDoor To Door Pick Up / Drop Off\r\nWedding Event Transfer\r\nBusiness Investigation\r\nChartered & Driver One-Day / Multi-Day Tour Service', '', '|', 'aservices', 'en'),
(352, 119, 'About Us Cover', ' ', '', '', 'ascover', 'en'),
(353, 119, '', '  ', '', NULL, NULL, 'cn'),
(354, 119, '', '  ', '', 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;

--
-- Dumping data for table `cms_courier`
--

INSERT INTO `cms_courier` (`ref`, `subcat`, `photo`, `active`, `datecreate`, `dateupdate`, `Extension`, `SKU`, `Stock`, `remark`) VALUES
(11, '8f14e45fceea167a5a36dedd4bea2543', '', 1, 1634870142, 1634873867, '', '', '', 0),
(7, '8f14e45fceea167a5a36dedd4bea2543', '', 1, 1634634159, 1634873866, '', '', '', 0),
(10, '8f14e45fceea167a5a36dedd4bea2543', '', 1, 1634870130, 1634873864, '', '', '', 0),
(12, '8f14e45fceea167a5a36dedd4bea2543', '', 1, 1634870427, 1635383738, '', '', '', 0),
(13, '8f14e45fceea167a5a36dedd4bea2543', '', 1, 1634873406, 1634877365, '', '', '', 0),
(14, '8f14e45fceea167a5a36dedd4bea2543', '', 1, 1634873775, 1634877431, '', '', '', 0);

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

--
-- 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,
  `Postcode` longtext 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;

--
-- Dumping data for table `cms_courier_attr`
--

INSERT INTO `cms_courier_attr` (`aRef`, `RefID`, `Title`, `ShortDesc`, `Price`, `Postcode`, `PriceSG`, `OfferPrice`, `OfferPriceSG`, `Discount`, `Weight`, `Dimension`, `PhotoDesc`, `lang`) VALUES
(11, 11, '', '', 8, '79100\r\n79150\r\n80990\r\n81100\r\n81310', NULL, NULL, NULL, NULL, NULL, '', '', ''),
(7, 7, '', '', 5, '80000\r\n80300\r\n80100\r\n80200\r\n80300\r\n80400', NULL, NULL, NULL, NULL, NULL, '', '', ''),
(10, 10, '', '', 6, '80050\r\n80150\r\n80250\r\n80500\r\n81300', NULL, NULL, NULL, NULL, NULL, '', '', ''),
(12, 12, '', '', 3, '81200\r\n80350', NULL, NULL, NULL, NULL, NULL, '', '', ''),
(13, 13, '', '', 10, '81110\r\n81750\r\n81120\r\n81800', NULL, NULL, NULL, NULL, NULL, '', '', ''),
(14, 14, '', '', 14, '81000\r\n81250\r\n81400', NULL, NULL, NULL, NULL, NULL, '', '', '');

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

--
-- 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,
  `Price` double DEFAULT NULL,
  `photo` text DEFAULT NULL,
  `active` int(11) NOT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL,
  `link` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_courier_cat`
--

INSERT INTO `cms_courier_cat` (`ref`, `subcat`, `Title`, `ShortDesc`, `Price`, `photo`, `active`, `datecreate`, `dateupdate`, `link`) VALUES
(7, NULL, 'Next Day Delivery ( JB AREA)', '', NULL, '', 1, 1634632471, 1634869269, NULL),
(8, 7, 'Self Delivery', '', NULL, NULL, 1, 1634632478, 1634632478, NULL);

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

--
-- Table structure for table `cms_form`
--

CREATE TABLE `cms_form` (
  `ref` int(11) NOT NULL,
  `Title` varchar(100) DEFAULT NULL,
  `ShortDesc` longtext DEFAULT NULL,
  `Col` longtext DEFAULT NULL,
  `datestart` varchar(20) DEFAULT NULL,
  `dateend` varchar(20) DEFAULT NULL,
  `photo` longtext DEFAULT NULL,
  `video` longtext DEFAULT NULL,
  `datecreate` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_form_register`
--

CREATE TABLE `cms_form_register` (
  `ref` int(11) NOT NULL,
  `RefID` varchar(50) DEFAULT NULL,
  `Status` varchar(100) DEFAULT NULL,
  `Col` longtext DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `datecreate` varchar(20) DEFAULT NULL,
  `dateupdate` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member`
--

CREATE TABLE `cms_member` (
  `ref` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `userpwd` varchar(50) DEFAULT NULL,
  `point` float DEFAULT 0,
  `cat` int(11) DEFAULT NULL,
  `active` tinyint(1) DEFAULT NULL,
  `level` int(2) DEFAULT NULL,
  `datecreate` int(11) DEFAULT NULL,
  `expdate` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_member`
--

INSERT INTO `cms_member` (`ref`, `username`, `userpwd`, `point`, `cat`, `active`, `level`, `datecreate`, `expdate`) VALUES
(1, 'bellygan@hotmail.com', 'e10adc3949ba59abbe56e057f20f883e', 777.6, NULL, 1, 1, 1641883354, NULL);

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

--
-- Table structure for table `cms_member_address`
--

CREATE TABLE `cms_member_address` (
  `ref` int(11) NOT NULL,
  `mem` varchar(50) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Mobile` varchar(255) DEFAULT NULL,
  `Area` varchar(50) 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` int(11) DEFAULT NULL,
  `datecreate` int(11) 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) DEFAULT NULL,
  `Company` varchar(255) DEFAULT NULL,
  `RegID` varchar(30) DEFAULT NULL,
  `NRIC` varchar(25) DEFAULT NULL,
  `DOB` varchar(25) DEFAULT NULL,
  `Gender` varchar(1) 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 DEFAULT NULL,
  `Note` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_member_attr`
--

INSERT INTO `cms_member_attr` (`aRef`, `RefID`, `Name`, `Nationality`, `Company`, `RegID`, `NRIC`, `DOB`, `Gender`, `Tel`, `Mobile`, `Fax`, `Email`, `Address`, `PostCode`, `State`, `City`, `Country`, `Remark`, `Note`) VALUES
(1, 1, 'Belly', NULL, NULL, NULL, NULL, '', NULL, NULL, '0123456', NULL, 'bellygan@hotmail.com', '', '', '', '', 'c4ca4238a0b923820dcc509a6f75849b', 'c4ca4238a0b923820dcc509a6f75849b', NULL);

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

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

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

--
-- Dumping data for table `cms_member_cart`
--

INSERT INTO `cms_member_cart` (`ref`, `mem`, `info`, `cart`, `cart2`, `shipping`, `latlng`, `km`, `datecreate`, `dateupdate`, `remark`) VALUES
(1, 'c4ca4238a0b923820dcc509a6f75849b', '', '[]', '', '', '', '', 1641883354, 1643094651, '0');

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

--
-- 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_level`
--

CREATE TABLE `cms_member_level` (
  `ref` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `point` int(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cms_member_level`
--

INSERT INTO `cms_member_level` (`ref`, `title`, `point`) VALUES
(1, 'Member', 1),
(2, 'Gold Member', 2),
(3, 'Jade Member', 3);

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

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

CREATE TABLE `cms_member_orders` (
  `ref` int(11) NOT NULL,
  `inv` int(50) DEFAULT NULL,
  `user` int(11) DEFAULT NULL,
  `mem` int(11) DEFAULT NULL,
  `Currency` varchar(5) DEFAULT NULL,
  `Cart` longtext DEFAULT NULL,
  `ShippingInfo` mediumtext DEFAULT NULL,
  `ShippingService` mediumtext DEFAULT NULL,
  `PaymentService` tinytext DEFAULT NULL,
  `Amount` double DEFAULT NULL,
  `Discount` varchar(50) DEFAULT NULL,
  `ShippingFee` varchar(20) DEFAULT NULL,
  `dateCreate` int(11) DEFAULT NULL,
  `dateUpdate` int(11) DEFAULT NULL,
  `dateSend` int(20) DEFAULT NULL,
  `Status` int(11) NOT NULL DEFAULT 1,
  `PaymentStatus` tinyint(4) DEFAULT NULL,
  `Remark` text DEFAULT NULL,
  `courier` longtext DEFAULT NULL,
  `Voucher` longtext DEFAULT NULL,
  `Promotion` longtext DEFAULT NULL,
  `Remark2` mediumtext DEFAULT NULL,
  `Response` longtext DEFAULT NULL,
  `TrackingNumber` tinytext DEFAULT NULL,
  `ShippingStatus` varchar(255) DEFAULT NULL,
  `latlng` varchar(100) DEFAULT NULL,
  `km` varchar(100) DEFAULT NULL,
  `lalamove` longtext DEFAULT NULL,
  `Cash` varchar(11) DEFAULT NULL,
  `senangpay` varchar(11) DEFAULT NULL,
  `view` varchar(11) DEFAULT NULL,
  `expdate` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_member_orders`
--

INSERT INTO `cms_member_orders` (`ref`, `inv`, `user`, `mem`, `Currency`, `Cart`, `ShippingInfo`, `ShippingService`, `PaymentService`, `Amount`, `Discount`, `ShippingFee`, `dateCreate`, `dateUpdate`, `dateSend`, `Status`, `PaymentStatus`, `Remark`, `courier`, `Voucher`, `Promotion`, `Remark2`, `Response`, `TrackingNumber`, `ShippingStatus`, `latlng`, `km`, `lalamove`, `Cash`, `senangpay`, `view`, `expdate`) VALUES
(4, 2, NULL, 1, 'RM', '{\"size\":[\"7|322.2\"],\"addon\":{\"c4ca4238a0b923820dcc509a6f75849b\":[\"Cake Topper|20\",\"Curvy Birthday Candle Set (6pcs)|10\"]},\"currency\":\"RM\",\"price\":[\"352.20\"],\"weight\":[\"0\"],\"zeroweight\":[\"0\"],\"brand\":[\"\"],\"cat\":[\"\"],\"totalprice\":\"352.2\",\"total_weight\":0,\"above\":[\"0\"],\"dimension\":\"**|\",\"photoext\":[\"\"],\"extid\":[\"-1\"],\"extkey\":[\"\"],\"preorder\":[\"1\"],\"datesend\":[\"13-01-2022\"],\"time\":[\"10:00am - 12:00pm\"],\"candle\":[\"Need\"],\"ref\":[\"c4ca4238a0b923820dcc509a6f75849b\"],\"qty\":[\"1\"],\"url\":null}', '{\"name\":\"Belly Gan\",\"mobile\":\"+60167301955\",\"address\":\"43-02, Jalan Permas 11, Bandar Baru Permas Jaya, Bandar Baru Permas Jaya\",\"postcode\":\"81750\",\"city\":\"Johor Bahru\",\"state\":\"Johor\",\"remark\":\"\"}', 'Delivery|13', NULL, 365.2, '', '13', 1641911237, 1641911237, 1643379800, 1, 1, '{\"mode\":\"senangpay\",\"pay\":\"test\",\"status_id\":\"1\",\"order_id\":\"4\"}', '\"\"', '', 'null', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL),
(7, 4, NULL, 1, 'RM', '{\"size\":[\"\"],\"addon\":{\"c81e728d9d4c2f636f067f89cc14862c\":[\"\"]},\"currency\":\"RM\",\"price\":[\"159.00\"],\"weight\":[\"0\"],\"zeroweight\":[\"0\"],\"brand\":[\"\"],\"cat\":[\"\"],\"totalprice\":\"159\",\"total_weight\":0,\"above\":[\"0\"],\"dimension\":\"**|\",\"photoext\":[\"\"],\"extid\":[\"-1\"],\"extkey\":[\"\"],\"preorder\":[\"1\"],\"datesend\":[\"24-01-2022\"],\"time\":[\"2:00pm - 4:00pm\"],\"candle\":[\"Need\"],\"message\":[\"Halo\"],\"ref\":[\"c81e728d9d4c2f636f067f89cc14862c\"],\"qty\":[\"1\"],\"url\":null}', '{\"name\":\"Belly\",\"mobile\":\"0123456\",\"address\":\"No. 168, Jalan SS2\\/4\",\"postcode\":\"47300\",\"city\":\"Petaling Jaya\",\"state\":\"Selangor\",\"remark\":\"\"}', 'Delivery|30.77', NULL, 189.77, '', '30.77', 1643039312, 1643039312, 1641201200, 1, 1, '{\"mode\":\"senangpay\",\"pay\":\"test\",\"status_id\":\"1\",\"order_id\":\"7\"}', '\"\"', '', 'null', NULL, NULL, NULL, NULL, '3.2427594,101.6768019', '21.5', NULL, NULL, '1', NULL, NULL),
(13, 10, NULL, 1, 'RM', '{\"size\":[\"\"],\"addon\":{\"c4ca4238a0b923820dcc509a6f75849b\":[\"\"]},\"aloption\":[\"Classic|0\"],\"currency\":\"RM\",\"price\":[\"259.20\"],\"weight\":[\"0\"],\"zeroweight\":[\"0\"],\"brand\":[\"\"],\"cat\":[\"\"],\"totalprice\":\"259.2\",\"total_weight\":0,\"above\":[\"0\"],\"dimension\":\"**|\",\"photoext\":[\"\"],\"extid\":[\"-1\"],\"extkey\":[\"\"],\"preorder\":[\"1\"],\"datesend\":[\"27-01-2022\"],\"datedelivery\":[\"1643274000\"],\"time\":[\"5:00pm - 6:00pm\"],\"candle\":[\"Need\"],\"message\":[\"\"],\"ref\":[\"c4ca4238a0b923820dcc509a6f75849b\"],\"qty\":[\"1\"],\"url\":null}', '{\"name\":\"Belly\",\"mobile\":\"+6012345678\",\"address\":\"sample address\'gfdsgd\'ghjdgh-fhj!#@$#&({|?>|\",\"postcode\":\"12345\",\"city\":\"johor bahru\'fgbdfgdf\",\"state\":\"Johor\",\"remark\":\"\"}', 'Pickup|0', NULL, 259.2, '', '0', 1643094528, 1643094528, 1643274000, 1, 1, '{\"mode\":\"senangpay\",\"pay\":\"test\",\"status_id\":\"1\",\"order_id\":\"13\"}', '\"Pickup\"', '', 'null', NULL, NULL, NULL, NULL, '', '', NULL, NULL, '1', NULL, NULL),
(12, 11, NULL, 1, 'RM', '{\"size\":[\"\"],\"addon\":{\"c81e728d9d4c2f636f067f89cc14862c\":[\"\"]},\"currency\":\"RM\",\"price\":[\"159.00\"],\"weight\":[\"0\"],\"zeroweight\":[\"0\"],\"brand\":[\"\"],\"cat\":[\"\"],\"totalprice\":\"159\",\"total_weight\":0,\"above\":[\"0\"],\"dimension\":\"**|\",\"photoext\":[\"\"],\"extid\":[\"-1\"],\"extkey\":[\"\"],\"preorder\":[\"1\"],\"datesend\":[\"26-01-2022\"],\"datedelivery\":[\"1643176800\"],\"time\":[\"2:00pm - 4:00pm\"],\"candle\":[\"Need\"],\"message\":[\"\"],\"ref\":[\"c81e728d9d4c2f636f067f89cc14862c\"],\"qty\":[\"1\"],\"url\":null}', '{\"name\":\"Belly Gan\",\"mobile\":\"+60167301955\",\"address\":\"Sample Apartment\",\"postcode\":\"81750\",\"city\":\"Masai\",\"state\":\"Johor\",\"remark\":\"\"}', 'Pickup|0', NULL, 159, '', '0', 1643094061, 1643094061, 1643176800, 1, 1, '{\"mode\":\"senangpay\",\"pay\":\"test\",\"status_id\":\"1\",\"order_id\":\"12\"}', '\"\"', '', 'null', NULL, NULL, NULL, NULL, '', '', NULL, NULL, '1', NULL, NULL),
(11, 8, NULL, 1, 'RM', '{\"size\":[\"\"],\"addon\":{\"c81e728d9d4c2f636f067f89cc14862c\":[\"\"]},\"currency\":\"RM\",\"price\":[\"159.00\"],\"weight\":[\"0\"],\"zeroweight\":[\"0\"],\"brand\":[\"\"],\"cat\":[\"\"],\"totalprice\":\"159\",\"total_weight\":0,\"above\":[\"0\"],\"dimension\":\"**|\",\"photoext\":[\"\"],\"extid\":[\"-1\"],\"extkey\":[\"\"],\"preorder\":[\"1\"],\"datesend\":[\"26-01-2022\"],\"datedelivery\":[\"1643176800\"],\"time\":[\"2:00pm - 4:00pm\"],\"candle\":[\"Need\"],\"message\":[\"\"],\"ref\":[\"c81e728d9d4c2f636f067f89cc14862c\"],\"qty\":[\"1\"],\"url\":null}', '{\"name\":\"Belly\",\"mobile\":\"+6012345678\",\"address\":\"sample address\'gfdsgd\'ghjdgh-fhj!#@$#&({|?>|\",\"postcode\":\"12345\",\"city\":\"johor bahru\'fgbdfgdf\",\"state\":\"Johor\",\"remark\":\"\"}', 'Pickup|0', NULL, 159, '', '0', 1643044028, 1643044028, 1643211200, 1, 1, '{\"mode\":\"senangpay\",\"pay\":\"test\",\"status_id\":\"1\",\"order_id\":\"11\"}', '\"Pickup\"', '', 'null', NULL, NULL, NULL, NULL, '', '', NULL, NULL, '1', NULL, NULL);

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

--
-- Table structure for table `cms_member_orders_copy`
--

CREATE TABLE `cms_member_orders_copy` (
  `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,
  `Remark2` text DEFAULT NULL,
  `TrackingNumber` tinytext NOT NULL,
  `expdate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_member_orders_copy2`
--

CREATE TABLE `cms_member_orders_copy2` (
  `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,
  `Remark2` text DEFAULT 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_member_voucher`
--

CREATE TABLE `cms_member_voucher` (
  `ref` int(11) NOT NULL,
  `mem` varchar(50) DEFAULT NULL,
  `RefID` varchar(50) DEFAULT NULL,
  `datecreate` int(11) DEFAULT 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
(6, '', 1, 1604597604, 1),
(16, '', 1, 1680673836, 4),
(10, '', 1, 1604597641, 3),
(12, '', 1, 1623222328, 2),
(14, '', 1, 1641485939, 6),
(15, '', 1, 1680495981, 5);

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

--
-- 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
(16, 6, 'Home', '', '', 'en'),
(17, 6, '', '', '', 'cn'),
(18, 6, '', '', '', 'my'),
(47, 16, '', '', '', 'cn'),
(46, 16, 'Fleet', '', '', 'en'),
(28, 10, 'Pricing', '', '', 'en'),
(29, 10, '', '', '', 'cn'),
(30, 10, '', '', '', 'my'),
(34, 12, 'About Us', '', '', 'en'),
(35, 12, 'å•†åº—', '', '', 'cn'),
(36, 12, '', '', '', 'my'),
(40, 14, 'Blog', '', '', 'en'),
(41, 14, '', '', '', 'cn'),
(42, 14, '', '', '', 'my'),
(43, 15, 'Testimonials', '', '', 'en'),
(44, 15, '', '', '', 'cn'),
(45, 15, '', '', '', 'my'),
(48, 16, '', '', '', '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
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `cms_news` (`ref`, `subcat`, `photo`, `active`, `datecreate`, `dateupdate`) VALUES
(1, 'c81e728d9d4c2f636f067f89cc14862c', '16822797191680857646t1.png|1691087144Viotonic Website page.jpg|', 1, 1682279719, 1691087144),
(2, 'c81e728d9d4c2f636f067f89cc14862c', '16822807401680857646t1.png|', 1, 1682280740, 1682280740),
(3, 'a87ff679a2f3e71d9181a67b7542122c', '16827111641.png|', 1, 1682711164, 1682711164),
(4, 'd41d8cd98f00b204e9800998ecf8427e', '', 1, 1682711164, 1682711164),
(5, 'a87ff679a2f3e71d9181a67b7542122c', '16827111821.png|', 1, 1682711182, 1682711182),
(6, 'd41d8cd98f00b204e9800998ecf8427e', '', 1, 1682711182, 1682711182),
(7, 'a87ff679a2f3e71d9181a67b7542122c', '16827111931.png|', 1, 1682711193, 1682711193),
(8, 'd41d8cd98f00b204e9800998ecf8427e', '', 1, 1682711193, 1682711193),
(9, 'a87ff679a2f3e71d9181a67b7542122c', '16827111931.png|', 1, 1682711193, 1682711193),
(10, 'a87ff679a2f3e71d9181a67b7542122c', '16827112191.png|', 1, 1682711219, 1682711219),
(11, 'd41d8cd98f00b204e9800998ecf8427e', '', 1, 1682711219, 1682711219),
(12, 'a87ff679a2f3e71d9181a67b7542122c', '16827112531.png|', 1, 1682711253, 1682711253),
(13, 'd41d8cd98f00b204e9800998ecf8427e', '', 1, 1682711253, 1682711253),
(14, 'a87ff679a2f3e71d9181a67b7542122c', '16827112711.png|', 1, 1682711271, 1682711431),
(15, 'a87ff679a2f3e71d9181a67b7542122c', '16827114482.png|', 1, 1682711395, 1682711448),
(16, 'a87ff679a2f3e71d9181a67b7542122c', '16827114653.png|', 1, 1682711465, 1682711465),
(17, 'a87ff679a2f3e71d9181a67b7542122c', '16827114874.png|', 1, 1682711487, 1682711487),
(18, 'a87ff679a2f3e71d9181a67b7542122c', '16827115135.png|', 1, 1682711497, 1682711513);

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

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

CREATE TABLE `cms_news_attr` (
  `aRef` int(11) NOT NULL,
  `RefID` int(11) DEFAULT NULL,
  `Title` varchar(200) DEFAULT NULL,
  `ShortDesc` text DEFAULT NULL,
  `Price` varchar(50) DEFAULT NULL,
  `PhotoDesc` varchar(200) DEFAULT NULL,
  `datenews` varchar(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`, `ShortDesc`, `Price`, `PhotoDesc`, `datenews`, `lang`) VALUES
(1, 1, 'From Singapore To Theme Park', ' “ Thanks For The Arrangement ...Ah Wei\r\nGood Service And Safe Drive.....\r\nWill Keep Ur Phone Number For Ours Trip\r\nIn Future.. ”', '', '|', '1682265600', 'en'),
(2, 1, '', '', NULL, NULL, '1682265600', 'cn'),
(3, 1, '', '', NULL, NULL, '1682265600', 'my'),
(4, 2, 'From Singapore To Genting', 'Thanks Ah Wei drive us to Genting with safety ride ', NULL, NULL, '1682265600', 'en'),
(5, 2, '', '', NULL, NULL, '1682265600', 'cn'),
(6, 2, '', '', NULL, NULL, '1682265600', 'my'),
(7, 14, 'Singapore', 'Malacca', '1X8', '|', '', 'en'),
(8, 15, 'Singapore', 'KSL City', '1xx', '', '', 'en'),
(9, 16, 'Singapore', 'KLIA', '1XX', NULL, '', 'en'),
(10, 17, 'Singapore', 'Kek Lok Si', '1XX', NULL, '', 'en'),
(11, 18, 'Singapore', 'KLCC', '2XX', '', '', 'en');

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

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

CREATE TABLE `cms_news_cat` (
  `ref` int(11) NOT NULL,
  `Brand` varchar(50) DEFAULT NULL,
  `Type` varchar(11) DEFAULT NULL,
  `Title` varchar(250) DEFAULT NULL,
  `ShortDesc` 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_news_cat`
--

INSERT INTO `cms_news_cat` (`ref`, `Brand`, `Type`, `Title`, `ShortDesc`, `active`, `datecreate`, `dateupdate`) VALUES
(2, NULL, '1', 'Happy Travel Memories', '', 1, 1644747240, 1682709810),
(4, NULL, '2', 'Explore To Top Destination', '', 1, 1682709883, 1682709883),
(5, NULL, '3', 'Latest Blog', '', 1, 1691081322, 1691081334);

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

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

CREATE TABLE `cms_prod` (
  `ref` int(11) NOT NULL,
  `cat` varchar(50) NOT NULL,
  `oneway` longtext DEFAULT NULL,
  `twoway` longtext DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  `datecreate` int(11) DEFAULT NULL,
  `dateupdate` int(11) DEFAULT NULL,
  `queue` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `cms_prod` (`ref`, `cat`, `oneway`, `twoway`, `active`, `datecreate`, `dateupdate`, `queue`) VALUES
(1, 'c4ca4238a0b923820dcc509a6f75849b', '{\"1\":\"98\",\"2\":\"128\",\"3\":\"108\"}', '{\"1\":\"168\",\"2\":\"188\",\"3\":\"148\"}', 1, 1682587021, 1682587408, NULL),
(2, 'c4ca4238a0b923820dcc509a6f75849b', '{\"1\":\"118\",\"2\":\"158\",\"3\":\"138\"}', '{\"1\":\"188\",\"2\":\"228\",\"3\":\"168\"}', 1, 1682587656, 1682587656, NULL);

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

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

CREATE TABLE `cms_prod_attr` (
  `aRef` int(11) NOT NULL,
  `RefID` int(11) DEFAULT NULL,
  `Location` 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`, `Location`, `lang`) VALUES
(1, 1, 'Jb Sentral\r\nKSL\r\nCity Square\r\nTaman Setosa\r\nTaman Pelangi\r\nStulang Laut', 'en'),
(2, 2, 'Legoland Malaysia\r\nJpo\r\nNusajaya\r\nIskandar Puteri\r\nGelang Patah\r\nBukit Indah\r\nPerling\r\nSkudai\r\nTaman Impian Emas\r\nPermas Jaya\r\nTaman Molek\r\nSetia Tropika\r\nTebrau City\r\nKempas\r\nMount Austin\r\nTampoi\r\nTaman Setia Indah\r\nLarkin\r\nJohor Jaya\r\nBandar Dato Onn\r\nPlentong\r\nSeri Alam\r\nTaman Gaya\r\nMasai\r\nUlu Tiram\r\nPasir Gudang\r\nTaman Desa Cemerlang\r\nTanjung Langsat', '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,
  `feature` varchar(11) DEFAULT NULL,
  `Title` varchar(250) DEFAULT NULL,
  `ShortTitle` varchar(255) DEFAULT NULL,
  `ShortDesc` text DEFAULT NULL,
  `addDesc` longtext DEFAULT NULL,
  `addDesc2` longtext DEFAULT NULL,
  `Price` double DEFAULT NULL,
  `photo` text DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  `offer` varchar(11) DEFAULT NULL,
  `datecreate` int(11) DEFAULT NULL,
  `dateupdate` int(11) DEFAULT NULL,
  `queue` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `cms_prod_cat` (`ref`, `subcat`, `menu`, `feature`, `Title`, `ShortTitle`, `ShortDesc`, `addDesc`, `addDesc2`, `Price`, `photo`, `active`, `offer`, `datecreate`, `dateupdate`, `queue`) VALUES
(1, NULL, '', '', 'Travelling\r\nSINGAPORE to JOHOR BAHRU (JB)', 'SG to JB', '', '', '', NULL, '1682581774.png|', 1, NULL, 1682581553, 1682599439, 0),
(2, NULL, '', '', 'AIRPORT TRANSFER', 'Airport', '', '', '', NULL, '1682581868.png|', 1, NULL, 1682581868, 1682599449, 2),
(3, NULL, '', '', 'Traveling\r\nSINGAPORE to MALAYSIA', 'SG to MY', '', '', '', NULL, '1682581907.png|', 1, NULL, 1682581907, 1682599455, 1),
(4, NULL, '', '', 'VIP DAY TRIP', 'VIP', '', '', '', NULL, '1682581932.png|', 1, NULL, 1682581932, 1682599466, 3);

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

--
-- Table structure for table `cms_prod_sale`
--

CREATE TABLE `cms_prod_sale` (
  `ref` int(11) NOT NULL,
  `RefID` varchar(50) DEFAULT NULL,
  `OrderNo` varchar(50) DEFAULT NULL,
  `qty` varchar(50) DEFAULT NULL,
  `datecreate` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cms_prod_temp`
--

CREATE TABLE `cms_prod_temp` (
  `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_promotion`
--

CREATE TABLE `cms_promotion` (
  `ref` int(11) NOT NULL,
  `Title` varchar(250) DEFAULT NULL,
  `Code` varchar(50) DEFAULT NULL,
  `above` double DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `percent` double DEFAULT NULL,
  `maximum` double DEFAULT NULL,
  `hfree` varchar(11) DEFAULT NULL,
  `free` varchar(11) DEFAULT NULL,
  `cat` longtext DEFAULT NULL,
  `item` longtext DEFAULT NULL,
  `mem` longtext DEFAULT NULL,
  `quota` int(11) DEFAULT NULL,
  `Active` varchar(11) DEFAULT NULL,
  `datestart` int(11) DEFAULT NULL,
  `dateend` int(11) DEFAULT NULL,
  `datecreate` int(11) DEFAULT 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_receipe`
--

CREATE TABLE `cms_receipe` (
  `ref` int(11) NOT NULL,
  `Title` varchar(250) DEFAULT NULL,
  `ShortDesc` text DEFAULT NULL,
  `Product` longtext DEFAULT NULL,
  `photo` longtext DEFAULT NULL,
  `video` longtext DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  `datecreate` int(11) DEFAULT NULL,
  `dateupdate` int(11) DEFAULT 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,
  `Offer` varchar(11) DEFAULT NULL,
  `datecreate` int(11) NOT NULL,
  `dateupdate` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_sys`
--

INSERT INTO `cms_sys` (`ref`, `Currency`, `Offer`, `datecreate`, `dateupdate`) VALUES
(1, 0, '1', 0, 1680496239);

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

--
-- Table structure for table `cms_voucher`
--

CREATE TABLE `cms_voucher` (
  `ref` int(11) NOT NULL,
  `Title` varchar(250) DEFAULT NULL,
  `Code` varchar(50) DEFAULT NULL,
  `above` double DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `percent` double DEFAULT NULL,
  `maximum` double NOT NULL,
  `hfree` varchar(11) DEFAULT NULL,
  `free` varchar(50) NOT NULL,
  `cat` longtext DEFAULT NULL,
  `item` longtext DEFAULT NULL,
  `mem` longtext DEFAULT NULL,
  `quota` int(11) DEFAULT NULL,
  `Active` varchar(11) DEFAULT NULL,
  `Redeem` varchar(50) DEFAULT NULL,
  `datestart` int(11) DEFAULT NULL,
  `dateend` int(11) DEFAULT NULL,
  `datecreate` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

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

--
-- 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_booking`
--
ALTER TABLE `cms_booking`
  ADD PRIMARY KEY (`ref`);

--
-- 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_car`
--
ALTER TABLE `cms_car`
  ADD PRIMARY KEY (`ref`);

--
-- 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_form`
--
ALTER TABLE `cms_form`
  ADD PRIMARY KEY (`ref`);

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

--
-- Indexes for table `cms_member`
--
ALTER TABLE `cms_member`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `username` (`username`),
  ADD KEY `userpwd` (`userpwd`),
  ADD KEY `active` (`active`),
  ADD KEY `expdate` (`expdate`);

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

--
-- 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_level`
--
ALTER TABLE `cms_member_level`
  ADD PRIMARY KEY (`ref`);

--
-- 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_copy`
--
ALTER TABLE `cms_member_orders_copy`
  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_copy2`
--
ALTER TABLE `cms_member_orders_copy2`
  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_member_voucher`
--
ALTER TABLE `cms_member_voucher`
  ADD PRIMARY KEY (`ref`);

--
-- 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_prod_sale`
--
ALTER TABLE `cms_prod_sale`
  ADD PRIMARY KEY (`ref`);

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

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

--
-- 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_receipe`
--
ALTER TABLE `cms_receipe`
  ADD PRIMARY KEY (`ref`),
  ADD KEY `active` (`active`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

--
-- 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=14;

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `cms_member_address`
--
ALTER TABLE `cms_member_address`
  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=2;

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

--
-- 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_level`
--
ALTER TABLE `cms_member_level`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

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

--
-- AUTO_INCREMENT for table `cms_member_orders_copy2`
--
ALTER TABLE `cms_member_orders_copy2`
  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_member_voucher`
--
ALTER TABLE `cms_member_voucher`
  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=17;

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

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

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

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

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

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

--
-- 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_prod_sale`
--
ALTER TABLE `cms_prod_sale`
  MODIFY `ref` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cms_promotion`
--
ALTER TABLE `cms_promotion`
  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_receipe`
--
ALTER TABLE `cms_receipe`
  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, AUTO_INCREMENT=3;

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

