-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 18, 2026 at 03:14 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: `bni-project`
--

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Online UPS & Batteries', NULL, 1, NULL, NULL),
(2, 'Industrial Valves', NULL, 1, NULL, NULL),
(3, 'Telecom Solutions', NULL, 1, NULL, NULL),
(4, 'Industrial & Automotive Bearings', NULL, 1, NULL, NULL),
(5, 'Unsecured Loans', NULL, 1, NULL, NULL),
(6, 'Shipping & Logistics', NULL, 1, NULL, NULL),
(7, 'Engineering Design & PMC', NULL, 1, NULL, NULL),
(8, 'CCTV & Security Systems', NULL, 1, NULL, NULL),
(9, 'Automotive Ancillary Components', NULL, 1, NULL, NULL),
(10, 'Plastic Products', NULL, 1, NULL, NULL),
(11, 'Fasteners Trade', NULL, 1, NULL, NULL),
(12, 'Pre-engineered building', NULL, 1, NULL, NULL),
(13, 'Wire Netting Products', NULL, 1, NULL, NULL),
(14, 'Commercial Interior Contractor - High Value', NULL, 1, NULL, NULL),
(15, 'Anti Corrosion Products & Services', NULL, 1, NULL, NULL),
(16, 'Welding Products Manufacturer', NULL, 1, NULL, NULL),
(17, 'Home Automation', NULL, 1, NULL, NULL),
(18, 'Interior Hardware', NULL, 1, NULL, NULL),
(19, 'Lighting & Lighting Solutions', NULL, 1, NULL, NULL),
(20, 'Paints', NULL, 1, NULL, NULL),
(21, 'Stretch Ceiling & Corian Products', NULL, 1, NULL, NULL),
(22, 'Soft Furnishings', NULL, 1, NULL, NULL),
(23, 'Marbles & Granites', NULL, 1, NULL, NULL),
(24, 'Modular Kitchens & Wardrobes', NULL, 1, NULL, NULL),
(25, 'Glass', NULL, 1, NULL, NULL),
(26, 'Commercial Modular Furniture Manufacturer', NULL, 1, NULL, NULL),
(27, 'Tensile Structures', NULL, 1, NULL, NULL),
(28, 'Office Chairs', NULL, 1, NULL, NULL),
(29, 'LPG Distribution', NULL, 1, NULL, NULL),
(30, 'Timbers & Doors', NULL, 1, NULL, NULL),
(31, 'Tiles', NULL, 1, NULL, NULL),
(32, 'Plywood', NULL, 1, NULL, NULL),
(33, 'Wall Panelling', NULL, 1, NULL, NULL),
(34, 'Embroidery', NULL, 1, NULL, NULL),
(35, 'Surgical Instruments', NULL, 1, NULL, NULL),
(36, 'Uniforms', NULL, 1, NULL, NULL),
(37, 'Commercial Audio Systems', NULL, 1, NULL, NULL),
(38, 'Nuts & Spices', NULL, 1, NULL, NULL),
(39, 'Commercial TV', NULL, 1, NULL, NULL),
(40, 'Events & Activations', NULL, 1, NULL, NULL),
(41, 'Corrugated Box Manufacturer', NULL, 1, NULL, NULL),
(42, 'Hygiene Products', NULL, 1, NULL, NULL),
(43, 'Baking & Baking Products', NULL, 1, NULL, NULL),
(44, 'Mutual Fund', NULL, 1, NULL, NULL),
(45, 'Computers, Peripherals & Accessories', NULL, 1, NULL, NULL),
(46, 'Consulting Services', NULL, 1, NULL, NULL),
(47, 'Cyber Security', NULL, 1, NULL, NULL),
(48, 'Training & Placement', NULL, 1, NULL, NULL),
(49, 'Business Consulting', NULL, 1, NULL, NULL),
(50, 'ERP Solutions', NULL, 1, NULL, NULL),
(51, 'Forex', NULL, 1, NULL, NULL),
(52, 'Makeup Artist', NULL, 1, NULL, NULL),
(53, 'Psychotherapist', NULL, 1, NULL, NULL),
(54, 'IOT Based Energy Management', NULL, 1, NULL, NULL),
(55, 'Iron & Steel', NULL, 1, NULL, NULL),
(56, 'Wooden & Vinyl Flooring', NULL, 1, NULL, NULL),
(57, 'Electrical Contractor', NULL, 1, NULL, NULL),
(58, 'Electrical Panels', NULL, 1, NULL, NULL),
(59, 'Builder', NULL, 1, NULL, NULL),
(60, 'Blocks & Blue Metal', NULL, 1, NULL, NULL),
(61, 'Architect', NULL, 1, NULL, NULL),
(62, 'Structural Engineer', NULL, 1, NULL, NULL),
(63, 'Centralized Air Conditioning System', NULL, 1, NULL, NULL),
(64, 'Water & Waste Water Treatment', NULL, 1, NULL, NULL),
(65, 'Electrical Goods', NULL, 1, NULL, NULL),
(66, 'Solar Energy Solutions', NULL, 1, NULL, NULL),
(67, 'Creatives for Advertising', NULL, 1, NULL, NULL),
(68, 'Turnkey Residential Interior', NULL, 1, NULL, NULL),
(69, 'UPVC Windows', NULL, 1, NULL, NULL),
(70, 'Lifts', NULL, 1, NULL, NULL),
(71, 'Landscaping', NULL, 1, NULL, NULL),
(72, 'Home Loan & Mortgage', NULL, 1, NULL, NULL),
(73, 'Realtor', NULL, 1, NULL, NULL),
(74, 'Sanitarywares & Bath Faucets', NULL, 1, NULL, NULL),
(75, 'Pest control', NULL, 1, NULL, NULL),
(76, 'Car Rental Service', NULL, 1, NULL, NULL),
(77, 'Printing', NULL, 1, NULL, NULL),
(78, 'Hospital Services', NULL, 1, NULL, NULL),
(79, 'Leather Product Manufacturing', NULL, 1, NULL, NULL),
(80, 'Security Services', NULL, 1, NULL, NULL),
(81, 'Life & Health Insurance Advisor', NULL, 1, NULL, NULL),
(82, 'AI Videos', NULL, 1, NULL, NULL),
(83, 'Corporate Gifting', NULL, 1, NULL, NULL),
(84, 'EV Charging', NULL, 1, NULL, NULL),
(85, 'Resorts', NULL, 1, NULL, NULL),
(86, 'Physiotherapy', NULL, 1, NULL, NULL),
(87, 'Health & Wellness Nutritionist', NULL, 1, NULL, NULL),
(88, 'Automotive Interior', NULL, 1, NULL, NULL),
(89, 'Dentist', NULL, 1, NULL, NULL),
(90, 'Tours & Travels', NULL, 1, NULL, NULL),
(91, 'Gold and Silver Jewellery', NULL, 1, NULL, NULL),
(92, 'Bespoke Wedding Planner', NULL, 1, NULL, NULL),
(93, 'Civil Contractor', NULL, 1, NULL, NULL),
(94, 'Diamond & Diamond Jewellery (B2B)', NULL, 1, NULL, NULL),
(95, 'Catering', NULL, 1, NULL, NULL),
(96, 'Garment Accessories', NULL, 1, NULL, NULL),
(97, 'Custom Tailoring & Wardrobe Consultancy', NULL, 1, NULL, NULL),
(98, 'Cleaning Services', NULL, 1, NULL, NULL),
(99, 'Website E-Commerce Solutions', NULL, 1, NULL, NULL),
(100, 'Complete Legal Solutions', NULL, 1, NULL, NULL),
(101, 'Car & Motorcycle Automotive Expert', NULL, 1, NULL, NULL),
(102, 'Wealth Management', NULL, 1, NULL, NULL),
(103, 'Veg Catering', NULL, 1, NULL, NULL),
(104, 'Photography & Videography', NULL, 1, NULL, NULL);

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `meeting_schedules`
--

CREATE TABLE `meeting_schedules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meeting_id` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `month` int(11) NOT NULL,
  `week` int(11) NOT NULL,
  `meeting_date` date NOT NULL,
  `status` enum('scheduled','completed','cancelled') NOT NULL DEFAULT 'scheduled',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `meeting_schedules`
--

INSERT INTO `meeting_schedules` (`id`, `meeting_id`, `year`, `month`, `week`, `meeting_date`, `status`, `created_at`, `updated_at`) VALUES
(1, 706, 2026, 1, 1, '2026-01-01', 'completed', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(2, 707, 2026, 1, 2, '2026-01-08', 'completed', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(3, 708, 2026, 1, 3, '2026-01-15', 'completed', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(4, 709, 2026, 1, 4, '2026-01-22', 'completed', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(5, 710, 2026, 1, 5, '2026-01-29', 'completed', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(6, 711, 2026, 2, 1, '2026-02-05', 'completed', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(7, 712, 2026, 2, 2, '2026-02-12', 'completed', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(8, 713, 2026, 2, 3, '2026-02-19', 'completed', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(9, 714, 2026, 2, 4, '2026-02-26', 'completed', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(10, 715, 2026, 3, 1, '2026-03-05', 'completed', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(11, 716, 2026, 3, 2, '2026-03-12', 'completed', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(12, 718, 2026, 3, 3, '2026-03-19', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(13, 719, 2026, 3, 4, '2026-03-26', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(14, 720, 2026, 4, 1, '2026-04-02', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(15, 721, 2026, 4, 2, '2026-04-09', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(16, 722, 2026, 4, 3, '2026-04-16', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(17, 723, 2026, 4, 4, '2026-04-23', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(18, 724, 2026, 4, 5, '2026-04-30', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(19, 725, 2026, 5, 1, '2026-05-07', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(20, 726, 2026, 5, 2, '2026-05-14', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(21, 727, 2026, 5, 3, '2026-05-21', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(22, 728, 2026, 5, 4, '2026-05-28', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(23, 729, 2026, 6, 1, '2026-06-04', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(24, 730, 2026, 6, 2, '2026-06-11', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(25, 731, 2026, 6, 3, '2026-06-18', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(26, 732, 2026, 6, 4, '2026-06-25', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(27, 733, 2026, 7, 1, '2026-07-02', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(28, 734, 2026, 7, 2, '2026-07-09', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(29, 735, 2026, 7, 3, '2026-07-16', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(30, 736, 2026, 7, 4, '2026-07-23', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(31, 737, 2026, 7, 5, '2026-07-30', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(32, 738, 2026, 8, 1, '2026-08-06', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(33, 739, 2026, 8, 2, '2026-08-13', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(34, 740, 2026, 8, 3, '2026-08-20', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(35, 741, 2026, 8, 4, '2026-08-27', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(36, 742, 2026, 9, 1, '2026-09-03', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(37, 743, 2026, 9, 2, '2026-09-10', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(38, 744, 2026, 9, 3, '2026-09-17', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(39, 745, 2026, 9, 4, '2026-09-24', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(40, 746, 2026, 10, 1, '2026-10-01', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(41, 747, 2026, 10, 2, '2026-10-08', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(42, 748, 2026, 10, 3, '2026-10-15', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(43, 749, 2026, 10, 4, '2026-10-22', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(44, 750, 2026, 10, 5, '2026-10-29', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(45, 751, 2026, 11, 1, '2026-11-05', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(46, 752, 2026, 11, 2, '2026-11-12', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(47, 753, 2026, 11, 3, '2026-11-19', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(48, 754, 2026, 11, 4, '2026-11-26', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(49, 755, 2026, 12, 1, '2026-12-03', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(50, 756, 2026, 12, 2, '2026-12-10', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(51, 757, 2026, 12, 3, '2026-12-17', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(52, 758, 2026, 12, 4, '2026-12-24', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(53, 759, 2026, 12, 5, '2026-12-31', 'scheduled', '2026-03-17 08:30:46', '2026-03-17 08:30:46'),
(54, 760, 2027, 1, 1, '2027-01-07', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(55, 761, 2027, 1, 2, '2027-01-14', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(56, 762, 2027, 1, 3, '2027-01-21', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(57, 763, 2027, 1, 4, '2027-01-28', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(58, 764, 2027, 2, 1, '2027-02-04', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(59, 765, 2027, 2, 2, '2027-02-11', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(60, 766, 2027, 2, 3, '2027-02-18', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(61, 767, 2027, 2, 4, '2027-02-25', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(62, 768, 2027, 3, 1, '2027-03-04', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(63, 769, 2027, 3, 2, '2027-03-11', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(64, 770, 2027, 3, 3, '2027-03-18', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(65, 771, 2027, 3, 4, '2027-03-25', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(66, 772, 2027, 4, 1, '2027-04-01', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(67, 773, 2027, 4, 2, '2027-04-08', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(68, 774, 2027, 4, 3, '2027-04-15', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(69, 775, 2027, 4, 4, '2027-04-22', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(70, 776, 2027, 4, 5, '2027-04-29', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(71, 777, 2027, 5, 1, '2027-05-06', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(72, 778, 2027, 5, 2, '2027-05-13', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(73, 779, 2027, 5, 3, '2027-05-20', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(74, 780, 2027, 5, 4, '2027-05-27', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(75, 781, 2027, 6, 1, '2027-06-03', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(76, 782, 2027, 6, 2, '2027-06-10', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(77, 783, 2027, 6, 3, '2027-06-17', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(78, 784, 2027, 6, 4, '2027-06-24', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(79, 785, 2027, 7, 1, '2027-07-01', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(80, 786, 2027, 7, 2, '2027-07-08', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(81, 787, 2027, 7, 3, '2027-07-15', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(82, 788, 2027, 7, 4, '2027-07-22', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(83, 789, 2027, 7, 5, '2027-07-29', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(84, 790, 2027, 8, 1, '2027-08-05', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(85, 791, 2027, 8, 2, '2027-08-12', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(86, 792, 2027, 8, 3, '2027-08-19', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(87, 793, 2027, 8, 4, '2027-08-26', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(88, 794, 2027, 9, 1, '2027-09-02', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(89, 795, 2027, 9, 2, '2027-09-09', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(90, 796, 2027, 9, 3, '2027-09-16', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(91, 797, 2027, 9, 4, '2027-09-23', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(92, 798, 2027, 9, 5, '2027-09-30', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(93, 799, 2027, 10, 1, '2027-10-07', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(94, 800, 2027, 10, 2, '2027-10-14', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(95, 801, 2027, 10, 3, '2027-10-21', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(96, 802, 2027, 10, 4, '2027-10-28', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(97, 803, 2027, 11, 1, '2027-11-04', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(98, 804, 2027, 11, 2, '2027-11-11', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(99, 805, 2027, 11, 3, '2027-11-18', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(100, 806, 2027, 11, 4, '2027-11-25', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(101, 807, 2027, 12, 1, '2027-12-02', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(102, 808, 2027, 12, 2, '2027-12-09', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(103, 809, 2027, 12, 3, '2027-12-16', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(104, 810, 2027, 12, 4, '2027-12-23', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17'),
(105, 811, 2027, 12, 5, '2027-12-30', 'scheduled', '2026-03-17 10:04:17', '2026-03-17 10:04:17');

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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `company` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expire_schedule_id` int(11) DEFAULT NULL,
  `renewal_schedule_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`id`, `category_id`, `name`, `company`, `phone`, `email`, `created_at`, `updated_at`, `expire_schedule_id`, `renewal_schedule_id`) VALUES
(1, 1, 'UMASHANKAR S', 'Anushri Systems Pvt Ltd', '9841688178', 'umesh90@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', 13, 14),
(2, 2, 'VINOTHKUMAR THANGARAJ', 'Sree Mahalakshmi Industries', '9444951754', 'sreemahalakshmi1997@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(3, 3, 'RAMESH UMAPATHY', 'Inkrap Telecom India Pvt Ltd', '9840244343', 'r.umesh@inkarpco.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(4, 4, 'TINKESH PARIKH', 'NTA Bearings', '9677002100', 'alpaaagencies@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(5, 5, 'AASHISH KUMAR', 'Sunrays Financial Services', '7200005309', 'sales@sunraysfinance.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(6, 6, 'LINGOVAN P', 'Sri Shipping Services Pvt Ltd', '9841041239', 'ilango@srisip.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(7, 7, 'KAVINKUMAR SHANMUGAM', 'EPMCR (P) Ltd', '9444039796', 'kavin.epmcr@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(8, 8, 'MAGESH PATTABIRAMAN', 'Powerchip Technologies India Pvt Ltd', '9841032035', 'magesh@pct.co.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(9, 9, 'MANIVASAGAM VAIRAVAN', 'Vallimalai Industries', '9444880303', 'mv@rudrxengineering.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(10, 10, 'ANU BARDIA', 'Sunshine Plastic Industries', '9884804804', 'anubardia@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(11, 11, 'ABBAS BHARMAL', 'Alamdar Traders', '9500386530', 'alamdar1983@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(12, 12, 'ELANGO AL', 'Success Steel Structures', '9042549424', 'elango@successsteelstructures.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(13, 13, 'PARAG DUGA', 'Rajesh Industrial Corporation', '9884319326', 'contact@rsolutions.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(14, 14, 'SIDDHARTHAN C', 'Adya Interiors Private Limited', '9003111100', 'siddharth@adya.co', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(15, 15, 'LAKSHMANA PERUMAL', 'One Touch Solutionss', '9840985953', 'peru@onetouchsolutionss.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(16, 16, 'PALANIYAPPAN RAJENDRAN', 'Special Wire Products (P) Ltd', '9944446633', 'palaniyappan.ra@specialwires.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(17, 17, 'SACHIN MEHTA', 'Impulse Concepts', '9840057577', 'samithampulse@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(18, 18, 'EBU THAHIR', 'Thahir Designer Hardware', '9952051718', 'et@bightahir.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(19, 19, 'ROHIT KUMBHAT', 'Lightscape', '9841745400', 'rohit@lightscape.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(20, 20, 'SACHIN KHAN', 'Rainbow Height Paints LLP', '9159078777', 'sachin@rainbowheightspaints.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(21, 21, 'VISHAL KOTHARI', 'Satvik Enterprises', '9363043567', 'info@satvikenterprises.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(22, 22, 'VISHAL MEHTA', 'Patterns Furnishing', '9600111333', 'vm@patternsfurnishing.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(23, 23, 'HEMANT AMERA', 'Marble Kingdom India LLP', '9444085540', 'hemant@themixindia.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(24, 24, 'NANDHAKUMAR D', 'Dynamic', '9840298002', 'nandha@dynamic.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(25, 25, 'B DINAKARAN', 'Art Glass Edge', '9380877666', 'dina@artglass.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(26, 26, 'SATHISH KUMAR G', 'Monads Furniture Systems Pvt Ltd', '9282200235', 'sathish.monads@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(27, 27, 'JOHN THILAK', 'Texsys Structures Pvt Ltd', '8939232333', 'johnthilak@texsysstructures.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(28, 28, 'POOJA SHYAM CHUGH', 'SIT ON', '9791015779', 'artositting@hotmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(29, 29, 'MOHAMED WASIM T A', 'Javed Gas Agency', '9884407769', 'awasim.md@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(30, 30, 'KASHYAP PATEL', 'Geetha Wood Industries', '9566046664', 'geetha_gvi@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(31, 31, 'JAI SHAH', 'Arisco', '9176215414', 'sales@arisco.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(32, 32, 'RAHUL CHANDAK', 'Kwality Plywood', '9840457999', 'rahul@kwality.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(33, 33, 'ANANDAKANNAN R', 'VRS Leathers Pvt Ltd', '9940334949', 'anand@9twelveindia.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(34, 34, 'R SUMATHI', 'YUTI Designer Private Limited', '9789903599', 'rsumathee@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(35, 35, 'SHIV BATRA', 'Apollo Surgicals', '9841314722', 'apollo_surgical@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(36, 36, 'TAMANNA SARDA', 'Kunal Uniforms', '9360031000', 'tanvisini@yahoo.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(37, 37, 'AASHISH JAIN', 'Deccan Soundscape Pvt Ltd', '9952090940', 'aashish@deccansoundscape.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(38, 38, 'SUNIL AGARWAL', 'Raynav Agro Nuts', '8667582192', 'sunilgemawath@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(39, 39, 'MUTHUS', 'Palaniappa Electronics', '9003045685', 'muthu@palaniappagroup.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(40, 40, 'VIVEK MENON', 'Beyond Branding India Pvt Ltd', '9840731857', 'vivekmenon@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(41, 41, 'SANJAY JEYAN', 'Crystal Enterprises', '9791191741', 'sanjayjeyan@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(42, 42, 'SANJAY REDDY', 'Aspire Corporation', '9500053079', 'govindanjay@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(43, 43, 'AMIT VAISHNAV', 'Mega Foods', '9884455605', 'megafoods@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(44, 44, 'PRANESH NAGARAJAN', 'Money Mine Investments', '9150561059', 'pranesh@moneyinvestments.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(45, 45, 'SURESH KUMAR SONI', 'Auro Enterprises', '9786221111', 'info@auro.co.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(46, 46, 'NIVEDITHA RAVICHANDRAN', 'S Venkatesh & Associates', '8124092125', 'niveditha@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(47, 47, 'BHARATH S', 'Mithra Consulting', '9880781801', 'bharath@mithracon.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(48, 48, 'SURAJ DAVEY', 'Vivac Business Consultants LLP', '9884108405', 'sdavey@vivacacademy.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(49, 49, 'GOVINDAN R', 'Vridhni Consultants', '9840637000', 'govindan55@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(50, 50, 'DINESH KONIDALA', 'SDK Infinty Technologies Pvt Ltd', '7298948082', 'dinesh@sdk.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(51, 51, 'PRATIK VAKHARIA', 'Vakharla Forex Pvt Ltd', '9884623104', 'pv@vakharla.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(52, 52, 'KP NIRANJANA', 'Lavenders Beauty Salon', '9884061902', 'makeupniranjana@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(53, 53, 'DR VIJAYALAKSHMI PRAVEEN', 'Makkal Nalam Clinic', '8939219593', 'dr.vjpraveen@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(54, 54, 'SHARATH RAMARAJ', 'Senergy IOT Pvt Ltd', '9551144112', 'sharathramaraj@senergy.net', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(55, 55, 'DINESH KUMAR SETHI', 'Jains Steels and Alloys', '9444031114', 'jainsteels_alloys@yahoo.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(56, 56, 'ASHOK KRIPLANI', 'Heritage', '9840048615', 'ashok@globalmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(57, 57, 'T SUBRAMANIAN', 'Vinpower Engineers & Associates', '9790018639', 'subramani.power@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(58, 58, 'MANI SINGARAM', 'Chitra Enterprises', '9840138827', 'chithramani2006@yahoo.co.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(59, 59, 'MUTHUKUMAR AN', 'SKI Project', '9884408589', 'san.muthukumar@skiprojects.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(60, 60, 'SAGARIKA N P', 'Sri Guru Enterprises', '9176273385', 'sagarika.np@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(61, 61, 'SUGUMAR V', 'I and S Studio', '9840025728', 'insstudio@yahoo.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(62, 62, 'PUNITHAM MURUGESAN', 'Murugu Consultant', '9884400273', 'murugum@yahoo.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(63, 63, 'JOHN RUDHAYARAJ R', 'GV Aircon Projects & Services', '9551621171', 'john@airmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(64, 64, 'LAKSHMANAN S P', 'Clar Aqua Pvt Ltd', '9500026363', 'lakshmanan@claraqua.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(65, 65, 'SHRAVAN FOMRA', 'Fomra Electricals', '9840785000', 'shravan@fomra.co.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(66, 66, 'RATNESH MOOTHA', 'Datalite', '9381811414', 'mootha@datalite.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(67, 67, 'MONIQUE DASWANI', 'MAH Design Strategy', '9841678457', 'moniquedaswani@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(68, 68, 'BABITA CHHAJER', 'Lines and Spaces', '9444173706', 'linesandspaces.chennai@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(69, 69, 'VEERAMANIKANDAN P', 'Saravana Building Products', '9840014993', 'sbpwindows@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(70, 70, 'KANNAN JOSEPH', 'Cooper Elevators', '9344052205', 'md@cooperelevators.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(71, 71, 'DURAI PANDI', 'Palm Landscape', '9003240877', 'durai@palmlandscapes.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(72, 72, 'AMIT SHAH', 'Shree Realty', '9840940104', 'amit@shreealty.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(73, 73, 'JIGER MODI', 'Realty India', '9080249689', 'jm.realtyindia@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(74, 74, 'MOHAMMED ALI R', 'International Sales Corporation', '9941290493', 'insco1972@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(75, 75, 'ALFRED IMMANUEL', 'Pest Rid Naturals LLP', '9600922177', 'alfred@pestridnaturals.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(76, 76, 'JAI SUBASH', 'APJ Cabs', '9840422122', 'cars@apjcabs.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(77, 77, 'LACHUMANAN ARUMUGAM', 'Hitech Offset Pvt Ltd', '9094444455', 'lachu@hitechoffset.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(78, 78, 'DR SU THILLAI VALLAL', 'Venkateshwara Hospitals', '9841095554', 'drthillai@vhospitals.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(79, 79, 'RAJARAMAN K', 'SSV Exports', '9884102191', 'rajaraman@ssvexports.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(80, 80, 'B MURUGESAN', 'General Security Force', '9789901122', 'v4gsf@yahoo.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(81, 81, 'ASHOK KUMAR MIMANI', 'Mimani Group', '9381052424', 'mimaniinsurance@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(82, 82, 'S BAGAWATI PRASAD', 'Takeoff Entertainment LLP', '9941253395', 'sbagawati1989@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(83, 83, 'SATISH KUMAR D', 'Nexus Innovative Solutions', '9884040777', 'satishkumar@nexus.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(84, 84, 'KATHIRESAN KULANDAYAN', 'EVtron Tech Pvt Ltd', '9962974739', 'kathir@evtron.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(85, 85, 'THINAKARA KRISHNARAJ', 'Mamalla Beach Resort', '9443346875', 'krishnaraj@mamallaresort.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(86, 86, 'DR RESHI C', 'Beyond Rehab', '8971819499', 'rehabbeyond@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(87, 87, 'SADHVIKA SRINIVAS', 'Livstack Health and Performance', '9962561993', 'dietitiansadhvika@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(88, 88, 'ASHWATH SURESH', 'Cetus Automotives', '9952982428', 'ashwathsuresh@bableather.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(89, 89, 'SHRI NANDHINI DEVI R', 'Shri Clinic', '8778894366', 'theshriclinic@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(90, 90, 'SOHAIL CURRIMBHOY', 'Alliance Intl Tours & Travels', '9840064497', 'sohailcurrimbhoy@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(91, 91, 'KAMAL JAIN', 'V Jewels', '9169165108', 'Kamaljain362@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(92, 92, 'AKASH KAPOOR', 'Anyonya', '9841196502', 'anyonya.events@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(93, 93, 'VENKATAKRISHNAN V', 'Krish Foundation LLP', '9841064411', 'krishfoundationsllp@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(94, 94, 'VIIKRAM VIJAY KUMAR', 'Clear Facets', '9884056057', 'vijaykumarviikram@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(95, 95, 'SUNIL RAJANKAR', 'Goldline Catering', '9841070763', 'sunil.rajankar@goldline.co.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(96, 96, 'KRINA SANGHVI', 'Sanghvi Enterprises', '9080039025', 'krinasanghvi@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(97, 97, 'ANU J', 'Suit Lounge', '9840182652', 'info@thesuitlounge.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(98, 98, 'DINESH VENKATESAN', 'Hygiene Homes Marketing Pvt Ltd', '9094720713', 'dineshnaidu02@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(99, 99, 'S BABU', 'Dextra Technologies', '7397261418', 'sbabu@dextratechnologies.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(100, 100, 'BHARAT B JAIN', '360 Legal', '9444467187', 'jainbharat2000@yahoo.co.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(101, 101, 'AFFUNISSA CHAUDHARY', 'Motorheads', '9092440407', 'affunissa@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(102, 102, 'CHIRAG KHATRI', 'Acefront LLP', '9884474621', 'chiragkhat@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(103, 103, 'POOJARANI G', 'Vijayalakshmi Catering Service', '9841885065', 'vijayalakshmicaters69@gmail.com', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL),
(104, 104, 'PRADEEP SEKAR', 'Infinite Art', '9840103282', 'contact@infiniteart.in', '2026-03-17 13:55:29', '2026-03-17 13:55:29', NULL, NULL);

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

--
-- Table structure for table `membership_payments`
--

CREATE TABLE `membership_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `member_id` bigint(20) UNSIGNED NOT NULL,
  `months` int(11) NOT NULL,
  `start_month` varchar(255) NOT NULL,
  `expiry_month` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_03_14_075659_create_members_table', 2),
(5, '2026_03_14_075709_create_visitors_table', 2),
(6, '2026_03_14_075754_create_membership_visit_payments_table', 2),
(7, '2026_03_14_141900_add_payment_mode_and_paid_to_to_visitors_table', 3),
(8, '2026_03_16_105201_add_status_and_payment_details_to_visitors_table', 4),
(9, '2026_03_16_124614_create_meeting_schedules_table', 5),
(10, '2026_03_17_130918_create_categories_table', 6);

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

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

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

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('GEyxCAXNndxCURab7jdbaMUihZKUPP3FuEgUFa38', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTUxhT2c5SmVjekxZQlkzS3pqa0NXRjc4emkxQlJSMWpyemRYakw3TiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyOToiaHR0cDovLzEyNy4wLjAuMTo4MDAwL21lbWJlcnMiO31zOjk6Il9wcmV2aW91cyI7YToyOntzOjM6InVybCI7czoyMToiaHR0cDovLzEyNy4wLjAuMTo4MDAwIjtzOjU6InJvdXRlIjtzOjU6ImxvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773837596),
('TRdLdR3eYRyff3wzYPH4WY0RGf7Yo0LN8Jxqgl58', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiczlkeTEzTmxvRjNFNllsMkVWU1FIU2NneVI3RXpiQ1RYZlYyRWJBZyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9tZW1iZXJzIjtzOjU6InJvdXRlIjtzOjc6Im1lbWJlcnMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=', 1773842445);

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin@bni.com', NULL, '$2y$12$9JvARTkpNiuLekW6l7mbE.juEKZOSE5U8gJm.MuJamvCUY40I8v4K', NULL, '2026-03-14 00:57:00', '2026-03-14 00:57:00');

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

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

CREATE TABLE `visitors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `company` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `referred_by_member_id` bigint(20) UNSIGNED DEFAULT NULL,
  `paid_by` enum('visitor','member') NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT 1500.00,
  `payment_date` date DEFAULT NULL,
  `payment_mode` enum('cash','card','upi') DEFAULT NULL,
  `upi_number` varchar(255) DEFAULT NULL,
  `upi_transaction_id` varchar(255) DEFAULT NULL,
  `status` enum('pending','paid','failed') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `paid_to` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `visitors` (`id`, `name`, `company`, `phone`, `email`, `referred_by_member_id`, `paid_by`, `amount`, `payment_date`, `payment_mode`, `upi_number`, `upi_transaction_id`, `status`, `created_at`, `updated_at`, `paid_to`) VALUES
(1, 'Sabarinathan', 'Dextra Techlologies', '9789878987', 'sabarinathan@gmail.com', 2, 'visitor', 1500.00, '2026-03-16', 'upi', NULL, NULL, 'pending', '2026-03-16 05:37:47', '2026-03-16 05:37:47', 3),
(2, 'Visitor 2', 'Dextra', '9988998866', 'visitor2@gmail.com', 3, 'visitor', 1500.00, '2026-03-16', 'upi', '8899888888', '8968585858585', 'paid', '2026-03-16 05:45:45', '2026-03-16 05:45:45', 3);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_expiration_index` (`expiration`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_locks_expiration_index` (`expiration`);

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_reserved_at_available_at_index` (`queue`,`reserved_at`,`available_at`);

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

--
-- Indexes for table `meeting_schedules`
--
ALTER TABLE `meeting_schedules`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `meeting_schedules_meeting_id_unique` (`meeting_id`);

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

--
-- Indexes for table `membership_payments`
--
ALTER TABLE `membership_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `membership_payments_member_id_foreign` (`member_id`);

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

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- Indexes for table `visitors`
--
ALTER TABLE `visitors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `visitors_referred_by_member_id_foreign` (`referred_by_member_id`),
  ADD KEY `visitors_paid_to_foreign` (`paid_to`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `members`
--
ALTER TABLE `members`
  ADD CONSTRAINT `members_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `membership_payments`
--
ALTER TABLE `membership_payments`
  ADD CONSTRAINT `membership_payments_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `visitors`
--
ALTER TABLE `visitors`
  ADD CONSTRAINT `visitors_paid_to_foreign` FOREIGN KEY (`paid_to`) REFERENCES `members` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `visitors_referred_by_member_id_foreign` FOREIGN KEY (`referred_by_member_id`) REFERENCES `members` (`id`) ON DELETE SET NULL;
COMMIT;

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