-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: May 25, 2026 at 01:28 AM -- Server version: 10.6.24-MariaDB-cll-lve -- PHP Version: 8.4.21 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `handloandb` -- -- -------------------------------------------------------- -- -- Table structure for table `addresses` -- CREATE TABLE `addresses` ( `id` bigint(20) UNSIGNED NOT NULL, `customer_id` bigint(20) UNSIGNED NOT NULL, `address_line1` varchar(255) NOT NULL, `address_line2` varchar(255) DEFAULT NULL, `city` varchar(255) NOT NULL, `state` varchar(255) NOT NULL, `pincode` varchar(255) NOT NULL, `country` varchar(255) NOT NULL DEFAULT 'India', `type` enum('home','work','other') NOT NULL DEFAULT 'home', `is_default` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `addresses` -- INSERT INTO `addresses` (`id`, `customer_id`, `address_line1`, `address_line2`, `city`, `state`, `pincode`, `country`, `type`, `is_default`, `created_at`, `updated_at`) VALUES (1, 1, 'test1', 'test2', 'test city2', 'test state2', '222226', 'India', 'work', 0, '2025-09-09 22:09:17', '2025-09-09 23:01:59'), (2, 1, 'test1', 'test2', 'test city2', 'test state2', '222226', 'India', 'home', 1, '2025-09-09 22:30:57', '2025-09-09 23:01:59'); -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `carousels` -- CREATE TABLE `carousels` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) DEFAULT NULL, `subtitle` varchar(255) DEFAULT NULL, `image` varchar(255) NOT NULL, `active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `carousels` -- INSERT INTO `carousels` (`id`, `title`, `subtitle`, `image`, `active`, `created_at`, `updated_at`) VALUES (4, 'test3', 'test3', 'carousels/1760617371_fashionapparel-design-college-major1624972214.jpg', 1, '2025-10-16 19:22:51', '2025-10-16 19:22:51'), (5, 'test4', 'test4', 'carousels/1760617664_fashion-design-workshop1718956444.jpg', 1, '2025-10-16 19:27:44', '2025-10-16 19:27:44'); -- -------------------------------------------------------- -- -- Table structure for table `carts` -- CREATE TABLE `carts` ( `id` bigint(20) UNSIGNED NOT NULL, `customer_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cart_items` -- CREATE TABLE `cart_items` ( `id` bigint(20) UNSIGNED NOT NULL, `cart_id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) UNSIGNED NOT NULL, `quantity` int(11) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `image` varchar(255) DEFAULT NULL, `product_count` int(10) UNSIGNED NOT NULL DEFAULT 0, `status` enum('active','blocked') NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `name`, `image`, `product_count`, `status`, `created_at`, `updated_at`) VALUES (1, 'Activewears', 'category/1773127939_activewear10.jpg', 0, 'active', '2025-08-29 08:58:35', '2026-03-10 14:32:19'), (2, 'Shoes', 'category/1756478159_shoes.jpeg', 0, 'active', '2025-08-29 09:05:59', '2025-08-29 09:05:59'), (3, 'Gym & Fitness', 'category/1756478203_fitness.jpeg', 0, 'active', '2025-08-29 09:06:43', '2025-08-29 09:06:43'), (4, 'Hiking & Trekking', 'category/1756478357_bags.jpeg', 0, 'active', '2025-08-29 09:09:17', '2025-08-29 09:09:17'), (5, 'Cycles', 'category/1756478409_cat-5.jpg', 0, 'active', '2025-08-29 09:10:09', '2025-08-29 09:10:09'), (6, 'Swimming', 'category/1756478442_swimming.jpg', 0, 'active', '2025-08-29 09:10:42', '2025-08-29 09:10:42'), (7, 'Bags & Backpacks', 'category/1756478519_backpack.jpg', 0, 'active', '2025-08-29 09:11:59', '2025-08-29 09:11:59'), (8, 'Accessories', 'category/1756478609_cat-6.jpg', 0, 'active', '2025-08-29 09:13:29', '2025-08-29 09:13:29'); -- -------------------------------------------------------- -- -- Table structure for table `colors` -- CREATE TABLE `colors` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `colors` -- INSERT INTO `colors` (`id`, `name`, `created_at`, `updated_at`) VALUES (1, 'Black', NULL, NULL), (2, 'White', NULL, NULL), (3, 'Red', NULL, NULL), (4, 'Blue', NULL, NULL), (5, 'Green', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `coupons` -- CREATE TABLE `coupons` ( `id` bigint(20) UNSIGNED NOT NULL, `code` varchar(255) NOT NULL, `type` enum('flat','percentage') NOT NULL, `value` decimal(10,2) NOT NULL, `min_cart_amount` decimal(10,2) NOT NULL DEFAULT 0.00, `max_discount` decimal(10,2) DEFAULT NULL, `usage_limit` int(11) DEFAULT NULL, `per_user_limit` int(11) DEFAULT NULL, `start_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `coupons` -- INSERT INTO `coupons` (`id`, `code`, `type`, `value`, `min_cart_amount`, `max_discount`, `usage_limit`, `per_user_limit`, `start_date`, `end_date`, `status`, `created_at`, `updated_at`) VALUES (2, 'TEST10', 'flat', 100.00, 1000.00, 100.00, 2, 2, '2025-09-14 00:00:00', '2025-09-18 00:00:00', 1, '2025-09-13 16:03:29', '2025-09-13 16:04:14'); -- -------------------------------------------------------- -- -- Table structure for table `customers` -- CREATE TABLE `customers` ( `id` bigint(20) UNSIGNED NOT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) DEFAULT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `dob` date DEFAULT NULL, `gender` enum('male','female','other') DEFAULT NULL, `profile_image` varchar(255) DEFAULT NULL, `status` enum('active','inactive','blocked') NOT NULL DEFAULT 'active', `wallet_balance` decimal(12,2) NOT NULL DEFAULT 0.00, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `customers` -- INSERT INTO `customers` (`id`, `first_name`, `last_name`, `email`, `phone`, `password`, `dob`, `gender`, `profile_image`, `status`, `wallet_balance`, `created_at`, `updated_at`) VALUES (1, 'Aparna1', 'Tripathi', 'tripathi@gmail.com', '3434343434', '$2y$12$Don3OVrg2QyWSwDIL9TswuW/bU7k0rliqoUFhqwQM4Sr/qV0cz9Oa', '1994-08-01', 'female', 'profiles/1757433709_user.png', 'active', 2.00, '2025-08-18 01:09:15', '2025-09-09 23:01:49'), (2, 'Ajay', 'Mishra', 'ajay@gmail.com', '8104460233', '$2y$12$UshifENew.zwnpVirBao5unvH.Biu7Tjlttni62s.15cIIAFDzncm', NULL, NULL, NULL, 'active', 0.00, '2025-10-16 19:06:40', '2025-10-16 19:06:40'), (3, 'Demo', 'One', 'demoone@yopmail.com', '9999888811', '$2y$12$QES1M0zubfEr2NfmplKIDO8Al27bXmRamrBgyOG99Ii9Cpi5Ji7We', NULL, NULL, NULL, 'active', 0.00, '2026-03-20 13:59:15', '2026-03-20 13:59:15'), (4, 'shivam', 'singh', 'shivamtech9310@gmail.com', '8104460231', '$2y$12$b.jTr42UO3pelEQrXC2GSeHZRoXRHWjBLrslXf87TL9gAYnrOxuuW', NULL, NULL, NULL, 'active', 0.00, '2026-03-20 15:18:24', '2026-03-26 16:36:23'), (5, 'isfhvlfid', 'rytegwfdsbrvfecdwsqa', 'tgrfewdws@gmail.com', '09876543212', '$2y$12$ElRq0cIBcoCGdLxbRc2WJ.9i6b3dcuVtbW2KdQYHCvlS7Zx4v8BuW', NULL, NULL, NULL, 'active', 0.00, '2026-03-20 19:56:36', '2026-03-20 19:56:36'), (6, 'Ll', 'Ll', 'll@ll.com', '9999999999', '$2y$12$QtxVY9Idlf9iJEE41xgaluImWxz728/RikDnl86FzlFzg3TcS99rK', NULL, NULL, NULL, 'active', 0.00, '2026-03-21 18:15:47', '2026-03-21 18:15:47'), (7, 'ifvidf', 'fvfd', 'tripathiji1606@gmail.com', '9876543201', '$2y$12$ejFOWidFVq8tSlqzAzNLIOd9dqndNmEiY/lVTRpn742F55j0GPXp.', NULL, NULL, NULL, 'active', 0.00, '2026-03-24 11:45:54', '2026-03-26 17:10:56'), (8, 'gaurav', 'tiwari', 'Gaurav@blinkpe.net', '8104460235', '$2y$12$rZjE2zDIiu0T0.tuFzDppe48qQ.UB.XA6RBXLk7lXA9g1DG.Zm876', NULL, NULL, NULL, 'active', 0.00, '2026-04-01 14:15:25', '2026-04-01 14:15:25'); -- -------------------------------------------------------- -- -- Table structure for table `discounts` -- CREATE TABLE `discounts` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `code` varchar(255) DEFAULT NULL, `type` enum('flat','percentage') NOT NULL, `value` decimal(10,2) NOT NULL, `applies_to` enum('all','category','product') NOT NULL DEFAULT 'all', `category_id` bigint(20) UNSIGNED DEFAULT NULL, `product_id` bigint(20) UNSIGNED DEFAULT NULL, `min_cart_amount` decimal(10,2) NOT NULL DEFAULT 0.00, `max_discount` decimal(10,2) DEFAULT NULL, `usage_limit` int(11) DEFAULT NULL, `per_user_limit` int(11) DEFAULT NULL, `start_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `discounts` -- INSERT INTO `discounts` (`id`, `name`, `code`, `type`, `value`, `applies_to`, `category_id`, `product_id`, `min_cart_amount`, `max_discount`, `usage_limit`, `per_user_limit`, `start_date`, `end_date`, `status`, `created_at`, `updated_at`) VALUES (2, 'test1', 'TEST100', 'flat', 100.00, 'all', NULL, NULL, 10000.00, 1000.00, 1, 1, '2025-09-14 00:00:00', '2025-09-15 00:00:00', 1, '2025-09-14 02:04:02', '2025-09-15 10:28:08'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `job_batches` -- CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `microlog` -- CREATE TABLE `microlog` ( `id` int(11) NOT NULL, `product` varchar(250) DEFAULT NULL, `request` longtext DEFAULT NULL, `response` longtext DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `microlog` -- INSERT INTO `microlog` (`id`, `product`, `request`, `response`, `created_at`) VALUES (1, 'onepesacallck', NULL, '[]', '2026-04-01 07:52:07'), (2, 'onepesacallck', NULL, '[]', '2026-04-01 07:55:53'), (3, 'onepesacallck', NULL, '[]', '2026-04-01 08:09:03'), (4, 'onepesacallck', NULL, '[]', '2026-04-01 08:09:42'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '0001_01_01_000000_create_users_table', 1), (2, '0001_01_01_000001_create_cache_table', 1), (3, '0001_01_01_000002_create_jobs_table', 1), (4, '2025_08_13_122400_create_categories_table', 2), (5, '2025_08_13_153840_add_status_to_categories_table', 3), (6, '2025_08_14_073331_add_image_and_productcount_to_categories_table', 4), (7, '2025_08_14_155008_create_products_table', 5), (8, '2025_08_17_161415_add_fields_to_users_table', 6), (9, '2025_08_18_055315_create_customers_table', 6), (10, '2025_08_18_060605_create_addresses_table', 7), (11, '2025_08_18_060616_create_wallets_table', 7), (12, '2025_08_18_060638_create_orders_table', 7), (13, '2025_08_18_060653_create_order_items_table', 7), (14, '2025_08_18_060659_create_wishlists_table', 7), (15, '2025_08_18_060709_create_reviews_table', 7), (16, '2025_08_18_060715_create_carts_table', 7), (17, '2025_08_18_061132_create_order_items_table', 8), (18, '2025_08_18_061150_create_reviews_table', 8), (19, '2025_08_18_061207_create_carts_table', 8), (20, '2025_08_18_061227_create_cart_items_table', 8), (21, '2025_08_19_174437_create_carousels_table', 9), (22, '2025_08_26_105100_change_image_column_to_json_in_products_table', 10), (23, '2025_08_27_162526_change_image_column_to_string_in_products_table', 11), (24, '2025_08_27_162702_create_product_images_table', 12), (25, '2025_08_30_054702_add_sizes_and_colors_to_products_table', 13), (26, '2025_08_30_055946_create_sizes_and_colors_tables', 14); -- -------------------------------------------------------- -- -- Table structure for table `offers` -- CREATE TABLE `offers` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `position` varchar(255) NOT NULL DEFAULT 'homepage_banner', `cta_url` varchar(255) DEFAULT NULL, `start_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `offers` -- INSERT INTO `offers` (`id`, `title`, `description`, `image`, `position`, `cta_url`, `start_date`, `end_date`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'Activewears', '20% off the all order', 'offer/1758110014_offer-2.png', '2', 'https://zenderapp.in/shop', '2025-09-17 00:00:00', '2025-09-19 00:00:00', 1, '2025-09-14 11:50:45', '2025-09-17 19:30:00'), (2, 'Fashionable Dress', '10% Off Your First Order', 'offer/1758110003_offer-1.png', '1', 'https://zenderapp.in/shop', '2025-09-17 00:00:00', '2025-09-19 00:00:00', 1, '2025-09-15 10:39:32', '2025-09-17 19:30:44'); -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `id` bigint(20) UNSIGNED NOT NULL, `customer_id` bigint(20) UNSIGNED NOT NULL, `order_number` varchar(255) NOT NULL, `total_amount` decimal(12,2) NOT NULL, `status` enum('pending','processing','completed','cancelled','refunded') NOT NULL DEFAULT 'pending', `order_status` enum('created','confirmed','cancelled','completed') DEFAULT 'created', `payment_status` enum('pending','paid','failed','refunded','initiated') DEFAULT 'pending', `payment_mode` varchar(225) DEFAULT NULL, `razorpay_order_id` varchar(191) DEFAULT NULL, `payment_id` varchar(191) DEFAULT NULL, `utr` varchar(256) DEFAULT NULL, `payment_method` varchar(225) DEFAULT NULL, `payment_fee` varchar(225) DEFAULT NULL, `payment_tax` varchar(225) DEFAULT NULL, `paid_at` varchar(225) DEFAULT NULL, `shipment_status` enum('not_shipped','shipped','out_for_delivery','delivered') DEFAULT 'not_shipped', `order_date` timestamp NOT NULL DEFAULT current_timestamp(), `created_at` datetime DEFAULT current_timestamp(), `updated_at` datetime DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `orders` -- INSERT INTO `orders` (`id`, `customer_id`, `order_number`, `total_amount`, `status`, `order_status`, `payment_status`, `payment_mode`, `razorpay_order_id`, `payment_id`, `utr`, `payment_method`, `payment_fee`, `payment_tax`, `paid_at`, `shipment_status`, `order_date`, `created_at`, `updated_at`) VALUES (9, 3, 'ORD-7TO6ZJER', 510.00, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2025-09-18 16:47:23', '2025-09-18 16:47:23', '2025-09-18 16:47:23'), (11, 5, 'ORD-LICXPTIY', 110.00, 'refunded', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2025-09-19 10:01:57', '2025-09-19 10:01:57', '2025-10-14 10:22:11'), (14, 17, 'ORD-RPEWPIQ2', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2025-10-16 05:59:30', '2025-10-16 05:59:30', '2025-10-16 05:59:30'), (15, 17, 'ORD-3UHJBBM1', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2025-10-16 06:03:33', '2025-10-16 06:03:33', '2025-10-16 06:03:33'), (16, 17, 'ORD-D8QRMUMB', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2025-10-16 07:36:24', '2025-10-16 07:36:24', '2025-10-16 07:36:24'), (17, 17, 'ORD-PDNREGZN', 4758.10, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2025-10-16 08:05:43', '2025-10-16 08:05:43', '2025-10-16 08:05:43'), (21, 21, 'ORD-VHJYG9PA', 2384.05, 'cancelled', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2025-12-13 07:50:51', '2025-12-13 07:50:51', '2026-01-03 10:48:55'), (23, 23, 'ORD-8NAGHF7S', 2509.00, 'refunded', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2025-12-15 07:20:15', '2025-12-15 07:20:15', '2026-01-03 10:49:05'), (33, 29, 'ORD-TSJSTAY9', 2509.00, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2025-12-16 07:13:46', '2025-12-16 07:13:46', '2025-12-16 07:13:46'), (35, 21, 'ORD-CO2QEBYW', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-05 16:45:52', '2026-01-05 16:45:52', '2026-01-05 16:45:52'), (36, 21, 'ORD-6HTPN1OS', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 05:45:34', '2026-01-06 05:45:34', '2026-01-06 05:45:34'), (37, 21, 'ORD-QYJGTQUU', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 05:45:44', '2026-01-06 05:45:44', '2026-01-06 05:45:44'), (38, 21, 'ORD-UEM1IY9I', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 05:46:00', '2026-01-06 05:46:00', '2026-01-06 05:46:00'), (39, 21, 'ORD-9Q783J7R', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 05:48:06', '2026-01-06 05:48:06', '2026-01-06 05:48:06'), (40, 21, 'ORD-W8ZE0LZ2', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 06:23:02', '2026-01-06 06:23:02', '2026-01-06 06:23:02'), (41, 21, 'ORD-XNADKJUF', 2384.05, 'cancelled', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 06:25:00', '2026-01-06 06:25:00', '2026-01-06 06:27:03'), (42, 21, 'ORD-4SUR2LPB', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 06:27:13', '2026-01-06 06:27:13', '2026-01-06 06:27:13'), (43, 21, 'ORD-IEUDUZPO', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 06:41:50', '2026-01-06 06:41:50', '2026-01-06 06:41:50'), (44, 21, 'ORD-N4Z0ZQ75', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 06:48:50', '2026-01-06 06:48:50', '2026-01-06 06:48:50'), (45, 21, 'ORD-FK8PDKCV', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 07:20:54', '2026-01-06 07:20:54', '2026-01-06 07:20:54'), (46, 21, 'ORD-BCIL41VA', 4758.10, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 07:47:23', '2026-01-06 07:47:23', '2026-01-06 07:47:23'), (47, 21, 'ORD-UNHUUQYD', 7132.15, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 07:50:54', '2026-01-06 07:50:54', '2026-01-06 07:50:54'), (48, 33, 'ORD-F45PDRIY', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 08:04:18', '2026-01-06 08:04:18', '2026-01-06 08:04:18'), (49, 33, 'ORD-PRBMCGMI', 2509.00, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 13:42:19', '2026-01-06 13:42:19', '2026-01-06 13:42:19'), (50, 33, 'ORD-J9RDXYWA', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 13:47:32', '2026-01-06 13:47:32', '2026-01-06 13:47:32'), (51, 33, 'ORD-BXBF9DXY', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 13:50:03', '2026-01-06 13:50:03', '2026-01-06 13:50:03'), (52, 33, 'ORD-Z4GZU47V', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 13:53:01', '2026-01-06 13:53:01', '2026-01-06 13:53:01'), (53, 33, 'ORD-Z9YZIYLS', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 13:59:30', '2026-01-06 13:59:30', '2026-01-06 13:59:30'), (54, 33, 'ORD-DQSQNXKU', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 14:03:10', '2026-01-06 14:03:10', '2026-01-06 14:03:10'), (60, 33, 'ORD-TEQKMSHQ', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-06 15:44:13', '2026-01-06 15:44:13', '2026-01-06 15:44:13'), (61, 21, 'ORD-H4WPCUUZ', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-07 10:12:57', '2026-01-07 10:12:57', '2026-01-07 23:20:36'), (62, 33, 'ORD-PVRNJJTF', 2509.00, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-07 23:35:13', '2026-01-07 23:35:13', '2026-01-07 23:35:13'), (63, 33, 'ORD-T5S5DDI3', 5008.00, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-08 00:17:45', '2026-01-08 00:17:45', '2026-01-08 00:17:45'), (64, 5, 'ORD-LDARAK9Y', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-21 13:04:30', '2026-01-21 13:04:30', '2026-01-21 13:04:30'), (65, 5, 'ORD-HG9RO5OV', 2509.00, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-21 13:07:22', '2026-01-21 13:07:22', '2026-01-21 13:07:22'), (66, 34, 'ORD-GJMMI7HK', 2384.05, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-27 13:01:45', '2026-01-27 13:01:45', '2026-01-27 13:01:45'), (67, 5, 'ORD-LQNQYGSH', 2760.00, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-01-27 15:51:02', '2026-01-27 15:51:02', '2026-01-27 15:51:02'), (68, 5, 'ORD-I5SGZIIB', 2760.00, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-09 07:01:51', '2026-02-09 12:31:51', '2026-02-09 12:31:51'), (69, 5, 'ORD-HCR2SXQO', 2509.00, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-09 11:23:25', '2026-02-09 16:53:25', '2026-02-09 16:53:25'), (70, 5, 'ORD-QVKZZHMK', 2760.00, 'pending', 'created', 'pending', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-09 13:34:02', '2026-02-09 19:04:02', '2026-02-09 19:04:02'), (71, 5, 'ORD-JCZD49EU', 2760.00, 'pending', 'created', 'pending', 'cod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-09 13:41:18', '2026-02-09 19:11:18', '2026-02-09 19:11:18'), (72, 5, 'ORD-NCEFZWFT', 5259.00, 'pending', 'created', 'pending', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-09 13:49:26', '2026-02-09 19:19:26', '2026-02-09 19:19:26'), (74, 5, 'ORD-FKZGUK60', 1210.00, 'pending', 'created', 'pending', 'cod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-19 13:34:16', '2026-02-19 19:04:16', '2026-02-19 19:04:16'), (75, 29, 'ORD-NHUSBZQE', 2384.05, 'pending', 'created', 'pending', 'cod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-19 14:01:07', '2026-02-19 19:31:07', '2026-02-19 19:31:07'), (76, 5, 'ORD-RXC7FDQO', 2010.00, 'pending', 'created', 'pending', 'cod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-19 14:17:28', '2026-02-19 19:47:28', '2026-02-19 19:47:28'), (77, 5, 'ORD-W5FSFZII', 2209.00, 'pending', 'created', 'pending', 'cod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-19 15:29:56', '2026-02-19 20:59:56', '2026-02-19 20:59:56'), (78, 5, 'ORD-RXPZHLJD', 2509.00, 'pending', 'created', 'initiated', 'online', 'order_SI3mCeThjD5DLN', NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-19 15:50:47', '2026-02-19 21:20:47', '2026-02-19 21:20:48'), (79, 5, 'ORD-M5NHAWDO', 6708.00, 'pending', 'created', 'pending', 'cod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-19 16:01:22', '2026-02-19 21:31:22', '2026-02-19 21:31:22'), (80, 29, 'ORD-7Q3RGUV8', 2509.00, 'pending', 'created', 'pending', 'cod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-20 04:31:59', '2026-02-20 10:01:59', '2026-02-20 10:01:59'), (81, 29, 'ORD-LVHTUENE', 10.95, 'pending', 'created', 'initiated', 'online', 'order_SIGq4frP2R7Nmk', NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-20 04:37:28', '2026-02-20 10:07:28', '2026-02-20 10:07:28'), (82, 5, 'ORD-YLKFML8O', 11.00, 'pending', 'created', 'initiated', 'online', 'order_SIHjOogMyAXX0H', NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-20 05:29:51', '2026-02-20 10:59:51', '2026-02-20 10:59:51'), (83, 29, 'ORD-X8LJCQXI', 10.95, 'pending', 'created', 'initiated', 'online', 'order_SIJ8g5e8IX133N', NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-20 06:52:28', '2026-02-20 12:22:28', '2026-02-20 12:22:28'), (84, 29, 'ORD-IRZZR8IE', 10.95, 'pending', 'created', 'initiated', 'online', 'order_SIJAE2i92JH2ZD', NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-20 06:53:56', '2026-02-20 12:23:56', '2026-02-20 12:23:56'), (85, 29, 'ORD-EC8K4TMO', 10.95, 'pending', 'created', 'initiated', 'online', 'order_SIJuICCATZE0xz', NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-20 07:37:33', '2026-02-20 13:07:33', '2026-02-20 13:07:33'), (86, 12, 'ORD-EKAQMVOH', 11.00, 'pending', 'created', 'initiated', 'online', 'order_SIK2uERv600TUU', NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-20 07:45:42', '2026-02-20 13:15:42', '2026-02-20 13:15:42'), (87, 29, 'ORD-4W3Z9L0G', 11.00, 'pending', 'confirmed', 'paid', 'online', 'order_SJuWmuwL0AbM58', 'pay_SJuWzV8HcWfoHz', '246833770013', 'upi', '26', '4', '2026-02-27 14:10:16', 'not_shipped', '2026-02-24 08:05:57', '2026-02-24 13:35:57', '2026-02-27 14:10:16'), (88, 29, 'ORD-GQNFUBRG', 11.00, 'pending', 'created', 'initiated', 'online', 'order_SJuXXayURy3u95', NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-24 08:06:40', '2026-02-24 13:36:40', '2026-02-24 13:36:40'), (89, 29, 'ORD-ZX9IXLCH', 11.00, 'pending', 'created', 'initiated', 'online', 'order_SJuXdlVktZCK6j', NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-24 08:06:46', '2026-02-24 13:36:46', '2026-02-24 13:36:46'), (90, 5, 'ORD-DW5CCXIT', 2509.00, 'pending', 'created', 'initiated', 'online', 'order_SL4pJ6g6BI2McE', NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-02-27 06:49:26', '2026-02-27 12:19:26', '2026-02-27 12:19:26'), (91, 5, 'ORD-ROM0XHYT', 2509.00, 'pending', 'confirmed', 'paid', 'online', 'order_SL6kLne7WAUctS', 'pay_SL6kxh3tAaYLTK', '367625814075', 'upi', '5922', '904', '2026-02-27 14:12:44', 'not_shipped', '2026-02-27 08:42:07', '2026-02-27 14:12:07', '2026-02-27 14:12:44'), (92, 5, 'ORD-MWNTAHKJ', 2509.00, 'pending', 'confirmed', 'paid', 'online', 'order_SL78onc237Mi5t', 'pay_SL79A71BTNQyKI', '346994012598', 'upi', '5922', '904', '2026-02-27 14:35:39', 'not_shipped', '2026-02-27 09:05:17', '2026-02-27 14:35:17', '2026-02-27 14:35:39'), (93, 5, 'ORD-G9CF2LAX', 709.00, 'pending', 'confirmed', 'paid', 'online', 'order_SL8DEobmIc482x', 'pay_SL8Dhw1YFhfu9b', '663270767124', 'upi', '1674', '256', '2026-02-27 15:38:38', 'not_shipped', '2026-02-27 10:08:09', '2026-02-27 15:38:09', '2026-02-27 15:38:38'), (94, 7, 'ORD-RZPUKG0U', 2209.00, 'pending', 'created', 'pending', 'cod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 14:04:33', '2026-04-01 07:04:33', '2026-04-01 07:04:33'), (95, 7, 'ORD-YXGF39O8', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 14:05:15', '2026-04-01 07:05:15', '2026-04-01 07:05:15'), (96, 7, 'ORD-EYS4Y2W1', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 14:06:03', '2026-04-01 07:06:03', '2026-04-01 07:06:03'), (97, 7, 'ORD-AJJUVEEK', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 14:06:33', '2026-04-01 07:06:33', '2026-04-01 07:06:33'), (98, 7, 'ORD-CCL9PHIU', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 14:07:36', '2026-04-01 07:07:36', '2026-04-01 07:07:36'), (99, 7, 'ORD-UE0NVGZT', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 14:46:39', '2026-04-01 07:46:39', '2026-04-01 07:46:39'), (100, 7, 'ORD-QTQCSPUD', 909.00, 'pending', 'created', 'pending', 'cod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 15:05:26', '2026-04-01 08:05:26', '2026-04-01 08:05:26'), (101, 7, 'ORD-MNYDWWTF', 1309.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 15:13:35', '2026-04-01 08:13:35', '2026-04-01 08:13:35'), (102, 7, 'ORD-JEWOTREP', 1309.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 15:14:12', '2026-04-01 08:14:12', '2026-04-01 08:14:12'), (103, 7, 'ORD-UDVFXOW4', 1309.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 15:19:50', '2026-04-01 08:19:50', '2026-04-01 08:19:50'), (104, 7, 'ORD-87033', 1309.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 15:21:04', '2026-04-01 08:21:04', '2026-04-01 08:21:04'), (105, 7, 'ORD30999', 1309.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 15:21:24', '2026-04-01 08:21:24', '2026-04-01 08:21:24'), (106, 7, 'ORD87361', 1309.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 15:23:21', '2026-04-01 08:23:21', '2026-04-01 08:23:21'), (107, 7, 'ORD45866', 1309.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 15:24:51', '2026-04-01 08:24:51', '2026-04-01 08:24:51'), (108, 7, 'ORD92905', 1309.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 15:25:29', '2026-04-01 08:25:29', '2026-04-01 08:25:29'), (109, 4, 'ORD19880', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 15:32:37', '2026-04-01 08:32:37', '2026-04-01 08:32:37'), (110, 4, 'ORD21080', 2709.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 16:52:41', '2026-04-01 09:52:41', '2026-04-01 09:52:41'), (111, 4, 'ORD47587', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 16:57:36', '2026-04-01 09:57:36', '2026-04-01 09:57:36'), (112, 4, 'ORD16721', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 17:00:55', '2026-04-01 10:00:55', '2026-04-01 10:00:55'), (113, 4, 'ORD55458', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-01 17:56:44', '2026-04-01 10:56:44', '2026-04-01 10:56:44'), (114, 4, 'ORD89275', 909.00, 'pending', 'created', 'pending', 'cod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-06 14:08:30', '2026-04-06 07:08:30', '2026-04-06 07:08:30'), (115, 4, 'ORD29467', 809.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-06 14:09:24', '2026-04-06 07:09:24', '2026-04-06 07:09:24'), (116, 4, 'ORD99026', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-07 16:25:47', '2026-04-07 09:25:47', '2026-04-07 09:25:47'), (117, 4, 'ORD21104', 809.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-07 17:40:59', '2026-04-07 10:40:59', '2026-04-07 10:40:59'), (118, 4, 'ORD22433', 1708.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-07 17:44:46', '2026-04-07 10:44:46', '2026-04-07 10:44:46'), (119, 4, 'ORD34276', 1708.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-07 17:46:02', '2026-04-07 10:46:02', '2026-04-07 10:46:02'), (120, 4, 'ORD51573', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-07 23:16:35', '2026-04-07 16:16:35', '2026-04-07 16:16:35'), (121, 4, 'ORD25853', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-08 11:40:54', '2026-04-08 04:40:54', '2026-04-08 04:40:54'), (122, 4, 'ORD51809', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-08 11:44:58', '2026-04-08 04:44:58', '2026-04-08 04:44:58'), (123, 4, 'ORD76279', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-08 12:29:07', '2026-04-08 05:29:07', '2026-04-08 05:29:07'), (124, 4, 'ORD94065', 1808.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-08 15:48:49', '2026-04-08 08:48:49', '2026-04-08 08:48:49'), (125, 7, 'ORD69833', 709.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-08 17:06:05', '2026-04-08 10:06:05', '2026-04-08 10:06:05'), (126, 7, 'ORD40573', 709.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-08 17:06:45', '2026-04-08 10:06:45', '2026-04-08 10:06:45'), (127, 7, 'ORD96849', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-08 17:11:31', '2026-04-08 10:11:31', '2026-04-08 10:11:31'), (128, 4, 'ORD39731', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-09 18:45:37', '2026-04-09 11:45:37', '2026-04-09 11:45:37'), (129, 4, 'ORD51558', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-09 18:47:23', '2026-04-09 11:47:23', '2026-04-09 11:47:23'), (130, 4, 'ORD59538', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-09 19:31:15', '2026-04-09 12:31:15', '2026-04-09 12:31:15'), (131, 4, 'ORD69147', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-09 19:32:44', '2026-04-09 12:32:44', '2026-04-09 12:32:44'), (132, 4, 'ORD18121', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-09 20:04:15', '2026-04-09 13:04:15', '2026-04-09 13:04:15'), (133, 4, 'ORD12056', 2409.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-13 11:06:24', '2026-04-13 04:06:24', '2026-04-13 04:06:24'), (134, 4, 'ORD30275', 2409.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-13 16:43:54', '2026-04-13 09:43:54', '2026-04-13 09:43:54'), (135, 4, 'ORD55517', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-14 00:05:42', '2026-04-13 17:05:42', '2026-04-13 17:05:42'), (136, 4, 'ORD37608', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-14 00:08:33', '2026-04-13 17:08:33', '2026-04-13 17:08:33'), (137, 4, 'ORD42704', 809.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-14 15:00:06', '2026-04-14 08:00:06', '2026-04-14 08:00:06'), (138, 4, 'ORD34037', 12009.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-14 18:17:41', '2026-04-14 11:17:41', '2026-04-14 11:17:41'), (139, 4, 'ORD52216', 12009.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-14 18:17:51', '2026-04-14 11:17:51', '2026-04-14 11:17:51'), (140, 4, 'ORD69682', 12009.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-14 18:18:04', '2026-04-14 11:18:04', '2026-04-14 11:18:04'), (141, 4, 'ORD28044', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-14 18:18:37', '2026-04-14 11:18:37', '2026-04-14 11:18:37'), (142, 7, 'ORD96101', 809.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-20 20:46:52', '2026-04-20 13:46:52', '2026-04-20 13:46:52'), (143, 4, 'ORD51162', 809.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-20 23:51:05', '2026-04-20 16:51:05', '2026-04-20 16:51:05'), (144, 4, 'ORD66444', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-20 23:55:12', '2026-04-20 16:55:12', '2026-04-20 16:55:12'), (145, 4, 'ORD78547', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-20 23:55:13', '2026-04-20 16:55:13', '2026-04-20 16:55:13'), (146, 4, 'ORD29823', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-21 15:21:36', '2026-04-21 08:21:36', '2026-04-21 08:21:36'), (147, 4, 'ORD74207', 12009.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-24 04:18:06', '2026-04-23 21:18:06', '2026-04-23 21:18:06'), (148, 4, 'ORD78943', 12009.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-24 04:18:23', '2026-04-23 21:18:23', '2026-04-23 21:18:23'), (149, 4, 'ORD74853', 12009.00, 'pending', 'created', 'pending', 'cod', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-24 04:18:48', '2026-04-23 21:18:48', '2026-04-23 21:18:48'), (150, 4, 'ORD90364', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-24 04:20:00', '2026-04-23 21:20:00', '2026-04-23 21:20:00'), (151, 4, 'ORD15558', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-24 05:29:31', '2026-04-23 22:29:31', '2026-04-23 22:29:31'), (152, 4, 'ORD28322', 809.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-24 17:11:33', '2026-04-24 10:11:33', '2026-04-24 10:11:33'), (153, 4, 'ORD53634', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:17:24', '2026-04-24 17:17:24', '2026-04-24 17:17:24'), (154, 4, 'ORD23156', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:18:04', '2026-04-24 17:18:04', '2026-04-24 17:18:04'), (155, 4, 'ORD86306', 2209.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:21:39', '2026-04-24 17:21:39', '2026-04-24 17:21:39'), (156, 4, 'ORD64282', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:21:46', '2026-04-24 17:21:46', '2026-04-24 17:21:46'), (157, 4, 'ORD99754', 2209.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:21:53', '2026-04-24 17:21:53', '2026-04-24 17:21:53'), (158, 4, 'ORD36789', 2209.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:22:15', '2026-04-24 17:22:15', '2026-04-24 17:22:15'), (159, 4, 'ORD50920', 2209.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:22:38', '2026-04-24 17:22:38', '2026-04-24 17:22:38'), (160, 4, 'ORD48745', 2209.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:23:33', '2026-04-24 17:23:33', '2026-04-24 17:23:33'), (161, 4, 'ORD68270', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:23:57', '2026-04-24 17:23:57', '2026-04-24 17:23:57'), (162, 4, 'ORD42297', 2409.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:25:24', '2026-04-24 17:25:24', '2026-04-24 17:25:24'), (163, 4, 'ORD12338', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:27:08', '2026-04-24 17:27:08', '2026-04-24 17:27:08'), (164, 4, 'ORD69840', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:29:58', '2026-04-24 17:29:58', '2026-04-24 17:29:58'), (165, 4, 'ORD58195', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:31:20', '2026-04-24 17:31:20', '2026-04-24 17:31:20'), (166, 4, 'ORD58008', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:32:00', '2026-04-24 17:32:00', '2026-04-24 17:32:00'), (167, 4, 'ORD23842', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:32:24', '2026-04-24 17:32:24', '2026-04-24 17:32:24'), (168, 4, 'ORD55985', 22009.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:33:23', '2026-04-24 17:33:23', '2026-04-24 17:33:23'), (169, 4, 'ORD74336', 22009.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:33:52', '2026-04-24 17:33:52', '2026-04-24 17:33:52'), (170, 4, 'ORD89431', 22009.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:34:11', '2026-04-24 17:34:11', '2026-04-24 17:34:11'), (171, 4, 'ORD65226', 22009.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:34:23', '2026-04-24 17:34:23', '2026-04-24 17:34:23'), (172, 4, 'ORD76442', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:34:48', '2026-04-24 17:34:48', '2026-04-24 17:34:48'), (173, 4, 'ORD27712', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:35:50', '2026-04-24 17:35:50', '2026-04-24 17:35:50'), (174, 4, 'ORD41113', 22009.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:37:37', '2026-04-24 17:37:37', '2026-04-24 17:37:37'), (175, 4, 'ORD48044', 22009.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:38:08', '2026-04-24 17:38:08', '2026-04-24 17:38:08'), (176, 4, 'ORD27162', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:44:14', '2026-04-24 17:44:14', '2026-04-24 17:44:14'), (177, 4, 'ORD77984', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-25 00:46:18', '2026-04-24 17:46:18', '2026-04-24 17:46:18'), (178, 4, 'ORD27847', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-28 01:00:26', '2026-04-27 18:00:26', '2026-04-27 18:00:26'), (179, 4, 'ORD65152', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-28 01:00:43', '2026-04-27 18:00:43', '2026-04-27 18:00:43'), (180, 4, 'ORD80711', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-29 00:41:22', '2026-04-28 17:41:22', '2026-04-28 17:41:22'), (181, 4, 'ORD85366', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-29 00:41:59', '2026-04-28 17:41:59', '2026-04-28 17:41:59'), (182, 4, 'ORD85343', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-29 00:43:43', '2026-04-28 17:43:43', '2026-04-28 17:43:43'), (183, 4, 'ORD61593', 909.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-04-29 00:44:39', '2026-04-28 17:44:39', '2026-04-28 17:44:39'), (184, 4, 'ORD90548', 3509.00, 'pending', 'created', 'initiated', 'online', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'not_shipped', '2026-05-11 19:17:00', '2026-05-11 12:17:00', '2026-05-11 12:17:00'); -- -------------------------------------------------------- -- -- Table structure for table `order_items` -- CREATE TABLE `order_items` ( `id` bigint(20) UNSIGNED NOT NULL, `order_id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) UNSIGNED NOT NULL, `quantity` int(11) NOT NULL DEFAULT 1, `price` decimal(12,2) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `order_items` -- INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `quantity`, `price`, `created_at`, `updated_at`) VALUES (11, 14, 8, 1, 2499.00, '2025-10-16 05:59:31', '2025-10-16 05:59:31'), (12, 15, 8, 1, 2499.00, '2025-10-16 06:03:33', '2025-10-16 06:03:33'), (13, 16, 8, 1, 2499.00, '2025-10-16 07:36:25', '2025-10-16 07:36:25'), (14, 17, 8, 2, 2499.00, '2025-10-16 08:05:43', '2025-10-16 08:05:43'), (18, 21, 8, 1, 2499.00, '2025-12-13 07:50:51', '2025-12-13 07:50:51'), (20, 23, 8, 1, 2499.00, '2025-12-15 07:20:15', '2025-12-15 07:20:15'), (29, 33, 8, 1, 2499.00, '2025-12-16 07:13:46', '2025-12-16 07:13:46'), (31, 35, 8, 1, 2499.00, '2026-01-05 16:45:53', '2026-01-05 16:45:53'), (32, 36, 8, 1, 2499.00, '2026-01-06 05:45:34', '2026-01-06 05:45:34'), (33, 37, 8, 1, 2499.00, '2026-01-06 05:45:44', '2026-01-06 05:45:44'), (34, 38, 8, 1, 2499.00, '2026-01-06 05:46:00', '2026-01-06 05:46:00'), (35, 39, 8, 1, 2499.00, '2026-01-06 05:48:06', '2026-01-06 05:48:06'), (36, 40, 8, 1, 2499.00, '2026-01-06 06:23:03', '2026-01-06 06:23:03'), (37, 41, 8, 1, 2499.00, '2026-01-06 06:25:01', '2026-01-06 06:25:01'), (38, 42, 8, 1, 2499.00, '2026-01-06 06:27:13', '2026-01-06 06:27:13'), (39, 43, 8, 1, 2499.00, '2026-01-06 06:41:50', '2026-01-06 06:41:50'), (40, 44, 8, 1, 2499.00, '2026-01-06 06:48:51', '2026-01-06 06:48:51'), (41, 45, 8, 1, 2499.00, '2026-01-06 07:20:55', '2026-01-06 07:20:55'), (42, 46, 8, 2, 2499.00, '2026-01-06 07:47:23', '2026-01-06 07:47:23'), (43, 47, 8, 3, 2499.00, '2026-01-06 07:50:54', '2026-01-06 07:50:54'), (44, 48, 8, 1, 2499.00, '2026-01-06 08:04:18', '2026-01-06 08:04:18'), (45, 49, 8, 1, 2499.00, '2026-01-06 13:42:19', '2026-01-06 13:42:19'), (46, 50, 8, 1, 2499.00, '2026-01-06 13:47:32', '2026-01-06 13:47:32'), (47, 51, 8, 1, 2499.00, '2026-01-06 13:50:03', '2026-01-06 13:50:03'), (48, 52, 8, 1, 2499.00, '2026-01-06 13:53:01', '2026-01-06 13:53:01'), (49, 53, 8, 1, 2499.00, '2026-01-06 13:59:30', '2026-01-06 13:59:30'), (50, 54, 8, 1, 2499.00, '2026-01-06 14:03:10', '2026-01-06 14:03:10'), (56, 60, 8, 1, 2499.00, '2026-01-06 15:44:13', '2026-01-06 15:44:13'), (57, 61, 8, 1, 2499.00, '2026-01-07 10:12:57', '2026-01-07 10:12:57'), (58, 62, 8, 1, 2499.00, '2026-01-07 23:35:13', '2026-01-07 23:35:13'), (59, 63, 8, 2, 2499.00, '2026-01-08 00:17:45', '2026-01-08 00:17:45'), (60, 64, 8, 1, 2499.00, '2026-01-21 13:04:30', '2026-01-21 13:04:30'), (61, 65, 8, 1, 2499.00, '2026-01-21 13:07:22', '2026-01-21 13:07:22'), (62, 66, 8, 1, 2499.00, '2026-01-27 13:01:45', '2026-01-27 13:01:45'), (63, 67, 9, 1, 2750.00, '2026-01-27 15:51:02', '2026-01-27 15:51:02'), (64, 68, 9, 1, 2750.00, '2026-02-09 07:01:51', '2026-02-09 07:01:51'), (65, 69, 8, 1, 2499.00, '2026-02-09 11:23:25', '2026-02-09 11:23:25'), (66, 70, 9, 1, 2750.00, '2026-02-09 13:34:02', '2026-02-09 13:34:02'), (67, 71, 9, 1, 2750.00, '2026-02-09 13:41:18', '2026-02-09 13:41:18'), (68, 72, 9, 1, 2750.00, '2026-02-09 13:49:26', '2026-02-09 13:49:26'), (69, 72, 8, 1, 2499.00, '2026-02-09 13:49:26', '2026-02-09 13:49:26'), (72, 75, 8, 1, 2499.00, '2026-02-19 14:01:07', '2026-02-19 14:01:07'), (74, 77, 9, 1, 2199.00, '2026-02-19 15:29:56', '2026-02-19 15:29:56'), (75, 78, 8, 1, 2499.00, '2026-02-19 15:50:47', '2026-02-19 15:50:47'), (77, 79, 9, 1, 2199.00, '2026-02-19 16:01:22', '2026-02-19 16:01:22'), (78, 79, 8, 1, 2499.00, '2026-02-19 16:01:22', '2026-02-19 16:01:22'), (79, 80, 8, 1, 2499.00, '2026-02-20 04:31:59', '2026-02-20 04:31:59'), (86, 87, 15, 1, 1.00, '2026-02-24 08:05:57', '2026-02-24 08:05:57'), (87, 88, 15, 1, 1.00, '2026-02-24 08:06:40', '2026-02-24 08:06:40'), (88, 89, 15, 1, 1.00, '2026-02-24 08:06:46', '2026-02-24 08:06:46'), (89, 90, 8, 1, 2499.00, '2026-02-27 06:49:26', '2026-02-27 06:49:26'), (90, 91, 8, 1, 2499.00, '2026-02-27 08:42:07', '2026-02-27 08:42:07'), (91, 92, 8, 1, 2499.00, '2026-02-27 14:35:17', '2026-02-27 14:35:17'), (92, 93, 14, 1, 699.00, '2026-02-27 15:38:09', '2026-02-27 15:38:09'), (93, 100, 1, 1, 899.00, '2026-04-01 08:05:26', '2026-04-01 08:05:26'), (94, 101, 2, 1, 1299.00, '2026-04-01 08:13:35', '2026-04-01 08:13:35'), (95, 102, 2, 1, 1299.00, '2026-04-01 08:14:12', '2026-04-01 08:14:12'), (96, 103, 2, 1, 1299.00, '2026-04-01 08:19:50', '2026-04-01 08:19:50'), (97, 104, 2, 1, 1299.00, '2026-04-01 08:21:04', '2026-04-01 08:21:04'), (98, 105, 2, 1, 1299.00, '2026-04-01 08:21:24', '2026-04-01 08:21:24'), (99, 106, 2, 1, 1299.00, '2026-04-01 08:23:21', '2026-04-01 08:23:21'), (100, 107, 2, 1, 1299.00, '2026-04-01 08:24:51', '2026-04-01 08:24:51'), (101, 108, 2, 1, 1299.00, '2026-04-01 08:25:29', '2026-04-01 08:25:29'), (102, 109, 1, 1, 899.00, '2026-04-01 08:32:37', '2026-04-01 08:32:37'), (103, 110, 13, 1, 2699.00, '2026-04-01 09:52:41', '2026-04-01 09:52:41'), (104, 111, 1, 1, 899.00, '2026-04-01 09:57:36', '2026-04-01 09:57:36'), (105, 112, 1, 1, 899.00, '2026-04-01 10:00:55', '2026-04-01 10:00:55'), (106, 113, 1, 1, 899.00, '2026-04-01 10:56:44', '2026-04-01 10:56:44'), (107, 114, 1, 1, 899.00, '2026-04-06 07:08:30', '2026-04-06 07:08:30'), (108, 115, 3, 1, 799.00, '2026-04-06 07:09:24', '2026-04-06 07:09:24'), (109, 116, 1, 1, 899.00, '2026-04-07 09:25:47', '2026-04-07 09:25:47'), (110, 117, 3, 1, 799.00, '2026-04-07 10:40:59', '2026-04-07 10:40:59'), (111, 118, 3, 1, 799.00, '2026-04-07 10:44:46', '2026-04-07 10:44:46'), (112, 118, 1, 1, 899.00, '2026-04-07 10:44:46', '2026-04-07 10:44:46'), (113, 119, 3, 1, 799.00, '2026-04-07 10:46:02', '2026-04-07 10:46:02'), (114, 119, 1, 1, 899.00, '2026-04-07 10:46:02', '2026-04-07 10:46:02'), (115, 120, 1, 1, 899.00, '2026-04-07 16:16:35', '2026-04-07 16:16:35'), (116, 121, 1, 1, 899.00, '2026-04-08 04:40:54', '2026-04-08 04:40:54'), (117, 122, 1, 1, 899.00, '2026-04-08 04:44:58', '2026-04-08 04:44:58'), (118, 123, 1, 1, 899.00, '2026-04-08 05:29:07', '2026-04-08 05:29:07'), (119, 124, 1, 2, 899.00, '2026-04-08 08:48:49', '2026-04-08 08:48:49'), (120, 125, 6, 1, 699.00, '2026-04-08 10:06:05', '2026-04-08 10:06:05'), (121, 126, 6, 1, 699.00, '2026-04-08 10:06:45', '2026-04-08 10:06:45'), (122, 127, 1, 1, 899.00, '2026-04-08 10:11:31', '2026-04-08 10:11:31'), (123, 128, 1, 1, 899.00, '2026-04-09 11:45:37', '2026-04-09 11:45:37'), (124, 129, 1, 1, 899.00, '2026-04-09 11:47:23', '2026-04-09 11:47:23'), (125, 130, 1, 1, 899.00, '2026-04-09 12:31:15', '2026-04-09 12:31:15'), (126, 131, 1, 1, 899.00, '2026-04-09 12:32:44', '2026-04-09 12:32:44'), (127, 132, 1, 1, 899.00, '2026-04-09 13:04:15', '2026-04-09 13:04:15'), (128, 133, 12, 1, 2399.00, '2026-04-13 04:06:24', '2026-04-13 04:06:24'), (129, 134, 12, 1, 2399.00, '2026-04-13 09:43:54', '2026-04-13 09:43:54'), (130, 135, 1, 1, 899.00, '2026-04-13 17:05:42', '2026-04-13 17:05:42'), (131, 136, 1, 1, 899.00, '2026-04-13 17:08:33', '2026-04-13 17:08:33'), (132, 137, 3, 1, 799.00, '2026-04-14 08:00:06', '2026-04-14 08:00:06'), (133, 138, 42, 1, 11999.00, '2026-04-14 11:17:41', '2026-04-14 11:17:41'), (134, 139, 42, 1, 11999.00, '2026-04-14 11:17:51', '2026-04-14 11:17:51'), (135, 140, 42, 1, 11999.00, '2026-04-14 11:18:04', '2026-04-14 11:18:04'), (136, 141, 1, 1, 899.00, '2026-04-14 11:18:37', '2026-04-14 11:18:37'), (137, 142, 3, 1, 799.00, '2026-04-20 13:46:52', '2026-04-20 13:46:52'), (138, 143, 3, 1, 799.00, '2026-04-20 16:51:05', '2026-04-20 16:51:05'), (139, 144, 1, 1, 899.00, '2026-04-20 16:55:12', '2026-04-20 16:55:12'), (140, 145, 1, 1, 899.00, '2026-04-20 16:55:13', '2026-04-20 16:55:13'), (141, 146, 1, 1, 899.00, '2026-04-21 08:21:36', '2026-04-21 08:21:36'), (142, 147, 42, 1, 11999.00, '2026-04-23 21:18:06', '2026-04-23 21:18:06'), (143, 148, 42, 1, 11999.00, '2026-04-23 21:18:23', '2026-04-23 21:18:23'), (144, 149, 42, 1, 11999.00, '2026-04-23 21:18:48', '2026-04-23 21:18:48'), (145, 150, 1, 1, 899.00, '2026-04-23 21:20:00', '2026-04-23 21:20:00'), (146, 151, 1, 1, 899.00, '2026-04-23 22:29:31', '2026-04-23 22:29:31'), (147, 152, 3, 1, 799.00, '2026-04-24 10:11:33', '2026-04-24 10:11:33'), (148, 153, 1, 1, 899.00, '2026-04-24 17:17:24', '2026-04-24 17:17:24'), (149, 154, 1, 1, 899.00, '2026-04-24 17:18:04', '2026-04-24 17:18:04'), (150, 155, 16, 1, 2199.00, '2026-04-24 17:21:39', '2026-04-24 17:21:39'), (151, 156, 1, 1, 899.00, '2026-04-24 17:21:46', '2026-04-24 17:21:46'), (152, 157, 16, 1, 2199.00, '2026-04-24 17:21:53', '2026-04-24 17:21:53'), (153, 158, 16, 1, 2199.00, '2026-04-24 17:22:15', '2026-04-24 17:22:15'), (154, 159, 16, 1, 2199.00, '2026-04-24 17:22:38', '2026-04-24 17:22:38'), (155, 160, 16, 1, 2199.00, '2026-04-24 17:23:33', '2026-04-24 17:23:33'), (156, 161, 1, 1, 899.00, '2026-04-24 17:23:57', '2026-04-24 17:23:57'), (157, 162, 12, 1, 2399.00, '2026-04-24 17:25:24', '2026-04-24 17:25:24'), (158, 163, 1, 1, 899.00, '2026-04-24 17:27:08', '2026-04-24 17:27:08'), (159, 164, 1, 1, 899.00, '2026-04-24 17:29:58', '2026-04-24 17:29:58'), (160, 165, 1, 1, 899.00, '2026-04-24 17:31:20', '2026-04-24 17:31:20'), (161, 166, 1, 1, 899.00, '2026-04-24 17:32:00', '2026-04-24 17:32:00'), (162, 167, 1, 1, 899.00, '2026-04-24 17:32:24', '2026-04-24 17:32:24'), (163, 168, 44, 1, 21999.00, '2026-04-24 17:33:23', '2026-04-24 17:33:23'), (164, 169, 44, 1, 21999.00, '2026-04-24 17:33:52', '2026-04-24 17:33:52'), (165, 170, 44, 1, 21999.00, '2026-04-24 17:34:11', '2026-04-24 17:34:11'), (166, 171, 44, 1, 21999.00, '2026-04-24 17:34:24', '2026-04-24 17:34:24'), (167, 172, 1, 1, 899.00, '2026-04-24 17:34:48', '2026-04-24 17:34:48'), (168, 173, 1, 1, 899.00, '2026-04-24 17:35:50', '2026-04-24 17:35:50'), (169, 174, 44, 1, 21999.00, '2026-04-24 17:37:37', '2026-04-24 17:37:37'), (170, 175, 44, 1, 21999.00, '2026-04-24 17:38:08', '2026-04-24 17:38:08'), (171, 176, 1, 1, 899.00, '2026-04-24 17:44:14', '2026-04-24 17:44:14'), (172, 177, 1, 1, 899.00, '2026-04-24 17:46:18', '2026-04-24 17:46:18'), (173, 178, 1, 1, 899.00, '2026-04-27 18:00:26', '2026-04-27 18:00:26'), (174, 179, 1, 1, 899.00, '2026-04-27 18:00:44', '2026-04-27 18:00:44'), (175, 180, 1, 1, 899.00, '2026-04-28 17:41:22', '2026-04-28 17:41:22'), (176, 181, 1, 1, 899.00, '2026-04-28 17:41:59', '2026-04-28 17:41:59'), (177, 182, 1, 1, 899.00, '2026-04-28 17:43:44', '2026-04-28 17:43:44'), (178, 183, 1, 1, 899.00, '2026-04-28 17:44:39', '2026-04-28 17:44:39'), (179, 184, 34, 1, 3499.00, '2026-05-11 12:17:00', '2026-05-11 12:17:00'); -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` bigint(20) UNSIGNED NOT NULL, `category_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `sizes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`sizes`)), `colors` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`colors`)), `price` decimal(10,2) NOT NULL, `original_price` decimal(10,2) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `quantity` varchar(191) DEFAULT NULL, `section` enum('trendy','bestsellers','justArrived') DEFAULT NULL, `description` text DEFAULT NULL, `rating` decimal(3,2) NOT NULL DEFAULT 0.00, `reviews` int(10) UNSIGNED NOT NULL DEFAULT 0, `specifications` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`specifications`)), `status` enum('active','blocked') NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `category_id`, `name`, `sizes`, `colors`, `price`, `original_price`, `image`, `quantity`, `section`, `description`, `rating`, `reviews`, `specifications`, `status`, `created_at`, `updated_at`) VALUES (1, 1, 'Men DryFit Training T-Shirt', '[\"S\",\"M\",\"L\",\"XL\"]', '[\"Black\",\"Blue\"]', 899.00, 1199.00, 'product/activewear1.jpg', '18', 'trendy', 'Stay cool and comfortable during your workouts with this high-performance DryFit training t-shirt.\r\nMade from breathable polyester fabric, it helps wick away sweat and keeps you dry.\r\nThe athletic fit ensures flexibility and ease of movement during intense training sessions.\r\nPerfect for gym workouts, running, and outdoor sports activities.\r\nA stylish and durable choice for everyday fitness wear.', 4.50, 120, '{\"material\":\"Polyester\",\"fit\":\"Athletic\"}', 'active', '2026-03-09 15:37:45', '2026-04-06 14:08:30'), (2, 1, 'Women Yoga Stretch Leggings', '[\"S\",\"M\",\"L\"]', '[\"Black\",\"Purple\"]', 1299.00, 1599.00, 'product/activewear2.jpg', '20', 'bestsellers', 'Experience ultimate comfort with these premium yoga stretch leggings designed for active women.\r\nCrafted from a soft spandex blend, they offer excellent flexibility and support.\r\nThe snug fit enhances body shape while allowing free movement during yoga or workouts.\r\nIdeal for gym sessions, stretching, and casual athleisure wear.\r\nA must-have for comfort, style, and performance.', 4.60, 90, '{\"material\":\"Spandex Blend\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (3, 1, 'Women Running Shorts Pro', '[\"M\",\"L\",\"XL\"]', '[\"Grey\",\"Black\"]', 799.00, 999.00, 'product/activewear3.jpg', '20', 'trendy', 'Designed for performance, these running shorts provide maximum comfort during workouts.\r\nLightweight and breathable fabric ensures proper airflow and sweat control.\r\nThe flexible fit allows easy movement for running, training, or sports activities.\r\nPerfect for both indoor gym sessions and outdoor running.\r\nStay active and stylish with these high-quality running shorts.', 4.40, 80, '{\"material\":\"Polyester\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (4, 1, 'Women Sports Training Jacket', '[\"S\",\"M\",\"L\"]', '[\"Pink\",\"Black\"]', 1499.00, 1799.00, 'product/activewear4.jpg', '20', 'justArrived', 'Upgrade your workout wardrobe with this stylish sports training jacket.\r\nMade from durable polyester, it provides comfort and protection during workouts.\r\nThe lightweight design makes it perfect for all-season training.\r\nIdeal for gym sessions, jogging, or casual wear.\r\nA perfect combination of fashion and functionality.', 4.30, 60, '{\"material\":\"Polyester\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (5, 1, 'Men Compression Gym Tights', '[\"M\",\"L\",\"XL\"]', '[\"Black\"]', 1199.00, 1499.00, 'product/activewear5.jpg', '20', 'bestsellers', 'Boost your performance with these high-stretch compression gym tights.\r\nDesigned to improve blood circulation and muscle support during workouts.\r\nThe breathable fabric keeps you cool even during intense sessions.\r\nPerfect for weight training, running, and high-intensity workouts.\r\nA reliable choice for athletes seeking comfort and durability.', 4.50, 70, '{\"stretch\":\"High\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (6, 1, 'Women Fitness Crop Top', '[\"S\",\"M\",\"L\"]', '[\"White\",\"Blue\"]', 699.00, 899.00, 'product/activewear6.jpg', '20', 'trendy', 'Stay trendy and comfortable with this stylish fitness crop top.\r\nMade with quick-dry fabric to keep you fresh during workouts.\r\nProvides a perfect fit for yoga, gym, and active wear.\r\nLightweight material ensures ease of movement and flexibility.\r\nA perfect blend of fashion and performance for active women.', 4.20, 45, '{\"fabric\":\"Quick Dry\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (7, 1, 'Men Sleeveless Gym Tank', '[\"M\",\"L\",\"XL\"]', '[\"Red\",\"Black\"]', 599.00, 799.00, 'product/activewear7.jpg', '20', 'justArrived', 'Train harder with this sleeveless gym tank designed for maximum comfort.\r\nMade from soft cotton fabric that feels great on the skin.\r\nAllows full range of motion for bodybuilding and strength training.\r\nKeeps you cool during intense workouts and hot weather.\r\nPerfect for gym, sports, or casual wear.', 4.40, 55, '{\"material\":\"Cotton\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (8, 1, 'Women High Waist Yoga Pants', '[\"S\",\"M\",\"L\"]', '[\"Grey\",\"Black\"]', 1399.00, 1699.00, 'product/activewear8.jpg', '20', 'bestsellers', 'Enjoy superior comfort with these high waist yoga pants.\r\nDesigned with stretchable fabric that supports flexibility and movement.\r\nThe high-rise fit provides better support and a flattering look.\r\nPerfect for yoga, workouts, or daily casual wear.\r\nA stylish and comfortable addition to your fitness wardrobe.', 4.60, 88, '{\"fabric\":\"Stretch\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (9, 1, 'Men Gym Training Hoodie', '[\"M\",\"L\",\"XL\"]', '[\"Black\",\"Green\"]', 1899.00, 2299.00, 'product/activewear9.jpg', '20', 'trendy', 'Stay warm and comfortable with this premium gym training hoodie.\r\nMade for both workouts and casual wear in cooler weather.\r\nSoft and durable fabric ensures long-lasting comfort.\r\nIdeal for outdoor training sessions or gym warm-ups.\r\nA perfect mix of style, comfort, and performance.', 4.70, 110, '{\"season\":\"Winter\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (10, 1, 'Women Lightweight Workout Tee', '[\"S\",\"M\",\"L\"]', '[\"Blue\",\"Pink\"]', 799.00, 999.00, 'product/activewear10.jpg', '20', 'justArrived', 'This lightweight workout tee is perfect for everyday fitness activities.\r\nBreathable fabric keeps you cool and comfortable during workouts.\r\nDesigned for flexibility and ease of movement.\r\nIdeal for gym, yoga, or casual daily wear.\r\nA simple yet stylish choice for active women.', 4.30, 50, '{\"fabric\":\"Breathable\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (11, 2, 'Men Running Shoes', '[\"7\",\"8\",\"9\",\"10\"]', '[\"Black\",\"White\"]', 2499.00, 2999.00, 'product/shoes1.jpg', '20', 'bestsellers', 'Run with confidence using these lightweight running shoes.\r\nDesigned for comfort, cushioning, and daily performance.\r\nBreathable material keeps your feet cool and fresh.\r\nPerfect for jogging, gym, and outdoor activities.\r\nA reliable choice for active lifestyles.', 4.60, 210, '{\"sole\":\"Rubber\"}', 'blocked', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (12, 2, 'Women Training Sneakers', '[\"5\",\"6\",\"7\",\"8\"]', '[\"Pink\",\"White\"]', 2399.00, 2799.00, 'product/shoes2.jpg', '20', 'trendy', 'Step into comfort with these stylish training sneakers.\r\nDesigned for gym workouts and everyday wear.\r\nSoft cushioning ensures all-day comfort and support.\r\nLightweight build improves movement and flexibility.\r\nPerfect blend of style and performance.', 4.50, 180, '{\"sole\":\"Foam\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (13, 2, 'Men Marathon Shoes', '[\"7\",\"8\",\"9\",\"10\"]', '[\"Blue\",\"Black\"]', 2699.00, 3199.00, 'product/shoes3.jpg', '20', 'trendy', 'Engineered for marathon runners seeking performance and comfort.\r\nLightweight construction enhances speed and endurance.\r\nProvides superior grip and stability on all surfaces.\r\nBreathable design keeps feet cool during long runs.\r\nIdeal for professional and casual runners alike.', 4.70, 220, '{\"weight\":\"Light\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (14, 2, 'Women Walking Shoes', '[\"5\",\"6\",\"7\"]', '[\"Grey\",\"Black\"]', 2199.00, 2599.00, 'product/shoes4.jpg', '20', 'bestsellers', 'Enjoy comfortable walks with these cushioned walking shoes.\r\nDesigned to reduce stress on feet during long use.\r\nSoft sole provides excellent support and grip.\r\nPerfect for daily walking and casual wear.\r\nStylish and practical for everyday use.', 4.40, 150, '{\"sole\":\"Cushion\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (15, 2, 'Men Gym Sneakers', '[\"7\",\"8\",\"9\"]', '[\"Black\"]', 2299.00, 2699.00, 'product/shoes5.jpg', '20', 'justArrived', 'Train harder with these stable gym sneakers.\r\nDesigned for strength training and workouts.\r\nHigh grip sole ensures safety and balance.\r\nDurable build for long-term use.\r\nPerfect for gym enthusiasts.', 4.30, 120, '{\"grip\":\"High\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (16, 2, 'Women Jogging Shoes', '[\"5\",\"6\",\"7\"]', '[\"Purple\",\"Black\"]', 2199.00, 2599.00, 'product/shoes6.jpg', '20', 'trendy', 'Lightweight jogging shoes designed for everyday running.\r\nBreathable material keeps feet fresh and dry.\r\nFlexible sole ensures smooth movement.\r\nPerfect for fitness and casual wear.\r\nA great choice for active individuals.', 4.40, 130, '{\"breathable\":\"Yes\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (17, 2, 'Men Trail Running Shoes', '[\"7\",\"8\",\"9\"]', '[\"Brown\",\"Black\"]', 2899.00, 3399.00, 'product/shoes7.jpg', '20', 'bestsellers', 'Durable trail running shoes built for outdoor adventures.\r\nStrong grip ensures stability on rough terrains.\r\nComfortable design for long-distance running.\r\nBreathable and lightweight construction.\r\nIdeal for trekking and trail runners.', 4.60, 140, '{\"outdoor\":\"Yes\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (18, 2, 'Women Cushion Sneakers', '[\"5\",\"6\",\"7\"]', '[\"White\",\"Blue\"]', 2399.00, 2799.00, 'product/shoes8.jpg', '20', 'trendy', 'Soft cushion sneakers designed for maximum comfort.\r\nProvides excellent support for daily use.\r\nLightweight design enhances flexibility.\r\nPerfect for casual wear and workouts.\r\nA stylish and comfortable option.', 4.50, 125, '{\"sole\":\"Soft\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (19, 2, 'Men Sport Casual Shoes', '[\"7\",\"8\",\"9\"]', '[\"Black\",\"Grey\"]', 1999.00, 2299.00, 'product/shoes9.jpg', '20', 'justArrived', 'Casual sports shoes for everyday comfort.\r\nDesigned for both style and performance.\r\nLightweight and durable construction.\r\nPerfect for daily activities.\r\nA versatile addition to your wardrobe.', 4.30, 90, '{\"style\":\"Casual\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (20, 2, 'Women Athletic Shoes', '[\"5\",\"6\",\"7\"]', '[\"Pink\",\"White\"]', 2499.00, 2899.00, 'product/shoes10.jpg', '20', 'bestsellers', 'Athletic shoes built for training and performance.\r\nLightweight design improves speed and agility.\r\nComfortable cushioning supports long workouts.\r\nBreathable fabric keeps feet cool.\r\nPerfect for active lifestyles.', 4.60, 170, '{\"weight\":\"Light\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (21, 3, 'Adjustable Dumbbell Set', '[]', '[\"Black\"]', 3499.00, 3999.00, 'product/gym5.jpg', '20', 'bestsellers', 'Upgrade your strength training with this adjustable dumbbell set.\r\nDesigned for versatile workouts targeting multiple muscle groups.\r\nDurable material ensures long-lasting performance and safety.\r\nPerfect for home gym and professional fitness routines.\r\nA compact and effective solution for strength building.', 4.70, 300, '{\"weight\":\"10kg\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (22, 3, 'Resistance Bands Kit', '[]', '[\"Multi\"]', 899.00, 1199.00, 'product/gym1.jpg', '20', 'trendy', 'Enhance your workouts with this resistance bands kit.\r\nComes with multiple resistance levels for varied training intensity.\r\nLightweight and portable for home or travel workouts.\r\nIdeal for strength training, stretching, and rehabilitation.\r\nA must-have fitness accessory for full-body workouts.', 4.50, 180, '{\"levels\":\"5\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (23, 3, 'Yoga Mat Premium', '[]', '[\"Blue\",\"Purple\"]', 999.00, 1299.00, 'product/gym6.jpg', '20', 'bestsellers', 'Practice yoga comfortably with this premium yoga mat.\r\nAnti-slip surface provides stability during poses.\r\nSoft cushioning protects joints and improves comfort.\r\nLightweight and easy to carry anywhere.\r\nPerfect for yoga, meditation, and exercise routines.', 4.60, 210, '{\"thickness\":\"6mm\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (24, 3, 'Push Up Bars', '[]', '[\"Black\"]', 699.00, 899.00, 'product/gym2.jpg', '20', 'trendy', 'Build upper body strength with these push up bars.\r\nDesigned to reduce wrist strain and improve posture.\r\nStrong and durable construction for safe workouts.\r\nCompact design makes it easy to carry and store.\r\nIdeal for home workouts and fitness training.', 4.40, 150, '{\"material\":\"Steel\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (25, 3, 'Kettlebell 12kg', '[]', '[\"Black\"]', 1799.00, 2199.00, 'product/gym9.jpg', '20', 'justArrived', 'Train like a pro with this 12kg kettlebell.\r\nPerfect for strength, endurance, and functional training.\r\nDurable build ensures long-lasting usage.\r\nComfortable grip allows better control during exercises.\r\nIdeal for both beginners and advanced users.', 4.50, 130, '{\"weight\":\"12kg\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (26, 3, 'Ab Roller Wheel', '[]', '[\"Black\",\"Green\"]', 799.00, 999.00, 'product/gym7.jpg', '20', 'bestsellers', 'Strengthen your core with this ab roller wheel.\r\nDual-wheel design provides better balance and stability.\r\nComfortable handles ensure firm grip during workouts.\r\nCompact and easy to use at home or gym.\r\nPerfect for core training and abs workouts.', 4.60, 200, '{\"wheel\":\"Dual\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (27, 3, 'Skipping Rope Trainer', '[]', '[\"Red\",\"Black\"]', 199.00, 399.00, 'product/gym3.jpg', '20', 'trendy', 'Boost your cardio workouts with this skipping rope trainer.\r\nAdjustable length makes it suitable for all heights.\r\nLightweight design ensures fast and smooth rotations.\r\nPerfect for endurance, weight loss, and fitness training.\r\nAn essential tool for effective cardio sessions.', 4.30, 140, '{\"length\":\"Adjustable\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (28, 3, 'Adjustable Weight Bench', '[]', '[\"Black\"]', 3499.00, 5999.00, 'product/gym10.jpg', '20', 'justArrived', 'Upgrade your home gym with this adjustable weight bench.\r\nDesigned for multiple workout positions and exercises.\r\nStrong and stable structure ensures safety during use.\r\nFoldable design allows easy storage and portability.\r\nPerfect for strength training and full-body workouts.', 4.70, 160, '{\"foldable\":\"Yes\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (29, 3, 'Medicine Ball 5kg', '[]', '[\"Black\",\"Orange\"]', 999.00, 1299.00, 'product/gym8.jpg', '20', 'bestsellers', 'Improve your core strength with this 5kg medicine ball.\r\nDurable material ensures long-lasting performance.\r\nProvides excellent grip for safe handling.\r\nIdeal for strength, balance, and coordination exercises.\r\nPerfect for gym and home workouts.', 4.40, 120, '{\"weight\":\"5kg\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (30, 3, 'Pull Up Bands Set', '[]', '[\"Multi\"]', 1199.00, 1499.00, 'product/gym4.jpg', '20', 'trendy', 'Enhance your pull-up training with this bands set.\r\nProvides support and resistance for better performance.\r\nDurable and stretchable material ensures long use.\r\nSuitable for beginners and advanced athletes.\r\nPerfect for strength training and assisted workouts.', 4.50, 130, '{\"resistance\":\"Heavy\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (31, 4, 'Waterproof Trekking Backpack 40L', '[]', '[\"Green\",\"Black\"]', 2999.00, 3499.00, 'product/trek5.jpg', '20', 'bestsellers', 'Carry your essentials with this waterproof trekking backpack.\r\nLarge capacity design makes it ideal for long trips.\r\nDurable material protects against rough outdoor conditions.\r\nComfortable straps reduce strain during travel.\r\nPerfect for trekking, hiking, and adventure trips.', 4.70, 140, '{\"capacity\":\"40L\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (32, 4, 'Aluminum Trekking Poles', '[]', '[\"Silver\"]', 1499.00, 1799.00, 'product/trek1.jpg', '20', 'trendy', 'Improve your trekking experience with these aluminum poles.\r\nLightweight design reduces fatigue during long hikes.\r\nStrong material ensures durability and support.\r\nAdjustable height for personalized comfort.\r\nIdeal for trekking, hiking, and outdoor adventures.', 4.50, 100, '{\"material\":\"Aluminum\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (33, 4, 'Camping Sleeping Bag', '[]', '[\"Blue\"]', 1999.00, 2299.00, 'product/trek6.jpg', '20', 'bestsellers', 'Stay comfortable during camping with this sleeping bag.\r\nDesigned for all-season use with proper insulation.\r\nSoft inner material ensures a cozy sleeping experience.\r\nCompact and easy to carry on trips.\r\nPerfect for camping and outdoor stays.', 4.60, 120, '{\"season\":\"All\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (34, 4, 'Hiking Boots Waterproof', '[\"7\",\"8\",\"9\"]', '[\"Brown\"]', 3499.00, 3999.00, 'product/trek2.jpg', '20', 'trendy', 'Explore confidently with these waterproof hiking boots.\r\nDurable sole provides excellent grip on rough terrains.\r\nComfortable design supports long-distance trekking.\r\nWaterproof material keeps feet dry in all conditions.\r\nPerfect for hiking and outdoor adventures.', 4.70, 160, '{\"sole\":\"Rubber\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (35, 4, 'LED Trekking Headlamp', '[]', '[\"Black\"]', 599.00, 799.00, 'product/trek9.jpg', '20', 'justArrived', 'Light your path with this LED trekking headlamp.\r\nBright illumination ensures clear visibility in the dark.\r\nRechargeable battery offers long-lasting performance.\r\nLightweight and comfortable to wear.\r\nIdeal for trekking, camping, and night activities.', 4.30, 80, '{\"battery\":\"Rechargeable\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (36, 4, 'Portable Camping Stove', '[]', '[\"Silver\"]', 1299.00, 1599.00, 'product/trek7.jpg', '20', 'bestsellers', 'Cook anywhere with this portable camping stove.\r\nCompact design makes it easy to carry on trips.\r\nEfficient fuel usage ensures long cooking time.\r\nDurable construction for outdoor use.\r\nPerfect for camping, trekking, and travel.', 4.50, 110, '{\"fuel\":\"Gas\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (37, 4, 'Hydration Backpack', '[]', '[\"Blue\"]', 2199.00, 2499.00, 'product/trek3.jpg', '20', 'trendy', 'Stay hydrated with this hydration backpack.\r\nIncludes water storage for long outdoor activities.\r\nLightweight design ensures comfortable carrying.\r\nPerfect for trekking, running, and cycling.\r\nA must-have for outdoor fitness enthusiasts.', 4.40, 90, '{\"water\":\"2L\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (38, 4, 'Waterproof Trek Jacket', '[\"M\",\"L\",\"XL\"]', '[\"Green\"]', 2799.00, 3199.00, 'product/trek8.jpg', '20', 'bestsellers', 'Stay protected with this waterproof trekking jacket.\r\nDesigned to withstand wind and rain conditions.\r\nLightweight material ensures comfort during wear.\r\nPerfect for outdoor activities and travel.\r\nA reliable choice for all-weather protection.', 4.60, 130, '{\"layer\":\"Windproof\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (39, 4, 'Outdoor Survival Kit', '[]', '[\"Black\"]', 899.00, 1199.00, 'product/trek10.jpg', '20', 'justArrived', 'Be prepared with this outdoor survival kit.\r\nIncludes essential tools for emergency situations.\r\nCompact design makes it easy to carry.\r\nDurable components ensure reliability.\r\nPerfect for trekking, camping, and outdoor safety.', 4.30, 70, '{\"items\":\"10\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (40, 4, 'Foldable Camping Chair', '[]', '[\"Blue\"]', 1499.00, 1799.00, 'product/trek4.jpg', '20', 'trendy', 'Relax anywhere with this foldable camping chair.\r\nLightweight and portable design for easy transport.\r\nStrong frame ensures durability and stability.\r\nComfortable seating for outdoor use.\r\nPerfect for camping, picnics, and travel.', 4.50, 100, '{\"weight\":\"Light\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (41, 5, 'Mountain Bike 26 Inch', '[]', '[\"Black\",\"Red\"]', 5759.00, 8999.00, 'product/cycle1.jpg', '20', 'bestsellers', 'Experience thrilling rides with this mountain bike.\r\nEquipped with multiple gears for smooth performance.\r\nStrong frame ensures durability on rough terrains.\r\nComfortable seating for long rides.\r\nPerfect for adventure and off-road cycling.', 4.70, 210, '{\"gears\":\"21\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (42, 5, 'Hybrid City Bicycle', '[]', '[\"Blue\"]', 11999.00, 15999.00, 'product/cycle2.jpg', '20', 'trendy', 'Enjoy city rides with this hybrid bicycle.\r\nDesigned for comfort and daily commuting.\r\nStrong frame ensures durability and balance.\r\nSmooth handling makes riding effortless.\r\nPerfect for urban travel and fitness.', 4.60, 190, '{\"frame\":\"Steel\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (43, 5, 'Kids Bicycle 20 Inch', '[]', '[\"Yellow\"]', 4999.00, 9999.00, 'product/cycle3.jpg', '20', 'bestsellers', 'Give your kids a fun ride with this sports bicycle.\r\nDesigned with safety and comfort in mind.\r\nDurable build ensures long-lasting use.\r\nSmooth ride for everyday cycling.\r\nPerfect for young riders and beginners.', 4.50, 150, '{\"age\":\"7-10\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (44, 5, 'Road Racing cycle', '[]', '[\"Black\"]', 21999.00, 23999.00, 'product/cycle4.jpg', '20', 'trendy', 'Ride faster with this lightweight road racing cycle.\r\nAerodynamic design improves speed and performance.\r\nStrong frame ensures durability.\r\nComfortable for long-distance rides.\r\nIdeal for racing and professional use.', 4.70, 120, '{\"frame\":\"Aluminum\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (45, 5, 'Folding Bicycle', '[]', '[\"Grey\"]', 10750.00, 15999.00, 'product/cycle9.jpg', '20', 'justArrived', 'Carry your bike anywhere with this folding bicycle.\r\nCompact design allows easy storage and transport.\r\nDurable frame ensures stability.\r\nSmooth riding experience for daily use.\r\nPerfect for travel and urban commuting.', 4.50, 90, '{\"foldable\":\"Yes\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (46, 5, 'MTB Offroad Bike', '[]', '[\"Green\"]', 16999.00, 18999.00, 'product/cycle5.jpg', '20', 'bestsellers', 'Conquer rough terrains with this MTB offroad bike.\r\nStrong suspension ensures a smooth ride.\r\nDurable build for long-lasting performance.\r\nComfortable seating for long rides.\r\nPerfect for adventure cycling.', 4.60, 160, '{\"suspension\":\"Front\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (47, 5, 'Women City Bike', '[]', '[\"Pink\"]', 4799.00, 6899.00, 'product/cycle6.jpg', '20', 'trendy', 'Enjoy comfortable rides with this women city bike.\r\nDesigned for ease and style.\r\nLightweight frame ensures smooth handling.\r\nPerfect for daily commuting and leisure rides.\r\nA stylish and practical choice.', 4.40, 110, '{\"style\":\"Comfort\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (49, 5, 'Sports Gear Cycle', '[]', '[\"Red\"]', 5699.00, 6999.00, 'product/cycle5.jpg', '20', 'trendy', 'Ride with power using this sports gear cycle.\r\nMultiple gears provide better speed control.\r\nDurable build ensures long-term usage.\r\nComfortable design for long rides.\r\nPerfect for fitness and adventure cycling.', 4.50, 130, '{\"gears\":\"24\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (50, 5, 'Electric Assist Cycle', '[]', '[\"Black\"]', 21999.00, 25000.00, 'product/cycle10.jpg', '20', 'justArrived', 'Experience advanced riding with this electric assist cycle.\r\nBattery-powered support makes riding effortless.\r\nDurable build ensures reliability.\r\nSmooth and comfortable riding experience.\r\nPerfect for modern commuting.', 4.80, 90, '{\"battery\":\"Lithium\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (51, 6, 'Professional Swim Goggles', '[]', '[\"Black\"]', 799.00, 999.00, 'product/swim2.jpg', '20', 'bestsellers', 'Swim with clarity using these professional goggles.\r\nAnti-fog lenses ensure clear underwater vision.\r\nComfortable fit prevents water leakage.\r\nDurable material for long use.\r\nPerfect for swimming training and competitions.', 4.60, 150, '{\"antiFog\":\"Yes\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (52, 6, 'Silicone Swim Cap', '[]', '[\"Blue\",\"Black\"]', 399.00, 499.00, 'product/swim1.jpg', '20', 'trendy', 'Protect your hair with this silicone swim cap.\r\nStretchable design ensures a secure fit.\r\nWater-resistant material keeps hair dry.\r\nComfortable for long swimming sessions.\r\nIdeal for beginners and professionals.', 4.40, 100, '{\"material\":\"Silicone\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (53, 6, 'Men Swim Shorts', '[\"M\",\"L\",\"XL\"]', '[\"Blue\"]', 999.00, 1199.00, 'product/swim3.jpg', '20', 'bestsellers', 'Enjoy swimming with these quick-dry swim shorts.\r\nLightweight fabric ensures comfort in water.\r\nElastic waistband provides a perfect fit.\r\nDurable material for long-lasting use.\r\nPerfect for pool and beach wear.', 4.50, 120, '{\"fabric\":\"Polyester\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (54, 6, 'Women One Piece Swimsuit', '[\"S\",\"M\",\"L\"]', '[\"Black\"]', 1499.00, 1799.00, 'product/swim4.jpg', '20', 'trendy', 'Stay stylish with this women one-piece swimsuit.\r\nComfortable fit enhances movement in water.\r\nHigh-quality fabric ensures durability.\r\nPerfect for training and leisure swimming.\r\nA great choice for active women.', 4.60, 140, '{\"fit\":\"Slim\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (55, 6, 'Swimming Ear Plugs', '[]', '[\"Orange\"]', 199.00, 299.00, 'product/swim5.jpg', '20', 'justArrived', 'Keep water out with these swimming ear plugs.\r\nSoft material ensures comfort during use.\r\nReusable and easy to carry.\r\nProvides effective ear protection.\r\nPerfect for regular swimmers.', 4.20, 70, '{\"material\":\"Silicone\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (56, 6, 'Kids Swim Goggles', '[]', '[\"Green\"]', 399.00, 499.00, 'product/swim6.jpg', '20', 'bestsellers', 'Make swimming fun for kids with these goggles.\r\nAnti-fog lenses ensure clear vision.\r\nComfortable fit designed for children.\r\nDurable and safe materials used.\r\nPerfect for learning and training.', 4.40, 80, '{\"antiFog\":\"Yes\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (57, 6, 'Training Kickboard', '[]', '[\"Yellow\"]', 699.00, 899.00, 'product/swim7.jpg', '20', 'trendy', 'Improve swimming skills with this training kickboard.\r\nProvides support for beginners.\r\nDurable foam construction ensures long use.\r\nLightweight and easy to handle.\r\nPerfect for swim training sessions.', 4.50, 90, '{\"foam\":\"HighDensity\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (58, 6, 'Men Swim Trunks', '[\"M\",\"L\"]', '[\"Black\"]', 899.00, 1099.00, 'product/swim8.jpg', '20', 'bestsellers', 'Enjoy water activities with these swim trunks.\r\nQuick-dry fabric ensures comfort.\r\nElastic fit for better support.\r\nDurable and stylish design.\r\nPerfect for swimming and beach wear.', 4.40, 85, '{\"quickDry\":\"Yes\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (59, 6, 'Women Training Swimsuit', '[\"S\",\"M\"]', '[\"Blue\"]', 1599.00, 1899.00, 'product/swim9.jpg', '20', 'trendy', 'Train efficiently with this women training swimsuit.\r\nStretchable fabric allows free movement.\r\nComfortable fit for long sessions.\r\nDurable and stylish design.\r\nPerfect for professional training.', 4.60, 95, '{\"fit\":\"Stretch\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (60, 6, 'Anti Fog Swim Goggles Pro', '[]', '[\"Black\"]', 899.00, 1099.00, 'product/swim10.jpg', '20', 'justArrived', 'Upgrade your swim gear with pro anti-fog goggles.\r\nEnhanced visibility underwater.\r\nComfortable and leak-proof design.\r\nDurable for long-term use.\r\nIdeal for competitive swimmers.', 4.70, 110, '{\"antiFog\":\"Pro\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (61, 7, 'Gym Duffel Bag', '[]', '[\"Black\"]', 1299.00, 1499.00, 'product/bag1.jpg', '20', 'bestsellers', 'Carry your gear easily with this gym duffel bag.\r\nSpacious design fits all essentials.\r\nDurable material ensures long use.\r\nComfortable straps for easy carrying.\r\nPerfect for gym and travel.', 4.60, 130, '{\"capacity\":\"30L\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (62, 7, 'Hiking Backpack 50L', '[]', '[\"Green\"]', 2999.00, 3499.00, 'product/bag2.jpg', '20', 'trendy', 'Take on long trips with this hiking backpack.\r\nLarge capacity design for all essentials.\r\nDurable material for rugged use.\r\nComfortable straps reduce strain.\r\nPerfect for trekking and travel.', 4.70, 160, '{\"capacity\":\"50L\"}', 'blocked', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (63, 7, 'Laptop Travel Backpack', '[]', '[\"Grey\"]', 1999.00, 2299.00, 'product/bag3.jpg', '20', 'bestsellers', 'Keep your laptop safe with this travel backpack.\r\nPadded compartment protects devices.\r\nDurable and stylish design.\r\nComfortable for daily use.\r\nPerfect for office and travel.', 4.50, 140, '{\"laptop\":\"15inch\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (64, 7, 'Camping Backpack', '[]', '[\"Blue\"]', 2499.00, 2799.00, 'product/bag4.jpg', '20', 'trendy', 'Carry essentials with this camping backpack.\r\nSpacious and durable design.\r\nComfortable straps for long use.\r\nLightweight for easy travel.\r\nPerfect for outdoor adventures.', 4.60, 120, '{\"capacity\":\"45L\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (65, 7, 'Running Backpack', '[]', '[\"Black\"]', 999.00, 1199.00, 'product/bag5.jpg', '20', 'justArrived', 'Stay light with this running backpack.\r\nCompact design for minimal load.\r\nComfortable fit during movement.\r\nDurable material ensures long use.\r\nPerfect for runners and cyclists.', 4.30, 90, '{\"weight\":\"Light\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (66, 7, 'Multi Pocket Gym Bag', '[]', '[\"Black\"]', 1399.00, 1599.00, 'product/bag6.jpg', '20', 'bestsellers', 'Organize your gear with this multi-pocket gym bag.\r\nMultiple compartments for easy storage.\r\nDurable and strong material.\r\nComfortable to carry.\r\nPerfect for gym and travel use.', 4.40, 100, '{\"pockets\":\"6\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (67, 7, 'Rain Cover Trek Bag', '[]', '[\"Green\"]', 2899.00, 3199.00, 'product/bag7.jpg', '20', 'trendy', 'Protect your gear with this trek bag with rain cover.\r\nWater-resistant material ensures safety.\r\nSpacious design for long trips.\r\nComfortable to carry.\r\nPerfect for trekking and travel.', 4.50, 110, '{\"rainCover\":\"Yes\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (68, 7, 'Anti Theft Travel Bag', '[]', '[\"Grey\"]', 1799.00, 1999.00, 'product/bag8.jpg', '20', 'bestsellers', 'Travel securely with this anti-theft backpack.\r\nDesigned with safety features.\r\nDurable and stylish design.\r\nComfortable for daily use.\r\nPerfect for travel and commuting.', 4.60, 130, '{\"security\":\"AntiTheft\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (69, 7, 'Foldable Sports Bag', '[]', '[\"Blue\"]', 799.00, 999.00, 'product/bag9.jpg', '20', 'trendy', 'Carry extra luggage with this foldable sports bag.\r\nCompact when folded, spacious when used.\r\nDurable material ensures long use.\r\nLightweight and easy to carry.\r\nPerfect for travel and sports.', 4.30, 80, '{\"foldable\":\"Yes\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (70, 7, 'Large Training Bag', '[]', '[\"Black\"]', 1599.00, 1799.00, 'product/bag10.jpg', '20', 'justArrived', 'Carry more with this large training bag.\r\nSpacious design for all essentials.\r\nDurable build for long-term use.\r\nComfortable carrying straps.\r\nPerfect for gym and travel.', 4.40, 95, '{\"capacity\":\"40L\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (71, 8, 'Sports Water Bottle', '[]', '[\"Blue\"]', 399.00, 499.00, 'product/acc1.jpg', '20', 'bestsellers', 'Stay hydrated with this sports water bottle.\r\nLarge capacity for long workouts.\r\nDurable and leak-proof design.\r\nEasy to carry and use.\r\nPerfect for gym and outdoor activities.', 4.50, 200, '{\"capacity\":\"1L\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (72, 8, 'Wrist Support Bands', '[]', '[\"Black\"]', 299.00, 399.00, 'product/acc2.jpg', '20', 'trendy', 'Support your wrists with these fitness bands.\r\nElastic design ensures flexibility.\r\nProvides stability during workouts.\r\nComfortable for long use.\r\nPerfect for gym training.', 4.40, 150, '{\"elastic\":\"Yes\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (73, 8, 'Digital Stopwatch', '[]', '[\"Black\"]', 699.00, 899.00, 'product/acc3.jpg', '20', 'bestsellers', 'Track time accurately with this digital stopwatch.\r\nClear display for easy reading.\r\nDurable and lightweight design.\r\nEasy to use controls.\r\nPerfect for sports and training.', 4.60, 180, '{\"display\":\"LCD\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (74, 8, 'Cycling Helmet', '[]', '[\"Red\",\"Black\"]', 1499.00, 1799.00, 'product/acc4.jpg', '20', 'trendy', 'Protect your head with this cycling helmet.\r\nStrong build ensures safety.\r\nComfortable fit for long rides.\r\nLightweight and durable design.\r\nPerfect for cycling and outdoor sports.', 4.70, 160, '{\"safety\":\"Certified\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (75, 8, 'Running Arm Phone Holder', '[]', '[\"Black\"]', 499.00, 599.00, 'product/acc5.jpg', '20', 'justArrived', 'Keep your phone secure with this running arm holder.\r\nAdjustable strap for perfect fit.\r\nLightweight and comfortable design.\r\nDurable material for long use.\r\nPerfect for running and workouts.', 4.30, 100, '{\"size\":\"Universal\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (76, 8, 'Fitness Smart Band', '[]', '[\"Black\"]', 1999.00, 2299.00, 'product/acc6.jpg', '20', 'bestsellers', 'Track fitness with this smart band.\r\nMonitors health and activity levels.\r\nComfortable and stylish design.\r\nLong battery life for continuous use.\r\nPerfect for fitness enthusiasts.', 4.60, 210, '{\"features\":\"HeartRate\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (77, 8, 'Gym Training Gloves', '[]', '[\"Black\"]', 599.00, 799.00, 'product/acc7.jpg', '20', 'trendy', 'Improve grip with these gym training gloves.\r\nProvides comfort during weightlifting.\r\nDurable material ensures long use.\r\nBreathable design keeps hands cool.\r\nPerfect for gym workouts.', 4.50, 170, '{\"grip\":\"Strong\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (78, 8, 'Sports Headband', '[]', '[\"White\"]', 199.00, 299.00, 'product/acc8.jpg', '20', 'bestsellers', 'Stay sweat-free with this sports headband.\r\nSoft fabric absorbs moisture effectively.\r\nComfortable for long workouts.\r\nStretchable for perfect fit.\r\nIdeal for sports and gym use.', 4.20, 90, '{\"fabric\":\"Cotton\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (79, 8, 'Cycling Sunglasses', '[]', '[\"Black\"]', 899.00, 1099.00, 'product/acc9.jpg', '20', 'trendy', 'Protect your eyes with cycling sunglasses.\r\nUV protection for outdoor rides.\r\nLightweight and stylish design.\r\nComfortable for long use.\r\nPerfect for cycling and sports.', 4.40, 120, '{\"UV\":\"400\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'), (80, 8, 'Knee Support Brace', '[]', '[\"Black\"]', 499.00, 699.00, 'product/acc10.jpg', '20', 'justArrived', 'Protect your knees with this support brace.\r\nAdjustable design ensures proper fit.\r\nProvides stability during workouts.\r\nComfortable and durable material.\r\nPerfect for injury prevention and support.', 4.50, 130, '{\"support\":\"Adjustable\"}', 'active', '2026-03-09 15:37:45', '2026-03-09 15:37:45'); -- -------------------------------------------------------- -- -- Table structure for table `product_images` -- CREATE TABLE `product_images` ( `id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) UNSIGNED NOT NULL, `image_path` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `referral_transactions` -- CREATE TABLE `referral_transactions` ( `id` bigint(20) UNSIGNED NOT NULL, `partner_id` bigint(20) UNSIGNED NOT NULL, `customer_id` bigint(20) UNSIGNED NOT NULL, `order_id` bigint(20) UNSIGNED NOT NULL, `referral_code` varchar(50) DEFAULT NULL, `commission_amount` decimal(10,2) DEFAULT 0.00, `discount_amount` decimal(10,2) DEFAULT 0.00, `status` enum('pending','confirmed','cancelled') DEFAULT 'pending', `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `referral_transactions` -- INSERT INTO `referral_transactions` (`id`, `partner_id`, `customer_id`, `order_id`, `referral_code`, `commission_amount`, `discount_amount`, `status`, `created_at`, `updated_at`) VALUES (1, 3, 17, 14, 'QIKXM73Q', 124.95, 124.95, 'pending', '2025-10-16 05:59:31', '2026-01-03 09:20:03'), (2, 2, 17, 15, 'QIKXM73Q', 124.95, 124.95, 'pending', '2025-10-16 06:03:33', '2025-10-16 06:03:33'), (3, 2, 17, 16, 'QIKXM73Q', 124.95, 124.95, 'pending', '2025-10-16 07:36:25', '2025-10-16 07:36:25'), (4, 2, 17, 17, 'QIKXM73Q', 249.90, 249.90, 'pending', '2025-10-16 08:05:43', '2025-10-16 08:05:43'), (5, 23, 21, 21, '5MAUDHOL', 124.95, 124.95, 'pending', '2025-12-13 07:50:51', '2025-12-13 07:50:51'), (6, 28, 21, 35, '75FX65BC', 124.95, 124.95, 'pending', '2026-01-05 16:45:53', '2026-01-05 16:45:53'), (13, 3, 33, 54, 'QIKXM73Q', 124.95, 124.95, 'pending', '2026-01-06 14:03:10', '2026-01-06 14:03:10'), (19, 2, 33, 60, 'QIKXM73Q', 124.95, 124.95, 'pending', '2026-01-06 15:44:13', '2026-01-06 15:44:13'), (20, 3, 21, 61, 'WWHTMOOJ', 124.95, 124.95, 'pending', '2026-01-07 10:12:57', '2026-01-07 10:12:57'), (21, 28, 5, 64, '75FX65BC', 124.95, 124.95, 'pending', '2026-01-21 13:04:30', '2026-01-21 13:04:30'), (22, 28, 34, 66, '75FX65BC', 124.95, 124.95, 'pending', '2026-01-27 13:01:45', '2026-01-27 13:01:45'), (23, 27, 29, 75, '4QAQ6KHT', 124.95, 124.95, 'pending', '2026-02-19 14:01:07', '2026-02-19 14:01:07'), (24, 3, 29, 81, 'WWHTMOOJ', 0.05, 0.05, 'pending', '2026-02-20 04:37:28', '2026-02-20 04:37:28'), (25, 3, 29, 83, 'WWHTMOOJ', 0.05, 0.05, 'pending', '2026-02-20 06:52:28', '2026-02-20 06:52:28'), (26, 3, 29, 84, 'WWHTMOOJ', 0.05, 0.05, 'pending', '2026-02-20 06:53:56', '2026-02-20 06:53:56'), (27, 3, 29, 85, 'WWHTMOOJ', 0.05, 0.05, 'pending', '2026-02-20 07:37:33', '2026-02-20 07:37:33'); -- -------------------------------------------------------- -- -- Table structure for table `reviews` -- CREATE TABLE `reviews` ( `id` bigint(20) UNSIGNED NOT NULL, `customer_id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) UNSIGNED NOT NULL, `rating` tinyint(4) NOT NULL COMMENT '1 to 5', `review` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('1huWUBD6AuUqjXngjw38DzRD8L7qYgr1QouH5k1K', NULL, '43.167.232.38', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiam82VHRiRnltOTFxTmZlbFVrd0FGSUVmeE16UlVWV3dZNFY5TlFLYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778521070), ('3HkBx6f8canhgEYanCZwiMkFuED0oUe0fD4UkIBV', NULL, '35.208.206.72', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUjZocFF2OTVSRjVYcWdlcGVHQzFzVlhmanB2cFpsSlBHQmNseHNlTCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779408751), ('49DnpGa5cn66Q02It5eFyo1NfvTZXhMplI3uRZ5J', NULL, '43.159.136.201', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSGFINFBUdHd2M2JCNG9SQ2Y4cEt6OGYxZDdsaDR2N1dXeWdOaEZjayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778826222), ('5ERPgq6QDTrPsKPImZedU99faAzom8ySnDK62X1I', NULL, '74.7.243.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieDRHNm9xR3RTQ0RadTZKVGN0ZWxHc3hMNVFENUZRVk9qV1AwM3dKWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1778898782), ('5HGtFq1RdMnUtDH4R6JyXSoMru5RbnTAIYZpbu9q', NULL, '35.227.88.2', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiblJKbU9uNklpWWJ5NkFTSlFUTExqdzRpUzlLSmhxWHZoaTBsdlhzWiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779290120), ('5Vl4XqX1uR5QwxAQCle9Kh226ZaEn7Logf438XBP', NULL, '43.130.32.245', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRU1BcWlMWml4VUE0VmlERmN1Q3o5MXN1QzRXQTZQMVFXNmJWclU5SCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779478525), ('61TVHbh93KB6gS5sePf0lf7A0uUhvZ0kXqGa8OXR', NULL, '66.132.172.222', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUWxyTENSRGFpaWF1b2xVcXRwVFJLMEx4a0dzazdQV05NYWtqdGJTbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778901882), ('6lrah7OVsl7QzEOiVVGYJahjFNrwJm6NFhSwHsJR', NULL, '43.165.186.188', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTHBKRTlTYkJWdFJNSVBtUG42OFIzZHQxalpTS2FNaWc5R2ZJMU9MNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779244394), ('7OoI72guF71vIEjhAI91zoKacuv3mPSqEtzKKTnn', NULL, '34.70.81.76', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQk5CUTd4bWwyYXJhVjdFZlE4RnFWa2ZNb25oRVZSZ2t2NVFVaTVYaCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779289941), ('9ccMPkW9fRpvVEy73wyEu8jIHgDO5NqspZ9qyQEA', NULL, '43.134.187.251', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMnNGSkpMeHE0RUk3S25aTGtjZHNaU2kxbnhVSXlmYWRMdWg0SDBOVyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779186019), ('A6UwJZVMUeCyHKBXuVLijGYDpsZFhv0D6ret6PcU', NULL, '43.156.249.28', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTmhOVnNIeFBwU1NwZFkyS2g0UEprN2hITm5aWFhSTDlwU1pmaGwwUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779199402), ('AWbUroDAyYDxHR0skZEtJfpKfb92v9FgEvp3PsOt', NULL, '34.7.189.4', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiT3NTbDNIYjNXNjI2ZlVmRmZGeHhQQXUxa3ZjU0h5bk13clNScnljRSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779287485), ('bN2bXrWcDsQskJgyaO7jqXbf6kYNBpPTpXCBZdMj', NULL, '34.229.69.171', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:139.0) Gecko/20100101 Firefox/139.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicGkxTU9rdENMR04yd2lnTGw4bmc4dE1meDhHVDVkdzBtN1hiYWpkNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1778866290), ('cK5xotzbyH9WlL61QpsLpQdafTIrg9oVbPzc6rRR', NULL, '66.132.172.194', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidEJDVFZDM3VKWmozQU54UmFVT2dCaFlnd2FQWllRU3Bpc25mYlR3biI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1778901014), ('dY3roQEAEyGN5BoXlzK1sOL0khkgjKx8N8naDDPV', NULL, '185.122.113.205', 'Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibmFDcUtlOXJQN1M3OTZrUzNxb2w4d3JXdmJDMzFwcEtzTTZWdUFGYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778650076), ('EVmI8rtfT9I57XSKGZoUO6AZ08SwcjAJ7vnHAuxW', NULL, '205.210.31.34', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOUNpTmFPdXFIbTNHYjdJWG0zUGJXQlRDTWg4WGVISkFnbDQ3cjNWdyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1779533139), ('eY5eYEsC2L1IlslepR1OO9MexdPRH8m5DByn2Hwp', NULL, '34.9.216.246', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYWdVNWo3dnVHN1VPeXR5ZlBhWVNqcjFUTUdEYWVxSXZmcjFIc3JLbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1779306169), ('fgHpeaPcvwYaF39AqfCHmW4f80FfVRB5FDIKT3fT', NULL, '49.51.204.74', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNnlSSkFnQTZ3R1VDSnc1T0cyM05ZVE1sbWFYeVN6aTljWkFsQmZhdyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779157104), ('fmtDIMo51vh9lzMYoiCmsvhDyV3KCkjswkMKIvcm', NULL, '43.159.136.201', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSW1GSHJBcVlvcmFoWHh3cmxxWndHeXhzN3pSV2xrc2ppbk1uWVdBNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778664991), ('fMtKEytVzb79wqsuz6nB90aSoYsiwqa1kerRChvr', NULL, '43.133.253.253', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOUt1YlJYVDlrYkpjZWxTQ0N4WkR5a2lMRnNqQnphc2dlZW5MdktPbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778445756), ('fPrObjJNUbFZIWrRHWGFzvboR2Ya3Jrwp1gXQuTj', NULL, '43.166.238.12', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMndIenhPSFRLTEdtTkFOWjFUc3dBN3Q4bFVIdGdIRHF4ZWJ6aEZTViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778710079), ('GKnMcVqjOVbWNMdUmUmqtlTrkrO2NQk3Ia4s0FR7', NULL, '205.210.31.39', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoid1JRQ3l0M0I4MlVnWm85UERVdVNZazRZamQyaE5MZVFMc3ROTk16eiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1779112451), ('gkXENQXYoeO2sz4FOJqq6MEoNpkoxUTRMUSksGhp', NULL, '43.166.134.114', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZkJJSU1DbWdVamhRejF5dDhBRE0xaXlQeUh4UWVDZGxTNjNHTWhiTSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779171811), ('h0FpTZO0o0Gd68gQoheJDaW61tVqd1WocgKkeoIz', NULL, '43.153.58.28', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMmw1a2loZTNlSVc1bE8xSHowQTh2WnpvOTk4MFFFdXVRTWZ6SE9RdCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779213328), ('iF0lugNHeRTaqRjHJFHL717QSfy2qBFm7A76gcv0', NULL, '43.153.205.132', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNGdlMWg2ZUxQdUlwSktVUk1VUHlHMXRsYjM0T2ZKdEZhTEFoVnFtayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779101157), ('iN719bPAWOJYIfWbEsrfQVIL14cDWH69iTSjcuCE', NULL, '66.132.172.211', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOG9LV1paeWxyYzd0dWR0dG9ndTJZcGtCaDM3d043b2FBeFNXTGpVbiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1778941841), ('jDUWPoJ5D8XicJMRlAEYoqkxPIGRYP6vjAPguxhE', NULL, '3.18.186.238', 'visionheight.com/scan Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) Chrome/126.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicDNNaFZnUXFSQzMwc2hIbE1Ib1BGcXFmdU40RGp5RHdrdEZaYXVDbiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778565864), ('JpwTT9OFZtI2fxJTsaYnGzgNClrObigpHZzhCEfc', NULL, '176.65.139.234', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRUhPMGhLazJ0Zk5zbWtORFpWVDBzWHNlZjBDSzF6SWRoMFdpSFlURSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1779366042), ('jSjacaQkqLerFysp9T36J9Vib4baExjJspQDqkuV', NULL, '43.134.121.208', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUVRsM25iOWN6WmxYNFhZSlF5a1ZqWWJUNjR6U0RpMmVPQ2pSdExhTSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778725123), ('Kb7SKMDRDiuLRbiEg9O17XLkPzbbreeEtTIxhvZE', NULL, '43.166.244.192', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTzByUDVzUnpVbkJrc1RPeXNqVEk2UHVwVGtkakpxN2dZREtNdlRxNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779456482), ('kEjL3jeFUKXZyRQZk8kc9LpahNA28CmRzVo65xhT', NULL, '176.65.139.237', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ2U1RTBOZ3I4eGdjTE9ldkVqNHg1T2R3TlkwZzlMTnBwQjhiRjZTQSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1778641553), ('kVNlEmbZSyyzhc0hmBFoWZ1wQq2F4uMaZCayRO6J', NULL, '43.166.244.192', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiUVpxVDZSc05rRHVFb0JYczNyZkJNU2FSWW81cUdPZ250MzZFeUlTaSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MzoiaHR0cDovL2FkbWluLmhlYWRub2Rlc29sdXRpb24uY29tL2Rhc2hib2FyZCI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQzOiJodHRwOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20vZGFzaGJvYXJkIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1779456479), ('l22e0ynQfWokt8J6790W6gD8Nwo0miLOvzU3NfDO', NULL, '49.51.33.159', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibEVSS2NReUFWYUdQRjRhZFdWVUV2WUp6Mk1zR2had0I4TnB5djVnQyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778635771), ('LAhb7ML87JGPbXen60eGiLqbGKVRA1rrSqwrYYcH', NULL, '119.28.100.147', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVzRvZzIwWHBWaEFQd2QyOEFacE5heHJmUlRDZDNwRDZGTjJpYTZLYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778811723), ('P56XFvcTFEIEulyP9KNepkzz0gkwjywvtNH6Xgl3', NULL, '49.51.204.74', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRGhpZzZaQk0yQ0txbEcyTTJYb2dHNXRjcTVYOXo5eEx0MmFqeUlZQSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778536811), ('p6Vt2TLQRSTMdk7A9CUnvZVSdNYSqxqpwSg82y3f', NULL, '87.236.176.73', 'Mozilla/5.0 (compatible; InternetMeasurement/1.0; +https://internet-measurement.com/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoic053V0lXM2xyTlpBVlVBR1NLS1ptZXVEcnRPbXZPSXdQOVEwWXdYNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1779457743), ('PimB9GgrKPBS7HNSBoM2j7oZatu8xGReI5KrNapx', NULL, '3.18.186.238', 'visionheight.com/scan Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) Chrome/126.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQlM5aUxUYkNrQWw5WVpMT2NCNVdtNU1XSjk4R3hXdlQza0tuREVMUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1778565967), ('PpeqiuVrqO7gev6j4V679q3lSvcG0THC5zWJdkpC', NULL, '43.157.67.70', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQjFOUjFIUmlYY1R3UmRPRkJLTFBiWFpQRXRZNXJmRVM2bm1HNVF3ZiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MzoiaHR0cDovL2FkbWluLmhlYWRub2Rlc29sdXRpb24uY29tL2Rhc2hib2FyZCI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQzOiJodHRwOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20vZGFzaGJvYXJkIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1778693219), ('PSOCiKrd89V0DexVmAmbbaeI9G5trKKy8JY2saUe', NULL, '129.226.152.67', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVkNCd0RSYlNYSW53bDBoYUZBUWZHSXRYSmF4SjJxZzFHRGpCajRTQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779455633), ('Q816foeHOHi6DfDVBdz35r8jsTl9AzGNUjIv8DdM', NULL, '74.7.242.9', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOHNxMHcxVHFBNnk5NmQyc0p6ZTF1c1d0cG04eXMzVkdOb09aQVNHZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1778444445), ('QCqbGmSCGuCayKTLNSrWiorWSiHWUShiYhOppiD9', NULL, '167.94.146.56', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ2tNMW1YWURLSENtcTBrZHhKU1VEcFo1TEFoSWFCTHhRbG5tVVNxQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778943073), ('r1YfULRxSdT4sbqnqKX4GGyJZAUWPcMA4byMNr4V', NULL, '43.157.38.228', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ2RPUWNtSU5zcnUwZUJMS0RCclpHS3BZQnRSaXB0Um5JbTcyZ0F1aCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779087109), ('RC8wff6RuB4vTc3K0Mt88d41ECW39w3iVD8KVo5k', NULL, '43.156.204.134', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSnN5aFRTdVJSdENMSTJySG5iOGxnT1l4QjJJcWgwaFBDYXJjMGdvSCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779272421), ('RUEhMt30omeayHzJsxJfGfHrNOPvJdE5YGtFDJ81', NULL, '159.89.234.126', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVmg1RkRQTGdjb1JRTTlmSUNRbUY1SXhGSUhZN2ZrRXE0ekp4aTBoZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779016850), ('sJPE3FzvOxAbNeEl6lHgzhLcdmd5irX86Vhbr1G7', NULL, '43.153.204.189', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiczR6OGxXeThsYkVjVVR5bkttbEwxMXVCeUVicGk5UXpMUzhKSUR6TiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779258779), ('swm5BYLTnKy5ucO4BchN6IyQgqhpXWGekv5Mi5iP', NULL, '205.210.31.53', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiY3M5d1Fxc2Q5cFEwM25mQ0VKSzBvczlFUks0UmdkSXFQWlFuN2ZsTSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779639706), ('SXZ5ZGvkAJ7mEpYi1mXKvC2yeDznC779WNhYLoq3', NULL, '43.165.167.72', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ0dpWUs4ZDRIZFBPZXdiUUlLWURCMzVPNTZWVkJ4Nk9EMWlVN1VubSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778752406), ('tOIZZ8UNuKRvRJy1SFegRmWn4nfM23fo35OyL9gQ', NULL, '43.157.95.239', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYTFIQzluQ21ON0dPbzRtbXZWZVo1dUlxWEQ1b042a3VHZ08xRVRoUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779071778), ('tRwOOdEVu9zJKHlg3OKEZtVCnupYFkUBXa2jEn8j', NULL, '74.7.243.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMzRYUVIwTUd2cDRyd2EyeDAwakFsaUpqcjAwTjdUc0VveG1KcjkwYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1779212055), ('TsEF6mnSgrHVxh0gEuRfCmksTllE8fQfo7zeR7oR', NULL, '49.51.203.164', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ05uMEFzTnRhVUZXQlFCWm5xb2NrN29PMW1wanRBQm9ranVJT1lRbSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1779229118), ('UqqNUCPg6WtlHNfQFCNoiqvrE5gVujEMOHGWb0wn', NULL, '150.109.230.210', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQmVrSGZaeEZEY0xzV2xJMGJ4RkwxSVAyaEdyNEM3TFhoT2cyQ1dlcyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778839623), ('uvxSVck32V9i5j4HVZALIKZLLJ6PiVaSlC64UWiG', NULL, '43.157.170.126', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNzlMazAxVWRuYmRwdTdQb0RPNFEzV2xIZFhKN1dZcFI4VFFodEx0OSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778678449), ('v2bzruoniqoFdzya1F7EBbpMmchpzlloBZ8XOqca', NULL, '34.1.17.184', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidWJ3WVBMNXVhVXlhRGdaSjdxSU9OTWwxUFV1elk1Ylhud2lmTWFzYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778659276), ('VFKK6q6GunKYzkOs8ubFEnRQimcwemRfP3Igri36', NULL, '43.134.57.179', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZE5mVHhIaTIwSU9STlhPUTJkQkFQb0FTVzdPTFZaY2wwYTJuMmZSRyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778738791), ('vYSNdWWtCOFetXMMrQNLg0ez9I1rBZtwy8VaDlZG', NULL, '34.222.202.255', 'Mozilla/5.0 (compatible; wpbot/1.4; +https://forms.gle/ajBaxygz9jSR8p8G9)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYUdOZ3ppVnI5YlJEQWZuWUl3WVZZRXhmaUhRRlZaMDNqTnJNbnRSRyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1778731369), ('w3cSwOVReLODPCYYYMwAmwEydVhXiUZV9S7rBgck', NULL, '43.157.67.70', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoid3cxcHVOendKbTlleTZVclFHU1lGZDV2SGpKQ1BYbWcyUHZFZzdWOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778693220), ('wJMtmx9YeeHFL16TNaqxfDfMmFEE608bULQLtYgb', NULL, '45.148.10.16', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 Chrome/122.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiT1lUbjNhVTk4Zlp6Z0h3NkczNVBiMzFZS1RFdWkzVmFvc2Rqb09KUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1778615218), ('X1zJYz664mDF4x1hDJaDXtvEcWXi7GngbMBvr54w', NULL, '74.7.243.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRFlmd0hDTmx1bWVsSGl3YWVkbE10T3o5V3NrUExOS3d3V1VkSTZqciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1778700165), ('xPu8SXtwZmotzfoN98nX9Wy8gsaqqKbBgsrviLwO', NULL, '43.133.14.237', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicGo3M2toZXc0NkVsanFVb2w2SjBrZWRWR2FHc0xIVUIyVzNGZUxTeCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778650353), ('ynV2luRnftTtb3F4Bes4NeeIRNtomodf334BuHyP', NULL, '159.89.234.126', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieU9Cem51WXJFbEluNGRrcjhhSnRLN1VZYm1OWnphUEVnMW4xbGwxYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1779016852), ('ySsjQ1z1oyV6Gr0ritiDvUIMCHOG3bkgheHlJrVA', NULL, '129.226.210.142', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOTlySHFEdU9Ya2dWclBjVTdpNGlsS3lucXBOVG5lUk1IMXVBanRpYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778507300), ('zDz44OZaa2qAhQ10Ah0njU2Ebgm90B7eIbhJxrwl', NULL, '43.153.73.200', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVU9LOVEwcG1NVzFPOGNjTjQwVWE0OFdBNmNiQkdjQkM1OGdyZHdiZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9hZG1pbi5oZWFkbm9kZXNvbHV0aW9uLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778692568), ('zVEc5G66kw0P1hpdkJoPcnewyaX6QWySfZogo77d', NULL, '34.252.20.5', 'Mozilla/5.0 (compatible; NetcraftSurveyAgent/1.0; +info@netcraft.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNXR1NGF6elpQdzdrMk8zSDczcXRUbmFRN052U0l4QWlZT1ViNzdySiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vYWRtaW4uaGVhZG5vZGVzb2x1dGlvbi5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1778522122); -- -------------------------------------------------------- -- -- Table structure for table `sizes` -- CREATE TABLE `sizes` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sizes` -- INSERT INTO `sizes` (`id`, `name`, `created_at`, `updated_at`) VALUES (1, 'XS', NULL, NULL), (2, 'S', NULL, NULL), (3, 'M', NULL, NULL), (4, 'L', NULL, NULL), (5, 'XL', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `userotps` -- CREATE TABLE `userotps` ( `id` int(11) NOT NULL, `user_id` varchar(191) NOT NULL, `otp` longtext NOT NULL, `type` varchar(191) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `userotps` -- INSERT INTO `userotps` (`id`, `user_id`, `otp`, `type`, `created_at`, `updated_at`) VALUES (1, '8', '$2y$10$ZguxHpFbHThLf17dL.nEt.lobZg3gBqA/DfCKNUecJerZ.MuWD54i', 'password_reset_request', '2024-10-15 16:44:11', '2025-04-15 13:48:09'), (2, '8', '$2y$10$ZguxHpFbHThLf17dL.nEt.lobZg3gBqA/DfCKNUecJerZ.MuWD54i', 'login_otp', '2024-10-16 09:24:32', '2025-04-15 13:48:09'), (3, '1', '$2y$10$ryaZuQ2954adlX9SRKUVKu.Lxb5EkZDowgnK2rh1pc9TqEDVnQZTi', 'login_otp', '2024-11-13 05:03:18', '2025-11-21 08:27:52'), (4, '22', '$2y$10$Q4Wt3G7Pxtq6TREb6GNjXO3NVSXIE9SZPidoMg6hpOemsOXdhqkTK', 'password_reset_request', '2024-11-23 10:13:13', '2024-11-23 14:34:51'), (5, '1', '$2y$10$ryaZuQ2954adlX9SRKUVKu.Lxb5EkZDowgnK2rh1pc9TqEDVnQZTi', 'account_details_update', '2024-11-26 12:44:50', '2025-11-21 08:27:52'), (6, '22', '$2y$10$DalGPuwmLItviVPgOWtlcelP8a3lS4lFva6dyXGbabHhtSB2VaKd.', 'account_details_update', '2024-11-27 05:25:14', '2024-11-27 05:25:14'), (13, '30', '$2y$10$3pCX13VwK9OhHs5OOmbbaOe69tM84vrj0EePxaMDK1.kzKWiCXgWy', 'password_reset_request', '2024-11-28 11:10:46', '2025-02-03 09:07:53'), (14, '20', '$2y$10$DHzSjqigIfbxayJdGd.B/OH5eYFgyDClwTXpvpvns6cPaE5OhMPX2', 'password_reset_request', '2024-11-30 10:43:55', '2024-11-30 10:43:55'), (15, '21', '$2y$10$6j2zZ7T6pIfNFDkIZViGcuzt/7k8WBt6lNMx3Xiq/gaqk7WoxHvE6', 'password_reset_request', '2024-12-01 01:44:23', '2024-12-01 01:44:23'), (16, '37', '$2y$10$viPypB6VPkVBgazwASSc.e8v6UYFKr7dRtQJfOpb3gM83Z.ctJ4y6', 'password_reset_request', '2024-12-26 04:47:45', '2024-12-26 04:53:08'), (17, '1', '$2y$10$ryaZuQ2954adlX9SRKUVKu.Lxb5EkZDowgnK2rh1pc9TqEDVnQZTi', 'password_reset_request', '2024-12-26 04:52:54', '2025-11-21 08:27:52'), (18, '39', '$2y$10$xJ1VYrNK7NINuk/gkxHZze8fpkcoGr4kaUJSiVDIIE4cVQ0t5t3li', 'password_reset_request', '2024-12-31 11:58:03', '2024-12-31 11:58:03'), (19, '40', '$2y$10$XFPe8Fy07kz23WTELTmV1.8G51YYOKcccT1ChNroe38jrsw.Ioe0S', 'password_reset_request', '2025-01-05 10:19:06', '2025-12-07 07:10:44'), (20, '44', '$2y$10$fKpCbTyf8JsUgyO1NuKQ8eoSRHQW1DnOBffvdUDKpp8ChioXe4RgW', 'password_reset_request', '2025-01-09 14:57:32', '2025-01-09 14:57:32'), (21, '45', '$2y$10$b1hqzN2OewAbDYyveiwTcudAtaiWk1k37dDE9f8cv7.4gD.2dZkwq', 'password_reset_request', '2025-01-09 16:05:45', '2025-01-10 07:26:50'), (22, '46', '$2y$10$Ka9ga1U5kIJ.7SrRxyx3CuO69z6Rly0Uzj2MXFb2r848VMQLzhLAq', 'password_reset_request', '2025-01-10 06:18:30', '2025-01-10 15:35:49'), (23, '49', '$2y$10$s7Jih0UBhcjdWymKSWpwO.jG6H3VIBfRVNV80P62Rx7P3ymjY5i2W', 'password_reset_request', '2025-01-16 06:01:16', '2025-10-06 02:05:01'), (24, '50', '$2y$10$Q.DobMHUUl05UAGzcNM1Z.l3vbBQCIfGnTC0jB2CAWSvAus8uBm7.', 'password_reset_request', '2025-01-17 05:49:14', '2025-01-17 05:49:14'), (25, '2', '$2y$10$j7sG2kSSeRWlTBZOFBDb8uU6BMbf.JAn3634ab7jC50RpeY5Fav7S', 'password_reset_request', '2025-01-28 16:52:56', '2025-12-02 02:02:14'), (26, '53', '$2y$10$ydhWLcn.3YqGdQkZh/zJ3uqYfQPQ4AHaPjLoGs289qbgyayO7t/4W', 'password_reset_request', '2025-02-03 11:33:05', '2025-02-03 11:33:05'), (27, '54', '$2y$10$4qEUgX39TX8V0erJ38PSjueAASidN4G9wCAh.ZjzlpFNnwUB9VJ0S', 'password_reset_request', '2025-02-05 10:59:31', '2025-02-07 08:43:07'), (28, '55', '$2y$10$Pk1Wv6T4K9250.3MpjAJ5O7f9kjqriXoY/I0BIsdmSUNIDdXDl98W', 'password_reset_request', '2025-02-07 08:42:21', '2025-10-10 05:33:00'), (29, '59', '$2y$10$3kzUexCgWLIvcWwFeShnOeWgAD4cB8RpwwubBnBrLqEGOPOxbkHV.', 'password_reset_request', '2025-02-20 13:12:06', '2025-02-20 13:12:06'), (30, '43', '$2y$10$YXrjHE3SbnBzFSYdDFQ2AehiWu.nDxq/0C/AqoNI6uLGb0UqZ788W', 'password_reset_request', '2025-02-26 06:35:46', '2025-02-26 06:47:19'), (31, '60', '$2y$10$eRXezm65NvqEnnfZmu5Gw.3Mkykv.tbo2F/OC5QHqtKe.b5Hv6Yyq', 'password_reset_request', '2025-03-10 05:04:32', '2025-09-13 13:26:01'), (32, '65', '$2y$10$AMkFwL/AMEJ5MDBiEayhgOfqJcPk26Ae68QKK0C1AmGqTt2K0Xx/i', 'password_reset_request', '2025-05-26 12:55:01', '2025-05-26 12:55:01'), (33, '67', '$2y$10$20qDqezDZf/iQ0rSP9finO0BC/cmWYuahrkSwTm2jD9uDtMmNpbZu', 'password_reset_request', '2025-06-11 12:22:17', '2025-06-11 12:22:17'), (34, '69', '$2y$10$auGv9GYTDETfUqm8f6321.bjcGfeZt5sWoAD9sTcURYxs2nRGiYrm', 'password_reset_request', '2025-07-16 10:02:52', '2025-07-16 10:02:52'), (35, '70', '$2y$10$TAlT0IS5GQlSNtVPOI0JUuKdinR0cTDsEEMRwvRd6WlLXQDNhlAz.', 'password_reset_request', '2025-07-26 12:43:56', '2025-07-26 12:49:01'), (36, '73', '$2y$10$WVCjujb.Z6jMPLERWs4cceTzMIs6nExvIcim7omF2Di3iTlzf2Svy', 'password_reset_request', '2025-08-14 06:21:08', '2025-08-14 06:21:08'), (37, '74', '$2y$10$qF9BFjxJoa7rWR83htvJFeC7Nci7AubqylWpmLyX7WTHGwgdUA4Am', 'password_reset_request', '2025-08-14 14:11:52', '2025-08-14 14:11:52'), (38, '75', '$2y$10$X/AWF3nX1/6imi3TZpHmDeEMuZADmvTX3BGUTsxeehabwPwAFSYUC', 'password_reset_request', '2025-08-23 08:37:23', '2025-08-23 08:37:23'), (39, '84', '$2y$10$TenyL7Htj4cfeqgW0O3Y5.uocKibzT7zPgxTiDMWiIF8fGs7sp8HK', 'password_reset_request', '2025-09-03 10:12:03', '2025-09-03 10:12:03'), (40, '89', '$2y$10$fcvWkOvgKQ8OwUqEQYMy7uwqL/xpfj3Cn1XZyo4UGV7/OThZ3kwqq', 'password_reset_request', '2025-09-07 10:21:24', '2025-09-07 10:26:32'), (41, '72', '$2y$10$JwvRjLllLDAWWe3YSwK1XuO3kRIjwZe/6eh4F6wB.ei9mEQYr9rtK', 'password_reset_request', '2025-09-10 20:32:07', '2025-09-18 09:49:05'), (42, '92', '$2y$10$siaj6O.Q72RvIrvK8M1XQuWWUtSAk7uL1a19UCX7c4PYyYZvNU/VK', 'password_reset_request', '2025-09-24 04:47:55', '2025-09-24 04:47:55'), (43, '98', '$2y$10$ZNAHhtiQGVwraJn2pTTGreGSOhet4RwHnYNMTDsohWj92bxMaFLY2', 'password_reset_request', '2025-09-27 07:48:53', '2025-09-27 07:58:01'), (44, '100', '$2y$10$F/c90Y22r3XNoLfTVKdZEeA99YFJm9MBNl0nt7c3Sn5xSi/WG8CUa', 'password_reset_request', '2025-09-30 04:33:36', '2025-09-30 04:33:36'), (45, '99', '$2y$10$HN0l4G.tU7mytyhLViP5HOS1El9DfPiu8rjQEET43C0fikI/Ud4ka', 'password_reset_request', '2025-09-30 11:35:37', '2025-09-30 11:35:37'), (46, '95', '$2y$10$9fVa0Qc4aX6bbt4sCYZoJO3q1T4ijzk/9dsxxU1DP8ROU7Y1BO2Z2', 'password_reset_request', '2025-09-30 14:42:24', '2025-09-30 14:42:24'), (47, '93', '$2y$10$d9CvWitntPO.QDAC965KzOImNXLTk2yiBBtm/UOqEEOn5C4dwB82y', 'password_reset_request', '2025-10-01 05:25:08', '2025-10-01 07:56:57'), (48, '101', '$2y$10$mukgfFmNFY92PvVfN9E3C.Wr7.LTQiG/xD4Xk3BHM1BNPaNcgtzO6', 'password_reset_request', '2025-10-01 06:45:41', '2025-10-05 05:51:11'), (49, '97', '$2y$10$hcJJbAv5KRdLH5urj/w7geESfu17K3CXk/4xa.8zvPbuBQ88MFxfC', 'password_reset_request', '2025-10-02 11:22:58', '2025-10-23 15:12:52'), (50, '102', '$2y$10$J0yerap853it96p3KhEtx.llPNN4OkjcFATV9ZMt.Y.d1mKfUSzJu', 'password_reset_request', '2025-10-07 14:39:11', '2025-10-07 14:39:11'), (51, '94', '$2y$10$RkYT.NmGNztthuCDnFgSiuIxqDUwwwrU.QIVeM.Kdz.YuPRKyvfX2', 'password_reset_request', '2025-10-09 12:59:22', '2025-10-09 12:59:22'), (52, '105', '$2y$10$fqs8ie7El1up5HFh4plBfupxpl41jBQVdZCbpzfJia9y6/pxx87Ym', 'password_reset_request', '2025-10-10 13:22:38', '2025-10-10 13:22:38'), (53, '47', '$2y$10$9Z5TxDoPFMch9O1KmrANeuKriZn6cRceFctR/DQ/VMlCw8RfYjUaa', 'password_reset_request', '2025-10-15 10:44:20', '2025-10-15 10:44:20'), (54, '114', '$2y$10$Y0YinEP7uQl5VvWQyBe7K.GMYXLItXIlY/iDHNwbANZbDKKMMIwqq', 'password_reset_request', '2025-10-16 06:15:16', '2025-10-16 08:50:05'), (55, '115', '$2y$10$IF/9g5ixJ0nnjLxiRLu6O.XH2FvDQXVCYhg16iEI8l6ZsWDKyYYDO', 'password_reset_request', '2025-10-18 00:24:16', '2025-10-18 00:24:16'), (56, '10', '$2y$10$sX7dAAvA9ni9f640c0KpxOfYLEHjRmymPmtw9HbpOXB2xb.rnxgvq', 'password_reset_request', '2025-10-20 09:54:51', '2025-10-20 09:54:51'), (57, '121', '$2y$10$IyYgwueA5fkP7AZcb24QF.g3SlC1MkFVgT49YCaczxN2r4kchx9V6', 'password_reset_request', '2025-10-22 12:21:41', '2025-10-22 12:21:41'), (58, '126', '$2y$10$U6zx3kV.iBQT3r6OfMiDvu2NMEDwqWvovjV5JutrChONCDjnqRv0m', 'password_reset_request', '2025-10-24 03:24:47', '2025-10-24 03:31:29'), (59, '128', '$2y$10$5NgS4f29tfUwc4oJMlQqMuWEhPDrJpxGeMa/RfnfgplZMGbhSqfhO', 'password_reset_request', '2025-10-24 14:03:03', '2025-10-24 14:03:03'), (60, '131', '$2y$10$0A6HFogzulwbOg6dNnZ/IOpt7QR7.BvrDMppa5Gw.ZnAc5gk.muYq', 'password_reset_request', '2025-10-25 03:23:04', '2025-10-25 14:16:02'), (61, '133', '$2y$10$zIU5dDwXz28nUu93A5gRweBBeDV9swE6ruOWbS14.1Zz1Pko6R7iG', 'password_reset_request', '2025-10-25 14:38:32', '2025-10-25 14:43:45'), (62, '139', '$2y$10$JWRhldspr8FzCRnUkbxHf.dHtYEh5nWUmpC1pUZg15WDW5z7tUHqy', 'password_reset_request', '2025-10-30 07:54:50', '2025-10-30 07:54:50'), (63, '136', '$2y$10$.1TqvGmNS0nRFTuw/FpTpOmYwEpYB0vOX6r.awtz1zQFcbM2OlAQu', 'password_reset_request', '2025-10-30 09:37:49', '2025-10-30 09:37:49'), (64, '142', '$2y$10$gm87wIK4q.vVdRi5MrdnD.bMMqf5xCcl93WRUXnOY3i.3PaR4dc6S', 'password_reset_request', '2025-10-31 04:20:41', '2025-10-31 04:20:41'), (65, '143', '$2y$10$jPHz/LWqo.SjcnVrFXCoW.8WF3KPu.1BcZubhQHJLgcgO81D0le2G', 'password_reset_request', '2025-10-31 06:32:23', '2025-10-31 06:32:23'), (66, '144', '$2y$10$ziXN3Bk.f/Y.bxWi/FOHQ.vuWyYB6BT2VHb99aGoev5jRSN0n48K2', 'password_reset_request', '2025-10-31 07:31:55', '2025-10-31 07:31:55'), (67, '111', '$2y$10$GFArECp5txjD8E20odmwGOQRuMPw7FUvBbUr3oXyz3duJ8NsKhHlS', 'password_reset_request', '2025-11-01 12:12:20', '2025-11-01 13:07:39'), (68, '145', '$2y$10$aomSodzpH6HOeqYTQGk8guavS9nvYiljsmPQu5gv9d9UMQZSzZCLy', 'password_reset_request', '2025-11-01 15:20:00', '2025-11-01 15:25:19'), (69, '153', '$2y$10$IKzNvXbsuxraZqZjwcnaSu4yI2bJ0.WjcrjXkVVFjPScn.UcLxghG', 'password_reset_request', '2025-11-10 08:53:37', '2025-11-10 08:53:37'), (70, '68', '$2y$10$4OpyFZHCRXJH07a.eBzS5ubWTHUDbecC9XY5nfHzQ/aAELz.fO63G', 'password_reset_request', '2025-11-10 09:30:53', '2025-11-10 09:30:53'), (71, '108', '$2y$10$Km/i.58T2iX.OsDOuxPoteTga7Z5qr515htBPkhw5.rmQypuTg.D2', 'password_reset_request', '2025-11-21 08:28:04', '2025-11-21 08:35:20'), (72, '165', '$2y$10$mpLi94AMDsZ93Ped8LG8dumdqSm4WiF4YlIe6hSwix4d8jfIofPE6', 'password_reset_request', '2025-11-21 08:54:38', '2025-11-21 08:54:38'), (73, '42', '$2y$10$qW9lTPuo1g.cj5zoU3PbSe9Ez0.74p41C8W5VuBC2s2YQV9gXDxEC', 'password_reset_request', '2025-11-27 07:48:36', '2025-11-27 07:48:36'), (74, '71', '$2y$10$mFsS5Cx56jaiwokE/UsFPe0goEsq1OdYDwMF/KovLcyKIBZ3vxqMq', 'password_reset_request', '2025-11-27 11:05:17', '2025-11-27 11:11:28'), (75, '175', '$2y$10$leTdWkQ3WRXnsCYBwlRKYe5Lehns6At1kBX4LLw31abNiZYY4e6vC', 'password_reset_request', '2025-11-29 10:23:25', '2025-11-29 10:23:25'), (76, '180', '$2y$10$nvqdRCIkv1oi6Q4f1GOAR.x5GsTf8HN5YT3zR/xhddsAYpYeyXDvG', 'password_reset_request', '2025-12-01 14:50:28', '2025-12-01 14:50:28'), (77, '148', '$2y$10$E99.WwQ9Q/KXSoSd1W3xO.hI09E5s2dFXB4YsvPSPeKSrdAH0ctsW', 'password_reset_request', '2025-12-02 07:22:49', '2025-12-02 07:22:49'), (78, '168', '$2y$10$/zkMw.neJfUzeU9x5qDOHOEB5g9SDU4XUyOfpDpcqWUFafhha0EvC', 'password_reset_request', '2025-12-17 06:24:52', '2025-12-17 06:24:52'), (79, '4', '$2y$12$e8waP59.aDzr9diiHYqaluqPc98zko3KmfKazqCseIslHel3JYHJ.', 'password_reset_request', '2026-03-25 13:24:36', '2026-03-26 16:34:58'), (80, '7', '$2y$12$EU6wKO03G.TrVhEge38QH.LisaEeC0stCLDppml7sPQSmWnxzyLJy', 'password_reset_request', '2026-03-26 05:58:33', '2026-03-26 17:08:31'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `mobile` varchar(191) NOT NULL, `role` varchar(191) DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `mobile`, `role`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Admin', 'admin@gmail.com', '1234567890', 'admin', NULL, '$2y$12$Don3OVrg2QyWSwDIL9TswuW/bU7k0rliqoUFhqwQM4Sr/qV0cz9Oa', NULL, NULL, '2025-08-13 13:25:26'); -- -------------------------------------------------------- -- -- Table structure for table `wallets` -- CREATE TABLE `wallets` ( `id` bigint(20) UNSIGNED NOT NULL, `customer_id` bigint(20) UNSIGNED NOT NULL, `balance` decimal(12,2) NOT NULL DEFAULT 0.00, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wishlists` -- CREATE TABLE `wishlists` ( `id` bigint(20) UNSIGNED NOT NULL, `customer_id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) UNSIGNED NOT 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 `addresses` -- ALTER TABLE `addresses` ADD PRIMARY KEY (`id`), ADD KEY `addresses_customer_id_foreign` (`customer_id`); -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- Indexes for table `carousels` -- ALTER TABLE `carousels` ADD PRIMARY KEY (`id`); -- -- Indexes for table `carts` -- ALTER TABLE `carts` ADD PRIMARY KEY (`id`), ADD KEY `carts_customer_id_foreign` (`customer_id`); -- -- Indexes for table `cart_items` -- ALTER TABLE `cart_items` ADD PRIMARY KEY (`id`), ADD KEY `cart_items_cart_id_foreign` (`cart_id`), ADD KEY `cart_items_product_id_foreign` (`product_id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `colors` -- ALTER TABLE `colors` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `colors_name_unique` (`name`); -- -- Indexes for table `coupons` -- ALTER TABLE `coupons` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `coupons_code_unique` (`code`); -- -- Indexes for table `customers` -- ALTER TABLE `customers` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `customers_email_unique` (`email`), ADD UNIQUE KEY `customers_phone_unique` (`phone`); -- -- Indexes for table `discounts` -- ALTER TABLE `discounts` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `discounts_code_unique` (`code`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indexes for table `job_batches` -- ALTER TABLE `job_batches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `microlog` -- ALTER TABLE `microlog` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `offers` -- ALTER TABLE `offers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `orders_order_number_unique` (`order_number`), ADD KEY `orders_customer_id_foreign` (`customer_id`); -- -- Indexes for table `order_items` -- ALTER TABLE `order_items` ADD PRIMARY KEY (`id`), ADD KEY `order_items_order_id_foreign` (`order_id`), ADD KEY `order_items_product_id_foreign` (`product_id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`), ADD KEY `products_category_id_section_index` (`category_id`,`section`); -- -- Indexes for table `product_images` -- ALTER TABLE `product_images` ADD PRIMARY KEY (`id`), ADD KEY `product_images_product_id_foreign` (`product_id`); -- -- Indexes for table `referral_transactions` -- ALTER TABLE `referral_transactions` ADD PRIMARY KEY (`id`), ADD KEY `partner_id` (`partner_id`), ADD KEY `customer_id` (`customer_id`), ADD KEY `order_id` (`order_id`); -- -- Indexes for table `reviews` -- ALTER TABLE `reviews` ADD PRIMARY KEY (`id`), ADD KEY `reviews_customer_id_foreign` (`customer_id`), ADD KEY `reviews_product_id_foreign` (`product_id`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indexes for table `sizes` -- ALTER TABLE `sizes` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `sizes_name_unique` (`name`); -- -- Indexes for table `userotps` -- ALTER TABLE `userotps` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- Indexes for table `wallets` -- ALTER TABLE `wallets` ADD PRIMARY KEY (`id`), ADD KEY `wallets_customer_id_foreign` (`customer_id`); -- -- Indexes for table `wishlists` -- ALTER TABLE `wishlists` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `wishlists_customer_id_product_id_unique` (`customer_id`,`product_id`), ADD KEY `wishlists_product_id_foreign` (`product_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `addresses` -- ALTER TABLE `addresses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `carousels` -- ALTER TABLE `carousels` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `carts` -- ALTER TABLE `carts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `cart_items` -- ALTER TABLE `cart_items` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `colors` -- ALTER TABLE `colors` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `coupons` -- ALTER TABLE `coupons` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `customers` -- ALTER TABLE `customers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `discounts` -- ALTER TABLE `discounts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `microlog` -- ALTER TABLE `microlog` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27; -- -- AUTO_INCREMENT for table `offers` -- ALTER TABLE `offers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=185; -- -- AUTO_INCREMENT for table `order_items` -- ALTER TABLE `order_items` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=180; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81; -- -- AUTO_INCREMENT for table `product_images` -- ALTER TABLE `product_images` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `referral_transactions` -- ALTER TABLE `referral_transactions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28; -- -- AUTO_INCREMENT for table `reviews` -- ALTER TABLE `reviews` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `sizes` -- ALTER TABLE `sizes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `userotps` -- ALTER TABLE `userotps` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `wallets` -- ALTER TABLE `wallets` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `wishlists` -- ALTER TABLE `wishlists` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `addresses` -- ALTER TABLE `addresses` ADD CONSTRAINT `addresses_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE; -- -- Constraints for table `carts` -- ALTER TABLE `carts` ADD CONSTRAINT `carts_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE; -- -- Constraints for table `cart_items` -- ALTER TABLE `cart_items` ADD CONSTRAINT `cart_items_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `cart_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; -- -- Constraints for table `order_items` -- ALTER TABLE `order_items` ADD CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; -- -- Constraints for table `products` -- ALTER TABLE `products` ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE; -- -- Constraints for table `product_images` -- ALTER TABLE `product_images` ADD CONSTRAINT `product_images_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; -- -- Constraints for table `reviews` -- ALTER TABLE `reviews` ADD CONSTRAINT `reviews_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `reviews_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; -- -- Constraints for table `wallets` -- ALTER TABLE `wallets` ADD CONSTRAINT `wallets_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE; -- -- Constraints for table `wishlists` -- ALTER TABLE `wishlists` ADD CONSTRAINT `wishlists_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `wishlists_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;