-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 30, 2026 at 01:52 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.0.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `rivisha`
--

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

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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(255) DEFAULT '',
  `icon` varchar(10) DEFAULT '?',
  `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`, `name`, `description`, `icon`, `created_at`) VALUES
(1, 'Bandhani', 'Bandhani', '🌿', '2026-04-07 14:16:59'),
(2, 'Haldi', 'Haldi', '🌿', '2026-04-07 14:16:59'),
(3, 'Tiger', 'Tiger', '🌿', '2026-04-07 14:16:59'),
(4, 'Flower', 'Flower', '🌿', '2026-04-07 14:16:59'),
(5, 'Coffee', 'Coffee', '🌿', '2026-04-07 14:16:59'),
(6, 'Chameli', 'Chameli', '🌿', '2026-04-07 14:16:59');

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

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

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `image` text NOT 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 `products`
--

INSERT INTO `products` (`id`, `category_id`, `name`, `color`, `image`, `created_at`, `updated_at`) VALUES
(3, 1, 'White-Red Bandhani', 'White-Red', 'kurti-red-dupatta-for-women.jpg', '2026-03-24 16:10:29', '2026-04-07 14:17:37'),
(4, 1, 'Yellow-Red Bandhani', 'Yellow-Red', '2.png', '2026-03-24 16:10:29', '2026-04-07 14:17:41'),
(5, 2, 'Haldi-Yellow', 'Haldi-Yellow', 'Red-kurti-with-duppta.PNG', '2026-03-30 08:41:28', '2026-04-07 14:17:49'),
(6, 2, 'Haldi-White', 'Haldi-White', 'haldi-white.png', '2026-03-30 08:43:22', '2026-04-07 14:17:54'),
(7, 2, 'Halid-Morpich', 'Halid-Morpich', 'RAMA.png', '2026-03-30 08:48:48', '2026-04-07 14:18:12'),
(8, 2, 'Haldi-baigani', 'Haldi-baigani', 'baigani.png', '2026-03-30 08:52:09', '2026-04-07 14:18:23'),
(9, 2, 'Halid-Yellow-Green', 'Halid-Yellow-Green', 'YELLOW-GREEN.jpeg', '2026-03-30 08:58:05', '2026-04-07 14:18:56'),
(10, 2, 'Halid-Fanta', 'Halid-Fanta', 'HALDI-FANTA.png', '2026-03-30 09:02:26', '2026-04-07 14:18:19'),
(11, 2, 'Haldi-Green', 'Haldi-Green', 'HALDI-GREEN.jpeg', '2026-03-30 09:06:50', '2026-04-07 14:18:53'),
(12, 2, 'Haldi-Yellow-Blue', 'Haldi-Yellow-Blue', 'YELLOW-BLUE.jpeg', '2026-03-30 09:09:31', '2026-04-07 14:17:57'),
(13, 2, 'Haldi-Black', 'Haldi-Black', 'HALID-BLACK.jpeg', '2026-03-30 09:12:17', '2026-04-07 14:18:16'),
(14, 3, 'Tiger-White-Blue', 'Tiger-White-Blue', 'white-blue-pant-set.jpg', '2026-03-30 09:20:50', '2026-04-07 14:18:08'),
(15, 3, 'Tiger-White-Rani', 'Tiger-White-Rani', 'tIGER-WHITE-RANI.png', '2026-03-30 09:23:45', '2026-04-07 14:18:27'),
(16, 3, 'Tiger-Green', 'Tiger-Green', 'green-kurti-set.jpg', '2026-03-30 09:25:52', '2026-04-07 14:18:32'),
(17, 3, 'Tiger-Black', 'Tiger-Black', 'black-rani-kurti.jpg', '2026-03-30 09:27:57', '2026-04-07 14:18:49'),
(18, 3, 'Tiger-Yellow-Rani', 'Tiger-Yellow-Rani', 'TIGER-YELLOW.png', '2026-03-30 09:30:52', '2026-04-07 14:18:03'),
(19, 3, 'Tiger-Yellow-Blue', 'Tiger-Yellow-Blue', 'traditional-kurti.jpg', '2026-03-30 09:35:38', '2026-04-07 14:19:01'),
(20, 3, 'Tiger-Fanta', 'Tiger-Fanta', 'fanta-blue-pant-set-for-all-women.jpg', '2026-03-30 09:45:11', '2026-04-07 14:18:45'),
(21, 3, 'Tiger-Light-Purple', 'Tiger-Light-Purple', 'PURPLE-KURTI.png', '2026-03-30 09:48:37', '2026-04-07 14:18:40'),
(22, 3, 'Tiger-morpich', 'Tiger-morpich', 'morpich-rani.png', '2026-03-30 09:51:12', '2026-04-07 14:18:36'),
(23, 4, 'Flower', 'Flower', 'pista-dupatta.jpeg', '2026-03-31 12:59:40', '2026-04-07 14:19:07'),
(24, 6, 'chameli-purple', 'chameli-purple', 'chamli-purple.jpeg', '2026-03-31 13:58:35', '2026-04-07 16:38:21'),
(25, 6, 'Chameli-Marron', 'Chameli-Marron', 'chamli-marron.jpeg', '2026-03-31 14:03:10', '2026-04-07 16:38:17'),
(26, 5, 'Coffee', 'Coffee', 'COFFEE.PNG', '2026-03-31 14:05:20', '2026-04-07 16:37:52'),
(27, 3, 'Tiger_Pink', 'Tiger_Pink', 'pink.jpeg', '2026-04-03 05:51:32', '2026-04-07 14:19:14'),
(28, NULL, 'Tiger_Blue', 'Tiger_Blue', 'blue.jpeg', '2026-04-03 05:51:32', NULL);

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

--
-- Table structure for table `product_stock`
--

CREATE TABLE `product_stock` (
  `id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `size` varchar(10) DEFAULT NULL,
  `quantity` int(11) DEFAULT 0,
  `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_stock`
--

INSERT INTO `product_stock` (`id`, `product_id`, `size`, `quantity`, `created_at`, `updated_at`) VALUES
(7, 3, 'XXS', 0, '2026-03-24 16:42:03', '2026-03-31 13:51:20'),
(8, 4, 'XXS', 0, '2026-03-24 16:42:03', '2026-03-31 13:51:20'),
(11, 3, 'S', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(12, 4, 'S', 0, '2026-03-24 16:42:03', '2026-03-31 13:46:27'),
(15, 3, 'M', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(16, 4, 'M', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(19, 3, 'L', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(20, 4, 'L', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(23, 3, 'XL', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(24, 4, 'XL', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(27, 3, 'XXL', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(28, 4, 'XXL', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(31, 3, 'XXXL', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(32, 4, 'XXXL', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(35, 3, '4XL', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(36, 4, '4XL', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(39, 3, '5XL', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(40, 4, '5XL', 0, '2026-03-24 16:42:03', '2026-03-30 08:39:25'),
(64, 5, 'XXS', 0, '2026-03-30 08:44:26', '2026-04-05 06:03:55'),
(65, 5, 'S', 50, '2026-03-30 08:44:26', '2026-04-07 09:06:53'),
(66, 5, 'M', 127, '2026-03-30 08:44:40', '2026-04-07 13:53:45'),
(67, 5, 'L', 0, '2026-03-30 08:44:40', NULL),
(68, 5, 'XL', 0, '2026-03-30 08:45:09', '2026-04-04 04:11:08'),
(69, 5, 'XXL', 133, '2026-03-30 08:45:09', '2026-04-07 10:23:36'),
(70, 5, 'XXXL', 200, '2026-03-30 08:46:11', '2026-04-05 07:21:52'),
(71, 5, '4XL', 0, '2026-03-30 08:46:11', '2026-04-07 13:53:33'),
(72, 5, '5XL', 50, '2026-03-30 08:46:27', '2026-04-07 13:54:13'),
(73, 6, 'XXS', 100, '2026-03-30 08:46:27', '2026-04-07 10:23:57'),
(74, 6, 'S', 0, '2026-03-30 08:46:40', '2026-04-07 10:24:17'),
(75, 6, 'M', 150, '2026-03-30 08:46:40', '2026-04-07 10:00:25'),
(76, 6, 'L', 113, '2026-03-30 08:47:02', '2026-04-07 10:28:20'),
(77, 6, 'XL', 57, '2026-03-30 08:47:02', '2026-04-05 06:09:16'),
(78, 6, 'XXL', 0, '2026-03-30 08:47:27', NULL),
(79, 6, 'XXXL', 0, '2026-03-30 08:47:27', '2026-04-06 15:16:54'),
(80, 6, '4XL', 0, '2026-03-30 08:47:41', '2026-04-07 09:08:05'),
(81, 6, '5XL', 0, '2026-03-30 08:47:41', '2026-04-01 16:48:50'),
(82, 7, 'XXS', 0, '2026-03-30 08:49:04', NULL),
(83, 7, 'S', 0, '2026-03-30 08:49:04', NULL),
(84, 7, 'M', 0, '2026-03-30 08:49:17', NULL),
(85, 7, 'L', 0, '2026-03-30 08:49:17', NULL),
(86, 7, 'XL', 0, '2026-03-30 08:49:31', NULL),
(87, 7, 'XXL', 0, '2026-03-30 08:49:31', NULL),
(88, 7, 'XXXL', 0, '2026-03-30 08:49:44', NULL),
(89, 7, '4XL', 0, '2026-03-30 08:49:44', NULL),
(90, 7, '5XL', 0, '2026-03-30 08:49:53', NULL),
(91, 8, 'XXS', 0, '2026-03-30 08:52:31', NULL),
(92, 8, 'S', 0, '2026-03-30 08:52:31', NULL),
(93, 8, 'M', 0, '2026-03-30 08:52:44', NULL),
(94, 8, 'L', 0, '2026-03-30 08:52:44', NULL),
(95, 8, 'XL', 0, '2026-03-30 08:52:57', NULL),
(96, 8, 'XXL', 0, '2026-03-30 08:52:57', NULL),
(97, 8, 'XXXL', 0, '2026-03-30 08:56:35', NULL),
(98, 8, '4XL', 0, '2026-03-30 08:56:35', NULL),
(99, 8, '5XL', 0, '2026-03-30 08:56:43', NULL),
(100, 9, 'XXS', 0, '2026-03-30 08:58:35', NULL),
(101, 9, 'S', 0, '2026-03-30 08:58:35', NULL),
(102, 9, 'M', 0, '2026-03-30 08:58:56', NULL),
(103, 9, 'L', 0, '2026-03-30 08:58:56', NULL),
(104, 9, 'XL', 0, '2026-03-30 08:59:18', NULL),
(105, 9, 'XXL', 0, '2026-03-30 08:59:18', NULL),
(106, 9, 'XXXL', 0, '2026-03-30 08:59:45', NULL),
(107, 9, '4XL', 0, '2026-03-30 08:59:45', NULL),
(108, 9, '5XL', 0, '2026-03-30 09:00:48', NULL),
(109, 10, 'XXS', 0, '2026-03-30 09:04:45', NULL),
(110, 10, 'S', 100, '2026-03-30 09:04:45', '2026-04-06 12:31:44'),
(111, 10, 'M', 100, '2026-03-30 09:05:02', '2026-04-06 12:13:11'),
(112, 10, 'L', 153, '2026-03-30 09:05:02', '2026-04-07 07:15:32'),
(113, 10, 'XL', 100, '2026-03-30 09:05:17', '2026-04-07 05:01:59'),
(114, 10, 'XXL', 100, '2026-03-30 09:05:17', '2026-04-07 07:24:48'),
(115, 10, 'XXXL', 100, '2026-03-30 09:05:35', '2026-04-07 13:55:30'),
(116, 10, '4XL', 100, '2026-03-30 09:05:35', '2026-04-07 14:01:22'),
(117, 10, '5XL', 100, '2026-03-30 09:05:58', '2026-04-07 13:55:19'),
(118, 11, 'XXS', 0, '2026-03-30 09:07:11', NULL),
(119, 11, 'S', 0, '2026-03-30 09:07:11', NULL),
(120, 11, 'M', 50, '2026-03-30 09:07:28', '2026-04-06 04:35:45'),
(121, 11, 'L', 0, '2026-03-30 09:07:28', NULL),
(122, 11, 'XL', 0, '2026-03-30 09:07:44', NULL),
(123, 11, 'XXL', 0, '2026-03-30 09:07:44', NULL),
(124, 11, 'XXXL', 50, '2026-03-30 09:08:14', '2026-04-07 13:38:53'),
(125, 11, '4XL', 50, '2026-03-30 09:08:14', '2026-04-07 13:38:56'),
(126, 11, '5XL', 50, '2026-03-30 09:08:24', '2026-04-07 13:38:59'),
(127, 12, 'XXS', 0, '2026-03-30 09:09:48', NULL),
(128, 12, 'S', 0, '2026-03-30 09:09:48', NULL),
(129, 12, 'M', 0, '2026-03-30 09:10:42', NULL),
(130, 12, 'L', 0, '2026-03-30 09:10:42', NULL),
(131, 12, 'XL', 0, '2026-03-30 09:10:55', NULL),
(132, 12, 'XXL', 0, '2026-03-30 09:10:55', NULL),
(133, 12, 'XXXL', 0, '2026-03-30 09:11:14', NULL),
(134, 12, '4XL', 0, '2026-03-30 09:11:14', NULL),
(135, 12, '5XL', 0, '2026-03-30 09:11:24', NULL),
(136, 13, 'XXS', 0, '2026-03-30 09:12:35', NULL),
(137, 13, 'S', 0, '2026-03-30 09:12:35', '2026-04-05 05:51:24'),
(138, 13, 'M', 62, '2026-03-30 09:12:46', '2026-04-04 05:40:16'),
(139, 13, 'L', 0, '2026-03-30 09:12:46', '2026-04-07 13:48:32'),
(140, 13, 'XL', 0, '2026-03-30 09:12:59', NULL),
(141, 13, 'XXL', 0, '2026-03-30 09:12:59', '2026-04-06 15:18:49'),
(142, 13, 'XXXL', 0, '2026-03-30 09:13:12', '2026-04-06 06:56:31'),
(143, 13, '4XL', 92, '2026-03-30 09:13:12', '2026-04-05 04:17:51'),
(144, 13, '5XL', 0, '2026-03-30 09:13:20', NULL),
(145, 14, 'XXS', 0, '2026-03-30 09:21:11', '2026-04-03 17:22:08'),
(146, 14, 'S', 0, '2026-03-30 09:21:11', '2026-04-06 04:18:46'),
(147, 14, 'M', 200, '2026-03-30 09:21:44', '2026-04-07 13:43:37'),
(148, 14, 'L', 0, '2026-03-30 09:21:44', '2026-04-05 09:18:31'),
(149, 14, 'XL', 50, '2026-03-30 09:22:23', '2026-04-07 13:43:45'),
(150, 14, 'XXL', 200, '2026-03-30 09:22:23', '2026-04-07 13:43:53'),
(151, 14, 'XXXL', 50, '2026-03-30 09:22:42', '2026-04-04 13:11:20'),
(152, 14, '4XL', 0, '2026-03-30 09:22:42', '2026-04-05 06:08:04'),
(153, 14, '5XL', 0, '2026-03-30 09:22:51', '2026-04-04 12:55:12'),
(154, 15, 'XXS', 0, '2026-03-30 09:24:09', '2026-04-05 11:23:57'),
(155, 15, 'S', 0, '2026-03-30 09:24:09', '2026-04-04 17:10:43'),
(156, 15, 'M', 200, '2026-03-30 09:24:23', '2026-04-07 13:43:09'),
(157, 15, 'L', 200, '2026-03-30 09:24:23', '2026-04-07 13:43:16'),
(158, 15, 'XL', 200, '2026-03-30 09:24:42', '2026-04-07 13:41:56'),
(159, 15, 'XXL', 250, '2026-03-30 09:24:42', '2026-04-07 13:42:10'),
(160, 15, 'XXXL', 0, '2026-03-30 09:24:59', '2026-04-07 13:41:19'),
(161, 15, '4XL', 0, '2026-03-30 09:24:59', '2026-04-04 17:26:22'),
(162, 15, '5XL', 100, '2026-03-30 09:25:08', '2026-04-07 10:23:01'),
(163, 16, 'XXS', 0, '2026-03-30 09:26:09', NULL),
(164, 16, 'S', 0, '2026-03-30 09:26:09', NULL),
(165, 16, 'M', 46, '2026-03-30 09:26:23', '2026-04-07 04:24:43'),
(166, 16, 'L', 46, '2026-03-30 09:26:23', '2026-04-07 13:38:05'),
(167, 16, 'XL', 46, '2026-03-30 09:26:38', '2026-04-07 13:38:09'),
(168, 16, 'XXL', 46, '2026-03-30 09:26:38', '2026-04-07 04:24:46'),
(169, 16, 'XXXL', 50, '2026-03-30 09:26:53', '2026-04-07 07:16:05'),
(170, 16, '4XL', 50, '2026-03-30 09:26:53', '2026-04-07 07:16:08'),
(171, 16, '5XL', 50, '2026-03-30 09:27:03', '2026-04-07 07:16:10'),
(172, 17, 'XXS', 0, '2026-03-30 09:28:13', NULL),
(173, 17, 'S', 0, '2026-03-30 09:28:13', NULL),
(174, 17, 'M', 0, '2026-03-30 09:28:28', NULL),
(175, 17, 'L', 0, '2026-03-30 09:28:28', NULL),
(176, 17, 'XL', 0, '2026-03-30 09:28:44', NULL),
(177, 17, 'XXL', 0, '2026-03-30 09:28:44', NULL),
(178, 17, 'XXXL', 0, '2026-03-30 09:29:03', NULL),
(179, 17, '4XL', 0, '2026-03-30 09:29:03', NULL),
(180, 17, '5XL', 0, '2026-03-30 09:29:14', NULL),
(181, 18, 'XXS', 0, '2026-03-30 09:31:50', NULL),
(182, 18, 'S', 0, '2026-03-30 09:31:50', NULL),
(183, 18, 'M', 0, '2026-03-30 09:32:12', NULL),
(184, 18, 'L', 0, '2026-03-30 09:32:12', NULL),
(185, 18, 'XL', 0, '2026-03-30 09:32:57', NULL),
(186, 18, 'XXL', 0, '2026-03-30 09:32:57', NULL),
(187, 18, 'XXXL', 0, '2026-03-30 09:33:16', NULL),
(188, 18, '4XL', 0, '2026-03-30 09:33:16', NULL),
(189, 18, '5XL', 0, '2026-03-30 09:33:27', NULL),
(190, 19, 'XXS', 0, '2026-03-30 09:36:00', '2026-03-30 10:56:57'),
(191, 19, 'S', 0, '2026-03-30 09:36:00', NULL),
(192, 19, 'M', 0, '2026-03-30 09:36:19', NULL),
(193, 19, 'L', 0, '2026-03-30 09:36:19', NULL),
(194, 19, 'XL', 0, '2026-03-30 09:36:48', NULL),
(195, 19, 'XXL', 0, '2026-03-30 09:36:48', NULL),
(196, 19, 'XXXL', 0, '2026-03-30 09:37:16', NULL),
(197, 19, '4XL', 0, '2026-03-30 09:37:16', NULL),
(198, 19, '5XL', 0, '2026-03-30 09:37:37', NULL),
(199, 20, 'XXS', 0, '2026-03-30 09:45:30', NULL),
(200, 20, 'S', 0, '2026-03-30 09:45:30', NULL),
(201, 20, 'M', 46, '2026-03-30 09:45:44', '2026-04-07 05:03:06'),
(202, 20, 'L', 46, '2026-03-30 09:45:44', '2026-04-07 05:03:06'),
(203, 20, 'XL', 46, '2026-03-30 09:46:03', '2026-04-07 05:03:09'),
(204, 20, 'XXL', 46, '2026-03-30 09:46:03', '2026-04-07 07:23:13'),
(205, 20, 'XXXL', 50, '2026-03-30 09:46:44', '2026-04-07 06:55:12'),
(206, 20, '4XL', 50, '2026-03-30 09:46:44', '2026-04-07 06:55:19'),
(207, 20, '5XL', 50, '2026-03-30 09:46:54', '2026-04-07 06:55:19'),
(208, 21, 'XXS', 0, '2026-03-30 09:48:52', NULL),
(209, 21, 'S', 0, '2026-03-30 09:48:52', NULL),
(210, 21, 'M', 0, '2026-03-30 09:49:11', NULL),
(211, 21, 'L', 0, '2026-03-30 09:49:11', NULL),
(212, 21, 'XL', 0, '2026-03-30 09:49:43', NULL),
(213, 21, 'XXL', 0, '2026-03-30 09:49:43', NULL),
(214, 21, 'XXXL', 0, '2026-03-30 09:50:13', NULL),
(215, 21, '4XL', 0, '2026-03-30 09:50:13', NULL),
(216, 21, '5XL', 0, '2026-03-30 09:50:20', NULL),
(217, 22, 'XXS', 0, '2026-03-30 09:51:32', NULL),
(218, 22, 'S', 0, '2026-03-30 09:51:32', NULL),
(219, 22, 'M', 0, '2026-03-30 09:51:47', NULL),
(220, 22, 'L', 0, '2026-03-30 09:51:47', NULL),
(221, 22, 'XL', 0, '2026-03-30 09:52:17', NULL),
(222, 22, 'XXL', 0, '2026-03-30 09:52:17', NULL),
(223, 22, 'XXXL', 0, '2026-03-30 09:52:34', NULL),
(224, 22, '4XL', 0, '2026-03-30 09:52:34', NULL),
(225, 22, '5XL', 0, '2026-03-30 09:52:54', NULL),
(226, 23, 'XXS', 0, '2026-03-31 13:00:11', NULL),
(227, 23, 'S', 0, '2026-03-31 13:00:11', '2026-04-04 06:11:42'),
(228, 23, 'M', 0, '2026-03-31 13:00:27', '2026-04-02 16:29:22'),
(229, 23, 'L', 0, '2026-03-31 13:00:27', '2026-04-04 06:11:47'),
(230, 23, 'XL', 0, '2026-03-31 13:00:41', NULL),
(231, 23, 'XXL', 0, '2026-03-31 13:00:41', NULL),
(232, 23, 'XXXL', 0, '2026-03-31 13:00:57', '2026-04-04 06:11:30'),
(233, 23, '4XL', 150, '2026-03-31 13:00:57', '2026-04-07 04:26:48'),
(234, 23, '5XL', 100, '2026-03-31 13:01:05', '2026-04-07 04:26:53'),
(235, 24, 'XXS', 0, '2026-03-31 13:58:49', NULL),
(236, 24, 'S', 0, '2026-03-31 13:58:49', NULL),
(237, 24, 'M', 0, '2026-03-31 13:59:02', NULL),
(238, 24, 'L', 0, '2026-03-31 13:59:02', NULL),
(239, 24, 'XL', 0, '2026-03-31 13:59:16', NULL),
(240, 24, 'XXL', 0, '2026-03-31 13:59:16', NULL),
(241, 24, 'XXXL', 0, '2026-03-31 14:02:07', NULL),
(242, 24, '4XL', 0, '2026-03-31 14:02:07', '2026-04-01 06:57:00'),
(243, 24, '5XL', 0, '2026-03-31 14:02:14', NULL),
(244, 25, 'XXS', 0, '2026-03-31 14:03:24', NULL),
(245, 25, 'S', 0, '2026-03-31 14:03:24', NULL),
(246, 25, 'M', 0, '2026-03-31 14:03:35', NULL),
(247, 25, 'L', 0, '2026-03-31 14:03:35', NULL),
(248, 25, 'XL', 0, '2026-03-31 14:03:47', NULL),
(249, 25, 'XXL', 0, '2026-03-31 14:03:47', NULL),
(250, 25, 'XXXL', 0, '2026-03-31 14:04:02', NULL),
(251, 25, '4XL', 0, '2026-03-31 14:04:02', NULL),
(252, 25, '5XL', 0, '2026-03-31 14:04:09', NULL),
(253, 26, 'XXS', 0, '2026-03-31 14:05:37', NULL),
(254, 26, 'S', 0, '2026-03-31 14:05:37', NULL),
(255, 26, 'M', 0, '2026-03-31 14:05:58', NULL),
(256, 26, 'L', 0, '2026-03-31 14:05:58', NULL),
(257, 26, 'XL', 0, '2026-03-31 14:06:16', NULL),
(258, 26, 'XXL', 0, '2026-03-31 14:06:16', NULL),
(259, 26, 'XXXL', 0, '2026-03-31 14:06:53', NULL),
(260, 26, '4XL', 0, '2026-03-31 14:06:53', NULL),
(261, 26, '5XL', 0, '2026-03-31 14:07:01', NULL),
(262, 23, '6XL', 0, '2026-04-01 09:34:16', '2026-04-04 06:21:43'),
(263, 26, '6XL', 0, '2026-04-01 09:34:16', NULL),
(264, 27, 'XXS', 0, '2026-04-03 05:54:48', NULL),
(265, 27, 'XXL', 0, '2026-04-03 05:54:48', NULL),
(266, 27, '4XL', 0, '2026-04-03 05:55:08', NULL),
(267, 28, 'XXS', 0, '2026-04-03 05:55:08', NULL),
(268, 28, 'XXL', 0, '2026-04-03 05:55:30', NULL),
(269, 28, '4XL', 0, '2026-04-03 05:55:30', NULL);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `mobile` varchar(15) NOT NULL,
  `role` enum('admin','user') DEFAULT 'user',
  `is_active` tinyint(1) DEFAULT 1,
  `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 `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `mobile`, `role`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Swati', 'swati@gmail.com', '9512345884', 'admin', 1, '2026-04-30 10:31:50', NULL);

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mobile` (`mobile`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `product_stock`
--
ALTER TABLE `product_stock`
  ADD CONSTRAINT `product_stock_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;