In today\'s fast-paced world, maintaining a stress-free home environment can be challenging. The demands of work, family, and social commitments leave little time for household chores and maintenance. This is where professional home services come to the rescue, ensuring your home remains a sanctuary of peace and comfort. Here are the top 10 must-have home services for stress-free living:<\\/p>\\r\\n
Regular cleaning services keep your home sparkling clean, eliminating dust, dirt, and allergens. Professional cleaners tackle hard-to-reach areas, ensuring a thorough clean and a healthy living environment.<\\/p>\\r\\n
Regular air conditioning maintenance ensures your system runs efficiently, preventing unexpected breakdowns and keeping your home cool during hot weather. Timely repairs also extend the lifespan of your AC unit.<\\/p>\\r\\n
From fixing leaky faucets to unclogging drains, professional plumbers handle all your plumbing needs. This prevents water damage, reduces the risk of mold growth, and maintains a smoothly running household.<\\/p>\\r\\n
Whether it\'s installing new lighting fixtures or repairing electrical issues, skilled electricians ensure your home\'s electrical system is safe and functional. This reduces the risk of electrical hazards and enhances your home\'s comfort.<\\/p>\\r\\n
Keep your home free from pests with regular pest control services. Professional exterminators identify and eliminate infestations, ensuring a pest-free environment and protecting your health and property.<\\/p>\\r\\n
A well-maintained garden enhances the beauty of your home. Gardening services include lawn care, pruning, and landscape design, creating a serene outdoor space for relaxation and enjoyment.<\\/p>\\r\\n
From minor repairs to major renovations, a handyman can tackle various tasks around the house, saving you time and effort. Their expertise ensures that your home is always in top condition.<\\/p>\\r\\n
Installing a home security system provides peace of mind by protecting your home from intruders and emergencies. Regular maintenance ensures the system is always operational, safeguarding your family and property.<\\/p>\\r\\n
Professional cleaning services remove deep-seated dirt and stains from carpets and upholstery, extending their lifespan and keeping your home fresh. This enhances indoor air quality and the overall cleanliness of your home.<\\/p>\\r\\n
Personal chefs or meal prep services take the hassle out of daily cooking, providing healthy, delicious meals tailored to your preferences. This saves time and ensures you and your family enjoy nutritious, home-cooked meals.<\\/p>\\r\\n
Investing in these essential home services not only maintains the functionality and aesthetics of your home but also significantly reduces stress. By outsourcing these tasks to professionals, you can focus on enjoying your living space and spending quality time with your loved ones. A clean, well-maintained home contributes to a healthier lifestyle, enhances your well-being, and ultimately provides a stress-free living environment. Embrace these services and transform your home into a sanctuary where you can relax, unwind, and recharge.<\\/p>\"}', '{\"en\":\"Top 10 Must-Have Home Services for a Stress-Free Living\"}', '{\"en\":\"Explore essential home services that can help you maintain a stress-free living environment.\"}', 1, 1, 1, '2024-06-14 13:10:04', '2024-06-24 10:50:11', NULL), (2, '{\"en\":\"Why Regular AC Maintenance is Essential for Your Home\"}', 'why-regular-ac-maintenance-is-essential-for-your-home', '{\"en\":\"Learn about the importance of regular AC maintenance and how it can benefit your home.\"}', '{\"en\":\"
Regular air conditioning maintenance is a crucial aspect of home care that is often overlooked. However, it plays a significant role in ensuring the comfort, efficiency, and longevity of your cooling system. Here are several reasons why regular AC maintenance is essential for your home:<\\/p>\\r\\n
Routine maintenance helps your air conditioner run more efficiently by ensuring all components are clean and functioning correctly. A well-maintained AC unit uses less energy to cool your home, which can significantly reduce your energy bills.<\\/p>\\r\\n
Regular maintenance extends the lifespan of your air conditioning unit. By addressing minor issues before they become major problems, you can avoid costly repairs or premature replacement of your system.<\\/p>\\r\\n
A well-maintained AC unit improves indoor air quality by reducing the accumulation of dust, allergens, and other pollutants. Regular cleaning and filter changes prevent these contaminants from circulating throughout your home, creating a healthier living environment.<\\/p>\\r\\n
Maintenance ensures that your AC unit performs consistently, providing reliable cooling throughout the hottest months. Regular check-ups can identify and resolve issues that may cause uneven cooling or system inefficiencies.<\\/p>\\r\\n
Routine inspections and tune-ups help detect potential problems early, preventing unexpected and costly breakdowns. This proactive approach saves you from the discomfort and inconvenience of a malfunctioning AC unit during peak usage times.<\\/p>\\r\\n
By addressing small issues during regular maintenance, you can avoid expensive repair bills. Preventative maintenance is generally more affordable than emergency repairs or complete system replacements.<\\/p>\\r\\n
Regular maintenance ensures that your AC unit operates safely. Technicians check for potential hazards such as refrigerant leaks or electrical issues, reducing the risk of accidents or damage to your home.<\\/p>\\r\\n
Many AC manufacturers require regular maintenance to keep the warranty valid. Skipping maintenance can void your warranty, leaving you responsible for any repair costs that would have otherwise been covered.<\\/p>\\r\\n
An efficiently running AC unit has a lower carbon footprint. By keeping your system in top condition, you contribute to environmental sustainability by reducing energy consumption and greenhouse gas emissions.<\\/p>\\r\\n
Knowing that your AC unit is well-maintained gives you peace of mind. You can relax and enjoy a comfortable home environment, confident that your cooling system is reliable and efficient.<\\/p>\\r\\n
In conclusion, regular AC maintenance is essential for ensuring the efficiency, longevity, and reliability of your air conditioning system. By investing in routine check-ups and cleanings, you can enjoy lower energy bills, improved air quality, and consistent cooling performance. Don\'t wait for your AC unit to break down—schedule regular maintenance to keep your home cool and comfortable all year round.<\\/p>\"}', '{\"en\":\"Why Regular AC Maintenance is Essential for Your Home\"}', '{\"en\":\"Learn about the importance of regular AC maintenance and how it can benefit your home.\"}', 1, 1, 1, '2024-06-14 13:11:52', '2024-06-24 10:47:05', NULL), (3, '{\"en\":\"The Ultimate Guide to Choosing the Best Spa Services Near You\"}', 'the-ultimate-guide-to-choosing-the-best-spa-services-near-you', '{\"en\":\"Find out how to select the perfect spa services to relax and rejuvenate your mind and body.\"}', '{\"en\":\"
Choosing the best spa services can be a daunting task, especially with so many options available. Whether you\'re looking for a relaxing massage, a rejuvenating facial, or a luxurious body treatment, it\'s important to choose a spa that meets your needs and provides the level of service you deserve. Here are some tips to help you choose the best spa services near you:<\\/p>\\r\\n
Before you start looking for a spa, determine what services you\'re interested in. Are you looking for a specific treatment, such as a deep tissue massage or a body wrap? Or are you looking for a spa that offers a variety of services so you can try different treatments?<\\/p>\\r\\n
Once you know what services you\'re looking for, research spas in your area that offer those services. Look for spas with positive reviews and a good reputation for providing high-quality services.<\\/p>\\r\\n
The atmosphere of a spa can greatly impact your experience. Consider whether you prefer a spa with a tranquil and relaxing atmosphere or one that is more lively and energetic.<\\/p>\\r\\n
It\'s important to choose a spa that prioritizes cleanliness and hygiene. Check online reviews or visit the spa in person to ensure that it meets your standards for cleanliness.<\\/p>\\r\\n
Before booking a service, ask about the spa\'s credentials. Find out if the spa is licensed and if the therapists are certified. This will ensure that you receive safe and professional services.<\\/p>\\r\\n
Before booking a service, inquire about pricing and packages. Ask about any discounts or promotions that may be available, and choose a spa that offers services within your budget.<\\/p>\\r\\n
Reading reviews and testimonials from previous clients can give you insight into the quality of services offered by a spa. Look for spas with positive reviews and satisfied customers.<\\/p>\\r\\n
If possible, visit the spa in person before booking a service. This will give you the opportunity to check out the facilities, meet the staff, and get a feel for the spa\'s atmosphere.<\\/p>\\r\\n
Ultimately, trust your instincts when choosing a spa. If something doesn\'t feel right or if you\'re not comfortable, it\'s okay to look elsewhere. Choose a spa that makes you feel welcome and valued.<\\/p>\\r\\n
By following these tips, you can choose the best spa services near you and enjoy a relaxing and rejuvenating experience. Whether you\'re looking for a quick massage or a full day of pampering, choosing the right spa is key to ensuring a memorable and enjoyable experience.<\\/p>\"}', '{\"en\":\"The Ultimate Guide to Choosing the Best Spa Services Near You\"}', '{\"en\":\"Find out how to select the perfect spa services to relax and rejuvenate your mind and body.\"}', 1, 1, 1, '2024-06-14 13:13:36', '2024-06-24 10:51:10', NULL), (4, '{\"en\":\"5 Reasons to Hire a Professional for Your Haircut\"}', '5-reasons-to-hire-a-professional-for-your-haircut', '{\"en\":\"Learn why it\'s beneficial to hire a professional for your haircut and how it can make a difference in your style.\"}', '{\"en\":\"
When it comes to getting a haircut, many people are tempted to save money by cutting their own hair or going to a budget salon. However, hiring a professional hairstylist offers several advantages that make it worth the investment. Here are five reasons to hire a professional for your haircut:<\\/p>\\r\\n
Professional hairstylists have the training and experience to create a hairstyle that suits your face shape, hair type, and lifestyle. They can also offer advice on hair care and styling techniques.<\\/p>\\r\\n
Professional hairstylists use high-quality tools and products to ensure a professional finish. They can also provide personalized recommendations for products that will help maintain your hairstyle.<\\/p>\\r\\n
Professional hairstylists take the time to listen to your needs and preferences. They can work with you to create a hairstyle that reflects your personality and style.<\\/p>\\r\\n
Professional hairstylists stay up-to-date with the latest trends and techniques in hair cutting and styling. They can offer modern and stylish options that you may not be able to achieve on your own.<\\/p>\\r\\n
Visiting a professional salon for your haircut is convenient and can save you time and effort. You can relax and enjoy the experience while your hairstylist takes care of the rest.<\\/p>\\r\\n
Overall, hiring a professional hairstylist for your haircut offers several benefits, including expertise, quality results, personalized service, up-to-date techniques, and convenience. If you want a haircut that looks great and makes you feel confident, consider booking an appointment with a professional hairstylist.<\\/p>\"}', '{\"en\":\"5 Reasons to Hire a Professional for Your Haircut\"}', '{\"en\":\"Learn why it\'s beneficial to hire a professional for your haircut and how it can make a difference in your style.\"}', 1, 1, 1, '2024-06-14 13:15:20', '2024-06-24 10:58:42', NULL), (5, '{\"en\":\"Spring Cleaning Made Easy: Tips from the Experts\"}', 'spring-cleaning-made-easy-tips-from-the-experts', '{\"en\":\"Get expert tips on how to make spring cleaning a breeze and keep your home looking fresh and clean.\"}', '{\"en\":\"
Spring is the perfect time to give your home a thorough cleaning and fresh start. Whether you\'re tackling a few cluttered areas or deep cleaning your entire house, these expert tips will help you make the most of your spring cleaning efforts.<\\/p>\\r\\n
Before you start cleaning, make a list of all the areas you want to tackle. This will help you stay organized and ensure that no area is overlooked.<\\/p>\\r\\n
Before you start cleaning, take some time to declutter your home. Get rid of items you no longer need or use to free up space and make cleaning easier.<\\/p>\\r\\n
Make sure you have all the necessary cleaning supplies before you start. This includes cleaning solutions, microfiber cloths, sponges, and scrub brushes.<\\/p>\\r\\n
Start cleaning high surfaces, such as ceilings and shelves, and work your way down to the floors. This will help you avoid spreading dust and dirt to areas you\'ve already cleaned.<\\/p>\\r\\n
Focus on cleaning one room at a time to avoid feeling overwhelmed. Start with the rooms you use most frequently, such as the kitchen and living room.<\\/p>\\r\\n
Pay attention to often overlooked areas, such as baseboards, ceiling fans, and light fixtures. These areas can collect dust and dirt and should be included in your cleaning routine.<\\/p>\\r\\n
Don\'t forget to freshen up your fabrics, such as curtains, rugs, and upholstery. You can vacuum, spot clean, or even wash these items to remove dirt and odors.<\\/p>\\r\\n
Spring cleaning doesn\'t have to be a solo effort. Get the whole family involved by assigning tasks and working together to clean and organize your home.<\\/p>\\r\\n
Spring cleaning can be physically and mentally exhausting, so be sure to take breaks when needed. Stay hydrated and listen to your body.<\\/p>\\r\\n
After you\'ve completed your spring cleaning, reward yourself for a job well done. Treat yourself to a relaxing bath or a day out to enjoy your clean and organized home.<\\/p>\\r\\n
By following these expert tips, you can make spring cleaning a breeze and enjoy a clean, fresh home all season long.<\\/p>\"}', '{\"en\":\"Spring Cleaning Made Easy: Tips from the Experts\"}', '{\"en\":\"Get expert tips on how to make spring cleaning a breeze and keep your home looking fresh and clean.\"}', 1, 1, 1, '2024-06-14 13:36:40', '2024-06-24 10:52:59', NULL), (6, '{\"en\":\"How to Choose the Right Vendor for Your Home Repair Needs\"}', 'how-to-choose-the-right-vendor-for-your-home-repair-needs', '{\"en\":\"Discover the key factors to consider when choosing a vendor for your home repair needs and ensure quality service.\"}', '{\"en\":\"
When it comes to home repairs, choosing the right vendor is crucial. Whether you\'re looking for a plumber, electrician, or general contractor, selecting the right vendor can ensure that the job is done correctly and efficiently. Here are some tips to help you choose the right vendor for your home repair needs:<\\/p>\\r\\n
Before you start looking for a vendor, determine exactly what repairs you need. This will help you narrow down your options and find a vendor who specializes in the type of work you need done.<\\/p>\\r\\n
Ask friends, family, and neighbors for recommendations. Word of mouth is often the best way to find a reliable and trustworthy vendor.<\\/p>\\r\\n
Once you have a list of potential vendors, do some research to learn more about each one. Check their website, read reviews, and look for any certifications or accreditations they may have.<\\/p>\\r\\n
Before you hire a vendor, get quotes from several different companies. This will help you compare prices and services to find the best option for your budget.<\\/p>\\r\\n
Ask the vendor for references from past clients. Contact these references to learn more about their experience working with the vendor and the quality of the work performed.<\\/p>\\r\\n
Make sure the vendor is properly insured and licensed to perform the work in your area. This will protect you in case of any accidents or issues during the repair process.<\\/p>\\r\\n
Find out if the vendor offers any guarantees or warranties on their work. This can give you peace of mind knowing that they stand behind their services.<\\/p>\\r\\n
Choose a vendor who communicates clearly and promptly. You should feel comfortable asking questions and discussing your needs with them.<\\/p>\\r\\n
Ultimately, trust your instincts when choosing a vendor. If something doesn\'t feel right or if you\'re not comfortable, it\'s okay to look for another option.<\\/p>\\r\\n
Before you sign a contract, review it carefully to ensure that all the details of the job are included. Make sure you understand the terms and conditions before work begins.<\\/p>\\r\\n
By following these tips, you can choose the right vendor for your home repair needs and ensure that the job is done right the first time.<\\/p>\"}', '{\"en\":\"How to Choose the Right Vendor for Your Home Repair Needs\"}', '{\"en\":\"Discover the key factors to consider when choosing a vendor for your home repair needs and ensure quality service.\"}', 1, 1, 1, '2024-06-14 13:38:27', '2024-06-24 10:54:01', NULL), (7, '{\"en\":\"Benefits of Professional AC Installation: What You Need to Know\"}', 'benefits-of-professional-ac-installation-what-you-need-to-know', '{\"en\":\"Learn about the benefits of professional AC installation and why it\'s essential for your home\'s comfort.\"}', '{\"en\":\"
When it comes to installing a new air conditioning system, many homeowners are tempted to tackle the job themselves to save money. However, professional AC installation offers several benefits that make it a worthwhile investment. Here\'s what you need to know:<\\/p>\\r\\n
Professional HVAC technicians have the knowledge and experience to properly size your AC unit for your home. This ensures that your new system is not too small, which can lead to inadequate cooling, or too large, which can result in higher energy bills and reduced comfort.<\\/p>\\r\\n
Professional installation ensures that your AC unit is installed correctly and according to manufacturer specifications. This helps prevent issues such as leaks, improper airflow, and premature breakdowns.<\\/p>\\r\\n
A properly installed AC unit operates more efficiently, leading to lower energy bills and reduced energy consumption. Professional installation also ensures that your system meets energy efficiency standards.<\\/p>\\r\\n
Many manufacturers require professional installation to validate the warranty on your new AC unit. Professional installation ensures that your warranty remains valid and protects you in case of any issues with your system.<\\/p>\\r\\n
Professional installation ensures that your AC unit is installed safely and according to building codes. This helps prevent issues such as electrical hazards and carbon monoxide leaks.<\\/p>\\r\\n
Professional installation ensures that your AC unit is properly sized and installed for optimal airflow. This helps ensure even cooling throughout your home and reduces strain on your system.<\\/p>\\r\\n
Proper installation and regular maintenance can help extend the life of your AC unit. Professional installation ensures that your system is installed correctly from the start, reducing the risk of premature breakdowns.<\\/p>\\r\\n
A properly installed AC unit provides better and more consistent cooling, leading to improved comfort in your home. Professional installation ensures that your system is set up to provide maximum comfort.<\\/p>\\r\\n
Overall, professional AC installation offers several benefits that make it a smart choice for homeowners. From proper sizing to energy efficiency, professional installation can help ensure that your new AC unit operates smoothly and efficiently for years to come.<\\/p>\"}', '{\"en\":\"Benefits of Professional AC Installation: What You Need to Know\"}', '{\"en\":\"Learn about the benefits of professional AC installation and why it\'s essential for your home\'s comfort.\"}', 1, 1, 1, '2024-06-14 13:48:18', '2024-06-24 10:56:14', NULL), (8, '{\"en\":\"Transform Your Home with Our Comprehensive Cleaning Services\"}', 'transform-your-home-with-our-comprehensive-cleaning-services', '{\"en\":\"Explore how our comprehensive cleaning services can transform your home and create a healthier living environment.\"}', '{\"en\":\"
Is your home in need of a deep clean? Our comprehensive cleaning services can transform your living space into a pristine and inviting environment. Whether you\'re looking to refresh your home for a special occasion or simply want to maintain a clean and healthy living environment, our team of experienced cleaners is here to help.<\\/p>\\r\\n
We understand that every home is unique, which is why we offer tailored cleaning solutions to meet your specific needs. Whether you need a one-time deep clean or regular maintenance cleaning, we can create a cleaning plan that works for you.<\\/p>\\r\\n
Our team is trained to deliver thorough and efficient cleaning services, ensuring that every corner of your home is spotless. From dusting and vacuuming to mopping and disinfecting, we use the latest cleaning techniques and eco-friendly products to achieve exceptional results.<\\/p>\\r\\n
You can trust our team to provide professional and reliable service every time. We arrive on time, equipped with all the necessary tools and supplies to complete the job efficiently. Your satisfaction is our top priority, and we strive to exceed your expectations with every cleaning.<\\/p>\\r\\n
Transforming your home doesn\'t have to break the bank. We offer competitive rates for our comprehensive cleaning services, making it easy and affordable to maintain a clean and healthy living environment.<\\/p>\\r\\n
Ready to transform your home? Contact us today to schedule your comprehensive cleaning service. Our friendly team is here to answer any questions you may have and help you create a cleaning plan that fits your needs and budget. Transform your home with our comprehensive cleaning services and enjoy a clean and healthy living environment.<\\/p>\"}', '{\"en\":\"Transform Your Home with Our Comprehensive Cleaning Services\"}', '{\"en\":\"Explore how our comprehensive cleaning services can transform your home and create a healthier living environment.\"}', 1, 1, 1, '2024-06-14 13:57:05', '2024-06-24 10:49:43', NULL), (9, '{\"en\":\"Expert Tips for Maintaining a Clean and Healthy Home\"}', 'expert-tips-for-maintaining-a-clean-and-healthy-home', '{\"en\":\"Get expert tips on how to maintain a clean and healthy home year-round and improve your quality of life.\"}', '{\"en\":\"
Keeping your home clean and healthy is essential for your wellbeing. From reducing allergens to preventing the spread of germs, maintaining a clean home can have a positive impact on your health. Here are some expert tips for keeping your home clean and healthy:<\\/p>\\r\\n
Set aside time each week for cleaning tasks, such as vacuuming, dusting, and mopping. Having a regular cleaning routine will help you stay on top of household chores and maintain a clean home.<\\/p>\\r\\n
Use cleaning products that are safe and effective for your home. Look for products that are eco-friendly and free from harsh chemicals.<\\/p>\\r\\n
Get rid of items you no longer need or use to reduce clutter in your home. Clutter can attract dust and make cleaning more difficult.<\\/p>\\r\\n
Pay extra attention to high-touch surfaces, such as doorknobs, light switches, and countertops. These areas can harbor germs and should be cleaned regularly.<\\/p>\\r\\n
The kitchen is a breeding ground for bacteria. Clean countertops, sinks, and appliances regularly to prevent the spread of germs.<\\/p>\\r\\n
Keep your bathroom clean and dry to prevent mold and mildew growth. Clean the toilet, sink, and shower regularly to maintain a healthy environment.<\\/p>\\r\\n
Wash bedding and linens, such as sheets and towels, regularly to remove dirt, dust, and allergens. Use hot water and a detergent that kills bacteria.<\\/p>\\r\\n
Use a vacuum cleaner with a HEPA filter to remove dust, dirt, and allergens from carpets and rugs. Dust surfaces regularly to prevent buildup.<\\/p>\\r\\n
Keep humidity levels in your home between 30-50% to prevent mold and mildew growth. Use a dehumidifier if necessary.<\\/p>\\r\\n
Open windows regularly to let in fresh air and improve ventilation. This can help reduce indoor air pollution and improve air quality.<\\/p>\\r\\n
By following these expert tips, you can maintain a clean and healthy home for you and your family. A clean home not only looks great but also contributes to a healthier living environment.<\\/p>\"}', '{\"en\":\"Expert Tips for Maintaining a Clean and Healthy Home\"}', '{\"en\":\"Get expert tips on how to maintain a clean and healthy home year-round and improve your quality of life.\"}', 1, 1, 1, '2024-06-14 13:58:58', '2024-06-24 10:54:59', NULL), (10, '{\"en\":\"The Importance of Regular Spa Treatments for Your Wellbeing\"}', 'the-importance-of-regular-spa-treatments-for-your-wellbeing', '{\"en\":\"Discover the importance of regular spa treatments for your overall wellbeing and how they can benefit you.\"}', '{\"en\":\"
Regular spa treatments are not just a luxury; they are essential for your overall wellbeing. In today\'s fast-paced world, it\'s important to take time for yourself and prioritize self-care. Spa treatments offer a variety of benefits for both your physical and mental health. Here are some reasons why regular spa treatments are important:<\\/p>\\r\\n
One of the primary benefits of spa treatments is stress relief. Massages, facials, and other spa treatments can help relax your body and mind, reducing stress levels and promoting a sense of calm and relaxation.<\\/p>\\r\\n
Many spa treatments, such as massages and hydrotherapy, can help relieve pain and discomfort in your muscles and joints. These treatments can improve circulation, reduce inflammation, and promote healing.<\\/p>\\r\\n
Facials, body wraps, and other spa treatments can improve the health and appearance of your skin. These treatments can help cleanse, exfoliate, and moisturize your skin, leaving it looking and feeling rejuvenated.<\\/p>\\r\\n
Spa treatments such as saunas and body wraps can help detoxify your body by eliminating toxins and impurities through sweating. This can improve your overall health and wellbeing.<\\/p>\\r\\n
Regular spa treatments can help improve your sleep quality by promoting relaxation and reducing stress. This can lead to better overall health and a greater sense of wellbeing.<\\/p>\\r\\n
Some spa treatments, such as aromatherapy and hydrotherapy, can help boost your immune system. These treatments can help your body fight off illness and infection, keeping you healthy.<\\/p>\\r\\n
Spa treatments can help improve your mental clarity and focus by reducing stress and promoting relaxation. This can improve your overall cognitive function and productivity.<\\/p>\\r\\n
Regular spa treatments can help enhance your mood by promoting relaxation and reducing stress. This can lead to a greater sense of happiness and wellbeing.<\\/p>\\r\\n
Overall, regular spa treatments are essential for maintaining your physical and mental health. By taking time for yourself and prioritizing self-care, you can improve your overall wellbeing and enjoy a happier, healthier life.<\\/p>\"}', '{\"en\":\"The Importance of Regular Spa Treatments for Your Wellbeing\"}', '{\"en\":\"Discover the importance of regular spa treatments for your overall wellbeing and how they can benefit you.\"}', 1, 1, 1, '2024-06-14 14:01:25', '2024-06-24 10:52:11', NULL), (11, '{\"en\":\"Why Hiring Professionals for Home Repairs Saves You Time and Money\"}', 'why-hiring-professionals-for-home-repairs-saves-you-time-and-money', '{\"en\":\"Learn about the advantages of hiring professionals for home repairs and how it can save you time and money in the long run.\"}', '{\"en\":\"
When it comes to home repairs, many homeowners are tempted to take the DIY route to save money. However, hiring professionals for home repairs can actually save you both time and money in the long run. Here are several reasons why investing in professional services is a wise decision:<\\/p>\\r\\n
Professional repair technicians have the training and experience to handle a wide range of home repair tasks. Their expertise ensures that repairs are done correctly the first time, reducing the likelihood of future issues and costly rework.<\\/p>\\r\\n
Professionals use high-quality materials and tools to complete repairs. Their attention to detail and adherence to industry standards result in durable, long-lasting repairs that stand the test of time.<\\/p>\\r\\n
Homeowners often underestimate the time required for DIY repairs. Professionals can complete repairs quickly and efficiently, freeing up your time for other important tasks and activities.<\\/p>\\r\\n
While it may seem cheaper to do repairs yourself, DIY projects can lead to mistakes that require expensive fixes. Professionals provide cost-effective solutions by getting the job done right the first time, preventing additional expenses down the line.<\\/p>\\r\\n
Home repairs can involve risks, such as electrical work, plumbing, or structural repairs. Professionals are trained to handle these tasks safely, minimizing the risk of accidents and injuries.<\\/p>\\r\\n
Professionals have access to specialized tools and equipment that are often necessary for certain repairs. Purchasing or renting these tools for a one-time repair can be costly and impractical for homeowners.<\\/p>\\r\\n
Many professional repair services offer warranties and guarantees on their work. This provides peace of mind, knowing that if something goes wrong, the issue will be resolved at no additional cost to you.<\\/p>\\r\\n
DIY repairs can sometimes uncover hidden issues that require additional expertise and resources. Professionals can identify and address these underlying problems, preventing unexpected costs from arising.<\\/p>\\r\\n
Quality repairs and maintenance by professionals can increase the value of your home. Whether you plan to sell your home in the future or simply want to maintain its value, professional repairs are a smart investment.<\\/p>\\r\\n
Attempting complex repairs on your own can be stressful and frustrating. Hiring professionals allows you to avoid this stress, knowing that skilled technicians are handling the repairs efficiently and effectively.<\\/p>\\r\\n
In conclusion, while DIY repairs may seem like a cost-saving measure, hiring professionals for home repairs offers numerous benefits. Their expertise, efficiency, and quality workmanship save you time, money, and stress. Investing in professional repair services ensures that your home remains in excellent condition, providing a safe and comfortable living environment for you and your family.<\\/p>\"}', '{\"en\":\"Why Hiring Professionals for Home Repairs Saves You Time and Money\"}', '{\"en\":\"Learn about the advantages of hiring professionals for home repairs and how it can save you time and money in the long run.\"}', 1, 1, 1, '2024-06-14 14:03:15', '2024-06-24 10:48:50', NULL), (12, '{\"en\":\"A Complete Guide to Our Home Service Offerings\"}', 'a-complete-guide-to-our-home-service-offerings', '{\"en\":\"Explore our comprehensive range of home services and find the right solutions for your home.\"}', '{\"en\":\"
We offer comprehensive HVAC services, including installation, repair, and maintenance of heating, ventilation, and air conditioning systems.<\\/p>\\r\\n
Our plumbing services include everything from leak detection and repair to drain cleaning and fixture installation.<\\/p>\\r\\n
We offer a full range of electrical services, including wiring, lighting installation, and electrical panel upgrades.<\\/p>\\r\\n
Our team can repair a wide range of appliances, including refrigerators, dishwashers, washing machines, and dryers.<\\/p>\\r\\n
We offer home security services, including installation of security cameras, alarms, and smart locks.<\\/p>\\r\\n
Our home automation services allow you to control your home\'s lighting, temperature, and security systems remotely.<\\/p>\\r\\n
We provide roofing and siding services, including repairs, replacements, and installations.<\\/p>\\r\\n
Our painting services include interior and exterior painting, as well as staining and sealing.<\\/p>\\r\\n
We offer carpentry services, including furniture assembly, custom cabinetry, and trim installation.<\\/p>\\r\\n
Our home cleaning services include regular maintenance cleaning, deep cleaning, and move-in\\/move-out cleaning.<\\/p>\\r\\n
Whatever your home service needs may be,has you covered. Our team of professionals is dedicated to providing high-quality service and ensuring your complete satisfaction. Contact us today to learn more about our home service offerings and schedule an appointment.<\\/p>\"}', '{\"en\":\"A Complete Guide to Our Home Service Offerings\"}', '{\"en\":\"Explore our comprehensive range of home services and find the right solutions for your home.\"}', 0, 1, 1, '2024-06-14 14:06:59', '2024-06-24 10:57:51', NULL), (13, '{\"en\":\"Consequuntur irure u\"}', 'consequuntur-irure-u', '{\"en\":\"Cupidatat dolore eve\"}', '{\"en\":\"
b vcb <\\/p>\"}', '{\"en\":\"At at exercitationem\"}', '{\"en\":\"Aut mollitia officia\"}', 0, 1, 1, '2024-11-14 05:52:24', '2024-11-14 05:52:42', '2024-11-14 05:52:42'); -- -------------------------------------------------------- -- -- Table structure for table `blog_categories` -- CREATE TABLE `blog_categories` ( `id` bigint(20) UNSIGNED NOT NULL, `blog_id` bigint(20) UNSIGNED NOT NULL, `category_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `blog_categories` -- INSERT INTO `blog_categories` (`id`, `blog_id`, `category_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 1, 55, NULL, NULL, NULL), (2, 2, 56, NULL, NULL, NULL), (3, 3, 57, NULL, NULL, NULL), (4, 4, 58, NULL, NULL, NULL), (5, 5, 59, NULL, NULL, NULL), (6, 6, 61, NULL, NULL, NULL), (7, 7, 56, NULL, NULL, NULL), (8, 7, 63, NULL, NULL, NULL), (9, 8, 59, NULL, NULL, NULL), (10, 9, 59, NULL, NULL, NULL), (11, 10, 57, NULL, NULL, NULL), (12, 11, 64, NULL, NULL, NULL), (13, 12, 55, NULL, NULL, NULL), (14, 13, 56, NULL, NULL, NULL), (15, 13, 58, NULL, NULL, NULL), (16, 13, 63, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `blog_tags` -- CREATE TABLE `blog_tags` ( `id` bigint(20) UNSIGNED NOT NULL, `blog_id` bigint(20) UNSIGNED NOT NULL, `tag_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `blog_tags` -- INSERT INTO `blog_tags` (`id`, `blog_id`, `tag_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 1, 1, NULL, NULL, NULL), (2, 1, 12, NULL, NULL, NULL), (3, 1, 30, NULL, NULL, NULL), (4, 2, 1, NULL, NULL, NULL), (5, 2, 6, NULL, NULL, NULL), (6, 2, 7, NULL, NULL, NULL), (7, 2, 9, NULL, NULL, NULL), (8, 2, 10, NULL, NULL, NULL), (9, 3, 11, NULL, NULL, NULL), (10, 3, 12, NULL, NULL, NULL), (11, 3, 13, NULL, NULL, NULL), (12, 4, 15, NULL, NULL, NULL), (13, 4, 16, NULL, NULL, NULL), (14, 4, 18, NULL, NULL, NULL), (15, 4, 29, NULL, NULL, NULL), (16, 5, 20, NULL, NULL, NULL), (17, 5, 21, NULL, NULL, NULL), (18, 5, 22, NULL, NULL, NULL), (19, 5, 24, NULL, NULL, NULL), (20, 6, 1, NULL, NULL, NULL), (21, 6, 26, NULL, NULL, NULL), (22, 6, 30, NULL, NULL, NULL), (23, 7, 1, NULL, NULL, NULL), (24, 7, 6, NULL, NULL, NULL), (25, 7, 7, NULL, NULL, NULL), (26, 8, 1, NULL, NULL, NULL), (27, 8, 14, NULL, NULL, NULL), (28, 8, 20, NULL, NULL, NULL), (29, 8, 22, NULL, NULL, NULL), (30, 9, 1, NULL, NULL, NULL), (31, 9, 14, NULL, NULL, NULL), (32, 9, 20, NULL, NULL, NULL), (33, 10, 11, NULL, NULL, NULL), (34, 10, 12, NULL, NULL, NULL), (35, 10, 26, NULL, NULL, NULL), (36, 11, 1, NULL, NULL, NULL), (37, 11, 3, NULL, NULL, NULL), (38, 12, 1, NULL, NULL, NULL), (39, 12, 2, NULL, NULL, NULL), (40, 13, 1, NULL, NULL, NULL), (41, 13, 4, NULL, NULL, NULL), (42, 13, 5, NULL, NULL, NULL), (43, 13, 6, NULL, NULL, NULL), (44, 13, 15, NULL, NULL, NULL), (45, 13, 20, NULL, NULL, NULL), (46, 13, 23, NULL, NULL, NULL), (47, 13, 24, NULL, NULL, NULL), (48, 13, 26, NULL, NULL, NULL), (49, 13, 27, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `bookings` -- CREATE TABLE `bookings` ( `id` bigint(20) UNSIGNED NOT NULL, `parent_id` bigint(20) UNSIGNED DEFAULT NULL, `booking_number` int(11) DEFAULT NULL, `consumer_id` bigint(20) UNSIGNED NOT NULL, `coupon_id` bigint(20) UNSIGNED DEFAULT NULL, `wallet_balance` decimal(8,2) DEFAULT NULL, `convert_wallet_balance` double DEFAULT NULL, `provider_id` bigint(20) UNSIGNED DEFAULT NULL, `service_id` bigint(20) UNSIGNED DEFAULT NULL, `service_package_id` bigint(20) UNSIGNED DEFAULT NULL, `address_id` bigint(20) UNSIGNED DEFAULT NULL, `service_price` decimal(8,2) DEFAULT NULL, `type` enum('fixed','provider_site','remotely','') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fixed', `tax` decimal(8,2) DEFAULT NULL, `per_serviceman_charge` decimal(8,2) DEFAULT NULL, `coupon_total_discount` decimal(8,2) DEFAULT NULL, `platform_fees` decimal(8,2) DEFAULT NULL, `platform_fees_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `required_servicemen` int(11) DEFAULT NULL, `total_extra_servicemen` int(11) DEFAULT NULL, `total_servicemen` int(11) DEFAULT NULL, `total_extra_servicemen_charge` decimal(8,2) DEFAULT NULL, `subtotal` decimal(8,2) DEFAULT NULL, `total` decimal(8,2) DEFAULT NULL, `date_time` datetime DEFAULT NULL, `booking_status_id` bigint(20) UNSIGNED DEFAULT NULL, `payment_method` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payment_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'PENDING', `description` text COLLATE utf8mb4_unicode_ci, `invoice_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` bigint(20) UNSIGNED DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `bookings` -- INSERT INTO `bookings` (`id`, `parent_id`, `booking_number`, `consumer_id`, `coupon_id`, `wallet_balance`, `convert_wallet_balance`, `provider_id`, `service_id`, `service_package_id`, `address_id`, `service_price`, `type`, `tax`, `per_serviceman_charge`, `coupon_total_discount`, `platform_fees`, `platform_fees_type`, `required_servicemen`, `total_extra_servicemen`, `total_servicemen`, `total_extra_servicemen_charge`, `subtotal`, `total`, `date_time`, `booking_status_id`, `payment_method`, `payment_status`, `description`, `invoice_url`, `created_by_id`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, NULL, 1073741824, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 27.00, NULL, 0.00, 10.00, 'fixed', 2, 0, 2, 180.00, 180.00, 217.00, '2024-11-19 18:04:51', 1, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741824', 2, NULL, '2025-03-06 10:09:54', '2024-07-22 21:20:01'), (2, 1, 1073741825, 2, NULL, NULL, NULL, 3, 3, NULL, 105, 180.00, 'fixed', 27.00, 90.00, 0.00, 0.00, 'fixed', 2, 0, 2, 180.00, 180.00, 207.00, '2024-07-23 12:44:00', 10, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741825', 2, NULL, '2025-03-06 10:09:54', '2024-07-22 22:27:42'), (3, NULL, 1073741826, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 6.38, NULL, 0.00, 10.00, 'fixed', 1, 0, 1, 42.50, 42.50, 58.88, '2024-11-19 00:00:00', 1, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741826', 2, NULL, '2025-03-06 10:09:54', '2024-07-22 23:08:29'), (4, 3, 1073741827, 2, NULL, NULL, NULL, 3, 25, NULL, 105, 42.50, 'fixed', 6.38, 42.50, 0.00, 0.00, 'fixed', 1, 0, 1, 42.50, 42.50, 48.88, '2024-07-23 12:36:00', 3, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741827', 3, NULL, '2025-03-06 10:09:54', '2024-07-23 01:04:29'), (5, NULL, 1073741828, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 6.38, NULL, 0.00, 10.00, 'fixed', 1, 0, 1, 42.50, 42.50, 58.88, '2024-11-19 18:06:26', 1, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741828', 18, NULL, '2025-03-06 10:09:54', '2024-07-23 01:15:25'), (6, 5, 1073741829, 18, NULL, NULL, NULL, 3, 25, NULL, 14, 42.50, 'fixed', 6.38, 42.50, 0.00, 0.00, 'fixed', 1, 0, 1, 42.50, 42.50, 48.88, '2024-07-25 14:44:00', 10, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741829', 18, NULL, '2025-03-06 10:09:54', '2024-07-23 01:17:29'), (7, NULL, 1073741830, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 9.87, NULL, 0.00, 10.00, 'fixed', 1, 0, 1, 65.80, 65.80, 85.67, '2024-11-19 18:06:26', 1, 'wallet', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741830', 2, NULL, '2025-03-06 10:09:54', '2024-07-23 02:12:07'), (8, 7, 1073741831, 2, NULL, NULL, NULL, 33, 18, NULL, 105, 65.80, 'fixed', 9.87, 65.80, 0.00, 0.00, 'fixed', 1, 0, 1, 65.80, 65.80, 75.67, '2024-07-24 15:41:00', 10, 'wallet', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741831', 2, NULL, '2025-03-06 10:09:54', '2024-07-23 02:17:44'), (9, NULL, 1073741832, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 13.37, NULL, 0.00, 10.00, 'fixed', 1, 0, 1, 89.10, 89.10, 112.47, '2024-11-19 18:06:26', 1, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741832', 2, NULL, '2025-03-06 10:09:54', '2024-07-23 04:50:12'), (10, 9, 1073741833, 2, NULL, NULL, NULL, 3, 12, NULL, 105, 89.10, 'fixed', 13.37, 89.10, 0.00, 0.00, 'fixed', 1, 0, 1, 89.10, 89.10, 102.47, '2024-07-24 18:17:00', 10, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741833', 2, NULL, '2025-03-06 10:09:54', '2024-07-23 04:54:10'), (19, NULL, 1073741834, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 13.37, NULL, 0.00, 10.00, 'fixed', 1, 0, 1, 89.10, 89.10, 112.47, '2024-11-19 18:06:26', 1, 'cash', 'PENDING', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741834', 2, NULL, '2025-03-06 10:09:54', '2024-07-24 01:15:46'), (20, 19, 1073741835, 2, NULL, NULL, NULL, 3, 12, NULL, 105, 89.10, 'fixed', 13.37, 89.10, 0.00, 0.00, 'fixed', 1, 0, 1, 89.10, 89.10, 102.47, '2024-07-27 14:45:00', 10, 'cash', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741835', 2, NULL, '2025-03-06 10:09:54', '2024-07-24 01:28:54'), (21, NULL, 1073741836, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 121.50, NULL, 0.00, 10.00, 'fixed', 3, 0, 3, 810.00, 810.00, 941.50, '2024-11-19 18:06:26', 3, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741836', 2, NULL, '2025-03-06 10:09:54', '2024-07-24 02:30:46'), (22, 21, 1073741837, 2, NULL, NULL, NULL, 3, 36, NULL, 105, 810.00, 'fixed', 121.50, 270.00, 0.00, 0.00, 'fixed', 3, 0, 3, 810.00, 810.00, 931.50, '2024-07-25 15:59:00', 3, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741837', 2, NULL, '2025-03-06 10:09:54', '2024-07-24 02:30:46'), (23, NULL, 1073741838, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 25.50, NULL, 0.00, 10.00, 'fixed', 1, 0, 1, 170.00, 170.00, 205.50, '2024-11-19 18:06:26', 4, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741838', 2, NULL, '2025-03-06 10:09:54', '2024-07-24 02:32:20'), (24, 23, 1073741839, 2, NULL, NULL, NULL, 30, 32, NULL, 105, 170.00, 'fixed', 25.50, 170.00, 0.00, 0.00, 'fixed', 1, 0, 1, 170.00, 170.00, 195.50, '2024-07-28 16:42:00', 4, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741839', 43, NULL, '2025-03-06 10:09:54', '2024-07-24 02:42:15'), (25, NULL, 1073741840, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 4.46, NULL, 0.00, 10.00, 'fixed', 1, 0, 1, 29.70, 29.70, 44.16, '2024-11-19 18:06:26', 9, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741840', 2, NULL, '2025-03-06 10:09:54', '2024-07-24 02:45:06'), (26, 25, 1073741841, 2, NULL, NULL, NULL, 30, 31, NULL, 105, 29.70, 'fixed', 4.46, 29.70, 0.00, 0.00, 'fixed', 1, 0, 1, 29.70, 29.70, 34.16, '2024-07-28 16:14:00', 9, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741841', 2, NULL, '2025-03-06 10:09:54', '2024-07-24 02:46:20'), (27, NULL, 1073741842, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 12.83, NULL, 0.00, 10.00, 'fixed', 1, 0, 1, 85.50, 85.50, 108.33, '2024-11-19 18:06:26', 8, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741842', 2, NULL, '2025-03-06 10:09:54', '2024-07-24 02:49:11'), (28, 27, 1073741843, 2, NULL, NULL, NULL, 33, 29, NULL, 105, 85.50, 'fixed', 12.83, 85.50, 0.00, 0.00, 'fixed', 1, 0, 1, 85.50, 85.50, 98.33, '2024-07-27 16:18:00', 8, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741843', 2, NULL, '2025-03-06 10:09:54', '2024-11-08 15:22:37'), (29, NULL, 1073741844, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 8.55, NULL, 0.00, 10.00, 'fixed', 1, 0, 1, 57.00, 57.00, 75.55, '2024-11-19 18:06:26', 7, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741844', 2, NULL, '2025-03-06 10:09:54', '2024-07-24 02:56:02'), (30, 29, 1073741845, 2, NULL, NULL, NULL, 33, 19, NULL, 105, 57.00, 'fixed', 8.55, 57.00, 0.00, 0.00, 'fixed', 1, 0, 1, 57.00, 57.00, 65.55, '2024-07-28 16:25:00', 7, 'paypal', 'COMPLETED', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741845', 2, NULL, '2025-03-06 10:09:54', '2024-07-24 02:58:09'), (31, NULL, 1073741846, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 25.50, NULL, 0.00, 10.00, 'fixed', 1, 0, 1, 170.00, 170.00, 205.50, '2024-11-19 18:06:26', 1, 'cash', 'PENDING', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741846', 2, NULL, '2025-03-06 10:09:54', '2024-07-24 03:36:53'), (32, 31, 1073741847, 2, NULL, NULL, NULL, 30, 32, NULL, 105, 170.00, 'fixed', 25.50, 170.00, 0.00, 0.00, 'fixed', 1, 0, 1, 170.00, 170.00, 195.50, '2024-07-24 17:01:00', 6, 'cash', 'PENDING', NULL, 'https://laia.webiots.co.in/booking/invoice/1073741847', 2, NULL, '2025-03-06 10:09:54', '2024-07-24 03:37:14'), (33, NULL, 1073741848, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 14.25, NULL, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 0.00, 95.00, 119.25, '2024-11-19 18:06:26', 1, 'paypal', 'PENDING', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741848', 2, NULL, '2025-03-06 10:09:54', '2024-11-08 14:47:36'), (34, 33, 1073741849, 2, NULL, NULL, NULL, 30, 9, 1, 109, 47.50, 'fixed', 7.13, 297.00, 0.00, 5.00, 'fixed', NULL, NULL, NULL, 0.00, 47.50, 59.63, '2024-11-19 18:06:26', 4, 'paypal', 'PENDING', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741849', 2, NULL, '2025-03-06 10:09:54', '2024-11-08 14:47:37'), (35, 33, 1073741850, 2, NULL, NULL, NULL, 30, 10, 1, 109, 47.50, 'fixed', 7.13, 765.00, 0.00, 5.00, 'fixed', NULL, NULL, NULL, 0.00, 47.50, 59.63, '2024-11-19 18:06:26', 4, 'paypal', 'PENDING', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741850', 2, NULL, '2025-03-06 10:09:54', '2024-11-08 14:47:38'), (36, NULL, 1073741851, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 27.00, NULL, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 180.00, 180.00, 217.00, '2024-11-19 18:06:26', 2, 'paypal', 'FAILED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741851', 2, NULL, '2025-03-06 10:09:54', '2024-11-08 14:55:12'), (37, 36, 1073741852, 2, NULL, NULL, NULL, 3, 3, NULL, 109, 180.00, 'fixed', 27.00, 90.00, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 180.00, 180.00, 217.00, '2024-11-19 18:06:26', 2, 'paypal', 'FAILED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741852', 2, NULL, '2025-03-06 10:09:54', '2024-11-08 14:55:12'), (38, NULL, 1073741853, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 27.00, NULL, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 180.00, 180.00, 217.00, '2024-11-19 18:06:26', 3, 'paypal', 'COMPLETED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741853', NULL, NULL, '2025-03-06 10:09:54', '2024-11-08 15:19:13'), (39, 38, 1073741854, 2, NULL, NULL, NULL, 3, 3, NULL, 105, 180.00, 'fixed', 27.00, 90.00, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 180.00, 180.00, 217.00, '2024-11-19 18:06:26', 3, 'paypal', 'COMPLETED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741854', 2, NULL, '2025-03-06 10:09:54', '2024-11-08 15:19:13'), (40, NULL, 1073741855, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 222.75, NULL, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 0.00, 1485.00, 1717.75, '2024-11-19 18:06:26', 1, 'paypal', 'COMPLETED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741855', NULL, NULL, '2025-03-06 10:09:54', '2024-11-08 15:25:20'), (41, 40, 1073741856, 2, NULL, NULL, NULL, 23, 20, 2, 105, 742.50, 'fixed', 111.38, 148.50, 0.00, 5.00, 'fixed', NULL, NULL, NULL, 0.00, 742.50, 858.88, '2024-11-19 18:06:26', 1, 'paypal', 'COMPLETED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741856', 2, NULL, '2025-03-06 10:09:54', '2024-11-08 15:25:20'), (42, 40, 1073741857, 2, NULL, NULL, NULL, 23, 21, 2, 105, 742.50, 'fixed', 111.38, 39.00, 0.00, 5.00, 'fixed', NULL, NULL, NULL, 0.00, 742.50, 858.88, '2024-11-19 18:06:26', 1, 'paypal', 'COMPLETED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741857', 2, NULL, '2025-03-06 10:09:54', '2024-11-08 15:25:20'), (43, NULL, 1073741858, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 27.00, NULL, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 180.00, 180.00, 217.00, '2024-11-19 18:06:26', 5, 'paypal', 'PENDING', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741858', 2, NULL, '2025-03-06 10:09:54', '2024-11-09 03:08:50'), (44, 43, 1073741859, 2, NULL, NULL, NULL, 3, 3, NULL, 105, 180.00, 'fixed', 27.00, 90.00, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 180.00, 180.00, 217.00, '2024-11-19 18:06:26', 5, 'paypal', 'PENDING', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741859', 2, NULL, '2025-03-06 10:09:54', '2024-11-09 03:08:52'), (45, NULL, 1073741860, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 27.00, NULL, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 180.00, 180.00, 217.00, '2024-11-19 18:06:26', 6, 'wallet', 'COMPLETED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741860', 2, NULL, '2025-03-06 10:09:54', '2024-11-10 11:46:33'), (46, 45, 1073741861, 2, NULL, NULL, NULL, 3, 3, NULL, 105, 180.00, 'fixed', 27.00, 90.00, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 180.00, 180.00, 217.00, '2024-11-19 18:06:26', 6, 'wallet', 'COMPLETED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741861', 2, NULL, '2025-03-06 10:09:54', '2024-11-10 11:46:33'), (47, NULL, 1073741862, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 27.00, NULL, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 180.00, 180.00, 217.00, '2024-11-19 18:06:26', 4, 'paypal', 'PENDING', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741862', 2, NULL, '2025-03-06 10:09:54', '2024-11-11 10:22:07'), (48, 47, 1073741863, 2, NULL, NULL, NULL, 3, 3, NULL, 105, 180.00, 'fixed', 27.00, 90.00, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 180.00, 180.00, 217.00, '2024-11-19 18:06:26', 4, 'paypal', 'PENDING', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741863', 2, NULL, '2025-03-06 10:09:54', '2024-11-11 10:22:09'), (49, NULL, 1073741864, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 27.00, NULL, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 180.00, 180.00, 217.00, '2024-11-19 18:06:26', 2, 'paypal', 'COMPLETED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741864', NULL, NULL, '2025-03-06 10:09:54', '2024-11-11 10:26:38'), (50, 49, 1073741865, 2, NULL, NULL, NULL, 3, 3, NULL, 105, 180.00, 'fixed', 27.00, 90.00, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 180.00, 180.00, 217.00, '2024-11-19 18:06:26', 2, 'paypal', 'COMPLETED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741865', 2, NULL, '2025-03-06 10:09:54', '2024-11-12 13:14:26'), (51, NULL, 1073741866, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 249.75, NULL, 0.00, 20.00, 'fixed', NULL, NULL, NULL, 180.00, 1665.00, 1934.75, '2024-11-19 18:06:26', 1, 'stripe', 'COMPLETED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741866', NULL, NULL, '2025-03-06 10:09:54', '2024-11-12 14:13:37'), (52, 51, 1073741867, 2, NULL, NULL, NULL, 23, 20, 2, 105, 742.50, 'fixed', 111.38, 148.50, 0.00, 5.00, 'fixed', NULL, NULL, NULL, 0.00, 742.50, 858.88, '2024-11-19 18:06:26', 1, 'stripe', 'COMPLETED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741867', 2, NULL, '2025-03-06 10:09:54', '2024-11-12 14:13:37'), (53, 51, 1073741868, 2, NULL, NULL, NULL, 23, 21, 2, 105, 742.50, 'fixed', 111.38, 39.00, 0.00, 5.00, 'fixed', NULL, NULL, NULL, 0.00, 742.50, 858.88, '2024-11-19 18:06:26', 1, 'stripe', 'COMPLETED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741868', 2, NULL, '2025-03-06 10:09:54', '2024-11-12 14:13:37'), (54, 51, 1073741869, 2, NULL, NULL, NULL, 3, 3, NULL, 105, 180.00, 'fixed', 27.00, 90.00, 0.00, 10.00, 'fixed', NULL, NULL, NULL, 180.00, 180.00, 217.00, '2024-11-19 18:06:26', 1, 'stripe', 'COMPLETED', NULL, 'http://127.0.0.1:8000/booking/invoice/1073741869', 2, NULL, '2025-03-06 10:09:54', '2024-11-12 14:13:37'), (55, NULL, 32768, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fixed', 6.37, NULL, 0.00, 10.00, 'fixed', 1, 0, 1, 42.49, 42.49, 58.87, NULL, 1, 'paypal', 'COMPLETED', NULL, 'https://fixit.webiots.co.in/booking/invoice/32768', 2, NULL, '2025-03-06 10:09:54', '2024-11-20 02:52:42'), (56, 55, 32769, 2, NULL, NULL, NULL, 3, 64, NULL, 105, 42.49, 'remotely', 6.37, 42.49, 0.00, 10.00, 'fixed', 1, 0, 1, 42.49, 42.49, 58.87, '2024-11-21 14:20:00', 10, 'paypal', 'COMPLETED', NULL, 'https://fixit.webiots.co.in/booking/invoice/32769', 2, NULL, '2025-03-06 10:09:54', '2024-11-20 03:03:58'); -- -------------------------------------------------------- -- -- Table structure for table `booking_additional_services` -- CREATE TABLE `booking_additional_services` ( `id` bigint(20) UNSIGNED NOT NULL, `booking_id` bigint(20) UNSIGNED NOT NULL, `additional_service_id` bigint(20) UNSIGNED NOT NULL, `price` decimal(10,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `booking_reason_logs` -- CREATE TABLE `booking_reason_logs` ( `id` bigint(20) UNSIGNED NOT NULL, `booking_id` bigint(20) UNSIGNED NOT NULL, `status_id` bigint(20) UNSIGNED NOT NULL, `reason` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `booking_service` -- CREATE TABLE `booking_service` ( `id` bigint(20) UNSIGNED NOT NULL, `booking_id` bigint(20) UNSIGNED DEFAULT NULL, `provider_id` bigint(20) UNSIGNED DEFAULT NULL, `service_id` bigint(20) UNSIGNED DEFAULT NULL, `service_package_id` bigint(20) UNSIGNED DEFAULT NULL, `service_price` decimal(8,2) DEFAULT NULL, `tax` decimal(8,2) DEFAULT NULL, `per_serviceman_charge` decimal(8,2) DEFAULT NULL, `total_extra_servicemen` decimal(8,2) DEFAULT NULL, `total_extra_servicemen_charge` decimal(8,2) DEFAULT NULL, `subtotal` decimal(8,2) DEFAULT NULL, `total` decimal(8,2) DEFAULT NULL, `date_time` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `booking_servicemen` -- CREATE TABLE `booking_servicemen` ( `id` bigint(20) UNSIGNED NOT NULL, `booking_id` bigint(20) UNSIGNED DEFAULT NULL, `serviceman_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `booking_servicemen` -- INSERT INTO `booking_servicemen` (`id`, `booking_id`, `serviceman_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 2, 27, NULL, NULL, NULL), (2, 2, 25, NULL, NULL, NULL), (3, 4, 27, NULL, NULL, NULL), (4, 6, 4, NULL, NULL, NULL), (5, 8, 58, NULL, NULL, NULL), (6, 10, 4, NULL, NULL, NULL), (10, 20, 25, NULL, NULL, NULL), (12, 24, 43, NULL, NULL, NULL), (13, 26, 43, NULL, NULL, NULL), (14, 28, 58, NULL, NULL, NULL), (15, 30, 58, NULL, NULL, NULL), (16, 56, 3, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `booking_status` -- CREATE TABLE `booking_status` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sequence` int(11) DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `created_by_id` bigint(20) UNSIGNED DEFAULT NULL, `system_reserve` int(11) NOT NULL DEFAULT '0', `hexa_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `booking_status` -- INSERT INTO `booking_status` (`id`, `name`, `slug`, `sequence`, `description`, `created_by_id`, `system_reserve`, `hexa_code`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Pending', 'pending', 1, NULL, 1, 1, '#FDB448', 1, '2024-06-13 11:38:16', '2024-06-13 11:38:16', NULL), (2, 'Accepted', 'accepted', 2, NULL, 1, 1, '#48BFFD', 1, '2024-06-13 11:38:16', '2024-06-13 11:38:16', NULL), (3, 'Assigned', 'assigned', 3, NULL, 1, 1, '#AD46FF', 1, '2024-06-13 11:38:16', '2024-06-13 11:38:16', NULL), (4, 'On The Way', 'on-the-way', 4, NULL, 1, 1, '#FF7456', 1, '2024-06-13 11:38:16', '2024-06-13 11:38:16', NULL), (5, 'Decline', 'decline', 5, NULL, 1, 1, '#FF4B4B', 1, '2024-06-13 11:38:16', '2024-06-13 11:38:16', NULL), (6, 'Cancel', 'cancel', 6, NULL, 1, 1, '#FF4B4B', 1, '2024-06-13 11:38:16', '2024-06-13 11:38:16', NULL), (7, 'On Going', 'on-going', 7, NULL, 1, 1, '#FF7456', 1, '2024-06-13 11:38:16', '2024-06-13 11:38:16', NULL), (8, 'On Hold', 'on-hold', 8, NULL, 1, 1, '#FF1D53', 1, '2024-06-13 11:38:16', '2024-06-13 11:38:16', NULL), (9, 'Start Again', 'start-again', 9, NULL, 1, 1, '#FF1D53', 1, '2024-06-13 11:38:16', '2024-06-13 11:38:16', NULL), (10, 'Completed', 'completed', 10, NULL, 1, 1, '#5465FF', 1, '2024-06-13 11:38:16', '2024-06-13 11:38:16', NULL), (11, 'Pending Approval', 'pending-approval', 11, NULL, 1, 1, '#5498FF', 1, '2024-06-13 11:38:16', '2024-06-13 11:38:16', NULL); -- -------------------------------------------------------- -- -- Table structure for table `booking_status_logs` -- CREATE TABLE `booking_status_logs` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `booking_id` bigint(20) UNSIGNED NOT NULL, `booking_status_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `booking_status_logs` -- INSERT INTO `booking_status_logs` (`id`, `title`, `description`, `booking_id`, `booking_status_id`, `created_at`, `updated_at`) VALUES (1, 'Pending booking request', 'New booking is added.', 1, 1, '2024-07-22 21:19:30', '2024-07-22 21:19:30'), (2, 'Pending booking request', 'New booking is added.', 2, 1, '2024-07-22 21:19:30', '2024-07-22 21:19:30'), (3, 'Booking is Assigned', 'The booking has been assigned.', 2, 3, '2024-07-22 22:18:53', '2024-07-22 22:18:53'), (4, 'Pending booking request', 'New booking is added.', 3, 1, '2024-07-22 23:07:46', '2024-07-22 23:07:46'), (5, 'Pending booking request', 'New booking is added.', 4, 1, '2024-07-22 23:07:46', '2024-07-22 23:07:46'), (6, 'Booking is Assigned', 'The booking has been assigned.', 4, 3, '2024-07-23 01:04:29', '2024-07-23 01:04:29'), (7, 'Pending booking request', 'New booking is added.', 5, 1, '2024-07-23 01:14:51', '2024-07-23 01:14:51'), (8, 'Pending booking request', 'New booking is added.', 6, 1, '2024-07-23 01:14:52', '2024-07-23 01:14:52'), (9, 'Booking is Assigned', 'The booking has been assigned.', 6, 3, '2024-07-23 01:15:49', '2024-07-23 01:15:49'), (10, 'Pending booking request', 'New booking is added.', 7, 1, '2024-07-23 02:12:06', '2024-07-23 02:12:06'), (11, 'Pending booking request', 'New booking is added.', 8, 1, '2024-07-23 02:12:06', '2024-07-23 02:12:06'), (12, 'Booking is Assigned', 'The booking has been assigned.', 8, 3, '2024-07-23 02:12:43', '2024-07-23 02:12:43'), (13, 'Pending booking request', 'New booking is added.', 9, 1, '2024-07-23 04:49:30', '2024-07-23 04:49:30'), (14, 'Pending booking request', 'New booking is added.', 10, 1, '2024-07-23 04:49:30', '2024-07-23 04:49:30'), (15, 'Booking is Assigned', 'The booking has been assigned.', 10, 3, '2024-07-23 04:52:15', '2024-07-23 04:52:15'), (26, 'Pending booking request', 'New booking is added.', 19, 1, '2024-07-24 01:15:45', '2024-07-24 01:15:45'), (27, 'Pending booking request', 'New booking is added.', 20, 1, '2024-07-24 01:15:45', '2024-07-24 01:15:45'), (28, 'Booking is Assigned', 'The booking has been assigned.', 20, 3, '2024-07-24 01:26:00', '2024-07-24 01:26:00'), (29, 'Pending booking request', 'New booking is added.', 21, 1, '2024-07-24 02:29:29', '2024-07-24 02:29:29'), (30, 'Pending booking request', 'New booking is added.', 22, 1, '2024-07-24 02:29:29', '2024-07-24 02:29:29'), (31, 'Pending booking request', 'New booking is added.', 23, 1, '2024-07-24 02:32:04', '2024-07-24 02:32:04'), (32, 'Pending booking request', 'New booking is added.', 24, 1, '2024-07-24 02:32:05', '2024-07-24 02:32:05'), (33, 'Booking is Assigned', 'The booking has been assigned.', 24, 3, '2024-07-24 02:36:21', '2024-07-24 02:36:21'), (34, 'Booking is Assigned', 'The booking has been assigned.', 24, 3, '2024-07-24 02:40:22', '2024-07-24 02:40:22'), (35, 'Pending booking request', 'New booking is added.', 25, 1, '2024-07-24 02:44:46', '2024-07-24 02:44:46'), (36, 'Pending booking request', 'New booking is added.', 26, 1, '2024-07-24 02:44:47', '2024-07-24 02:44:47'), (37, 'Booking is Assigned', 'The booking has been assigned.', 26, 3, '2024-07-24 02:45:52', '2024-07-24 02:45:52'), (38, 'Pending booking request', 'New booking is added.', 27, 1, '2024-07-24 02:48:55', '2024-07-24 02:48:55'), (39, 'Pending booking request', 'New booking is added.', 28, 1, '2024-07-24 02:48:55', '2024-07-24 02:48:55'), (40, 'Booking is Assigned', 'The booking has been assigned.', 28, 3, '2024-07-24 02:51:57', '2024-07-24 02:51:57'), (41, 'Pending booking request', 'New booking is added.', 29, 1, '2024-07-24 02:55:43', '2024-07-24 02:55:43'), (42, 'Pending booking request', 'New booking is added.', 30, 1, '2024-07-24 02:55:44', '2024-07-24 02:55:44'), (43, 'Booking is Assigned', 'The booking has been assigned.', 30, 3, '2024-07-24 02:56:42', '2024-07-24 02:56:42'), (44, 'Pending booking request', 'New booking is added.', 31, 1, '2024-07-24 03:36:51', '2024-07-24 03:36:51'), (45, 'Pending booking request', 'New booking is added.', 32, 1, '2024-07-24 03:36:52', '2024-07-24 03:36:52'), (46, 'Pending booking request', 'New booking is added.', 33, 1, '2024-11-08 14:47:36', '2024-11-08 14:47:36'), (47, 'Pending booking request', 'New booking is added.', 34, 1, '2024-11-08 14:47:37', '2024-11-08 14:47:37'), (48, 'Pending booking request', 'New booking is added.', 35, 1, '2024-11-08 14:47:38', '2024-11-08 14:47:38'), (49, 'Pending booking request', 'New booking is added.', 36, 1, '2024-11-08 14:55:10', '2024-11-08 14:55:10'), (50, 'Pending booking request', 'New booking is added.', 37, 1, '2024-11-08 14:55:11', '2024-11-08 14:55:11'), (51, 'Pending booking request', 'New booking is added.', 38, 1, '2024-11-08 15:18:27', '2024-11-08 15:18:27'), (52, 'Pending booking request', 'New booking is added.', 39, 1, '2024-11-08 15:18:28', '2024-11-08 15:18:28'), (53, 'Booking Completed', 'The booking has been completed.', 28, 10, '2024-11-08 15:22:37', '2024-11-08 15:22:37'), (54, 'Pending booking request', 'New booking is added.', 40, 1, '2024-11-08 15:24:59', '2024-11-08 15:24:59'), (55, 'Pending booking request', 'New booking is added.', 41, 1, '2024-11-08 15:25:00', '2024-11-08 15:25:00'), (56, 'Pending booking request', 'New booking is added.', 42, 1, '2024-11-08 15:25:02', '2024-11-08 15:25:02'), (57, 'Pending booking request', 'New booking is added.', 43, 1, '2024-11-09 03:08:50', '2024-11-09 03:08:50'), (58, 'Pending booking request', 'New booking is added.', 44, 1, '2024-11-09 03:08:52', '2024-11-09 03:08:52'), (59, 'Pending booking request', 'New booking is added.', 45, 1, '2024-11-10 11:46:31', '2024-11-10 11:46:31'), (60, 'Pending booking request', 'New booking is added.', 46, 1, '2024-11-10 11:46:33', '2024-11-10 11:46:33'), (61, 'Pending booking request', 'New booking is added.', 47, 1, '2024-11-11 10:22:07', '2024-11-11 10:22:07'), (62, 'Pending booking request', 'New booking is added.', 48, 1, '2024-11-11 10:22:09', '2024-11-11 10:22:09'), (63, 'Pending booking request', 'New booking is added.', 49, 1, '2024-11-11 10:26:03', '2024-11-11 10:26:03'), (64, 'Pending booking request', 'New booking is added.', 50, 1, '2024-11-11 10:26:05', '2024-11-11 10:26:05'), (65, 'Booking Canceled', 'The booking has been canceled.', 50, 6, '2024-11-12 13:14:26', '2024-11-12 13:14:26'), (66, 'Pending booking request', 'New booking is added.', 51, 1, '2024-11-12 14:11:59', '2024-11-12 14:11:59'), (67, 'Pending booking request', 'New booking is added.', 52, 1, '2024-11-12 14:12:02', '2024-11-12 14:12:02'), (68, 'Pending booking request', 'New booking is added.', 53, 1, '2024-11-12 14:12:04', '2024-11-12 14:12:04'), (69, 'Pending booking request', 'New booking is added.', 54, 1, '2024-11-12 14:12:05', '2024-11-12 14:12:05'), (70, 'Pending booking request', 'New booking is added.', 55, 1, '2024-11-20 02:52:08', '2024-11-20 02:52:08'), (71, 'Pending booking request', 'New booking is added.', 56, 1, '2024-11-20 02:52:08', '2024-11-20 02:52:08'), (72, 'Booking Accepted', 'The booking has been accepted by the provider.', 56, 2, '2024-11-20 02:55:08', '2024-11-20 02:55:08'), (73, 'Booking is Assigned', 'The booking has been assigned.', 56, 3, '2024-11-20 02:55:17', '2024-11-20 02:55:17'), (74, 'Booking On Going', 'The booking has been on going.', 56, 7, '2024-11-20 02:55:31', '2024-11-20 02:55:31'), (75, 'Booking Completed', 'The booking has been completed.', 56, 10, '2024-11-20 03:03:58', '2024-11-20 03:03:58'); -- -------------------------------------------------------- -- -- Table structure for table `booking_transactions` -- CREATE TABLE `booking_transactions` ( `id` bigint(20) UNSIGNED NOT NULL, `transaction_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `booking_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint(20) UNSIGNED NOT NULL, `title` text COLLATE utf8mb4_unicode_ci, `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `parent_id` int(11) DEFAULT NULL, `meta_title` text COLLATE utf8mb4_unicode_ci, `meta_description` longtext COLLATE utf8mb4_unicode_ci, `commission` decimal(8,2) DEFAULT '0.00', `status` int(11) NOT NULL DEFAULT '0', `is_featured` int(11) NOT NULL DEFAULT '0', `category_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `title`, `slug`, `description`, `parent_id`, `meta_title`, `meta_description`, `commission`, `status`, `is_featured`, `category_type`, `created_by`, `created_at`, `updated_at`, `deleted_at`) VALUES (7, '{\"en\":\"AC Repair\",\"ar\":\"إصلاح التيار المتردد\",\"de\":\"AC-Reparatur\"}', 'ac-repair', '{\"en\":\"Comprehensive AC repair services for all types and brands of air conditioners, ensuring your cooling systems are running efficiently and effectively.\",\"ar\":\"خدمات إصلاح مكيفات الهواء الشاملة لجميع أنواع وماركات مكيفات الهواء، مما يضمن تشغيل أنظمة التبريد لديك بكفاءة وفعالية.\",\"de\":\"Umfassende AC-Reparaturdienste für alle Arten und Marken von Klimaanlagen, um sicherzustellen, dass Ihre Kühlsysteme effizient und effektiv funktionieren.\"}', NULL, NULL, NULL, 5.00, 1, 1, 'service', 1, '2024-06-14 10:40:34', '2025-02-05 05:04:52', NULL), (8, '{\"en\":\"AC Installation\",\"de\":\"AC-Installation\",\"ar\":\"تركيب مكيف الهواء\"}', 'ac-installation', '{\"en\":\"Professional installation of new air conditioning units, ensuring proper setup and optimal performance.\",\"de\":\"Professionelle Installation neuer Klimaanlagen, um eine ordnungsgemäße Einrichtung und optimale Leistung sicherzustellen.\",\"ar\":\"التركيب الاحترافي لوحدات تكييف الهواء الجديدة، مما يضمن الإعداد المناسب والأداء الأمثل.\"}', 7, NULL, NULL, 7.00, 1, 1, 'service', 1, '2024-06-14 10:55:48', '2025-02-05 05:07:45', NULL), (9, '{\"en\":\"AC Maintenance\",\"ar\":\"صيانة مكيفات الهواء\",\"de\":\"AC-Wartung\"}', 'ac-maintenance', '{\"en\":\"Regular servicing to maintain optimal performance.\",\"ar\":\"الصيانة الدورية للحفاظ على الأداء الأمثل.\",\"de\":\"Regelmäßige Wartung zur Aufrechterhaltung einer optimalen Leistung.\"}', 7, NULL, NULL, 9.00, 1, 0, 'service', 1, '2024-06-14 10:56:47', '2025-02-05 05:09:57', NULL), (10, '{\"en\":\"Emergency Repair\",\"ar\":\"إصلاح الطوارئ\",\"de\":\"Notfallreparatur\"}', 'emergency-repair', '{\"en\":\"Immediate response to urgent repair needs.\",\"ar\":\"الاستجابة الفورية لاحتياجات الإصلاح العاجلة.\",\"de\":\"Sofortige Reaktion auf dringenden Reparaturbedarf.\"}', 7, NULL, NULL, 5.00, 1, 0, 'service', 1, '2024-06-14 10:57:19', '2025-02-05 05:12:30', NULL), (11, '{\"en\":\"Duct Cleaning\",\"ar\":\"تنظيف القناة\",\"de\":\"Kanalreinigung\"}', 'duct-cleaning', '{\"en\":\"Cleaning and maintenance of air ducts.\",\"ar\":\"تنظيف وصيانة مجاري الهواء.\",\"de\":\"Reinigung und Wartung von Luftkanälen.\"}', 7, NULL, NULL, 2.00, 1, 1, 'service', 1, '2024-06-14 10:57:46', '2025-02-05 05:14:32', NULL), (12, '{\"en\":\"Thermostat Repair\",\"ar\":\"إصلاح ترموستات\",\"de\":\"Thermostatreparatur\"}', 'thermostat-repair', '{\"en\":\"Fixing or replacing faulty thermostats.\",\"ar\":\"إصلاح أو استبدال منظمات الحرارة المعيبة.\",\"de\":\"Defekte Thermostate reparieren oder austauschen.\"}', 7, NULL, NULL, 5.00, 1, 1, 'service', 1, '2024-06-14 10:58:16', '2025-02-05 05:17:06', NULL), (13, '{\"en\":\"Cleaning\",\"ar\":\"تنظيف\",\"de\":\"Reinigung\"}', 'cleaning', '{\"en\":\"Comprehensive cleaning services for homes and offices. Our trained staff uses eco-friendly products to ensure a spotless and healthy environment.\",\"ar\":\"خدمات تنظيف شاملة للمنازل والمكاتب. يستخدم موظفونا المدربون منتجات صديقة للبيئة لضمان بيئة نظيفة وصحية.\",\"de\":\"Umfassende Reinigungsdienste für Wohnungen und Büros. Unser geschultes Personal verwendet umweltfreundliche Produkte, um eine makellose und gesunde Umwelt zu gewährleisten.\"}', NULL, NULL, NULL, 9.00, 1, 1, 'service', 1, '2024-06-14 10:59:19', '2025-02-05 05:18:56', NULL), (14, '{\"en\":\"Residential Cleaning\",\"ar\":\"تنظيف السكن\",\"de\":\"Wohnungsreinigung\"}', 'residential-cleaning', '{\"en\":\"Detailed cleaning of homes and apartments.\",\"ar\":\"تنظيف تفصيلي للمنازل والشقق.\",\"de\":\"Detaillierte Reinigung von Häusern und Wohnungen.\"}', 13, NULL, NULL, 6.00, 1, 1, 'service', 1, '2024-06-14 11:01:57', '2025-02-05 05:21:02', NULL), (15, '{\"en\":\"Office Cleaning\",\"ar\":\"تنظيف المكاتب\",\"de\":\"Büroreinigung\"}', 'office-cleaning', '{\"en\":\"Routine cleaning services for office spaces.\",\"ar\":\"خدمات التنظيف الروتينية للمساحات المكتبية.\",\"de\":\"Routinereinigungsdienste für Büroräume.\"}', 13, NULL, NULL, 7.00, 1, 1, 'service', 1, '2024-06-14 11:02:29', '2025-02-05 05:23:14', NULL), (16, '{\"en\":\"Deep Cleaning\",\"ar\":\"التنظيف العميق\",\"de\":\"Tiefenreinigung\"}', 'deep-cleaning', '{\"en\":\"Intensive cleaning for all areas of the home or office.\",\"ar\":\"تنظيف مكثف لجميع مناطق المنزل أو المكتب.\",\"de\":\"Intensive Reinigung für alle Bereiche im Haus oder Büro.\"}', 13, NULL, NULL, 7.00, 1, 0, 'service', 1, '2024-06-14 11:02:59', '2025-02-05 05:25:14', NULL), (17, '{\"en\":\"Carpet Cleaning\",\"ar\":\"تنظيف السجاد\",\"de\":\"Teppichreinigung\"}', 'carpet-cleaning', '{\"en\":\"Professional cleaning of carpets and rugs.\",\"ar\":\"التنظيف الاحترافي للسجاد والموكيت.\",\"de\":\"Professionelle Reinigung von Teppichen und Vorlegern.\"}', 13, NULL, NULL, 4.00, 1, 0, 'service', 1, '2024-06-14 11:03:22', '2025-02-05 05:27:46', NULL), (18, '{\"en\":\"Window Cleaning\",\"ar\":\"تنظيف النوافذ\",\"de\":\"Fensterreinigung\"}', 'window-cleaning', '{\"en\":\"Spotless cleaning of interior and exterior windows.\",\"ar\":\"تنظيف نظيف للنوافذ الداخلية والخارجية.\",\"de\":\"Saubere Reinigung von Innen- und Außenfenstern.\"}', 13, NULL, NULL, 7.00, 1, 0, 'service', 1, '2024-06-14 11:03:44', '2025-02-05 05:30:13', NULL), (19, '{\"en\":\"Carpenter\",\"ar\":\"النجار\",\"de\":\"Tischler\"}', 'carpenter', '{\"en\":\"Skilled carpentry services for building, repairing, and enhancing wooden structures and furniture. Our carpenters deliver craftsmanship with precision and attention to detail.\",\"ar\":\"خدمات النجارة الماهرة لبناء وإصلاح وتعزيز الهياكل الخشبية والأثاث. يقدم النجارون لدينا براعة في العمل مع الدقة والاهتمام بالتفاصيل.\",\"de\":\"Kompetente Schreinerdienstleistungen für den Bau, die Reparatur und die Verbesserung von Holzkonstruktionen und Möbeln. Unsere Tischler liefern handwerkliche Arbeit mit Präzision und Liebe zum Detail.\"}', NULL, NULL, NULL, 5.00, 1, 0, 'service', 1, '2024-06-14 11:31:47', '2025-02-05 05:47:24', NULL), (20, '{\"en\":\"Furniture Making\",\"ar\":\"صناعة الأثاث\",\"de\":\"Möbelherstellung\"}', 'furniture-making', '{\"en\":\"Custom furniture design and creation.\",\"ar\":\"تصميم وإنشاء الأثاث المخصص.\",\"de\":\"Individuelles Design und Herstellung von Möbeln.\"}', 19, NULL, NULL, 5.00, 1, 1, 'service', 1, '2024-06-14 11:32:13', '2025-02-05 05:49:59', NULL), (21, '{\"en\":\"Repair Services\",\"ar\":\"خدمات الإصلاح\",\"de\":\"Reparaturdienste\"}', 'repair-services', '{\"en\":\"Fixing and restoring wooden items.\",\"ar\":\"إصلاح وترميم العناصر الخشبية.\",\"de\":\"Reparieren und Restaurieren von Holzgegenständen.\"}', 19, NULL, NULL, 6.00, 1, 1, 'service', 1, '2024-06-14 11:32:42', '2025-02-05 05:53:45', NULL), (22, '{\"en\":\"Cabinet Installation\",\"ar\":\"تركيب مجلس الوزراء\",\"de\":\"Schrankinstallation\"}', 'cabinet-installation', '{\"en\":\"Installing and customizing cabinets.\",\"ar\":\"تركيب وتخصيص الخزانات.\",\"de\":\"Einbau und Anpassung von Schränken.\"}', 19, NULL, NULL, 4.00, 1, 0, 'service', 1, '2024-06-14 11:33:05', '2025-02-05 05:56:11', NULL), (23, '{\"en\":\"Wooden Flooring\",\"ar\":\"الأرضيات الخشبية\",\"de\":\"Holzböden\"}', 'wooden-flooring', '{\"en\":\"Laying and polishing wooden floors.\",\"ar\":\"تركيب وتلميع الأرضيات الخشبية.\",\"de\":\"Holzböden verlegen und polieren.\"}', 19, NULL, NULL, 5.00, 1, 0, 'service', 1, '2024-06-14 11:33:27', '2025-02-05 07:57:20', NULL), (24, '{\"en\":\"Deck Construction\",\"ar\":\"بناء سطح السفينة\",\"de\":\"Deckbau\"}', 'deck-construction', '{\"en\":\"Building and maintaining outdoor decks.\",\"ar\":\"بناء وصيانة الأسطح الخارجية.\",\"de\":\"Bau und Instandhaltung von Außenterrassen.\"}', 19, NULL, NULL, 4.00, 1, 0, 'service', 1, '2024-06-14 11:33:48', '2025-02-05 08:00:01', NULL), (25, '{\"en\":\"Cooking\",\"ar\":\"طبخ\",\"de\":\"Kochen\"}', 'cooking', '{\"en\":\"Professional cooking services for personal and event-based needs. Our chefs prepare delicious and customized meals to suit all dietary preferences.\",\"ar\":\"خدمات الطبخ الاحترافية لتلبية الاحتياجات الشخصية والمناسبات. يقوم الطهاة لدينا بإعداد وجبات لذيذة ومخصصة لتناسب جميع التفضيلات الغذائية.\",\"de\":\"Professionelle Kochdienstleistungen für persönliche und veranstaltungsbezogene Bedürfnisse. Unsere Köche bereiten köstliche und individuelle Mahlzeiten zu, die allen Ernährungsvorlieben gerecht werden.\"}', NULL, NULL, NULL, 9.00, 1, 0, 'service', 1, '2024-06-14 11:34:19', '2025-02-05 08:03:06', NULL), (26, '{\"en\":\"Personal Chef\",\"ar\":\"الشيف الشخصي\",\"de\":\"Persönlicher Koch\"}', 'personal-chef', '{\"en\":\"Customized meal preparation for individuals and families.\",\"ar\":\"إعداد وجبات مخصصة للأفراد والعائلات.\",\"de\":\"Maßgeschneiderte Essenszubereitung für Einzelpersonen und Familien.\"}', 25, NULL, NULL, 6.00, 1, 0, 'service', 1, '2024-06-14 11:34:55', '2025-02-05 08:42:41', NULL), (27, '{\"en\":\"Catering Services\",\"ar\":\"خدمات تقديم الطعام\",\"de\":\"Catering-Dienstleistungen\"}', 'catering-services', '{\"en\":\"Food services for events and gatherings.\",\"ar\":\"خدمات الطعام للمناسبات والتجمعات.\",\"de\":\"Verpflegungsdienstleistungen für Veranstaltungen und Versammlungen.\"}', 25, NULL, NULL, 5.00, 1, 0, 'service', 1, '2024-06-14 11:35:27', '2025-02-05 08:44:36', NULL), (28, '{\"en\":\"Cooking Classes\",\"ar\":\"دروس الطبخ\",\"de\":\"Kochkurse\"}', 'cooking-classes', '{\"en\":\"Instructional sessions for aspiring cooks.\",\"ar\":\"دورات تعليمية للطهاة الطموحين.\",\"de\":\"Lehrveranstaltungen für angehende Köche.\"}', 25, NULL, NULL, 6.00, 1, 0, 'service', 1, '2024-06-14 11:35:54', '2025-02-05 08:47:10', NULL), (29, '{\"en\":\"Meal Prep\",\"ar\":\"وجبة الإعدادية\",\"de\":\"Essenszubereitung\"}', 'meal-prep', '{\"en\":\"Preparing meals for the week based on dietary requirements.\",\"ar\":\"إعداد وجبات الأسبوع على أساس المتطلبات الغذائية.\",\"de\":\"Bereiten Sie Mahlzeiten für die Woche entsprechend den Ernährungsbedürfnissen zu.\"}', 25, NULL, NULL, 6.00, 1, 0, 'service', 1, '2024-06-14 11:36:15', '2025-02-05 08:49:15', NULL), (30, '{\"en\":\"Special Diets\",\"ar\":\"الأنظمة الغذائية الخاصة\",\"de\":\"Spezielle Diäten\"}', 'special-diets', '{\"en\":\"Cooking for specific diets like keto, vegan, and gluten-free.\",\"ar\":\"الطبخ لأنظمة غذائية محددة مثل الكيتو والنباتية والخالية من الغلوتين.\",\"de\":\"Kochen für bestimmte Diäten wie Keto, vegan und glutenfrei.\"}', 25, NULL, NULL, 7.00, 1, 0, 'service', 1, '2024-06-14 11:36:35', '2025-02-05 08:51:35', NULL), (31, '{\"en\":\"Electrician\",\"ar\":\"كهربائي\",\"de\":\"Elektriker\"}', 'electrician', '{\"en\":\"Certified electrical services for residential and commercial properties. Our electricians handle everything from installations to emergency repairs with utmost safety and expertise.\",\"ar\":\"خدمات كهربائية معتمدة للعقارات السكنية والتجارية. يتعامل كهربائيونا مع كل شيء بدءًا من التركيبات وحتى الإصلاحات الطارئة بأقصى درجات الأمان والخبرة.\",\"de\":\"Zertifizierte Elektrodienstleistungen für Wohn- und Gewerbeimmobilien. Unsere Elektriker erledigen alles von der Installation bis zur Notfallreparatur mit größter Sicherheit und Fachkenntnis.\"}', NULL, NULL, NULL, 9.00, 1, 0, 'service', 1, '2024-06-14 11:37:10', '2025-02-05 08:53:53', NULL), (32, '{\"en\":\"Wiring Installation\",\"ar\":\"تركيب الأسلاك\",\"de\":\"Verkabelungsinstallation\"}', 'wiring-installation', '{\"en\":\"Installing and upgrading electrical wiring.\",\"ar\":\"تركيب وتحديث التمديدات الكهربائية.\",\"de\":\"Installation und Modernisierung der elektrischen Leitungen.\"}', 31, NULL, NULL, 6.00, 1, 0, 'service', 1, '2024-06-14 11:37:35', '2025-02-05 08:57:15', NULL), (33, '{\"en\":\"Lighting\",\"ar\":\"إضاءة\",\"de\":\"Beleuchtung\"}', 'lighting', '{\"en\":\"Installation and repair of lighting systems.\",\"ar\":\"تركيب وإصلاح أنظمة الإضاءة.\",\"de\":\"Installation und Reparatur von Beleuchtungssystemen.\"}', 31, NULL, NULL, 5.00, 1, 0, 'service', 1, '2024-06-14 11:38:10', '2025-02-05 09:00:09', NULL), (34, '{\"en\":\"Circuit Breaker Repair\",\"de\":\"Reparatur von Leistungsschaltern\",\"ar\":\"إصلاح قواطع الدائرة\"}', 'circuit-breaker-repair', '{\"en\":\"Fixing and replacing circuit breakers.\",\"de\":\"Reparatur und Austausch von Leistungsschaltern.\",\"ar\":\"Fixing and replacing circuit breakers.\"}', 31, NULL, NULL, 6.00, 1, 0, 'service', 1, '2024-06-14 11:38:38', '2025-02-05 09:03:14', NULL), (35, '{\"en\":\"Emergency Services\",\"ar\":\"خدمات الطوارئ\",\"de\":\"Notdienste\"}', 'emergency-services', '{\"en\":\"Immediate response to electrical emergencies.\",\"ar\":\"الاستجابة الفورية لحالات الطوارئ الكهربائية.\",\"de\":\"Sofortige Reaktion auf elektrische Notfälle.\"}', 31, NULL, NULL, 8.00, 1, 0, 'service', 1, '2024-06-14 11:39:41', '2025-02-05 09:05:21', NULL), (36, '{\"en\":\"Appliance Installation\",\"ar\":\"تركيب الأجهزة\",\"de\":\"Geräteinstallation\"}', 'appliance-installation', '{\"en\":\"Setting up and connecting electrical appliances.\",\"ar\":\"تركيب وتوصيل الأجهزة الكهربائية.\",\"de\":\"Elektrogeräte aufstellen und anschließen.\"}', 31, NULL, NULL, 8.00, 1, 0, 'service', 1, '2024-06-14 11:40:05', '2025-02-05 09:07:25', NULL), (37, '{\"en\":\"Painter\",\"ar\":\"رسام\",\"de\":\"Maler\"}', 'painter', '{\"en\":\"Professional painting services to enhance the aesthetic appeal of your property. Our painters ensure a flawless finish and use high-quality paints for long-lasting results.\",\"ar\":\"خدمات طلاء احترافية لتعزيز المظهر الجمالي لممتلكاتك. يضمن الرسامون لدينا لمسة نهائية خالية من العيوب ويستخدمون دهانات عالية الجودة للحصول على نتائج طويلة الأمد.\",\"de\":\"Professionelle Malerarbeiten zur Verbesserung der Ästhetik Ihrer Immobilie. Unsere Maler sorgen für ein makelloses Finish und verwenden hochwertige Farben für langanhaltende Ergebnisse.\"}', NULL, NULL, NULL, 9.00, 1, 0, 'service', 1, '2024-06-14 11:40:28', '2025-02-05 09:10:10', NULL), (38, '{\"en\":\"Interior Painting\",\"ar\":\"اللوحة الداخلية\",\"de\":\"Innenmalerei\"}', 'interior-painting', '{\"en\":\"Painting of interior walls, ceilings, and trim.\",\"ar\":\"طلاء الجدران الداخلية والأسقف والديكورات.\",\"de\":\"Streichen von Innenwänden, Decken und Verkleidungen.\"}', 37, NULL, NULL, 8.00, 1, 0, 'service', 1, '2024-06-14 11:41:00', '2025-02-05 09:12:51', NULL), (39, '{\"en\":\"Exterior Painting\",\"ar\":\"اللوحة الخارجية\",\"de\":\"Außenanstrich\"}', 'exterior-painting', '{\"en\":\"Painting of exterior walls and structures.\",\"ar\":\"طلاء الجدران والهياكل الخارجية.\",\"de\":\"Anstrich von Außenwänden und Bauwerken.\"}', 37, NULL, NULL, 8.00, 1, 0, 'service', 1, '2024-06-14 11:41:28', '2025-02-05 09:20:43', NULL), (40, '{\"en\":\"Wallpaper Installation\",\"de\":\"Tapeteninstallation\",\"ar\":\"تركيب ورق الجدران\"}', 'wallpaper-installation', '{\"en\":\"Applying and removing wallpaper.\",\"de\":\"Streichen von Innenwänden, Decken und Verkleidungen.\",\"ar\":\"تطبيق وإزالة ورق الجدران.\"}', 37, NULL, NULL, 5.00, 1, 0, 'service', 1, '2024-06-14 11:41:56', '2025-02-05 09:23:10', NULL), (41, '{\"en\":\"Touch-up Services\",\"de\":\"Ausbesserungsdienste\",\"ar\":\"خدمات اللمس\"}', 'touch-up-services', '{\"en\":\"Minor painting repairs and touch-ups.\",\"de\":\"Kleinere Lackreparaturen und Ausbesserungen.\",\"ar\":\"إصلاحات الطلاء البسيطة واللمسات النهائية.\"}', 37, NULL, NULL, 8.00, 1, 0, 'service', 1, '2024-06-14 11:42:18', '2025-02-05 09:25:33', NULL), (42, '{\"en\":\"Decorative Painting\",\"ar\":\"اللوحة الزخرفية\",\"de\":\"Dekorative Malerei\"}', 'decorative-painting', '{\"en\":\"Custom and artistic painting designs.\",\"ar\":\"تصاميم اللوحة المخصصة والفنية.\",\"de\":\"Individuelle und künstlerische Malereientwürfe.\"}', 37, NULL, NULL, 7.00, 1, 0, 'service', 1, '2024-06-14 11:42:39', '2025-02-05 09:27:59', NULL), (43, '{\"en\":\"Plumber\",\"ar\":\"سباك\",\"de\":\"Klempner\"}', 'plumber', '{\"en\":\"Reliable plumbing services for all your needs, from fixing leaks to installing new systems. Our plumbers provide prompt and efficient solutions to ensure smooth water flow and drainage.\",\"ar\":\"خدمات سباكة موثوقة تلبي جميع احتياجاتك، بدءًا من إصلاح التسريبات وحتى تركيب أنظمة جديدة. يقدم السباكون لدينا حلولاً سريعة وفعالة لضمان تدفق المياه وتصريفها بشكل سلس.\",\"de\":\"Zuverlässige Sanitärdienstleistungen für alle Ihre Bedürfnisse, von der Reparatur von Lecks bis zur Installation neuer Systeme. Unsere Klempner bieten schnelle und effiziente Lösungen, um einen reibungslosen Wasserfluss und eine reibungslose Entwässerung zu gewährleisten.\"}', NULL, NULL, NULL, 9.00, 1, 0, 'service', 1, '2024-06-14 11:43:36', '2025-02-05 09:33:04', NULL), (44, '{\"en\":\"Leak Repair\",\"ar\":\"إصلاح التسرب\",\"de\":\"Leckreparatur\"}', 'leak-repair', '{\"en\":\"Fixing leaks in pipes and faucets.\",\"ar\":\"إصلاح التسريبات في الأنابيب والحنفيات.\",\"de\":\"Behebung von Lecks in Rohren und Wasserhähnen.\"}', 43, NULL, NULL, 5.00, 1, 0, 'service', 1, '2024-06-14 11:44:00', '2025-02-05 09:34:42', NULL), (45, '{\"en\":\"Drain Cleaning\",\"ar\":\"تنظيف الصرف\",\"de\":\"Abflussreinigung\"}', 'drain-cleaning', '{\"en\":\"Unclogging and cleaning drains.\",\"ar\":\"فك انسداد وتنظيف المصارف.\",\"de\":\"Entstopfen und Reinigen von Abflüssen.\"}', 43, NULL, NULL, 5.00, 1, 0, 'service', 1, '2024-06-14 11:44:28', '2025-02-05 09:36:58', NULL), (46, '{\"en\":\"Pipe Installation\",\"ar\":\"تركيب الأنابيب\",\"de\":\"Rohrinstallation\"}', 'pipe-installation', '{\"en\":\"Installing new piping systems.\",\"ar\":\"تركيب أنظمة الأنابيب الجديدة.\",\"de\":\"Installation neuer Rohrleitungssysteme.\"}', 43, NULL, NULL, 8.00, 1, 0, 'service', 1, '2024-06-14 11:45:15', '2025-02-05 09:38:29', NULL), (47, '{\"en\":\"Water Heater Repair\",\"ar\":\"إصلاح سخان المياه\",\"de\":\"Reparatur von Warmwasserbereitern\"}', 'water-heater-repair', '{\"en\":\"Fixing and installing water heaters.\",\"ar\":\"إصلاح وتركيب سخانات المياه.\",\"de\":\"Reparatur und Installation von Warmwasserbereitern.\"}', 43, NULL, NULL, 8.00, 1, 0, 'service', 1, '2024-06-14 11:45:41', '2025-02-05 09:40:01', NULL), (48, '{\"en\":\"Emergency Plumbing\",\"ar\":\"سباكة الطوارئ\",\"de\":\"Notfall-Sanitär\"}', 'emergency-plumbing', '{\"en\":\"24/7 services for urgent plumbing issues.\",\"ar\":\"خدمات 24/7 لقضايا السباكة العاجلة.\",\"de\":\"24/7-Service für dringende Sanitärprobleme.\"}', 43, NULL, NULL, 8.00, 1, 0, 'service', 1, '2024-06-14 11:46:07', '2025-02-05 09:41:26', NULL), (49, '{\"en\":\"Salon\",\"ar\":\"صالون\",\"de\":\"Salon\"}', 'salon', '{\"en\":\"Top-notch salon services for hair, skin, and nails. Our skilled professionals use the best products and techniques to help you look and feel your best.\",\"ar\":\"خدمات صالون من الدرجة الأولى للشعر والبشرة والأظافر. يستخدم المتخصصون المهرة لدينا أفضل المنتجات والتقنيات لمساعدتك في الظهور والشعور بأفضل ما لديك.\",\"de\":\"Erstklassige Salondienstleistungen für Haare, Haut und Nägel. Unsere erfahrenen Fachkräfte verwenden die besten Produkte und Techniken, damit Sie gut aussehen und sich gut fühlen.\"}', NULL, NULL, NULL, 9.00, 1, 0, 'service', 1, '2024-06-14 11:46:33', '2025-02-05 09:43:24', NULL), (50, '{\"en\":\"Haircut\",\"ar\":\"قصة شعر\",\"de\":\"Haarschnitt\"}', 'haircut', '{\"en\":\"Stylish haircuts for men, women, and children.\",\"ar\":\"قصات شعر أنيقة للرجال والنساء والأطفال.\",\"de\":\"Stilvolle Haarschnitte für Männer, Frauen und Kinder.\"}', 49, NULL, NULL, 8.00, 1, 0, 'service', 1, '2024-06-14 11:46:57', '2025-02-05 09:45:38', NULL), (51, '{\"en\":\"Hair Coloring\",\"ar\":\"تلوين الشعر\",\"de\":\"Haarfärbung\"}', 'hair-coloring', '{\"en\":\"Professional coloring services.\",\"ar\":\"خدمات التلوين الاحترافية.\",\"de\":\"Professionelle Färbedienste.\"}', 49, NULL, NULL, 7.00, 1, 0, 'service', 1, '2024-06-14 11:47:24', '2025-02-05 09:48:36', NULL), (52, '{\"en\":\"Facials\",\"ar\":\"علاجات للوجه\",\"de\":\"Gesichtsbehandlungen\"}', 'facials', '{\"en\":\"Rejuvenating facial treatments.\",\"ar\":\"علاجات تجديد شباب الوجه.\",\"de\":\"Verjüngende Gesichtsbehandlungen.\"}', 49, NULL, NULL, 8.00, 1, 0, 'service', 1, '2024-06-14 11:47:48', '2025-02-05 09:50:57', NULL), (53, '{\"en\":\"Manicure & Pedicure\",\"ar\":\"مانيكير وباديكير\",\"de\":\"Maniküre und Pediküre\"}', 'manicure-pedicure', '{\"en\":\"Nail care and polish services.\",\"ar\":\"خدمات العناية بالأظافر وتلميعها.\",\"de\":\"Nagelpflege- und Nagellackdienstleistungen.\"}', 49, NULL, NULL, 5.00, 1, 0, 'service', 1, '2024-06-14 11:48:09', '2025-02-05 09:54:18', NULL), (54, '{\"en\":\"Spa Services\",\"ar\":\"خدمات السبا\",\"de\":\"Spa-Dienstleistungen\"}', 'spa-services', '{\"en\":\"Relaxing spa treatments including massages and skin care.\",\"ar\":\"علاجات السبا المريحة بما في ذلك التدليك والعناية بالبشرة.\",\"de\":\"Entspannende Spa-Behandlungen einschließlich Massagen und Hautpflege.\"}', 49, NULL, NULL, 8.00, 1, 0, 'service', 1, '2024-06-14 11:48:32', '2025-02-05 09:56:58', NULL), (55, '{\"en\":\"Home Services\"}', 'home-services', '{\"en\":\"Explore a range of home services to enhance your living experience, from AC repair and installation to spa treatments and more.\"}', NULL, NULL, NULL, 0.00, 1, 0, 'blog', 1, '2024-06-14 12:26:38', '2024-06-14 12:26:38', NULL), (56, '{\"en\":\"AC Services\"}', 'ac-services', '{\"en\":\"Learn about the importance of AC maintenance, repair tips, and how to choose the right AC system for your home.\"}', NULL, NULL, NULL, 0.00, 1, 0, 'blog', 1, '2024-06-14 12:26:54', '2024-06-14 12:26:54', NULL), (57, '{\"en\":\"Spa and Wellness\"}', 'spa-and-wellness', '{\"en\":\"Discover the world of spa and wellness, including benefits of different treatments, relaxation techniques, and more.\"}', NULL, NULL, NULL, 0.00, 1, 0, 'blog', 1, '2024-06-14 12:27:15', '2024-06-14 12:27:15', NULL), (58, '{\"en\":\"Hair and Beauty\"}', 'hair-and-beauty', '{\"en\":\"Stay updated with the latest hair trends, beauty tips, and expert advice on hair care and styling.\"}', NULL, NULL, NULL, 0.00, 1, 0, 'blog', 1, '2024-06-14 12:27:28', '2024-06-14 12:27:28', NULL), (59, '{\"en\":\"Cleaning and Organization\"}', 'cleaning-and-organization', '{\"en\":\"Get practical tips for cleaning your home efficiently, organizing spaces, and maintaining a tidy living environment.\"}', NULL, NULL, NULL, 0.00, 1, 0, 'blog', 1, '2024-06-14 12:27:44', '2024-06-14 12:27:44', NULL), (60, '{\"en\":\"Home Improvement\"}', 'home-improvement', '{\"en\":\"Explore DIY projects, renovation ideas, and home improvement tips to enhance the look and functionality of your home.\"}', NULL, NULL, NULL, 0.00, 1, 0, 'blog', 1, '2024-06-14 12:27:58', '2024-06-14 12:27:58', NULL), (61, '{\"en\":\"Vendor Selection and Tips\"}', 'vendor-selection-and-tips', '{\"en\":\"Find guidance on how to choose the right vendors for home services, maintenance, and repairs.\"}', NULL, NULL, NULL, 0.00, 1, 0, 'blog', 1, '2024-06-14 12:28:20', '2024-06-14 12:28:20', NULL), (62, '{\"en\":\"Wellbeing and Lifestyle\"}', 'wellbeing-and-lifestyle', '{\"en\":\"Discover ways to improve your overall wellbeing, including fitness tips, mental health advice, and lifestyle changes.\"}', NULL, NULL, NULL, 0.00, 1, 0, 'blog', 1, '2024-06-14 12:28:33', '2024-06-14 12:28:33', NULL), (63, '{\"en\":\"Home Maintenance\"}', 'home-maintenance', '{\"en\":\"Learn about essential home maintenance tasks, seasonal upkeep, and tips for keeping your home in top condition.\"}', NULL, NULL, NULL, 0.00, 1, 0, 'blog', 1, '2024-06-14 12:28:46', '2024-06-14 12:28:46', NULL), (64, '{\"en\":\"Professional Services\"}', 'professional-services', '{\"en\":\"Explore the benefits of hiring professionals for home services, repairs, and maintenance, and how to find trusted professionals.\"}', NULL, NULL, NULL, 0.00, 1, 0, 'blog', 1, '2024-06-14 12:28:58', '2024-06-14 12:28:58', NULL), (65, '{\"en\":\"Education And Tutoring\",\"ar\":\"التعليم والدروس الخصوصية\",\"de\":\"Bildung und Nachhilfe\"}', 'education-and-tutoring', '{\"en\":\"Education and Training category, services focus on providing knowledge, skills, and expertise through structured learning experiences.\",\"ar\":\"فئة التعليم والتدريب، تركز الخدمات على توفير المعرفة والمهارات والخبرة من خلال تجارب التعلم المنظمة.\",\"de\":\"In der Kategorie „Aus- und Weiterbildung“ konzentrieren sich die Dienstleistungen auf die Vermittlung von Wissen, Fähigkeiten und Fachwissen durch strukturierte Lernerfahrungen.\"}', NULL, NULL, NULL, 8.00, 1, 0, 'service', 1, '2024-11-19 10:48:32', '2025-02-05 09:58:49', NULL), (66, '{\"en\":\"Physiotherapy\",\"ar\":\"العلاج الطبيعي\",\"de\":\"Physiotherapy\"}', 'physiotherapy', '{\"en\":\"Physiotherapy involves the assessment, treatment, and prevention of physical conditions that affect movement and function.\",\"ar\":\"يتضمن العلاج الطبيعي تقييم وعلاج والوقاية من الحالات الجسدية التي تؤثر على الحركة والوظيفة.\",\"de\":\"Physiotherapie umfasst die Beurteilung, Behandlung und Vorbeugung von körperlichen Erkrankungen, die Bewegung und Funktion beeinträchtigen.\"}', NULL, NULL, NULL, 6.00, 1, 0, 'service', 1, '2024-11-19 10:50:26', '2025-02-05 10:00:44', NULL), (67, '{\"en\":\"Yoga\",\"ar\":\"اليوغا\",\"de\":\"Yoga\"}', 'yoga', '{\"en\":\"Yoga is a holistic practice that integrates physical postures, breathing exercises, meditation, and relaxation techniques to promote physical, mental, and emotional well-being.\",\"ar\":\"اليوغا هي ممارسة شاملة تدمج الأوضاع الجسدية وتمارين التنفس والتأمل وتقنيات الاسترخاء لتعزيز الصحة البدنية والعقلية والعاطفية.\",\"de\":\"Yoga ist eine ganzheitliche Praxis, die Körperhaltungen, Atemübungen, Meditation und Entspannungstechniken integriert, um das körperliche, geistige und emotionale Wohlbefinden zu fördern.\"}', NULL, NULL, NULL, 7.00, 1, 0, 'service', 1, '2024-11-19 10:51:02', '2025-02-05 10:02:18', NULL); -- -------------------------------------------------------- -- -- Table structure for table `category_zones` -- CREATE TABLE `category_zones` ( `id` bigint(20) UNSIGNED NOT NULL, `category_id` bigint(20) UNSIGNED NOT NULL, `zone_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `category_zones` -- INSERT INTO `category_zones` (`id`, `category_id`, `zone_id`) VALUES (7, 7, 1), (8, 8, 1), (9, 9, 1), (10, 10, 1), (11, 11, 1), (12, 12, 1), (13, 13, 1), (14, 13, 2), (15, 14, 1), (16, 15, 1), (17, 16, 1), (18, 17, 1), (19, 18, 1), (20, 19, 1), (21, 20, 1), (22, 21, 1), (23, 22, 1), (24, 23, 1), (25, 24, 1), (26, 25, 1), (27, 25, 2), (28, 26, 1), (29, 26, 2), (30, 27, 1), (31, 27, 2), (32, 28, 1), (33, 28, 2), (34, 29, 1), (35, 29, 2), (36, 30, 1), (37, 30, 2), (38, 31, 1), (39, 32, 1), (40, 33, 1), (41, 34, 1), (42, 35, 1), (43, 36, 1), (44, 37, 1), (45, 37, 2), (46, 38, 1), (47, 38, 2), (48, 39, 1), (49, 39, 2), (50, 40, 1), (51, 40, 2), (52, 41, 1), (53, 41, 2), (54, 42, 1), (55, 42, 2), (56, 43, 1), (58, 44, 1), (60, 45, 1), (61, 46, 1), (62, 47, 1), (63, 48, 1), (64, 49, 1), (65, 49, 2), (66, 50, 1), (67, 50, 2), (68, 51, 1), (69, 51, 2), (70, 52, 1), (71, 52, 2), (72, 53, 1), (73, 53, 2), (74, 54, 1), (75, 54, 2), (76, 65, 1), (77, 66, 1), (78, 67, 1); -- -------------------------------------------------------- -- -- Table structure for table `comments` -- CREATE TABLE `comments` ( `id` bigint(20) NOT NULL, `message` longtext COLLATE utf8mb4_unicode_ci, `user_id` int(11) DEFAULT NULL, `blog_id` int(11) DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `commission_histories` -- CREATE TABLE `commission_histories` ( `id` bigint(20) UNSIGNED NOT NULL, `admin_commission` decimal(8,2) DEFAULT '0.00', `provider_commission` decimal(8,2) DEFAULT '0.00', `booking_id` bigint(20) UNSIGNED DEFAULT NULL, `provider_id` bigint(20) UNSIGNED DEFAULT NULL, `category_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `commission_histories` -- INSERT INTO `commission_histories` (`id`, `admin_commission`, `provider_commission`, `booking_id`, `provider_id`, `category_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 16.20, 163.80, 2, 3, 9, '2024-07-22 22:48:46', '2024-07-22 22:48:46', NULL), (2, 3.83, 38.68, 6, 3, 13, '2024-07-23 01:26:43', '2024-07-23 01:26:43', NULL), (3, 5.92, 59.88, 8, 33, 49, '2024-07-23 02:51:49', '2024-07-23 02:51:49', NULL), (4, 8.02, 81.08, 10, 3, 13, '2024-07-24 02:23:10', '2024-07-24 02:23:10', NULL), (5, 8.02, 81.08, 20, 3, 13, '2024-07-24 02:23:10', '2024-07-24 02:23:10', NULL), (6, 5.13, 51.87, 30, 33, 49, '2024-07-24 03:05:50', '2024-07-24 03:05:50', NULL); -- -------------------------------------------------------- -- -- Table structure for table `companies` -- CREATE TABLE `companies` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code` bigint(20) DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `companies` -- INSERT INTO `companies` (`id`, `name`, `email`, `phone`, `code`, `description`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Company Example', 'company@example.com', '123456789', 91, 'provider company description', '2024-06-13 11:38:15', '2024-06-13 11:38:15', NULL), (2, 'Tech Solutions Ltd', 'info@techsolutions.com', '256859', 44, NULL, '2024-06-13 13:33:01', '2024-06-13 13:33:01', NULL), (3, 'Innovatech Inc.', 'contact@innovatech.ca', '41625896378', 1, NULL, '2024-06-13 13:48:52', '2024-06-13 13:48:52', NULL), (4, 'Bright Cleaners Ltd.', 'contact@brightcleaners.com', '9655899517', 44, NULL, '2024-06-14 09:29:49', '2024-06-14 09:29:49', NULL), (5, 'Doe Enterprises', 'contact@doeenterprises.com', '9644539853', 1, 'Leading provider of tech solutions.', '2024-06-14 10:16:21', '2024-06-14 10:16:21', NULL), (6, 'Wilson Technologies', 'contact@wilsontech.de', '3075463102', 49, NULL, '2024-06-14 10:27:57', '2024-06-14 10:27:57', NULL), (7, 'Garcia Innovations', 'info@garciainnovations.es', '9198765432', 34, NULL, '2024-06-14 10:31:40', '2024-06-14 10:31:40', NULL), (8, 'Barton and Suarez Plc', 'xove@mailinator.com', '2356565', 92, 'In qui ut doloremque', '2024-11-19 06:55:44', '2024-11-19 06:55:44', NULL); -- -------------------------------------------------------- -- -- Table structure for table `countries` -- CREATE TABLE `countries` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `currency_symbol` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `iso_3166_2` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `iso_3166_3` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone_code` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `flag` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `currency_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `countries` -- INSERT INTO `countries` (`id`, `name`, `currency`, `currency_symbol`, `iso_3166_2`, `iso_3166_3`, `phone_code`, `flag`, `currency_code`) VALUES (4, 'Afghanistan', 'afghani', 'Øâ', 'AF', 'AFG', '93', 'AF.png', 'AFN'), (8, 'Albania', 'lek', 'Lek', 'AL', 'ALB', '355', 'AL.png', 'ALL'), (10, 'Antarctica', '', '', 'AQ', 'ATA', '672', 'AQ.png', ''), (12, 'Algeria', 'Algerian dinar', 'DZD', 'DZ', 'DZA', '213', 'DZ.png', 'DZD'), (16, 'American Samoa', 'US dollar', '$', 'AS', 'ASM', '1', 'AS.png', 'USD'), (20, 'Andorra', 'euro', 'ââ', 'AD', 'AND', '376', 'AD.png', 'EUR'), (24, 'Angola', 'kwanza', 'Kz', 'AO', 'AGO', '244', 'AO.png', 'AOA'), (28, 'Antigua and Barbuda', 'East Caribbean dollar', '$', 'AG', 'ATG', '1', 'AG.png', 'XCD'), (31, 'Azerbaijan', 'Azerbaijani manat', 'ÃÂ', 'AZ', 'AZE', '994', 'AZ.png', 'AZN'), (32, 'Argentina', 'Argentine peso', '$', 'AR', 'ARG', '54', 'AR.png', 'ARS'), (36, 'Australia', 'Australian dollar', '$', 'AU', 'AUS', '61', 'AU.png', 'AUD'), (40, 'Austria', 'euro', 'ââ', 'AT', 'AUT', '43', 'AT.png', 'EUR'), (44, 'Bahamas', 'Bahamian dollar', '$', 'BS', 'BHS', '1', 'BS.png', 'BSD'), (48, 'Bahrain', 'Bahraini dinar', 'BHD', 'BH', 'BHR', '973', 'BH.png', 'BHD'), (50, 'Bangladesh', 'taka (inv.)', 'BDT', 'BD', 'BGD', '880', 'BD.png', 'BDT'), (51, 'Armenia', 'dram (inv.)', 'AMD', 'AM', 'ARM', '374', 'AM.png', 'AMD'), (52, 'Barbados', 'Barbados dollar', '$', 'BB', 'BRB', '1', 'BB.png', 'BBD'), (56, 'Belgium', 'euro', 'ââ', 'BE', 'BEL', '32', 'BE.png', 'EUR'), (60, 'Bermuda', 'Bermuda dollar', '$', 'BM', 'BMU', '1', 'BM.png', 'BMD'), (64, 'Bhutan', 'ngultrum (inv.)', 'BTN', 'BT', 'BTN', '975', 'BT.png', 'BTN'), (68, 'Bolivia, Plurinational State of', 'boliviano', '$b', 'BO', 'BOL', '591', 'BO.png', 'BOB'), (70, 'Bosnia and Herzegovina', 'convertible mark', 'KM', 'BA', 'BIH', '387', 'BA.png', 'BAM'), (72, 'Botswana', 'pula (inv.)', 'P', 'BW', 'BWA', '267', 'BW.png', 'BWP'), (74, 'Bouvet Island', '', 'kr', 'BV', 'BVT', '47', 'BV.png', ''), (76, 'Brazil', 'real (pl. reais)', 'R$', 'BR', 'BRA', '55', 'BR.png', 'BRL'), (84, 'Belize', 'Belize dollar', 'BZ$', 'BZ', 'BLZ', '501', 'BZ.png', 'BZD'), (86, 'British Indian Ocean Territory', 'US dollar', '$', 'IO', 'IOT', '246', 'IO.png', 'USD'), (90, 'Solomon Islands', 'Solomon Islands dollar', '$', 'SB', 'SLB', '677', 'SB.png', 'SBD'), (92, 'Virgin Islands, British', 'US dollar', '$', 'VG', 'VGB', '1', 'VG.png', 'USD'), (96, 'Brunei Darussalam', 'Brunei dollar', '$', 'BN', 'BRN', '673', 'BN.png', 'BND'), (100, 'Bulgaria', 'lev (pl. leva)', 'ÃÂ', 'BG', 'BGR', '359', 'BG.png', 'BGN'), (104, 'Myanmar', 'kyat', 'K', 'MM', 'MMR', '95', 'MM.png', 'MMK'), (108, 'Burundi', 'Burundi franc', 'BIF', 'BI', 'BDI', '257', 'BI.png', 'BIF'), (112, 'Belarus', 'Belarusian rouble', 'p.', 'BY', 'BLR', '375', 'BY.png', 'BYR'), (116, 'Cambodia', 'riel', 'áÅ', 'KH', 'KHM', '855', 'KH.png', 'KHR'), (120, 'Cameroon', 'CFA franc (BEAC)', 'FCF', 'CM', 'CMR', '237', 'CM.png', 'XAF'), (124, 'Canada', 'Canadian dollar', '$', 'CA', 'CAN', '1', 'CA.png', 'CAD'), (132, 'Cape Verde', 'Cape Verde escudo', 'CVE', 'CV', 'CPV', '238', 'CV.png', 'CVE'), (136, 'Cayman Islands', 'Cayman Islands dollar', '$', 'KY', 'CYM', '1', 'KY.png', 'KYD'), (140, 'Central African Republic', 'CFA franc (BEAC)', 'CFA', 'CF', 'CAF', '236', 'CF.png', 'XAF'), (144, 'Sri Lanka', 'Sri Lankan rupee', 'ââ', 'LK', 'LKA', '94', 'LK.png', 'LKR'), (148, 'Chad', 'CFA franc (BEAC)', 'XAF', 'TD', 'TCD', '235', 'TD.png', 'XAF'), (152, 'Chile', 'Chilean peso', 'CLP', 'CL', 'CHL', '56', 'CL.png', 'CLP'), (156, 'China', 'renminbi-yuan (inv.)', 'ÂÂ', 'CN', 'CHN', '86', 'CN.png', 'CNY'), (158, 'Taiwan, Province of China', 'new Taiwan dollar', 'NT$', 'TW', 'TWN', '886', 'TW.png', 'TWD'), (162, 'Christmas Island', 'Australian dollar', '$', 'CX', 'CXR', '61', 'CX.png', 'AUD'), (166, 'Cocos (Keeling) Islands', 'Australian dollar', '$', 'CC', 'CCK', '61', 'CC.png', 'AUD'), (170, 'Colombia', 'Colombian peso', '$', 'CO', 'COL', '57', 'CO.png', 'COP'), (174, 'Comoros', 'Comorian franc', 'KMF', 'KM', 'COM', '269', 'KM.png', 'KMF'), (175, 'Mayotte', 'euro', 'ââ', 'YT', 'MYT', '262', 'YT.png', 'EUR'), (178, 'Congo', 'CFA franc (BEAC)', 'FCF', 'CG', 'COG', '242', 'CG.png', 'XAF'), (180, 'Congo, the Democratic Republic of the', 'Congolese franc', 'CDF', 'CD', 'COD', '243', 'CD.png', 'CDF'), (184, 'Cook Islands', 'New Zealand dollar', '$', 'CK', 'COK', '682', 'CK.png', 'NZD'), (188, 'Costa Rica', 'Costa Rican colón (pl. colones)', 'ââ', 'CR', 'CRI', '506', 'CR.png', 'CRC'), (191, 'Croatia', 'kuna (inv.)', 'kn', 'HR', 'HRV', '385', 'HR.png', 'HRK'), (192, 'Cuba', 'Cuban peso', 'ââ', 'CU', 'CUB', '53', 'CU.png', 'CUP'), (196, 'Cyprus', 'euro', 'CYP', 'CY', 'CYP', '357', 'CY.png', 'EUR'), (203, 'Czech Republic', 'Czech koruna (pl. koruny)', 'KÄ', 'CZ', 'CZE', '420', 'CZ.png', 'CZK'), (204, 'Benin', 'CFA franc (BCEAO)', 'XOF', 'BJ', 'BEN', '229', 'BJ.png', 'XOF'), (208, 'Denmark', 'Danish krone', 'kr', 'DK', 'DNK', '45', 'DK.png', 'DKK'), (212, 'Dominica', 'East Caribbean dollar', '$', 'DM', 'DMA', '1', 'DM.png', 'XCD'), (214, 'Dominican Republic', 'Dominican peso', 'RD$', 'DO', 'DOM', '1', 'DO.png', 'DOP'), (218, 'Ecuador', 'US dollar', '$', 'EC', 'ECU', '593', 'EC.png', 'USD'), (222, 'El Salvador', 'Salvadorian colón (pl. colones)', '$', 'SV', 'SLV', '503', 'SV.png', 'SVC'), (226, 'Equatorial Guinea', 'CFA franc (BEAC)', 'FCF', 'GQ', 'GNQ', '240', 'GQ.png', 'XAF'), (231, 'Ethiopia', 'birr (inv.)', 'ETB', 'ET', 'ETH', '251', 'ET.png', 'ETB'), (232, 'Eritrea', 'nakfa', 'Nfk', 'ER', 'ERI', '291', 'ER.png', 'ERN'), (233, 'Estonia', 'euro', 'kr', 'EE', 'EST', '372', 'EE.png', 'EUR'), (234, 'Faroe Islands', 'Danish krone', 'kr', 'FO', 'FRO', '298', 'FO.png', 'DKK'), (238, 'Falkland Islands (Malvinas)', 'Falkland Islands pound', 'ÂÂ', 'FK', 'FLK', '500', 'FK.png', 'FKP'), (239, 'South Georgia and the South Sandwich Islands', '', 'ÂÂ', 'GS', 'SGS', '44', 'GS.png', ''), (242, 'Fiji', 'Fiji dollar', '$', 'FJ', 'FJI', '679', 'FJ.png', 'FJD'), (246, 'Finland', 'euro', 'ââ', 'FI', 'FIN', '358', 'FI.png', 'EUR'), (248, 'Ã…land Islands', 'euro', NULL, 'AX', 'ALA', '358', NULL, 'EUR'), (250, 'France', 'euro', 'ââ', 'FR', 'FRA', '33', 'FR.png', 'EUR'), (254, 'French Guiana', 'euro', 'ââ', 'GF', 'GUF', '594', 'GF.png', 'EUR'), (258, 'French Polynesia', 'CFP franc', 'XPF', 'PF', 'PYF', '689', 'PF.png', 'XPF'), (260, 'French Southern Territories', 'euro', 'ââ', 'TF', 'ATF', '33', 'TF.png', 'EUR'), (262, 'Djibouti', 'Djibouti franc', 'DJF', 'DJ', 'DJI', '253', 'DJ.png', 'DJF'), (266, 'Gabon', 'CFA franc (BEAC)', 'FCF', 'GA', 'GAB', '241', 'GA.png', 'XAF'), (268, 'Georgia', 'lari', 'GEL', 'GE', 'GEO', '995', 'GE.png', 'GEL'), (270, 'Gambia', 'dalasi (inv.)', 'D', 'GM', 'GMB', '220', 'GM.png', 'GMD'), (275, 'Palestinian Territory, Occupied', NULL, 'ââ', 'PS', 'PSE', '970', 'PS.png', NULL), (276, 'Germany', 'euro', 'ââ', 'DE', 'DEU', '49', 'DE.png', 'EUR'), (288, 'Ghana', 'Ghana cedi', 'ÂÂ', 'GH', 'GHA', '233', 'GH.png', 'GHS'), (292, 'Gibraltar', 'Gibraltar pound', 'ÂÂ', 'GI', 'GIB', '350', 'GI.png', 'GIP'), (296, 'Kiribati', 'Australian dollar', '$', 'KI', 'KIR', '686', 'KI.png', 'AUD'), (300, 'Greece', 'euro', 'ââ', 'GR', 'GRC', '30', 'GR.png', 'EUR'), (304, 'Greenland', 'Danish krone', 'kr', 'GL', 'GRL', '299', 'GL.png', 'DKK'), (308, 'Grenada', 'East Caribbean dollar', '$', 'GD', 'GRD', '1', 'GD.png', 'XCD'), (312, 'Guadeloupe', 'euro', 'ââ', 'GP', 'GLP', '590', 'GP.png', 'EUR '), (316, 'Guam', 'US dollar', '$', 'GU', 'GUM', '1', 'GU.png', 'USD'), (320, 'Guatemala', 'quetzal (pl. quetzales)', 'Q', 'GT', 'GTM', '502', 'GT.png', 'GTQ'), (324, 'Guinea', 'Guinean franc', 'GNF', 'GN', 'GIN', '224', 'GN.png', 'GNF'), (328, 'Guyana', 'Guyana dollar', '$', 'GY', 'GUY', '592', 'GY.png', 'GYD'), (332, 'Haiti', 'gourde', 'G', 'HT', 'HTI', '509', 'HT.png', 'HTG'), (334, 'Heard Island and McDonald Islands', '', '$', 'HM', 'HMD', '61', 'HM.png', ''), (336, 'Holy See (Vatican City State)', 'euro', 'ââ', 'VA', 'VAT', '39', 'VA.png', 'EUR'), (340, 'Honduras', 'lempira', 'L', 'HN', 'HND', '504', 'HN.png', 'HNL'), (344, 'Hong Kong', 'Hong Kong dollar', '$', 'HK', 'HKG', '852', 'HK.png', 'HKD'), (348, 'Hungary', 'forint (inv.)', 'Ft', 'HU', 'HUN', '36', 'HU.png', 'HUF'), (352, 'Iceland', 'króna (pl. krónur)', 'kr', 'IS', 'ISL', '354', 'IS.png', 'ISK'), (356, 'India', 'Indian rupee', 'ââ', 'IN', 'IND', '91', 'IN.png', 'INR'), (360, 'Indonesia', 'Indonesian rupiah (inv.)', 'Rp', 'ID', 'IDN', '62', 'ID.png', 'IDR'), (364, 'Iran, Islamic Republic of', 'Iranian rial', 'ïÂ', 'IR', 'IRN', '98', 'IR.png', 'IRR'), (368, 'Iraq', 'Iraqi dinar', 'IQD', 'IQ', 'IRQ', '964', 'IQ.png', 'IQD'), (372, 'Ireland', 'euro', 'ââ', 'IE', 'IRL', '353', 'IE.png', 'EUR'), (376, 'Israel', 'shekel', 'ââ', 'IL', 'ISR', '972', 'IL.png', 'ILS'), (380, 'Italy', 'euro', 'ââ', 'IT', 'ITA', '39', 'IT.png', 'EUR'), (384, 'Côte d\'Ivoire', 'CFA franc (BCEAO)', 'XOF', 'CI', 'CIV', '225', 'CI.png', 'XOF'), (388, 'Jamaica', 'Jamaica dollar', '$', 'JM', 'JAM', '1', 'JM.png', 'JMD'), (392, 'Japan', 'yen (inv.)', 'ÂÂ', 'JP', 'JPN', '81', 'JP.png', 'JPY'), (398, 'Kazakhstan', 'tenge (inv.)', 'ÃÂ', 'KZ', 'KAZ', '7', 'KZ.png', 'KZT'), (400, 'Jordan', 'Jordanian dinar', 'JOD', 'JO', 'JOR', '962', 'JO.png', 'JOD'), (404, 'Kenya', 'Kenyan shilling', 'KES', 'KE', 'KEN', '254', 'KE.png', 'KES'), (408, 'Korea, Democratic People\'s Republic of', 'North Korean won (inv.)', 'ââ', 'KP', 'PRK', '850', 'KP.png', 'KPW'), (410, 'Korea, Republic of', 'South Korean won (inv.)', 'ââ', 'KR', 'KOR', '82', 'KR.png', 'KRW'), (414, 'Kuwait', 'Kuwaiti dinar', 'KWD', 'KW', 'KWT', '965', 'KW.png', 'KWD'), (417, 'Kyrgyzstan', 'som', 'ÃÂ', 'KG', 'KGZ', '996', 'KG.png', 'KGS'), (418, 'Lao People\'s Democratic Republic', 'kip (inv.)', 'ââ', 'LA', 'LAO', '856', 'LA.png', 'LAK'), (422, 'Lebanon', 'Lebanese pound', 'ÂÂ', 'LB', 'LBN', '961', 'LB.png', 'LBP'), (426, 'Lesotho', 'loti (pl. maloti)', 'L', 'LS', 'LSO', '266', 'LS.png', 'LSL'), (428, 'Latvia', 'euro', 'Ls', 'LV', 'LVA', '371', 'LV.png', 'EUR'), (430, 'Liberia', 'Liberian dollar', '$', 'LR', 'LBR', '231', 'LR.png', 'LRD'), (434, 'Libya', 'Libyan dinar', 'LYD', 'LY', 'LBY', '218', 'LY.png', 'LYD'), (438, 'Liechtenstein', 'Swiss franc', 'CHF', 'LI', 'LIE', '423', 'LI.png', 'CHF'), (440, 'Lithuania', 'euro', 'Lt', 'LT', 'LTU', '370', 'LT.png', 'EUR'), (442, 'Luxembourg', 'euro', 'ââ', 'LU', 'LUX', '352', 'LU.png', 'EUR'), (446, 'Macao', 'pataca', 'MOP', 'MO', 'MAC', '853', 'MO.png', 'MOP'), (450, 'Madagascar', 'ariary', 'MGA', 'MG', 'MDG', '261', 'MG.png', 'MGA'), (454, 'Malawi', 'Malawian kwacha (inv.)', 'MK', 'MW', 'MWI', '265', 'MW.png', 'MWK'), (458, 'Malaysia', 'ringgit (inv.)', 'RM', 'MY', 'MYS', '60', 'MY.png', 'MYR'), (462, 'Maldives', 'rufiyaa', 'Rf', 'MV', 'MDV', '960', 'MV.png', 'MVR'), (466, 'Mali', 'CFA franc (BCEAO)', 'XOF', 'ML', 'MLI', '223', 'ML.png', 'XOF'), (470, 'Malta', 'euro', 'MTL', 'MT', 'MLT', '356', 'MT.png', 'EUR'), (474, 'Martinique', 'euro', 'ââ', 'MQ', 'MTQ', '596', 'MQ.png', 'EUR'), (478, 'Mauritania', 'ouguiya', 'UM', 'MR', 'MRT', '222', 'MR.png', 'MRO'), (480, 'Mauritius', 'Mauritian rupee', 'ââ', 'MU', 'MUS', '230', 'MU.png', 'MUR'), (484, 'Mexico', 'Mexican peso', '$', 'MX', 'MEX', '52', 'MX.png', 'MXN'), (492, 'Monaco', 'euro', 'ââ', 'MC', 'MCO', '377', 'MC.png', 'EUR'), (496, 'Mongolia', 'tugrik', 'ââ', 'MN', 'MNG', '976', 'MN.png', 'MNT'), (498, 'Moldova, Republic of', 'Moldovan leu (pl. lei)', 'MDL', 'MD', 'MDA', '373', 'MD.png', 'MDL'), (499, 'Montenegro', 'euro', 'ââ', 'ME', 'MNE', '382', 'ME.png', 'EUR'), (500, 'Montserrat', 'East Caribbean dollar', '$', 'MS', 'MSR', '1', 'MS.png', 'XCD'), (504, 'Morocco', 'Moroccan dirham', 'MAD', 'MA', 'MAR', '212', 'MA.png', 'MAD'), (508, 'Mozambique', 'metical', 'MT', 'MZ', 'MOZ', '258', 'MZ.png', 'MZN'), (512, 'Oman', 'Omani rial', 'ïÂ', 'OM', 'OMN', '968', 'OM.png', 'OMR'), (516, 'Namibia', 'Namibian dollar', '$', 'NA', 'NAM', '264', 'NA.png', 'NAD'), (520, 'Nauru', 'Australian dollar', '$', 'NR', 'NRU', '674', 'NR.png', 'AUD'), (524, 'Nepal', 'Nepalese rupee', 'ââ', 'NP', 'NPL', '977', 'NP.png', 'NPR'), (528, 'Netherlands', 'euro', 'ââ', 'NL', 'NLD', '31', 'NL.png', 'EUR'), (531, 'Curaçao', 'Netherlands Antillean guilder (CW1)', NULL, 'CW', 'CUW', '599', NULL, 'ANG'), (533, 'Aruba', 'Aruban guilder', 'Æâ', 'AW', 'ABW', '297', 'AW.png', 'AWG'), (534, 'Sint Maarten (Dutch part)', 'Netherlands Antillean guilder (SX1)', NULL, 'SX', 'SXM', '721', NULL, 'ANG'), (535, 'Bonaire, Sint Eustatius and Saba', 'US dollar', NULL, 'BQ', 'BES', '599', NULL, 'USD'), (540, 'New Caledonia', 'CFP franc', 'XPF', 'NC', 'NCL', '687', 'NC.png', 'XPF'), (548, 'Vanuatu', 'vatu (inv.)', 'Vt', 'VU', 'VUT', '678', 'VU.png', 'VUV'), (554, 'New Zealand', 'New Zealand dollar', '$', 'NZ', 'NZL', '64', 'NZ.png', 'NZD'), (558, 'Nicaragua', 'córdoba oro', 'C$', 'NI', 'NIC', '505', 'NI.png', 'NIO'), (562, 'Niger', 'CFA franc (BCEAO)', 'XOF', 'NE', 'NER', '227', 'NE.png', 'XOF'), (566, 'Nigeria', 'naira (inv.)', 'ââ', 'NG', 'NGA', '234', 'NG.png', 'NGN'), (570, 'Niue', 'New Zealand dollar', '$', 'NU', 'NIU', '683', 'NU.png', 'NZD'), (574, 'Norfolk Island', 'Australian dollar', '$', 'NF', 'NFK', '672', 'NF.png', 'AUD'), (578, 'Norway', 'Norwegian krone (pl. kroner)', 'kr', 'NO', 'NOR', '47', 'NO.png', 'NOK'), (580, 'Northern Mariana Islands', 'US dollar', '$', 'MP', 'MNP', '1', 'MP.png', 'USD'), (581, 'United States Minor Outlying Islands', 'US dollar', '$', 'UM', 'UMI', '1', 'UM.png', 'USD'), (583, 'Micronesia, Federated States of', 'US dollar', '$', 'FM', 'FSM', '691', 'FM.png', 'USD'), (584, 'Marshall Islands', 'US dollar', '$', 'MH', 'MHL', '692', 'MH.png', 'USD'), (585, 'Palau', 'US dollar', '$', 'PW', 'PLW', '680', 'PW.png', 'USD'), (586, 'Pakistan', 'Pakistani rupee', 'ââ', 'PK', 'PAK', '92', 'PK.png', 'PKR'), (591, 'Panama', 'balboa', 'B/.', 'PA', 'PAN', '507', 'PA.png', 'PAB'), (598, 'Papua New Guinea', 'kina (inv.)', 'PGK', 'PG', 'PNG', '675', 'PG.png', 'PGK'), (600, 'Paraguay', 'guaranÃÂ', 'Gs', 'PY', 'PRY', '595', 'PY.png', 'PYG'), (604, 'Peru', 'new sol', 'S/.', 'PE', 'PER', '51', 'PE.png', 'PEN'), (608, 'Philippines', 'Philippine peso', 'Php', 'PH', 'PHL', '63', 'PH.png', 'PHP'), (612, 'Pitcairn', 'New Zealand dollar', '$', 'PN', 'PCN', '649', 'PN.png', 'NZD'), (616, 'Poland', 'zloty', 'zÃ…', 'PL', 'POL', '48', 'PL.png', 'PLN'), (620, 'Portugal', 'euro', 'ââ', 'PT', 'PRT', '351', 'PT.png', 'EUR'), (624, 'Guinea-Bissau', 'CFA franc (BCEAO)', 'XOF', 'GW', 'GNB', '245', 'GW.png', 'XOF'), (626, 'Timor-Leste', 'US dollar', '$', 'TL', 'TLS', '670', 'TL.png', 'USD'), (630, 'Puerto Rico', 'US dollar', '$', 'PR', 'PRI', '1', 'PR.png', 'USD'), (634, 'Qatar', 'Qatari riyal', 'ïÂ', 'QA', 'QAT', '974', 'QA.png', 'QAR'), (638, 'Réunion', 'euro', 'ââ', 'RE', 'REU', '262', 'RE.png', 'EUR'), (642, 'Romania', 'Romanian leu (pl. lei)', 'lei', 'RO', 'ROU', '40', 'RO.png', 'RON'), (643, 'Russian Federation', 'Russian rouble', 'Ñâ', 'RU', 'RUS', '7', 'RU.png', 'RUB'), (646, 'Rwanda', 'Rwandese franc', 'RWF', 'RW', 'RWA', '250', 'RW.png', 'RWF'), (652, 'Saint Barthélemy', 'euro', NULL, 'BL', 'BLM', '590', NULL, 'EUR'), (654, 'Saint Helena, Ascension and Tristan da Cunha', 'Saint Helena pound', 'ÂÂ', 'SH', 'SHN', '290', 'SH.png', 'SHP'), (659, 'Saint Kitts and Nevis', 'East Caribbean dollar', '$', 'KN', 'KNA', '1', 'KN.png', 'XCD'), (660, 'Anguilla', 'East Caribbean dollar', '$', 'AI', 'AIA', '1', 'AI.png', 'XCD'), (662, 'Saint Lucia', 'East Caribbean dollar', '$', 'LC', 'LCA', '1', 'LC.png', 'XCD'), (663, 'Saint Martin (French part)', 'euro', NULL, 'MF', 'MAF', '590', NULL, 'EUR'), (666, 'Saint Pierre and Miquelon', 'euro', 'ââ', 'PM', 'SPM', '508', 'PM.png', 'EUR'), (670, 'Saint Vincent and the Grenadines', 'East Caribbean dollar', '$', 'VC', 'VCT', '1', 'VC.png', 'XCD'), (674, 'San Marino', 'euro', 'ââ', 'SM', 'SMR', '378', 'SM.png', 'EUR '), (678, 'Sao Tome and Principe', 'dobra', 'Db', 'ST', 'STP', '239', 'ST.png', 'STD'), (682, 'Saudi Arabia', 'riyal', 'ïÂ', 'SA', 'SAU', '966', 'SA.png', 'SAR'), (686, 'Senegal', 'CFA franc (BCEAO)', 'XOF', 'SN', 'SEN', '221', 'SN.png', 'XOF'), (688, 'Serbia', 'Serbian dinar', NULL, 'RS', 'SRB', '381', NULL, 'RSD'), (690, 'Seychelles', 'Seychelles rupee', 'ââ', 'SC', 'SYC', '248', 'SC.png', 'SCR'), (694, 'Sierra Leone', 'leone', 'Le', 'SL', 'SLE', '232', 'SL.png', 'SLL'), (702, 'Singapore', 'Singapore dollar', '$', 'SG', 'SGP', '65', 'SG.png', 'SGD'), (703, 'Slovakia', 'euro', 'Sk', 'SK', 'SVK', '421', 'SK.png', 'EUR'), (704, 'Viet Nam', 'dong', 'ââ', 'VN', 'VNM', '84', 'VN.png', 'VND'), (705, 'Slovenia', 'euro', 'ââ', 'SI', 'SVN', '386', 'SI.png', 'EUR'), (706, 'Somalia', 'Somali shilling', 'S', 'SO', 'SOM', '252', 'SO.png', 'SOS'), (710, 'South Africa', 'rand', 'R', 'ZA', 'ZAF', '27', 'ZA.png', 'ZAR'), (716, 'Zimbabwe', 'Zimbabwe dollar (ZW1)', 'Z$', 'ZW', 'ZWE', '263', 'ZW.png', 'ZWL'), (724, 'Spain', 'euro', 'ââ', 'ES', 'ESP', '34', 'ES.png', 'EUR'), (728, 'South Sudan', 'South Sudanese pound', NULL, 'SS', 'SSD', '211', NULL, 'SSP'), (729, 'Sudan', 'Sudanese pound', NULL, 'SD', 'SDN', '249', NULL, 'SDG'), (732, 'Western Sahara', 'Moroccan dirham', 'MAD', 'EH', 'ESH', '212', 'EH.png', 'MAD'), (740, 'Suriname', 'Surinamese dollar', '$', 'SR', 'SUR', '597', 'SR.png', 'SRD'), (744, 'Svalbard and Jan Mayen', 'Norwegian krone (pl. kroner)', 'kr', 'SJ', 'SJM', '47', 'SJ.png', 'NOK'), (748, 'Swaziland', 'lilangeni', 'SZL', 'SZ', 'SWZ', '268', 'SZ.png', 'SZL'), (752, 'Sweden', 'krona (pl. kronor)', 'kr', 'SE', 'SWE', '46', 'SE.png', 'SEK'), (756, 'Switzerland', 'Swiss franc', 'CHF', 'CH', 'CHE', '41', 'CH.png', 'CHF'), (760, 'Syrian Arab Republic', 'Syrian pound', 'ÂÂ', 'SY', 'SYR', '963', 'SY.png', 'SYP'), (762, 'Tajikistan', 'somoni', 'TJS', 'TJ', 'TJK', '992', 'TJ.png', 'TJS'), (764, 'Thailand', 'baht (inv.)', 'à Â', 'TH', 'THA', '66', 'TH.png', 'THB'), (768, 'Togo', 'CFA franc (BCEAO)', 'XOF', 'TG', 'TGO', '228', 'TG.png', 'XOF'), (772, 'Tokelau', 'New Zealand dollar', '$', 'TK', 'TKL', '690', 'TK.png', 'NZD'), (776, 'Tonga', 'pa’anga (inv.)', 'T$', 'TO', 'TON', '676', 'TO.png', 'TOP'), (780, 'Trinidad and Tobago', 'Trinidad and Tobago dollar', 'TT$', 'TT', 'TTO', '1', 'TT.png', 'TTD'), (784, 'United Arab Emirates', 'UAE dirham', 'AED', 'AE', 'ARE', '971', 'AE.png', 'AED'), (788, 'Tunisia', 'Tunisian dinar', 'TND', 'TN', 'TUN', '216', 'TN.png', 'TND'), (792, 'Turkey', 'Turkish lira (inv.)', 'ââ', 'TR', 'TUR', '90', 'TR.png', 'TRY'), (795, 'Turkmenistan', 'Turkmen manat (inv.)', 'm', 'TM', 'TKM', '993', 'TM.png', 'TMT'), (796, 'Turks and Caicos Islands', 'US dollar', '$', 'TC', 'TCA', '1', 'TC.png', 'USD'), (798, 'Tuvalu', 'Australian dollar', '$', 'TV', 'TUV', '688', 'TV.png', 'AUD'), (800, 'Uganda', 'Uganda shilling', 'UGX', 'UG', 'UGA', '256', 'UG.png', 'UGX'), (804, 'Ukraine', 'hryvnia', 'ââ', 'UA', 'UKR', '380', 'UA.png', 'UAH'), (807, 'Macedonia, the former Yugoslav Republic of', 'denar (pl. denars)', 'ÃÂ', 'MK', 'MKD', '389', 'MK.png', 'MKD'), (818, 'Egypt', 'Egyptian pound', 'ÂÂ', 'EG', 'EGY', '20', 'EG.png', 'EGP'), (826, 'United Kingdom', 'pound sterling', 'ÂÂ', 'GB', 'GBR', '44', 'GB.png', 'GBP'), (831, 'Guernsey', 'Guernsey pound (GG2)', NULL, 'GG', 'GGY', '44', NULL, 'GGP (GG2)'), (832, 'Jersey', 'Jersey pound (JE2)', NULL, 'JE', 'JEY', '44', NULL, 'JEP (JE2)'), (833, 'Isle of Man', 'Manx pound (IM2)', NULL, 'IM', 'IMN', '44', NULL, 'IMP (IM2)'), (834, 'Tanzania, United Republic of', 'Tanzanian shilling', 'TZS', 'TZ', 'TZA', '255', 'TZ.png', 'TZS'), (840, 'United States', 'US dollar', '$', 'US', 'USA', '1', 'US.png', 'USD'), (850, 'Virgin Islands, U.S.', 'US dollar', '$', 'VI', 'VIR', '1', 'VI.png', 'USD'), (854, 'Burkina Faso', 'CFA franc (BCEAO)', 'XOF', 'BF', 'BFA', '226', 'BF.png', 'XOF'), (858, 'Uruguay', 'Uruguayan peso', '$U', 'UY', 'URY', '598', 'UY.png', 'UYU'), (860, 'Uzbekistan', 'sum (inv.)', 'ÃÂ', 'UZ', 'UZB', '998', 'UZ.png', 'UZS'), (862, 'Venezuela, Bolivarian Republic of', 'bolÃÂvar fuerte (pl. bolÃÂvares fuertes)', 'Bs', 'VE', 'VEN', '58', 'VE.png', 'VEF'), (876, 'Wallis and Futuna', 'CFP franc', 'XPF', 'WF', 'WLF', '681', 'WF.png', 'XPF'), (882, 'Samoa', 'tala (inv.)', 'WS$', 'WS', 'WSM', '685', 'WS.png', 'WST'), (887, 'Yemen', 'Yemeni rial', 'ïÂ', 'YE', 'YEM', '967', 'YE.png', 'YER'), (894, 'Zambia', 'Zambian kwacha (inv.)', 'ZK', 'ZM', 'ZMB', '260', 'ZM.png', 'ZMW'); -- -------------------------------------------------------- -- -- Table structure for table `coupons` -- CREATE TABLE `coupons` ( `id` bigint(20) UNSIGNED NOT NULL, `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` enum('fixed','free_service','percentage') COLLATE utf8mb4_unicode_ci DEFAULT 'fixed', `amount` decimal(15,2) DEFAULT '0.00', `min_spend` decimal(15,2) DEFAULT '0.00', `is_unlimited` int(11) DEFAULT '1', `usage_per_coupon` int(11) DEFAULT '0', `usage_per_customer` int(11) DEFAULT '0', `used` int(11) DEFAULT '0', `status` int(11) DEFAULT '1', `is_expired` int(11) DEFAULT '0', `is_apply_all` int(11) DEFAULT '0', `is_first_order` int(11) DEFAULT '0', `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `created_by_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `coupons` -- INSERT INTO `coupons` (`id`, `code`, `type`, `amount`, `min_spend`, `is_unlimited`, `usage_per_coupon`, `usage_per_customer`, `used`, `status`, `is_expired`, `is_apply_all`, `is_first_order`, `start_date`, `end_date`, `created_by_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'HS50OFF2024', 'percentage', 50.00, 100.00, 1, NULL, NULL, 0, 1, 0, 1, 0, '2024-06-14', '2025-12-31', 1, '2024-06-14 02:53:32', '2024-06-14 02:53:32', NULL), (2, 'SPRING10', 'fixed', 50.00, 100.00, 0, 30, 1, 0, 1, 0, 1, 1, NULL, NULL, 1, '2024-06-14 03:07:26', '2024-06-14 03:07:26', NULL), (3, 'EXCLUSIVEVIP', 'fixed', 15.00, 10.00, 1, NULL, NULL, 0, 1, 0, 1, 0, NULL, NULL, 1, '2024-06-14 03:08:52', '2024-06-14 03:08:52', NULL), (4, 'MOST25', 'fixed', 25.00, 120.00, 1, NULL, NULL, 0, 1, 0, 1, 1, NULL, NULL, 1, '2024-06-14 03:10:16', '2024-06-14 03:10:16', NULL), (5, 'FABULOUS15', 'percentage', 25.00, 100.00, 0, 1, 1, 0, 1, 0, 1, 1, '2024-06-14', '2025-12-31', 1, '2024-06-14 03:14:05', '2024-06-14 03:14:05', NULL), (6, 'SAVE20', 'fixed', 20.00, 100.00, 0, 1, 1, 0, 1, 0, 1, 1, NULL, NULL, 1, '2024-06-14 03:14:43', '2024-06-14 03:14:43', NULL), (7, 'FIXIT5', 'percentage', 10.00, 100.00, 0, 1, 1, 0, 1, 0, 1, 1, '2024-06-18', '2025-12-31', 1, '2024-06-14 03:15:39', '2024-06-14 03:15:39', NULL); -- -------------------------------------------------------- -- -- Table structure for table `coupon_users` -- CREATE TABLE `coupon_users` ( `id` bigint(20) UNSIGNED NOT NULL, `coupon_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `coupon_zones` -- CREATE TABLE `coupon_zones` ( `id` bigint(20) UNSIGNED NOT NULL, `coupon_id` bigint(20) UNSIGNED NOT NULL, `zone_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `currencies` -- CREATE TABLE `currencies` ( `id` bigint(20) UNSIGNED NOT NULL, `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `symbol` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `no_of_decimal` decimal(8,2) DEFAULT '2.00', `exchange_rate` decimal(8,2) DEFAULT '1.00', `thousands_separator` enum('comma','period','space') COLLATE utf8mb4_unicode_ci DEFAULT 'comma', `decimal_separator` enum('comma','period','space') COLLATE utf8mb4_unicode_ci DEFAULT 'comma', `system_reserve` int(11) NOT NULL DEFAULT '0', `status` int(11) DEFAULT '1', `created_by_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `currencies` -- INSERT INTO `currencies` (`id`, `code`, `symbol`, `no_of_decimal`, `exchange_rate`, `thousands_separator`, `decimal_separator`, `system_reserve`, `status`, `created_by_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'USD', '$', 2.00, 1.00, 'comma', 'comma', 0, 1, NULL, '2024-06-13 11:38:13', '2024-06-13 11:38:13', NULL), (2, 'INR', '₹', 2.00, 82.00, 'comma', 'comma', 0, 1, NULL, '2024-06-13 11:38:13', '2024-06-13 11:38:13', NULL), (3, 'GBP', '£', 2.00, 100.00, 'comma', 'comma', 0, 1, NULL, '2024-06-13 11:38:13', '2024-06-13 11:38:13', NULL), (4, 'EUR', '€', 2.00, 56.00, 'comma', 'comma', 0, 1, NULL, '2024-06-13 11:38:13', '2024-06-13 11:38:13', NULL); -- -------------------------------------------------------- -- -- Table structure for table `custom_sms_gateways` -- CREATE TABLE `custom_sms_gateways` ( `id` bigint(20) UNSIGNED NOT NULL, `base_url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `method` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `sid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `auth_token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `is_config` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `from` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `custom_keys` json DEFAULT NULL, `config` json DEFAULT NULL, `body` json DEFAULT NULL, `params` json DEFAULT NULL, `headers` json DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `custom_sms_gateways` -- INSERT INTO `custom_sms_gateways` (`id`, `base_url`, `method`, `sid`, `auth_token`, `is_config`, `from`, `custom_keys`, `config`, `body`, `params`, `headers`, `created_at`, `updated_at`) VALUES (1, 'https://api.twilio.com/2010-04-01/Accounts/AC29dca1a7ff0237356fd999c6ecb5d992/Messages.json', 'post', 'AC29dca1a7ff0237356fd999c6ecb5d992', '562b4f1ff7ade37ee543ae6e18bee36d', '[\"sid\",\"auth_token\"]', '16572084747', NULL, NULL, '{\"To\": \"{to}\", \"Body\": \"{message}\", \"From\": \"+16572084747\"}', '{\"\": null}', '{\"\": null}', '2024-10-22 18:36:58', '2024-11-04 23:46:22'); -- -------------------------------------------------------- -- -- Table structure for table `documents` -- CREATE TABLE `documents` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint(1) NOT NULL, `is_required` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `documents` -- INSERT INTO `documents` (`id`, `title`, `status`, `is_required`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Passport', 1, 0, '2024-06-13 12:47:16', '2024-06-13 12:47:16', NULL), (2, 'National Identity Card (ID Card)', 1, 0, '2024-06-13 12:47:32', '2024-06-13 12:47:32', NULL), (3, 'Driver\'s License', 1, 0, '2024-06-13 12:47:40', '2024-06-13 12:47:40', NULL), (4, 'Social Security Card', 1, 0, '2024-06-13 12:47:48', '2024-06-13 12:47:48', NULL), (5, 'Voter Identification Card', 1, 0, '2024-06-13 12:47:57', '2024-06-13 12:47:57', NULL), (6, 'Residence Permit', 1, 0, '2024-06-13 12:48:04', '2024-06-13 12:48:04', NULL), (7, 'Work Permit', 1, 0, '2024-06-13 12:48:21', '2024-06-13 12:48:21', NULL), (8, 'Tax Identification Number (TIN) Card', 1, 0, '2024-06-13 12:48:36', '2024-06-13 12:48:36', NULL), (9, 'Health Insurance Card', 1, 0, '2024-06-13 12:48:44', '2024-06-13 12:48:44', NULL), (10, 'Employee Identification Card', 1, 0, '2024-06-13 12:49:01', '2024-06-13 12:49:01', NULL); -- -------------------------------------------------------- -- -- Table structure for table `email_templates` -- CREATE TABLE `email_templates` ( `id` bigint(20) UNSIGNED NOT NULL, `title` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `content` longtext COLLATE utf8mb4_unicode_ci, `button_text` longtext COLLATE utf8mb4_unicode_ci, `button_url` longtext COLLATE utf8mb4_unicode_ci, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `email_templates` -- INSERT INTO `email_templates` (`id`, `title`, `slug`, `content`, `button_text`, `button_url`, `deleted_at`, `created_at`, `updated_at`) VALUES (1, '{\"en\":\"Laboriosam aut dele\",\"ar\":\"Qui distinctio Mini\",\"de\":\"Sit quia nisi quo d\",\"fr\":\"Optio soluta ipsam\"}', 'test-mail', '{\"en\":\"Qui aut nobis nihil\",\"ar\":\"Explicabo Accusanti\",\"de\":\"Sit consequatur Su\",\"fr\":\"Rerum amet ipsum co\"}', '{\"en\":\"Sunt voluptas offici\",\"ar\":\"Cum reprehenderit cu\",\"de\":\"Dolorem delectus su\",\"fr\":\"Velit magni minim er\"}', '{\"en\":\"https:\\/\\/www.vaguhac.ws\",\"ar\":\"https:\\/\\/www.sebapenepyveryr.tv\",\"de\":\"https:\\/\\/www.jizorovakypikog.net\",\"fr\":\"https:\\/\\/www.lejaluwo.in\"}', NULL, '2024-10-17 06:24:08', '2024-10-17 06:24:08'), (2, '{\"en\":\"New Service Request Created\",\"ar\":\"\\u0646\\u0626\\u06cc \\u0633\\u0631\\u0648\\u0633 \\u062f\\u0631\\u062e\\u0648\\u0627\\u0633\\u062a \\u062a\\u06cc\\u0627\\u0631 \\u06a9\\u06cc \\u06af\\u0626\\u06cc\",\"de\":\"Neue Serviceanfrage erstellt\",\"fr\":\"Nouvelle demande de service cr\\u00e9\\u00e9e\"}', 'new-service-request-provider', '{\"en\":\"
<\\/p>\\r\\n
Hello!<\\/p>\\r\\n
A new service request has been created and is available for bidding.<\\/p>\\r\\n
Thank you for using our application!<\\/p>\",\"ar\":\"
\\u06c1\\u06cc\\u0644\\u0648!<\\/p>\\r\\n
\\u0627\\u06cc\\u06a9 \\u0646\\u0626\\u06cc \\u0633\\u0631\\u0648\\u0633 \\u062f\\u0631\\u062e\\u0648\\u0627\\u0633\\u062a \\u062a\\u06cc\\u0627\\u0631 \\u06a9\\u06cc \\u06af\\u0626\\u06cc \\u06c1\\u06d2 \\u0627\\u0648\\u0631 \\u0628\\u0648\\u0644\\u06cc \\u06a9\\u06d2 \\u0644\\u06cc\\u06d2 \\u062f\\u0633\\u062a\\u06cc\\u0627\\u0628 \\u06c1\\u06d2\\u06d4<\\/p>\\r\\n
\\u06c1\\u0645\\u0627\\u0631\\u06d2 \\u0627\\u06cc\\u067e\\u0644\\u06cc\\u06a9\\u06cc\\u0634\\u0646 \\u06a9\\u0627 \\u0627\\u0633\\u062a\\u0639\\u0645\\u0627\\u0644 \\u06a9\\u0631\\u0646\\u06d2 \\u06a9\\u0627 \\u0634\\u06a9\\u0631\\u06cc\\u06c1!<\\/p>\",\"de\":\"
Hallo!<\\/p>\\r\\n
Eine neue Serviceanfrage wurde erstellt und steht zur Ausschreibung zur Verfügung.<\\/p>\\r\\n
Vielen Dank, dass Sie unsere Anwendung verwenden!<\\/p>\",\"fr\":\"
Bonjour!<\\/p>\\r\\n
Une nouvelle demande de service a été créée et est disponible pour les enchères.<\\/p>\\r\\n
Merci d\'utiliser notre application !<\\/p>\"}', '{\"en\":\"Click Here!\",\"ar\":\"\\u06cc\\u06c1\\u0627\\u06ba \\u06a9\\u0644\\u06a9 \\u06a9\\u0631\\u06cc\\u06ba\",\"de\":\"Hier klicken\",\"fr\":\"Cliquez ici\"}', '{\"en\":\"https:\\/\\/chatgpt.com\\/\",\"ar\":\"https:\\/\\/chatgpt.com\\/\",\"de\":\"https:\\/\\/chatgpt.com\\/\",\"fr\":\"https:\\/\\/chatgpt.com\\/\"}', NULL, '2024-10-18 04:44:31', '2024-10-18 04:44:31'), (3, '{\"en\":\"New Bid on Your Service Request\",\"ar\":\"\\u0622\\u067e \\u06a9\\u06cc \\u0633\\u0631\\u0648\\u0633 \\u062f\\u0631\\u062e\\u0648\\u0627\\u0633\\u062a \\u067e\\u0631 \\u0646\\u0626\\u06cc \\u0628\\u0648\\u0644\\u06cc\",\"de\":\"Neues Gebot auf Ihre Serviceanfrage\",\"fr\":\"Nouvelle offre sur votre demande de service\"}', 'new-bid-notification-consumer', '{\"en\":\"
Hello {{notifiable_name}},<\\/strong><\\/p>\\r\\n You\'ve received a new bid on your service request:<\\/p>\\r\\n Thank you for using our platform!<\\/p>\",\"ar\":\" \\u06c1\\u06cc\\u0644\\u0648 {{notifiable_name}},<\\/strong><\\/p>\\r\\n \\u0622\\u067e \\u06a9\\u0648 \\u0627\\u067e\\u0646\\u06cc \\u0633\\u0631\\u0648\\u0633 \\u062f\\u0631\\u062e\\u0648\\u0627\\u0633\\u062a \\u067e\\u0631 \\u0646\\u0626\\u06cc \\u0628\\u0648\\u0644\\u06cc \\u0645\\u0648\\u0635\\u0648\\u0644 \\u06c1\\u0648\\u0626\\u06cc \\u06c1\\u06d2:<\\/p>\\r\\n \\u06c1\\u0645\\u0627\\u0631\\u0627 \\u067e\\u0644\\u06cc\\u0679 \\u0641\\u0627\\u0631\\u0645 \\u0627\\u0633\\u062a\\u0639\\u0645\\u0627\\u0644 \\u06a9\\u0631\\u0646\\u06d2 \\u06a9\\u0627 \\u0634\\u06a9\\u0631\\u06cc\\u06c1!<\\/p>\",\"de\":\" Hallo {{notifiable_name}},<\\/strong><\\/p>\\r\\n Sie haben ein neues Gebot auf Ihre Serviceanfrage erhalten:<\\/p>\\r\\n Vielen Dank, dass Sie unsere Plattform nutzen!<\\/p>\",\"fr\":\" Bonjour {{notifiable_name}},<\\/strong><\\/p>\\r\\n Vous avez reçu une nouvelle offre sur votre demande de service :<\\/p>\\r\\n Merci d\'utiliser notre plateforme !<\\/p>\"}', '{\"en\":\"Click here\",\"ar\":\"\\u06cc\\u06c1\\u0627\\u06ba \\u06a9\\u0644\\u06a9 \\u06a9\\u0631\\u06cc\\u06ba\",\"de\":\"Hier klicken\",\"fr\":\"Cliquez ici\"}', '{\"en\":\"https:\\/\\/www.xalote.mobi\",\"ar\":\"https:\\/\\/www.xalote.mobi\",\"de\":\"https:\\/\\/www.xalote.mobi\",\"fr\":\"https:\\/\\/www.pofeqyk.ca\"}', NULL, '2024-10-18 22:23:34', '2024-10-18 22:24:02'),
(4, '{\"en\":\"Bid Updated for Service Request\",\"ar\":\"\\u0622\\u067e \\u06a9\\u06cc \\u0633\\u0631\\u0648\\u0633 \\u062f\\u0631\\u062e\\u0648\\u0627\\u0633\\u062a \\u06a9\\u06d2 \\u0644\\u06cc\\u06d2 \\u0628\\u0648\\u0644\\u06cc \\u06a9\\u0648 \\u0627\\u067e \\u0688\\u06cc\\u0679 \\u06a9\\u06cc\\u0627 \\u06af\\u06cc\\u0627\",\"de\":\"Gebot aktualisiert f\\u00fcr Ihre Serviceanfrage\",\"fr\":\"Offre mise \\u00e0 jour sur votre demande de service\"}', 'update-bid-provider', '{\"en\":\" Hello {{notifiable_name}},<\\/strong><\\/p>\\r\\n The bid for your service request has been updated:<\\/p>\\r\\n\\r\\n
\\r\\n
\\r\\n
\\r\\n