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

START TRANSACTION;



--
-- Database: `addmyentry_newadd`
--

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

--
-- Table structure for table `about_banner`
--

CREATE TABLE `about_banner` (
  `Slider_id` int(13) NOT NULL,
  `Slider_Image` varchar(120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `apply_request`
--

CREATE TABLE `apply_request` (
  `apply_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `entry` varchar(50) NOT NULL,
  `entry_fees` int(11) NOT NULL,
  `apply_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `apply_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apply_request`
--

INSERT INTO `apply_request` (`apply_id`, `user_id`, `event_id`, `entry`, `entry_fees`, `apply_on`, `apply_status`) VALUES
(1, 30, 1, 'paid', 100, '2022-12-31 09:11:41', 1),
(2, 33, 1, 'paid', 100, '2023-01-02 22:22:33', 1);

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

--
-- Table structure for table `award_master`
--

CREATE TABLE `award_master` (
  `Slider_id` int(13) NOT NULL,
  `Slider_Image` varchar(120) NOT NULL,
  `Slider_order` varchar(120) NOT NULL,
  `Slider_title` varchar(120) NOT NULL,
  `Slider_contecnt` varchar(120) NOT NULL,
  `Slider_link` varchar(120) NOT NULL,
  `Slider_date` varchar(120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `award_master`
--

INSERT INTO `award_master` (`Slider_id`, `Slider_Image`, `Slider_order`, `Slider_title`, `Slider_contecnt`, `Slider_link`, `Slider_date`) VALUES
(5, 'Clip-in-hair-Extension-Single-pcs-80G.png', '1', 'Permenent hair extensions', 'The clip-in hair extensions are super easy to use and are the quickest and easiest way to transform your look in a matte', 'Clip-in hair extensions', ''),
(6, 'Clip-in-hair-Extension-Single-pcs-80G.png', '2', 'Human hair topper', 'yjgfjgfjgdnfchnfjhe', 'contact', ''),
(7, 'Clip-in-hair-Extension-Single-pcs-80G.png', '2', 'Clip in hair extensions', 'uiyjkgfhdfhdhyh', 'contact', ''),
(8, 'Clip-in-hair-2pc-20G.png', '1', 'Human hair topper', 'Permenent hair extensions	', 'Permenent hair extensions	', '');

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

--
-- Table structure for table `booking_master`
--

CREATE TABLE `booking_master` (
  `booking_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `brand_master`
--

CREATE TABLE `brand_master` (
  `Brand_id` int(11) NOT NULL,
  `Brand_Name` varchar(255) DEFAULT NULL,
  `Brand_status` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `brand_master`
--

INSERT INTO `brand_master` (`Brand_id`, `Brand_Name`, `Brand_status`) VALUES
(5, 'SONY', 1),
(6, 'MICROSOFT', 1);

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

--
-- Table structure for table `buypack_master`
--

CREATE TABLE `buypack_master` (
  `buy_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ticket` int(11) NOT NULL,
  `transaction_id` varchar(200) NOT NULL,
  `buy_amount` int(11) NOT NULL,
  `add_on` int(11) NOT NULL,
  `payment_mode` varchar(50) NOT NULL,
  `buy_on` datetime NOT NULL,
  `buy_status` tinyint(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `buypack_master`
--

INSERT INTO `buypack_master` (`buy_id`, `user_id`, `ticket`, `transaction_id`, `buy_amount`, `add_on`, `payment_mode`, `buy_on`, `buy_status`) VALUES
(1, 30, 926942, 'cvsgr', 500, 500, 'offline', '2022-12-31 14:30:46', 2),
(2, 33, 137761, '235qrfw3', 1000, 0, 'offline', '2023-01-03 03:51:45', 2);

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

--
-- Table structure for table `certificate_master`
--

CREATE TABLE `certificate_master` (
  `certificate_id` int(11) NOT NULL,
  `certificate_title` varchar(400) NOT NULL,
  `certificate_img` varchar(200) NOT NULL,
  `certificate_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `certificate_master`
--

INSERT INTO `certificate_master` (`certificate_id`, `certificate_title`, `certificate_img`, `certificate_status`) VALUES
(15, 'Certificate 03', 'certificate.jpg', 0);

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

--
-- Table structure for table `city_master`
--

CREATE TABLE `city_master` (
  `City_id` int(11) NOT NULL,
  `City_Name` varchar(255) DEFAULT NULL,
  `City_district` varchar(255) DEFAULT NULL,
  `City_Status` tinyint(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `city_master`
--

INSERT INTO `city_master` (`City_id`, `City_Name`, `City_district`, `City_Status`) VALUES
(1, 'Chennai', 'Chennai', 1),
(2, 'erode', '', 1);

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

--
-- Table structure for table `classroom_slider`
--

CREATE TABLE `classroom_slider` (
  `slider_id` int(12) NOT NULL,
  `Slider_contecnt` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slider_title` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slider_Image` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slider_order` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slider_Status` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slider_Product` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slider_link` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slider_btn` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `classroom_slider`
--

INSERT INTO `classroom_slider` (`slider_id`, `Slider_contecnt`, `Slider_title`, `Slider_Image`, `Slider_order`, `Slider_Status`, `Slider_Product`, `Slider_link`, `Slider_btn`) VALUES
(2, '', '', 'banner1.jpg', '2', '1', '', '', ''),
(3, '', '', 'banner4.jpg', '1', '1', '', '', '');

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

--
-- Table structure for table `cms`
--

CREATE TABLE `cms` (
  `cms_id` int(11) NOT NULL,
  `TC_cont` longblob,
  `home_title` varchar(200) NOT NULL,
  `home_desc` longblob NOT NULL,
  `home_img` varchar(400) NOT NULL,
  `About_us` varchar(200) DEFAULT NULL,
  `About_us_desc` longblob,
  `About_us_img` varchar(500) DEFAULT NULL,
  `pro_title` varchar(200) DEFAULT NULL,
  `pro_desc` longblob,
  `pro_img` varchar(200) DEFAULT NULL,
  `Vission` longblob,
  `Mission` longblob,
  `infra` varchar(200) NOT NULL,
  `infra_desc` longblob NOT NULL,
  `infra_img` varchar(400) NOT NULL,
  `miles` varchar(200) NOT NULL,
  `miles_desc` longblob NOT NULL,
  `miles_img` varchar(400) NOT NULL,
  `Privacy_policy` longblob,
  `Delivery_Policy` longtext,
  `TC_Status` tinyint(4) DEFAULT NULL,
  `About_us_status` tinyint(4) DEFAULT NULL,
  `Privacy_status` tinyint(4) DEFAULT NULL,
  `Delivery_status` tinyint(4) DEFAULT NULL,
  `Refund_policy` longtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `cms`
--

INSERT INTO `cms` (`cms_id`, `TC_cont`, `home_title`, `home_desc`, `home_img`, `About_us`, `About_us_desc`, `About_us_img`, `pro_title`, `pro_desc`, `pro_img`, `Vission`, `Mission`, `infra`, `infra_desc`, `infra_img`, `miles`, `miles_desc`, `miles_img`, `Privacy_policy`, `Delivery_Policy`, `TC_Status`, `About_us_status`, `Privacy_status`, `Delivery_status`, `Refund_policy`) VALUES
(1, 0x3c703e4279207669736974696e67206f7572207369746520616e642f206f722070757263686173696e6720736f6d657468696e672066726f6d2075732c20796f7520656e6761676520696e206f757220266c6471756f3b5365727669636526726471756f3b20616e6420616772656520746f20626520626f756e642062792074686520666f6c6c6f77696e67207465726d7320616e6420636f6e646974696f6e732028266c6471756f3b5465726d73206f66205365727669636526726471756f3b2c20266c6471756f3b5465726d7326726471756f3b292c20696e636c7564696e672074686f7365206164646974696f6e616c207465726d7320616e6420636f6e646974696f6e7320616e6420706f6c6963696573207265666572656e6365642068657265696e20616e642f6f7220617661696c61626c652062792068797065726c696e6b2e205468657365205465726d73206f662053657276696365206170706c7920746f20616c6c207573657273206f662074686520736974652c20696e636c7564696e6720776974686f7574206c696d69746174696f6e2075736572732077686f206172652062726f77736572732c2076656e646f72732c20637573746f6d6572732c206d65726368616e74732c20616e642f206f7220636f6e7472696275746f7273206f6620636f6e74656e742e3132333c2f703e0d0a3c703e266e6273703b3c2f703e0d0a3c703e266e6273703b3c2f703e, 'Welcome to the world of Virukshalaya Ghee', 0x3c7020636c6173733d224d736f4e6f726d616c22207374796c653d22746578742d616c69676e3a6a7573746966793b746578742d6a7573746966793a696e7465722d6964656f6772617068223e3c7370616e207374796c653d22666f6e742d73697a653a31342e3070743b6c696e652d6865696768743a313135253b6d736f2d626964692d666f6e742d66616d696c793a43616c696272693b0d0a6d736f2d626964692d7468656d652d666f6e743a6d696e6f722d6c6174696e3b6261636b67726f756e643a7768697465223e48696d61646872692044616972792050726f647563740d0a50726976617465204c696d697465642061206c656164696e67206d616e75666163747572657220616e64206578706f72746572206f66206661726d2066726573682070757265206768656520696e0d0a496e6469612e3c2f7370616e3e3c7370616e207374796c653d22666f6e742d73697a653a31342e3070743b6c696e652d6865696768743a313135253b6d736f2d626964692d666f6e742d66616d696c793a0d0a43616c696272693b6d736f2d626964692d7468656d652d666f6e743a6d696e6f722d6c6174696e223e204f757220636f6d70616e79207370656369616c697a657320696e207468650d0a6d616e75666163747572696e67206f6620507572652047686565207769746820737472696e67656e74207175616c697479207374616e646172647320756e64657220746865206272616e640d0a6e616d65203c623ee2809c564952554b5348414c415941e2809d3c2f623e2e266e6273703b203c2f7370616e3e3c7370616e207374796c653d22666f6e742d73697a653a31342e3070743b0d0a6d736f2d626964692d666f6e742d73697a653a392e3570743b6c696e652d6865696768743a313135253b6d736f2d626964692d666f6e742d66616d696c793a43616c696272693b0d0a6d736f2d626964692d7468656d652d666f6e743a6d696e6f722d6c6174696e223e5175616c6974792068617320616c77617973206265656e207468652068616c6c6d61726b206f66206f75720d0a6f7267616e697a6174696f6e2e3c2f7370616e3e3c7370616e207374796c653d22666f6e742d73697a653a31342e3070743b6c696e652d6865696768743a313135253b6d736f2d626964692d666f6e742d66616d696c793a0d0a43616c696272693b6d736f2d626964692d7468656d652d666f6e743a6d696e6f722d6c6174696e3b6261636b67726f756e643a7768697465223e203c6f3a703e3c2f6f3a703e3c2f7370616e3e3c2f703e3c7020636c6173733d224d736f4e6f726d616c223e3c7370616e207374796c653d22666f6e742d73697a653a31342e3070743b6d736f2d626964692d666f6e742d73697a653a31312e3070743b0d0a6c696e652d6865696768743a313135253b6261636b67726f756e643a7768697465223e566972756b7368616c61796120476865652069732061207075726520627574746572206661740d0a6c6566746f76657220616674657220746865206d696c6b20736f6c69647320616e64207761746572206172652072656d6f7665642066726f6d206275747465722e204974206973206120726963680d0a736f75726365206f662070726f7465696e732c20766974616d696e732c20636172626f68796472617465732c2063616c6369756d2c2069726f6e20616e64206f6d6567612d332066617474790d0a61636964732e204974206173736973747320696e20696d70726f76696e672074686520627261696e20616e64206865617274206865616c74682c20616e64207472656174696e670d0a696e666c616d6d6174696f6e20616e64206e756d65726f75732064697365617365732e203c6f3a703e3c2f6f3a703e3c2f7370616e3e3c2f703e3c7020636c6173733d224d736f4e6f726d616c22207374796c653d22636f6c6f723a207267622838352c2038352c203835293b20666f6e742d66616d696c793a2022206f70656e3d22222073616e73222c3d22222073616e732d73657269663b3d222220666f6e742d73697a653a3d222220313670783b3d2222206261636b67726f756e642d636f6c6f723a3d222220726762283235352c3d2222203235352c3d222220323535293b3d222220746578742d616c69676e3a3d2222206a7573746966793b223d22223e0d0a0d0a0d0a0d0a3c2f703e3c7020636c6173733d224d736f4e6f726d616c223e3c7370616e207374796c653d22666f6e742d73697a653a31342e3070743b6d736f2d626964692d666f6e742d73697a653a31312e3070743b0d0a6c696e652d6865696768743a313135253b6261636b67726f756e643a7768697465223e4265736964657320746861742c20697420737472656e677468656e732074686520696d6d756e650d0a73797374656d2c20666163696c69746174657320626f77656c206d6f76656d656e742c20616e642070726576656e7473206368726f6e696320636f7567682069737375657320616e640d0a6469736f726465727320696e20657965732e3c6f3a703e3c2f6f3a703e3c2f7370616e3e3c2f703e, 'Logo.jpeg', 'Welcome to the world of Add My Entry ', 0x3c7020636c6173733d224d736f4e6f726d616c22207374796c653d22746578742d616c69676e3a6a7573746966793b746578742d6a7573746966793a696e7465722d6964656f6772617068223e3c7370616e206c616e673d22454e2d474222207374796c653d22666f6e742d73697a653a20313470743b206c696e652d6865696768743a20313135253b223e416464204d7920456e74727920697320612070726f66657373696f6e616c206d616e61676564206f7267616e69736174696f6e20686561647175617274657265643c2f7370616e3e3c7370616e207374796c653d22666f6e742d73697a653a20313470743b206c696e652d6865696768743a20313135253b223e20696e204368656e6e6169207769746820697473207374617465206f6620746865206172740d0a70726f64756374696f6e20666163696c697479206e656172204368656e6e61692c2054616d696c6e6164752e3c2f7370616e3e3c62723e3c2f703e0d0a0d0a3c7020636c6173733d224d736f4e6f726d616c22207374796c653d226d736f2d6d617267696e2d746f702d616c743a6175746f3b6d736f2d6d617267696e2d626f74746f6d2d616c743a6175746f3b0d0a746578742d616c69676e3a6a7573746966793b746578742d6a7573746966793a696e7465722d6964656f67726170683b6c696e652d6865696768743a6e6f726d616c3b6261636b67726f756e643a0d0a7768697465223e3c7370616e207374796c653d226261636b67726f756e642d636f6c6f723a20726762283234392c203235312c20323533293b20666f6e742d73697a653a20313470743b206c696e652d6865696768743a20313135253b223e576520617265206163636f756e7461626c6520666f722074686520656e6420746f20656e640d0a70726f64756374696f6e20616e64206d61726b6574696e67206f66206f75722070726f647563742e203c2f7370616e3e3c7370616e207374796c653d226261636b67726f756e642d636f6c6f723a20726762283234392c203235312c20323533293b20666f6e742d73697a653a20313470743b206c696e652d6865696768743a20313135253b223e5468650d0a70726f64756374732061726520746573746564206f6e20766172696f757320706172616d65746572732c20616e64207765207374726963746c7920757365203c7370616e207374796c653d226261636b67726f756e643a7768697465223e41726f6d6120526574656e74696f6e203c2f7370616e3e666f6f6420677261646520676c617373206a61727320666f72207468650d0a7061636b6167696e67206f66207468652070726f64756374733c2f7370616e3e3c62723e3c2f703e0d0a0d0a3c7020636c6173733d224d736f4e6f726d616c22207374796c653d22746578742d616c69676e3a6a7573746966793b746578742d6a7573746966793a696e7465722d6964656f6772617068223e3c7370616e207374796c653d22666f6e742d73697a653a31342e3070743b6c696e652d6865696768743a313135253b6d736f2d626964692d666f6e742d66616d696c793a43616c696272693b0d0a6d736f2d626964692d7468656d652d666f6e743a6d696e6f722d6c6174696e223e3c7370616e207374796c653d22666f6e742d73697a653a2031382e3636363770783b223e416464204d7920456e7472793c2f7370616e3e3c7370616e207374796c653d22666f6e742d73697a653a2031382e3636363770783b223e266e6273703b3c2f7370616e3e697320746865206f6e65206f6620746865206d6f73740d0a7072656665727265642070726f6475637473206f66206d696c6c696f6e73206f6620636f6e73756d65727320666f72206974732061757468656e74696369747920616e6420756e697175650d0a61726f6d6120626c656e646564207769746820747261646974696f6e616c2054617374652c20466c61766f7220616e6420446976696e6974792e266e6273703b3c2f7370616e3e3c2f703e, '1672693538.jpg', '', 0x3c7020636c6173733d224d736f4e6f726d616c22207374796c653d226d617267696e2d626f74746f6d3a372e363570743b746578742d616c69676e3a6a7573746966793b746578742d6a7573746966793a0d0a696e7465722d6964656f67726170683b6c696e652d6865696768743a6e6f726d616c3b6261636b67726f756e643a7768697465223e3c7370616e207374796c653d22666f6e742d73697a653a2031382e3636363770783b223e3c623e566972756b7368616c61796120476865653c2f623e206973206d6164652066726f6d20746865206d696c6b206f6620636f7773206772617a696e67206f6e206661726d6c616e6473206f662076696c6c616765732061646a6f696e696e67205765737465726e204768617473206f66205468656e6920616e642044696e646967756c20446973747269637473206f662054616d696c6e6164752e20546865736520667265652072616e676520636f777320617265206e6f74206578706f73656420746f206861726d66756c206368656d6963616c2c20706573746963696465732c206172746966696369616c20686f726d6f6e65732e20566972756b7368616c617961204768656520636f6e7461696e732061207269636820736f75726365206f6620657373656e7469616c2066617474792061636964732073756368206173206f6d6567612d3320616e6420436f6e7461696e73206865616c7468792066617420736f6c75626c6520766974616d696e73207768696368206169647320696e20746865206162736f727074696f6e206f66206e75747269656e747320696e20666f6f647320616e642061726520657373656e7469616c20666f7220676f6f64206865616c74683c2f7370616e3e3c2f703e3c7020636c6173733d224d736f4e6f726d616c22207374796c653d226d617267696e2d626f74746f6d3a372e363570743b746578742d616c69676e3a6a7573746966793b746578742d6a7573746966793a0d0a696e7465722d6964656f67726170683b6c696e652d6865696768743a6e6f726d616c3b6261636b67726f756e643a7768697465223e3c7370616e207374796c653d22666f6e742d73697a653a2031382e3636363770783b223e566972756b7368616c61796120476865652074616b657320707269646520696e206272696e67696e6720746f20796f757220686f6d65732074686520747261646974696f6e616c2061726f6d6174696320676865652077697468207468652070726f6d697365206f6620646976696e652070757269747920616e64207175616c6974792e3c2f7370616e3e3c62723e3c2f703e3c7020636c6173733d224d736f4e6f726d616c22207374796c653d226d617267696e2d626f74746f6d3a372e363570743b746578742d616c69676e3a6a7573746966793b746578742d6a7573746966793a0d0a696e7465722d6964656f67726170683b6c696e652d6865696768743a6e6f726d616c3b6261636b67726f756e643a7768697465223e3c7370616e207374796c653d22666f6e742d73697a653a2031382e3636363770783b223e52657365617263682073686f7773206768656520696d70726f76657320696d6d756e6974792c206169647320646967657374696f6e20616e642068617320696e6372656469626c65206865616c696e672070726f70657274696573206163636f7264696e6720746f2041797572766564612e20497420616c736f20636f6e7461696e7320736174757261746564206661747320776869636820697320676f6f6420666f72206865617274206865616c7468206f6e20696465616c20636f6e73756d7074696f6e206f6620322d33207461626c6573706f6f6e73206f66206768656520657665727964617920696e206469657420666f72206f7074696d756d2062656e65666974732e3c2f7370616e3e3c62723e3c2f703e, 'Logo.jpeg', 0x57652061737069726520746f206c6561642061732074686520776f726c6473206d6f7374207472757374656420616e642072657370656374656420646169727920666f6f64206d616e75666163747572657220616e6420737570706c6965722077697468207468652062657374207175616c6974792070726f647563747320616e642074686520227072656665727265642063686f6963652220666f7220616c6c206f757220637573746f6d6572732c20737570706c696572732c20616e6420656d706c6f796565732e, 0x546f206275696c642061207375737461696e61626c6520616e6420656e647572696e672072656c6174696f6e736869702077697468206f757220637573746f6d65727320616e6420636c69656e742062617365207768696c6520696e73706972696e67206865616c746869657220636f6d6d756e69746965732062792070726f766964696e6720657863656c6c656e74207175616c6974792070726f6475637473206174206120636f6d70657469746976652070726963652e2057652c2061742048696d61646872692044616972792050726f64756374732050726976617465204c696d69746564206f7065726174652077697468206f7572206f776e20736574206f66203350732c207468617420697320e280932050726f63757265207468652062657374202d2050726f64756365207468652062657374202d2050726f76696465207468652062657374, '', 0x3c7020636c6173733d224d736f4e6f726d616c223e3c7370616e206c616e673d22454e2d474222207374796c653d22666f6e742d73697a653a31342e3070743b6d736f2d626964692d666f6e742d73697a653a0d0a31312e3070743b6c696e652d6865696768743a313135253b6d736f2d616e73692d6c616e67756167653a454e2d4742223e546865206272616e6420686173207468650d0a3c623e6d616e75666163747572696e67203c2f623e636170616369747920746f2070726f64756365203630206d657472696320746f6e73206f6620707572652067686565206576657279206d6f6e74682e0d0a467572746865722c207468652062657374207175616c69747920636f6e74726f6c20706f6c69636965732061726520656d706c6f79656420616e64207365766572616c20636865636b73206172650d0a756e64657274616b656e206265666f7265207468652070726f647563742069732068796769656e6963616c6c79207061636b656420616e64207365616c65642c20746f20656e7375726520796f750d0a686176652074686520667265736865737420616e642066696e6573742067686565206f6e2068616e6420746f206164642061206d61676963616c20666c61766f757220746f20796f75720d0a6661766f7572697465206469736865732e3c6f3a703e3c2f6f3a703e3c2f7370616e3e3c2f703e, 'infrastructure.jpeg', '', 0x[encoded data, 13370 characters], 'Logo.jpeg', 0x3c703e476f6f676c65204c4c4320697320616e20416d65726963616e206d756c74696e6174696f6e616c20746563686e6f6c6f677920636f6d70616e792074686174207370656369616c697a657320696e20496e7465726e65742d72656c6174656420736572766963657320616e642070726f64756374732c20776869636820696e636c75646520612073656172636820656e67696e652c206f6e6c696e65266e6273703b3c2f703e, '      <div><br></div><div><img src=\"https://content3.jdmagicbox.com/comp/chennai/g7/044pxx44.xx44.120814190354.z5g7/catalogue/st-courier-ayanambakkam-chennai-courier-services-v7lgmy.jpg?clr=1f471f\" alt=\"\" align=\"none\"><br></div>', 1, 1, 1, 1, '<p>Google LLC is an American multinational technology company that specializes in Internet-related services</p>');

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

--
-- Table structure for table `contact_master`
--

CREATE TABLE `contact_master` (
  `c_id` int(11) NOT NULL,
  `c_location` varchar(100) NOT NULL,
  `c_address` longtext NOT NULL,
  `c_mobile` varchar(20) NOT NULL,
  `c_telephone` int(11) NOT NULL,
  `c_email_id` varchar(400) NOT NULL,
  `c_map` varchar(400) NOT NULL,
  `c_status` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `contact_master`
--

INSERT INTO `contact_master` (`c_id`, `c_location`, `c_address`, `c_mobile`, `c_telephone`, `c_email_id`, `c_map`, `c_status`) VALUES
(1, 'Chennai', '#165, Paper Mills Road, SRP Colony, Peravallur, Kolathur, Chennai-6000082', '73050 58866', 2147483647, 'sales@addmyentry.com', '        <iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3886.8564450047625!2d80.26551291430503!3d13.044808216798383!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3a52662e4de0bb3b%3A0xd573c710f9610089!2sKRD%20Gee%20Gee%20Crystal!5e0!3m2!1sen!2sin!4v1669375876953!5m2!1sen!2sin\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-re', 1);

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

--
-- Table structure for table `customer_addresss_master`
--

CREATE TABLE `customer_addresss_master` (
  `Address_id` int(11) NOT NULL,
  `Customet_id` varchar(200) DEFAULT NULL,
  `Delivery_Area` varchar(500) DEFAULT NULL,
  `Complete_Address` varchar(500) DEFAULT NULL,
  `Delivery_Landmark` varchar(255) DEFAULT NULL,
  `Address_type` varchar(255) DEFAULT NULL,
  `Address_default` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `customer_addresss_master`
--

INSERT INTO `customer_addresss_master` (`Address_id`, `Customet_id`, `Delivery_Area`, `Complete_Address`, `Delivery_Landmark`, `Address_type`, `Address_default`) VALUES
(8, '2', '2', '123,Erode Bus Stand', 'Erode Bus Stand', 'Home', 0),
(9, '3', '2', '123,Erode Bus Stand', 'Erode Bus Stand', 'Home', NULL),
(10, '4', '2', 'Tester', 'Tester', 'Home', NULL),
(11, '5', '2', 'Tester', 'Tester', 'Home', NULL),
(14, '6', '2', '123,Erode Bus Stand', 'Erode Bus Stand', 'Home', 1),
(15, '6', '', '', '', '', 0);

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

--
-- Table structure for table `delivery_price_master`
--

CREATE TABLE `delivery_price_master` (
  `delivery_price_id` int(11) NOT NULL,
  `delivery_location` varchar(255) DEFAULT NULL,
  `devlivery_price` float(4,2) DEFAULT NULL,
  `Delivery_status` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `delivery_price_master`
--

INSERT INTO `delivery_price_master` (`delivery_price_id`, `delivery_location`, `devlivery_price`, `Delivery_status`) VALUES
(2, '1', 20.00, 1);

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

--
-- Table structure for table `deliver_charges`
--

CREATE TABLE `deliver_charges` (
  `id` int(120) NOT NULL,
  `delivery_amount` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ordertrack_id` varchar(123) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deliver_charges`
--

INSERT INTO `deliver_charges` (`id`, `delivery_amount`, `ordertrack_id`) VALUES
(1, '99.99', '30802'),
(2, '99.99', '30803'),
(3, '99.99', '30803'),
(4, '99.99', '30803'),
(5, '99.99', '30803'),
(6, '99.99', '30803'),
(7, '99.99', '30803'),
(8, '99.99', '308102147'),
(9, '99.99', '308107724'),
(10, '99.99', '308102186'),
(11, '99.99', '308101482'),
(12, '99.99', '308106097'),
(13, '99.99', '308111141'),
(14, '99.99', '308115904'),
(15, '99.99', '308113234'),
(16, '99.99', '311051189'),
(17, '99.99', '311069147'),
(18, '99.99', '311079670'),
(19, '99.99', '311082840'),
(20, '99.99', '31109853'),
(21, '99.99', '3110931'),
(22, '99.99', '311092634'),
(23, '99.99', '311093991'),
(24, '99.99', '311105163'),
(25, '', '04066907'),
(26, '', '209085348'),
(27, '99.99', '309087163'),
(28, '99.99', '309084755'),
(29, '99.99', '309084696'),
(30, '99.99', '309086227'),
(31, '99.99', '309085338'),
(32, '99.99', '309082084'),
(33, '', '09032465'),
(34, '99.99', '311109389'),
(35, '99.99', '311101586'),
(36, '99.99', '311107555'),
(37, '99.99', '311111667'),
(38, '99.99', '31111102'),
(39, '99.99', '316074482'),
(40, '99.99', '316088309'),
(41, '99.99', '316105237'),
(42, '99.99', '31611281'),
(43, '99.99', '316121007'),
(44, '99.99', '317094263'),
(45, '99.99', '31709925'),
(46, '99.99', '317106893'),
(47, '99.99', '317117595'),
(48, '99.99', '317117914'),
(49, '99.99', '317117422'),
(50, '', '17019729'),
(51, '99.99', '317019520'),
(52, '', '1217039149'),
(53, '', '17041335'),
(54, '', '1317069176'),
(55, '', '1317065635'),
(56, '', '1417071518'),
(57, '99.99', '320065730'),
(58, '', '21035335'),
(59, '', '2103997'),
(60, '', '22082444'),
(61, '99.99', '322095474'),
(62, '', '2222118112'),
(63, '', '2222111460'),
(64, '', '32212964'),
(65, '', '322129054'),
(66, '', '3007038927'),
(67, '', '3108031467'),
(68, '', '3108053174'),
(69, '', '3208038172'),
(70, '', '3309019466'),
(71, '', '3310078684'),
(72, '', '3512065459'),
(73, '', '3716068239'),
(74, '', '3917083439'),
(75, '', '3917082042'),
(76, '', '317092082'),
(77, '', '31709441'),
(78, '', '317097524'),
(79, '', '3170920'),
(80, '', '317094976'),
(81, '', '31709126'),
(82, '', '4017035463'),
(83, '', '4323067923'),
(84, '', '4323104186'),
(85, '', '4425096904'),
(86, '', '4526052699'),
(87, '', '3928059679'),
(88, '', '3928069857'),
(89, '', '4628086823'),
(90, '', '3928089515'),
(91, '', '3928082829'),
(92, '', '4628097855'),
(93, '', '4628093787'),
(94, '', '32809827'),
(95, '', '328102476'),
(96, '', '328103541'),
(97, '', '328101713'),
(98, '', '328106920'),
(99, '', '328111782'),
(100, '', '328119165'),
(101, '', '4931057436'),
(102, '', '5131071405'),
(103, '', '3902082045'),
(104, '', '3902086207'),
(105, '', '3902084665'),
(106, '', '5203076867'),
(107, '', '5203071457'),
(108, '', '303071854'),
(109, '', '303079712'),
(110, '', '5203071645'),
(111, '', '30307917'),
(112, '', '5404076172'),
(113, '', '5404078843'),
(114, '', '5404071256'),
(115, '', '5605011497'),
(116, '', '5708124461'),
(117, '', '308069183'),
(118, '', '308067992'),
(119, '', '308064854'),
(120, '', '6109042886'),
(121, '', '3910022674'),
(122, '', '631106231'),
(123, '', '5412067764'),
(124, '', '5412061678'),
(125, '', '6514081159'),
(126, '', '4716032677'),
(127, '', '7124088937'),
(128, '', '7505034036'),
(129, '', '7505033715'),
(130, '', '7603033556'),
(131, '', '7603032708'),
(132, '200', '7604013827'),
(133, '120', '7604023092'),
(134, '500', '7604028220'),
(135, '100', '7606055302'),
(136, '', '19077760'),
(137, '', '19079646'),
(138, '', '19075209'),
(139, '', '1907769'),
(140, '', '19077801'),
(141, '', '19087918'),
(142, '', '19089035'),
(143, '', '20078308'),
(144, '', '20073817'),
(145, '', '20071819'),
(146, '', '20094140'),
(147, '', '20092110'),
(148, '', '20098202'),
(149, '', '21094955'),
(150, '', '21037236'),
(151, '', '21075098'),
(152, '', '21089948'),
(153, '', '21082887'),
(154, '', '21081168'),
(155, '', '21084169'),
(156, '', '21083941'),
(157, '', '21089961'),
(158, '', '21083276'),
(159, '', '2109626'),
(160, '', '21093863'),
(161, '', '21108627'),
(162, '', '21107819'),
(163, '', '21108897'),
(164, '', '21107661'),
(165, '', '22099812'),
(166, '', '22112342'),
(167, '', '22113893'),
(168, '', '22117266'),
(169, '', '14822116211'),
(170, '', '14922111823'),
(171, '', '14922118123'),
(172, '', '14922115131'),
(173, '', '15022128300'),
(174, '', '1502212847'),
(175, '', '22122014'),
(176, '', '15122121865'),
(177, '', '15222128487'),
(178, '', '22018795'),
(179, '', '15322018823'),
(180, '', '15422017137'),
(181, '', '15522018176'),
(182, '', '15622012334'),
(183, '', '15722013086'),
(184, '', '1582201952'),
(185, '', '15822015396');

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

--
-- Table structure for table `enquiry`
--

CREATE TABLE `enquiry` (
  `enquiryId` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(120) NOT NULL,
  `phone` varchar(13) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `message` text NOT NULL,
  `createAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `event_post`
--

CREATE TABLE `event_post` (
  `event_id` int(11) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `e_title` varchar(200) NOT NULL,
  `sub_title` varchar(400) NOT NULL,
  `sub_cate_id` int(11) NOT NULL,
  `pack_id` int(11) NOT NULL,
  `e_type` varchar(400) NOT NULL,
  `address` varchar(400) NOT NULL,
  `area` varchar(200) NOT NULL,
  `city` varchar(200) NOT NULL,
  `e_desc` longtext NOT NULL,
  `entry` varchar(10) NOT NULL,
  `entry_fees` int(11) NOT NULL,
  `e_date` date NOT NULL,
  `l_date` date NOT NULL,
  `e_image` varchar(100) NOT NULL,
  `e_broucher` varchar(100) NOT NULL,
  `e_status` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `event_post`
--

INSERT INTO `event_post` (`event_id`, `vendor_id`, `e_title`, `sub_title`, `sub_cate_id`, `pack_id`, `e_type`, `address`, `area`, `city`, `e_desc`, `entry`, `entry_fees`, `e_date`, `l_date`, `e_image`, `e_broucher`, `e_status`) VALUES
(1, 31, 'CHESS TOURNAMENT', 'IN A AROUND CHENNAI TOURNAMENT', 119, 3, 'trophy', '#165. Paper Mills Road, SRP Colony', 'Kolathur', 'Chennai', '<p>IN A AROUND CHENNAI TOURNAMENT,&nbsp;IN A AROUND CHENNAI TOURNAMENT ,&nbsp;IN A AROUND CHENNAI TOURNAMENTIN A AROUND CHENNAI TOURNAMENTIN A AROUND CHENNAI TOURNAMENTIN A AROUND CHENNAI TOURNAMENT<br></p>', 'paid', 100, '2023-01-10', '2023-01-02', 'event31122022143930.jpg', 'broucher31122022143930.jpeg', 2),
(2, 34, 'CHESS TOURNAMENT', 'Kolathur, Chennai', 130, 3, 'Prize & Trophy', '165, Paper Mill Road, SRP Colony', 'Kolathur', 'Chennai', '<p>CHESS TOURNAMENT, 1st STD to 6th Standard Childrens, School Id Card Must<br></p>', 'paid', 100, '2023-01-15', '2023-01-10', 'event03012023085643.jpg', 'broucher03012023085643.jpg', 2),
(3, 34, 'Tournament Carrom', 'Kolathur, Chennai', 131, 6, 'Trophy', '#165, Paper Mills Road, SRP Colony, Peravallur,', 'Kolathur', 'Chennai', '<p>Tournament Carrom, School Student Match, ID Card Must<br></p>', 'paid', 150, '2023-01-14', '2023-01-10', 'event03012023092543.jpg', 'broucher03012023092543.jpg', 2),
(4, 34, 'Corporate Tennis Ball', 'Kolathur, Chennai', 132, 4, 'Prize & Trophy', '#165, Paper Mills Road, SRP Colony, ', 'Kolathur', 'Chennai', '<p>Corporate Tennis Ball, Only For BPO, IT And NON IT Company Can Apply<br></p>', 'paid', 250, '2023-01-15', '2023-01-15', 'event03012023092821.jpg', 'broucher03012023092821.jpg', 2);

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

--
-- Table structure for table `ewallet_master`
--

CREATE TABLE `ewallet_master` (
  `id` int(11) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `total_amount` int(11) NOT NULL,
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ewallet_master`
--

INSERT INTO `ewallet_master` (`id`, `vendor_id`, `user_id`, `total_amount`, `updated_date`) VALUES
(1, 0, 30, 900, '2022-12-31 09:11:41'),
(2, 31, 0, 600, '2022-12-31 09:03:45'),
(3, 32, 0, 1200, '2023-01-03 08:13:51'),
(4, 0, 33, 900, '2023-01-02 22:22:33'),
(5, 34, 0, 1050, '2023-01-03 03:58:21');

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

--
-- Table structure for table `feature`
--

CREATE TABLE `feature` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `feature_desc` varchar(400) NOT NULL,
  `icon` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `feature`
--

INSERT INTO `feature` (`id`, `title`, `feature_desc`, `icon`) VALUES
(1, 'Pure & Natural', '', 'icon-1.png'),
(2, 'No Preservatives', '', 'icon-2.png'),
(3, 'Farm Fresh', '', 'icon-3.png');

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

--
-- Table structure for table `game_banner`
--

CREATE TABLE `game_banner` (
  `slider_id` int(11) NOT NULL,
  `Slider_contecnt` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slider_title` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slider_Image` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slider_order` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slider_Status` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Slider_link` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` varchar(13) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `game_banner`
--

INSERT INTO `game_banner` (`slider_id`, `Slider_contecnt`, `Slider_title`, `Slider_Image`, `Slider_order`, `Slider_Status`, `Slider_link`, `size`) VALUES
(8, '100% satisfaction guarantee', 'Up to 70% Off - Free Shipping', 'wooden-sculptures.jpg', '1', '1', 'https://www.google.co.in/1', '907 * 630'),
(9, 'Best Quality Assured', 'Modern Gardening Products', 'brass-statues.jpg', '2', '1', 'https://www.google.co.in', '907 * 300'),
(10, 'Discover wide range', 'Discover wide range', 'vedic-beads.jpg', '3', '1', 'https://www.academyoftraditionalart.com/', '907 * 300');

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

--
-- Table structure for table `game_rate`
--

CREATE TABLE `game_rate` (
  `Game_rate_id` int(11) NOT NULL,
  `Game_Rateing` varchar(255) DEFAULT NULL,
  `Rate_Status` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `game_rate`
--

INSERT INTO `game_rate` (`Game_rate_id`, `Game_Rateing`, `Rate_Status`) VALUES
(24, '500 ML', 1),
(25, '1000 ML', 1);

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

--
-- Table structure for table `game_support_flatform`
--

CREATE TABLE `game_support_flatform` (
  `shop_id` int(11) NOT NULL,
  `Shop__setting` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Shop_setting_status` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_list` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `game_support_flatform`
--

INSERT INTO `game_support_flatform` (`shop_id`, `Shop__setting`, `Shop_setting_status`, `order_list`, `icon`) VALUES
(14, '500 ML', '1', '', '../../../photos/gamesupport/'),
(15, '1 Liter', '1', '', '../../../photos/gamesupport/'),
(16, '5 Liter', '1', '', '../../../photos/gamesupport/');

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

--
-- Table structure for table `infrastructure`
--

CREATE TABLE `infrastructure` (
  `infra_id` int(11) NOT NULL,
  `infra_title` varchar(200) NOT NULL,
  `infra_desc` longblob NOT NULL,
  `infra_img` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `infrastructure`
--

INSERT INTO `infrastructure` (`infra_id`, `infra_title`, `infra_desc`, `infra_img`) VALUES
(4, 'Infrastructure', 0x3c7020636c6173733d224d736f4e6f726d616c223e3c7370616e206c616e673d22454e2d474222207374796c653d22666f6e742d73697a653a31342e3070743b6d736f2d626964692d666f6e742d73697a653a0d0a31312e3070743b6c696e652d6865696768743a313135253b6d736f2d616e73692d6c616e67756167653a454e2d4742223e546865206272616e6420686173207468650d0a6d616e75666163747572696e6720636170616369747920746f2070726f64756365203630206d657472696320746f6e73206f6620707572652067686565206576657279206d6f6e74682e0d0a467572746865722c207468652062657374207175616c69747920636f6e74726f6c20706f6c69636965732061726520656d706c6f79656420616e64207365766572616c20636865636b73206172650d0a756e64657274616b656e206265666f7265207468652070726f647563742069732068796769656e6963616c6c79207061636b656420616e64207365616c65642c20746f20656e7375726520796f750d0a686176652074686520667265736865737420616e642066696e6573742067686565206f6e2068616e6420746f206164642061206d61676963616c20666c61766f757220746f20796f75720d0a6661766f7572697465206469736865732e3c6f3a703e3c2f6f3a703e3c2f7370616e3e3c2f703e, '1669970759.jpeg');

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

--
-- Table structure for table `intro_master`
--

CREATE TABLE `intro_master` (
  `intro_id` int(11) NOT NULL,
  `Intro_Content` longtext NOT NULL,
  `Intro_Image` varchar(255) NOT NULL,
  `Intro_Logo` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `intro_master`
--

INSERT INTO `intro_master` (`intro_id`, `Intro_Content`, `Intro_Image`, `Intro_Logo`) VALUES
(1, 'Online Shopping Store', '../../../photos/Intro/qrcode.png', '../../../photos/Intro/leefoodies.jpg');

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

--
-- Table structure for table `landing_page`
--

CREATE TABLE `landing_page` (
  `Landing_id` int(11) NOT NULL,
  `Landing_icon` varchar(500) NOT NULL,
  `Landing_Bold` varchar(500) NOT NULL,
  `Landing_text` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `landing_page`
--

INSERT INTO `landing_page` (`Landing_id`, `Landing_icon`, `Landing_Bold`, `Landing_text`) VALUES
(1, 'icofont-sale-discount', 'Best Prices & Offers.', 'Cheaper prices than your local supermarket, great cashback offers to top it off.'),
(2, 'icofont-cart', 'Wide Assortment', 'Choose from 5000+ products across food, personal care, household & other categories.'),
(3, 'icofont-support-faq', 'Easy Returns', 'Not satisfied with a product? Return it at the doorstep & get a refund within hours.');

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

--
-- Table structure for table `leadership_master`
--

CREATE TABLE `leadership_master` (
  `leadership_id` int(11) NOT NULL,
  `leadership_title` varchar(120) NOT NULL,
  `leadership_position` varchar(200) NOT NULL,
  `leadership_desc` varchar(400) DEFAULT NULL,
  `leadership_img` varchar(200) NOT NULL,
  `leadership_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `leadership_master`
--

INSERT INTO `leadership_master` (`leadership_id`, `leadership_title`, `leadership_position`, `leadership_desc`, `leadership_img`, `leadership_status`) VALUES
(1, 'H.Sriramachandhran ', 'Chief Executive Officer', '', 'Lead_01.jpg', 1),
(2, 'S. Srividhya', 'Chief Finance Officer', '', 'Lead_02.jpg', 1),
(3, 'A.B. Sathya ', 'Chief Operating Officer', '', 'Lead_02.jpg', 1),
(4, 'S. Sharaj Subraminiam ', 'Chief Growth Officer', '', 'Lead_01.jpg', 1);

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

--
-- Table structure for table `lee_master`
--

CREATE TABLE `lee_master` (
  `Site_id` int(11) NOT NULL,
  `Logo_Path` varchar(255) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Location` varchar(1000) DEFAULT NULL,
  `Address1` varchar(500) DEFAULT NULL,
  `Address2` varchar(500) NOT NULL,
  `Address3` varchar(500) NOT NULL,
  `Email_id` varchar(255) DEFAULT NULL,
  `Contact_Number` varchar(10) DEFAULT NULL,
  `Enable_Status` tinyint(4) DEFAULT NULL,
  `Facebook_link` varchar(1000) DEFAULT NULL,
  `Youtube_link` varchar(1000) DEFAULT NULL,
  `Instagram_link` varchar(1000) DEFAULT NULL,
  `Twitter_link` varchar(1000) DEFAULT NULL,
  `logo_status` tinyint(4) DEFAULT NULL,
  `Name_status` tinyint(4) DEFAULT NULL,
  `Contact_Status` tinyint(4) DEFAULT NULL,
  `GST_No` varchar(255) DEFAULT NULL,
  `Tel_No` varchar(255) DEFAULT NULL,
  `Website` longtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `lee_master`
--

INSERT INTO `lee_master` (`Site_id`, `Logo_Path`, `Name`, `Location`, `Address1`, `Address2`, `Address3`, `Email_id`, `Contact_Number`, `Enable_Status`, `Facebook_link`, `Youtube_link`, `Instagram_link`, `Twitter_link`, `logo_status`, `Name_status`, `Contact_Status`, `GST_No`, `Tel_No`, `Website`) VALUES
(1, '../../../img/logo/Logo.jpeg', 'Addmyentry', 'Chennai', 'Registered office: 15/6, Zenith Flats, Brindavan Street, Mylapore,  Chennai -600004', 'Corporate Officd: 6A,  KRD GEE GEE Crystal,  No. 92, RK. Salai, Mylapore, Chennai 600004', 'Factory Address: 236/2, West Thepam Road, MLP Village, Madurai district, Pin 625702', 'sales@virukshalaya.com ', '8590299999', 1, 'https://www.facebook.com/profile.php?id=100087071331060', 'https://studio.youtube.com/channel/UCIheR45eP4NJvdRgRQsph1Q/videos/upload?filter=%5B%5D&sort=%7B%22columnType%22%3A%22date%22%2C%22sortOrder%22%3A%22DESCENDING%22%7D', 'https://www.instagram.com/', 'https://twitter.com', 1, 1, 1, '33AAFCH1862H1ZR', '8386889999', '        <iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3886.8564450047625!2d80.26551291430503!3d13.044808216798383!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x3a52662e4de0bb3b%3A0xd573c710f9610089!2sKRD%20Gee%20Gee%20Crystal!5e0!3m2!1sen!2sin!4v1669375876953!5m2!1sen!2sin\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"no-referrer-when-downgrade\"></iframe>');

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

--
-- Table structure for table `logo_master`
--

CREATE TABLE `logo_master` (
  `logo_id` int(11) NOT NULL,
  `logo_name` varchar(400) NOT NULL,
  `logo_name_status` tinyint(2) NOT NULL,
  `logo_image` varchar(200) NOT NULL,
  `logo_status` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `logo_master`
--

INSERT INTO `logo_master` (`logo_id`, `logo_name`, `logo_name_status`, `logo_image`, `logo_status`) VALUES
(1, 'THAGAVAL BUSINESS NETWORK', 1, '1672706997.png', 1);

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

--
-- Table structure for table `main_category`
--

CREATE TABLE `main_category` (
  `Main_Category_id` int(11) NOT NULL,
  `Main_Category_Name` varchar(255) DEFAULT NULL,
  `Main_Category_Status` tinyint(4) DEFAULT NULL,
  `Main_Category_Add_on` date DEFAULT NULL,
  `Main_Category_image` varchar(255) DEFAULT NULL,
  `Shop_setting` varchar(255) DEFAULT NULL,
  `sub_menu` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `main_category`
--

INSERT INTO `main_category` (`Main_Category_id`, `Main_Category_Name`, `Main_Category_Status`, `Main_Category_Add_on`, `Main_Category_image`, `Shop_setting`, `sub_menu`) VALUES
(74, 'TOURNAMENT', 1, '2023-01-03', NULL, NULL, 1),
(80, 'EVENTS', 1, NULL, NULL, NULL, 1),
(81, 'CLASSIFIED', 1, NULL, NULL, NULL, 1),
(82, 'SOFTWARE', 1, NULL, NULL, NULL, 1);

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

--
-- Table structure for table `main_category_res`
--

CREATE TABLE `main_category_res` (
  `Main_Category_id` int(11) NOT NULL,
  `Main_Category_Name` varchar(255) DEFAULT NULL,
  `Main_Category_Status` tinyint(4) DEFAULT NULL,
  `Main_Category_Add_on` date DEFAULT NULL,
  `Main_Category_image` varchar(255) DEFAULT NULL,
  `Shop_setting` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `minu_order`
--

CREATE TABLE `minu_order` (
  `minu_order_id` int(120) NOT NULL,
  `minu_order_price` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `minu_order_pre` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `minu_order_status` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `minu_order`
--

INSERT INTO `minu_order` (`minu_order_id`, `minu_order_price`, `minu_order_pre`, `minu_order_status`) VALUES
(1, '10', '10', '1');

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

--
-- Table structure for table `module_view`
--

CREATE TABLE `module_view` (
  `id` int(10) NOT NULL,
  `four_banner` varchar(50) NOT NULL,
  `hotdeal` varchar(50) NOT NULL,
  `specials` varchar(50) NOT NULL,
  `featured` varchar(50) NOT NULL,
  `new_arrivals` varchar(50) NOT NULL,
  `twothirdbanner` varchar(50) NOT NULL,
  `footerbanner` varchar(50) NOT NULL,
  `top_catgories` varchar(50) NOT NULL,
  `popular_brand` varchar(50) NOT NULL,
  `newsletter` varchar(50) NOT NULL,
  `sidebanner` varchar(50) NOT NULL,
  `related` varchar(50) NOT NULL,
  `compare` varchar(50) NOT NULL,
  `payumoney` varchar(255) NOT NULL,
  `paytm` char(20) NOT NULL,
  `cash_on_delivery` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `module_view`
--

INSERT INTO `module_view` (`id`, `four_banner`, `hotdeal`, `specials`, `featured`, `new_arrivals`, `twothirdbanner`, `footerbanner`, `top_catgories`, `popular_brand`, `newsletter`, `sidebanner`, `related`, `compare`, `payumoney`, `paytm`, `cash_on_delivery`) VALUES
(1, '', '', '', 'yes', 'yes', 'yes', 'yes', 'yes', '', 'yes', 'yes', 'yes', '', 'yes', 'no', 'yes');

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

--
-- Table structure for table `offer_master`
--

CREATE TABLE `offer_master` (
  `Offer_id` int(11) NOT NULL,
  `Offer_Title` varchar(255) DEFAULT NULL,
  `Offer_main_category` varchar(255) DEFAULT NULL,
  `Offer_Sub_category` varchar(255) DEFAULT NULL,
  `Offer_percent` int(11) DEFAULT NULL,
  `Offer_upto` date DEFAULT NULL,
  `Offer_Status` tinyint(4) DEFAULT NULL,
  `offer_price` decimal(10,2) DEFAULT NULL,
  `offer_Product_id` int(11) DEFAULT NULL,
  `offer_add_on` date DEFAULT NULL,
  `offer_quality` varchar(255) DEFAULT NULL,
  `Shop_setting` varchar(255) DEFAULT NULL,
  `Product_price` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

--
-- Stand-in structure for view `offer_product`
-- (See below for the actual view)
--
CREATE TABLE `offer_product` (
`Offer_id` int(11)
,`Offer_Title` varchar(255)
,`Offer_main_category` varchar(255)
,`Offer_Sub_category` varchar(255)
,`Offer_percent` int(11)
,`Offer_upto` date
,`Offer_Status` tinyint(4)
,`offer_price` decimal(10,2)
,`offer_Product_id` int(11)
,`offer_add_on` date
,`offer_quality` varchar(255)
);

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

--
-- Table structure for table `offline_payment_setting`
--

CREATE TABLE `offline_payment_setting` (
  `offline_id` int(11) NOT NULL,
  `offline_mode` varchar(200) NOT NULL,
  `offline_img` varchar(200) NOT NULL,
  `offline_details` longblob NOT NULL,
  `offline_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `offline_payment_setting`
--

INSERT INTO `offline_payment_setting` (`offline_id`, `offline_mode`, `offline_img`, `offline_details`, `offline_status`) VALUES
(1, '', 'ICICI Bank.png', 0x2020202020203c703e2048696d61646872692044616972792050726f64756374732050726976617465204c696d697465642c266e6273703b204163636f756e74204e6f3a203030303130353033343637372c204272616e63683a2043656e6f7461706820526f61642c204368656e6e61692c266e6273703b204163636f756e7420547970653a2043412c204946534320434f44453a204943494349303030303030313c2f703e, 1),
(2, '', 'QR Code.jpeg', 0x203c703e202020202020203c2f703e3c703e203c2f703e3c703e3c2f703e, 1),
(3, '', 'Gpay.png', 0x203c623e393834303134323830313c2f623e, 1);

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

--
-- Table structure for table `online_class`
--

CREATE TABLE `online_class` (
  `online_class_id` int(12) NOT NULL,
  `s_name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `s_last_name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `s_email` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `s_phone` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `s_age` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `s_city` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `s_address` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `s_occ` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `s_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `s_pic_name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `s_size` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `s_tpic_name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `s_tsize` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `s_tref_pic` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `online_class`
--

INSERT INTO `online_class` (`online_class_id`, `s_name`, `s_last_name`, `s_email`, `s_phone`, `s_age`, `s_city`, `s_address`, `s_occ`, `s_type`, `s_pic_name`, `s_size`, `s_tpic_name`, `s_tsize`, `s_tref_pic`, `created_at`, `updated_at`) VALUES
(2, 'saravananan', 'asad', 'saravanansri1999@gmail.com', '09876543210', '2019-05-10', 'erode', '11', 'eq', '2', '', '', 'wrew', 'wrw', 'b5.jpg', '2022-06-30 08:13:25', '2022-06-30 10:42:04'),
(3, 'saravananan', 'asad', 'saravanansri1999@gmail.com', '09876543210', '2007-02-15', 'erode', '11', 'eq', '1', 'er', '12 * 15 Inches', '', '', '', '2022-06-30 10:47:05', '2022-06-30 10:47:05');

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

--
-- Table structure for table `online_payment_transcation`
--

CREATE TABLE `online_payment_transcation` (
  `Online_order_id` int(11) NOT NULL,
  `Customer_id` int(11) DEFAULT NULL,
  `Customer_Name` varchar(255) DEFAULT NULL,
  `Order_id` varchar(11) DEFAULT NULL,
  `Order_Paid_Status` varchar(255) DEFAULT NULL,
  `Paid_on` varchar(255) DEFAULT NULL,
  `R_Order_id` varchar(255) DEFAULT NULL,
  `Payment_id` varchar(255) DEFAULT NULL,
  `Payment_Gateway` varchar(255) DEFAULT NULL,
  `Shop_setting` varchar(255) DEFAULT NULL,
  `Paid_Amout` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `online_payment_transcation`
--

INSERT INTO `online_payment_transcation` (`Online_order_id`, `Customer_id`, `Customer_Name`, `Order_id`, `Order_Paid_Status`, `Paid_on`, `R_Order_id`, `Payment_id`, `Payment_Gateway`, `Shop_setting`, `Paid_Amout`) VALUES
(1, 82, 'saravananan s asad', '1952712', 'success', ' 27-08-2022 12:48: pm ', 'order_KAZS6Tbvsr0GRP', 'pay_KAZUjmH8K1DYIN', 'Razorpay', NULL, '560'),
(2, 82, 'saravananan s asad', '33952712', 'success', ' 27-08-2022 12:57: pm ', 'order_KAZdmFOXFdBro6', 'pay_KAZe4NZuhO6M1o', 'Razorpay', NULL, '560'),
(3, 83, 'saravananan asad', '5390101', 'success', ' 01-09-2022 13:43: pm ', 'order_KCZ5w5f87D5uCy', 'pay_KCZ6LHfcYq4ztL', 'Razorpay', NULL, '100'),
(4, 83, 'saravananan asad', '45190106', 'success', ' 01-09-2022 18:47: pm ', 'MOJO2901705A84270869', '7c5cca15359241f8bc91208bee152121', 'instamojo', NULL, '100'),
(5, 83, 'saravananan asad', '13810106', 'success', ' 01-09-2022 18:52: pm ', 'MOJO2901G05A84270872', '33e746be079c4ece9e763814ee93987a', 'instamojo', NULL, '420'),
(6, 84, 'saravananan s asad', '61801006', 'success', ' 10-09-2022 18:04: pm ', 'MOJO2910N05A59420331', '0c3d1394843d4fb1978dd0402af635a4', 'instamojo', NULL, '24'),
(7, 85, 'saravananan s asad', '45662310', 'success', ' 23-09-2022 10:37: am ', 'MOJO2923805A92892375', 'ee47eb6138f340ab8b2df5303541ef72', 'instamojo', NULL, '50'),
(8, 86, 'shah', '57412410', 'success', ' 24-09-2022 11:03: am ', 'order_KLcgXzGTecAGk4', 'pay_KLcgjuDrTzNU3L', 'Razorpay', NULL, '10'),
(9, 86, 'shah', '66252401', 'success', ' 24-09-2022 13:37: pm ', 'MOJO2924X05Q98379857', '2648831fcd8a4609b5d857a8e5976bd1', 'instamojo', NULL, '10'),
(10, 92, 'abi', '25962401', 'success', ' 24-09-2022 13:45: pm ', 'MOJO2924U05Q98380098', 'ce2bbf8db9d74b258fe05e0873aee629', 'instamojo', NULL, '10'),
(11, 93, 'shah', '40812402', 'success', ' 24-09-2022 14:46: pm ', 'MOJO2924N05Q98382255', 'fe462ebf0c3f4105a7a7ac7d7b34b5e9', 'instamojo', NULL, '10'),
(12, 94, 'shah', '44572403', 'success', ' 24-09-2022 15:50: pm ', 'MOJO2924F05Q98384322', '32214b86187240ab957bf44ed093c3f4', 'instamojo', NULL, '10'),
(13, 95, 'saravananan s asad', '59992403', 'success', ' 24-09-2022 15:52: pm ', 'order_KLhcYfLmRybysf', 'pay_KLhdCpVGoCg24m', 'Razorpay', NULL, '480'),
(14, 95, 'saravananan s asad', '62672403', 'success', ' 24-09-2022 15:55: pm ', 'order_KLhgqfOGdz9UbE', 'pay_KLhh5L0Wdzmj4T', 'Razorpay', NULL, '128'),
(15, 95, 'saravananan s asad', '25902404', 'success', ' 24-09-2022 16:12: pm ', 'order_KLhxxxrLE2gSTI', 'pay_KLhyhawmT04y14', 'Razorpay', NULL, '480'),
(16, 96, 'shah', '43652404', 'success', ' 24-09-2022 16:17: pm ', 'order_KLi2JDPPJv5Yut', 'pay_KLi2lKxOzUbx6B', 'Razorpay', NULL, '10'),
(17, 97, 'abi', '33482404', 'success', ' 24-09-2022 16:22: pm ', 'MOJO2924305Q98385291', 'eb98016ecaad4ef8a73062cbfb7b14ed', 'instamojo', NULL, '10'),
(18, 97, 'abi', '43142404', 'success', ' 24-09-2022 16:51: pm ', 'MOJO2924805Q98386075', 'df2868b11e2641fa829684a19ee4a0d1', 'instamojo', NULL, '10'),
(19, 98, 'Saravana Kumar', '29992612', 'success', ' 26-09-2022 12:20: pm ', 'MOJO2926T05Q21967882', '6bd7f521b9044185ac54af7e36fbc51e', 'instamojo', NULL, '108'),
(20, 99, 'Saravana Kumar', '21280309', 'success', ' 03-10-2022 21:12: pm ', 'MOJO2a03Y05Q28285193', '246c3f62a30c47fbac5f637a70365fe2', 'instamojo', NULL, '154'),
(21, 105, 'saravananan s asad', '', 'success', ' 11-10-2022 15:02: pm ', 'order_KSPnR9JBYnADac', 'pay_KSPoWR0ubCgI3E', 'Razorpay', NULL, '3650'),
(22, 105, 'saravananan s asad', '', 'success', ' 11-10-2022 15:03: pm ', 'order_KSPnR9JBYnADac', 'pay_KSPoWR0ubCgI3E', 'Razorpay', NULL, '3650'),
(23, 105, 'saravananan s asad', '', 'success', ' 11-10-2022 15:06: pm ', 'order_KSPnR9JBYnADac', 'pay_KSPoWR0ubCgI3E', 'Razorpay', NULL, '3650'),
(24, 105, 'saravananan s asad', '5091103', 'success', ' 11-10-2022 15:12: pm ', 'order_KSPzKaEfYO8L4N', 'pay_KSPzYmCqUWKGqY', 'Razorpay', NULL, '1450'),
(25, 105, 'saravananan s asad', '5091103', 'success', ' 11-10-2022 15:14: pm ', 'order_KSPzKaEfYO8L4N', 'pay_KSPzYmCqUWKGqY', 'Razorpay', NULL, '1450'),
(26, 105, 'saravananan s asad', '5091103', 'success', ' 11-10-2022 15:15: pm ', 'order_KSPzKaEfYO8L4N', 'pay_KSPzYmCqUWKGqY', 'Razorpay', NULL, '1450'),
(27, 106, 'saravananan s asad', '1721104', 'success', ' 11-10-2022 16:07: pm ', 'order_KSQupq0s63q8Sm', 'pay_KSQvFtRZpXLxkM', 'Razorpay', NULL, '4050'),
(28, 108, 'saravana', '10141109', 'success', ' 11-10-2022 21:09: pm ', 'order_KSW5fzyOXLvQ8a', 'pay_KSW5mbSwjvpJNh', 'Razorpay', NULL, '20'),
(29, 109, 'saravana', '22531210', 'success', ' 12-10-2022 10:06: am ', 'order_KSjM59HFn62Q2R', 'pay_KSjMC4OrmcBapo', 'Razorpay', NULL, '15'),
(30, 110, 'saravananan s asad', '27431206', 'success', ' 12-10-2022 18:22: pm ', 'order_KSrnXSi2rzGBhK', 'pay_KSro4xpQvRToOR', 'Razorpay', NULL, '190'),
(31, 113, 'kumar', '62051311', 'success', ' 13-10-2022 11:12: am ', 'order_KT90KiajrweVuq', 'pay_KT90bJkMMlhco1', 'Razorpay', NULL, '20'),
(32, 114, 'saravananan s asad', '40431311', 'success', ' 13-10-2022 11:59: am ', 'order_KT9ooZxkFqVJxl', 'pay_KT9p0iuKSB4wzL', 'Razorpay', NULL, '89'),
(33, 116, 'shah', '46181306', 'success', ' 13-10-2022 18:02: pm ', 'order_KTFymuchWSYHra', 'pay_KTFyzZPU3Na1d7', 'Razorpay', NULL, '20'),
(34, 117, 'saravana', '59311307', 'success', ' 13-10-2022 19:33: pm ', 'order_KTHXD3Tn5I5HQc', 'pay_KTHXXp72oGBjOM', 'Razorpay', NULL, '20'),
(35, 0, '', '', 'success', ' 01-11-2022 14:42: pm ', '', '', 'Razorpay', NULL, ''),
(36, 176, 'saravana', '16152209', 'success', ' 22-11-2022 21:58: pm ', 'MOJO2b22P05Q05216453', '394d0123eaa74a5cb4126a4c7f6b3030', 'instamojo', NULL, '30'),
(37, 178, 'saravana', '37912512', 'success', ' 25-11-2022 12:52: pm ', 'MOJO2b25105Q01978150', '641437f5221f49a1a535845a614daa9f', 'instamojo', NULL, '70'),
(38, 183, 'sd', '24393011', 'success', ' 30-11-2022 11:23: am ', 'MOJO2b30Y05Q44560308', '028a1c62343f4b828f3b849efe7d78bf', 'instamojo', NULL, '29'),
(39, 184, 'sd', '7643012', 'success', ' 30-11-2022 13:19: pm ', 'order_KmAofGWwvT7WsC', 'pay_KmAornTQBDOh3e', 'Razorpay', NULL, '30'),
(40, 184, 'sd', '64603001', 'success', ' 30-11-2022 13:23: pm ', 'order_KmAsjNVOZmHOsr', 'pay_KmAst51CRezSwj', 'Razorpay', NULL, '29'),
(41, 185, 'SARAVANAN', '34763003', 'success', ' 30-11-2022 15:04: pm ', 'order_KmCbbwSoYMTngi', 'pay_KmCc17cRgmBQ0O', 'Razorpay', NULL, '120'),
(42, 185, 'SARAVANAN', '60793003', 'success', ' 30-11-2022 15:07: pm ', 'order_KmCeOHXb6LvLTx', 'pay_KmCeahUL8npd9p', 'Razorpay', NULL, '120'),
(43, 188, 'SARAVANAN', '39440102', 'success', ' 01-12-2022 15:02: pm ', 'order_Kmb66LhZsqJ1uv', 'pay_Kmb6tTHSPv8PSq', 'Razorpay', NULL, '30');

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

--
-- Table structure for table `order_master`
--

CREATE TABLE `order_master` (
  `order_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `ticket` int(11) NOT NULL,
  `transaction_id` varchar(200) NOT NULL,
  `order_category` int(11) NOT NULL,
  `order_sub_category` int(11) NOT NULL,
  `order_package` int(11) NOT NULL,
  `order_price` int(11) NOT NULL,
  `order_on` datetime NOT NULL,
  `payment_mode` varchar(400) NOT NULL,
  `add_on` int(11) NOT NULL,
  `total` int(11) NOT NULL,
  `paid_status` tinyint(2) NOT NULL,
  `paid_date` datetime NOT NULL,
  `order_status` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_master`
--

INSERT INTO `order_master` (`order_id`, `customer_id`, `ticket`, `transaction_id`, `order_category`, `order_sub_category`, `order_package`, `order_price`, `order_on`, `payment_mode`, `add_on`, `total`, `paid_status`, `paid_date`, `order_status`) VALUES
(1, 31, 734181, 'dsgsfs', 74, 122, 1, 100, '2022-12-31 14:33:01', 'offline', 500, 0, 1, '2022-12-31 02:33:45', 2),
(2, 0, 0, '', 74, 122, 1, 100, '2023-01-02 16:27:24', '', 0, 0, 0, '0000-00-00 00:00:00', 1),
(3, 0, 0, '', 74, 122, 1, 100, '2023-01-02 16:30:40', '', 0, 0, 0, '0000-00-00 00:00:00', 1),
(4, 0, 0, '', 74, 122, 1, 100, '2023-01-02 16:33:46', '', 0, 0, 0, '0000-00-00 00:00:00', 1),
(5, 0, 0, '', 74, 122, 1, 100, '2023-01-02 16:39:51', '', 0, 0, 0, '0000-00-00 00:00:00', 1),
(6, 34, 121486, 'dffr3442', 74, 130, 3, 1200, '2023-01-03 08:51:24', 'offline', 100, 0, 1, '2023-01-03 08:56:49', 2),
(7, 32, 548259, '2345236', 74, 130, 3, 1200, '2023-01-03 13:43:12', 'offline', 0, 0, 1, '2023-01-03 01:43:51', 2);

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

--
-- Table structure for table `order_master1`
--

CREATE TABLE `order_master1` (
  `Order_id` int(11) NOT NULL,
  `Order_Main_Category` varchar(255) DEFAULT NULL,
  `Order_Sub_category` varchar(255) DEFAULT NULL,
  `Ordered_quantity` varchar(255) DEFAULT NULL,
  `Order_Price` float(10,0) DEFAULT NULL,
  `Order_on` date DEFAULT NULL,
  `Order_delivery_time` varchar(255) DEFAULT NULL,
  `Order_delivery_date` date DEFAULT NULL,
  `Payment_Mode` varchar(255) DEFAULT NULL,
  `Customer_id` varchar(255) DEFAULT NULL,
  `Customer__address_type` varchar(255) DEFAULT NULL,
  `Order_status` varchar(255) DEFAULT NULL,
  `order_customer_track_id` varchar(255) DEFAULT NULL,
  `Order_product` varchar(255) DEFAULT NULL,
  `Product_priceid` varchar(120) NOT NULL,
  `Order_product_price` float(10,0) DEFAULT NULL,
  `Referral_code` varchar(255) DEFAULT NULL,
  `Refered_customer_id` int(11) DEFAULT NULL,
  `Order_type_quantity` varchar(255) DEFAULT NULL,
  `Delivery_status` varchar(255) DEFAULT NULL,
  `Grand_total` float(10,2) DEFAULT NULL,
  `Delivery_charge` int(10) NOT NULL,
  `Promo_code` varchar(255) DEFAULT NULL,
  `Promo_code_status` varchar(255) DEFAULT NULL,
  `Promo_code_offer_Percent` float(10,0) DEFAULT NULL,
  `Discount_Offer_prce` int(10) NOT NULL,
  `Promocode_status` varchar(255) DEFAULT NULL,
  `Paid_status` varchar(255) DEFAULT NULL,
  `Wallet_Amount` float(19,0) DEFAULT NULL,
  `wallet_status` varchar(255) DEFAULT NULL,
  `Productname` varchar(255) DEFAULT NULL,
  `Payment_Option` varchar(255) DEFAULT NULL,
  `Shop_setting` varchar(255) DEFAULT NULL,
  `Product_tax` varchar(255) DEFAULT NULL,
  `Product_tax_amount` varchar(255) DEFAULT NULL,
  `Product_total_tax_amount` varchar(255) DEFAULT NULL,
  `product_plateform` varchar(255) DEFAULT NULL,
  `product_type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `order_master1`
--

INSERT INTO `order_master1` (`Order_id`, `Order_Main_Category`, `Order_Sub_category`, `Ordered_quantity`, `Order_Price`, `Order_on`, `Order_delivery_time`, `Order_delivery_date`, `Payment_Mode`, `Customer_id`, `Customer__address_type`, `Order_status`, `order_customer_track_id`, `Order_product`, `Product_priceid`, `Order_product_price`, `Referral_code`, `Refered_customer_id`, `Order_type_quantity`, `Delivery_status`, `Grand_total`, `Delivery_charge`, `Promo_code`, `Promo_code_status`, `Promo_code_offer_Percent`, `Discount_Offer_prce`, `Promocode_status`, `Paid_status`, `Wallet_Amount`, `wallet_status`, `Productname`, `Payment_Option`, `Shop_setting`, `Product_tax`, `Product_tax_amount`, `Product_total_tax_amount`, `product_plateform`, `product_type`) VALUES
(375, '', NULL, '1', 2000, '2022-10-11', NULL, NULL, NULL, '', NULL, 'Cart', '10801111', '178', '249', 2000, NULL, NULL, '2000.00', NULL, 2000.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(376, '', NULL, '2', 4000, '2022-10-11', NULL, NULL, NULL, '101', NULL, 'Cart', '41161101', '178', '249', 2000, NULL, NULL, '2000.00', NULL, 4000.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(377, '', NULL, '2', 4000, '2022-10-11', NULL, NULL, NULL, '104', NULL, 'Cart', '3901102', '178', '249', 2000, NULL, NULL, '2000.00', NULL, 4000.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(378, '', NULL, '2', 4000, '2022-10-11', NULL, NULL, NULL, '105', NULL, 'Cart', '7481102', '178', '249', 2000, NULL, NULL, '2000.00', NULL, 4000.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(379, '', NULL, '2', 4000, '2022-10-11', NULL, NULL, NULL, '105', NULL, 'Cart', '58431102', '178', '249', 2000, NULL, NULL, '2000.00', NULL, 4000.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(380, '', NULL, '1', 2000, '2022-10-11', NULL, '0000-00-00', 'ONLINE_PAYMENT', '105', NULL, 'Completed', '5091103', '178', '249', 2000, NULL, NULL, '2000.00', 'Completed', 1450.00, 50, '', NULL, 30, 600, '1', '1', NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(381, '', NULL, '2', 4000, '2022-10-11', NULL, '0000-00-00', 'ONLINE_PAYMENT', '106', NULL, 'Completed', '1721104', '178', '249', 2000, NULL, NULL, '2000.00', 'Completed', 4050.00, 50, '', NULL, 0, 0, '1', '1', NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(382, '', NULL, '1', 2000, '2022-10-11', NULL, NULL, NULL, '106', NULL, 'Cart', '23101104', '178', '249', 2000, NULL, NULL, '2000.00', NULL, 2000.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(383, '', NULL, '2', 4000, '2022-10-11', NULL, NULL, NULL, '106', NULL, 'Cart', '65291104', '178', '249', 2000, NULL, NULL, '2000.00', NULL, 4000.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(384, '', NULL, '1', 1000, '2022-10-11', NULL, NULL, NULL, '', NULL, 'Cart', '22181105', '179', '250', 1000, NULL, NULL, '1000.00', NULL, 1000.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Test Product', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(385, '', NULL, '1', 10, '2022-10-11', NULL, NULL, NULL, '107', NULL, 'Cart', '17041109', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(386, '', NULL, '1', 10, '2022-10-11', NULL, NULL, NULL, '107', NULL, 'Cart', '33321109', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(387, '', NULL, '1', 10, '2022-10-11', NULL, NULL, NULL, '107', NULL, 'Cart', '56091109', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(388, '', NULL, '1', 10, '2022-10-13', NULL, '0000-00-00', 'ONLINE_PAYMENT', '108', NULL, 'Completed', '10141109', '184', '261', 10, NULL, NULL, '10.00', '22531210', 20.00, 10, '', NULL, 10, 0, '1', '1', NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(389, '', NULL, '1', 10, '2022-10-13', NULL, '0000-00-00', 'ONLINE_PAYMENT', '109', NULL, 'Completed', '22531210', '184', '261', 10, NULL, NULL, '10.00', 'Completed', 15.00, 10, '', NULL, 50, 5, '1', '1', NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(390, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '109', NULL, 'Cart', '42791210', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(391, '', NULL, '1', 75, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '33841210', '182', '255', 75, NULL, NULL, '75.00', NULL, 75.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(392, '', NULL, '3', 30, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '33841210', '184', '261', 10, NULL, NULL, '10.00', NULL, 30.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(393, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '31261212', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(394, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '56701201', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(395, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '35001201', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(396, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '56211201', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(397, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '36191201', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(398, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '36191201', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(399, '', NULL, '1', 75, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '36191201', '182', '255', 75, NULL, NULL, '75.00', NULL, 75.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(400, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '60781201', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(401, '', NULL, '2', 140, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '60781201', '181', '252', 70, NULL, NULL, '70.00', NULL, 140.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(402, '', NULL, '3', 225, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '60781201', '182', '255', 75, NULL, NULL, '75.00', NULL, 225.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(403, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '11051201', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(404, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '11051201', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(405, '', NULL, '1', 75, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '11051201', '182', '255', 75, NULL, NULL, '75.00', NULL, 75.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(406, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '26421201', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(407, '', NULL, '2', 140, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '26421201', '181', '252', 70, NULL, NULL, '70.00', NULL, 140.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(408, '', NULL, '2', 150, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '26421201', '182', '255', 75, NULL, NULL, '75.00', NULL, 150.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(409, '', NULL, '2', 20, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '33641201', '184', '261', 10, NULL, NULL, '10.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(410, '', NULL, '3', 210, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '33641201', '181', '252', 70, NULL, NULL, '70.00', NULL, 210.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(411, '', NULL, '3', 225, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '33641201', '182', '255', 75, NULL, NULL, '75.00', NULL, 225.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(412, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '55351201', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(413, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '55351201', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(414, '', NULL, '1', 75, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '55351201', '182', '255', 75, NULL, NULL, '75.00', NULL, 75.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(415, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '3991201', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(416, '', NULL, '2', 140, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '3991201', '181', '252', 70, NULL, NULL, '70.00', NULL, 140.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(417, '', NULL, '2', 150, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '3991201', '182', '255', 75, NULL, NULL, '75.00', NULL, 150.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(418, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '56191201', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(419, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '56191201', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(420, '', NULL, '1', 75, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '56191201', '182', '255', 75, NULL, NULL, '75.00', NULL, 75.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(421, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '64351202', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(422, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '64351202', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(423, '', NULL, '1', 75, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '64351202', '182', '255', 75, NULL, NULL, '75.00', NULL, 75.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(424, '', NULL, '2', 240, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '64351202', '181', '253', 120, NULL, NULL, '120.00', NULL, 240.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(425, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '57251202', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(426, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '57251202', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(427, '', NULL, '1', 75, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '57251202', '182', '255', 75, NULL, NULL, '75.00', NULL, 75.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(428, '', NULL, '2', 240, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '57251202', '181', '253', 120, NULL, NULL, '120.00', NULL, 240.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(429, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '54961202', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(430, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '54961202', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(431, '', NULL, '2', 240, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '54961202', '181', '253', 120, NULL, NULL, '120.00', NULL, 240.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(432, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '7121202', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(433, '', NULL, '2', 240, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '7121202', '181', '253', 120, NULL, NULL, '120.00', NULL, 240.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(434, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '61501202', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(435, '', NULL, '2', 140, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '7611202', '181', '252', 70, NULL, NULL, '70.00', NULL, 140.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(436, '', NULL, '2', 140, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '58811202', '181', '252', 70, NULL, NULL, '70.00', NULL, 140.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(437, '', NULL, '3', 210, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '61101202', '181', '252', 70, NULL, NULL, '70.00', NULL, 210.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(438, '', NULL, '6', 420, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '40681202', '181', '252', 70, NULL, NULL, '70.00', NULL, 420.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(439, '', NULL, '7', 490, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '341202', '181', '252', 70, NULL, NULL, '70.00', NULL, 490.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(440, '', NULL, '2', 140, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '33791202', '181', '252', 70, NULL, NULL, '70.00', NULL, 140.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(441, '', NULL, '3', 210, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '57091202', '181', '252', 70, NULL, NULL, '70.00', NULL, 210.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(442, '', NULL, '3', 210, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '58111202', '181', '252', 70, NULL, NULL, '70.00', NULL, 210.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(443, '', NULL, '1', 75, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '58111202', '182', '255', 75, NULL, NULL, '75.00', NULL, 75.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(444, '', NULL, '3', 210, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '12071202', '181', '252', 70, NULL, NULL, '70.00', NULL, 210.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(445, '', NULL, '2', 150, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '12071202', '182', '255', 75, NULL, NULL, '75.00', NULL, 150.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(446, '', NULL, '3', 210, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '52911202', '181', '252', 70, NULL, NULL, '70.00', NULL, 210.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(447, '', NULL, '2', 150, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '52911202', '182', '255', 75, NULL, NULL, '75.00', NULL, 150.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(448, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '5451202', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(449, '', NULL, '2', 240, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '5451202', '181', '253', 120, NULL, NULL, '120.00', NULL, 240.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(450, '', NULL, '2', 20, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '66161202', '184', '261', 10, NULL, NULL, '10.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(451, '', NULL, '2', 240, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '66161202', '181', '253', 120, NULL, NULL, '120.00', NULL, 240.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(452, '', NULL, '2', 20, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '19131202', '184', '261', 10, NULL, NULL, '10.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(453, '', NULL, '2', 240, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '19131202', '181', '253', 120, NULL, NULL, '120.00', NULL, 240.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(454, '', NULL, '1', 75, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '19131202', '182', '255', 75, NULL, NULL, '75.00', NULL, 75.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(455, '', NULL, '1', 10, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '13111202', '184', '261', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(456, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '27831202', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(457, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '14901202', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(458, '', NULL, '2', 20, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '14901202', '184', '261', 10, NULL, NULL, '10.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(459, '', NULL, '2', 20, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '38711202', '184', '261', 10, NULL, NULL, '10.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(460, '', NULL, '3', 210, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '58961202', '181', '252', 70, NULL, NULL, '70.00', NULL, 210.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(461, '', NULL, '2', 150, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '58961202', '182', '255', 75, NULL, NULL, '75.00', NULL, 150.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(462, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '26361202', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(463, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '26361202', '182', '265', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '18', NULL, NULL, NULL, '60'),
(464, '', NULL, '1', 20, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '26361202', '184', '264', 20, NULL, NULL, '20.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '18', NULL, NULL, NULL, '60'),
(465, '', NULL, '1', 550, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '51871205', '181', '254', 550, NULL, NULL, '550.00', NULL, 550.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(466, '', NULL, '1', 20, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '38201205', '184', '264', 20, NULL, NULL, '20.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '18', NULL, NULL, NULL, '60'),
(467, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '521205', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(468, '', NULL, '1', 550, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '56841205', '181', '254', 550, NULL, NULL, '550.00', NULL, 550.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(469, '', NULL, '2', 1100, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '30941205', '181', '254', 550, NULL, NULL, '550.00', NULL, 1100.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(470, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '30941205', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(471, '', NULL, '1', 120, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '30941205', '181', '253', 120, NULL, NULL, '120.00', NULL, 120.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(472, '', NULL, '2', 1100, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '36281205', '181', '254', 550, NULL, NULL, '550.00', NULL, 1100.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(473, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '36281205', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(474, '', NULL, '1', 120, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '36281205', '181', '253', 120, NULL, NULL, '120.00', NULL, 120.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(475, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '1141205', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(476, '', NULL, '1', 650, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '1141205', '182', '257', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(477, '', NULL, '2', 1100, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '4971205', '181', '254', 550, NULL, NULL, '550.00', NULL, 1100.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(478, '', NULL, '38', 4560, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '4971205', '181', '253', 120, NULL, NULL, '120.00', NULL, 4560.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(479, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '4971205', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(480, '', NULL, '2', 1100, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '63421205', '181', '254', 550, NULL, NULL, '550.00', NULL, 1100.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(481, '', NULL, '2', 240, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '63421205', '181', '253', 120, NULL, NULL, '120.00', NULL, 240.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(482, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '63421205', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(483, '', NULL, '2', 1100, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '53621205', '181', '254', 550, NULL, NULL, '550.00', NULL, 1100.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(484, '', NULL, '2', 240, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '53621205', '181', '253', 120, NULL, NULL, '120.00', NULL, 240.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(485, '', NULL, '2', 140, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '53621205', '181', '252', 70, NULL, NULL, '70.00', NULL, 140.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(486, '', NULL, '3', 210, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '5121205', '181', '252', 70, NULL, NULL, '70.00', NULL, 210.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(487, '', NULL, '4', 2600, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '5121205', '182', '257', 650, NULL, NULL, '650.00', NULL, 2600.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(488, '', NULL, '3', 210, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '26631205', '181', '252', 70, NULL, NULL, '70.00', NULL, 210.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(489, '', NULL, '4', 2600, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '26631205', '182', '257', 650, NULL, NULL, '650.00', NULL, 2600.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(490, '', NULL, '4', 280, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '61851206', '181', '252', 70, NULL, NULL, '70.00', NULL, 280.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(491, '', NULL, '4', 0, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '61851206', '', '257', 0, NULL, NULL, '', NULL, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, ''),
(492, '', NULL, '4', 280, '2022-10-12', NULL, NULL, 'ONLINE_PAYMENT', '', NULL, 'Completed', '65111206', '181', '252', 70, NULL, NULL, '70.00', '	\r\nCompleted', 280.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(493, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '5501206', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(494, '', NULL, '1', 60, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '5501206', '187', '276', 60, NULL, NULL, '60.00', NULL, 60.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(495, '', NULL, '1', 60, '2022-10-12', NULL, '0000-00-00', 'ONLINE_PAYMENT', '110', NULL, 'Completed', '27431206', '187', '276', 60, NULL, NULL, '60.00', 'Completed', 190.00, 10, '', NULL, 0, 0, '1', '1', NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(496, '', NULL, '1', 120, '2022-10-12', NULL, '0000-00-00', 'ONLINE_PAYMENT', '110', NULL, 'Completed', '27431206', '181', '253', 120, NULL, NULL, '120.00', 'Completed', 190.00, 10, '', NULL, 0, 0, '1', '1', NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(497, '', NULL, '1', 120, '2022-10-12', NULL, NULL, NULL, '112', NULL, 'Cart', '29721206', '181', '253', 120, NULL, NULL, '120.00', NULL, 120.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(498, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '20041207', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(499, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '33661207', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(500, '', NULL, '1', 70, '2022-10-12', NULL, NULL, NULL, '', NULL, 'Cart', '61431207', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(501, '', NULL, '1', 75, '2022-10-13', NULL, NULL, NULL, '', NULL, 'Cart', '56621311', '187', '275', 75, NULL, NULL, '75.00', NULL, 75.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(502, '', NULL, '1', 10, '2022-10-13', NULL, NULL, NULL, '', NULL, 'Cart', '53101311', '187', '276', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(504, '', NULL, '1', 79, '2022-10-13', NULL, NULL, NULL, '114', NULL, 'Cart', '28641311', '225', '320', 79, NULL, NULL, '79.00', NULL, 79.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'SESAME BURFI WHITE', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(505, '', NULL, '1', 79, '2022-10-13', NULL, '0000-00-00', 'ONLINE_PAYMENT', '114', NULL, 'Completed', '40431311', '225', '320', 79, NULL, NULL, '79.00', 'Canceled', 89.00, 10, '', NULL, 0, 0, '1', '1', NULL, NULL, 'SESAME BURFI WHITE', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(506, '', NULL, '1', 10, '2022-10-13', NULL, NULL, NULL, '', NULL, 'Cart', '7961312', '187', '276', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(507, '', NULL, '3', 255, '2022-10-13', NULL, NULL, NULL, '', NULL, 'Cart', '48631305', '188', '278', 85, NULL, NULL, '85.00', NULL, 255.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(508, '', NULL, '1', 10, '2022-10-13', NULL, NULL, NULL, '', NULL, 'Cart', '48631305', '187', '276', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(509, '', NULL, '3', 255, '2022-10-13', NULL, NULL, NULL, '115', NULL, 'Cart', '15261305', '188', '278', 85, NULL, NULL, '85.00', NULL, 255.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(510, '', NULL, '3', 30, '2022-10-13', NULL, NULL, NULL, '115', NULL, 'Cart', '15261305', '187', '276', 10, NULL, NULL, '10.00', NULL, 30.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(511, '', NULL, '1', 10, '2022-10-13', NULL, NULL, NULL, '115', NULL, 'Cart', '32411305', '187', '276', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(512, '', NULL, '1', 10, '2022-10-13', NULL, NULL, NULL, '115', NULL, 'Cart', '65671305', '187', '276', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(513, '', NULL, '1', 10, '2022-10-13', NULL, NULL, NULL, '115', NULL, 'Cart', '37451306', '187', '276', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(514, '', NULL, '1', 10, '2022-10-13', NULL, '0000-00-00', 'ONLINE_PAYMENT', '116', NULL, 'Completed', '46181306', '187', '276', 10, NULL, NULL, '10.00', 'Completed', 20.00, 10, '', NULL, 0, 0, '1', '1', NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(515, '', NULL, '1', 10, '2022-10-13', NULL, '0000-00-00', 'ONLINE_PAYMENT', '117', NULL, 'Completed', '59311307', '226', '321', 10, NULL, NULL, '10.00', 'Completed', 20.00, 10, '', NULL, 0, 0, '1', '1', NULL, NULL, 'FRIED GRAM BALLS', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(516, '', NULL, '1', 110, '2022-10-17', NULL, NULL, NULL, '', NULL, 'Cart', '14361709', '186', '271', 110, NULL, NULL, '110.00', NULL, 110.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Hand Wash', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(517, '', NULL, '1', 0, '2022-10-20', NULL, NULL, NULL, '88', NULL, 'Cart', '42632006', '', '208', 0, NULL, NULL, '', NULL, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, ''),
(518, '', NULL, '1', 0, '2022-10-20', NULL, NULL, NULL, '88', NULL, 'Cart', '42632006', '', '206', 0, NULL, NULL, '', NULL, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, ''),
(519, '', NULL, '1', 0, '2022-10-20', NULL, NULL, NULL, '88', NULL, 'Cart', '42632006', '', '207', 0, NULL, NULL, '', NULL, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, ''),
(520, '', NULL, '1', 110, '2022-10-27', NULL, NULL, NULL, '', NULL, 'Cart', '30502711', '186', '271', 110, NULL, NULL, '110.00', NULL, 110.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Hand Wash', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(521, '', NULL, '1', 650, '2022-11-01', NULL, NULL, NULL, '', NULL, 'Cart', '9920112', '188', '280', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Dish Wash Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(522, '', NULL, '1', 75, '2022-11-07', NULL, NULL, NULL, '', NULL, 'Cart', '27630707', '187', '275', 75, NULL, NULL, '75.00', NULL, 75.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Floor Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(523, '', NULL, '1', 79, '2022-11-15', NULL, NULL, NULL, '', NULL, 'Cart', '9201501', '224', '319', 79, NULL, NULL, '79.00', NULL, 79.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'SESAME BURFI BLACK', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(524, '', NULL, '1', 70, '2022-11-19', NULL, NULL, NULL, '', NULL, 'Cart', '54161907', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(525, '', NULL, '1', 70, '2022-11-19', NULL, NULL, NULL, '', NULL, 'Cart', '8851907', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(526, '', NULL, '1', 70, '2022-11-19', NULL, NULL, NULL, '', NULL, 'Cart', '5981907', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(527, '', NULL, '1', 70, '2022-11-19', NULL, NULL, NULL, '', NULL, 'Cart', '41461907', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(528, '', NULL, '1', 70, '2022-11-19', NULL, NULL, NULL, '', NULL, 'Cart', '21741907', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(529, '', NULL, '1', 65, '2022-11-19', NULL, NULL, NULL, '', NULL, 'Cart', '40741908', '185', '268', 65, NULL, NULL, '65.00', NULL, 65.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Toilet Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(530, '', NULL, '1', 70, '2022-11-20', NULL, NULL, NULL, '', NULL, 'Cart', '3522009', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(531, '', NULL, '1', 120, '2022-11-20', NULL, NULL, NULL, '', NULL, 'Cart', '3522009', '199', '291', 120, NULL, NULL, '120.00', NULL, 120.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Head Set Boat', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(532, '', NULL, '1', 550, '2022-11-20', NULL, NULL, NULL, '', NULL, 'Cart', '3522009', '201', '293', 550, NULL, NULL, '550.00', NULL, 550.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '3D Gold 3D-BT160', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(533, '', NULL, '1', 70, '2022-11-20', NULL, NULL, NULL, '', NULL, 'Cart', '24832009', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(534, '', NULL, '1', 70, '2022-11-20', NULL, NULL, NULL, '', NULL, 'Cart', '58652009', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(535, '', NULL, '1', 70, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '63682109', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(536, '', NULL, '1', 70, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '26282103', '181', '252', 70, NULL, NULL, '70.00', NULL, 70.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Detergent Liquid', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(537, '', NULL, '1', 65, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '6072107', '185', '268', 65, NULL, NULL, '65.00', NULL, 65.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Toilet Cleaner', NULL, NULL, '0', NULL, NULL, NULL, '60'),
(538, '', NULL, '1', 0, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '5052108', '', '268', 0, NULL, NULL, '', NULL, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, ''),
(539, '', NULL, '1', 0, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '5362108', '', '268', 0, NULL, NULL, '', NULL, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, ''),
(540, '', NULL, '1', 0, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '66412108', '', '268', 0, NULL, NULL, '', NULL, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, ''),
(541, '', NULL, '1', 0, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '26182108', '', '268', 0, NULL, NULL, '', NULL, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, ''),
(542, '', NULL, '1', 0, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '40332108', '', '268', 0, NULL, NULL, '', NULL, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, ''),
(543, '', NULL, '1', 0, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '42872108', '', '268', 0, NULL, NULL, '', NULL, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, ''),
(544, '', NULL, '1', 0, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '3372108', '', '268', 0, NULL, NULL, '', NULL, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, ''),
(545, '', NULL, '1', 0, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '28512109', '', '268', 0, NULL, NULL, '', NULL, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, ''),
(546, '', NULL, '1', 80, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '1482109', '228', '323', 80, NULL, NULL, '80.00', NULL, 80.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 01', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(547, '', NULL, '1', 20, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '62162110', '227', '322', 20, NULL, NULL, '20.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(548, '', NULL, '1', 20, '2022-11-21', NULL, NULL, NULL, '', NULL, 'Cart', '61582110', '227', '322', 20, NULL, NULL, '20.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(549, '', NULL, '1', 160, '2022-11-22', NULL, NULL, NULL, '', NULL, 'Cart', '64102209', '214', '306', 160, NULL, NULL, '160.00', NULL, 160.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Leggings', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(550, '', NULL, '1', 110, '2022-11-22', NULL, NULL, NULL, '', NULL, 'Cart', '47792211', '229', '324', 110, NULL, NULL, '110.00', NULL, 110.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 02', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(551, '', NULL, '1', 110, '2022-11-22', NULL, NULL, NULL, '', NULL, 'Cart', '56432211', '229', '324', 110, NULL, NULL, '110.00', NULL, 110.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 02', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(552, '', NULL, '1', 110, '2022-11-22', NULL, NULL, NULL, '', NULL, 'Cart', '52532211', '229', '324', 110, NULL, NULL, '110.00', NULL, 110.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 02', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(553, '', NULL, '1', 200, '2022-11-22', NULL, NULL, NULL, '148', NULL, 'Cart', '52602211', '230', '325', 200, NULL, NULL, '200.00', NULL, 200.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 05', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(554, '', NULL, '1', 160, '2022-11-22', NULL, NULL, NULL, '149', NULL, 'Cart', '45372211', '214', '306', 160, NULL, NULL, '160.00', NULL, 160.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Leggings', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(555, '', NULL, '1', 160, '2022-11-22', NULL, NULL, NULL, '149', NULL, 'Cart', '66172211', '214', '306', 160, NULL, NULL, '160.00', NULL, 160.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Leggings', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(556, '', NULL, '1', 160, '2022-11-22', NULL, NULL, NULL, '149', NULL, 'Cart', '17382211', '214', '306', 160, NULL, NULL, '160.00', NULL, 160.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Leggings', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(557, '', NULL, '3', 480, '2022-11-22', NULL, NULL, NULL, '150', NULL, 'Cart', '35762212', '214', '306', 160, NULL, NULL, '160.00', NULL, 480.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Leggings', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(558, '', NULL, '3', 480, '2022-11-22', NULL, NULL, NULL, '150', NULL, 'Cart', '65862212', '214', '306', 160, NULL, NULL, '160.00', NULL, 480.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Leggings', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(559, '', NULL, '1', 300, '2022-11-22', NULL, NULL, NULL, '150', NULL, 'Cart', '65862212', '231', '326', 300, NULL, NULL, '300.00', NULL, 300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 06', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(560, '', NULL, '1', 110, '2022-11-22', NULL, NULL, NULL, '', NULL, 'Cart', '49102212', '229', '324', 110, NULL, NULL, '110.00', NULL, 110.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 02', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(561, '', NULL, '1', 300, '2022-11-22', NULL, NULL, NULL, '151', NULL, 'Cart', '24342212', '231', '326', 300, NULL, NULL, '300.00', NULL, 300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 06', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(562, '', NULL, '1', 300, '2022-11-22', NULL, NULL, NULL, '152', NULL, 'Cart', '48242212', '231', '326', 300, NULL, NULL, '300.00', NULL, 300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 06', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(563, '', NULL, '1', 110, '2022-11-22', NULL, NULL, NULL, '', NULL, 'Cart', '61392201', '229', '324', 110, NULL, NULL, '110.00', NULL, 110.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 02', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(564, '', NULL, '1', 300, '2022-11-22', NULL, NULL, NULL, '153', NULL, 'Cart', '38442201', '231', '326', 300, NULL, NULL, '300.00', NULL, 300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 06', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(565, '', NULL, '1', 300, '2022-11-22', NULL, NULL, NULL, '154', NULL, 'Cart', '36392201', '231', '326', 300, NULL, NULL, '300.00', NULL, 300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 06', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(566, '', NULL, '1', 300, '2022-11-22', NULL, NULL, NULL, '155', NULL, 'Cart', '45562201', '231', '326', 300, NULL, NULL, '300.00', NULL, 300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 06', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(567, '', NULL, '1', 300, '2022-11-22', NULL, NULL, NULL, '156', NULL, 'Cart', '17872201', '231', '326', 300, NULL, NULL, '300.00', NULL, 300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 06', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(568, '', NULL, '1', 200, '2022-11-22', NULL, NULL, NULL, '157', NULL, 'Cart', '54112201', '230', '325', 200, NULL, NULL, '200.00', NULL, 200.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 05', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(569, '', NULL, '1', 200, '2022-11-22', NULL, NULL, NULL, '158', NULL, 'Cart', '48062201', '230', '325', 200, NULL, NULL, '200.00', NULL, 200.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 05', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(570, '', NULL, '1', 200, '2022-11-22', NULL, NULL, NULL, '158', NULL, 'Cart', '49052201', '230', '325', 200, NULL, NULL, '200.00', NULL, 200.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 05', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(571, '', NULL, '1', 200, '2022-11-22', NULL, NULL, NULL, '161', NULL, 'Cart', '15382203', '230', '325', 200, NULL, NULL, '200.00', NULL, 200.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 05', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(572, '', NULL, '1', 0, '2022-11-22', NULL, NULL, NULL, '161', NULL, 'Cart', '60332203', '', '', 0, NULL, NULL, '', NULL, 0.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, '', NULL, NULL, NULL, ''),
(573, '', NULL, '1', 200, '2022-11-22', NULL, NULL, NULL, '162', NULL, 'Cart', '2022203', '230', '325', 200, NULL, NULL, '200.00', NULL, 200.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 05', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(574, '', NULL, '1', 110, '2022-11-22', NULL, NULL, NULL, '163', NULL, 'Cart', '47862203', '229', '324', 110, NULL, NULL, '110.00', NULL, 110.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 02', NULL, NULL, '0', NULL, NULL, NULL, '72');
INSERT INTO `order_master1` (`Order_id`, `Order_Main_Category`, `Order_Sub_category`, `Ordered_quantity`, `Order_Price`, `Order_on`, `Order_delivery_time`, `Order_delivery_date`, `Payment_Mode`, `Customer_id`, `Customer__address_type`, `Order_status`, `order_customer_track_id`, `Order_product`, `Product_priceid`, `Order_product_price`, `Referral_code`, `Refered_customer_id`, `Order_type_quantity`, `Delivery_status`, `Grand_total`, `Delivery_charge`, `Promo_code`, `Promo_code_status`, `Promo_code_offer_Percent`, `Discount_Offer_prce`, `Promocode_status`, `Paid_status`, `Wallet_Amount`, `wallet_status`, `Productname`, `Payment_Option`, `Shop_setting`, `Product_tax`, `Product_tax_amount`, `Product_total_tax_amount`, `product_plateform`, `product_type`) VALUES
(575, '', NULL, '1', 110, '2022-11-22', NULL, NULL, NULL, '164', NULL, 'Cart', '632203', '229', '324', 110, NULL, NULL, '110.00', NULL, 110.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 02', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(576, '', NULL, '1', 20, '2022-11-22', NULL, NULL, NULL, '166', NULL, 'Cart', '38982203', '227', '322', 20, NULL, NULL, '20.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(577, '', NULL, '1', 80, '2022-11-22', NULL, NULL, NULL, '167', NULL, 'Cart', '44812203', '228', '323', 80, NULL, NULL, '80.00', NULL, 80.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 01', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(578, '', NULL, '1', 20, '2022-11-22', NULL, NULL, NULL, '168', NULL, 'Cart', '5182204', '227', '322', 20, NULL, NULL, '20.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(579, '', NULL, '1', 20, '2022-11-22', NULL, NULL, NULL, '168', NULL, 'Cart', '59252204', '227', '322', 20, NULL, NULL, '20.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(580, '', NULL, '2', 160, '2022-11-22', NULL, NULL, NULL, '173', NULL, 'Cart', '1132207', '228', '323', 80, NULL, NULL, '80.00', NULL, 160.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 01', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(581, '', NULL, '1', 200, '2022-11-22', NULL, NULL, NULL, '175', NULL, 'Cart', '50712209', '230', '325', 200, NULL, NULL, '200.00', NULL, 200.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 05', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(582, '', NULL, '1', 80, '2022-11-22', NULL, NULL, NULL, '', NULL, 'Cart', '53422209', '228', '323', 80, NULL, NULL, '80.00', NULL, 80.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee 01', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(583, '', NULL, '1', 20, '2022-11-22', NULL, '0000-00-00', 'ONLINE_PAYMENT', '176', NULL, 'Completed', '16152209', '227', '322', 20, NULL, NULL, '20.00', 'On_Order', 30.00, 0, '', NULL, 0, 0, '1', '1', NULL, NULL, 'Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(584, '', NULL, '1', 20, '2022-11-22', NULL, NULL, NULL, '', NULL, 'Cart', '42162210', '227', '322', 20, NULL, NULL, '20.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(585, '', NULL, '2', 40, '2022-11-25', NULL, NULL, NULL, '', NULL, 'Cart', '12872508', '227', '322', 20, NULL, NULL, '20.00', NULL, 40.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(586, '', NULL, '2', 40, '2022-11-25', NULL, NULL, NULL, '177', NULL, 'Cart', '36192509', '227', '322', 20, NULL, NULL, '20.00', NULL, 40.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(587, '', NULL, '1', 20, '2022-11-25', NULL, NULL, NULL, '', NULL, 'Cart', '60302512', '227', '322', 20, NULL, NULL, '20.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(588, '', NULL, '1', 20, '2022-11-25', NULL, NULL, NULL, '', NULL, 'Cart', '27912512', '227', '322', 20, NULL, NULL, '20.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(589, '', NULL, '1', 20, '2022-11-25', NULL, '0000-00-00', 'ONLINE_PAYMENT', '178', NULL, 'Completed', '37912512', '227', '322', 20, NULL, NULL, '20.00', 'On_Dispatch', 70.00, 0, '', NULL, 0, 0, '1', '1', NULL, NULL, 'Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(590, '', NULL, '1', 1200, '2022-11-25', NULL, NULL, NULL, '', NULL, 'Cart', '52112505', '232', '327', 1200, NULL, NULL, '1200.00', NULL, 1200.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(591, '', NULL, '1', 1200, '2022-11-25', NULL, NULL, NULL, '', NULL, 'Cart', '63432506', '232', '327', 1200, NULL, NULL, '1200.00', NULL, 1200.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(592, '', NULL, '1', 650, '2022-11-25', NULL, NULL, NULL, '', NULL, 'Cart', '63742511', '233', '328', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(593, '', NULL, '2', 1300, '2022-11-29', NULL, NULL, NULL, '180', NULL, 'Cart', '30822911', '233', '328', 650, NULL, NULL, '650.00', NULL, 1300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(594, '', NULL, '2', 1300, '2022-11-29', NULL, NULL, NULL, '180', NULL, 'Cart', '51132911', '233', '328', 650, NULL, NULL, '650.00', NULL, 1300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(595, '', NULL, '2', 2400, '2022-11-30', NULL, NULL, NULL, '', NULL, 'Cart', '39753010', '232', '327', 1200, NULL, NULL, '1200.00', NULL, 2400.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(596, '', NULL, '1', 650, '2022-11-30', NULL, NULL, NULL, '', NULL, 'Cart', '56863010', '233', '328', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(597, '', NULL, '2', 1300, '2022-11-30', NULL, NULL, NULL, '181', NULL, 'Cart', '18703010', '233', '328', 650, NULL, NULL, '650.00', NULL, 1300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(598, '', NULL, '2', 1300, '2022-11-30', NULL, NULL, NULL, '182', NULL, 'Cart', '35513010', '233', '328', 650, NULL, NULL, '650.00', NULL, 1300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(599, '', NULL, '1', 1200, '2022-11-30', NULL, NULL, NULL, '182', NULL, 'Cart', '35513010', '232', '327', 1200, NULL, NULL, '1200.00', NULL, 1200.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(600, '', NULL, '1', 650, '2022-11-30', NULL, NULL, NULL, '', NULL, 'Cart', '28793010', '233', '328', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(601, '', NULL, '2', 1300, '2022-11-30', NULL, NULL, NULL, '182', NULL, 'Cart', '17713011', '233', '328', 650, NULL, NULL, '650.00', NULL, 1300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(602, '', NULL, '1', 1200, '2022-11-30', NULL, NULL, NULL, '182', NULL, 'Cart', '17713011', '232', '327', 1200, NULL, NULL, '1200.00', NULL, 1200.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(603, '', NULL, '2', 1300, '2022-11-30', NULL, NULL, NULL, '182', NULL, 'Cart', '14483011', '233', '328', 650, NULL, NULL, '650.00', NULL, 1300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(604, '', NULL, '1', 1200, '2022-11-30', NULL, NULL, NULL, '182', NULL, 'Cart', '14483011', '232', '327', 1200, NULL, NULL, '1200.00', NULL, 1200.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(605, '', NULL, '2', 20, '2022-11-30', NULL, NULL, NULL, '182', NULL, 'Cart', '12523011', '233', '328', 10, NULL, NULL, '10.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(606, '', NULL, '1', 10, '2022-11-30', NULL, NULL, NULL, '182', NULL, 'Cart', '40403011', '233', '328', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(607, '', NULL, '1', 10, '2022-11-30', NULL, NULL, NULL, '183', NULL, 'Cart', '27813011', '233', '328', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(608, '', NULL, '1', 10, '2022-11-30', NULL, NULL, NULL, '183', NULL, 'Cart', '15903011', '233', '328', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(609, '', NULL, '1', 10, '2022-11-30', NULL, '0000-00-00', 'ONLINE_PAYMENT', '183', NULL, 'Completed', '24393011', '233', '328', 10, NULL, NULL, '10.00', 'On_Progress', 29.00, 20, '', NULL, 10, 1, '1', '1', NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(610, '', NULL, '1', 10, '2022-11-30', NULL, NULL, NULL, '184', NULL, 'Cart', '27573012', '233', '328', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(611, '', NULL, '1', 10, '2022-11-30', NULL, '0000-00-00', 'ONLINE_PAYMENT', '184', NULL, 'Completed', '7643012', '233', '328', 10, NULL, NULL, '10.00', 'Canceled', 30.00, 20, '', NULL, 0, 0, '1', '1', NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(612, '', NULL, '1', 10, '2022-11-30', NULL, '0000-00-00', 'ONLINE_PAYMENT', '184', NULL, 'Completed', '64603001', '233', '328', 10, NULL, NULL, '10.00', 'Canceled', 29.00, 20, '', NULL, 10, 1, '1', '1', NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(613, '', NULL, '2', 20, '2022-11-30', NULL, NULL, NULL, '184', NULL, 'Cart', '60603001', '233', '328', 10, NULL, NULL, '10.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(614, '', NULL, '1', 10, '2022-11-30', NULL, NULL, NULL, '', NULL, 'Cart', '61133002', '233', '328', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(615, '', NULL, '1', 10, '2022-11-30', NULL, NULL, NULL, '', NULL, 'Cart', '21093002', '233', '328', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(616, '', NULL, '10', 100, '2022-11-30', NULL, '0000-00-00', 'ONLINE_PAYMENT', '185', NULL, 'Completed', '34763003', '233', '328', 10, NULL, NULL, '10.00', 'On_Order', 120.00, 20, '', NULL, 0, 0, '1', '1', NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(617, '', NULL, '10', 100, '2022-11-30', NULL, '0000-00-00', 'ONLINE_PAYMENT', '185', NULL, 'Completed', '60793003', '233', '328', 10, NULL, NULL, '10.00', 'On_Order', 120.00, 20, '', NULL, 0, 0, '1', '1', NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(618, '', NULL, '1', 10, '2022-11-30', NULL, NULL, NULL, '', NULL, 'Cart', '31673006', '233', '328', 10, NULL, NULL, '10.00', NULL, 10.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(619, '', NULL, '2', 20, '2022-11-30', NULL, NULL, NULL, '187', NULL, 'Cart', '14553007', '233', '328', 10, NULL, NULL, '10.00', NULL, 20.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(620, '', NULL, '3', 30, '2022-12-01', NULL, NULL, NULL, '', NULL, 'Cart', '16330108', '233', '328', 10, NULL, NULL, '10.00', NULL, 30.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(621, '', NULL, '3', 30, '2022-12-01', NULL, NULL, NULL, '', NULL, 'Cart', '24400109', '233', '328', 10, NULL, NULL, '10.00', NULL, 30.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(622, '', NULL, '1', 10, '2022-12-01', NULL, '0000-00-00', 'ONLINE_PAYMENT', '188', NULL, 'Completed', '39440102', '233', '328', 10, NULL, NULL, '10.00', 'On_Order', 30.00, 20, '', NULL, 0, 0, '1', '1', NULL, NULL, 'Testing 123', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(623, '', NULL, '1', 650, '2022-12-01', NULL, NULL, NULL, '', NULL, 'Cart', '41470108', '232', '327', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(624, '', NULL, '1', 650, '2022-12-02', NULL, NULL, NULL, '190', NULL, 'Cart', '21920202', '232', '327', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(625, '', NULL, '1', 650, '2022-12-02', NULL, NULL, NULL, '190', NULL, 'Cart', '35350202', '232', '327', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(626, '', NULL, '2', 1300, '2022-12-02', NULL, NULL, NULL, '190', NULL, 'Cart', '1240202', '232', '327', 650, NULL, NULL, '650.00', NULL, 1300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(627, '', NULL, '1', 650, '2022-12-02', NULL, NULL, NULL, '191', NULL, 'Cart', '9280202', '232', '327', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(628, '', NULL, '1', 650, '2022-12-03', NULL, NULL, NULL, '', NULL, 'Cart', '35290312', '232', '327', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(629, '', NULL, '1', 900, '2022-12-07', NULL, NULL, NULL, '', NULL, 'Cart', '13800703', '232', '328', 900, NULL, NULL, '900.00', NULL, 900.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(630, '', NULL, '1', 650, '2022-12-07', NULL, NULL, NULL, '', NULL, 'Cart', '13800703', '232', '327', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(631, '', NULL, '1', 900, '2022-12-07', NULL, NULL, NULL, '', NULL, 'Cart', '12160703', '232', '328', 900, NULL, NULL, '900.00', NULL, 900.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(632, '', NULL, '1', 650, '2022-12-07', NULL, NULL, NULL, '', NULL, 'Cart', '12160703', '232', '327', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(633, '', NULL, '1', 900, '2022-12-07', NULL, NULL, NULL, '', NULL, 'Cart', '55940703', '232', '328', 900, NULL, NULL, '900.00', NULL, 900.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(634, '', NULL, '1', 650, '2022-12-07', NULL, NULL, NULL, '', NULL, 'Cart', '55940703', '232', '327', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(635, '', NULL, '1', 650, '2022-12-07', NULL, NULL, NULL, '', NULL, 'Cart', '15530703', '232', '327', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(636, '', NULL, '2', 1300, '2022-12-07', NULL, NULL, NULL, '', NULL, 'Cart', '4000703', '232', '327', 650, NULL, NULL, '650.00', NULL, 1300.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(637, '', NULL, '2', 1800, '2022-12-07', NULL, NULL, NULL, '', NULL, 'Cart', '4000703', '232', '328', 900, NULL, NULL, '900.00', NULL, 1800.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(638, '', NULL, '1', 900, '2022-12-07', NULL, NULL, NULL, '194', NULL, 'Cart', '33110703', '232', '328', 900, NULL, NULL, '900.00', NULL, 900.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(639, '', NULL, '1', 650, '2022-12-07', NULL, NULL, NULL, '194', NULL, 'Cart', '33110703', '232', '327', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(640, '', NULL, '1', 650, '2022-12-07', NULL, NULL, NULL, '', NULL, 'Cart', '6800703', '232', '327', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(641, '', NULL, '1', 900, '2022-12-07', NULL, NULL, NULL, '', NULL, 'Cart', '360705', '232', '328', 900, NULL, NULL, '900.00', NULL, 900.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(642, '', NULL, '1', 650, '2022-12-07', NULL, NULL, NULL, '', NULL, 'Cart', '37450706', '232', '327', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(643, '', NULL, '1', 900, '2022-12-07', NULL, NULL, NULL, '195', NULL, 'Cart', '44470706', '232', '328', 900, NULL, NULL, '900.00', NULL, 900.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(644, '', NULL, '1', 900, '2022-12-07', NULL, NULL, NULL, '196', NULL, 'Cart', '55780706', '232', '328', 900, NULL, NULL, '900.00', NULL, 900.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(645, '', NULL, '1', 900, '2022-12-07', NULL, NULL, NULL, '196', NULL, 'Cart', '22040706', '232', '328', 900, NULL, NULL, '900.00', NULL, 900.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(646, '', NULL, '1', 900, '2022-12-07', NULL, NULL, NULL, '196', NULL, 'Cart', '22170706', '232', '328', 900, NULL, NULL, '900.00', NULL, 900.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(647, '', NULL, '1', 650, '2022-12-07', NULL, NULL, NULL, '198', NULL, 'Cart', '48360708', '232', '327', 650, NULL, NULL, '650.00', NULL, 650.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '0', NULL, NULL, NULL, '72'),
(648, '', NULL, '1', 900, '2022-12-07', NULL, NULL, NULL, '198', NULL, 'Cart', '48360708', '232', '328', 900, NULL, NULL, '900.00', NULL, 900.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(649, '', NULL, '1', 900, '2022-12-09', NULL, NULL, NULL, '', NULL, 'Cart', '15990910', '232', '328', 900, NULL, NULL, '900.00', NULL, 900.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(650, '', NULL, '3', 2700, '2022-12-09', NULL, NULL, NULL, '', NULL, 'Cart', '18740911', '232', '328', 900, NULL, NULL, '900.00', NULL, 2700.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(651, '', NULL, '1', 900, '2022-12-09', NULL, NULL, NULL, '', NULL, 'Cart', '39050903', '232', '328', 900, NULL, NULL, '900.00', NULL, 900.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72'),
(652, '', NULL, '1', 900, '2022-12-12', NULL, NULL, NULL, '', NULL, 'Cart', '17001312', '232', '328', 900, NULL, NULL, '900.00', NULL, 900.00, 0, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'Premium Cow Ghee', NULL, NULL, '18', NULL, NULL, NULL, '72');

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

--
-- Table structure for table `package_master`
--

CREATE TABLE `package_master` (
  `pack_id` int(11) NOT NULL,
  `pack_name` varchar(400) NOT NULL,
  `pack_duration` int(11) NOT NULL,
  `pack_cost` int(11) NOT NULL,
  `pack_commission` int(11) NOT NULL,
  `pack_sub_cate` int(11) NOT NULL,
  `pack_status` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `package_master`
--

INSERT INTO `package_master` (`pack_id`, `pack_name`, `pack_duration`, `pack_cost`, `pack_commission`, `pack_sub_cate`, `pack_status`) VALUES
(1, 'Trail pack ', 30, 100, 12, 122, 0),
(3, 'Testing  Pack', 30, 1200, 10, 130, 1),
(4, 'Trail pack ', 30, 100, 6, 132, 1),
(6, 'Carrom MAtch', 30, 250, 10, 131, 1);

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

--
-- Table structure for table `payment_request`
--

CREATE TABLE `payment_request` (
  `pay_id` int(11) NOT NULL,
  `pay_vendor_id` int(11) NOT NULL,
  `pay_event_id` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `wallet` int(11) NOT NULL,
  `payment_date` datetime NOT NULL,
  `pay_status` tinyint(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_request`
--

INSERT INTO `payment_request` (`pay_id`, `pay_vendor_id`, `pay_event_id`, `amount`, `wallet`, `payment_date`, `pay_status`) VALUES
(1, 34, 2, 1200, 100, '2023-01-03 08:56:43', 2),
(2, 34, 3, 250, 1150, '2023-01-03 09:25:43', 2),
(3, 34, 4, 100, 1050, '2023-01-03 09:28:21', 2);

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

--
-- Table structure for table `payment_setting`
--

CREATE TABLE `payment_setting` (
  `Payment_id` int(11) NOT NULL,
  `Payment_Mode` varchar(255) DEFAULT NULL,
  `Payment_status` tinyint(4) DEFAULT NULL,
  `Gateway_name` varchar(255) DEFAULT NULL,
  `Payment_Option` varchar(255) DEFAULT NULL,
  `Payment__id` varbinary(1000) DEFAULT NULL,
  `Payment_Key` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `payment_setting`
--

INSERT INTO `payment_setting` (`Payment_id`, `Payment_Mode`, `Payment_status`, `Gateway_name`, `Payment_Option`, `Payment__id`, `Payment_Key`) VALUES
(1, 'ONLINE_PAY', 1, 'Razorpay', 'ONLINE_PAY', 0x727a705f6c6976655f4d524a674f6b5876785942795a53, 'SGcKxBViRVBodNTHJW5khRcF'),
(2, 'COD', 0, 'Cash On Delivery', 'COD', '', ''),
(3, 'ONLINE_PAY', 0, 'Instamojo', 'Payment_Option2', 0x3364316365343035663035363835363739666461326231646361333935626561, '79da2bff2ad282f3deadbda5421111fe');

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

--
-- Table structure for table `payout_request`
--

CREATE TABLE `payout_request` (
  `payout_request_id` int(11) NOT NULL,
  `payout_customer_id` varchar(255) DEFAULT NULL,
  `payout_customer_name` varchar(255) DEFAULT NULL,
  `payout_setting` varchar(255) DEFAULT NULL,
  `payout_bank_name` varchar(255) DEFAULT NULL,
  `payout_bank_holder_name` varchar(255) DEFAULT NULL,
  `payout_bank_account_no` varchar(255) DEFAULT NULL,
  `payout_bank_ifsc_code` varchar(255) DEFAULT NULL,
  `pauout_upi_setting` varchar(255) DEFAULT NULL,
  `payout_upi_holder_name` varchar(255) DEFAULT NULL,
  `payout_upi_id` varchar(255) DEFAULT NULL,
  `payout_status` varchar(255) DEFAULT NULL,
  `payout_attachment` varchar(1000) DEFAULT NULL,
  `payout_request_on` date DEFAULT NULL,
  `payout_customer_mobile` varchar(255) DEFAULT NULL,
  `payout_customer_email` varchar(255) DEFAULT NULL,
  `payout_request_amount` varchar(255) DEFAULT NULL,
  `Payout_on` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `payout_setting`
--

CREATE TABLE `payout_setting` (
  `payout_id` int(11) NOT NULL,
  `payout_set` varchar(255) DEFAULT NULL,
  `Payout_setting` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `payout_setting`
--

INSERT INTO `payout_setting` (`payout_id`, `payout_set`, `Payout_setting`) VALUES
(1, '10', 1);

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

--
-- Table structure for table `plateform_master`
--

CREATE TABLE `plateform_master` (
  `plateform_id` int(11) NOT NULL,
  `plateform_name` varchar(255) DEFAULT NULL,
  `plateform_status` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `plateform_master`
--

INSERT INTO `plateform_master` (`plateform_id`, `plateform_name`, `plateform_status`) VALUES
(4, 'straight', '1'),
(5, 'Wavy', '1');

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

--
-- Table structure for table `product_banner`
--

CREATE TABLE `product_banner` (
  `prod_id` int(11) NOT NULL,
  `prod_video` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `product_game_age_rating`
--

CREATE TABLE `product_game_age_rating` (
  `age_rating_id` int(11) NOT NULL,
  `product_id` varchar(255) DEFAULT NULL,
  `game_rating` varchar(255) DEFAULT NULL,
  `game_rating_status` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `product_game_age_rating`
--

INSERT INTO `product_game_age_rating` (`age_rating_id`, `product_id`, `game_rating`, `game_rating_status`) VALUES
(10, '0', '18+', 1),
(34, '', '12+', 1),
(35, '', '18+', 1),
(76, '89', '12+', 1),
(77, '89', '18+', 1),
(78, '89', '16+', 1),
(79, '90', '12+', 1),
(80, '90', '18+', 1),
(81, '90', '16+', 1),
(82, '91', '12+', 1),
(83, '91', '18+', 1),
(84, '91', '16+', 1),
(88, '93', '12+', 1),
(89, '93', '18+', 1),
(90, '93', '16+', 1),
(103, '0', '12+', 1),
(104, '0', '18+', 1),
(105, '0', '16+', 1),
(106, '0', '12+', 1),
(107, '0', '18+', 1),
(108, '0', '16+', 1),
(109, '0', '12+', 1),
(110, '0', '18+', 1),
(111, '0', '16+', 1),
(112, '0', '12+', 1),
(113, '0', '18+', 1),
(114, '0', '16+', 1),
(120, '0', '12+', 1),
(121, '0', '18+', 1),
(122, '0', '16+', 1),
(135, '0', '12+', 1),
(136, '0', '18+', 1),
(137, '0', '16+', 1),
(138, '0', '12+', 1),
(139, '0', '18+', 1),
(140, '0', '16+', 1),
(141, '0', '12+', 1),
(142, '0', '18+', 1),
(143, '0', '16+', 1),
(144, '0', '12+', 1),
(145, '0', '18+', 1),
(146, '0', '16+', 1),
(149, '0', '12+', 1),
(150, '0', '18+', 1),
(151, '0', '16+', 1),
(152, '0', '12+', 1),
(153, '0', '18+', 1),
(154, '0', '16+', 1),
(158, '0', '12+', 1),
(159, '0', '18+', 1),
(160, '0', '16+', 1),
(189, '121', '12+', 1),
(190, '121', '18+', 1),
(191, '121', '16+', 1);

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

--
-- Table structure for table `product_game_sub_cate`
--

CREATE TABLE `product_game_sub_cate` (
  `sub_cate_id` int(11) NOT NULL,
  `product_id` varchar(255) DEFAULT NULL,
  `subcate_Name` varchar(255) DEFAULT NULL,
  `sub_cate_status` tinyint(4) DEFAULT NULL,
  `sub_main_cate` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `product_game_sub_cate`
--

INSERT INTO `product_game_sub_cate` (`sub_cate_id`, `product_id`, `subcate_Name`, `sub_cate_status`, `sub_main_cate`) VALUES
(123, '124', NULL, NULL, '69'),
(124, '124', NULL, NULL, '70'),
(125, '125', NULL, NULL, '65'),
(126, '125', NULL, NULL, '66'),
(127, '126', NULL, NULL, '69'),
(128, '126', NULL, NULL, '70'),
(129, '127', NULL, NULL, '71'),
(130, '128', NULL, NULL, '72'),
(131, '129', NULL, NULL, '71');

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

--
-- Table structure for table `product_image_master`
--

CREATE TABLE `product_image_master` (
  `product_image_id` int(11) NOT NULL,
  `Product_image` varchar(1000) DEFAULT NULL,
  `Product_id` int(11) DEFAULT NULL,
  `Product_image_status` tinyint(4) DEFAULT NULL,
  `Shop_setting` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `product_image_master`
--

INSERT INTO `product_image_master` (`product_image_id`, `Product_image`, `Product_id`, `Product_image_status`, `Shop_setting`) VALUES
(274, '22ct-gold-handmade-goddess-lakshmi-gaja-lakshmi-tanjore-painting.jpg', 123, 1, NULL),
(275, 'tanjore-painting-lakshmi.jpg', 123, 1, NULL),
(276, '22ct-gold-handmade-goddess-lakshmi-gaja-lakshmi-tanjore-painting.jpg', 124, 1, NULL),
(277, 'tanjore-painting-gaja-lakshmi.jpg', 124, 1, NULL),
(278, '22ct-gold-handmade-goddess-lakshmi-gaja-lakshmi-tanjore-painting.jpg', 125, 1, NULL),
(279, 'tanjore-painting-lakshmi.jpg', 125, 1, NULL),
(281, 'tanjore-painting-gaja-lakshmi.jpg', 125, 1, NULL),
(282, 'tanjore-painting-gaja-lakshmi.jpg', 125, 1, NULL),
(283, 'tanjore-painting-gaja-lakshmi.jpg', 125, 1, NULL),
(284, 'tanjore-painting-gaja-lakshmi.jpg', 125, 1, NULL),
(285, '22ct-gold-handmade-goddess-lakshmi-gaja-lakshmi-tanjore-painting.jpg', 126, 1, NULL),
(286, 'tanjore-painting-lakshmi.jpg', 126, 1, NULL),
(287, 'photo-1605721911519-3dfeb3be25e7.jpg', 127, 1, NULL),
(288, 'hp-toptile1-hybrid-03282022-large.jpg', 127, 1, NULL),
(289, 'photo-1605721911519-3dfeb3be25e7.jpg', 128, 1, NULL),
(290, 'hp-toptile1-hybrid-03282022-large.jpg', 128, 1, NULL),
(291, 'photo-1605721911519-3dfeb3be25e7.jpg', 129, 1, NULL),
(292, 'hp-toptile1-hybrid-03282022-large.jpg', 129, 1, NULL),
(301, '', 134, 1, NULL),
(302, '', 137, 1, NULL),
(303, '', 138, 1, NULL),
(304, '', 139, 1, NULL),
(305, '', 140, 1, NULL),
(306, '', 142, 1, NULL),
(307, '', 143, 1, NULL),
(317, '', 153, 1, NULL),
(319, '', 155, 1, NULL),
(320, '', 156, 1, NULL),
(321, '', 157, 1, NULL),
(322, '', 158, 1, NULL),
(323, '', 159, 1, NULL),
(324, '', 160, 1, NULL),
(325, '', 161, 1, NULL),
(326, '', 162, 1, NULL),
(327, '', 163, 1, NULL),
(328, '', 164, 1, NULL),
(329, '', 165, 1, NULL),
(330, '', 166, 1, NULL),
(331, '', 167, 1, NULL),
(332, '', 168, 1, NULL),
(333, '', 169, 1, NULL),
(334, '', 170, 1, NULL),
(335, '', 171, 1, NULL),
(336, '', 172, 1, NULL),
(337, '', 173, 1, NULL),
(338, '', 174, 1, NULL),
(339, '', 175, 1, NULL),
(340, '', 176, 1, NULL),
(341, '', 177, 1, NULL),
(396, '', 232, 1, NULL);

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

--
-- Table structure for table `product_master`
--

CREATE TABLE `product_master` (
  `Product_id` int(255) NOT NULL,
  `Main_Category` varchar(255) DEFAULT NULL,
  `sub_cate` varchar(12) NOT NULL,
  `Product_offer` tinyint(4) DEFAULT NULL,
  `Product_Active_Status` tinyint(4) DEFAULT NULL,
  `Product_image` varchar(1000) DEFAULT NULL,
  `Product_add_on` date DEFAULT NULL,
  `Product_Name` varchar(255) DEFAULT NULL,
  `Product_description` longtext,
  `Shop_setting` varchar(255) DEFAULT NULL,
  `product_tax` decimal(10,0) DEFAULT NULL,
  `product_brand` varchar(255) DEFAULT NULL,
  `product_display_cate` varchar(255) DEFAULT NULL,
  `product_display` varchar(255) DEFAULT NULL,
  `product_video_link` varchar(255) DEFAULT NULL,
  `product_publisher` varchar(255) DEFAULT NULL,
  `product_developer` varchar(255) DEFAULT NULL,
  `Releasing_on` varchar(255) DEFAULT NULL,
  `refundpolicy` varchar(120) NOT NULL,
  `product_ttype` varchar(13) NOT NULL,
  `pro_list` int(13) NOT NULL,
  `pro_list2` int(13) NOT NULL,
  `delivry` int(13) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `product_master`
--

INSERT INTO `product_master` (`Product_id`, `Main_Category`, `sub_cate`, `Product_offer`, `Product_Active_Status`, `Product_image`, `Product_add_on`, `Product_Name`, `Product_description`, `Shop_setting`, `product_tax`, `product_brand`, `product_display_cate`, `product_display`, `product_video_link`, `product_publisher`, `product_developer`, `Releasing_on`, `refundpolicy`, `product_ttype`, `pro_list`, `pro_list2`, `delivry`) VALUES
(232, '72', '118', 0, 1, 'gree.jpg', '2022-11-25', 'Premium Cow Ghee', '  <div><p class=\"MsoNormal\" style=\"margin-bottom: 7.65pt; text-align: justify; line-height: normal; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\"><span style=\"font-size:\r\n14.0pt;mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-font-family:Calibri;\r\nmso-bidi-theme-font:minor-latin\">Virukshalaya Ghee is made from the milk of\r\ncows grazing on farmlands of villages adjoining Western Ghats of Theni and\r\nDindigul Districts of Tamilnadu. These free range cows are not exposed to\r\nharmful chemical, pesticides, artificial hormones. <o:p></o:p></span></p>\r\n\r\n<p class=\"MsoNormal\" style=\"margin-bottom: 7.65pt; text-align: justify; line-height: normal; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\"><span style=\"font-size:\r\n14.0pt;mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-font-family:Calibri;\r\nmso-bidi-theme-font:minor-latin\">Virukshalaya Ghee contains </span><span style=\"font-size:14.0pt;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin\">a\r\nrich source of essential fatty acids such as omega-3 and Contains healthy fat\r\nsoluble vitamins which&nbsp;aids&nbsp;in the absorption of nutrients in foods\r\nand are essential for good health</span><span style=\"font-size:14.0pt;\r\nmso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-font-family:Calibri;\r\nmso-bidi-theme-font:minor-latin\"> <o:p></o:p></span></p>\r\n\r\n<p class=\"MsoNormal\" style=\"margin-bottom: 7.65pt; text-align: justify; line-height: normal; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\"><span style=\"font-size:\r\n14.0pt;mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-font-family:Calibri;\r\nmso-bidi-theme-font:minor-latin\">Virukshalaya Ghee takes pride in bringing to\r\nyour homes the traditional aromatic ghee with the promise of divine purity and\r\nquality.<o:p></o:p></span></p>\r\n\r\n<p class=\"MsoNormal\" style=\"margin-bottom: 7.65pt; text-align: justify; line-height: normal; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\"><span style=\"font-size:\r\n14.0pt;mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-font-family:Calibri;\r\nmso-bidi-theme-font:minor-latin\">Research shows ghee improves immunity, aids\r\ndigestion and has incredible healing properties according to Ayurveda. It also\r\ncontains saturated fats which is good for heart health on ideal consumption of\r\n2-3 tablespoons of ghee everyday in diet for optimum benefits.<o:p></o:p></span></p>\r\n\r\n<p class=\"MsoNormal\" style=\"margin-bottom: 7.65pt; text-align: justify; line-height: normal; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\"><span style=\"font-size:\r\n14.0pt;mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-font-family:Calibri;\r\nmso-bidi-theme-font:minor-latin\">&nbsp;</span></p>\r\n\r\n<p class=\"MsoNormal\" style=\"margin-bottom: 7.65pt; text-align: justify; line-height: normal; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;\"><span style=\"font-size:\r\n14.0pt;mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-font-family:Calibri;\r\nmso-bidi-theme-font:minor-latin\">Wishing You Good Health and Happiness<o:p></o:p></span></p></div>     \r\n     \r\n', NULL, 0, '', 'Console', 'New', '', 'Premium Cow Ghee', '', '2022-11-25', 'Non Refund', '', 1, 0, 0);

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

--
-- Table structure for table `product_plateform`
--

CREATE TABLE `product_plateform` (
  `plateform_id` int(11) NOT NULL,
  `product_id` varchar(255) DEFAULT NULL,
  `plateform` varchar(255) DEFAULT NULL,
  `plateform_status` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `product_plateform`
--

INSERT INTO `product_plateform` (`plateform_id`, `product_id`, `plateform`, `plateform_status`) VALUES
(11, '0', 'Standard Edition', 1),
(34, '', 'Standard Edition', 1),
(35, '', 'Ultimate Edition', 1),
(36, '', 'Standard Edition', 1),
(77, '89', 'STANDARD', 1),
(78, '93', 'SLIM', 1),
(80, '0', 'STANDARD', 1),
(81, '0', 'STANDARD', 1),
(82, '0', 'STANDARD', 1),
(83, '0', 'STANDARD', 1),
(84, '0', 'STANDARD', 1),
(87, '0', 'STANDARD', 1),
(88, '0', 'STANDARD', 1),
(90, '0', 'STANDARD', 1),
(98, '121', 'STANDARD', 1);

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

--
-- Stand-in structure for view `product_price`
-- (See below for the actual view)
--
CREATE TABLE `product_price` (
`Product_price_id` int(11)
,`Product_id` int(11)
,`Product_type` varchar(255)
,`Product_price` float(10,2)
,`Product_offer_price` float(10,2)
,`Product_status` tinyint(4)
,`Product_Type_number` int(11)
,`Product_price_Add_on` date
,`pr_quantity` varchar(255)
,`Protuct_price_type` varchar(278)
,`Shelling_price` float(10,2)
,`Offer_Percent` float(10,2)
);

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

--
-- Table structure for table `product_price_master`
--

CREATE TABLE `product_price_master` (
  `Product_price_id` int(11) NOT NULL,
  `Product_id` int(11) DEFAULT NULL,
  `P_image` varchar(120) NOT NULL,
  `p_weight` varchar(120) NOT NULL,
  `p_texture` varchar(120) NOT NULL,
  `Product_type` varchar(255) DEFAULT NULL,
  `Product_price` float(10,2) DEFAULT NULL,
  `Product_offer_price` float(10,2) DEFAULT NULL,
  `Product_status` tinyint(4) DEFAULT NULL,
  `Product_Type_number` int(11) DEFAULT NULL,
  `Product_price_Add_on` date DEFAULT NULL,
  `Shelling_price` float(10,2) DEFAULT NULL,
  `Offer_Percent` float(10,2) DEFAULT NULL,
  `Shop_setting` varchar(255) DEFAULT NULL,
  `product_stock` int(255) DEFAULT NULL,
  `product_tax` varchar(255) DEFAULT NULL,
  `Product_length` varchar(120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `product_price_master`
--

INSERT INTO `product_price_master` (`Product_price_id`, `Product_id`, `P_image`, `p_weight`, `p_texture`, `Product_type`, `Product_price`, `Product_offer_price`, `Product_status`, `Product_Type_number`, `Product_price_Add_on`, `Shelling_price`, `Offer_Percent`, `Shop_setting`, `product_stock`, `product_tax`, `Product_length`) VALUES
(327, 232, 'gree.jpg', '24', '4', '72', 650.00, NULL, 1, NULL, '2022-11-25', 650.00, 0.00, NULL, 100, '0', '14'),
(328, 232, 'gree.jpg', '25', '4', '72', 1300.00, NULL, 1, NULL, '0000-00-00', 950.00, 26.92, NULL, 100, '18', '14');

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

--
-- Table structure for table `product_type`
--

CREATE TABLE `product_type` (
  `Product_Type_id` int(11) NOT NULL,
  `Product_type` varchar(255) DEFAULT NULL,
  `Product_type_status` tinyint(4) DEFAULT NULL,
  `Product_type_Addon` date DEFAULT NULL,
  `Shop_setting` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `product_type`
--

INSERT INTO `product_type` (`Product_Type_id`, `Product_type`, `Product_type_status`, `Product_type_Addon`, `Shop_setting`) VALUES
(10, 'STANDARD', 1, '2021-11-09', NULL),
(11, 'SLIM', 1, '2021-11-09', NULL),
(12, 'PRO', 1, '2021-11-09', NULL),
(13, 'DIGITAL', 1, '2021-11-09', NULL),
(14, 'PREMIUM EDITION', 1, '2022-02-21', NULL);

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

--
-- Table structure for table `promo_code_master`
--

CREATE TABLE `promo_code_master` (
  `Promo_id` int(11) NOT NULL,
  `Promo_code` varchar(255) DEFAULT NULL,
  `Offer_Percent` float(4,0) DEFAULT NULL,
  `Offer_Main_Category` varchar(255) DEFAULT NULL,
  `Offer_sub_category` varchar(255) DEFAULT NULL,
  `Promo_code_valid_upto` date DEFAULT NULL,
  `Offer_Highlights` varchar(255) DEFAULT NULL,
  `Terms_and_Conditions` text,
  `Offer_Poster` varchar(255) DEFAULT NULL,
  `Promo_code_Active_Status` tinyint(4) DEFAULT NULL,
  `Bg_color` varchar(255) DEFAULT NULL,
  `Product_id` int(11) DEFAULT NULL,
  `off_cate` varchar(12) NOT NULL,
  `Promo_code_addon` date DEFAULT NULL,
  `is_ch` int(12) NOT NULL,
  `cate` int(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `promo_code_master`
--

INSERT INTO `promo_code_master` (`Promo_id`, `Promo_code`, `Offer_Percent`, `Offer_Main_Category`, `Offer_sub_category`, `Promo_code_valid_upto`, `Offer_Highlights`, `Terms_and_Conditions`, `Offer_Poster`, `Promo_code_Active_Status`, `Bg_color`, `Product_id`, `off_cate`, `Promo_code_addon`, `is_ch`, `cate`) VALUES
(8, 'SHOPBEE34OSHOPBEE34O5', 50, '0', '0', '2022-12-30', ' dfs f', ' afds', '', 1, 'bg-success', 0, '', '2022-10-11', 1, 118),
(9, 'Virukshalaya2022', 10, '72', '106', '2022-12-31', ' Virukshalaya2022', ' Virukshalaya2022', '', 1, 'bg-success', 233, '', '2022-11-22', 0, 0);

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

--
-- Table structure for table `ps_master`
--

CREATE TABLE `ps_master` (
  `ps_id` int(11) NOT NULL,
  `ps_banner` varchar(255) DEFAULT NULL,
  `ps_video_link` longtext,
  `ps_type` varchar(255) DEFAULT NULL,
  `ps_status` tinyint(4) DEFAULT NULL,
  `ps_banner_status` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `ps_master`
--

INSERT INTO `ps_master` (`ps_id`, `ps_banner`, `ps_video_link`, `ps_type`, `ps_status`, `ps_banner_status`) VALUES
(3, 'Ad in MT.jpeg', 'z7eCngU68lo', '', 0, 0);

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

--
-- Table structure for table `quality_master`
--

CREATE TABLE `quality_master` (
  `quality_id` int(11) NOT NULL,
  `quality_title` varchar(400) NOT NULL,
  `quality_img` varchar(200) NOT NULL,
  `quality_status` tinyint(4) NOT NULL,
  `quality_desc` longblob
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `quality_master`
--

INSERT INTO `quality_master` (`quality_id`, `quality_title`, `quality_img`, `quality_status`, `quality_desc`) VALUES
(3, '', 'Logo.jpeg', 0, 0x3c7020636c6173733d224d736f4e6f726d616c22207374796c653d22746578742d616c69676e3a6a7573746966793b746578742d6a7573746966793a696e7465722d6964656f6772617068223e3c7370616e206c616e673d22454e2d474222207374796c653d22666f6e742d73697a653a31342e3070743b6d736f2d626964692d666f6e742d73697a653a31312e3070743b6c696e652d6865696768743a313135253b0d0a6d736f2d616e73692d6c616e67756167653a454e2d4742223e4174203c623e48696d6164687269204461697279203c2f623e50726f64756374732050726976617465204c696d697465642c20776520706c6163650d0a696d6d656e736520656d706861736973206f6e207175616c697479206f66207468652070726f647563742e20576520756e64657274616b6520737472696e67656e74207175616c6974790d0a636f6e74726f6c207465737473206174206576657279207374616765206f662070726f64756374696f6e2e2054686520726177206d6174657269616c20697320636865636b656420666f720d0a7175616c697479206265666f72652070726f64756374696f6e2e20546f20656e73757265207a65726f2073706f696c616765206f662074686520726177206d6174657269616c732c2069742069730d0a73746f72656420756e64657220617070726f7072696174652074656d706572617475726520636f6e646974696f6e2e204f757220666163746f7279207072656d697365732061726520636c65616e0d0a616e64206172652064657369676e65642061732070657220746865206e6f726d732e205468652066696e616c2070726f6365737365642070726f647563742069732074657374656420696e206f75720d0a6c61626f7261746f7279206f6e20766172696f757320706172616d65746572732e204f75722070726f647563747320617265207061636b6564207374726963746c79207573696e672041726f6d6120526574656e74696f6e0d0a666f6f6420677261646520676c617373206a617273206f66203530306d6c2e2054687573206f75722070726f63657373696e6720616e64207061636b6167696e67206f66207468650d0a70726f64756374732069732063617272696564206f757420696e20612073616665206d616e6e65722077697468206164686572656e636520746f20696e647573747269616c206e6f726d7320616e640d0a7072616374696365732e3c6f3a703e3c2f6f3a703e3c2f7370616e3e3c2f703e);

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

--
-- Table structure for table `referal_master`
--

CREATE TABLE `referal_master` (
  `Referal_id` int(11) NOT NULL,
  `Referal_Code` varchar(255) DEFAULT NULL,
  `Referal_Product` varchar(255) DEFAULT NULL,
  `Referal_Price_Percentage` varchar(255) DEFAULT NULL,
  `Refered_customer_earn_commission` float(4,0) DEFAULT NULL,
  `Referal_active_status` tinyint(4) DEFAULT NULL,
  `Referal_valid_upto` date DEFAULT NULL,
  `Referal_Terms_and_condition` longtext,
  `Referal_code_addon` date DEFAULT NULL,
  `Referal_Main_Category` varchar(255) DEFAULT NULL,
  `Referal_sub_category` varchar(255) DEFAULT NULL,
  `Referal_bg_color` varchar(255) DEFAULT NULL,
  `Shop_setting` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `referal_master`
--

INSERT INTO `referal_master` (`Referal_id`, `Referal_Code`, `Referal_Product`, `Referal_Price_Percentage`, `Refered_customer_earn_commission`, `Referal_active_status`, `Referal_valid_upto`, `Referal_Terms_and_condition`, `Referal_code_addon`, `Referal_Main_Category`, `Referal_sub_category`, `Referal_bg_color`, `Shop_setting`) VALUES
(3, 'LEECAR21', '3', '30', NULL, 1, '2021-07-30', ' ', '2021-07-14', '15', '22', 'bg-success', NULL);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `footer_text` varchar(255) NOT NULL,
  `footer_text1` varchar(255) NOT NULL,
  `footer_text2` varchar(255) NOT NULL,
  `footer_link` varchar(255) NOT NULL,
  `domain_name` varchar(255) NOT NULL,
  `base_url` varchar(255) NOT NULL,
  `site_url` varchar(255) NOT NULL,
  `main_url` varchar(255) NOT NULL,
  `admin_url` varchar(255) NOT NULL,
  `form_email_id` varchar(255) NOT NULL,
  `to_email_id` varchar(255) NOT NULL,
  `contact_email` varchar(255) NOT NULL,
  `contact_phone` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `pincode` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `facebook` varchar(255) NOT NULL,
  `google` varchar(255) NOT NULL,
  `twitter` varchar(255) NOT NULL,
  `youtube` varchar(255) NOT NULL,
  `linkedin` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `favicon` varchar(255) NOT NULL,
  `paypalmail` varchar(255) NOT NULL,
  `currency` varchar(255) NOT NULL,
  `shipping` varchar(255) NOT NULL,
  `free_shipping` varchar(255) NOT NULL,
  `update` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `title`, `footer_text`, `footer_text1`, `footer_text2`, `footer_link`, `domain_name`, `base_url`, `site_url`, `main_url`, `admin_url`, `form_email_id`, `to_email_id`, `contact_email`, `contact_phone`, `address`, `address1`, `address2`, `city`, `state`, `pincode`, `country`, `facebook`, `google`, `twitter`, `youtube`, `linkedin`, `logo`, `favicon`, `paypalmail`, `currency`, `shipping`, `free_shipping`, `update`) VALUES
(1, 'SHOPBEE', 'Copyright 2019 SHOPBEE', 'Designed and Developed by', 'YESGLE SOLUTIONS', 'https://shopbee.in/', 'https://shopbee.in/', 'https://shopbee.in/', 'https://shopbee.in/', 'https://shopbee.in/', 'https://shopbee.in/', 'info@shopbee.in', 'yesgleinfo@gmail.com', 'yesgleinfo@gmail.com', '+919962516035', 'SHOPBEE', '', '', 'Chennai ', 'Tamil nadu', '600 001', 'India', 'https://www.facebook.com/', 'https://plus.google.com/', 'https://twitter.com/', '', 'https://www.linkedin.com/', 'logo2.png', 'favicon.ico', 'senthil@cwd.co.in', 'Rs.', '50', '100000', '2016-05-11 09:27:25');

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

--
-- Table structure for table `shop_setting`
--

CREATE TABLE `shop_setting` (
  `shop_id` int(11) NOT NULL,
  `Shop__setting` varchar(255) DEFAULT NULL,
  `Shop_setting_status` tinyint(4) DEFAULT NULL,
  `order_list` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `shop_setting`
--

INSERT INTO `shop_setting` (`shop_id`, `Shop__setting`, `Shop_setting_status`, `order_list`) VALUES
(4, 'Paintings', 1, '3'),
(18, 'Tanjore Painting', 0, '2');

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

--
-- Table structure for table `slider_master`
--

CREATE TABLE `slider_master` (
  `slider_id` int(11) NOT NULL,
  `Slider_contecnt` varchar(500) DEFAULT NULL,
  `slider_title` varchar(120) NOT NULL,
  `Slider_btn` varchar(120) NOT NULL,
  `slider_image` varchar(500) DEFAULT NULL,
  `Slider_order` int(11) DEFAULT NULL,
  `slider_status` tinyint(4) DEFAULT NULL,
  `Slider_Product` varchar(255) DEFAULT NULL,
  `Slider_link` varchar(120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `slider_master`
--

INSERT INTO `slider_master` (`slider_id`, `Slider_contecnt`, `slider_title`, `Slider_btn`, `slider_image`, `Slider_order`, `slider_status`, `Slider_Product`, `Slider_link`) VALUES
(1, NULL, 'Experience ', '#', '1672693213.jpg', 1, 1, '232', ''),
(2, NULL, 'Experience ', '#', '1672693222.jpg', 2, 1, '232', ''),
(3, NULL, 'Experience ', '#', '1672693230.jpg', 3, 1, '232', '');

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

--
-- Table structure for table `social_media_master`
--

CREATE TABLE `social_media_master` (
  `sm_id` int(11) NOT NULL,
  `sm_facebook_link` varchar(400) NOT NULL,
  `sm_instagram_link` varchar(400) NOT NULL,
  `sm_youtube_link` varchar(400) NOT NULL,
  `sm_whatsapp` varchar(400) NOT NULL,
  `sm_status` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `social_media_master`
--

INSERT INTO `social_media_master` (`sm_id`, `sm_facebook_link`, `sm_instagram_link`, `sm_youtube_link`, `sm_whatsapp`, `sm_status`) VALUES
(1, 'www.facebook.com', 'www.instagram.com', 'www.youtube.com', '132471241', 1);

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

--
-- Table structure for table `sub_category`
--

CREATE TABLE `sub_category` (
  `Sub_Category_id` int(11) NOT NULL,
  `Sub_Category_Name` varchar(255) DEFAULT NULL,
  `Sub_Category_Status` tinyint(4) DEFAULT NULL,
  `Sub_Category_Add_on` date DEFAULT NULL,
  `Sub_Category_image` varchar(255) DEFAULT NULL,
  `Main_Category_sub` int(11) DEFAULT NULL,
  `Shop_setting` varchar(255) DEFAULT NULL,
  `Add_sub_cate_icon` varchar(120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `sub_category`
--

INSERT INTO `sub_category` (`Sub_Category_id`, `Sub_Category_Name`, `Sub_Category_Status`, `Sub_Category_Add_on`, `Sub_Category_image`, `Main_Category_sub`, `Shop_setting`, `Add_sub_cate_icon`) VALUES
(130, 'CHESS', 1, '2023-01-03', NULL, 74, NULL, ''),
(131, 'CARROM', 1, '2023-01-03', NULL, 74, NULL, ''),
(132, 'CRICKET', 1, '2023-01-03', NULL, 80, NULL, ''),
(133, 'JOBS', 1, '2023-01-03', NULL, 81, NULL, ''),
(134, 'PROPERTY', 1, '2023-01-03', NULL, 81, NULL, ''),
(135, 'DYNAMIC WEBSITE', 1, '2023-01-03', NULL, 82, NULL, ''),
(136, 'TELECALLER MANAGEMENT', 1, '2023-01-03', NULL, 82, NULL, ''),
(137, 'POS BILLING', 1, '2023-01-03', NULL, 82, NULL, ''),
(138, 'ONINE SHOPPING', 1, '2023-01-03', NULL, 82, NULL, '');

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

--
-- Table structure for table `tax_master`
--

CREATE TABLE `tax_master` (
  `id` int(11) NOT NULL,
  `Tax` varchar(50) DEFAULT NULL,
  `Tax_status` tinyint(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `tax_master`
--

INSERT INTO `tax_master` (`id`, `Tax`, `Tax_status`) VALUES
(2, '2', 1),
(3, '3', 1),
(4, '4', 1),
(5, '18', 1),
(6, '0', 1);

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

--
-- Table structure for table `testimonial`
--

CREATE TABLE `testimonial` (
  `id` int(11) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `images` varchar(400) DEFAULT NULL,
  `com` varchar(200) DEFAULT NULL,
  `city` varchar(300) DEFAULT NULL,
  `test_desc` varchar(400) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `testimonial`
--

INSERT INTO `testimonial` (`id`, `name`, `images`, `com`, `city`, `test_desc`, `status`) VALUES
(24, 'Suresh', 'avatar.png', '', 'Chennai', 'The quality and Taste is so good, I had never experienced before with any brand, keep it up', 1),
(25, 'Krishna', 'avatar.png', '', 'Chennai', 'Excellent product, value for money, I have personally recommended in my community Thank you ', 1),
(26, 'Sangeetha', 'avatar.png', '', 'Mylapore Chennai', 'The granulation is very good, we feel the product excellence.', 1),
(31, 'Madhavan', 'avatar.png', '', 'Mylapore Chennai', 'Excellent aroma, could feel the melting taste, your team has developed a product respecting the consumers. all the best', 1),
(32, 'Lakshmi', 'avatar.png', '', 'Chennai', 'Its a healthy product for all age groups and the ghee is unique in taste and aroma', 1),
(33, 'Lakshmi', 'avatar.png', '', 'Chennai', 'Its a healthy product for all age groups and the ghee is unique in taste and aroma', 0),
(34, 'Lakshmi', 'avatar.png', '', 'Chennai', 'Its a healthy product for all age groups and the ghee is unique in taste and aroma', 0);

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

--
-- Table structure for table `user_profile`
--

CREATE TABLE `user_profile` (
  `pro_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_name` varchar(200) NOT NULL,
  `address` varchar(400) NOT NULL,
  `area` varchar(200) NOT NULL,
  `city` varchar(200) NOT NULL,
  `up_image` varchar(200) NOT NULL,
  `up_status` tinyint(2) NOT NULL,
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ref_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_profile`
--

INSERT INTO `user_profile` (`pro_id`, `user_id`, `user_name`, `address`, `area`, `city`, `up_image`, `up_status`, `updated_on`, `ref_id`) VALUES
(1, 30, 'saravana', 'no 165 . Paper mills Road , ', 'Kolathur', 'chennai', '', 0, '2022-12-31 09:00:56', 0),
(2, 33, 'Yuvi', '', '', '', '', 0, '2023-01-02 22:20:57', 0);

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

--
-- Table structure for table `visiting_history`
--

CREATE TABLE `visiting_history` (
  `visitor_id` int(11) NOT NULL,
  `visting_date` date DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `visiting_history`
--

INSERT INTO `visiting_history` (`visitor_id`, `visting_date`, `customer_id`) VALUES
(0, '2021-06-12', NULL);

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

--
-- Table structure for table `v_payout_request`
--

CREATE TABLE `v_payout_request` (
  `payout_request_id` int(11) NOT NULL,
  `payout_customer_id` varchar(255) DEFAULT NULL,
  `payout_customer_name` varchar(255) DEFAULT NULL,
  `payout_customer_mobile` varchar(255) DEFAULT NULL,
  `payout_customer_email` varchar(255) DEFAULT NULL,
  `payout_request_on` datetime DEFAULT NULL,
  `payout_request_amount` varchar(255) DEFAULT NULL,
  `payout_status` varchar(255) DEFAULT NULL,
  `payout_on` datetime DEFAULT NULL,
  `payout_attachment` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

--
-- Table structure for table `v_profile`
--

CREATE TABLE `v_profile` (
  `vp_id` int(11) NOT NULL,
  `v_id` int(11) NOT NULL,
  `v_name` varchar(200) NOT NULL,
  `company` varchar(200) NOT NULL,
  `address` varchar(400) NOT NULL,
  `area` varchar(200) NOT NULL,
  `city` varchar(200) NOT NULL,
  `vp_image` varchar(200) NOT NULL,
  `vp_logo` varchar(200) NOT NULL,
  `vp_status` tinyint(2) NOT NULL,
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `v_profile`
--

INSERT INTO `v_profile` (`vp_id`, `v_id`, `v_name`, `company`, `address`, `area`, `city`, `vp_image`, `vp_logo`, `vp_status`, `updated_on`) VALUES
(1, 31, 'saravana', 'call info', 'no 165 . Paper mills Road , ', 'Kolathur', 'chennai', 'saravana1672477652.jpg', 'saravanalogo1672477652.jpg', 0, '2022-12-31 09:07:32'),
(2, 32, 'Yuvi', 'Prediction Plus', '', '', '', '', '', 0, '2023-01-03 08:13:02'),
(3, 34, 'saravana', 'Yesgle Solutions', 'No 165, Paper Mills Road , SRP Colony Peravallur', 'Kolathur', 'Chennai', 'saravana1672716020.png', 'saravanalogo1672716020.jpg', 0, '2023-01-03 03:20:20');

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

--
-- Table structure for table `wallet_master`
--

CREATE TABLE `wallet_master` (
  `walle_id` int(11) NOT NULL,
  `wallet_Customer_id` int(11) DEFAULT NULL,
  `Wallet_amount` float(10,0) DEFAULT NULL,
  `Wallet_status` varchar(255) DEFAULT NULL,
  `Wallet_Active_Status` tinyint(4) DEFAULT NULL,
  `Wallet_Add_on` date DEFAULT NULL,
  `wallet_order` varchar(255) DEFAULT NULL,
  `Unic_wallet` varchar(255) DEFAULT NULL,
  `Referal_customer_id` varchar(255) DEFAULT NULL,
  `Shop_setting` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `wallet_master`
--

INSERT INTO `wallet_master` (`walle_id`, `wallet_Customer_id`, `Wallet_amount`, `Wallet_status`, `Wallet_Active_Status`, `Wallet_Add_on`, `wallet_order`, `Unic_wallet`, `Referal_customer_id`, `Shop_setting`) VALUES
(9, 5, 20025, 'Cancel Order Refund', 1, '2021-06-25', '525108998', '520025Cancel Order Refund525108998', NULL, NULL),
(10, 5, 12000, 'Cancel Order Refund', 1, '2021-06-25', '525104700', '512000Cancel Order Refund525104700', NULL, NULL),
(11, 5, 25, 'Cancel Order Refund', 1, '2021-06-25', '525112325', '525Cancel Order Refund525112325', NULL, NULL),
(12, 5, 20000, 'Cancel Order Refund', 1, '2021-06-25', '525118808', '520000Cancel Order Refund525118808', NULL, NULL),
(13, 6, 15025, 'Cancel Order Refund', 1, '2021-07-13', '613053929', '615025Cancel Order Refund613053929', NULL, NULL),
(15, 6, 15025, 'Cancel Order Refund', 1, '2021-07-13', '61305969', '615025Cancel Order Refund61305969', NULL, NULL),
(17, 6, 15025, 'Cancel Order Refund', 1, '2021-07-13', '613059355', '615025Cancel Order Refund613059355', NULL, NULL),
(20, 6, 15025, 'Cancel Order Refund', 1, '2021-07-13', '613053771', '615025Cancel Order Refund613053771', NULL, NULL),
(22, 6, 15025, 'Cancel Order Refund', 1, '2021-07-13', '613053338', '615025Cancel Order Refund613053338', NULL, NULL),
(24, 6, 15025, 'Cancel Order Refund', 1, '2021-07-13', '613056258', '615025Cancel Order Refund613056258', NULL, NULL),
(25, 82, 560, 'Cancel Order Refund', 1, '2022-08-27', '33952712', '82560Cancel Order Refund33952712', NULL, NULL),
(26, 83, 0, 'Cancel Order Refund', 1, '2022-09-01', '5390101', '83Cancel Order Refund5390101', NULL, NULL),
(28, 83, 0, 'Cancel Order Refund', 1, '2022-09-01', '13810106', '83Cancel Order Refund13810106', NULL, NULL),
(29, 84, 0, 'Cancel Order Refund', 1, '2022-09-10', '61801006', '84Cancel Order Refund61801006', NULL, NULL),
(30, 105, 1450, 'Cancel Order Refund', 1, '2022-10-11', '5091103', '1051450Cancel Order Refund5091103', NULL, NULL);

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

--
-- Table structure for table `wishlist`
--

CREATE TABLE `wishlist` (
  `wi_id` int(11) NOT NULL,
  `Customer_id` varchar(255) DEFAULT NULL,
  `Product_id` varchar(255) DEFAULT NULL,
  `Add_on` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `wishlist`
--

INSERT INTO `wishlist` (`wi_id`, `Customer_id`, `Product_id`, `Add_on`) VALUES
(29, '76', '156', '2022-04-29'),
(31, '76', '153', '2022-05-04'),
(32, '76', '163', '2022-05-06');

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

--
-- Structure for view `offer_product`
--

CREATE A SQL SECURITY DEFINER VIEW `offer_product`  AS SELECT `offer_master`.`Offer_id` AS `Offer_id`, `offer_master`.`Offer_Title` AS `Offer_Title`, `offer_master`.`Offer_main_category` AS `Offer_main_category`, `offer_master`.`Offer_Sub_category` AS `Offer_Sub_category`, `offer_master`.`Offer_percent` AS `Offer_percent`, `offer_master`.`Offer_upto` AS `Offer_upto`, `offer_master`.`Offer_Status` AS `Offer_Status`, `offer_master`.`offer_price` AS `offer_price`, `offer_master`.`offer_Product_id` AS `offer_Product_id`, `offer_master`.`offer_add_on` AS `offer_add_on`, `offer_master`.`offer_quality` AS `offer_quality` FROM `offer_master` ;

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

--
-- Structure for view `product_price`
--

CREATE A SQL SECURITY DEFINER VIEW `product_price`  AS SELECT `product_price_master`.`Product_price_id` AS `Product_price_id`, `product_price_master`.`Product_id` AS `Product_id`, `product_price_master`.`Product_type` AS `Product_type`, `product_price_master`.`Product_price` AS `Product_price`, `product_price_master`.`Product_offer_price` AS `Product_offer_price`, `product_price_master`.`Product_status` AS `Product_status`, `product_price_master`.`Product_Type_number` AS `Product_Type_number`, `product_price_master`.`Product_price_Add_on` AS `Product_price_Add_on`, `product_price_master`.`Product_type` AS `pr_quantity`, concat(convert(concat(`product_price_master`.`Product_price`) using latin1),'(',concat(`product_price_master`.`Product_Type_number`,`product_price_master`.`Product_type`),')') AS `Protuct_price_type`, `product_price_master`.`Shelling_price` AS `Shelling_price`, `product_price_master`.`Offer_Percent` AS `Offer_Percent` FROM `product_price_master` ;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `about_banner`
--
ALTER TABLE `about_banner`
  ADD PRIMARY KEY (`Slider_id`);

--
-- Indexes for table `apply_request`
--
ALTER TABLE `apply_request`
  ADD PRIMARY KEY (`apply_id`);

--
-- Indexes for table `award_master`
--
ALTER TABLE `award_master`
  ADD PRIMARY KEY (`Slider_id`);

--
-- Indexes for table `booking_master`
--
ALTER TABLE `booking_master`
  ADD PRIMARY KEY (`booking_id`);

--
-- Indexes for table `brand_master`
--
ALTER TABLE `brand_master`
  ADD PRIMARY KEY (`Brand_id`) USING BTREE;

--
-- Indexes for table `buypack_master`
--
ALTER TABLE `buypack_master`
  ADD PRIMARY KEY (`buy_id`);

--
-- Indexes for table `certificate_master`
--
ALTER TABLE `certificate_master`
  ADD PRIMARY KEY (`certificate_id`);

--
-- Indexes for table `city_master`
--
ALTER TABLE `city_master`
  ADD PRIMARY KEY (`City_id`) USING BTREE;

--
-- Indexes for table `classroom_slider`
--
ALTER TABLE `classroom_slider`
  ADD PRIMARY KEY (`slider_id`);

--
-- Indexes for table `cms`
--
ALTER TABLE `cms`
  ADD PRIMARY KEY (`cms_id`) USING BTREE;

--
-- Indexes for table `contact_master`
--
ALTER TABLE `contact_master`
  ADD PRIMARY KEY (`c_id`);

--
-- Indexes for table `customer_addresss_master`
--
ALTER TABLE `customer_addresss_master`
  ADD PRIMARY KEY (`Address_id`) USING BTREE;

--
-- Indexes for table `delivery_price_master`
--
ALTER TABLE `delivery_price_master`
  ADD PRIMARY KEY (`delivery_price_id`) USING BTREE;

--
-- Indexes for table `deliver_charges`
--
ALTER TABLE `deliver_charges`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `enquiry`
--
ALTER TABLE `enquiry`
  ADD PRIMARY KEY (`enquiryId`);

--
-- Indexes for table `event_post`
--
ALTER TABLE `event_post`
  ADD PRIMARY KEY (`event_id`);

--
-- Indexes for table `ewallet_master`
--
ALTER TABLE `ewallet_master`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `feature`
--
ALTER TABLE `feature`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `game_banner`
--
ALTER TABLE `game_banner`
  ADD PRIMARY KEY (`slider_id`);

--
-- Indexes for table `game_rate`
--
ALTER TABLE `game_rate`
  ADD PRIMARY KEY (`Game_rate_id`) USING BTREE;

--
-- Indexes for table `game_support_flatform`
--
ALTER TABLE `game_support_flatform`
  ADD PRIMARY KEY (`shop_id`);

--
-- Indexes for table `infrastructure`
--
ALTER TABLE `infrastructure`
  ADD PRIMARY KEY (`infra_id`);

--
-- Indexes for table `intro_master`
--
ALTER TABLE `intro_master`
  ADD PRIMARY KEY (`intro_id`) USING BTREE;

--
-- Indexes for table `landing_page`
--
ALTER TABLE `landing_page`
  ADD PRIMARY KEY (`Landing_id`) USING BTREE;

--
-- Indexes for table `leadership_master`
--
ALTER TABLE `leadership_master`
  ADD PRIMARY KEY (`leadership_id`);

--
-- Indexes for table `lee_master`
--
ALTER TABLE `lee_master`
  ADD PRIMARY KEY (`Site_id`) USING BTREE;

--
-- Indexes for table `logo_master`
--
ALTER TABLE `logo_master`
  ADD PRIMARY KEY (`logo_id`);

--
-- Indexes for table `main_category`
--
ALTER TABLE `main_category`
  ADD PRIMARY KEY (`Main_Category_id`) USING BTREE;

--
-- Indexes for table `main_category_res`
--
ALTER TABLE `main_category_res`
  ADD PRIMARY KEY (`Main_Category_id`) USING BTREE;

--
-- Indexes for table `minu_order`
--
ALTER TABLE `minu_order`
  ADD PRIMARY KEY (`minu_order_id`);

--
-- Indexes for table `module_view`
--
ALTER TABLE `module_view`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `offer_master`
--
ALTER TABLE `offer_master`
  ADD PRIMARY KEY (`Offer_id`) USING BTREE;

--
-- Indexes for table `offline_payment_setting`
--
ALTER TABLE `offline_payment_setting`
  ADD PRIMARY KEY (`offline_id`);

--
-- Indexes for table `online_class`
--
ALTER TABLE `online_class`
  ADD PRIMARY KEY (`online_class_id`);

--
-- Indexes for table `online_payment_transcation`
--
ALTER TABLE `online_payment_transcation`
  ADD PRIMARY KEY (`Online_order_id`) USING BTREE;

--
-- Indexes for table `order_master`
--
ALTER TABLE `order_master`
  ADD PRIMARY KEY (`order_id`);

--
-- Indexes for table `order_master1`
--
ALTER TABLE `order_master1`
  ADD PRIMARY KEY (`Order_id`) USING BTREE;

--
-- Indexes for table `package_master`
--
ALTER TABLE `package_master`
  ADD PRIMARY KEY (`pack_id`);

--
-- Indexes for table `payment_request`
--
ALTER TABLE `payment_request`
  ADD PRIMARY KEY (`pay_id`);

--
-- Indexes for table `payment_setting`
--
ALTER TABLE `payment_setting`
  ADD PRIMARY KEY (`Payment_id`) USING BTREE;

--
-- Indexes for table `payout_request`
--
ALTER TABLE `payout_request`
  ADD PRIMARY KEY (`payout_request_id`) USING BTREE;

--
-- Indexes for table `payout_setting`
--
ALTER TABLE `payout_setting`
  ADD PRIMARY KEY (`payout_id`) USING BTREE;

--
-- Indexes for table `plateform_master`
--
ALTER TABLE `plateform_master`
  ADD PRIMARY KEY (`plateform_id`) USING BTREE;

--
-- Indexes for table `product_banner`
--
ALTER TABLE `product_banner`
  ADD PRIMARY KEY (`prod_id`);

--
-- Indexes for table `product_game_age_rating`
--
ALTER TABLE `product_game_age_rating`
  ADD PRIMARY KEY (`age_rating_id`) USING BTREE;

--
-- Indexes for table `product_game_sub_cate`
--
ALTER TABLE `product_game_sub_cate`
  ADD PRIMARY KEY (`sub_cate_id`) USING BTREE;

--
-- Indexes for table `product_image_master`
--
ALTER TABLE `product_image_master`
  ADD PRIMARY KEY (`product_image_id`) USING BTREE;

--
-- Indexes for table `product_master`
--
ALTER TABLE `product_master`
  ADD PRIMARY KEY (`Product_id`) USING BTREE;

--
-- Indexes for table `product_plateform`
--
ALTER TABLE `product_plateform`
  ADD PRIMARY KEY (`plateform_id`) USING BTREE;

--
-- Indexes for table `product_price_master`
--
ALTER TABLE `product_price_master`
  ADD PRIMARY KEY (`Product_price_id`) USING BTREE;

--
-- Indexes for table `product_type`
--
ALTER TABLE `product_type`
  ADD PRIMARY KEY (`Product_Type_id`) USING BTREE;

--
-- Indexes for table `promo_code_master`
--
ALTER TABLE `promo_code_master`
  ADD PRIMARY KEY (`Promo_id`) USING BTREE;

--
-- Indexes for table `ps_master`
--
ALTER TABLE `ps_master`
  ADD PRIMARY KEY (`ps_id`) USING BTREE;

--
-- Indexes for table `quality_master`
--
ALTER TABLE `quality_master`
  ADD PRIMARY KEY (`quality_id`);

--
-- Indexes for table `referal_master`
--
ALTER TABLE `referal_master`
  ADD PRIMARY KEY (`Referal_id`) USING BTREE;

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `shop_setting`
--
ALTER TABLE `shop_setting`
  ADD PRIMARY KEY (`shop_id`) USING BTREE;

--
-- Indexes for table `slider_master`
--
ALTER TABLE `slider_master`
  ADD PRIMARY KEY (`slider_id`) USING BTREE;

--
-- Indexes for table `social_media_master`
--
ALTER TABLE `social_media_master`
  ADD PRIMARY KEY (`sm_id`);

--
-- Indexes for table `sub_category`
--
ALTER TABLE `sub_category`
  ADD PRIMARY KEY (`Sub_Category_id`) USING BTREE;

--
-- Indexes for table `tax_master`
--
ALTER TABLE `tax_master`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `testimonial`
--
ALTER TABLE `testimonial`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_profile`
--
ALTER TABLE `user_profile`
  ADD PRIMARY KEY (`pro_id`);

--
-- Indexes for table `visiting_history`
--
ALTER TABLE `visiting_history`
  ADD PRIMARY KEY (`visitor_id`) USING BTREE;

--
-- Indexes for table `v_payout_request`
--
ALTER TABLE `v_payout_request`
  ADD PRIMARY KEY (`payout_request_id`) USING BTREE;

--
-- Indexes for table `v_profile`
--
ALTER TABLE `v_profile`
  ADD PRIMARY KEY (`vp_id`);

--
-- Indexes for table `wallet_master`
--
ALTER TABLE `wallet_master`
  ADD PRIMARY KEY (`walle_id`) USING BTREE,
  ADD UNIQUE KEY `Unic_wallet` (`Unic_wallet`) USING BTREE;

--
-- Indexes for table `wishlist`
--
ALTER TABLE `wishlist`
  ADD PRIMARY KEY (`wi_id`) USING BTREE;

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about_banner`
--
ALTER TABLE `about_banner`
  MODIFY `Slider_id` int(13) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `award_master`
--
ALTER TABLE `award_master`
  MODIFY `Slider_id` int(13) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `booking_master`
--
ALTER TABLE `booking_master`
  MODIFY `booking_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `certificate_master`
--
ALTER TABLE `certificate_master`
  MODIFY `certificate_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

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

--
-- AUTO_INCREMENT for table `classroom_slider`
--
ALTER TABLE `classroom_slider`
  MODIFY `slider_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

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

--
-- AUTO_INCREMENT for table `customer_addresss_master`
--
ALTER TABLE `customer_addresss_master`
  MODIFY `Address_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

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

--
-- AUTO_INCREMENT for table `deliver_charges`
--
ALTER TABLE `deliver_charges`
  MODIFY `id` int(120) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=186;

--
-- AUTO_INCREMENT for table `enquiry`
--
ALTER TABLE `enquiry`
  MODIFY `enquiryId` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- AUTO_INCREMENT for table `game_rate`
--
ALTER TABLE `game_rate`
  MODIFY `Game_rate_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `game_support_flatform`
--
ALTER TABLE `game_support_flatform`
  MODIFY `shop_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `main_category`
--
ALTER TABLE `main_category`
  MODIFY `Main_Category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT for table `main_category_res`
--
ALTER TABLE `main_category_res`
  MODIFY `Main_Category_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `minu_order`
--
ALTER TABLE `minu_order`
  MODIFY `minu_order_id` int(120) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `module_view`
--
ALTER TABLE `module_view`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `offer_master`
--
ALTER TABLE `offer_master`
  MODIFY `Offer_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `online_class`
--
ALTER TABLE `online_class`
  MODIFY `online_class_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `online_payment_transcation`
--
ALTER TABLE `online_payment_transcation`
  MODIFY `Online_order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `order_master`
--
ALTER TABLE `order_master`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `order_master1`
--
ALTER TABLE `order_master1`
  MODIFY `Order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=653;

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

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

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

--
-- AUTO_INCREMENT for table `payout_request`
--
ALTER TABLE `payout_request`
  MODIFY `payout_request_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `product_banner`
--
ALTER TABLE `product_banner`
  MODIFY `prod_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_game_age_rating`
--
ALTER TABLE `product_game_age_rating`
  MODIFY `age_rating_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=192;

--
-- AUTO_INCREMENT for table `product_game_sub_cate`
--
ALTER TABLE `product_game_sub_cate`
  MODIFY `sub_cate_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=132;

--
-- AUTO_INCREMENT for table `product_image_master`
--
ALTER TABLE `product_image_master`
  MODIFY `product_image_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=397;

--
-- AUTO_INCREMENT for table `product_master`
--
ALTER TABLE `product_master`
  MODIFY `Product_id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=233;

--
-- AUTO_INCREMENT for table `product_plateform`
--
ALTER TABLE `product_plateform`
  MODIFY `plateform_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=99;

--
-- AUTO_INCREMENT for table `product_price_master`
--
ALTER TABLE `product_price_master`
  MODIFY `Product_price_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=329;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

--
-- AUTO_INCREMENT for table `sub_category`
--
ALTER TABLE `sub_category`
  MODIFY `Sub_Category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=139;

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

--
-- AUTO_INCREMENT for table `testimonial`
--
ALTER TABLE `testimonial`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

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

--
-- AUTO_INCREMENT for table `v_payout_request`
--
ALTER TABLE `v_payout_request`
  MODIFY `payout_request_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `wallet_master`
--
ALTER TABLE `wallet_master`
  MODIFY `walle_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `wishlist`
--
ALTER TABLE `wishlist`
  MODIFY `wi_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;
COMMIT;

