-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 09, 2026 at 10:20 AM
-- Server version: 10.5.29-MariaDB
-- PHP Version: 8.3.26

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

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

--
-- Table structure for table `aadhaarpdf`
--

CREATE TABLE `aadhaarpdf` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `pan_no` varchar(255) DEFAULT NULL,
  `eid` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `pdf_link` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) NOT NULL,
  `ret_wp_no` varchar(255) DEFAULT NULL,
  `aadhaar_no` varchar(255) DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `aadhaar_no`
--

CREATE TABLE `aadhaar_no` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `eid` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `ret_wp_no` varchar(255) DEFAULT NULL,
  `aadhaar_no` varchar(255) DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `aadhaar_no_2`
--

CREATE TABLE `aadhaar_no_2` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `aadhaar_pdf`
--

CREATE TABLE `aadhaar_pdf` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dob` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `aadhaar_Ration`
--

CREATE TABLE `aadhaar_Ration` (
  `id` int(11) NOT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rasan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `district` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `block` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `village` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Family_aadhar` varchar(255) NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `aadharauto`
--

CREATE TABLE `aadharauto` (
  `aadharautoid` int(99) NOT NULL,
  `aadharno` varchar(50) DEFAULT NULL,
  `originalaadharno` varchar(50) DEFAULT NULL,
  `aadharname` varchar(250) DEFAULT NULL,
  `fathername` varchar(250) DEFAULT NULL,
  `dob` varchar(50) DEFAULT NULL,
  `dobinlocal` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `sexinlocal` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `fulladdress` varchar(250) DEFAULT NULL,
  `locallanguage` varchar(50) DEFAULT NULL,
  `localname` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `localaddress` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `imagepathoriginal` longtext DEFAULT NULL,
  `imagename` varchar(250) DEFAULT NULL,
  `pata` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `houseno` varchar(50) DEFAULT NULL,
  `street` varchar(250) DEFAULT NULL,
  `panchayat` varchar(250) DEFAULT NULL,
  `vtcandpost` varchar(150) DEFAULT NULL,
  `dist` varchar(150) DEFAULT NULL,
  `subdist` varchar(150) DEFAULT NULL,
  `statename` varchar(150) DEFAULT NULL,
  `pincode` varchar(50) DEFAULT NULL,
  `srno` int(99) DEFAULT NULL,
  `createdatetime` datetime DEFAULT NULL,
  `userid` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `aadharmanual`
--

CREATE TABLE `aadharmanual` (
  `aadharmanualid` int(99) NOT NULL,
  `aadharno` varchar(50) DEFAULT NULL,
  `originalaadharno` varchar(50) DEFAULT NULL,
  `aadharname` varchar(250) DEFAULT NULL,
  `fathername` varchar(250) DEFAULT NULL,
  `dob` varchar(50) DEFAULT NULL,
  `dobinlocal` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `sexinlocal` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `fulladdress` varchar(250) DEFAULT NULL,
  `locallanguage` varchar(50) DEFAULT NULL,
  `localname` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `localaddress` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `imagepathoriginal` varchar(250) DEFAULT NULL,
  `imagename` varchar(250) DEFAULT NULL,
  `pata` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `houseno` varchar(50) DEFAULT NULL,
  `street` varchar(250) DEFAULT NULL,
  `panchayat` varchar(250) DEFAULT NULL,
  `vtcandpost` varchar(150) DEFAULT NULL,
  `dist` varchar(150) DEFAULT NULL,
  `subdist` varchar(150) DEFAULT NULL,
  `statename` varchar(150) DEFAULT NULL,
  `pincode` varchar(50) DEFAULT NULL,
  `srno` int(99) DEFAULT NULL,
  `createdatetime` datetime DEFAULT NULL,
  `username` varchar(150) DEFAULT NULL,
  `userid` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `payment_status` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `airtelpass`
--

CREATE TABLE `airtelpass` (
  `id` int(25) NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fathername` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `aadhar` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `account` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `cif` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ifsc` varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `actype` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `branch` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `occuption` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `village` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `post` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `block` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `district` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `state` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `pincode` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `mobile` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `userid` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Payment Pending,In Progress, Generated',
  `payment_status` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `AxenAadhar_PVC`
--

CREATE TABLE `AxenAadhar_PVC` (
  `id` int(11) NOT NULL,
  `front` longtext NOT NULL,
  `back` longtext NOT NULL,
  `pdf` longtext NOT NULL,
  `username` varchar(200) NOT NULL,
  `date` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ayushmancard_save_date`
--

CREATE TABLE `ayushmancard_save_date` (
  `id` int(11) NOT NULL,
  `name_aush` varchar(200) DEFAULT NULL,
  `father_name` varchar(200) DEFAULT NULL,
  `crteate_on_date` varchar(200) DEFAULT NULL,
  `type_proof` varchar(200) DEFAULT NULL,
  `pairameeter_ayus` varchar(200) DEFAULT NULL,
  `stats_id` varchar(200) DEFAULT NULL,
  `parameeter_id` varchar(200) DEFAULT NULL,
  `payment_status` varchar(200) DEFAULT NULL,
  `date_check` varchar(200) DEFAULT NULL,
  `save_date` varchar(100) DEFAULT NULL,
  `userid` varchar(100) NOT NULL,
  `phone` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `biometric_issues`
--

CREATE TABLE `biometric_issues` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `certificate_applications`
--

CREATE TABLE `certificate_applications` (
  `id` int(11) NOT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `certificate_type` varchar(255) NOT NULL,
  `applicant_name` varchar(255) NOT NULL,
  `applicant_aadhar` varchar(12) DEFAULT NULL,
  `gender` enum('Male','Female','Other') NOT NULL,
  `date_of_birth` date DEFAULT NULL,
  `date_of_death` date DEFAULT NULL,
  `father_name` varchar(255) NOT NULL,
  `father_aadhar` varchar(12) DEFAULT NULL,
  `mother_name` varchar(255) NOT NULL,
  `mother_aadhar` varchar(12) DEFAULT NULL,
  `address` text NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `aadhaar_no` varchar(255) DEFAULT NULL,
  `pdf_link` varchar(500) NOT NULL,
  `date` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `certificate_applications`
--

INSERT INTO `certificate_applications` (`id`, `appliedby`, `application_no`, `certificate_type`, `applicant_name`, `applicant_aadhar`, `gender`, `date_of_birth`, `date_of_death`, `father_name`, `father_aadhar`, `mother_name`, `mother_aadhar`, `address`, `status`, `fee`, `remark`, `aadhaar_no`, `pdf_link`, `date`) VALUES
(0, 'admin', 'KAFILA35263548', 'birthcertificate', 'rahul', '18888888888', 'Male', '0089-08-07', NULL, 'raja', '789789787867', 'yasin', '000000000000', 'ugjhgjyg', 'success', '35', NULL, '711007675500', 'https://print.mtgcreation.in/admin/uploads/9005509999.pdf', '12th of November 2024 08:56:46 PM'),
(0, '8008357278', 'KAFILA63653207', 'birthcertificate', 'SHAIK AMMAJAN', '968545263524', 'Female', '1992-08-01', NULL, 'SHAIK MASTAN SAHAB', '966352415263', 'SHAIK SYEDA BEE', '502908993313', '1-189,EGUVA VEEDHI,KALLUR,PULICHERLA MANDAL,CHITTOOR,ANDHRA PRADESH,517113', 'success', '35', NULL, '711007675500', 'https://print.mtgcreation.in/admin/uploads/9005509999.pdf', '18th of November 2024 06:09:49 PM'),
(0, '8008357278', 'KAFILA11207093', 'birthcertificate', 'SUNDUPALLI MUNI PRAKASH', '711007675500', 'Male', '2011-07-06', NULL, 'SUNDUPALLI KUMARASWAMY', '908313637900', 'SUNDUPALLI AMARAVATHI', '728498300568', '1-10,POTTISIDDAREDDYGARIPALLI,VENKATADASARIPALLE-CHITTOOR,ANDHRA PRADESH517113', 'success', '35', NULL, '711007675500', 'https://print.mtgcreation.in/admin/uploads/9005509999.pdf', '18th of November 2024 07:55:39 PM'),
(0, '8008357278', 'KAFILA21502634', 'birthcertificate', 'SUNDUPALLI PRAVALLIKA', '967701438032', 'Female', '2013-08-22', NULL, 'SUNDUPALLI KUMARA SWAMY', '908313637900', 'SUNDUPALLI AMARAVATHI', '728498300568', '1-10,POTTISIDDAREDDYGARIPALLI,BODIREDDYGARIPALLI,CHITTOOR,ANDHRA PRADESH-517113', 'success', '35', NULL, '711007675500', 'https://print.mtgcreation.in/admin/uploads/9005509999.pdf', '18th of November 2024 07:59:09 PM');

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

--
-- Table structure for table `complaints`
--

CREATE TABLE `complaints` (
  `complaint_id` bigint(20) NOT NULL,
  `site_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `username` varchar(255) NOT NULL,
  `utrnumber` varchar(100) DEFAULT NULL,
  `complaint_type` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `remark` varchar(500) NOT NULL DEFAULT '',
  `date_time` datetime DEFAULT current_timestamp(),
  `status` enum('Open','Close','') DEFAULT 'Open'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `complaint_aadhaar`
--

CREATE TABLE `complaint_aadhaar` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int(225) NOT NULL,
  `name` varchar(250) NOT NULL,
  `email` varchar(250) NOT NULL,
  `sub` text NOT NULL,
  `mess` text NOT NULL,
  `status` varchar(255) NOT NULL,
  `reply` varchar(500) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `covid_1_2_dose`
--

CREATE TABLE `covid_1_2_dose` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mobail_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `covid_1_dose`
--

CREATE TABLE `covid_1_dose` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mobail_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `covid_2_dose`
--

CREATE TABLE `covid_2_dose` (
  `id` int(11) NOT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dob` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `declaration_form` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_pdf` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `dllist`
--

CREATE TABLE `dllist` (
  `id` int(11) NOT NULL,
  `dlno` varchar(15) NOT NULL,
  `name` varchar(100) NOT NULL,
  `swd` varchar(100) NOT NULL,
  `dob` varchar(10) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `bgroup` varchar(10) NOT NULL,
  `address` longtext NOT NULL,
  `state` varchar(2) NOT NULL,
  `typeofvehicle` varchar(25) NOT NULL,
  `idate` varchar(10) NOT NULL,
  `edate` varchar(10) NOT NULL,
  `ddate` varchar(10) NOT NULL,
  `photo` longtext NOT NULL,
  `sign` longtext NOT NULL,
  `userid` varchar(110) NOT NULL,
  `payment_status` int(1) NOT NULL DEFAULT 1,
  `srno` int(99) DEFAULT NULL,
  `mobileno` text NOT NULL,
  `emailid` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `dlprint`
--

CREATE TABLE `dlprint` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `dl_no` varchar(255) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `response` longtext NOT NULL,
  `status` varchar(255) NOT NULL,
  `message` varchar(300) DEFAULT NULL,
  `fee` int(11) NOT NULL,
  `front` longtext NOT NULL,
  `back` longtext NOT NULL,
  `pdf` longtext NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `dlprint2`
--

CREATE TABLE `dlprint2` (
  `id` int(11) NOT NULL,
  `application_no` varchar(100) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `dl_no` varchar(50) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `response` text DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `fee` decimal(10,2) DEFAULT NULL,
  `front` longblob DEFAULT NULL,
  `back` longblob DEFAULT NULL,
  `pdf` longblob DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `dl_no`
--

CREATE TABLE `dl_no` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dl_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rasan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `father_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `dl_pdf`
--

CREATE TABLE `dl_pdf` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dl_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `gadi_no`
--

CREATE TABLE `gadi_no` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dob` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Chassis_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Engine_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gadi_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `instantpan_find`
--

CREATE TABLE `instantpan_find` (
  `id` int(11) NOT NULL,
  `ip` varchar(500) DEFAULT NULL,
  `application_no` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `aadhaar_no` varchar(255) NOT NULL,
  `pan_no` varchar(255) NOT NULL,
  `clint_id` varchar(300) NOT NULL,
  `status` varchar(200) NOT NULL,
  `status_code` varchar(300) NOT NULL,
  `fee` varchar(200) NOT NULL,
  `old_balance` varchar(255) DEFAULT NULL,
  `new_balance` varchar(588) DEFAULT NULL,
  `message` varchar(220) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `job_card`
--

CREATE TABLE `job_card` (
  `id` int(50) NOT NULL,
  `username` varchar(300) NOT NULL,
  `job_card_no` varchar(300) NOT NULL,
  `status` varchar(300) NOT NULL,
  `pdf` longtext NOT NULL,
  `date` varchar(110) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `kafilapass`
--

CREATE TABLE `kafilapass` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dl_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rasan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `father_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `larning_exam`
--

CREATE TABLE `larning_exam` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dl_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `state_fee` varchar(255) DEFAULT NULL,
  `rasan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `learner_license`
--

CREATE TABLE `learner_license` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dl_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rasan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `matching_dublicate_hkb`
--

CREATE TABLE `matching_dublicate_hkb` (
  `id` int(11) NOT NULL,
  `aadhaar_no` varchar(200) NOT NULL,
  `status` longtext NOT NULL,
  `fee` varchar(11) NOT NULL,
  `code` longtext NOT NULL,
  `generated_eid` varchar(200) NOT NULL,
  `date` varchar(200) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `message` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `m_link`
--

CREATE TABLE `m_link` (
  `id` int(11) NOT NULL,
  `epic_no` varchar(200) NOT NULL,
  `mobile_no` varchar(200) NOT NULL,
  `response` varchar(200) NOT NULL,
  `userid` varchar(200) NOT NULL,
  `date` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `name_to_aadhaar`
--

CREATE TABLE `name_to_aadhaar` (
  `id` int(11) NOT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `aadhaar_no` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `new_pan_request`
--

CREATE TABLE `new_pan_request` (
  `id` int(11) NOT NULL,
  `application_no` varchar(50) DEFAULT NULL,
  `fullname` varchar(100) DEFAULT NULL,
  `dateofbirth` varchar(20) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `fathername` varchar(100) DEFAULT NULL,
  `fulladdress` text DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `mobileNumber` varchar(15) DEFAULT NULL,
  `aadhaarimg` longtext DEFAULT NULL,
  `photoimg` longtext DEFAULT NULL,
  `signimg` longtext DEFAULT NULL,
  `status` enum('pending','process','success','completed','failed') DEFAULT 'pending',
  `status_code` varchar(10) DEFAULT NULL,
  `fee` decimal(10,2) DEFAULT NULL,
  `old_balance` decimal(10,2) DEFAULT NULL,
  `new_balance` decimal(10,2) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `clint_id` varchar(50) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `aadhaarNumber` varchar(20) NOT NULL,
  `statusMessage` text DEFAULT NULL,
  `is_refunded` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `New_Pucc`
--

CREATE TABLE `New_Pucc` (
  `id` int(11) NOT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `gadi` varchar(10) DEFAULT NULL,
  `aadhaar_pdf` longtext DEFAULT NULL,
  `Photo_pdf` longtext DEFAULT NULL,
  `signature_pdf` longtext DEFAULT NULL,
  `pdf_link` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int(11) NOT NULL,
  `message` longtext DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notification`
--

INSERT INTO `notification` (`id`, `message`, `status`, `date`) VALUES
(26, '</marquee><b>\r\n</font></font><b>\r\n<font size=\"+3\">\r\n<font color=\"Yellow\"> <b><marquee bgcolor=blue behavior=\"alternate\">ALL SERVICES INSTANT ( PAN NO FIND 5rs, RASAN CARD PDF 5rs, PAN VERIFY 3rs,DL INSTANT PDF 5rs , FINGER SE AADHAR DOWNLOAD 15rs) \r\n </marquee><b>', '1', '2023-12-15 02:00:13');

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

--
-- Table structure for table `nsdlekyc`
--

CREATE TABLE `nsdlekyc` (
  `id` int(11) NOT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `customer_ref_id` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `middle_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `mode` varchar(255) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `redirect_url` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `api_message` varchar(255) DEFAULT NULL,
  `json_response` varchar(5000) DEFAULT NULL,
  `response_url` varchar(5000) DEFAULT NULL,
  `encdata` longtext DEFAULT NULL,
  `api_type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `panauto`
--

CREATE TABLE `panauto` (
  `id` int(11) NOT NULL,
  `userid` varchar(200) DEFAULT NULL,
  `panno` text NOT NULL,
  `name` text NOT NULL,
  `fathername` text NOT NULL,
  `dob` text NOT NULL,
  `gender` varchar(10) NOT NULL,
  `image` text NOT NULL,
  `signimage` text NOT NULL,
  `create_time` datetime NOT NULL,
  `admin` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `pan_no`
--

CREATE TABLE `pan_no` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `aadhaar_no` varchar(255) DEFAULT NULL,
  `dob` varchar(255) DEFAULT NULL,
  `ret_wp_no` varchar(255) DEFAULT NULL,
  `pan_no` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `pan_pdf`
--

CREATE TABLE `pan_pdf` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `aadhaar_no` varchar(255) DEFAULT NULL,
  `dob` varchar(255) DEFAULT NULL,
  `ret_wp_no` varchar(255) DEFAULT NULL,
  `pan_no` varchar(255) DEFAULT NULL,
  `pdf_link` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `pan_to_uid_find`
--

CREATE TABLE `pan_to_uid_find` (
  `id` int(11) NOT NULL,
  `application_no` varchar(30) NOT NULL,
  `panNumber` varchar(20) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `dob` varchar(20) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `uid` varchar(20) DEFAULT NULL,
  `mobile` varchar(15) DEFAULT NULL,
  `username` varchar(20) DEFAULT NULL,
  `clint_id` varchar(30) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `status_code` varchar(10) DEFAULT NULL,
  `fee` decimal(10,2) DEFAULT NULL,
  `old_balance` decimal(10,2) DEFAULT NULL,
  `new_balance` decimal(10,2) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `passbook`
--

CREATE TABLE `passbook` (
  `id` int(11) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `fathername` varchar(200) NOT NULL,
  `account` varchar(200) NOT NULL,
  `cif` varchar(200) NOT NULL,
  `ifsc` varchar(35) NOT NULL,
  `actype` varchar(200) NOT NULL,
  `branch` varchar(200) NOT NULL,
  `occupation` varchar(200) NOT NULL,
  `village` varchar(200) NOT NULL,
  `post` varchar(200) NOT NULL,
  `block` varchar(200) NOT NULL,
  `district` varchar(200) NOT NULL,
  `state` varchar(200) NOT NULL,
  `pincode` varchar(200) NOT NULL,
  `mobile` varchar(10) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `userid` varchar(10) DEFAULT NULL,
  `date` varchar(25) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL COMMENT 'Payment Pending, In Progress, Generated',
  `payment_status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Table storing passbook application details';

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

--
-- Table structure for table `passport_applications`
--

CREATE TABLE `passport_applications` (
  `id` int(11) NOT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `applicant_name` varchar(255) NOT NULL,
  `father_name` varchar(255) NOT NULL,
  `dob` date NOT NULL,
  `mother_name` varchar(255) NOT NULL,
  `mobile_number` varchar(10) NOT NULL,
  `gmail_id` varchar(255) NOT NULL,
  `parent_contact_number` varchar(255) NOT NULL,
  `pan_pdf_path` varchar(255) NOT NULL,
  `aadhar_pdf_path` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `aadhaar_no` varchar(255) DEFAULT NULL,
  `pdf_link` varchar(500) NOT NULL,
  `date` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `postpass`
--

CREATE TABLE `postpass` (
  `id` int(11) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `account` varchar(200) NOT NULL,
  `cif` varchar(200) NOT NULL,
  `ifsc` varchar(35) NOT NULL,
  `refrence` varchar(200) NOT NULL,
  `mobile` varchar(10) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `userid` varchar(10) DEFAULT NULL,
  `date` varchar(25) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL COMMENT 'Payment Pending, In Progress, Generated',
  `payment_status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Table storing user postpass payment details';

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

--
-- Table structure for table `pricing`
--

CREATE TABLE `pricing` (
  `id` int(11) NOT NULL,
  `service_name` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pricing`
--

INSERT INTO `pricing` (`id`, `service_name`, `price`) VALUES
(1, 'aadhaaar_e-KYC_fee', '20'),
(2, 'aadhar_manual_fee', '10'),
(3, 'rc_vehical_fee', '15'),
(4, 'Aadhaar_To_Pan_find', '20'),
(5, 'pan_details_verify', '10'),
(6, 'instant_pan_manual_fee', '10'),
(7, 'voter_manual_flx', '10'),
(8, 'v_mobile_link', '100'),
(9, 'adhaar_to_ration_details', '10'),
(10, 'ayushman_price', '40'),
(11, 'Driving_Licence_Pdf', '20'),
(12, 'Driving_Licence_Find', '10'),
(13, 'challan_fee', '10'),
(14, 'Aadhar_pdf_fee', '50'),
(15, 'esharm_fee', '50'),
(16, 'Airtel_pas', '10'),
(17, 'Pin_code_Fee', '2'),
(18, 'Fino_pass_fee', '10'),
(19, 'Ippb_pass_fee', '10'),
(20, 'generated_eid_fee', '20'),
(21, 'aadhaar_no', '300'),
(22, 'voter_pdf_instant', '15'),
(23, 'Mobile_Operator_check', '2'),
(24, 'ration_pdf_flx_print_fee', '25'),
(25, 'voter_org_fee', '20'),
(26, 'ration_aadhar_fee', '300'),
(27, 'ration_jh_link_fee', '50'),
(28, 'ration2_uid_findfee', '100'),
(29, 'convert_PVC_fee', '10'),
(35, 'gst_verification', '6'),
(36, 'janAaadhar_PDF_fee', '30'),
(37, 'janadhar_find_fee', '25'),
(38, 'electricBill_details_fee', '5'),
(39, 'dbt_farmer_fee', '20'),
(40, 'elctricbill_pdf_fee', '10'),
(42, 'ehsram_details_find', '120'),
(43, 'pan_adhaar_mask', '2'),
(44, 'eshram_pdf', '120'),
(45, 'pan_adhaar_status', '2'),
(46, 'ennrollment_status_fee', '2'),
(47, 'aadhaar_verify_fee', '2'),
(48, 'ifsc_Verification_fee', '2'),
(49, 'bihar_rtps_all', '6'),
(50, 'bike_2_whiller_fee ', '120'),
(52, 'all_petrol_and_cng_fee', '180'),
(53, 'all_diesel_fee', '230'),
(54, 'normal_puc_fee', '100'),
(55, 'll_request_fee', '100'),
(56, 'Tec_fee', '500'),
(57, 'Pan_apply_fee', '130'),
(58, 'Pan_To_Aadhaar_find', '200'),
(59, 'new_pan_request', '120'),
(60, 'agri_stack_fee', '5'),
(61, 'npci_status_check', '20'),
(62, 'ration_to_adhaar_find_all', '170'),
(63, 'AgriFarmer_PDF_Fee', '20'),
(64, 'student_card_fee', '10'),
(65, 'HaryanaFaimly_Charge', '30'),
(66, 'Chassic_rc_find', '30');

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

--
-- Table structure for table `rasan_card`
--

CREATE TABLE `rasan_card` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dl_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rasan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `rasan_to_aadhar_pdf`
--

CREATE TABLE `rasan_to_aadhar_pdf` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rasan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `district` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `block` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `village` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `rasn_print`
--

CREATE TABLE `rasn_print` (
  `id` int(50) NOT NULL,
  `application_no` varchar(300) NOT NULL,
  `username` varchar(300) NOT NULL,
  `rasan_no` varchar(300) NOT NULL,
  `state` varchar(300) NOT NULL,
  `response` longtext NOT NULL,
  `status` varchar(300) NOT NULL,
  `message` varchar(300) DEFAULT NULL,
  `fee` int(50) NOT NULL,
  `front` longtext NOT NULL,
  `back` longtext NOT NULL,
  `pdf` longtext NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `ration2uid_find`
--

CREATE TABLE `ration2uid_find` (
  `id` int(11) NOT NULL,
  `rationNo` varchar(200) DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `status` varchar(100) DEFAULT 'pending',
  `username` varchar(200) DEFAULT NULL,
  `date` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `rationPdf_Uid`
--

CREATE TABLE `rationPdf_Uid` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `aadhaar` varchar(200) NOT NULL,
  `pdf` longtext NOT NULL,
  `username` varchar(200) NOT NULL,
  `date` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `rc_vehical`
--

CREATE TABLE `rc_vehical` (
  `id` int(50) NOT NULL,
  `username` varchar(300) NOT NULL,
  `rc_vehical_no` varchar(300) NOT NULL,
  `status` varchar(300) NOT NULL,
  `pdf` longtext NOT NULL,
  `date` varchar(110) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `recharge_history`
--

CREATE TABLE `recharge_history` (
  `id` int(11) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `operator` varchar(50) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` varchar(20) NOT NULL,
  `debitamount` varchar(50) DEFAULT NULL,
  `opid` varchar(50) DEFAULT NULL,
  `rbid` varchar(50) DEFAULT NULL,
  `msg` varchar(255) DEFAULT NULL,
  `commission` decimal(10,2) DEFAULT 0.00,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `referal`
--

CREATE TABLE `referal` (
  `id` int(11) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `referred_by` varchar(255) DEFAULT NULL,
  `txn_no` varchar(255) DEFAULT NULL,
  `referral_balance` varchar(255) DEFAULT NULL,
  `total_ref_bal` varchar(255) DEFAULT NULL,
  `refer_date` datetime NOT NULL DEFAULT current_timestamp(),
  `status` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `school_id`
--

CREATE TABLE `school_id` (
  `id` int(11) NOT NULL,
  `userid` varchar(200) DEFAULT NULL,
  `panno` text NOT NULL,
  `name` text NOT NULL,
  `fathername` text NOT NULL,
  `dob` text NOT NULL,
  `gender` text NOT NULL,
  `image` text NOT NULL,
  `signimage` text NOT NULL,
  `create_time` datetime NOT NULL,
  `admin` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `webname` varchar(255) DEFAULT NULL,
  `weburl` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `HomeTemplatename` varchar(255) DEFAULT NULL,
  `ref_bal` varchar(255) DEFAULT NULL,
  `logo` longtext DEFAULT NULL,
  `pgtype` varchar(255) DEFAULT NULL,
  `mid` varchar(255) DEFAULT NULL,
  `mkey` varchar(255) DEFAULT NULL,
  `callback_url` varchar(255) DEFAULT NULL,
  `reg_callback_url` varchar(255) DEFAULT NULL,
  `nsdl_api_key` varchar(255) DEFAULT NULL,
  `nsdl_callback_url` varchar(255) DEFAULT NULL,
  `paytm` int(11) DEFAULT NULL,
  `payu` int(11) DEFAULT NULL,
  `upi` int(11) DEFAULT NULL,
  `qr` varchar(255) NOT NULL DEFAULT '1',
  `upi_id` varchar(255) DEFAULT NULL,
  `payu_mkey` varchar(255) DEFAULT NULL,
  `salt` varchar(255) DEFAULT NULL,
  `upi_key` varchar(2000) DEFAULT NULL,
  `ret_reg_fee` varchar(255) DEFAULT NULL,
  `dist_reg_fee` varchar(255) DEFAULT NULL,
  `rc_flat_com` varchar(255) DEFAULT NULL,
  `airtel_com` varchar(255) DEFAULT NULL,
  `jio_com` varchar(255) DEFAULT NULL,
  `bsnl_com` varchar(255) DEFAULT NULL,
  `vi_com` varchar(255) DEFAULT NULL,
  `dist_com` varchar(255) DEFAULT '20',
  `status` varchar(255) DEFAULT NULL,
  `mobile_recharge_active` tinyint(1) DEFAULT 1,
  `airtal` varchar(10) DEFAULT NULL,
  `vi` varchar(10) DEFAULT NULL,
  `jio` varchar(10) DEFAULT NULL,
  `bsnl` varchar(10) DEFAULT NULL,
  `airtel_digital_tv_dth` varchar(10) DEFAULT NULL,
  `tata_sky_dth` varchar(10) DEFAULT NULL,
  `dishtv_dth` varchar(10) DEFAULT NULL,
  `Videocon_dth` varchar(10) DEFAULT NULL,
  `Sun_Direct_dth` varchar(10) DEFAULT NULL,
  `google_play` varchar(10) DEFAULT NULL,
  `auth_url` varchar(255) DEFAULT 'authorized.flexsecure.in',
  `pgurl` varchar(255) DEFAULT NULL,
  `whurl` varchar(255) DEFAULT NULL,
  `whkey` varchar(255) DEFAULT NULL,
  `whnumber` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `settings` (`id`, `webname`, `weburl`, `phone`, `email`, `address`, `HomeTemplatename`, `ref_bal`, `logo`, `pgtype`, `mid`, `mkey`, `callback_url`, `reg_callback_url`, `nsdl_api_key`, `nsdl_callback_url`, `paytm`, `payu`, `upi`, `qr`, `upi_id`, `payu_mkey`, `salt`, `upi_key`, `ret_reg_fee`, `dist_reg_fee`, `rc_flat_com`, `airtel_com`, `jio_com`, `bsnl_com`, `vi_com`, `dist_com`, `status`, `mobile_recharge_active`, `airtal`, `vi`, `jio`, `bsnl`, `airtel_digital_tv_dth`, `tata_sky_dth`, `dishtv_dth`, `Videocon_dth`, `Sun_Direct_dth`, `google_play`, `auth_url`, `pgurl`, `whurl`, `whkey`, `whnumber`) VALUES
(1, 'One Touch - PAN Online Services , Pan Card Online', 'https://recharge4upoint.xyz', '0000000000', 'YourEmail@gmail.com', 'New Delhi', '', '10', 'https://recharge4upoint.xyz/admin/uploads/703659Flx.png', 'f80527914e919f07cf5c7769b813d5d5', '', '', '', '', '59b215-3d01cd-5f0311-1f106a-43d008', 'http://localhost/ProjectList/AllinOne/admin/nsdl_ekyc_callback.php', 0, 0, 0, '1', '', 'YOURTELEGRAM', 'YOURTELEGRAM', 'f80527914e919f07cf5c7769b813d5d5', '99', '199', '3', '3.0', '3.0', '3.0', '2.5', '30', '1', 1, '0.70', '0.40', '0.10', '0.70', '0', '0', '0', '0', '0', '0', 'authorized.theflexsecurity.com', 'checkout.flexrecharge.online', 'online.flexrecharge.online', 'Your WhatsApp Api Key', '910000000000');

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

--
-- Table structure for table `shram_ax`
--

CREATE TABLE `shram_ax` (
  `id` int(50) NOT NULL,
  `username` varchar(300) NOT NULL,
  `aadhaar_no` varchar(300) NOT NULL,
  `status` varchar(300) NOT NULL,
  `pdf` longtext NOT NULL,
  `date` varchar(110) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tbltrans`
--

CREATE TABLE `tbltrans` (
  `id` int(11) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `username` varchar(150) DEFAULT NULL,
  `transdate` datetime DEFAULT current_timestamp(),
  `transqty` int(11) DEFAULT 0,
  `transtype` varchar(50) DEFAULT NULL,
  `touserid` varchar(100) DEFAULT NULL,
  `tousername` varchar(150) DEFAULT NULL,
  `remark` text DEFAULT NULL,
  `loginid` varchar(100) DEFAULT NULL,
  `logdate` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tec_certificate`
--

CREATE TABLE `tec_certificate` (
  `id` int(11) NOT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `declaration_form` longtext DEFAULT NULL,
  `aadhaar_pdf` longtext DEFAULT NULL,
  `pdf_link` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `uidToaadhar_Axen`
--

CREATE TABLE `uidToaadhar_Axen` (
  `id` int(11) NOT NULL,
  `panNo` varchar(200) DEFAULT NULL,
  `aadhaar` varchar(200) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `father` varchar(200) DEFAULT NULL,
  `dob` varchar(200) DEFAULT NULL,
  `gender` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `mobile` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `username` varchar(200) DEFAULT NULL,
  `date` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `parent` varchar(255) NOT NULL DEFAULT 'admin',
  `referred_by` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `type` text DEFAULT NULL,
  `balance` varchar(255) NOT NULL DEFAULT '0',
  `address` varchar(255) DEFAULT NULL,
  `reg_date` datetime NOT NULL DEFAULT current_timestamp(),
  `order_id` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `reset_token` varchar(255) DEFAULT NULL,
  `reset_expiry` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` (`id`, `parent`, `referred_by`, `name`, `phone`, `email`, `password`, `type`, `balance`, `address`, `reg_date`, `order_id`, `status`, `date`, `reset_token`, `reset_expiry`) VALUES
(1, 'Admin', NULL, 'Admin', '0000000000', '0000000000@gmail.com', 'Tcp9JwOER7396', 'admin', '151388.95', NULL, '2025-04-26 05:13:53', NULL, '1', NULL, NULL, NULL);

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

--
-- Table structure for table `utipsa`
--

CREATE TABLE `utipsa` (
  `id` int(11) NOT NULL,
  `user_id` varchar(20) NOT NULL,
  `status` enum('pending','success','reject') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `vcm_Req`
--

CREATE TABLE `vcm_Req` (
  `id` int(11) NOT NULL,
  `epicNo` varchar(200) DEFAULT NULL,
  `mobileNumber` varchar(15) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `status` varchar(100) DEFAULT 'pending',
  `username` varchar(200) DEFAULT NULL,
  `date` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `voter`
--

CREATE TABLE `voter` (
  `id` int(10) NOT NULL,
  `localdetail` varchar(500) NOT NULL,
  `epicno` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `namel` varchar(200) NOT NULL,
  `gender` varchar(200) NOT NULL,
  `dob` varchar(200) NOT NULL,
  `relation` varchar(200) NOT NULL,
  `fhn` varchar(200) NOT NULL,
  `fhnl` varchar(200) NOT NULL,
  `ps` varchar(200) NOT NULL,
  `acn` varchar(500) NOT NULL,
  `acnl` varchar(500) NOT NULL,
  `tahseel` varchar(200) NOT NULL,
  `partno` varchar(500) NOT NULL,
  `partname` varchar(500) NOT NULL,
  `partnamel` varchar(500) NOT NULL,
  `image` varchar(200) NOT NULL,
  `lang` varchar(200) NOT NULL,
  `adrs` varchar(500) NOT NULL,
  `adrsl` varchar(500) NOT NULL,
  `date` varchar(200) NOT NULL,
  `user` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `voterauto1`
--

CREATE TABLE `voterauto1` (
  `voterautoid` int(11) NOT NULL,
  `votername` varchar(250) DEFAULT NULL,
  `aadharname` varchar(250) DEFAULT NULL,
  `namelocal` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `dob` varchar(50) DEFAULT NULL,
  `dobinlocal` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `genderlocal` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sexlocal` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `spousename` varchar(50) DEFAULT NULL,
  `spousenamelocal` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `fathername` varchar(150) DEFAULT NULL,
  `fatheraadharname` varchar(250) DEFAULT NULL,
  `fathernamelocal` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `epicno` varchar(50) DEFAULT NULL,
  `policestation` varchar(150) DEFAULT NULL,
  `tahshil` varchar(150) DEFAULT NULL,
  `assconnonm` varchar(150) DEFAULT NULL,
  `assconnonmlocal` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `partno` varchar(50) DEFAULT NULL,
  `partname` varchar(250) DEFAULT NULL,
  `partnamelocal` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `locallanguage` varchar(50) DEFAULT NULL,
  `fulladdress` varchar(250) DEFAULT NULL,
  `localaddress` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `pata` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `kaname` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sign` varchar(250) DEFAULT NULL,
  `signlocal` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `assconnameno` varchar(250) DEFAULT NULL,
  `assconnamenolocal` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `partnoandname` varchar(250) DEFAULT NULL,
  `partnoandnamelocal` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `imagepathoriginal` longtext DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `updatestatusdatetime` datetime DEFAULT NULL,
  `updateuserid` int(11) DEFAULT NULL,
  `srno` int(11) DEFAULT NULL,
  `createdatetime` datetime DEFAULT NULL,
  `userid` varchar(200) DEFAULT NULL,
  `payment_status` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `voter_photo`
--

CREATE TABLE `voter_photo` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dob` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `epc_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `voter_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `wallet`
--

CREATE TABLE `wallet` (
  `id` int(11) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `txn_id` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `txn_date` datetime DEFAULT current_timestamp(),
  `email` varchar(255) DEFAULT NULL,
  `PAYMENTMODE` varchar(255) DEFAULT NULL,
  `RESPMSG` varchar(255) DEFAULT NULL,
  `BANKTXNID` varchar(255) DEFAULT NULL,
  `status` enum('pending','success','rejected') NOT NULL DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `wallethistory`
--

CREATE TABLE `wallethistory` (
  `id` int(11) NOT NULL,
  `userid` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `balance` varchar(255) DEFAULT NULL,
  `purpose` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

--
-- Indexes for table `aadharauto`
--
ALTER TABLE `aadharauto`
  ADD PRIMARY KEY (`aadharautoid`);

--
-- Indexes for table `aadharmanual`
--
ALTER TABLE `aadharmanual`
  ADD PRIMARY KEY (`aadharmanualid`);

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

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

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

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

--
-- Indexes for table `complaints`
--
ALTER TABLE `complaints`
  ADD PRIMARY KEY (`complaint_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `voterauto1`
--
ALTER TABLE `voterauto1`
  ADD PRIMARY KEY (`voterautoid`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

--
-- AUTO_INCREMENT for table `aadharauto`
--
ALTER TABLE `aadharauto`
  MODIFY `aadharautoid` int(99) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=882984;

--
-- AUTO_INCREMENT for table `aadharmanual`
--
ALTER TABLE `aadharmanual`
  MODIFY `aadharmanualid` int(99) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=303;

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

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

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

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

--
-- AUTO_INCREMENT for table `complaints`
--
ALTER TABLE `complaints`
  MODIFY `complaint_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `id` int(225) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `rc_vehical`
--
ALTER TABLE `rc_vehical`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=211;

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `voterauto1`
--
ALTER TABLE `voterauto1`
  MODIFY `voterautoid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=286;

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

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

--
-- AUTO_INCREMENT for table `wallethistory`
--
ALTER TABLE `wallethistory`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1788;
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 */;
