UPDATE `attribute_values` SET `value` = '{\"en\":28}' WHERE `attribute_values`.`id` = 12;
UPDATE `attribute_values` SET `value` = '{\"en\":30}' WHERE `attribute_values`.`id` = 13;
UPDATE `attribute_values` SET `value` = '{\"en\":32}' WHERE `attribute_values`.`id` = 14;
UPDATE `attribute_values` SET `value` = '{\"en\":34}' WHERE `attribute_values`.`id` = 15;


CREATE TABLE `zones` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `place_points` geometry DEFAULT NULL,
  `locations` json DEFAULT NULL,
  `status` int DEFAULT '1',
  `created_by_id` bigint 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;

ALTER TABLE `zones`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `zones_name_unique` (`name`),
  ADD KEY `zones_created_by_id_foreign` (`created_by_id`);

ALTER TABLE `zones`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

ALTER TABLE `zones`
  ADD CONSTRAINT `zones_created_by_id_foreign` FOREIGN KEY (`created_by_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

CREATE TABLE `category_zones` (
  `id` bigint UNSIGNED NOT NULL,
  `category_id` bigint UNSIGNED NOT NULL,
  `zone_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `category_zones`
--
ALTER TABLE `category_zones`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_zones_category_id_foreign` (`category_id`),
  ADD KEY `category_zones_zone_id_foreign` (`zone_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `category_zones`
--
ALTER TABLE `category_zones`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `category_zones`
--
ALTER TABLE `category_zones`
  ADD CONSTRAINT `category_zones_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `category_zones_zone_id_foreign` FOREIGN KEY (`zone_id`) REFERENCES `zones` (`id`) ON DELETE CASCADE;

CREATE TABLE `exclude_zone_categories` (
  `id` bigint UNSIGNED NOT NULL,
  `zone_id` bigint UNSIGNED DEFAULT NULL,
  `category_id` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `exclude_zone_categories`
--
ALTER TABLE `exclude_zone_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exclude_zone_categories_zone_id_foreign` (`zone_id`),
  ADD KEY `exclude_zone_categories_category_id_foreign` (`category_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `exclude_zone_categories`
--
ALTER TABLE `exclude_zone_categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `exclude_zone_categories`
--
ALTER TABLE `exclude_zone_categories`
  ADD CONSTRAINT `exclude_zone_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exclude_zone_categories_zone_id_foreign` FOREIGN KEY (`zone_id`) REFERENCES `zones` (`id`) ON DELETE CASCADE;

CREATE TABLE `authors` (
  `id` bigint UNSIGNED NOT NULL,
  `author_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bio` longtext COLLATE utf8mb4_unicode_ci,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author_image_id` bigint UNSIGNED DEFAULT NULL,
  `author_cover_image_id` bigint UNSIGNED DEFAULT NULL,
  `country_id` bigint UNSIGNED DEFAULT NULL,
  `state_id` bigint UNSIGNED DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `death_date` date DEFAULT NULL,
  `languages` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `youtube` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pinterest` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by_id` bigint UNSIGNED DEFAULT NULL,
  `status` int 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;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `authors`
--
ALTER TABLE `authors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `authors_state_id_foreign` (`state_id`),
  ADD KEY `authors_created_by_id_foreign` (`created_by_id`),
  ADD KEY `authors_country_id_foreign` (`country_id`),
  ADD KEY `authors_author_image_id_foreign` (`author_image_id`),
  ADD KEY `authors_author_cover_image_id_foreign` (`author_cover_image_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `authors`
--
ALTER TABLE `authors`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `authors`
--
ALTER TABLE `authors`
  ADD CONSTRAINT `authors_author_cover_image_id_foreign` FOREIGN KEY (`author_cover_image_id`) REFERENCES `attachments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `authors_author_image_id_foreign` FOREIGN KEY (`author_image_id`) REFERENCES `attachments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `authors_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `authors_created_by_id_foreign` FOREIGN KEY (`created_by_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `authors_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE;

CREATE TABLE `product_authors` (
  `id` bigint UNSIGNED NOT NULL,
  `author_id` bigint UNSIGNED NOT NULL,
  `product_id` bigint UNSIGNED NOT 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;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `product_authors`
--
ALTER TABLE `product_authors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_authors_product_id_foreign` (`product_id`),
  ADD KEY `product_authors_author_id_foreign` (`author_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `product_authors`
--
ALTER TABLE `product_authors`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `product_authors`
--
ALTER TABLE `product_authors`
  ADD CONSTRAINT `product_authors_author_id_foreign` FOREIGN KEY (`author_id`) REFERENCES `authors` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_authors_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

CREATE TABLE `languages` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flag` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `locale` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_rtl` int DEFAULT '0',
  `status` int DEFAULT '1',
  `system_reserve` int NOT NULL DEFAULT '0',
  `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 `languages`
--

INSERT INTO `languages` (`id`, `name`, `flag`, `locale`, `is_rtl`, `status`, `system_reserve`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '{\"en\":\"English\"}', 'in', 'en', 0, 1, 1, '2025-01-06 02:44:59', '2025-01-06 02:44:59', NULL);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;


  ALTER TABLE `categories` ADD `is_allow_all_zone` INT NULL AFTER `deleted_at`;

CREATE TABLE `publications` (
  `id` bigint UNSIGNED NOT NULL,
  `publisher_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publisher_logo_id` bigint UNSIGNED DEFAULT NULL,
  `publisher_cover_image_id` bigint UNSIGNED DEFAULT NULL,
  `country_id` bigint UNSIGNED DEFAULT NULL,
  `state_id` bigint UNSIGNED DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `youtube` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pinterest` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by_id` bigint UNSIGNED DEFAULT NULL,
  `status` int 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;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `publications`
--
ALTER TABLE `publications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `publications_state_id_foreign` (`state_id`),
  ADD KEY `publications_created_by_id_foreign` (`created_by_id`),
  ADD KEY `publications_country_id_foreign` (`country_id`),
  ADD KEY `publications_publisher_logo_id_foreign` (`publisher_logo_id`),
  ADD KEY `publications_publisher_cover_image_id_foreign` (`publisher_cover_image_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `publications`
--
ALTER TABLE `publications`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;



ALTER TABLE `publications`
  ADD CONSTRAINT `publications_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `publications_created_by_id_foreign` FOREIGN KEY (`created_by_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `publications_publisher_cover_image_id_foreign` FOREIGN KEY (`publisher_cover_image_id`) REFERENCES `attachments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `publications_publisher_logo_id_foreign` FOREIGN KEY (`publisher_logo_id`) REFERENCES `attachments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `publications_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE;

  ALTER TABLE `products` ADD `external_details` LONGTEXT NULL AFTER `updated_at`, ADD `authors_id` INT NULL AFTER `external_details`, ADD `publication_id` INT NULL AFTER `authors_id`, ADD `read_button_text` LONGTEXT NULL AFTER `publication_id`, ADD `read_document_id` BIGINT NULL AFTER `read_button_text`, ADD `creator_id` BIGINT NULL AFTER `read_document_id`;



INSERT INTO `modules` (`id`, `name`, `sequence`, `created_at`, `updated_at`, `deleted_at`) VALUES (NULL, 'languages', '34', '2025-02-15 14:39:41', '2025-02-15 14:39:41', NULL), (NULL, 'zones', '35', '2025-02-15 14:39:41', '2025-02-15 14:39:41', NULL);
INSERT INTO `modules` (`id`, `name`, `sequence`, `created_at`, `updated_at`, `deleted_at`) VALUES (NULL, 'authors', '36', '2025-02-15 14:41:19', '2025-02-15 14:41:19', NULL), (NULL, 'publications', '37', '2025-02-15 14:41:19', '2025-02-15 14:41:19', NULL);

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'language.index', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32'), (NULL, 'language.create', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32');

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'language.edit', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32'), (NULL, 'language.destroy', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32');

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'zone.index', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32'), (NULL, 'zone.create', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32');

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'zone.edit', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32'), (NULL, 'zone.destroy', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32');

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'author.index', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32'), (NULL, 'author.create', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32');

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'author.edit', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32'), (NULL, 'author.destroy', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32');

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'publication.index', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32'), (NULL, 'publication.create', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32');

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (NULL, 'publication.edit', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32'), (NULL, 'publication.destroy', 'web', '2025-02-15 14:42:32', '2025-02-15 14:42:32');

INSERT INTO `module_permissions` (`id`, `name`, `module_id`, `permission_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (NULL, 'index', '34', '114', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL), (NULL, 'create', '34', '115', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL);

INSERT INTO `module_permissions` (`id`, `name`, `module_id`, `permission_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (NULL, 'edit', '34', '116', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL), (NULL, 'destroy', '34', '117', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL);

INSERT INTO `module_permissions` (`id`, `name`, `module_id`, `permission_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (NULL, 'index', '35', '118', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL), (NULL, 'create', '35', '119', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL);

INSERT INTO `module_permissions` (`id`, `name`, `module_id`, `permission_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (NULL, 'edit', '35', '120', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL), (NULL, 'destroy', '35', '121', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL);

INSERT INTO `module_permissions` (`id`, `name`, `module_id`, `permission_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (NULL, 'index', '36', '122', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL), (NULL, 'create', '36', '123', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL);

INSERT INTO `module_permissions` (`id`, `name`, `module_id`, `permission_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (NULL, 'edit', '36', '124', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL), (NULL, 'destroy', '36', '125', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL);

INSERT INTO `module_permissions` (`id`, `name`, `module_id`, `permission_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (NULL, 'index', '37', '126', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL), (NULL, 'create', '37', '127', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL);

INSERT INTO `module_permissions` (`id`, `name`, `module_id`, `permission_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (NULL, 'edit', '37', '128', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL), (NULL, 'destroy', '37', '129', '2025-02-15 14:46:12', '2025-02-15 14:46:12', NULL);

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('114', '1'), ('115', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('116', '1'), ('117', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('118', '1'), ('119', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('120', '1'), ('121', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('122', '1'), ('123', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('124', '1'), ('125', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('126', '1'), ('127', '1');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('128', '1'), ('129', '1');


UPDATE `home_pages` SET `content` = '{\"en\":{\"home_banner\":{\"status\":true,\"main_banner\":{\"image_url\":\"\\/storage\\/570\\/paris_01.jpg\",\"redirect_link\":{\"link\":\"daily-breakfast\",\"link_type\":\"collection\",\"product_ids\":null}},\"sub_banner_1\":{\"image_url\":\"\\/storage\\/571\\/paris_02.jpg\",\"redirect_link\":{\"link\":\"grocery-staples\",\"link_type\":\"collection\",\"product_ids\":null}},\"sub_banner_2\":{\"image_url\":\"\\/storage\\/572\\/paris_03.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null}}},\"featured_banners\":{\"status\":true,\"banners\":[{\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"},\"status\":true,\"image_url\":\"\\/storage\\/574\\/paris_04.jpg\"},{\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"},\"status\":true,\"image_url\":\"\\/storage\\/575\\/paris_05.jpg\"},{\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"},\"status\":true,\"image_url\":\"\\/storage\\/576\\/paris_06.jpg\"},{\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"},\"status\":true,\"image_url\":\"\\/storage\\/577\\/paris_07.jpg\"}]},\"main_content\":{\"status\":true,\"sidebar\":{\"status\":true,\"categories_icon_list\":{\"title\":\"Popular Categories\",\"category_ids\":[2,5,3,4,6,39,10,8,9,1,7],\"status\":true},\"left_side_banners\":{\"status\":true,\"banner_1\":{\"image_url\":\"\\/storage\\/579\\/paris_08.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null}},\"banner_2\":{\"image_url\":\"\\/storage\\/581\\/paris_11.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null}}},\"sidebar_products\":{\"title\":\"Trending Products\",\"status\":true,\"product_ids\":[1,2,4,6]}},\"section1_products\":{\"title\":\"Top Save Today\",\"description\":\"Don\'t miss this opportunity at a special discount just for this week.\",\"product_ids\":[8,10,15,16,12],\"status\":true},\"section2_categories_list\":{\"image_url\":null,\"title\":\"Browse By Categories\",\"description\":\"Uncover Hidden Gems and Culinary Delights\",\"category_ids\":[2,5,3,4,6,10,9,1,7],\"status\":true},\"section3_two_column_banners\":{\"status\":true,\"banner_1\":{\"image_url\":\"\\/storage\\/563\\/paris_09.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null}},\"banner_2\":{\"image_url\":\"\\/storage\\/564\\/paris_10.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null}}},\"section4_products\":{\"title\":\"Fresh Veggies and Fruits\",\"description\":\"Unlocking the Pantry: A Journey into Essential Veggies Staples\",\"status\":true,\"product_ids\":[19,17,7,9,11,13]},\"seller\":{\"status\":true,\"title\":\"Sellers Showcase\",\"description\":\"Explore our top-rated products loved by customers just like you. Find your new favorites today!\",\"store_ids\":[14,4,3,2,6,12]},\"section5_coupons\":{\"image_url\":\"\\/storage\\/302\\/paris_12.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"},\"status\":true},\"section6_two_column_banners\":{\"status\":true,\"banner_1\":{\"image_url\":\"\\/storage\\/583\\/paris_13.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"}},\"banner_2\":{\"image_url\":\"\\/storage\\/584\\/paris_14.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":\"collection\"}}},\"section7_products\":{\"title\":\"Our Best Seller\",\"description\":\"A virtual assistant collects the products from your list.\",\"status\":true,\"product_ids\":[6,10,2,3,8,1,4,7,12,11,9,19]},\"section8_full_width_banner\":{\"image_url\":\"\\/storage\\/305\\/paris_15.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"status\":true},\"section9_featured_blogs\":{\"title\":\"Featured Blog\",\"description\":\"Uncover Intriguing Highlights in Our Featured Blog\",\"status\":true,\"blog_ids\":[23,24,22]}},\"brands\":{\"status\":true,\"brand_ids\":[3,11,18,34,42,1]},\"news_letter\":{\"title\":\"Join Our Newsletter And Get...\",\"sub_title\":\"$20 discount for your first order\",\"image_url\":\"\\/storage\\/309\\/newsletter.jpg\",\"status\":true},\"products_ids\":[1,2,4,6,8,10,15,16,12,19,17,7,9,11,13,\"collection\",3]}}' WHERE `home_pages`.`id` = 1;


UPDATE `home_pages` SET `content` = '{\"en\":{\"home_banner\":{\"status\":true,\"main_banner\":{\"image_url\":\"\\/storage\\/622\\/tokyo_02.jpg\",\"redirect_link\":{\"link\":\"biscuits-snacks\",\"link_type\":\"collection\",\"product_ids\":null}},\"sub_banner_1\":{\"image_url\":\"\\/storage\\/621\\/tokyo_01.jpg\",\"redirect_link\":{\"link\":\"grocery-staples\",\"link_type\":\"collection\",\"product_ids\":null}},\"sub_banner_2\":{\"image_url\":\"\\/storage\\/623\\/tokyo_03.jpg\",\"redirect_link\":{\"link\":\"daily-breakfast\",\"link_type\":\"collection\",\"product_ids\":null}}},\"categories_icon_list\":{\"image_url\":null,\"category_ids\":[2,5,3,4,6,10,8,9,1],\"status\":true},\"coupons\":{\"status\":true,\"image_url\":\"\\/storage\\/624\\/tokyo_04.jpg\",\"redirect_link\":{\"link\":\"biscuits-snacks\",\"link_type\":\"collection\",\"product_ids\":null}},\"featured_banners\":{\"status\":true,\"banners\":[{\"redirect_link\":{\"link\":\"biscuits-snacks\",\"link_type\":\"collection\",\"product_ids\":null},\"status\":true,\"image_url\":\"\\/storage\\/629\\/tokyo_08.jpg\"},{\"redirect_link\":{\"link\":\"biscuits-snacks\",\"link_type\":\"collection\",\"product_ids\":null},\"status\":true,\"image_url\":\"\\/storage\\/630\\/tokyo_09.jpg\"},{\"redirect_link\":{\"link\":\"biscuits-snacks\",\"link_type\":\"collection\",\"product_ids\":null},\"status\":true,\"image_url\":\"\\/storage\\/631\\/tokyo_10.jpg\"},{\"redirect_link\":{\"link\":40,\"link_type\":\"product\",\"product_ids\":40},\"status\":true,\"image_url\":\"\\/storage\\/633\\/tokyo_11.jpg\"}]},\"main_content\":{\"sidebar\":{\"status\":true,\"right_side_banners\":{\"status\":true,\"banner_1\":{\"image_url\":\"\\/storage\\/625\\/tokyo_05.jpg\",\"redirect_link\":{\"link\":\"https:\\/\\/google.com\\/\",\"link_type\":\"external_url\",\"product_ids\":null}},\"banner_2\":{\"image_url\":\"\\/storage\\/627\\/tokyo_06.jpg\",\"redirect_link\":{\"link\":\"https:\\/\\/google.com\\/\",\"link_type\":\"external_url\",\"product_ids\":null}}}},\"section1_products\":{\"title\":\"Top Save Today\",\"status\":true,\"product_ids\":[40,44,39,31,36]},\"section2_slider_products\":{\"title\":\"Bakery Delights for Everyone\",\"status\":true,\"product_ids\":[25,28,35,39,43,27,31,29,44]},\"seller\":{\"status\":false,\"title\":null,\"store_ids\":[]},\"section3_products\":{\"title\":\"Your Daily Staples\",\"status\":true,\"product_ids\":[26,29,43,41,44,34]},\"section4_products\":{\"title\":\"Popular Snakes\",\"status\":true,\"product_ids\":[41,37,35,31,27,22,25]}},\"full_width_banner\":{\"image_url\":\"\\/storage\\/628\\/tokyo_07.jpg\",\"status\":true,\"redirect_link\":{\"link\":\"grocery-staples\",\"link_type\":\"collection\",\"product_ids\":null}},\"slider_products\":{\"status\":true,\"product_slider_1\":{\"title\":\"Top Selling\",\"product_ids\":[25,26,27],\"status\":true},\"product_slider_2\":{\"title\":\"Trending Products\",\"product_ids\":[40,22,31],\"status\":true},\"product_slider_3\":{\"title\":\"Recently added\",\"product_ids\":[42,38,32],\"status\":true},\"product_slider_4\":{\"title\":\"Top Rated\",\"product_ids\":[45,43,41],\"status\":true}},\"news_letter\":{\"title\":\"Join Our Newsletter And Get...\",\"sub_title\":\"$20 discount for your first order\",\"image_url\":\"\\/storage\\/634\\/tokyo_12.jpg\",\"status\":true},\"brands\":{\"status\":true,\"brand_ids\":[3,11,18,24,34,42]},\"products_ids\":[40,44,39,31,36,25,28,35,43,27,29,26,41,34,37,22,42,38,32,45]}}' WHERE `home_pages`.`id` = 2;


UPDATE `home_pages` SET `content` = '{\"en\":{\"home_banner\":{\"status\":true,\"main_banner\":{\"image_url\":\"\\/storage\\/651\\/osaka_03.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null}},\"sub_banner_1\":{\"image_url\":\"\\/storage\\/652\\/osaka_04.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":\"collection\"}}},\"categories_icon_list\":{\"title\":\"Browse By Categories\",\"description\":\"Top Categories Of The Week\",\"image_url\":null,\"category_ids\":[2,5,3,4,6,10,8,1,7],\"status\":true},\"coupons\":{\"image_url\":\"\\/storage\\/335\\/osaka_02.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"status\":true},\"products_list_1\":{\"title\":\"Fruits and Vegetables\",\"description\":\"Farm-Fresh Goodness: A Variety of Fruits and Vegetables Awaits\",\"status\":true,\"product_ids\":[19,15,8,5,6,7]},\"offer_banner\":{\"image_url\":\"\\/storage\\/305\\/paris_15.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"status\":true},\"seller\":{\"status\":true,\"title\":\"Sellers Showcase\",\"description\":\"Explore our top-rated products loved by customers just like you. Find your new favorites today!\",\"store_ids\":[18,16,4,3,2,7]},\"products_list_2\":{\"title\":\"Breakfast and Dairy\",\"description\":\"Morning Delights: Breakfast and Dairy Choices to Start Your Day\",\"status\":true,\"product_ids\":[45,30,21,19,8,44,41,38,36]},\"product_bundles\":{\"status\":true,\"bundles\":[{\"title\":\"Hot Deals on New Items\",\"sub_title\":\"Daily Essentials Eggs & Dairy\",\"image_url\":\"\\/storage\\/338\\/osaka_05.png\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"status\":true},{\"title\":\"Organic Meat Prepared\",\"sub_title\":\"Delivered to Your Home\",\"image_url\":\"\\/storage\\/342\\/osaka_08.png\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"status\":true},{\"title\":\"Buy More & Save More\",\"sub_title\":\"Fresh Vegetables & Fruits\",\"image_url\":\"\\/storage\\/340\\/osaka_06.png\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"status\":true},{\"title\":\"Fresh Fruits on Go\",\"sub_title\":\"Fresh Vegetables & Fruits\",\"image_url\":\"\\/storage\\/341\\/osaka_07.png\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"status\":true}]},\"slider_products\":{\"status\":true,\"product_slider_1\":{\"title\":\"Top Selling\",\"status\":true,\"product_ids\":[36,35,34]},\"product_slider_2\":{\"title\":\"Trending Products\",\"status\":true,\"product_ids\":[32,33,38]},\"product_slider_3\":{\"title\":\"Recently added\",\"status\":true,\"product_ids\":[44,43,42]},\"product_slider_4\":{\"title\":\"Top Rated\",\"status\":true,\"product_ids\":[30,21,45]}},\"featured_blogs\":{\"title\":\"Featured Blog\",\"description\":\"Uncover Intriguing Highlights in Our Featured Blog\",\"status\":true,\"blog_ids\":[23,24,22]},\"news_letter\":{\"title\":\"Join Our Newsletter And Get...\",\"sub_title\":\"$20 discount for your first order\",\"image_url\":\"\\/storage\\/309\\/newsletter.jpg\",\"status\":true},\"brands\":{\"status\":true,\"brand_ids\":[11,3,34,18,1,42]},\"products_ids\":[\"collection\",19,15,8,5,6,7,45,30,21,44,41,38,36,35,34,32,33,43,42]}}' WHERE `home_pages`.`id` = 3;

UPDATE `home_pages` SET `content` = '{\"en\":{\"home_banner\":{\"status\":true,\"bg_image_url\":\"\\/storage\\/351\\/rome_07.png\",\"main_banner\":{\"image_url\":\"\\/storage\\/672\\/rome_09.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"}},\"sub_banner_1\":{\"image_url\":\"\\/storage\\/673\\/rome_10.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"}},\"sub_banner_2\":{\"image_url\":\"\\/storage\\/667\\/rome_05.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"}},\"sub_banner_3\":{\"image_url\":\"\\/storage\\/669\\/rome_06.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"}}},\"categories_image_list\":{\"title\":\"Shop By Categories\",\"category_ids\":[20,18,2,22,19,6,21,1],\"status\":true},\"value_banners\":{\"title\":\"Best Valuable Deals\",\"status\":true,\"banners\":[{\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"},\"status\":true,\"image_url\":\"\\/storage\\/665\\/rome_03.jpg\"},{\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"},\"status\":true,\"image_url\":\"\\/storage\\/663\\/rome_01.jpg\"},{\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"},\"status\":true,\"image_url\":\"\\/storage\\/664\\/rome_02.jpg\"}]},\"categories_products\":{\"title\":\"Our Products\",\"status\":true,\"category_ids\":[5,6]},\"seller\":{\"status\":[\"on\"],\"title\":\"Sellers Showcase\",\"store_ids\":[16,14,15,13,12,7]},\"two_column_banners\":{\"status\":true,\"banner_1\":{\"image_url\":\"\\/storage\\/671\\/rome_08.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"}},\"banner_2\":{\"image_url\":\"\\/storage\\/666\\/rome_04.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"}}},\"slider_products\":{\"status\":true,\"product_slider_1\":{\"title\":\"New Products\",\"product_ids\":[6,1,13],\"status\":true},\"product_slider_2\":{\"title\":\"Featured Products\",\"product_ids\":[12,18,19],\"status\":true},\"product_slider_3\":{\"title\":\"Best Seller\",\"product_ids\":[2,15,9],\"status\":true},\"product_slider_4\":{\"title\":\"Trending Products\",\"product_ids\":[8,10,14],\"status\":true}},\"full_width_banner\":{\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"},\"image_url\":\"\\/storage\\/670\\/rome_07.jpg\",\"status\":true},\"products_list_1\":{\"title\":\"Top Products\",\"status\":true,\"product_ids\":[4,7,15,17,16,1,20]},\"featured_blogs\":{\"title\":\"Featured Blog\",\"status\":true,\"blog_ids\":[24,23,20,22,21]},\"news_letter\":{\"title\":\"Subscribe to the newsletter\",\"sub_title\":\"Join our subscribers list to get the latest news, updates and special offers  delivered directly in your inbox.\",\"image_url\":\"\\/storage\\/358\\/rome_12.png\",\"status\":true},\"brands\":{\"status\":false,\"brand_ids\":[1]},\"products_ids\":[6,1,13,12,18,19,2,15,9,8,10,14,4,7,17,16,20]}}' WHERE `home_pages`.`id` = 4;

UPDATE `home_pages` SET `content` = '{\"en\":{\"home_banner\":{\"status\":true,\"main_banner\":{\"image_url\":\"\\/storage\\/1454\\/fruite-Banner.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null}}},\"featured_banners\":{\"status\":true,\"banners\":[{\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"image_url\":\"\\/storage\\/678\\/madrid_04.jpg\",\"status\":true},{\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"image_url\":\"\\/storage\\/677\\/madrid_03.jpg\",\"status\":true},{\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"image_url\":\"\\/storage\\/676\\/madrid_02.jpg\",\"status\":true},{\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"image_url\":\"\\/storage\\/675\\/madrid_01.jpg\",\"status\":true}]},\"categories_image_list\":{\"title\":\"Shop By Categories\",\"category_ids\":[20,18,2,22,19,6,21,1],\"status\":true},\"products_list_1\":{\"title\":\"Fruits & Vegetables\",\"product_ids\":[4,11,12,6,1,17],\"status\":true},\"bank_wallet_offers\":{\"title\":\"Bank & Wallet Offers\",\"status\":true,\"offers\":[{\"coupon_code\":\"FASTPR10\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"image_url\":\"\\/storage\\/402\\/mc1.jpg\",\"status\":true},{\"coupon_code\":\"FASTBOGO\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"image_url\":\"\\/storage\\/403\\/mc2.jpg\",\"status\":true},{\"coupon_code\":\"FASTFESTIVE\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\",\"product_ids\":null},\"image_url\":\"\\/storage\\/404\\/mc3.jpg\",\"status\":true}]},\"product_with_deals\":{\"title\":\"Top Selling Items\",\"status\":true,\"products_list\":{\"title\":\"Top Selling Items\",\"status\":true,\"product_ids\":[20,2,12,17,30,45,33,22]},\"deal_of_days\":{\"title\":\"Special Offer\",\"status\":true,\"image_url\":\"\\/storage\\/406\\/m_bg.jpg\",\"label\":\"Hot Deal\",\"deals\":[{\"offer_title\":\"Special Offer\",\"product_id\":11,\"end_date\":\"2026-06-28T10:32\",\"status\":true}]}},\"seller\":{\"status\":true,\"title\":\"Sellers Showcase\",\"store_ids\":[16,15,6,4,14,7]},\"full_width_banner\":{\"image_url\":\"\\/storage\\/368\\/madrid_10.png\",\"status\":true,\"redirect_link\":{\"link\":null,\"link_type\":null}},\"products_list_2\":{\"title\":\"Breakfast & Dairy\",\"product_ids\":[35,36,30,44,38,34,37,42],\"status\":true},\"products_list_3\":{\"title\":\"Fresh Fruits\",\"product_ids\":[12,8,18,16,10,14],\"status\":true},\"two_column_banners\":{\"status\":true,\"banner_1\":{\"image_url\":\"\\/storage\\/370\\/madrid_11.jpg\",\"redirect_link\":{\"link\":40,\"link_type\":\"product\",\"product_ids\":40}},\"banner_2\":{\"image_url\":\"\\/storage\\/372\\/madrid_12.jpg\",\"redirect_link\":{\"link\":\"grocery-staples\",\"link_type\":\"collection\",\"product_ids\":null}}},\"products_list_4\":{\"title\":\"Organic Vegetables\",\"status\":true,\"product_ids\":[5,6,4,2,1,7,9,11]},\"products_list_5\":{\"title\":\"Our Best Sellers\",\"status\":true,\"product_ids\":[32,33,34,31,38,41,45]},\"delivery_banners\":{\"status\":true,\"banner_1\":{\"image_url\":\"\\/storage\\/367\\/madrid_09.jpg\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"}},\"banner_2\":{\"image_url\":\"\\/storage\\/361\\/madrid_04.png\",\"redirect_link\":{\"link\":\"vegetables-fruits\",\"link_type\":\"collection\"}}},\"products_list_6\":{\"title\":\"Trending Products\",\"status\":true,\"product_ids\":[42,40,32,34,30,36,45]},\"products_list_7\":{\"title\":\"New Arrivals\",\"status\":true,\"product_ids\":[39,38,35,32,31,40,22]},\"featured_blogs\":{\"title\":\"Featured Blog\",\"status\":true,\"blog_ids\":[17,16,19,21,20]},\"brands\":{\"status\":false,\"brand_ids\":[3]},\"products_ids\":[4,11,12,6,1,17,20,2,30,45,33,22,35,36,44,38,34,37,42,8,18,16,10,14,40,5,7,9,32,31,41,39]}}' WHERE `home_pages`.`id` = 5;


UPDATE `home_pages` SET `content` = '{\"en\":{\"home_banner\":{\"status\":true,\"main_banner\":{\"image_url\":\"\\/storage\\/684\\/berlin_04.jpg\",\"redirect_link\":{\"link\":\"furniture\",\"link_type\":\"collection\",\"product_ids\":null}},\"sub_banner_1\":{\"image_url\":\"\\/storage\\/683\\/berlin_03.jpg\",\"redirect_link\":{\"link\":\"furniture\",\"link_type\":\"collection\",\"product_ids\":null}}},\"services_banner\":{\"status\":true,\"services\":[{\"title\":\"Free Shipping\",\"sub_title\":\"Free Shipping world wide\",\"status\":true,\"image_url\":\"\\/storage\\/558\\/Free-shipping.png\"},{\"title\":\"24 x 7 Service\",\"sub_title\":\"Online Service For 24 x 7\",\"status\":true,\"image_url\":\"\\/storage\\/557\\/24-support.png\"},{\"title\":\"Online Pay\",\"sub_title\":\"Online Payment Available\",\"status\":true,\"image_url\":\"\\/storage\\/560\\/Online-payment.png\"},{\"title\":\"Festival Offer\",\"sub_title\":\"Super Sale Upto 50% off\",\"status\":true,\"image_url\":\"\\/storage\\/559\\/Offer.png\"},{\"title\":\"100% Original\",\"sub_title\":\"100% Money Back\",\"status\":true,\"image_url\":\"\\/storage\\/561\\/Original.png\"}]},\"main_content\":{\"status\":true,\"sidebar\":{\"status\":true,\"categories_icon_list\":{\"title\":\"Shop By Categories\",\"category_ids\":[20,18,22,19,17],\"status\":true},\"right_side_banners\":{\"status\":true,\"banner_1\":{\"redirect_link\":{\"link\":\"furniture\",\"link_type\":\"collection\",\"product_ids\":null},\"image_url\":\"\\/storage\\/681\\/berlin_01.jpg\"}},\"sidebar_products\":{\"title\":\"Modern Furniture\",\"status\":true,\"product_ids\":[59,57,55]}},\"section1_products\":{\"title\":\"Top Save Today\",\"description\":\"Don\'t miss this opportunity at a special discount just for this week.\",\"product_ids\":[55,57,50,59,53,49],\"status\":true},\"section2_categories_icon_list\":{\"title\":\"Categories\",\"description\":\"Top Categories Of The Week\",\"image_url\":null,\"category_ids\":[20,18,22,19,17,9,21],\"status\":true},\"section3_two_column_banners\":{\"status\":true,\"banner_1\":{\"image_url\":\"\\/storage\\/687\\/berlin_06.jpg\",\"redirect_link\":{\"link\":\"furniture\",\"link_type\":\"collection\",\"product_ids\":null}},\"banner_2\":{\"image_url\":\"\\/storage\\/685\\/berlin_05.jpg\",\"redirect_link\":{\"link\":\"furniture\",\"link_type\":\"collection\",\"product_ids\":null}}},\"section4_products\":{\"title\":\"Elegant Designs\",\"description\":\"Crafting timeless, sophisticated furniture for your dream living spaces\",\"status\":true,\"product_ids\":[49,50,47,57,69,72,77]},\"seller\":{\"status\":true,\"title\":\"Sellers Showcase\",\"description\":\"Explore our top-rated products loved by customers just like you. Find your new favorites today!\",\"store_ids\":[16,15,14,13,12,4]}},\"full_width_banner\":{\"image_url\":\"\\/storage\\/682\\/berlin_02.jpg\",\"redirect_link\":{\"link\":\"furniture\",\"link_type\":\"collection\",\"product_ids\":null}},\"product_list_1\":{\"title\":\"Furniture Collections\",\"description\":\"Contemporary designs for stylish, comfortable living spaces.\",\"status\":true,\"product_ids\":[59,57,55,53,50,47,77,74,72,70,69,61]},\"news_letter\":{\"title\":\"Join Our Newsletter And Get...\",\"sub_title\":\"$20 discount for your first order\",\"image_url\":\"\\/storage\\/309\\/newsletter.jpg\",\"status\":true},\"brands\":{\"status\":false,\"brand_ids\":[2,3]},\"products_ids\":[59,57,55,50,53,49,47,69,72,77,74,70,61]}}' WHERE `home_pages`.`id` = 6;


UPDATE `home_pages` SET `content` = '{\"en\":{\"home_banner\":{\"status\":false,\"main_banner\":{\"image_url\":\"\\/storage\\/1470\\/01.jpg\",\"redirect_link\":{\"link\":\"fashion\",\"link_type\":\"collection\",\"product_ids\":null}}},\"categories_icon_list\":{\"status\":true,\"category_ids\":[20,18,22,19,17,9,21],\"image_url\":null},\"products_list_1\":{\"title\":\"Top Selling Items\",\"product_ids\":[178,163,161,152,121,170,177],\"status\":true},\"two_column_banners\":{\"status\":true,\"banner_1\":{\"image_url\":\"\\/storage\\/1471\\/02.jpg\",\"redirect_link\":{\"link\":\"fashion\",\"link_type\":\"collection\",\"product_ids\":null}},\"banner_2\":{\"image_url\":\"\\/storage\\/1472\\/03.jpg\",\"redirect_link\":{\"link\":\"https:\\/\\/www.google.com\\/\",\"link_type\":\"external_url\",\"product_ids\":null}}},\"seller\":{\"status\":true,\"title\":\"Sellers Showcase\",\"store_ids\":[16,15,14,4,6,7]},\"slider_product_with_banner\":{\"left_side_banners\":{\"status\":true,\"banner_1\":{\"image_url\":\"\\/storage\\/1473\\/04.jpg\",\"redirect_link\":{\"link\":\"fashion\",\"link_type\":\"collection\",\"product_ids\":null}}},\"slider_products\":{\"status\":true,\"product_slider_1\":{\"title\":\"Top Selling\",\"product_ids\":[178,177,163,161],\"status\":true},\"product_slider_2\":{\"title\":\"Trending Products\",\"product_ids\":[163,152,121,178],\"status\":true},\"product_slider_3\":{\"title\":\"Recently added\",\"product_ids\":[171,170,168,177],\"status\":true}}},\"coupon_banner\":{\"image_url\":\"\\/storage\\/690\\/denver_02.jpg\",\"status\":true,\"redirect_link\":{\"link\":\"fashion\",\"link_type\":\"collection\",\"product_ids\":null}},\"products_list_2\":{\"title\":\"Trendy Fashion Finds\",\"product_ids\":[178,177,174,173,172,171,170,169],\"status\":true},\"products_list_3\":{\"title\":\"Chic Style Selection\",\"product_ids\":[121,152,161,163,165,166,167],\"status\":true},\"news_letter\":{\"title\":\"Join Our Newsletter And Get...\",\"status\":true,\"image_url\":\"\\/storage\\/309\\/newsletter.jpg\",\"sub_title\":\"$20 discount for your first order\"},\"brands\":[],\"products_ids\":[178,163,161,152,121,170,177,171,168,174,173,172,169,165,166,167]}}' WHERE `home_pages`.`id` = 7;

UPDATE `home_pages` SET `content` = '{\"en\":{\"home_banner\":{\"status\":false,\"main_banner\":{\"image_url\":\"\\/storage\\/1606\\/book_main_banner.jpg\",\"redirect_link\":{\"link\":\"books\",\"link_type\":\"collection\",\"product_ids\":null}}},\"categories_icon_list\":{\"status\":true,\"category_ids\":[34,35,36,37,38,40,41,42,39],\"title\":\"Categories\"},\"products_list_1\":{\"title\":\"Popular Books This Year\",\"product_ids\":[183,192,191,193,189,186,187,185],\"status\":true},\"coupons\":{\"status\":true,\"image_url\":\"\\/storage\\/1608\\/book_c.jpg\",\"redirect_link\":{\"link\":\"books\",\"link_type\":\"collection\",\"product_ids\":null}},\"slider_product_with_banner\":{\"left_side_banners\":{\"status\":true,\"banner_1\":{\"image_url\":\"\\/storage\\/1610\\/book_side_banner.jpg\",\"redirect_link\":{\"link\":183,\"link_type\":\"product\",\"product_ids\":183}}},\"slider_products\":{\"status\":true,\"product_slider_1\":{\"title\":\"Top Selling\",\"product_ids\":[193,192,190,191],\"status\":true},\"product_slider_2\":{\"title\":\"Trending Books\",\"product_ids\":[190,192,187,186],\"status\":true},\"product_slider_3\":{\"title\":\"Recently Added\",\"product_ids\":[192,191,193,190],\"status\":true}}},\"products_list_2\":{\"title\":\"Best Selling Books\",\"product_ids\":[189,188,190,193,192,187],\"status\":true},\"news_letter\":{\"title\":\"Join Our Newsletter And Get...\",\"status\":true,\"image_url\":\"\\/storage\\/309\\/newsletter.jpg\",\"sub_title\":\"$20 discount for your first order\"},\"brands\":{\"status\":false,\"brand_ids\":[3,1]},\"products_ids\":[183,192,191,193,189,186,187,185,190,188]}}' WHERE `home_pages`.`id` = 8;

UPDATE `home_pages` SET `content` = '{\"en\":{\"home_banner\":{\"status\":true,\"main_banner\":{\"image_url\":\"\\/storage\\/1630\\/digital-bg.jpg\",\"title\":\"Modern Themes & Website Template for any project\",\"sub_title\":\"Discover thousands of digital product & downloads\",\"search_enable\":true,\"category_ids\":[44,50,47,52,51,48,45,46,49,43]}},\"categories_icon_list\":{\"status\":true,\"category_ids\":[56,55,57,54,53,58]},\"products_list_1\":{\"title\":\"Featured Templates\",\"product_ids\":[198,196,205,209],\"status\":true},\"categories_icon_list_2\":{\"status\":true,\"title\":\"Browse By Category\",\"category_ids\":[44,50,47,52,51,48,45,46,49,43]},\"slider_product\":{\"status\":true,\"image_url\":\"\\/storage\\/1632\\/digi-bg-2.jpg\",\"title\":\"Featured Templates\",\"description\":\"Every week, our staff personally hand-pick some of the best new website themes from our collection.\",\"product_ids\":[196,195,198]},\"seller\":{\"status\":false,\"title\":\"Sellers Showcase\",\"store_ids\":[16,15,14,13,12,7]},\"categories_products\":{\"title\":\"Newest Items\",\"status\":true,\"category_ids\":[54,58]},\"featured_blogs\":{\"status\":true,\"title\":\"Tips, Tricks, And Trends\",\"description\":null,\"blog_ids\":[31,30,29,28,27]},\"brands\":{\"status\":false,\"brand_ids\":[3,1]},\"news_letter\":{\"status\":true,\"title\":\"Join Our Newsletter And Get...\",\"image_url\":\"\\/storage\\/309\\/newsletter.jpg\",\"sub_title\":\"$20 discount for your first order\"},\"products_ids\":[198,196,205,209,195]}}' WHERE `home_pages`.`id` = 9;

UPDATE `menus` SET `title` = '{\"en\":404}' WHERE `menus`.`id` = 128;

ALTER TABLE `products` ADD `is_digital` INT NULL DEFAULT '0' AFTER `creator_id`;

UPDATE `settings` SET `values` = '{\n    \"email\": {\n        \"mail_host\": \"webiots.co.in\",\n        \"mail_port\": 465,\n        \"mail_mailer\": \"smtp\",\n        \"mail_password\": \"fastkart@123\",\n        \"mail_username\": \"fastkart-v2@webiots.co.in\",\n        \"mail_from_name\": \"no-reply\",\n        \"mailgun_domain\": \"ENTER_YOUR_MAILGUN_DOMAIN\",\n        \"mailgun_secret\": \"ENTER_YOUR_MAILGUN_SECRET\",\n        \"mail_encryption\": \"ssl\",\n        \"system_test_mail\": true,\n        \"cancel_order_mail\": true,\n        \"mail_from_address\": \"fastkart-v2@webiots.co.in\",\n        \"password_reset_mail\": true,\n        \"refund_request_mail\": true,\n        \"signup_welcome_mail\": true,\n        \"visitor_inquiry_mail\": true,\n        \"order_confirmation_mail\": true,\n        \"withdrawal_request_mail\": true,\n        \"order_status_update_mail\": true,\n        \"pending_order_alert_mail\": true,\n        \"refund_status_update_mail\": true,\n        \"new_vendor_notification_mail\": true,\n        \"withdrawal_status_update_mail\": true\n    },\n    \"refund\": {\n        \"status\": true,\n        \"refundable_days\": 7\n    },\n    \"general\": {\n        \"mode\": \"light-only\",\n        \"site_url\": \"https://angular.pixelstrap.net/multikart-rest/\",\n        \"copyright\": \"Copyright 2024 © Multikart theme by pixelstrap\",\n        \"site_name\": \"Multikart\",\n        \"site_title\": \"Multikart Marketplace: Where Vendors Shine Together\",\n        \"site_tagline\": \"Shop Unique, Sell Exceptional – Multikart\'s Multi-Vendor Universe.\",\n        \"default_timezone\": \"Asia/Kolkata\",\n        \"favicon_image_id\": 10,\n        \"min_order_amount\": 0,\n        \"dark_logo_image_id\": 3948,\n        \"product_sku_prefix\": \"FS\",\n        \"tiny_logo_image_id\": 1302,\n        \"default_currency_id\": 1,\n        \"default_language_id\": 1,\n        \"light_logo_image_id\": 3950,\n        \"min_order_free_shipping\": 50,\n        \"admin_site_language_direction\": \"ltr\"\n    },\n    \"delivery\": {\n        \"default\": {\n            \"title\": \"Standard Delivery\",\n            \"description\": \"Approx 5 to 7 Days\"\n        },\n        \"same_day\": {\n            \"title\": \"Express Delivery\",\n            \"description\": \"Schedule\"\n        },\n        \"default_delivery\": 1,\n        \"same_day_delivery\": true,\n        \"same_day_intervals\": [\n            {\n                \"title\": \"Morning\",\n                \"description\": \"8.00 AM - 12.00 AM\"\n            },\n            {\n                \"title\": \"Noon\",\n                \"description\": \"12.00 PM - 2.00 PM\"\n            },\n            {\n                \"title\": \"Afternoon\",\n                \"description\": \"02.00 PM - 05.00 PM\"\n            },\n            {\n                \"title\": \"Evening\",\n                \"description\": \"05.00 PM - 08.00 PM\"\n            }\n        ]\n    },\n    \"analytics\": {\n        \"facebook_pixel\": [],\n        \"google_analytics\": []\n    },\n    \"activation\": {\n        \"send_sms\": true,\n        \"multivendor\": true,\n        \"track_order\": true,\n        \"zone_enable\": true,\n        \"login_number\": true,\n        \"point_enable\": true,\n        \"coupon_enable\": true,\n        \"wallet_enable\": true,\n        \"guest_checkout\": true,\n        \"stock_product_hide\": false,\n        \"store_auto_approve\": true,\n        \"product_auto_approve\": true\n    },\n    \"maintenance\": {\n        \"title\": \"We\'ll be back Soon..\",\n        \"end_date\": \"2024-7-31\",\n        \"start_date\": null,\n        \"description\": \"We are busy to updating our store for you.\",\n        \"maintenance_mode\": false,\n        \"maintenance_image_id\": 3863\n    },\n    \"sms_methods\": {\n        \"config\": {\n            \"place_order_sms\": true,\n            \"cancel_order_sms\": true,\n            \"signup_bonus_sms\": true,\n            \"pending_order_sms\": true,\n            \"refund_request_sms\": true,\n            \"vendor_register_sms\": true,\n            \"withdraw_request_sms\": true,\n            \"update_order_status_sms\": true,\n            \"update_refund_request_sms\": true,\n            \"update_withdraw_request_sms\": true\n        },\n        \"twilio\": {\n            \"title\": \"Twilio\",\n            \"status\": true,\n            \"twilio_sid\": \"AC6bd10e339930c604024a70ae84fb8658\",\n            \"twilio_number\": \"+12533368066\",\n            \"twilio_auth_token\": \"fb0d683efd4bef598a6b4e7614654841\"\n        }\n    },\n    \"wallet_points\": {\n        \"signup_points\": 100,\n        \"min_per_order_amount\": 100,\n        \"point_currency_ratio\": 30,\n        \"reward_per_order_amount\": 10\n    },\n    \"payment_methods\": {\n        \"cod\": {\n            \"title\": \"Cash On Delivery\",\n            \"status\": true\n        },\n        \"bkash\": {\n            \"title\": \"bKash\",\n            \"status\": true,\n            \"app_key\": \"ENTER_YOUR_APP_KEY\",\n            \"password\": \"ENTER_YOUR_BKASH_PASSWORD\",\n            \"username\": \"ENTER_YOUR_BKASH_USERNAME\",\n            \"app_secret\": \"ENTER_YOUR_APP_SECRET\",\n            \"sandbox_mode\": true\n        },\n        \"mollie\": {\n            \"title\": \"Mollie\",\n            \"status\": true,\n            \"secret_key\": \"test_pKDxyTWpj6bFDuy67DBq4KHFqWSCEf\"\n        },\n        \"paypal\": {\n            \"title\": \"PayPal\",\n            \"status\": true,\n            \"client_id\": \"AWSvIg3u2s-p7g2RYkcktJLjtn3Rsw0LZAm0CoS6WeYtEoYmSzRC01bT0wVxz4whG3eN4bCu1vparBbp\",\n            \"sandbox_mode\": true,\n            \"client_secret\": \"EPtAGaQiNig5iYMuxtoFs_kVimBODw7axl7hSjn21YLPi6aCRJymPoU2n9GtLWNVqXGWj155XRK7Kpcm\"\n        },\n        \"stripe\": {\n            \"key\": \"pk_test_51MmTx1SHGHXeqsVlOWH2cwf42zty7jStl9ngvASN79Vri7bwGsbOSTGFTf17O2r5PiCIinh6vmO5FGrU5B2ymW7L00OcvpXwT3\",\n            \"title\": \"Stripe\",\n            \"secret\": \"sk_test_51MmTx1SHGHXeqsVlAbforUpNIqByURbQy2xKZLlDrSNUvtvbgjywaaEZfGsbcQxIh0ggazGXrfnZBy0rQSLCqvzo00PyWPfbne\",\n            \"status\": true\n        },\n        \"phonepe\": {\n            \"title\": \"PhonePe\",\n            \"status\": true,\n            \"salt_key\": null,\n            \"salt_index\": \"ENTER_YOUR_SALT_INDEX\",\n            \"merchant_id\": \"ENTER_YOUR_MERCHANT_ID\",\n            \"sandbox_mode\": true\n        },\n        \"ccavenue\": {\n            \"title\": \"CCAvenue\",\n            \"status\": true,\n            \"access_code\": \"ENTER_YOUR_ACCESS_CODE\",\n            \"merchant_id\": \"ENTER_YOUR_MERCHANT_ID\",\n            \"working_key\": \"ENTER_YOUR_WORKING_KEY\",\n            \"sandbox_mode\": true\n        },\n        \"paystack\": {\n            \"title\": \"Paystack\",\n            \"status\": true,\n            \"public_key\": \"ENTER_YOUR_PUBLIC_KEY\",\n            \"secret_key\": \"ENTER_YOUR_SECRET_KEY\",\n            \"sandbox_mode\": true\n        },\n        \"razorpay\": {\n            \"key\": \"rzp_test_iV7SM01Wb7wvhv\",\n            \"title\": \"RazorPay\",\n            \"secret\": \"gjdchqP3v7shiW7SRKo2xecV\",\n            \"status\": true\n        },\n        \"instamojo\": {\n            \"title\": \"InstaMojo\",\n            \"status\": true,\n            \"salt_key\": \"ENTER_YOUR_SALT_KEY\",\n            \"client_id\": \"ENTER_YOUR_CLIENT_ID\",\n            \"sandbox_mode\": true,\n            \"client_secret\": \"ENTER_YOUR_CLIENT_SECRET\"\n        },\n        \"sslcommerz\": {\n            \"title\": \"SSLCommerz\",\n            \"status\": true,\n            \"store_id\": \"ENTER_YOUR_STORE_ID\",\n            \"sandbox_mode\": true,\n            \"store_password\": \"ENTER_YOUR_STORE_PASSWORD\"\n        },\n        \"flutter_wave\": {\n            \"title\": \"FlutterWave\",\n            \"status\": true,\n            \"public_key\": \"ENTER_YOUR_PUBLIC_KEY\",\n            \"secret_key\": \"ENTER_YOUR_SECRET_KEY\",\n            \"secret_hash\": \"ENTER_YOUR_SECRET_HASH\",\n            \"sandbox_mode\": true\n        },\n        \"bank_transfer\": {\n            \"title\": \"Bank Transfer\",\n            \"status\": true\n        }\n    },\n    \"google_reCaptcha\": {\n        \"secret\": \"ENTER_YOUR_SECRET_KEY\",\n        \"status\": false,\n        \"site_key\": \"ENTER_YOUR_SITE_KEY\"\n    },\n    \"vendor_commissions\": {\n        \"status\": true,\n        \"min_withdraw_amount\": 500,\n        \"default_commission_rate\": 10,\n        \"is_category_based_commission\": true\n    },\n    \"media_configuration\": {\n        \"aws_bucket\": \"ENTER_YOUR_AWS_BUCKET\",\n        \"media_disk\": \"public\",\n        \"aws_access_key_id\": \"ENTER_YOUR_AWS_ACCESS_KEY\",\n        \"aws_default_region\": \"ENTER_YOUR_AWS_DEFAULT_REGION\",\n        \"aws_secret_access_key\": \"ENTER_YOUR_AWS_SECRET_KEY\"\n    }\n}' WHERE `settings`.`id` = 1;



Consumer Permissions:-
=====================
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('44', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('80', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('77', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('74', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('45', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('81', '2');

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('83', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('84', '2');
INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES ('85', '2');

NotRequired:-
============
ALTER TABLE `wholesales` CHANGE `value` `value` FLOAT NULL DEFAULT NULL;