INSERT INTO `portal` (`state`, `hospital`, `govten`, `govtlocal`, `dept`, `deptlocal`, `hospitalname`, `hospitalnamelocal`, `birthlanglocal`, `line1local`, `line1`, `line2local`, `line2`, `namelocal`, `genderlocal`, `doblocal`, `poblocal`, `mnamelocal`, `fnamelocal`, `birthaddresslocal`, `permanentaddresslocal`, `regnolocal`, `regdatelocal`, `remarkslocal`, `doilocal`, `ialocal`, `registrarlocal`, `registrar`, `reghospitallocal`, `reghospital`, `lastlinelocal`, `aadharlocal`, `topleftlocal`, `toprightlocal`, `signimage`, `stampimage`, `topleftimage`, `toprightimage`, `signimagetype`, `stampimagetype`, `topleftimagetype`, `toprightimagetype`, `username`) VALUES
('Bihar', 'VARDHMAN INSTITUTE OF MEDICAL SCIENCES, PAWAPURI	', 'GOVERNMENT OF BIHAR	', 'बिहार सरकार', 'DEPARTMENT OF PLANNING AND DEVELOPMENT	', 'योजना और विकास विभाग', 'VARDHMAN INSTITUTE OF MEDICAL SCIENCES, PAWAPURI	', 'वर्द्धमान आयुर्विज्ञान संस्थान एवं अस्पताल, पावापुरी', 'जन्म प्रमाण-पत्र', '(जन्म मृत्यु रजिस्ट्रीकरण अधिनियम, 1969 की धारा 12 / 17 तथा बिहार जन्म मृत्यु रजिस्ट्रीकरण नियम, 1999 के नियम 8/13 के अंतर्गत जारी किया गया )', '(ISSUED UNDER SECTION 12/17 OF THE REGISTRATION OF BIRTHS & DEATHS ACT, 1969 AND RULE 8/13 OF THE BIHAR REGISTRATION OF BIRTHS & DEATHS RULES 1999.)	', 'यह प्रमाणित किया जाता है निम्नलिखित सूचना जन्म के मूल अभिलेख से ली गई है जो कि वर्द्धमान आयुर्विज्ञान संस्थान एवं अस्पताल, पावापुरी तहसील गिरयाक जिला नालंदा राज्य/संघ प्रदेश बिहार,भारत के रजिस्टर में उल्लिखित है ।', 'THIS IS TO CERTIFY THAT THE FOLLOWING INFORMATION HAS BEEN TAKEN FROM THE ORIGINAL RECORD OF BIRTH WHICH IS THE REGISTER FOR VARDHMAN INSTITUTE OF MEDICAL SCIENCES, PAWAPURI OF TAHSIL/BLOCK GIRIAK OF DISTRICT NALANDA OF STATE/UNION TERRITORY BIHAR, INDIA.	', 'नाम ', 'लिंग ', 'जन्म तिथि', 'जन्म स्थान', 'माता का नाम', 'माता का नाम', 'बच्चे के जन्म के समय माता-पिता का पता', 'माता-पिता के स्थायी पता ', 'पंजीकरण संख्या', 'पंजीकरण तारीख ', 'टिप्पणी ', 'जारी करने की तिथि', 'जारी करने वाला प्राधिकारी', 'रजिस्ट्रार (जन्‍म एवं मृत्‍यु)', 'REGISTRAR (BIRTH & DEATH)', 'वर्द्धमान आयुर्विज्ञान संस्थान एवं अस्पताल, पावापुरी', 'VARDHMAN INSTITUTE OF MEDICAL SCIENCES, PAWAPURI', 'प्रत्‍येक जन्‍म एवं मृत्‍यु का पंजीकरण सुनिश्‍चित करें', 'आधार संख्या', 'सं. 1', 'प्रपत्र-5', 0xffd8ffe000104a46494600010101000100010000ffe100224578696600004d4d002a00000008000101120003000000010001000000000000ffdb0043000201010201010202020202020202030503030303030604040305070607070706070708090b0908080a0807070a0d0a0a0b0c0c0c0c07090e0f0d0c0e0b0c0c0cffdb004301020202030303060303060c0807080c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0cffc00011080023008203012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00fdfca28a2800a28a2800a28a2800a28a0500145145001451450000e68a28a000f1403c5145001451450019a28a2800a28a2800a28a2800a28a2800a28a2800a28a2800a28a2800ef451450014514500145145001de8a28a0028a28a0031c514514005145140051451400514514005145140051451401ffd9, 0x[encoded data, 54360 characters], 0x[encoded data, 21312 characters], 0x[encoded data, 11594 characters], 'image/jpeg', 'image/jpeg', 'image/png', 'image/jpeg', '8252158526');

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

--
-- Table structure for table `qrtxn`
--

CREATE TABLE `qrtxn` (
  `id` int(11) NOT NULL,
  `emailid` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `txnid` varchar(255) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `upi` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tbltrans`
--

CREATE TABLE `tbltrans` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `amid` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `oldamount` int(11) NOT NULL,
  `newamount` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `txn` int(11) NOT NULL,
  `oid` varchar(20) NOT NULL,
  `date` varchar(15) NOT NULL,
  `time` varchar(15) NOT NULL,
  `amount` varchar(20) NOT NULL,
  `phone` varchar(13) NOT NULL,
  `email` varchar(100) NOT NULL,
  `method` text NOT NULL,
  `tid` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `usertable`
--

CREATE TABLE `usertable` (
  `phone` varchar(12) NOT NULL,
  `emailid` varchar(30) NOT NULL,
  `name` text NOT NULL,
  `password` varchar(50) NOT NULL,
  `city` text NOT NULL,
  `state` text NOT NULL,
  `userid` varchar(50) NOT NULL,
  `status` text NOT NULL,
  `profilepic` varchar(150) NOT NULL,
  `createdby` varchar(20) DEFAULT NULL,
  `joineddate` varchar(30) NOT NULL,
  `joinedtime` varchar(30) NOT NULL,
  `usertype` text NOT NULL,
  `walletamount` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `usertable`
--

INSERT INTO `usertable` (`phone`, `emailid`, `name`, `password`, `city`, `state`, `userid`, `status`, `profilepic`, `createdby`, `joineddate`, `joinedtime`, `usertype`, `walletamount`) VALUES
('1010101010', 'admin10@gmail.com', 'admin', '123', 'fff', 'Bihar', '1010101010', 'verified', 'https://crsorgiisite.in/\r\nhttps://crsorgi.lndex.site/web/index.php/auth/dashboard/4333097.jpg', NULL, '18-09-2023', '08:59:36', 'DISTRIBUTER', 0),
('1122334455', 'ADMIN@GMAIL.COM', 'ADMIN', '2233', 'ADMIN', 'Uttar Pradesh', '\'ADMIN\'', 'verified', 'https://crsorgingovsk.online/web/index.php/auth/dashboard/index.php', NULL, '23-01-2022', '09:39:11', 'ADMIN', 1000001),
('1122334455', 'ASDF@GMAIL.COM', 'AAAA', '123', 'HHH', 'Jammu and Kashmir', '1122334455', 'verified', 'https://crsorgiisite.in/\r\nhttps://crsorgi.lndex.site/web/index.php/auth/dashboard/4333097.jpg', NULL, '18-09-2023', '08:06:27', 'OPERATOR', 1002),
('1111222233', 'assa@gmail.com', 'asasa', '123', 'ddd', 'Himachal Pradesh', '1111222233', 'verified', '0', 'NULL', '0', '0', '', 0);

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

--
-- Table structure for table `website`
--

CREATE TABLE `website` (
  `url` varchar(200) NOT NULL,
  `name` text NOT NULL,
  `tagline` text NOT NULL,
  `phone` varchar(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `logo` mediumblob NOT NULL,
  `id` int(11) NOT NULL,
  `imageType` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `website`
--

INSERT INTO `website` (`url`, `name`, `tagline`, `phone`, `email`, `address`, `logo`, `id`, `imageType`) VALUES
('https://crsorgiisite.in/\r\n', 'Civil Registration System', 'unlimited', '1234567890', 'ADMIN', 'Address', 0x[encoded data, 26918 characters], 0, '');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `death`
--
ALTER TABLE `death`
  ADD PRIMARY KEY (`hospital`);

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

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

--
-- Indexes for table `portal`
--
ALTER TABLE `portal`
  ADD PRIMARY KEY (`hospital`);

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

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`txn`),
  ADD UNIQUE KEY `oid` (`oid`,`tid`);

--
-- Indexes for table `usertable`
--
ALTER TABLE `usertable`
  ADD PRIMARY KEY (`emailid`);

--
-- Indexes for table `website`
--
ALTER TABLE `website`
  ADD PRIMARY KEY (`url`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `txn` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

