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

START TRANSACTION;



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

--
-- 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_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);

--
-- Indexes for table `tb_slab`
--
ALTER TABLE `tb_slab`
  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`);

--
-- 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_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;
COMMIT;

