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

START TRANSACTION;



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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `bid` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `link` varchar(255) DEFAULT NULL,
  `order_no` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`bid`, `image`, `link`, `order_no`, `created_at`, `updated_at`) VALUES
(21, '1586009666_home_banner.png', NULL, 1, '2020-04-04 14:14:26', '2020-04-04 14:14:26');

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `cid` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `banner` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `icon_for_mobile_view` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `highlight_message` text DEFAULT NULL,
  `advantage_message` text DEFAULT NULL,
  `how_it_works` text DEFAULT NULL,
  `about` text DEFAULT NULL,
  `pop_up_advantage_message` text DEFAULT NULL,
  `bottom_info` text DEFAULT NULL,
  `parent_cid` int(11) NOT NULL DEFAULT 0,
  `min_amount_for_user` float DEFAULT NULL,
  `featured` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `meta_keyword` text DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`cid`, `title`, `banner`, `slug`, `icon`, `icon_for_mobile_view`, `image`, `highlight_message`, `advantage_message`, `how_it_works`, `about`, `pop_up_advantage_message`, `bottom_info`, `parent_cid`, `min_amount_for_user`, `featured`, `status`, `meta_keyword`, `meta_description`, `created_at`, `updated_at`) VALUES
(24, 'Appliance Repair', NULL, 'appliance-repair', '1555671712_259981.svg', '1555824909_minisplit copy.png', '1555827163_34680.png', NULL, NULL, NULL, NULL, NULL, NULL, 0, 100, NULL, 1, NULL, NULL, '2019-03-12 13:43:18', '2020-04-04 15:21:13'),
(25, 'AC Service and Repair', '1586013196_ac-service-and-repair-banner.jpg', 'ac-service-and-repair', '1555827259_096-512.png', NULL, '1585980514_ac-service-and-repair.jpg', '<ul>\r\n	<li>Upto Rs 10,000 damage insurance</li>\r\n	<li>30 day service guarantee</li>\r\n	<li>Background checked and trained technicians with genuine parts &amp; fixed pricing</li>\r\n</ul>', '<div class=\"row\">\r\n<div class=\"col-md-2 no_right_pad\"><img class=\"img-fluid category_icon\" src=\"https://www.repairservicesindia.com/public/images/icons/category_icon1.png\" /></div>\r\n\r\n<div class=\"col-md-10 no_left_pad\"><b>Doorstep repair in 90 minutes</b>\r\n\r\n<p>On-time service</p>\r\n\r\n<ul>\r\n	<li>At your chosen time slot</li>\r\n</ul>\r\n</div>\r\n</div>\r\n\r\n<div class=\"row pt-5\">\r\n<div class=\"col-md-2 no_right_pad\"><img class=\"img-fluid category_icon\" src=\"https://www.repairservicesindia.com/public/images/icons/category_icon2.png\" /></div>\r\n\r\n<div class=\"col-md-10 no_left_pad\"><b>Experienced repair professionals</b>\r\n\r\n<p>4.3+ star rated</p>\r\n\r\n<ul>\r\n	<li>Background-verified &amp; trained professionals</li>\r\n	<li>We service all Brands &amp; Models</li>\r\n</ul>\r\n</div>\r\n</div>\r\n\r\n<div class=\"row pt-5\">\r\n<div class=\"col-md-2 no_right_pad\"><img class=\"img-fluid category_icon\" src=\"https://www.repairservicesindia.com/public/images/icons/category_icon3.png\" /></div>\r\n\r\n<div class=\"col-md-10 no_left_pad\"><b>Customer protection</b>\r\n\r\n<p>Insurance upto 10,000 INR</p>\r\n\r\n<ul>\r\n	<li>30 Day service guarantee</li>\r\n	<li>Insurance upto 10,000 INR against Damages</li>\r\n</ul>\r\n</div>\r\n</div>', '<div class=\"row\">\r\n<div class=\"col-md-2 no_right_pad\"><img class=\"img-fluid category_icon\" src=\"https://www.repairservicesindia.com/public/images/icons/category_icon4.png\" /></div>\r\n\r\n<div class=\"col-md-10 no_left_pad\"><b>Choose the type of AC</b>\r\n\r\n<p>We Service all types of ACs: Split, Window, Central</p>\r\n\r\n<hr /></div>\r\n</div>\r\n\r\n<div class=\"row pt-2\">\r\n<div class=\"col-md-2 no_right_pad\"><img class=\"img-fluid category_icon\" src=\"https://www.repairservicesindia.com/public/images/icons/category_icon5.png\" /></div>\r\n\r\n<div class=\"col-md-10 no_left_pad\"><b>Choose the service you need</b>\r\n\r\n<p>We provide repairs, installations &amp; servicing</p>\r\n\r\n<hr /></div>\r\n</div>\r\n\r\n<div class=\"row pt-2\">\r\n<div class=\"col-md-2 no_right_pad\"><img class=\"img-fluid category_icon\" src=\"https://www.repairservicesindia.com/public/images/icons/category_icon6.png\" /></div>\r\n\r\n<div class=\"col-md-10 no_left_pad\"><b>Choose your time-slot</b>\r\n\r\n<p>We service from 9 AM - 9 PM</p>\r\n\r\n<hr /></div>\r\n</div>\r\n\r\n<div class=\"row pt-2\">\r\n<div class=\"col-md-2 no_right_pad\"><img class=\"img-fluid category_icon\" src=\"https://www.repairservicesindia.com/public/images/icons/category_icon7.png\" /></div>\r\n\r\n<div class=\"col-md-10 no_left_pad\"><b>Hassle-free service</b>\r\n\r\n<p>Our professional will get in touch with you one hour before the service</p>\r\n\r\n<hr /></div>\r\n</div>', '<h3>Services offered in AC Service and Repair</h3>\r\n\r\n<ul>\r\n	<li>Installing an AC: Choose this service for AC installation at your place. The professional will ensure that the AC is running properly as gas pressure and performance of the appliance will be checked post AC installation.</li>\r\n	<li>Uninstalling an existing AC: Select this option when you need professionals to dismount an AC. The appliance will be checked before the AC uninstallation.</li>\r\n	<li>Wet services: This service includes an end to end cleaning of your AC (which is not faulty). Cooling coils, condenser coils, outer panel, drain and filet pipes will be extensively cleaned and washed. However, high-pressure jet pumps will not be used for the cleaning purpose. Tick this service when you want your AC to be properly cleaned.</li>\r\n	<li>Repairs: Choose this option for diagnosis and repair of your AC. The professional will check the AC upon visitation and provide with quotation depending on the condition of the appliance.</li>\r\n</ul>\r\n\r\n<h3>Why AC Service and Repair?</h3>\r\n\r\n<ul>\r\n	<li>Customer Protection: Unlike any other service provider, provides a customer protection of Rs. 10,000 against damages.</li>\r\n	<li>Verified Professionals: All the professionals on board with are taken through a screening process to check for their expertise.</li>\r\n	<li>Service Warranty: We at take full ownership of our services and hence, this is the reason that we provide a service warranty of 30 days.</li>\r\n	<li>Customer Centric: All our services are curated keeping our customers in mind and AC repair service is no exception.</li>\r\n	<li>Standardized pricing: To save our customers from unfair pricing, we have come up with the idea of standardized pricing with the rate card shared on both our website and App.</li>\r\n	<li>Online payment: Now pay hassle free post your service through our online portal. You will receive a link via SMS and/or email which will take you to the online payment portal.</li>\r\n</ul>\r\n\r\n<p>Like any other machinery, an appliance such as AC needs to be maintained and looked after for its healthy functioning. Hence, the appliance should receive a proper service before the start of summer season. After all, nothing can be worse than a broken or faulty AC. Hunting a service personnel for AC repair in the sultry weather can be a hassle. You can now book a professional either for service and repair within minutes from your home. You don&rsquo;t even need to clear your schedule as you can choose your desirable time slot. &rsquo;s AC repair service has proven to be a blessing for our customers as we continue to receive happy testimonials and ratings from our customers.</p>\r\n\r\n<h3>How it works?</h3>\r\n\r\n<p>To find the best professionals near you in no time, you just need to go on the website or App and search for &lsquo;AC Repair&rsquo; in the search tab. A pop up tab will open up wherein you will need to fill in the details according to your requirements. Questions such as what kind of service is required &ndash; split AC or window AC, location, time, etc. compromise the questionnaire. Once your request is uploaded on the portal, a professional will be at your doorstep at your requested time and location.</p>\r\n\r\n<h3>AC Common Repair/Service Prices in Delhi</h3>\r\n\r\n<table class=\"table table-striped table-hovered\">\r\n	<thead>\r\n		<tr>\r\n			<th>Part Name</th>\r\n			<th>Spare Part Cost (INR)</th>\r\n			<th>Labour Cost (INR)</th>\r\n			<th>Final Cost</th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td>Repair Of PCB</td>\r\n			<td>1500</td>\r\n			<td>499</td>\r\n			<td>NA</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Gas Charging</td>\r\n			<td>NA</td>\r\n			<td>NA</td>\r\n			<td>2500(Including Nitrogen Flushing)</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<h3>Window AC Repair/Service Prices in Delhi</h3>\r\n\r\n<table class=\"table table-striped table-hovered\">\r\n	<thead>\r\n		<tr>\r\n			<th>Part Name</th>\r\n			<th>Labour Cost (INR)</th>\r\n			<th>&nbsp;</th>\r\n			<th>&nbsp;</th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td>Installation - Window (Copper Pipe And Stand Extra)</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Uninstallation - Window</td>\r\n			<td>399</td>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Wet Servicing - Window</td>\r\n			<td>399</td>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<h3>Split AC Repair/Service Prices in Delhi</h3>\r\n\r\n<table class=\"table table-striped table-hovered\">\r\n	<thead>\r\n		<tr>\r\n			<th>Part Name</th>\r\n			<th>Labour Cost (INR)</th>\r\n			<th>&nbsp;</th>\r\n			<th>&nbsp;</th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td>Installation - Split (Copper Pipe And Stand Extra)</td>\r\n			<td>1499</td>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Uninstallation - Split</td>\r\n			<td>599</td>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Wet Servicing - Split</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<h3>Other AC Repair/Service Prices in Delhi</h3>\r\n\r\n<table class=\"table table-striped table-hovered\">\r\n	<thead>\r\n		<tr>\r\n			<th>Part Name</th>\r\n			<th>Spare Part Cost (INR)</th>\r\n			<th>Labour Cost (INR)</th>\r\n			<th>&nbsp;</th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td>Copper Condenser Coil</td>\r\n			<td>3700</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Grill Cover</td>\r\n			<td>1000</td>\r\n			<td>349</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<h3>AC Common Spare Parts Prices in Delhi</h3>\r\n\r\n<table class=\"table table-striped table-hovered\">\r\n	<thead>\r\n		<tr>\r\n			<th>Repair/Service</th>\r\n			<th>Spare Part Cost (INR)</th>\r\n			<th>Labour Cost (INR)</th>\r\n			<th>&nbsp;</th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td>Blower</td>\r\n			<td>1100</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Grill</td>\r\n			<td>1100</td>\r\n			<td>349</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Fan Motor Outdoor</td>\r\n			<td>1600</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Replace LVT</td>\r\n			<td>900</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Replace Sensor</td>\r\n			<td>350</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Blower Motor</td>\r\n			<td>2200</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Copper Pipe (Per Meter)</td>\r\n			<td>750</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Replace Flap/Swing Motor</td>\r\n			<td>400</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<h3>AC Common Spare Parts Prices in Delhi</h3>\r\n\r\n<table class=\"table table-striped table-hovered\">\r\n	<thead>\r\n		<tr>\r\n			<th>Repair/Service</th>\r\n			<th>Spare Part Cost (INR)</th>\r\n			<th>Labour Cost (INR)</th>\r\n			<th>Total Cost (INR)</th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td>Capacitor 2-5 Mfd</td>\r\n			<td>200</td>\r\n			<td>349</td>\r\n			<td>NA</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Capacitor 10-25 Mfd</td>\r\n			<td>250</td>\r\n			<td>349</td>\r\n			<td>NA</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Capacitor 35-50 Mfd</td>\r\n			<td>300</td>\r\n			<td>349</td>\r\n			<td>NA</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Capacitor 50-60 Mfd</td>\r\n			<td>350</td>\r\n			<td>349</td>\r\n			<td>NA</td>\r\n		</tr>\r\n		<tr>\r\n			<td>AC Fan Blade</td>\r\n			<td>700</td>\r\n			<td>499</td>\r\n			<td>NA</td>\r\n		</tr>\r\n		<tr>\r\n			<td>AC Valve</td>\r\n			<td>700</td>\r\n			<td>499</td>\r\n			<td>NA</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Compressor 0.8-1 Ton (Rs. 2500 Extra For Gas Charging)</td>\r\n			<td>NA</td>\r\n			<td>NA</td>\r\n			<td>6500</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Compressor 1.5 Ton (Rs. 2500 Extra For Gas Charging)</td>\r\n			<td>NA</td>\r\n			<td>NA</td>\r\n			<td>7500</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Compressor 2 Ton (Rs. 2500 Extra For Gas Charging)</td>\r\n			<td>NA</td>\r\n			<td>NA</td>\r\n			<td>9200</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<h3>Window AC Spare Parts Prices in Delhi</h3>\r\n\r\n<table class=\"table table-striped table-hovered\">\r\n	<thead>\r\n		<tr>\r\n			<th>Repair/Service</th>\r\n			<th>Spare Part Cost (INR)</th>\r\n			<th>Labour Cost (INR)</th>\r\n			<th>&nbsp;</th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td>Copper Cooling Coil</td>\r\n			<td>3700</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Grill Cover</td>\r\n			<td>1000</td>\r\n			<td>349</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<h3>Split AC Spare Parts Prices in Delhi</h3>\r\n\r\n<table class=\"table table-striped table-hovered\">\r\n	<thead>\r\n		<tr>\r\n			<th>Repair/Service</th>\r\n			<th>Spare Part Cost (INR)</th>\r\n			<th>Labour Cost (INR)</th>\r\n			<th>&nbsp;</th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td>Copper Cooling Coil Split</td>\r\n			<td>4700</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Copper Coil Condenser 1 Ton Split</td>\r\n			<td>2700</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Copper Coil Condenser 1.5 Ton Split</td>\r\n			<td>3300</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Copper Coil Condenser 2 Ton Split</td>\r\n			<td>3700</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Split AC Floor Stand</td>\r\n			<td>550</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Split AC Wall Stand</td>\r\n			<td>550</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Contractor (Split AC)</td>\r\n			<td>500</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<h3>Other AC Repair/Services in Delhi</h3>\r\n\r\n<table class=\"table table-striped table-hovered\">\r\n	<thead>\r\n		<tr>\r\n			<th>Repair/Service</th>\r\n			<th>Labour Cost (INR)</th>\r\n			<th>&nbsp;</th>\r\n			<th>&nbsp;</th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td>Adjust Grill Locks</td>\r\n			<td>249</td>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Adjust Pipe And Tight Compressor Screw</td>\r\n			<td>349</td>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Cover All Lines By Insulation</td>\r\n			<td>499</td>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Tighten/Replace Thimble</td>\r\n			<td>349</td>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Replace Wires</td>\r\n			<td>349</td>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n		<tr>\r\n			<td>Remove Pipe From Water</td>\r\n			<td>249</td>\r\n			<td>&nbsp;</td>\r\n			<td>&nbsp;</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p><strong>* Branded spare parts will be charged at MRP<br />\r\n*Overall labour cost will not exceed INR 499</strong></p>', '<div class=\"text-left\">\r\n<ul>\r\n	<li>Service Guarantee&nbsp;</li>\r\n	<li>Warranty period top class&nbsp;</li>\r\n	<li>Repair&nbsp;service&nbsp;washing machine&nbsp;microwave&nbsp;Customer Protection of upto Rs.10,000 against damages</li>\r\n	<li>30-day service guarantee</li>\r\n	<li>Professional Servicing &amp; Repair</li>\r\n</ul>\r\n</div>', NULL, 24, NULL, 1, 1, 'kk', 'ddd', '2019-03-12 13:43:30', '2020-04-04 15:13:16'),
(26, 'Refrigerator Repair', '1559908662_refrigerator-repair-service-Georgetown-TX.jpg', 'refrigerator-repair', '1555827398_double_door_refrigerator_4056.png', '1559908947_1555827398_double_door_refrigerator_4056.png', '1559908842_refrigerator-repair-service-Georgetown-TX.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 24, NULL, 1, 1, NULL, NULL, '2019-03-12 13:43:48', '2019-06-07 17:38:43'),
(27, 'Washing Machine Repair', '1559918756_slide1.jpg', 'washing-machine-repair', '1555475448_Laundry_12-512.png', '1555475448_Laundry_12-512.png', '1559918756_slide1.jpg', '<hr />\r\n<p>Gshshs</p>', '<hr />\r\n<p>GdddddGshshsddjjdj</p>', '<hr />\r\n<p>Hhhhshhshdhhd</p>', '<hr />\r\n<p>Jdjjxjdjjd cudjfj</p>', '<hr />\r\n<p>Nxndnjxuhdjrhfjjfjf</p>', '<hr />\r\n<p>Ndndnndhxuxhd</p>', 24, NULL, 1, 1, NULL, NULL, '2019-03-12 13:44:04', '2019-06-08 23:24:20'),
(28, 'RO or Water Purifier Repair', '1559911280_RO-repair_Luminosity_Desktop.jpg', 'ro-or-water-purifier-repair', '1555827496_water_6315.png', NULL, '1559910486_RO-repair_Luminosity_Desktop (2).jpg', NULL, NULL, NULL, NULL, NULL, NULL, 24, NULL, NULL, 1, NULL, NULL, '2019-03-12 13:44:17', '2019-06-07 18:11:20'),
(29, 'Microwave Repair', NULL, 'microwave-repair', '1555672197_1701482.png', NULL, '1555673043_images.jpeg', '<p>&nbsp;</p>\r\n\r\n<ul>\r\n	<li>Doorstep repair within 90 mins</li>\r\n	<li>Protection Against Damage Upto INR 8,000</li>\r\n	<li>30 day post-service guarantee</li>\r\n</ul>', NULL, NULL, NULL, '<h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Service Guarantee</h4>\r\n\r\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30-day service guarantee post service completion</p>\r\n\r\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Customer Protection of upto Rs.10,000 against damages</p>\r\n\r\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Surcharge of Rs. 150 for 9-10 PM service</p>\r\n\r\n<h4>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Expert Technicians</h4>\r\n\r\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Background checked and highly trained technicians</p>\r\n\r\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Genuine parts &amp; fixed pricing</p>\r\n\r\n<p>&nbsp;</p>', NULL, 24, NULL, 1, 1, NULL, NULL, '2019-03-12 13:44:26', '2019-05-12 16:06:19'),
(30, 'Beauty & Spa', '1559910963_AABT_Upgrade.jpg', 'beauty-spa', '1555475182_lipstick-makeup-beauty-grooming-512.png', '1555822683_lipstick-png-clipart-24.png', '1559910963_AABT_Upgrade.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1, 1, NULL, NULL, '2019-03-12 13:44:37', '2019-06-07 18:16:06'),
(31, 'Salon at home for Women', '1559915049_Fotolia_61320080_Subscription_XL-2048x1229.jpg', 'salon-at-home-for-women', '1555838916_hair-dryer.png', NULL, '1559915049_Fotolia_61320080_Subscription_XL-2048x1229.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 30, NULL, 1, 1, NULL, NULL, '2019-03-12 13:44:48', '2019-06-07 19:14:09'),
(32, 'Message for Women', '1559914959_massage-therapy-avon-indiana.jpg', 'message-for-women', '1555830245_makeup.png', NULL, '1559914959_massage-therapy-avon-indiana.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 30, NULL, 1, 1, NULL, NULL, '2019-03-12 13:45:11', '2019-06-07 19:12:39'),
(33, 'Makeup and Hairstyling', '1559914828_sonam-kapoor-anand-ahuja-mehand-makeup-hairstyle-namrata-soni-first-look-2.jpg', 'makeup-and-hairstyling', '1555827697_lipstick.png', NULL, '1559914828_sonam-kapoor-anand-ahuja-mehand-makeup-hairstyle-namrata-soni-first-look-2.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 30, NULL, 1, 1, NULL, NULL, '2019-03-12 13:45:20', '2019-06-07 19:10:28'),
(34, 'Home Cleaning & Repairs', '1559917626_Merry 2.jpg', 'home-cleaning-repairs', '1555510060_Untitled-1-70-512.png', '1555823383_tool-icon-3.png', '1559917626_Merry 2.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1, NULL, NULL, '2019-03-13 03:59:18', '2019-06-07 19:57:06'),
(35, 'Business & Taxes', NULL, 'business-taxes', '1555509056_business_symbolicon_2-14-512.png', '1555509056_256-256-b28b004bc58a054c6f2b0b31022e840f.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1, NULL, NULL, '2019-03-13 03:59:31', '2019-04-17 19:20:56'),
(36, 'Personal & More', NULL, 'personal-more', '1555510792_manager_director_leader_head-512.png', '', '', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1, NULL, NULL, '2019-03-13 03:59:40', '2019-10-07 02:34:57'),
(37, 'Electricians', '1559918297_EggersElectric-May-b1.jpg', 'electricians', '1555840572_img_372796.png', NULL, '1559918297_EggersElectric-May-b1.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 34, NULL, 1, 1, NULL, NULL, '2019-03-13 04:00:02', '2019-06-07 20:08:17'),
(38, 'Plumbers', NULL, 'plumbers', '1555841268_plumbering.png', NULL, '1559919664_4Q2EYRR2XMI6TMIL6BNCFZ2YMU.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 34, NULL, 1, 1, NULL, NULL, '2019-03-13 04:00:12', '2019-06-07 20:31:04'),
(39, 'Carpenters', '1559917809_1.jpg', 'carpenters', '1555840220_saw.png', NULL, '1559917809_1.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 34, NULL, 1, 1, NULL, NULL, '2019-03-13 04:00:23', '2019-06-07 20:00:09'),
(40, 'Bathroom Deep Cleaning', '1559917686_15304488_m.jpg', 'bathroom-deep-cleaning', '1555839942_sink.png', NULL, '1559917686_15304488_m.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 34, NULL, 1, 1, NULL, NULL, '2019-03-13 04:00:41', '2019-06-07 19:58:06'),
(41, 'Carpet Cleaning', '1559918211_CarpetCleaner_600x330.jpg', 'carpet-cleaning', '1555840302_carpet.png', NULL, '1559918211_CarpetCleaner_600x330.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 34, NULL, 1, 1, NULL, NULL, '2019-03-13 04:00:55', '2019-06-07 20:06:51'),
(42, 'Home Deep Cleaning', NULL, 'home-deep-cleaning', '1555840735_spray.png', NULL, '1552494963_home_deep_cleaning.png', NULL, NULL, NULL, NULL, NULL, NULL, 34, NULL, 1, 1, NULL, NULL, '2019-03-13 04:01:07', '2019-04-21 15:28:55'),
(43, 'Kitchen Deep Cleaning', NULL, 'kitchen-deep-cleaning', '1555840827_cleaning.png', NULL, '1559919063_Kitchen-Cleaning-Tips-6-Quick-Hacks-to-Deep-Clean-Your-Kitchen-.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 34, NULL, 1, 1, NULL, NULL, '2019-03-13 04:01:19', '2019-06-07 20:21:03'),
(44, 'Car Cleaning', '1559917739_shutterstock_682966966-850x476.jpg', 'car-cleaning', '1555840058_car.png', NULL, '1559917739_shutterstock_682966966-850x476.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 34, NULL, 1, 1, NULL, NULL, '2019-03-13 04:01:30', '2019-06-07 19:58:59'),
(45, 'Pest Control', NULL, 'pest-control', '1555841181_cockroach.png', NULL, '1559919524_pest-control.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 34, NULL, 1, 1, NULL, NULL, '2019-03-13 04:01:37', '2019-06-07 20:28:44'),
(46, 'CA for Income Tax Filling', NULL, 'ca-for-income-tax-filling', '1555839132_accounting.png', NULL, '1552494914_ca.png', NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, 1, 1, NULL, NULL, '2019-03-13 04:02:09', '2019-04-21 15:02:12'),
(47, 'Packers & Movers', '1559916374_best-packers-movers-gurgaon.jpg', 'packers-movers', '1555839580_svg-7-512.png', NULL, '1559916374_best-packers-movers-gurgaon.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, 1, 1, NULL, NULL, '2019-03-13 04:02:17', '2019-06-07 19:36:14'),
(48, 'CCTV Camera & Installation', '1559916229_cctv-installation-wolverhampton.jpg', 'cctv-camera-installation', '1555829687_cctv.png', NULL, '1559916229_cctv-installation-wolverhampton.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, 1, 1, NULL, NULL, '2019-03-13 04:02:30', '2019-06-07 19:33:49'),
(49, 'Web Designer & Developer', '1559917550_team-1.jpg', 'web-designer-developer', '1555839762_web-development-glyph-16-512.png', NULL, '1559917550_team-1.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, 1, 1, NULL, NULL, '2019-03-13 04:02:46', '2019-06-07 19:55:50'),
(50, 'CA for Small Business', '1559916147_tax-planning-for-small-businesses-rancho-cucamonga-ca.jpg', 'ca-for-small-business', '1555839222_resume.png', NULL, '1559916147_tax-planning-for-small-businesses-rancho-cucamonga-ca.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, 1, 1, NULL, NULL, '2019-03-13 04:03:01', '2019-06-07 19:32:27'),
(51, 'GST Registration & Migration Service', '1559916303_gst-reu-3-2.webp', 'gst-registration-migration-service', '1555839375_bussiness.png', NULL, '1559916303_gst-reu-3-2.webp', NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, 1, 1, NULL, NULL, '2019-03-13 04:03:21', '2019-06-07 19:35:03'),
(53, 'Baby Portfolio Photographer', NULL, 'baby-portfolio-photographer', NULL, NULL, '1559919763_02_FrontCover.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 36, NULL, NULL, 1, NULL, NULL, '2019-03-13 04:03:59', '2019-06-07 20:32:43'),
(54, 'Wedding & Events', NULL, 'wedding-events', '1555671913_918465.svg', '1555826256_1407510.png', '1559920793_Indian-Wedding.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1, NULL, NULL, '2019-03-13 04:05:46', '2019-06-07 20:49:53'),
(55, 'Makeup & Hairstyling', NULL, 'makeup-hairstyling', NULL, NULL, '1552495013_makeup.png', NULL, NULL, NULL, NULL, NULL, NULL, 54, NULL, NULL, 1, NULL, NULL, '2019-03-13 04:06:01', '2019-03-13 11:06:53'),
(56, 'Wedding Photographer', NULL, 'wedding-photographer', NULL, NULL, '1559921160_1522852403-weddingphotography-featured.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 54, NULL, NULL, 1, NULL, NULL, '2019-03-13 04:06:11', '2019-06-07 20:56:00'),
(57, 'Pre-Wedding Shoot', NULL, 'pre-wedding-shoot', NULL, NULL, '1559921087_pre5.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 54, NULL, NULL, 1, NULL, NULL, '2019-03-13 04:06:22', '2019-06-07 20:54:47'),
(58, 'Event Photograoher', NULL, 'event-photograoher', '1576409949_1562481155_camera.png', NULL, '1576409871_Event-Photographer.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 54, NULL, NULL, 1, NULL, NULL, '2019-03-13 04:06:34', '2019-12-15 17:09:09'),
(59, 'Wedding Venues', NULL, 'wedding-venues', NULL, NULL, '1559921224_110303_1_800.jpeg', NULL, NULL, NULL, NULL, NULL, NULL, 54, NULL, NULL, 1, NULL, NULL, '2019-03-13 04:06:45', '2019-06-07 20:57:04'),
(60, 'Party Decoration', NULL, 'party-decoration', NULL, NULL, '1559921008_maxresdefault.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 54, NULL, NULL, 1, NULL, NULL, '2019-03-13 04:06:57', '2019-06-07 20:53:28'),
(61, 'Astrologer', NULL, 'astrologer', '1555671841_918465.svg', NULL, '1559920872_ello-hdpi-910da1a5.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 54, NULL, NULL, 1, NULL, NULL, '2019-03-13 04:07:14', '2019-06-07 20:51:12'),
(62, 'Rent & Sell Property', '1559845078_1559828076_27681cdd9e.svg', 'rent-sell-property', '1559845149_1559828076_27681cdd9e.svg', '1559921326_253__hospital__clinic__property_-512.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1, NULL, NULL, '2019-06-06 18:17:58', '2019-06-07 20:58:46'),
(63, 'For Buy Property', NULL, 'for-buy-property', '1576410016_1561309173_estate-agent.png', NULL, '1559920597_Home-security.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, NULL, 1, NULL, NULL, '2019-06-06 18:18:20', '2019-12-15 17:10:16'),
(64, 'For Given To Rent', NULL, 'for-given-to-rent', '1576410008_1562481340_coin.png', NULL, '1559920678_housekey.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 62, NULL, NULL, 1, NULL, NULL, '2019-06-06 18:18:31', '2019-12-15 17:10:08');

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

--
-- Table structure for table `category_advantage_images`
--

CREATE TABLE `category_advantage_images` (
  `id` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `category_pop_up_advantage_images`
--

CREATE TABLE `category_pop_up_advantage_images` (
  `cp_id` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `weight` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `city`
--

CREATE TABLE `city` (
  `city_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `billing_address` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `city`
--

INSERT INTO `city` (`city_id`, `title`, `slug`, `billing_address`, `created_at`, `updated_at`) VALUES
(1, 'Ahmedabad', 'ahmedabad', NULL, '2019-03-12 13:04:33', '2019-03-12 13:04:33'),
(3, 'Bangalore', 'bangalore', NULL, '2019-03-12 13:05:12', '2019-03-12 13:05:12'),
(4, 'Chandigarh Tricity', 'chandigarh-tricity', NULL, '2019-03-12 13:05:30', '2019-03-12 13:05:30'),
(6, 'Delhi NCR', 'delhi-ncr', 'T-67A, Ground Floor, Vishnu Garden, New Delhi-110018', '2019-03-12 13:05:44', '2019-05-23 14:33:26'),
(7, 'Lucknow', 'lucknow', 'T-67A, Ground Floor, Vishnu Garden, New Delhi-110018', '2019-06-07 00:44:40', '2019-06-07 00:44:40'),
(10, 'Chennai', 'chennai', 'Chennai Station', '2019-11-25 12:56:04', '2019-11-25 12:56:04'),
(11, 'Ankleshwer', 'ankleshwer', 'Ankleshwer', '2020-01-05 18:20:52', '2020-01-05 18:20:52');

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

--
-- Table structure for table `contact_form`
--

CREATE TABLE `contact_form` (
  `cid` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(25) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact_form`
--

INSERT INTO `contact_form` (`cid`, `name`, `email`, `phone`, `subject`, `message`, `created_at`, `updated_at`) VALUES
(2, 'Pooja', 'pooja@gmail.com', '98989898', 'Hello subject', 'some message here', '2019-04-24 09:07:42', '2019-04-24 09:07:42'),
(3, 'MauriceDow', 'mr_stevens42160@yahoo.com', '82413637797', 'Bezahlte Umfragen: Verdienen Sie € 3.000 oder mehr pro Woche', 'Wie man zusatzliches Geld von zu Hause aus verdient - € 3000 pro Tag einfach: https://clck.ru/GQrcn', '2019-06-08 06:59:40', '2019-06-08 06:59:40'),
(4, 'JoshuaBlamI', 'rusasa80@hotmail.com', '89264256971', '$ 10000 pro Tag Bitcoin Trading Guide mit Broker Reviews und Tutorial - Bin?re Optionen', '$ 10000 pro Tag Bitcoins auf dem Markt f?r bin?re Optionen handeln: http://tinyurl.com/y35mun4z', '2019-06-08 13:35:03', '2019-06-08 13:35:03'),
(5, 'Lonnieunapy', 'rodiron2000@hotmail.com', '81346429355', 'Wie man € 10.000 pro Tag SCHNELL macht', 'Wie mache ich € 3000 pro Tag?: http://tinyurl.com/yxus8tmk', '2019-06-08 16:51:37', '2019-06-08 16:51:37'),
(6, 'repairservicesindia.com', 'micgyhaelles@gmail.com', '254611127', 'That is an amazingpromotion for winning. repairservicesindia.com', 'Look at an interesting  prize for you. repairservicesindia.com \r\nhttp://bit.ly/2KBDRHd', '2019-06-09 00:19:24', '2019-06-09 00:19:24'),
(7, 'Ankur thakur', 'thakurankur5@gmail.com', '8966888417', 'I want this app', 'I want to purchase this app', '2019-10-28 21:47:43', '2019-10-28 21:47:43'),
(8, 'Kevin', 'kevin@zealicontechnologies.com', '9891400078', 'SEO Service', 'We can create and promote your website on Google by doing web design and SEO, SMO & PPC Services of your business at a very normal cost.\r\n\r\nIf you would like to know more about this, please send a quick email to us.\r\n\r\nBest Regards', '2020-01-10 17:52:08', '2020-01-10 17:52:08');

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `cid` int(10) UNSIGNED NOT NULL,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
  `coupon_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `minimum_total_amount` int(11) DEFAULT NULL,
  `discount` int(11) DEFAULT NULL,
  `date_start` date DEFAULT NULL,
  `date_end` date DEFAULT NULL,
  `uses_per_coupon` int(11) DEFAULT NULL,
  `uses_per_customer` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `coupon_used`
--

CREATE TABLE `coupon_used` (
  `cu_id` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  `oid` int(11) DEFAULT NULL,
  `discount_amount` float DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `home_categories`
--

CREATE TABLE `home_categories` (
  `hc_id` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `order_no` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `home_categories`
--

INSERT INTO `home_categories` (`hc_id`, `cid`, `order_no`, `created_at`, `updated_at`) VALUES
(6, 24, 1, '2019-03-13 11:51:18', '2019-03-13 11:51:18'),
(8, 34, 3, '2019-03-13 11:51:40', '2019-03-13 11:51:40'),
(9, 35, 3, '2019-03-13 12:34:50', '2019-03-13 12:34:50'),
(10, 62, 4, '2019-06-07 18:07:05', '2019-06-07 18:07:05'),
(11, 30, 3, '2019-12-03 17:35:45', '2019-12-03 17:35:45'),
(14, 54, 6, '2020-01-22 22:28:57', '2020-01-22 22:28:57');

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

--
-- Table structure for table `identity_proof_types`
--

CREATE TABLE `identity_proof_types` (
  `ipt_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `identity_proof_types`
--

INSERT INTO `identity_proof_types` (`ipt_id`, `title`, `slug`, `weight`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Voter ID', 'voter_id', 1, 1, '2019-03-31 08:02:26', NULL),
(2, 'Aadhar', 'aadhar', 2, 1, '2019-03-31 08:02:26', NULL),
(3, 'Driver\'s License', 'driver_license', 3, 1, '2019-03-31 08:02:46', NULL),
(4, 'Pan Card', 'pan_card', 4, 1, '2019-03-31 08:02:46', NULL);

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `mid` int(11) NOT NULL,
  `file` varchar(255) DEFAULT NULL,
  `alt_tag` varchar(255) DEFAULT NULL,
  `title_tag` varchar(255) DEFAULT NULL,
  `file_type` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`mid`, `file`, `alt_tag`, `title_tag`, `file_type`, `created_at`, `updated_at`) VALUES
(7, 'base_url/uploads/media/1559994570_Anil_Soni.png', 'Sketch Artist', 'Anil Soni', NULL, '2019-06-03 16:40:33', '2019-06-08 17:19:52'),
(8, 'base_url/uploads/media/1559979308_wedding.jpg', 'Wedding', 'Wedding', NULL, '2019-06-04 06:29:35', '2019-06-08 13:05:08'),
(9, 'base_url/uploads/media/1559975888_1559629814_renovating.png', 'Renovating', 'Renovating', NULL, '2019-06-04 06:30:14', '2019-06-08 12:08:08'),
(10, 'base_url/uploads/media/1559981333_img_mobile.png', 'mobile', 'mobile', NULL, '2019-06-08 13:38:53', '2019-06-08 13:38:53'),
(11, 'base_url/uploads/media/1559993379_pp copy.png', 'tets', 'tes', NULL, '2019-06-08 16:59:39', '2019-06-08 16:59:39'),
(13, 'base_url/uploads/media/1559997383_Divya.png', 'Make Up Artist', 'Divya Bhatra', NULL, '2019-06-08 18:06:23', '2019-06-08 18:06:23'),
(14, 'base_url/uploads/media/1559997896_Vikram_Singh.png', 'Wedding Photographer', 'Vikram Singh', NULL, '2019-06-08 18:14:56', '2019-06-08 18:14:56'),
(15, 'base_url/uploads/media/1560006886_mobile_img2.png', 'Partner', 'Repair Services India Partner', NULL, '2019-06-08 20:35:43', '2019-06-08 20:44:46'),
(16, 'base_url/uploads/media/1560007107_mobile_2.png', 'mobile', 'Repair Services India Partner', NULL, '2019-06-08 20:48:27', '2019-06-08 20:48:27'),
(17, 'base_url/uploads/media/1560007779_Mobile3n.png', 'mobile', 'Repair Services India Partner', NULL, '2019-06-08 20:51:05', '2019-06-08 20:59:39'),
(18, 'base_url/uploads/media/1560022693_download.png', 'Profile', 'Pradeep Kumar', NULL, '2019-06-09 01:08:13', '2019-06-09 01:08:13'),
(19, 'base_url/uploads/media/1560022866_4.png', 'Linked In', 'Linked', NULL, '2019-06-09 01:11:06', '2019-06-09 01:11:06'),
(20, 'base_url/uploads/media/1560065721_Naitik_Verma.png', 'Naitik', 'Naitik Verma', NULL, '2019-06-09 13:05:21', '2019-06-09 13:05:21'),
(21, 'base_url/uploads/media/1585391304_renovating_home_banner.png', NULL, NULL, NULL, '2020-03-28 10:28:24', '2020-03-28 10:28:24'),
(22, 'base_url/uploads/media/1585391457_planning_a_wedding.png', NULL, NULL, NULL, '2020-03-28 10:30:57', '2020-03-28 10:30:57');

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

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `mid` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  `message` text NOT NULL,
  `admin_reply` int(11) NOT NULL DEFAULT 0,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `is_admin_read` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `mid` int(11) NOT NULL,
  `id` int(11) DEFAULT NULL,
  `member_type` varchar(20) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `admin_reply` int(11) DEFAULT 0,
  `parent_id` int(11) DEFAULT 0,
  `is_admin_read` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1);

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

--
-- Table structure for table `orders_completed`
--

CREATE TABLE `orders_completed` (
  `oc_id` int(11) NOT NULL,
  `oid` int(11) NOT NULL,
  `tid` int(11) DEFAULT NULL,
  `tl_id` int(11) DEFAULT NULL,
  `cid` int(11) DEFAULT NULL,
  `id` int(11) NOT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `payment_method` varchar(30) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `is_warrenty` int(11) DEFAULT NULL,
  `warrenty_msg` varchar(255) DEFAULT NULL,
  `other_items_details` text DEFAULT NULL,
  `other_items_total` float DEFAULT NULL,
  `grand_total` float DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orders_completed`
--

INSERT INTO `orders_completed` (`oc_id`, `oid`, `tid`, `tl_id`, `cid`, `id`, `ip`, `payment_method`, `comment`, `is_warrenty`, `warrenty_msg`, `other_items_details`, `other_items_total`, `grand_total`, `created_at`, `updated_at`) VALUES
(1, 5, 1, 4, 25, 2, '::1', 'cash', NULL, NULL, NULL, NULL, NULL, 420, '2020-04-04 16:05:38', '2020-04-04 16:05:38'),
(2, 6, 1, 5, 25, 3, '::1', 'cash', NULL, NULL, NULL, NULL, NULL, 6328, '2020-05-27 16:10:14', '2020-05-27 16:10:14'),
(3, 7, 1, 6, 25, 2, '::1', 'online', NULL, NULL, NULL, NULL, NULL, 6428, '2021-02-18 07:44:18', '2021-02-18 07:44:18');

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

--
-- Table structure for table `order_case_image`
--

CREATE TABLE `order_case_image` (
  `oci_id` int(11) NOT NULL,
  `oid` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `tl_id` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  `case_image_type` varchar(100) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `order_hardcopy_invoice`
--

CREATE TABLE `order_hardcopy_invoice` (
  `oh_id` int(11) NOT NULL,
  `oid` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `oi_id` int(11) NOT NULL,
  `oid` int(11) NOT NULL,
  `sid` int(11) DEFAULT NULL,
  `cid` int(11) DEFAULT NULL,
  `id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `cost` float DEFAULT NULL,
  `is_extra_order_items` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` (`oi_id`, `oid`, `sid`, `cid`, `id`, `title`, `cost`, `is_extra_order_items`, `created_at`, `updated_at`) VALUES
(6, 5, 1, 25, 2, 'AC Service', 120, NULL, '2020-04-04 15:50:19', NULL),
(7, 5, 3, 25, 2, 'AC Repair', 200, NULL, '2020-04-04 15:50:19', NULL),
(8, 5, NULL, NULL, 2, 'abc', 50, 1, '2020-04-04 16:05:38', NULL),
(9, 6, 1, 25, 3, 'AC Service', 120, NULL, '2020-05-27 16:07:28', NULL),
(10, 6, 3, 25, 3, 'AC Repair', 200, NULL, '2020-05-27 16:07:28', NULL),
(11, 6, 5, 25, 3, 'AC compressor Repair', 6008, NULL, '2020-05-27 16:07:28', NULL),
(12, 7, 1, 25, 2, 'AC Service', 120, NULL, '2021-02-18 07:31:01', NULL),
(13, 7, 3, 25, 2, 'AC Repair', 200, NULL, '2021-02-18 07:31:01', NULL),
(14, 7, 5, 25, 2, 'AC compressor Repair', 6008, NULL, '2021-02-18 07:31:01', NULL);

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

--
-- Table structure for table `order_service_charge`
--

CREATE TABLE `order_service_charge` (
  `osc_id` int(11) NOT NULL,
  `oid` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `tl_id` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `id` int(11) NOT NULL,
  `grand_total` float DEFAULT NULL,
  `commission_amount` float DEFAULT NULL,
  `commission_percentage` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_service_charge`
--

INSERT INTO `order_service_charge` (`osc_id`, `oid`, `tid`, `tl_id`, `cid`, `id`, `grand_total`, `commission_amount`, `commission_percentage`, `created_at`, `updated_at`) VALUES
(1, 5, 1, 4, 25, 2, 420, 47, 10, '2020-04-04 16:05:39', NULL),
(2, 6, 1, 5, 25, 3, 6328, 632.8, 10, '2020-05-27 16:10:14', NULL),
(3, 7, 1, 6, 25, 2, 6428, 642.8, 10, '2021-02-18 07:45:02', NULL);

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

--
-- Table structure for table `order_status`
--

CREATE TABLE `order_status` (
  `os_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_status`
--

INSERT INTO `order_status` (`os_id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Failed', '2018-03-19 20:10:24', '0000-00-00 00:00:00'),
(2, 'Refunded', '2018-03-19 20:10:24', '0000-00-00 00:00:00'),
(3, 'Cancelled', '2018-03-19 20:10:48', '0000-00-00 00:00:00'),
(4, 'Completed', '2018-03-19 20:10:48', '0000-00-00 00:00:00'),
(5, 'On Hold', '2018-03-19 20:11:12', '0000-00-00 00:00:00'),
(6, 'Processing', '2018-03-19 20:11:12', '0000-00-00 00:00:00'),
(7, 'Pending', '2018-03-19 20:11:22', '0000-00-00 00:00:00'),
(8, 'Customer Re-Scheduled', '2019-04-04 17:00:41', NULL),
(9, 'Customer Cancelled', '2019-04-04 17:00:41', NULL),
(10, 'Customer Unreachable', '2019-04-04 17:00:47', NULL);

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

--
-- Table structure for table `order_status_changes`
--

CREATE TABLE `order_status_changes` (
  `osc_id` int(11) NOT NULL,
  `oid` int(11) NOT NULL,
  `os_id` int(11) DEFAULT NULL,
  `changes_by` varchar(255) DEFAULT NULL,
  `changes_by_id` int(11) DEFAULT NULL,
  `reschedule_date` datetime DEFAULT NULL,
  `cancel_reason` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_status_changes`
--

INSERT INTO `order_status_changes` (`osc_id`, `oid`, `os_id`, `changes_by`, `changes_by_id`, `reschedule_date`, `cancel_reason`, `created_at`, `updated_at`) VALUES
(1, 5, 4, 'technician', 1, NULL, NULL, '2020-04-04 16:05:39', NULL),
(2, 6, 4, 'technician', 1, NULL, NULL, '2020-05-27 16:10:14', NULL),
(3, 7, 4, 'technician', 1, NULL, NULL, '2021-02-18 07:44:18', NULL);

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `page_id` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `body` longtext NOT NULL,
  `seo_keyword` text DEFAULT NULL,
  `seo_description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`page_id`, `title`, `slug`, `body`, `seo_keyword`, `seo_description`, `created_at`, `updated_at`) VALUES
(9, 'Privacy Policy', 'privacy-policy', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n', NULL, NULL, '2018-08-28 22:36:14', '2019-11-16 09:47:22'),
(10, 'About Us', 'about', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n', NULL, NULL, '2018-09-13 22:36:28', '2019-06-09 13:16:31'),
(11, 'Refund Policy', 'refund-policy', '<p>Coming Soon...</p>', NULL, NULL, '2018-09-13 22:37:01', '2018-09-13 22:37:01'),
(12, 'Cancelled Policy', 'cancelled-policy', '<p>Coming Soon...</p>', NULL, NULL, '2018-09-13 22:37:27', '2018-09-13 22:37:27'),
(13, 'Home Featured Story', 'home-featured-story', '<div class=\"row\">\r\n<div class=\"col  border1 pb-3 \">\r\n<div class=\"text-center pt-3\"><img class=\"rounded-circle\" src=\"http://localhost/urbanclap_clone_scripts/public/images/avatar.png\" style=\"width: 168px; height: 183px;\" /></div>\r\n\r\n<h4 class=\"pt-4 text-center\">Pooja Sharma</h4>\r\n\r\n<div class=\"text-center font-size-14\">Beautician</div>\r\n\r\n<hr />\r\n<div class=\"text-center\">Lorem ipsum dolor sit amet, consectetur adipiscing elit</div>\r\n</div>\r\n\r\n<div class=\"col  border1 pb-3 \">\r\n<div class=\"text-center pt-3\"><img class=\"rounded-circle\" src=\"http://localhost/urbanclap_clone_scripts/public/images/avatar.png\" style=\"width: 180px; height: 173px;\" /></div>\r\n\r\n<h4 class=\"pt-4 text-center\">Rohan Kumar</h4>\r\n\r\n<div class=\"text-center font-size-14\">Electrician</div>\r\n\r\n<hr />\r\n<div class=\"text-center\">Lorem ipsum dolor sit amet, consectetur adipiscing elit</div>\r\n</div>\r\n\r\n<div class=\"col  border1 pb-3 \">\r\n<div class=\"text-center pt-3\"><img class=\"rounded-circle\" src=\"http://localhost/urbanclap_clone_scripts/public/images/avatar.png\" style=\"width: 170px; height: 171px;\" /></div>\r\n\r\n<h4 class=\"pt-4 text-center\">Harpreet Singh</h4>\r\n\r\n<div class=\"text-center font-size-14\">Baby Portfolio Photographer</div>\r\n\r\n<hr />\r\n<div class=\"text-center\">Lorem ipsum dolor sit amet, consectetur adipiscing elit</div>\r\n</div>\r\n</div>', NULL, NULL, '2019-06-03 15:30:52', '2020-04-04 10:43:54'),
(14, 'Home Bottom photo', 'home-bottom-photo', '<div class=\"col-md-6\"><img class=\"img-fluid\" src=\"base_url/uploads/media/1585391304_renovating_home_banner.png\" /></div>\r\n\r\n<div class=\"col-md-6\"><img class=\"img-fluid\" src=\"base_url/uploads/media/1585391457_planning_a_wedding.png\" /></div>', NULL, NULL, '2019-06-04 06:30:26', '2020-03-28 10:31:07'),
(16, 'Terms & Conditions', 'terms', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n', NULL, NULL, '2019-06-07 16:26:01', '2019-06-07 16:34:33'),
(17, 'How it Works', 'how-it-works', '<p>test</p>', NULL, NULL, '2019-06-07 16:43:07', '2019-06-07 16:43:07'),
(18, 'Partner Help Center', 'help-center', 'We are here to help you .', NULL, NULL, '2019-06-08 22:52:56', '2020-04-04 13:28:18'),
(20, 'Create And Update Account', 'create-and-update-account', '<p>test</p>\r\n\r\n<p>&nbsp;</p>', NULL, NULL, '2019-06-09 13:27:19', '2019-06-09 13:27:19'),
(21, 'Wallet, Recharge & Refunds', 'wallet-recharge-refunds', '<p>test</p>', NULL, NULL, '2019-06-09 13:39:51', '2019-06-09 13:39:51'),
(22, 'Connect to Customers', 'connect-to-customers', '<p>test</p>', NULL, NULL, '2019-06-09 13:44:35', '2019-06-09 13:44:35'),
(23, 'App Download & Settings', 'app-download-settings', '<p>test</p>', NULL, NULL, '2019-06-09 13:54:35', '2019-06-09 13:54:35');

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `rev_id` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `review` text DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` (`rev_id`, `cid`, `id`, `name`, `rating`, `review`, `ip`, `status`, `created_at`, `updated_at`) VALUES
(1, 25, NULL, 'Pawan Kumar', 4, 'hello abc', '::1', 1, '2019-06-06 15:49:41', '2019-06-06 16:01:49'),
(2, 25, NULL, 'Manish Bagga', 5, 'Good service and overall behavior', '::1', 1, '2019-06-06 16:03:37', '2019-06-06 16:15:10'),
(3, 25, NULL, 'IMAM', 3, 'Fast service', '::1', 1, '2019-06-06 16:04:00', '2019-06-06 16:15:05'),
(4, 25, NULL, 'Nitesh Kumar Pathak', 5, 'Great job done', '::1', 1, '2019-06-06 16:04:20', '2019-06-06 16:19:01'),
(7, 28, NULL, 'asdfghjklkjhgfd', 4, 'sdfghjkl;\'lkjhgfd hdfghjkl;\';ln fghjkl;\';lkjbv kjhgfddsfghjklk.,', '49.34.83.198', 1, '2020-01-22 22:47:17', '2020-01-22 22:47:39');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `sid` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `body` text DEFAULT NULL,
  `cost` float DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`sid`, `cid`, `title`, `body`, `cost`, `weight`, `status`, `created_at`, `updated_at`) VALUES
(1, 25, 'AC Service', '<ul>\r\n	<li>\r\n	<p>Deep Cleaning the AC for fresh air</p>\r\n	</li>\r\n	<li>\r\n	<p>Filter, coils etc. cleaned with water</p>\r\n	</li>\r\n	<li>\r\n	<p>Save upto 20% on your summer electricity bill with regular servicing</p>\r\n\r\n	<hr />\r\n	<p>&nbsp;</p>\r\n	</li>\r\n</ul>', 120, 1, 1, '2019-03-15 12:17:35', '2019-05-07 22:02:11'),
(2, 29, 'Repair', '<p>red not&nbsp;</p>', 250, 2, 1, '2019-03-15 12:24:04', '2019-05-12 16:07:04'),
(3, 25, 'AC Repair', '<p>&nbsp;</p>\r\n\r\n<hr />\r\n<p>&nbsp;</p>', 200, 2, 1, '2019-03-18 01:18:26', '2019-05-07 22:03:58'),
(4, 25, 'Installation/Un-installation', '<p>&nbsp;</p>\r\n\r\n<p>Parts &amp; wall modification charges extra</p>', 250, 3, 1, '2019-03-18 01:18:43', '2019-03-18 01:41:22'),
(5, 25, 'AC compressor Repair', '<ul>\r\n	<li>AC compressor import export&nbsp;</li>\r\n	<li>Bxbxbx</li>\r\n	<li>Nznxnxjjd</li>\r\n	<li>Ndjdnxjj</li>\r\n</ul>', 6008, 2, 1, '2019-05-07 21:49:29', '2019-05-07 21:49:29'),
(6, 29, 'Not heating', '<p>hhhhhd</p>', 20000, 2, 1, '2019-05-12 16:07:39', '2019-05-12 16:07:39'),
(7, 27, 'Top load', '<hr />\r\n<p>&nbsp;</p>', 0, 2, 1, '2019-06-08 23:08:32', '2019-06-08 23:26:34'),
(8, 27, 'Front load', '<hr />\r\n<p>&nbsp;</p>', 0, 3, 1, '2019-06-08 23:08:55', '2019-06-08 23:26:49'),
(9, 27, 'Semi Automatic', '<hr />\r\n<p>&nbsp;</p>', 0, 5, 1, '2019-06-08 23:09:14', '2019-06-08 23:27:03'),
(10, 31, 'Spa Service', '<p>Spa Service</p>', 120, 1, 1, '2019-12-10 11:12:59', '2019-12-10 11:12:59'),
(11, 66, 'car rentel', '<p>esy to transform&nbsp;</p>', 780, 24, 1, '2019-12-14 22:01:44', '2019-12-14 22:01:44');

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

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

CREATE TABLE `settings` (
  `set_id` int(11) NOT NULL,
  `meta_key` varchar(255) NOT NULL,
  `meta_value` text DEFAULT NULL,
  `field_type` varchar(30) NOT NULL DEFAULT 'text',
  `weight` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `settings` (`set_id`, `meta_key`, `meta_value`, `field_type`, `weight`, `created_at`, `updated_at`) VALUES
(2, 'admin_mobile', '9999999999', 'text', 1, '2018-08-22 14:12:19', '2020-01-23 19:00:37'),
(3, 'admin_email', 'admin_email@gmail.com', 'text', 2, '2018-08-22 14:12:19', '2020-01-23 19:00:28'),
(4, 'default_category_image', 'default_category_image.png', 'text', 3, '2019-03-13 15:30:41', '2019-03-13 10:57:27'),
(6, 'minimum_wallet_balance', '-5000', 'text', 4, '2019-04-07 08:11:53', '2019-06-18 20:29:20'),
(7, 'install_app_sms_message', 'Need a beautician, plumber or your appliance repaired? Download from', 'text', 5, '2019-06-04 07:15:08', '2020-01-23 14:00:01'),
(8, 'customer_care_no', '9999999999', 'text', 6, '2019-06-06 16:40:41', '2020-01-23 19:00:28'),
(9, 'facebook', '#', 'text', 7, '2019-06-06 16:54:35', '2020-01-23 19:00:28'),
(10, 'twitter', '#', 'text', 8, '2019-06-06 16:54:35', '2020-01-23 19:00:28'),
(11, 'linkedin', '#', 'text', 9, '2019-06-06 16:55:26', '2020-01-23 19:00:28'),
(12, 'instagram', '#', 'text', 10, '2019-06-06 16:55:26', '2020-01-23 19:00:28'),
(13, 'footer_code', NULL, 'textarea', 11, '2019-06-13 10:45:16', '2020-01-23 19:00:28'),
(14, 'header_code', NULL, 'textarea', 12, '2019-06-13 10:45:16', '2020-01-23 19:00:28'),
(15, 'full_sms_api_url', '', 'text', 13, '2020-09-25 13:13:00', '2020-09-25 13:24:14'),
(16, 'show_otp_on_login', '1', 'text', 14, '2021-08-09 02:40:24', '0000-00-00 00:00:00');

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

--
-- Table structure for table `state`
--

CREATE TABLE `state` (
  `sid` int(11) NOT NULL,
  `name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `state`
--

INSERT INTO `state` (`sid`, `name`) VALUES
(1, 'Delhi'),
(2, 'Haryana'),
(3, 'Punjab'),
(4, 'Bihar'),
(5, 'Jharkhand');

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

--
-- Table structure for table `technician_categories`
--

CREATE TABLE `technician_categories` (
  `t_cid` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `cid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `technician_credits`
--

CREATE TABLE `technician_credits` (
  `tc_id` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `recharge_amount` float DEFAULT NULL,
  `total_balance` float DEFAULT NULL,
  `payment_method` varchar(30) DEFAULT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `oid` int(11) DEFAULT NULL,
  `tl_id` int(11) DEFAULT NULL,
  `is_recharged_by_admin` int(11) NOT NULL DEFAULT 0,
  `is_hold` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `technician_credits`
--

INSERT INTO `technician_credits` (`tc_id`, `tid`, `recharge_amount`, `total_balance`, `payment_method`, `transaction_id`, `oid`, `tl_id`, `is_recharged_by_admin`, `is_hold`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 10000, 10000, 'paytm', NULL, NULL, NULL, 1, 0, 1, '2020-04-04 16:05:11', NULL),
(2, 1, -47, 9953, 'cash', NULL, 5, 4, 0, 0, 1, '2020-04-04 16:05:38', NULL),
(3, 1, -632.8, 9320.2, 'cash', NULL, 6, 5, 0, 0, 1, '2020-05-27 16:10:14', NULL),
(5, 1, 5785.2, 15105.4, 'online', NULL, 7, 6, 0, 0, 1, '2021-02-18 07:45:02', NULL);

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

--
-- Table structure for table `technician_current_address`
--

CREATE TABLE `technician_current_address` (
  `tca_id` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `permanent_address_house_no` varchar(255) DEFAULT NULL,
  `permanent_address_locality` varchar(255) DEFAULT NULL,
  `permanent_address_pincode` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `technician_id_proofs`
--

CREATE TABLE `technician_id_proofs` (
  `tip_id` int(11) NOT NULL,
  `tid` int(11) DEFAULT NULL,
  `ipt_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `image_front` varchar(255) DEFAULT NULL,
  `image_back` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `technician_leads`
--

CREATE TABLE `technician_leads` (
  `tl_id` int(11) NOT NULL,
  `tid` int(11) DEFAULT NULL,
  `cid` int(11) NOT NULL,
  `oid` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `technician_leads`
--

INSERT INTO `technician_leads` (`tl_id`, `tid`, `cid`, `oid`, `created_at`, `updated_at`) VALUES
(3, 1, 25, 1, '2020-02-15 15:48:16', '2020-02-15 15:48:16'),
(4, 1, 25, 5, '2020-04-04 15:50:37', '2020-04-04 15:50:37'),
(5, 1, 25, 6, '2020-05-27 16:07:35', '2020-05-27 16:07:35'),
(6, 1, 25, 7, '2021-02-18 07:31:16', '2021-02-18 07:31:16');

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

--
-- Table structure for table `technician_personal_details`
--

CREATE TABLE `technician_personal_details` (
  `tpd_id` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `father_mother_name` varchar(255) DEFAULT NULL,
  `gender` varchar(15) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `permanent_address_house_no` varchar(255) DEFAULT NULL,
  `permanent_address_locality` varchar(255) DEFAULT NULL,
  `permanent_address_pincode` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `test_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `body` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `reviewed_on` varchar(255) DEFAULT NULL,
  `tid` int(11) DEFAULT NULL,
  `rating` varchar(255) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`test_id`, `name`, `body`, `image`, `reviewed_on`, `tid`, `rating`, `weight`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Priya', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit</p>', '1556087699_img_review.png', 'Facebook', 2, '4.5', 1, 1, '2019-04-24 06:34:59', '2020-03-28 10:17:11'),
(2, 'Radha', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit</p>', '1585390623_avatar5.png', 'Twitter', NULL, '4.6', 2, 1, '2019-04-24 06:37:04', '2020-03-28 10:17:03'),
(3, 'Neha', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit</p>', '1559999645_Stylish-Girls-DP-Pics-Photos-MyWhatsappimages.blogspot.com-Whats-app-photos-IMG_22904918831029.jpg', 'PlayStore', NULL, '5.0', 2, 1, '2019-05-15 18:15:05', '2020-03-28 10:16:52'),
(4, 'Pooja Sharma', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit</p>', '1559844277_family_reunuion_shirts2.jpg', 'PlayStore', NULL, '5', 4, 1, '2019-06-06 18:04:37', '2020-03-28 10:16:42'),
(5, 'Nisha', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit</p>', '1585986163_avatar5.png', 'Facebook', NULL, '5', NULL, 1, '2020-04-04 07:42:43', '2020-04-04 07:42:43'),
(6, 'Rohan', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit</p>', '1585986187_avatar5.png', 'Facebook', NULL, NULL, NULL, 1, '2020-04-04 07:43:07', '2020-04-04 07:43:07');

--
-- Indexes for table `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`bid`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`cid`);

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

--
-- Indexes for table `category_pop_up_advantage_images`
--
ALTER TABLE `category_pop_up_advantage_images`
  ADD PRIMARY KEY (`cp_id`);

--
-- Indexes for table `city`
--
ALTER TABLE `city`
  ADD PRIMARY KEY (`city_id`);

--
-- Indexes for table `contact_form`
--
ALTER TABLE `contact_form`
  ADD PRIMARY KEY (`cid`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`cid`),
  ADD UNIQUE KEY `coupons_code_unique` (`code`),
  ADD KEY `coupons_code_expires_at_index` (`code`),
  ADD KEY `coupons_code_active_index` (`code`),
  ADD KEY `coupons_code_active_expires_at_index` (`code`);

--
-- Indexes for table `coupon_used`
--
ALTER TABLE `coupon_used`
  ADD PRIMARY KEY (`cu_id`);

--
-- Indexes for table `home_categories`
--
ALTER TABLE `home_categories`
  ADD PRIMARY KEY (`hc_id`);

--
-- Indexes for table `identity_proof_types`
--
ALTER TABLE `identity_proof_types`
  ADD PRIMARY KEY (`ipt_id`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`mid`);

--
-- Indexes for table `message`
--
ALTER TABLE `message`
  ADD PRIMARY KEY (`mid`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`mid`);

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

--
-- Indexes for table `orders_completed`
--
ALTER TABLE `orders_completed`
  ADD PRIMARY KEY (`oc_id`);

--
-- Indexes for table `order_case_image`
--
ALTER TABLE `order_case_image`
  ADD PRIMARY KEY (`oci_id`);

--
-- Indexes for table `order_hardcopy_invoice`
--
ALTER TABLE `order_hardcopy_invoice`
  ADD PRIMARY KEY (`oh_id`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`oi_id`);

--
-- Indexes for table `order_service_charge`
--
ALTER TABLE `order_service_charge`
  ADD PRIMARY KEY (`osc_id`);

--
-- Indexes for table `order_status`
--
ALTER TABLE `order_status`
  ADD PRIMARY KEY (`os_id`);

--
-- Indexes for table `order_status_changes`
--
ALTER TABLE `order_status_changes`
  ADD PRIMARY KEY (`osc_id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`page_id`);

--
-- Indexes for table `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`rev_id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`sid`);

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

--
-- Indexes for table `state`
--
ALTER TABLE `state`
  ADD PRIMARY KEY (`sid`);

--
-- Indexes for table `technician_categories`
--
ALTER TABLE `technician_categories`
  ADD PRIMARY KEY (`t_cid`);

--
-- Indexes for table `technician_credits`
--
ALTER TABLE `technician_credits`
  ADD PRIMARY KEY (`tc_id`);

--
-- Indexes for table `technician_current_address`
--
ALTER TABLE `technician_current_address`
  ADD PRIMARY KEY (`tca_id`);

--
-- Indexes for table `technician_id_proofs`
--
ALTER TABLE `technician_id_proofs`
  ADD PRIMARY KEY (`tip_id`);

--
-- Indexes for table `technician_leads`
--
ALTER TABLE `technician_leads`
  ADD PRIMARY KEY (`tl_id`);

--
-- Indexes for table `technician_personal_details`
--
ALTER TABLE `technician_personal_details`
  ADD PRIMARY KEY (`tpd_id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`test_id`);

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `bid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `cid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `category_advantage_images`
--
ALTER TABLE `category_advantage_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `category_pop_up_advantage_images`
--
ALTER TABLE `category_pop_up_advantage_images`
  MODIFY `cp_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `cid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `coupon_used`
--
ALTER TABLE `coupon_used`
  MODIFY `cu_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `mid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `message`
--
ALTER TABLE `message`
  MODIFY `mid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `mid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `order_case_image`
--
ALTER TABLE `order_case_image`
  MODIFY `oci_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order_hardcopy_invoice`
--
ALTER TABLE `order_hardcopy_invoice`
  MODIFY `oh_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

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

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

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

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

--
-- AUTO_INCREMENT for table `technician_categories`
--
ALTER TABLE `technician_categories`
  MODIFY `t_cid` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `technician_current_address`
--
ALTER TABLE `technician_current_address`
  MODIFY `tca_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `technician_id_proofs`
--
ALTER TABLE `technician_id_proofs`
  MODIFY `tip_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `technician_personal_details`
--
ALTER TABLE `technician_personal_details`
  MODIFY `tpd_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `test_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

