-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- 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 `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 `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 `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 `shram_ax`
--
ALTER TABLE `shram_ax`
  ADD PRIMARY KEY (`id`);

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

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

--
-- 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 `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 `uidToaadhar_Axen`
--
ALTER TABLE `uidToaadhar_Axen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

