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

START TRANSACTION;



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

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `id` int(11) NOT NULL,
  `banner_name` varchar(250) NOT NULL,
  `banner_image` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` (`id`, `banner_name`, `banner_image`) VALUES
(1, 'first', '7.png\r\n'),
(2, 'second', 'images.png');

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

--
-- Table structure for table `birthcertificate_service`
--

CREATE TABLE `birthcertificate_service` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `baby_name` varchar(100) NOT NULL,
  `dob` varchar(30) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `baby_photo` varchar(200) NOT NULL,
  `mother_front_aadhar` varchar(100) NOT NULL,
  `mother_back_aadhar` varchar(100) NOT NULL,
  `father_front_aadhar` varchar(100) NOT NULL,
  `father_back_aadhar` varchar(100) NOT NULL,
  `hospital_slip` varchar(100) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `birthcertificate_service`
--

INSERT INTO `birthcertificate_service` (`id`, `order_id`, `fb_id`, `baby_name`, `dob`, `mobile_number`, `baby_photo`, `mother_front_aadhar`, `mother_back_aadhar`, `father_front_aadhar`, `father_back_aadhar`, `hospital_slip`, `date_time`) VALUES
(1, 320231, '9079740588', '', '', '', '', '', 'upload/images_91769.png', 'upload/images_73400.png', 'upload/images_69783.png', '', '2023-03-05 10:39:51'),
(2, 120525, '9079740588', 'test', '7-12-2002', '1989898789', 'upload/79677.jpg ', 'upload/41299.jpg ', 'upload/images_51824.png', 'upload/images_52761.png', 'upload/images_89490.png', 'upload/images_66815.png', '2023-03-18 12:04:38');

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

--
-- Table structure for table `cast_certificate_services`
--

CREATE TABLE `cast_certificate_services` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `mobile_number` varchar(100) NOT NULL,
  `mother_name` varchar(100) NOT NULL,
  `user_photo` varchar(100) NOT NULL,
  `front_doc_image` varchar(100) NOT NULL,
  `back_image` varchar(100) NOT NULL,
  `other_doc_image` varchar(100) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cast_certificate_services`
--

INSERT INTO `cast_certificate_services` (`id`, `order_id`, `fb_id`, `mobile_number`, `mother_name`, `user_photo`, `front_doc_image`, `back_image`, `other_doc_image`, `date_time`) VALUES
(1, 655280, '9079740588', '494949494966', 'xjkddkdjsaa', 'upload/6713.jpg ', 'upload/images_68954.png', 'upload/images_91243.png', 'upload/images_61532.png', '2023-03-18 12:30:17');

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

--
-- Table structure for table `challan_service`
--

CREATE TABLE `challan_service` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `vehicle_number` varchar(20) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `engine_number` varchar(50) NOT NULL,
  `challan_number` varchar(60) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `challan_service`
--

INSERT INTO `challan_service` (`id`, `order_id`, `fb_id`, `vehicle_number`, `mobile_number`, `engine_number`, `challan_number`, `date_time`) VALUES
(1, 676130, '9079740588', 'RJ36SC2939a', '90797405888', 'jdjffkfa', 'sjisisisa', '2023-03-18 12:55:29');

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

--
-- Table structure for table `death_certificate_service`
--

CREATE TABLE `death_certificate_service` (
  `id` int(11) NOT NULL,
  `applicant_photo` varchar(100) NOT NULL,
  `applicant_front_aadhar` varchar(100) NOT NULL,
  `applicant_back_aadhar` varchar(100) NOT NULL,
  `death_slip` varchar(100) NOT NULL,
  `death_person_front_aadhar` varchar(100) NOT NULL,
  `death_person_back_aadhar` varchar(100) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `fb_id` int(20) NOT NULL,
  `order_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `death_certificate_service`
--

INSERT INTO `death_certificate_service` (`id`, `applicant_photo`, `applicant_front_aadhar`, `applicant_back_aadhar`, `death_slip`, `death_person_front_aadhar`, `death_person_back_aadhar`, `mobile_number`, `fb_id`, `order_id`) VALUES
(1, 'upload/91921.jpg ', '', '', 'upload/images_85675.png', 'upload/images_11861.png', 'upload/7416.jpg ', '9079743041', 2147483647, 928047);

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

--
-- Table structure for table `devices`
--

CREATE TABLE `devices` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `fcm_id` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `devices`
--

INSERT INTO `devices` (`id`, `user_id`, `fcm_id`) VALUES
(1, 0, 'csi06HUHSzKlWh-WXP9XSN:APA91bFlMb-i8VoQ6lfUWX1og7rsPfFUfgV7vCerg11K3Q3L2xI0bxro4s1w3bGl0isR6sqYQnNDdzv-mQgvpjNaoA83vo3lfyYmXqFONET8n7P07BGmXN05pbTN13XxN2QxtvGc21QQ'),
(3, 0, 'eHtKLYqmQhOh7SWlC1yzqV:APA91bFj79ixu817V30KYnsAOEo_Kq88_ofdb-CjtQz93QpU9zUuiD0bRG0XQJz-q_83TtBJxPTexblByLHUDjVBbCmIcxnmGmWW3TDgD442sf2xgMF_yMEWrJ42OzHZxRLwdsee5Jp-'),
(4, 0, 'e9Mly86wRv65xQwK4VlS3h:APA91bECOzeD_u-0ACAzRHXJeoZ6dhlhVPjvpKemb84knG-02MC6o-0ehGIn-Mn7ufXwM-5aMCToWJtSAfUtLVGNbXB7zyPsZBm3aFvqIUdll3M-uTxXsex6swWrmFVprtbMYp87l0QY'),
(5, 0, 'd6bC8smpSRqtmkXFlLHGsx:APA91bGjaoXU0xHiRpqvKUGtG8YxznhvDt6lqqbqMnsdFa4ssjE5p42SdYvJNpGzhhiJH0McFdP3lPLvNw94CRi-xivjd6PBVLiVWXTy0HaR_Zq1_Qv6Rf5AQVcb-LQvJawi_KVXTnU-'),
(6, 0, 'dLUnJsg9QquIQXmWs69yiT:APA91bEpoEpJHc5DZVoCKUNV06kACz1BiT1s_2AsepW8aVMZoMaB-Y6TE7mS8o5L0JXSGdVCm6onLMsflGjq75LeIDyJl51L1_mFLjC60G9h76uouQKBnUl-jaD5R0GlSQNRCppBU6G1'),
(7, 0, 'ewvYcPubT3qHtqPv8tUxSX:APA91bGeyUz61tMajBPko_x1DjsqaOEzrP9OFmRoqfTfkAfOrPPDpHt2mDj_XGqQjzGJPYBjj-gqO6LwUd2gDTDJ6d_-_nK7O7VakrDwwAEQC6q2lXB3ioxJ8aWFaPV7oXyZsRcVbvbU'),
(8, 0, 'ehG6vq4YS82zBYQHm9bGL0:APA91bG4NF5vbD6HVMhdjzOuieG4XAySJljzKA_oCFPsuHFKYVrbsIkVsXRTIHZMqdZmMG7O5v32EGWE-rpzRFo4P9ZBfydECTJlJ3PQRItO99BFDs-HdoPNM0ryn7cRbZuF5Ww5kzQN'),
(9, 0, 'ehG6vq4YS82zBYQHm9bGL0:APA91bEcOrYwZw0Cvmdtuo9oHyyLjNhMsL3gmBcAWMEUeJp_DMo39TE52x3jYfpt_yTExi2lrktViYPnn6NUuyHuJd38DIefTuNiao3XLjFmg22qpMt27Gcqwk-1PKPlvnjvN7o2TtSf'),
(10, 0, 'e1tPX3XsSiKhauPhyBNj1A:APA91bGzoiQ_pbRHVWPMsCk1CUPG08bG5i8IxN0I7n9XG88EOTwPv3cDoCn2KXWM8r6OLrw272hZe372ER7DBTzp8TjdhblNykAHtXErQzpoqtyPi6aRLB49wVRjndIFIkJkYsuaCKJo'),
(11, 0, 'cpFUU8YoS5GZLzF6ufeWbe:APA91bHWMHP9tTJDJSksGvQq-QifFBQaxLYDBLd5jYqZ-MlNRQrUmTg-HYQJ7KpimIQisKgZX3falP1NSCAzir34VkYU3trgG_sbEhSMZgB6Lc_oYnju9Zwhm5ga1hasecPkUBQkH8Du'),
(12, 0, 'feJXdBEFRvGBc6fVRmUHO6:APA91bFKPEZqlOtT833kqqVeNWoNXECr-a7_ekWjxKM_O6ZF_aY-qwRju3SqMKjYbwQwdqXY1dpgq-tbF8gnmH-cj_BB2i5ypweJ_3nZZK6WutAmyf0DoWe4WKCSpJ0O4wLfdaUqvepE'),
(13, 0, 'fMNid0mjTyqJq1yOld375e:APA91bH53hjXieOOtsm1YNC28ZhOQSy-nXdx3uclrMCz4wKQVQsRjIBezA2NndV0R2fywr1JLsxBSxBzpi17eo17ys-N1LKRZ5pehZafYr3vr_XaWCA2tyuz1YFLbbgvjn4R-1ydTcTP'),
(16, 0, 'ck_DKLgOTcGZpsZOYK6I3a:APA91bGWZXjMOXuB4BRMGejiflWIC1KezSZrgd4P02Vqbvzzb-zmA8wuMM448xlqvfLAshLwbNSanp0CrUYW50iLKs0tqYB_o1s_Zlf5Z9G9RDkdiV05yUePDEkqtfkPFVa7vc7Bs-x6'),
(17, 0, 'cb9h-9PCRkOxqtzj8ICoxz:APA91bGL4Cnmo0saau7s9Xdz5TQJD0p9fUfNwG_MNtfaqZlbuviTRrBEXaZspQMHX4Q6fdEtks7JZNxo8GM62rTwXUkf-2pibM4_RIIEqfJGEdxXarL9J514u-oQw9cDnliKtcnfciDE'),
(18, 0, 'eic-BV_8RG6UuwEknz2blh:APA91bEiMFmwKGn3-8qZw_A76ZynzkOTAnLoWsiZo7ATVEu20OXFYMMTXD1GXgZXX7UcUbnOIGufnRg8AU13xOT8hD6rCx5rGk0TSUja5sz21Dit-9gDRC7GQ3ccLv41RaONTttF-kBJ'),
(19, 0, 'd6So9-3gS7W10rZD-gbTua:APA91bGk937Z5D0r-lt5fJJqz2QZHsxW0n0-ons74VVmigJdG3Tbr-Dpr7_2siJybn9hMcH-YdbEL7KaoxPPps07FD85m8rTyYHeS2V3949y_ksQOuEbS_t2rHdC5zJIk-PU-zoZlf7X'),
(20, 0, 'dgIv750_Se6YZc5g2qfMte:APA91bF00IkE9zt1c8BhEQ26BbrfErBwGu3h0XcM7lWvMPyFqwgc9GaVwTDsN0pqZx6LSR74MknrU9ylmwwXMw1yWx1IaSDgVdYTyXFz7jo10KHt_EhWaudHTnbukqpy_6iBby50R-Lv'),
(21, 0, 'c0qC8cvtTleggFdIolfiOg:APA91bH5NWMGbenZQwF5gL_prs2R5_xLbtRfIyYfDWBKiRc_WoDBI2L4XqZ1Mj6YFhcu9O-gfxKdQ4tPzq-hpzc7QxUecltlHd4TrsFRkcejhsiNTf4xjnmU7doEakYApshc7k4cAsuM'),
(22, 0, 'ffdHgAe4RhGOJTtw6tYceP:APA91bEWaZoBK8nxw-8tUFee_Mpq6_4Prr4Hb_p5DVvPLsfSyQbuFEwQ4R-iQsVtxVsIg60nVZyeaJwv0k7UowCXOHPM1X514Lpd895cJjVuhj1h2_3hySKt11_mSRmIL5tCBIXbD8rT'),
(23, 0, 'ey45uy_zTGK5eGrFLMyJ1e:APA91bGWS1bLbyDhVN-FZkocY-mwoF-IkaqGOE6ec3qbV0yBEzwcNr8iYSIgJ4aJTzrzn9yvfc3dwgf4iqQO6o7gksqePXNAjQW-_2rzcjalRHJtZhVBqpXUUclpKjiFPkAGI0-bkv-R'),
(24, 0, 'cOmvDr46T_OKgAPHNV6jdp:APA91bG-bEgDo-t_H2P2OTo6AkP9rR8ISqWDK7g5Mk-sZITE23_ExDVM9tz3v4hDmOSQtXmcujtXZaiLJflUuROGeUEx-FnuZeOnsGbIV1hxv0YHfcoR-YrhYtJjj8qyPlqb4ugF2WNw'),
(25, 0, 'cX4voT2vQJu6nEwPsevLEi:APA91bHrQjz4fKziwN5DNzUD3dOpArmDSvH7WnqoxPp4IwvIdwropYN8o5QobQZtIRK1zJrd1xuU2ffefuMtLKK_Hnueewq4o_65d8sJOXRzY8mncF9Zl2gFmhCBGz0UMJSrt2dktOf-'),
(26, 0, 'egpsazuAQDydhJWyQjrry9:APA91bEMBds2QKbhbRsW3MV2YNYRZZd3vZUlrzRF_sINxmrxxpDMlgvAMMMguXhqHNM5XcIKPJLXg9LUDJkTATCCIfj4xweNZbFsGaLCbQI7DZqTcT4wMy5OXx0NjmYPAtxPnezlNYK2'),
(27, 0, 'dkH-mZzgTSGNj4PalccC0g:APA91bFIuVCu5GBGCignFlIqYK_Y0nhJM2okLK4Dp0DYuWJzUa8VvuH7y-eODscI0HuYEK87-XzoEh25tBLN-6V37yS3s_TYIQVtIC2s0oSnQD-Lk63S_LdHF1j5ZAXuEm0RVVs6bYde'),
(28, 0, 'eCdowIW5SWihpcBJvkF8kI:APA91bEA4EIpNMwC6LrjVQ2ucW1IUTWri8aoMKTEz8O6rXiA_x1lGyL7a9PKQIyMcER_YfellX2HdXRb8hQ-PTvZAl8OjGzdAo5iOTxbkK1b_yVs0anenUq0xlwvzf21R1Z0F4C7x3qd'),
(29, 0, 'etmKMtSJStW_DJkaZYSnIY:APA91bHac2s1ZxugQlxW03Y9qyHADR210x78N9RkzBFxdYjS75m_w29JtKOEvTk9QXlvkOe-RqrHJHz5fh0qtnRXB8yHOHd-7H3PcxvpwsfYozHoiMRIlGk3PeCuUbTJ6g-Jcc22nFW7'),
(30, 0, 'dP8igOiXRHewpVYU9p81iR:APA91bF5o9RI1OcQmi659vzwwunr7go1Gd30ipv9nyVGTF6MZykTP2asBIhZw1eLpkePBvgY3K-tgksfPVge0TGEXwdHDfW-V1dfOTBzikGy62wpLV1grv-BcYkiCVoVAzC3tiZi3q-U'),
(31, 0, 'fSm5TxkJRN2r1bGqYBWYcM:APA91bHWFV4EyPVfHo_1lY6SNNTIyAeDvpxNO6XK3Dfv_jc_QUpjQZAeoMemTOUlR3A3CSmvV6bseY5W3qvZblv7iGD_ZLHtI50fHVaktglyRFvxxYTQRBnDS8xnigVqtJS22lC5SSO-'),
(32, 0, 'f_Lb4p9TQ9uVtCd1i4EU2s:APA91bHmep013duX8lkB7cDRpumdBY4TomKW2kB3bgakHIJEXhtT9_lSDjlgACiZAtQT1ghiooEHTWDncglROLFkQ2N4iveSMeI_l6KmGUpexirNLRSSggisO0w5X8SdEsYstX1pAvmj'),
(33, 0, 'cKa3unnTS--lMNsz88g7IQ:APA91bEwu1N8WnZLApTJkq8BUIgggXjtDEskgQAKEMTe8HauzwFSWxDIaK5W8qHi9ACCr4hZ73xRNoy30e6OuBPoeVrd4kYtktPdWGwlC0qtS0pR3kTDQw_xsXqLua1xgFbzRjumzftO'),
(34, 0, 'eRyuR1qXTn-BI0UUjyPfjl:APA91bG3WTv6qoAi1ghGFGTqNWJpQb9kyv-yevHLaFUF-mZ0KBwKmasw58_oJnuoe2NVnzXGJTfO08eDhGbIsLndsOJOzpP6Sj13vwQ3IgAXpu0So2mfLwfdFRBKlmAaHQXiNEH4dz_-'),
(35, 0, 'dGCQ39MnTOac9k1JIHxbvg:APA91bGMTx5RWKu3VNXQwX_5VBzZABqk8iXk1kcc9v3aBc6cSyAOxebgc8A5q995O8awuGnAzE5Fx6F3h_rGkmfDUYL6CYJ6SoBtIeaFPCV0iVWFjZrSFiYS936ToVRPofonni8blP3f'),
(36, 0, 'eYYNdFZoQ8OL5sm1HKBnjh:APA91bGbtyps6S2WHcT9lymFxnSzEFTHL-vJbTu4ue7wXPfl_ckBed2UmhZTdOkfJ3HEA-oPgRoDVhcCvfmBajShWDo-Gp0OLGzAecmaBzl_UpLjaNlOMFoSj5pOmUFlyVkvxFo_2Inf'),
(37, 0, 'dP8igOiXRHewpVYU9p81iR:APA91bFrnPtkcJk-vx0WSkqZ3C3qdL9drOsD5nYhzACjILoQy63Ne-6ZOGHU4_cN65FTh4xxkuulnq51ED1Z4W8BSB-RItej__w3GFEd_I2-hd1TXaE_N2-xvWLuqw-_fgOemkm5QglZ'),
(38, 0, 'cMifHCbaQPmcepBz8zIg7H:APA91bE9S7PUwjiOAAMFgVHiPUuV_p0M65d7Ae2Ju1qsAF-iZdTOU22yMVNoIosETZIFw9UYe3ptxi5PZup6OnlEATQ553KnXo5hTeGnrIvs1hXZMHI2y8ORexZVv0at1IODcIFhBQW6'),
(39, 0, 'etmKMtSJStW_DJkaZYSnIY:APA91bGsKajZGT8CAYfCciMJAVuc8d_w9N-se9-etl9a_UAle6h03MiMQLGTjpOvpQ2BMMDXkuScsQv_x2093d9ADWCHi93UzROCOVQkCRxXuCkNuO5CB0M-LNtiiKcSzDwsiu_SgIF7'),
(40, 0, 'etmKMtSJStW_DJkaZYSnIY:APA91bHqyqHRHbZ9ImnyUmu_OxL-Ztor0rDsYsn8vJyfyPPDvjCF9PmNC-nvSSEEDqdH3xzDDBNsUz2pl_0_smqjzqfH2km9bNc96gqt4qCerwCWDbsz4AIVCuyqUm84zs7bP1XVyqdn'),
(41, 0, 'emlCMQnyR2qFvuhobxQ661:APA91bGp5gLSqlUDuCZiKGdDqR_kTBzgkSEts5xJmP-Po0SpF5Yxu3xqeuycZaCdHYI93oQKTQFwlANdQzHt4rfPT6uiybNy1dpzFZKALWDpc6tB7BE0gYcHlUqrwTv_WF6NXukfRB1K'),
(42, 0, 'd5b2NIqsQPWPdhwjhGKr0t:APA91bEd0x2T5YkvPSEloYT8sLqT1aN8gKk4Ge1N14dwXFFhgOuICNX0hchq92BtgL8xXUkqpSyerwRXURmeiSPwmfAyDMUwDj9XZc-pTx_7TwtjeEA8xIXS9kB4D7vr91r24fSzkkMp'),
(44, 0, 'eQQb1i8AROKOKtoqM5nIDl:APA91bFOlXXntFiOnww9gTZld2vXwk2P56viuif66eZNrhkgpn-ymjRsi7EMh2f3IuPb5gym6vaMwacn_0fdutGXUW6ryoaFvVaD9Mtvtkz2WXsCqQoM12BVMjLc-kQXhcXBMWH1pChi'),
(46, 0, 'ePTQ0_94TDytTJpz5l5QDs:APA91bEOI3eGMSnattAG9eEYaH-suq0HxLYos7zQFCUp6eO7afCqp0atHHwsUDzyDs0bdR0yiV_PcE-O961lHuLPfNVNpio4u-h8v5Z-yZWsfMsccKm7lJE0r5HRt-mPQQrxQs_rVEsj'),
(49, 0, 'eBYgFWRKRlersZ82a5E505:APA91bGiNIk9AWGc54tPdoi-9QXySrYEC4Jt5QR5p3kS1hD0weHPh1WUFP_KRIw-A-mKhZsCIfEnRiUe8MeDQ4dbVTOKu5X37gbMFvcfYCq02Jc3UzoABN9VtCvUrD9o_VuTd_qK5CTQ'),
(50, 0, 'dzpcWZmpQnWOnKX3nuHHzo:APA91bHGX8Pg0O-GMT3EhfbRpvfZRLkcxaye-eEQyPCkjYqS9Gy3mGvSxyyKrXb9RFPbdVkpbddS_2fMn-_bbhYMkICqNdgBO2bXj42TAJnRUoo4iDPxFQP3gjnuhdHmGb1PU-8PPMXE'),
(51, 0, 'dO-e-hWzQg6G9ljzHc0uYK:APA91bFNVKF7UL0qUuVzhSE4NPQlUmcHSQu5uuE0Y80Pift18J5TB3WSrWFq1UoSP_WdaRtQhEvAnewZTnxV7Wt1UuX20lxDGHbx5y9ci44M0I7EKOpTRf16FX77MuhyPK1QrR8CaWp-'),
(52, 0, 'fxOKs4l6QjmgY_j6dZmNiq:APA91bHkVH8PMPIld5DZwBcEMPg_wtoKAk-tln4gTDFuv0ar_IfbQDPsCDEWUwVr3dwu4PE3x4wzMoAdlhOtLSPBSxIqqaCTVsmQCHzYSRt5RGPVmie4Ffso8F4p8vB379mcncyWG7Uy'),
(56, 0, 'ffZecVmRTWaPi6v3M0nexe:APA91bExcj6X1O7qgSKdZcDS0rrRLh1hhav6QWYfOyYi26zKS49D4j5YQaogVpViaiOx2zml4vBIW18hxiE5ek-TX3w_R4dQygQhZbFpJaPDRw4Ehi2rc6Ykwqe8C-7rUWtnugElQZhh'),
(57, 0, 'flPbhxjETVKovtqGZM9aGR:APA91bErXaas9RGbZdmgQF_21pGS2p8iXGqGGp7_Z5nn6iZlnJlivE_F0cHQs1MEOLMdWJROhVKRTOVIeOz5sCI6EeY6WTqxW8D-EaiKgOBfC9mx0TSFsec1-1_CmDQ6lvoGT026XrrN'),
(60, 0, 'dWnLzgRcSg2Bp9deRVey2N:APA91bF12hyEEzX9_SmIgYAYf3513BOSp5EAKJPpdELfNVOaFDRouFA57WyPd7XfeKQcK6GW1GRdsxyfLAUHldll9mow_QNW8_a_c6VSzKLYFyH9HqndFztGQx4xYltpABKFWq0-9tXF'),
(61, 0, 'eDQarm1wTomJ-bUsdcv3MZ:APA91bG29il_NiTPxS413yJdWjEXUhHDvXXFJNnuZiySX-34XnI3n5Zb5oYQvZ8jrm85mqqYdOEmCK1cFDhoD9DLL_kQC47atYfBNyy96i-gC-qAJ61EKPnq6hvmQ2opRyTBBH0UaHt0'),
(62, 0, 'fyiihq3xQICzrsSlBcVla6:APA91bEXujt0BnJLrDRdFnrmiV1_Jm2ZfSN223hVXGDXkZrYkj5W80EQBdJ3TpGRE11XGmsejQdMkb_kL2yoQO9qo-lpLcRUoRh6WJqxpGHkCj4j35I76zB8n1_5dvm3MlSb_0UjlLmG'),
(63, 0, 'cF1I7Cs7QDWGiNR5YEwa7K:APA91bHZsroV-b3k2EgedSp7pl4Mm89WZxwT_GYwup_wGLkp-UlYM0B7I5DwJhJh3tUcp9sUvhKo_7jdvgr4quKjdQpOKFXjsvVVxrUird_Zr_75OVh3grqh-y1mHTPaNekDbjG6ojsY'),
(64, 0, 'etmKMtSJStW_DJkaZYSnIY:APA91bHOF21WXsFAPZrizkLL1xk6hvO2xN5iBGhP573kUMYGY4Dr0q7IlCaHCxtYgrMyKwDgP68tTL821t2GO8KLTHwai8N6SrRP-qwRdyBJIxWHUz2fa4ZF2In_lW4STiwXOtTaAXZh'),
(65, 0, 'czF6eqtMTeqLDvHG8GLBMi:APA91bEEqbJr3Mpd3Nb3ceUf6XNG9qBUEUOKBQ5y6Ij_jS5FHpomulful0VurmB7T6YC3FEVJxiCG6qoA9D3syEOPYv75VXOa0cjOfnUJR3sE9-G8j37SnbBtutElewtfCdpBZhf2aaR'),
(66, 0, 'egYBr1bTTVOQlcI0w_vR2N:APA91bFZlDNHx241pfezmj__ncUbuBTacyxCVzw1VBcEGWr3r1SUaHX5jZ0NDrEVgwRsSaL4R9wqPUDwpb0_A6JHfECw3ON2rYPrdim-Oy4Itf8IciofmfP7VPXxykhaYiGKM5w6HvU6'),
(67, 0, 'et1L0fGXS2a85WGr9LMUrx:APA91bHeee0tyneBYF-Tps5Yo_ZTWoAXcjcohL606jdQI0oLJg0Nt8PluwKIYUu0r2Mf5bwlrXejLzSyQjkDsp93IQmrs8KCjvFycSeNMAa4f8AEDLou6PWvjrMQeODZ5O_yqnN5mz1D'),
(68, 0, 'duzNCT78RJGBM0X5jvgPOQ:APA91bEiqYAhyU4M2y0M21DVlZN9nIGfmNRyHs6W-V56ppYyDN9OIn-PUpxioCaj1Yppb2ryGkzvgFnaLuG-QN1edzAOye2Sh4LXDQU1Jy4oMN2bdQKWyi4kLBtKqrarIuADDfvZSnD9'),
(69, 0, 'd_EgDyJURvqz9YyaTaxx6e:APA91bGf6LJgdKba6loMUOGgwNEr76Xj-hRSB2ReR5eLmqiFTYmUFp-vV5sNXTOVO9xKLBgYE5mz8EYJdgGfXKy9F-4BnjbqX43kPOGw991Q9HGPifSmeE8d6xfWNQ4fY8zwhOs8BqCd'),
(70, 0, 'drcHgIBFRCG9-QKB1bv_Wq:APA91bHNr8JRrajWb623EYfGeWOqxtgxN8XkQVszpDpKMsnKiGG6B7sC5SmFMUDN4kqXxnPpTR_dA6KWEttAIlvUwI6u_8MKzQxxA_zPDlThFEoZe-_UON1_MIEd3Vvd9EjKzZYoSFgi'),
(71, 0, 'fKIp4vU0Tz2nbwazdYD63L:APA91bEqhCYm7hLcHa51YaGMFIeRX-8g5ZB5UTLz3ONWW0JKJQVrWVPjqr4xuio3vbpRbjKRmjhYgRFtGWbMDBU5LKcD7W-WVRLn84anRkErG7O4U7UsJN1wa75HjVtp1fxxL0CdLj1h'),
(72, 0, 'csVMkTHcR925kOKrB1iadx:APA91bHEqA2LDqr-XMGDGirctBWkXd3n9qGGdFySPKmkMjMOor52-ulMN5T3QIkCH-eF8fXP84OaROc0n1xAAxQe5NbYae_ty37YUQhFo55XNba9ApsRM9yEshbQkINBNO7x0EkwzMIi'),
(73, 0, 'drJayzrdSrqDiF6CC0R4p7:APA91bGt-tOZC15M-DnpeE_dHw4GrwRIEZ59OWQfiQmzowdQIkJUmobme_AGR4TDA_UvhcT_Z3P6E6DoF7i6yxXjJLKi5LOlczFPMMCKP20CCjEHqA-hUXfHA69RrQXY6gm_bSKTaHmi'),
(74, 0, 'fs2L5v_gQ6-jPZQ4mhFLW_:APA91bFR2P6K7FZDkDoHHKCXAUpGEx5pOzFST9R__ZM2DYG3WCcroyQEJNf5_KPCUmwhb6CpS2Z0hs1e8tb_xFBcKD3Ygjs4k5uQYhSwB7u1fxEN2uXugRzBgTVEN5ej2e2LFRx-2mxD'),
(75, 0, 'dtnmjR8mT8qzrC6--j0T1D:APA91bEU5mCwOL5a3mA2HbNgl4Dy7aMToypWy_4UHPZTgh2QfK7OKWDgSSScEbw3VPadK4iK9sDT_czB658ytQu_Z95OG7uJRjkbmghjbV8ic_lE4pIw6_JJOAJw3Mfv-SqSZ6g05zm_'),
(76, 0, 'd_51YcfUSvK80HbrPB_Am2:APA91bFMSAlNeECzarknfuWS2OAcDvQES9dBOhcCBaep3EEPumM3ZL42-M30MHZ5baJP8VthafmHeAeTTrsqmmmc1dcO0iIJ_fVdYOsts0m9CqnacHFIaeMjAdueHSGvHEXOhXpgaSS_'),
(77, 0, 'cPSnTYBtT9m6PvdieYJN-Q:APA91bGgdFjoMVsgPSw0HUZ3r9HlhCCy3oFu2_49i39HghgtUGMHdDuDJuJfFHwsuBSbs0AvWXCEcHsEzjPuGgtGvBiJAKE-UEjxUWheUEO0lO-ERVON8BlUbXe1PfxEq8__Brc4jOdD'),
(78, 0, 'egOQCgD7QuG5SQiFlNJthT:APA91bFjx1FbL3nB2-z5W-ivu6J1PK9cdFF8LQ9pkA1lc2RadHEkIZZ0i0zdmmZEVbo-pNg1M75Adl3Oxwl5EIZGqiysJu_Xgm2YLQ29OduSD1JJkiD4I3-GYOfDlFGZZDIIWcIO_Q-d'),
(79, 0, 'dpVX-crnRxKh1FXj7PMclG:APA91bGRxs76I3kcMqckVC3NciTdpK6EKYqTeYcNu209gzBnyhfYJqsXn92UizxD1j6NSg5DCzmBnEPX5ZL6cplE2OCJ-68umjor9JHd7ocOM2asUU0oj89SG-XEq3M5z-dzZYNY7WZ0'),
(80, 0, 'chSNQR4gRtii2tt2oFlNlZ:APA91bGpWXZz2dJW435AzgoYiCGq_7NGwmwP7YBfZ3vT8uLNK7u2NjLYRNqQnm2zRpz_zKXXUSYEDn1ykl5VchZJ7b7fCbjl5gTAEzbGxfuKAhZmf9eM3DYeZkpUtST3b--JZIqDDYsW'),
(81, 0, 'eGgBaJCiQXuE8KB2z8fU3X:APA91bGZ9Mkv0PL8G3jSBqLCvtotpuWlQSe3FxujoB4sc57Ikxg83fRyQaRR4kMjztaE_F8LspuvuIDkFK7WugZvakQ-yPX9jDlPspuj0YEOlC0Zndw1xRMS4y_4s_o4hHt0uajthGqW'),
(82, 0, 'eAl12nwjR6CxYpEugMgS8_:APA91bG11xISm0ebkDecJj1MmFLjgnVCkWAZcofaP0cBYPKqP0GM3qdouZwP0MUcTAYSrQrvNrIFzUTjgRqT5KkdTTiKghcRSIs6bLnWGJLaq83edsb3S10lDbaUeJBl-ZRbVCZ-BdmE'),
(83, 0, 'c-eSv1GWSwKORipxSqTsAF:APA91bE0ilo7FjYfaJFu0xlQutS8c3OL9KGaiVAclm_6VGiA-apTsgy1HxVrOrT5shTAwG7KddT6ECIrI03a4FXRKqgCWuJPymnVGj72Ysk2VebUEXs2lm6uxc-B_oZdJfc8PHSSaCcI'),
(84, 0, 'c0tNLGcCSKqqydJfQEjGIQ:APA91bGEncktw41NNC8xxNRDF-Zh1PF9d_bagy0D4vcuvXZN8UIVXHpCTJ1z080I3oTMHQT9kfZZZsTt0LgVaMCob-rMWOxnPriF9vpHdhQh2dBUULr0Rom9HiSZyp4UtXTeCCgXQtgQ'),
(85, 0, 'cRPZ7naIQ9myIegDP1oVfC:APA91bEr7TH_xLHsWg7aQRjhKf23xSi9KzrwEHSYrgIR2_q5URcaJbUv_Pc_eYO6XwosabiZ_RorT7wJL5l8X1z_-LcnqrSlDrlc8Nhkz6dADnXa01MLMBMWCGzY08ulJTbUmjhLaOAq'),
(86, 0, 'e-PZMGETSFaqk-jAiQ8LFC:APA91bHC12Hl3Smd9Z0iE-13WF7NdWPb9PIfWp_KKP6rEcn09LlzANwiW20beAu067gXm6fmjE5hq9cPugrJdXB8TFigDi0qmTdFfY6lWaLBdznWVitS0y7mvPiV5F_Y3WDNt_bQ0AEk'),
(87, 0, 'cd-C7ksvQxqL8rtJ8mCKXY:APA91bHzEPNsxBni5Itsj7OmMavZJtCSNYZlVA9oFbPkkKHZKlRjaXTZzVhuFJgqwN4XqOj9QweoFrkZ81t6Pcv_lHBzEyQ_vD3UY7-hv7GICNhnTKnf6RaCbTpOHKB3yKlbeAvhnap2'),
(88, 0, 'cscwrdTYQv6IBQN1ZB85KY:APA91bGFJnW325EX_XVbfIeOuBE7KpeER7PovIAvs1jdl6eV2QgUHb8o9H3KENwVyxCWb0vfRIE33i-U3WBCyv-ocs9LEfT74JsvAJCv2QfPmojDSUpsK5zK0EBG0cbQ5NOf9tCHgpsG'),
(90, 0, 'ch1M9oliSYS2aNWziwFuyE:APA91bG7Gfj8_Rg1uxet3M9c_uC3QSGbpz93uKZhbKqsLZz1fwG0Hx9gn_A-nnAGs4q2uLRkzFYO6Rk2mXyc3ghsfoNScVgElcoBHGhN8uiqzd-lGZiGvcdY15CdyZ86vvQVwwflkYds'),
(91, 0, 'da63dN__QEWFv9xwi0tydf:APA91bFzoE3kPci16aKI5g_6pZO-dwTNLJGRMzjKx6Z4Ds72ZhcCjsygAhhHdaZQ1SZN6VvyaqDwBXCTKe6PzvcqBjCgEfoX_j2De_dODf8Xmq8p0VTftSmifkZhrzEhFgJKn8Pv1V1h'),
(92, 0, 'dKsNHOdvSzePWTSFTd3MFu:APA91bFB9FYvW29M-IJWZ5W2znfzR48dVFdKtx-jYe6UrtE2MYRpCb8McY94CkkuyF0jFNuCT7UX-wIR8Omc46NpPxAtXb5cjRE8ThSvT7yO6iRSZ3WaCWo5u06RiFcVvUFPS6a8yKIw');

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

--
-- Table structure for table `domiclie_certificate_service`
--

CREATE TABLE `domiclie_certificate_service` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `applicant_back_aadhar` varchar(50) NOT NULL,
  `applicant_front_aadhar` varchar(50) NOT NULL,
  `applicant_photo` varchar(50) NOT NULL,
  `bank_passbook` varchar(50) NOT NULL,
  `ration_card` varchar(50) NOT NULL,
  `electricity_bill` varchar(50) NOT NULL,
  `mother_name` varchar(50) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `domiclie_certificate_service`
--

INSERT INTO `domiclie_certificate_service` (`id`, `order_id`, `fb_id`, `applicant_back_aadhar`, `applicant_front_aadhar`, `applicant_photo`, `bank_passbook`, `ration_card`, `electricity_bill`, `mother_name`, `date_time`) VALUES
(1, 265978, '9079740588', 'upload/images_93150.png', 'upload/images_45432.png', 'upload/images_64490.png', 'upload/images_69542.png', 'upload/90317.jpg ', 'upload/images_62427.png', 'Demo test', '2023-03-18 13:16:50');

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

--
-- Table structure for table `driving_licence_service`
--

CREATE TABLE `driving_licence_service` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `blood_group` varchar(10) NOT NULL,
  `applicant_front_aadhar` varchar(100) NOT NULL,
  `applicant_back_aadhar` varchar(100) NOT NULL,
  `tenth_marksheet` varchar(100) NOT NULL,
  `applicant_photo` varchar(100) NOT NULL,
  `signature_photo` varchar(100) NOT NULL,
  `gmail_id` varchar(50) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `epfo_services`
--

CREATE TABLE `epfo_services` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `pan_card` varchar(50) NOT NULL,
  `bank_passbook` varchar(50) NOT NULL,
  `applicant_front_aadhar_photo` varchar(50) NOT NULL,
  `applicant_back_aadhar_photo` varchar(50) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `uan_no` varchar(20) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `epfo_services`
--

INSERT INTO `epfo_services` (`id`, `order_id`, `fb_id`, `pan_card`, `bank_passbook`, `applicant_front_aadhar_photo`, `applicant_back_aadhar_photo`, `mobile_number`, `email`, `uan_no`, `date_time`) VALUES
(1, 486424, '9079740588', 'upload/images_64181.png', 'upload/images_44714.png', 'upload/images_24576.png', 'upload/images_13610.png', '', 'sunil21singh99@gmail.com', '3939494Dkdk', '2023-03-14 09:50:56'),
(2, 780885, '9079740588', 'upload/images_56093.png', 'upload/images_52227.png', 'upload/images_40344.png', 'upload/images_88527.png', '', 'sunil21singh99@gmail.com', '3939494Dkdk', '2023-03-14 09:52:16'),
(3, 207805, '', 'upload/34315.jpg ', 'upload/33796.jpg ', 'upload/97927.jpg ', 'upload/60294.jpg ', '1989898789', 'aman@gmail.com', 'aaads', '2023-03-18 13:21:07');

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

--
-- Table structure for table `handicap_certificate_service`
--

CREATE TABLE `handicap_certificate_service` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `photo` varchar(100) NOT NULL,
  `applicant_front_aadhar` varchar(50) NOT NULL,
  `applicant_back_aadhar` varchar(50) NOT NULL,
  `income_cerificate` varchar(50) NOT NULL,
  `bank_passbook` varchar(50) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `mother_name` varchar(50) NOT NULL,
  `father_name` varchar(50) NOT NULL,
  `cast` varchar(50) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `handicap_certificate_service`
--

INSERT INTO `handicap_certificate_service` (`id`, `order_id`, `fb_id`, `photo`, `applicant_front_aadhar`, `applicant_back_aadhar`, `income_cerificate`, `bank_passbook`, `mobile_number`, `mother_name`, `father_name`, `cast`, `date_time`) VALUES
(1, 939865, '9079740588', 'upload/81408.jpg ', '', '', 'upload/images_56792.png', 'upload/images_50919.png', '44622', 'ryrheyrw ', 'hrehhrdhdhhd. d', 'fhrh d', '2023-03-18 14:02:30');

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

--
-- Table structure for table `handicap_pension_service`
--

CREATE TABLE `handicap_pension_service` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `applicant_front_aadhar` varchar(50) NOT NULL,
  `applicant_back_aadhar` varchar(50) NOT NULL,
  `applicant_photo` varchar(50) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `bank_passbook` varchar(50) NOT NULL,
  `income_certificate` varchar(50) NOT NULL,
  `handicap_certificate` varchar(50) NOT NULL,
  `mother_name` varchar(50) NOT NULL,
  `father_name` varchar(50) NOT NULL,
  `cast` varchar(50) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `handicap_pension_service`
--

INSERT INTO `handicap_pension_service` (`id`, `order_id`, `fb_id`, `applicant_front_aadhar`, `applicant_back_aadhar`, `applicant_photo`, `mobile_number`, `bank_passbook`, `income_certificate`, `handicap_certificate`, `mother_name`, `father_name`, `cast`, `date_time`) VALUES
(1, 974180, '9079740588', '', '', '', '3939393', 'upload/images_98758.png', 'upload/images_19051.png', 'upload/images_74603.png', 'fjjddi', 'fufjffi', 'fifif', '2023-03-14 16:10:08'),
(2, 234167, '8700626287', 'upload/65738.jpg ', '', 'upload/26246.jpg ', '1989898789', 'upload/images_58264.png', 'upload/images_84768.png', 'upload/images_99684.png', 'abc', 'abc', 'jdu3', '2023-03-18 14:08:02');

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

--
-- Table structure for table `help`
--

CREATE TABLE `help` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `orderid` int(11) NOT NULL,
  `message` varchar(200) NOT NULL,
  `email` varchar(100) NOT NULL,
  `type` varchar(20) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `help`
--

INSERT INTO `help` (`id`, `name`, `orderid`, `message`, `email`, `type`, `date_time`) VALUES
(3, 'Sunil Singh', 0, 'hii', 'sunil44singh21@gmail.com', 'Delivery Boy', '2023-02-01 15:37:16'),
(2, 'Sunil Singh', 134, 'cf', 'sunil44singh21@gmail.com', 'Customer', '2023-02-01 15:38:10'),
(4, 'rj', 563256, 'hdggbso8sfofwvo', 'jrjwuv7fuoviddovwvvfahwwuy', 'Customer', '2023-02-01 18:39:37');

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

--
-- Table structure for table `income_certificate_service`
--

CREATE TABLE `income_certificate_service` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `applicant_front_aadhar` varchar(50) NOT NULL,
  `applicant_back_aadhar` varchar(50) NOT NULL,
  `applicant_photo` varchar(50) NOT NULL,
  `voter_id` varchar(50) NOT NULL,
  `document` varchar(50) NOT NULL,
  `mother_name` varchar(50) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `income_certificate_service`
--

INSERT INTO `income_certificate_service` (`id`, `order_id`, `fb_id`, `applicant_front_aadhar`, `applicant_back_aadhar`, `applicant_photo`, `voter_id`, `document`, `mother_name`, `date_time`) VALUES
(1, 228259, '9079740588', 'upload/images_62808.png', 'upload/images_90105.png', 'upload/images_54332.png', 'upload/images_87516.png', 'upload/84581.jpg ', 'ddfffffddddsa', '2023-03-18 13:11:06');

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

--
-- Table structure for table `jeevan_praman_patr_service`
--

CREATE TABLE `jeevan_praman_patr_service` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `applicant_back_aadhar` varchar(50) NOT NULL,
  `applicant_front_aadhar` varchar(50) NOT NULL,
  `applicant_photo` varchar(50) NOT NULL,
  `bank_passbook` varchar(50) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `ppo_number` varchar(40) NOT NULL,
  `email` varchar(40) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jeevan_praman_patr_service`
--

INSERT INTO `jeevan_praman_patr_service` (`id`, `order_id`, `fb_id`, `applicant_back_aadhar`, `applicant_front_aadhar`, `applicant_photo`, `bank_passbook`, `mobile_number`, `ppo_number`, `email`, `date_time`) VALUES
(1, 91624, '9079740588', 'upload/images_88219.png', 'upload/images_72888.png', 'upload/78768.jpg ', 'upload/images_5488.png', '9079539394', 'kskskdkd4', 'sunil21singh99@gmail.com4', '2023-03-18 14:22:40');

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

--
-- Table structure for table `job_applications`
--

CREATE TABLE `job_applications` (
  `id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `father_name` varchar(100) NOT NULL,
  `mother_name` varchar(100) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `dob` varchar(20) NOT NULL,
  `gender` varchar(20) NOT NULL,
  `cottager` varchar(20) NOT NULL,
  `highest_qualification` varchar(40) NOT NULL,
  `address` varchar(100) NOT NULL,
  `remark` varchar(100) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `job_applications`
--

INSERT INTO `job_applications` (`id`, `fb_id`, `name`, `father_name`, `mother_name`, `phone_number`, `email`, `dob`, `gender`, `cottager`, `highest_qualification`, `address`, `remark`, `date_time`) VALUES
(1, '9079740588', 'Sunil Singh', 'Indra Singh', 'Meena Devi', '9079740588', '9079740588', '1999-06-19', 'Male', 'General', 'Under Graduate', 'Rohini Delhi', '', '2023-03-28 15:21:05');

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

--
-- Table structure for table `labour_card_services`
--

CREATE TABLE `labour_card_services` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `photo` varchar(100) NOT NULL,
  `nominee_front_aadhar` varchar(100) NOT NULL,
  `nominee_back_aadhar` varchar(100) NOT NULL,
  `children_front_aadhar` varchar(100) NOT NULL,
  `children_back_aadhar` varchar(100) NOT NULL,
  `bank_passbook` varchar(100) NOT NULL,
  `signature` varchar(100) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `father_name` varchar(50) NOT NULL,
  `mother_name` varchar(50) NOT NULL,
  `proffesion` varchar(50) NOT NULL,
  `thana_name` varchar(50) NOT NULL,
  `cast` varchar(50) NOT NULL,
  `post_office_name` varchar(100) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `labour_card_services`
--

INSERT INTO `labour_card_services` (`id`, `order_id`, `fb_id`, `photo`, `nominee_front_aadhar`, `nominee_back_aadhar`, `children_front_aadhar`, `children_back_aadhar`, `bank_passbook`, `signature`, `mobile_number`, `email`, `father_name`, `mother_name`, `proffesion`, `thana_name`, `cast`, `post_office_name`, `date_time`) VALUES
(1, 962608, '9079740588', 'upload/images_5279.png', 'upload/images_15274.png', 'upload/images_83230.png', 'upload/images_46903.png', 'upload/images_41170.png', 'upload/images_23217.png', 'upload/images_40514.png', '4849449 3', 'sunil44singh@gmail.com3', 'Indra Singh3', 'Meena devi3', 'Application developer3', 'sjsjd3', 'jdu3', '3djdu', '2023-03-18 12:25:24');

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

--
-- Table structure for table `login_status`
--

CREATE TABLE `login_status` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `date_time` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `login_status`
--

INSERT INTO `login_status` (`id`, `name`, `date_time`, `mobile`) VALUES
(112, 'Deepak', '2022-04-25 11:01', ''),
(113, 'Deepak', '2022-04-25 12:10', ''),
(114, 'Deepak', '2022-04-29 01:00', ''),
(115, 'Deepak', '2022-05-10 01:14', ''),
(116, 'Deepak', '2022-05-10 01:14', '');

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

--
-- Table structure for table `mobile_verification`
--

CREATE TABLE `mobile_verification` (
  `mobileno` int(10) NOT NULL,
  `opt` int(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `old_age_pension_service`
--

CREATE TABLE `old_age_pension_service` (
  `id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `order_id` int(11) NOT NULL,
  `photo` varchar(50) NOT NULL,
  `income_certificate` varchar(50) NOT NULL,
  `applicant_front_adhaar` varchar(50) NOT NULL,
  `applicant_back_adhaar` varchar(50) NOT NULL,
  `bank_passbook` varchar(100) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `mother_name` varchar(50) NOT NULL,
  `father_name` varchar(50) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `old_age_pension_service`
--

INSERT INTO `old_age_pension_service` (`id`, `fb_id`, `order_id`, `photo`, `income_certificate`, `applicant_front_adhaar`, `applicant_back_adhaar`, `bank_passbook`, `mobile_number`, `mother_name`, `father_name`, `date_time`) VALUES
(1, '9079740588', 675611, 'upload/images_94357.png', 'upload/94487.jpg ', 'upload/images_80335.png', 'upload/images_27553.png', 'upload/images_94999.png', '1989898789', 'dkffkfa', 'dkdkd', '2023-03-18 13:29:30');

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `fb_id` int(20) NOT NULL,
  `document_number` varchar(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `father_name` varchar(100) NOT NULL,
  `dob` varchar(50) NOT NULL,
  `address` varchar(100) NOT NULL,
  `pincode` varchar(8) NOT NULL,
  `order_id` int(11) NOT NULL,
  `service_name` varchar(100) NOT NULL,
  `service_type` varchar(100) NOT NULL,
  `user_photo` varchar(100) NOT NULL,
  `front_doc_image` varchar(100) NOT NULL,
  `back_doc_image` varchar(100) NOT NULL,
  `other_doc_image` varchar(100) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `fb_id`, `document_number`, `name`, `father_name`, `dob`, `address`, `pincode`, `order_id`, `service_name`, `service_type`, `user_photo`, `front_doc_image`, `back_doc_image`, `other_doc_image`, `date_time`) VALUES
(1, 2147483647, '', '', '', '', '', '', 256602, 'Aadhar Card Service Without Proof', 'Update DOB', 'upload/images_71554png', 'upload/images_26815png', 'upload/images_4208png', 'upload/images_65271png', '2023-03-03 17:10:06'),
(2, 2147483647, '', '', '', '', '', '', 406843, 'Aadhar Card Service Without Proof', 'Update Name', 'upload/images_26946.png', 'upload/images_24930.png', 'upload/images_14831.png', 'upload/images_29126.png', '2023-03-03 17:12:22'),
(3, 2147483647, '', '', '', '', '', '', 949278, 'Aadhar Card Service Without Proof', 'Update Name', 'upload/images_15346.png', 'upload/images_15721.png', 'upload/images_36247.png', 'upload/images_98425.png', '2023-03-04 02:44:44'),
(4, 2147483647, '', '', '', '', '', '', 230610, 'Aadhaar', 'Lost Aadhar', '', '', '', 'upload/images_91068.png', '2023-03-04 04:10:07'),
(5, 2147483647, '2555 6666 6667 7777', 'Sunil Singh', 'Indra Singh', '2023-03-17', 'Uper ki guar Todgarh', '302017', 925173, 'Aadhaar', 'Lost Aadhar', 'upload/61626.jpg ', 'upload/28358.png ', 'upload/88696.jpeg ', 'upload/27089.jpg ', '2023-03-18 11:38:37'),
(6, 2147483647, '', '', '', '', '', '', 594541, 'Aadhaar', 'Lost Aadhar', '', '', '', 'upload/images_86614.png', '2023-03-04 04:17:45'),
(7, 2147483647, 'a33423r', 'testing', 'abc', '2023-03-03', 'Address Goes Here', '24r', 366980, 'Aadhaar', 'Lost Aadhar', 'upload/88497.jpg ', '', '', 'upload/images_64453.png', '2023-03-18 11:40:11');

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

--
-- Table structure for table `pancard_services`
--

CREATE TABLE `pancard_services` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `service_name` varchar(100) NOT NULL,
  `service_type` varchar(100) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `photo` varchar(100) NOT NULL,
  `front_aadhaar` varchar(100) NOT NULL,
  `back_aadhaar` varchar(100) NOT NULL,
  `document` varchar(100) NOT NULL,
  `document_number` varchar(20) NOT NULL,
  `aadhar_number` varchar(20) NOT NULL,
  `father_name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pancard_services`
--

INSERT INTO `pancard_services` (`id`, `order_id`, `service_name`, `service_type`, `fb_id`, `photo`, `front_aadhaar`, `back_aadhaar`, `document`, `document_number`, `aadhar_number`, `father_name`, `email`, `mobile_number`, `date_time`) VALUES
(1, 643278, 'Pan Card Service With Proof', 'Update Address', '9079740588', 'upload/images_9007.png', 'upload/images_27263.png', '', 'upload/images_88422.png', '', '', '', '', '', '2023-03-06 03:45:15'),
(2, 49715, 'Pan Card Service Without Proof', 'Update Address', '9079740588', 'upload/images_98500.png', 'upload/images_1186.png', '', 'upload/images_57113.png', '', '', '', '', '', '2023-03-06 03:57:44'),
(3, 819452, '', '', '9079740588', 'upload/images_67415.png', 'upload/images_16608.png', 'upload/images_8357.png', 'upload/images_21987.png', '', '', 'Indra Singh', 'sunil44singh@gmail.com', '90797333494', '2023-03-06 05:00:09'),
(4, 20738, 'Pan Card', 'Lost Pan Card', '9079740588', '', '', '', '', '282282828', '384844948', '', '', '', '2023-03-06 05:22:48'),
(5, 486382, 'Pan Card Service With Proof a', 'Update Name a', '', 'upload/images_36478.png', 'upload/images_54590.png', 'upload/93134.jpg ', 'upload/images_50797.png', 'a33423r', 'a asa', 'aa', 'abcd@gmail.com', '7011494160', '2023-03-18 12:17:35');

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

--
-- Table structure for table `passport_services`
--

CREATE TABLE `passport_services` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `front_aadhaar` varchar(250) NOT NULL,
  `back_aadhar` varchar(250) NOT NULL,
  `other_doc` varchar(250) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `emergency_number` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `passport_services`
--

INSERT INTO `passport_services` (`id`, `order_id`, `fb_id`, `front_aadhaar`, `back_aadhar`, `other_doc`, `mobile_number`, `emergency_number`, `email`, `date_time`) VALUES
(1, 191904, '9079740588', '', '', 'upload/images_2700.png', '', '', '', '2023-03-05 04:55:00'),
(2, 553416, '9079740588', '', '', 'upload/images_12302.png', '9079740588', '3838383', 'sunil21singh99@gmail.com', '2023-03-05 04:55:15'),
(3, 84437, '9079740588', 'upload/images_91934.png', '', 'upload/images_12044.png', '9079740578', '39393', 'sunil21singh99@gmail.com', '2023-03-05 04:56:38'),
(4, 580239, '8700626287', 'upload/images_85309.png', 'upload/images_43050.png', 'upload/images_17069.png', '8700626287', '796989', 'aman@gmail.com', '2023-03-18 11:46:59');

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

--
-- Table structure for table `police_verification`
--

CREATE TABLE `police_verification` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `applicant_front_aadhar` varchar(50) NOT NULL,
  `applicant_back_aadhar` varchar(50) NOT NULL,
  `applicant_photo` varchar(50) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `thana_name` varchar(20) NOT NULL,
  `father_name` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `police_verification`
--

INSERT INTO `police_verification` (`id`, `order_id`, `fb_id`, `applicant_front_aadhar`, `applicant_back_aadhar`, `applicant_photo`, `mobile_number`, `thana_name`, `father_name`, `email`, `date_time`) VALUES
(1, 147874, '9079740588', 'upload/images_59655.png', 'upload/images_18493.png', 'upload/88979.jpg ', '393949494ssd', 'jdjcckid', 'dididkdddv', 'sunil21singh99@gmail.com', '2023-03-18 14:14:39');

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

--
-- Table structure for table `ration_card_service`
--

CREATE TABLE `ration_card_service` (
  `id` int(11) NOT NULL,
  `fb_id` int(20) NOT NULL,
  `order_id` int(11) NOT NULL,
  `applicant_front_aadhar` varchar(250) NOT NULL,
  `applicant_back_aadhar` varchar(250) NOT NULL,
  `family_front_aadhar` varchar(250) NOT NULL,
  `family_back_aadhar` varchar(250) NOT NULL,
  `applicant_photo` varchar(250) NOT NULL,
  `income_certificate` varchar(250) NOT NULL,
  `bank_passbook` varchar(100) NOT NULL,
  `father_name` varchar(100) NOT NULL,
  `mother_name` varchar(100) NOT NULL,
  `mobile_number` int(20) NOT NULL,
  `emergency_number` int(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `ration_dealer_name` varchar(50) NOT NULL,
  `cast_name` varchar(50) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ration_card_service`
--

INSERT INTO `ration_card_service` (`id`, `fb_id`, `order_id`, `applicant_front_aadhar`, `applicant_back_aadhar`, `family_front_aadhar`, `family_back_aadhar`, `applicant_photo`, `income_certificate`, `bank_passbook`, `father_name`, `mother_name`, `mobile_number`, `emergency_number`, `email`, `ration_dealer_name`, `cast_name`, `date_time`) VALUES
(1, 2147483647, 909036, '', '', 'upload/images_26958.png', 'upload/images_33906.png', 'upload/images_10478.png', 'upload/images_81809.png', '', '', '', 0, 0, '', '', '', '2023-03-05 06:21:00'),
(2, 2147483647, 800341, '', '', 'upload/images_45499.png', 'upload/images_49356.png', 'upload/images_97600.png', 'upload/images_62532.png', '', '', '', 0, 0, '', '', '', '2023-03-05 06:46:32'),
(3, 2147483647, 378542, 'upload/images_92588.png', 'upload/images_88480.png', 'upload/9620.jpg ', 'upload/35650.jpg ', 'upload/33509.jpeg ', 'upload/79344.png ', 'upload/69321.jpg ', 'abc', 'abc', 2147483647, 76969, 'aman@gmail.com', 'aaa', 'aaa', '2023-03-18 11:56:42');

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

--
-- Table structure for table `roadtax_service`
--

CREATE TABLE `roadtax_service` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `vehicle_number` varchar(20) NOT NULL,
  `engine_number` varchar(50) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roadtax_service`
--

INSERT INTO `roadtax_service` (`id`, `order_id`, `fb_id`, `mobile_number`, `vehicle_number`, `engine_number`, `date_time`) VALUES
(1, 228334, '9079740588', '90797405889', 'Rhdjdjdja', 'djdjdaa', '2023-03-18 14:18:28');

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `address` text NOT NULL,
  `phone_no` varchar(200) NOT NULL DEFAULT '',
  `email_id` varchar(200) NOT NULL DEFAULT '',
  `settlor_counter` int(11) NOT NULL,
  `truty_1_counter` int(11) NOT NULL,
  `trusty_2_counter` int(11) NOT NULL,
  `trusty_3_counter` int(11) NOT NULL,
  `si_counter` int(11) NOT NULL,
  `di_counter` int(11) NOT NULL,
  `div_counter` int(11) NOT NULL,
  `gold_price` decimal(11,0) NOT NULL DEFAULT '0',
  `gold_actual_price` int(11) NOT NULL,
  `tax` int(11) NOT NULL DEFAULT '3' COMMENT 'GST',
  `dice_charge` int(11) NOT NULL DEFAULT '2',
  `about_us` longtext,
  `contact_us` longtext,
  `terms` longtext
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `settings` (`id`, `address`, `phone_no`, `email_id`, `settlor_counter`, `truty_1_counter`, `trusty_2_counter`, `trusty_3_counter`, `si_counter`, `di_counter`, `div_counter`, `gold_price`, `gold_actual_price`, `tax`, `dice_charge`, `about_us`, `contact_us`, `terms`) VALUES
(1, 'H.N-568, Dhansa Village, South West, New Delhi-110073', '7210050984', 'rmhse.trust@gmail.com', 0, 0, 0, 0, 0, 0, 0, 5670, 0, 0, 2, NULL, NULL, NULL);

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

--
-- Table structure for table `settingsUpdate`
--

CREATE TABLE `settingsUpdate` (
  `id` int(11) NOT NULL,
  `address` text NOT NULL,
  `phone_no` varchar(200) NOT NULL DEFAULT '',
  `email_id` varchar(200) NOT NULL DEFAULT '',
  `gold_price` decimal(11,0) NOT NULL DEFAULT '0',
  `gold_actual_price` int(11) NOT NULL,
  `tax` int(11) NOT NULL DEFAULT '3' COMMENT 'GST',
  `dice_charge` int(11) NOT NULL DEFAULT '2',
  `about_us` longtext,
  `contact_us` longtext,
  `terms` longtext
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settingsUpdate`
--

INSERT INTO `settingsUpdate` (`id`, `address`, `phone_no`, `email_id`, `gold_price`, `gold_actual_price`, `tax`, `dice_charge`, `about_us`, `contact_us`, `terms`) VALUES
(46, 'demo', '0987654321', 'demo@gmail.com', 2000, 5000, 3, 2, '2022/01/14  07:12:22pm', '0987654321', 'demo'),
(45, 'demo', '0987654321', 'demo@gmail.com', 4920, 5000, 3, 2, '2022/01/12  11:49:51pm', '0987654321', 'demo'),
(43, 'demo', '0987654321', 'demo@gmail.com', 49200, 5000, 3, 2, '2022/01/11  06:19:45pm', '0987654321', 'demo'),
(44, 'demo', '0987654321', 'demo@gmail.com', 4920, 5000, 3, 2, '2022/01/11  06:20:02pm', '0987654321', 'demo'),
(41, 'demo', '0987654321', 'demo@gmail.com', 49600, 5000, 3, 2, '2022/01/10  05:40:52pm', '0987654321', 'demo'),
(42, 'demo', '0987654321', 'demo@gmail.com', 49200, 5000, 3, 2, '2022/01/10  10:03:49pm', '0987654321', 'demo'),
(38, 'demo', '0987654321', 'demo@gmail.com', 52000, 5000, 3, 2, '2022/01/07  06:12:44pm', '0987654321', 'demo'),
(39, 'demo', '0987654321', 'demo@gmail.com', 5200, 5000, 3, 2, '2022/01/07  06:13:35pm', '0987654321', 'demo'),
(40, 'demo', '0987654321', 'demo@gmail.com', 49200, 5000, 3, 2, '2022/01/10  12:21:29pm', '0987654321', 'demo'),
(37, 'demo', '0987654321', 'demo@gmail.com', 5200, 5000, 3, 2, '2022/01/07  06:12:30pm', '0987654321', 'demo'),
(36, 'demo', '0987654321', 'demo@gmail.com', 49200, 5000, 3, 2, '2022/01/07  06:07:14pm', '0987654321', 'demo'),
(47, 'demo', '0987654321', 'demo@gmail.com', 4920, 5000, 3, 2, '2022/01/14  07:13:37pm', '0987654321', 'demo'),
(48, 'demo', '0987654321', 'demo@gmail.com', 2500, 5000, 3, 2, '2022/01/14  07:14:54pm', '0987654321', 'demo'),
(49, 'demo', '0987654321', 'demo@gmail.com', 49200, 5000, 3, 2, '2022/01/14  07:20:48pm', '0987654321', 'demo'),
(50, 'demo', '0987654321', 'demo@gmail.com', 4920, 5000, 3, 2, '2022/01/15  02:35:25pm', '0987654321', 'demo'),
(51, 'demo', '0987654321', 'demo@gmail.com', 5270, 5000, 3, 2, '2022/01/20  04:39:34pm', '0987654321', 'demo'),
(52, 'demo', '0987654321', 'demo@gmail.com', 4910, 5000, 3, 2, '2022/01/20  04:51:09pm', '0987654321', 'demo'),
(53, 'demo', '0987654321', 'demo@gmail.com', 5000, 5000, 3, 2, '2022/01/27  05:54:54pm', '0987654321', 'demo'),
(54, 'demo', '0987654321', 'demo@gmail.com', 6000, 5000, 3, 2, '2022/01/28  03:05:20pm', '0987654321', 'demo'),
(55, 'demo', '0987654321', 'demo@gmail.com', 5000, 5000, 3, 2, '2022/01/28  03:05:40pm', '0987654321', 'demo'),
(56, 'demo', '0987654321', 'demo@gmail.com', 6000, 5000, 3, 2, '2022/01/28  03:07:27pm', '0987654321', 'demo'),
(57, 'demo', '0987654321', 'demo@gmail.com', 4970, 5000, 3, 2, '2022/01/28  04:49:03pm', '0987654321', 'demo'),
(58, 'demo', '0987654321', 'demo@gmail.com', 4970, 5000, 3, 2, '2022/01/28  04:51:55pm', '0987654321', 'demo'),
(59, 'demo', '0987654321', 'demo@gmail.com', 5253, 5000, 3, 2, '2022/01/28  05:15:56pm', '0987654321', 'demo'),
(60, 'demo', '0987654321', 'demo@gmail.com', 5221, 5000, 3, 2, '2022/01/28  05:17:19pm', '0987654321', 'demo'),
(61, 'demo', '0987654321', 'demo@gmail.com', 5180, 5000, 3, 2, '2022/01/29  12:51:53pm', '0987654321', 'demo'),
(62, 'demo', '0987654321', 'demo@gmail.com', 4948, 5000, 3, 2, '2022/01/30  03:42:18pm', '0987654321', 'demo'),
(63, 'demo', '0987654321', 'demo@gmail.com', 5203, 5000, 3, 2, '2022/02/06  01:27:06pm', '0987654321', 'demo'),
(64, 'demo', '0987654321', 'demo@gmail.com', 5220, 5000, 3, 2, '2022/02/08  07:14:28pm', '0987654321', 'demo'),
(65, 'demo', '0987654321', 'demo@gmail.com', 5220, 5000, 3, 2, '2022/02/08  07:15:34pm', '0987654321', 'demo'),
(66, 'demo', '0987654321', 'demo@gmail.com', 5050, 5000, 3, 2, '2022/02/08  07:28:31pm', '0987654321', 'demo'),
(67, 'demo', '0987654321', 'demo@gmail.com', 5220, 5000, 3, 2, '2022/02/08  07:31:44pm', '0987654321', 'demo'),
(68, 'demo', '0987654321', 'demo@gmail.com', 5000, 5000, 3, 2, '2022/02/08  07:34:11pm', '0987654321', 'demo'),
(69, 'demo', '0987654321', 'demo@gmail.com', 5220, 5000, 3, 2, '2022/02/08  07:45:38pm', '0987654321', 'demo'),
(70, 'demo', '0987654321', 'demo@gmail.com', 5220, 5000, 3, 2, '2022/02/08  07:45:59pm', '0987654321', 'demo'),
(71, 'demo', '0987654321', 'demo@gmail.com', 5220, 5000, 3, 2, '2022/02/11  02:26:03pm', '0987654321', 'demo'),
(72, 'demo', '0987654321', 'demo@gmail.com', 5350, 5000, 3, 2, '2022/02/12  06:00:58pm', '0987654321', 'demo'),
(73, 'demo', '0987654321', 'demo@gmail.com', 5400, 5000, 3, 2, '2022/02/12  06:02:32pm', '0987654321', 'demo'),
(74, 'demo', '0987654321', 'demo@gmail.com', 5300, 5000, 3, 2, '2022/02/16  08:33:21pm', '0987654321', 'demo'),
(75, 'demo', '0987654321', 'demo@gmail.com', 5300, 5000, 3, 2, '2022/02/16  08:33:28pm', '0987654321', 'demo'),
(76, 'demo', '0987654321', 'demo@gmail.com', 5410, 5000, 3, 2, '2022/02/18  06:13:37pm', '0987654321', 'demo'),
(77, 'demo', '0987654321', 'demo@gmail.com', 54200, 5000, 3, 2, '2022/02/27  06:54:26pm', '0987654321', 'demo'),
(78, 'demo', '0987654321', 'demo@gmail.com', 55996, 5000, 3, 2, '2022/03/02  02:34:56pm', '0987654321', 'demo'),
(79, 'demo', '0987654321', 'demo@gmail.com', 5599, 5000, 3, 2, '2022/03/02  02:35:29pm', '0987654321', 'demo'),
(80, 'demo', '0987654321', 'demo@gmail.com', 5616, 5000, 3, 2, '2022/03/05  03:33:20pm', '0987654321', 'demo'),
(81, 'demo', '0987654321', 'demo@gmail.com', 5760, 5000, 3, 2, '2022/03/09  05:59:32pm', '0987654321', 'demo'),
(82, 'demo', '0987654321', 'demo@gmail.com', 5599, 5000, 3, 2, '2022/03/14  01:15:54pm', '0987654321', 'demo'),
(83, 'demo', '0987654321', 'demo@gmail.com', 5650, 5000, 3, 2, '2022/03/14  01:17:14pm', '0987654321', 'demo'),
(84, 'demo', '0987654321', 'demo@gmail.com', 55560, 5000, 3, 2, '2022/03/20  11:19:34am', '0987654321', 'demo'),
(85, 'demo', '0987654321', 'demo@gmail.com', 55700, 5000, 3, 2, '2022/03/22  05:10:24pm', '0987654321', 'demo'),
(86, 'demo', '0987654321', 'demo@gmail.com', 5570, 5000, 3, 2, '2022/03/22  05:11:26pm', '0987654321', 'demo'),
(87, 'demo', '0987654321', 'demo@gmail.com', 5570, 5000, 3, 2, '2022/03/22  05:12:40pm', '0987654321', 'demo'),
(88, 'demo', '0987654321', 'demo@gmail.com', 5600, 5000, 3, 2, '2022/03/29  10:57:44am', '0987654321', 'demo'),
(89, 'demo', '0987654321', 'demo@gmail.com', 5600, 5000, 3, 2, '2022/04/08  04:10:26pm', '0987654321', 'demo'),
(90, 'demo', '0987654321', 'demo@gmail.com', 5670, 5000, 3, 2, '2022/04/16  07:03:09pm', '0987654321', 'demo');

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

--
-- Table structure for table `voter_card_service`
--

CREATE TABLE `voter_card_service` (
  `id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `order_id` int(11) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `email` varchar(60) NOT NULL,
  `father_name` varchar(60) NOT NULL,
  `mother_name` varchar(60) NOT NULL,
  `thana_name` varchar(60) NOT NULL,
  `cast` varchar(50) NOT NULL,
  `postoffice` varchar(50) NOT NULL,
  `applicant_front_adhaar` varchar(50) NOT NULL,
  `applicant_back_adhaar` varchar(50) NOT NULL,
  `applicant_photo` varchar(100) NOT NULL,
  `document` varchar(100) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `voter_card_service`
--

INSERT INTO `voter_card_service` (`id`, `fb_id`, `order_id`, `mobile_number`, `email`, `father_name`, `mother_name`, `thana_name`, `cast`, `postoffice`, `applicant_front_adhaar`, `applicant_back_adhaar`, `applicant_photo`, `document`, `date_time`) VALUES
(1, '9079740588', 53151, '4955950053', 'didikddi3', 'wd', 'fmfmfmf312', 'ee', 'e', 'e', 'upload/59399.jpg ', 'upload/images_25750.png', 'upload/images_3639.png', 'upload/53497.jpg ', '2023-03-18 13:05:24');

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

--
-- Table structure for table `widow_pension_service`
--

CREATE TABLE `widow_pension_service` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `fb_id` varchar(20) NOT NULL,
  `photo` varchar(50) NOT NULL,
  `income_certificate` varchar(50) NOT NULL,
  `applicant_front_adhaar` varchar(50) NOT NULL,
  `applicant_back_adhaar` varchar(50) NOT NULL,
  `bank_passbook` varchar(50) NOT NULL,
  `death_certificate` varchar(50) NOT NULL,
  `mobile_number` varchar(20) NOT NULL,
  `mother_name` varchar(50) NOT NULL,
  `father_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `widow_pension_service`
--

INSERT INTO `widow_pension_service` (`id`, `order_id`, `fb_id`, `photo`, `income_certificate`, `applicant_front_adhaar`, `applicant_back_adhaar`, `bank_passbook`, `death_certificate`, `mobile_number`, `mother_name`, `father_name`) VALUES
(1, 696759, '9079740588', 'upload/43807.jpg ', 'upload/images_27881.png', '', '', 'upload/images_94532.png', 'upload/images_96571.png', '4945995533', 'zjxjx33', 'ciffi33');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

