-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Sep 21, 2025 at 08:51 AM
-- Server version: 11.8.3-MariaDB-log
-- PHP Version: 7.2.34

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

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

--
-- 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_uca1400_ai_ci DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `sexinlocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `fulladdress` varchar(250) DEFAULT NULL,
  `locallanguage` varchar(50) DEFAULT NULL,
  `localname` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `localaddress` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `imagepathoriginal` longtext DEFAULT NULL,
  `imagename` varchar(250) DEFAULT NULL,
  `pata` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_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_uca1400_ai_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 utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `sexinlocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `fulladdress` varchar(250) DEFAULT NULL,
  `locallanguage` varchar(50) DEFAULT NULL,
  `localname` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `localaddress` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `imagepathoriginal` longtext DEFAULT NULL,
  `imagename` varchar(250) DEFAULT NULL,
  `pata` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_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_uca1400_ai_ci DEFAULT NULL,
  `payment_status` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `aadhar_org_pdf`
--

CREATE TABLE `aadhar_org_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `aadhar_otp_pdf`
--

CREATE TABLE `aadhar_otp_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `aadhar_pvc_pdf`
--

CREATE TABLE `aadhar_pvc_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `agri_farmer_pdf`
--

CREATE TABLE `agri_farmer_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `dbt_farmer_br_pdf`
--

CREATE TABLE `dbt_farmer_br_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime 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,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `electric_pdf`
--

CREATE TABLE `electric_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `eshrampdf`
--

CREATE TABLE `eshrampdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `family_pdf`
--

CREATE TABLE `family_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime 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,
  `application_no` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `aadhaar_no` varchar(255) NOT NULL,
  `pan_no` varchar(255) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `janaadhar_pdf`
--

CREATE TABLE `janaadhar_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `llexam_requests`
--

CREATE TABLE `llexam_requests` (
  `id` int(11) NOT NULL,
  `user_applno` varchar(50) NOT NULL,
  `application_no` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `dob` varchar(20) NOT NULL,
  `status` enum('Pending','Success','Refunded','Failed') DEFAULT 'Pending',
  `pdf` longtext DEFAULT NULL,
  `phone` varchar(15) NOT NULL,
  `amount` decimal(10,2) DEFAULT 0.00,
  `date` datetime DEFAULT current_timestamp(),
  `request_time` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_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_uca1400_ai_ci;

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

INSERT INTO `notification` (`id`, `message`, `status`, `date`) VALUES
(1, 'ALL SERVICE WORKING FINE\r\n\r\nTELEGRAM CHANNEL JOIN ', 'success', '2024-08-27 20:35:17');

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

--
-- Table structure for table `nsdl_requests`
--

CREATE TABLE `nsdl_requests` (
  `id` int(11) NOT NULL,
  `name` varchar(150) DEFAULT NULL,
  `mobile` varchar(15) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `application_type` varchar(10) DEFAULT NULL,
  `application_mode` varchar(20) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `p_order_id` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT 'Pending',
  `encrypted_data` text DEFAULT NULL,
  `ack_no` varchar(100) DEFAULT NULL,
  `date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `pan2uid_find`
--

CREATE TABLE `pan2uid_find` (
  `id` int(11) NOT NULL,
  `panNo` varchar(200) DEFAULT NULL,
  `aadhaar` varchar(200) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `dob` varchar(200) DEFAULT NULL,
  `gender` 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;

--
-- Dumping data for table `pan2uid_find`
--

INSERT INTO `pan2uid_find` (`id`, `panNo`, `aadhaar`, `name`, `dob`, `gender`, `status`, `username`, `date`) VALUES
(1, 'KTYPK8803G', '680074641793', 'Vikas  Kumar', '01/01/2002', 'Male', 'completed', 'admin', '2025-09-20 14:18:49');

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

--
-- Table structure for table `pan2uid_find_instant`
--

CREATE TABLE `pan2uid_find_instant` (
  `id` int(11) NOT NULL,
  `panNo` varchar(200) DEFAULT NULL,
  `aadhaar` varchar(200) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `dob` varchar(200) DEFAULT NULL,
  `gender` 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 `panauto`
--

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

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

--
-- Table structure for table `pan_details`
--

CREATE TABLE `pan_details` (
  `id` int(11) NOT NULL,
  `application` varchar(50) NOT NULL,
  `username` varchar(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `pan` varchar(20) NOT NULL,
  `dob` varchar(255) DEFAULT NULL,
  `gender` varchar(10) NOT NULL,
  `fathername` varchar(100) NOT NULL,
  `aadhar` varchar(20) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

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

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

CREATE TABLE `postpass` (
  `id` int(11) NOT NULL,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci DEFAULT NULL,
  `account` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci NOT NULL,
  `cif` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci NOT NULL,
  `ifsc` varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci NOT NULL,
  `refrence` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci NOT NULL,
  `mobile` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci DEFAULT NULL,
  `userid` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci DEFAULT NULL,
  `date` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci DEFAULT NULL,
  `status` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci DEFAULT NULL COMMENT 'Payment Pending,In Progress, Generated',
  `payment_status` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

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

INSERT INTO `pricing` (`id`, `service_name`, `price`) VALUES
(1, 'tng_aadhar_advance', '30'),
(2, 'aadhar_manual', '20'),
(3, 'bank_pass_book', '10'),
(4, 'pan_advance_print', '20'),
(5, 'tng_pan_details', '10'),
(6, 'tng_pan_panfind', '20'),
(7, 'aadhar_print_pdf_a', '40'),
(8, 'aadhar_validation_fee', '5'),
(9, 'aadhar_pvc_pdf_fee', '18'),
(10, 'AgriFarmerCardPdf_a', '30'),
(11, 'aadhar_to_ration_pdf_fee', '20'),
(12, 'aadhar_to_ration_find_fee', '10'),
(13, 'Pan_To_Aadhar_Find_a', '150'),
(14, 'ration_pdf_fee', '10'),
(15, 'rationt_to_aadhar_up_a', '100'),
(16, 'rationt_to_aadhar_wb_a', '130'),
(17, 'ration_to_uid_all', '200'),
(77, 'voter_to_mobile_link_without_otp_a', '20'),
(78, 'voter_mobile_link_a', '15'),
(79, 'voter_pdf_fee', '10'),
(80, 'dlFindfee', '20'),
(81, 'dl_pdf_fee', '20'),
(82, 'Vehicle_pdf_fee', '30'),
(83, 'challan_fee', '10'),
(84, 'vehicle_2_mobile', '50'),
(85, 'rc_2_fasttag', '50'),
(86, 'rto_find_fee', '5'),
(87, 'chassis_2_rc', '50'),
(88, 'mobile_2_pan', '50'),
(89, 'gstin_2_contact', '50'),
(90, 'gst_to_pan_fee', '10'),
(91, 'gst_to_pan_details_fee', '20'),
(92, 'pan_to_gst_fee', '20'),
(93, 'janadhar_find_fee', '20'),
(94, 'janadhar_pdf_fee', '30'),
(95, 'dbtAgriculture_br_pdf_a', '20'),
(96, 'electricBillPDF_Br_a', '5'),
(97, 'family_Id_pvc_card_pdf_up_a', '20'),
(98, 'rtps_pdf_fee', '5'),
(99, 'mobile_2_lpg', '50'),
(100, 'uid_to_mask_pan_fee', '2'),
(101, 'pan_to_mask_uid_fee', '2'),
(102, 'nsdl_new_pan_fee', '107'),
(103, 'nsdl_new_pan_activation_charge', '51'),
(104, 'sambal_pvc_card_pdf_mp_a', '20'),
(105, 'samagra_pvc_card_pdf_mp_a', '20'),
(106, 'mobile_to_look_up_details_find_a', '2'),
(107, 'Post_Office_To_Details_Find_a', '2'),
(108, 'PinCode_To_Details_Find_a', '2'),
(109, 'ifsc_lookup', '2'),
(110, 'aadhaar_otp_pdf_fee', '10'),
(111, 'rationt_to_aadhar_up_a', '100'),
(112, 'eshram_pdf_fee', '50'),
(113, 'pan_manual_fee', '10'),
(114, 'voter_advance_fee', '20'),
(115, 'engine_2_rc', '50'),
(116, 'llexam_fee', '100'),
(117, 'pan_to_msme_udyam_fee', '70'),
(118, 'mobile_to_msme_udyam_fee', '70'),
(119, 'udyam_number_to_msme_udyam_fee', '100');

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

--
-- Table structure for table `ration_pdf`
--

CREATE TABLE `ration_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `ration_to_aadhar_requests`
--

CREATE TABLE `ration_to_aadhar_requests` (
  `id` int(11) NOT NULL,
  `userid` varchar(20) NOT NULL,
  `ration_no` varchar(30) NOT NULL,
  `order_id` varchar(50) NOT NULL,
  `status` enum('Pending','Success','Failed') NOT NULL DEFAULT 'Pending',
  `request_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_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,
  `agentid` 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_uca1400_ai_ci;

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

--
-- Table structure for table `rtps_pdf`
--

CREATE TABLE `rtps_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `samgra_pdf`
--

CREATE TABLE `samgra_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB 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,
  `wt_status` varchar(255) DEFAULT NULL,
  `telegram` varchar(255) DEFAULT NULL,
  `user_commission` varchar(255) DEFAULT NULL,
  `payment_status` 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,
  `tng_apikey` varchar(100) NOT NULL,
  `tng_apiurl` varchar(100) NOT NULL,
  `tng_gatewaye_apikey` varchar(200) DEFAULT NULL,
  `tng_gatewaye_url` varchar(100) NOT NULL,
  `tng_wa_apikey` varchar(255) DEFAULT NULL,
  `tng_wa_sender` varchar(255) DEFAULT NULL,
  `otp_option` varchar(255) DEFAULT NULL,
  `ret_reg_fee` varchar(255) DEFAULT NULL,
  `dist_reg_fee` varchar(255) DEFAULT NULL,
  `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,
  `status` varchar(255) DEFAULT NULL,
  `mobile_recharge_active` tinyint(1) DEFAULT 1,
  `dth_recharge_active` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

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

INSERT INTO `settings` (`id`, `webname`, `weburl`, `phone`, `email`, `address`, `HomeTemplatename`, `ref_bal`, `logo`, `wt_status`, `telegram`, `user_commission`, `payment_status`, `reg_callback_url`, `nsdl_api_key`, `nsdl_callback_url`, `paytm`, `payu`, `upi`, `qr`, `upi_id`, `tng_apikey`, `tng_apiurl`, `tng_gatewaye_apikey`, `tng_gatewaye_url`, `tng_wa_apikey`, `tng_wa_sender`, `otp_option`, `ret_reg_fee`, `dist_reg_fee`, `airtal`, `vi`, `jio`, `bsnl`, `airtel_digital_tv_dth`, `tata_sky_dth`, `dishtv_dth`, `Videocon_dth`, `Sun_Direct_dth`, `google_play`, `status`, `mobile_recharge_active`, `dth_recharge_active`) VALUES
(1, 'Your Print', NULL, '#', 'NA', 'DELHI', 'payoon', '10', NULL, 'whatsapp', 'https://t.me/yourusername', '3.0', '1', 'NA', 'NA', 'NA', 0, 0, 1, '', 'NA', '', 'https://secure.thenextgenapi.co.in', NULL, 'https://secure.thenextgenapi.co.in', '', '', 'no', '99', '199', '1.5', '3.5', '1.2', '4.0', '3.0', '3.0', '3.0', '3.0', '2.2', '1.0', '1', 1, 1);

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

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

CREATE TABLE `users` (
  `id` int(10) 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,
  `balance` varchar(255) DEFAULT '0',
  `address` varchar(255) DEFAULT NULL,
  `reg_date` datetime NOT NULL DEFAULT current_timestamp(),
  `order_id` varchar(255) DEFAULT NULL,
  `status` enum('0','1') DEFAULT '0',
  `otp_system` enum('yes','no') DEFAULT 'yes',
  `nsdl_status` enum('active','inactive') DEFAULT 'inactive',
  `branch_code` varchar(50) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `type` enum('admin','retailer','distributor','prime','user') NOT NULL DEFAULT 'retailer'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

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

INSERT INTO `users` (`id`, `parent`, `referred_by`, `name`, `phone`, `email`, `password`, `balance`, `address`, `reg_date`, `order_id`, `status`, `otp_system`, `nsdl_status`, `branch_code`, `date`, `type`) VALUES
(1, 'admin', 'admin', 'ADMIN', 'admin', 'admin@gmail.com', '$2y$10$PTex7.0QvZzpiRLdO.EW0umEZcDaGoj5T5q9bzRilr7p9A84hL0wO', '100000', 'admin', '2025-09-21 08:51:40', NULL, '1', 'no', 'inactive', NULL, NULL, 'admin');

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

--
-- Table structure for table `vehicle_pdf`
--

CREATE TABLE `vehicle_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `voterauto1` (
  `voterautoid` int(99) NOT NULL,
  `votername` varchar(250) DEFAULT NULL,
  `aadharname` varchar(250) DEFAULT NULL,
  `namelocal` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `dob` varchar(50) DEFAULT NULL,
  `dobinlocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `genderlocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `sexlocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `spousename` varchar(50) DEFAULT NULL,
  `spousenamelocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `fathername` varchar(150) DEFAULT NULL,
  `fatheraadharname` varchar(250) DEFAULT NULL,
  `fathernamelocal` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_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 utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `partno` varchar(50) DEFAULT NULL,
  `partname` varchar(250) DEFAULT NULL,
  `partnamelocal` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `locallanguage` varchar(50) DEFAULT NULL,
  `fulladdress` varchar(250) DEFAULT NULL,
  `localaddress` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `pata` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `kaname` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `sign` varchar(250) DEFAULT NULL,
  `signlocal` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `assconnameno` varchar(250) DEFAULT NULL,
  `assconnamenolocal` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `partnoandname` varchar(250) DEFAULT NULL,
  `partnoandnamelocal` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
  `imagepathoriginal` longtext DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `updatestatusdatetime` datetime DEFAULT NULL,
  `updateuserid` int(99) DEFAULT NULL,
  `srno` int(99) DEFAULT NULL,
  `createdatetime` datetime DEFAULT NULL,
  `userid` varchar(200) DEFAULT NULL,
  `payment_status` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `voter_pdf`
--

CREATE TABLE `voter_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pdf` longtext DEFAULT NULL,
  `date` datetime 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') NOT NULL DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

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

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

CREATE TABLE `wallethistory` (
  `id` int(11) NOT NULL,
  `userid` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `oldbalance` varchar(100) DEFAULT NULL,
  `balance` varchar(255) DEFAULT NULL,
  `purpose` longtext 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_uca1400_ai_ci;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `ration_to_aadhar_requests`
--
ALTER TABLE `ration_to_aadhar_requests`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `userid_ration_unique` (`userid`,`ration_no`);

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

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

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

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

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

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

--
-- Indexes for table `voter_pdf`
--
ALTER TABLE `voter_pdf`
  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 `aadharauto`
--
ALTER TABLE `aadharauto`
  MODIFY `aadharautoid` int(99) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `pan2uid_find_instant`
--
ALTER TABLE `pan2uid_find_instant`
  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 for table `pan_details`
--
ALTER TABLE `pan_details`
  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 for table `pricing`
--
ALTER TABLE `pricing`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=120;

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `voterauto1`
--
ALTER TABLE `voterauto1`
  MODIFY `voterautoid` int(99) NOT NULL AUTO_INCREMENT;

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