-- phpMyAdmin SQL Dump -- version 5.0.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Aug 11, 2021 at 05:22 PM -- Server version: 10.4.14-MariaDB -- PHP Version: 7.3.21 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: `urbanclap_clone_scripts` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `aid` int(11) NOT NULL, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `photo` varchar(255) DEFAULT NULL, `username` varchar(50) NOT NULL, `password` varchar(255) NOT 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 `admin` -- INSERT INTO `admin` (`aid`, `name`, `email`, `photo`, `username`, `password`, `created_at`, `updated_at`) VALUES (2, 'Admin', 'admin@domain.com', '', 'admin', '$2y$10$IVXMDNv1X/yDdxD29b2VKuFm1TrUBcoKCNBL4TruyICDVAyEgiQKO', '2018-06-14 03:35:30', '2019-07-09 14:23:06'); -- -------------------------------------------------------- -- -- 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', '', '
\r\n
\r\n\r\n
Doorstep repair in 90 minutes\r\n\r\n

On-time service

\r\n\r\n\r\n
\r\n
\r\n\r\n
\r\n
\r\n\r\n
Experienced repair professionals\r\n\r\n

4.3+ star rated

\r\n\r\n\r\n
\r\n
\r\n\r\n
\r\n
\r\n\r\n
Customer protection\r\n\r\n

Insurance upto 10,000 INR

\r\n\r\n\r\n
\r\n
', '
\r\n
\r\n\r\n
Choose the type of AC\r\n\r\n

We Service all types of ACs: Split, Window, Central

\r\n\r\n
\r\n
\r\n\r\n
\r\n
\r\n\r\n
Choose the service you need\r\n\r\n

We provide repairs, installations & servicing

\r\n\r\n
\r\n
\r\n\r\n
\r\n
\r\n\r\n
Choose your time-slot\r\n\r\n

We service from 9 AM - 9 PM

\r\n\r\n
\r\n
\r\n\r\n
\r\n
\r\n\r\n
Hassle-free service\r\n\r\n

Our professional will get in touch with you one hour before the service

\r\n\r\n
\r\n
', '

Services offered in AC Service and Repair

\r\n\r\n\r\n\r\n

Why AC Service and Repair?

\r\n\r\n\r\n\r\n

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’t even need to clear your schedule as you can choose your desirable time slot. ’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.

\r\n\r\n

How it works?

\r\n\r\n

To find the best professionals near you in no time, you just need to go on the website or App and search for ‘AC Repair’ 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 – 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.

\r\n\r\n

AC Common Repair/Service Prices in Delhi

\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Part NameSpare Part Cost (INR)Labour Cost (INR)Final Cost
Repair Of PCB1500499NA
Gas ChargingNANA2500(Including Nitrogen Flushing)
\r\n\r\n

Window AC Repair/Service Prices in Delhi

\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Part NameLabour Cost (INR)  
Installation - Window (Copper Pipe And Stand Extra)499  
Uninstallation - Window399  
Wet Servicing - Window399  
\r\n\r\n

Split AC Repair/Service Prices in Delhi

\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Part NameLabour Cost (INR)  
Installation - Split (Copper Pipe And Stand Extra)1499  
Uninstallation - Split599  
Wet Servicing - Split499  
\r\n\r\n

Other AC Repair/Service Prices in Delhi

\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Part NameSpare Part Cost (INR)Labour Cost (INR) 
Copper Condenser Coil3700499 
Grill Cover1000349 
\r\n\r\n

AC Common Spare Parts Prices in Delhi

\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Repair/ServiceSpare Part Cost (INR)Labour Cost (INR) 
Blower1100499 
Grill1100349 
Fan Motor Outdoor1600499 
Replace LVT900499 
Replace Sensor350499 
Blower Motor2200499 
Copper Pipe (Per Meter)750499 
Replace Flap/Swing Motor400499 
\r\n\r\n

AC Common Spare Parts Prices in Delhi

\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Repair/ServiceSpare Part Cost (INR)Labour Cost (INR)Total Cost (INR)
Capacitor 2-5 Mfd200349NA
Capacitor 10-25 Mfd250349NA
Capacitor 35-50 Mfd300349NA
Capacitor 50-60 Mfd350349NA
AC Fan Blade700499NA
AC Valve700499NA
Compressor 0.8-1 Ton (Rs. 2500 Extra For Gas Charging)NANA6500
Compressor 1.5 Ton (Rs. 2500 Extra For Gas Charging)NANA7500
Compressor 2 Ton (Rs. 2500 Extra For Gas Charging)NANA9200
\r\n\r\n

Window AC Spare Parts Prices in Delhi

\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Repair/ServiceSpare Part Cost (INR)Labour Cost (INR) 
Copper Cooling Coil3700499 
Grill Cover1000349 
\r\n\r\n

Split AC Spare Parts Prices in Delhi

\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Repair/ServiceSpare Part Cost (INR)Labour Cost (INR) 
Copper Cooling Coil Split4700499 
Copper Coil Condenser 1 Ton Split2700499 
Copper Coil Condenser 1.5 Ton Split3300499 
Copper Coil Condenser 2 Ton Split3700499 
Split AC Floor Stand550499 
Split AC Wall Stand550499 
Contractor (Split AC)500499 
\r\n\r\n

Other AC Repair/Services in Delhi

\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Repair/ServiceLabour Cost (INR)  
Adjust Grill Locks249  
Adjust Pipe And Tight Compressor Screw349  
Cover All Lines By Insulation499  
Tighten/Replace Thimble349  
Replace Wires349  
Remove Pipe From Water249  
\r\n\r\n

* Branded spare parts will be charged at MRP
\r\n*Overall labour cost will not exceed INR 499

', '
\r\n\r\n
', 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', '
\r\n

Gshshs

', '
\r\n

GdddddGshshsddjjdj

', '
\r\n

Hhhhshhshdhhd

', '
\r\n

Jdjjxjdjjd cudjfj

', '
\r\n

Nxndnjxuhdjrhfjjfjf

', '
\r\n

Ndndnndhxuxhd

', 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', '

 

\r\n\r\n', NULL, NULL, NULL, '

                        Service Guarantee

\r\n\r\n

                                30-day service guarantee post service completion

\r\n\r\n

                                Customer Protection of upto Rs.10,000 against damages

\r\n\r\n

                                Surcharge of Rs. 150 for 9-10 PM service

\r\n\r\n

                        Expert Technicians

\r\n\r\n

                               Background checked and highly trained technicians

\r\n\r\n

                               Genuine parts & fixed pricing

\r\n\r\n

 

', 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` -- CREATE TABLE `orders` ( `oid` int(11) NOT NULL, `cid` int(11) DEFAULT NULL, `id` int(11) NOT NULL, `city_id` int(11) DEFAULT NULL, `shipping_same_as_billing` int(11) NOT NULL DEFAULT 0, `invoice_no` varchar(50) DEFAULT NULL, `transaction_id` varchar(100) DEFAULT NULL, `invoice_date` date NOT NULL, `tax` varchar(255) DEFAULT NULL, `sub_total` varchar(255) NOT NULL, `min_amount_for_user` float DEFAULT NULL, `final_subtotal` float DEFAULT NULL, `gst_amount` float DEFAULT NULL, `coupon_applied_id` int(11) DEFAULT NULL, `coupon_applied_discount` float DEFAULT NULL, `grand_total` float DEFAULT NULL, `order_comments` text DEFAULT NULL, `ip` varchar(100) NOT NULL, `payment_method` varchar(50) DEFAULT NULL, `name_title` varchar(20) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `flat_building` varchar(255) DEFAULT NULL, `location_field` varchar(255) DEFAULT NULL, `date_of_service` datetime DEFAULT NULL, `coupon` varchar(255) DEFAULT NULL, `order_pass_code` varchar(255) DEFAULT NULL, `billing_name` varchar(100) DEFAULT NULL, `billing_email` varchar(100) DEFAULT NULL, `billing_address` varchar(255) DEFAULT NULL, `billing_phone` varchar(50) DEFAULT NULL, `billing_gst_no` varchar(255) DEFAULT NULL, `billing_city` varchar(50) DEFAULT NULL, `billing_state` varchar(50) DEFAULT NULL, `billing_zip` int(10) DEFAULT NULL, `billing_country_code` varchar(3) DEFAULT NULL, `shipping_name` varchar(100) DEFAULT NULL, `shipping_email` varchar(100) DEFAULT NULL, `shipping_address` varchar(255) DEFAULT NULL, `shipping_phone` varchar(50) DEFAULT NULL, `shipping_city` varchar(50) DEFAULT NULL, `shipping_state` varchar(50) DEFAULT NULL, `shipping_zip` varchar(10) DEFAULT NULL, `shipping_country_code` varchar(3) 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 `orders` -- INSERT INTO `orders` (`oid`, `cid`, `id`, `city_id`, `shipping_same_as_billing`, `invoice_no`, `transaction_id`, `invoice_date`, `tax`, `sub_total`, `min_amount_for_user`, `final_subtotal`, `gst_amount`, `coupon_applied_id`, `coupon_applied_discount`, `grand_total`, `order_comments`, `ip`, `payment_method`, `name_title`, `name`, `phone`, `flat_building`, `location_field`, `date_of_service`, `coupon`, `order_pass_code`, `billing_name`, `billing_email`, `billing_address`, `billing_phone`, `billing_gst_no`, `billing_city`, `billing_state`, `billing_zip`, `billing_country_code`, `shipping_name`, `shipping_email`, `shipping_address`, `shipping_phone`, `shipping_city`, `shipping_state`, `shipping_zip`, `shipping_country_code`, `created_at`, `updated_at`) VALUES (5, 25, 2, 4, 0, '1', '21555151515', '2020-04-04', NULL, '320', 100, NULL, NULL, NULL, NULL, 470, NULL, '::1', 'paytm', 'Mr', 'Pooja', '9999968096', 'abcd', 'New Delhi', '2020-04-16 00:00:00', NULL, '1219', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-04-04 15:50:19', '2020-04-04 16:05:38'), (6, 25, 3, 6, 0, '2', NULL, '2020-05-27', NULL, '6328', NULL, NULL, NULL, NULL, NULL, 6328, NULL, '::1', 'pay_with_cash', 'Mr', 'Pooja', '3434343', 'abcd', 'ssss', '2020-05-28 00:00:00', NULL, '9697', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-05-27 16:07:28', '2020-05-27 16:07:28'), (7, 25, 2, 1, 0, '3', '', '2021-02-18', NULL, '6328', 100, NULL, NULL, NULL, NULL, 6428, NULL, '::1', 'pay_cash_after_service', 'Mr', 'test abc', '9999968096', 'test', 'ddd', '2021-02-20 00:00:00', NULL, '1521', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-02-18 07:31:01', '2021-02-18 07:31:01'); -- -------------------------------------------------------- -- -- 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', '

Coming Soon...

', NULL, NULL, '2018-09-13 22:37:01', '2018-09-13 22:37:01'), (12, 'Cancelled Policy', 'cancelled-policy', '

Coming Soon...

', NULL, NULL, '2018-09-13 22:37:27', '2018-09-13 22:37:27'), (13, 'Home Featured Story', 'home-featured-story', '
\r\n
\r\n
\r\n\r\n

Pooja Sharma

\r\n\r\n
Beautician
\r\n\r\n
\r\n
Lorem ipsum dolor sit amet, consectetur adipiscing elit
\r\n
\r\n\r\n
\r\n
\r\n\r\n

Rohan Kumar

\r\n\r\n
Electrician
\r\n\r\n
\r\n
Lorem ipsum dolor sit amet, consectetur adipiscing elit
\r\n
\r\n\r\n
\r\n
\r\n\r\n

Harpreet Singh

\r\n\r\n
Baby Portfolio Photographer
\r\n\r\n
\r\n
Lorem ipsum dolor sit amet, consectetur adipiscing elit
\r\n
\r\n
', NULL, NULL, '2019-06-03 15:30:52', '2020-04-04 10:43:54'), (14, 'Home Bottom photo', 'home-bottom-photo', '
\r\n\r\n
', 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', '

test

', 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', '

test

\r\n\r\n

 

', NULL, NULL, '2019-06-09 13:27:19', '2019-06-09 13:27:19'), (21, 'Wallet, Recharge & Refunds', 'wallet-recharge-refunds', '

test

', NULL, NULL, '2019-06-09 13:39:51', '2019-06-09 13:39:51'), (22, 'Connect to Customers', 'connect-to-customers', '

test

', NULL, NULL, '2019-06-09 13:44:35', '2019-06-09 13:44:35'), (23, 'App Download & Settings', 'app-download-settings', '

test

', NULL, NULL, '2019-06-09 13:54:35', '2019-06-09 13:54:35'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `password_resets` -- INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES ('Repairservicesindia1998@gmail.com', '$2y$10$o7A87WRMf/zPX6a.gXwwH.ethUv.9taxU1lZgAARBxPD4vgGMVzzy', '2018-09-04 23:46:46'); -- -------------------------------------------------------- -- -- Table structure for table `phone_varification` -- CREATE TABLE `phone_varification` ( `pv_id` int(11) NOT NULL, `phone` varchar(15) NOT NULL, `otp` int(11) NOT NULL, `is_varified` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `phone_varification` -- INSERT INTO `phone_varification` (`pv_id`, `phone`, `otp`, `is_varified`, `created_at`) VALUES (1, '9999968096', 1728, 1, '2020-01-23 13:47:51'), (2, '8527844965', 2205, 1, '2020-02-15 15:33:39'), (3, '0111111111', 6951, 0, '2021-08-09 04:08:02'), (4, '1111111111', 3169, 0, '2021-08-09 04:12:31'); -- -------------------------------------------------------- -- -- Table structure for table `phone_varification_partner` -- CREATE TABLE `phone_varification_partner` ( `pv_id` int(11) NOT NULL, `phone` varchar(15) NOT NULL, `otp` int(11) NOT NULL, `is_varified` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `phone_varification_partner` -- INSERT INTO `phone_varification_partner` (`pv_id`, `phone`, `otp`, `is_varified`, `created_at`) VALUES (1, '8130712202', 8569, 1, '2020-02-15 15:54:18'), (2, '9999968096', 5643, 1, '2020-04-04 15:50:51'); -- -------------------------------------------------------- -- -- 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', '', 120, 1, 1, '2019-03-15 12:17:35', '2019-05-07 22:02:11'), (2, 29, 'Repair', '

red not 

', 250, 2, 1, '2019-03-15 12:24:04', '2019-05-12 16:07:04'), (3, 25, 'AC Repair', '

 

\r\n\r\n
\r\n

 

', 200, 2, 1, '2019-03-18 01:18:26', '2019-05-07 22:03:58'), (4, 25, 'Installation/Un-installation', '

 

\r\n\r\n

Parts & wall modification charges extra

', 250, 3, 1, '2019-03-18 01:18:43', '2019-03-18 01:41:22'), (5, 25, 'AC compressor Repair', '', 6008, 2, 1, '2019-05-07 21:49:29', '2019-05-07 21:49:29'), (6, 29, 'Not heating', '

hhhhhd

', 20000, 2, 1, '2019-05-12 16:07:39', '2019-05-12 16:07:39'), (7, 27, 'Top load', '
\r\n

 

', 0, 2, 1, '2019-06-08 23:08:32', '2019-06-08 23:26:34'), (8, 27, 'Front load', '
\r\n

 

', 0, 3, 1, '2019-06-08 23:08:55', '2019-06-08 23:26:49'), (9, 27, 'Semi Automatic', '
\r\n

 

', 0, 5, 1, '2019-06-08 23:09:14', '2019-06-08 23:27:03'), (10, 31, 'Spa Service', '

Spa Service

', 120, 1, 1, '2019-12-10 11:12:59', '2019-12-10 11:12:59'), (11, 66, 'car rentel', '

esy to transform 

', 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 `technicians` -- CREATE TABLE `technicians` ( `tid` int(10) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `phone` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `city_id` int(11) DEFAULT NULL, `photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `declaration_is_agree` int(11) DEFAULT NULL, `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `badge` int(11) NOT NULL DEFAULT 0, `service_charge_per` int(11) DEFAULT 0, `status` int(11) DEFAULT 1, `accept_order` 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; -- -- Dumping data for table `technicians` -- INSERT INTO `technicians` (`tid`, `name`, `email`, `password`, `phone`, `city_id`, `photo`, `declaration_is_agree`, `remember_token`, `badge`, `service_charge_per`, `status`, `accept_order`, `created_at`, `updated_at`) VALUES (1, 'Pawan', 'webmaster.delhi1@gmail.com', '$2y$10$eXSYWyQxn6.WjRh0zSUCT.V1QjZ3BJAUSejSmY7qy.q/tiaovUpcG', '9999968096', NULL, NULL, NULL, NULL, 2, 10, 1, 1, '2020-02-15 15:35:03', '2020-02-15 15:35:03'), (2, NULL, NULL, NULL, '8130712202', NULL, NULL, NULL, NULL, 0, 0, 1, 1, '2020-02-15 15:54:36', '2020-02-15 15:54:36'); -- -------------------------------------------------------- -- -- 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', '

Lorem ipsum dolor sit amet, consectetur adipiscing elit

', '1556087699_img_review.png', 'Facebook', 2, '4.5', 1, 1, '2019-04-24 06:34:59', '2020-03-28 10:17:11'), (2, 'Radha', '

Lorem ipsum dolor sit amet, consectetur adipiscing elit

', '1585390623_avatar5.png', 'Twitter', NULL, '4.6', 2, 1, '2019-04-24 06:37:04', '2020-03-28 10:17:03'), (3, 'Neha', '

Lorem ipsum dolor sit amet, consectetur adipiscing elit

', '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', '

Lorem ipsum dolor sit amet, consectetur adipiscing elit

', '1559844277_family_reunuion_shirts2.jpg', 'PlayStore', NULL, '5', 4, 1, '2019-06-06 18:04:37', '2020-03-28 10:16:42'), (5, 'Nisha', '

Lorem ipsum dolor sit amet, consectetur adipiscing elit

', '1585986163_avatar5.png', 'Facebook', NULL, '5', NULL, 1, '2020-04-04 07:42:43', '2020-04-04 07:42:43'), (6, 'Rohan', '

Lorem ipsum dolor sit amet, consectetur adipiscing elit

', '1585986187_avatar5.png', 'Facebook', NULL, NULL, NULL, 1, '2020-04-04 07:43:07', '2020-04-04 07:43:07'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `name_title` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `phone` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `update_on_whatsapp` int(11) DEFAULT NULL, `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `status` int(11) NOT NULL DEFAULT 1, `document_id_proof` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `document_address_proof` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name_title`, `name`, `email`, `password`, `phone`, `update_on_whatsapp`, `address`, `photo`, `remember_token`, `status`, `document_id_proof`, `document_address_proof`, `created_at`, `updated_at`) VALUES (1, 'Mr', 'Hari', NULL, '$2y$10$HbT4CzcvDCOPD3BKXhZnqOpA5lAp/Kns2gNLNBQg1mXcMDa1Q8g8G', '8527844965', NULL, NULL, NULL, NULL, 1, NULL, NULL, '2020-02-15 15:34:19', '2020-02-15 15:34:19'), (2, 'Mr', 'Pooja', NULL, '$2y$10$e3zwy6N6SWM9B6YUFltoKumPHqyoPt5Zsx1Fsg30USGIXcLpPjeKC', '9999968096', NULL, NULL, NULL, NULL, 1, NULL, NULL, '2020-04-04 12:44:16', '2020-04-04 12:44:16'), (3, 'Mr', 'Pooja', NULL, '$2y$10$FiGe5TS0X6M.nnUe8cxqnOaGUfm5FrQEPdNd43bliTARuNB4ReznO', '3434343', NULL, NULL, NULL, NULL, 1, NULL, NULL, '2020-05-27 16:07:27', '2020-05-27 16:07:27'); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`aid`); -- -- 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` -- ALTER TABLE `orders` ADD PRIMARY KEY (`oid`); -- -- 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 `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `phone_varification` -- ALTER TABLE `phone_varification` ADD PRIMARY KEY (`pv_id`); -- -- Indexes for table `phone_varification_partner` -- ALTER TABLE `phone_varification_partner` ADD PRIMARY KEY (`pv_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 `technicians` -- ALTER TABLE `technicians` ADD PRIMARY KEY (`tid`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- 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`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `aid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 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` -- ALTER TABLE `orders` MODIFY `oid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- 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 `phone_varification` -- ALTER TABLE `phone_varification` MODIFY `pv_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `phone_varification_partner` -- ALTER TABLE `phone_varification_partner` MODIFY `pv_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 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 `technicians` -- ALTER TABLE `technicians` MODIFY `tid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 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; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; 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 */;