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

START TRANSACTION;



--
-- Database: `ekcgvafm_MyPrintDatbase545`
--

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

--
-- 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 utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `sexinlocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `fulladdress` varchar(250) DEFAULT NULL,
  `locallanguage` varchar(50) DEFAULT NULL,
  `localname` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `localaddress` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `imagepathoriginal` longtext DEFAULT NULL,
  `imagename` varchar(250) DEFAULT NULL,
  `pata` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_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;

--
-- Dumping data for table `aadharauto`
--

INSERT INTO `aadharauto` (`aadharautoid`, `aadharno`, `originalaadharno`, `aadharname`, `fathername`, `dob`, `dobinlocal`, `gender`, `sexinlocal`, `fulladdress`, `locallanguage`, `localname`, `localaddress`, `imagepathoriginal`, `imagename`, `pata`, `houseno`, `street`, `panchayat`, `vtcandpost`, `dist`, `subdist`, `statename`, `pincode`, `srno`, `createdatetime`, `userid`) VALUES

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

--
-- 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 utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `sexinlocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `fulladdress` varchar(250) DEFAULT NULL,
  `locallanguage` varchar(50) DEFAULT NULL,
  `localname` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `localaddress` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `imagepathoriginal` varchar(250) DEFAULT NULL,
  `imagename` varchar(250) DEFAULT NULL,
  `pata` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_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;

--
-- Dumping data for table `aadharmanual`
--

INSERT INTO `aadharmanual` (`aadharmanualid`, `aadharno`, `originalaadharno`, `aadharname`, `fathername`, `dob`, `dobinlocal`, `gender`, `sexinlocal`, `fulladdress`, `locallanguage`, `localname`, `localaddress`, `imagepathoriginal`, `imagename`, `pata`, `houseno`, `street`, `panchayat`, `vtcandpost`, `dist`, `subdist`, `statename`, `pincode`, `srno`, `createdatetime`, `username`, `userid`, `payment_status`) VALUES

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

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

--
-- Dumping data for table `AxenAadhar_PVC`
--

INSERT INTO `AxenAadhar_PVC` (`id`, `front`, `back`, `pdf`, `username`, `date`) VALUES
(14, 'data:image/png;base64,[encoded data, 511916 characters]