-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 10, 2026 at 12:02 PM
-- 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: `mmbds_in1_rongtuli_db`
--

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

--
-- Table structure for table `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_type` enum('Admin','User') NOT NULL,
  `action` varchar(255) NOT NULL,
  `ip_address` varchar(50) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `activity_logs`
--

INSERT INTO `activity_logs` (`id`, `user_id`, `user_type`, `action`, `ip_address`, `details`, `created_at`) VALUES
(1, 2, 'User', 'Google Social Registration (Desktop)', '::1', NULL, '2026-06-07 06:32:30'),
(2, 1, 'Admin', 'Admin Successful Login', '::1', NULL, '2026-06-07 06:36:07'),
(3, 3, 'User', 'Google Social Registration (Desktop)', '::1', NULL, '2026-06-07 07:55:51'),
(4, 1, 'Admin', 'Admin Successful Login', '::1', NULL, '2026-06-07 07:56:06'),
(5, 1, 'Admin', 'Admin Successful Login', '127.0.0.1', NULL, '2026-06-08 04:33:16'),
(6, 1, 'Admin', 'Admin Successful Login', '127.0.0.1', NULL, '2026-06-08 09:01:14'),
(7, 3, 'User', 'Google Social Login (Desktop)', '::1', NULL, '2026-06-08 09:39:35'),
(8, 1, 'Admin', 'Admin Successful Login', '127.0.0.1', NULL, '2026-06-09 06:02:15'),
(9, 1, 'Admin', 'Admin Successful Login', '127.0.0.1', NULL, '2026-06-09 07:24:59');

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role_id` int(11) DEFAULT NULL,
  `status` enum('Active','Blocked') DEFAULT 'Active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `username`, `email`, `password`, `role_id`, `status`, `created_at`) VALUES
(1, 'admin', 'admin@smartdigital.com', '$2y$10$A49E.HSa0SqcL3eEDNOdYutSPFbMN8hrtgyEuDNLyJ3W00TunPwo2', 1, 'Active', '2026-06-07 06:31:55');

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

--
-- Table structure for table `api_settings`
--

CREATE TABLE `api_settings` (
  `id` int(11) NOT NULL DEFAULT 1,
  `razorpay_key` varchar(100) DEFAULT 'rzp_test_mockKey123',
  `razorpay_secret` varchar(100) DEFAULT 'rzp_test_mockSecret123',
  `whatsapp_token` varchar(255) DEFAULT NULL,
  `google_maps_key` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `shiprocket_email` varchar(150) DEFAULT 'rongtuligraphicscentre@gmail.com',
  `shiprocket_password` varchar(255) DEFAULT 'U^Hu!YFabls1jHBp#dn!GvKu^pqeDBZs',
  `shiprocket_token` text DEFAULT NULL,
  `shiprocket_token_expiry` datetime DEFAULT NULL,
  `shiprocket_endpoint_auth` varchar(255) DEFAULT 'https://shiprocket.in',
  `shiprocket_endpoint_order` varchar(255) DEFAULT 'https://shiprocket.in'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `api_settings`
--

INSERT INTO `api_settings` (`id`, `razorpay_key`, `razorpay_secret`, `whatsapp_token`, `google_maps_key`, `created_at`, `shiprocket_email`, `shiprocket_password`, `shiprocket_token`, `shiprocket_token_expiry`, `shiprocket_endpoint_auth`, `shiprocket_endpoint_order`) VALUES
(1, 'rzp_live_SCqhYY1VSBtUuW', '3C0OSC1XPAol1k2vAgZxRbK7', '', '', '2026-06-07 06:31:55', 'rongtuligraphicscentre@gmail.com', 'U^Hu!YFabls1jHBp#dn!GvKu^pqeDBZs', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOjEwODA3MDU2LCJzb3VyY2UiOiJzci1hdXRoLWludCIsImV4cCI6MTc4MTc3NTYyNiwianRpIjoiQmZ2ZHdmbkh2Q3B5c1JLdSIsImlhdCI6MTc4MDkxMTYyNiwiaXNzIjoiaHR0cHM6Ly9zci1hdXRoLnNoaXByb2NrZXQuaW4vYXV0aG9yaXplL3VzZXIiLCJuYmYiOjE3ODA5MTE2MjYsImNpZCI6NTQxNTk3NiwidGMiOjM2MCwidmVyYm9zZSI6ZmFsc2UsInZlbmRvcl9pZCI6MCwidmVuZG9yX2NvZGUiOiIifQ.LsmO_7_bOmG2Byyd78YT0CKOZy3Idj25Zn8dFqU32Vk', '2026-06-09 10:40:23', 'https://apiv2.shiprocket.in/v1/external/auth/login', 'https://apiv2.shiprocket.in/v1/external/orders/create/adhoc');

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` int(11) NOT NULL,
  `title` varchar(150) NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `button_text` varchar(50) DEFAULT 'Shop Now',
  `button_link` varchar(255) DEFAULT NULL,
  `button_text2` varchar(50) DEFAULT NULL,
  `button_link2` varchar(255) DEFAULT NULL,
  `button_text3` varchar(50) DEFAULT NULL,
  `button_link3` varchar(255) DEFAULT NULL,
  `button_text4` varchar(50) DEFAULT NULL,
  `button_link4` varchar(255) DEFAULT NULL,
  `status` enum('Active','Inactive') DEFAULT 'Active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` enum('Published','Draft') DEFAULT 'Published',
  `author` varchar(100) DEFAULT 'Admin',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `title`, `slug`, `content`, `image`, `status`, `author`, `created_at`) VALUES
(1, 'The Importance of Branding Stationery', 'branding-stationery-importance', '<p>Every business needs premium business cards and letterheads to establish trustworthiness...</p>', 'assets/images/business_cards.jpg', 'Published', 'Admin', '2026-06-07 07:22:52');

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

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

CREATE TABLE `carts` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `session_id` varchar(100) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `paper_type` varchar(100) DEFAULT NULL,
  `size` varchar(100) DEFAULT NULL,
  `finish` varchar(100) DEFAULT NULL,
  `design_file` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `carts`
--

INSERT INTO `carts` (`id`, `user_id`, `session_id`, `product_id`, `quantity`, `paper_type`, `size`, `finish`, `design_file`, `created_at`) VALUES
(1, NULL, '6si7gef49drku9vjmir6hv9378', 1, 100, 'Standard 300GSM', 'Standard (3.5x2 inch)', 'No Lamination', '', '2026-06-07 07:50:42'),
(2, NULL, 'sm35vfak47e7ai83ui6q2qqc2s', 4, 1, 'Standard White Ceramic', 'Standard 325ml Capacity', 'Vibrant Sublimation Gloss Finish', 'uploads/artwork_6a2523e5055bc_1780818917.pdf', '2026-06-07 07:55:17'),
(19, NULL, 'mqf6scsq8kb2b024jj2rbqlt2u', 5, 100, 'Glossy Sticker Paper', 'Circle 2-inch', 'Gloss Lamination', 'uploads/print-product/temp/temp_6a27c20ada92b_smartdigital.png', '2026-06-09 07:34:34');

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

--
-- Table structure for table `cart_options`
--

CREATE TABLE `cart_options` (
  `id` int(11) NOT NULL,
  `cart_id` int(11) NOT NULL,
  `group_id` int(11) DEFAULT NULL,
  `option_id` int(11) DEFAULT NULL,
  `group_name` varchar(100) NOT NULL,
  `option_name` varchar(100) NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cart_options`
--

INSERT INTO `cart_options` (`id`, `cart_id`, `group_id`, `option_id`, `group_name`, `option_name`, `price`) VALUES
(22, 19, 10, 24, 'Material/Paper Type', 'Glossy Sticker Paper', 1.20),
(23, 19, 11, 27, 'Size/Dimension', 'Circle 2-inch', 0.00),
(24, 19, 12, 30, 'Finish/Coating', 'Gloss Lamination', 0.00);

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

--
-- Table structure for table `contact_messages`
--

CREATE TABLE `contact_messages` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `subject` varchar(150) NOT NULL,
  `message` text NOT NULL,
  `status` enum('Pending','Read','Replied') DEFAULT 'Pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` int(11) NOT NULL,
  `code` varchar(50) NOT NULL,
  `discount_type` enum('Percentage','Fixed') DEFAULT 'Percentage',
  `value` decimal(10,2) NOT NULL,
  `min_cart_amount` decimal(10,2) DEFAULT 0.00,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `usage_limit` int(11) DEFAULT 100,
  `status` enum('Active','Expired') DEFAULT 'Active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `code`, `discount_type`, `value`, `min_cart_amount`, `start_date`, `end_date`, `usage_limit`, `status`, `created_at`) VALUES
(1, 'WELCOME10', 'Percentage', 10.00, 0.00, '2026-01-01', '2027-12-31', 1000, 'Active', '2026-06-07 06:31:55'),
(2, 'SMART15', 'Percentage', 15.00, 500.00, '2026-01-01', '2027-12-31', 500, 'Active', '2026-06-07 06:31:55'),
(3, 'BULKSAVE20', 'Percentage', 20.00, 2000.00, '2026-01-01', '2027-12-31', 500, 'Active', '2026-06-07 06:31:55'),
(4, 'FESTIVE25', 'Percentage', 25.00, 1500.00, '2026-01-01', '2027-12-31', 200, 'Active', '2026-06-07 06:31:55'),
(5, 'STARTUP30', 'Percentage', 30.00, 3000.00, '2026-01-01', '2027-12-31', 200, 'Active', '2026-06-07 06:31:55'),
(6, 'OFFICE35', 'Percentage', 35.00, 5000.00, '2026-01-01', '2027-12-31', 100, 'Active', '2026-06-07 06:31:55'),
(7, 'FREESHIP', 'Fixed', 100.00, 1000.00, '2026-01-01', '2027-12-31', 1000, 'Active', '2026-06-07 06:31:55'),
(8, 'CORP40', 'Percentage', 40.00, 10000.00, '2026-01-01', '2027-12-31', 50, 'Active', '2026-06-07 06:31:55'),
(9, 'BRAND50', 'Percentage', 50.00, 15000.00, '2026-01-01', '2027-12-31', 50, 'Active', '2026-06-07 06:31:55'),
(10, 'FIRSTORDER', 'Percentage', 10.00, 0.00, '2026-01-01', '2027-12-31', 1000, 'Active', '2026-06-07 06:31:55');

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

--
-- Table structure for table `courier_zone`
--

CREATE TABLE `courier_zone` (
  `id` int(11) NOT NULL,
  `zone_name` varchar(100) NOT NULL,
  `status` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `courier_zone`
--

INSERT INTO `courier_zone` (`id`, `zone_name`, `status`) VALUES
(1, 'Local Zone', 1),
(2, 'Intra-State Zone', 1),
(3, 'Inter-State Zone', 1),
(4, 'Regional Zone', 1),
(5, 'National Zone', 1),
(6, 'Remote Area Zone', 1);

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

--
-- Table structure for table `delivery_districts`
--

CREATE TABLE `delivery_districts` (
  `id` int(11) NOT NULL,
  `state_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `standard_price` decimal(10,2) NOT NULL DEFAULT 59.00,
  `standard_min_days` int(11) NOT NULL DEFAULT 5,
  `standard_max_days` int(11) NOT NULL DEFAULT 8,
  `express_price` decimal(10,2) NOT NULL DEFAULT 149.00,
  `express_min_days` int(11) NOT NULL DEFAULT 3,
  `express_max_days` int(11) NOT NULL DEFAULT 5
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `delivery_pricing`
--

CREATE TABLE `delivery_pricing` (
  `id` int(11) NOT NULL,
  `delivery_type` varchar(50) NOT NULL,
  `display_name` varchar(100) NOT NULL,
  `base_charge` decimal(10,2) NOT NULL DEFAULT 0.00,
  `base_distance` decimal(10,2) NOT NULL DEFAULT 5.00,
  `per_km_charge` decimal(10,2) NOT NULL DEFAULT 0.00,
  `est_days_min` int(11) NOT NULL DEFAULT 3,
  `est_days_max` int(11) NOT NULL DEFAULT 5,
  `status` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `delivery_pricing`
--

INSERT INTO `delivery_pricing` (`id`, `delivery_type`, `display_name`, `base_charge`, `base_distance`, `per_km_charge`, `est_days_min`, `est_days_max`, `status`) VALUES
(9, 'pickup', 'Pickup from Store', 0.00, 9999.00, 0.00, 1, 2, 1),
(10, 'standard', 'Standard Delivery', 59.00, 5.00, 5.00, 3, 5, 1),
(11, 'express', 'Express Delivery', 129.00, 5.00, 10.00, 1, 2, 1),
(12, 'free', 'Free Delivery', 0.00, 9999.00, 0.00, 5, 7, 1);

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

--
-- Table structure for table `delivery_pricing_rules`
--

CREATE TABLE `delivery_pricing_rules` (
  `id` int(11) NOT NULL,
  `state` varchar(100) NOT NULL,
  `district` varchar(100) NOT NULL DEFAULT 'All',
  `delivery_type` varchar(50) NOT NULL,
  `min_charge` decimal(10,2) NOT NULL DEFAULT 0.00,
  `max_charge` decimal(10,2) NOT NULL DEFAULT 9999.00,
  `base_distance` decimal(10,2) NOT NULL DEFAULT 5.00,
  `per_km_charge` decimal(10,2) NOT NULL DEFAULT 0.00,
  `handling_fee` decimal(10,2) NOT NULL DEFAULT 0.00,
  `cod_charge` decimal(10,2) NOT NULL DEFAULT 0.00,
  `gst_percent` decimal(5,2) NOT NULL DEFAULT 18.00,
  `free_delivery_limit` decimal(10,2) NOT NULL DEFAULT 0.00,
  `est_days_min` int(11) NOT NULL DEFAULT 3,
  `est_days_max` int(11) NOT NULL DEFAULT 5,
  `zone` varchar(50) NOT NULL DEFAULT 'National',
  `area_type` varchar(50) NOT NULL DEFAULT 'Urban',
  `status` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `delivery_pricing_rules`
--

INSERT INTO `delivery_pricing_rules` (`id`, `state`, `district`, `delivery_type`, `min_charge`, `max_charge`, `base_distance`, `per_km_charge`, `handling_fee`, `cod_charge`, `gst_percent`, `free_delivery_limit`, `est_days_min`, `est_days_max`, `zone`, `area_type`, `status`) VALUES
(45, 'Zone', 'Local Zone', 'pickup', 0.00, 0.00, 9999.00, 0.00, 0.00, 0.00, 0.00, 0.00, 1, 2, 'Local Zone', 'Metro Cities', 1),
(46, 'Zone', 'Local Zone', 'free', 0.00, 0.00, 9999.00, 0.00, 0.00, 0.00, 0.00, 0.00, 5, 7, 'Local Zone', 'Metro Cities', 1),
(47, 'Zone', 'Intra-State Zone', 'pickup', 0.00, 0.00, 9999.00, 0.00, 0.00, 0.00, 0.00, 0.00, 1, 2, 'Intra-State Zone', 'Urban Areas', 1),
(48, 'Zone', 'Intra-State Zone', 'free', 0.00, 0.00, 9999.00, 0.00, 0.00, 0.00, 0.00, 0.00, 5, 7, 'Intra-State Zone', 'Urban Areas', 1),
(49, 'Zone', 'Inter-State Zone', 'pickup', 0.00, 0.00, 9999.00, 0.00, 0.00, 0.00, 0.00, 0.00, 1, 2, 'Inter-State Zone', 'Rural Areas', 1),
(50, 'Zone', 'Inter-State Zone', 'free', 0.00, 0.00, 9999.00, 0.00, 0.00, 0.00, 0.00, 0.00, 5, 7, 'Inter-State Zone', 'Rural Areas', 1),
(51, 'Zone', 'Regional Zone', 'pickup', 0.00, 0.00, 9999.00, 0.00, 0.00, 0.00, 0.00, 0.00, 1, 2, 'Regional Zone', 'Rural Areas', 1),
(52, 'Zone', 'Regional Zone', 'free', 0.00, 0.00, 9999.00, 0.00, 0.00, 0.00, 0.00, 0.00, 5, 7, 'Regional Zone', 'Rural Areas', 1),
(53, 'Zone', 'National Zone', 'pickup', 0.00, 0.00, 9999.00, 0.00, 0.00, 0.00, 0.00, 0.00, 1, 2, 'National Zone', 'Urban Areas', 1),
(54, 'Zone', 'National Zone', 'free', 0.00, 0.00, 9999.00, 0.00, 0.00, 0.00, 0.00, 0.00, 5, 7, 'National Zone', 'Urban Areas', 1),
(55, 'Zone', 'Remote Area Zone', 'pickup', 0.00, 0.00, 9999.00, 0.00, 0.00, 0.00, 0.00, 0.00, 1, 2, 'Remote Area Zone', 'Remote Locations', 1),
(56, 'Zone', 'Remote Area Zone', 'free', 0.00, 0.00, 9999.00, 0.00, 0.00, 0.00, 0.00, 0.00, 5, 7, 'Remote Area Zone', 'Remote Locations', 1),
(57, 'Zone', 'Local Zone', 'standard', 59.00, 89.00, 5.00, 5.00, 5.00, 30.00, 18.00, 499.00, 2, 3, 'Local Zone', 'Metro Cities', 1),
(58, 'Zone', 'Intra-State Zone', 'standard', 69.00, 89.00, 10.00, 6.00, 10.00, 40.00, 18.00, 799.00, 3, 5, 'Intra-State Zone', 'Urban Areas', 1),
(59, 'Zone', 'Inter-State Zone', 'standard', 79.00, 89.00, 15.00, 7.00, 15.00, 50.00, 18.00, 999.00, 4, 7, 'Inter-State Zone', 'Urban Areas', 1),
(60, 'Zone', 'Regional Zone', 'standard', 79.00, 89.00, 15.00, 8.00, 15.00, 50.00, 18.00, 999.00, 4, 7, 'Regional Zone', 'Semi-Urban Areas', 1),
(61, 'Zone', 'National Zone', 'standard', 89.00, 89.00, 20.00, 10.00, 20.00, 60.00, 18.00, 1499.00, 5, 9, 'National Zone', 'Urban Areas', 1),
(62, 'Zone', 'Remote Area Zone', 'standard', 89.00, 89.00, 25.00, 12.00, 30.00, 80.00, 18.00, 2499.00, 7, 14, 'Remote Area Zone', 'Remote Locations', 1),
(63, 'Zone', 'Local Zone', 'express', 129.00, 199.00, 5.00, 10.00, 10.00, 40.00, 18.00, 999.00, 1, 1, 'Local Zone', 'Metro Cities', 1),
(64, 'Zone', 'Intra-State Zone', 'express', 149.00, 199.00, 10.00, 12.00, 15.00, 50.00, 18.00, 1499.00, 1, 2, 'Intra-State Zone', 'Urban Areas', 1),
(65, 'Zone', 'Inter-State Zone', 'express', 169.00, 199.00, 15.00, 14.00, 20.00, 65.00, 18.00, 1999.00, 2, 3, 'Inter-State Zone', 'Urban Areas', 1),
(66, 'Zone', 'Regional Zone', 'express', 169.00, 199.00, 15.00, 15.00, 20.00, 65.00, 18.00, 1999.00, 2, 3, 'Regional Zone', 'Semi-Urban Areas', 1),
(67, 'Zone', 'National Zone', 'express', 169.00, 199.00, 20.00, 18.00, 25.00, 80.00, 18.00, 2999.00, 2, 4, 'National Zone', 'Urban Areas', 1),
(68, 'Zone', 'Remote Area Zone', 'express', 199.00, 199.00, 25.00, 22.00, 40.00, 100.00, 18.00, 4999.00, 4, 7, 'Remote Area Zone', 'Remote Locations', 1);

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

--
-- Table structure for table `delivery_states`
--

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

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

--
-- Table structure for table `districts_master`
--

CREATE TABLE `districts_master` (
  `id` int(11) NOT NULL,
  `state_id` int(11) NOT NULL,
  `district_name` varchar(100) NOT NULL,
  `area_type` varchar(50) NOT NULL DEFAULT 'Urban Areas',
  `status` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `districts_master`
--

INSERT INTO `districts_master` (`id`, `state_id`, `district_name`, `area_type`, `status`) VALUES
(1, 1, 'Anantapur', 'Semi-Urban Areas', 1),
(2, 1, 'Chittoor', 'Urban Areas', 1),
(3, 1, 'East Godavari', 'Urban Areas', 1),
(4, 1, 'Guntur', 'Semi-Urban Areas', 1),
(5, 1, 'Krishna', 'Urban Areas', 1),
(6, 1, 'Kurnool', 'Urban Areas', 1),
(7, 1, 'Prakasam', 'Urban Areas', 1),
(8, 1, 'Srikakulam', 'Urban Areas', 1),
(9, 1, 'Sri Potti Sriramulu Nellore', 'Semi-Urban Areas', 1),
(10, 1, 'Visakhapatnam', 'Urban Areas', 1),
(11, 1, 'Vizianagaram', 'Semi-Urban Areas', 1),
(12, 1, 'West Godavari', 'Urban Areas', 1),
(13, 1, 'YSR Kadapa', 'Urban Areas', 1),
(14, 2, 'Tawang', 'Semi-Urban Areas', 1),
(15, 2, 'West Kameng', 'Urban Areas', 1),
(16, 2, 'East Kameng', 'Urban Areas', 1),
(17, 2, 'Papum Pare', 'Urban Areas', 1),
(18, 2, 'Kurung Kumey', 'Semi-Urban Areas', 1),
(19, 2, 'Lower Subansiri', 'Semi-Urban Areas', 1),
(20, 2, 'Upper Subansiri', 'Semi-Urban Areas', 1),
(21, 2, 'West Siang', 'Urban Areas', 1),
(22, 2, 'East Siang', 'Urban Areas', 1),
(23, 2, 'Siang', 'Urban Areas', 1),
(24, 2, 'Upper Siang', 'Urban Areas', 1),
(25, 2, 'Lower Siang', 'Urban Areas', 1),
(26, 2, 'Lower Dibang Valley', 'Urban Areas', 1),
(27, 2, 'Dibang Valley', 'Urban Areas', 1),
(28, 2, 'Anjaw', 'Urban Areas', 1),
(29, 2, 'Lohit', 'Urban Areas', 1),
(30, 2, 'Namsai', 'Semi-Urban Areas', 1),
(31, 2, 'Changlang', 'Semi-Urban Areas', 1),
(32, 2, 'Tirap', 'Urban Areas', 1),
(33, 2, 'Longding', 'Urban Areas', 1),
(34, 3, 'Baksa', 'Urban Areas', 1),
(35, 3, 'Barpeta', 'Urban Areas', 1),
(36, 3, 'Biswanath', 'Semi-Urban Areas', 1),
(37, 3, 'Bongaigaon', 'Urban Areas', 1),
(38, 3, 'Cachar', 'Semi-Urban Areas', 1),
(39, 3, 'Charaideo', 'Semi-Urban Areas', 1),
(40, 3, 'Chirang', 'Urban Areas', 1),
(41, 3, 'Darrang', 'Urban Areas', 1),
(42, 3, 'Dhemaji', 'Urban Areas', 1),
(43, 3, 'Dhubri', 'Semi-Urban Areas', 1),
(44, 3, 'Dibrugarh', 'Semi-Urban Areas', 1),
(45, 3, 'Dima Hasao', 'Urban Areas', 1),
(46, 3, 'Goalpara', 'Urban Areas', 1),
(47, 3, 'Golaghat', 'Urban Areas', 1),
(48, 3, 'Hailakandi', 'Urban Areas', 1),
(49, 3, 'Hojai', 'Urban Areas', 1),
(50, 3, 'Jorhat', 'Semi-Urban Areas', 1),
(51, 3, 'Kamrup', 'Semi-Urban Areas', 1),
(52, 3, 'Kamrup Metropolitan', 'Urban Areas', 1),
(53, 3, 'Karbi Anglong', 'Urban Areas', 1),
(54, 3, 'Karimganj', 'Semi-Urban Areas', 1),
(55, 3, 'Kokrajhar', 'Semi-Urban Areas', 1),
(56, 3, 'Lakhimpur', 'Semi-Urban Areas', 1),
(57, 3, 'Majuli', 'Semi-Urban Areas', 1),
(58, 3, 'Morigaon', 'Urban Areas', 1),
(59, 3, 'Nagaon', 'Semi-Urban Areas', 1),
(60, 3, 'Nalbari', 'Urban Areas', 1),
(61, 3, 'Sivasagar', 'Semi-Urban Areas', 1),
(62, 3, 'Sonitpur', 'Urban Areas', 1),
(63, 3, 'South Salmara-Mankachar', 'Urban Areas', 1),
(64, 3, 'Tinsukia', 'Urban Areas', 1),
(65, 3, 'Udalguri', 'Urban Areas', 1),
(66, 3, 'West Karbi Anglong', 'Semi-Urban Areas', 1),
(67, 4, 'Araria', 'Semi-Urban Areas', 1),
(68, 4, 'Arwal', 'Urban Areas', 1),
(69, 4, 'Aurangabad', 'Urban Areas', 1),
(70, 4, 'Banka', 'Urban Areas', 1),
(71, 4, 'Begusarai', 'Semi-Urban Areas', 1),
(72, 4, 'Bhagalpur', 'Semi-Urban Areas', 1),
(73, 4, 'Bhojpur', 'Urban Areas', 1),
(74, 4, 'Buxar', 'Urban Areas', 1),
(75, 4, 'Darbhanga', 'Semi-Urban Areas', 1),
(76, 4, 'East Champaran', 'Urban Areas', 1),
(77, 4, 'Gaya', 'Urban Areas', 1),
(78, 4, 'Gopalganj', 'Semi-Urban Areas', 1),
(79, 4, 'Jamui', 'Urban Areas', 1),
(80, 4, 'Jehanabad', 'Semi-Urban Areas', 1),
(81, 4, 'Kaimur', 'Semi-Urban Areas', 1),
(82, 4, 'Katihar', 'Urban Areas', 1),
(83, 4, 'Khagaria', 'Urban Areas', 1),
(84, 4, 'Kishanganj', 'Urban Areas', 1),
(85, 4, 'Lakhisarai', 'Urban Areas', 1),
(86, 4, 'Madhepura', 'Semi-Urban Areas', 1),
(87, 4, 'Madhubani', 'Semi-Urban Areas', 1),
(88, 4, 'Munger', 'Semi-Urban Areas', 1),
(89, 4, 'Muzaffarpur', 'Urban Areas', 1),
(90, 4, 'Nalanda', 'Urban Areas', 1),
(91, 4, 'Nawada', 'Semi-Urban Areas', 1),
(92, 4, 'Patna', 'Urban Areas', 1),
(93, 4, 'Purnia', 'Semi-Urban Areas', 1),
(94, 4, 'Rohtas', 'Semi-Urban Areas', 1),
(95, 4, 'Saharsa', 'Urban Areas', 1),
(96, 4, 'Samastipur', 'Urban Areas', 1),
(97, 4, 'Saran', 'Urban Areas', 1),
(98, 4, 'Sheikhpura', 'Urban Areas', 1),
(99, 4, 'Sheohar', 'Urban Areas', 1),
(100, 4, 'Sitamarhi', 'Semi-Urban Areas', 1),
(101, 4, 'Siwan', 'Urban Areas', 1),
(102, 4, 'Supaul', 'Semi-Urban Areas', 1),
(103, 4, 'Vaishali', 'Urban Areas', 1),
(104, 4, 'West Champaran', 'Urban Areas', 1),
(105, 5, 'Balod', 'Urban Areas', 1),
(106, 5, 'Baloda Bazar', 'Semi-Urban Areas', 1),
(107, 5, 'Balrampur', 'Semi-Urban Areas', 1),
(108, 5, 'Bastar', 'Semi-Urban Areas', 1),
(109, 5, 'Bemetara', 'Urban Areas', 1),
(110, 5, 'Bijapur', 'Urban Areas', 1),
(111, 5, 'Bilaspur', 'Urban Areas', 1),
(112, 5, 'Dantewada', 'Semi-Urban Areas', 1),
(113, 5, 'Dhamtari', 'Urban Areas', 1),
(114, 5, 'Durg', 'Urban Areas', 1),
(115, 5, 'Gariaband', 'Semi-Urban Areas', 1),
(116, 5, 'Janibar-Champa', 'Urban Areas', 1),
(117, 5, 'Jashpur', 'Urban Areas', 1),
(118, 5, 'Kabirdham', 'Semi-Urban Areas', 1),
(119, 5, 'Kanker', 'Semi-Urban Areas', 1),
(120, 5, 'Kondagaon', 'Semi-Urban Areas', 1),
(121, 5, 'Korba', 'Urban Areas', 1),
(122, 5, 'Koriya', 'Semi-Urban Areas', 1),
(123, 5, 'Mahasamund', 'Urban Areas', 1),
(124, 5, 'Mungeli', 'Urban Areas', 1),
(125, 5, 'Narayanpur', 'Urban Areas', 1),
(126, 5, 'Raigarh', 'Urban Areas', 1),
(127, 5, 'Raipur', 'Semi-Urban Areas', 1),
(128, 5, 'Rajnandgaon', 'Urban Areas', 1),
(129, 5, 'Sukma', 'Urban Areas', 1),
(130, 5, 'Surajpur', 'Urban Areas', 1),
(131, 5, 'Surguja', 'Urban Areas', 1),
(132, 6, 'North Goa', 'Semi-Urban Areas', 1),
(133, 6, 'South Goa', 'Semi-Urban Areas', 1),
(134, 7, 'Ahmedabad', 'Metro Cities', 1),
(135, 7, 'Amreli', 'Semi-Urban Areas', 1),
(136, 7, 'Anand', 'Urban Areas', 1),
(137, 7, 'Aravalli', 'Urban Areas', 1),
(138, 7, 'Banaskantha', 'Urban Areas', 1),
(139, 7, 'Bharuch', 'Urban Areas', 1),
(140, 7, 'Bhavnagar', 'Semi-Urban Areas', 1),
(141, 7, 'Botad', 'Urban Areas', 1),
(142, 7, 'Chhota Udepur', 'Urban Areas', 1),
(143, 7, 'Dahod', 'Urban Areas', 1),
(144, 7, 'Dangs', 'Urban Areas', 1),
(145, 7, 'Devbhoomi Dwarka', 'Urban Areas', 1),
(146, 7, 'Gandhinagar', 'Urban Areas', 1),
(147, 7, 'Gir Somnath', 'Urban Areas', 1),
(148, 7, 'Jamnagar', 'Urban Areas', 1),
(149, 7, 'Junagadh', 'Urban Areas', 1),
(150, 7, 'Kheda', 'Urban Areas', 1),
(151, 7, 'Kutch', 'Urban Areas', 1),
(152, 7, 'Mahisagar', 'Semi-Urban Areas', 1),
(153, 7, 'Mehsana', 'Urban Areas', 1),
(154, 7, 'Morbi', 'Urban Areas', 1),
(155, 7, 'Narmada', 'Urban Areas', 1),
(156, 7, 'Navsari', 'Urban Areas', 1),
(157, 7, 'Panchmahal', 'Urban Areas', 1),
(158, 7, 'Patan', 'Urban Areas', 1),
(159, 7, 'Porbandar', 'Semi-Urban Areas', 1),
(160, 7, 'Rajkot', 'Semi-Urban Areas', 1),
(161, 7, 'Sabarkantha', 'Urban Areas', 1),
(162, 7, 'Surat', 'Urban Areas', 1),
(163, 7, 'Surendranagar', 'Urban Areas', 1),
(164, 7, 'Tapi', 'Urban Areas', 1),
(165, 7, 'Vadodara', 'Urban Areas', 1),
(166, 7, 'Valsad', 'Semi-Urban Areas', 1),
(167, 8, 'Ambala', 'Semi-Urban Areas', 1),
(168, 8, 'Bhiwani', 'Urban Areas', 1),
(169, 8, 'Charkhi Dadri', 'Urban Areas', 1),
(170, 8, 'Faridabad', 'Semi-Urban Areas', 1),
(171, 8, 'Fatehabad', 'Semi-Urban Areas', 1),
(172, 8, 'Gurugram', 'Metro Cities', 1),
(173, 8, 'Hisar', 'Urban Areas', 1),
(174, 8, 'Jhajjar', 'Urban Areas', 1),
(175, 8, 'Jind', 'Urban Areas', 1),
(176, 8, 'Kaithal', 'Urban Areas', 1),
(177, 8, 'Karnal', 'Semi-Urban Areas', 1),
(178, 8, 'Kurukshetra', 'Urban Areas', 1),
(179, 8, 'Mahendragarh', 'Semi-Urban Areas', 1),
(180, 8, 'Nuh', 'Semi-Urban Areas', 1),
(181, 8, 'Palwal', 'Semi-Urban Areas', 1),
(182, 8, 'Panchkula', 'Semi-Urban Areas', 1),
(183, 8, 'Panipat', 'Urban Areas', 1),
(184, 8, 'Rewari', 'Semi-Urban Areas', 1),
(185, 8, 'Rohtak', 'Semi-Urban Areas', 1),
(186, 8, 'Sirsa', 'Urban Areas', 1),
(187, 8, 'Sonipat', 'Urban Areas', 1),
(188, 8, 'Yamunanagar', 'Urban Areas', 1),
(189, 9, 'Bilaspur', 'Urban Areas', 1),
(190, 9, 'Chamba', 'Semi-Urban Areas', 1),
(191, 9, 'Hamirpur', 'Urban Areas', 1),
(192, 9, 'Kangra', 'Semi-Urban Areas', 1),
(193, 9, 'Kinnaur', 'Urban Areas', 1),
(194, 9, 'Kullu', 'Urban Areas', 1),
(195, 9, 'Lahaul and Spiti', 'Urban Areas', 1),
(196, 9, 'Mandi', 'Urban Areas', 1),
(197, 9, 'Shimla', 'Semi-Urban Areas', 1),
(198, 9, 'Sirmaur', 'Urban Areas', 1),
(199, 9, 'Solan', 'Urban Areas', 1),
(200, 9, 'Una', 'Semi-Urban Areas', 1),
(201, 10, 'Bokaro', 'Semi-Urban Areas', 1),
(202, 10, 'Chatra', 'Semi-Urban Areas', 1),
(203, 10, 'Deoghar', 'Urban Areas', 1),
(204, 10, 'Dhanbad', 'Urban Areas', 1),
(205, 10, 'Dumka', 'Urban Areas', 1),
(206, 10, 'East Singhbhum', 'Urban Areas', 1),
(207, 10, 'Garhwa', 'Semi-Urban Areas', 1),
(208, 10, 'Giridih', 'Urban Areas', 1),
(209, 10, 'Godda', 'Urban Areas', 1),
(210, 10, 'Gumla', 'Urban Areas', 1),
(211, 10, 'Hazaribagh', 'Urban Areas', 1),
(212, 10, 'Jamtara', 'Urban Areas', 1),
(213, 10, 'Khunti', 'Semi-Urban Areas', 1),
(214, 10, 'Koderma', 'Urban Areas', 1),
(215, 10, 'Latehar', 'Urban Areas', 1),
(216, 10, 'Lohardaga', 'Semi-Urban Areas', 1),
(217, 10, 'Pakur', 'Urban Areas', 1),
(218, 10, 'Palamu', 'Semi-Urban Areas', 1),
(219, 10, 'Ramgarh', 'Urban Areas', 1),
(220, 10, 'Ranchi', 'Semi-Urban Areas', 1),
(221, 10, 'Sahibganj', 'Semi-Urban Areas', 1),
(222, 10, 'Seraikela Kharsawan', 'Urban Areas', 1),
(223, 10, 'Simdega', 'Urban Areas', 1),
(224, 10, 'West Singhbhum', 'Urban Areas', 1),
(225, 11, 'Bagalkot', 'Urban Areas', 1),
(226, 11, 'Ballari', 'Urban Areas', 1),
(227, 11, 'Belagavi', 'Urban Areas', 1),
(228, 11, 'Bengaluru Rural', 'Metro Cities', 1),
(229, 11, 'Bengaluru Urban', 'Metro Cities', 1),
(230, 11, 'Bidar', 'Urban Areas', 1),
(231, 11, 'Chamarajanagar', 'Urban Areas', 1),
(232, 11, 'Chikkaballapur', 'Urban Areas', 1),
(233, 11, 'Chikkamagaluru', 'Urban Areas', 1),
(234, 11, 'Chitradurga', 'Urban Areas', 1),
(235, 11, 'Dakshina Kannada', 'Urban Areas', 1),
(236, 11, 'Davanagere', 'Urban Areas', 1),
(237, 11, 'Dharwad', 'Urban Areas', 1),
(238, 11, 'Gadag', 'Urban Areas', 1),
(239, 11, 'Hassan', 'Semi-Urban Areas', 1),
(240, 11, 'Haveri', 'Semi-Urban Areas', 1),
(241, 11, 'Kalaburagi', 'Urban Areas', 1),
(242, 11, 'Kodagu', 'Semi-Urban Areas', 1),
(243, 11, 'Kolar', 'Urban Areas', 1),
(244, 11, 'Koppal', 'Semi-Urban Areas', 1),
(245, 11, 'Mandya', 'Semi-Urban Areas', 1),
(246, 11, 'Mysuru', 'Semi-Urban Areas', 1),
(247, 11, 'Raichur', 'Urban Areas', 1),
(248, 11, 'Ramanagara', 'Urban Areas', 1),
(249, 11, 'Shivamogga', 'Urban Areas', 1),
(250, 11, 'Tumakuru', 'Urban Areas', 1),
(251, 11, 'Udupi', 'Urban Areas', 1),
(252, 11, 'Uttara Kannada', 'Urban Areas', 1),
(253, 11, 'Vijayapura', 'Urban Areas', 1),
(254, 11, 'Yadgir', 'Semi-Urban Areas', 1),
(255, 12, 'Alappuzha', 'Semi-Urban Areas', 1),
(256, 12, 'Ernakulam', 'Semi-Urban Areas', 1),
(257, 12, 'Idukki', 'Semi-Urban Areas', 1),
(258, 12, 'Kannur', 'Semi-Urban Areas', 1),
(259, 12, 'Kasaragod', 'Semi-Urban Areas', 1),
(260, 12, 'Kollam', 'Semi-Urban Areas', 1),
(261, 12, 'Kottayam', 'Urban Areas', 1),
(262, 12, 'Kozhikode', 'Semi-Urban Areas', 1),
(263, 12, 'Malappuram', 'Urban Areas', 1),
(264, 12, 'Palakkad', 'Urban Areas', 1),
(265, 12, 'Pathanamthitta', 'Urban Areas', 1),
(266, 12, 'Thiruvananthapuram', 'Semi-Urban Areas', 1),
(267, 12, 'Thrissur', 'Urban Areas', 1),
(268, 12, 'Wayanad', 'Urban Areas', 1),
(269, 13, 'Agar Malwa', 'Urban Areas', 1),
(270, 13, 'Alirajpur', 'Semi-Urban Areas', 1),
(271, 13, 'Anuppur', 'Urban Areas', 1),
(272, 13, 'Ashoknagar', 'Urban Areas', 1),
(273, 13, 'Balaghat', 'Urban Areas', 1),
(274, 13, 'Barwani', 'Urban Areas', 1),
(275, 13, 'Betul', 'Urban Areas', 1),
(276, 13, 'Bhind', 'Urban Areas', 1),
(277, 13, 'Bhopal', 'Semi-Urban Areas', 1),
(278, 13, 'Burhanpur', 'Semi-Urban Areas', 1),
(279, 13, 'Chhatarpur', 'Urban Areas', 1),
(280, 13, 'Chhindwara', 'Urban Areas', 1),
(281, 13, 'Damoh', 'Urban Areas', 1),
(282, 13, 'Datia', 'Urban Areas', 1),
(283, 13, 'Dewas', 'Urban Areas', 1),
(284, 13, 'Dhar', 'Urban Areas', 1),
(285, 13, 'Dindori', 'Urban Areas', 1),
(286, 13, 'Guna', 'Urban Areas', 1),
(287, 13, 'Gwalior', 'Urban Areas', 1),
(288, 13, 'Harda', 'Urban Areas', 1),
(289, 13, 'Narmadapuram', 'Semi-Urban Areas', 1),
(290, 13, 'Indore', 'Semi-Urban Areas', 1),
(291, 13, 'Jabalpur', 'Urban Areas', 1),
(292, 13, 'Jhabua', 'Semi-Urban Areas', 1),
(293, 13, 'Katni', 'Urban Areas', 1),
(294, 13, 'Khandwa', 'Urban Areas', 1),
(295, 13, 'Khargone', 'Urban Areas', 1),
(296, 13, 'Mandla', 'Semi-Urban Areas', 1),
(297, 13, 'Mandsaur', 'Urban Areas', 1),
(298, 13, 'Morena', 'Semi-Urban Areas', 1),
(299, 13, 'Narsinghpur', 'Urban Areas', 1),
(300, 13, 'Neemuch', 'Urban Areas', 1),
(301, 13, 'Panna', 'Urban Areas', 1),
(302, 13, 'Raisen', 'Semi-Urban Areas', 1),
(303, 13, 'Rajgarh', 'Urban Areas', 1),
(304, 13, 'Ratlam', 'Semi-Urban Areas', 1),
(305, 13, 'Rewa', 'Urban Areas', 1),
(306, 13, 'Sagar', 'Urban Areas', 1),
(307, 13, 'Satna', 'Urban Areas', 1),
(308, 13, 'Sehore', 'Semi-Urban Areas', 1),
(309, 13, 'Seoni', 'Urban Areas', 1),
(310, 13, 'Shahdol', 'Urban Areas', 1),
(311, 13, 'Shajapur', 'Urban Areas', 1),
(312, 13, 'Sheopur', 'Urban Areas', 1),
(313, 13, 'Shivpuri', 'Urban Areas', 1),
(314, 13, 'Sidhi', 'Urban Areas', 1),
(315, 13, 'Singrauli', 'Semi-Urban Areas', 1),
(316, 13, 'Tikamgarh', 'Semi-Urban Areas', 1),
(317, 13, 'Ujjain', 'Semi-Urban Areas', 1),
(318, 13, 'Umaria', 'Semi-Urban Areas', 1),
(319, 13, 'Vidisha', 'Urban Areas', 1),
(320, 14, 'Ahmednagar', 'Urban Areas', 1),
(321, 14, 'Akola', 'Urban Areas', 1),
(322, 14, 'Amravati', 'Urban Areas', 1),
(323, 14, 'Aurangabad', 'Urban Areas', 1),
(324, 14, 'Beed', 'Urban Areas', 1),
(325, 14, 'Bhandara', 'Urban Areas', 1),
(326, 14, 'Buldhana', 'Urban Areas', 1),
(327, 14, 'Chandrapur', 'Urban Areas', 1),
(328, 14, 'Dhule', 'Urban Areas', 1),
(329, 14, 'Gadchiroli', 'Urban Areas', 1),
(330, 14, 'Gondia', 'Semi-Urban Areas', 1),
(331, 14, 'Hingoli', 'Urban Areas', 1),
(332, 14, 'Jalgaon', 'Urban Areas', 1),
(333, 14, 'Jalna', 'Urban Areas', 1),
(334, 14, 'Kolhapur', 'Urban Areas', 1),
(335, 14, 'Latur', 'Urban Areas', 1),
(336, 14, 'Mumbai City', 'Metro Cities', 1),
(337, 14, 'Mumbai Suburban', 'Metro Cities', 1),
(338, 14, 'Nagpur', 'Semi-Urban Areas', 1),
(339, 14, 'Nanded', 'Semi-Urban Areas', 1),
(340, 14, 'Nandurbar', 'Semi-Urban Areas', 1),
(341, 14, 'Nashik', 'Semi-Urban Areas', 1),
(342, 14, 'Osmanabad', 'Semi-Urban Areas', 1),
(343, 14, 'Palghar', 'Urban Areas', 1),
(344, 14, 'Parbhani', 'Urban Areas', 1),
(345, 14, 'Pune', 'Metro Cities', 1),
(346, 14, 'Raigad', 'Semi-Urban Areas', 1),
(347, 14, 'Ratnagiri', 'Semi-Urban Areas', 1),
(348, 14, 'Sangli', 'Semi-Urban Areas', 1),
(349, 14, 'Satara', 'Semi-Urban Areas', 1),
(350, 14, 'Sindhudurg', 'Urban Areas', 1),
(351, 14, 'Solapur', 'Urban Areas', 1),
(352, 14, 'Thane', 'Urban Areas', 1),
(353, 14, 'Wardha', 'Semi-Urban Areas', 1),
(354, 14, 'Washim', 'Semi-Urban Areas', 1),
(355, 14, 'Yavatmal', 'Urban Areas', 1),
(356, 15, 'Bishnupur', 'Semi-Urban Areas', 1),
(357, 15, 'Chandel', 'Urban Areas', 1),
(358, 15, 'Churachandpur', 'Urban Areas', 1),
(359, 15, 'Imphal East', 'Urban Areas', 1),
(360, 15, 'Imphal West', 'Urban Areas', 1),
(361, 15, 'Jiribam', 'Urban Areas', 1),
(362, 15, 'Kakching', 'Urban Areas', 1),
(363, 15, 'Kamjong', 'Urban Areas', 1),
(364, 15, 'Kangpokpi', 'Semi-Urban Areas', 1),
(365, 15, 'Noney', 'Urban Areas', 1),
(366, 15, 'Pherzawl', 'Urban Areas', 1),
(367, 15, 'Senapati', 'Urban Areas', 1),
(368, 15, 'Tamenglong', 'Urban Areas', 1),
(369, 15, 'Tengnoupal', 'Urban Areas', 1),
(370, 15, 'Thoubal', 'Urban Areas', 1),
(371, 15, 'Ukhrul', 'Semi-Urban Areas', 1),
(372, 16, 'East Garo Hills', 'Semi-Urban Areas', 1),
(373, 16, 'East Jaintia Hills', 'Semi-Urban Areas', 1),
(374, 16, 'East Khasi Hills', 'Urban Areas', 1),
(375, 16, 'North Garo Hills', 'Urban Areas', 1),
(376, 16, 'Ri Bhoi', 'Urban Areas', 1),
(377, 16, 'South Garo Hills', 'Urban Areas', 1),
(378, 16, 'South West Garo Hills', 'Semi-Urban Areas', 1),
(379, 16, 'South West Khasi Hills', 'Urban Areas', 1),
(380, 16, 'West Garo Hills', 'Semi-Urban Areas', 1),
(381, 16, 'West Jaintia Hills', 'Semi-Urban Areas', 1),
(382, 16, 'West Khasi Hills', 'Urban Areas', 1),
(383, 17, 'Aizawl', 'Semi-Urban Areas', 1),
(384, 17, 'Champhai', 'Urban Areas', 1),
(385, 17, 'Hnahthial', 'Semi-Urban Areas', 1),
(386, 17, 'Khawzawl', 'Urban Areas', 1),
(387, 17, 'Kolasib', 'Urban Areas', 1),
(388, 17, 'Lawngtlai', 'Semi-Urban Areas', 1),
(389, 17, 'Lunglei', 'Urban Areas', 1),
(390, 17, 'Mamit', 'Urban Areas', 1),
(391, 17, 'Saiha', 'Urban Areas', 1),
(392, 17, 'Saitual', 'Urban Areas', 1),
(393, 17, 'Serchhip', 'Urban Areas', 1),
(394, 18, 'Dimapur', 'Urban Areas', 1),
(395, 18, 'Kiphire', 'Urban Areas', 1),
(396, 18, 'Kohima', 'Semi-Urban Areas', 1),
(397, 18, 'Longleng', 'Urban Areas', 1),
(398, 18, 'Mokokchung', 'Urban Areas', 1),
(399, 18, 'Mon', 'Semi-Urban Areas', 1),
(400, 18, 'Noklak', 'Semi-Urban Areas', 1),
(401, 18, 'Peren', 'Urban Areas', 1),
(402, 18, 'Phek', 'Urban Areas', 1),
(403, 18, 'Tuensang', 'Urban Areas', 1),
(404, 18, 'Wokha', 'Urban Areas', 1),
(405, 18, 'Zunheboto', 'Semi-Urban Areas', 1),
(406, 19, 'Angul', 'Urban Areas', 1),
(407, 19, 'Balangir', 'Urban Areas', 1),
(408, 19, 'Balasore', 'Urban Areas', 1),
(409, 19, 'Bargarh', 'Urban Areas', 1),
(410, 19, 'Bhadrak', 'Urban Areas', 1),
(411, 19, 'Boudh', 'Urban Areas', 1),
(412, 19, 'Cuttack', 'Urban Areas', 1),
(413, 19, 'Deogarh', 'Urban Areas', 1),
(414, 19, 'Dhenkanal', 'Semi-Urban Areas', 1),
(415, 19, 'Gajapati', 'Urban Areas', 1),
(416, 19, 'Ganjam', 'Semi-Urban Areas', 1),
(417, 19, 'Jagatsinghpur', 'Urban Areas', 1),
(418, 19, 'Jajpur', 'Semi-Urban Areas', 1),
(419, 19, 'Jharsuguda', 'Urban Areas', 1),
(420, 19, 'Kalahandi', 'Semi-Urban Areas', 1),
(421, 19, 'Kandhamal', 'Semi-Urban Areas', 1),
(422, 19, 'Kendrapara', 'Urban Areas', 1),
(423, 19, 'Kendujhar', 'Semi-Urban Areas', 1),
(424, 19, 'Khordha', 'Urban Areas', 1),
(425, 19, 'Koraput', 'Urban Areas', 1),
(426, 19, 'Malkangiri', 'Urban Areas', 1),
(427, 19, 'Mayurbhanj', 'Urban Areas', 1),
(428, 19, 'Nabarangpur', 'Urban Areas', 1),
(429, 19, 'Nayagarh', 'Urban Areas', 1),
(430, 19, 'Nuapada', 'Urban Areas', 1),
(431, 19, 'Puri', 'Urban Areas', 1),
(432, 19, 'Rayagada', 'Urban Areas', 1),
(433, 19, 'Sambalpur', 'Semi-Urban Areas', 1),
(434, 19, 'Subarnapur', 'Urban Areas', 1),
(435, 19, 'Sundargarh', 'Urban Areas', 1),
(436, 20, 'Amritsar', 'Urban Areas', 1),
(437, 20, 'Barnala', 'Urban Areas', 1),
(438, 20, 'Bathinda', 'Urban Areas', 1),
(439, 20, 'Faridkot', 'Urban Areas', 1),
(440, 20, 'Fatehgarh Sahib', 'Semi-Urban Areas', 1),
(441, 20, 'Fazilka', 'Urban Areas', 1),
(442, 20, 'Ferozepur', 'Semi-Urban Areas', 1),
(443, 20, 'Gurdaspur', 'Semi-Urban Areas', 1),
(444, 20, 'Hoshiarpur', 'Urban Areas', 1),
(445, 20, 'Jalandhar', 'Semi-Urban Areas', 1),
(446, 20, 'Kapurthala', 'Urban Areas', 1),
(447, 20, 'Ludhiana', 'Urban Areas', 1),
(448, 20, 'Malerkotla', 'Urban Areas', 1),
(449, 20, 'Mansa', 'Urban Areas', 1),
(450, 20, 'Moga', 'Urban Areas', 1),
(451, 20, 'Muktsar', 'Urban Areas', 1),
(452, 20, 'Pathankot', 'Semi-Urban Areas', 1),
(453, 20, 'Patiala', 'Urban Areas', 1),
(454, 20, 'Rupnagar', 'Urban Areas', 1),
(455, 20, 'Sahibzada Ajit Singh Nagar', 'Urban Areas', 1),
(456, 20, 'Sangrur', 'Urban Areas', 1),
(457, 20, 'Shahid Bhagat Singh Nagar', 'Urban Areas', 1),
(458, 20, 'Tarn Taran', 'Urban Areas', 1),
(459, 21, 'Ajmer', 'Urban Areas', 1),
(460, 21, 'Alwar', 'Urban Areas', 1),
(461, 21, 'Banswara', 'Urban Areas', 1),
(462, 21, 'Baran', 'Urban Areas', 1),
(463, 21, 'Barmer', 'Semi-Urban Areas', 1),
(464, 21, 'Bharatpur', 'Semi-Urban Areas', 1),
(465, 21, 'Bhilwara', 'Urban Areas', 1),
(466, 21, 'Bikaner', 'Urban Areas', 1),
(467, 21, 'Bundi', 'Urban Areas', 1),
(468, 21, 'Chittorgarh', 'Urban Areas', 1),
(469, 21, 'Churu', 'Urban Areas', 1),
(470, 21, 'Dausa', 'Urban Areas', 1),
(471, 21, 'Dholpur', 'Urban Areas', 1),
(472, 21, 'Dungarpur', 'Semi-Urban Areas', 1),
(473, 21, 'Hanumangarh', 'Urban Areas', 1),
(474, 21, 'Jaipur', 'Semi-Urban Areas', 1),
(475, 21, 'Jaisalmer', 'Semi-Urban Areas', 1),
(476, 21, 'Jalore', 'Semi-Urban Areas', 1),
(477, 21, 'Jhalawar', 'Urban Areas', 1),
(478, 21, 'Jhunjhunu', 'Semi-Urban Areas', 1),
(479, 21, 'Jodhpur', 'Urban Areas', 1),
(480, 21, 'Karauli', 'Urban Areas', 1),
(481, 21, 'Kota', 'Urban Areas', 1),
(482, 21, 'Nagaur', 'Semi-Urban Areas', 1),
(483, 21, 'Pali', 'Urban Areas', 1),
(484, 21, 'Pratapgarh', 'Urban Areas', 1),
(485, 21, 'Rajsamand', 'Semi-Urban Areas', 1),
(486, 21, 'Sawai Madhopur', 'Urban Areas', 1),
(487, 21, 'Sikar', 'Urban Areas', 1),
(488, 21, 'Sirohi', 'Semi-Urban Areas', 1),
(489, 21, 'Sri Ganganagar', 'Urban Areas', 1),
(490, 21, 'Tonk', 'Urban Areas', 1),
(491, 21, 'Udaipur', 'Urban Areas', 1),
(492, 22, 'East Sikkim', 'Urban Areas', 1),
(493, 22, 'North Sikkim', 'Semi-Urban Areas', 1),
(494, 22, 'South Sikkim', 'Semi-Urban Areas', 1),
(495, 22, 'West Sikkim', 'Urban Areas', 1),
(496, 23, 'Ariyalur', 'Urban Areas', 1),
(497, 23, 'Chengalpattu', 'Semi-Urban Areas', 1),
(498, 23, 'Chennai', 'Metro Cities', 1),
(499, 23, 'Coimbatore', 'Urban Areas', 1),
(500, 23, 'Cuddalore', 'Semi-Urban Areas', 1),
(501, 23, 'Dharmapuri', 'Urban Areas', 1),
(502, 23, 'Dindigul', 'Urban Areas', 1),
(503, 23, 'Erode', 'Urban Areas', 1),
(504, 23, 'Kallakurichi', 'Semi-Urban Areas', 1),
(505, 23, 'Kanchipuram', 'Urban Areas', 1),
(506, 23, 'Kanyakumari', 'Urban Areas', 1),
(507, 23, 'Karur', 'Urban Areas', 1),
(508, 23, 'Krishnagiri', 'Urban Areas', 1),
(509, 23, 'Madurai', 'Urban Areas', 1),
(510, 23, 'Mayiladuthurai', 'Urban Areas', 1),
(511, 23, 'Nagapattinam', 'Semi-Urban Areas', 1),
(512, 23, 'Namakkal', 'Urban Areas', 1),
(513, 23, 'Nilgiris', 'Urban Areas', 1),
(514, 23, 'Perambalur', 'Urban Areas', 1),
(515, 23, 'Pudukkottai', 'Urban Areas', 1),
(516, 23, 'Ramanathapuram', 'Urban Areas', 1),
(517, 23, 'Ranipet', 'Urban Areas', 1),
(518, 23, 'Salem', 'Urban Areas', 1),
(519, 23, 'Sivaganga', 'Semi-Urban Areas', 1),
(520, 23, 'Tenkasi', 'Urban Areas', 1),
(521, 23, 'Thanjavur', 'Semi-Urban Areas', 1),
(522, 23, 'Theni', 'Urban Areas', 1),
(523, 23, 'Thoothukudi', 'Urban Areas', 1),
(524, 23, 'Tiruchirappalli', 'Semi-Urban Areas', 1),
(525, 23, 'Tirunelveli', 'Urban Areas', 1),
(526, 23, 'Tirupathur', 'Urban Areas', 1),
(527, 23, 'Tiruppur', 'Urban Areas', 1),
(528, 23, 'Tiruvallur', 'Urban Areas', 1),
(529, 23, 'Tiruvannamalai', 'Urban Areas', 1),
(530, 23, 'Tiruvarur', 'Semi-Urban Areas', 1),
(531, 23, 'Vellore', 'Urban Areas', 1),
(532, 23, 'Viluppuram', 'Urban Areas', 1),
(533, 23, 'Virudhunagar', 'Semi-Urban Areas', 1),
(534, 24, 'Adilabad', 'Urban Areas', 1),
(535, 24, 'Bhadradri Kothagudem', 'Urban Areas', 1),
(536, 24, 'Hanumakonda', 'Urban Areas', 1),
(537, 24, 'Hyderabad', 'Metro Cities', 1),
(538, 24, 'Jagtial', 'Urban Areas', 1),
(539, 24, 'Jangaon', 'Urban Areas', 1),
(540, 24, 'Jayashankar Bhupalpally', 'Urban Areas', 1),
(541, 24, 'Jogulamba Gadwal', 'Urban Areas', 1),
(542, 24, 'Kamareddy', 'Semi-Urban Areas', 1),
(543, 24, 'Karimnagar', 'Urban Areas', 1),
(544, 24, 'Khammam', 'Urban Areas', 1),
(545, 24, 'Kumuram Bheem Asifabad', 'Urban Areas', 1),
(546, 24, 'Mahabubabad', 'Urban Areas', 1),
(547, 24, 'Mahabubnagar', 'Semi-Urban Areas', 1),
(548, 24, 'Mancherial', 'Urban Areas', 1),
(549, 24, 'Medak', 'Urban Areas', 1),
(550, 24, 'Medchal-Malkajgiri', 'Semi-Urban Areas', 1),
(551, 24, 'Mulugu', 'Semi-Urban Areas', 1),
(552, 24, 'Nagarkurnool', 'Semi-Urban Areas', 1),
(553, 24, 'Nalgonda', 'Urban Areas', 1),
(554, 24, 'Narayanpet', 'Urban Areas', 1),
(555, 24, 'Nirmal', 'Semi-Urban Areas', 1),
(556, 24, 'Nizamabad', 'Semi-Urban Areas', 1),
(557, 24, 'Peddapalli', 'Urban Areas', 1),
(558, 24, 'Rajanna Sircilla', 'Urban Areas', 1),
(559, 24, 'Rangareddy', 'Urban Areas', 1),
(560, 24, 'Sangareddy', 'Urban Areas', 1),
(561, 24, 'Siddipet', 'Urban Areas', 1),
(562, 24, 'Suryapet', 'Urban Areas', 1),
(563, 24, 'Vikarabad', 'Semi-Urban Areas', 1),
(564, 24, 'Wanaparthy', 'Urban Areas', 1),
(565, 24, 'Warangal', 'Urban Areas', 1),
(566, 24, 'Yadadri Bhuvanagiri', 'Urban Areas', 1),
(567, 25, 'Dhalai', 'Semi-Urban Areas', 1),
(568, 25, 'Gomati', 'Semi-Urban Areas', 1),
(569, 25, 'Khowai', 'Semi-Urban Areas', 1),
(570, 25, 'North Tripura', 'Urban Areas', 1),
(571, 25, 'Sepahijala', 'Urban Areas', 1),
(572, 25, 'South Tripura', 'Urban Areas', 1),
(573, 25, 'Unakoti', 'Urban Areas', 1),
(574, 25, 'West Tripura', 'Semi-Urban Areas', 1),
(575, 26, 'Agra', 'Urban Areas', 1),
(576, 26, 'Aligarh', 'Urban Areas', 1),
(577, 26, 'Ambedkar Nagar', 'Urban Areas', 1),
(578, 26, 'Amethi', 'Semi-Urban Areas', 1),
(579, 26, 'Amroha', 'Semi-Urban Areas', 1),
(580, 26, 'Auraiya', 'Urban Areas', 1),
(581, 26, 'Ayodhya', 'Urban Areas', 1),
(582, 26, 'Azamgarh', 'Urban Areas', 1),
(583, 26, 'Baghpat', 'Urban Areas', 1),
(584, 26, 'Bahraich', 'Urban Areas', 1),
(585, 26, 'Ballia', 'Semi-Urban Areas', 1),
(586, 26, 'Balrampur', 'Semi-Urban Areas', 1),
(587, 26, 'Banda', 'Urban Areas', 1),
(588, 26, 'Barabanki', 'Semi-Urban Areas', 1),
(589, 26, 'Bareilly', 'Urban Areas', 1),
(590, 26, 'Basti', 'Urban Areas', 1),
(591, 26, 'Bhadohi', 'Urban Areas', 1),
(592, 26, 'Bijnor', 'Semi-Urban Areas', 1),
(593, 26, 'Budaun', 'Semi-Urban Areas', 1),
(594, 26, 'Bulandshahr', 'Urban Areas', 1),
(595, 26, 'Chandauli', 'Semi-Urban Areas', 1),
(596, 26, 'Chitrakoot', 'Urban Areas', 1),
(597, 26, 'Deoria', 'Semi-Urban Areas', 1),
(598, 26, 'Etah', 'Urban Areas', 1),
(599, 26, 'Etawah', 'Semi-Urban Areas', 1),
(600, 26, 'Farrukhabad', 'Urban Areas', 1),
(601, 26, 'Fatehpur', 'Urban Areas', 1),
(602, 26, 'Firozabad', 'Semi-Urban Areas', 1),
(603, 26, 'Gautam Buddha Nagar', 'Urban Areas', 1),
(604, 26, 'Ghaziabad', 'Metro Cities', 1),
(605, 26, 'Ghazipur', 'Urban Areas', 1),
(606, 26, 'Gonda', 'Urban Areas', 1),
(607, 26, 'Gorakhpur', 'Semi-Urban Areas', 1),
(608, 26, 'Hamirpur', 'Urban Areas', 1),
(609, 26, 'Hapur', 'Urban Areas', 1),
(610, 26, 'Hardoi', 'Semi-Urban Areas', 1),
(611, 26, 'Hathras', 'Urban Areas', 1),
(612, 26, 'Jalaun', 'Semi-Urban Areas', 1),
(613, 26, 'Jaunpur', 'Urban Areas', 1),
(614, 26, 'Jhansi', 'Semi-Urban Areas', 1),
(615, 26, 'Kannauj', 'Urban Areas', 1),
(616, 26, 'Kanpur Dehat', 'Semi-Urban Areas', 1),
(617, 26, 'Kanpur Nagar', 'Semi-Urban Areas', 1),
(618, 26, 'Kasganj', 'Urban Areas', 1),
(619, 26, 'Kaushambi', 'Semi-Urban Areas', 1),
(620, 26, 'Kheri', 'Urban Areas', 1),
(621, 26, 'Kushinagar', 'Urban Areas', 1),
(622, 26, 'Lalitpur', 'Urban Areas', 1),
(623, 26, 'Lucknow', 'Urban Areas', 1),
(624, 26, 'Maharajganj', 'Urban Areas', 1),
(625, 26, 'Mahoba', 'Semi-Urban Areas', 1),
(626, 26, 'Mainpuri', 'Urban Areas', 1),
(627, 26, 'Mathura', 'Urban Areas', 1),
(628, 26, 'Mau', 'Semi-Urban Areas', 1),
(629, 26, 'Meerut', 'Semi-Urban Areas', 1),
(630, 26, 'Mirzapur', 'Urban Areas', 1),
(631, 26, 'Moradabad', 'Semi-Urban Areas', 1),
(632, 26, 'Muzaffarnagar', 'Urban Areas', 1),
(633, 26, 'Pilibhit', 'Urban Areas', 1),
(634, 26, 'Pratapgarh', 'Urban Areas', 1),
(635, 26, 'Prayagraj', 'Semi-Urban Areas', 1),
(636, 26, 'Raebareli', 'Semi-Urban Areas', 1),
(637, 26, 'Rampur', 'Semi-Urban Areas', 1),
(638, 26, 'Saharanpur', 'Urban Areas', 1),
(639, 26, 'Sambhal', 'Urban Areas', 1),
(640, 26, 'Sant Kabir Nagar', 'Urban Areas', 1),
(641, 26, 'Shahjahanpur', 'Semi-Urban Areas', 1),
(642, 26, 'Shamli', 'Semi-Urban Areas', 1),
(643, 26, 'Shravasti', 'Semi-Urban Areas', 1),
(644, 26, 'Siddharthnagar', 'Urban Areas', 1),
(645, 26, 'Sitapur', 'Urban Areas', 1),
(646, 26, 'Sonbhadra', 'Semi-Urban Areas', 1),
(647, 26, 'Sultanpur', 'Semi-Urban Areas', 1),
(648, 26, 'Unnao', 'Urban Areas', 1),
(649, 26, 'Varanasi', 'Urban Areas', 1),
(650, 27, 'Almora', 'Semi-Urban Areas', 1),
(651, 27, 'Bageshwar', 'Semi-Urban Areas', 1),
(652, 27, 'Chamoli', 'Urban Areas', 1),
(653, 27, 'Champawat', 'Semi-Urban Areas', 1),
(654, 27, 'Dehradun', 'Urban Areas', 1),
(655, 27, 'Haridwar', 'Urban Areas', 1),
(656, 27, 'Nainital', 'Urban Areas', 1),
(657, 27, 'Pauri Garhwal', 'Urban Areas', 1),
(658, 27, 'Pithoragarh', 'Urban Areas', 1),
(659, 27, 'Rudraprayag', 'Urban Areas', 1),
(660, 27, 'Tehri Garhwal', 'Urban Areas', 1),
(661, 27, 'Udham Singh Nagar', 'Urban Areas', 1),
(662, 27, 'Uttarkashi', 'Urban Areas', 1),
(663, 28, 'Alipurduar', 'Urban Areas', 1),
(664, 28, 'Bankura', 'Urban Areas', 1),
(665, 28, 'Birbhum', 'Urban Areas', 1),
(666, 28, 'Cooch Behar', 'Urban Areas', 1),
(667, 28, 'Dakshin Dinajpur', 'Urban Areas', 1),
(668, 28, 'Darjeeling', 'Urban Areas', 1),
(669, 28, 'Hooghly', 'Urban Areas', 1),
(670, 28, 'Howrah', 'Semi-Urban Areas', 1),
(671, 28, 'Jalpaiguri', 'Urban Areas', 1),
(672, 28, 'Jhargram', 'Urban Areas', 1),
(673, 28, 'Kalimpong', 'Semi-Urban Areas', 1),
(674, 28, 'Kolkata', 'Metro Cities', 1),
(675, 28, 'Malda', 'Urban Areas', 1),
(676, 28, 'Murshidabad', 'Urban Areas', 1),
(677, 28, 'Nadia', 'Urban Areas', 1),
(678, 28, 'North 24 Parganas', 'Urban Areas', 1),
(679, 28, 'Paschim Bardhaman', 'Urban Areas', 1),
(680, 28, 'Paschim Medinipur', 'Urban Areas', 1),
(681, 28, 'Purba Bardhaman', 'Semi-Urban Areas', 1),
(682, 28, 'Purba Medinipur', 'Semi-Urban Areas', 1),
(683, 28, 'Purulia', 'Urban Areas', 1),
(684, 28, 'South 24 Parganas', 'Urban Areas', 1),
(685, 28, 'Uttar Dinajpur', 'Urban Areas', 1),
(686, 29, 'Nicobar', 'Remote Locations', 1),
(687, 29, 'North and Middle Andaman', 'Remote Locations', 1),
(688, 29, 'South Andaman', 'Remote Locations', 1),
(689, 30, 'Chandigarh', 'Urban Areas', 1),
(690, 31, 'Dadra and Nagar Haveli', 'Urban Areas', 1),
(691, 31, 'Daman', 'Urban Areas', 1),
(692, 31, 'Diu', 'Semi-Urban Areas', 1),
(693, 32, 'Central Delhi', 'Urban Areas', 1),
(694, 32, 'East Delhi', 'Urban Areas', 1),
(695, 32, 'New Delhi', 'Metro Cities', 1),
(696, 32, 'North Delhi', 'Urban Areas', 1),
(697, 32, 'North East Delhi', 'Urban Areas', 1),
(698, 32, 'North West Delhi', 'Urban Areas', 1),
(699, 32, 'Shahdara', 'Urban Areas', 1),
(700, 32, 'South Delhi', 'Urban Areas', 1),
(701, 32, 'South East Delhi', 'Urban Areas', 1),
(702, 32, 'South West Delhi', 'Urban Areas', 1),
(703, 32, 'West Delhi', 'Urban Areas', 1),
(704, 33, 'Anantnag', 'Remote Locations', 1),
(705, 33, 'Bandipora', 'Remote Locations', 1),
(706, 33, 'Baramulla', 'Remote Locations', 1),
(707, 33, 'Budgam', 'Remote Locations', 1),
(708, 33, 'Doda', 'Remote Locations', 1),
(709, 33, 'Ganderbal', 'Remote Locations', 1),
(710, 33, 'Jammu', 'Remote Locations', 1),
(711, 33, 'Kathua', 'Remote Locations', 1),
(712, 33, 'Kishtwar', 'Remote Locations', 1),
(713, 33, 'Kulgam', 'Remote Locations', 1),
(714, 33, 'Kupwara', 'Remote Locations', 1),
(715, 33, 'Poonch', 'Remote Locations', 1),
(716, 33, 'Pulwama', 'Remote Locations', 1),
(717, 33, 'Ramban', 'Remote Locations', 1),
(718, 33, 'Reasi', 'Remote Locations', 1),
(719, 33, 'Samba', 'Remote Locations', 1),
(720, 33, 'Shopian', 'Remote Locations', 1),
(721, 33, 'Srinagar', 'Remote Locations', 1),
(722, 33, 'Udhampur', 'Remote Locations', 1),
(723, 34, 'Kargil', 'Remote Locations', 1),
(724, 34, 'Leh', 'Remote Locations', 1),
(725, 35, 'Lakshadweep', 'Remote Locations', 1),
(726, 36, 'Karaikal', 'Urban Areas', 1),
(727, 36, 'Mahe', 'Urban Areas', 1),
(728, 36, 'Puducherry', 'Urban Areas', 1),
(729, 36, 'Yanam', 'Urban Areas', 1);

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

--
-- Table structure for table `hero_banners`
--

CREATE TABLE `hero_banners` (
  `id` int(11) NOT NULL,
  `desktop_image` varchar(255) NOT NULL,
  `mobile_image` varchar(255) NOT NULL,
  `banner_link` varchar(255) DEFAULT NULL,
  `sort_order` int(11) DEFAULT 0,
  `status` varchar(20) DEFAULT 'Active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `indian_cities`
--

CREATE TABLE `indian_cities` (
  `id` int(11) NOT NULL,
  `state` varchar(150) NOT NULL,
  `city` varchar(150) NOT NULL,
  `closest_hub` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `indian_cities`
--

INSERT INTO `indian_cities` (`id`, `state`, `city`, `closest_hub`) VALUES
(1, 'Andaman and Nicobar Islands (union territory)', 'Port Blair', 'New-Delhi'),
(2, 'Andhra Pradesh', 'Adoni', 'Hyderabad'),
(3, 'Andhra Pradesh', 'Amaravati', 'Hyderabad'),
(4, 'Andhra Pradesh', 'Anantapur', 'Hyderabad'),
(5, 'Andhra Pradesh', 'Chandragiri', 'Hyderabad'),
(6, 'Andhra Pradesh', 'Chittoor', 'Hyderabad'),
(7, 'Andhra Pradesh', 'Dowlaiswaram', 'Hyderabad'),
(8, 'Andhra Pradesh', 'Eluru', 'Hyderabad'),
(9, 'Andhra Pradesh', 'Guntur', 'Hyderabad'),
(10, 'Andhra Pradesh', 'Kadapa', 'Hyderabad'),
(11, 'Andhra Pradesh', 'Kakinada', 'Hyderabad'),
(12, 'Andhra Pradesh', 'Kurnool', 'Hyderabad'),
(13, 'Andhra Pradesh', 'Machilipatnam', 'Hyderabad'),
(14, 'Andhra Pradesh', 'Nagarjunakoṇḍa', 'Hyderabad'),
(15, 'Andhra Pradesh', 'Rajahmundry', 'Hyderabad'),
(16, 'Andhra Pradesh', 'Srikakulam', 'Hyderabad'),
(17, 'Andhra Pradesh', 'Tirupati', 'Hyderabad'),
(18, 'Andhra Pradesh', 'Vijayawada', 'Hyderabad'),
(19, 'Andhra Pradesh', 'Visakhapatnam', 'Hyderabad'),
(20, 'Andhra Pradesh', 'Vizianagaram', 'Hyderabad'),
(21, 'Andhra Pradesh', 'Yemmiganur', 'Hyderabad'),
(22, 'Arunachal Pradesh', 'Itanagar', 'New-Delhi'),
(23, 'Assam', 'Dhuburi', 'New-Delhi'),
(24, 'Assam', 'Dibrugarh', 'New-Delhi'),
(25, 'Assam', 'Dispur', 'New-Delhi'),
(26, 'Assam', 'Guwahati', 'New-Delhi'),
(27, 'Assam', 'Jorhat', 'New-Delhi'),
(28, 'Assam', 'Nagaon', 'New-Delhi'),
(29, 'Assam', 'Sivasagar', 'New-Delhi'),
(30, 'Assam', 'Silchar', 'New-Delhi'),
(31, 'Assam', 'Tezpur', 'New-Delhi'),
(32, 'Assam', 'Tinsukia', 'New-Delhi'),
(33, 'Bihar', 'Ara', 'New-Delhi'),
(34, 'Bihar', 'Barauni', 'New-Delhi'),
(35, 'Bihar', 'Begusarai', 'New-Delhi'),
(36, 'Bihar', 'Bettiah', 'New-Delhi'),
(37, 'Bihar', 'Bhagalpur', 'New-Delhi'),
(38, 'Bihar', 'Bihar Sharif', 'New-Delhi'),
(39, 'Bihar', 'Bodh Gaya', 'New-Delhi'),
(40, 'Bihar', 'Buxar', 'New-Delhi'),
(41, 'Bihar', 'Chapra', 'New-Delhi'),
(42, 'Bihar', 'Darbhanga', 'New-Delhi'),
(43, 'Bihar', 'Dehri', 'New-Delhi'),
(44, 'Bihar', 'Dinapur Nizamat', 'New-Delhi'),
(45, 'Bihar', 'Gaya', 'New-Delhi'),
(46, 'Bihar', 'Hajipur', 'New-Delhi'),
(47, 'Bihar', 'Jamalpur', 'New-Delhi'),
(48, 'Bihar', 'Katihar', 'New-Delhi'),
(49, 'Bihar', 'Madhubani', 'New-Delhi'),
(50, 'Bihar', 'Motihari', 'New-Delhi'),
(51, 'Bihar', 'Munger', 'New-Delhi'),
(52, 'Bihar', 'Muzaffarpur', 'New-Delhi'),
(53, 'Bihar', 'Patna', 'New-Delhi'),
(54, 'Bihar', 'Purnia', 'New-Delhi'),
(55, 'Bihar', 'Pusa', 'New-Delhi'),
(56, 'Bihar', 'Saharsa', 'New-Delhi'),
(57, 'Bihar', 'Samastipur', 'New-Delhi'),
(58, 'Bihar', 'Sasaram', 'New-Delhi'),
(59, 'Bihar', 'Sitamarhi', 'New-Delhi'),
(60, 'Bihar', 'Siwan', 'New-Delhi'),
(61, 'Chandigarh (union territory)', 'Chandigarh', 'New-Delhi'),
(62, 'Chhattisgarh', 'Ambikapur', 'Hyderabad'),
(63, 'Chhattisgarh', 'Bhilai', 'Hyderabad'),
(64, 'Chhattisgarh', 'Bilaspur', 'Hyderabad'),
(65, 'Chhattisgarh', 'Dhamtari', 'Hyderabad'),
(66, 'Chhattisgarh', 'Durg', 'Hyderabad'),
(67, 'Chhattisgarh', 'Jagdalpur', 'Hyderabad'),
(68, 'Chhattisgarh', 'Raipur', 'Hyderabad'),
(69, 'Chhattisgarh', 'Rajnandgaon', 'Hyderabad'),
(70, 'Dadra and Nagar Haveli and Daman and Diu (union territory)', 'Daman', 'Pune'),
(71, 'Dadra and Nagar Haveli and Daman and Diu (union territory)', 'Diu', 'Pune'),
(72, 'Dadra and Nagar Haveli and Daman and Diu (union territory)', 'Silvassa', 'Pune'),
(73, 'Delhi (national capital territory)', 'Delhi', 'New-Delhi'),
(74, 'Delhi (national capital territory)', 'New Delhi', 'New-Delhi'),
(75, 'Goa', 'Madgaon', 'Bangalore'),
(76, 'Goa', 'Panaji', 'Bangalore'),
(77, 'Gujarat', 'Ahmadabad', 'Pune'),
(78, 'Gujarat', 'Amreli', 'Pune'),
(79, 'Gujarat', 'Bharuch', 'Pune'),
(80, 'Gujarat', 'Bhavnagar', 'Pune'),
(81, 'Gujarat', 'Bhuj', 'Pune'),
(82, 'Gujarat', 'Dwarka', 'Pune'),
(83, 'Gujarat', 'Gandhinagar', 'Pune'),
(84, 'Gujarat', 'Godhra', 'Pune'),
(85, 'Gujarat', 'Jamnagar', 'Pune'),
(86, 'Gujarat', 'Junagadh', 'Pune'),
(87, 'Gujarat', 'Kandla', 'Pune'),
(88, 'Gujarat', 'Khambhat', 'Pune'),
(89, 'Gujarat', 'Kheda', 'Pune'),
(90, 'Gujarat', 'Mahesana', 'Pune'),
(91, 'Gujarat', 'Morbi', 'Pune'),
(92, 'Gujarat', 'Nadiad', 'Pune'),
(93, 'Gujarat', 'Navsari', 'Pune'),
(94, 'Gujarat', 'Okha', 'Pune'),
(95, 'Gujarat', 'Palanpur', 'Pune'),
(96, 'Gujarat', 'Patan', 'Pune'),
(97, 'Gujarat', 'Porbandar', 'Pune'),
(98, 'Gujarat', 'Rajkot', 'Pune'),
(99, 'Gujarat', 'Surat', 'Pune'),
(100, 'Gujarat', 'Surendranagar', 'Pune'),
(101, 'Gujarat', 'Valsad', 'Pune'),
(102, 'Gujarat', 'Veraval', 'Pune'),
(103, 'Haryana', 'Ambala', 'Gurugram'),
(104, 'Haryana', 'Bhiwani', 'Gurugram'),
(105, 'Haryana', 'Chandigarh', 'Gurugram'),
(106, 'Haryana', 'Faridabad', 'Gurugram'),
(107, 'Haryana', 'Firozpur Jhirka', 'Gurugram'),
(108, 'Haryana', 'Gurugram', 'Gurugram'),
(109, 'Haryana', 'Hansi', 'Gurugram'),
(110, 'Haryana', 'Hisar', 'Gurugram'),
(111, 'Haryana', 'Jind', 'Gurugram'),
(112, 'Haryana', 'Kaithal', 'Gurugram'),
(113, 'Haryana', 'Karnal', 'Gurugram'),
(114, 'Haryana', 'Kurukshetra', 'Gurugram'),
(115, 'Haryana', 'Panipat', 'Gurugram'),
(116, 'Haryana', 'Pehowa', 'Gurugram'),
(117, 'Haryana', 'Rewari', 'Gurugram'),
(118, 'Haryana', 'Rohtak', 'Gurugram'),
(119, 'Haryana', 'Sirsa', 'Gurugram'),
(120, 'Haryana', 'Sonipat', 'Gurugram'),
(121, 'Himachal Pradesh', 'Bilaspur', 'New-Delhi'),
(122, 'Himachal Pradesh', 'Chamba', 'New-Delhi'),
(123, 'Himachal Pradesh', 'Dalhousie', 'New-Delhi'),
(124, 'Himachal Pradesh', 'Dharmshala', 'New-Delhi'),
(125, 'Himachal Pradesh', 'Hamirpur', 'New-Delhi'),
(126, 'Himachal Pradesh', 'Kangra', 'New-Delhi'),
(127, 'Himachal Pradesh', 'Kullu', 'New-Delhi'),
(128, 'Himachal Pradesh', 'Mandi', 'New-Delhi'),
(129, 'Himachal Pradesh', 'Nahan', 'New-Delhi'),
(130, 'Himachal Pradesh', 'Shimla', 'New-Delhi'),
(131, 'Himachal Pradesh', 'Una', 'New-Delhi'),
(132, 'Jammu and Kashmir (union territory)', 'Anantnag', 'New-Delhi'),
(133, 'Jammu and Kashmir (union territory)', 'Baramula', 'New-Delhi'),
(134, 'Jammu and Kashmir (union territory)', 'Doda', 'New-Delhi'),
(135, 'Jammu and Kashmir (union territory)', 'Gulmarg', 'New-Delhi'),
(136, 'Jammu and Kashmir (union territory)', 'Jammu', 'New-Delhi'),
(137, 'Jammu and Kashmir (union territory)', 'Kathua', 'New-Delhi'),
(138, 'Jammu and Kashmir (union territory)', 'Punch', 'New-Delhi'),
(139, 'Jammu and Kashmir (union territory)', 'Rajouri', 'New-Delhi'),
(140, 'Jammu and Kashmir (union territory)', 'Srinagar', 'New-Delhi'),
(141, 'Jammu and Kashmir (union territory)', 'Udhampur', 'New-Delhi'),
(142, 'Jharkhand', 'Bokaro', 'New-Delhi'),
(143, 'Jharkhand', 'Chaibasa', 'New-Delhi'),
(144, 'Jharkhand', 'Deoghar', 'New-Delhi'),
(145, 'Jharkhand', 'Dhanbad', 'New-Delhi'),
(146, 'Jharkhand', 'Dumka', 'New-Delhi'),
(147, 'Jharkhand', 'Giridih', 'New-Delhi'),
(148, 'Jharkhand', 'Hazaribag', 'New-Delhi'),
(149, 'Jharkhand', 'Jamshedpur', 'New-Delhi'),
(150, 'Jharkhand', 'Jharia', 'New-Delhi'),
(151, 'Jharkhand', 'Rajmahal', 'New-Delhi'),
(152, 'Jharkhand', 'Ranchi', 'New-Delhi'),
(153, 'Jharkhand', 'Saraikela', 'New-Delhi'),
(154, 'Karnataka', 'Badami', 'Bangalore'),
(155, 'Karnataka', 'Ballari', 'Bangalore'),
(156, 'Karnataka', 'Bengaluru', 'Bangalore'),
(157, 'Karnataka', 'Belagavi', 'Bangalore'),
(158, 'Karnataka', 'Bhadravati', 'Bangalore'),
(159, 'Karnataka', 'Bidar', 'Bangalore'),
(160, 'Karnataka', 'Chikkamagaluru', 'Bangalore'),
(161, 'Karnataka', 'Chitradurga', 'Bangalore'),
(162, 'Karnataka', 'Davangere', 'Bangalore'),
(163, 'Karnataka', 'Halebid', 'Bangalore'),
(164, 'Karnataka', 'Hassan', 'Bangalore'),
(165, 'Karnataka', 'Hubballi-Dharwad', 'Bangalore'),
(166, 'Karnataka', 'Kalaburagi', 'Bangalore'),
(167, 'Karnataka', 'Kolar', 'Bangalore'),
(168, 'Karnataka', 'Madikeri', 'Bangalore'),
(169, 'Karnataka', 'Mandya', 'Bangalore'),
(170, 'Karnataka', 'Mangaluru', 'Bangalore'),
(171, 'Karnataka', 'Mysuru', 'Bangalore'),
(172, 'Karnataka', 'Raichur', 'Bangalore'),
(173, 'Karnataka', 'Shivamogga', 'Bangalore'),
(174, 'Karnataka', 'Shravanabelagola', 'Bangalore'),
(175, 'Karnataka', 'Shrirangapattana', 'Bangalore'),
(176, 'Karnataka', 'Tumakuru', 'Bangalore'),
(177, 'Karnataka', 'Vijayapura', 'Bangalore'),
(178, 'Kerala', 'Alappuzha', 'Chennai'),
(179, 'Kerala', 'Vatakara', 'Chennai'),
(180, 'Kerala', 'Idukki', 'Chennai'),
(181, 'Kerala', 'Kannur', 'Chennai'),
(182, 'Kerala', 'Kochi', 'Chennai'),
(183, 'Kerala', 'Kollam', 'Chennai'),
(184, 'Kerala', 'Kottayam', 'Chennai'),
(185, 'Kerala', 'Kozhikode', 'Chennai'),
(186, 'Kerala', 'Mattancheri', 'Chennai'),
(187, 'Kerala', 'Palakkad', 'Chennai'),
(188, 'Kerala', 'Thalassery', 'Chennai'),
(189, 'Kerala', 'Thiruvananthapuram', 'Chennai'),
(190, 'Kerala', 'Thrissur', 'Chennai'),
(191, 'Ladakh (union territory)', 'Kargil', 'New-Delhi'),
(192, 'Ladakh (union territory)', 'Leh', 'New-Delhi'),
(193, 'Madhya Pradesh', 'Balaghat', 'Hyderabad'),
(194, 'Madhya Pradesh', 'Barwani', 'Hyderabad'),
(195, 'Madhya Pradesh', 'Betul', 'Hyderabad'),
(196, 'Madhya Pradesh', 'Bharhut', 'Hyderabad'),
(197, 'Madhya Pradesh', 'Bhind', 'Hyderabad'),
(198, 'Madhya Pradesh', 'Bhojpur', 'Hyderabad'),
(199, 'Madhya Pradesh', 'Bhopal', 'Hyderabad'),
(200, 'Madhya Pradesh', 'Burhanpur', 'Hyderabad'),
(201, 'Madhya Pradesh', 'Chhatarpur', 'Hyderabad'),
(202, 'Madhya Pradesh', 'Chhindwara', 'Hyderabad'),
(203, 'Madhya Pradesh', 'Damoh', 'Hyderabad'),
(204, 'Madhya Pradesh', 'Datia', 'Hyderabad'),
(205, 'Madhya Pradesh', 'Dewas', 'Hyderabad'),
(206, 'Madhya Pradesh', 'Dhar', 'Hyderabad'),
(207, 'Madhya Pradesh', 'Dr. Ambedkar Nagar (Mhow)', 'Hyderabad'),
(208, 'Madhya Pradesh', 'Guna', 'Hyderabad'),
(209, 'Madhya Pradesh', 'Gwalior', 'Hyderabad'),
(210, 'Madhya Pradesh', 'Hoshangabad', 'Hyderabad'),
(211, 'Madhya Pradesh', 'Indore', 'Hyderabad'),
(212, 'Madhya Pradesh', 'Itarsi', 'Hyderabad'),
(213, 'Madhya Pradesh', 'Jabalpur', 'Hyderabad'),
(214, 'Madhya Pradesh', 'Jhabua', 'Hyderabad'),
(215, 'Madhya Pradesh', 'Khajuraho', 'Hyderabad'),
(216, 'Madhya Pradesh', 'Khandwa', 'Hyderabad'),
(217, 'Madhya Pradesh', 'Khargone', 'Hyderabad'),
(218, 'Madhya Pradesh', 'Maheshwar', 'Hyderabad'),
(219, 'Madhya Pradesh', 'Mandla', 'Hyderabad'),
(220, 'Madhya Pradesh', 'Mandsaur', 'Hyderabad'),
(221, 'Madhya Pradesh', 'Morena', 'Hyderabad'),
(222, 'Madhya Pradesh', 'Murwara', 'Hyderabad'),
(223, 'Madhya Pradesh', 'Narsimhapur', 'Hyderabad'),
(224, 'Madhya Pradesh', 'Narsinghgarh', 'Hyderabad'),
(225, 'Madhya Pradesh', 'Narwar', 'Hyderabad'),
(226, 'Madhya Pradesh', 'Neemuch', 'Hyderabad'),
(227, 'Madhya Pradesh', 'Nowgong', 'Hyderabad'),
(228, 'Madhya Pradesh', 'Orchha', 'Hyderabad'),
(229, 'Madhya Pradesh', 'Panna', 'Hyderabad'),
(230, 'Madhya Pradesh', 'Raisen', 'Hyderabad'),
(231, 'Madhya Pradesh', 'Rajgarh', 'Hyderabad'),
(232, 'Madhya Pradesh', 'Ratlam', 'Hyderabad'),
(233, 'Madhya Pradesh', 'Rewa', 'Hyderabad'),
(234, 'Madhya Pradesh', 'Sagar', 'Hyderabad'),
(235, 'Madhya Pradesh', 'Sarangpur', 'Hyderabad'),
(236, 'Madhya Pradesh', 'Satna', 'Hyderabad'),
(237, 'Madhya Pradesh', 'Sehore', 'Hyderabad'),
(238, 'Madhya Pradesh', 'Seoni', 'Hyderabad'),
(239, 'Madhya Pradesh', 'Shahdol', 'Hyderabad'),
(240, 'Madhya Pradesh', 'Shajapur', 'Hyderabad'),
(241, 'Madhya Pradesh', 'Sheopur', 'Hyderabad'),
(242, 'Madhya Pradesh', 'Shivpuri', 'Hyderabad'),
(243, 'Madhya Pradesh', 'Ujjain', 'Hyderabad'),
(244, 'Madhya Pradesh', 'Vidisha', 'Hyderabad'),
(245, 'Maharashtra', 'Ahmadnagar', 'Pune'),
(246, 'Maharashtra', 'Akola', 'Pune'),
(247, 'Maharashtra', 'Amravati', 'Pune'),
(248, 'Maharashtra', 'Aurangabad', 'Pune'),
(249, 'Maharashtra', 'Bhandara', 'Pune'),
(250, 'Maharashtra', 'Bhusawal', 'Pune'),
(251, 'Maharashtra', 'Bid', 'Pune'),
(252, 'Maharashtra', 'Buldhana', 'Pune'),
(253, 'Maharashtra', 'Chandrapur', 'Pune'),
(254, 'Maharashtra', 'Daulatabad', 'Pune'),
(255, 'Maharashtra', 'Dhule', 'Pune'),
(256, 'Maharashtra', 'Jalgaon', 'Pune'),
(257, 'Maharashtra', 'Kalyan', 'Pune'),
(258, 'Maharashtra', 'Karli', 'Pune'),
(259, 'Maharashtra', 'Kolhapur', 'Pune'),
(260, 'Maharashtra', 'Mahabaleshwar', 'Pune'),
(261, 'Maharashtra', 'Malegaon', 'Pune'),
(262, 'Maharashtra', 'Matheran', 'Pune'),
(263, 'Maharashtra', 'Mumbai', 'Pune'),
(264, 'Maharashtra', 'Nagpur', 'Pune'),
(265, 'Maharashtra', 'Nanded', 'Pune'),
(266, 'Maharashtra', 'Nashik', 'Pune'),
(267, 'Maharashtra', 'Osmanabad', 'Pune'),
(268, 'Maharashtra', 'Pandharpur', 'Pune'),
(269, 'Maharashtra', 'Parbhani', 'Pune'),
(270, 'Maharashtra', 'Pune', 'Pune'),
(271, 'Maharashtra', 'Ratnagiri', 'Pune'),
(272, 'Maharashtra', 'Sangli', 'Pune'),
(273, 'Maharashtra', 'Satara', 'Pune'),
(274, 'Maharashtra', 'Sevagram', 'Pune'),
(275, 'Maharashtra', 'Solapur', 'Pune'),
(276, 'Maharashtra', 'Thane', 'Pune'),
(277, 'Maharashtra', 'Ulhasnagar', 'Pune'),
(278, 'Maharashtra', 'Vasai-Virar', 'Pune'),
(279, 'Maharashtra', 'Wardha', 'Pune'),
(280, 'Maharashtra', 'Yavatmal', 'Pune'),
(281, 'Manipur', 'Imphal', 'New-Delhi'),
(282, 'Meghalaya', 'Cherrapunji', 'New-Delhi'),
(283, 'Meghalaya', 'Shillong', 'New-Delhi'),
(284, 'Mizoram', 'Aizawl', 'New-Delhi'),
(285, 'Mizoram', 'Lunglei', 'New-Delhi'),
(286, 'Nagaland', 'Kohima', 'New-Delhi'),
(287, 'Nagaland', 'Mon', 'New-Delhi'),
(288, 'Nagaland', 'Phek', 'New-Delhi'),
(289, 'Nagaland', 'Wokha', 'New-Delhi'),
(290, 'Nagaland', 'Zunheboto', 'New-Delhi'),
(291, 'Odisha', 'Balangir', 'Hyderabad'),
(292, 'Odisha', 'Baleshwar', 'Hyderabad'),
(293, 'Odisha', 'Baripada', 'Hyderabad'),
(294, 'Odisha', 'Bhubaneshwar', 'Hyderabad'),
(295, 'Odisha', 'Brahmapur', 'Hyderabad'),
(296, 'Odisha', 'Cuttack', 'Hyderabad'),
(297, 'Odisha', 'Dhenkanal', 'Hyderabad'),
(298, 'Odisha', 'Kendujhar', 'Hyderabad'),
(299, 'Odisha', 'Konark', 'Hyderabad'),
(300, 'Odisha', 'Koraput', 'Hyderabad'),
(301, 'Odisha', 'Paradip', 'Hyderabad'),
(302, 'Odisha', 'Phulabani', 'Hyderabad'),
(303, 'Odisha', 'Puri', 'Hyderabad'),
(304, 'Odisha', 'Sambalpur', 'Hyderabad'),
(305, 'Odisha', 'Udayagiri', 'Hyderabad'),
(306, 'Puducherry (union territory)', 'Karaikal', 'Chennai'),
(307, 'Puducherry (union territory)', 'Mahe', 'Chennai'),
(308, 'Puducherry (union territory)', 'Puducherry', 'Chennai'),
(309, 'Puducherry (union territory)', 'Yanam', 'Chennai'),
(310, 'Punjab', 'Amritsar', 'New-Delhi'),
(311, 'Punjab', 'Batala', 'New-Delhi'),
(312, 'Punjab', 'Chandigarh', 'New-Delhi'),
(313, 'Punjab', 'Faridkot', 'New-Delhi'),
(314, 'Punjab', 'Firozpur', 'New-Delhi'),
(315, 'Punjab', 'Gurdaspur', 'New-Delhi'),
(316, 'Punjab', 'Hoshiarpur', 'New-Delhi'),
(317, 'Punjab', 'Jalandhar', 'New-Delhi'),
(318, 'Punjab', 'Kapurthala', 'New-Delhi'),
(319, 'Punjab', 'Ludhiana', 'New-Delhi'),
(320, 'Punjab', 'Nabha', 'New-Delhi'),
(321, 'Punjab', 'Patiala', 'New-Delhi'),
(322, 'Punjab', 'Rupnagar', 'New-Delhi'),
(323, 'Punjab', 'Sangrur', 'New-Delhi'),
(324, 'Rajasthan', 'Abu', 'New-Delhi'),
(325, 'Rajasthan', 'Ajmer', 'New-Delhi'),
(326, 'Rajasthan', 'Alwar', 'New-Delhi'),
(327, 'Rajasthan', 'Amer', 'New-Delhi'),
(328, 'Rajasthan', 'Barmer', 'New-Delhi'),
(329, 'Rajasthan', 'Beawar', 'New-Delhi'),
(330, 'Rajasthan', 'Bharatpur', 'New-Delhi'),
(331, 'Rajasthan', 'Bhilwara', 'New-Delhi'),
(332, 'Rajasthan', 'Bikaner', 'New-Delhi'),
(333, 'Rajasthan', 'Bundi', 'New-Delhi'),
(334, 'Rajasthan', 'Chittaurgarh', 'New-Delhi'),
(335, 'Rajasthan', 'Churu', 'New-Delhi'),
(336, 'Rajasthan', 'Dhaulpur', 'New-Delhi'),
(337, 'Rajasthan', 'Dungarpur', 'New-Delhi'),
(338, 'Rajasthan', 'Ganganagar', 'New-Delhi'),
(339, 'Rajasthan', 'Hanumangarh', 'New-Delhi'),
(340, 'Rajasthan', 'Jaipur', 'New-Delhi'),
(341, 'Rajasthan', 'Jaisalmer', 'New-Delhi'),
(342, 'Rajasthan', 'Jalor', 'New-Delhi'),
(343, 'Rajasthan', 'Jhalawar', 'New-Delhi'),
(344, 'Rajasthan', 'Jhunjhunu', 'New-Delhi'),
(345, 'Rajasthan', 'Jodhpur', 'New-Delhi'),
(346, 'Rajasthan', 'Kishangarh', 'New-Delhi'),
(347, 'Rajasthan', 'Kota', 'New-Delhi'),
(348, 'Rajasthan', 'Merta', 'New-Delhi'),
(349, 'Rajasthan', 'Nagaur', 'New-Delhi'),
(350, 'Rajasthan', 'Nathdwara', 'New-Delhi'),
(351, 'Rajasthan', 'Pali', 'New-Delhi'),
(352, 'Rajasthan', 'Phalodi', 'New-Delhi'),
(353, 'Rajasthan', 'Pushkar', 'New-Delhi'),
(354, 'Rajasthan', 'Sawai Madhopur', 'New-Delhi'),
(355, 'Rajasthan', 'Shahpura', 'New-Delhi'),
(356, 'Rajasthan', 'Sikar', 'New-Delhi'),
(357, 'Rajasthan', 'Sirohi', 'New-Delhi'),
(358, 'Rajasthan', 'Tonk', 'New-Delhi'),
(359, 'Rajasthan', 'Udaipur', 'New-Delhi'),
(360, 'Sikkim', 'Gangtok', 'New-Delhi'),
(361, 'Sikkim', 'Gyalshing', 'New-Delhi'),
(362, 'Sikkim', 'Lachung', 'New-Delhi'),
(363, 'Sikkim', 'Mangan', 'New-Delhi'),
(364, 'Tamil Nadu', 'Arcot', 'Chennai'),
(365, 'Tamil Nadu', 'Chengalpattu', 'Chennai'),
(366, 'Tamil Nadu', 'Chennai', 'Chennai'),
(367, 'Tamil Nadu', 'Chidambaram', 'Chennai'),
(368, 'Tamil Nadu', 'Coimbatore', 'Chennai'),
(369, 'Tamil Nadu', 'Cuddalore', 'Chennai'),
(370, 'Tamil Nadu', 'Dharmapuri', 'Chennai'),
(371, 'Tamil Nadu', 'Dindigul', 'Chennai'),
(372, 'Tamil Nadu', 'Erode', 'Chennai'),
(373, 'Tamil Nadu', 'Kanchipuram', 'Chennai'),
(374, 'Tamil Nadu', 'Kanniyakumari', 'Chennai'),
(375, 'Tamil Nadu', 'Kodaikanal', 'Chennai'),
(376, 'Tamil Nadu', 'Kumbakonam', 'Chennai'),
(377, 'Tamil Nadu', 'Madurai', 'Chennai'),
(378, 'Tamil Nadu', 'Mamallapuram', 'Chennai'),
(379, 'Tamil Nadu', 'Nagappattinam', 'Chennai'),
(380, 'Tamil Nadu', 'Nagercoil', 'Chennai'),
(381, 'Tamil Nadu', 'Palayamkottai', 'Chennai'),
(382, 'Tamil Nadu', 'Pudukkottai', 'Chennai'),
(383, 'Tamil Nadu', 'Rajapalayam', 'Chennai'),
(384, 'Tamil Nadu', 'Ramanathapuram', 'Chennai'),
(385, 'Tamil Nadu', 'Salem', 'Chennai'),
(386, 'Tamil Nadu', 'Thanjavur', 'Chennai'),
(387, 'Tamil Nadu', 'Tiruchchirappalli', 'Chennai'),
(388, 'Tamil Nadu', 'Tirunelveli', 'Chennai'),
(389, 'Tamil Nadu', 'Tiruppur', 'Chennai'),
(390, 'Tamil Nadu', 'Thoothukudi', 'Chennai'),
(391, 'Tamil Nadu', 'Udhagamandalam', 'Chennai'),
(392, 'Tamil Nadu', 'Vellore', 'Chennai'),
(393, 'Telangana', 'Hyderabad', 'Hyderabad'),
(394, 'Telangana', 'Karimnagar', 'Hyderabad'),
(395, 'Telangana', 'Khammam', 'Hyderabad'),
(396, 'Telangana', 'Mahbubnagar', 'Hyderabad'),
(397, 'Telangana', 'Nizamabad', 'Hyderabad'),
(398, 'Telangana', 'Sangareddi', 'Hyderabad'),
(399, 'Telangana', 'Warangal', 'Hyderabad'),
(400, 'Tripura', 'Agartala', 'New-Delhi'),
(401, 'Uttar Pradesh', 'Agra', 'New-Delhi'),
(402, 'Uttar Pradesh', 'Aligarh', 'New-Delhi'),
(403, 'Uttar Pradesh', 'Amroha', 'New-Delhi'),
(404, 'Uttar Pradesh', 'Ayodhya', 'New-Delhi'),
(405, 'Uttar Pradesh', 'Azamgarh', 'New-Delhi'),
(406, 'Uttar Pradesh', 'Bahraich', 'New-Delhi'),
(407, 'Uttar Pradesh', 'Ballia', 'New-Delhi'),
(408, 'Uttar Pradesh', 'Banda', 'New-Delhi'),
(409, 'Uttar Pradesh', 'Bara Banki', 'New-Delhi'),
(410, 'Uttar Pradesh', 'Bareilly', 'New-Delhi'),
(411, 'Uttar Pradesh', 'Basti', 'New-Delhi'),
(412, 'Uttar Pradesh', 'Bijnor', 'New-Delhi'),
(413, 'Uttar Pradesh', 'Bithur', 'New-Delhi'),
(414, 'Uttar Pradesh', 'Budaun', 'New-Delhi'),
(415, 'Uttar Pradesh', 'Bulandshahr', 'New-Delhi'),
(416, 'Uttar Pradesh', 'Deoria', 'New-Delhi'),
(417, 'Uttar Pradesh', 'Etah', 'New-Delhi'),
(418, 'Uttar Pradesh', 'Etawah', 'New-Delhi'),
(419, 'Uttar Pradesh', 'Faizabad', 'New-Delhi'),
(420, 'Uttar Pradesh', 'Farrukhabad-cum-Fatehgarh', 'New-Delhi'),
(421, 'Uttar Pradesh', 'Fatehpur', 'New-Delhi'),
(422, 'Uttar Pradesh', 'Fatehpur Sikri', 'New-Delhi'),
(423, 'Uttar Pradesh', 'Ghaziabad', 'New-Delhi'),
(424, 'Uttar Pradesh', 'Ghazipur', 'New-Delhi'),
(425, 'Uttar Pradesh', 'Gonda', 'New-Delhi'),
(426, 'Uttar Pradesh', 'Gorakhpur', 'New-Delhi'),
(427, 'Uttar Pradesh', 'Hamirpur', 'New-Delhi'),
(428, 'Uttar Pradesh', 'Hardoi', 'New-Delhi'),
(429, 'Uttar Pradesh', 'Hathras', 'New-Delhi'),
(430, 'Uttar Pradesh', 'Jalaun', 'New-Delhi'),
(431, 'Uttar Pradesh', 'Jaunpur', 'New-Delhi'),
(432, 'Uttar Pradesh', 'Jhansi', 'New-Delhi'),
(433, 'Uttar Pradesh', 'Kannauj', 'New-Delhi'),
(434, 'Uttar Pradesh', 'Kanpur', 'New-Delhi'),
(435, 'Uttar Pradesh', 'Lakhimpur', 'New-Delhi'),
(436, 'Uttar Pradesh', 'Lalitpur', 'New-Delhi'),
(437, 'Uttar Pradesh', 'Lucknow', 'New-Delhi'),
(438, 'Uttar Pradesh', 'Mainpuri', 'New-Delhi'),
(439, 'Uttar Pradesh', 'Mathura', 'New-Delhi'),
(440, 'Uttar Pradesh', 'Meerut', 'New-Delhi'),
(441, 'Uttar Pradesh', 'Mirzapur-Vindhyachal', 'New-Delhi'),
(442, 'Uttar Pradesh', 'Moradabad', 'New-Delhi'),
(443, 'Uttar Pradesh', 'Muzaffarnagar', 'New-Delhi'),
(444, 'Uttar Pradesh', 'Partapgarh', 'New-Delhi'),
(445, 'Uttar Pradesh', 'Pilibhit', 'New-Delhi'),
(446, 'Uttar Pradesh', 'Prayagraj', 'New-Delhi'),
(447, 'Uttar Pradesh', 'Rae Bareli', 'New-Delhi'),
(448, 'Uttar Pradesh', 'Rampur', 'New-Delhi'),
(449, 'Uttar Pradesh', 'Saharanpur', 'New-Delhi'),
(450, 'Uttar Pradesh', 'Sambhal', 'New-Delhi'),
(451, 'Uttar Pradesh', 'Shahjahanpur', 'New-Delhi'),
(452, 'Uttar Pradesh', 'Sitapur', 'New-Delhi'),
(453, 'Uttar Pradesh', 'Sultanpur', 'New-Delhi'),
(454, 'Uttar Pradesh', 'Tehri', 'New-Delhi'),
(455, 'Uttar Pradesh', 'Varanasi', 'New-Delhi'),
(456, 'Uttarakhand', 'Almora', 'New-Delhi'),
(457, 'Uttarakhand', 'Dehra Dun', 'New-Delhi'),
(458, 'Uttarakhand', 'Haridwar', 'New-Delhi'),
(459, 'Uttarakhand', 'Mussoorie', 'New-Delhi'),
(460, 'Uttarakhand', 'Nainital', 'New-Delhi'),
(461, 'Uttarakhand', 'Pithoragarh', 'New-Delhi'),
(462, 'West Bengal', 'Alipore', 'Tamluk'),
(463, 'West Bengal', 'Alipur Duar', 'Tamluk'),
(464, 'West Bengal', 'Asansol', 'Tamluk'),
(465, 'West Bengal', 'Baharampur', 'Tamluk'),
(466, 'West Bengal', 'Bally', 'Tamluk'),
(467, 'West Bengal', 'Balurghat', 'Tamluk'),
(468, 'West Bengal', 'Bankura', 'Tamluk'),
(469, 'West Bengal', 'Baranagar', 'Tamluk'),
(470, 'West Bengal', 'Barasat', 'Tamluk'),
(471, 'West Bengal', 'Barrackpore', 'Tamluk'),
(472, 'West Bengal', 'Basirhat', 'Tamluk'),
(473, 'West Bengal', 'Bhatpara', 'Tamluk'),
(474, 'West Bengal', 'Bishnupur', 'Tamluk'),
(475, 'West Bengal', 'Budge Budge', 'Tamluk'),
(476, 'West Bengal', 'Burdwan', 'Tamluk'),
(477, 'West Bengal', 'Chandernagore', 'Tamluk'),
(478, 'West Bengal', 'Darjeeling', 'Tamluk'),
(479, 'West Bengal', 'Diamond Harbour', 'Tamluk'),
(480, 'West Bengal', 'Dum Dum', 'Tamluk'),
(481, 'West Bengal', 'Durgapur', 'Tamluk'),
(482, 'West Bengal', 'Haldia', 'Tamluk'),
(483, 'West Bengal', 'Halisahar', 'Tamluk'),
(484, 'West Bengal', 'Haora', 'Tamluk'),
(485, 'West Bengal', 'Hugli', 'Tamluk'),
(486, 'West Bengal', 'Ingraj Bazar', 'Tamluk'),
(487, 'West Bengal', 'Jalpaiguri', 'Tamluk'),
(488, 'West Bengal', 'Kalimpong', 'Tamluk'),
(489, 'West Bengal', 'Kamarhati', 'Tamluk'),
(490, 'West Bengal', 'Kanchrapara', 'Tamluk'),
(491, 'West Bengal', 'Kharagpur', 'Tamluk'),
(492, 'West Bengal', 'Cooch Behar', 'Tamluk'),
(493, 'West Bengal', 'Kolkata', 'Tamluk'),
(494, 'West Bengal', 'Krishnanagar', 'Tamluk'),
(495, 'West Bengal', 'Malda', 'Tamluk'),
(496, 'West Bengal', 'Midnapore', 'Tamluk'),
(497, 'West Bengal', 'Murshidabad', 'Tamluk'),
(498, 'West Bengal', 'Nabadwip', 'Tamluk'),
(499, 'West Bengal', 'Palashi', 'Tamluk'),
(500, 'West Bengal', 'Panihati', 'Tamluk'),
(501, 'West Bengal', 'Purulia', 'Tamluk'),
(502, 'West Bengal', 'Raiganj', 'Tamluk'),
(503, 'West Bengal', 'Santipur', 'Tamluk'),
(504, 'West Bengal', 'Shantiniketan', 'Tamluk'),
(505, 'West Bengal', 'Shrirampur', 'Tamluk'),
(506, 'West Bengal', 'Siliguri', 'Tamluk'),
(507, 'West Bengal', 'Siuri', 'Tamluk'),
(508, 'West Bengal', 'Tamluk', 'Tamluk'),
(509, 'West Bengal', 'Titagarh', 'Tamluk');

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

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `invoice_number` varchar(50) NOT NULL,
  `pdf_path` varchar(255) DEFAULT NULL,
  `status` enum('Generated','Sent','Paid') DEFAULT 'Generated',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `mail_templates`
--

CREATE TABLE `mail_templates` (
  `id` int(11) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mail_templates`
--

INSERT INTO `mail_templates` (`id`, `slug`, `subject`, `body`, `created_at`, `updated_at`) VALUES
(1, 'welcome_user', 'Welcome to Smart Digital', '<p>Hi {{name}},</p><p>Welcome to Smart Digital. Thank you for registering. Your wallet has been credited with ₹10.</p><p>Regards,<br/>Smart Digital</p>', '2026-06-07 06:31:55', NULL);

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

--
-- Table structure for table `newsletter`
--

CREATE TABLE `newsletter` (
  `id` int(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `status` enum('Subscribed','Unsubscribed') DEFAULT 'Subscribed',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `title` varchar(150) NOT NULL,
  `message` text 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`, `title`, `message`, `is_read`, `created_at`) VALUES
(1, 2, 'Welcome via Google!', 'Thank you for joining Smart Digital with Google. We have credited ₹10.00 welcome bonus to your account wallet!', 0, '2026-06-07 06:32:30'),
(2, 3, 'Welcome via Google!', 'Thank you for joining Smart Digital with Google. We have credited ₹10.00 welcome bonus to your account wallet!', 0, '2026-06-07 07:55:51'),
(3, 3, 'Order Received Successfully', 'Your printing order PR-D2AF0D5D has been received. Our preflight labs are preparing to verify your artwork file.', 0, '2026-06-07 07:57:56'),
(4, 3, 'Fulfillment Update: Order Delivered', 'Your printing order #PR-D2AF0D5D has transitioned to: Delivered. Tracking reference ID: 456464hujg.', 0, '2026-06-08 04:33:40'),
(5, 3, 'Fulfillment Update: Order Cancelled', 'Your printing order #PR-D2AF0D5D has transitioned to: Cancelled. Tracking reference ID: 456464hujg.', 0, '2026-06-08 04:33:47'),
(6, 3, 'Shipping Routed (Simulated): Order PR-D2AF0D5D', 'Your printing order has been synchronized with our mock logistics channel. Shipment Reference: SIM_SHIP_21774274. Tracking Code: AWB3933759920.', 0, '2026-06-08 09:12:34'),
(7, 3, 'Order Received Successfully', 'Your printing order PR-1F5766B5 has been received. Our preflight labs are preparing to verify your artwork file.', 0, '2026-06-08 09:40:23'),
(8, 3, 'Order Received Successfully', 'Your printing order PR-D387D2C7 has been received. Our preflight labs are preparing to verify your artwork file.', 0, '2026-06-08 09:42:12'),
(9, 3, 'Shipping Routed: Order PR-D387D2C7', 'Your printing order has been synchronized with our logistics channel. Shipment Reference: 1384384039.', 0, '2026-06-08 09:46:48'),
(10, 3, 'Shipping Routed: Order PR-1F5766B5', 'Your printing order has been synchronized with our logistics channel. Shipment Reference: 1384392017.', 0, '2026-06-08 09:51:12'),
(11, 1, 'Order Received Successfully', 'Your printing order PR-DA8791AF has been received. Our preflight labs are preparing to verify your artwork file.', 0, '2026-06-09 07:32:30'),
(12, 1, 'Order Received Successfully', 'Your printing order PR-2955CA12 has been received. Our preflight labs are preparing to verify your artwork file.', 0, '2026-06-09 07:33:06'),
(13, 1, 'Order Received Successfully', 'Your printing order PR-EC6D264C has been received. Our preflight labs are preparing to verify your artwork file.', 0, '2026-06-09 07:36:36'),
(14, 1, 'Order Received Successfully', 'Your printing order PR-09364E93 has been received. Our preflight labs are preparing to verify your artwork file.', 0, '2026-06-09 07:42:37'),
(15, 1, 'Order Received Successfully', 'Your printing order PR-158088AD has been received. Our preflight labs are preparing to verify your artwork file.', 0, '2026-06-09 07:48:52'),
(16, 1, 'Order Received Successfully', 'Your printing order PR-1918871C has been received. Our preflight labs are preparing to verify your artwork file.', 0, '2026-06-09 07:50:44'),
(17, 1, 'Order Received Successfully', 'Your printing order PR-CB4B7A87 has been received. Our preflight labs are preparing to verify your artwork file.', 0, '2026-06-09 07:53:05');

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

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

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `order_number` varchar(50) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `address_name` varchar(100) NOT NULL,
  `address_mobile` varchar(20) NOT NULL,
  `address_line1` varchar(255) NOT NULL,
  `address_line2` varchar(255) DEFAULT NULL,
  `address_city` varchar(100) NOT NULL,
  `address_state` varchar(100) NOT NULL,
  `address_pincode` varchar(10) NOT NULL,
  `coupon_id` int(11) DEFAULT NULL,
  `total_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `discount_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `tax_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `delivery_charge` decimal(10,2) NOT NULL DEFAULT 0.00,
  `net_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `payment_status` enum('Pending','Paid','Failed') DEFAULT 'Pending',
  `order_status` enum('Pending','Received','Processing','Printing','Shipped','Delivered','Cancelled') DEFAULT 'Pending',
  `tracking_number` varchar(100) DEFAULT NULL,
  `special_instructions` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `delivery_type` varchar(50) DEFAULT 'standard',
  `delivery_distance` decimal(10,2) DEFAULT 0.00,
  `shipping_type` varchar(50) DEFAULT 'Standard',
  `shipping_min_days` int(11) DEFAULT 5,
  `shipping_max_days` int(11) DEFAULT 8,
  `shiprocket_order_id` varchar(100) DEFAULT NULL,
  `shiprocket_shipment_id` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `orders` (`id`, `order_number`, `user_id`, `address_name`, `address_mobile`, `address_line1`, `address_line2`, `address_city`, `address_state`, `address_pincode`, `coupon_id`, `total_amount`, `discount_amount`, `tax_amount`, `delivery_charge`, `net_amount`, `payment_status`, `order_status`, `tracking_number`, `special_instructions`, `created_at`, `delivery_type`, `delivery_distance`, `shipping_type`, `shipping_min_days`, `shipping_max_days`, `shiprocket_order_id`, `shiprocket_shipment_id`) VALUES
(18, 'PR-793EE162', NULL, 'Rekha Makar', '09749926952', 'Kalayanpur', 'Kalyanpur', 'Purba Medinipur', 'West Bengal', '721632', NULL, 114.00, 0.00, 20.52, 100.00, 234.52, 'Pending', 'Pending', NULL, 'dfg', '2026-06-09 07:59:53', 'standard', 0.00, 'Standard', 5, 8, NULL, NULL);

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

--
-- 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) DEFAULT NULL,
  `product_name` varchar(150) NOT NULL,
  `quantity` int(11) NOT NULL,
  `paper_type` varchar(100) DEFAULT NULL,
  `size` varchar(100) DEFAULT NULL,
  `finish` varchar(100) DEFAULT NULL,
  `design_file` varchar(255) DEFAULT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `subtotal` decimal(10,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `product_name`, `quantity`, `paper_type`, `size`, `finish`, `design_file`, `price`, `subtotal`, `created_at`) VALUES
(10, 18, 5, 'Self-Adhesive Labels & Stickers', 100, 'Glossy Sticker Paper', 'Circle 2-inch', 'Gloss Lamination', 'uploads/print-product/temp/temp_6a27c20ada92b_smartdigital.png', 1.14, 114.00, '2026-06-09 07:59:53');

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

--
-- Table structure for table `order_item_options`
--

CREATE TABLE `order_item_options` (
  `id` int(11) NOT NULL,
  `order_item_id` int(11) NOT NULL,
  `group_id` int(11) DEFAULT NULL,
  `option_id` int(11) DEFAULT NULL,
  `group_name` varchar(100) NOT NULL,
  `option_name` varchar(100) NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `order_item_options`
--

INSERT INTO `order_item_options` (`id`, `order_item_id`, `group_id`, `option_id`, `group_name`, `option_name`, `price`) VALUES
(25, 10, 10, 24, 'Material/Paper Type', 'Glossy Sticker Paper', 1.20),
(26, 10, 11, 27, 'Size/Dimension', 'Circle 2-inch', 0.00),
(27, 10, 12, 30, 'Finish/Coating', 'Gloss Lamination', 0.00);

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `content` text DEFAULT NULL,
  `meta_title` varchar(150) DEFAULT NULL,
  `meta_desc` text DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `title`, `slug`, `content`, `meta_title`, `meta_desc`, `updated_at`) VALUES
(1, 'About Us', 'about', '<p>Welcome to Smart Digital. We print awesome graphics.</p>', 'About Smart Digital | Tamluk', 'Read our history and corporate graphics credentials.', '2026-06-07 07:22:42'),
(2, 'Contact Us', 'contact', '<p>Visit ourTamulok store or mail support@smartdigital.com</p>', 'Contact Customer Care | Smart Press', 'Get in touch with customer care coordinators today.', '2026-06-07 07:22:42'),
(3, 'Privacy Policy', 'privacy', '<p>We protect admin and client credentials securely.</p>', 'Smart Press Privacy Protections', 'Read how we protect client vectors and transactions.', '2026-06-07 07:22:42');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `id` int(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `token` varchar(255) NOT NULL,
  `expires_at` datetime NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `payment_number` varchar(50) NOT NULL,
  `transaction_id` varchar(100) DEFAULT NULL,
  `gateway` varchar(50) DEFAULT 'Razorpay',
  `amount` decimal(10,2) NOT NULL,
  `status` enum('Pending','Successful','Failed') DEFAULT 'Pending',
  `details` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `subcategory_id` int(11) DEFAULT NULL,
  `name` varchar(150) NOT NULL,
  `slug` varchar(150) NOT NULL,
  `description` text DEFAULT NULL,
  `specifications` text DEFAULT NULL,
  `mrp` decimal(10,2) NOT NULL DEFAULT 0.00,
  `base_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `paper_options` varchar(255) DEFAULT NULL,
  `size_options` varchar(255) DEFAULT NULL,
  `quantity_options` varchar(255) DEFAULT NULL,
  `finish_options` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `is_popular` tinyint(1) DEFAULT 0,
  `tag` varchar(50) DEFAULT NULL,
  `seo_title` varchar(150) DEFAULT NULL,
  `seo_description` text DEFAULT NULL,
  `features_benefits` text DEFAULT NULL,
  `branding_guidelines` text DEFAULT NULL,
  `care_instructions` text DEFAULT NULL,
  `color_options` text DEFAULT NULL,
  `print_location_options` text DEFAULT NULL,
  `print_size_options` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `is_sample` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `products` (`id`, `category_id`, `subcategory_id`, `name`, `slug`, `description`, `specifications`, `mrp`, `base_price`, `paper_options`, `size_options`, `quantity_options`, `finish_options`, `image`, `is_popular`, `tag`, `seo_title`, `seo_description`, `features_benefits`, `branding_guidelines`, `care_instructions`, `color_options`, `print_location_options`, `print_size_options`, `created_at`, `is_sample`) VALUES
(1, 1, NULL, 'Premium Business Cards', 'premium-business-cards', 'High-quality visiting cards custom-made with choice of finishes and premium paper quality.', 'Paper: 300GSM Standard, 350GSM Premium, Matte Texture | Size: Standard (3.5x2 inch), Rounded Corners | Options: Double Sided, Spot UV', 5.00, 2.50, 'Standard 300GSM, Premium 350GSM, Matte Texture', 'Standard (3.5x2 inch), Rounded Corner, Square', '100, 200, 500, 1000', 'No Lamination, Gloss Lamination, Matte Lamination, Spot UV', 'uploads/products/premium-business-cards.jpg', 1, '4 Hrs Del.', 'Order Premium Custom Business Cards Online | Smart Digital', 'Create the perfect business impression with premium custom printed business cards in matte, glossy or spot-UV finish.', 'Supreme Finish Quality: Matte, gloss, and spot-UV options.|Robust Card Stock: Heavy 350GSM standard for rigid durability.|Bleed Margin Protection: 2mm bleed guidelines are actively audited.|Double-Sided Graphics: Print on both sides with zero color bleed.', 'Vector Mode: Set artwork files to standard 300 DPI resolution.|Color Profile: Work in CMYK workspace (RGB files will be auto-converted).|Border Safety: Keep critical text at least 3mm away from card edge lines.', 'Storage Mode: Avoid prolonged exposure to direct sunlight and moisture.|Temperature details: Store inside standard cards holder sleeves.', NULL, NULL, NULL, '2026-06-07 06:31:55', 0),
(2, 2, NULL, 'Premium Trifold Flyers', 'trifold-flyers', 'A perfect multi-page brochure layout to tell your company story or present products vividly.', 'Paper: 170GSM Glossy Art Paper, 220GSM Premium Matte | Size: A4 Folded, A5 Folded | Options: Tri-Fold, Bi-Fold', 15.00, 8.00, 'Dynamic Relational', 'Dynamic Relational', '50, 100, 250, 500, 1000', 'Dynamic Relational', 'uploads/products/trifold-flyers.jpg', 1, 'Best Seller', 'Custom Trifold Flyer & Pamphlet Printing Services', 'Order high-quality tri-fold and bi-fold flyers. Professional grade brochure prints delivered straight to your door.', 'Vibrant Art Paper: 170GSM and 220GSM options for premium texture.|Double Sided: Excellent crispness for folded brochures.|Machine Trimming: High-accuracy crease folding avoids cracking.', 'High Resolution: Minimum 300 DPI resolution required.|Folding Margins: Keep important layout text inside panel boundaries.|CMYK Standard: Ensure design colors match offset lithography profiles.', 'Keeping Standard: Keep in dry, shaded rooms.|Cleanliness: Wipe dust away using clean dry microfiber rags.', NULL, NULL, NULL, '2026-06-07 06:31:55', 0),
(4, 4, NULL, 'Custom Ceramic Mug', 'custom-ceramic-mug', 'Perfect personal and corporate promotional gift. Features vibrant sublimation prints.', 'Material: Premium Ceramic | Capacity: 325ml | Color: Classic White, Inner Color, Magic Mug (Heat-Sensitive)', 249.00, 120.00, 'Standard White Ceramic, Inner Dual Color Ceramic, Premium Heat Magic Mug', 'Standard 325ml Capacity', '1, 5, 10, 50, 100', 'Vibrant Sublimation Gloss Finish', 'uploads/products/custom-ceramic-mug.jpg', 1, 'New', 'Order Personalized Photo Mugs & Magic Mugs Online', 'Vivid sublimation printed ceramic coffee mugs. Magic mugs that reveal designs with hot tea or coffee.', 'Lead-Free Clay: Food-grade premium ceramic construction.|Magic Heat Reveal: Heat-sensitive thermochromic coating (Magic Mug).|Vivid Sublimation: Edge-to-edge sublimation with glossy finish.|Microwave Safe: Durable construction handles standard heating.', 'Wrap Canvas: 8.5 in x 3.7 in safe wrapping bleed parameters.|Dynamic Ink: Minimum 300 DPI layout file for crisp photo outputs.|Transparent Background: Use transparent backgrounds for white ceramic mugs.', 'Washing standard: Hand wash with mild detergents. Do not scrub graphics.|Machine Wash: Standard dishwasher safe, but hand washing is recommended.', NULL, NULL, NULL, '2026-06-07 06:31:55', 0),
(5, 5, NULL, 'Self-Adhesive Labels & Stickers', 'custom-stickers', 'Durable self-adhesive labels for products, packaging boxes, and promotions.', 'Material: Glossy Paper, Waterproof Vinyl | Cut: Circle, Square, Custom Die-Cut | Options: Sheet Form, Roll Form', 2.50, 1.20, 'Glossy Sticker Paper, Matte Sticker Paper, Waterproof Premium Vinyl', 'Circle 2-inch, Square 2-inch, Custom Die-Cut', '100, 500, 1000, 5000', 'Gloss Lamination, Matte Scratch-Resistant Coating, Uncoated Matte', 'uploads/products/custom-stickers.jpg', 0, 'Best Seller', 'Custom Stickers and Product Label Printing Online', 'Order durable die-cut circular or square stickers and waterproof vinyl product labels for packaging branding.', 'Waterproof Vinyl: Waterproof and weather-resistant backing standard.|Precise Cuts: Computerized contour cutting for circle and custom stickers.|Heavy Adhesion: Surface lock adhesive works on plastic, glass, and wood.|UV Protective: Lamination coat protects against scratching and fading.', 'Vector Cut Path: Highlight outer cutting paths with standard magenta colors.|DPI standard: Minimum 300 DPI artwork; vector AI/PDF files preferred.', 'Application details: Clean surface before pasting. Avoid dust particles.|Removal guidance: Peel off gently to avoid leaving heavy glue residues.', NULL, NULL, NULL, '2026-06-07 06:31:55', 0),
(7, 6, NULL, 'Flat Mailer Boxes Samples', 'flat-mailer-boxes-samples', 'High-quality, pre-printed physical sample of Flat Mailer Boxes Samples to inspect material quality, thickness, and standard print finish before bulk ordering.', 'Quantity: 1 piece | Material: Standard Showcased Material | Quality Check: Standard Color Proof', 95.00, 95.00, NULL, NULL, '1 piece', NULL, 'https://placehold.co/400x300/e2e8f0/64748b?text=Mailer+Boxes', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-09 05:58:02', 1),
(8, 6, NULL, 'Paper Bag Samples', 'paper-bag-samples', 'High-quality, pre-printed physical sample of Paper Bag Samples to inspect material quality, thickness, and standard print finish before bulk ordering.', 'Quantity: 1 piece | Material: Standard Showcased Material | Quality Check: Standard Color Proof', 188.00, 188.00, NULL, NULL, '1 piece', NULL, 'https://placehold.co/400x300/e2e8f0/64748b?text=Paper+Bags', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-09 05:58:02', 1),
(9, 6, NULL, 'Tote Bag Samples', 'tote-bag-samples', 'High-quality, pre-printed physical sample of Tote Bag Samples to inspect material quality, thickness, and standard print finish before bulk ordering.', 'Quantity: 1 piece | Material: Standard Showcased Material | Quality Check: Standard Color Proof', 167.00, 167.00, NULL, NULL, '1 piece', NULL, 'https://placehold.co/400x300/e2e8f0/64748b?text=Tote+Bags', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-09 05:58:02', 1),
(10, 6, NULL, 'Cotton Carry Bag Samples', 'cotton-carry-bag-samples', 'High-quality, pre-printed physical sample of Cotton Carry Bag Samples to inspect material quality, thickness, and standard print finish before bulk ordering.', 'Quantity: 1 piece | Material: Standard Showcased Material | Quality Check: Standard Color Proof', 151.00, 151.00, NULL, NULL, '1 piece', NULL, 'https://placehold.co/400x300/e2e8f0/64748b?text=Cotton+Bags', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-09 05:58:02', 1),
(11, 6, NULL, 'Courier Poly Bag Samples', 'courier-poly-bag-samples', 'High-quality, pre-printed physical sample of Courier Poly Bag Samples to inspect material quality, thickness, and standard print finish before bulk ordering.', 'Quantity: 1 piece | Material: Standard Showcased Material | Quality Check: Standard Color Proof', 63.00, 63.00, NULL, NULL, '1 piece', NULL, 'https://placehold.co/400x300/e2e8f0/64748b?text=Poly+Bags', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-09 05:58:02', 1),
(12, 6, NULL, 'Packaging Sleeve Samples', 'packaging-sleeve-samples', 'High-quality, pre-printed physical sample of Packaging Sleeve Samples to inspect material quality, thickness, and standard print finish before bulk ordering.', 'Quantity: 1 piece | Material: Standard Showcased Material | Quality Check: Standard Color Proof', 82.00, 82.00, NULL, NULL, '1 piece', NULL, 'https://placehold.co/400x300/e2e8f0/64748b?text=Sleeves', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-09 05:58:02', 1),
(13, 6, NULL, 'Kraft Envelope Samples', 'kraft-envelope-samples', 'High-quality, pre-printed physical sample of Kraft Envelope Samples to inspect material quality, thickness, and standard print finish before bulk ordering.', 'Quantity: 1 piece | Material: Standard Showcased Material | Quality Check: Standard Color Proof', 69.00, 69.00, NULL, NULL, '1 piece', NULL, 'https://placehold.co/400x300/e2e8f0/64748b?text=Envelopes', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-09 05:58:02', 1),
(14, 6, NULL, 'Hang Tag Samples', 'hang-tag-samples', 'High-quality, pre-printed physical sample of Hang Tag Samples to inspect material quality, thickness, and standard print finish before bulk ordering.', 'Quantity: 1 piece | Material: Standard Showcased Material | Quality Check: Standard Color Proof', 95.00, 95.00, NULL, NULL, '1 piece', NULL, 'https://placehold.co/400x300/e2e8f0/64748b?text=Hang+Tags', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-09 05:58:02', 1),
(15, 6, NULL, 'Packing Tape Samples', 'packing-tape-samples', 'High-quality, pre-printed physical sample of Packing Tape Samples to inspect material quality, thickness, and standard print finish before bulk ordering.', 'Quantity: 1 piece | Material: Standard Showcased Material | Quality Check: Standard Color Proof', 101.00, 101.00, NULL, NULL, '1 piece', NULL, 'https://placehold.co/400x300/e2e8f0/64748b?text=Packing+Tape', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-09 05:58:02', 1),
(16, 6, NULL, 'Sticker Samples', 'sticker-samples', 'High-quality, pre-printed physical sample of Sticker Samples to inspect material quality, thickness, and standard print finish before bulk ordering.', 'Quantity: 1 piece | Material: Standard Showcased Material | Quality Check: Standard Color Proof', 113.00, 113.00, NULL, NULL, '1 piece', NULL, 'https://placehold.co/400x300/e2e8f0/64748b?text=Stickers', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-09 05:58:02', 1),
(17, 6, NULL, 'Paper Pouch Samples', 'paper-pouch-samples', 'High-quality, pre-printed physical sample of Paper Pouch Samples to inspect material quality, thickness, and standard print finish before bulk ordering.', 'Quantity: 1 piece | Material: Standard Showcased Material | Quality Check: Standard Color Proof', 82.00, 82.00, NULL, NULL, '1 piece', NULL, 'https://placehold.co/400x300/e2e8f0/64748b?text=Paper+Pouches', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-09 05:58:02', 1),
(18, 6, NULL, 'Food & Cake Box Samples', 'food-cake-box-samples', 'High-quality, pre-printed physical sample of Food & Cake Box Samples to inspect material quality, thickness, and standard print finish before bulk ordering.', 'Quantity: 1 piece | Material: Standard Showcased Material | Quality Check: Standard Color Proof', 220.00, 220.00, NULL, NULL, '1 piece', NULL, 'https://placehold.co/400x300/e2e8f0/64748b?text=Food+Boxes', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-09 05:58:02', 1),
(19, 6, NULL, 'Label Samples', 'label-samples', 'High-quality, pre-printed physical sample of Label Samples to inspect material quality, thickness, and standard print finish before bulk ordering.', 'Quantity: 1 piece | Material: Standard Showcased Material | Quality Check: Standard Color Proof', 126.00, 126.00, 'Dynamic Relational', 'Dynamic Relational', '1 piece', 'Dynamic Relational', 'uploads/products/prod_sample_1780986078_2119.jpeg', 0, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-09 05:58:02', 1);

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

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

CREATE TABLE `product_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` enum('Active','Inactive') DEFAULT 'Active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `product_categories` (`id`, `name`, `slug`, `image`, `description`, `status`, `created_at`) VALUES
(1, 'Business Stationery', 'business-stationery', 'uploads/categories/business-stationery.jpg', 'Stationery items for everyday corporate functions.', 'Active', '2026-06-07 06:31:55'),
(2, 'Marketing Materials', 'marketing-materials', 'uploads/categories/marketing-materials.jpg', 'Flyers, brochures, and dynamic promotional tools.', 'Active', '2026-06-07 06:31:55'),
(3, 'Custom Apparel', 'custom-apparel', 'uploads/categories/custom-apparel.jpg', 'High quality t-shirts, sweatshirts and sports jerseys.', 'Active', '2026-06-07 06:31:55'),
(4, 'Corporate Gifts', 'corporate-gifts', 'uploads/categories/corporate-gifts.jpg', 'Premium mugs, diaries, and executive pen sets.', 'Active', '2026-06-07 06:31:55'),
(5, 'Packaging & Stickers', 'packaging-stickers', 'uploads/categories/packaging-stickers.jpg', 'Stickers, product labels, and custom shipping boxes.', 'Active', '2026-06-07 06:31:55'),
(6, 'Sample Kits', 'sample-kits', 'uploads/categories/sample-kits.jpg', 'Evaluate print and material quality with our pre-printed sample packs.', 'Active', '2026-06-09 05:58:02');

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

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

CREATE TABLE `product_images` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `image_path` 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 `product_images`
--

INSERT INTO `product_images` (`id`, `product_id`, `image_path`, `created_at`) VALUES
(1, 1, 'uploads/products/premium-business-cards.jpg', '2026-06-07 06:31:55'),
(2, 1, 'https://images.unsplash.com/photo-1542744094-3a31f103e35f?q=80&w=600', '2026-06-07 06:31:55'),
(3, 1, 'https://images.unsplash.com/photo-1586075010923-2dd4570fb338?q=80&w=600', '2026-06-07 06:31:55'),
(4, 2, 'uploads/products/trifold-flyers.jpg', '2026-06-07 06:31:55'),
(5, 2, 'https://images.unsplash.com/photo-1561070791-26c113006238?q=80&w=600', '2026-06-07 06:31:55'),
(6, 2, 'https://images.unsplash.com/photo-1531403009284-440f080d1e12?q=80&w=600', '2026-06-07 06:31:55'),
(10, 4, 'uploads/products/custom-ceramic-mug.jpg', '2026-06-07 06:31:55'),
(11, 4, 'https://images.unsplash.com/photo-1514228742587-6b1558fcca3d?q=80&w=600', '2026-06-07 06:31:55'),
(12, 4, 'https://images.unsplash.com/photo-1576092768241-dec231879fc3?q=80&w=600', '2026-06-07 06:31:55'),
(13, 5, 'uploads/products/custom-stickers.jpg', '2026-06-07 06:31:55'),
(14, 5, 'https://images.unsplash.com/photo-1589939705384-5185137a7f0f?q=80&w=600', '2026-06-07 06:31:55'),
(15, 5, 'https://images.unsplash.com/photo-1626785774573-4b799315345d?q=80&w=600', '2026-06-07 06:31:55');

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

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

CREATE TABLE `product_options` (
  `id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `option_name` varchar(100) NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `is_default` tinyint(1) DEFAULT 0,
  `sort_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `image` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `product_options` (`id`, `group_id`, `option_name`, `price`, `is_default`, `sort_order`, `created_at`, `image`) VALUES
(1, 1, 'Standard 300GSM', 2.50, 1, 0, '2026-06-08 04:55:09', NULL),
(2, 1, 'Premium 350GSM', 10.00, 0, 1, '2026-06-08 04:55:09', NULL),
(3, 1, 'Matte Texture', 20.00, 0, 2, '2026-06-08 04:55:09', NULL),
(4, 2, 'Standard (3.5x2 inch)', 0.00, 1, 0, '2026-06-08 04:55:09', NULL),
(5, 2, 'Rounded Corner', 5.00, 0, 1, '2026-06-08 04:55:09', NULL),
(6, 2, 'Square', 10.00, 0, 2, '2026-06-08 04:55:09', NULL),
(7, 3, 'No Lamination', 0.00, 1, 0, '2026-06-08 04:55:09', NULL),
(8, 3, 'Gloss Lamination', 5.00, 0, 1, '2026-06-08 04:55:09', NULL),
(9, 3, 'Matte Lamination', 10.00, 0, 2, '2026-06-08 04:55:09', NULL),
(10, 3, 'Spot UV', 25.00, 0, 3, '2026-06-08 04:55:09', NULL),
(11, 4, '130GSM Budget', 8.00, 1, 0, '2026-06-08 04:55:09', ''),
(12, 4, '170GSM Standard Gloss', 5.00, 0, 1, '2026-06-08 04:55:09', ''),
(13, 4, '220GSM Luxury Matte', 20.00, 0, 2, '2026-06-08 04:55:09', ''),
(14, 5, 'A4 Folded to DL', 0.00, 1, 0, '2026-06-08 04:55:09', ''),
(15, 5, 'A4 Folded to A5', 5.00, 0, 1, '2026-06-08 04:55:09', ''),
(16, 6, 'No Lamination', 0.00, 1, 0, '2026-06-08 04:55:09', ''),
(17, 6, 'Soft Gloss Coating', 5.00, 0, 1, '2026-06-08 04:55:09', ''),
(18, 6, 'Matte Finish', 10.00, 0, 2, '2026-06-08 04:55:09', ''),
(19, 7, 'Standard White Ceramic', 120.00, 1, 0, '2026-06-08 04:55:09', NULL),
(20, 7, 'Inner Dual Color Ceramic', 5.00, 0, 1, '2026-06-08 04:55:09', NULL),
(21, 7, 'Premium Heat Magic Mug', 10.00, 0, 2, '2026-06-08 04:55:09', NULL),
(22, 8, 'Standard 325ml Capacity', 0.00, 1, 0, '2026-06-08 04:55:09', NULL),
(23, 9, 'Vibrant Sublimation Gloss Finish', 0.00, 1, 0, '2026-06-08 04:55:09', NULL),
(24, 10, 'Glossy Sticker Paper', 1.20, 1, 0, '2026-06-08 04:55:09', NULL),
(25, 10, 'Matte Sticker Paper', 20.00, 0, 1, '2026-06-08 04:55:09', NULL),
(26, 10, 'Waterproof Premium Vinyl', 10.00, 0, 2, '2026-06-08 04:55:09', NULL),
(27, 11, 'Circle 2-inch', 0.00, 1, 0, '2026-06-08 04:55:09', NULL),
(28, 11, 'Square 2-inch', 10.00, 0, 1, '2026-06-08 04:55:09', NULL),
(29, 11, 'Custom Die-Cut', 5.00, 0, 2, '2026-06-08 04:55:09', NULL),
(30, 12, 'Gloss Lamination', 0.00, 1, 0, '2026-06-08 04:55:09', NULL),
(31, 12, 'Matte Scratch-Resistant Coating', 10.00, 0, 1, '2026-06-08 04:55:09', NULL),
(32, 12, 'Uncoated Matte', 10.00, 0, 2, '2026-06-08 04:55:09', NULL);

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

--
-- Table structure for table `product_option_groups`
--

CREATE TABLE `product_option_groups` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `group_name` varchar(100) NOT NULL,
  `sort_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `icon` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_option_groups`
--

INSERT INTO `product_option_groups` (`id`, `product_id`, `group_name`, `sort_order`, `created_at`, `icon`) VALUES
(1, 1, 'Material/Paper Type', 0, '2026-06-08 04:55:09', NULL),
(2, 1, 'Size/Dimension', 1, '2026-06-08 04:55:09', NULL),
(3, 1, 'Finish/Coating', 2, '2026-06-08 04:55:09', NULL),
(4, 2, 'Material/Paper Type', 0, '2026-06-08 04:55:09', 'fa-solid fa-print'),
(5, 2, 'Size/Dimension', 1, '2026-06-08 04:55:09', 'fa-solid fa-ruler-combined'),
(6, 2, 'Finish/Coating', 2, '2026-06-08 04:55:09', 'fa-solid fa-layer-group'),
(7, 4, 'Material/Paper Type', 0, '2026-06-08 04:55:09', NULL),
(8, 4, 'Size/Dimension', 1, '2026-06-08 04:55:09', NULL),
(9, 4, 'Finish/Coating', 2, '2026-06-08 04:55:09', NULL),
(10, 5, 'Material/Paper Type', 0, '2026-06-08 04:55:09', NULL),
(11, 5, 'Size/Dimension', 1, '2026-06-08 04:55:09', NULL),
(12, 5, 'Finish/Coating', 2, '2026-06-08 04:55:09', NULL);

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

--
-- Table structure for table `product_subcategories`
--

CREATE TABLE `product_subcategories` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `status` enum('Active','Inactive') DEFAULT 'Active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `refunds`
--

CREATE TABLE `refunds` (
  `id` int(11) NOT NULL,
  `payment_id` int(11) NOT NULL,
  `refund_number` varchar(50) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `reason` text DEFAULT NULL,
  `status` enum('Pending','Processed','Failed') DEFAULT 'Pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `reviews` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `rating` int(11) NOT NULL DEFAULT 5,
  `comment` text DEFAULT NULL,
  `status` enum('Pending','Approved','Rejected') DEFAULT 'Approved',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `created_at`) VALUES
(1, 'Super Admin', '2026-06-07 06:31:55');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL DEFAULT 1,
  `site_name` varchar(100) DEFAULT 'Smart Digital',
  `site_email` varchar(100) DEFAULT 'support@Smart Digital.com',
  `site_phone` varchar(20) DEFAULT '+91 98765 43210',
  `site_address` text DEFAULT NULL,
  `currency` varchar(10) DEFAULT 'INR',
  `logo` varchar(255) DEFAULT 'assets/logo/logo.png',
  `favicon` varchar(255) DEFAULT NULL,
  `announcement_text` text DEFAULT '4 Hrs delivery now in Bangalore, Hyderabad, NCR, and Chennai.',
  `announcement_text_2` text DEFAULT 'Free Delivery on all orders',
  `announcement_text_3` text DEFAULT 'And more exclusive offers inside!',
  `locator_banner_title` varchar(255) DEFAULT 'Same Day Delivery | Get it in 4–6 Hours',
  `locator_banner_desc` text DEFAULT 'Order before 4:30 PM and enjoy same-day delivery within 4–6 hours in Bengaluru, Hyderabad, Chennai, Delhi, Noida, and Ghaziabad. Perfect for urgent print materials, retail packaging, customized corporate gifts, and active business collateral needs.',
  `locator_banner_image` varchar(255) DEFAULT 'uploads/store-locator/store-locator-img-001.png',
  `locator_banner_btn_text` varchar(100) DEFAULT 'Explore More',
  `locator_banner_btn_link` varchar(255) DEFAULT 'products',
  `google_login_enabled` int(11) DEFAULT 1,
  `welcome_bonus_amount` decimal(10,2) DEFAULT 10.00,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `locator_banner_image_2` varchar(255) DEFAULT 'uploads/store-locator/store-locator-img-001 copy.png',
  `gst_enabled` int(11) DEFAULT 1,
  `pickup_name` varchar(255) DEFAULT NULL,
  `pickup_address` text DEFAULT NULL,
  `pickup_pincode` varchar(20) DEFAULT NULL,
  `pickup_state` varchar(100) DEFAULT NULL,
  `pickup_lat` varchar(50) DEFAULT NULL,
  `pickup_lng` varchar(50) DEFAULT NULL,
  `del_min_days` int(11) DEFAULT 3,
  `del_max_days` int(11) DEFAULT 5,
  `dist_del_min_days` int(11) DEFAULT 7,
  `dist_del_max_days` int(11) DEFAULT 10,
  `ship_time_days` int(11) DEFAULT 1,
  `ship_time_max_days` int(11) DEFAULT 2,
  `pickup_district` varchar(100) DEFAULT NULL,
  `free_delivery_enabled` int(11) DEFAULT 0,
  `free_delivery_min_value` decimal(10,2) DEFAULT 0.00,
  `free_delivery_products` text DEFAULT NULL,
  `free_delivery_locations` text DEFAULT NULL,
  `facebook_link` varchar(255) DEFAULT '',
  `instagram_link` varchar(255) DEFAULT '',
  `twitter_link` varchar(255) DEFAULT '',
  `linkedin_link` varchar(255) DEFAULT '',
  `youtube_link` varchar(255) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `site_name`, `site_email`, `site_phone`, `site_address`, `currency`, `logo`, `favicon`, `announcement_text`, `announcement_text_2`, `announcement_text_3`, `locator_banner_title`, `locator_banner_desc`, `locator_banner_image`, `locator_banner_btn_text`, `locator_banner_btn_link`, `google_login_enabled`, `welcome_bonus_amount`, `created_at`, `locator_banner_image_2`, `gst_enabled`, `pickup_name`, `pickup_address`, `pickup_pincode`, `pickup_state`, `pickup_lat`, `pickup_lng`, `del_min_days`, `del_max_days`, `dist_del_min_days`, `dist_del_max_days`, `ship_time_days`, `ship_time_max_days`, `pickup_district`, `free_delivery_enabled`, `free_delivery_min_value`, `free_delivery_products`, `free_delivery_locations`, `facebook_link`, `instagram_link`, `twitter_link`, `linkedin_link`, `youtube_link`) VALUES
(1, 'Smart Digital', 'support@smartdigital.com', '+91 98765 43210', 'Bengaluru, India', 'INR', 'uploads/settings/logo_1780991618.png', NULL, '4 Hrs delivery now in Bangalore, Hyderabad, NCR, and Chennai.', 'Free Delivery on all orders', 'And more exclusive offers inside!', 'Same Day Delivery | Get it in 4–6 Hours', 'Order before 4:30 PM and enjoy same-day delivery within 4–6 hours in Bengaluru, Hyderabad, Chennai, Delhi, Noida, and Ghaziabad. Perfect for urgent print materials, retail packaging, customized corporate gifts, and active business collateral needs.', 'uploads/store-locator/store-locator-img-001.png', 'Explore More', 'products', 1, 10.00, '2026-06-07 06:31:55', 'uploads/store-locator/store-locator-img-001 copy.png', 1, 'Office', 'Rongtuli Graphics Centre, Kalyanpur, Nandakumar, West Bengal 721632', '721632', 'West Bengal', '22.1510872', '87.9397742', 3, 5, 7, 10, 1, 2, 'East Midnapore', 0, 0.00, '', '', 'https://www.facebook.com/SmartDigital.India', 'https://www.instagram.com/smartdigital_india/', 'https://twitter.com/smartdigital', 'https://in.linkedin.com/company/smartdigital-india', 'https://www.youtube.com');

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

--
-- Table structure for table `smtp_providers`
--

CREATE TABLE `smtp_providers` (
  `id` int(11) NOT NULL,
  `provider` varchar(50) NOT NULL,
  `host` varchar(150) NOT NULL,
  `port` int(11) NOT NULL DEFAULT 587,
  `username` varchar(150) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `encryption` varchar(20) DEFAULT 'tls',
  `from_email` varchar(150) DEFAULT NULL,
  `from_name` varchar(150) DEFAULT NULL,
  `is_active` 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 `smtp_providers`
--

INSERT INTO `smtp_providers` (`id`, `provider`, `host`, `port`, `username`, `password`, `encryption`, `from_email`, `from_name`, `is_active`, `created_at`) VALUES
(1, 'gmail', 'smtp.gmail.com', 587, 'tourismagency.in@gmail.com', 'kmqxnsmuzrcuucmo', 'tls', 'tourismagency.in@gmail.com', 'Smart Digital', 1, '2026-06-07 06:31:55'),
(2, 'outlook', 'smtp.office365.com', 587, 'outlook@example.com', 'change_me', 'tls', 'no-reply@yourdomain.com', 'Smart Digital', 0, '2026-06-07 06:31:55'),
(3, 'custom', 'mail.yourdomain.com', 587, 'postmaster@yourdomain.com', 'change_me', 'tls', 'no-reply@yourdomain.com', 'Smart Digital', 0, '2026-06-07 06:31:55');

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

--
-- Table structure for table `smtp_settings`
--

CREATE TABLE `smtp_settings` (
  `id` int(11) NOT NULL DEFAULT 1,
  `host` varchar(100) DEFAULT 'smtp.mailtrap.io',
  `port` int(11) DEFAULT 2525,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `encryption` varchar(10) DEFAULT 'tls',
  `from_email` varchar(100) DEFAULT 'noreply@Smart Digital.com',
  `from_name` varchar(100) DEFAULT 'Smart Digital Printing',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `smtp_settings`
--

INSERT INTO `smtp_settings` (`id`, `host`, `port`, `username`, `password`, `encryption`, `from_email`, `from_name`, `created_at`) VALUES
(1, 'smtp.mailtrap.io', 2525, 'smtp_user', 'smtp_pass', 'tls', 'noreply@smartdigital.com', 'Smart Digital Printing', '2026-06-07 06:31:55');

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

--
-- Table structure for table `states_master`
--

CREATE TABLE `states_master` (
  `id` int(11) NOT NULL,
  `state_name` varchar(100) NOT NULL,
  `status` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `states_master`
--

INSERT INTO `states_master` (`id`, `state_name`, `status`) VALUES
(1, 'Andhra Pradesh', 1),
(2, 'Arunachal Pradesh', 1),
(3, 'Assam', 1),
(4, 'Bihar', 1),
(5, 'Chhattisgarh', 1),
(6, 'Goa', 1),
(7, 'Gujarat', 1),
(8, 'Haryana', 1),
(9, 'Himachal Pradesh', 1),
(10, 'Jharkhand', 1),
(11, 'Karnataka', 1),
(12, 'Kerala', 1),
(13, 'Madhya Pradesh', 1),
(14, 'Maharashtra', 1),
(15, 'Manipur', 1),
(16, 'Meghalaya', 1),
(17, 'Mizoram', 1),
(18, 'Nagaland', 1),
(19, 'Odisha', 1),
(20, 'Punjab', 1),
(21, 'Rajasthan', 1),
(22, 'Sikkim', 1),
(23, 'Tamil Nadu', 1),
(24, 'Telangana', 1),
(25, 'Tripura', 1),
(26, 'Uttar Pradesh', 1),
(27, 'Uttarakhand', 1),
(28, 'West Bengal', 1),
(29, 'Andaman and Nicobar Islands', 1),
(30, 'Chandigarh', 1),
(31, 'Dadra and Nagar Haveli and Daman and Diu', 1),
(32, 'Delhi', 1),
(33, 'Jammu and Kashmir', 1),
(34, 'Ladakh', 1),
(35, 'Lakshadweep', 1),
(36, 'Puducherry', 1);

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

--
-- Table structure for table `stores`
--

CREATE TABLE `stores` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `city` varchar(100) NOT NULL,
  `address` text NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `lat` decimal(10,8) NOT NULL,
  `lng` decimal(11,8) NOT NULL,
  `status` varchar(50) DEFAULT 'Open Now',
  `status_color` varchar(20) DEFAULT 'success',
  `hours` varchar(150) DEFAULT 'Open Everyday: 9:00 AM - 9:00 PM',
  `services` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stores`
--

INSERT INTO `stores` (`id`, `name`, `city`, `address`, `phone`, `email`, `lat`, `lng`, `status`, `status_color`, `hours`, `services`, `created_at`) VALUES
(1, 'Rongtuli Graphics Centre', 'Tamluk', 'Rongtuli Graphics Centre, Kalyanpur, Nandakumar, West Bengal 721632', '+91 97499 26952', 'rongtuligraphicscenter@gmail.com', 22.15108230, 87.94234910, 'Open Now', 'success', 'Open Everyday: 9:00 AM - 9:00 PM', 'Digital Printing, Offset Printing, Graphic Design, Customized Gifts, Flex Printing, Banner Printing, Wedding Card Printing, Photo Framing', '2026-06-07 06:31:55');

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

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ticket_number` varchar(50) NOT NULL,
  `subject` varchar(150) NOT NULL,
  `description` text NOT NULL,
  `priority` enum('Low','Medium','High') DEFAULT 'Medium',
  `status` enum('Open','In-Progress','Resolved','Closed') DEFAULT 'Open',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `type` enum('Debit','Credit') NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` varchar(50) DEFAULT 'Completed',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `payment_id`, `user_id`, `type`, `amount`, `status`, `created_at`) VALUES
(1, NULL, 3, 'Debit', 262.84, 'Completed', '2026-06-07 07:57:56'),
(2, NULL, 3, 'Debit', 380.25, 'Completed', '2026-06-08 09:40:23'),
(3, NULL, 3, 'Debit', 234.52, 'Completed', '2026-06-08 09:42:12'),
(4, NULL, 1, 'Debit', 128.03, 'Completed', '2026-06-09 07:32:30'),
(5, NULL, 1, 'Debit', 128.03, 'Completed', '2026-06-09 07:33:06'),
(6, NULL, 1, 'Debit', 128.03, 'Completed', '2026-06-09 07:36:36'),
(7, NULL, 1, 'Debit', 128.03, 'Completed', '2026-06-09 07:42:37'),
(8, NULL, 1, 'Debit', 128.03, 'Completed', '2026-06-09 07:48:52'),
(9, NULL, 1, 'Debit', 128.03, 'Completed', '2026-06-09 07:50:44'),
(10, NULL, 1, 'Debit', 128.03, 'Completed', '2026-06-09 07:53:05');

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

--
-- Table structure for table `uploaded_designs`
--

CREATE TABLE `uploaded_designs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `file_path` varchar(255) NOT NULL,
  `file_size` int(11) DEFAULT 0,
  `file_type` varchar(50) DEFAULT NULL,
  `status` enum('Pending','Approved','Rejected') DEFAULT 'Pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `uploaded_designs`
--

INSERT INTO `uploaded_designs` (`id`, `user_id`, `file_path`, `file_size`, `file_type`, `status`, `created_at`) VALUES
(1, NULL, 'uploads/artwork_6a2523e5055bc_1780818917.pdf', 22175464, 'pdf', 'Pending', '2026-06-07 07:55:17'),
(2, 3, 'uploads/artwork_6a252475a8ce2_1780819061.pdf', 150917, 'pdf', 'Pending', '2026-06-07 07:57:41'),
(3, 3, 'uploads/artwork_6a268e69afe69_1780911721.png', 57554, 'png', 'Pending', '2026-06-08 09:42:01'),
(4, NULL, 'uploads/print-product/2026/2026-06-09/order_4/4_Annapurna_Yojana_Family_Level_Data_Collection_Form__1_.pdf', 482442, 'pdf', 'Pending', '2026-06-09 06:40:20'),
(5, NULL, 'uploads/print-product/2026/2026-06-09/5_ChatGPT_Image_May_21__2026__05_52_14_PM.png', 1931713, 'png', 'Pending', '2026-06-09 06:46:25'),
(6, NULL, 'uploads/print-product/2026/2026-06-09/6.png', 22353, 'png', 'Pending', '2026-06-09 06:50:10'),
(7, NULL, 'uploads/print-product/2026/2026-06-09/PR-DBC2C097.jpg', 94228, 'jpg', 'Pending', '2026-06-09 06:52:46'),
(8, NULL, 'uploads/print-product/2026/2026-06-09/PR-33B27641.png', 1931713, 'png', 'Pending', '2026-06-09 07:25:33'),
(9, NULL, 'uploads/print-product/2026/2026-06-09/PR-81F95668.png', 14259, 'png', 'Pending', '2026-06-09 07:34:34');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `fullname` varchar(100) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `google_id` varchar(255) DEFAULT NULL,
  `profile_image` varchar(255) DEFAULT NULL,
  `login_type` varchar(50) DEFAULT 'Email',
  `email_verified` tinyint(1) DEFAULT 0,
  `remember_token` varchar(255) DEFAULT NULL,
  `wallet_balance` decimal(10,2) DEFAULT 0.00,
  `status` enum('Active','Blocked') DEFAULT 'Active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` (`id`, `name`, `fullname`, `email`, `mobile`, `password`, `google_id`, `profile_image`, `login_type`, `email_verified`, `remember_token`, `wallet_balance`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Mahit Kumar', NULL, 'customer@smartdigital.com', '9876543210', '$2y$10$B0i1tE6eHwJpZqW9i1fG0e/V7a8p/5gW0y5U9rQZzGfP3Hn4U1J3e', NULL, NULL, 'Email', 0, NULL, 500.00, 'Active', '2026-06-07 06:31:55', '2026-06-07 06:31:55'),
(2, 'Mahitosh Makar', 'Mahitosh Makar', 'tarama.online.service@gmail.com', NULL, '$2y$10$6rhJcuh5dLpvr41ezCcPT.xvm7DTAE3qGVqWd2zhCXUZadgIZ2tmK', '116253073619309657830', 'https://lh3.googleusercontent.com/a/ACg8ocLBZVwsZWgvjUKguiJDStjMsReIRyHOZJwNPHDNGm_Qajm-1is=s96-c', 'Google', 1, NULL, 10.00, 'Active', '2026-06-07 06:32:30', '2026-06-07 06:32:30'),
(3, 'Mahitosh Makar', 'Mahitosh Makar', 'mahitoshmakar35@gmail.com', NULL, '$2y$10$Lb1GqmHlpT5ZQCTY38.tauwtxy3ll/0ls2tYfUZlAyMa1BugmbRyS', '117748212895458556985', 'https://lh3.googleusercontent.com/a/ACg8ocJqUMaidt-8ouJSxcQDcMHy1xBi7wNWCcO77q7d4Oy4SNamXlbW=s96-c', 'Google', 1, NULL, 10.00, 'Active', '2026-06-07 07:55:51', '2026-06-07 07:55:51');

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

--
-- Table structure for table `user_addresses`
--

CREATE TABLE `user_addresses` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `address_type` enum('Home','Office','Other') DEFAULT 'Home',
  `name` varchar(100) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `address_line1` varchar(255) NOT NULL,
  `address_line2` varchar(255) DEFAULT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `pincode` varchar(10) NOT NULL,
  `is_default` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `wishlists` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`),
  ADD KEY `role_id` (`role_id`);

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

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

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

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

--
-- Indexes for table `cart_options`
--
ALTER TABLE `cart_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cart_id` (`cart_id`);

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

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

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

--
-- Indexes for table `delivery_districts`
--
ALTER TABLE `delivery_districts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `state_district` (`state_id`,`name`);

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

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

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

--
-- Indexes for table `districts_master`
--
ALTER TABLE `districts_master`
  ADD PRIMARY KEY (`id`),
  ADD KEY `state_id` (`state_id`);

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

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

--
-- Indexes for table `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `invoice_number` (`invoice_number`),
  ADD KEY `order_id` (`order_id`);

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

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

--
-- 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`),
  ADD UNIQUE KEY `order_number` (`order_number`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `coupon_id` (`coupon_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_item_options`
--
ALTER TABLE `order_item_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_item_id` (`order_item_id`);

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

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

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `payment_number` (`payment_number`),
  ADD KEY `order_id` (`order_id`);

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

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

--
-- 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 `group_id` (`group_id`);

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

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

--
-- Indexes for table `refunds`
--
ALTER TABLE `refunds`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `refund_number` (`refund_number`),
  ADD KEY `payment_id` (`payment_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `admins`
--
ALTER TABLE `admins`
  ADD CONSTRAINT `admins_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE SET NULL;

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

--
-- Constraints for table `cart_options`
--
ALTER TABLE `cart_options`
  ADD CONSTRAINT `cart_options_ibfk_1` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `delivery_districts`
--
ALTER TABLE `delivery_districts`
  ADD CONSTRAINT `delivery_districts_ibfk_1` FOREIGN KEY (`state_id`) REFERENCES `delivery_states` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `districts_master`
--
ALTER TABLE `districts_master`
  ADD CONSTRAINT `districts_master_ibfk_1` FOREIGN KEY (`state_id`) REFERENCES `states_master` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `invoices`
--
ALTER TABLE `invoices`
  ADD CONSTRAINT `invoices_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE SET NULL;

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

--
-- Constraints for table `order_item_options`
--
ALTER TABLE `order_item_options`
  ADD CONSTRAINT `order_item_options_ibfk_1` FOREIGN KEY (`order_item_id`) REFERENCES `order_items` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `product_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_ibfk_2` FOREIGN KEY (`subcategory_id`) REFERENCES `product_subcategories` (`id`) ON DELETE SET NULL;

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

--
-- Constraints for table `product_options`
--
ALTER TABLE `product_options`
  ADD CONSTRAINT `product_options_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `product_option_groups` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `product_subcategories`
--
ALTER TABLE `product_subcategories`
  ADD CONSTRAINT `product_subcategories_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `product_categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `refunds`
--
ALTER TABLE `refunds`
  ADD CONSTRAINT `refunds_ibfk_1` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE CASCADE;

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

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

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `transactions_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

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

--
-- Constraints for table `wishlists`
--
ALTER TABLE `wishlists`
  ADD CONSTRAINT `wishlists_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wishlists_ibfk_2` 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 */;
