SET FOREIGN_KEY_CHECKS=0; -- Data for table `users` -- TRUNCATE TABLE `users`; INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `phone_verified`, `remember_token`, `created_at`, `updated_at`, `is_active`, `last_login_at`, `phone`) VALUES ("1", "Admin User", "admin@example.com", "2025-12-16 17:25:31", "$2y$12$9p7LjXdhWpU15yrETuqbROOxApTvFXAkE.WhBy3Szf07IRd7ieneK", "admin", "0", "I2b9lgqZCakJcp6h5MK4MVqAFao3fXpP40itGdckYWqLIVSgVVEkwMNR3lOj", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "1", NULL, NULL); INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `phone_verified`, `remember_token`, `created_at`, `updated_at`, `is_active`, `last_login_at`, `phone`) VALUES ("2", "Seller 1", "seller1@example.com", "2025-12-16 17:25:31", "$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi", "seller", "0", "mXfhuCTN1s3pfsS2hwF4uTt86VFFz2OnU518bCtE7UFRfasRf9w7vVFNmH8V", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "1", NULL, NULL); INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `phone_verified`, `remember_token`, `created_at`, `updated_at`, `is_active`, `last_login_at`, `phone`) VALUES ("3", "Seller 2", "seller2@example.com", "2025-12-16 17:25:31", "$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi", "seller", "0", "jEbx3ZZFBb", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "1", NULL, NULL); INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `phone_verified`, `remember_token`, `created_at`, `updated_at`, `is_active`, `last_login_at`, `phone`) VALUES ("4", "Seller 3", "seller3@example.com", "2025-12-16 17:25:31", "$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi", "seller", "0", "3psmvgCCBf", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "1", NULL, NULL); INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `phone_verified`, `remember_token`, `created_at`, `updated_at`, `is_active`, `last_login_at`, `phone`) VALUES ("5", "Buyer 1", "buyer1@example.com", "2025-12-16 17:25:31", "$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi", "buyer", "0", "n3bbNA2qe3", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "1", NULL, NULL); INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `phone_verified`, `remember_token`, `created_at`, `updated_at`, `is_active`, `last_login_at`, `phone`) VALUES ("6", "Buyer 2", "buyer2@example.com", "2025-12-16 17:25:31", "$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi", "buyer", "0", "5xEW22uxOH", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "1", NULL, NULL); INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `phone_verified`, `remember_token`, `created_at`, `updated_at`, `is_active`, `last_login_at`, `phone`) VALUES ("7", "Buyer 3", "buyer3@example.com", "2025-12-16 17:25:31", "$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi", "buyer", "0", "NeyObCd1Ph", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "1", NULL, NULL); INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `phone_verified`, `remember_token`, `created_at`, `updated_at`, `is_active`, `last_login_at`, `phone`) VALUES ("8", "Buyer 4", "buyer4@example.com", "2025-12-16 17:25:31", "$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi", "buyer", "0", "mW6gR0YMMb", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "1", NULL, NULL); INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `phone_verified`, `remember_token`, `created_at`, `updated_at`, `is_active`, `last_login_at`, `phone`) VALUES ("9", "Buyer 5", "buyer5@example.com", "2025-12-16 17:25:31", "$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi", "buyer", "0", "u9NMy3c0SS", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "1", NULL, NULL); INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `phone_verified`, `remember_token`, `created_at`, `updated_at`, `is_active`, `last_login_at`, `phone`) VALUES ("10", "Demo Seller", "seller@example.com", NULL, "$2y$12$XnOZys3FM81/jT4e2xAOC.dqQ1lihBqXdsgxrY/NixgdP87M8lcZC", "seller", "0", NULL, "2025-12-16 17:25:34", "2025-12-16 17:25:34", "1", NULL, NULL); INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `phone_verified`, `remember_token`, `created_at`, `updated_at`, `is_active`, `last_login_at`, `phone`) VALUES ("11", "Seller Testing 1", "sellerstesting1@gmail.com", NULL, "$2y$12$pUEa05KWloii814DAV5WL.Sc1WHVSKm6YavuiHZ5ebsAwkbProidG", "seller", "0", NULL, "2025-12-17 23:37:30", "2025-12-17 23:37:30", "1", NULL, NULL); -- Data for table `plans` -- TRUNCATE TABLE `plans`; INSERT INTO `plans` (`id`, `name`, `duration_days`, `product_limit`, `inquiry_limit`, `price_inr`, `price_usd`, `created_at`, `updated_at`, `can_view_phone`, `can_view_email`, `can_reply_inquiry`, `banner_limit`, `has_certificates`, `has_video`, `custom_page_limit`, `features`, `is_active`, `show_contact_details`, `view_buyer_contact`, `is_featured`, `has_verified_badge`, `allow_microsite`, `commission_rate`, `product_image_limit`) VALUES ("1", "Free Starter", "365", "5", "10", "0", "0", "2025-12-18 13:11:11", "2025-12-18 13:11:11", "0", "0", "0", "1", "0", "0", "0", "[\"Basic Support\",\"Limited Inquiries\"]", "1", "0", "0", "0", "0", "0", "10", "3"); INSERT INTO `plans` (`id`, `name`, `duration_days`, `product_limit`, `inquiry_limit`, `price_inr`, `price_usd`, `created_at`, `updated_at`, `can_view_phone`, `can_view_email`, `can_reply_inquiry`, `banner_limit`, `has_certificates`, `has_video`, `custom_page_limit`, `features`, `is_active`, `show_contact_details`, `view_buyer_contact`, `is_featured`, `has_verified_badge`, `allow_microsite`, `commission_rate`, `product_image_limit`) VALUES ("2", "Silver Growth", "365", "50", "100", "4999", "69", "2025-12-18 13:11:11", "2025-12-18 13:11:11", "0", "0", "0", "1", "0", "0", "0", "[\"Email Support\",\"Buyer Contact Access\"]", "1", "1", "1", "0", "0", "0", "5", "5"); INSERT INTO `plans` (`id`, `name`, `duration_days`, `product_limit`, `inquiry_limit`, `price_inr`, `price_usd`, `created_at`, `updated_at`, `can_view_phone`, `can_view_email`, `can_reply_inquiry`, `banner_limit`, `has_certificates`, `has_video`, `custom_page_limit`, `features`, `is_active`, `show_contact_details`, `view_buyer_contact`, `is_featured`, `has_verified_badge`, `allow_microsite`, `commission_rate`, `product_image_limit`) VALUES ("3", "Gold Pro", "365", "200", "500", "14999", "199", "2025-12-18 13:11:11", "2025-12-18 13:11:11", "0", "0", "0", "1", "0", "0", "0", "[\"Priority Support\",\"Verified Badge\",\"Featured Listings\"]", "1", "1", "1", "1", "1", "0", "2", "10"); INSERT INTO `plans` (`id`, `name`, `duration_days`, `product_limit`, `inquiry_limit`, `price_inr`, `price_usd`, `created_at`, `updated_at`, `can_view_phone`, `can_view_email`, `can_reply_inquiry`, `banner_limit`, `has_certificates`, `has_video`, `custom_page_limit`, `features`, `is_active`, `show_contact_details`, `view_buyer_contact`, `is_featured`, `has_verified_badge`, `allow_microsite`, `commission_rate`, `product_image_limit`) VALUES ("4", "Platinum Enterprise", "365", "10000", "10000", "49999", "599", "2025-12-18 13:11:11", "2025-12-18 13:11:11", "0", "0", "0", "1", "0", "0", "0", "[\"Dedicated Manager\",\"Microsite\",\"0% Commission\",\"Top Search Ranking\"]", "1", "1", "1", "1", "1", "1", "0", "20"); -- Data for table `subscriptions` -- TRUNCATE TABLE `subscriptions`; INSERT INTO `subscriptions` (`id`, `seller_id`, `plan_id`, `start_date`, `end_date`, `status`, `created_at`, `updated_at`, `payment_id`, `payment_method`) VALUES ("1", "1", "2", "2025-12-16 17:25:31", "2026-01-15 17:25:31", "active", "2025-12-16 17:25:31", "2025-12-16 17:25:31", NULL, "razorpay"); INSERT INTO `subscriptions` (`id`, `seller_id`, `plan_id`, `start_date`, `end_date`, `status`, `created_at`, `updated_at`, `payment_id`, `payment_method`) VALUES ("2", "2", "1", "2025-12-16 17:25:31", "2026-01-15 17:25:31", "active", "2025-12-16 17:25:31", "2025-12-16 17:25:31", NULL, "razorpay"); INSERT INTO `subscriptions` (`id`, `seller_id`, `plan_id`, `start_date`, `end_date`, `status`, `created_at`, `updated_at`, `payment_id`, `payment_method`) VALUES ("3", "3", "1", "2025-12-16 17:25:31", "2026-01-15 17:25:31", "active", "2025-12-16 17:25:31", "2025-12-16 17:25:31", NULL, "razorpay"); -- Data for table `sellers` -- TRUNCATE TABLE `sellers`; INSERT INTO `sellers` (`id`, `user_id`, `company_name`, `gst`, `iec`, `state`, `country`, `is_verified`, `subscription_id`, `created_at`, `updated_at`, `gst_doc`, `iec_doc`, `slug`, `logo`, `banner`, `about`, `social_links`, `address`, `city`, `pincode`, `business_type`, `establishment_year`, `bank_name`, `account_name`, `account_number`, `ifsc_code`, `branch_name`, `pan_no`, `pan_doc`, `cancelled_cheque_doc`, `theme_color`, `google_map_embed`, `moq_quantity`, `moq_unit_id`, `mobile`, `product_range`, `price_range_min`, `price_range_max`, `business_description`, `category_id`) VALUES ("1", "2", "Seller Company 1", "73HUIRT2921G6Z8", "5168166339", "Oklahoma", "India", "1", "1", "2025-12-16 17:25:31", "2025-12-16 17:25:31", NULL, NULL, "dickinson-ltd", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "#0d6efd", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `sellers` (`id`, `user_id`, `company_name`, `gst`, `iec`, `state`, `country`, `is_verified`, `subscription_id`, `created_at`, `updated_at`, `gst_doc`, `iec_doc`, `slug`, `logo`, `banner`, `about`, `social_links`, `address`, `city`, `pincode`, `business_type`, `establishment_year`, `bank_name`, `account_name`, `account_number`, `ifsc_code`, `branch_name`, `pan_no`, `pan_doc`, `cancelled_cheque_doc`, `theme_color`, `google_map_embed`, `moq_quantity`, `moq_unit_id`, `mobile`, `product_range`, `price_range_min`, `price_range_max`, `business_description`, `category_id`) VALUES ("2", "3", "Seller Company 2", "13PTELM6059COZK", "4751220928", "Ohio", "India", "0", "2", "2025-12-16 17:25:31", "2025-12-16 17:25:31", NULL, NULL, "nolan-buckridge-and-robel", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "#0d6efd", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `sellers` (`id`, `user_id`, `company_name`, `gst`, `iec`, `state`, `country`, `is_verified`, `subscription_id`, `created_at`, `updated_at`, `gst_doc`, `iec_doc`, `slug`, `logo`, `banner`, `about`, `social_links`, `address`, `city`, `pincode`, `business_type`, `establishment_year`, `bank_name`, `account_name`, `account_number`, `ifsc_code`, `branch_name`, `pan_no`, `pan_doc`, `cancelled_cheque_doc`, `theme_color`, `google_map_embed`, `moq_quantity`, `moq_unit_id`, `mobile`, `product_range`, `price_range_min`, `price_range_max`, `business_description`, `category_id`) VALUES ("3", "4", "Seller Company 3", "80LYYQA3270QBZA", "7845459495", "New Jersey", "India", "0", "3", "2025-12-16 17:25:31", "2025-12-16 17:25:31", NULL, NULL, "simonis-and-sons", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "#0d6efd", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `sellers` (`id`, `user_id`, `company_name`, `gst`, `iec`, `state`, `country`, `is_verified`, `subscription_id`, `created_at`, `updated_at`, `gst_doc`, `iec_doc`, `slug`, `logo`, `banner`, `about`, `social_links`, `address`, `city`, `pincode`, `business_type`, `establishment_year`, `bank_name`, `account_name`, `account_number`, `ifsc_code`, `branch_name`, `pan_no`, `pan_doc`, `cancelled_cheque_doc`, `theme_color`, `google_map_embed`, `moq_quantity`, `moq_unit_id`, `mobile`, `product_range`, `price_range_min`, `price_range_max`, `business_description`, `category_id`) VALUES ("4", "10", "Demo Global Traders", NULL, NULL, NULL, NULL, "1", NULL, "2025-12-16 17:25:34", "2025-12-16 21:23:29", NULL, NULL, "demo-global-traders-4", NULL, NULL, NULL, NULL, NULL, NULL, NULL, "Manufacturer", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "#0d6efd", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO `sellers` (`id`, `user_id`, `company_name`, `gst`, `iec`, `state`, `country`, `is_verified`, `subscription_id`, `created_at`, `updated_at`, `gst_doc`, `iec_doc`, `slug`, `logo`, `banner`, `about`, `social_links`, `address`, `city`, `pincode`, `business_type`, `establishment_year`, `bank_name`, `account_name`, `account_number`, `ifsc_code`, `branch_name`, `pan_no`, `pan_doc`, `cancelled_cheque_doc`, `theme_color`, `google_map_embed`, `moq_quantity`, `moq_unit_id`, `mobile`, `product_range`, `price_range_min`, `price_range_max`, `business_description`, `category_id`) VALUES ("5", "11", "Seller Testing 1 Company", NULL, NULL, NULL, "India", "0", NULL, "2025-12-17 23:37:30", "2025-12-17 23:37:40", NULL, NULL, "seller-testing-1-company", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, "Seller Testing 1", NULL, NULL, NULL, NULL, NULL, NULL, "#0d6efd", NULL, "149", "2", "1234567890", NULL, NULL, NULL, NULL, "2"); -- Data for table `buyers` -- TRUNCATE TABLE `buyers`; INSERT INTO `buyers` (`id`, `user_id`, `created_at`, `updated_at`) VALUES ("1", "5", "2025-12-16 17:25:31", "2025-12-16 17:25:31"); INSERT INTO `buyers` (`id`, `user_id`, `created_at`, `updated_at`) VALUES ("2", "6", "2025-12-16 17:25:31", "2025-12-16 17:25:31"); INSERT INTO `buyers` (`id`, `user_id`, `created_at`, `updated_at`) VALUES ("3", "7", "2025-12-16 17:25:31", "2025-12-16 17:25:31"); INSERT INTO `buyers` (`id`, `user_id`, `created_at`, `updated_at`) VALUES ("4", "8", "2025-12-16 17:25:31", "2025-12-16 17:25:31"); INSERT INTO `buyers` (`id`, `user_id`, `created_at`, `updated_at`) VALUES ("5", "9", "2025-12-16 17:25:31", "2025-12-16 17:25:31"); -- Data for table `categories` -- TRUNCATE TABLE `categories`; INSERT INTO `categories` (`id`, `name`, `slug`, `industries`, `created_at`, `updated_at`, `parent_id`, `image`, `is_active`, `is_featured`) VALUES ("1", "Agriculture", "agriculture", "Farming", "2025-12-16 17:25:30", "2025-12-16 17:25:30", NULL, NULL, "1", "0"); INSERT INTO `categories` (`id`, `name`, `slug`, `industries`, `created_at`, `updated_at`, `parent_id`, `image`, `is_active`, `is_featured`) VALUES ("2", "Chemicals", "chemicals", "Industrial", "2025-12-16 17:25:30", "2025-12-16 17:25:30", NULL, NULL, "1", "0"); INSERT INTO `categories` (`id`, `name`, `slug`, `industries`, `created_at`, `updated_at`, `parent_id`, `image`, `is_active`, `is_featured`) VALUES ("3", "Industrial", "industrial", "Manufacturing", "2025-12-16 17:25:30", "2025-12-16 17:25:32", NULL, "categories/industrial.jpg", "1", "1"); INSERT INTO `categories` (`id`, `name`, `slug`, `industries`, `created_at`, `updated_at`, `parent_id`, `image`, `is_active`, `is_featured`) VALUES ("4", "Electronics", "electronics", NULL, "2025-12-16 17:25:32", "2025-12-16 17:25:32", NULL, "categories/electronics.jpg", "1", "1"); INSERT INTO `categories` (`id`, `name`, `slug`, `industries`, `created_at`, `updated_at`, `parent_id`, `image`, `is_active`, `is_featured`) VALUES ("5", "Fashion", "fashion", NULL, "2025-12-16 17:25:32", "2025-12-16 17:25:32", NULL, "categories/fashion.jpg", "1", "1"); INSERT INTO `categories` (`id`, `name`, `slug`, `industries`, `created_at`, `updated_at`, `parent_id`, `image`, `is_active`, `is_featured`) VALUES ("6", "Home & Garden", "home-garden", NULL, "2025-12-16 17:25:32", "2025-12-16 17:25:32", NULL, "categories/home-garden.jpg", "1", "1"); INSERT INTO `categories` (`id`, `name`, `slug`, `industries`, `created_at`, `updated_at`, `parent_id`, `image`, `is_active`, `is_featured`) VALUES ("7", "Beauty & Health", "beauty-health", NULL, "2025-12-16 17:25:32", "2025-12-16 17:25:32", NULL, "categories/beauty-health.jpg", "1", "1"); INSERT INTO `categories` (`id`, `name`, `slug`, `industries`, `created_at`, `updated_at`, `parent_id`, `image`, `is_active`, `is_featured`) VALUES ("8", "Automotive", "automotive", NULL, "2025-12-16 17:25:32", "2025-12-16 17:25:32", NULL, "categories/automotive.jpg", "1", "1"); INSERT INTO `categories` (`id`, `name`, `slug`, `industries`, `created_at`, `updated_at`, `parent_id`, `image`, `is_active`, `is_featured`) VALUES ("9", "Sports", "sports", NULL, "2025-12-16 17:25:32", "2025-12-16 17:25:32", NULL, "categories/sports.jpg", "1", "1"); INSERT INTO `categories` (`id`, `name`, `slug`, `industries`, `created_at`, `updated_at`, `parent_id`, `image`, `is_active`, `is_featured`) VALUES ("10", "Toys & Hobbies", "toys-hobbies", NULL, "2025-12-16 17:25:33", "2025-12-16 21:57:05", NULL, "categories/1J6SGQUROG7eSJLubZLG2CBOPOqrzMYXXhjB0Q4X.jpg", "1", "1"); -- Data for table `products` -- TRUNCATE TABLE `products`; INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("1", "2", "2", "Product 1", "Nobis animi officia nostrum aut ea dolor sed. Delectus et optio voluptas sed. Eum sed ratione voluptatem sapiente doloremque aut. Labore dolorum amet tenetur reiciendis quod fugiat.", "691.99", "41", NULL, "1", "0", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "0", "aut-autem-tempora", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("2", "1", "3", "Product 2", "Quos eum nisi reiciendis consequuntur illo eum tenetur et. Soluta repellat laudantium iure eos magni aut.", "1539.09", "120", "[{\"original\":\"products\\/6943befb1d690_1766047483.webp\",\"thumbnail\":\"products\\/thumbnails\\/6943befb9a85d_1766047483.webp\"}]", "1", "0", "2025-12-16 17:25:31", "2025-12-18 14:14:44", "0", "mollitia-eligendi-quaerat", "[]", "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("3", "1", "3", "Product 3", "Asperiores voluptatem consequatur sequi quo sed nemo. Aut consequatur ea harum sint voluptas aspernatur.", "3289.85", "50", "[{\"original\":\"products\\/6943c511a23e4_1766049041.webp\",\"thumbnail\":\"products\\/thumbnails\\/6943c5123aaec_1766049042.webp\"}]", "1", "0", "2025-12-16 17:25:31", "2025-12-18 14:40:42", "0", "expedita-deserunt-ab", "[]", "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("4", "1", "3", "Product 4", "Impedit voluptatem voluptatem voluptatibus molestiae adipisci minus ut. Dignissimos cum non tempora voluptatem. Aut velit suscipit illum non optio ut officia molestiae.", "9617.66", "48", NULL, "1", "0", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "0", "nostrum-architecto-aliquid", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("5", "3", "2", "Product 5", "Earum reiciendis libero sunt voluptatem rerum saepe quis saepe. Iure repudiandae dolorem eos et corporis. Laborum eum iusto et quis est iusto qui.", "8346.78", "15", NULL, "0", "0", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "0", "et-impedit-ea", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("6", "2", "3", "Product 6", "Accusamus nemo distinctio sed sit tenetur et. Voluptatibus consequatur voluptas maxime nesciunt.", "7717.75", "50", NULL, "0", "0", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "0", "vel-fuga-sint", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("7", "1", "2", "Product 7", "Animi doloribus soluta et aut adipisci iure. Qui error dolor ut non. Ullam quo suscipit ea est consequatur enim saepe dolores. In veniam voluptatum impedit saepe ipsam iste.", "5823.68", "41", NULL, "0", "0", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "0", "eligendi-quia-in", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("8", "2", "3", "Product 8", "Nihil earum aut adipisci ipsum facilis quis. Ea consequatur qui quia veritatis sit incidunt velit. Quod debitis nulla voluptas vero quia.", "4707.42", "39", NULL, "0", "0", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "0", "magnam-eum-animi", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("9", "1", "3", "Product 9", "Adipisci sed inventore aut quas cupiditate. Optio autem et molestias quaerat. Ut labore odio sed culpa. Sed occaecati iste corporis et qui sint. Ipsa itaque aperiam non hic voluptate fuga ea.", "1725.28", "40", NULL, "0", "0", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "0", "dolore-hic-tempora", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("10", "1", "2", "Product 10", "Veritatis maiores et quam dolorem quis excepturi ex. Perspiciatis nisi corporis tenetur quis ut. Dignissimos doloremque laborum qui aut error nisi.", "359.96", "46", NULL, "0", "0", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "0", "ipsum-aut-in", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("11", "4", "4", "Wireless Noise Cancelling Headphones", "High quality Wireless Noise Cancelling Headphones available for bulk order. Contact for best prices.", "2500", "10", "\"[{\\\"thumbnail\\\":\\\"products\\\\\\/product_0.jpg\\\",\\\"original\\\":\\\"products\\\\\\/product_0.jpg\\\"}]\"", "1", "0", "2025-12-16 17:25:34", "2025-12-16 17:25:34", "0", "wireless-noise-cancelling-headphones", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("12", "4", "4", "Smart Watch Series 7", "High quality Smart Watch Series 7 available for bulk order. Contact for best prices.", "4500", "10", "\"[{\\\"thumbnail\\\":\\\"products\\\\\\/product_1.jpg\\\",\\\"original\\\":\\\"products\\\\\\/product_1.jpg\\\"}]\"", "1", "0", "2025-12-16 17:25:35", "2025-12-16 17:25:35", "0", "smart-watch-series-7", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("13", "4", "6", "Modern Sofa Set", "High quality Modern Sofa Set available for bulk order. Contact for best prices.", "25000", "10", "\"[{\\\"thumbnail\\\":\\\"products\\\\\\/product_2.jpg\\\",\\\"original\\\":\\\"products\\\\\\/product_2.jpg\\\"}]\"", "1", "0", "2025-12-16 17:25:35", "2025-12-16 17:25:35", "0", "modern-sofa-set", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("14", "4", "3", "Industrial Drilling Machine", "High quality Industrial Drilling Machine available for bulk order. Contact for best prices.", "15000", "10", "\"[{\\\"thumbnail\\\":\\\"products\\\\\\/product_3.jpg\\\",\\\"original\\\":\\\"products\\\\\\/product_3.jpg\\\"}]\"", "1", "0", "2025-12-16 17:25:36", "2025-12-16 17:25:36", "0", "industrial-drilling-machine", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("15", "4", "7", "Organic Face Serum", "High quality Organic Face Serum available for bulk order. Contact for best prices.", "800", "10", "\"[{\\\"thumbnail\\\":\\\"products\\\\\\/product_4.jpg\\\",\\\"original\\\":\\\"products\\\\\\/product_4.jpg\\\"}]\"", "0", "0", "2025-12-16 17:25:38", "2025-12-16 17:25:38", "0", "organic-face-serum", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("16", "4", "5", "Running Shoes Pro", "High quality Running Shoes Pro available for bulk order. Contact for best prices.", "3200", "10", "\"[{\\\"thumbnail\\\":\\\"products\\\\\\/product_5.jpg\\\",\\\"original\\\":\\\"products\\\\\\/product_5.jpg\\\"}]\"", "0", "0", "2025-12-16 17:25:39", "2025-12-16 17:25:39", "0", "running-shoes-pro", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("17", "4", "9", "Yoga Mat Premium", "High quality Yoga Mat Premium available for bulk order. Contact for best prices.", "1200", "250", "\"[{\\\"thumbnail\\\":\\\"products\\\\\\/product_6.jpg\\\",\\\"original\\\":\\\"products\\\\\\/product_6.jpg\\\"}]\"", "0", "0", "2025-12-16 17:25:40", "2025-12-18 13:30:26", "0", "yoga-mat-premium", NULL, "0", NULL, "0"); INSERT INTO `products` (`id`, `seller_id`, `category_id`, `name`, `description`, `price`, `moq`, `images_json`, `is_highlighted`, `plan_limit`, `created_at`, `updated_at`, `is_featured`, `slug`, `specifications`, `stock`, `keywords`, `is_approved`) VALUES ("18", "4", "10", "RC Drone with Camera", "High quality RC Drone with Camera available for bulk order. Contact for best prices.", "8500", "10", "\"[{\\\"thumbnail\\\":\\\"products\\\\\\/product_7.jpg\\\",\\\"original\\\":\\\"products\\\\\\/product_7.jpg\\\"}]\"", "0", "0", "2025-12-16 17:25:40", "2025-12-16 17:25:40", "0", "rc-drone-with-camera", NULL, "0", NULL, "0"); -- Data for table `rfqs` -- TRUNCATE TABLE `rfqs`; INSERT INTO `rfqs` (`id`, `buyer_id`, `title`, `description`, `budget`, `status`, `created_at`, `updated_at`, `quantity`, `delivery_location`, `file_path`, `category_id`) VALUES ("1", "1", "Need Agriculture Supplies", "Looking for high quality Agriculture products in bulk. Please quote best price.", NULL, "open", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "727 Units", "Mumbai, India", NULL, "1"); INSERT INTO `rfqs` (`id`, `buyer_id`, `title`, `description`, `budget`, `status`, `created_at`, `updated_at`, `quantity`, `delivery_location`, `file_path`, `category_id`) VALUES ("2", "2", "Need Industrial Supplies", "Looking for high quality Industrial products in bulk. Please quote best price.", NULL, "open", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "691 Units", "Mumbai, India", NULL, "3"); INSERT INTO `rfqs` (`id`, `buyer_id`, `title`, `description`, `budget`, `status`, `created_at`, `updated_at`, `quantity`, `delivery_location`, `file_path`, `category_id`) VALUES ("3", "5", "Need Chemicals Supplies", "Looking for high quality Chemicals products in bulk. Please quote best price.", NULL, "open", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "891 Units", "Mumbai, India", NULL, "2"); INSERT INTO `rfqs` (`id`, `buyer_id`, `title`, `description`, `budget`, `status`, `created_at`, `updated_at`, `quantity`, `delivery_location`, `file_path`, `category_id`) VALUES ("4", "2", "Need Chemicals Supplies", "Looking for high quality Chemicals products in bulk. Please quote best price.", NULL, "open", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "626 Units", "Mumbai, India", NULL, "2"); INSERT INTO `rfqs` (`id`, `buyer_id`, `title`, `description`, `budget`, `status`, `created_at`, `updated_at`, `quantity`, `delivery_location`, `file_path`, `category_id`) VALUES ("5", "4", "Need Agriculture Supplies", "Looking for high quality Agriculture products in bulk. Please quote best price.", NULL, "open", "2025-12-16 17:25:31", "2025-12-16 17:25:31", "605 Units", "Mumbai, India", NULL, "1"); -- Data for table `banners` -- TRUNCATE TABLE `banners`; INSERT INTO `banners` (`id`, `image`, `position`, `link`, `active`, `created_at`, `updated_at`, `seller_id`, `is_approved`, `type`, `title`, `description`) VALUES ("7", "banners/slider_1.jpg", "home_top", "#", "1", "2025-12-16 18:02:51", "2025-12-16 18:02:51", NULL, "0", "standard", NULL, NULL); INSERT INTO `banners` (`id`, `image`, `position`, `link`, `active`, `created_at`, `updated_at`, `seller_id`, `is_approved`, `type`, `title`, `description`) VALUES ("8", "banners/slider_2.jpg", "home_top", "#", "1", "2025-12-16 18:02:51", "2025-12-16 18:02:51", NULL, "0", "standard", NULL, NULL); INSERT INTO `banners` (`id`, `image`, `position`, `link`, `active`, `created_at`, `updated_at`, `seller_id`, `is_approved`, `type`, `title`, `description`) VALUES ("9", "banners/slider_3.jpg", "home_top", "#", "1", "2025-12-16 18:02:51", "2025-12-16 18:02:51", NULL, "0", "standard", NULL, NULL); INSERT INTO `banners` (`id`, `image`, `position`, `link`, `active`, `created_at`, `updated_at`, `seller_id`, `is_approved`, `type`, `title`, `description`) VALUES ("10", "banners/694172483e3dc_1765896776.webp", "home_top_right_1", NULL, "1", "2025-12-16 20:22:56", "2025-12-16 20:22:56", NULL, "0", "standard", NULL, NULL); INSERT INTO `banners` (`id`, `image`, `position`, `link`, `active`, `created_at`, `updated_at`, `seller_id`, `is_approved`, `type`, `title`, `description`) VALUES ("11", "banners/6941725d496f7_1765896797.webp", "home_top_right_2", NULL, "1", "2025-12-16 20:23:17", "2025-12-16 20:23:17", NULL, "0", "standard", NULL, NULL); -- Data for table `analytics` -- TRUNCATE TABLE `analytics`; INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("1", "1", "product_view", "2", NULL, "127.0.0.1", "2025-12-16 17:58:39", "2025-12-16 17:58:39"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("2", "4", "product_view", "11", NULL, "127.0.0.1", "2025-12-16 21:07:52", "2025-12-16 21:07:52"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("3", "4", "product_view", "11", NULL, "127.0.0.1", "2025-12-16 21:13:48", "2025-12-16 21:13:48"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("4", "4", "product_view", "11", NULL, "127.0.0.1", "2025-12-16 21:24:58", "2025-12-16 21:24:58"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("5", "4", "product_view", "11", NULL, "127.0.0.1", "2025-12-16 21:25:14", "2025-12-16 21:25:14"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("6", "2", "product_view", "1", NULL, "127.0.0.1", "2025-12-16 21:25:33", "2025-12-16 21:25:33"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("7", "4", "product_view", "11", NULL, "127.0.0.1", "2025-12-16 21:25:43", "2025-12-16 21:25:43"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("8", "1", "product_view", "3", NULL, "127.0.0.1", "2025-12-16 21:43:31", "2025-12-16 21:43:31"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("9", "4", "product_view", "11", NULL, "127.0.0.1", "2025-12-16 21:43:38", "2025-12-16 21:43:38"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("10", "4", "product_view", "11", NULL, "127.0.0.1", "2025-12-16 21:43:42", "2025-12-16 21:43:42"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("11", "4", "product_view", "18", NULL, "127.0.0.1", "2025-12-16 21:57:51", "2025-12-16 21:57:51"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("12", "4", "product_view", "18", NULL, "127.0.0.1", "2025-12-16 22:04:19", "2025-12-16 22:04:19"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("13", "4", "product_view", "18", NULL, "127.0.0.1", "2025-12-16 22:09:44", "2025-12-16 22:09:44"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("14", "4", "product_view", "14", NULL, "127.0.0.1", "2025-12-16 22:19:32", "2025-12-16 22:19:32"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("15", "1", "product_view", "2", NULL, "127.0.0.1", "2025-12-18 14:15:55", "2025-12-18 14:15:55"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("16", "1", "product_view", "2", NULL, "127.0.0.1", "2025-12-18 14:33:07", "2025-12-18 14:33:07"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("17", "1", "product_view", "2", NULL, "127.0.0.1", "2025-12-18 14:38:19", "2025-12-18 14:38:19"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("18", "1", "product_view", "2", NULL, "127.0.0.1", "2025-12-18 14:38:49", "2025-12-18 14:38:49"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("19", "1", "product_view", "3", NULL, "127.0.0.1", "2025-12-18 14:41:00", "2025-12-18 14:41:00"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("20", "1", "product_view", "3", NULL, "127.0.0.1", "2025-12-18 14:54:18", "2025-12-18 14:54:18"); INSERT INTO `analytics` (`id`, `seller_id`, `type`, `source_id`, `country`, `ip_address`, `created_at`, `updated_at`) VALUES ("21", "1", "product_view", "3", NULL, "127.0.0.1", "2025-12-18 16:33:54", "2025-12-18 16:33:54"); -- Data for table `microsite_settings` -- TRUNCATE TABLE `microsite_settings`; INSERT INTO `microsite_settings` (`id`, `seller_id`, `tagline`, `cta_text`, `cta_link`, `show_stats`, `years_in_business`, `happy_clients`, `products_sold`, `show_about`, `show_products`, `show_certificates`, `show_testimonials`, `show_faq`, `show_video`, `show_contact`, `video_url`, `video_title`, `brochure_path`, `page_views`, `inquiry_count`, `meta_title`, `meta_description`, `meta_keywords`, `created_at`, `updated_at`) VALUES ("1", "4", "Quality Products & Services", "Contact Us", NULL, "1", "0", "100", "8", "1", "1", "1", "1", "1", "0", "1", NULL, NULL, NULL, "4", "0", NULL, NULL, NULL, "2025-12-16 22:19:51", "2025-12-18 23:17:56"); INSERT INTO `microsite_settings` (`id`, `seller_id`, `tagline`, `cta_text`, `cta_link`, `show_stats`, `years_in_business`, `happy_clients`, `products_sold`, `show_about`, `show_products`, `show_certificates`, `show_testimonials`, `show_faq`, `show_video`, `show_contact`, `video_url`, `video_title`, `brochure_path`, `page_views`, `inquiry_count`, `meta_title`, `meta_description`, `meta_keywords`, `created_at`, `updated_at`) VALUES ("2", "5", "Quality Products & Services", "Contact Us", NULL, "1", "0", "100", "0", "1", "1", "1", "1", "1", "0", "1", NULL, NULL, NULL, "0", "0", NULL, NULL, NULL, "2025-12-17 23:37:32", "2025-12-17 23:37:32"); INSERT INTO `microsite_settings` (`id`, `seller_id`, `tagline`, `cta_text`, `cta_link`, `show_stats`, `years_in_business`, `happy_clients`, `products_sold`, `show_about`, `show_products`, `show_certificates`, `show_testimonials`, `show_faq`, `show_video`, `show_contact`, `video_url`, `video_title`, `brochure_path`, `page_views`, `inquiry_count`, `meta_title`, `meta_description`, `meta_keywords`, `created_at`, `updated_at`) VALUES ("3", "1", "Quality Products & Services", "Contact Us", NULL, "1", "0", "100", "6", "1", "1", "1", "1", "1", "0", "1", NULL, NULL, NULL, "3", "0", NULL, NULL, NULL, "2025-12-18 13:59:56", "2025-12-18 14:40:52"); -- Data for table `roles` -- TRUNCATE TABLE `roles`; INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ("1", "admin", "web", "2025-12-16 17:25:30", "2025-12-16 17:25:30"); INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ("2", "seller", "web", "2025-12-16 17:25:30", "2025-12-16 17:25:30"); INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES ("3", "buyer", "web", "2025-12-16 17:25:30", "2025-12-16 17:25:30"); -- Data for table `model_has_roles` -- TRUNCATE TABLE `model_has_roles`; INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ("1", "App\\Models\\User", "1"); INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ("2", "App\\Models\\User", "2"); INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ("2", "App\\Models\\User", "3"); INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ("2", "App\\Models\\User", "4"); INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ("3", "App\\Models\\User", "5"); INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ("3", "App\\Models\\User", "6"); INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ("3", "App\\Models\\User", "7"); INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ("3", "App\\Models\\User", "8"); INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES ("3", "App\\Models\\User", "9"); -- Data for table `settings` -- TRUNCATE TABLE `settings`; INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("1", "razorpay_key", NULL, "payment", "text", "Razorpay Key ID", "2025-12-16 17:25:27", "2025-12-17 23:51:17"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("2", "razorpay_secret", NULL, "payment", "text", "Razorpay Key Secret", "2025-12-16 17:25:27", "2025-12-17 23:51:17"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("3", "paypal_client_id", NULL, "payment", "text", "PayPal Client ID", "2025-12-16 17:25:27", "2025-12-17 23:51:17"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("4", "paypal_secret", NULL, "payment", "text", "PayPal Secret", "2025-12-16 17:25:27", "2025-12-17 23:51:17"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("5", "paypal_mode", "sandbox", "payment", "select", "PayPal Mode", "2025-12-16 17:25:27", "2025-12-16 17:25:27"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("6", "registration_moq_min", "10", "general", "text", "Registration Min MOQ", "2025-12-17 23:42:18", "2025-12-18 22:34:10"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("7", "registration_moq_max", "150", "general", "text", "Registration Max MOQ", "2025-12-17 23:42:18", "2025-12-18 22:34:10"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("8", "site_name", "The Mini Port", "general", "text", "Site Name", "2025-12-17 23:43:40", "2025-12-17 23:43:40"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("9", "site_logo", NULL, "general", "image", "Site Logo", "2025-12-17 23:43:40", "2025-12-17 23:43:40"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("10", "footer_text", "© 2024 The Mini Port. All rights reserved.", "general", "textarea", "Footer Text", "2025-12-17 23:43:40", "2025-12-17 23:43:40"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("11", "home_stat_products_count", "10000+", "home", "text", "Products Count", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("12", "home_stat_products_label", "Products", "home", "text", "Products Label", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("13", "home_stat_suppliers_count", "500+", "home", "text", "Verified Suppliers Count", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("14", "home_stat_suppliers_label", "Verified Suppliers", "home", "text", "Verified Suppliers Label", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("15", "home_stat_buyers_count", "2000+", "home", "text", "Active Buyers Count", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("16", "home_stat_buyers_label", "Active Buyers", "home", "text", "Active Buyers Label", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("17", "home_stat_support_count", "24/7", "home", "text", "Support Availability", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("18", "home_stat_support_label", "Support", "home", "text", "Support Label", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("19", "home_show_trending", "1", "home", "boolean", "Show Trending Products Section", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("20", "social_facebook", "https://facebook.com", "social", "text", "Facebook URL", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("21", "social_twitter", "https://twitter.com", "social", "text", "Twitter URL", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("22", "social_instagram", "https://instagram.com", "social", "text", "Instagram URL", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("23", "social_linkedin", "https://linkedin.com", "social", "text", "LinkedIn URL", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("24", "social_youtube", "https://youtube.com", "social", "text", "YouTube URL", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("25", "seo_meta_title", "The Mini Port - Global B2B Marketplace", "seo", "text", "Default Meta Title", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("26", "seo_meta_description", "Connect with top suppliers and buyers on The Mini Port, the leading global B2B marketplace.", "seo", "textarea", "Default Meta Description", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("27", "seo_meta_keywords", "b2b, marketplace, suppliers, buyers, trade, export, import", "seo", "textarea", "Default Meta Keywords", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("28", "scripts_header", "", "scripts", "textarea", "Header Scripts", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("29", "scripts_footer", "", "scripts", "textarea", "Footer Scripts", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("30", "mail_mailer", "smtp", "email", "text", "Mailer", "2025-12-17 23:49:03", "2025-12-18 21:56:44"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("31", "mail_host", "smtp.mailtrap.io", "email", "text", "Mail Host", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("32", "mail_port", "2525", "email", "text", "Mail Port", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("33", "mail_username", NULL, "email", "text", "Mail Username", "2025-12-17 23:49:03", "2025-12-18 22:34:10"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("34", "mail_password", NULL, "email", "text", "Mail Password", "2025-12-17 23:49:03", "2025-12-18 22:34:10"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("35", "mail_encryption", "tls", "email", "text", "Mail Encryption", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("36", "mail_from_address", "admin@theminiport.com", "email", "text", "From Address", "2025-12-17 23:49:03", "2025-12-18 21:56:45"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("37", "mail_from_name", "The Mini Port", "email", "text", "From Name", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("38", "payment_gateway_mode", "sandbox", "payment", "select", "Gateway Mode", "2025-12-17 23:49:03", "2025-12-17 23:49:03"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("39", "stripe_key", NULL, "payment", "text", "Stripe Publishable Key", "2025-12-17 23:49:03", "2025-12-17 23:51:17"); INSERT INTO `settings` (`id`, `key`, `value`, `group`, `type`, `label`, `created_at`, `updated_at`) VALUES ("40", "stripe_secret", NULL, "payment", "text", "Stripe Secret Key", "2025-12-17 23:49:03", "2025-12-17 23:51:18"); -- Data for table `units` -- TRUNCATE TABLE `units`; INSERT INTO `units` (`id`, `name`, `code`, `is_active`, `created_at`, `updated_at`) VALUES ("1", "Pieces", "pcs", "1", "2025-12-16 17:25:27", "2025-12-16 17:25:27"); INSERT INTO `units` (`id`, `name`, `code`, `is_active`, `created_at`, `updated_at`) VALUES ("2", "Kilograms", "kg", "1", "2025-12-16 17:25:27", "2025-12-16 17:25:27"); INSERT INTO `units` (`id`, `name`, `code`, `is_active`, `created_at`, `updated_at`) VALUES ("3", "Tons", "tons", "1", "2025-12-16 17:25:27", "2025-12-16 17:25:27"); INSERT INTO `units` (`id`, `name`, `code`, `is_active`, `created_at`, `updated_at`) VALUES ("4", "Liters", "ltr", "1", "2025-12-16 17:25:27", "2025-12-16 17:25:27"); INSERT INTO `units` (`id`, `name`, `code`, `is_active`, `created_at`, `updated_at`) VALUES ("5", "Boxes", "box", "1", "2025-12-16 17:25:27", "2025-12-16 17:25:27"); INSERT INTO `units` (`id`, `name`, `code`, `is_active`, `created_at`, `updated_at`) VALUES ("6", "Dozens", "doz", "1", "2025-12-16 17:25:27", "2025-12-16 17:25:27"); INSERT INTO `units` (`id`, `name`, `code`, `is_active`, `created_at`, `updated_at`) VALUES ("7", "Sets", "set", "1", "2025-12-16 17:25:27", "2025-12-16 17:25:27"); INSERT INTO `units` (`id`, `name`, `code`, `is_active`, `created_at`, `updated_at`) VALUES ("8", "Meters", "mtr", "1", "2025-12-16 17:25:27", "2025-12-16 17:25:27"); INSERT INTO `units` (`id`, `name`, `code`, `is_active`, `created_at`, `updated_at`) VALUES ("9", "Grams", "g", "1", "2025-12-16 22:31:24", "2025-12-16 22:31:24"); -- Data for table `email_templates` -- TRUNCATE TABLE `email_templates`; INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("1", "seller-welcome", "Seller Welcome Email", "Welcome to The Mini Port - Start Selling Today!", "

Hi {{name}},

Welcome to The Mini Port! We are excited to have you on board.

You can now list your products and reach thousands of buyers.

", "[\"name\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("2", "admin-new-seller", "Admin - New Seller Notification", "New Seller Registration: {{company_name}}", "

A new seller has registered.

Name: {{name}}
Company: {{company_name}}
Email: {{email}}

", "[\"name\",\"company_name\",\"email\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("3", "buyer-welcome", "Buyer Welcome Email", "Welcome to The Mini Port!", "

Hi {{name}},

Thanks for joining The Mini Port. You can now post RFQs and contact suppliers directly.

", "[\"name\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("4", "seller-profile-updated", "Seller Profile Updated Alert", "Security Alert: Profile Updated", "

Hi {{name}},

Your seller profile was updated on {{updated_at}}. If this wasn\'t you, please contact support immediately.

", "[\"name\",\"updated_at\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("5", "seller-verified", "Seller KYC Verified", "Congratulations! Your Account is Verified", "

Hi {{name}},

Your KYC documents have been approved. You are now a Verified Supplier on The Mini Port.

", "[\"name\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("6", "kyc-rejected", "Seller KYC Rejected", "Action Required: KYC Document Rejected", "

Hi {{name}},

Your KYC document ({{document_type}}) was rejected.

Reason: {{reason}}

Please upload a valid document.

", "[\"name\",\"document_type\",\"reason\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("7", "seller-rejected", "Seller Account Rejected", "Account Application Status", "

Hi {{name}},

Your seller application has been rejected.

Reason: {{reason}}

", "[\"name\",\"reason\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("8", "product-approved", "Product Approved", "Your Product is Live: {{product_name}}", "

Hi {{name}},

Great news! Your product \"{{product_name}}\" has been approved and is now live on the marketplace.

", "[\"name\",\"product_name\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("9", "product-rejected", "Product Rejected", "Action Required: Product Rejected", "

Hi {{name}},

Your product \"{{product_name}}\" was rejected.

Reason: {{reason}}

Please edit and resubmit.

", "[\"name\",\"product_name\",\"reason\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("10", "subscription-activated", "Subscription Activated", "Subscription Active: {{plan_name}}", "

Hi {{name}},

Your subscription for {{plan_name}} is now active.

Valid until: {{end_date}}

", "[\"name\",\"plan_name\",\"end_date\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("11", "promotion-activated", "Promotion Activated", "Promotion Active: {{package_name}}", "

Hi {{name}},

Your promotion package {{package_name}} is now active for {{product_count}} products.

", "[\"name\",\"package_name\",\"product_count\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("12", "subscription-expiring", "Subscription Expiring Soon", "Reminder: Subscription Expiring in {{days}} Days", "

Hi {{name}},

Your {{plan_name}} subscription will expire in {{days}} days. Renew now to avoid losing benefits.

", "[\"name\",\"plan_name\",\"days\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("13", "subscription-expired", "Subscription Expired", "Alert: Subscription Expired", "

Hi {{name}},

Your {{plan_name}} subscription has expired. Please renew to continue using premium features.

", "[\"name\",\"plan_name\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("14", "rfq-posted-confirmation", "RFQ Posted Confirmation", "RFQ Received: {{rfq_title}}", "

Hi {{name}},

We have received your Buy Lead \"{{rfq_title}}\". It is under review and will be live shortly.

", "[\"name\",\"rfq_title\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("15", "admin-new-rfq", "Admin - New RFQ Alert", "New RFQ Posted: {{rfq_title}}", "

A new RFQ has been posted.

Title: {{rfq_title}}
Buyer: {{buyer_name}}

", "[\"rfq_title\",\"buyer_name\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("16", "new-rfq-notification", "New RFQ Match for Seller", "New Lead Matching Your Category: {{rfq_title}}", "

Hi {{name}},

A new buy lead matches your products.

{{rfq_title}}

View Lead

", "[\"name\",\"rfq_title\",\"link\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("17", "new-inquiry-received", "New Inquiry Received", "New Inquiry from {{buyer_name}}", "

Hi {{seller_name}},

You have received a new inquiry for {{product_name}}.

Buyer: {{buyer_name}}
Message: {{message}}

", "[\"seller_name\",\"buyer_name\",\"product_name\",\"message\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("18", "inquiry-confirmation", "Inquiry Sent Confirmation", "Inquiry Sent to {{seller_company}}", "

Hi {{name}},

Your inquiry for {{product_name}} has been sent to {{seller_company}}.

", "[\"name\",\"product_name\",\"seller_company\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("19", "quote-submitted", "Quote Submitted", "New Quote Received for {{rfq_title}}", "

Hi {{buyer_name}},

{{seller_company}} has sent a quote for your requirement.

Price: {{price}}

View Quote

", "[\"buyer_name\",\"seller_company\",\"rfq_title\",\"price\",\"link\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("20", "quote-revised", "Quote Revised", "Quote Revised: {{rfq_title}}", "

Hi {{buyer_name}},

{{seller_company}} has revised their quote.

New Price: {{price}}

View Quote

", "[\"buyer_name\",\"seller_company\",\"rfq_title\",\"price\",\"link\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("21", "quote-accepted", "Quote Accepted", "Congratulations! Quote Accepted for {{rfq_title}}", "

Hi {{seller_name}},

Your quote for {{rfq_title}} has been accepted by the buyer.

", "[\"seller_name\",\"rfq_title\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("22", "quote-rejected", "Quote Rejected", "Update on your Quote for {{rfq_title}}", "

Hi {{seller_name}},

Your quote for {{rfq_title}} was not selected by the buyer.

", "[\"seller_name\",\"rfq_title\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); INSERT INTO `email_templates` (`id`, `slug`, `name`, `subject`, `body`, `variables`, `created_at`, `updated_at`, `is_active`) VALUES ("23", "payment-failed", "Payment Failed", "Action Required: Payment Failed", "

Hi {{name}},

Your payment of {{amount}} for {{description}} has failed.

Reason: {{reason}}

", "[\"name\",\"amount\",\"description\",\"reason\"]", "2025-12-18 21:51:57", "2025-12-18 21:51:57", "1"); -- Data for table `promotion_settings` -- TRUNCATE TABLE `promotion_settings`; INSERT INTO `promotion_settings` (`id`, `setting_key`, `setting_value`, `setting_type`, `description`, `created_at`, `updated_at`) VALUES ("1", "razorpay_enabled", "true", "boolean", "Enable/Disable Razorpay Payment Gateway", "2025-12-16 17:25:30", "2025-12-16 17:25:30"); INSERT INTO `promotion_settings` (`id`, `setting_key`, `setting_value`, `setting_type`, `description`, `created_at`, `updated_at`) VALUES ("2", "razorpay_key", "", "string", "Razorpay API Key", "2025-12-16 17:25:30", "2025-12-16 17:25:30"); INSERT INTO `promotion_settings` (`id`, `setting_key`, `setting_value`, `setting_type`, `description`, `created_at`, `updated_at`) VALUES ("3", "razorpay_secret", "", "string", "Razorpay API Secret", "2025-12-16 17:25:30", "2025-12-16 17:25:30"); INSERT INTO `promotion_settings` (`id`, `setting_key`, `setting_value`, `setting_type`, `description`, `created_at`, `updated_at`) VALUES ("4", "paypal_enabled", "false", "boolean", "Enable/Disable PayPal Payment Gateway", "2025-12-16 17:25:30", "2025-12-16 17:25:30"); INSERT INTO `promotion_settings` (`id`, `setting_key`, `setting_value`, `setting_type`, `description`, `created_at`, `updated_at`) VALUES ("5", "paypal_client_id", "", "string", "PayPal Client ID", "2025-12-16 17:25:30", "2025-12-16 17:25:30"); INSERT INTO `promotion_settings` (`id`, `setting_key`, `setting_value`, `setting_type`, `description`, `created_at`, `updated_at`) VALUES ("6", "paypal_secret", "", "string", "PayPal Secret", "2025-12-16 17:25:30", "2025-12-16 17:25:30"); INSERT INTO `promotion_settings` (`id`, `setting_key`, `setting_value`, `setting_type`, `description`, `created_at`, `updated_at`) VALUES ("7", "manual_payment_enabled", "true", "boolean", "Enable/Disable Manual Payment (Bank Transfer)", "2025-12-16 17:25:30", "2025-12-16 17:25:30"); INSERT INTO `promotion_settings` (`id`, `setting_key`, `setting_value`, `setting_type`, `description`, `created_at`, `updated_at`) VALUES ("8", "manual_payment_instructions", "Bank Name: Example Bank Account Name: The Mini Port Account Number: 1234567890 IFSC: EXMP0001234", "string", "Instructions for Manual Payment", "2025-12-16 17:25:30", "2025-12-16 17:25:30"); -- Data for table `promotion_packages` -- TRUNCATE TABLE `promotion_packages`; INSERT INTO `promotion_packages` (`id`, `name`, `description`, `price`, `duration_days`, `page_position`, `max_products`, `priority_level`, `badge_text`, `badge_color`, `is_active`, `created_at`, `updated_at`) VALUES ("1", "Basic Boost", "Get noticed with a budget-friendly boost. Your product appears on Page 2.", "499", "7", "2", "1", "3", "Boosted", "#17a2b8", "1", "2025-12-18 21:38:58", "2025-12-18 21:38:58"); INSERT INTO `promotion_packages` (`id`, `name`, `description`, `price`, `duration_days`, `page_position`, `max_products`, `priority_level`, `badge_text`, `badge_color`, `is_active`, `created_at`, `updated_at`) VALUES ("2", "Standard Visibility", "Increase your reach significantly. Your product appears on Page 1.", "999", "15", "1", "2", "5", "Featured", "#0d6efd", "1", "2025-12-18 21:38:58", "2025-12-18 21:38:58"); INSERT INTO `promotion_packages` (`id`, `name`, `description`, `price`, `duration_days`, `page_position`, `max_products`, `priority_level`, `badge_text`, `badge_color`, `is_active`, `created_at`, `updated_at`) VALUES ("3", "Premium Spotlight", "Dominate the listings with high priority placement on Page 1.", "1999", "30", "1", "5", "8", "Premium", "#ffc107", "1", "2025-12-18 21:38:58", "2025-12-18 21:38:58"); INSERT INTO `promotion_packages` (`id`, `name`, `description`, `price`, `duration_days`, `page_position`, `max_products`, `priority_level`, `badge_text`, `badge_color`, `is_active`, `created_at`, `updated_at`) VALUES ("4", "Ultimate Domination", "Maximum visibility. Top of Page 1 guaranteed with highest priority.", "4999", "30", "1", "10", "10", "Top Choice", "#dc3545", "1", "2025-12-18 21:38:58", "2025-12-18 21:38:58"); SET FOREIGN_KEY_CHECKS=1;