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

START TRANSACTION;



--
-- Database: `testthenkeep`
--

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

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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `deleted_at` timestamp NULL DEFAULT NULL,
  `detail` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `deleted_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`, `detail`, `created_by`, `deleted_by`) VALUES
(33, 'Quon Wyatt123', '2025-03-17 12:07:06', '2025-03-17 12:07:17', '2025-03-17 12:07:17', 'Commodi cumque ut co', 1, 1),
(34, 'Popular', '2025-03-17 12:09:51', '2025-04-10 10:03:10', '2025-04-10 10:03:10', NULL, 1, 1),
(35, 'Breakfast', '2025-03-17 12:09:55', '2025-04-10 10:03:08', '2025-04-10 10:03:08', NULL, 1, 1),
(36, 'Lunch', '2025-03-17 12:09:59', '2025-04-10 10:03:07', '2025-04-10 10:03:07', NULL, 1, 1),
(37, 'Dinner', '2025-03-17 12:10:04', '2025-04-10 10:03:04', '2025-04-10 10:03:04', NULL, 1, 1),
(38, 'Snack', '2025-03-17 12:10:09', '2025-04-10 10:03:03', '2025-04-10 10:03:03', NULL, 1, 1),
(39, 'Meal prep', '2025-03-17 12:10:15', '2025-04-10 10:03:02', '2025-04-10 10:03:02', NULL, 1, 1),
(40, 'Vegetable', '2025-03-17 12:10:19', '2025-04-10 10:03:00', '2025-04-10 10:03:00', NULL, 1, 1),
(41, 'Vegetarian', '2025-03-17 12:10:24', '2025-04-10 10:02:56', '2025-04-10 10:02:56', NULL, 1, 1),
(42, 'Egg-free', '2025-03-17 12:10:31', '2025-04-10 10:02:54', '2025-04-10 10:02:54', NULL, 1, 1),
(43, 'Dairy-free', '2025-03-17 12:10:36', '2025-04-10 10:02:52', '2025-04-10 10:02:52', NULL, 1, 1),
(44, 'Electronics', '2025-04-10 10:04:01', '2025-04-10 10:04:09', NULL, NULL, 1, NULL),
(45, 'GYM', '2025-04-10 10:04:16', '2025-04-10 13:16:12', '2025-04-10 13:16:12', NULL, 1, 1),
(46, 'Accessories', '2025-04-10 10:04:32', '2025-04-10 10:04:32', NULL, NULL, 1, NULL),
(47, 'Women\'s', '2025-04-10 10:04:41', '2025-04-10 13:16:10', '2025-04-10 13:16:10', NULL, 1, 1),
(48, 'Men\'s', '2025-04-10 10:04:52', '2025-04-10 13:16:08', '2025-04-10 13:16:08', NULL, 1, 1);

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

--
-- Table structure for table `contactus`
--

CREATE TABLE `contactus` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `email` text DEFAULT NULL,
  `subject` text DEFAULT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `contactus`
--

INSERT INTO `contactus` (`id`, `name`, `email`, `subject`, `message`, `created_at`, `updated_at`) VALUES
(11, 'Jerome Ingram', 'vomefomeku@mailinator.com', '+1 (807) 108-3097', 'In rerum corrupti a', '2025-04-10 13:40:25', '2025-04-10 13:40:25');

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

--
-- 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_general_ci;

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

--
-- 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_general_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `userid` int(11) DEFAULT NULL,
  `productid` int(11) DEFAULT NULL,
  `product_name` text DEFAULT NULL,
  `product_price` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `instructions` text DEFAULT NULL,
  `status` enum('pending','approved') DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `userid`, `productid`, `product_name`, `product_price`, `description`, `instructions`, `status`, `created_at`, `updated_at`) VALUES
(4, 72, 13, 'Razer BlackShark V2 X Gaming Headset', '34', 'About this item\r\nIMMERSIVE, 7.1 SURROUND SOUND — Heighten awareness with accurate positional audio that lets you pinpoint intuitively where every sound is coming from (only available on Windows 10 64-bit)\r\nTRIFORCE 50MM DRIVERS — Cutting-edge proprietary design that divides the driver into 3 parts for the individual tuning of highs, mids, and lows —producing brighter, clearer audio with richer highs and more powerful lows\r\nADVANCED PASSIVE NOISE CANCELLATION — Sturdy closed earcups fully cover ears to prevent noise from leaking into the headset, with its cushions providing a closer seal for more sound isolation —\r\nLIGHTWEIGHT DESIGN WITH BREATHABLE FOAM EAR CUSHIONS — At just 240g, the headset features thicker headband padding and leatherette with memory foam ear cushions to provide maximum comfort\r\nBENDABLE HYPERCLEAR CARDIOID MIC — An improved pickup pattern ensures more voice and less noise as it tapers off towards the mic’s back and sides, with the sweet spot easily placed at your mouth because of the mic’s bendable design\r\nCROSS-PLATFORM COMPATIBILITY — Works with PC, Mac, PS4, Xbox One, Nintendo Switch via 3.5mm jack, enjoy unfair audio advantage across almost every platform. *Xbox One stereo adapter may be required, purchase separately\r\n#1 SELLING PC GAMING PERIPHERALS BRAND IN THE U.S. — Source — Circana, Retail Tracking Service, U.S., Dollar Sales, Gaming Designed Mice, Keyboards, and PC Headsets, Jan. 2019- Dec. 2023 combined', '<ul class=\"a-unordered-list a-vertical a-spacing-mini\">\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">IMMERSIVE, 7.1 SURROUND SOUND &mdash; Heighten awareness with accurate positional audio that lets you pinpoint intuitively where every sound is coming from (only available on Windows 10 64-bit)</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">TRIFORCE 50MM DRIVERS &mdash; Cutting-edge proprietary design that divides the driver into 3 parts for the individual tuning of highs, mids, and lows &mdash;producing brighter, clearer audio with richer highs and more powerful lows</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">ADVANCED PASSIVE NOISE CANCELLATION &mdash; Sturdy closed earcups fully cover ears to prevent noise from leaking into the headset, with its cushions providing a closer seal for more sound isolation &mdash;</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">LIGHTWEIGHT DESIGN WITH BREATHABLE FOAM EAR CUSHIONS &mdash; At just 240g, the headset features thicker headband padding and leatherette with memory foam ear cushions to provide maximum comfort</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">BENDABLE HYPERCLEAR CARDIOID MIC &mdash; An improved pickup pattern ensures more voice and less noise as it tapers off towards the mic&rsquo;s back and sides, with the sweet spot easily placed at your mouth because of the mic&rsquo;s bendable design</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">CROSS-PLATFORM COMPATIBILITY &mdash; Works with PC, Mac, PS4, Xbox One, Nintendo Switch via 3.5mm jack, enjoy unfair audio advantage across almost every platform. *Xbox One stereo adapter may be required, purchase separately</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">#1 SELLING PC GAMING PERIPHERALS BRAND IN THE U.S. &mdash; Source &mdash; Circana, Retail Tracking Service, U.S., Dollar Sales, Gaming Designed Mice, Keyboards, and PC Headsets, Jan. 2019- Dec. 2023 combined</span></li>\r\n</ul>', 'approved', '2025-04-12 13:28:40', '2025-04-12 13:31:47');

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

--
-- Table structure for table `order_history`
--

CREATE TABLE `order_history` (
  `id` int(11) NOT NULL,
  `orderid` int(11) NOT NULL,
  `number` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `order_history`
--

INSERT INTO `order_history` (`id`, `orderid`, `number`, `image`, `created_at`, `updated_at`) VALUES
(5, 4, 'TRE-654', '492093-1744482699doc.jpg', '2025-04-12 13:31:39', '2025-04-12 13:31:39');

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

--
-- Table structure for table `payment_history`
--

CREATE TABLE `payment_history` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `orderid` int(11) NOT NULL,
  `status` enum('pending','approved') DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment_history`
--

INSERT INTO `payment_history` (`id`, `userid`, `orderid`, `status`, `created_at`, `updated_at`) VALUES
(10, 72, 4, 'approved', '2025-04-12 13:31:47', '2025-04-12 13:31:58');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `heading` text DEFAULT NULL,
  `categoryid` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `price` text DEFAULT NULL,
  `tags` text DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `instructions` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `heading`, `categoryid`, `image`, `price`, `tags`, `slug`, `description`, `instructions`, `created_at`, `updated_at`) VALUES
(13, 'Razer BlackShark V2 X Gaming Headset', '46', '331396-1744307883p1.jpg', '34', 'PC , Headset , Headphones', 'razer-blackshark-v2-x-gaming-headset', 'About this item\r\nIMMERSIVE, 7.1 SURROUND SOUND — Heighten awareness with accurate positional audio that lets you pinpoint intuitively where every sound is coming from (only available on Windows 10 64-bit)\r\nTRIFORCE 50MM DRIVERS — Cutting-edge proprietary design that divides the driver into 3 parts for the individual tuning of highs, mids, and lows —producing brighter, clearer audio with richer highs and more powerful lows\r\nADVANCED PASSIVE NOISE CANCELLATION — Sturdy closed earcups fully cover ears to prevent noise from leaking into the headset, with its cushions providing a closer seal for more sound isolation —\r\nLIGHTWEIGHT DESIGN WITH BREATHABLE FOAM EAR CUSHIONS — At just 240g, the headset features thicker headband padding and leatherette with memory foam ear cushions to provide maximum comfort\r\nBENDABLE HYPERCLEAR CARDIOID MIC — An improved pickup pattern ensures more voice and less noise as it tapers off towards the mic’s back and sides, with the sweet spot easily placed at your mouth because of the mic’s bendable design\r\nCROSS-PLATFORM COMPATIBILITY — Works with PC, Mac, PS4, Xbox One, Nintendo Switch via 3.5mm jack, enjoy unfair audio advantage across almost every platform. *Xbox One stereo adapter may be required, purchase separately\r\n#1 SELLING PC GAMING PERIPHERALS BRAND IN THE U.S. — Source — Circana, Retail Tracking Service, U.S., Dollar Sales, Gaming Designed Mice, Keyboards, and PC Headsets, Jan. 2019- Dec. 2023 combined', '<ul class=\"a-unordered-list a-vertical a-spacing-mini\">\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">IMMERSIVE, 7.1 SURROUND SOUND &mdash; Heighten awareness with accurate positional audio that lets you pinpoint intuitively where every sound is coming from (only available on Windows 10 64-bit)</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">TRIFORCE 50MM DRIVERS &mdash; Cutting-edge proprietary design that divides the driver into 3 parts for the individual tuning of highs, mids, and lows &mdash;producing brighter, clearer audio with richer highs and more powerful lows</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">ADVANCED PASSIVE NOISE CANCELLATION &mdash; Sturdy closed earcups fully cover ears to prevent noise from leaking into the headset, with its cushions providing a closer seal for more sound isolation &mdash;</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">LIGHTWEIGHT DESIGN WITH BREATHABLE FOAM EAR CUSHIONS &mdash; At just 240g, the headset features thicker headband padding and leatherette with memory foam ear cushions to provide maximum comfort</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">BENDABLE HYPERCLEAR CARDIOID MIC &mdash; An improved pickup pattern ensures more voice and less noise as it tapers off towards the mic&rsquo;s back and sides, with the sweet spot easily placed at your mouth because of the mic&rsquo;s bendable design</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">CROSS-PLATFORM COMPATIBILITY &mdash; Works with PC, Mac, PS4, Xbox One, Nintendo Switch via 3.5mm jack, enjoy unfair audio advantage across almost every platform. *Xbox One stereo adapter may be required, purchase separately</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">#1 SELLING PC GAMING PERIPHERALS BRAND IN THE U.S. &mdash; Source &mdash; Circana, Retail Tracking Service, U.S., Dollar Sales, Gaming Designed Mice, Keyboards, and PC Headsets, Jan. 2019- Dec. 2023 combined</span></li>\r\n</ul>', '2025-04-10 12:58:03', '2025-04-10 12:58:03'),
(15, 'JBL CHARGE Portable Waterproof', '44', '381485-1744308939pp1.webp', '179', 'CHARGE  , JBL , BLUETOOTH', 'jbl-charge-portable-waterproof', 'BOLD JBL ORIGINAL PRO SOUND - Take the power of JBL with you. The JBL Charge 5 has an optimized long excursion driver, a separate tweeter & dual bass radiators, all delivering impressively rich, clear audio. Get big room sound, even when outdoors.\r\n20 HOURS OF PLAYTIME - The fun doesn\'t have to stop. Packed with an incredible 20 hours of battery life, Charge 5 lets you party all day & into the night. Plus, a built-in powerbank lets you charge your devices without taking a break from the tunes.\r\nWIRELESS BLUETOOTH STREAMING - Wirelessly connect up to 2 smartphones or tablets to the speaker & take turns enjoying JBL Pro sound. Thanks to PartyBoost, you can connect multiple JBL PartyBoost-enabled speakers for a sound big enough for any crowd.\r\nIPX7 WATERPROOF - Bring your speakers anywhere. Pool party? Perfect. Sudden cloudburst? Covered. Bash on the beach? Charge 5 is IPX7 waterproof and dustproof for fearless outdoor entertainment.\r\nTHE SOUND PROMISE - JBL has brought music to life in a way people can feel for over 70 years. From Woodstock to the Motion Picture Academy, our speakers unleash the power of music so you can live life to the fullest, wherever and whenever.', '<p>&nbsp;</p>\r\n<ul class=\"a-unordered-list a-vertical a-spacing-mini\">\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\"><strong>BOLD JBL ORIGINAL PRO SOUND</strong> - Take the power of JBL with you. The JBL Charge 5 has an optimized long excursion driver, a separate tweeter &amp; dual bass radiators, all delivering impressively rich, clear audio. Get big room sound, even when outdoors.</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\"><strong>20 HOURS OF PLAYTIME</strong> - The fun doesn\'t have to stop. Packed with an incredible 20 hours of battery life, Charge 5 lets you party all day &amp; into the night. Plus, a built-in powerbank lets you charge your devices without taking a break from the tunes.</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\"><strong>WIRELESS BLUETOOTH STREAMING</strong> - Wirelessly connect up to 2 smartphones or tablets to the speaker &amp; take turns enjoying JBL Pro sound. Thanks to PartyBoost, you can connect multiple JBL PartyBoost-enabled speakers for a sound big enough for any crowd.</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\"><strong>IPX7 WATERPROOF</strong> - Bring your speakers anywhere. Pool party? Perfect. Sudden cloudburst? Covered. Bash on the beach? Charge 5 is IPX7 waterproof and dustproof for fearless outdoor entertainment.</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\"><strong>THE SOUND PROMISE</strong> - JBL has brought music to life in a way people can feel for over 70 years. From Woodstock to the Motion Picture Academy, our speakers unleash the power of music so you can live life to the fullest, wherever and whenever.</span></li>\r\n</ul>', '2025-04-10 13:15:39', '2025-04-10 13:15:57'),
(16, 'Nintendo Switch – OLED Model', '44', '16495-1744309120ppp1.webp', '348', 'Nintendo , LCD , Switch , LED', 'nintendo-switch-oled-model', 'Vivid 7” OLED screen\r\nLocal co-op, online, and local wireless multiplayer\r\n64 GB internal storage (a portion of which is reserved for use by the system)\r\nEnhanced audio in handheld and tabletop modes\r\nWide adjustable stand', '<p class=\"desc-text\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, dolore magna eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute iruremod thats dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.</p>\r\n<p class=\"desc-text\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, dolore magna eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute iruremod thats dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.</p>\r\n<p class=\"desc-text\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, dolore magna eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute iruremod thats dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.</p>\r\n<p class=\"desc-text\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, dolore magna eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute iruremod thats dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.</p>\r\n<p class=\"desc-text\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, dolore magna eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute iruremod thats dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.</p>\r\n<p class=\"desc-text\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, dolore magna eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute iruremod thats dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.</p>', '2025-04-10 13:18:40', '2025-04-10 13:18:40'),
(17, 'WOLFBOX MF100 Electric Air Duster', '46', '395683-1744309307pppp1.webp', '89', 'WOLFBOX , Electric , Air Duster', 'wolfbox-mf100-electric-air-duster', 'Super Power Turbo Fan: The WOLFBOX MegaFlow100 electric air duster delivers impressive speeds of up to 150,000 RPM, generating a maximum wind speed of 45 m/s for efficient dust and debris removal. With 3 adjustable speed settings, it adapts to a variety of cleaning tasks with ease.\r\nVersatile Cleaning Tool: Featuring 5 nozzles and 2 brushes, the WOLFBOX electric air duster is perfect for cleaning electronics like PCs and keyboards, as well as for home, car, and outdoor use. It’s also great for inflating gear or managing campfires, making it a must-have for multiple scenarios.\r\nReuse and Cost-Efficiency: Made from durable materials, the WOLFBOX air duster offers a long battery life and can be reused more than 500 times. It’s a sustainable and economical alternative to single-use compressed air cans, much better choice for your wallet and the planet.\r\nFast 2.5-Hour Charging: The air duster supports Type-C charging and fully charges in just 2.5 hours. It provides up to 100 minutes of runtime on the first gear and offers 4 charging options. To ensure optimal performance of your MF100, please fully charge the battery before use.\r\nCompact and Portable Design: Weighing only 0.66lb, the WOLFBOX electric air duster is lightweight and easy to carry. It includes a lanyard for convenient handheld use, making it ideal for indoor cleaning, outdoor adventures, travel, and camping.\r\n24 Months & Support: WOLFBOX MegaFlow100 compressed air duster comes with a 24-month guarantee and 24/7 customer service. During this period, we will resolve any issues related to the product, installation, or usage for you.', '<ul class=\"a-unordered-list a-vertical a-spacing-mini\">\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\"><strong>Super Power Turbo Fan</strong>: The WOLFBOX MegaFlow100 electric air duster delivers impressive speeds of up to 150,000 RPM, generating a maximum wind speed of 45 m/s for efficient dust and debris removal. With 3 adjustable speed settings, it adapts to a variety of cleaning tasks with ease.</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">Versatile Cleaning Tool: Featuring 5 nozzles and 2 brushes, the WOLFBOX electric air duster is perfect for cleaning electronics like PCs and keyboards, as well as for home, car, and outdoor use. It&rsquo;s also great for inflating gear or managing campfires, making it a must-have for multiple scenarios.</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">Reuse and Cost-Efficiency: Made from durable materials, the WOLFBOX air duster offers a long battery life and can be reused more than 500 times. It&rsquo;s a sustainable and economical alternative to single-use compressed air cans, much better choice for your wallet and the planet.</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">Fast 2.5-Hour Charging: The air duster supports Type-C charging and fully charges in just 2.5 hours. It provides up to 100 minutes of runtime on the first gear and offers 4 charging options. To ensure optimal performance of your MF100, please fully charge the battery before use.</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\">Compact and Portable Design: Weighing only 0.66lb, the WOLFBOX electric air duster is lightweight and easy to carry. It includes a lanyard for convenient handheld use, making it ideal for indoor cleaning, outdoor adventures, travel, and camping.</span></li>\r\n<li class=\"a-spacing-mini\"><span class=\"a-list-item\"><strong>24 Months &amp; Support</strong>: WOLFBOX MegaFlow100 compressed air duster comes with a 24-month guarantee and 24/7 customer service. During this period, we will resolve any issues related to the product, installation, or usage for you.</span></li>\r\n</ul>', '2025-04-10 13:21:47', '2025-04-10 13:21:47');

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

--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `id` int(11) NOT NULL,
  `productid` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_images`
--

INSERT INTO `product_images` (`id`, `productid`, `image`, `created_at`, `updated_at`) VALUES
(1, '13', '1744307883p2.jpg', '2025-04-10 12:58:03', '2025-04-10 12:58:03'),
(2, '13', '1744307883p3.jpg', '2025-04-10 12:58:03', '2025-04-10 12:58:03'),
(3, '13', '1744307883p4.jpg', '2025-04-10 12:58:03', '2025-04-10 12:58:03'),
(5, '14', '1744308631ab.png', '2025-04-10 13:10:31', '2025-04-10 13:10:31'),
(6, '15', '1744308939pp2.jpg', '2025-04-10 13:15:39', '2025-04-10 13:15:39'),
(8, '15', '1744308940pp4.jpg', '2025-04-10 13:15:40', '2025-04-10 13:15:40'),
(9, '16', '1744309120ppp2.jpg', '2025-04-10 13:18:40', '2025-04-10 13:18:40'),
(10, '16', '1744309120ppp3.jpg', '2025-04-10 13:18:40', '2025-04-10 13:18:40'),
(11, '16', '1744309120ppp4.jpg', '2025-04-10 13:18:40', '2025-04-10 13:18:40'),
(12, '17', '1744309307pppp2.jpg', '2025-04-10 13:21:47', '2025-04-10 13:21:47'),
(13, '17', '1744309307pppp3.jpg', '2025-04-10 13:21:47', '2025-04-10 13:21:47'),
(14, '17', '1744309307pppp4.jpg', '2025-04-10 13:21:47', '2025-04-10 13:21:47');

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userid` (`userid`);

--
-- Indexes for table `order_history`
--
ALTER TABLE `order_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orderid` (`orderid`);

--
-- Indexes for table `payment_history`
--
ALTER TABLE `payment_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userid` (`userid`),
  ADD KEY `orderid` (`orderid`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `contactus`
--
ALTER TABLE `contactus`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

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

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

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `order_history`
--
ALTER TABLE `order_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `payment_history`
--
ALTER TABLE `payment_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `order_history`
--
ALTER TABLE `order_history`
  ADD CONSTRAINT `order_history_ibfk_1` FOREIGN KEY (`orderid`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `payment_history`
--
ALTER TABLE `payment_history`
  ADD CONSTRAINT `payment_history_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `payment_history_ibfk_2` FOREIGN KEY (`orderid`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

