-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 16, 2024 at 03:50 PM -- Server version: 5.7.44-cll-lve -- PHP Version: 8.1.30 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `daysmart_shodsa` -- -- -------------------------------------------------------- -- -- Table structure for table `ads` -- CREATE TABLE `ads` ( `id` int(11) NOT NULL, `name` varchar(260) NOT NULL, `category` varchar(250) NOT NULL, `image` varchar(260) NOT NULL, `created_on` datetime NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `ads` -- INSERT INTO `ads` (`id`, `name`, `category`, `image`, `created_on`, `status`) VALUES (2, 'test', 'beverages', '1721877595_f9374c286ead66d1842e.jpg', '2023-07-26 12:35:39', 1), (3, 'ads1', 'personal-care', '1721877603_c8b835810f089cfe3fdd.jpg', '2023-07-26 12:35:53', 1), (4, 'ads3', 'snacks', '1721877611_c1ecfa0f6605ec99bdd2.jpg', '2023-07-26 15:19:55', 1), (5, 'ads4', 'cleaning-item', '1721877619_2284a8c8c3166697264d.jpg', '2023-07-26 15:38:40', 1), (6, 'test', 'hand-made-soap', '1721877626_5bb1049105f6e5051b96.jpg', '2023-07-28 18:14:30', 1); -- -------------------------------------------------------- -- -- Table structure for table `area` -- CREATE TABLE `area` ( `id` int(11) NOT NULL, `area` varchar(260) NOT NULL, `pincode` varchar(30) NOT NULL, `city_id` int(11) NOT NULL, `created_on` datetime NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `area` -- INSERT INTO `area` (`id`, `area`, `pincode`, `city_id`, `created_on`, `status`) VALUES (2, 'Kolathur - 600099', '', 2, '2023-05-17 00:00:00', 1), (3, 'GKM Colony - 600 082', '', 2, '2023-05-17 00:00:00', 1), (5, 'Peravallur - 600 082', '', 2, '2023-05-24 00:00:00', 1), (6, 'Thiru Vi Ka Nagar - 600011', '', 2, '2023-05-24 00:00:00', 1), (7, 'Perambur - 600 011', '', 2, '2023-05-24 00:00:00', 1), (8, 'Periyar Nagar - 600082', '', 2, '2023-05-24 00:00:00', 1), (9, 'Anna Nagar - 600 040', '', 2, '2023-05-24 00:00:00', 1), (10, 'Korattur - 600 050', '', 2, '2023-05-24 00:00:00', 1), (11, 'Villivakkam - 600 049', '', 2, '2023-05-24 00:00:00', 1), (12, 'Mylapore - 600004', '', 2, '2023-06-15 00:00:00', 1), (13, 'Parrys - 600 001', '', 2, '2023-06-17 00:00:00', 1), (14, 'Park Town - 600 003', '', 2, '2023-06-17 00:00:00', 1), (15, 'Anna Road HO - 600 002', '', 2, '2023-06-17 00:00:00', 1), (16, 'Triplicane - 600 005', '', 2, '2023-06-17 00:00:00', 1), (17, 'Greems Road - 600 006', '', 2, '2023-06-17 00:00:00', 1), (18, 'Vepery - 600 007', '', 2, '2023-06-17 00:00:00', 1), (19, 'Egmore - 600 008', '', 2, '2023-06-17 00:00:00', 1), (20, 'Fort St.Ggeorge - 600 009', '', 2, '2023-06-17 00:00:00', 1), (21, 'Kilpauk - 600 010', '', 2, '2023-06-17 00:00:00', 1), (22, 'Perambur Barracks - 600 012', '', 2, '2023-06-17 00:00:00', 1), (23, 'Royapuram - 600 013', '', 2, '2023-06-17 00:00:00', 1), (24, 'Royapettah - 600 014', '', 2, '2023-06-17 00:00:00', 1), (25, 'Saidapet - 600 015', '', 2, '2023-06-17 00:00:00', 1), (26, 'St.Thomos Mount - 600 016', '', 2, '2023-06-17 00:00:00', 1), (27, 'T.Nagar - 600 017', '', 2, '2023-06-17 00:00:00', 1), (28, 'Teynampet - 600 018', '', 2, '2023-06-17 00:00:00', 1), (29, 'Tiruvottiyur - 600 019', '', 2, '2023-06-17 00:00:00', 1), (30, 'Adyar - 600 020', '', 2, '2023-06-17 00:00:00', 1), (31, 'Washermanpet - 600 021', '', 2, '2023-06-17 00:00:00', 1), (32, 'Raj Bhavan - 600 022', '', 2, '2023-06-17 00:00:00', 1), (33, 'Ayanavaram - 600 023', '', 2, '2023-06-17 00:00:00', 1), (34, 'Kodambakkam - 600 024', '', 2, '2023-06-17 00:00:00', 1), (35, 'Vadapalani - 600 026', '', 2, '2023-06-17 00:00:00', 1), (36, 'Meenambakkam - 600 027', '', 2, '2023-06-17 00:00:00', 1), (37, 'R.A.Puram - 600 028', '', 2, '2023-06-17 00:00:00', 1), (38, 'Aminjikarai - 600 029', '', 2, '2023-06-17 00:00:00', 1), (39, 'Shenoy Nagar - 600 030', '', 2, '2023-06-17 00:00:00', 1), (40, 'Chetpet HO - 600 031', '', 2, '2023-06-17 00:00:00', 1), (41, 'Guindy Indl.Estate - 600 032', '', 2, '2023-06-17 00:00:00', 1), (42, 'West Mambalam - 600 033', '', 2, '2023-06-17 00:00:00', 1), (43, 'Nungambakkam - 600 034', '', 2, '2023-06-17 00:00:00', 1), (44, 'Nandanam - 600 035', '', 2, '2023-06-17 00:00:00', 1), (45, 'I.I.T - 600 036', '', 2, '2023-06-17 00:00:00', 1), (46, 'Officers Training Academy - 600 037', '', 2, '2023-06-17 00:00:00', 1), (47, 'ICF Colony - 600 038', '', 2, '2023-06-17 00:00:00', 1), (48, 'Vyasarpadi - 600 050', '', 2, '2023-06-17 00:00:00', 1), (49, 'Tiruvanmiyur - 600 041', '', 2, '2023-06-17 00:00:00', 1), (50, 'Velachery - 600 042', '', 2, '2023-06-17 00:00:00', 1), (51, 'Palavaram - 600 043', '', 2, '2023-06-17 00:00:00', 1), (52, 'Chrompet - 600 044', '', 2, '2023-06-17 00:00:00', 1), (53, 'Tambaram HO - 600 045', '', 2, '2023-06-17 00:00:00', 1), (54, 'Tambaram ICF - 600 046', '', 2, '2023-06-17 00:00:00', 1), (55, 'Tambaram Sanatorium - 600 047', '', 2, '2023-06-17 00:00:00', 1), (56, 'Vandalur - 600 048', '', 2, '2023-06-17 00:00:00', 1), (57, 'Padi- 600 050', '', 2, '2023-06-17 00:00:00', 1), (58, 'Madhavaram Milk Clny - 600 051', '', 2, '2023-06-17 00:00:00', 1), (59, 'Redhills - 600 052', '', 2, '2023-06-17 00:00:00', 1), (60, 'Ambattur Ho - 600 053', '', 2, '2023-06-17 00:00:00', 1), (61, 'Avadi Camp HO - 600 054', '', 2, '2023-06-17 00:00:00', 1), (62, 'Avadi IAF - 600 055', '', 2, '2023-06-17 00:00:00', 1), (63, 'Poonamallee - 600 056', '', 2, '2023-06-17 00:00:00', 1), (64, 'Ennore Termal Stn - 600 057', '', 2, '2023-06-17 00:00:00', 1), (65, 'Ambattur Indl.Estate - 600 058', '', 2, '2023-06-17 00:00:00', 1), (66, 'Tambaram East - 600 059', '', 2, '2023-06-17 00:00:00', 1), (67, 'Madhavaram - 600 060', '', 2, '2023-06-17 00:00:00', 1), (68, 'Nanganallur - 600 061', '', 2, '2023-06-17 00:00:00', 1), (69, 'Sathyamurthi Nagar - 600 062', '', 2, '2023-06-17 00:00:00', 1), (70, 'Chitalapakkam - 600 064', '', 2, '2023-06-17 00:00:00', 1), (71, 'CRP Camp Avadi - 600 065', '', 2, '2023-06-17 00:00:00', 1), (72, 'Pozhal - 600 066', '', 2, '2023-06-17 00:00:00', 1), (73, 'Sholavaram - 600 06', '', 2, '2023-06-17 00:00:00', 1), (74, 'Manali - 600 068', '', 2, '2023-06-17 00:00:00', 1), (75, 'kunnathur - 600 069', '', 2, '2023-06-17 00:00:00', 1), (76, 'Anakaputhur - 600 070', '', 2, '2023-06-17 00:00:00', 1), (77, 'Pattabiram - 600 072', '', 2, '2023-06-17 00:00:00', 1), (78, 'Selaiyur - 600 073', '', 2, '2023-06-17 00:00:00', 1), (79, 'Polichalur - 600 074', '', 2, '2023-06-17 00:00:00', 1), (80, 'Pammal - 600 075', '', 2, '2023-06-17 00:00:00', 1), (81, 'Korattur RS - 600 076', '', 2, '2023-06-17 00:00:00', 1), (82, 'Tirverkadu - 600 077', '', 2, '2023-06-17 00:00:00', 1), (83, 'K.K.Nagar - 600 078', '', 2, '2023-06-17 00:00:00', 1), (84, 'Sowcarpet - 600 079', '', 2, '2023-06-17 00:00:00', 1), (85, 'Korattur - 600 080', '', 2, '2023-06-17 00:00:00', 1), (86, 'Tondiarpet - 600 081', '', 2, '2023-06-17 00:00:00', 1), (87, 'Ashok Nagar - 600 083', '', 2, '2023-06-17 00:00:00', 1), (88, 'Kottur - 600 085', '', 2, '2023-06-17 00:00:00', 1), (89, 'Gopalapuram - 600 086', '', 2, '2023-06-17 00:00:00', 1), (90, 'Alwarthirunagar - 600 087', '', 2, '2023-06-17 00:00:00', 1), (91, 'Adambakkam - 600 088', '', 2, '2023-06-17 00:00:00', 1), (92, 'Nandabakkamudiyiruppu - 600 089', '', 2, '2023-06-17 00:00:00', 1), (93, 'Besant Nagar - 600 090', '', 2, '2023-06-17 00:00:00', 1), (94, 'Madipakkam - 600 091', '', 2, '2023-06-17 00:00:00', 1), (95, 'Virugambakkam - 600 092', '', 2, '2023-06-17 00:00:00', 1), (96, 'Saligramam - 600 093', '', 2, '2023-06-17 00:00:00', 1), (97, 'Choolaimedu - 600 094', '', 2, '2023-06-17 00:00:00', 1), (98, 'Jafferkhanpet - 600 095', '', 2, '2023-06-17 00:00:00', 1), (99, 'Perungudi - 600 096', '', 2, '2023-06-17 00:00:00', 1), (100, 'Ekkaduthangal - 600 097', '', 2, '2023-06-17 00:00:00', 1), (101, 'SIDCO Estate - 600 098', '', 2, '2023-06-17 00:00:00', 1), (102, 'Anna Nagar West Extn - 600 101', '', 2, '2023-06-17 00:00:00', 1), (103, 'Anna Nagar East - 600 102', '', 2, '2023-06-17 00:00:00', 1), (104, 'Manali New Town - 600 103', '', 2, '2023-06-17 00:00:00', 1), (105, 'Madras High Court - 600 104', '', 2, '2023-06-17 00:00:00', 1), (106, 'Arumbakkam - 600 106', '', 2, '2023-06-17 00:00:00', 1), (107, 'Koyambedu - 600 107', '', 2, '2023-06-17 00:00:00', 1), (108, 'Broadway - 600 108', '', 2, '2023-06-17 00:00:00', 1), (109, 'Rly.Car Shed Avadi - 600 109', '', 2, '2023-06-17 00:00:00', 1), (110, 'Ponniamman Medu - 600 110', '', 2, '2023-06-17 00:00:00', 1), (111, 'Choolai - 600 112', '', 2, '2023-06-17 00:00:00', 1), (112, 'Tharamani - 600 113', '', 2, '2023-06-17 00:00:00', 1), (113, 'Pazhavanthangal - 600 114', '', 2, '2023-06-17 00:00:00', 1), (114, 'Velachari - 600 115', '', 2, '2023-06-17 00:00:00', 1), (115, 'Porur - 600 116', '', 2, '2023-06-17 00:00:00', 1), (116, 'Keezhakattalai - 600 117', '', 2, '2023-06-17 00:00:00', 1), (117, 'Minjur - 601 203', '', 2, '2023-06-17 00:00:00', 1), (118, 'Ponneri - 601 204', '', 2, '2023-06-17 00:00:00', 1), (119, 'Pulicat - 601 205', '', 2, '2023-06-17 00:00:00', 1), (120, 'Kavarapettai - 601 206', '', 2, '2023-06-17 00:00:00', 1), (121, 'Arambakkam RS - 601 207', '', 2, '2023-06-17 00:00:00', 1), (122, 'Thirupalai Vanam - 601 208', '', 2, '2023-06-17 00:00:00', 1), (123, 'Thirumullaivoyal - 601 209', '', 2, '2023-06-17 00:00:00', 1), (124, 'Perumbadu - 601 210', '', 2, '2023-06-17 00:00:00', 1), (125, 'Elavur - 601 211', '', 2, '2023-06-17 00:00:00', 1), (126, 'Iguvar Palayam - 601 212', '', 2, '2023-06-17 00:00:00', 1), (127, 'Jothi Nagar(Minjur) - 601 213', '', 2, '2023-06-17 00:00:00', 1), (128, 'Devampattu - 601 214', '', 2, '2023-06-17 00:00:00', 1), (129, 'Padappai - 601 301', '', 2, '2023-06-17 00:00:00', 1), (130, 'Gowrivakkam - 601 302', '', 2, '2023-06-17 00:00:00', 1), (131, 'Old Pallavaram - 601 303', '', 2, '2023-06-17 00:00:00', 1), (132, 'Thiruninravur - 602 024', '', 2, '2023-06-17 00:00:00', 1), (133, 'Mangadu - 602 101', '', 2, '2023-06-17 00:00:00', 1), (134, 'Maduravoil - 602 102', '', 2, '2023-06-17 00:00:00', 1), (135, 'West porur - 602 104', '', 2, '2023-06-17 00:00:00', 1), (136, 'Nazareth Pettai', ' 602 107', 2, '2023-06-17 00:00:00', 1), (142, 'test', '123321', 3, '2023-06-19 15:27:03', 1); -- -------------------------------------------------------- -- -- Table structure for table `calls` -- CREATE TABLE `calls` ( `id` int(11) NOT NULL, `category` varchar(110) NOT NULL, `subcategory` varchar(110) NOT NULL, `sub_subcategory` varchar(250) NOT NULL, `mobile_number` varchar(20) NOT NULL, `name` varchar(120) NOT NULL, `alt_number` varchar(20) NOT NULL, `email` varchar(120) NOT NULL, `reason` varchar(110) NOT NULL, `reason_id` int(11) NOT NULL, `reason_type` varchar(120) NOT NULL, `descriptions` longtext NOT NULL, `project_cost` int(11) NOT NULL, `project_advance` int(11) NOT NULL, `project_pending` int(11) NOT NULL, `notification` longtext NOT NULL, `description` longtext NOT NULL, `amount_description` longtext NOT NULL, `created_by` int(11) DEFAULT NULL, `vendor_id` int(11) NOT NULL, `swap_id` varchar(300) NOT NULL, `created_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `calls` -- INSERT INTO `calls` (`id`, `category`, `subcategory`, `sub_subcategory`, `mobile_number`, `name`, `alt_number`, `email`, `reason`, `reason_id`, `reason_type`, `descriptions`, `project_cost`, `project_advance`, `project_pending`, `notification`, `description`, `amount_description`, `created_by`, `vendor_id`, `swap_id`, `created_on`) VALUES (11, 'CLASSIFIED', 'JOBS', 'test', '9876543210', 'test', '2323232223', 'saravana@yesgle.in', 'Appointment', 5, 'Appointment Today', 'test', 1000, 500, 500, 'test1', '', 'test', 58, 47, '', '2023-05-08 05:04:43'), (12, 'CLASSIFIED', 'JOBS', 'test.test1', '9876543212', 'praveen', '4343443222', 'saravana@yesgle.in', 'Appointment', 5, 'Appointment Today', 'dfsgdsdsfdf', 1000, 200, 800, '', '', '', 58, 47, '', '2023-05-08 05:29:41'), (13, 'CLASSIFIED', 'JOBS', 'test.test1', '9876543211', 'test', '3432434333', 'test@gamil.com', 'Not Picked', 8, 'NOT PICKED', 'sdfsfsf', 0, 0, 0, '', '', '', 58, 47, '[\"79\"]', '2023-05-09 07:33:08'), (14, 'CLASSIFIED', 'JOBS', 'test', '9876541111', 'praveen', '1212133111', 'pk123@gdfg.com', 'Follow Up ', 6, 'FOLLOW UP', '12121212', 0, 0, 0, '', '', '', 59, 47, '[\"58\",\"79\"]', '2023-05-09 08:31:16'), (15, 'CLASSIFIED', 'JOBS', 'test', '9876543213', 'test', '2342343444', 'pk123@gdfg.com', 'Follow Up ', 6, 'FOLLOW UP', 'ewrewrew', 0, 0, 0, '', '', '', 58, 47, '', '2023-05-09 09:30:51'), (16, 'CLASSIFIED', 'JOBS', 'test.test1', '3232321298', 'test', '3232321298', 'pk123@gdfg.com', 'Follow Up ', 6, 'FOLLOW UP', '', 0, 0, 0, '', '', '', 58, 47, '', '2023-05-09 09:32:23'), (17, 'CLASSIFIED', 'JOBS', 'test.test1', '9876543234', 'dfdsf', '3423423432', 'saravana@yesgle.in', 'Appointment', 5, 'Appointment Today', 'dfdsf', 0, 0, 0, '', '', '', 58, 47, '', '2023-05-12 13:44:46'), (18, 'CLASSIFIED', 'JOBS', 'test.test1', '9876543214', '6225', '', '', 'Appointment', 5, 'Appointment Today', '62', 0, 0, 0, '', '', '', 58, 47, '', '2023-05-12 13:46:34'), (19, 'CLASSIFIED', 'JOBS', 'test', '9876543217', '98', '', '', 'Blocked', 10, 'BLOCKED NUMBER', '', 0, 0, 0, '', '', '', 58, 47, '', '2023-05-12 13:47:52'), (20, 'CLASSIFIED', 'JOBS', '', '7395951992', 'Santhosh', '', '', 'Follow Up ', 6, 'FOLLOW UP', 'Call tomoorow at 10.00 clock', 0, 0, 0, '', '', '', 81, 48, '[\"82\"]', '2023-05-15 11:52:50'), (21, 'CLASSIFIED', 'JOBS', '', '9962516036', 'Mouleeswari', '', '', 'Appointment', 5, 'Others', 'Appointment tomorrow', 0, 0, 0, '', '', '', 81, 48, '', '2023-05-15 12:04:19'), (22, 'CLASSIFIED', 'JOBS', '', '7395951982', 'Shalu', '', '', 'Call Backs', 7, 'Tomorrow call back', 'Will give appointment ', 0, 0, 0, '', '', '', 81, 48, '', '2023-05-15 12:05:54'), (23, 'DIGITAL VCARD', 'DIGI CARD', '', '8122655680', 'Eswari', '', '', 'Call Backs', 7, 'Tomorrow call back', '', 0, 0, 0, '', '', '', 82, 48, '', '2023-05-15 12:11:05'), (24, 'DIGITAL VCARD', 'DIGI CARD', '', '9047111871', 'swathi', '', '', 'Follow Up ', 5, 'Follow tomorrow', 'Confirmed order ', 10000, 5000, 5000, '', 'comp[lete in 10 days', '', 82, 48, '[\"81\"]', '2023-05-15 12:11:52'), (25, 'FIND EXPERTS', 'BUSIENSS 1999', '', '9876543221', 'test', '2323232333', 'saravana@yesgle.in', 'Not Intrested', 9, 'Others', 'kjsdfhsjdf', 0, 0, 0, '', '', '', 58, 47, '', '2023-05-15 12:24:38'), (26, 'CLASSIFIED', 'EVENTS EXPO', '', '7876543210', 'praveen', '2323233333', 'dfg@dfg.com', 'Appointment', 5, 'Appointment Today', 'dsfdsfdsf', 0, 0, 0, '', '', '', 58, 47, '', '2023-05-15 12:25:09'), (27, 'DIGITAL VCARD', 'DIGI CARD', '', '5576543210', 'Tamil Nadu1', '3324343444', 'saravana@yesgle.in', 'Appointment', 5, 'Appointment Today', '2334', 0, 0, 0, '', '', '', 58, 47, '', '2023-05-15 12:26:07'), (28, 'CLASSIFIED', 'EVENTS EXPO', '', '9855543210', 'test', '3434444444', 'pk123@gdfg.com', 'Appointment', 5, 'Appointment Today', 'fdssfsdfs', 0, 0, 0, '', '', '', 58, 47, '', '2023-05-15 12:29:13'), (29, 'CLASSIFIED', 'JOBS', '', '9576543210', 'test', '1221212121', 'dfg@dfg.com', 'Not Picked', 8, 'Others', 'sdfsdfdsf', 0, 0, 0, '', '', '', 58, 47, '', '2023-05-15 12:34:00'); -- -------------------------------------------------------- -- -- Table structure for table `cart` -- CREATE TABLE `cart` ( `id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `variant_id` int(11) NOT NULL, `variant_name` varchar(360) NOT NULL, `qty` int(11) NOT NULL, `price` int(11) NOT NULL, `m_price` int(11) NOT NULL, `customer_id` int(11) NOT NULL, `total_amount` int(11) NOT NULL, `transport_min` int(11) NOT NULL, `transport_amt` int(11) NOT NULL, `created_on` datetime NOT NULL, `vendor_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `cart` -- INSERT INTO `cart` (`id`, `product_id`, `variant_id`, `variant_name`, `qty`, `price`, `m_price`, `customer_id`, `total_amount`, `transport_min`, `transport_amt`, `created_on`, `vendor_id`) VALUES (285, 151, 141, 'Dabur Red paste 500g', 1, 90, 110, 15, 0, 0, 0, '2023-07-12 13:08:07', 105), (306, 170, 175, 'Health Mix 500 grm', 4, 190, 220, 27, 0, 0, 0, '2024-11-15 06:07:30', 105); -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE `category` ( `id` int(11) NOT NULL, `vendor_id` int(11) NOT NULL, `category_name` varchar(255) NOT NULL, `slug` varchar(250) NOT NULL, `image` varchar(250) NOT NULL, `position` int(11) NOT NULL, `category_type` int(11) DEFAULT NULL, `created_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `category` -- INSERT INTO `category` (`id`, `vendor_id`, `category_name`, `slug`, `image`, `position`, `category_type`, `created_on`, `updated_on`, `status`) VALUES (17, 0, 'Hand Made Soap', 'hand-made-soap', '1689236107_7a38206e68ecf5670b26.jpg', 2, 3, '2023-05-24 00:00:00', '2023-05-24 15:38:50', 1), (18, 0, 'Personal Care', 'personal-care', '1689236114_7e389d28d8d46553e40f.jpg', 4, 3, '2023-05-24 00:00:00', '2023-05-24 15:39:03', 1), (20, 0, 'Cleaning Item', 'cleaning-item', '1689236102_4c2b1704b2f3212bbb7c.jpg', 1, 3, '2023-05-24 00:00:00', '2023-05-24 15:39:54', 1), (38, 0, 'Snacks', 'snacks', '1685708576_964bb4a2e812af52469b.jpg', 5, 3, '2023-06-02 00:00:00', '2023-06-02 17:34:20', 1), (39, 0, 'Beverages', 'beverages', '1689236119_e91a3d022b28603bcc49.jpg', 3, 3, '2023-06-02 00:00:00', '2023-06-02 18:16:26', 1), (40, 0, 'Masala', 'masala', '1722056452_19bfdeefe5665469cd47.jpg', 6, 3, '2023-09-07 00:00:00', '2023-09-07 14:11:22', 1), (41, 0, 'Goli Soda', 'goli-soda', '1722056490_6f1ea9516897ee509aa9.jpg', 7, 3, '2024-07-27 00:00:00', '2024-07-27 10:31:30', 0), (42, 0, 'Seeds', 'seeds', '1723631807_1656a8311aca73df5fac.jpg', 8, 3, '2024-08-14 00:00:00', '2024-08-14 16:06:47', 1); -- -------------------------------------------------------- -- -- Table structure for table `category_type` -- CREATE TABLE `category_type` ( `id` int(11) NOT NULL, `category_type` varchar(110) NOT NULL, `created_on` datetime NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `category_type` -- INSERT INTO `category_type` (`id`, `category_type`, `created_on`, `status`) VALUES (2, 'Food', '2023-06-02 16:13:56', 0), (3, 'Shop', '2023-06-02 16:15:21', 1), (4, 'Services', '2023-06-02 16:42:44', 0); -- -------------------------------------------------------- -- -- Table structure for table `city` -- CREATE TABLE `city` ( `id` int(11) NOT NULL, `city` varchar(260) NOT NULL, `created_on` datetime NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `city` -- INSERT INTO `city` (`id`, `city`, `created_on`, `status`) VALUES (2, 'Chennai', '2023-05-17 00:00:00', 1), (3, 'Tiruchirappalli', '2023-06-15 00:00:00', 0), (4, 'Coimbatore', '2023-06-15 00:00:00', 0), (5, 'Vellore', '2023-06-15 00:00:00', 0), (6, 'Tiruvannamalai', '2023-06-15 00:00:00', 0), (7, 'Salem', '2023-06-15 00:00:00', 0), (8, 'Dharmapuri', '2023-06-15 00:00:00', 0), (9, 'Krishnagiri', '2023-06-15 00:00:00', 0), (10, 'Karur', '2023-06-15 00:00:00', 0), (11, 'Nagapattinam', '2023-06-15 00:00:00', 0), (12, 'Theni', '2023-06-15 00:00:00', 0), (13, 'Virudhunagar', '2023-06-15 00:00:00', 0), (14, 'Perambalur', '2023-06-15 00:00:00', 0), (15, 'Tenkasi', '2023-06-15 00:00:00', 0), (16, 'Ranipet', '2023-06-15 00:00:00', 0), (17, 'Sivagangai', '2023-06-15 00:00:00', 0), (18, 'Kanyakumari', '2023-06-15 00:00:00', 0), (19, 'Nilgiris', '2023-06-15 00:00:00', 0), (20, 'Pudukkottai', '2023-06-15 00:00:00', 0), (21, 'Ariyalur', '2023-06-15 00:00:00', 0), (22, 'Chengalpet', '2023-06-15 00:00:00', 0), (23, 'Cuddalore', '2023-06-15 00:00:00', 0), (24, 'Dindigul', '2023-06-15 00:00:00', 0), (25, 'Erode', '2023-06-15 00:00:00', 0), (26, 'Kallakurichi', '2023-06-15 00:00:00', 0), (27, 'Kancheepuram', '2023-06-15 00:00:00', 0), (28, 'Madurai', '2023-06-15 00:00:00', 0), (29, 'Mayiladuthurai', '2023-06-15 00:00:00', 0), (30, 'Namakkal', '2023-06-15 00:00:00', 0), (31, 'Ramanathapuram', '2023-06-15 00:00:00', 0), (32, 'Thanjavur', '2023-06-15 00:00:00', 0), (33, 'Thiruvallur', '2023-06-15 00:00:00', 0), (34, 'Thiruvarur', '2023-06-15 00:00:00', 0), (35, 'Tuticorin', '2023-06-15 00:00:00', 0), (36, 'Thirunelveli', '2023-06-15 00:00:00', 0), (37, 'Tirupathur', '2023-06-15 00:00:00', 0), (38, 'Tiruppur', '2023-06-15 00:00:00', 0), (39, 'Viluppuram', '2023-06-15 00:00:00', 0), (40, 'Thoothukudi', '2023-08-03 00:00:00', 0); -- -------------------------------------------------------- -- -- Table structure for table `commission` -- CREATE TABLE `commission` ( `id` int(11) NOT NULL, `amount` int(11) NOT NULL, `percentage` int(11) NOT NULL, `type` varchar(50) NOT NULL, `created_on` datetime NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `commission` -- INSERT INTO `commission` (`id`, `amount`, `percentage`, `type`, `created_on`, `status`) VALUES (1, 0, 15, 'Percentage', '2023-05-18 16:54:44', 1), (3, 0, 16, 'Percentage', '2023-05-18 17:43:19', 1), (4, 25, 0, 'Fixed', '2023-05-18 17:43:25', 1), (5, 10, 0, 'Fixed', '2023-05-18 17:43:30', 1); -- -------------------------------------------------------- -- -- Table structure for table `commission_slab` -- CREATE TABLE `commission_slab` ( `id` int(11) NOT NULL, `vendor_id` int(11) NOT NULL, `comm_id` int(11) DEFAULT NULL, `cat_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `commission_slab` -- INSERT INTO `commission_slab` (`id`, `vendor_id`, `comm_id`, `cat_id`) VALUES (25, 105, 1, 17); -- -------------------------------------------------------- -- -- Table structure for table `contact_us` -- CREATE TABLE `contact_us` ( `id` int(11) NOT NULL, `name` varchar(360) NOT NULL, `mobile_number` varchar(20) NOT NULL, `subject` varchar(150) NOT NULL, `message` longtext NOT NULL, `email` varchar(250) NOT NULL, `status` tinyint(4) NOT NULL, `created_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `contact_us` -- INSERT INTO `contact_us` (`id`, `name`, `mobile_number`, `subject`, `message`, `email`, `status`, `created_on`) VALUES (222, 'Tamil Nadu1', '1234567890', 'General Enquiry', 'ttes', 'pk123@gdfg.com', 0, '2023-07-17 15:44:52'), (223, 'S w sahib', '7019577381', 'Distributorship', 'Dear sir.\r\nWe are interested to start this type of business so pls advice according to you.\r\nBye. and awaiting your reply.', 'swinfrapiling@rediffmail.com', 1, '2023-08-18 17:09:59'); -- -------------------------------------------------------- -- -- Table structure for table `customer` -- CREATE TABLE `customer` ( `id` int(11) NOT NULL, `role` int(11) NOT NULL, `name` varchar(260) NOT NULL, `mobile_number` varchar(20) NOT NULL, `email` varchar(160) NOT NULL, `password` varchar(260) NOT NULL, `address` longtext NOT NULL, `image` varchar(250) NOT NULL, `city` varchar(260) NOT NULL, `area` varchar(260) NOT NULL, `press_name` varchar(250) NOT NULL, `tac` int(11) NOT NULL, `status` tinyint(1) NOT NULL, `created_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `customer` -- INSERT INTO `customer` (`id`, `role`, `name`, `mobile_number`, `email`, `password`, `address`, `image`, `city`, `area`, `press_name`, `tac`, `status`, `created_on`) VALUES (19, 0, 'saravana', '9962516035', 'yesgleinfo@gmail.com', '9962516035', '', '', '', '', '', 0, 1, '2023-07-29 13:52:27'), (23, 1, 'saravana', '9360466662', 'dayshomecaredotin@gmail.com', '9360466662', '', '1691136923_42e6791e38fe301b8fb8.jpg', 'Chennai', 'Kolathur', 'Days Home Care', 0, 1, '2023-08-04 13:45:23'), (25, 1, 'Shiv kumar', '9955336803', 'shivnemua@gmail.com', '12345', '', '', 'Chennai', 'Madhubani ', 'Dez india', 0, 0, '2023-08-08 14:03:15'), (27, 0, 'Saravana Kumar', '7395951992', 'callinfoinc@gmail.com', '7395951992', '', '', '', '', '', 1, 1, '2024-10-13 02:28:54'), (28, 1, 'Kumar', '7395951982', 'yesglewebsolutions@gmail.com', '7395951982', '', '1730953240_28c4cf78baed84c40c5b.jpg', 'Chennai', 'Mylapore', 'Daysmart', 0, 0, '2024-11-07 09:50:40'); -- -------------------------------------------------------- -- -- Table structure for table `customer_address` -- CREATE TABLE `customer_address` ( `id` int(11) NOT NULL, `customer_id` int(11) NOT NULL, `set` int(11) NOT NULL, `pincode` int(11) NOT NULL, `land_mark` varchar(250) NOT NULL, `city` varchar(250) NOT NULL, `area` varchar(260) NOT NULL, `house_no` varchar(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `customer_address` -- INSERT INTO `customer_address` (`id`, `customer_id`, `set`, `pincode`, `land_mark`, `city`, `area`, `house_no`) VALUES (1, 2, 0, 114623, 'srp', 'Chennai', 'Kolathur - 600099', '3th'), (3, 2, 1, 123333, '70 feet road', 'Chennai', 'Kolathur - 600099', '7(1)'), (4, 4, 0, 600082, 'SRP colony Bus Stop', 'Chennai', 'Kolathur - 600099', '165, Paper Mills Road, SRP Colony, Peravallur,'), (5, 7, 0, 123333, 'SRP colony', 'Chennai', 'Kolathur - 600099', '3'), (6, 4, 0, 600011, 'Perambur ', 'Chennai', 'Perambur - 600 011', '54'), (11, 19, 0, 600099, 'SRP colony Bus Stop', 'Chennai', 'Kolathur - 600099', '165, Paper Mills Road, SRP Colony, Peravallur,'), (16, 19, 1, 600082, 'SRP colony Bus Stop', 'Chennai', 'Peravallur - 600 082', '165, Paper Mills Road, SRP Colony, Peravallur,'), (17, 23, 1, 600082, 'Peravallur ', 'Chennai', 'Kolathur - 600099', '165, Paper Mills Road'); -- -------------------------------------------------------- -- -- Table structure for table `delivery` -- CREATE TABLE `delivery` ( `id` int(11) NOT NULL, `title` varchar(260) NOT NULL, `amount` int(11) NOT NULL, `status` tinyint(1) NOT NULL, `created_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `delivery` -- INSERT INTO `delivery` (`id`, `title`, `amount`, `status`, `created_on`) VALUES (1, 'Delivery Charges', 10, 1, '2023-05-18 18:04:26'); -- -------------------------------------------------------- -- -- Table structure for table `delivery_area` -- CREATE TABLE `delivery_area` ( `id` int(11) NOT NULL, `area_id` int(11) NOT NULL, `vendor_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `delivery_area` -- INSERT INTO `delivery_area` (`id`, `area_id`, `vendor_id`) VALUES (17, 2, 105), (19, 3, 105), (20, 5, 105), (21, 6, 105), (22, 7, 105), (23, 8, 105), (24, 9, 105), (25, 10, 105), (45, 11, 105); -- -------------------------------------------------------- -- -- Table structure for table `dsa` -- CREATE TABLE `dsa` ( `id` int(11) NOT NULL, `v_id` int(11) NOT NULL, `dsa` int(11) NOT NULL, `created_on` datetime NOT NULL, `status` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `dsa` -- INSERT INTO `dsa` (`id`, `v_id`, `dsa`, `created_on`, `status`) VALUES (6, 155, 35, '2023-07-19 13:13:05', 1), (7, 151, 35, '2023-07-19 13:13:13', 1), (8, 147, 50, '2023-07-19 13:13:20', 1), (9, 153, 35, '2023-07-19 13:13:30', 1), (10, 150, 35, '2023-07-19 13:13:40', 1), (11, 157, 35, '2023-07-19 13:13:53', 1), (12, 159, 50, '2023-07-19 13:14:01', 1), (13, 160, 35, '2023-07-19 13:14:10', 1), (14, 164, 35, '2023-07-19 13:17:16', 1), (15, 162, 30, '2023-07-19 13:17:26', 1), (16, 184, 35, '2023-07-19 13:21:47', 1), (17, 175, 35, '2023-07-19 13:23:01', 1), (18, 177, 35, '2023-07-19 13:23:09', 1), (19, 178, 50, '2023-07-19 13:23:16', 1), (20, 182, 50, '2023-07-19 13:23:22', 1), (21, 181, 50, '2023-07-19 13:23:30', 1), (22, 183, 50, '2023-07-19 13:23:37', 1), (23, 166, 35, '2023-07-19 13:25:11', 1), (24, 167, 35, '2023-07-19 13:25:17', 1), (25, 168, 35, '2023-07-19 13:25:22', 1), (26, 170, 35, '2023-07-19 13:25:28', 1), (27, 169, 35, '2023-07-19 13:25:34', 1), (28, 171, 35, '2023-07-19 13:25:43', 1), (29, 173, 35, '2023-07-19 13:25:48', 1), (30, 174, 35, '2023-07-19 13:27:09', 1), (31, 188, 50, '2023-07-19 13:41:00', 0), (32, 186, 50, '2023-07-19 13:41:06', 0), (33, 187, 50, '2023-07-19 13:41:19', 0), (34, 152, 45, '2024-08-15 08:48:07', 1), (35, 154, 45, '2024-08-15 08:48:36', 1), (36, 156, 45, '2024-08-15 08:48:52', 1), (37, 158, 45, '2024-08-15 08:48:59', 1), (38, 161, 45, '2024-08-15 08:49:07', 1), (39, 163, 45, '2024-08-15 08:49:14', 1), (40, 165, 45, '2024-08-15 08:49:22', 1), (41, 200, 35, '2024-08-15 08:54:26', 1), (42, 198, 35, '2024-08-15 09:02:31', 1), (43, 192, 35, '2024-11-07 09:08:50', 1), (44, 193, 35, '2024-11-07 09:09:17', 1), (45, 194, 35, '2024-11-07 09:09:28', 1), (46, 195, 35, '2024-11-07 09:09:39', 1), (47, 196, 35, '2024-11-07 09:09:51', 1), (48, 197, 35, '2024-11-07 09:10:00', 1), (49, 201, 35, '2024-11-07 09:11:46', 1), (50, 202, 35, '2024-11-07 09:12:07', 1), (51, 203, 35, '2024-11-07 09:12:19', 1), (52, 204, 35, '2024-11-07 09:12:31', 1), (53, 205, 35, '2024-11-07 09:12:42', 1), (54, 206, 35, '2024-11-07 09:12:51', 1); -- -------------------------------------------------------- -- -- Table structure for table `dsa_dealer` -- CREATE TABLE `dsa_dealer` ( `id` int(11) NOT NULL, `name` varchar(260) NOT NULL, `email` varchar(260) NOT NULL, `mobile_number` varchar(20) NOT NULL, `mobile_number2` varchar(20) NOT NULL, `city` varchar(260) NOT NULL, `area` varchar(260) NOT NULL, `address` longtext NOT NULL, `total` int(11) NOT NULL, `total_mrp` int(11) NOT NULL, `created_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `dsa_dealer` -- INSERT INTO `dsa_dealer` (`id`, `name`, `email`, `mobile_number`, `mobile_number2`, `city`, `area`, `address`, `total`, `total_mrp`, `created_on`) VALUES (17, 'test', 'pk123@gdfg.com', '9876543210', '', 'chennai', 'test', '', 539, 718, '0000-00-00 00:00:00'), (18, 'praveen', 'pk123@gdfg.com', '9876543210', '3423432434', 'chennai', 'test', 'sdfdsfdsfdsf', 338, 450, '2023-07-19 16:53:37'), (19, 'saravana', 'yesgleinfo@gmail.com', '9962516035', '9360466662', 'Chennai', 'Kolathur', '16/30, School Road, Kolathur', 77403, 131652, '2024-11-07 09:15:18'); -- -------------------------------------------------------- -- -- Table structure for table `dsa_dealer_details` -- CREATE TABLE `dsa_dealer_details` ( `id` int(11) NOT NULL, `dealer_id` int(11) NOT NULL, `variant_name` varchar(260) NOT NULL, `volume` varchar(260) NOT NULL, `m_price` int(11) NOT NULL, `dsa_p` int(11) NOT NULL, `dsa_price` int(11) NOT NULL, `qty` int(11) NOT NULL, `total` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `dsa_dealer_details` -- INSERT INTO `dsa_dealer_details` (`id`, `dealer_id`, `variant_name`, `volume`, `m_price`, `dsa_p`, `dsa_price`, `qty`, `total`) VALUES (3, 17, 'Hair Oil', '100ML', 120, 25, 90, 1, 90), (4, 17, 'Onion Oil', '100ML', 299, 25, 224, 2, 449), (5, 18, 'Detergent Liquid', '500ML', 90, 25, 68, 1, 68), (6, 18, 'Hair Oil', '100ML', 120, 25, 90, 3, 270), (7, 19, 'Detergent Liquid', '500ML', 90, 35, 59, 12, 702), (8, 19, 'Detergent Liquid', '1Kg', 180, 35, 117, 12, 1404), (9, 19, 'Dish Wash', '500ML', 110, 35, 72, 12, 858), (10, 19, 'Floor Cleaner', '500ML', 90, 35, 59, 12, 702), (11, 19, 'Multi Cleaner', '500ML', 80, 35, 52, 12, 624), (12, 19, 'Hand Wash Liquid ', '500ML', 140, 35, 91, 12, 1092), (13, 19, 'Toilet Cleaner', '500ML', 85, 35, 55, 12, 663), (14, 19, 'Fabric Conditioners', '1Ltr', 260, 35, 169, 12, 2028), (15, 19, 'Detergent Liquid', '5Ltr', 790, 45, 435, 12, 5214), (16, 19, 'Dish Wash', '5Ltr', 890, 45, 490, 12, 5874), (17, 19, 'Floor Cleaner', '5Ltr', 850, 45, 468, 12, 5610), (18, 19, 'Multi Cleaner', '5Ltr', 850, 45, 468, 12, 5610), (19, 19, 'Hand Wash Liquid ', '5Ltr', 999, 45, 549, 12, 6593), (20, 19, 'Fabric Conditioner', '5Ltr', 890, 45, 490, 12, 5874), (21, 19, 'Toilet Cleaner', '5Ltr', 790, 45, 435, 12, 5214), (22, 19, 'Health Mix', '500Grm', 220, 35, 143, 12, 1716), (23, 19, 'Instant Coffee', '100Grm', 190, 35, 124, 12, 1482), (24, 19, 'Badam Instant Mix', '200Grm', 120, 50, 60, 12, 720), (25, 19, 'Pista Instant Mix', '200Grm', 120, 50, 60, 12, 720), (26, 19, 'Rose Instant Mix', '200Grm', 120, 50, 60, 12, 720), (27, 19, 'Chocolate Instant Mix', '200Grm', 140, 50, 70, 12, 840), (28, 19, 'Nattu Sakarai', '500Grm', 79, 35, 51, 12, 616), (29, 19, 'Aloevera Soap', '100Grm', 99, 35, 64, 12, 772), (30, 19, 'Charcoal Soap', '100Grm', 99, 35, 64, 12, 772), (31, 19, 'Papaya Soap', '100Grm', 99, 35, 64, 12, 772), (32, 19, 'Menthol Soap', '100Grm', 99, 35, 64, 12, 772), (33, 19, 'Neem Soap', '100Grm', 99, 35, 64, 12, 772), (34, 19, 'Goat Milk Soap', '100Grm', 99, 35, 64, 12, 772), (35, 19, 'Red Wine Soap', '100Grm', 99, 35, 64, 12, 772), (36, 19, 'Hair Oil', '100ML', 180, 35, 117, 1, 117), (37, 19, 'Onion Hair Oil', '100ML', 220, 35, 143, 12, 1716), (38, 19, 'Gram Ball', '250Grm', 160, 35, 104, 12, 1248), (39, 19, 'Goundnut Nice Burfi', '220Grm', 160, 35, 104, 12, 1248), (40, 19, 'Goundnut Round Burfi', '220Grm', 160, 35, 104, 12, 1248), (41, 19, 'Goundnut Burfi', '220Ltr', 160, 35, 104, 12, 1248), (42, 19, 'Sesame Round White', '220Grm', 160, 35, 104, 12, 1248), (43, 19, 'Sesame Round Black', '220Grm', 160, 35, 104, 12, 1248), (44, 19, 'Pepper Masala Powder', '220Grm', 190, 35, 124, 12, 1482), (45, 19, 'Briyani Masala Powder', '250Grm', 220, 35, 143, 12, 1716), (46, 19, 'Chicken Masala Powder', '220Grm', 190, 35, 124, 12, 1482), (47, 19, 'Trimeric Masala Powder', '220Grm', 180, 35, 117, 12, 1404), (48, 19, 'Rasam Powder', '220Grm', 190, 35, 124, 12, 1482), (49, 19, 'Sambar Powder', '220Grm', 180, 35, 117, 2, 234); -- -------------------------------------------------------- -- -- Table structure for table `enquiry` -- CREATE TABLE `enquiry` ( `id` int(11) NOT NULL, `type` varchar(110) NOT NULL, `name` varchar(260) NOT NULL, `shop_name` varchar(260) NOT NULL, `mobile_number` varchar(20) NOT NULL, `city_id` int(11) DEFAULT NULL, `area_id` varchar(110) DEFAULT NULL, `product_type` varchar(160) NOT NULL, `address` longtext NOT NULL, `proof1` varchar(350) NOT NULL, `business_type` varchar(250) NOT NULL, `service` int(11) NOT NULL, `status` tinyint(1) NOT NULL, `created_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `enquiry` -- INSERT INTO `enquiry` (`id`, `type`, `name`, `shop_name`, `mobile_number`, `city_id`, `area_id`, `product_type`, `address`, `proof1`, `business_type`, `service`, `status`, `created_on`) VALUES (13, 'business', 'saravana', '', '9962516035', 2, '2', '', 'Kolathur', '', 'Business Partner', 0, 1, '2023-06-17 11:50:29'), (17, 'business', 'test', '', '9876543210', 2, 'test', '', 'test', '', 'Business Partner', 0, 1, '2023-06-19 13:10:39'), (18, 'delivery', 'test', '', '9876543210', 2, 'test', '', 'dsffd', '1687160679_6d0aca5f4a8fe9ac4332.png', '', 0, 1, '2023-06-19 13:14:39'), (19, 'vendor', 'test', 'multikart', '9876543210', 3, 'teste3', 'Gadgets', 'dsfdasfas', '', '', 3, 1, '2023-06-19 13:15:42'), (20, 'business', 'BHARATHIRAJA R', '', '7010642176', 28, 'Thirumangalam ', '', '1/103 WAST STREET PERIYAULAGANI, koodakovil post,kalligudi taluk,madurai.pincode-625022\r\nKOODAKOVIL POST KALLIGUDI TALUKA MADYRAI', '', 'Business Partner', 0, 1, '2023-06-24 15:21:25'), (21, 'delivery', 'VENKATACHALAM V ', '', '7708354143', 7, 'Idappadi ', '', 'D No. LB48 Housing board \r\nIdappadi post & TK\r\nSalem DT 637101\r\n', '1687607435_dacc19ba92bd6d3e2dd8.jpg', '', 0, 1, '2023-06-24 17:20:35'), (22, 'delivery', 'Muralimohun', '', '8883804777', 6, 'Tiruvannamalai ', '', '1248, 12-th Street, Thendral Nagar, Vengikkal', '1687658801_19f4827c54fc3a5a8386.jpg', '', 0, 1, '2023-06-25 07:36:41'), (23, 'delivery', 'Naveen narayanar M', '', '9442684777', 6, 'Tiruvannamalai', '', '1248, 12-th Street, Thendral Nagar, Vengikkal, Tiruvannamalai ', '1687658986_63b4afd81eed811df762.jpg', '', 0, 1, '2023-06-25 07:39:46'), (24, 'delivery', 'AKHIL KUMAR ', '', '9600293293', 18, 'Nagercoil ', '', '1-126 1A, Sree Lekshmi Bhavan, sastha nager, putheri, Nagercoil ', '1687763162_bd8fe64cfba9bf1efea6.jpg', '', 0, 1, '2023-06-26 12:36:02'), (25, 'delivery', 'Rajasekar S S', '', '9150453406', 2, 'Naduveerapattu ', '', '1/254, MGR Nagar, Thambaram\r\nNaduveerapattu koott Road, Thambaram', '', '', 0, 1, '2023-06-28 17:05:24'); -- -------------------------------------------------------- -- -- Table structure for table `gallery` -- CREATE TABLE `gallery` ( `id` int(11) NOT NULL, `image` varchar(360) NOT NULL, `product_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `job_enquiry` -- CREATE TABLE `job_enquiry` ( `id` int(11) NOT NULL, `email` varchar(100) NOT NULL, `name` varchar(260) NOT NULL, `mobile_number` varchar(20) NOT NULL, `job` varchar(160) NOT NULL, `image` varchar(350) NOT NULL, `status` tinyint(1) NOT NULL, `created_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `job_enquiry` -- INSERT INTO `job_enquiry` (`id`, `email`, `name`, `mobile_number`, `job`, `image`, `status`, `created_on`) VALUES (1, 'dfg@dfg.com', 'praveen', '9876543210', 'test1', '1689686438_d7c55f1b9f7f4e50f4ce.pdf', 0, '2023-07-18 18:50:38'); -- -------------------------------------------------------- -- -- Table structure for table `job_opening` -- CREATE TABLE `job_opening` ( `id` int(11) NOT NULL, `title` varchar(260) NOT NULL, `image` varchar(260) NOT NULL, `description` longtext NOT NULL, `created_on` datetime NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `job_opening` -- INSERT INTO `job_opening` (`id`, `title`, `image`, `description`, `created_on`, `status`) VALUES (3, 'Business Manager', '1690550719_8832e400808c52443cc5.jpg', '

Skills Requirements:

Responsibilities

', '2023-07-19 00:00:00', 1); -- -------------------------------------------------------- -- -- Table structure for table `keywords` -- CREATE TABLE `keywords` ( `id` int(11) NOT NULL, `keyword` varchar(110) NOT NULL, `category_id` int(11) NOT NULL, `slug` varchar(250) NOT NULL, `image` varchar(250) NOT NULL, `position` int(11) NOT NULL, `created_on` datetime NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `keywords` -- INSERT INTO `keywords` (`id`, `keyword`, `category_id`, `slug`, `image`, `position`, `created_on`, `status`) VALUES (6, 'CARPENTER', 35, 'carpenter', '1688377178_21fc6e96b744897c20a2.jpg', 1, '2023-07-03 00:00:00', 1), (7, 'PLUMBING', 35, 'plumbing', '1688376887_21d0f7e6326a7f398316.jpg', 2, '2023-07-03 00:00:00', 1), (8, 'ELECTRICIAN', 35, 'electrician', '1688376956_09b6810d25f584287b2d.jpg', 3, '2023-07-03 00:00:00', 1), (9, 'INTERIOR', 36, 'interior', '1688377245_19171d378ba0aed0746f.jpg', 1, '2023-07-03 00:00:00', 1), (10, 'WEBSITE DESINGNER', 37, 'website-desingner', '1688377354_99e697d049d5cf535b6d.jpg', 1, '2023-07-03 00:00:00', 1), (11, 'AC SERVICES', 35, 'ac-services', '1688543489_694b6b1bd6561c5d5eeb.jpg', 4, '2023-07-05 00:00:00', 1), (12, 'WASHING MACHINE', 35, 'washing-machine', '1688543516_37f62560bcbe0e41d7e5.jpg', 5, '2023-07-05 00:00:00', 1), (13, 'REFRIGERATOR', 35, 'refrigerator', '1688543540_d1f5f5f5c75d8ef4af48.jpg', 6, '2023-07-05 00:00:00', 1), (14, 'WATER HEATER', 35, 'water-heater', '1688543555_66c0f8de42ce4bd81fbc.jpg', 7, '2023-07-05 00:00:00', 1), (15, 'CHIMNEY', 35, 'chimney', '1688543735_cf7d7f02693f9c62fa6f.jpg', 8, '2023-07-05 00:00:00', 1), (16, 'RO WATER', 35, 'ro-water', '1688544618_53a2bd9c5503b7776b73.jpg', 9, '2023-07-05 00:00:00', 1), (17, 'PEST CONTROL', 35, 'pest-control', '1688544634_e20d395be73f340f2a53.jpg', 10, '2023-07-05 00:00:00', 1), (18, 'WATER TANK', 35, 'water-tank', '1688544656_c31400df3c0f4ea10855.jpg', 11, '2023-07-05 00:00:00', 1), (19, 'TV SERVICES', 35, 'tv-services', '1688544669_60bf99807ce1c065071f.jpg', 12, '2023-07-05 00:00:00', 1), (20, 'WATER PROOFING', 36, 'water-proofing', '1688544728_0fcddb7f81ef19a2bd89.jpg', 2, '2023-07-05 00:00:00', 1), (21, 'CCTV', 36, 'cctv', '1688544741_636233314256dd637597.jpg', 3, '2023-07-05 00:00:00', 1), (22, 'SECURITY', 36, 'security', '1688544754_4eb6fdfa40f9ca1f96e5.jpg', 4, '2023-07-05 00:00:00', 1), (23, 'HOUSE CLEANING', 36, 'house-cleaning', '1688544776_ef0dc2977ff518f377e1.jpg', 5, '2023-07-05 00:00:00', 1), (24, 'CATERING', 36, 'catering', '1688544799_a8f8cdda03d1520690ce.jpg', 6, '2023-07-05 00:00:00', 1), (25, 'PHOTO GRAPHY', 36, 'photo-graphy', '1688544811_c5665d0f2e702f610b17.jpg', 7, '2023-07-05 00:00:00', 1), (26, 'VIDEO GRAPHY', 36, 'video-graphy', '1688544830_34f4d28337a7debe7e9b.jpg', 8, '2023-07-05 00:00:00', 1), (27, 'PAINTER', 36, 'painter', '1688544852_2cc907a06a70b2a099f7.jpg', 9, '2023-07-05 00:00:00', 1), (28, 'PACKER MOVERS', 36, 'packer-movers', '1688544884_0805aefb8d4cddefcc6d.jpg', 10, '2023-07-05 00:00:00', 1), (29, 'WEB DEVELOPMENT', 37, 'web-development', '1688544914_e026ef3305370458d083.jpg', 2, '2023-07-05 00:00:00', 1), (30, 'ANDROID APP DEVELOPMENT', 37, 'android-app-development', '1688544923_83c6109a85734920e0fd.jpg', 3, '2023-07-05 00:00:00', 1), (31, 'CONTENT WRITEING', 37, 'content-writeing', '1688544937_4901723a0765f3da1ce4.jpg', 4, '2023-07-05 00:00:00', 1), (32, '3D GRAPHIC', 37, '3d-graphic', '1688544949_565a7604128b3cd1fcba.jpg', 4, '2023-07-05 00:00:00', 1), (33, 'BULK SMS', 37, 'bulk-sms', '1688544958_bf11a5921f5d36463db9.jpg', 4, '2023-07-05 00:00:00', 1), (34, 'COMPANY REGISTRATION', 41, 'company-registration', '1688545075_1915aef590030676c0f0.jpg', 1, '2023-07-05 00:00:00', 1), (35, 'GST REGISTRATION', 41, 'gst-registration', '1688545113_8b0082ea83b02f827b75.jpg', 2, '2023-07-05 00:00:00', 1), (36, 'TRADE MARK REGISTERATION', 41, 'trade-mark-registeration', '1688545124_18773126cd0bcf0ae8f8.jpg', 3, '2023-07-05 00:00:00', 1), (37, 'TAX FILING', 41, 'tax-filing', '1688545135_81ed5df7bec1f4e181ce.jpg', 4, '2023-07-05 00:00:00', 1); -- -------------------------------------------------------- -- -- Table structure for table `notification` -- CREATE TABLE `notification` ( `id` int(11) NOT NULL, `vendor_id` int(11) NOT NULL, `notification` longtext NOT NULL, `image` varchar(250) NOT NULL, `status` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `notification` -- INSERT INTO `notification` (`id`, `vendor_id`, `notification`, `image`, `status`) VALUES (1, 42, 'test1', '1681552790_2258711c917ac79e766c.jpg', 1); -- -------------------------------------------------------- -- -- Table structure for table `order` -- CREATE TABLE `order` ( `id` int(11) NOT NULL, `order_id` int(11) NOT NULL, `customer_id` int(11) NOT NULL, `customer_name` varchar(260) NOT NULL, `commission` int(11) NOT NULL, `customer_email` varchar(160) NOT NULL, `customer_mobile` varchar(20) NOT NULL, `area` varchar(260) NOT NULL, `land_mark` varchar(250) NOT NULL, `city` varchar(160) NOT NULL, `house_no` varchar(20) NOT NULL, `pincode` varchar(10) NOT NULL, `delivery_charges` varchar(20) NOT NULL, `transport_amt` int(11) NOT NULL, `payment_mode` int(11) NOT NULL COMMENT '0=cod,1=online', `payment_status` int(11) NOT NULL COMMENT '0=pending,1=paid', `total_amount` int(11) NOT NULL, `payment_reference` varchar(250) NOT NULL, `deliveryboy_id` int(11) NOT NULL, `delivery_date` datetime NOT NULL, `delivery_status` int(11) NOT NULL, `invoice_type` varchar(250) NOT NULL, `discount` int(11) NOT NULL, `created_by` int(11) NOT NULL, `created_on` datetime NOT NULL, `updated_on` datetime NOT NULL, `status` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `order` -- INSERT INTO `order` (`id`, `order_id`, `customer_id`, `customer_name`, `commission`, `customer_email`, `customer_mobile`, `area`, `land_mark`, `city`, `house_no`, `pincode`, `delivery_charges`, `transport_amt`, `payment_mode`, `payment_status`, `total_amount`, `payment_reference`, `deliveryboy_id`, `delivery_date`, `delivery_status`, `invoice_type`, `discount`, `created_by`, `created_on`, `updated_on`, `status`) VALUES (269, 246, 19, 'saravana', 0, 'yesgleinfo@gmail.com', '9962516035', 'Kolathur - 600099', 'SRP colony Bus Stop', 'Chennai', '165, Paper Mills Roa', '600099', '10', 0, 1, 1, 20, 'Online', 0, '0000-00-00 00:00:00', 0, '', 0, 0, '2024-11-16 15:49:43', '0000-00-00 00:00:00', 0), (270, 247, 19, 'saravana', 0, 'yesgleinfo@gmail.com', '9962516035', 'Kolathur - 600099', 'SRP colony Bus Stop', 'Chennai', '165, Paper Mills Roa', '600099', '10', 0, 1, 1, 10, 'Online', 0, '0000-00-00 00:00:00', 0, '', 0, 0, '2024-11-16 15:49:46', '0000-00-00 00:00:00', 0); -- -------------------------------------------------------- -- -- Table structure for table `order_details` -- CREATE TABLE `order_details` ( `id` int(11) NOT NULL, `order_id` int(11) NOT NULL, `vendor_id` int(11) NOT NULL, `variant_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `variant_name` varchar(360) NOT NULL, `image` varchar(360) NOT NULL, `price` int(11) NOT NULL, `qty` int(11) NOT NULL, `m_price` int(11) NOT NULL, `commission` varchar(30) NOT NULL, `tax` int(11) NOT NULL, `created_on` datetime NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `order_details` -- INSERT INTO `order_details` (`id`, `order_id`, `vendor_id`, `variant_id`, `product_id`, `variant_name`, `image`, `price`, `qty`, `m_price`, `commission`, `tax`, `created_on`, `status`) VALUES (236, 269, 105, 166, 161, 'Aloevera Soap 100 gm', '1722061448_132c686c589b62a7eb5a.jpg', 10, 1, 99, '0', 10, '2024-11-16 15:49:43', 1); -- -------------------------------------------------------- -- -- Table structure for table `order_status_history` -- CREATE TABLE `order_status_history` ( `id` int(11) NOT NULL, `order_id` int(11) NOT NULL, `order_status` int(11) NOT NULL, `created_by` int(11) NOT NULL, `created_on` datetime NOT NULL, `order_status_desc` longtext NOT NULL, `order_notes` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `order_status_history` -- INSERT INTO `order_status_history` (`id`, `order_id`, `order_status`, `created_by`, `created_on`, `order_status_desc`, `order_notes`) VALUES (85, 269, 0, 0, '2024-11-16 15:49:43', '', ''), (86, 270, 0, 0, '2024-11-16 15:49:46', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `package` -- CREATE TABLE `package` ( `id` int(11) NOT NULL, `package` varchar(255) NOT NULL, `created_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `product_limit` int(11) NOT NULL COMMENT 'name="list limit"', `comm_per_order` int(11) NOT NULL, `duration` varchar(110) NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `package` -- INSERT INTO `package` (`id`, `package`, `created_on`, `product_limit`, `comm_per_order`, `duration`, `status`) VALUES (11, 'Trial Package', '2023-04-14 17:47:34', 50, 0, '15', 1), (12, 'Sliver', '2023-04-14 17:55:40', 100, 0, '180', 1), (13, 'Business', '2023-04-15 10:09:38', 250, 0, '362', 1); -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE `pages` ( `id` int(11) NOT NULL, `privacy_policy` longtext NOT NULL, `email` varchar(250) NOT NULL, `about_us` longtext NOT NULL, `mobile_number` varchar(20) NOT NULL, `twitter_link` varchar(250) NOT NULL, `ab_image` varchar(250) NOT NULL, `address` longtext NOT NULL, `company_name` varchar(250) NOT NULL, `terms_and_conditions` longtext NOT NULL, `location_map` longtext NOT NULL, `logo` varchar(360) NOT NULL, `favicon` varchar(250) NOT NULL, `meta_title` varchar(250) NOT NULL, `meta_key_words` varchar(250) NOT NULL, `whatsapp_number` varchar(20) NOT NULL, `facebook_iframe` longtext NOT NULL, `facebook_link` varchar(100) NOT NULL, `insta_link` varchar(100) NOT NULL, `youtube_link` varchar(100) NOT NULL, `site_url` varchar(250) NOT NULL, `news` longtext NOT NULL, `news_2` longtext NOT NULL, `news_3` longtext NOT NULL, `gst_number` varchar(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `pages` -- INSERT INTO `pages` (`id`, `privacy_policy`, `email`, `about_us`, `mobile_number`, `twitter_link`, `ab_image`, `address`, `company_name`, `terms_and_conditions`, `location_map`, `logo`, `favicon`, `meta_title`, `meta_key_words`, `whatsapp_number`, `facebook_iframe`, `facebook_link`, `insta_link`, `youtube_link`, `site_url`, `news`, `news_2`, `news_3`, `gst_number`) VALUES (1, '

Introduction

Privacy Policy

Last updated on May 30 2024 This privacy policy sets out how Yesgle Web Solutions uses and protects any information that you give Yesgle Web Solutions when you visit their website and/or agree to purchase from them. Yesgle Web Solutions is committed to ensuring that your privacy is protected. Should we ask you to provide certain information by which you can be identified when using this website, and then you can be assured that it will only be used in accordance with this privacy statement. Yesgle Web Solutions may change this policy from time to time by updating this page. You should check this page from time to time to ensure that you adhere to these changes. We may collect the following information: Name Contact information including email address Demographic information such as postcode, preferences and interests, if required Other information relevant to customer surveys and/or offers What we do with the information we gather We require this information to understand your needs and provide you with a better service, and in particular for the following reasons: Internal record keeping. We may use the information to improve our products and services. We may periodically send promotional emails about new products, special offers or other information which we think you may find interesting using the email address which you have provided. From time to time, we may also use your information to contact you for market research purposes. We may contact you by email, phone, fax or mail. We may use the information to customise the website according to your interests. We are committed to ensuring that your information is secure. In order to prevent unauthorised access or disclosure we have put in suitable measures. How we use cookies A cookie is a small file which asks permission to be placed on your computer\'s hard drive. Once you agree, the file is added and the cookie helps analyze web traffic or lets you know when you visit a particular site. Cookies allow web applications to respond to you as an individual. The web application can tailor its operations to your needs, likes and dislikes by gathering and remembering information about your preferences. We use traffic log cookies to identify which pages are being used. This helps us analyze data about webpage traffic and improve our website in order to tailor it to customer needs. We only use this information for statistical analysis purposes and then the data is removed from the system. Overall, cookies help us provide you with a better website, by enabling us to monitor which pages you find useful and which you do not. A cookie in no way gives us access to your computer or any information about you, other than the data you choose to share with us. You can choose to accept or decline cookies. Most web browsers automatically accept cookies, but you can usually modify your browser setting to decline cookies if you prefer. This may prevent you from taking full advantage of the website. Controlling your personal information You may choose to restrict the collection or use of your personal information in the following ways: whenever you are asked to fill in a form on the website, look for the box that you can click to indicate that you do not want the information to be used by anybody for direct marketing purposes if you have previously agreed to us using your personal information for direct marketing purposes, you may change your mind at any time by writing to or emailing us at yesglewebsolutions@gmail.com We will not sell, distribute or lease your personal information to third parties unless we have your permission or are required by law to do so. We may use your personal information to send you promotional information about third parties which we think you may find interesting if you tell us that you wish this to happen. 

Privacy Policy

This Privacy Policy details the manner in which Yesgle Web Solutions (“Yesgle Web Solutions/Us/Our/We”) collects, restores, deals and handles the end users’ (“You/Your/User”) information made available by the User as a result of such User’s access to and use services provided by Yesgle Web Solutions through Daysmart Platform (which term shall be deemed to include the internet and mobile website www.Daysmart .in as well as its mobile application).

Yesgle Web Solutions values the trust You place in it. That\'s why Yesgle Web Solutions insists upon the highest standards for secure transactions and customer information privacy on the Daysmart Platform. Please read the following statement to learn about Yesgle Web Solutions information gathering and dissemination practices.

The provisions of this Privacy Policy shall be deemed to be an integral part of and shall be read in conjunction with the T&C document (available here) and shall govern Your use of the services provided through Daysmart Platform. This Privacy Policy has been published by Yesgle Web Solutions pursuant to the applicable provisions of the Information Technology Act, 2000 as amended and the relevant rules made thereunder as applicable, and the amended provisions pertaining to electronic records in various statutes under applicable Indian laws.

Your use of the Daysmart Platform and the services provided thereunder shall be governed by this Privacy Policy as well as any other applicable policies published on this Daysmart Platform, including but not limited to the Privacy Policy. Your use of the In Daysmart ider Platform whether for the purpose of transacting through Daysmart Platform or otherwise, implies Your specific consent to the provisions of this Privacy Policy as well as other applicable policies, including but not limited to Yesgle Web Solutions use of the information provided by You for the purpose of Your use of this Daysmart Platform. Yesgle Web Solutions hereby reserves the right to modify, add or delete any part of this Privacy Policy without prior written notice/ intimation to You. It shall be Your sole responsibility to periodically review this Privacy Policy and all other applicable policies published on the Daysmart Platform for any revisions thereto. If You do not agree to the revisions made to this Privacy Policy by Yesgle Web Solutions, You must discontinue further access and use of the Daysmart Platform and the services provided thereunder. You agree and acknowledge that such discontinuance of access to and use of the Daysmart Platform and the services provided thereunder will render the Privacy Policy inapplicable from such date of discontinuance only; however this Privacy Policy will remain applicable to all instances of use by You of Daysmart Platform and the services provided thereunder prior to such date of discontinuance by You.

It is clarified that terms and conditions specific to an event shall be published on the event page accessible on the Daysmart Platform. In the event of any conflict between the event-related terms and conditions, and this Privacy Policy, User agrees that the terms of this Privacy Policy shall prevail and be binding on the User at all times.

By mere use of the Daysmart Platform, You expressly consent to Our use and disclosure of Your personal information in accordance with this Privacy Policy. This Privacy Policy is incorporated into and subject to the T&C.

COLLECTION OF PERSONALLY IDENTIFIABLE INFORMATION AND OTHER INFORMATION

When You use the Daysmart Platform, We collect and store Your personal information which is provided by You from time to time. Our primary goal in doing so is to provide you a safe, efficient, smooth and customized experience. This allows Us to provide services and features that most likely meet Your needs, and to customize Daysmart Platform to make Your experience safer and easier. More importantly, while doing so We may collect personal information from You that We consider necessary for achieving this purpose.

In general, You can browse the Daysmart Platform without telling Us who You are or revealing any personal information about Yourself. Once You give Us Your personal information, You are not anonymous to us. Where possible, We indicate which fields are required and which fields are optional. You always have the option to not provide information by choosing not to use a particular service or feature on the Ins Daysmart der Platform. We may automatically track certain information about You based upon Your behaviour on Our Daysmart Platforms. We use this information to do internal research on Our users\' demographics, interests, and behaviour to better understand, protect and serve Our users. This information is compiled and analysed on an aggregated basis. This information may include the URL that you just came from (whether this URL is on Daysmart Platform or not), which URL You next go to (whether this URL is on Our Daysmart Platform or not), Your computer browser information, and Your IP address.

We use data collection devices such as \"cookies\" on certain pages of Daysmart Platform to help analyse Our web page flow, measure promotional effectiveness, and promote trust and safety. \"Cookies\" are small files placed on Your hard drive that assist Us in providing Our services. We offer certain features that are only available through the use of a \"cookie\".

We also use cookies to allow You to enter Your password less frequently during a session. Cookies can also help Us provide information that is targeted to Your interests. Most cookies are \"session cookies,\" meaning that they are automatically deleted from Your hard drive at the end of a session. You are always free to decline Our cookies if Your browser permits, although in that case You may not be able to use certain features on Daysmart Platform and You may be required to re-enter Your password more frequently during a session.

Additionally, You may encounter \"cookies\" or other similar devices on certain pages of Daysmart Platform that are placed by third parties. We do not control the use of cookies by third parties.

If You choose to buy on Daysmart Platform, We collect information about Your buying behaviour.

If You transact with us, We collect some additional information, such as a billing address, a credit / debit card number and a credit / debit card expiration date and/ or other payment instrument details and tracking information from cheques or money orders.

If You choose to post messages on Our message boards, chat rooms or other message areas or leave feedback, We will collect that information You provide to us. We retain this information as necessary to resolve disputes, provide customer support and troubleshoot problems as permitted by law.

If You send Us personal correspondence, such as emails or letters, or if other users or third parties send Us correspondence about Your activities or postings on Daysmart Platform, We may collect such information into a file specific to you.

We collect personally identifiable information (email address, name, mobile number, credit card / debit card / other payment instrument details, etc.) from you when You set up a free account with us. While You can browse some sections of Our Daysmart Platform without being a registered member, certain activities (such as placing an order) do require registration. We do use Your contact information to send You offers based on Your previous orders and Your interests.

USE OF DEMOGRAPHIC / PROFILE DATA / YOUR INFORMATION

We use personal information to provide the services You request. To the extent possible, We use Your personal information to market to You or share information with certain other parties to market to You, We will provide You the ability to opt-out of such uses. We use Your personal information to resolve disputes; troubleshoot problems; help promote a safe service; collect money; measure consumer interest in Our products and services, inform You about online and offline offers, products, services, and updates; customize Your experience; detect and protect Us against error, fraud and other criminal activity; enforce our terms and conditions; and as otherwise described to You at the time of collection.

In Our efforts to continually improve Our product and service offerings, We collect and analyse demographic and profile data about Our users\' activity on Daysmart Platform.

We identify and use Your IP address to help diagnose problems with Our server, and to administer Daysmart Platform. Your IP address is also used to help identify you and to gather broad demographic information.

We may occasionally ask You to complete optional online surveys. These surveys may ask You for contact information and demographic information (like zip code, age, or income level). We use this data to tailor Your experience on the Daysmart Platform, providing You with content that We think You might be interested in and to display content according to Your preferences.

Cookies

A \"cookie\" is a small piece of information stored by a web server on a web browser so it can be later read back from that browser. Cookies are useful for enabling the browser to remember information specific to a given user. We place both permanent and temporary cookies in Your computer\'s hard drive. The cookies do not contain any of Your personally identifiable information.

SHARING OF PERSONAL INFORMATION

We may share personal information with our affiliates, the Event Organizer as well as the Event Organizer’s (as defined under the T&C, available here) affiliates for various purposes, including but not limited to help with the detection and prevention of identity theft, fraud and other potentially illegal acts; correlate related or multiple accounts to prevent abuse of Our services; to facilitate marketing and promotional activities. Unless you explicitly agree to these T&Cs at the time of booking a ticket to an Event (as defined under T&Cs), the Event Organizer and its affiliates may not market to You as a result of such sharing of personal information by You.

We may also disclose personal information if required to do so by law or in the good faith belief that such disclosure is reasonably necessary to respond to subpoenas, court orders, or other legal process. We may disclose personal information to law enforcement offices, third party rights owners, or others in the good faith belief that such disclosure is reasonably necessary to: enforce Our Terms and Conditions (“T&C”) or Privacy Policy; respond to claims that an advertisement, posting or other content violates the rights of a third party; or protect the rights, property or personal safety of Our users or the general public.

We and Our affiliates will also share / sell some or all of Your personal information with another business entity should We (or Our assets) plan to merge with, or be acquired by that business entity, or re-organization, amalgamation, restructuring of business. Should such a transaction occur that other business entity (or the new combined entity) will be required to follow this Privacy Policy with respect to Your personal information.

LINKS TO OTHER SITES

Daysmart Platforms link to other websites that may collect personally identifiable information about You. Paytm Daysmart is not responsible for the privacy practices or the content of those linked websites.

SECURITY PRECAUTIONS

Daysmart Platforms have stringent security measures in place to protect the loss, misuse, and alteration of the information under Our control. Whenever You change or access Your account information, We offer the use of a secure server. Once your information is in Our possession We adhere to strict security guidelines, protecting it against unauthorized access.

CHOICE/OPT-OUT

We provide all Users with the opportunity to opt-out of receiving non-essential (promotional, marketing-related) communications from Us on behalf of our partners, and from Us in general, after setting up an account.

If You want to remove Your contact information from all Paytm Daysmart lists and newsletters, please click on the unsubscribe links in the emailer

ACCOUNT DELETION

If You wish to delete Your account from the Daysmart Platform, please send a request from your registered email id to help@daysmart.in Your account will be deleted as soon as is reasonably possible within 5-7 working days and confirmation of deletion of your account will be sent to your registered email id.

Please note that, after Your account is deleted from the Daysmart Platform, You will be automatically unsubscribed from receiving any communication from Us. Furthermore, You will not be able to login into the Daysmart Platform from the same registered email id.

You may sign up and create a new account with the same email id and avail the benefits of Our platform. However, please note that once We have confirmed deletion of Your account, You will be unable to retrieve any of Your data or account information that was created using Your previous account. An account created using the same email id as used before, will be considered as a new account for the purposes of this privacy policy and Your transaction history associated with the previous account will not be accessible or retrievable by You.

Please note that if you access the Daysmart Platform using the social login plugin whereby You use the Daysmart Platform through a third-party website, such as for e.g., facebook or gmail, then if You wish to discontinue Your use of the Daysmart Platform, You are advised to open your personal account on the third-party website facilitating Your access and visit the section that allows You to change settings related to third party applications. Once there, You may remove authorization for the Daysmart Platform from such third-party website. Once You have removed such authorization, then Daysmart Platform will no longer be accessible by You through such a social login plugin, until you once again grant authorization.

After You delete Your account, we may retain information including Your transactions history which we are legally obligated to retain as per the applicable laws including the Information Technology (Intermediary Guidelines and Digital Media Ethics Code) Rules, 2021 read with Information Technology (Intermediaries guidelines) Rules, 2011, for the purposes of any legal or regulatory investigations.

ADVERTISEMENTS ON DAYS MART 

We use third-party advertising companies to serve ads when You visit Daysmart Platforms . These companies may use information (not including Your name, address, email address, or mobile number) about Your visits to Daysmart Platform and other websites in order to provide advertisements about goods and services of interest to You.

YOUR CONSENT

By using the Daysmart Platform and/ or by providing Your information, You consent to the collection and use of the information You disclose on Daysmart  Platform in accordance with this Privacy Policy, including but not limited to Your consent for sharing your information as per this Privacy Policy.

If We decide to change Our Privacy Policy, We will post those changes on this page so that You are always aware of what information We collect, how We use it, and under what circumstances We disclose it.


GRIVANCE OFFICER
If you believe that any information we are holding on you is incorrect or incomplete, please write to 16/30, School Road, Kolathur Chennai TAMIL NADU 600099 . or contact us at 93604 66662 or yesglewebsolutions@gmail.com as soon as possible. We will promptly correct any information found to be incorrect

', 'sales@daysmart.in', '
founded in 2009, is an ONE-STOP personalized corporate gift manufacturer of sublimation heat transfer products such as heat transfer mug, heat transfer magic mug, heat transfer puzzle, heat transfer t-shirt with high quality printing technologies.\r\n\r\nWe provide personalized gifts for corporate in small & bulk quantity. Besides heat transfer printing, we also doing digital printing for PVC ID cards and button badges. Personalized printing on each gift items are available too at additional charges. No MOQ is required.1111\r\n\r\nWe also expand our business line to provide more gift printing machines & equipments relevant to printing line. For details, please visit www.DIYPrintingSupply.com – Malaysia DIY Gift Printing Machineries Supply. We currently have business links in whole Malaysia / Singapore and enjoy an excellent reputation in the market. As a one-stop manufacturer of sublimation heat transfer corporate gift products, our happy & satisfied clients are Google, Tenaga Nasional Malaysia, Maybank, Petronas, Shell, GROUPON, BMW, KLCC etc. With us you can find those personalized gift services you want.
', '9360466662', 'twitter', '1687844132_d035bc5edb44e25b6116.jpeg', '16/30, School Road, Kolathur, Chennai, 600099', 'Days Mart', '

Terms and Conditions for Online Shopping of FMCG Products

1. Introduction

 Welcome to Daysmart hereinafter referred to as \"we,\" \"our,\" or \"us\"). By accessing and using our website www.daysmart.in hereinafter referred to as the \"daysmart\", you agree to comply with and be bound by these Terms and Conditions hereinafter referred to as \"T&C\". Please read these T&C carefully before using our Site.

 If you do not agree with any part of these T&C, please do not use our Site.

2. Account Registration

To make a purchase on daysmart.in, you may need to create an account. You agree to provide accurate, current, and complete information during the registration process and to update such information to keep it accurate, current, and complete.

You are responsible for maintaining the confidentiality of your account information, including your password, and for all activities that occur under your account.

3. Product Information

We strive to ensure that all product descriptions, images, and prices are accurate. However, we do not warrant that product descriptions or other content on our Site is error-free, complete, or current.

All products are subject to availability. We reserve the right to limit the quantity of products we supply, and we may revise pricing or availability without prior notice.

4. Orders and Payments

By placing an order through daysmart.in, you are making an offer to purchase the products you have selected. We reserve the right to accept or reject your order for any reason.

Payment must be made using the payment methods available on daysmart.in. All payments are subject to validation checks and authorization by your payment provider.

In the event of an error in processing your payment or if there are issues with the products, we will contact you as soon as possible.

5. Shipping and Delivery

We will make reasonable efforts to ensure timely delivery of your order. However, we do not guarantee delivery dates or times, and delays may occur due to unforeseen circumstances.

Shipping costs and delivery times are specified at checkout and may vary depending on the delivery address and the shipping method selected.

You are responsible for providing accurate delivery information. We are not liable for delays or delivery issues resulting from incorrect or incomplete information provided by you.

Orders are shipped and delivered through registered international courier companies and/or International speed post only. For domestic buyers, orders are shipped through registered domestic courier companies and /or speed post only. Orders are shipped within 0-7 days or as per the delivery date agreed at the time of order confirmation and delivering of the shipment subject to Courier Company / post office norms. Yesgle Web Solutions is not liable for any delay in delivery by the courier company / postal authorities and only guarantees to hand over the consignment to the courier company or postal authorities within 0-7 days rom the date of the order and payment or as per the delivery date agreed at the time of order confirmation.

Delivery of all orders will be to the address provided by the buyer. Delivery of our services will be confirmed on your mail ID as specified during registration. For any issues in utilizing our services you may contact our helpdesk on 9962516035 or yesglewebsolutions@gmail.com Delivery time line will be 2 to 3 Worrking days.

6. Returns and Refunds

Our return policy is outlined on our Site. Generally, you may return products within of receipt for a refund or exchange, provided that they are in their original condition and packaging.

Refunds will be processed using the same payment method used for the original purchase. We reserve the right to deduct any shipping costs or restocking fees from the refund amount. Return not Accepted


In case You have made the payment but failed to receive any email and confirmation, then chances are that such a payment has failed. Once we have confirmed a failed order, we process refunds on our own. While we process such refunds within 3-5 days, it may take up to 7-10 working days (and sometimes more) for your financial institution to credit the amount back to your account.

7. User Conduct

You agree to use our Site for lawful purposes and in a manner that does not infringe on the rights of others or restrict their use of the Site.

You agree not to engage in any conduct that could damage, disable, or impair our Site or interfere with any other party’s use of the Site.

8. Intellectual Property

All content on our Site, including text, graphics, logos, and images, is the property of [Your Company Name] or its licensors and is protected by intellectual property laws.

You may not reproduce, distribute, or create derivative works from any content on our Site without our express written permission.

9. Limitation of Liability

To the fullest extent permitted by law, Yesgle Web Solutions shall not be liable for any indirect, incidental, consequential, or punitive damages arising from or related to your use of our Site or products.

Our liability for any claim arising out of your use of our Site or products shall be limited to the amount paid for the products in question.

10. Governing Law

These T&C shall be governed by and construed in accordance with the laws of [Your Jurisdiction].

Any disputes arising from or related to these T&C shall be resolved in the courts of [Your Jurisdiction].

11. Changes to Terms and Conditions

We reserve the right to update or modify these T&C at any time. Any changes will be posted on our Site, and your continued use of the Site following the posting of any changes constitutes your acceptance of those changes.

Contact Information

Contact Us Last updated on May 30 2024 You may contact us using the information below: Merchant Legal entity name: Yesgle Web Solutions Registered Address: 16/30, School Road, Kolathur Chennai TAMIL NADU 600099 Operational Address: 16/30, School Road, Kolathur Chennai TAMIL NADU 600099 Telephone No: 9962516035 E-Mail ID: yesglewebsolutions@gmail.com.

DELIVERY POLICY

Email confirmation: Your booking confirmation will be sent via an email. This confirmation needs to be printed and shown at the Enquiry or Lead or Products counter to get a physical Enquiry or Lead or Products , if entry to the Event in respect of which such Enquiry or Lead or Products has been booked is subject to presentation of a physical Enquiry or Lead or Products. Delivery Time Line Will Be 2 to 3 Working days..

Physical Enquiry or Lead or Products : n case of physical Enquiry or Lead or Products , we will deliver them to Your address confirmed and provided by You on Yesgle Platform. In case the Enquiry or Lead or Products  are returned to the origin, then Yesgle Web Solutions will refund the delivery charges. However, delivery charges will not be refunded for any reasons beyond Yesgle Web Solutions or its delivery partner’s control, including but not limited to your premises being closed at the time of delivery or in case you have provided an incorrect address. It is Your responsibility to ensure that delivery is taken at the address provided by You. It is also Your responsibility to ensure that You keep your delivery address updated to the one where You can ensure delivery is taken.

Enquiry or Lead or Products Pick-Up: If at the time of purchasing physicalEnquiry or Lead or Products , You choose to pick-up Enquiry or Lead or Products from a designated location, then the pick-up details shall be intimated to You on the purchase email containing details of your purchase. You can only pick-up the physical Enquiry or Lead or Products  during the pick-up window from the location or address specified in the email and/or SMS confirmation.

It is clarified that if you have chosen the delivery option, then the Enquiry or Lead or Products redemption shall not be available at the box-office at the Events venue. We will not be able to fulfil Your requests for issuing a duplicate Enquiry or Lead or Products  or issuing an e-Enquiry or Lead or Products  as a replacement. Therefore, its highly important for You to ensure that You pick up the Enquiry or Lead or Products during the pick-up window. It is Your responsibility to periodically check your notifications that shall be sent to You at the start of and during the pick-up window

In all of the above options, You will need to produce the credit or debit card used to purchase the Enquiry or Lead or Products for picking up the Enquiry or Lead or Products at the venue. If the card user is not picking up the Enquiry or Lead or Products  herself/himself, an authorisation with the photocopy of this card signed by the cardholder needs to be produced. The signature on the card will be matched against the one used for authorisation.

Damage: You shall be solely responsible for any damage, loss, destruction, mutilation or wastage of a physical Enquiry or Lead or Products which occurs for any reason except those related to packaging issues. If You received a damaged Enquiry or Lead or Products due to packaging issues, please do not take delivery of the physical Enquiry or Lead or Products  and instead hand it back to the delivery supplier. Accepting delivery shall exempt Yesgle Web Solutions from all liability for damage to physical Enquiry or Lead or Products  arising because of packaging issues and Yesgle Web Solutions shall not be responsible to compensate You for such damage or provide You a replacement Enquiry or Lead or Products  We will not be able to help You redeem the physical Enquiry or Lead or Products  if the barcode/qr code is not scannable. In such situations, You will be required to purchase another new Enquiry or Lead or Products  (s) to get access to the.

Refund Policy

In case You have made the payment but failed to receive any email and confirmation, then chances are that such a payment has failed. Once we have confirmed a failed order, we process refunds on our own. While we process such refunds within 3-5 days, it may take up to 7-10 working days (and sometimes more) for your financial institution to credit the amount back to your account.

Yesgle reserves the right to deny refunds for Enquiry or Lead or Products purchased outside of Yesgle Platform. Any decisions taken by the event organiser and Yesgle management will be final and binding in this regard. If you find that you have been issued fake Enquiry or Lead or Products not authorized by us, then you may be a victim of fraud, for which you may consider filing appropriate police complaints/first information report at the nearest police station having jurisdiction over the area of your residence. We bear no responsibility or liability, under any law or circumstances, for such frauds committed by unauthorized third parties. 

Return policy

Once the product is delivered, customer can raise the return request within 2 to 3 days


', '', '1721876817_0251aea644fe9d8baec7.jpg', '1721876817_9cec163354e0d7cde6a6.png', 'Welcome To days home care', '[\"Welcome To Days home care 35+ FMCG PRODUCTS\"]', '9047111871', '', '2023-07-04 18:07:08', 1), (2, 116, '', '2023-07-04 18:07:08', 1), (3, 116, '', '2023-07-04 18:07:08', 1); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int(11) NOT NULL, `vendor_prefix` varchar(10) NOT NULL, `vendor_suffix` int(11) NOT NULL, `pdm_prefix` varchar(110) NOT NULL, `pdm_suffix` int(11) NOT NULL, `emp_prefix` varchar(11) NOT NULL, `emp_suffix` int(11) NOT NULL, `product_prefix` varchar(11) NOT NULL, `product_code` int(11) NOT NULL, `payment_key` int(11) NOT NULL, `payment_icon` varchar(250) NOT NULL, `name` varchar(250) NOT NULL, `order_id` int(100) NOT NULL, `email` varchar(110) NOT NULL, `web_site` varchar(100) NOT NULL, `mobile` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `vendor_prefix`, `vendor_suffix`, `pdm_prefix`, `pdm_suffix`, `emp_prefix`, `emp_suffix`, `product_prefix`, `product_code`, `payment_key`, `payment_icon`, `name`, `order_id`, `email`, `web_site`, `mobile`) VALUES (2, 'DAI', 120, 'PDM', 100, 'EMP', 100, 'POD', 335, 0, '', 'daysmart', 248, 'services@daysmart.in', 'https://daysmart.in/', 0); -- -------------------------------------------------------- -- -- Table structure for table `shop_timing` -- CREATE TABLE `shop_timing` ( `id` int(11) NOT NULL, `vendor_id` int(11) NOT NULL, `day` varchar(100) NOT NULL, `open_time` varchar(160) NOT NULL, `close_time` varchar(160) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `shop_timing` -- INSERT INTO `shop_timing` (`id`, `vendor_id`, `day`, `open_time`, `close_time`) VALUES (1, 105, 'Sunday', '---', '---'), (2, 105, 'Monday', '9:30 am', '7:30 pm'), (3, 105, 'Tuesday', '9:30 am', '7:30 pm'), (4, 105, 'Wednesday', '9:30 am', '7:30 pm'), (5, 105, 'Thursday', '9:30 am', '7:30 pm'), (6, 105, 'Friday', '9:30 am', '7:30 pm'), (7, 105, 'Saturday', '9:30 am', '7:30 pm'); -- -------------------------------------------------------- -- -- Table structure for table `slider` -- CREATE TABLE `slider` ( `id` int(11) NOT NULL, `vendor_id` int(11) NOT NULL, `slider` varchar(260) NOT NULL, `image` varchar(350) NOT NULL, `category_type` int(11) NOT NULL, `created_on` datetime NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `slider` -- INSERT INTO `slider` (`id`, `vendor_id`, `slider`, `image`, `category_type`, `created_on`, `status`) VALUES (15, 105, '1', '1723605989_6ec47f011b0a505c02d0.jpg', 0, '2023-07-13 11:31:19', 1), (16, 105, '2', '1730953381_d37a7d9507daa6478724.jpg', 0, '2023-07-13 11:31:24', 1); -- -------------------------------------------------------- -- -- Table structure for table `status_list` -- CREATE TABLE `status_list` ( `1` int(11) NOT NULL, `state_id` int(11) NOT NULL, `status` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `status_list` -- INSERT INTO `status_list` (`1`, `state_id`, `status`) VALUES (1, 0, 'Order Placed'), (2, 1, 'Processing'), (3, 7, 'Dispatch'), (4, 4, 'Delivered'), (5, 6, 'Cancelled'); -- -------------------------------------------------------- -- -- Table structure for table `subcategory` -- CREATE TABLE `subcategory` ( `id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `parent_category` int(11) NOT NULL, `subcategory_name` varchar(255) NOT NULL, `slug` varchar(250) NOT NULL, `vendor_id` int(11) NOT NULL, `image` varchar(250) NOT NULL, `created_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `subcategory` -- INSERT INTO `subcategory` (`id`, `category_id`, `parent_category`, `subcategory_name`, `slug`, `vendor_id`, `image`, `created_on`, `updated_on`, `status`) VALUES (45, 39, 0, 'Health Mix', 'health-mix', 105, '1689219326_34f31134b9f20a866db1.jpg', '2023-07-13 00:00:00', '2023-07-13 09:05:26', 1), (46, 39, 0, 'Instant Coffee', 'instant-coffee', 105, '1689219340_e033bfe64594df20d56d.jpg', '2023-07-13 00:00:00', '2023-07-13 09:05:40', 1), (47, 39, 0, 'Rose Instant Mix', 'rose-instant-mix', 105, '1689219351_50ac0e0dee1ba2d9795c.jpg', '2023-07-13 00:00:00', '2023-07-13 09:05:51', 1), (48, 39, 0, 'Pista Instant Mix', 'pista-instant-mix', 105, '1689219361_316014cb445b8cdedc90.jpg', '2023-07-13 00:00:00', '2023-07-13 09:06:01', 1), (49, 39, 0, 'Chocolate Instant Mix', 'chocolate-instant-mix', 105, '1689219378_13cccb773d042004f093.jpg', '2023-07-13 00:00:00', '2023-07-13 09:06:18', 1), (50, 39, 0, 'Badam Instant Mix', 'badam-instant-mix', 105, '1689219392_c7a83a2ccac73d9ab643.jpg', '2023-07-13 00:00:00', '2023-07-13 09:06:32', 1), (51, 20, 0, 'Detergent Liquid', 'detergent-liquid', 105, '1689222008_14e16f22b5a33b24e233.jpg', '2023-07-13 00:00:00', '2023-07-13 09:50:08', 1), (52, 20, 0, 'Dish Wash Liquid', 'dish-wash-liquid', 105, '1689222036_e567d3e0902574864cda.jpg', '2023-07-13 00:00:00', '2023-07-13 09:50:36', 1), (53, 20, 0, 'Floor Cleaner', 'floor-cleaner', 105, '1689222045_1079e46fb0b416aed5d7.jpg', '2023-07-13 00:00:00', '2023-07-13 09:50:45', 1), (54, 20, 0, 'Multi Cleaner', 'multi-cleaner', 105, '1689222055_0b0ab48605f709d6c221.jpg', '2023-07-13 00:00:00', '2023-07-13 09:50:55', 1), (55, 20, 0, 'Hand Wash Liquid', 'hand-wash-liquid', 105, '1689222064_22fd018f7cd4b3f0fed8.jpg', '2023-07-13 00:00:00', '2023-07-13 09:51:04', 1), (56, 20, 0, 'Fabric Conditioner', 'fabric-conditioner', 105, '1689222080_5fe06f1ff384843ab350.jpg', '2023-07-13 00:00:00', '2023-07-13 09:51:20', 1), (57, 17, 0, 'Aloevera Soap', 'aloevera-soap', 105, '1689222103_2ee5b23ce0013f53bcf1.jpg', '2023-07-13 00:00:00', '2023-07-13 09:51:43', 1), (58, 17, 0, 'Charcoal Soap', 'charcoal-soap', 105, '1689222113_1b3a2f1d37b01d97fb08.jpg', '2023-07-13 00:00:00', '2023-07-13 09:51:53', 1), (59, 17, 0, 'Neem Soap', 'neem-soap', 105, '1689222123_cfcf8601b803da64476a.jpg', '2023-07-13 00:00:00', '2023-07-13 09:52:03', 1), (60, 17, 0, 'Menthol Soap', 'menthol-soap', 105, '1689222133_3457a88381cbc56a21ed.jpg', '2023-07-13 00:00:00', '2023-07-13 09:52:13', 1), (61, 17, 0, 'Papaya Soap', 'papaya-soap', 105, '1689222146_a83ec700e943109b4f70.jpg', '2023-07-13 00:00:00', '2023-07-13 09:52:26', 1), (62, 17, 0, 'Goat Milk Soap', 'goat-milk-soap', 105, '1689222155_203ce13fcb94b5f12a5a.jpg', '2023-07-13 00:00:00', '2023-07-13 09:52:35', 1), (63, 17, 0, 'Red Wine Soap', 'red-wine-soap', 105, '1689222164_3f38a622f1d8dc707781.jpg', '2023-07-13 00:00:00', '2023-07-13 09:52:44', 1), (64, 18, 0, 'Hair Oil', 'hair-oil', 105, '1689222194_d866ce855cab6a84f376.jpg', '2023-07-13 00:00:00', '2023-07-13 09:53:14', 1), (65, 20, 0, 'Toilet Cleaner', 'toilet-cleaner', 105, '1689223280_cdec6bae033d457cc675.jpg', '2023-07-13 00:00:00', '2023-07-13 10:11:20', 1), (66, 39, 0, 'Tomato Sauce', 'tomato-sauce', 105, '1689753966_1584fff750fd507766a6.jpg', '2023-07-19 00:00:00', '2023-07-19 13:36:06', 1), (67, 39, 0, 'Green Chilli Sauce', 'green-chilli-sauce', 105, '1689753986_aecc1f5575a519e2e1da.jpg', '2023-07-19 00:00:00', '2023-07-19 13:36:26', 1), (68, 39, 0, 'Soya Sauce', 'soya-sauce', 105, '1689754012_26bb76c26e81cb62d44d.jpg', '2023-07-19 00:00:00', '2023-07-19 13:36:52', 1), (69, 40, 0, 'Seed Vinayagar', 'seed-vinayagar', 105, '1694076108_42291066a3252480457a.jpg', '2023-09-07 00:00:00', '2023-09-07 14:11:48', 0), (70, 38, 0, 'Groundnut Round Burfi', 'groundnut-round-burfi', 105, '1721877866_2b5f448832dcdae8365f.jpg', '2024-07-25 00:00:00', '2024-07-25 08:54:26', 1), (71, 38, 0, 'Groundnut Burfi', 'groundnut-burfi', 105, '1721877881_7e95bc8b865961750ab1.jpg', '2024-07-25 00:00:00', '2024-07-25 08:54:41', 1), (72, 38, 0, 'Groundnut Nice Burfi', 'groundnut-nice-burfi', 105, '1721877892_0c83640bc29471836127.jpg', '2024-07-25 00:00:00', '2024-07-25 08:54:52', 1), (73, 38, 0, 'Sesame Round Black', 'sesame-round-black', 105, '1721877916_f4051a0fd45a136793bf.jpg', '2024-07-25 00:00:00', '2024-07-25 08:55:16', 1), (74, 38, 0, 'Sesame Round White', 'sesame-round-white', 105, '1721877927_be42f03a94e6f5c31aa1.jpg', '2024-07-25 00:00:00', '2024-07-25 08:55:27', 1), (75, 38, 0, 'Gram Ball', 'gram-ball', 105, '1721877943_d813d6899f88176f3f31.jpg', '2024-07-25 00:00:00', '2024-07-25 08:55:43', 1), (76, 18, 0, 'Onion Hair Oil', 'onion-hair-oil', 105, '1721966404_cbec3fe72322f95e2402.jpg', '2024-07-26 00:00:00', '2024-07-26 09:30:05', 1), (77, 18, 0, 'Sanitary Napkin', 'sanitary-napkin', 105, '1722057505_6c198171c481609990c3.jpg', '2024-07-27 00:00:00', '2024-07-27 10:48:25', 0), (78, 39, 0, 'Nattu Sakarai', 'nattu-sakarai', 105, '1722058127_06ddab34c4dce866fecb.jpg', '2024-07-27 00:00:00', '2024-07-27 10:58:47', 1), (79, 40, 0, 'Sambar Powder', 'sambar-powder', 105, '1722058409_94144fe939a23ab5bb5a.jpg', '2024-07-27 00:00:00', '2024-07-27 11:03:29', 1), (80, 40, 0, 'Rasam Powder', 'rasam-powder', 105, '1722058424_a805bf0b2a20cdac1378.jpg', '2024-07-27 00:00:00', '2024-07-27 11:03:44', 1), (81, 40, 0, 'Trimeric Masala Powder', 'trimeric-masala-powder', 105, '1722058439_d85626b1c70d68aa85c8.jpg', '2024-07-27 00:00:00', '2024-07-27 11:03:59', 1), (82, 40, 0, 'Chicken Masala Powder', 'chicken-masala-powder', 105, '1722058450_ee566a7037f4f5988b9f.jpg', '2024-07-27 00:00:00', '2024-07-27 11:04:10', 1), (83, 40, 0, 'Briyani Masala Powder', 'briyani-masala-powder', 105, '1722058461_423360506944728cb7e4.jpg', '2024-07-27 00:00:00', '2024-07-27 11:04:21', 1), (84, 40, 0, 'Pepper Masala Powder', 'pepper-masala-powder', 105, '1722058473_579cf39968b18defe592.jpg', '2024-07-27 00:00:00', '2024-07-27 11:04:33', 1), (85, 41, 0, 'Blueberry', 'blueberry', 105, '1722059030_94e78bc2e4e140427487.jpg', '2024-07-27 00:00:00', '2024-07-27 11:13:50', 1), (86, 41, 0, 'Rose Panner', 'rose-panner', 105, '1722059045_94016e158e919f41b524.jpg', '2024-07-27 00:00:00', '2024-07-27 11:14:05', 1), (87, 41, 0, 'Strawberry', 'strawberry', 105, '1722059064_7c99c6209a42c31fa792.jpg', '2024-07-27 00:00:00', '2024-07-27 11:14:24', 1), (88, 41, 0, 'Organge', 'organge', 105, '1722059079_e1c10f46af219cad5f98.jpg', '2024-07-27 00:00:00', '2024-07-27 11:14:39', 1), (89, 41, 0, 'Lemon', 'lemon', 105, '1722059095_8593a9459356e41969a6.jpg', '2024-07-27 00:00:00', '2024-07-27 11:14:55', 1), (90, 41, 0, 'Pineapple', 'pineapple', 105, '1722059118_03163bf112d8fa5dfb5f.jpg', '2024-07-27 00:00:00', '2024-07-27 11:15:18', 1), (91, 41, 0, 'Nannari', 'nannari', 105, '1722059133_52f9c89e694e85263e6d.jpg', '2024-07-27 00:00:00', '2024-07-27 11:15:33', 1), (92, 41, 0, 'Jera Masala', 'jera-masala', 105, '1722059145_038fca9bb4073199efae.jpg', '2024-07-27 00:00:00', '2024-07-27 11:15:45', 1), (93, 42, 0, 'Vegetables', 'vegetables', 105, '1723631833_d2aa25d184eaf24a8bcd.jpg', '2024-08-14 00:00:00', '2024-08-14 16:07:13', 1), (94, 42, 0, 'Keerai', 'keerai', 105, '1723631975_deae977a4b32ce292bec.jpg', '2024-08-14 00:00:00', '2024-08-14 16:09:35', 1); -- -------------------------------------------------------- -- -- Table structure for table `sub_subcategory` -- CREATE TABLE `sub_subcategory` ( `id` int(11) NOT NULL, `subcategory_id` int(11) NOT NULL, `category_name` varchar(260) NOT NULL, `status` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `sub_subcategory` -- INSERT INTO `sub_subcategory` (`id`, `subcategory_id`, `category_name`, `status`) VALUES (7, 9, 'test.test1', 1), (8, 9, 'test', 1), (9, 9, 'test', 1), (10, 16, 'test', 1); -- -------------------------------------------------------- -- -- Table structure for table `tag` -- CREATE TABLE `tag` ( `id` int(11) NOT NULL, `tag` varchar(260) NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tax` -- CREATE TABLE `tax` ( `id` int(11) NOT NULL, `tax` int(11) NOT NULL, `created_on` datetime NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tax` -- INSERT INTO `tax` (`id`, `tax`, `created_on`, `status`) VALUES (1, 10, '2023-05-17 00:00:00', 1), (2, 15, '2023-05-17 00:00:00', 1), (3, 5, '2023-05-23 00:00:00', 1), (4, 12, '2023-07-13 00:00:00', 1), (5, 18, '2023-07-13 00:00:00', 1), (6, 8, '2023-07-13 00:00:00', 1), (7, 1, '2024-07-27 00:00:00', 1), (8, 0, '2024-08-14 00:00:00', 1); -- -------------------------------------------------------- -- -- Table structure for table `template` -- CREATE TABLE `template` ( `user_id` int(11) NOT NULL, `template` varchar(255) DEFAULT NULL, `email` longtext NOT NULL, `sms_enabled` tinyint(1) NOT NULL, `email_enabled` int(11) NOT NULL, `sms` text NOT NULL, `email_subject` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `template` -- INSERT INTO `template` (`user_id`, `template`, `email`, `sms_enabled`, `email_enabled`, `sms`, `email_subject`) VALUES (3, 'Out for Delivery', '
\"Image\"

Order Processing

Dear {customerName},
Your Order #{orderId} is Processing

\"Image\"

Thanks,
Sales Team

Copyrights All Rights Reserved Tree Of Life



treeoflife.com

\"Facebook\"\"Twitter\"\"Instagram\"
', 0, 0, 'Dear {customerName},Your Tree Of Life order #{orderId} is Out for Delivery.', 'Your order Out for Delivery'), (2, 'order_placed', '\n\n\n\n\n\n \n \n \n \n
\n \n
\n
\n
\n
\n
\n
\n
\n \n \n \n \n \n \n
\n \n \n \n \n \n \n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n \"Image\" \n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

New Enquiry

\n
\n
\n
\n
\n

product Name :- {product},

\n
\n
\n
\n
\n
\n
\n
\n
\n

Copyrights All Rights Reserved {c_name}



{c_name}

', 1, 1, 'Dear {customerName},Your Tree Of Life order #{orderId} placed successfully.', 'Your Enquiry Send Successfully!'), (125, 'order_success', '\n\n\n\n\n\n \n \n \n \n
\n \n
\n
\n
\n
\n
\n
\n
\n \n \n \n \n \n \n
\n \n \n \n \n \n \n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n \"Image\" \n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

New Order

\n
\n
\n
\n
\n

product Name :- {customerName},

\n

Order Id :- {orderId},

\n

{content}

\n
\n
\n
\n
\n
\n
\n
\n
\n

Copyrights All Rights Reserved {c_name}



{c_name}

', 0, 1, '', 'Your Order Successfully!'); INSERT INTO `template` (`user_id`, `template`, `email`, `sms_enabled`, `email_enabled`, `sms`, `email_subject`) VALUES (1, 'enquiry', '\n\n\n\n\n\n \n \n \n \n
\n \n
\n
\n
\n
\n
\n
\n
\n \n \n \n \n \n \n
\n \n \n \n \n \n \n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n \"Image\" \n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

New Enquiry

\n
\n
\n
\n
\n

Customer Name :- {name},

\n

Mobile Number :- {mobile},

\n \n

Product Name :-   {product}

\n
\n
\n
\n
\n
\n
\n
\n
\n

Copyrights All Rights Reserved {c_name}



{c_name}

', 1, 1, 'Dear {customerName},Your Tree Of LIfe Register {otp} .', 'New Order'), (124, 'contact', '\n\n\n\n\n\n \n \n \n \n
\n \n
\n
\n
\n
\n
\n
\n
\n \n \n \n \n \n \n
\n \n \n \n \n \n \n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n \"Image\" \n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

New Enquiry

\n
\n
\n
\n
\n

Customer Name :- {name},

\n

Mobile Number :- {mobile},

\n

Subject :- {subject},

\n

Message :-   {message}

\n
\n
\n
\n
\n
\n
\n
\n
\n

Copyrights All Rights Reserved {c_name}



{c_name}

', 0, 1, '', 'New Enquiry '); -- -------------------------------------------------------- -- -- Table structure for table `transport_charges` -- CREATE TABLE `transport_charges` ( `id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `vendor_id` int(11) NOT NULL, `product_v_id` int(11) NOT NULL, `charge` int(11) NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `type` -- CREATE TABLE `type` ( `id` int(11) NOT NULL, `category_id` int(11) DEFAULT NULL, `type` varchar(260) NOT NULL, `created_on` datetime NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `type` -- INSERT INTO `type` (`id`, `category_id`, `type`, `created_on`, `status`) VALUES (2, NULL, 'Kg', '2023-05-18 19:01:20', 1), (3, NULL, 'Ltr', '2023-05-23 18:34:08', 1), (4, NULL, 'Grm', '2023-05-26 14:58:04', 1), (5, NULL, 'ML', '2023-05-26 14:58:12', 1), (6, NULL, 'Pic', '2023-05-26 14:58:17', 1), (7, NULL, 'Nos', '2023-05-26 14:58:28', 1), (8, NULL, 'Inch', '2023-06-23 16:20:38', 1), (9, NULL, 'Ton', '2023-06-23 16:56:19', 1), (10, NULL, 'W', '2023-06-23 18:03:53', 1), (11, NULL, 'MM', '2023-06-23 18:41:37', 1), (12, NULL, 'Pad', '2024-07-27 10:55:05', 1); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `user_id` int(11) NOT NULL, `user_group` int(11) NOT NULL COMMENT '1=admin,2=vendor,3=employee,4=pdm', `package_id` int(11) DEFAULT NULL, `register_id` varchar(280) NOT NULL, `email` varchar(100) NOT NULL, `mobile` varchar(100) NOT NULL, `username` varchar(50) NOT NULL, `password` varchar(50) NOT NULL, `photo` varchar(260) NOT NULL, `address` longtext NOT NULL, `city_id` int(11) DEFAULT NULL, `area_id` int(11) DEFAULT NULL, `category_id` int(11) DEFAULT NULL, `refer_commssion` int(11) NOT NULL, `salary` int(11) NOT NULL, `shop_name` varchar(350) NOT NULL, `ot_amount` int(11) NOT NULL, `emp_prefix` varchar(11) NOT NULL, `emp_suffix` int(11) NOT NULL, `proof1` varchar(250) NOT NULL, `proof2` varchar(260) NOT NULL, `proof3` varchar(260) NOT NULL, `show_type` int(11) NOT NULL, `payment_option` varchar(110) NOT NULL, `advance_pay` int(11) NOT NULL, `advance_amount` int(11) NOT NULL, `url` varchar(250) NOT NULL, `gst_number` varchar(250) NOT NULL, `min_order_amount` int(11) NOT NULL, `min_delivery_time` varchar(110) NOT NULL, `delivery_charges` int(11) NOT NULL, `about_us` longtext NOT NULL, `location_map` longtext NOT NULL, `category_type` mediumtext NOT NULL, `verified` int(11) NOT NULL, `created_on` datetime NOT NULL, `created_by` int(11) NOT NULL, `status` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `user` -- INSERT INTO `user` (`user_id`, `user_group`, `package_id`, `register_id`, `email`, `mobile`, `username`, `password`, `photo`, `address`, `city_id`, `area_id`, `category_id`, `refer_commssion`, `salary`, `shop_name`, `ot_amount`, `emp_prefix`, `emp_suffix`, `proof1`, `proof2`, `proof3`, `show_type`, `payment_option`, `advance_pay`, `advance_amount`, `url`, `gst_number`, `min_order_amount`, `min_delivery_time`, `delivery_charges`, `about_us`, `location_map`, `category_type`, `verified`, `created_on`, `created_by`, `status`) VALUES (1, 1, NULL, 'admin@daysmart.in', 'admin@gmail.com', '9962516035', 'admin@daysmart.in', '260812!234', '', '', NULL, NULL, NULL, 0, 0, '', 0, '', 0, '', '', '', 0, '', 0, 0, '', '', 0, '', 0, '', '', '0', 0, '2022-12-05 00:00:00', 0, 1), (105, 2, 13, 'DAI104', 'Daysmartdotin@gmail.com', '9962516035', 'Saravana Kumar', '260812', '', 'No 165, Paper Mills Road , SRP Colony, Kolathur,\r\nChennai - 600099,', 2, 2, NULL, 0, 0, 'Daysmart', 0, 'DHC', 100, '1722224198_10bce5a197db4d61f89e.jpg', '1722224198_7d63960f985cf9f02b0c.jpg', '1722224198_ad4757ec382d7c5cb27e.jpg', 1, '[\"0\",\"1\"]', 1, 100, 'daysmart.in', '', 10, '60 Min', 10, 'test1', '', '0', 0, '2023-05-24 16:30:05', 1, 1), (106, 3, NULL, 'counter', 'pk123@gdfg.com', '2132132312', 'counter', 'counter', '', '', NULL, NULL, NULL, 0, 0, '', 0, '', 0, '', '', '', 0, '', 0, 0, '', '', 0, '', 0, '', '', '', 0, '2023-07-28 18:32:42', 0, 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `ads` -- ALTER TABLE `ads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `area` -- ALTER TABLE `area` ADD PRIMARY KEY (`id`), ADD KEY `city_delete_id` (`city_id`); -- -- Indexes for table `calls` -- ALTER TABLE `calls` ADD PRIMARY KEY (`id`), ADD KEY `created_by` (`created_by`); -- -- Indexes for table `cart` -- ALTER TABLE `cart` ADD PRIMARY KEY (`id`), ADD KEY `variant_id` (`variant_id`); -- -- Indexes for table `category` -- ALTER TABLE `category` ADD PRIMARY KEY (`id`), ADD KEY `category_type` (`category_type`); -- -- Indexes for table `category_type` -- ALTER TABLE `category_type` ADD PRIMARY KEY (`id`); -- -- Indexes for table `city` -- ALTER TABLE `city` ADD PRIMARY KEY (`id`); -- -- Indexes for table `commission` -- ALTER TABLE `commission` ADD PRIMARY KEY (`id`); -- -- Indexes for table `commission_slab` -- ALTER TABLE `commission_slab` ADD PRIMARY KEY (`id`), ADD KEY `cat_id` (`cat_id`) USING BTREE, ADD KEY `comm_id` (`comm_id`) USING BTREE, ADD KEY `vendor_id` (`vendor_id`) USING BTREE; -- -- Indexes for table `contact_us` -- ALTER TABLE `contact_us` ADD PRIMARY KEY (`id`); -- -- Indexes for table `customer` -- ALTER TABLE `customer` ADD PRIMARY KEY (`id`); -- -- Indexes for table `customer_address` -- ALTER TABLE `customer_address` ADD PRIMARY KEY (`id`); -- -- Indexes for table `delivery` -- ALTER TABLE `delivery` ADD PRIMARY KEY (`id`); -- -- Indexes for table `delivery_area` -- ALTER TABLE `delivery_area` ADD PRIMARY KEY (`id`), ADD KEY `vendor_id` (`vendor_id`), ADD KEY `fke_area_delete_id` (`area_id`); -- -- Indexes for table `dsa` -- ALTER TABLE `dsa` ADD PRIMARY KEY (`id`); -- -- Indexes for table `dsa_dealer` -- ALTER TABLE `dsa_dealer` ADD PRIMARY KEY (`id`); -- -- Indexes for table `dsa_dealer_details` -- ALTER TABLE `dsa_dealer_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `enquiry` -- ALTER TABLE `enquiry` ADD PRIMARY KEY (`id`), ADD KEY `city_id` (`city_id`); -- -- Indexes for table `gallery` -- ALTER TABLE `gallery` ADD PRIMARY KEY (`id`), ADD KEY `product_id` (`product_id`); -- -- Indexes for table `job_enquiry` -- ALTER TABLE `job_enquiry` ADD PRIMARY KEY (`id`); -- -- Indexes for table `job_opening` -- ALTER TABLE `job_opening` ADD PRIMARY KEY (`id`); -- -- Indexes for table `keywords` -- ALTER TABLE `keywords` ADD PRIMARY KEY (`id`); -- -- Indexes for table `notification` -- ALTER TABLE `notification` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order` -- ALTER TABLE `order` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order_details` -- ALTER TABLE `order_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order_status_history` -- ALTER TABLE `order_status_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `package` -- ALTER TABLE `package` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pages` -- ALTER TABLE `pages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `payment_history` -- ALTER TABLE `payment_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `payment_settings` -- ALTER TABLE `payment_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product` -- ALTER TABLE `product` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product_images` -- ALTER TABLE `product_images` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product_variant` -- ALTER TABLE `product_variant` ADD PRIMARY KEY (`id`); -- -- Indexes for table `service_enquiry` -- ALTER TABLE `service_enquiry` ADD PRIMARY KEY (`id`); -- -- Indexes for table `service_gallery` -- ALTER TABLE `service_gallery` ADD PRIMARY KEY (`id`); -- -- Indexes for table `service_keywords` -- ALTER TABLE `service_keywords` ADD PRIMARY KEY (`id`); -- -- Indexes for table `service_point` -- ALTER TABLE `service_point` ADD PRIMARY KEY (`id`); -- -- Indexes for table `service_video` -- ALTER TABLE `service_video` ADD PRIMARY KEY (`id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `shop_timing` -- ALTER TABLE `shop_timing` ADD PRIMARY KEY (`id`); -- -- Indexes for table `slider` -- ALTER TABLE `slider` ADD PRIMARY KEY (`id`); -- -- Indexes for table `status_list` -- ALTER TABLE `status_list` ADD PRIMARY KEY (`1`); -- -- Indexes for table `subcategory` -- ALTER TABLE `subcategory` ADD PRIMARY KEY (`id`), ADD KEY `subcate_delete_id` (`category_id`), ADD KEY `vendor_id` (`vendor_id`); -- -- Indexes for table `sub_subcategory` -- ALTER TABLE `sub_subcategory` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tag` -- ALTER TABLE `tag` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tax` -- ALTER TABLE `tax` ADD PRIMARY KEY (`id`); -- -- Indexes for table `template` -- ALTER TABLE `template` ADD PRIMARY KEY (`user_id`); -- -- Indexes for table `transport_charges` -- ALTER TABLE `transport_charges` ADD PRIMARY KEY (`id`); -- -- Indexes for table `type` -- ALTER TABLE `type` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`user_id`), ADD KEY `package_id` (`package_id`), ADD KEY `city_id` (`city_id`), ADD KEY `area_id` (`area_id`), ADD KEY `category_id` (`category_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `ads` -- ALTER TABLE `ads` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `area` -- ALTER TABLE `area` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=143; -- -- AUTO_INCREMENT for table `calls` -- ALTER TABLE `calls` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30; -- -- AUTO_INCREMENT for table `cart` -- ALTER TABLE `cart` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=311; -- -- AUTO_INCREMENT for table `category` -- ALTER TABLE `category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43; -- -- AUTO_INCREMENT for table `category_type` -- ALTER TABLE `category_type` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `city` -- ALTER TABLE `city` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; -- -- AUTO_INCREMENT for table `commission` -- ALTER TABLE `commission` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `commission_slab` -- ALTER TABLE `commission_slab` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `contact_us` -- ALTER TABLE `contact_us` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=224; -- -- AUTO_INCREMENT for table `customer` -- ALTER TABLE `customer` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- AUTO_INCREMENT for table `customer_address` -- ALTER TABLE `customer_address` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `delivery` -- ALTER TABLE `delivery` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `delivery_area` -- ALTER TABLE `delivery_area` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46; -- -- AUTO_INCREMENT for table `dsa` -- ALTER TABLE `dsa` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55; -- -- AUTO_INCREMENT for table `dsa_dealer` -- ALTER TABLE `dsa_dealer` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `dsa_dealer_details` -- ALTER TABLE `dsa_dealer_details` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50; -- -- AUTO_INCREMENT for table `enquiry` -- ALTER TABLE `enquiry` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `gallery` -- ALTER TABLE `gallery` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `job_enquiry` -- ALTER TABLE `job_enquiry` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `job_opening` -- ALTER TABLE `job_opening` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `keywords` -- ALTER TABLE `keywords` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38; -- -- AUTO_INCREMENT for table `notification` -- ALTER TABLE `notification` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `order` -- ALTER TABLE `order` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=271; -- -- AUTO_INCREMENT for table `order_details` -- ALTER TABLE `order_details` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=237; -- -- AUTO_INCREMENT for table `order_status_history` -- ALTER TABLE `order_status_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=87; -- -- AUTO_INCREMENT for table `package` -- ALTER TABLE `package` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `pages` -- ALTER TABLE `pages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `payment_history` -- ALTER TABLE `payment_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=169; -- -- AUTO_INCREMENT for table `payment_settings` -- ALTER TABLE `payment_settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `product` -- ALTER TABLE `product` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=238; -- -- AUTO_INCREMENT for table `product_images` -- ALTER TABLE `product_images` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=86; -- -- AUTO_INCREMENT for table `product_variant` -- ALTER TABLE `product_variant` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=243; -- -- AUTO_INCREMENT for table `service_enquiry` -- ALTER TABLE `service_enquiry` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `service_gallery` -- ALTER TABLE `service_gallery` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `service_keywords` -- ALTER TABLE `service_keywords` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `service_point` -- ALTER TABLE `service_point` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `service_video` -- ALTER TABLE `service_video` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `shop_timing` -- ALTER TABLE `shop_timing` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `slider` -- ALTER TABLE `slider` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `status_list` -- ALTER TABLE `status_list` MODIFY `1` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `subcategory` -- ALTER TABLE `subcategory` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=95; -- -- AUTO_INCREMENT for table `sub_subcategory` -- ALTER TABLE `sub_subcategory` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `tag` -- ALTER TABLE `tag` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tax` -- ALTER TABLE `tax` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `template` -- ALTER TABLE `template` MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=126; -- -- AUTO_INCREMENT for table `transport_charges` -- ALTER TABLE `transport_charges` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `type` -- ALTER TABLE `type` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107; -- -- Constraints for dumped tables -- -- -- Constraints for table `area` -- ALTER TABLE `area` ADD CONSTRAINT `city_delete_id` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `cart` -- ALTER TABLE `cart` ADD CONSTRAINT `delete_key_variant` FOREIGN KEY (`variant_id`) REFERENCES `product_variant` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `category` -- ALTER TABLE `category` ADD CONSTRAINT `null_fk_category_type` FOREIGN KEY (`category_type`) REFERENCES `category_type` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION; -- -- Constraints for table `commission_slab` -- ALTER TABLE `commission_slab` ADD CONSTRAINT `cat_delete_id` FOREIGN KEY (`cat_id`) REFERENCES `category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `comm_delete_fk` FOREIGN KEY (`comm_id`) REFERENCES `commission` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION, ADD CONSTRAINT `ved_delete_fk` FOREIGN KEY (`vendor_id`) REFERENCES `user` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `delivery_area` -- ALTER TABLE `delivery_area` ADD CONSTRAINT `area_delete_delivery` FOREIGN KEY (`vendor_id`) REFERENCES `user` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `fke_area_delete_id` FOREIGN KEY (`area_id`) REFERENCES `area` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `enquiry` -- ALTER TABLE `enquiry` ADD CONSTRAINT `fk_delete_id_city` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION; -- -- Constraints for table `gallery` -- ALTER TABLE `gallery` ADD CONSTRAINT `product_delete_id` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `subcategory` -- ALTER TABLE `subcategory` ADD CONSTRAINT `subcate_delete_id` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `user` -- ALTER TABLE `user` ADD CONSTRAINT `fk_area_id_delete` FOREIGN KEY (`area_id`) REFERENCES `area` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION, ADD CONSTRAINT `fk_cate_id_delete` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION, ADD CONSTRAINT `fk_city_id_delete` FOREIGN KEY (`city_id`) REFERENCES `area` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION, ADD CONSTRAINT `test` FOREIGN KEY (`package_id`) REFERENCES `package` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;