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

START TRANSACTION;



--
-- Database: `cod_db`
--

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

--
-- Table structure for table `areas`
--

CREATE TABLE `areas` (
  `id` int(11) NOT NULL,
  `city` varchar(255) NOT NULL,
  `delivery_price` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `areas`
--

INSERT INTO `areas` (`id`, `city`, `delivery_price`) VALUES
(1, 'casa', 20.00),
(2, 'Oujda', 30.00),
(3, 'Agadir', 45.00),
(4, 'test', 5.00),
(5, 'dsdsdsd', 45.00),
(6, 'Merakech', 0.00),
(7, 'Rabat', 0.00),
(8, 'custom', 10.00),
(9, 'dafcha', 0.00);

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

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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `thumbnail` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `categories` (`id`, `title`, `subtitle`, `link`, `thumbnail`, `created_at`) VALUES
(9, 'Tshirts', 'category for tshirts brands', 'tshirts', '1719790841_6681ecf9831d3_colorful-assortment-gents-tshirts-apparel-mockup-photo-shoot-instore-display_732449-1660.jpg', '2024-06-07 22:51:04'),
(10, 'Watches', 'this is a watches category that containe everything about watches', 'watches-cat', '1718555960_666f153843399_vintage-pocket-watch-white-background-closeup_1015980-149198.jpg', '2024-06-07 23:00:02'),
(13, 'Perfume', 'Discover the Scents of Sophistication', 'perfume', '1718574249_666f5ca9e8586_luxury-perfume-spray-bottle-branding-mockup_47987-10412.avif', '2024-06-16 16:28:40'),
(17, 'test cat', 'test description', 'test-cat', '1719790874_6681ed1a512d8_PU3001X2_C90.webp', '2024-06-30 23:41:15');

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

--
-- Table structure for table `combination_options`
--

CREATE TABLE `combination_options` (
  `id` int(11) NOT NULL,
  `combination_id` int(11) DEFAULT NULL,
  `option_title` varchar(255) NOT NULL,
  `variant` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `combination_options`
--

INSERT INTO `combination_options` (`id`, `combination_id`, `option_title`, `variant`) VALUES
(1, 1, 'Size', 'S'),
(2, 1, 'Color', 'Blue'),
(3, 2, 'Size', 'S'),
(4, 2, 'Color', 'Green'),
(5, 3, 'Size', 'S'),
(6, 3, 'Color', 'Black'),
(7, 4, 'Size', 'M'),
(8, 4, 'Color', 'Blue'),
(9, 5, 'Size', 'M'),
(10, 5, 'Color', 'Green'),
(11, 6, 'Size', 'M'),
(12, 6, 'Color', 'Black'),
(13, 7, 'Size', 'L'),
(14, 7, 'Color', 'Blue'),
(15, 8, 'Size', 'L'),
(16, 8, 'Color', 'Green'),
(17, 9, 'Size', 'L'),
(18, 9, 'Color', 'Black'),
(19, 10, 'Size', '5 ml'),
(20, 11, 'Size', '10 ml'),
(21, 12, 'Size', '30 ml'),
(22, 13, 'Size', 'all bottle'),
(53, 32, 'Size', 'S'),
(54, 32, 'Color', 'White'),
(55, 33, 'Size', 'S'),
(56, 33, 'Color', 'Black'),
(57, 34, 'Size', 'M'),
(58, 34, 'Color', 'White'),
(59, 35, 'Size', 'M'),
(60, 35, 'Color', 'Black'),
(61, 36, 'Size', 'L'),
(62, 36, 'Color', 'White'),
(63, 37, 'Size', 'L'),
(64, 37, 'Color', 'Black'),
(65, 38, 'Size', 'S'),
(66, 38, 'Color', 'White'),
(67, 39, 'Size', 'S'),
(68, 39, 'Color', 'Black'),
(69, 40, 'Size', 'M'),
(70, 40, 'Color', 'White'),
(71, 41, 'Size', 'M'),
(72, 41, 'Color', 'Black'),
(73, 42, 'Size', 'L'),
(74, 42, 'Color', 'White'),
(75, 43, 'Size', 'L'),
(76, 43, 'Color', 'Black');

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `message` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `reference_id` int(11) NOT NULL,
  `is_read` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `user_id`, `message`, `type`, `reference_id`, `is_read`, `created_at`) VALUES
(1, 1, 'A new order has been created.', 'new_order', 8, 1, '2024-06-21 19:26:52'),
(2, 3, 'A new order has been created.', 'new_order', 8, 0, '2024-06-21 19:26:52'),
(4, 1, 'A new order has been created.', 'new_order', 9, 1, '2024-06-21 19:48:05'),
(5, 3, 'A new order has been created.', 'new_order', 9, 0, '2024-06-21 19:48:05'),
(7, 1, 'A new order has been created.', 'new_order', 10, 1, '2024-06-21 23:04:56'),
(8, 3, 'A new order has been created.', 'new_order', 10, 0, '2024-06-21 23:04:56'),
(9, 23, 'A new order has been created.', 'new_order', 10, 1, '2024-06-21 23:04:56'),
(10, 1, 'A new order has been created.', 'new_order', 11, 1, '2024-06-21 23:30:11'),
(11, 3, 'A new order has been created.', 'new_order', 11, 0, '2024-06-21 23:30:11'),
(12, 23, 'A new order has been created.', 'new_order', 11, 1, '2024-06-21 23:30:11'),
(13, 1, 'A new order has been created.', 'new_order', 12, 1, '2024-06-21 23:45:49'),
(14, 3, 'A new order has been created.', 'new_order', 12, 0, '2024-06-21 23:45:49'),
(15, 23, 'A new order has been created.', 'new_order', 12, 1, '2024-06-21 23:45:49'),
(16, 1, 'The status of order ID: 10 has changed.', 'order_status_changed', 10, 1, '2024-06-22 14:24:43'),
(17, 1, 'A new order has been created. Order ID: 13', 'new_order', 13, 1, '2024-06-22 20:25:52'),
(18, 3, 'A new order has been created. Order ID: 13', 'new_order', 13, 0, '2024-06-22 20:25:52'),
(19, 23, 'A new order has been created. Order ID: 13', 'new_order', 13, 1, '2024-06-22 20:25:52'),
(20, 1, 'A new order has been created. Order ID: 14', 'new_order', 14, 1, '2024-06-22 20:28:18'),
(21, 3, 'A new order has been created. Order ID: 14', 'new_order', 14, 0, '2024-06-22 20:28:18'),
(22, 23, 'A new order has been created. Order ID: 14', 'new_order', 14, 1, '2024-06-22 20:28:18'),
(23, 1, 'A new order has been created. Order ID: 15', 'new_order', 15, 1, '2024-06-22 20:28:55'),
(24, 3, 'A new order has been created. Order ID: 15', 'new_order', 15, 0, '2024-06-22 20:28:55'),
(25, 23, 'A new order has been created. Order ID: 15', 'new_order', 15, 1, '2024-06-22 20:28:55'),
(26, 1, 'A new order has been created. Order ID: 16', 'new_order', 16, 1, '2024-06-22 20:30:37'),
(27, 3, 'A new order has been created. Order ID: 16', 'new_order', 16, 0, '2024-06-22 20:30:37'),
(28, 23, 'A new order has been created. Order ID: 16', 'new_order', 16, 1, '2024-06-22 20:30:37'),
(29, 1, 'A new order has been created. Order ID: 17', 'new_order', 17, 1, '2024-06-22 20:32:17'),
(30, 3, 'A new order has been created. Order ID: 17', 'new_order', 17, 0, '2024-06-22 20:32:17'),
(31, 23, 'A new order has been created. Order ID: 17', 'new_order', 17, 1, '2024-06-22 20:32:17'),
(32, 1, 'A new order has been created. Order ID: 18', 'new_order', 18, 1, '2024-06-22 20:33:47'),
(33, 3, 'A new order has been created. Order ID: 18', 'new_order', 18, 0, '2024-06-22 20:33:47'),
(34, 23, 'A new order has been created. Order ID: 18', 'new_order', 18, 1, '2024-06-22 20:33:47'),
(35, 1, 'A new order has been created. Order ID: 19', 'new_order', 19, 1, '2024-06-22 20:35:05'),
(36, 3, 'A new order has been created. Order ID: 19', 'new_order', 19, 0, '2024-06-22 20:35:05'),
(37, 23, 'A new order has been created. Order ID: 19', 'new_order', 19, 1, '2024-06-22 20:35:05'),
(38, 1, 'A new order has been created. Order ID: 20', 'new_order', 20, 1, '2024-06-22 20:36:45'),
(39, 3, 'A new order has been created. Order ID: 20', 'new_order', 20, 0, '2024-06-22 20:36:45'),
(40, 23, 'A new order has been created. Order ID: 20', 'new_order', 20, 1, '2024-06-22 20:36:45'),
(41, 1, 'A new order has been created. Order ID: 21', 'new_order', 21, 1, '2024-06-22 22:39:58'),
(42, 3, 'A new order has been created. Order ID: 21', 'new_order', 21, 0, '2024-06-22 22:39:58'),
(43, 23, 'A new order has been created. Order ID: 21', 'new_order', 21, 1, '2024-06-22 22:39:58'),
(44, 1, 'A new order has been created. Order ID: 22', 'new_order', 22, 1, '2024-06-22 22:40:30'),
(45, 3, 'A new order has been created. Order ID: 22', 'new_order', 22, 0, '2024-06-22 22:40:30'),
(46, 23, 'A new order has been created. Order ID: 22', 'new_order', 22, 1, '2024-06-22 22:40:30'),
(47, 1, 'A new order has been created. Order ID: 23', 'new_order', 23, 1, '2024-06-22 22:41:00'),
(48, 3, 'A new order has been created. Order ID: 23', 'new_order', 23, 0, '2024-06-22 22:41:00'),
(49, 23, 'A new order has been created. Order ID: 23', 'new_order', 23, 1, '2024-06-22 22:41:00'),
(50, 1, 'A new order has been created. Order ID: 24', 'new_order', 24, 1, '2024-06-22 23:01:38'),
(51, 3, 'A new order has been created. Order ID: 24', 'new_order', 24, 0, '2024-06-22 23:01:38'),
(52, 23, 'A new order has been created. Order ID: 24', 'new_order', 24, 1, '2024-06-22 23:01:38'),
(53, 1, 'The status of order ID: 24 has changed.', 'order_status_changed', 24, 1, '2024-06-23 18:59:54'),
(54, 1, 'The status of order ID: 23 has changed.', 'order_status_changed', 23, 1, '2024-06-23 19:12:37'),
(55, 1, 'The status of order ID: 22 has changed.', 'order_status_changed', 22, 1, '2024-06-23 19:12:57'),
(56, 1, 'The status of order ID: 21 has changed.', 'order_status_changed', 21, 1, '2024-06-23 19:13:09'),
(57, 1, 'The status of order ID: 20 has changed.', 'order_status_changed', 20, 1, '2024-06-23 19:20:01'),
(58, 1, 'The status of order ID: 19 has changed.', 'order_status_changed', 19, 1, '2024-06-24 00:08:49'),
(59, 1, 'This Order: 19 , is out of stock.', 'out_of_stock', 19, 1, '2024-06-24 00:08:49'),
(60, 3, 'This Order: 19 , is out of stock.', 'out_of_stock', 19, 0, '2024-06-24 00:08:49'),
(61, 23, 'This Order: 19 , is out of stock.', 'out_of_stock', 19, 1, '2024-06-24 00:08:49'),
(62, 1, 'The status of order ID: 19 has changed.', 'order_status_changed', 19, 1, '2024-06-24 00:58:20'),
(63, 4, 'The status of order ID: 19 has changed.', 'order_status_changed', 19, 1, '2024-06-24 00:58:20'),
(65, 1, 'The status of order ID: 19 has changed.', 'order_status_changed', 19, 1, '2024-06-24 01:39:09'),
(66, 1, 'This Order: 19 , is out of stock.', 'out_of_stock', 19, 1, '2024-06-24 01:39:09'),
(67, 3, 'This Order: 19 , is out of stock.', 'out_of_stock', 19, 0, '2024-06-24 01:39:09'),
(68, 23, 'This Order: 19 , is out of stock.', 'out_of_stock', 19, 1, '2024-06-24 01:39:09'),
(69, 1, 'The status of order ID: 19 has changed.', 'order_status_changed', 19, 1, '2024-06-24 01:39:36'),
(70, 4, 'The order ID: 19 has Confirmed!', 'order_status_changed', 19, 1, '2024-06-24 01:39:36'),
(71, 1, 'The status of order ID: 19 has changed.', 'order_status_changed', 19, 1, '2024-06-24 01:39:59'),
(72, 1, 'The status of order ID: 24 has changed.', 'order_status_changed', 24, 1, '2024-06-26 17:24:54'),
(73, 1, 'The status of order ID: 24 has changed.', 'order_status_changed', 24, 1, '2024-06-26 17:26:54'),
(74, 1, 'The status of order ID: 15 has changed.', 'order_status_changed', 15, 1, '2024-06-26 17:39:37'),
(75, 4, 'The order ID: 15 has Confirmed!', 'order_status_changed', 15, 1, '2024-06-26 17:39:37'),
(76, 1, 'A new order has been created. Order ID: 25', 'new_order', 25, 1, '2024-06-27 01:35:33'),
(77, 3, 'A new order has been created. Order ID: 25', 'new_order', 25, 0, '2024-06-27 01:35:33'),
(78, 23, 'A new order has been created. Order ID: 25', 'new_order', 25, 1, '2024-06-27 01:35:33'),
(79, 1, 'The status of order ID: 25 has changed.', 'order_status_changed', 25, 1, '2024-06-28 14:51:08'),
(80, 1, 'The status of order ID: 17 has changed.', 'order_status_changed', 17, 1, '2024-06-28 14:51:27'),
(81, 1, 'The status of order ID: 14 has changed.', 'order_status_changed', 14, 1, '2024-06-28 15:22:20'),
(82, 4, 'The order ID: 14 has Confirmed!', 'order_status_changed', 14, 1, '2024-06-28 15:22:20'),
(83, 1, 'The status of order ID: 14 has changed.', 'order_status_changed', 14, 1, '2024-06-28 15:22:38'),
(84, 1, 'The status of order ID: 14 has changed.', 'order_status_changed', 14, 1, '2024-06-28 15:22:49'),
(85, 1, 'The status of order ID: 13 has changed.', 'order_status_changed', 13, 1, '2024-06-28 15:23:10'),
(87, 1, 'A new order has been created. Order ID: 26', 'new_order', 26, 1, '2024-06-30 23:03:43'),
(88, 3, 'A new order has been created. Order ID: 26', 'new_order', 26, 0, '2024-06-30 23:03:43'),
(89, 23, 'A new order has been created. Order ID: 26', 'new_order', 26, 1, '2024-06-30 23:03:43'),
(90, 1, 'A new order has been created. Order ID: 27', 'new_order', 27, 1, '2024-06-30 23:07:12'),
(91, 3, 'A new order has been created. Order ID: 27', 'new_order', 27, 0, '2024-06-30 23:07:12'),
(92, 23, 'A new order has been created. Order ID: 27', 'new_order', 27, 1, '2024-06-30 23:07:12'),
(93, 1, 'A new order has been created. Order ID: 28', 'new_order', 28, 1, '2024-06-30 23:14:44'),
(94, 3, 'A new order has been created. Order ID: 28', 'new_order', 28, 0, '2024-06-30 23:14:44'),
(95, 23, 'A new order has been created. Order ID: 28', 'new_order', 28, 1, '2024-06-30 23:14:44'),
(96, 1, 'A new order has been created. Order ID: 29', 'new_order', 29, 1, '2024-06-30 23:46:25'),
(97, 3, 'A new order has been created. Order ID: 29', 'new_order', 29, 0, '2024-06-30 23:46:25'),
(98, 23, 'A new order has been created. Order ID: 29', 'new_order', 29, 1, '2024-06-30 23:46:25'),
(99, 1, 'The status of order ID: 29 has changed.', 'order_status_changed', 29, 1, '2024-06-30 23:50:10'),
(100, 4, 'The order ID: 29 has Confirmed!', 'order_status_changed', 29, 1, '2024-06-30 23:50:10'),
(101, 1, 'The status of order ID: 29 has changed.', 'order_status_changed', 29, 1, '2024-06-30 23:51:13'),
(102, 1, 'This Order: 29 , is out of stock.', 'out_of_stock', 29, 1, '2024-06-30 23:51:13'),
(103, 3, 'This Order: 29 , is out of stock.', 'out_of_stock', 29, 0, '2024-06-30 23:51:13'),
(104, 23, 'This Order: 29 , is out of stock.', 'out_of_stock', 29, 1, '2024-06-30 23:51:13'),
(105, 1, 'The status of order ID: 29 has changed.', 'order_status_changed', 29, 1, '2024-06-30 23:51:58'),
(106, 4, 'The order ID: 29 has Confirmed!', 'order_status_changed', 29, 1, '2024-06-30 23:51:58'),
(107, 1, 'The status of order ID: 29 has changed.', 'order_status_changed', 29, 1, '2024-06-30 23:52:27'),
(108, 1, 'The status of order ID: 29 has changed.', 'order_status_changed', 29, 0, '2024-06-30 23:54:43'),
(109, 1, 'A new order has been created. Order ID: 30', 'new_order', 30, 0, '2024-07-05 21:07:43'),
(110, 3, 'A new order has been created. Order ID: 30', 'new_order', 30, 0, '2024-07-05 21:07:43'),
(111, 23, 'A new order has been created. Order ID: 30', 'new_order', 30, 0, '2024-07-05 21:07:43'),
(112, 1, 'A new order has been created. Order ID: 31', 'new_order', 31, 0, '2024-07-05 21:27:32'),
(113, 3, 'A new order has been created. Order ID: 31', 'new_order', 31, 0, '2024-07-05 21:27:32'),
(114, 23, 'A new order has been created. Order ID: 31', 'new_order', 31, 0, '2024-07-05 21:27:32'),
(115, 1, 'A new order has been created. Order ID: 32', 'new_order', 32, 0, '2024-07-06 00:08:11'),
(116, 3, 'A new order has been created. Order ID: 32', 'new_order', 32, 0, '2024-07-06 00:08:11'),
(117, 23, 'A new order has been created. Order ID: 32', 'new_order', 32, 0, '2024-07-06 00:08:11'),
(118, 1, 'A new order has been created. Order ID: 33', 'new_order', 33, 0, '2024-07-06 00:10:24'),
(119, 3, 'A new order has been created. Order ID: 33', 'new_order', 33, 0, '2024-07-06 00:10:24'),
(120, 23, 'A new order has been created. Order ID: 33', 'new_order', 33, 0, '2024-07-06 00:10:24'),
(121, 1, 'A new order has been created. Order ID: 34', 'new_order', 34, 0, '2024-07-06 01:05:54'),
(122, 3, 'A new order has been created. Order ID: 34', 'new_order', 34, 0, '2024-07-06 01:05:54'),
(123, 23, 'A new order has been created. Order ID: 34', 'new_order', 34, 0, '2024-07-06 01:05:54'),
(124, 1, 'A new order has been created. Order ID: 35', 'new_order', 35, 0, '2024-07-06 01:35:22'),
(125, 3, 'A new order has been created. Order ID: 35', 'new_order', 35, 0, '2024-07-06 01:35:22'),
(126, 23, 'A new order has been created. Order ID: 35', 'new_order', 35, 0, '2024-07-06 01:35:22');

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

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

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `city` varchar(100) NOT NULL,
  `address` text NOT NULL,
  `message` text DEFAULT NULL,
  `status` varchar(50) DEFAULT 'pending',
  `source` varchar(50) DEFAULT 'shop',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `is_archived` tinyint(1) DEFAULT 0,
  `delivery_price` decimal(10,2) NOT NULL,
  `total_price` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `orders` (`id`, `name`, `phone`, `city`, `address`, `message`, `status`, `source`, `created_at`, `is_archived`, `delivery_price`, `total_price`) VALUES
(2, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Agadir', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'test', 'pending', 'shop', '2024-06-19 13:16:20', 0, 0.00, 0.00),
(4, 'Salah Daoud', '0611223344', 'casa', 'cornich, mall Rue 06, N 32', 'jibhali qbel nhar alhed', 'canceled', 'shop', '2024-06-19 16:07:59', 0, 0.00, 0.00),
(5, 'Bader Aimran', '0699887766', 'Oujda', 'el qods, rue 17, N 04', 'khaliha 3nd l7anot li lta7t ila malqitnich fdar', 'unreachable', 'shop', '2024-06-19 16:09:32', 0, 0.00, 0.00),
(6, 'Jhone Do', '0622222288', 'casa', 'Ain diab, rue 23 N 190', 'jibhali qbel l3id', 'pending', 'shop', '2024-06-21 19:15:04', 0, 0.00, 0.00),
(7, 'Houda Rahmani', '0611223344', 'Agadir', 'Hey el Hourya, Rue 41 N 01', 'ila malqitnich fdar khaliah 3and jarti', 'pending', 'shop', '2024-06-21 19:19:15', 0, 0.00, 0.00),
(8, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Oujda', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'sssssss', 'pending', 'shop', '2024-06-21 19:26:52', 0, 0.00, 0.00),
(9, 'Brahim Ibra', '0711223344', 'casa', 'garage alala, rue 12 n03', 'bghytha qbel ras al3am', 'pending', 'shop', '2024-06-21 19:48:05', 0, 0.00, 0.00),
(10, 'Dounya Yaago', '0655332211', 'Oujda', 'Hey Lazary, rue 25 n 45', 'sonili qble matjibhali', 'confirmed', 'shop', '2024-06-21 23:04:56', 0, 0.00, 0.00),
(11, 'Said batata', '0611221122', 'Agadir', 'Hey Houara, rue 12, n 12', 'jiboli lelkhadma mora 6h', 'pending', 'shop', '2024-06-21 23:30:11', 0, 0.00, 0.00),
(12, 'Aziz Laouki', '0722994433', 'Oujda', 'Hey Al Andalos, rue 88 n 10', 'bla ma tatl3 heta l 5eme, sonili flbab ta7tani ana nhbet 3ndo', 'returned', 'shop', '2024-06-21 23:45:49', 0, 0.00, 0.00),
(13, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Oujda', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'QSqsQSqsqqqqqqq', 'delivered', 'shop', '2024-06-22 20:25:52', 0, 0.00, 0.00),
(14, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Agadir', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'sssssssss', 'delivered', 'shop', '2024-06-22 20:28:18', 0, 0.00, 0.00),
(15, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Agadir', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'zzzzzzzzzzz', 'confirmed', 'shop', '2024-06-22 20:28:55', 0, 0.00, 0.00),
(16, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Agadir', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'zzzzzzzzz', 'pending', 'shop', '2024-06-22 20:30:37', 0, 0.00, 0.00),
(17, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Oujda', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'aaaaaa', 'delivered', 'confirmations', '2024-06-22 20:32:17', 0, 0.00, 0.00),
(18, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Agadir', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'wwwwwwww', 'pending', 'shop', '2024-06-22 20:33:47', 0, 0.00, 0.00),
(19, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Agadir', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'sdfsdfddddddddddddddd', 'packed', 'confirmations', '2024-06-22 20:35:05', 1, 0.00, 0.00),
(20, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'casa', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'ssssssssss', 'outofstock', 'confirmation agent', '2024-06-22 20:36:45', 1, 0.00, 0.00),
(21, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Oujda', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'aaaaaaaaaa', 'packed', 'confirmation agent', '2024-06-22 22:39:58', 1, 0.00, 0.00),
(22, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Oujda', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'aaaaaaaaaa', 'packed', 'confirmation agent', '2024-06-22 22:40:30', 1, 0.00, 0.00),
(23, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Oujda', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'aaaaaaaaaa', 'packed', 'confirmation agent', '2024-06-22 22:41:00', 0, 0.00, 0.00),
(24, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'casa', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'fghfghggggg', 'packed', 'confirmation agent', '2024-06-22 23:01:38', 1, 0.00, 0.00),
(25, 'test', '0600000000', 'Agadir', 'hey lmo3owaqin', 'jibhali had alhed', 'returned', 'Admin Panel', '2024-06-27 01:35:33', 0, 0.00, 0.00),
(26, 'test name', '0600000000', 'Rabat', 'hda raba center', 'ila malqitnich fdar khaliha lmol l7anot', 'pending', 'shop', '2024-06-30 23:03:43', 0, 0.00, 0.00),
(27, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Oujda', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'hjghjghj', 'pending', 'shop', '2024-06-30 23:07:11', 0, 0.00, 0.00),
(28, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Oujda', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'sdfsdf', 'pending', 'shop', '2024-06-30 23:14:44', 0, 0.00, 0.00),
(29, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'dafcha', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'ila malqitnich khaliha 3nd mol l7anot', 'delivered', 'shop', '2024-06-30 23:46:25', 1, 0.00, 0.00),
(30, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Agadir', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'something', 'pending', 'shop', '2024-07-05 21:07:43', 0, 0.00, 0.00),
(31, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Agadir', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'testtttttt', 'pending', 'shop', '2024-07-05 21:27:32', 0, 45.00, 670.00),
(32, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Oujda', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'sdfsdfsdfssssssssssssss', 'pending', 'shop', '2024-07-06 00:08:11', 0, 30.00, 349.00),
(33, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Oujda', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'qqqqqqqqqqqqq', 'pending', 'shop', '2024-07-06 00:10:24', 0, 30.00, 349.00),
(34, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Agadir', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'sssssssssss', 'pending', 'shop', '2024-07-06 01:05:54', 0, 45.00, 789.00),
(35, 'MOHAMED-AMINE CHEKROUNI', '0620108495', 'Agadir', 'HAY EL HOURIA SUD RUE 31 NR 04 EL AIOUN', 'cvfv', 'pending', 'shop', '2024-07-06 01:35:22', 0, 45.00, 220.00);

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `selected_variants` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`selected_variants`)),
  `quantity` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `selected_variants`, `quantity`, `price`) VALUES
(2, 2, 2, '{\"Size\":\"5 ml\"}', 1, 120.00),
(4, 4, 3, '{}', 2, 220.00),
(5, 5, 1, '{\"Size\":\"M\",\"Color\":\"Green\"}', 3, 199.00),
(6, 6, 3, '{}', 1, 220.00),
(7, 7, 3, '{}', 1, 220.00),
(8, 8, 3, '{}', 1, 220.00),
(9, 9, 2, '{\"Size\":\"5 ml\"}', 1, 120.00),
(10, 10, 1, '{\"Size\":\"S\",\"Color\":\"Blue\"}', 1, 199.00),
(11, 11, 3, '{}', 1, 220.00),
(12, 12, 1, '{\"Size\":\"L\",\"Color\":\"Black\"}', 1, 199.00),
(13, 13, 3, '{}', 1, 220.00),
(14, 14, 3, '{}', 1, 220.00),
(15, 15, 3, '{}', 1, 220.00),
(16, 16, 3, '{}', 1, 220.00),
(17, 17, 3, '{}', 1, 220.00),
(18, 18, 3, '{}', 1, 220.00),
(19, 19, 3, '{}', 1, 220.00),
(20, 20, 1, '{\"Size\":\"S\",\"Color\":\"Blue\"}', 1, 199.00),
(21, 21, 3, '{}', 1, 220.00),
(22, 22, 3, '{}', 1, 220.00),
(23, 23, 3, '{}', 1, 220.00),
(24, 24, 3, '{}', 1, 220.00),
(25, 25, 3, '{}', 1, 220.00),
(26, 26, 8, '{\"Size\":\"S\",\"Color\":\"White\"}', 1, 199.00),
(27, 27, 3, '{}', 1, 220.00),
(28, 28, 3, '{}', 1, 220.00),
(29, 29, 10, '{\"Size\":\"S\",\"Color\":\"White\"}', 1, 199.00),
(30, 30, 1, '{\"Size\":\"S\",\"Color\":\"Green\"}', 1, 150.00),
(31, 30, 2, '{\"Size\":\"10 ml\"}', 1, 199.00),
(32, 30, 3, '{}', 1, 220.00),
(33, 31, 1, '{\"Size\":\"S\",\"Color\":\"Green\"}', 1, 150.00),
(34, 31, 2, '{\"Size\":\"30 ml\"}', 1, 300.00),
(35, 31, 3, '{}', 1, 220.00),
(36, 32, 1, '{\"Size\":\"S\",\"Color\":\"Green\"}', 1, 150.00),
(37, 32, 10, '{\"Size\":\"L\",\"Color\":\"Black\"}', 1, 199.00),
(38, 33, 1, '{\"Size\":\"S\",\"Color\":\"Green\"}', 1, 150.00),
(39, 33, 10, '{\"Size\":\"M\",\"Color\":\"Black\"}', 1, 199.00),
(40, 34, 1, '{\"Size\":\"S\",\"Color\":\"Green\"}', 1, 150.00),
(41, 34, 2, '{\"Size\":\"10 ml\"}', 1, 199.00),
(42, 34, 3, '{}', 2, 220.00),
(43, 35, 3, '{}', 1, 220.00);

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

--
-- Table structure for table `order_status_changes`
--

CREATE TABLE `order_status_changes` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `new_status` varchar(50) NOT NULL,
  `comment` text DEFAULT NULL,
  `changed_by` int(11) NOT NULL,
  `change_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `order_status_changes`
--

INSERT INTO `order_status_changes` (`id`, `order_id`, `new_status`, `comment`, `changed_by`, `change_date`) VALUES
(1, 2, 'confirmed', 'ok', 23, '2024-06-20 16:29:49'),
(2, 2, 'canceled', 'ok', 23, '2024-06-20 16:30:08'),
(3, 2, 'confirmed', 'ok', 23, '2024-06-20 16:32:47'),
(4, 2, 'canceled', 'something', 23, '2024-06-20 16:51:31'),
(5, 2, 'unreachable', 'sssss', 23, '2024-06-20 16:52:14'),
(6, 2, 'confirmed', 'sssss', 23, '2024-06-20 16:52:29'),
(7, 2, 'canceled', 'sssss', 23, '2024-06-20 16:52:47'),
(8, 2, 'confirmed', 'sssss', 23, '2024-06-20 16:52:59'),
(9, 2, 'pending', 'sssss', 23, '2024-06-20 16:53:17'),
(10, 2, 'confirmed', 'sssss', 23, '2024-06-20 16:53:22'),
(11, 4, 'canceled', 'something', 23, '2024-06-20 16:53:41'),
(12, 5, 'unreachable', 'cansoni makayjawbch', 23, '2024-06-20 16:54:09'),
(13, 2, 'pending', '', 23, '2024-06-20 19:29:14'),
(14, 10, 'confirmed', 'ok', 23, '2024-06-22 14:24:43'),
(15, 24, 'packed', 'done', 4, '2024-06-23 18:59:54'),
(16, 23, 'packed', 'fgh', 4, '2024-06-23 19:12:37'),
(17, 22, 'packed', 'aaa', 4, '2024-06-23 19:12:57'),
(18, 21, 'unfilfiled', 'aaaaaaa', 4, '2024-06-23 19:13:09'),
(19, 20, 'outofstock', 'mab9ach noir, baqi lbyed o red', 4, '2024-06-23 19:20:01'),
(20, 19, 'outofstock', 'mabqach had order f noir', 4, '2024-06-24 00:08:49'),
(21, 19, 'confirmed', 'rah bdlha bgha l7mer', 23, '2024-06-24 00:58:20'),
(22, 19, 'outofstock', 'hetta dak lon makaynch kayen lwhite', 4, '2024-06-24 01:39:09'),
(23, 19, 'confirmed', 'safi bgha lbyed', 23, '2024-06-24 01:39:36'),
(24, 19, 'packed', 'done', 4, '2024-06-24 01:39:59'),
(25, 24, 'unreachable', '', 1, '2024-06-26 17:24:54'),
(26, 24, 'packed', 'safi rah jm3to rasi o sifto', 1, '2024-06-26 17:26:54'),
(27, 15, 'confirmed', 'confirmah mol chi hh', 1, '2024-06-26 17:39:37'),
(28, 25, 'return', 'matwslch biha', 1, '2024-06-28 14:51:08'),
(29, 17, 'deliver', 'twsel biha', 1, '2024-06-28 14:51:27'),
(30, 14, 'confirmed', 'admin confirm', 1, '2024-06-28 15:22:20'),
(31, 14, 'packed', 'admin packed', 1, '2024-06-28 15:22:38'),
(32, 14, 'deliver', 'admin deliver', 1, '2024-06-28 15:22:49'),
(33, 13, 'deliver', 'deliver by admin', 1, '2024-06-28 15:23:10'),
(34, 12, 'return', 'makhdahch', 1, '2024-06-28 15:23:24'),
(35, 29, 'confirmed', 'safi rani confirmit', 23, '2024-06-30 23:50:10'),
(36, 29, 'outofstock', 'mabqach flawn lbyed', 4, '2024-06-30 23:51:13'),
(37, 29, 'confirmed', 'safi rah bghah flawn noir', 23, '2024-06-30 23:51:58'),
(38, 29, 'packed', 'ok done!', 4, '2024-06-30 23:52:27'),
(39, 29, 'delivered', 'ran ideliverito rasi ( admin )', 1, '2024-06-30 23:54:43');

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

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

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `comparing_price` decimal(10,2) DEFAULT NULL,
  `stock` int(11) NOT NULL,
  `thumbnail_url` varchar(255) NOT NULL,
  `product_type` varchar(255) NOT NULL,
  `has_options` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `products` (`id`, `title`, `subtitle`, `description`, `price`, `comparing_price`, `stock`, `thumbnail_url`, `product_type`, `has_options`, `created_at`) VALUES
(1, 'Classic Comfort Tee', 'Simplicity Meets Style', '<p>Discover the ultimate in everyday wear with our Classic Comfort Tee. Made from ultra-soft, breathable cotton, this t-shirt delivers unmatched comfort and a timeless look. Perfect for any occasion, whether you\'re dressing it up or keeping it casual, this versatile tee is a wardrobe essential. With its clean lines and relaxed fit, the Classic Comfort Tee is designed to be your go-to choice for effortless style and comfort. Available in a range of colors to suit every taste, this shirt is the epitome of simple, understated elegance.</p>', 199.00, 250.00, 90, '1718551247_666f02cfc2e95_Capture d\'écran 2024-06-16 145648.png', 'tshirts', 1, '2024-06-16 15:23:30'),
(2, 'Montale Arabians Tonka Perfume', 'A Symphony of Exotic Elegance', '<p>Immerse yourself in the enchanting allure of Montale Arabians Tonka, a luxurious fragrance that captures the essence of opulence and mystique. This captivating scent opens with a vibrant burst of bergamot and saffron, gracefully transitioning into a heart of delicate rose and lush jasmine. The base notes of rich tonka bean, oud, and oakmoss create a warm, lingering finish that is both sensual and sophisticated. Perfect for those who appreciate the finer things in life, Montale Arabians Tonka is an exquisite blend of tradition and modernity, crafted to leave an unforgettable impression. Elevate your fragrance collection with this timeless masterpiece.</p>', 120.00, 150.00, 100, '1718555422_666f131ef11ff_ppVjkIN9e2QrmCdch4HNWJnf5xgzRtIA1Px0I5wM.webp', 'perfume', 1, '2024-06-16 16:32:49'),
(3, 'Eclipse Chronograph Watch', 'Masterpiece of Precision and Style', '<p>Introducing the Eclipse Chronograph Watch, a stunning fusion of elegance and functionality. This timepiece boasts a meticulously crafted stainless steel case, complemented by a sapphire crystal face that resists scratches and enhances durability. The intricate chronograph dial features luminous hands and markers, ensuring readability in any light. With its reliable quartz movement, the Eclipse Chronograph offers unparalleled accuracy. The sleek leather strap provides a comfortable fit, making it perfect for both formal occasions and everyday wear. Elevate your wristwear collection with the Eclipse Chronograph Watch, where timeless design meets modern sophistication.</p>', 220.00, 340.00, 10, '1718556162_666f160254dd2_Capture d\'écran 2024-06-16 152305.png', 'watch', 0, '2024-06-16 16:43:00'),
(8, 'test title', 'test subtitle', '<p>test description</p>', 199.00, 350.00, 100, '1719788297_6681e309eaf63_image-1.jpg', 'test type', 1, '2024-06-30 22:59:48'),
(10, 'test 02', 'test subtitle', '<p>test description</p>', 199.00, 350.00, 100, '1719790975_6681ed7f4b261_PU3001X2_C90.webp', 'test type', 1, '2024-06-30 23:44:00');

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

--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `product_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_categories`
--

INSERT INTO `product_categories` (`product_id`, `category_id`) VALUES
(1, 9),
(2, 13),
(3, 10),
(8, 9),
(8, 10),
(10, 9),
(10, 10);

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

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

CREATE TABLE `product_images` (
  `id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `image_url` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `product_images` (`id`, `product_id`, `image_url`) VALUES
(1, 1, '1718551242_666f02ca9471a_Capture d\'écran 2024-06-16 145324.png'),
(2, 1, '1718551242_666f02caa33c8_Capture d\'écran 2024-06-16 145454.png'),
(3, 1, '1718551242_666f02caaf4bb_Capture d\'écran 2024-06-16 145531.png'),
(4, 1, '1718551242_666f02cab76c0_Capture d\'écran 2024-06-16 145619.png'),
(5, 1, '1718551242_666f02cac438d_Capture d\'écran 2024-06-16 145648.png'),
(6, 1, '1718551242_666f02cabbfc5_Capture d\'écran 2024-06-16 145727.png'),
(7, 2, '1718555417_666f131952dbd_mbz9OhPoNmYQ8fzBm8kNHVZMoXSReKpTOrpu9ZW9.jpeg'),
(8, 2, '1718555417_666f1319537d4_ppVjkIN9e2QrmCdch4HNWJnf5xgzRtIA1Px0I5wM.webp'),
(9, 3, '1718556156_666f15fc7180c_Capture d\'écran 2024-06-16 152305.png'),
(10, 3, '1718556156_666f15fc79a38_Capture d\'écran 2024-06-16 152350.png'),
(11, 3, '1718556156_666f15fc801f2_Capture d\'écran 2024-06-16 152419.png'),
(12, 3, '1718556156_666f15fc82145_Capture d\'écran 2024-06-16 152457.png'),
(24, 8, '1719788283_6681e2fb2ac40_image-3.jpg'),
(25, 8, '1719788283_6681e2fb2af30_image-4.jpg'),
(26, 8, '1719788283_6681e2fb39965_image-5.jpg'),
(27, 8, '1719788283_6681e2fb2e746_image-6.jpg'),
(33, 10, '1719790968_6681ed78a6b5a_PU3001X2_BLACK.webp'),
(34, 10, '1719790968_6681ed78b617d_PU3001X2_BLUEMEL.webp'),
(35, 10, '1719790968_6681ed78b6422_PU3001X2_C80.webp'),
(36, 10, '1719790968_6681ed78baf07_PU3001X2_C90.webp');

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

--
-- Table structure for table `product_options`
--

CREATE TABLE `product_options` (
  `id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_options`
--

INSERT INTO `product_options` (`id`, `product_id`, `title`) VALUES
(1, 1, 'Size'),
(2, 1, 'Color'),
(3, 2, 'Size'),
(10, 8, 'Size'),
(11, 8, 'Color'),
(12, 10, 'Size'),
(13, 10, 'Color');

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

--
-- Table structure for table `product_variants`
--

CREATE TABLE `product_variants` (
  `id` int(11) NOT NULL,
  `option_id` int(11) DEFAULT NULL,
  `variant` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_variants`
--

INSERT INTO `product_variants` (`id`, `option_id`, `variant`) VALUES
(1, 1, 'S'),
(2, 1, 'M'),
(3, 1, 'L'),
(4, 2, 'Blue'),
(5, 2, 'Green'),
(6, 2, 'Black'),
(7, 3, '5 ml'),
(8, 3, '10 ml'),
(9, 3, '30 ml'),
(10, 3, 'all bottle'),
(27, 10, 'S'),
(28, 10, 'M'),
(29, 10, 'L'),
(30, 11, 'White'),
(31, 11, 'Black'),
(32, 12, 'S'),
(33, 12, 'M'),
(34, 12, 'L'),
(35, 13, 'White'),
(36, 13, 'Black');

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

--
-- Table structure for table `variant_combinations`
--

CREATE TABLE `variant_combinations` (
  `id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `stock` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `variant_combinations`
--

INSERT INTO `variant_combinations` (`id`, `product_id`, `price`, `stock`) VALUES
(1, 1, 199.00, 10),
(2, 1, 150.00, 10),
(3, 1, 130.00, 10),
(4, 1, 120.00, 10),
(5, 1, 110.00, 10),
(6, 1, 160.00, 10),
(7, 1, 170.00, 10),
(8, 1, 180.00, 10),
(9, 1, 100.00, 10),
(10, 2, 120.00, 10),
(11, 2, 199.00, 10),
(12, 2, 300.00, 10),
(13, 2, 1200.00, 10),
(32, 8, 199.00, 10),
(33, 8, 199.00, 10),
(34, 8, 199.00, 10),
(35, 8, 199.00, 10),
(36, 8, 199.00, 10),
(37, 8, 199.00, 10),
(38, 10, 199.00, 10),
(39, 10, 199.00, 10),
(40, 10, 199.00, 10),
(41, 10, 199.00, 10),
(42, 10, 199.00, 10),
(43, 10, 199.00, 10);

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

--
-- Table structure for table `visitors`
--

CREATE TABLE `visitors` (
  `id` int(11) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `visitors`
--

INSERT INTO `visitors` (`id`, `ip_address`, `timestamp`) VALUES
(1, '::1', 1719533629);

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `combination_options`
--
ALTER TABLE `combination_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `combination_id` (`combination_id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

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

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `order_status_changes`
--
ALTER TABLE `order_status_changes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `changed_by` (`changed_by`);

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

--
-- Indexes for table `product_categories`
--
ALTER TABLE `product_categories`
  ADD PRIMARY KEY (`product_id`,`category_id`),
  ADD KEY `category_id` (`category_id`);

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

--
-- Indexes for table `product_options`
--
ALTER TABLE `product_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `product_variants`
--
ALTER TABLE `product_variants`
  ADD PRIMARY KEY (`id`),
  ADD KEY `option_id` (`option_id`);

--
-- Indexes for table `variant_combinations`
--
ALTER TABLE `variant_combinations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `combination_options`
--
ALTER TABLE `combination_options`
  ADD CONSTRAINT `combination_options_ibfk_1` FOREIGN KEY (`combination_id`) REFERENCES `variant_combinations` (`id`);

--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
  ADD CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `order_items_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  ADD CONSTRAINT `order_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `order_status_changes`
--
ALTER TABLE `order_status_changes`
  ADD CONSTRAINT `order_status_changes_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  ADD CONSTRAINT `order_status_changes_ibfk_2` FOREIGN KEY (`changed_by`) REFERENCES `users` (`id`);

--
-- Constraints for table `product_categories`
--
ALTER TABLE `product_categories`
  ADD CONSTRAINT `product_categories_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  ADD CONSTRAINT `product_categories_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`);

--
-- Constraints for table `product_images`
--
ALTER TABLE `product_images`
  ADD CONSTRAINT `product_images_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `product_options`
--
ALTER TABLE `product_options`
  ADD CONSTRAINT `product_options_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `product_variants`
--
ALTER TABLE `product_variants`
  ADD CONSTRAINT `product_variants_ibfk_1` FOREIGN KEY (`option_id`) REFERENCES `product_options` (`id`);

--
-- Constraints for table `variant_combinations`
--
ALTER TABLE `variant_combinations`
  ADD CONSTRAINT `variant_combinations_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);
COMMIT;

