-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 03, 2026 at 08:43 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

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: `bharat_erp`
--

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

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

CREATE TABLE `categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `parent_id` int(10) UNSIGNED DEFAULT NULL,
  `name` varchar(120) NOT NULL,
  `slug` varchar(140) NOT NULL,
  `level` tinyint(3) UNSIGNED NOT NULL DEFAULT 1,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `categories` (`id`, `parent_id`, `name`, `slug`, `level`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Floor Tiles', 'floor-tiles', 1, 1, 1, '2026-02-03 07:40:32', '2026-02-03 07:40:32'),
(2, NULL, 'Wall Tiles', 'wall-tiles', 1, 1, 2, '2026-02-03 07:40:32', '2026-02-03 07:40:32'),
(3, NULL, 'Outdoor Tiles', 'outdoor-tiles', 1, 1, 3, '2026-02-03 07:40:32', '2026-02-03 07:40:32'),
(4, NULL, 'Special Tiles', 'special-tiles', 1, 1, 4, '2026-02-03 07:40:32', '2026-02-03 07:40:32'),
(5, NULL, 'Sanitary Ware', 'sanitary-ware', 1, 1, 5, '2026-02-03 07:40:32', '2026-02-03 07:40:32'),
(6, NULL, 'Bathware', 'bathware', 1, 1, 6, '2026-02-03 07:40:32', '2026-02-03 07:40:32'),
(7, NULL, 'Tanks', 'tanks', 1, 1, 7, '2026-02-03 07:40:32', '2026-02-03 07:40:32'),
(8, NULL, 'Chemical', 'chemical', 1, 1, 8, '2026-02-03 07:40:32', '2026-02-03 07:40:32'),
(9, NULL, 'Surface Care', 'surface-care', 1, 1, 9, '2026-02-03 07:40:32', '2026-02-03 07:40:32'),
(10, NULL, 'Plastic Water Tanks', 'plastic-water-tanks', 1, 1, 10, '2026-02-03 07:40:32', '2026-02-03 07:40:32'),
(11, 1, 'Vitrified Tiles', 'vitrified-tiles', 2, 1, 1, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(12, 1, 'Ceramic Floor Tiles', 'ceramic-floor-tiles', 2, 1, 2, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(13, 1, 'Wood Finish Tiles', 'wood-finish-tiles', 2, 1, 3, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(14, 1, 'Anti Skid Tiles', 'anti-skid-tiles', 2, 1, 4, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(21, 2, 'Bathroom Wall Tiles', 'bathroom-wall-tiles', 2, 1, 1, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(22, 2, 'Kitchen Wall Tiles', 'kitchen-wall-tiles', 2, 1, 2, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(23, 2, 'Designer Wall Tiles', 'designer-wall-tiles', 2, 1, 3, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(31, 3, 'Parking Tiles', 'parking-tiles', 2, 1, 1, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(32, 3, 'Terrace Tiles', 'terrace-tiles', 2, 1, 2, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(33, 3, 'Elevation Tiles', 'elevation-tiles', 2, 1, 3, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(41, 4, 'Large Format Tiles', 'large-format-tiles', 2, 1, 1, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(42, 4, '3D Tiles', '3d-tiles', 2, 1, 2, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(51, 5, 'Water Closets', 'water-closets', 2, 1, 1, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(52, 5, 'Wash Basins', 'wash-basins', 2, 1, 2, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(53, 5, 'Urinals', 'urinals', 2, 1, 3, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(61, 6, 'Faucets', 'faucets', 2, 1, 1, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(62, 6, 'Showers', 'showers', 2, 1, 2, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(63, 6, 'Bathroom Accessories', 'bathroom-accessories', 2, 1, 3, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(71, 7, 'Water Storage Tanks', 'water-storage-tanks', 2, 1, 1, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(81, 8, 'Tile Fixing', 'tile-fixing', 2, 1, 1, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(82, 8, 'Construction Chemicals', 'construction-chemicals', 2, 1, 2, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(83, 8, 'Waterproofing Chemicals', 'waterproofing-chemicals', 2, 1, 3, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(84, 8, 'Crack Fillers', 'crack-fillers', 2, 1, 4, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(91, 9, 'Tile Cleaners', 'tile-cleaners', 2, 1, 1, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(92, 9, 'Polishing Chemicals', 'polishing-chemicals', 2, 1, 2, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(101, 10, 'Overhead Tanks', 'overhead-tanks', 2, 1, 1, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(102, 10, 'Underground Tanks', 'underground-tanks', 2, 1, 2, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(103, 10, 'Cisterns', 'cisterns', 2, 1, 3, '2026-02-03 07:40:41', '2026-02-03 07:40:41'),
(111, 11, 'Polished Vitrified', 'polished-vitrified', 3, 1, 1, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(112, 11, 'Glazed Vitrified', 'glazed-vitrified', 3, 1, 2, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(113, 11, 'Double Charge', 'double-charge', 3, 1, 3, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(121, 12, 'Matte Finish', 'ceramic-matte', 3, 1, 1, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(122, 12, 'Glossy Finish', 'ceramic-glossy', 3, 1, 2, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(131, 13, 'Light Wood', 'light-wood', 3, 1, 1, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(132, 13, 'Dark Wood', 'dark-wood', 3, 1, 2, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(141, 14, 'Bathroom Anti Skid', 'bathroom-anti-skid', 3, 1, 1, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(142, 14, 'Outdoor Anti Skid', 'outdoor-anti-skid', 3, 1, 2, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(411, 41, '600x1200', '600x1200', 3, 1, 1, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(412, 41, '800x1600', '800x1600', 3, 1, 2, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(511, 51, 'One Piece WC', 'one-piece-wc', 3, 1, 1, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(512, 51, 'Two Piece WC', 'two-piece-wc', 3, 1, 2, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(513, 51, 'Wall Hung WC', 'wall-hung-wc', 3, 1, 3, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(521, 52, 'Table Top Basin', 'table-top-basin', 3, 1, 1, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(522, 52, 'Wall Hung Basin', 'wall-hung-basin', 3, 1, 2, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(523, 52, 'Pedestal Basin', 'pedestal-basin', 3, 1, 3, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(531, 53, 'Flat Back Urinals', 'flat-back-urinals', 3, 1, 1, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(532, 53, 'Corner Urinals', 'corner-urinals', 3, 1, 2, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(611, 61, 'Basin Taps', 'basin-taps', 3, 1, 1, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(612, 61, 'Wall Mixers', 'wall-mixers', 3, 1, 2, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(613, 61, 'Concealed Mixers', 'concealed-mixers', 3, 1, 3, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(621, 62, 'Overhead Showers', 'overhead-showers', 3, 1, 1, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(622, 62, 'Hand Showers', 'hand-showers', 3, 1, 2, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(623, 62, 'Shower Panels', 'shower-panels', 3, 1, 3, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(631, 63, 'Towel Rods', 'towel-rods', 3, 1, 1, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(632, 63, 'Soap Dispensers', 'soap-dispensers', 3, 1, 2, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(633, 63, 'Robe Hooks', 'robe-hooks', 3, 1, 3, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(811, 81, 'Tile Adhesives', 'tile-adhesives', 3, 1, 1, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(812, 81, 'Grouts', 'grouts', 3, 1, 2, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(1031, 103, 'Concealed Cisterns', 'concealed-cisterns', 3, 1, 1, '2026-02-03 07:40:47', '2026-02-03 07:40:47'),
(1032, 103, 'External Cisterns', 'external-cisterns', 3, 1, 2, '2026-02-03 07:40:47', '2026-02-03 07:40:47');

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

--
-- 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
(31, '2014_10_12_000000_create_users_table', 1),
(32, '2014_10_12_100000_create_password_reset_tokens_table', 2),
(33, '2019_08_19_000000_create_failed_jobs_table', 3),
(34, '2019_12_14_000001_create_personal_access_tokens_table', 4),
(35, '2025_12_03_052005_update_status_enum_in_request_slips_table', 5),
(36, '2025_12_03_053057_update_status_enum_in_request_slips_table', 6),
(37, '2025_12_01_065245_add_is_delete_to_users_table', 7),
(38, '2025_12_03_070133_create_supplier_inventories_table', 8),
(39, '2025_12_03_071627_create_supplier_inventories_table', 9),
(40, ' 2025_11_25_045134_create_roles_table', 9),
(41, '2025_11_25_045134_create_roles_table', 10),
(42, '2025_11_25_051317_create_menus_table', 10),
(45, '2025_11_25_051805_add_icon_to_menus_table', 11),
(46, '2025_11_25_054526_create_permissions_table', 10),
(47, '2025_11_25_054550_create_menu_permission_table', 10),
(48, '2025_11_25_063718_create_role_permission_table', 11),
(49, '2025_11_25_084005_create_units_table', 12),
(50, '2025_11_25_084009_create_inventories_table', 12),
(51, '2025_11_25_101142_create_products_table', 11),
(52, '2025_11_25_101415_create_product_items_table', 10),
(53, '2025_11_25_103056_create_projects_table', 11),
(54, '2025_11_25_103105_create_project_products_table', 11),
(55, '2025_11_26_102214_create_rs_request_slips_table', 11),
(56, '2025_11_27_055012_drop_code_from_products_table', 13),
(57, '2025_11_27_061752_drop_code_from_projects_table', 13),
(58, '2025_11_27_063508_create_request_slips_table', 11),
(59, '2025_11_27_063510_create_request_slip_items_table', 11),
(60, '2025_11_27_063511_create_request_slip_histories_table', 11),
(61, '2025_11_27_084151_increase_request_slips_status_length', 14),
(62, '2025_11_27_084211_update_request_slips_status_enum', 11),
(63, '2025_11_29_054234_add_rs_id_to_request_slips_table', 11),
(64, '2025_11_29_142122_add_workflow_columns_to_rs_request_slips_table', 11),
(65, '2025_11_29_142418_add_pending_fields_to_request_slip_items_table', 11),
(66, '2025_11_29_151548_update_action_column_in_request_slip_histories', 15),
(67, '2025_12_01_135700_create_notifications_table', 11),
(68, '2025_12_03_073211_add_image_to_users_table', 16),
(69, '2025_12_04_115928_create_departments_table', 16),
(70, '2025_12_12_044341_create_suppliers_table', 17),
(71, '2025_12_12_054646_create_suppliers_table', 18),
(72, '2025_12_12_055307_create_suppliers_table', 19),
(73, '2025_12_12_063230_categories', 20),
(74, '2025_12_12_121645_add_status_to_request_slip_histories', 20),
(75, '2025_12_18_125415_add_machine_id_to_requisition_slip_rows_table', 21);

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

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

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(255) NOT NULL,
  `notifiable_type` varchar(255) NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text NOT NULL,
  `read_at` timestamp NULL DEFAULT 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 `notifications`
--

INSERT INTO `notifications` (`id`, `type`, `notifiable_type`, `notifiable_id`, `data`, `read_at`, `created_at`, `updated_at`) VALUES
('0349fc54-1ba2-4491-a378-87e93647ce50', 'App\\Notifications\\RequestSlipCreated', 'App\\Models\\User', 2, '{\"module\":\"request_slip\",\"rs_id\":7,\"rs_code\":\"0001\",\"rs_name\":\"project a\",\"created_by\":\"ansh\",\"project_name\":\"project a\",\"message\":\"New Request Slip generated: project a\",\"url\":\"http:\\/\\/127.0.0.1:8000\\/request-slip\\/7\"}', NULL, '2025-12-01 04:00:32', '2025-12-01 04:00:32'),
('06f2fffb-8a6d-4ef2-ae91-69df308c5325', 'App\\Notifications\\RequestSlipCreated', 'App\\Models\\User', 2, '{\"module\":\"request_slip\",\"rs_id\":11,\"rs_code\":\"0005\",\"rs_name\":\"project a\",\"created_by\":\"ansh\",\"project_name\":\"project a\",\"message\":\"New Request Slip generated: project a\",\"url\":\"http:\\/\\/127.0.0.1:8000\\/request-slip\\/11\"}', NULL, '2025-12-02 04:24:46', '2025-12-02 04:24:46'),
('2940306b-7211-43fe-919c-b8a45a1604eb', 'App\\Notifications\\RequestSlipCreated', 'App\\Models\\User', 2, '{\"module\":\"request_slip\",\"rs_id\":12,\"rs_code\":\"0006\",\"rs_name\":\"project bita\",\"created_by\":\"ansh\",\"project_name\":\"project bita\",\"message\":\"New Request Slip generated: project bita\",\"url\":\"http:\\/\\/127.0.0.1:8000\\/request-slip\\/12\"}', NULL, '2025-12-02 05:23:38', '2025-12-02 05:23:38'),
('4da7b735-5837-405f-99c2-e3bc8935db55', 'App\\Notifications\\RequestSlipCreated', 'App\\Models\\User', 2, '{\"module\":\"request_slip\",\"rs_id\":15,\"rs_code\":\"0009\",\"rs_name\":\"project bita\",\"created_by\":\"ansh\",\"project_name\":\"project bita\",\"message\":\"New Request Slip generated: project bita\",\"url\":\"http:\\/\\/127.0.0.1:8000\\/request-slip\\/15\"}', NULL, '2025-12-02 23:35:52', '2025-12-02 23:35:52'),
('6a5981db-55be-407d-8861-5e170c218ee9', 'App\\Notifications\\RequestSlipCreated', 'App\\Models\\User', 2, '{\"module\":\"request_slip\",\"rs_id\":9,\"rs_code\":\"0003\",\"rs_name\":\"project bita\",\"created_by\":\"ansh\",\"project_name\":\"project bita\",\"message\":\"New Request Slip generated: project bita\",\"url\":\"http:\\/\\/127.0.0.1:8000\\/request-slip\\/9\"}', NULL, '2025-12-01 04:06:38', '2025-12-01 04:06:38'),
('72b6ba43-a259-4bed-9444-1efb3e819537', 'App\\Notifications\\RequestSlipCreated', 'App\\Models\\User', 2, '{\"module\":\"request_slip\",\"rs_id\":16,\"rs_code\":\"0010\",\"rs_name\":\"project bita\",\"created_by\":\"ansh\",\"project_name\":\"project bita\",\"message\":\"New Request Slip generated: project bita\",\"url\":\"http:\\/\\/127.0.0.1:8000\\/request-slip\\/16\"}', NULL, '2025-12-03 00:05:31', '2025-12-03 00:05:31'),
('78b4ee99-67aa-4bf2-8541-0ac273fb10d1', 'App\\Notifications\\RequestSlipCreated', 'App\\Models\\User', 2, '{\"module\":\"request_slip\",\"rs_id\":10,\"rs_code\":\"0004\",\"rs_name\":\"project a\",\"created_by\":\"ansh\",\"project_name\":\"project a\",\"message\":\"New Request Slip generated: project a\",\"url\":\"http:\\/\\/127.0.0.1:8000\\/request-slip\\/10\"}', NULL, '2025-12-01 04:10:05', '2025-12-01 04:10:05'),
('80a3e931-1e99-4494-b413-31bb6c2a1c8d', 'App\\Notifications\\RequestSlipCreated', 'App\\Models\\User', 2, '{\"module\":\"request_slip\",\"rs_id\":8,\"rs_code\":\"0002\",\"rs_name\":\"project bita\",\"created_by\":\"ansh\",\"project_name\":\"project bita\",\"message\":\"New Request Slip generated: project bita\",\"url\":\"http:\\/\\/127.0.0.1:8000\\/request-slip\\/8\"}', NULL, '2025-12-01 04:01:10', '2025-12-01 04:01:10'),
('866ac885-5b82-436b-a8c0-911e88082b1e', 'App\\Notifications\\RequestSlipCreated', 'App\\Models\\User', 2, '{\"module\":\"request_slip\",\"rs_id\":13,\"rs_code\":\"0007\",\"rs_name\":\"project a\",\"created_by\":\"ansh\",\"project_name\":\"project a\",\"message\":\"New Request Slip generated: project a\",\"url\":\"http:\\/\\/127.0.0.1:8000\\/request-slip\\/13\"}', NULL, '2025-12-02 23:16:16', '2025-12-02 23:16:16'),
('ac41acad-d91a-4646-afcd-4cc01a6a29a0', 'App\\Notifications\\RequestSlipCreated', 'App\\Models\\User', 2, '{\"module\":\"request_slip\",\"rs_id\":14,\"rs_code\":\"0008\",\"rs_name\":\"project a\",\"created_by\":\"ansh\",\"project_name\":\"project a\",\"message\":\"New Request Slip generated: project a\",\"url\":\"http:\\/\\/127.0.0.1:8000\\/request-slip\\/14\"}', NULL, '2025-12-02 23:16:17', '2025-12-02 23:16:17');

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT 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 `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT 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 `roles`
--

INSERT INTO `roles` (`id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Quantum Admin', NULL, '2025-11-25 00:38:21', '2025-12-26 16:02:17'),
(2, 'User (Store Owner)', NULL, '2025-11-25 01:24:00', '2025-12-26 16:02:04'),
(3, 'Shop', NULL, '2026-01-13 16:56:29', '2026-01-13 16:56:29');

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `status` date DEFAULT NULL,
  `date` date DEFAULT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT 0,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `role_id` bigint(20) UNSIGNED DEFAULT NULL,
  `country_code` varchar(10) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `store_id` int(50) DEFAULT NULL,
  `gender` enum('Male','Female') DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL COMMENT 'only uk city from drop down',
  `nationality` varchar(255) DEFAULT NULL,
  `ethnicity` varchar(255) DEFAULT NULL COMMENT 'Asian, African',
  `marital_status` varchar(255) DEFAULT NULL,
  `child` enum('Yes','No') NOT NULL,
  `child_count` decimal(10,8) DEFAULT NULL,
  `child_age_group` varchar(255) DEFAULT NULL,
  `height` decimal(10,8) DEFAULT NULL,
  `education` varchar(255) DEFAULT NULL,
  `profession` varchar(255) DEFAULT NULL,
  `income` varchar(255) DEFAULT NULL,
  `religion` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `status`, `date`, `is_delete`, `email_verified_at`, `password`, `role_id`, `country_code`, `mobile`, `remember_token`, `created_at`, `updated_at`, `image`, `store_id`, `gender`, `dob`, `city`, `nationality`, `ethnicity`, `marital_status`, `child`, `child_count`, `child_age_group`, `height`, `education`, `profession`, `income`, `religion`) VALUES
(1, 'anshdeveloper', 'admin@gmail.com', NULL, NULL, 0, NULL, '$2y$12$sqsSaO8YHa84cxvgc88ZKOhc9XN3w7fG3Z0hLUEXgVXfrnaxccR/C', 1, NULL, '9610092299', 'VJoPL2QYPXVr1wZmxmEWpgZghMbQaSa7Ab4YkE0EWRr8L29nbNm8m0pZhmUC', '2025-12-26 15:58:06', '2025-12-26 15:58:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 'Radhe Radhe', 'singhmahipal23@gmail.com', NULL, NULL, 0, NULL, '$2y$12$tt5U.lIUSZt4tMy.l3o7veJ8tUrXIfa69nz526qMQemVHvmNSsIdO', 3, NULL, NULL, NULL, '2026-01-13 17:26:07', '2026-01-13 17:26:07', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'Yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9, 'Royal Collection', 'rayal@gmail.com', NULL, NULL, 0, NULL, '$2y$12$2n4GOVwK5jLtErAzcPYOh.Yp8aFmMw0a.tGkV6ddZ25b9jHNea8nm', 3, NULL, NULL, NULL, '2026-01-16 16:23:27', '2026-01-22 16:58:06', NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, 'Yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10, 'Ganesh', 'g@gmail.com', NULL, NULL, 0, NULL, '$2y$12$z8ObigDS.miD9Bn8DwMX1u8Ncb.UwE5935THqA5hdqX26yBiJ5ihG', 2, NULL, '3231323', NULL, '2026-01-27 16:00:33', '2026-01-27 16:00:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, 'Warrgyizmorsch', 'warrgyizmorch@gmsil.com', NULL, NULL, 0, NULL, '$2y$12$tftmSEUwdsgMluKAv6Kbnudc3UWpvTFs5BAdYMyEo0QiGCknEQPKa', 3, NULL, NULL, NULL, '2026-01-27 16:03:39', '2026-01-27 16:05:24', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, 'Yes', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `fk_categories_parent` (`parent_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 `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_unique` (`name`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1033;

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `fk_categories_parent` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL;
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 */;