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

START TRANSACTION;



--
-- Database: `u286384913_Allinonepg`
--

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

--
-- Table structure for table `bharatpe_tokens`
--

CREATE TABLE `bharatpe_tokens` (
  `id` int(11) NOT NULL,
  `user_token` longtext DEFAULT NULL,
  `phoneNumber` varchar(255) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `cookie` varchar(255) DEFAULT NULL,
  `merchantId` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` varchar(255) DEFAULT 'Deactive',
  `Upiid` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `callback_report`
--

CREATE TABLE `callback_report` (
  `id` int(11) NOT NULL,
  `order_id` varchar(255) NOT NULL,
  `request_url` longtext NOT NULL,
  `response` longtext NOT NULL,
  `user_token` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `googlepay_tokens`
--

CREATE TABLE `googlepay_tokens` (
  `id` int(12) NOT NULL,
  `user_token` longtext DEFAULT NULL,
  `phoneNumber` varchar(255) DEFAULT NULL,
  `Instance_Id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` varchar(255) DEFAULT 'Deactive',
  `Upiid` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `googlepay_tokens`
--

INSERT INTO `googlepay_tokens` (`id`, `user_token`, `phoneNumber`, `Instance_Id`, `created_at`, `date`, `status`, `Upiid`, `user_id`) VALUES
(1, 'c1ac4f33ac772a3be24d1263820badae', '8057203385', '', '2024-01-21 08:03:20', '2024-01-21 08:03:20', 'Deactive', '', NULL),
(3, '97fedb05eecc71ca47550b2c35e72395', '8603042728', '', '2024-06-16 05:33:59', '2024-06-16 05:33:59', 'Deactive', '', NULL);

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

--
-- Table structure for table `googlepay_transactions`
--

CREATE TABLE `googlepay_transactions` (
  `id` int(11) NOT NULL,
  `user_token` longtext DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `utr` bigint(20) DEFAULT NULL,
  `user_id` int(12) DEFAULT NULL,
  `paymentTimestamp` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `hdfc`
--

CREATE TABLE `hdfc` (
  `id` int(11) NOT NULL,
  `number` varchar(255) NOT NULL,
  `seassion` varchar(255) NOT NULL,
  `device_id` varchar(255) NOT NULL,
  `user_token` varchar(255) NOT NULL,
  `pin` varchar(255) NOT NULL,
  `upi_hdfc` varchar(255) NOT NULL,
  `UPI` varchar(255) NOT NULL,
  `tidlist` varchar(255) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `status` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `user_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `order_id` mediumtext NOT NULL,
  `user_token` longtext NOT NULL,
  `status` text NOT NULL,
  `amount` int(11) NOT NULL,
  `utr` longtext NOT NULL,
  `plan_id` longtext NOT NULL,
  `customer_name` longtext NOT NULL,
  `customer_mobile` longtext NOT NULL,
  `redirect_url` longtext NOT NULL,
  `remark1` longtext NOT NULL,
  `remark2` longtext NOT NULL,
  `gateway_txn` longtext NOT NULL,
  `method` text NOT NULL,
  `HDFC_TXNID` mediumtext NOT NULL,
  `upiLink` mediumtext NOT NULL,
  `description` mediumtext NOT NULL,
  `byteTransactionId` varchar(255) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `paytm_txn_ref` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `payment_links`
--

CREATE TABLE `payment_links` (
  `id` int(11) NOT NULL,
  `link_token` varchar(255) NOT NULL,
  `order_id` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `paytm_tokens`
--

CREATE TABLE `paytm_tokens` (
  `id` int(11) NOT NULL,
  `user_token` longtext NOT NULL,
  `phoneNumber` varchar(255) DEFAULT NULL,
  `MID` varchar(255) DEFAULT NULL,
  `Upiid` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` varchar(255) DEFAULT 'Deactive',
  `user_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `paytm_tokens`
--

INSERT INTO `paytm_tokens` (`id`, `user_token`, `phoneNumber`, `MID`, `Upiid`, `created_at`, `date`, `status`, `user_id`) VALUES
(2, '97fedb05eecc71ca47550b2c35e72395', '7030306587', '', '', '2024-06-16 05:35:05', '2024-06-16 05:35:05', 'Deactive', NULL);

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

--
-- Table structure for table `phonepe_tokens`
--

CREATE TABLE `phonepe_tokens` (
  `sl` int(11) NOT NULL,
  `user_token` longtext NOT NULL,
  `phoneNumber` longtext NOT NULL,
  `userId` longtext NOT NULL,
  `token` longtext NOT NULL,
  `refreshToken` longtext NOT NULL,
  `name` text NOT NULL,
  `device_data` longtext NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'Deactive',
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `user_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `phonepe_tokens`
--

INSERT INTO `phonepe_tokens` (`sl`, `user_token`, `phoneNumber`, `userId`, `token`, `refreshToken`, `name`, `device_data`, `status`, `date`, `user_id`) VALUES
(3, '47a7d8919fa3c2401870a23bd16b1da7', '7024002846', '', '', '', '', '', 'Deactive', '2024-01-21 08:15:57', NULL),
(4, '47a7d8919fa3c2401870a23bd16b1da7', '9835231623', '', '', '', '', '', 'Deactive', '2024-01-21 08:20:56', NULL);

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

--
-- Table structure for table `reports`
--

CREATE TABLE `reports` (
  `id` int(11) NOT NULL,
  `transactionId` mediumtext DEFAULT NULL,
  `status` mediumtext DEFAULT NULL,
  `order_id` mediumtext DEFAULT NULL,
  `vpa` mediumtext DEFAULT NULL,
  `paymentApp` mediumtext DEFAULT NULL,
  `amount` mediumtext DEFAULT NULL,
  `user_token` mediumtext DEFAULT NULL,
  `UTR` mediumtext DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `mobile` varchar(255) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `merchantTransactionId` varchar(255) DEFAULT NULL,
  `transactionNote` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `store_id`
--

CREATE TABLE `store_id` (
  `sl` int(11) NOT NULL,
  `user_token` longtext NOT NULL,
  `unitId` longtext NOT NULL,
  `roleName` longtext NOT NULL,
  `groupValue` longtext NOT NULL,
  `groupId` longtext NOT NULL,
  `user_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `tb_gateway`
--

CREATE TABLE `tb_gateway` (
  `id` int(11) NOT NULL,
  `signup_fee` int(11) NOT NULL,
  `gateway_upiuid` varchar(255) NOT NULL,
  `gateway_secret` varchar(255) NOT NULL,
  `gateway_key` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_gateway`
--

INSERT INTO `tb_gateway` (`id`, `signup_fee`, `gateway_upiuid`, `gateway_secret`, `gateway_key`) VALUES
(1, 1, 'payssxwu@paytm', 'UAeGs0VT3', '829b95-a7f7e1-2sb1-525255-1ccbd5');

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

--
-- Table structure for table `tb_partner`
--

CREATE TABLE `tb_partner` (
  `id` int(11) NOT NULL,
  `uid_token` varchar(50) NOT NULL,
  `type` int(11) NOT NULL,
  `login_id` varchar(20) NOT NULL,
  `login_pwd` varchar(200) NOT NULL,
  `login_otp` varchar(12) NOT NULL,
  `name` varchar(100) NOT NULL,
  `company_name` varchar(255) NOT NULL,
  `mobile` varchar(10) NOT NULL,
  `email` varchar(100) NOT NULL,
  `pan_no` varchar(10) NOT NULL,
  `uid_no` varchar(12) NOT NULL,
  `balance` varchar(100) NOT NULL,
  `token` varchar(100) NOT NULL,
  `secret` varchar(100) NOT NULL,
  `txn_status_webhook` varchar(255) NOT NULL,
  `slab` int(11) NOT NULL,
  `upi_id` varchar(50) NOT NULL,
  `device` longtext NOT NULL,
  `upis` longtext NOT NULL,
  `paytm_business` longtext DEFAULT NULL,
  `paytm_active` int(11) NOT NULL DEFAULT 0,
  `settle_account` mediumtext NOT NULL,
  `upi_active` int(11) NOT NULL,
  `status` varchar(10) NOT NULL,
  `payid` varchar(255) DEFAULT NULL,
  `password_bckup` varchar(255) DEFAULT NULL,
  `start_date` varchar(255) DEFAULT NULL,
  `expire_date` varchar(255) DEFAULT NULL,
  `trial_done` varchar(255) NOT NULL DEFAULT '0',
  `plan_txn_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_partner`
--

INSERT INTO `tb_partner` (`id`, `uid_token`, `type`, `login_id`, `login_pwd`, `login_otp`, `name`, `company_name`, `mobile`, `email`, `pan_no`, `uid_no`, `balance`, `token`, `secret`, `txn_status_webhook`, `slab`, `upi_id`, `device`, `upis`, `paytm_business`, `paytm_active`, `settle_account`, `upi_active`, `status`, `payid`, `password_bckup`, `start_date`, `expire_date`, `trial_done`, `plan_txn_id`) VALUES
(268, '', 1, 'ADMIN', '$2y$10$pNho/32eNwxCy8yW.RYALexWM774DntRZvm216j9DE5stT8iY0xGa', 'gMnjzcAw', 'test', 'test', '1234567890', 'test@gmail.com', 'RJDPS1193P', '123123123124', '', '', '', '', 3, '', '', '', NULL, 0, '{\"account_no\":\"asdad\",\"beneficiary_name\":\"nortaxas\",\"ifsc\":\"asd\"}', 0, 'active', '', 'RJDPS1193P', NULL, NULL, '0', NULL);

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

--
-- Table structure for table `tb_settings`
--

CREATE TABLE `tb_settings` (
  `id` int(11) NOT NULL,
  `socket` varchar(10) NOT NULL,
  `base_url` varchar(200) NOT NULL,
  `company_name` varchar(200) NOT NULL,
  `company_account` mediumtext NOT NULL,
  `company_logo` varchar(255) NOT NULL,
  `app_logo` text NOT NULL,
  `company_about` mediumtext NOT NULL,
  `web_fav` varchar(255) NOT NULL,
  `web_tag` text NOT NULL,
  `web_rights` varchar(200) NOT NULL,
  `support` mediumtext NOT NULL,
  `slab_id` int(11) NOT NULL,
  `upi_prefix` varchar(50) NOT NULL,
  `upi_bank` varchar(100) NOT NULL,
  `hypto_token` varchar(200) NOT NULL,
  `authorization` varchar(255) NOT NULL,
  `smsapi` longtext NOT NULL,
  `app_link` text NOT NULL,
  `live_chat` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `notification` longtext NOT NULL,
  `uid` int(11) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_settings`
--

INSERT INTO `tb_settings` (`id`, `socket`, `base_url`, `company_name`, `company_account`, `company_logo`, `app_logo`, `company_about`, `web_fav`, `web_tag`, `web_rights`, `support`, `slab_id`, `upi_prefix`, `upi_bank`, `hypto_token`, `authorization`, `smsapi`, `app_link`, `live_chat`, `notification`, `uid`, `status`) VALUES
(1, 'https://', 'upifast.in', 'UPI PG', '{\"account\":\"91700000000\",\"name\":\"test\",\"ifsc\":\"PYTM0123456 ( UPI / IMPS / NEFT )\"}', 'logo-removebg-preview.png', '', 'Bengaluru Karnataka', 'https://upifast.in/public/uploads/all/62U9RiWsTLJDFPye4O0ox7gVOqRpv6wLbR3cIgLx.gif', 'UpiFast - Get Instant Settlement with 0 % MDR Fee', 'UpiFast', '{\"mobile\":\"5395001134\",\"mobile1\":\"5395001134\",\"email\":\"admin@apise.in\"}', 3, 'multipe', 'upi@upi', 'NA', 'NA', '{\"username\":\"https://smsapi/login.php?msgid=2\",\"password\":\"https://smsapi/login.php?msgid=2\",\"smsurl\":\"https://smsapi/login.php?msgid=2\"}', 'http://upifast.in/images/brand.png', '<script>\n (function () {\n var options = {\n whatsapp: \"5395991134\", // WhatsApp number\n call_to_action: \"WhtsApp Support\", // Call to action\n position: \"right\", // Position may be \'right\' or \'left\'\n };\n var proto = document.location.protocol, host = \"whatshelp.io\", url = proto + \"//static.\" + host;\n var s = document.createElement(\'script\'); s.type = \'text/javascript\'; s.async = true; s.src = url + \'/widget-send-button/js/init.js\';\n s.onload = function () { WhWidgetSendButton.init(host, proto, options); };\n var x = document.getElementsByTagName(\'script\')[0]; x.parentNode.insertBefore(s, x);\n })();\n</script>', '<h2><span class=\"marker\"><strong>LifeTime Offer Plan Price: 5000&nbsp;Only</strong></span></h2>\r\n', 1, 1);

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

--
-- Table structure for table `tb_slab`
--

CREATE TABLE `tb_slab` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `upi` varchar(50) NOT NULL,
  `van` varchar(50) NOT NULL,
  `imps` varchar(100) NOT NULL,
  `neft` varchar(100) NOT NULL,
  `uid` int(11) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_slab`
--

INSERT INTO `tb_slab` (`id`, `name`, `upi`, `van`, `imps`, `neft`, `uid`, `status`) VALUES
(3, 'Default', '0.50', '0.50', '{\"slab1\":\"2.50\",\"slab2\":\"4.30\",\"slab3\":\"8.95\"}', '{\"slab1\":\"3.60\",\"slab2\":\"3.60\",\"slab3\":\"3.60\"}', 1, 1);

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

--
-- Table structure for table `tb_transactions`
--

CREATE TABLE `tb_transactions` (
  `id` int(11) NOT NULL,
  `token` varchar(100) NOT NULL,
  `user_uid` int(11) NOT NULL,
  `order_id` varchar(50) NOT NULL,
  `client_orderid` varchar(200) NOT NULL,
  `date` date NOT NULL,
  `time` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `mode` varchar(50) NOT NULL,
  `pay_upi` varchar(100) NOT NULL,
  `upi_id` varchar(100) NOT NULL,
  `rrn` varchar(100) NOT NULL,
  `txn_amount` varchar(100) NOT NULL,
  `fees` varchar(100) NOT NULL,
  `settle_amount` varchar(100) NOT NULL,
  `closing_balance` varchar(100) NOT NULL,
  `txn_type` varchar(20) NOT NULL,
  `remark` text NOT NULL,
  `status` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_transactions`
--

INSERT INTO `tb_transactions` (`id`, `token`, `user_uid`, `order_id`, `client_orderid`, `date`, `time`, `type`, `mode`, `pay_upi`, `upi_id`, `rrn`, `txn_amount`, `fees`, `settle_amount`, `closing_balance`, `txn_type`, `remark`, `status`) VALUES
(3, '', 249, 'U3ncfuA1hH', '', '2023-02-08', '11:13:22 AM', 'Received - Admin', 'DCA', '917800152849', 'GDZPM8799A', '1675835002', '5000', '0', '5000', '5012', 'CREDIT', 'Admin', 'COMPLETED');

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

--
-- Table structure for table `tb_upis`
--

CREATE TABLE `tb_upis` (
  `id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `upi_uid` int(11) NOT NULL,
  `upi_id` varchar(100) NOT NULL,
  `upi_name` varchar(200) NOT NULL,
  `pan` varchar(10) NOT NULL,
  `category` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `date` varchar(50) NOT NULL,
  `time` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_upis`
--

INSERT INTO `tb_upis` (`id`, `uid`, `upi_uid`, `upi_id`, `upi_name`, `pan`, `category`, `address`, `date`, `time`, `status`) VALUES
(14, 1, 45545, 'nn@upi', 'fdgfd', 'HXsdssdsd2', 'Restaurants', 'ADDRESS', '2023-02-18', '02:42:57 AM', 'PENDING');

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

--
-- Table structure for table `tb_virtualtxn`
--

CREATE TABLE `tb_virtualtxn` (
  `id` int(11) NOT NULL,
  `credited_at` varchar(100) NOT NULL,
  `bene_account_no` varchar(200) NOT NULL,
  `bene_account_ifsc` varchar(200) NOT NULL,
  `rmtr_full_name` varchar(200) NOT NULL,
  `rmtr_account_no` varchar(200) NOT NULL,
  `rmtr_account_ifsc` varchar(50) NOT NULL,
  `rmtr_to_bene_note` varchar(255) NOT NULL,
  `txn_id` varchar(200) NOT NULL,
  `amount` varchar(200) NOT NULL,
  `charges_gst` varchar(200) NOT NULL,
  `settled_amount` varchar(200) NOT NULL,
  `txn_time` varchar(100) NOT NULL,
  `created_at` varchar(100) NOT NULL,
  `payment_type` varchar(50) NOT NULL,
  `bank_ref_num` varchar(50) NOT NULL,
  `results` longtext DEFAULT NULL,
  `client_orderid` varchar(100) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_virtualtxn`
--

INSERT INTO `tb_virtualtxn` (`id`, `credited_at`, `bene_account_no`, `bene_account_ifsc`, `rmtr_full_name`, `rmtr_account_no`, `rmtr_account_ifsc`, `rmtr_to_bene_note`, `txn_id`, `amount`, `charges_gst`, `settled_amount`, `txn_time`, `created_at`, `payment_type`, `bank_ref_num`, `results`, `client_orderid`, `user_id`) VALUES
(75, '2023-02-16 04:23:53', 's@paytm', 'W3EGUVYEs676501592', 'nfjf@mail.com', '4358764587 - 88171676501591', 'Txn Success', 'Payment received from name', '1676501633', '1.00', '0', '1.00', '2023-02-16 04:23:41.0', '2023-02-16 04:23:41.0', 'UPI', '304775593756', '{\"TXNID\":\"20230216010350000832833673962710483\",\"BANKTXNID\":\"304775593756\",\"ORDERID\":\"W3EGUVYEej1676501592\",\"TXNAMOUNT\":\"1.00\",\"STATUS\":\"TXN_SUCCESS\",\"TXNTYPE\":\"SALE\",\"GATEWAYNAME\":\"PPBL\",\"RESPCODE\":\"01\",\"RESPMSG\":\"Txn Success\",\"MID\":\"idVKUA69203033163757\",\"PAYMENTMODE\":\"UPI\",\"REFUNDAMT\":\"0.0\",\"TXNDATE\":\"2023-02-16 04:23:41.0\",\"currentTxnCount\":\"1\"}', '88171676501591', 1);

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `role` enum('User','Admin','','') NOT NULL DEFAULT 'User',
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `pin` varchar(255) NOT NULL,
  `pan` varchar(255) NOT NULL,
  `aadhaar` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `user_token` varchar(255) NOT NULL,
  `expiry` date NOT NULL,
  `callback_url` longtext NOT NULL,
  `bptoken` longtext NOT NULL,
  `upiid` longtext NOT NULL,
  `acc_lock` int(11) NOT NULL DEFAULT 0,
  `acc_ban` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'off',
  `upi_id` mediumtext DEFAULT NULL COMMENT 'This is the UPI ID for PhonePe',
  `phonepe_connected` varchar(3) DEFAULT 'No',
  `hdfc_connected` varchar(3) DEFAULT 'No',
  `paytm_connected` varchar(3) DEFAULT 'No',
  `bharatpe_connected` varchar(3) DEFAULT 'No',
  `googlepay_connected` varchar(3) DEFAULT 'No',
  `amazonpay_connected` varchar(3) DEFAULT 'No',
  `instance_id` varchar(255) DEFAULT NULL,
  `instance_secret` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` (`id`, `name`, `mobile`, `role`, `password`, `email`, `company`, `pin`, `pan`, `aadhaar`, `location`, `user_token`, `expiry`, `callback_url`, `bptoken`, `upiid`, `acc_lock`, `acc_ban`, `upi_id`, `phonepe_connected`, `hdfc_connected`, `paytm_connected`, `bharatpe_connected`, `googlepay_connected`, `amazonpay_connected`, `instance_id`, `instance_secret`) VALUES
(160, '1111111111', '1111111111', 'Admin', '$2y$10$VCv3DYwW5lKpi5RAcWPV8OXNYwRO75AItZKDguhBLTF21VmP/eGgK', 'demo@gmail.com', '1111111111', '0111', 'GDRTS5435H', '111111111111', 'deadas', '47a7d8919fa3c2401870a23bd16b1da7', '2024-01-27', '', '', '', 0, 'off', NULL, 'No', 'No', 'No', 'No', 'No', 'No', 'IVFxcG0fNB610824108', NULL),
(161, 'Amit', '7268940043', 'User', '$2y$10$Aa8McMWtyren4t8c4DHsje02cGdEBNCuf5qB4jkQ1CEwf0g5NA8oe', 'akhmlpr@gmail.com', 'Uti', '224122', 'LBLPS7754J', '578430661288', 'Lucknow', 'ec5a3268477b058786b9870f66a0bb2a', '2024-01-24', '', '', '', 0, 'off', NULL, 'No', 'No', 'No', 'No', 'No', 'No', 'I1VBD2PYa8647825154', NULL),
(163, '489848984898', '6353515623', 'User', '$2y$10$dqP7W165ckR.uRP4twdR3.8YZMKs5FXsznF6mz7AfUQ/FseV2bYtq', '4898@gmail.com', '4898', '489848', 'LSNPE0954T', '489848984898', 'afdafaf', 'd29cdb71f2dabf4131d9dfb2dea26a09', '2024-02-11', '', '', '', 0, 'off', NULL, 'No', 'No', 'No', 'No', 'No', 'No', 'IsC3Xhm3Yq821389361', NULL),
(165, 'Ranjeet Kumar ', '7258829455', 'User', '$2y$10$YYDtyEizEbcwr5RgpOERjuzl6sgHIxe/M0oYwOOHUhAxRAEllVLd6', 'cscranjeet70@gmail.com', 'Only admin ', '855586', 'HXCJG4556F', '786548621563', 'Shhj', '97fedb05eecc71ca47550b2c35e72395', '2024-06-19', '', '', '', 0, 'off', NULL, 'No', 'No', 'No', 'No', 'No', 'No', 'IN932pyBdf325516005', NULL);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

--
-- Indexes for table `phonepe_tokens`
--
ALTER TABLE `phonepe_tokens`
  ADD PRIMARY KEY (`sl`);

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

--
-- Indexes for table `store_id`
--
ALTER TABLE `store_id`
  ADD PRIMARY KEY (`sl`);

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

