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

START TRANSACTION;



--
-- Database: `mimeld_mxspax`
--

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

--
-- Table structure for table `address`
--

CREATE TABLE `address` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `house` text DEFAULT NULL,
  `landmark` text DEFAULT NULL,
  `pincode` varchar(255) DEFAULT NULL,
  `lat` varchar(255) NOT NULL,
  `lng` varchar(255) NOT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `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 `appointments`
--

CREATE TABLE `appointments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `freelancer_id` int(11) NOT NULL DEFAULT 0,
  `salon_id` int(11) NOT NULL DEFAULT 0,
  `specialist_id` int(11) NOT NULL DEFAULT 0,
  `appointments_to` int(11) NOT NULL,
  `address` text DEFAULT NULL,
  `items` text NOT NULL,
  `coupon_id` int(11) DEFAULT NULL,
  `coupon` text DEFAULT NULL,
  `discount` double(10,2) NOT NULL,
  `distance_cost` double(10,2) NOT NULL,
  `total` double(10,2) NOT NULL,
  `serviceTax` double(10,2) NOT NULL,
  `grand_total` double(10,2) NOT NULL,
  `pay_method` int(11) NOT NULL,
  `paid` text NOT NULL,
  `save_date` date NOT NULL,
  `slot` varchar(255) NOT NULL,
  `wallet_used` tinyint(4) NOT NULL DEFAULT 0,
  `wallet_price` double(10,2) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT 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 `banners`
--

CREATE TABLE `banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `city_id` int(11) NOT NULL,
  `cover` text NOT NULL,
  `type` tinyint(4) NOT NULL,
  `value` text NOT NULL,
  `title` text DEFAULT NULL,
  `from` date NOT NULL,
  `to` date NOT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `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 `banners`
--

INSERT INTO `banners` (`id`, `city_id`, `cover`, `type`, `value`, `title`, `from`, `to`, `extra_field`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 'WawoCZQNab1aMuzRurmJU2a3MQzMLn8xJGWduse0.jpg', 2, '3', 'asdf', '2003-06-26', '2024-07-26', NULL, 1, '2024-07-26 04:01:06', '2024-07-26 04:01:06'),
(2, 3, '3THd0GyxShCggFoOifOyB0Po6HELnijU3MvsSdPL.png', 2, '3', 'asdf', '2024-07-26', '2024-07-26', NULL, 1, '2024-07-26 04:03:51', '2024-07-26 04:03:51');

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` text NOT NULL,
  `cover` text NOT NULL,
  `short_content` text NOT NULL,
  `content` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `extra_field` text 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 `blogs`
--

INSERT INTO `blogs` (`id`, `title`, `cover`, `short_content`, `content`, `status`, `extra_field`, `created_at`, `updated_at`) VALUES
(1, 'Top Hair Trends of the Year: Must-Try Styles for Every Hair Type', 'NnRPnpht05QpABHiijCeY653VQVdVTVKr6fn0IIo.webp', 'Welcome to our annual roundup of the top hair trends! Whether you’re looking to update your look or find inspiration for your next salon visit, this guide covers everything you need to know about the must-try styles for this year.', '<p>Introduction</p>\n\n<p>Welcome to our annual roundup of the top hair trends! Whether you&rsquo;re looking to update your look or find inspiration for your next salon visit, this guide covers everything you need to know about the must-try styles for this year.</p>\n\n<p>1. Bold Colors</p>\n\n<p><strong>Vibrant Reds</strong>: Make a statement with fiery red hues that turn heads. <strong>Pastel Shades</strong>: Soft, pastel colors like lavender and peach are perfect for a subtle yet stylish change. <strong>Two-Tone Styles</strong>: Blending two contrasting colors for a unique and edgy look.</p>\n\n<p>2. Innovative Cuts</p>\n\n<p><strong>The Pixie Cut</strong>: A short, chic style that&#39;s easy to manage and versatile. <strong>Curtain Bangs</strong>: Face-framing bangs that add softness and elegance to any haircut. <strong>Blunt Bob</strong>: A sharp, clean cut that exudes confidence and modernity.</p>\n\n<p>3. Trending Textures</p>\n\n<p><strong>Beach Waves</strong>: Effortlessly chic waves that give you that just-from-the-beach look. <strong>Corkscrew Curls</strong>: Embrace your natural curls with enhanced definition and volume. <strong>Sleek and Straight</strong>: A timeless look that&#39;s always in style, perfect for any occasion.</p>\n\n<p>4. Styles for Different Hair Types</p>\n\n<p><strong>Fine Hair</strong>: Styles that add volume and dimension, such as layered cuts and texturizing sprays. <strong>Thick Hair</strong>: Techniques to manage and showcase thick hair, including thinning and shaping. <strong>Curly Hair</strong>: How to define and control curls, with tips on products and maintenance.</p>\n\n<p>Conclusion</p>\n\n<p>Stay trendy and stylish by trying out these top hair trends. Whether you opt for a bold color change, a new cut, or an updated texture, our expert tips will help you achieve and maintain the perfect look.</p>', 1, NULL, '2024-07-26 04:12:16', '2024-07-26 04:12:16'),
(2, 'The Ultimate Guide to Healthy Hair: Tips and Tricks from the Experts', 'zRSdV0di53oEhilgizefDTIfusNVnT2YSLePV6vH.webp', 'Healthy hair is the foundation of beautiful styles. In this ultimate guide, we’ll share expert tips and tricks to help you achieve and maintain healthy, vibrant hair.', '<p>Introduction</p>\n\n<p>Healthy hair is the foundation of beautiful styles. In this ultimate guide, we&rsquo;ll share expert tips and tricks to help you achieve and maintain healthy, vibrant hair.</p>\n\n<p>1. Hair Care Routines</p>\n\n<p><strong>Daily Care</strong>: How often to wash your hair, which products to use, and tips for different hair types. <strong>Weekly Treatments</strong>: Deep conditioning treatments and masks that nourish and repair hair. <strong>Monthly Maintenance</strong>: Trims and treatments to keep your hair in top condition.</p>\n\n<p>2. Best Products for Healthy Hair</p>\n\n<p><strong>Shampoos and Conditioners</strong>: Choosing the right products for your hair type. <strong>Leave-In Treatments</strong>: Benefits of leave-in conditioners and serums. <strong>Heat Protectants</strong>: Why they are essential and how to use them correctly.</p>\n\n<p>3. Preventing Damage</p>\n\n<p><strong>Heat Styling</strong>: Tips for minimizing damage from blow dryers, straighteners, and curling irons. <strong>Chemical Treatments</strong>: How to care for colored or chemically treated hair. <strong>Environmental Factors</strong>: Protecting your hair from sun, wind, and pollution.</p>\n\n<p>4. Promoting Hair Growth</p>\n\n<p><strong>Diet and Nutrition</strong>: Foods and supplements that promote healthy hair growth. <strong>Scalp Care</strong>: The importance of a healthy scalp and how to maintain it. <strong>Lifestyle Tips</strong>: How stress, sleep, and exercise affect your hair.</p>\n\n<p>5. Maintaining Shine and Strength</p>\n\n<p><strong>Natural Oils</strong>: Benefits of using oils like argan, coconut, and jojoba for hair health. <strong>Hair Masks</strong>: DIY and store-bought masks that add shine and strength. <strong>Regular Trims</strong>: Why trimming your hair regularly is crucial for maintaining its health.</p>\n\n<p>Conclusion</p>\n\n<p>Achieving healthy hair is a combination of proper care, the right products, and a healthy lifestyle. Follow our expert tips and tricks to enjoy vibrant, shiny, and strong hair every day.</p>', 1, NULL, '2024-07-26 04:12:47', '2024-07-26 04:12:47'),
(3, 'Bridal Beauty: How to Prep Your Hair for the Big Day', '4M9OT93GLIstKXMA15pO7VrQCrFtdLLJSjbg5RDd.jpg', 'Your wedding day is one of the most important days of your life, and your hair plays a significant role in your overall look. This guide provides a comprehensive plan to ensure your hair is perfect for your big day.', '<p>Introduction</p>\n\n<p>Your wedding day is one of the most important days of your life, and your hair plays a significant role in your overall look. This guide provides a comprehensive plan to ensure your hair is perfect for your big day.</p>\n\n<p>1. Initial Consultations</p>\n\n<p><strong>Choosing a Stylist</strong>: How to find a stylist who understands your vision. <strong>Hair Trials</strong>: The importance of hair trials and what to expect. <strong>Style Selection</strong>: Tips for choosing a hairstyle that complements your dress and face shape.</p>\n\n<p>2. Hair Care Leading Up to the Wedding</p>\n\n<p><strong>Six Months Before</strong>: Start a hair care routine to ensure your hair is in its best condition. <strong>Three Months Before</strong>: Schedule any color treatments or trims. <strong>One Month Before</strong>: Final hair trial and any last-minute adjustments.</p>\n\n<p>3. Day-Of Hair Preparation</p>\n\n<p><strong>Morning Routine</strong>: How to prepare your hair the morning of your wedding. <strong>Styling Tips</strong>: Techniques for ensuring your hairstyle lasts all day. <strong>Emergency Kit</strong>: Essential items to have on hand for any hair emergencies.</p>\n\n<p>4. Popular Bridal Hairstyles</p>\n\n<p><strong>Classic Updos</strong>: Elegant and timeless styles that never go out of fashion. <strong>Romantic Waves</strong>: Soft, flowing waves that add a touch of romance. <strong>Braided Beauty</strong>: Intricate braids that add detail and interest to your look.</p>\n\n<p>5. Post-Wedding Hair Care</p>\n\n<p><strong>Aftercare Tips</strong>: How to take care of your hair after the big day. <strong>Preserving Your Style</strong>: Tips for keeping your hairstyle looking fresh for photos and events.</p>\n\n<p>Conclusion</p>\n\n<p>With careful planning and preparation, your hair will look stunning on your wedding day. Follow our guide to ensure every detail is perfect, from the initial consultation to the final touch-up.</p>', 1, NULL, '2024-07-26 04:13:17', '2024-07-26 04:13:17');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `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 `categories`
--

INSERT INTO `categories` (`id`, `name`, `cover`, `extra_field`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Hair Services', 'juhfkw3TuotsdGvviaWrV1B9Rj9kkLN5SDbaupzo.jpg', NULL, 1, '2024-07-26 02:56:40', '2024-07-26 02:56:40'),
(2, 'Skin Care', 'GG1G3aHPcnxHM4MaU1mTpHYm3lihpnhARXg1quEx.jpg', NULL, 1, '2024-07-26 02:57:54', '2024-07-26 02:57:54'),
(3, 'Body Treatments', 'f2owvu0F29F012CT8hMK3XQo8JkxCkPF0ynRTNiy.jpg', NULL, 1, '2024-07-26 02:58:30', '2024-07-26 02:58:30'),
(4, 'Nail Services', '4e91jOYC4791J6BEXVZReiwVQd2FJjzCnbGdNxi4.jpg', NULL, 1, '2024-07-26 03:00:12', '2024-07-26 03:00:12'),
(5, 'Makeup', 'NWrrPbQMYxQw6u5wA4g0005wJMlOSqW5bNGweFy1.jpg', NULL, 1, '2024-07-26 03:02:43', '2024-07-26 03:02:43');

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

--
-- Table structure for table `chat_rooms`
--

CREATE TABLE `chat_rooms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `last_message` text DEFAULT NULL,
  `last_message_type` tinyint(4) DEFAULT NULL,
  `extra_fields` text DEFAULT NULL,
  `status` tinyint(4) NOT 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 `cities`
--

CREATE TABLE `cities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `lat` varchar(255) NOT NULL,
  `lng` varchar(255) NOT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `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 `cities`
--

INSERT INTO `cities` (`id`, `name`, `lat`, `lng`, `extra_field`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Indore', '22.71081185', '75.80769175', NULL, 1, '2024-07-26 03:05:02', '2024-07-26 03:05:02'),
(2, 'Mumbai', '19.08157715', '72.88662754', NULL, 1, '2024-07-26 03:05:34', '2024-07-26 03:05:34'),
(3, 'Pune', '18.521428', '73.8544541', NULL, 1, '2024-07-26 03:05:54', '2024-07-26 03:05:54'),
(4, 'New York', '51,265423', '65,478213', NULL, 1, '2024-07-26 03:05:54', '2024-07-26 03:05:54'),
(5, 'Washington DC', '6.9745621', '5.6542997', NULL, 1, '2024-07-26 03:06:28', '2024-07-26 03:06:28'),
(6, 'Banglore', '14.1122044', '78.1575131', NULL, 1, '2024-07-26 03:07:07', '2024-07-26 03:07:07');

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

--
-- Table structure for table `commission`
--

CREATE TABLE `commission` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `rate` double NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `extra_field` text 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 `commission`
--

INSERT INTO `commission` (`id`, `uid`, `rate`, `status`, `extra_field`, `created_at`, `updated_at`) VALUES
(1, 2, 10, 1, NULL, '2024-07-26 03:12:50', '2024-07-26 03:12:50'),
(2, 3, 50, 1, NULL, '2024-07-26 03:58:18', '2024-07-26 03:58:18'),
(3, 4, 5, 1, NULL, '2024-07-26 03:59:20', '2024-07-26 03:59:20'),
(4, 5, 900, 1, NULL, '2024-07-26 04:01:00', '2024-07-26 04:01:00'),
(5, 6, 600, 1, NULL, '2024-07-26 04:02:57', '2024-07-26 04:02:57'),
(6, 7, 600, 1, NULL, '2024-07-26 04:04:42', '2024-07-26 04:04:42');

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

--
-- Table structure for table `complaints`
--

CREATE TABLE `complaints` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `order_id` int(11) DEFAULT NULL,
  `appointment_id` int(11) DEFAULT NULL,
  `complaints_on` tinyint(4) NOT NULL,
  `issue_with` tinyint(4) NOT NULL,
  `driver_id` int(11) DEFAULT NULL,
  `freelancer_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `reason_id` int(11) DEFAULT NULL,
  `title` text DEFAULT NULL,
  `short_message` text DEFAULT NULL,
  `images` text DEFAULT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT 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 `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `extra_field` text 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 `conversions`
--

CREATE TABLE `conversions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sender_id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `message_type` tinyint(4) NOT NULL,
  `reported` tinyint(4) DEFAULT NULL,
  `extra_fields` text DEFAULT NULL,
  `status` tinyint(4) NOT 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 `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `individual`
--

CREATE TABLE `individual` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `background` varchar(255) NOT NULL,
  `categories` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `lat` varchar(255) DEFAULT NULL,
  `lng` varchar(255) DEFAULT NULL,
  `cid` varchar(255) DEFAULT NULL,
  `about` text DEFAULT NULL,
  `rating` double(10,2) NOT NULL DEFAULT 0.00,
  `fee_start` double(10,2) NOT NULL DEFAULT 0.00,
  `total_rating` int(11) NOT NULL,
  `website` text DEFAULT NULL,
  `timing` text DEFAULT NULL,
  `images` text DEFAULT NULL,
  `zipcode` text DEFAULT NULL,
  `verified` tinyint(4) NOT NULL DEFAULT 1,
  `in_home` tinyint(4) NOT NULL DEFAULT 1,
  `popular` tinyint(4) NOT NULL DEFAULT 1,
  `have_shop` tinyint(4) NOT NULL DEFAULT 1,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `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 `individual`
--

INSERT INTO `individual` (`id`, `uid`, `background`, `categories`, `address`, `lat`, `lng`, `cid`, `about`, `rating`, `fee_start`, `total_rating`, `website`, `timing`, `images`, `zipcode`, `verified`, `in_home`, `popular`, `have_shop`, `extra_field`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 'NA', '1,3,2', 'Pune', '18.521428', '73.8544541', '3', 'null', 0.00, 100.00, 0, 'NA', 'NA', 'NA', '123654', 1, 1, 1, 1, 'NA', 1, '2024-07-26 03:12:50', '2024-07-26 03:13:10'),
(2, 4, 'NA', '1,2,3,4,5', 'mumbai', '12.45454', '16.741258', '2', 'have a good service', 0.00, 5.00, 0, 'NA', 'NA', 'NA', '4500001', 1, 1, 0, 1, 'NA', 1, '2024-07-26 03:59:20', '2024-07-26 03:59:20');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2018_11_06_222923_create_transactions_table', 1),
(4, '2018_11_07_192923_create_transfers_table', 1),
(5, '2018_11_15_124230_create_wallets_table', 1),
(6, '2019_08_19_000000_create_failed_jobs_table', 1),
(7, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(8, '2021_11_02_202021_update_wallets_uuid_table', 1),
(9, '2024_06_20_052736_create_address_table', 1),
(10, '2024_06_20_052736_create_appointments_table', 1),
(11, '2024_06_20_052736_create_banners_table', 1),
(12, '2024_06_20_052736_create_blogs_table', 1),
(13, '2024_06_20_052736_create_categories_table', 1),
(14, '2024_06_20_052737_create_chat_rooms_table', 1),
(15, '2024_06_20_052737_create_cities_table', 1),
(16, '2024_06_20_052737_create_commission_table', 1),
(17, '2024_06_20_052737_create_complaints_table', 1),
(18, '2024_06_20_052737_create_contacts_table', 1),
(19, '2024_06_20_052737_create_conversions_table', 1),
(20, '2024_06_20_052737_create_individual_table', 1),
(21, '2024_06_20_052737_create_offers_table', 1),
(22, '2024_06_20_052737_create_otp_table', 1),
(23, '2024_06_20_052737_create_owner_reviews_table', 1),
(24, '2024_06_20_052737_create_packages_reviews_table', 1),
(25, '2024_06_20_052737_create_packages_table', 1),
(26, '2024_06_20_052737_create_pages_table', 1),
(27, '2024_06_20_052738_create_payments_table', 1),
(28, '2024_06_20_052738_create_product_categories_table', 1),
(29, '2024_06_20_052738_create_product_reviews_table', 1),
(30, '2024_06_20_052738_create_product_sub_category_table', 1),
(31, '2024_06_20_052738_create_products_orders_table', 1),
(32, '2024_06_20_052738_create_products_table', 1),
(33, '2024_06_20_052738_create_redeem_table', 1),
(34, '2024_06_20_052738_create_referral_table', 1),
(35, '2024_06_20_052738_create_referralcodes_table', 1),
(36, '2024_06_20_052738_create_register_request_table', 1),
(37, '2024_06_20_052738_create_salon_table', 1),
(38, '2024_06_20_052738_create_service_reviews_table', 1),
(39, '2024_06_20_052738_create_services_table', 1),
(40, '2024_06_20_052738_create_settings_table', 1),
(41, '2024_06_20_052739_create_specialist_table', 1),
(42, '2024_06_20_052739_create_timeslots_table', 1);

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

--
-- Table structure for table `offers`
--

CREATE TABLE `offers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `short_descriptions` text NOT NULL,
  `code` text NOT NULL,
  `type` tinyint(4) NOT NULL,
  `for` tinyint(4) NOT NULL,
  `discount` double(10,2) NOT NULL,
  `upto` double(10,2) NOT NULL,
  `expire` date NOT NULL,
  `freelancer_ids` text NOT NULL,
  `max_usage` int(11) NOT NULL,
  `min_cart_value` double(10,2) NOT NULL,
  `validations` tinyint(4) NOT NULL,
  `user_limit_validation` int(11) DEFAULT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT 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 `offers`
--

INSERT INTO `offers` (`id`, `name`, `short_descriptions`, `code`, `type`, `for`, `discount`, `upto`, `expire`, `freelancer_ids`, `max_usage`, `min_cart_value`, `validations`, `user_limit_validation`, `extra_field`, `status`, `created_at`, `updated_at`) VALUES
(1, '13377', 'Grand Opening Offer', '13377', 1, 1, 50.00, 100.00, '2024-12-27', '3,5,6,7,2,4', 3, 500.00, 1, 10, NULL, 1, '2024-07-26 04:17:00', '2024-07-26 04:17:00'),
(2, '56214', 'Daily Offer', '56214', 0, 1, 10.00, 50.00, '2025-07-19', '3,5,2,4', 2, 200.00, 1, 10, NULL, 1, '2024-07-26 04:17:55', '2024-07-26 04:17:55');

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

--
-- Table structure for table `owner_reviews`
--

CREATE TABLE `owner_reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `freelancer_id` varchar(255) NOT NULL,
  `notes` text DEFAULT NULL,
  `rating` double(10,2) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `extra_field` text 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 `packages`
--

CREATE TABLE `packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `package_from` tinyint(4) NOT NULL,
  `name` text NOT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `service_id` text NOT NULL,
  `descriptions` text DEFAULT NULL,
  `images` text DEFAULT NULL,
  `duration` double(10,2) DEFAULT NULL,
  `price` double(10,2) DEFAULT NULL,
  `off` double(10,2) DEFAULT NULL,
  `discount` double(10,2) DEFAULT NULL,
  `specialist_ids` text DEFAULT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `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 `packages_reviews`
--

CREATE TABLE `packages_reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `freelancer_id` int(11) NOT NULL,
  `notes` text DEFAULT NULL,
  `rating` double(10,2) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `extra_field` text 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 `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` text NOT NULL,
  `content` longtext NOT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT 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 `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `freelacer_id` int(11) NOT NULL,
  `cover` text NOT NULL,
  `name` text NOT NULL,
  `images` text NOT NULL,
  `original_price` double(10,2) DEFAULT NULL,
  `sell_price` double(10,2) DEFAULT NULL,
  `discount` double(10,2) DEFAULT NULL,
  `cate_id` int(11) DEFAULT NULL,
  `sub_cate_id` int(11) DEFAULT NULL,
  `in_home` tinyint(4) DEFAULT NULL,
  `is_single` tinyint(4) DEFAULT NULL,
  `have_gram` tinyint(4) DEFAULT NULL,
  `gram` varchar(255) DEFAULT NULL,
  `have_kg` tinyint(4) DEFAULT NULL,
  `kg` varchar(255) DEFAULT NULL,
  `have_pcs` tinyint(4) DEFAULT NULL,
  `pcs` varchar(255) DEFAULT NULL,
  `have_liter` tinyint(4) DEFAULT NULL,
  `liter` varchar(255) DEFAULT NULL,
  `have_ml` tinyint(4) DEFAULT NULL,
  `ml` varchar(255) DEFAULT NULL,
  `descriptions` text DEFAULT NULL,
  `key_features` text DEFAULT NULL,
  `disclaimer` text DEFAULT NULL,
  `exp_date` date DEFAULT NULL,
  `in_offer` tinyint(4) NOT NULL DEFAULT 2,
  `in_stock` tinyint(4) NOT NULL DEFAULT 0,
  `rating` double(10,2) DEFAULT NULL,
  `total_rating` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `extra_field` text 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 `products`
--

INSERT INTO `products` (`id`, `freelacer_id`, `cover`, `name`, `images`, `original_price`, `sell_price`, `discount`, `cate_id`, `sub_cate_id`, `in_home`, `is_single`, `have_gram`, `gram`, `have_kg`, `kg`, `have_pcs`, `pcs`, `have_liter`, `liter`, `have_ml`, `ml`, `descriptions`, `key_features`, `disclaimer`, `exp_date`, `in_offer`, `in_stock`, `rating`, `total_rating`, `status`, `extra_field`, `created_at`, `updated_at`) VALUES
(1, 2, '4F6sMr3clENd2IsrLXYxx3Ewy5k5HQfrTXLYFNXT.jpg', 'Bridal Bliss', '[\"B7r7wDcYMkJUD7thmMIPiSfxlbLoNJsBUWG2Ar6E.png\",\"em4dt7t7GPzjAQ9NDDdsqhn7ixuCjlghXp53kgzs.jpg\",\"Ve6r9XpNvwS6UB7zMnfTqoMihvU9VK8joMtEuZvi.jpg\",\"7JdK8JN7vUTPg4uqaw1q6Ism6t9jhUTmOmGbxTvm.jpg\",\"wrpBZGLhnyqOsxRwEuSYSDizQydAxIlpYQ6avb4p.jpg\",\"Vm0rBRrPz5LmUNuohVnqWxuYydjpd8ET8Y5BDu2x.jpg\"]', 5000.00, 3750.00, 25.00, 2, 2, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2025-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-29 10:39:13', '2024-08-01 03:37:01'),
(2, 2, 'M8q47WMyh7NVCxikq0tq7MLROHfdsAcsZ3toRGlS.jpg', 'Loreal Paris Serum', '[\"ZPIQ2tMOduaMGoywkZzXOvJY3jHWPh2wnILDVLGU.jpg\",\"DV3uMWjUdRlGkKQabN6BwdFy3Lr8GCxeda7TwhW4.jpg\",\"6lpeU6ffTEdRRMIRsH9sHkQY382GF0dNQKMayjBy.jpg\",\"Li5Sf1GQAtL6Du2Z6GhU5aBsqT8enGpJbrUwk9LX.jpg\",\"u73QunVAixjRRx0CAH3dGH1SIfkbH1bj9XN2HsV1.jpg\",\"\"]', 402.00, 393.96, 2.00, 1, 1, 1, 1, 1, '100', 0, '0', 0, '0', 0, '0', 0, '0', NULL, NULL, NULL, '2028-04-20', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:04:28', '2024-07-31 06:13:01'),
(3, 2, '2z4gacVaPIFY4LIcN28YZudzFHm27OmDSqDpUstq.jpg', 'Biolage Smoothproof', '[\"5gzQvODdju2qjRmuPmtSQB8vufmjsT8fQ8D59PaG.jpg\",\"QAwYWQMmReZEW5nyCWaQHZ3fy3IYKqmeeEKSjr5m.jpg\",\"eBjdhYEP4Qt6qrgiIN3UrCjFjyHODsDWrlTcxBom.jpg\",\"\",\"\",\"\"]', 350.00, 346.50, 1.00, 1, 1, 1, 1, 0, '0', 0, '0', 0, '0', 0, '0', 1, '700', NULL, NULL, NULL, '2025-04-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:10:46', '2024-07-31 06:33:50'),
(5, 2, 'hwvkLYENZZwfc4lK7ZLr8tvKNerr6Df0lZkuEaxL.jpg', 'Livon Serum', '[\"VWh006Iv3oBdPwxqs8WgxmuW3xVFjUPtr6gwAFn7.jpg\",\"8XRY2rVEFbDbCaN7QY4zw8o4kDQG3vR2yByYO1zs.jpg\",\"h6eSl2KUkQEhytVBEAjGKC4Sw6OzW3AxtBjySdbx.jpg\",\"qUbJwNsyY9044f55GYf09M0gL7sLtdhif5qgGXqa.jpg\",\"rSctPtZRe93mEM0IK8EVbeXnrEiUmxPpJAwE83uN.jpg\",\"\"]', 211.00, 211.00, 0.00, 1, 1, 1, 0, 0, '0', 0, '0', 0, '0', 0, '0', 1, '900', NULL, NULL, NULL, '2026-01-15', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:12:49', '2024-07-31 06:19:07'),
(6, 2, 'VCtuHOpfcGOaKJepbhVRskteXhrUULciwJm5yVwh.jpg', 'AGARO Atom Electric Handheld Full Body Massager with 3 Massage Head', '[\"bsHW7wKn3fE4OEBApg9nUjrGXt8xQEGlNVSvyaRy.jpg\",\"hQR8qWlEZMEw37RcRsaw6C9tgvQrohReGxweNWJ1.jpg\",\"PiOjsghTaBpdbVecwZWF1PKRtYrXBIn4fyQM01Dz.jpg\",\"TMeUsi5JwYBhjmQYIGlfwzMTn9MrCIGpGN8i8kbZ.jpg\",\"\",\"\"]', 1000.00, 900.00, 10.00, 3, 3, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2026-12-31', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:16:43', '2024-07-31 03:33:04'),
(7, 2, 'xTK0WvBAKVA93l2S9wMK7my7zeUSyAY0MHik7awD.jpg', 'ThriveCo Anti-Grey Hair', '[\"Fsuz6eHAVQtl6X6gxAlABT88Ib8RLMx7NA8DZCLI.jpg\",\"M571lldtSp6gEXqwUr3IWfNis61OjWrkRgHA8a3A.jpg\",\"OJiCi90SYTdes2FQ3o7vV77RaHRLArF6uL8gmdD6.jpg\",\"dPgWv9BYQqfQLIOuJNmG1Wl91ynyt92lgKdisrkv.jpg\",\"\",\"\"]', 825.00, 412.50, 50.00, 11, 8, 0, 1, 0, '0', 0, '0', 0, '0', 0, '0', 1, '750', NULL, NULL, NULL, '2025-04-04', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:17:07', '2024-07-31 06:24:20'),
(8, 2, 'lmZCltSJPctTgbpvOBwCq417FNmujCwFCdcK5F1x.jpg', 'Love Beauty and Planet', '[\"thlKK5DjwORYbFB0bK4rzSKbe2layqVIbl1dcgxN.jpg\",\"BsCXe6x1AOtBVyLuZdCFp7dtbBV2dXAMBAWJMVl6.jpg\",\"vZvNfApGNmtpetTdkuMYHJxCVNaP3LWd6VjU5hmm.jpg\",\"A1lF0hgmrcM5VY4jDOOwkXP3fzdUaYHRLOZRmjYJ.jpg\",\"ECEgyAfOiCC0x6CQmWOiL8MHaKU7PezCEImVvApk.jpg\",\"\"]', 320.00, 316.80, 1.00, 8, 5, 0, 0, 0, '0', 0, '0', 0, '0', 0, '0', 1, '900', NULL, NULL, NULL, '2028-12-22', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:19:52', '2024-07-31 06:27:30'),
(9, 2, 'kuudQth5tL89IISy9PAsNnEpNTkjelqS2XY4V7tV.jpg', 'Swiss Beauty Natural Makeup Fixer', '[\"vNvq9fI0Sc2cgO2kcKbVmht6TGBDCg2y6j4sfybm.jpg\",\"Gc0nzf1sdqW6NNlcXpEMF3VVy0dV2LJypjZABgqo.jpg\",\"8L1b6l06hxPwWTvlZ1CqlBHqj6I9hhOZL1oOf8Mq.jpg\",\"Fl27ltDEIQpeZBAy79UAqDafrVErfIBRSq8Nq7Sz.jpg\"]', 300.00, 270.00, 10.00, 2, 2, 1, 1, 0, '0', 0, '0', 0, '0', 0, '0', 1, '50', NULL, NULL, NULL, '2025-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:25:20', '2024-07-31 03:32:49'),
(10, 2, 'eKHSgQBBauyhLx1dOGtIUnHDTIuplqlp7d8rqlWy.jpg', 'ANCS Acupressure Wooden Roller', '[\"dqLskQABxxViqF6jBYXja8kMQocxcGCm9lYA06OK.jpg\",\"WVJV3ZVHtqRdGepU6Pstgg5matZN1ofx1ZajnRal.jpg\",\"GWnmcsPZRKdGrx4kzXUlRvPVWU2Dl9oh3jyLyERT.jpg\",\"\",\"\",\"\"]', 500.00, 450.00, 10.00, 4, 4, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2028-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:28:38', '2024-07-31 03:32:35'),
(11, 2, 'qrPbBn8OXeJZ6Swc7bxdwGqWnXhomWamE4o6Lg21.jpg', 'MyGlamm Super Khol Long Stay', '[\"\",\"\",\"\",\"\",\"\",\"\"]', 199.00, 199.00, 0.00, 2, 9, 1, 0, 0, '0', 0, '0', 0, '0', 0, '0', 1, '360', NULL, NULL, NULL, '2025-01-11', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:29:28', '2024-07-31 03:32:25'),
(12, 2, 'JSfsFhz7qNkQeWmbmyqCRIvH0aVX4OQKCzhMVdPY.jpg', 'Havells 4-In-1 Lady Body Groomer', '[\"XxQP34mbYKVdWeTaTZvmIsNpIBSRqVcxoZGnJ9AB.jpg\",\"HTI12gvpT3EzErdkyh4DTM6GgLO3eSOIsblkeGhj.jpg\",\"\",\"\",\"\",\"\"]', 2500.00, 2250.00, 10.00, 10, 6, 0, 0, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2024-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:31:55', '2024-07-31 03:32:06'),
(13, 2, '4q3nf4PSpcjCSbS26UjqYsh86dsK2fREf67C6lGr.jpg', 'LIT Liquid', '[\"\",\"\",\"\",\"\",\"\",\"\"]', 375.00, 337.50, 10.00, 2, 9, 1, 0, 0, '0', 0, '0', 0, '0', 0, '0', 1, '500', NULL, NULL, NULL, '2026-01-15', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:32:08', '2024-07-31 03:32:22'),
(14, 2, '5iUuSxxuBMbjFbUjyI6ERW8ZZzSwf8gxTywudpJM.jpg', 'Lixo Foot Massager – LI650', '[\"EX8ZEJWfZnDdBxxPefaRmaxHCNXNGRE48cfVxUxx.jpg\",\"q0RCs6YcXhY6xJJZoa483Qixv7qB5uUhggqemzcA.jpg\",\"YJ5gEHzz3C1EgCfYIETJH3BLsqB50CacKnNq6Aaw.jpg\",\"\",\"\",\"\"]', 30000.00, 24000.00, 20.00, 3, 3, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2029-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:46:18', '2024-07-31 03:46:26'),
(15, 2, 'g764JvSgRe44ewMxM4VKQElc2sjO3ZquOuCdU3R1.jpg', 'Popxo Makeup - Mini Lip Kit', '[\"\",\"\",\"\",\"\",\"\",\"\"]', 349.00, 331.55, 5.00, 2, 10, 1, 0, 0, '0', 0, '0', 0, '0', 0, '0', 1, '520', NULL, NULL, NULL, '2025-06-06', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:57:17', '2024-07-31 04:07:48'),
(16, 2, 'e13NM4ioB5QUgatH7LvFJUhzKrSouHkxZxyUqM4W.jpg', 'Lit Matte About It Lip Color Free sharpener', '[\"\",\"\",\"\",\"\",\"\",\"\"]', 100.00, 100.00, 0.00, 2, 10, 0, 1, 1, '20', 0, '0', 0, '0', 0, '0', 0, '0', NULL, NULL, NULL, '2022-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 03:59:11', '2024-07-31 04:07:44'),
(18, 2, 'GBks5oxv10CxxTTfXQZXE7MjgecJ0MjGb19FMZJA.jpg', 'MyGlamm Matte Rush Lipstick', '[\"\",\"\",\"\",\"\",\"\",\"\"]', 349.00, 345.51, 1.00, 2, 10, 0, 0, 1, '20', 0, '0', 0, '0', 0, '0', 0, '0', NULL, NULL, NULL, '2022-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 04:02:42', '2024-07-31 04:07:42'),
(19, 2, 'oBfTQ5aIEY6DrqCnCmbniiVBtNy6SegmvOc23xu5.jpg', 'VEDETIC® 5 PCS Hair Stylists Professional Styling Comb Set Variety Pack Great for All Hair Types', '[\"fJUjsyRNNb84M0QU9SwENOQwUi9brhcCHokiEzEq.jpg\",\"ilbsHTBvXWjKmPDe5NN4RX7xgMgOUfOk0SOmlBam.jpg\",\"Uu9jxKGWnAVSAoavNklyP5zUhFDtfItMXOAR8c9W.jpg\",\"gEooqgAwTX610ufRx3AtmSPrAnie1VLeC9LaoVyg.jpg\",\"n5ur4Hy8LMYcu90ebu8ZVXgpIuLYb0X8hKUX6PL1.jpg\",\"\"]', 300.00, 285.00, 5.00, 1, 1, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2028-12-31', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 04:04:07', '2024-07-31 04:07:42'),
(20, 2, 'j6qYjG8OYuZBNNDtC15bDOOMAAP9ajNCBZFKV0F6.jpg', 'Nova NHT 1073 Battery Powered USB Rechargeable and Cordless: 60 Minutes Runtime Professional Hair Clipper for Men, Blue', '[\"ZZLMu2E91De10FCXuuKWC22boGUQyF1zBXzXOdff.jpg\",\"flJLBZJCLL2m2YiQgaSR99Gyl9Z9ghp3B4oxnxbh.jpg\",\"Ep6OoiR3qwlFgpe8KDm1TDP0E5YHzf1D4GWhQpvV.jpg\",\"bwSJbYyd4dgHqcO4HvDn4AIZqGGfxzzmfnQ3UWxR.jpg\"]', 1000.00, 750.00, 25.00, 1, 1, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2028-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 04:07:32', '2024-07-31 04:07:42'),
(21, 2, 'm2LafTCWbASUSrOrQOkgDLRCmHFh8lln96nUEYsa.jpg', 'MAYCREATE® Professional Hair Cutting Scissors Kits Stainless Steel Scissors Hair Dressing Scissors Barber Kit Straight Shears Teeth Scissors Thinning Shears Tools with Bag for Home, Salon', '[\"xgEJYS50YBFql3SqDuNnepAG1aHx6t5j3wtheCAA.jpg\",\"ZfbOSK9y6O9UawKI1kw6zcPjEpw0GONUrE3jY4Yl.jpg\",\"MwsfTtpN6fgki8GzsPwOYAxMIv7FRvUBb53AzEa8.jpg\",\"\",\"\",\"\"]', 2399.00, 1631.32, 32.00, 1, 1, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2028-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 04:10:53', '2024-07-31 04:11:27'),
(22, 2, 'PLF5VFwdHXdRYjEXYQsTEziWlDSyIYPa7ywejwGN.jpg', 'Rubz Olive Hair Spa Cream | With the Goodness of Olive Extract |', '[\"7nZWjvBdKopPS5MIj0UCMbs5VukvZcfRYISbYVB9.jpg\",\"BMkW5n0bGVALCLGjwNfd85FNnehbXRJvyRrb2OCZ.jpg\",\"\",\"\",\"\",\"\"]', 699.00, 524.25, 25.00, 3, 3, 1, 1, 0, '0', 1, '1', 0, '0', 0, '0', 0, '0', NULL, NULL, NULL, '2025-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 04:15:35', '2024-07-31 04:16:59'),
(23, 2, '6t1eoL50pSVgIwwxk35wnLvZx8Z6JfRjRo5vQs7C.jpg', 'At-Home Hair Removal for Women & Men', '[\"2uNhmWLhOYrDomgw6SV6eQLOMCyytnOrB3BTHUs9.jpg\",\"tfMg6ZuTDlfOo1vVHrJANzMoQaEXQ3uUDjSmZAGb.jpg\",\"t75BS98m7qkyrdwwoyDENR1zhhS00yUozQcPLkBA.jpg\",\"r6Wd9w3Mx6C9ixrhSGiZc2b77ypGWlD2Tu8Bt8aY.jpg\",\"\",\"\"]', 10000.00, 8000.00, 20.00, 11, 8, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2026-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 04:31:24', '2024-07-31 04:31:32'),
(24, 2, 'fSKKNPE7WYPj5nLrKBYTdX39J1XODzUQ090pWKXD.png', 'Pigmentation & Blemishes Kit', '[\"D6ZLK6Dae3uzx860QobN4ZpppNvEyPC21kvruHgh.jpg\",\"6wpCV7fWRhaTXM0i1UxJcDkLxBRkV6MuYeGH07Vf.png\",\"\",\"\",\"\",\"\"]', 2000.00, 1560.00, 22.00, 3, 3, 0, 0, 1, '120', 0, '0', 0, '0', 0, '0', 0, '0', NULL, NULL, NULL, '2028-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 04:36:46', '2024-07-31 04:36:53'),
(25, 2, '2AM7jbJTJhYuzWYRKjydWII14887vTka1D94EKMk.jpg', 'Foot Spa Bath Massager I Heating & Vibration & Bubble 3 in 1', '[\"H1rrd43vFn744JTntx4piW2Yq3lW6t4kgQmUsbxC.jpg\",\"OKQ7cLZS5wG91oj7SBtHI2x14xJ88WCXFOd4RRvE.jpg\",\"XUsaRn466LI8mTMcJ8rlnmBrcsFgLW0p8QrNzyPR.jpg\",\"\",\"\",\"\"]', 8000.00, 6080.00, 24.00, 3, 3, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2028-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 04:55:06', '2024-07-31 04:55:13'),
(26, 2, 'CKbWdMSgA3LwXtwKwK7XWnGZFy0Jau3H0tCjJgKS.jpg', 'Electric Pressotherapy Air Compression Leg Foot Massager with Vibration & Infrared Therapy I Pneumatic Air Wave Pressure Machine', '[\"1CTCmtrkUqMytgjMGB6QIJ5QnpZSH6FQu7q2Sr6M.jpg\",\"OnYKfO2bMyXecyR2jVGCRKe8wR8xJqrSjYhB4BAD.jpg\",\"YBnJajdlABdVxErzld9nK8WZjB8CAjKdRcimS4xx.jpg\",\"p2vrNhrJVNe6yb45EEWvakyHoPZocclGf60QmHES.jpg\",\"\",\"\"]', 36000.00, 18000.00, 50.00, 3, 3, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2034-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 04:58:26', '2024-07-31 04:58:32'),
(27, 2, 'CB3A9GYuhatTWTJT8fPbCtTRJWKKE3C0s9vNfYYN.jpg', 'Ayurvedic Kansa Vatki Foot Massager – VT’s Padabhyanga Machine for Foot Massage (KT09) – Dotted, Round & Plain Vatki', '[\"92qWOkNh3thYD6C61LZVW1tDBFufsqFYzkv3q6Sj.jpg\",\"H0fwpLBCpKicYJl5dlGuvR4zIM8Oufg41wlvYrnw.jpg\",\"IGnfCwJ7mwuwUxnGD0oMFUX1xP9Qjk7d48ZNHxy2.jpg\",\"\",\"\",\"\"]', 5300.00, 4028.00, 24.00, 4, 4, 1, 1, 0, '0', 0, '0', 1, '1+1', 0, '0', 0, '0', NULL, NULL, NULL, '2028-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 05:05:11', '2024-07-31 05:05:16'),
(28, 2, 'z0vo6vn3zqBYybsEujDDiEwKtsml00nr1dnLxwO8.jpg', 'Core Asana Acupressure Mat Massager for Foot, Back, Neck and Joint Pain Relief, Reduce Stress & Tension with Pillow, Reflexology Accupressure Set', '[\"2StncFWPAZ83Jy7yXGgWirI3Sy2Rk1Y0S6uSuWbu.jpg\",\"AYtR9olGLnYQmKSspr3LKclbSeRELl7aXovOdRbN.jpg\",\"fRg4zRZxybBgZ72AJ8flmleJlaYRfGBTIKDrQyU8.jpg\",\"25lHxYv3NLrZDzlPyZtqGKWAa3uP0aY4uAe8gZJv.jpg\",\"3GkGmeoGG75kdgl2lpxvYY7UdyKObHRSg0mhbgMq.jpg\",\"\"]', 3900.00, 2964.00, 24.00, 4, 4, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2026-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 05:08:57', '2024-07-31 05:09:05'),
(29, 2, 'wFLDtxfHqunpdmMSdInxmPMQ129g7CwQMqx1AszM.jpg', 'Forest Fury Polarized Wayfarer Sunglasses', '[\"LEKg6xHNm8saeIK6gi1Ontflk4EnEEjvCzN8iaz2.jpg\",\"q9gqpWbkaPIZrN4PQp1NWk1jNQYQOspFgFD2gwV0.jpg\",\"i3GppaVOKi4QzJxk1LbyUUXE43k5UVHiLYI4pLj1.jpg\",\"2jYaNPO8YJrl8ZwK6R7S7bliqCMLYEeoV8mDHHeT.jpg\",\"\",\"\"]', 1687.00, 759.15, 55.00, 8, 5, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2028-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 05:21:20', '2024-07-31 05:21:27'),
(30, 2, '4vqnsA61lRIBHlgJNGmNGM9riY8TzE30rE6M8wRH.jpg', 'CUVLY® Waxing Kit Combo Wax Machine (Wax Heater + White Chocolate Cream Wax (600 gm) + Chocolate Wax (600 gm) + Wax Strips (70) + Wax Spatula + Sponge) | WAX COMBO (WHITE CHOCOLATE AND CHOCOLATE WAX)', '[\"IJujAFGUptYdUPfjltpuGx4esUtofI4ZxFPtJ8q9.jpg\",\"C0h0lHyDjWzx28OB9uiW6JvWm4Y0k4GYVK1lZDRs.jpg\",\"\",\"\",\"\",\"\"]', 1000.00, 500.00, 50.00, 6, 13, 1, 1, 1, '600+600', 0, '0', 0, '0', 0, '0', 0, '0', NULL, NULL, NULL, '2028-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 06:08:15', '2024-07-31 06:10:38'),
(31, 2, 'uylIPscVK4ugGXvv3R74RTnx0ZvoEz6B6XbZoqiR.jpg', 'Hair Removal Spray for Fast & Painless Hair Removal, 200gm', '[\"5hKPpgPlL7CYyE4cL8H0jvdzRkJhxjY7yK8FXCum.jpg\",\"CLEMa9ACkRyLLUQOViVL3RTlnhCVH9qbrTsOcPpJ.jpg\",\"Mu0CIifl4LY63FG8GIyjrYCpx5BFWeEHOlEGagpG.jpg\",\"\",\"\",\"\"]', 850.00, 680.00, 20.00, 6, 14, 1, 1, 1, '200', 0, '0', 0, '0', 0, '0', 0, '0', NULL, NULL, NULL, '2027-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 06:11:56', '2024-07-31 06:12:36'),
(32, 2, 'ydtsBfH414ljZYSU5s4CfM0hlyJxS2rhZhPCuISX.jpg', 'KREQU Wax Roller Waxing Kit on Wax Hair Removal | All Skin Types | Wax Kit Wax Heater machine Wax Refill Cartridge Wax Strips Waxing kit for Women Wax | Wax Roller Heater', '[\"hJ0FaKb1PO5RtRhNVgPQPRVHYXEzMIkbrmjKv9jg.jpg\",\"f0SoCHQzcvGlS1OyqAsrMq2EAFad5z89ZaAicSJv.jpg\",\"AB14p4pmnKNMYpxwRs6ckbfSWY7LgUAe5U48aljE.jpg\",\"B9GjdtBU4VMuAsb0MaFBlYM2DVFGQPiPbO1eFrg3.jpg\",\"\",\"\"]', 900.00, 504.00, 44.00, 6, 13, 1, 1, 1, '100', 0, '0', 0, '0', 0, '0', 0, '0', NULL, NULL, NULL, '2027-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 06:18:29', '2024-07-31 06:18:37'),
(33, 2, '7UCvweSAi3zKbiaW2ro7UhOU9OdkJbZxgKHX1ftN.jpg', 'Sacvic Waxing Kit Combo For Women(Wax Heater+Chocolate Wax(550 Gm)+Alovera Wax(550 Gm)+Strips(70)+Wax Spatula+Sponge(6 Items In Tha Set)', '[\"OaKCJGAuXmKzyasJtHW5VoAIOSuYna7en1YgjUu0.jpg\",\"zfgPqQyCk9RcCXGkfCa6qodtcy4k1L8mX1MRrb4l.jpg\",\"IU8Fr2izSBPnWuxYQKG0TQf5Y57TnTTqQ0xJyEYT.jpg\",\"Z3psKD0HOujQKwfh0LmtIFj5MfAxGhrhsXsWc7yj.jpg\",\"pU976Y6sWRrdCyaEyhBMG4N45AZ6XveTHjPoSzMo.jpg\",\"\"]', 899.00, 719.20, 20.00, 6, 13, 1, 1, 1, '550+550+70', 0, '0', 0, '0', 0, '0', 0, '0', NULL, NULL, NULL, '2025-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-07-31 06:24:02', '2024-07-31 06:31:21'),
(35, 2, '5bUJ3iiHQkpJ8Y4Z1xHK45JRQpaDTnUkaddIJO2X.jpg', 'Manish Malhotra Beauty Lip Liner & Filler - Cabernet Kiss', '[\"WA2xXsm3mqCwYJDbsZldKLAjSvTIKtiz7t4aqTTK.png\",\"vvTw053xZfD8pwAIlI6rG76H3quWBQugwlZ0id9v.jpg\",\"2bNJS2esp9aVE9Jb0fLJWA6JFVcghBL1EqoO93a9.jpg\",\"4mH0DY5uUQxj79b19ehH55g04eAaFCuGm3dY539F.jpg\",\"Np3F1D0hO9gGPvSKIMSc2wAYmmb9aLw2NkG8zWAS.jpg\",\"\"]', 799.00, 479.40, 40.00, 2, 2, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2025-12-25', 0, 0, 0.00, 0, 1, NULL, '2024-08-01 03:40:01', '2024-08-01 03:40:10'),
(36, 2, '0kF7FOkXpR2wEi1HInSJC8i0kkIrsh64wKYKOKno.jpg', 'Insight CosmeticsPro Concealer Palette - Corrector(15gm)', '[\"gtlOeuKY8eRV4LAyhE5aeLZHzhZox5LAlRLKKjUB.jpg\",\"EgQyTKxnyjlq7g9gEpt0Qr0HQmsHT4rbD6B8BPzM.jpg\",\"Z6N0Ud7qRTE6oFNTpacha9kTja9D802PuwOpGtR1.jpg\",\"wOzovoJ35WwG1TlruV8If4x98AuRMtO4LhT49vVn.jpg\",\"sutEjMDYp1F8FnGmSdjVxZa9AO8i6G4opta5mZqK.jpg\",\"TNyE5n3tpZkWXV1oPoZERcNkSyfYTUNhYxePX7M0.jpg\"]', 300.00, 285.00, 5.00, 2, 9, 1, 1, 1, '15', 0, '0', 0, '0', 0, '0', 0, '0', NULL, NULL, NULL, '2025-12-31', 0, 0, 0.00, 0, 1, NULL, '2024-08-01 03:43:54', '2024-08-01 03:44:10'),
(37, 2, 'Tr4x4sGBndEI2qUmMl0amxVbhWCivOii92fdkbUn.jpg', 'Blueberry Bathsalt', '[\"u7ibu7Zyf3l7FNsM1GNnRIrSxwHfj5niynrCCkXg.jpg\",\"NpDrIh6F7Gty7ecoELF4QdlPDoVcA4MFazFRLkOr.jpg\",\"zxNdf9x5lJ4n1WYLr0vays925gNhaIJt9CddpFLY.jpg\",\"\",\"\",\"\"]', 400.00, 376.00, 6.00, 3, 11, 1, 1, 1, '100', 0, '0', 0, '0', 0, '0', 0, '0', NULL, NULL, NULL, '2030-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-08-01 03:47:28', '2024-08-01 03:53:46'),
(38, 2, 'JzvAQpQEsAcCBumIokl4K3sPh2CJqd7hJVmScbnH.jpg', 'Lavender Body Scrub', '[\"gUvcVlDPggxAGGi3wS5UKtdw7JX7ehc1BLQ20VU2.jpg\",\"5ONnx53YmS0shv2J1FTEIIu53o1NFPa0VO8SnVzC.jpg\",\"MuSxUXFepMYrBK1NJKbkyVSIuTDs9mhLkrXwWUZb.jpg\",\"\",\"\",\"\"]', 1000.00, 850.00, 15.00, 3, 11, 1, 1, 1, '200', 0, '0', 0, '0', 0, '0', 0, '0', NULL, NULL, NULL, '2030-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-08-01 03:49:25', '2024-08-01 03:53:46'),
(39, 2, 'c5gaCyLTLVgYvju6yLPKtHFp3xIl5Kx3LIVMHfs1.jpg', 'Acne Face Wash', '[\"\",\"\",\"\",\"\",\"\",\"\"]', 250.00, 225.00, 10.00, 3, 11, 1, 1, 0, '0', 0, '0', 0, '0', 0, '0', 1, '60', NULL, NULL, NULL, '2026-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-08-01 03:53:41', '2024-08-01 03:53:45'),
(40, 2, 'pahOTzQggGGhnAT14UxpyRUUYgpUMaIYyQbOa7sl.jpg', 'Sirona Talc Free Hair Removal Cream For Dry & Sensitive Skin | Enriched With Shea Butter, Aloe Vera & Vitamin E, Hair Removal Cream For Bikini Li', '[\"trqvuCHVMuiCUtLUrjcJYiCGBDEvJPSup0mLuqJt.jpg\",\"3rwlApvzEOQ7rBWFHNRu790CYuic4GYdw9DcTClL.jpg\",\"xB1fdj0a4kozjUiA91MoZszFFgeEsKGX1kmE4inz.jpg\",\"\",\"\",\"\"]', 450.00, 405.00, 10.00, 6, 14, 1, 1, 1, '80', 0, '0', 0, '0', 0, '0', 0, '0', NULL, NULL, NULL, '2025-12-31', 0, 0, 0.00, 0, 1, NULL, '2024-08-01 04:03:09', '2024-08-01 04:06:34'),
(41, 2, 'CJO5pZuwXVJNNK6JvX1UPM32F8H6x56osPibttzz.jpg', 'Urbangabru Hygiene Expert', '[\"idBBjfvF46gSVEo4Odx5RKQnRKcwiJ4kFsnqKXvW.jpg\",\"yAidkMweVaQOWVWkcCbSOcziOt3esE2qGQwEX6WD.jpg\",\"p0A5mDkgh7WeHFQECjpcLPC8n2RWt8I4bJuyQoYX.jpg\",\"qRHRfzh9ykqEgbH2uGaQKDVnkHa4tiHvLY48s1K8.jpg\",\"\",\"\"]', 1200.00, 660.00, 45.00, 6, 14, 0, 0, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2025-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-08-01 04:05:58', '2024-08-01 04:06:28'),
(42, 2, 'GggS0bwYw6pKkX9igAFqhJ1ms7EuDH3Q3AItT1RS.jpg', 'Oversized Vintage Punk Goggle Women Round Eyewear – Brown', '[\"s5uHMBydmcITBKWT08HJc6mzzwsOD0z3Jl1noBKC.jpg\",\"8HmeoSwi5A7US38KYkrGxha3qc7G6j7oc3oltOYH.jpg\",\"gzOsc9WJZi041q50y0GJ8d1EFiKcWxFul2apyewM.jpg\",\"\",\"\",\"\"]', 5000.00, 4500.00, 10.00, 8, 5, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2026-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-08-01 04:11:51', '2024-08-01 04:12:11'),
(43, 2, 'N3YJaN9CFUBpJ4g9pkXzxiFDZfGejc2JCbaeuIZg.jpg', 'Eyebrow Stamp Stencil Kit, Eyebrow Stencils with 3 Pc, Eyebrow Brown Definer, Eyebrow Pencil, Brow Stencils and Shaping Kit Reusable (Black)', '[\"Wnt4dt1PHISydbnxVTs2X25pbThyWOvbvjKQ04Xt.jpg\",\"Z1DtbFPbRj23nhefGZedtmxtBU0GQsFD8tfK1aXD.jpg\",\"ZW5jPcNADIrKDj6uaOPkNqGFQjMOq9znuzvqrfcM.jpg\",\"\",\"\",\"\"]', 200.00, 120.00, 40.00, 10, 6, 1, 1, 0, '0', 0, '0', 1, '3', 0, '0', 0, '0', NULL, NULL, NULL, '2027-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-08-01 06:19:02', '2024-08-01 06:21:14'),
(44, 2, '8QBeT9fzNgesU970Nz9Yh3Pf5Fj0WGXh59GvUW5J.jpg', '3-IN-1 EYEBROW PALETTE', '[\"11uzGIku1hdWmPEHfBLyBtH9OF54luBS2iH4rzjL.jpg\",\"W47SFTT6oSlbx6UX9KwcX7cwRg2axclXgzs7HiyK.jpg\",\"JHNGx3K04ePdB7kIjrZU7pjhfTNsOqStVllXgsYZ.jpg\",\"\",\"\",\"\"]', 400.00, 340.00, 15.00, 10, 6, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2025-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-08-01 06:31:02', '2024-08-01 06:31:21'),
(45, 2, 'Xb6tuh7EB4UJ0X9UotB5SZMgzEL1s9NJRSmd7HWF.jpg', 'Beeswax Ear Candles', '[\"KGMdSZzKJMVYVzC56sgXECbia1HVtEnQkmjKUmKi.png\",\"CTkV8QTL9zhxrDugyr04et4CWZnlr8HKFtfvPuEj.png\",\"CCpyg4uFLxs4k1LwYuPge801DNH9XMl3aOTIzZdH.jpg\",\"fv8meRQjra2dG2uGfKxJZkArwwtSZxS2b8AVKFGp.jpg\",\"\",\"\"]', 1000.00, 800.00, 20.00, 12, 7, 1, 1, 0, '0', 0, '0', 1, '2', 0, '0', 0, '0', NULL, NULL, NULL, '2025-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-08-01 06:35:42', '2024-08-01 06:39:59'),
(46, 2, 'M0UFB6HGaE6mSM2Rz9abUjkZ7P1sxVROrUXgdGla.png', 'Ear Candling Course Kit', '[\"l4QyXXTehWxgIkmkt8TvZcwGJfwXn2O55f6GYnCQ.jpg\",\"\",\"\",\"\",\"\",\"\"]', 15000.00, 12000.00, 20.00, 12, 7, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2027-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-08-01 06:37:24', '2024-08-01 06:39:56'),
(47, 2, 'lm2WMy9dyHdIrkHQNlCOl2TEUKqn8ULWpn0vGzRc.png', 'Ear Candling Scissors', '[\"HhaMQvcfOY3AZuCQzk2wt6vcOSU7XfmHefl08B0O.png\",\"DsfEY4VPjvrZeUVEsoJEUspDin42QyOCYgQO2eIc.png\",\"\",\"\",\"\",\"\"]', 1500.00, 1200.00, 20.00, 12, 7, 0, 0, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2025-12-24', 0, 0, 0.00, 0, 1, NULL, '2024-08-01 06:39:48', '2024-08-01 06:39:58'),
(48, 2, 'NYiCNjanR28K0gATOm79Oar1ASamb4qLkBOfZ0Jr.jpg', '9 Level Lcd Laser Plasma Pen for Face Skin Beauty, Dark Spot Remover Mole Tattoo Removal Machine Facial Freckle Tag Wart Removal Beauty Tool [multi colour]', '[\"Mbc7ZFZQwC31MVSstKCnUCBv7MSr0fZPzuu2CdhP.jpg\"]', 1000.00, 850.00, 15.00, 11, 8, 1, 1, 0, '0', 0, '0', 1, '1', 0, '0', 0, '0', NULL, NULL, NULL, '2025-12-24', 0, 0, 0.00, 0, 0, NULL, '2024-08-01 06:47:14', '2024-08-01 06:47:14');

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

--
-- Table structure for table `products_orders`
--

CREATE TABLE `products_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `freelancer_id` int(11) NOT NULL DEFAULT 0,
  `salon_id` int(11) NOT NULL DEFAULT 0,
  `date_time` datetime NOT NULL,
  `paid_method` varchar(255) NOT NULL,
  `order_to` varchar(255) NOT NULL,
  `orders` text NOT NULL,
  `notes` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `total` double(10,2) DEFAULT NULL,
  `tax` double(10,2) DEFAULT NULL,
  `grand_total` double(10,2) DEFAULT NULL,
  `discount` double(10,2) DEFAULT NULL,
  `driver_id` varchar(255) DEFAULT NULL,
  `delivery_charge` double(10,2) DEFAULT NULL,
  `wallet_used` tinyint(4) NOT NULL DEFAULT 0,
  `wallet_price` double(10,2) DEFAULT NULL,
  `coupon_code` text DEFAULT NULL,
  `extra` text DEFAULT NULL,
  `pay_key` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `payStatus` tinyint(4) NOT NULL DEFAULT 0,
  `extra_field` text 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 `product_categories`
--

CREATE TABLE `product_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `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 `product_categories`
--

INSERT INTO `product_categories` (`id`, `name`, `cover`, `extra_field`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Haircuts', 'AcIXb3gjCstqTJY1xc5pa3E1d9S5NQAlRTwGRaMN.jpg', NULL, 1, '2024-07-26 04:17:11', '2024-07-26 04:17:11'),
(2, 'Makeup', 'xDQfJMuO39wR8jiQSSTtvKx6LDyiy1qgPtmJmEYM.jpg', NULL, 1, '2024-07-26 04:18:54', '2024-07-26 04:18:54'),
(3, 'Spa Packages', 'PZgiTHo6bMHg0eHiZ53jdoh9A93hUrU2hy1QEm9k.jpg', NULL, 1, '2024-07-26 04:19:44', '2024-07-26 04:19:44'),
(4, 'Wellness Services', '6AYKaIQqhlRpso5gzOt9MrI1LjjqzLFqSBoxwzQZ.jpg', NULL, 1, '2024-07-26 04:24:25', '2024-07-26 04:24:25'),
(6, 'Waxing & Hair Removal', 'NlLx5mOjFRpjlOdjqfmYwrLTVTU3RReRqEdMxnow.jpg', NULL, 1, '2024-07-26 04:25:51', '2024-07-26 04:25:51'),
(7, 'Microdermabrasion', 'bYzqCiVQ9prWSwJFicd49utngzfdLD8GdsusEUUk.jpg', NULL, 0, '2024-07-26 04:26:34', '2024-08-01 03:56:10'),
(8, 'Retail Shop', '71qCH4IafVjQIe0FE53cWIfwtpLu8mXD46kvUBBi.jpg', NULL, 1, '2024-07-26 04:31:39', '2024-07-26 04:31:39'),
(9, 'Fitness and Yoga', 'pKwmZn2umoiaidygqAqEp2oTg8MQ7lfTzDdjJZfu.jpg', NULL, 0, '2024-07-26 04:32:08', '2024-08-01 03:57:20'),
(10, 'Eyebrow and Eyelash Services', 'q7QqBCD5wVgE6lvdrWEzpCsdKjf2AkwOnu1S9sUV.jpg', NULL, 1, '2024-07-26 04:32:46', '2024-07-26 04:32:46'),
(11, 'Medical Spa Services', '2csyYKVA9oHgpiYwDm227ci4xagIwnuSUOc1xy8P.jpg', NULL, 1, '2024-07-26 04:33:34', '2024-07-26 04:33:34'),
(12, 'Specialty Treatments', 'dVMAdveggnY2FOQmIcvldIrr7DqzEMuLqgBHFzFj.jpg', NULL, 1, '2024-07-26 04:34:08', '2024-07-26 04:34:08');

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

--
-- Table structure for table `product_reviews`
--

CREATE TABLE `product_reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `product_id` varchar(255) NOT NULL,
  `notes` text DEFAULT NULL,
  `rating` double(10,2) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `extra_field` text 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 `product_sub_category`
--

CREATE TABLE `product_sub_category` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `cover` varchar(255) NOT NULL,
  `cate_id` int(11) NOT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT 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 `product_sub_category`
--

INSERT INTO `product_sub_category` (`id`, `name`, `cover`, `cate_id`, `extra_field`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Styling', 'OT1T4HAzjo2oASFRETkAET7nJWpjjnhDsjNSiP06.jpg', 1, NULL, 1, '2024-07-26 04:21:30', '2024-07-26 04:21:30'),
(2, 'Bridal Makeup', 'L4naScfAK8xzRjmGrRpKlq58gqgAVrLIPpQmpJaO.jpg', 2, NULL, 1, '2024-07-26 04:22:08', '2024-07-26 04:22:08'),
(3, 'Body Massage', 'FHhLIM2FvCA7sddfocThVBukVzf6ksyPRJtpXL85.jpg', 3, NULL, 1, '2024-07-26 04:22:39', '2024-07-26 04:22:39'),
(4, 'Acupuncture', '5bYdujNn3DzLgEYZcN6P2Giwos8yUwTMiicZARov.jpg', 4, NULL, 1, '2024-07-26 04:35:24', '2024-07-26 04:35:24'),
(5, 'Fashion and Accessories', 'D6UdL6vUv9LDjYyp5ybOYOrJ4qsxelaBphQR7nKd.jpg', 8, NULL, 1, '2024-07-26 04:36:51', '2024-07-31 05:17:36'),
(6, 'Eyebrow Shaping', 'zKpe62nmUMg1Uy9aN383fjd8HwiFCdIvfhrv4ucs.jpg', 10, NULL, 1, '2024-07-26 04:37:54', '2024-07-26 04:37:54'),
(7, 'Ear Candling', 'fZj2bTxIoLTMkgv7Hxpx8Voq8p4cL42xjtrVkujl.jpg', 12, NULL, 1, '2024-07-26 04:39:54', '2024-07-26 04:39:54'),
(8, 'Laser Skin Resurfacing', 'pCbesx4lJchUXTWs8LcTpNNCc8Zf2dun9mN4cP00.jpg', 11, NULL, 1, '2024-07-26 04:40:35', '2024-07-26 04:40:35'),
(9, 'Eye Makeup', '6WOm3v7jVhmRMQ5Z9TXSwOZ3q8C719hHA9gL8Y4L.jpg', 2, NULL, 1, '2024-07-31 03:27:29', '2024-07-31 03:27:29'),
(10, 'Matte Makeup', 'I9ezJr7maTtV5fkOC2NZUdAq0CKwmgimEtRTXQZ5.webp', 2, NULL, 1, '2024-07-31 03:27:46', '2024-07-31 03:27:46'),
(11, 'Beauty', 'XjflEPfHcv08WQccZQ37iRXHrIfUQYiVi6FC4YH8.webp', 3, NULL, 1, '2024-07-31 05:10:06', '2024-07-31 05:10:06'),
(12, 'Body Treats', 'A3MAgQstefazcyHhmiSAQza15RXESGZoekf9SKiG.webp', 3, NULL, 0, '2024-07-31 05:10:42', '2024-08-01 03:59:14'),
(13, 'Waxing Products', 'PK4O2UfXWecy34tMwDOoqw9QjlB8w17uw7sfJT31.jpg', 6, NULL, 1, '2024-07-31 05:31:25', '2024-07-31 05:31:25'),
(14, 'Hair Removal Devices', 'DKeg3afbCJxa5CQm3jNWo6yDX3rRbZ6zXwBExr4l.jpg', 6, NULL, 1, '2024-07-31 06:04:56', '2024-07-31 06:04:56');

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

--
-- Table structure for table `redeem`
--

CREATE TABLE `redeem` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `owner` int(11) NOT NULL,
  `redeemer` int(11) NOT NULL,
  `code` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `extra_field` text 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 `referral`
--

CREATE TABLE `referral` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `amount` double(10,2) NOT NULL,
  `title` text NOT NULL,
  `message` text NOT NULL,
  `limit` int(11) NOT NULL,
  `who_received` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `extra_field` text 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 `referral`
--

INSERT INTO `referral` (`id`, `amount`, `title`, `message`, `limit`, `who_received`, `status`, `extra_field`, `created_at`, `updated_at`) VALUES
(1, 500.00, 'New Users', 'Grand Offer for new commers', 3, 3, 1, NULL, '2024-07-26 04:18:50', '2024-07-26 04:18:50');

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

--
-- Table structure for table `referralcodes`
--

CREATE TABLE `referralcodes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `code` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `extra_field` text 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 `referralcodes`
--

INSERT INTO `referralcodes` (`id`, `uid`, `code`, `status`, `extra_field`, `created_at`, `updated_at`) VALUES
(1, 8, 'BJEVUJUC8EPI9', 0, NULL, '2024-07-26 04:13:43', '2024-07-26 04:13:43');

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

--
-- Table structure for table `salon`
--

CREATE TABLE `salon` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `cover` varchar(255) NOT NULL,
  `categories` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `lat` varchar(255) DEFAULT NULL,
  `lng` varchar(255) DEFAULT NULL,
  `cid` varchar(255) DEFAULT NULL,
  `about` text DEFAULT NULL,
  `rating` double(10,2) NOT NULL DEFAULT 0.00,
  `total_rating` int(11) NOT NULL,
  `website` text DEFAULT NULL,
  `timing` text DEFAULT NULL,
  `images` text DEFAULT NULL,
  `zipcode` text DEFAULT NULL,
  `service_at_home` tinyint(4) NOT NULL DEFAULT 1,
  `verified` tinyint(4) NOT NULL DEFAULT 1,
  `in_home` tinyint(4) NOT NULL DEFAULT 1,
  `popular` tinyint(4) NOT NULL DEFAULT 1,
  `have_shop` tinyint(4) NOT NULL DEFAULT 1,
  `have_stylist` tinyint(4) NOT NULL DEFAULT 1,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `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 `salon`
--

INSERT INTO `salon` (`id`, `uid`, `name`, `cover`, `categories`, `address`, `lat`, `lng`, `cid`, `about`, `rating`, `total_rating`, `website`, `timing`, `images`, `zipcode`, `service_at_home`, `verified`, `in_home`, `popular`, `have_shop`, `have_stylist`, `extra_field`, `status`, `created_at`, `updated_at`) VALUES
(1, 3, 'Stylish', '9D9JQfZAgWLl2dLtGmXc6spCQuaZ20jLwsEmbZhh.jpg', '2,4', 'Fake Town, New City', '56.569742', '63.214569', '3', 'This is best stylist salon', 0.00, 0, 'NA', 'NA', 'NA', '245621', 0, 1, 1, 1, 0, 1, 'NA', 1, '2024-07-26 03:58:18', '2024-07-26 04:01:07'),
(2, 5, 'Glamour Grove', '0qvchSHFTM4pWdpff9dLmoKSKEmLKpVWiZl3nVqS.jpg', '1,2,4,5,3', 'Fake Town, New City', '12.264597', '65.546974', '2', 'Enter Glamour Grove, where every visit is a journey into glamour and style. Our chic salon is dedicated to delivering cutting-edge hair and beauty services that leave you feeling fabulous. From contemporary cuts to exquisite color treatments, our stylists are masters of their craft. We use the latest techniques and high-quality products to ensure you always look your best. Discover your glamorous side at Glamour Grove – your haven for sophisticated beauty.', 0.00, 0, 'NA', 'NA', 'NA', '65941', 0, 1, 1, 1, 1, 1, 'NA', 1, '2024-07-26 04:00:59', '2024-07-26 04:01:12'),
(3, 6, 'Luxe Locks Salon', 'mcpgs5pZNmbsyj4la1cToKQRfspI8h9plSLlK1SJ.jpg', '3,1', 'New Town, New City.', '45.4569852', '32.65498', '2', 'At Radiant Reflections, we believe that beauty starts from within. Our salon offers a serene environment where you can unwind and rejuvenate while receiving exceptional hair and beauty services. Our talented team specializes in creating personalized styles that enhance your natural beauty. Experience the radiance of healthy, shiny hair and glowing skin with our premium treatments. Join us at Radiant Reflections and reflect your inner beauty outward.', 0.00, 0, 'NA', 'NA', 'NA', '659841', 0, 1, 1, 1, 1, 1, 'NA', 1, '2024-07-26 04:02:56', '2024-07-26 04:04:09'),
(4, 7, 'Serene Style Studio', 'y30OLYlg7NEvLwJm8H5FmAX9ibTGsFz0MoKQrBB9.jpg', '3,5,4', 'New Town, New City.', '41.654123697', '56.3215698', '5', 'Serene Style Studio is your escape from the hustle and bustle of everyday life. Our tranquil salon offers a peaceful ambiance where you can relax and enjoy our comprehensive range of hair and beauty services. Whether you need a simple trim or a complete makeover, our skilled professionals are here to cater to your needs. Embrace serenity and style with our customized treatments designed to enhance your natural allure. Visit Serene Style Studio for a truly calming beauty experience.', 0.00, 0, 'NA', 'NA', 'NA', '9845', 0, 1, 1, 0, 1, 1, 'NA', 1, '2024-07-26 04:04:42', '2024-07-26 04:04:42');

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

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

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `cate_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `duration` double(10,2) DEFAULT NULL,
  `price` double(10,2) DEFAULT NULL,
  `off` int(11) NOT NULL,
  `discount` double(10,2) DEFAULT NULL,
  `descriptions` text DEFAULT NULL,
  `images` text DEFAULT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `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 `service_reviews`
--

CREATE TABLE `service_reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `freelancer_id` int(11) NOT NULL,
  `notes` text DEFAULT NULL,
  `rating` double(10,2) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `extra_field` text 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 `specialist`
--

CREATE TABLE `specialist` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `salon_uid` int(11) NOT NULL,
  `cate_id` text NOT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `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 `timeslots`
--

CREATE TABLE `timeslots` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `week_id` int(11) NOT NULL,
  `slots` text DEFAULT NULL,
  `extra_field` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `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 `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `payable_type` varchar(255) NOT NULL,
  `payable_id` bigint(20) UNSIGNED NOT NULL,
  `wallet_id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('deposit','withdraw') NOT NULL,
  `amount` decimal(64,0) NOT NULL,
  `confirmed` tinyint(1) NOT NULL,
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`meta`)),
  `uuid` char(36) NOT 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 `transfers`
--

CREATE TABLE `transfers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `from_type` varchar(255) NOT NULL,
  `from_id` bigint(20) UNSIGNED NOT NULL,
  `to_type` varchar(255) NOT NULL,
  `to_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('exchange','transfer','paid','refund','gift') NOT NULL DEFAULT 'transfer',
  `status_last` enum('exchange','transfer','paid','refund','gift') DEFAULT NULL,
  `deposit_id` bigint(20) UNSIGNED NOT NULL,
  `withdraw_id` bigint(20) UNSIGNED NOT NULL,
  `discount` decimal(64,0) NOT NULL DEFAULT 0,
  `fee` decimal(64,0) NOT NULL DEFAULT 0,
  `uuid` char(36) NOT 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 `wallets`
--

CREATE TABLE `wallets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `holder_type` varchar(255) NOT NULL,
  `holder_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `uuid` char(36) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`meta`)),
  `balance` decimal(64,0) NOT NULL DEFAULT 0,
  `decimal_places` smallint(5) UNSIGNED NOT NULL DEFAULT 2,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transactions_uuid_unique` (`uuid`),
  ADD KEY `transactions_payable_type_payable_id_index` (`payable_type`,`payable_id`),
  ADD KEY `payable_type_payable_id_ind` (`payable_type`,`payable_id`),
  ADD KEY `payable_type_ind` (`payable_type`,`payable_id`,`type`),
  ADD KEY `payable_confirmed_ind` (`payable_type`,`payable_id`,`confirmed`),
  ADD KEY `payable_type_confirmed_ind` (`payable_type`,`payable_id`,`type`,`confirmed`),
  ADD KEY `transactions_type_index` (`type`),
  ADD KEY `transactions_wallet_id_foreign` (`wallet_id`);

--
-- Indexes for table `transfers`
--
ALTER TABLE `transfers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transfers_uuid_unique` (`uuid`),
  ADD KEY `transfers_from_type_from_id_index` (`from_type`,`from_id`),
  ADD KEY `transfers_to_type_to_id_index` (`to_type`,`to_id`),
  ADD KEY `transfers_deposit_id_foreign` (`deposit_id`),
  ADD KEY `transfers_withdraw_id_foreign` (`withdraw_id`);

--
-- Indexes for table `wallets`
--
ALTER TABLE `wallets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `wallets_holder_type_holder_id_slug_unique` (`holder_type`,`holder_id`,`slug`),
  ADD UNIQUE KEY `wallets_uuid_unique` (`uuid`),
  ADD KEY `wallets_holder_type_holder_id_index` (`holder_type`,`holder_id`),
  ADD KEY `wallets_slug_index` (`slug`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `address`
--
ALTER TABLE `address`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `appointments`
--
ALTER TABLE `appointments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `chat_rooms`
--
ALTER TABLE `chat_rooms`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `commission`
--
ALTER TABLE `commission`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `complaints`
--
ALTER TABLE `complaints`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `conversions`
--
ALTER TABLE `conversions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `individual`
--
ALTER TABLE `individual`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `offers`
--
ALTER TABLE `offers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `owner_reviews`
--
ALTER TABLE `owner_reviews`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `packages_reviews`
--
ALTER TABLE `packages_reviews`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `products_orders`
--
ALTER TABLE `products_orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_categories`
--
ALTER TABLE `product_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `product_reviews`
--
ALTER TABLE `product_reviews`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_sub_category`
--
ALTER TABLE `product_sub_category`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `redeem`
--
ALTER TABLE `redeem`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referral`
--
ALTER TABLE `referral`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `referralcodes`
--
ALTER TABLE `referralcodes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `salon`
--
ALTER TABLE `salon`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `service_reviews`
--
ALTER TABLE `service_reviews`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `specialist`
--
ALTER TABLE `specialist`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timeslots`
--
ALTER TABLE `timeslots`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transfers`
--
ALTER TABLE `transfers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `wallets`
--
ALTER TABLE `wallets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_wallet_id_foreign` FOREIGN KEY (`wallet_id`) REFERENCES `wallets` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transfers`
--
ALTER TABLE `transfers`
  ADD CONSTRAINT `transfers_deposit_id_foreign` FOREIGN KEY (`deposit_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transfers_withdraw_id_foreign` FOREIGN KEY (`withdraw_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE;
COMMIT;

