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

START TRANSACTION;



--
-- Database: `madamar`
--

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

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `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 `brands`
--

INSERT INTO `brands` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Arabian Princes Secret', NULL, NULL),
(2, 'Bye Bye Sun', NULL, NULL),
(3, 'Miracle', NULL, NULL),
(4, 'New Generation', NULL, NULL),
(5, 'Moon Skin', NULL, NULL);

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

--
-- Table structure for table `campaigns`
--

CREATE TABLE `campaigns` (
  `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 `campaigns`
--

INSERT INTO `campaigns` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'For You', '2024-10-08 12:54:06', '2024-10-08 12:54:06'),
(2, 'Latest Products', '2024-10-08 12:54:06', '2024-10-08 12:54:06'),
(3, 'Most Popular', '2024-10-08 12:54:06', '2024-10-08 12:54:06'),
(4, 'Products Restocked', '2024-10-08 12:54:06', '2024-10-08 12:54:06');

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

--
-- Table structure for table `campaign_contexts`
--

CREATE TABLE `campaign_contexts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `campaign_id` bigint(20) UNSIGNED NOT NULL,
  `brand_id` bigint(20) UNSIGNED DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `is_global` 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 `campaign_contexts`
--

INSERT INTO `campaign_contexts` (`id`, `campaign_id`, `brand_id`, `category_id`, `is_global`, `created_at`, `updated_at`) VALUES
(2, 1, NULL, NULL, 1, '2024-10-08 18:42:50', '2024-10-08 18:42:50'),
(3, 2, NULL, NULL, 1, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(4, 3, NULL, NULL, 1, '2024-10-08 18:43:44', '2024-10-08 18:43:44'),
(5, 4, NULL, NULL, 1, '2024-10-08 18:44:10', '2024-10-08 18:44:10'),
(6, 2, 1, 1, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(7, 2, 1, 2, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(8, 4, 1, 3, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(9, 2, 1, 3, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(10, 3, 2, 2, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(11, 1, 3, 1, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(12, 2, 5, 11, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(13, 2, 3, 3, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(14, 2, 4, 1, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(15, 4, 4, 2, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(16, 4, 2, 4, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(17, 2, 2, 5, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(18, 4, 2, 6, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(19, 1, 3, 7, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(20, 1, 3, 8, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(21, 2, 3, 9, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(22, 3, 4, 10, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22'),
(23, 3, 4, 12, 0, '2024-10-08 18:43:22', '2024-10-08 18:43:22');

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

--
-- Table structure for table `campaign_context_products`
--

CREATE TABLE `campaign_context_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `campaign_context_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;

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

--
-- Table structure for table `carts`
--

CREATE TABLE `carts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_number` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(11) 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 `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `brand_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;

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

INSERT INTO `categories` (`id`, `name`, `slug`, `brand_id`, `created_at`, `updated_at`) VALUES
(3, 'Capsules', 'capsules', 1, '2024-10-01 12:45:52', '2024-10-01 12:45:52'),
(4, 'Softgel Capsules', 'softgel-capsules', 2, '2024-10-01 12:45:52', '2024-10-01 12:45:52'),
(5, 'Syrups', 'syrups', 2, '2024-10-01 12:45:52', '2024-10-01 12:45:52'),
(6, 'Drops', 'drops', 2, '2024-10-01 12:45:52', '2024-10-01 12:45:52'),
(7, 'Sprays', 'sprays', 3, '2024-10-01 12:45:52', '2024-10-01 12:45:52'),
(8, 'Tablets', 'tablets', 3, '2024-10-01 12:45:52', '2024-10-01 12:45:52'),
(9, 'Gummies', 'gummies', 3, '2024-10-01 12:45:52', '2024-10-01 12:45:52'),
(10, 'Powder', 'powder', 4, '2024-10-01 12:45:52', '2024-10-01 12:45:52'),
(11, 'Effervescent', 'effervescent', 5, '2024-10-01 12:45:52', '2024-10-01 12:45:52'),
(12, 'Sachets', 'sachets', 4, '2024-10-01 12:45:52', '2024-10-01 12:45:52'),
(13, 'salmankhan', 'salmankhan', 4, '2024-10-15 14:06:13', '2024-10-15 14:06:13');

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

--
-- 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 `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, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2024_09_24_181421_create_brands_table', 2),
(6, '2024_09_24_170517_create_products_table', 3),
(7, '2024_10_02_181936_create_orders_table', 4),
(8, '2024_10_02_181942_create_carts_table', 5),
(9, '2024_10_02_195238_create_wishlists_table', 6),
(11, '2024_10_03_164159_create_sections_table', 7),
(12, '2024_10_03_165001_create_section_products_table', 8),
(13, '2024_10_03_165657_create_product_images_table', 9),
(14, '2024_09_24_165540_create_categories_table', 10),
(15, '2024_10_06_060950_create_campaigns_table', 11),
(16, '2024_10_06_060105_create_campagin_context_products_table', 12),
(17, '2024_10_06_064312_create_campaign_context_products_table', 13),
(18, '2024_10_06_065253_create_campaign_context_products_table', 14);

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

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

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `order_ref` varchar(255) NOT NULL,
  `total_price` decimal(10,2) NOT NULL,
  `total_products` int(11) DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `orders` (`id`, `user_id`, `order_ref`, `total_price`, `total_products`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'order_66fda405a24a9', '5608275.00', 10105, 'processing', '2024-10-02 14:50:29', '2024-10-02 14:50:29', NULL);

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

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `brand_id` bigint(20) UNSIGNED NOT NULL,
  `product_code` varchar(225) DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `in_stock` tinyint(1) NOT NULL DEFAULT 1,
  `sku` varchar(255) NOT NULL,
  `price` decimal(8,2) 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 `products`
--

INSERT INTO `products` (`id`, `name`, `description`, `brand_id`, `product_code`, `category_id`, `in_stock`, `sku`, `price`, `created_at`, `updated_at`) VALUES
(30, 'testing34', '43', 2, '43', 4, 1, '4', '4.00', '2024-10-15 12:24:23', '2024-10-15 12:24:23'),
(31, 'testing', 'description', 2, '32', 3, 1, '5', '1000.00', '2024-10-15 12:27:42', '2024-10-15 12:27:42'),
(34, 'afsd', 'afsd', 1, 'afsd', 3, 1, '344', '2.00', '2024-10-15 12:42:42', '2024-10-15 12:42:42');

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

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

CREATE TABLE `product_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `image` 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 `product_images`
--

INSERT INTO `product_images` (`id`, `product_id`, `image`, `created_at`, `updated_at`) VALUES
(18, 34, 'zXuupUHmKXw9WuLBYwR6ccX3cZKqjmMZaA07uroj.png', '2024-10-15 12:42:43', '2024-10-15 12:42:43');

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

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `brand_id` bigint(20) UNSIGNED NOT NULL,
  `category_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 `section_products`
--

CREATE TABLE `section_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `section_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;

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

--
-- Table structure for table `wishlists`
--

CREATE TABLE `wishlists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_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 `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`);

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

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

--
-- Indexes for table `campaign_context_products`
--
ALTER TABLE `campaign_context_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `campaign_context_products_campaign_context_id_foreign` (`campaign_context_id`),
  ADD KEY `campaign_context_products_product_id_foreign` (`product_id`);

--
-- Indexes for table `carts`
--
ALTER TABLE `carts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `carts_user_id_foreign` (`user_id`),
  ADD KEY `carts_product_id_foreign` (`product_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  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 UNIQUE KEY `orders_order_ref_unique` (`order_ref`),
  ADD KEY `orders_user_id_foreign` (`user_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_sku_unique` (`sku`),
  ADD KEY `products_brand_id_foreign` (`brand_id`),
  ADD KEY `products_category_id_foreign` (`category_id`);

--
-- 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 `sections`
--
ALTER TABLE `sections`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sections_brand_id_foreign` (`brand_id`),
  ADD KEY `sections_category_id_foreign` (`category_id`);

--
-- Indexes for table `section_products`
--
ALTER TABLE `section_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `section_products_section_id_foreign` (`section_id`),
  ADD KEY `section_products_product_id_foreign` (`product_id`);

--
-- Indexes for table `wishlists`
--
ALTER TABLE `wishlists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wishlists_user_id_foreign` (`user_id`),
  ADD KEY `wishlists_product_id_foreign` (`product_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `campaigns`
--
ALTER TABLE `campaigns`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `campaign_contexts`
--
ALTER TABLE `campaign_contexts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `campaign_context_products`
--
ALTER TABLE `campaign_context_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67180;

--
-- AUTO_INCREMENT for table `carts`
--
ALTER TABLE `carts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

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

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

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

--
-- AUTO_INCREMENT for table `section_products`
--
ALTER TABLE `section_products`
  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, AUTO_INCREMENT=4;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `campaign_context_products`
--
ALTER TABLE `campaign_context_products`
  ADD CONSTRAINT `campaign_context_products_campaign_context_id_foreign` FOREIGN KEY (`campaign_context_id`) REFERENCES `campaign_contexts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `campaign_context_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `carts`
--
ALTER TABLE `carts`
  ADD CONSTRAINT `carts_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `carts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE CASCADE,
  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 `sections`
--
ALTER TABLE `sections`
  ADD CONSTRAINT `sections_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`),
  ADD CONSTRAINT `sections_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`);

--
-- Constraints for table `section_products`
--
ALTER TABLE `section_products`
  ADD CONSTRAINT `section_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  ADD CONSTRAINT `section_products_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`);

--
-- Constraints for table `wishlists`
--
ALTER TABLE `wishlists`
  ADD CONSTRAINT `wishlists_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wishlists_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

