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

START TRANSACTION;



--
-- Database: `thewagqz_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),
(49, 'Furniture 123', '2025-04-12 23:00:28', '2025-04-12 23:00:55', '2025-04-12 23:00:55', NULL, 1, 1),
(50, 'Test', '2025-04-12 23:01:55', '2025-04-12 23:01:55', NULL, NULL, 1, NULL);

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

--
-- 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
(12, 'khateeb ullah', 'admin@gmail.com', 'Database', 'test', '2025-04-12 23:35:12', '2025-04-12 23:35:12');

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

--
-- 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` text 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
(8, 77, 17, 'WOLFBOX MF100 Electric Air Duster', '89', '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>', 'pending', '2025-04-13 00:43:05', '2025-04-13 00:43:05'),
(11, 76, 18, 'Test Product', '100', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has su', '<div>\r\n<h2>What is Lorem Ipsum?</h2>\r\n<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley o', 'approved', '2025-04-15 09:15:51', '2025-04-15 09:18:20');

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

--
-- 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
(9, 8, '1232154-754676-6435', '697712-1744490672Scalper.png', '2025-04-13 00:44:32', '2025-04-13 00:44:32'),
(12, 11, '#5435352', '622657-1744694243281-Info-pop-cover-letter_grande.jpg', '2025-04-15 09:17:23', '2025-04-15 09:17:23'),
(13, 11, 'Review', '706992-17446942802018-02-26_090517 (1).png', '2025-04-15 09:18:00', '2025-04-15 09:18:00');

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

--
-- 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',
  `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 `payment_history`
--

INSERT INTO `payment_history` (`id`, `userid`, `orderid`, `status`, `image`, `created_at`, `updated_at`) VALUES
(15, 76, 11, 'approved', '17446943382018-02-26_090517.png', '2025-04-15 09:18:20', '2025-04-15 09:18: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` longblob DEFAULT NULL,
  `quantity` 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 `products`
--

INSERT INTO `products` (`id`, `heading`, `categoryid`, `image`, `price`, `tags`, `slug`, `description`, `instructions`, `quantity`, `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 ', 0x[BLOB], '20', '2025-04-10 12:58:03', '2025-04-14 08:18:25'),
(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 HOU', 0x[BLOB], '15', '2025-04-10 13:15:39', '2025-04-14 08:18:20'),
(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', 0x[BLOB], '75', '2025-04-10 13:18:40', '2025-04-14 08:18:12'),
(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 o', 0x[BLOB], '50', '2025-04-10 13:21:47', '2025-04-14 08:18:08'),
(18, 'Test Product', '50', '208454-1744484715p3.jpg', '100', 'CHARGE  , JBL , BLUETOOTH', 'test-product', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has su', 0x[BLOB], '1', '2025-04-12 23:05:15', '2025-04-14 09:24:45'),
(20, 'Cordless Vacuum Cleaner, 80000 RPM', '46', '92367-1744625109p1.jpg', '119', 'CHARGE  , JBL , BLUETOOTH', 'cordless-vacuum-cleaner-80000-rpm', 'The cordless vacuum cleaner, powered by a 180W upgraded brushless motor, delivers powerful suction to handle everyday messes and deep cleaning. With adjustable modes, it easily cleans dust, pet hair, debris, and more on surfaces. The built-in noise-reducing sponge keeps the noiThe main body of the vacuum cleaner for home weighs just 2.65 lbs, is incredibly lightweight, and is designed for ease of use. Its ergonomic build ensures comfortable one-handed cleaning, even for extended periods, without tiring your hand. The convenient wall mount design allows for easy storage and charging, saving space in your home.se under 65dB, providing a quieter, more comfortable cleaning experience.', 0x[BLOB], '5', '2025-04-14 14:05:09', '2025-04-14 14:05:09');

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

--
-- 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'),
(15, '18', '1744484715p1.jpg', '2025-04-12 23:05:15', '2025-04-12 23:05:15'),
(16, '18', '1744484715p2.jpg', '2025-04-12 23:05:15', '2025-04-12 23:05:15'),
(17, '18', '1744484715p3.jpg', '2025-04-12 23:05:15', '2025-04-12 23:05:15'),
(18, '19', '17446041541.jpg', '2025-04-14 08:15:54', '2025-04-14 08:15:54'),
(19, '19', '17446041541.png', '2025-04-14 08:15:54', '2025-04-14 08:15:54'),
(20, '19', '17446041542.jpg', '2025-04-14 08:15:54', '2025-04-14 08:15:54'),
(21, '20', '1744625109p2.jpg', '2025-04-14 14:05:09', '2025-04-14 14:05:09'),
(22, '20', '1744625109p3.jpg', '2025-04-14 14:05:09', '2025-04-14 14:05:09'),
(23, '20', '1744625109p4.jpg', '2025-04-14 14:05:09', '2025-04-14 14:05:09'),
(24, '20', '1744625109p5.jpg', '2025-04-14 14:05:09', '2025-04-14 14:05:09');

--
-- 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=51;

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

--
-- 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=12;

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

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

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

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

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

