[BLOB]', '13/06/2024 7:03:14');

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

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

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

--
-- Dumping data for table `referal`
--

INSERT INTO `referal` (`id`, `phone`, `referred_by`, `txn_no`, `referral_balance`, `total_ref_bal`, `refer_date`, `status`) VALUES
(31, '8780203649', '7870814228', 'REF32776', '5', NULL, '2023-02-13 20:24:52', '1'),
(32, '9903428725', '6290007518', 'REF70282', '5', NULL, '2023-02-14 12:45:16', '1'),
(33, '8755367449', '9068182749', 'REF51959', '5', NULL, '2023-02-15 11:02:55', '1'),
(34, '9118785053', '8881983196', 'REF90271', '5', NULL, '2023-02-18 14:33:46', '1'),
(35, '7004603746', '7870814228', 'REF69029', '5', NULL, '2023-02-18 18:51:35', '1'),
(36, '9571395974', '7891500811', 'REF42827', '5', NULL, '2023-02-21 15:34:39', '1'),
(37, '7980603437', '6290007518', 'REF1397', '5', NULL, '2023-03-02 07:33:23', '1'),
(38, '8429222714', '6302195751', 'REF1221', '5', NULL, '2023-03-03 08:29:13', '1'),
(39, 'DHAKA', '8830017643', 'REF17066', '5', NULL, '2023-03-16 17:58:25', '1'),
(40, '6284064831', '9914734010', 'REF54002', '5', NULL, '2023-03-23 12:16:24', '1'),
(41, 'Yadav', '9936741231', 'REF84654', '5', NULL, '2023-03-25 16:20:24', '1'),
(42, '9142499134', '7773811452', 'REF62279', '5', NULL, '2023-03-26 08:01:33', '1'),
(43, '9310749227', '8882191393', 'REF91924', '5', NULL, '2023-04-16 12:36:16', '1'),
(44, '9876963088', '9897521386', 'REF22782', '5', NULL, '2023-04-16 20:54:48', '1'),
(45, '9044744456', '9897521386', 'REF19415', '5', NULL, '2023-04-16 21:45:16', '1'),
(46, '9548368757', '7037779592', 'REF72764', '5', NULL, '2023-04-17 09:58:53', '1'),
(47, '4682937518', '7037779592', 'REF93395', '5', NULL, '2023-04-17 10:04:55', '1'),
(48, '22588966', '7037779592', 'REF7481', '5', NULL, '2023-04-17 10:11:48', '1'),
(49, '2556363636', '7037779592', 'REF39052', '5', NULL, '2023-04-17 10:30:47', '1'),
(50, '1521521521', '7037779592', 'REF56724', '5', NULL, '2023-04-17 10:32:35', '1'),
(51, '2525252525', '7037779592', 'REF9326', '5', NULL, '2023-04-17 10:37:16', '1'),
(52, '5757875758', '7037779592', 'REF59259', '5', NULL, '2023-04-17 10:37:55', '1'),
(53, '9336939632', '7037779592', 'REF26777', '5', NULL, '2023-04-17 10:38:56', '1'),
(54, '5225255886', '7037779592', 'REF33512', '5', NULL, '2023-04-17 10:40:08', '1'),
(55, '9878007072', '9897521386', 'REF6541', '5', NULL, '2023-04-17 20:35:56', '1'),
(56, '9000322802', '8074172236', 'REF64652', '5', NULL, '2023-04-18 06:54:55', '1'),
(57, '7033230967', '9570298908', 'REF5547', '5', NULL, '2023-04-18 14:23:09', '1'),
(58, '9578463485', '9570298908', 'REF96315', '5', NULL, '2023-04-18 14:37:59', '1');

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

--
-- Table structure for table `samb`
--

CREATE TABLE `samb` (
  `id` int(11) NOT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `samb` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `aadhaar_no` varchar(255) DEFAULT NULL,
  `pdf_link` varchar(500) NOT NULL,
  `date` varchar(255) DEFAULT NULL,
  `ret_wp_no` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `samb`
--

INSERT INTO `samb` (`id`, `appliedby`, `application_no`, `samb`, `status`, `fee`, `remark`, `aadhaar_no`, `pdf_link`, `date`, `ret_wp_no`, `state`) VALUES
(992, '1234567890', 'KAFILA7907372', '989898365421', 'pending', '20', NULL, NULL, '', '6th of September 2023 04:30:19 PM', NULL, NULL),
(993, '1234567890', 'KAFILA12131091', '12588899', 'success', '20', NULL, 'NO RECORD', 'https://kafilaworld.xyz/admin/uploads/828417Screenshot 2023-07-06 185526.png', '6th of September 2023 04:46:46 PM', '975588112233', 'MADHYA PRADESH'),
(994, '7089755335', 'KAFILA88787825', '21793713', 'success', '20', NULL, '21793713', 'https://kafilaworld.xyz/admin/uploads/626358pdf (16).pdf', '7th of September 2023 05:45:19 PM', '7089755335', 'MADHYA PRADESH'),
(995, '7089755335', 'KAFILA86643591', '44092013', 'success', '20', NULL, '44092013', 'https://kafilaworld.xyz/admin/uploads/475982pdf (54).pdf', '15th of September 2023 03:09:37 PM', '7089755335', 'MADHYA PRADESH');

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

--
-- Table structure for table `upfind`
--

CREATE TABLE `upfind` (
  `id` int(11) NOT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `upfind` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `aadhaar_no` varchar(255) DEFAULT NULL,
  `pdf_link` varchar(500) NOT NULL,
  `date` varchar(255) DEFAULT NULL,
  `ret_wp_no` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `upfind`
--

INSERT INTO `upfind` (`id`, `appliedby`, `application_no`, `upfind`, `status`, `fee`, `remark`, `aadhaar_no`, `pdf_link`, `date`, `ret_wp_no`, `state`) VALUES
(997, '6395660281', 'KAFILA64917480', '6395660281', 'success', '22', NULL, 'NO RECORD', 'https://kafilaworld.xyz/admin/uploads/654955Screenshot 2023-07-06 185526.png', '9th of September 2023 12:19:00 PM', 'UTTAR PRADESH', '09175497028268'),
(998, '7459852255', 'KAFILA61866009', '7459852255', 'success', '22', NULL, 'NO RECORD', 'https://kafilaworld.xyz/admin/uploads/236230Screenshot 2023-07-06 185526.png', '16th of September 2023 10:53:46 PM', 'UTTAR PRADESH', '269615730943'),
(999, '8979760730', 'KAFILA63662321', '8979760730', 'success', '22', NULL, '926500899272', 'https://mbajallive.xyz/admin/uploads/40844NO RECORD.png', '17th of September 2023 09:52:44 PM', 'UTTAR PRADESH', '09145697274192');

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

--
-- Table structure for table `voterauto`
--

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

--
-- Dumping data for table `voterauto`
--

INSERT INTO `voterauto` (`id`, `votername`, `votarname2`, `aadharname`, `namelocal`, `dob`, `dobinlocal`, `gender`, `genderlocal`, `sexlocal`, `spousename`, `spousenamelocal`, `fathername`, `fatheraadharname`, `fathernamelocal`, `epicno`, `policestation`, `tahshil`, `assconnonm`, `assconnonmlocal`, `partno`, `partname`, `partnamelocal`, `locallanguage`, `fulladdress`, `localaddress`, `pata`, `kaname`, `sign`, `signlocal`, `assconnameno`, `assconnamenolocal`, `partnoandname`, `partnoandnamelocal`, `imagepathoriginal`, `status`, `updatestatusdatetime`, `updateuserid`, `srno`, `createdatetime`, `userid`, `payment_status`, `mobile`, `email`) VALUES
(1, 'HFDGHF', '', '', 'ghfg', '2023-09-04', 'ਜਨਮ ਤਿਥੀ/ਉਮਰ', 'hf', '', 'ਸੈਕਸ', 'Father', 'ਪਿਤਾ', 'DFHF', '', 'ghfdg', 'dfghfdg', 'ytutyu', 'fdghfdg', '- hfg', '-dfgh', 'dfgh', 'dfh', 'fgh', 'PA', 'Police Station-ytutyu, Tahshil-fdghfdg, District-dfghdfgh, Pin Code-546456', 'ਪੁਲਿਸ ਸਟੇਸ਼ਨ-ਯਤੂਯੂ, ਤਹਿਸ਼ੀਲ-fdghfdg, ਜ਼ਿਲ੍ਹਾ-dfghdfgh, ਪਿੰਨ ਕੋਡ-546456', 'ਪਤਾ', 'ਕਾ ਨਾਮ', '', 'ਚੋਣਕਾਰ ਰਜਿਸਟ੍ਰੇਸ਼ਨ ਅਫਸਰ', 'Assembly Constituency No. & Name', 'ਵਿਧਾਨ ਸਭਾ ਚੋਣ ਖੇਤਰ ਦਾ ਨੰਬਰ ਅਤੇ ਨਾਮ', 'Part No and Name', 'ਭਾਗ ਨੰਬਰ ਅਤੇ ਨਾਮ', 'data:image/jpeg;base64,[BLOB]', 'PENDING', NULL, NULL, 1, '2023-09-13 23:25:01', '0', 0, NULL, NULL);
INSERT INTO `voterauto` (`id`, `votername`, `votarname2`, `aadharname`, `namelocal`, `dob`, `dobinlocal`, `gender`, `genderlocal`, `sexlocal`, `spousename`, `spousenamelocal`, `fathername`, `fatheraadharname`, `fathernamelocal`, `epicno`, `policestation`, `tahshil`, `assconnonm`, `assconnonmlocal`, `partno`, `partname`, `partnamelocal`, `locallanguage`, `fulladdress`, `localaddress`, `pata`, `kaname`, `sign`, `signlocal`, `assconnameno`, `assconnamenolocal`, `partnoandname`, `partnoandnamelocal`, `imagepathoriginal`, `status`, `updatestatusdatetime`, `updateuserid`, `srno`, `createdatetime`, `userid`, `payment_status`, `mobile`, `email`) VALUES
(2, 'KARAMVEER SINGH', '', '', 'ਕਰਮਵੀਰ ਸਿੰਘ', '1992-05-17', 'ਜਨਮ ਤਿਥੀ/ਉਮਰ', 'MALE', '', 'ਸੈਕਸ', 'Father', 'ਪਿਤਾ', 'GURMAIL SINGH', '', 'ਗੁਰਮੇਲ ਸਿੰਘ', 'SLH2004869', 'H. NO.673/3 Jattan Mohalla', 'Adampur', '-', '-', '.', '.', '', 'PA', 'H.NO.673/3 Jattan Mohalla,Adampur, District-Jalandhar, Pin Code-144102', 'H NO 673/3 ਜੱਟਾਂ ਮੁਹੱਲਾ ਆਦਮਪੁਰ ਜ਼ਿਲ੍ਹਾ- ਜਲੰਧਰ ਪਿੰਨ ਕੋਡ 144102', 'ਪਤਾ', 'ਕਾ ਨਾਮ', '', 'ਚੋਣਕਾਰ ਰਜਿਸਟ੍ਰੇਸ਼ਨ ਅਫਸਰ', 'Assembly Constituency No. & Name', 'ਵਿਧਾਨ ਸਭਾ ਚੋਣ ਖੇਤਰ ਦਾ ਨੰਬਰ ਅਤੇ ਨਾਮ', 'Part No and Name', 'ਭਾਗ ਨੰਬਰ ਅਤੇ ਨਾਮ', 'data:image/jpeg;base64,[BLOB]', 'PENDING', NULL, NULL, 2, '2023-09-28 19:15:04', '8699591290', 0, NULL, NULL);
INSERT INTO `voterauto` (`id`, `votername`, `votarname2`, `aadharname`, `namelocal`, `dob`, `dobinlocal`, `gender`, `genderlocal`, `sexlocal`, `spousename`, `spousenamelocal`, `fathername`, `fatheraadharname`, `fathernamelocal`, `epicno`, `policestation`, `tahshil`, `assconnonm`, `assconnonmlocal`, `partno`, `partname`, `partnamelocal`, `locallanguage`, `fulladdress`, `localaddress`, `pata`, `kaname`, `sign`, `signlocal`, `assconnameno`, `assconnamenolocal`, `partnoandname`, `partnoandnamelocal`, `imagepathoriginal`, `status`, `updatestatusdatetime`, `updateuserid`, `srno`, `createdatetime`, `userid`, `payment_status`, `mobile`, `email`) VALUES
(3, 'CHANDA DEVI', '', '', 'ਚੰਦਾ ਦੇਵੀ', '10-08-2003', 'ਜਨਮ ਤਿਥੀ/ਉਮਰ', 'FEMALE', '', 'ਸੈਕਸ', 'Husband', 'ਪਤੀ', 'ANUJ', '', 'ਅਨੁਜ', 'IGZ8503891', 'SAHNEWAL', 'LUDHIANA', 'DHANDARI-25', 'ਢੰਡਾਰੀ-25', '125', 'DHANDARI KALAN', 'ਢੰਡਾਰੀ ਕਲਾਂ', 'PA', 'Police Station-SANEWAL, Tahshil-LUDHIANA, District-LUDHIANA, Pin Code-141014', 'ਪੁਲਿਸ ਸਟੇਸ਼ਨ-ਸਾਨੇਵਾਲ, ਤਹਿਸ਼ੀਲ-ਲੁਧਿਆਣਾ, ਜਿਲ੍ਹਾ-ਲੁਧਿਆਣਾ, ਪਿੰਨ ਕੋਡ-141014', 'ਪਤਾ', 'ਕਾ ਨਾਮ', '', 'ਚੋਣਕਾਰ ਰਜਿਸਟ੍ਰੇਸ਼ਨ ਅਫਸਰ', 'Assembly Constituency No. & Name', 'ਵਿਧਾਨ ਸਭਾ ਚੋਣ ਖੇਤਰ ਦਾ ਨੰਬਰ ਅਤੇ ਨਾਮ', 'Part No and Name', 'ਭਾਗ ਨੰਬਰ ਅਤੇ ਨਾਮ', 'data:image/png;base64,[BLOB]