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

START TRANSACTION;



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

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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `categories` (`id`, `name`, `slug`) VALUES
(2, 'New Arrivals', ''),
(3, 'Boys', ''),
(4, 'Girls', '');

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

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

CREATE TABLE `order_items` (
  `id` int(11) NOT NULL,
  `order_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `unit_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `color` varchar(50) DEFAULT NULL,
  `size` varchar(50) DEFAULT 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`, `quantity`, `unit_price`, `color`, `size`) VALUES
(3, 3, 187, 2, 1200.00, 'White', '12-18Months');

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

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

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `subcategory_id` int(11) DEFAULT NULL,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `barcode` varchar(100) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `sale_end` datetime DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `featured` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `products` (`id`, `name`, `slug`, `description`, `price`, `category_id`, `subcategory_id`, `sale_price`, `barcode`, `image`, `sale_end`, `created_at`, `status`, `featured`) VALUES
(147, 'Kids 3 piece Suit - Mini Charm', 'kids-3-piece-suit-mini-charm', 'Stylish 3-piece baby outfit featuring a white shirt with attached vest, matching blue bow tie, cozy blue pants, and a plaid cap. \r\nPerfect for special occasions or everyday charm.\r\n', 2100.00, 3, 2, 1499.00, 'BWL-8433', '0.1.jpeg', NULL, '2025-08-11 15:39:10', 1, 0),
(148, 'Full Sleeves 3 Piece Suit - Mini Charm', 'full-sleeves-3-piece-suit-mini-charm', 'Adorable 3-piece baby outfit set including a beige blazer-style jacket, printed white t-shirt with a cute bow tie design, and matching beige pants.\r\n Perfect for stylish everyday wear or special occasions.\r\n', 2100.00, 3, 2, 1499.00, 'BWL-8900', '0.2.jpeg', NULL, '2025-08-12 17:30:46', 1, 0),
(149, 'Kids 3-Piece Outfit Set - Mini Charm', 'kids-3-piece-outfit-set-mini-charm', 'Trendy 3-piece baby boy outfit featuring a grey printed blazer-style jacket with cute pocket designs, a white graphic t-shirt with a stylish bow tie and airplane print, and matching grey shorts.\r\n. Ideal for casual outings and playful days, offering both comfort and a smart look.\r\n', 2100.00, 3, 2, 1499.00, 'BWL-2566', '0.6.jpeg', NULL, '2025-08-12 17:33:09', 1, 0),
(150, 'Full Sleeve Romper - Mini Charm', 'full-sleeve-romper-mini-charm', 'Stylish black full-sleeve baby romper featuring a front button closure, cute bow tie print, and adorable detailing on the chest and legs. \r\nMade for comfort and easy wear, it\'s perfect for everyday use or special occasions.\r\n', 1800.00, 4, 3, 1200.00, 'BWL-8996', '0.5.jpeg', NULL, '2025-08-12 17:35:50', 1, 0),
(151, 'Baby Boy Winter Romper - Mini Charm', 'baby-boy-winter-romper-mini-charm', 'Stylish full-sleeve baby boy romper featuring a layered look with a grey top, red checkered collar and hem, and blue pants.\r\n Adorned with cute patches and a warm, cozy design, it’s perfect for cooler days and casual outings.\r\n', 2100.00, 3, 4, 1499.00, 'BWL-8905', '0.16.jpeg', NULL, '2025-08-12 17:39:35', 1, 0),
(152, 'Baby Boy Full Sleeve Romper - Mini Charm', 'baby-boy-full-sleeve-romper-mini-charm', 'Charming baby boy romper with a blue plaid shirt-style top and navy bottom, featuring printed suspenders and fun embroidery. \r\nDesigned for comfort and style, this one-piece outfit is perfect for casual outings and playful days.\r\n', 2100.00, 3, 5, 1499.00, 'BWL-8885', '0.15.jpeg', NULL, '2025-08-12 17:43:15', 1, 0),
(153, 'Baby Boy Dungaree Romper Set - Mini Charm', 'baby-boy-dungaree-romper-set-mini-charm', 'Cute baby boy dungaree-style romper in royal blue, featuring an adorable teddy bear print and a grey full-sleeve inner shirt with fun patterns. \r\nSoft, comfortable, and perfect for everyday wear or casual outings.\r\n', 2100.00, 3, 6, 1499.00, 'BWL-0578', '0.17.jpeg', NULL, '2025-08-12 17:48:54', 1, 0),
(154, 'Full Sleeves Casual Clothing Set - Mini Charm', 'full-sleeves-casual-clothing-set-mini-charm', 'Comfortable and stylish baby boy set featuring a mustard yellow full-sleeve top with a fun printed design and matching navy blue pants.\r\n Perfect for everyday wear, playdates, or casual outings.\r\n', 1700.00, 3, 7, 1299.00, 'BWL-8435', '0.8.jpeg', NULL, '2025-08-12 17:52:04', 1, 0),
(155, 'Full Sleeves Two-Piece Set - Mini Charm', 'full-sleeves-two-piece-set-mini-charm', 'Adorable baby boy set featuring a light grey long-sleeve top with subtle stripes and matching mustard yellow pants with playful printed details.\r\n Soft and comfortable, perfect for everyday wear or casual outings.\r\n', 1700.00, 3, 8, 1299.00, 'BWL-8434', '0.20.jpeg', NULL, '2025-08-12 18:40:41', 1, 0),
(156, 'Baby Boy Top and Pant Set - Mini Charm', 'baby-boy-top-and-pant-set-mini-charm', 'Comfortable and stylish baby boy outfit featuring a teal full-sleeve printed top paired with light grey pants with a matching graphic accent. \r\nIdeal for everyday wear, playdates, or casual outings.\r\n', 1700.00, 3, 11, 1299.00, 'BWL-8932', '0.7.jpeg', NULL, '2025-08-12 18:43:50', 1, 0),
(157, 'Baby Boy T-Shirt and Shorts Set - Mini Charm', 'baby-boy-t-shirt-and-shorts-set-mini-charm', 'Fun and comfy baby boy outfit featuring a green short-sleeve t-shirt with cute cartoon character prints, paired with black shorts with a matching bear graphic. \r\nPerfect for warm-weather play and casual days.\r\n', 1700.00, 3, 15, 1299.00, 'BWL-8865', '0.9.jpeg', NULL, '2025-08-12 18:46:46', 1, 0),
(158, 'Full Sleeves Top and Pant Set - Mini Charm', 'full-sleeves-top-and-pant-set-mini-charm', 'Cool and comfy baby boy outfit featuring a royal blue full-sleeve top with playful printed graphics, paired with matching blue pants with a fun design. \r\nPerfect for everyday wear, playdates, or casual outings.\r\n', 1700.00, 3, 11, 1299.00, 'BWL-8432', '0.10.jpeg', NULL, '2025-08-12 18:49:23', 1, 0),
(159, 'Baby Boy  T-Shirt and Shorts Set - Mini Charm', 'baby-boy-t-shirt-and-shorts-set-mini-charm', 'Bright and playful baby boy set featuring a white short-sleeve t-shirt with colorful printed text and graphics, paired with vibrant red shorts printed with “Positive.”\r\n Perfect for warm days, outings, and everyday fun.\r\n', 1700.00, 3, 15, 1299.00, 'BWL-8943', '0.14.jpeg', NULL, '2025-08-12 18:51:55', 1, 0),
(161, 'Baby Boy T-Shirt and Shorts Set', 'baby-boy-t-shirt-and-shorts-set', 'Trendy baby boy outfit featuring a peach-colored short-sleeve t-shirt with bold graphic print, paired with navy blue shorts accented by matching print detail. \r\nLightweight and comfy — ideal for summer wear and active play.\r\n', 1700.00, 3, 15, 1299.00, 'BWL-8946', '0.11.jpeg', NULL, '2025-08-12 18:56:45', 1, 0),
(162, 'Top and Pant Set - Mini Charm', 'top-and-pant-set-mini-charm', 'Adorable baby boy outfit featuring a full-sleeve blue top with a cute teddy bear print, paired with cozy navy blue pants. Perfect for cooler weather, offering both warmth and style for everyday comfort.\r\n', 1700.00, 3, 11, 1299.00, 'BWL-8935', '0.12.jpeg', NULL, '2025-08-12 18:58:42', 1, 0),
(163, 'Kids T-Shirt and Shorts Set', 'kids-t-shirt-and-shorts-set', 'Simple and stylish baby boy set featuring a beige short-sleeve t-shirt with cute graphic print, paired with navy blue shorts. \r\nLight, breathable, and perfect for daily wear in warm weather.\r\n', 1700.00, 3, 15, 1299.00, 'BWL-84322', '0.13.jpeg', NULL, '2025-08-12 19:01:07', 1, 0),
(164, 'Baby Boy Romper with Cap - Mini Charm', 'baby-boy-romper-with-cap-mini-charm', 'Adorable baby boy romper in a white and blue color combination, featuring cute prints and a button-down front for easy changing.\r\n Comes with a matching blue cap to complete the look. Perfect for cozy, everyday wear with a touch of charm.\r\n', 2000.00, 3, 12, 1399.00, 'BWL-8938', '0.3.jpeg', NULL, '2025-08-12 19:03:27', 1, 0),
(166, 'Half-Sleeves Printed Shirt and Shorts Set - Mini Charm', 'half-sleeves-printed-shirt-and-shorts-set-mini-charm', 'Trendy baby boy set featuring a matching shirt and shorts with a stylish black and white abstract print. \r\nLightweight and comfortable, perfect for casual outings and warm weather days.\r\n', 1500.00, 3, 13, 799.00, 'BWL-8967', '1.11.jpeg', NULL, '2025-08-13 07:17:53', 1, 0),
(167, 'Baby Boy Half-Sleeves  Printed Shirt and Shorts Set - Mini Charm', 'baby-boy-half-sleeves-printed-shirt-and-shorts-set-mini-charm', 'Classic baby boy outfit featuring a dark green button-up shirt with contrasting yellow stitching and matching pants. \r\nComfortable and stylish, perfect for casual wear or special occasions.\r\n', 1500.00, 3, 13, 799.00, 'BWL-8945', '1.5.jpeg', NULL, '2025-08-13 07:21:00', 1, 0),
(168, ' Baby Boy Printed Shirt and Shorts Set - Mini Charm', 'baby-boy-printed-shirt-and-shorts-set-mini-charm', 'Vibrant baby boy set featuring a colorful printed shirt and matching shorts with an abstract floral pattern in shades of red, orange, and black. \r\nLightweight and perfect for fun, casual outings or summer days.\r\n', 1500.00, 3, 13, 799.00, 'BWL-8937', '1.9.jpeg', NULL, '2025-08-13 07:23:39', 1, 0),
(169, 'Baby Girl Half-Sleeves Top and Leggings Set - Mini Charm', 'baby-girl-half-sleeves-top-and-leggings-set-mini-charm', 'Cute baby girl outfit featuring a white top with colorful polka dots and charming embroidered details, paired with soft leggings.\\r\\n Comfortable and perfect for everyday wear or playtime.\\r\\n', 1700.00, 4, 14, 1299.00, 'BWL-8844', '1.6.1.jpeg', NULL, '2025-08-13 07:26:52', 1, 0),
(170, 'T-Shirt and Shorts Set - Mini Charm', 't-shirt-and-shorts-set-mini-charm', 'Comfortable baby boy outfit featuring an orange short-sleeve printed t-shirt paired with black shorts. \r\nMade from soft, breathable fabric—ideal for everyday summer wear.\r\n', 1700.00, 3, 15, 1299.00, 'BWL-0055', '1.12.jpeg', NULL, '2025-08-13 07:29:33', 1, 0),
(171, 'Stylish light green T-Shirt and Shorts Set - Mini Charm', 'stylish-light-green-t-shirt-and-shorts-set-mini-charm', 'Stylish light green short-sleeve t-shirt with cute graphics, paired with comfy navy blue shorts. \r\nPerfect for casual summer days, made from soft, breathable fabric for all-day comfort.\r\n', 1700.00, 3, 15, 1299.00, 'BWL-8936', '1.13.jpeg', NULL, '2025-08-13 07:34:28', 1, 0),
(172, 'Warm orange full-sleeve T-Shirt and Shorts Set - Mini Charm', 'warm-orange-full-sleeve-t-shirt-and-shorts-set-mini-charm', 'Warm orange full-sleeve t-shirt with an adorable teddy bear print, paired with navy blue shorts. Ideal for cooler weather, offering both style and comfort in soft, cozy fabric.\r\n', 1700.00, 3, 15, 1299.00, 'BWL-8476', '1.14.jpeg', NULL, '2025-08-13 07:37:13', 1, 0),
(173, 'Bright yellow short-sleeve T-Shirt and Shorts Set - Mini Charm', 'bright-yellow-short-sleeve-t-shirt-and-shorts-set-mini-charm', 'Bright yellow short-sleeve t-shirt featuring cute cartoon prints, paired with black shorts with a matching graphic. Lightweight and perfect for warm weather play and casual outings.\r\n', 1700.00, 3, 15, 1299.00, 'BWL-8955', '1.16.jpeg', NULL, '2025-08-13 07:40:10', 1, 0),
(174, 'Colorful baby boy T-Shirt and Shorts Set - Mini Charm', 'colorful-baby-boy-t-shirt-and-shorts-set-mini-charm', 'Colorful baby boy outfit featuring a white short-sleeve t-shirt with vibrant prints and matching red shorts with \"Positive\" text. \r\nComfortable and perfect for everyday summer wear and playtime.\r\n', 1700.00, 3, 15, 1299.00, 'BWL-2576', '1.15.jpeg', NULL, '2025-08-13 07:43:18', 1, 0),
(175, 'Vibrant red full-sleeve T-Shirt and Pant Set - Mini Charm', 'vibrant-red-full-sleeve-t-shirt-and-pant-set-mini-charm', 'Vibrant red full-sleeve t-shirt with playful prints paired with navy blue pants featuring a matching graphic. \r\nPerfect for casual wear, offering comfort and style for your little one.\r\n', 1700.00, 3, 15, 1299.00, 'BWL-8968', '1.17.jpeg', NULL, '2025-08-13 07:48:44', 1, 0),
(176, 'Cute baby girl Top and Leggings Set - Mini Charm', 'cute-baby-girl-top-and-leggings-set-mini-charm', 'Cute baby girl outfit featuring a white sleeveless top with a teddy bear print and matching  leggings. \r\nSoft, comfortable, and perfect for everyday wear or playtime.\r\n', 1700.00, 4, 14, 1299.00, 'BWL-2579', '1.20.1.jpeg', NULL, '2025-08-13 07:52:43', 1, 0),
(177, 'Sweet baby girl Top and Leggings Set - Mini Charm', 'sweet-baby-girl-top-and-leggings-set-mini-charm', 'Sweet baby girl outfit featuring a white sleeveless top with small, colorful prints and a matching peach-colored leggings set. \r\nComfortable and perfect for everyday wear or playtime.\r\n', 1700.00, 4, 14, 1299.00, 'BWL-8899', '1.7.1.jpeg', NULL, '2025-08-13 07:56:26', 1, 0),
(178, 'Soft pink short-sleeve T-Shirt and Shorts Set - Mini Charm', 'soft-pink-short-sleeve-t-shirt-and-shorts-set-mini-charm', 'Soft pink short-sleeve t-shirt with fun printed text paired with navy blue shorts featuring matching print accents. \r\nLightweight and comfortable, ideal for casual summer wear and playtime.\r\n', 2000.00, 3, 15, 1499.00, 'AWL-2564', '3.1.jpeg', NULL, '2025-08-13 08:00:42', 1, 0),
(179, 'Charming baby boy Top and Pant Set - Mini Charm', 'charming-baby-boy-top-and-pant-set-mini-charm', 'Charming baby boy outfit featuring a mustard yellow full-sleeve top with a playful print, paired with navy blue pants. \r\nSoft and cozy, perfect for everyday wear and casual outings.\r\n', 2000.00, 3, 11, 1499.00, 'AWL-2588', '4.1.jpeg', NULL, '2025-08-13 08:05:44', 1, 0),
(180, 'Lovely baby girl Dress and Leggings Set - Mini Charm', 'lovely-baby-girl-dress-and-leggings-set-mini-charm', 'Lovely baby girl outfit featuring a brown floral dress with a blue waistband and matching brown leggings. \r\nComfortable and stylish, perfect for casual wear or special occasions.\r\n', 3000.00, 4, 18, 1799.00, 'AWL-2545', '4.2.1.jpeg', NULL, '2025-08-13 08:09:02', 1, 0),
(181, 'Elegant baby girl  Traditional Dress Set - Mini Charm', 'elegant-baby-girl-traditional-dress-set-mini-charm', 'Elegant baby girl set featuring a beige long-sleeve top with matching skirt and dupatta. Soft fabric and classic design make it perfect for special occasions and festive celebrations.\r\n', 3000.00, 4, 19, 1799.00, 'AWL-2547', '3.4.0.jpeg', NULL, '2025-08-13 08:11:23', 1, 0),
(182, 'Cool baby boy T-Shirt and Shorts Set - Mini Charm', 'cool-baby-boy-t-shirt-and-shorts-set-mini-charm', 'Cool baby boy outfit featuring a light blue short-sleeve t-shirt with a graphic print, paired with navy blue shorts.\r\n Soft and breathable, perfect for warm weather and casual play.\r\n', 2000.00, 3, 15, 1499.00, 'AWL-25668', '3.2.jpeg', NULL, '2025-08-13 08:27:01', 1, 0),
(183, 'Stylish green short-sleeve T-Shirt and Shorts Set - Mini Charm', 'stylish-green-short-sleeve-t-shirt-and-shorts-set-mini-charm', 'Stylish green short-sleeve t-shirt with cool graphic print paired with matching green shorts. Lightweight and comfy, perfect for playful summer days and casual outings.', 2000.00, 3, 15, 1499.00, 'AWL-25432', '3.3.jpeg', NULL, '2025-08-13 08:29:07', 1, 0);

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

--
-- Table structure for table `product_colors`
--

CREATE TABLE `product_colors` (
  `id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `color` varchar(50) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_colors`
--

INSERT INTO `product_colors` (`id`, `product_id`, `color`, `quantity`) VALUES
(16, 150, 'White', NULL),
(17, 150, 'Black', NULL),
(18, 153, 'Red', NULL),
(19, 153, 'Yellow', NULL),
(20, 153, 'Blue', NULL),
(21, 169, 'Mustard', NULL),
(22, 169, 'Baby Pink', NULL),
(23, 174, 'Brown', NULL),
(24, 174, 'Red', NULL),
(25, 175, 'Red', NULL),
(26, 175, 'Blue', NULL),
(27, 176, 'Blue', NULL),
(28, 176, 'Brown', NULL),
(29, 176, 'Yellow', NULL),
(30, 177, 'Brown', NULL),
(31, 177, 'Pink', NULL),
(32, 177, 'Green', NULL);

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

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

CREATE TABLE `product_images` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `image` 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`) VALUES
(89, 147, '0.1.jpeg'),
(90, 147, '0.1.jpeg'),
(91, 148, '0.2.jpeg'),
(92, 148, '0.2.jpeg'),
(93, 149, '0.6.jpeg'),
(94, 149, '0.6.jpeg'),
(95, 150, '0.5.jpeg'),
(96, 150, '0.4.jpeg'),
(97, 151, '0.16.jpeg'),
(98, 151, '0.16.jpeg'),
(99, 152, '0.15.jpeg'),
(100, 152, '0.15.jpeg'),
(101, 153, '0.17.jpeg'),
(102, 153, '0.18.jpeg'),
(103, 153, '0.19.jpeg'),
(104, 154, '0.8.jpeg'),
(105, 154, '0.8.jpeg'),
(106, 155, '0.20.jpeg'),
(107, 155, '0.20.jpeg'),
(108, 156, '0.7.jpeg'),
(109, 156, '0.7.jpeg'),
(110, 157, '0.9.jpeg'),
(111, 157, '0.9.jpeg'),
(112, 158, '0.10.jpeg'),
(113, 158, '0.10.jpeg'),
(114, 159, '0.14.jpeg'),
(115, 159, '0.14.jpeg'),
(116, 161, '0.11.jpeg'),
(117, 161, '0.11.jpeg'),
(118, 162, '0.12.jpeg'),
(119, 162, '0.12.jpeg'),
(120, 163, '0.13.jpeg'),
(121, 163, '0.13.jpeg'),
(122, 164, '0.3.jpeg'),
(123, 164, '0.3.jpeg'),
(124, 166, '1.11.jpeg'),
(125, 166, '1.11.jpeg'),
(126, 167, '1.5.jpeg'),
(127, 167, '1.5.jpeg'),
(128, 168, '1.9.jpeg'),
(129, 168, '1.9.jpeg'),
(130, 169, '1.6.1.jpeg'),
(131, 169, '1.6.2.jpeg'),
(132, 170, '1.12.jpeg'),
(133, 170, '1.12.jpeg'),
(134, 171, '1.13.jpeg'),
(135, 171, '1.13.jpeg'),
(136, 172, '1.14.jpeg'),
(137, 172, '1.14.jpeg'),
(138, 173, '1.16.jpeg'),
(139, 173, '1.16.jpeg'),
(140, 174, '1.15.jpeg'),
(141, 174, '1.18.jpeg'),
(142, 175, '1.17.jpeg'),
(143, 175, '1.19.jpeg'),
(144, 176, '1.20.1.jpeg'),
(145, 176, '1.20.2.jpeg'),
(146, 176, '1.20.3.jpeg'),
(147, 177, '1.7.1.jpeg'),
(148, 177, '1.7.2.jpeg'),
(149, 177, '1.7.3.jpeg'),
(150, 178, '3.1.jpeg'),
(151, 178, '3.1.jpeg'),
(152, 179, '4.1.jpeg'),
(153, 179, '4.1.jpeg'),
(154, 180, '4.2.1.jpeg'),
(155, 180, '4.2.2.jpeg'),
(156, 180, '4.2.3.jpeg'),
(157, 181, '3.4.0.jpeg'),
(158, 181, '3.4.1.jpeg'),
(159, 182, '3.2.jpeg'),
(160, 182, '3.2.jpeg'),
(161, 183, '3.3.jpeg'),
(162, 183, '3.3.jpeg');

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

--
-- Table structure for table `product_sizes`
--

CREATE TABLE `product_sizes` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `size` varchar(20) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_sizes`
--

INSERT INTO `product_sizes` (`id`, `product_id`, `size`, `quantity`) VALUES
(169, 147, 'Newborn (0 Months)', 10),
(170, 147, '0–3 Months', 10),
(171, 147, '3–6 Months', 10),
(172, 147, '6–8 Months', 10),
(173, 148, 'Newborn (0 Months)', 10),
(174, 148, '0-3 Months', 10),
(175, 148, '3-6Months', 10),
(176, 148, '6-8Months', 10),
(177, 149, 'Newborn (0 Months)', 10),
(178, 149, '0-3Months', 10),
(179, 149, '3-6Months', 10),
(180, 149, '6-8Months', 10),
(181, 150, 'Newborn (0 Months)', 10),
(182, 150, '0-3Months', 10),
(183, 150, '3-6Months', 10),
(184, 150, '6-8Months', 10),
(185, 151, 'Newborn (0 Months)', 10),
(186, 151, '0-3Months', 10),
(187, 151, '3-6Months', 10),
(188, 151, '6-8Months', 10),
(189, 152, 'Newborn (0 Months)', 10),
(190, 152, '0-3Months', 10),
(191, 152, '3-6Months', 10),
(192, 152, '6-8Months', 10),
(193, 153, 'Newborn (0 Months)', 10),
(194, 153, '0-3Months', 10),
(195, 153, '3-6Months', 10),
(196, 153, '6-8Months', 10),
(197, 154, 'Newborn (0 Months)', 10),
(198, 154, '0-3Months', 10),
(199, 154, '3-6Months', 10),
(200, 154, '6-8Months', 10),
(201, 155, 'Newborn (0 Months)', 10),
(202, 155, '0-3Months', 10),
(203, 155, '3-6Months', 10),
(204, 155, '6-8Months', 10),
(205, 156, 'Newborn (0 Months)', 10),
(206, 156, '0-3Months', 10),
(207, 156, '3-6Months', 10),
(208, 156, '6-8Months', 10),
(209, 157, 'Newborn (0 Months)', 10),
(210, 157, '0-3Months', 10),
(211, 157, '3-6Months', 10),
(212, 157, '6-8Months', 10),
(213, 158, 'Newborn (0 Months)', 10),
(214, 158, '0-3Months', 10),
(215, 158, '3-6Months', 10),
(216, 158, '6-8Months', 10),
(217, 159, 'Newborn (0 Months)', 10),
(218, 159, '0-3Months', 10),
(219, 159, '3-6Months', 10),
(220, 159, '6-8Months', 10),
(221, 161, 'Newborn (0 Months)', 10),
(222, 161, '0-3Months', 10),
(223, 161, '3-6Months', 10),
(224, 161, '6-8Months', 10),
(225, 162, 'Newborn (0 Months)', 10),
(226, 162, '0-3Months', 10),
(227, 162, '3-6Months', 10),
(228, 162, '6-8Months', 10),
(229, 163, 'Newborn (0 Months)', 10),
(230, 163, '0-3Months', 10),
(231, 163, '3-6Months', 10),
(232, 163, '6-8Months', 10),
(233, 164, 'Newborn (0 Months)', 10),
(234, 164, '0-3Months', 10),
(235, 164, '3-6Months', 10),
(236, 164, '6-8Months', 10),
(237, 166, '8–12 Months', 10),
(238, 166, '12–18 Months', 10),
(239, 166, '18–24 Months (2 Year', 10),
(240, 167, '8–12 Months', 10),
(241, 167, '12–18 Months', 10),
(242, 167, '18–24 Months (2 Year', 10),
(243, 168, '8–12 Months', 10),
(244, 168, '12–18 Months', 10),
(245, 168, '18–24 Months (2 Year', 10),
(249, 170, '8–12 Months', 10),
(250, 170, '12–18 Months', 10),
(251, 170, '18–24 Months (2 Year', 10),
(252, 171, '8–12 Months', 10),
(253, 171, '12-18Months', 10),
(254, 171, '18–24 Months (2 Year', 10),
(255, 172, '8–12 Months', 10),
(256, 172, '12-18Months', 10),
(257, 172, '18–24 Months (2 Year', 10),
(258, 173, '8–12 Months', 10),
(259, 173, '12-18Months', 10),
(260, 173, '18–24 Months (2 Year', 10),
(261, 174, '8–12 Months', 10),
(262, 174, '12-18Months', 10),
(263, 174, '18–24 Months (2 Year', 10),
(264, 169, '12–18 Months', 10),
(265, 169, '18–24 Months (2 Year', 10),
(266, 169, '8–12 Months', 10),
(267, 175, '8–12 Months', 10),
(268, 175, '12-18Months', 10),
(269, 175, '18–24 Months (2 Year', 10),
(270, 176, '8–12 Months', 10),
(271, 176, '12-18Months', 10),
(272, 176, '18–24 Months (2 Year', 10),
(273, 177, '8–12 Months', 10),
(274, 177, '12-18Months', 10),
(275, 177, '18–24 Months (2 Year', 10),
(276, 178, '2–3 Years', 10),
(277, 178, '3–4 Years', 10),
(278, 178, '4–5 Years', 10),
(279, 179, '2–3 Years', 10),
(280, 179, '3–4 Years', 10),
(281, 179, '4–5 Years', 10),
(282, 180, '2–3 Years', 10),
(283, 180, '3–4 Years', 10),
(284, 180, '4–5 Years', 10),
(285, 181, '2–3 Years', 10),
(286, 181, '3–4 Years', 10),
(287, 181, '4–5 Years', 10),
(288, 182, '2–3 Years', 10),
(289, 182, '3-4 Years', 10),
(290, 182, '4-5 Years', 10),
(318, 183, '2–3 Years', 10),
(319, 183, '3-4Years', 10),
(320, 183, '4-5Years', 10);

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `user_name` varchar(100) NOT NULL,
  `rating` int(11) NOT NULL CHECK (`rating` between 1 and 5),
  `comment` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` (`id`, `product_id`, `user_name`, `rating`, `comment`, `created_at`) VALUES
(10, 187, 'wahab', 5, 'excellent product', '2025-08-13 03:36:48');

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

--
-- Table structure for table `subcategories`
--

CREATE TABLE `subcategories` (
  `id` int(11) NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subcategories`
--

INSERT INTO `subcategories` (`id`, `category_id`, `name`) VALUES
(1, 4, '3 Piece Suit'),
(2, 3, '3-Piece Outfit Set'),
(3, 4, 'Full Sleeve Romper'),
(4, 3, 'Winter Romper'),
(5, 3, 'Full Sleeve Romper'),
(6, 3, 'Dungaree Romper Set'),
(7, 3, 'Casual Clothing Set'),
(8, 3, 'Two-Piece Set'),
(11, 3, 'Top and Pant Set'),
(12, 3, 'Romper with Cap'),
(13, 3, ' Printed Shirt and Shorts Set'),
(14, 4, 'Top and Leggings Set'),
(15, 3, 'T-Shirt and Shorts Set'),
(16, 4, 'T-Shirt and Shorts Set'),
(18, 4, 'Dress and Leggings Set'),
(19, 4, 'Traditional Dress Set');

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  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 `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `barcode` (`barcode`),
  ADD KEY `category_id` (`category_id`),
  ADD KEY `subcategory_id` (`subcategory_id`);

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

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

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

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

--
-- Indexes for table `subcategories`
--
ALTER TABLE `subcategories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_id` (`category_id`);

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  ADD CONSTRAINT `products_ibfk_2` FOREIGN KEY (`subcategory_id`) REFERENCES `subcategories` (`id`);

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

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

--
-- Constraints for table `subcategories`
--
ALTER TABLE `subcategories`
  ADD CONSTRAINT `subcategories_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`);
COMMIT;

