-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 17, 2023 at 01:10 PM
-- Server version: 10.4.27-MariaDB
-- PHP Version: 8.2.0

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `payment_gateway`
--

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

--
-- Table structure for table `account_report`
--

CREATE TABLE `account_report` (
  `account_key` int(11) NOT NULL,
  `member_key` text NOT NULL,
  `excute_date` varchar(200) NOT NULL,
  `amount` varchar(200) NOT NULL,
  `avl_balance` varchar(200) NOT NULL,
  `utr_number` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `account_report`
--

INSERT INTO `account_report` (`account_key`, `member_key`, `excute_date`, `amount`, `avl_balance`, `utr_number`, `status`) VALUES
(1, 'wferfersghteghtehththghgwefrwe4fger', '03:56 13/05/2023', '4', '4', '313356232577', 'SUCCESS'),
(2, 'wferfersghteghtehththghgwefrwe4fger', '04:00 13/05/2023', '4', '8', '313356232577', 'SUCCESS'),
(3, 'wferfersghteghtehththghgwefrwe4fger', '04:02 13/05/2023', '4', '12', '313317268949', 'SUCCESS'),
(4, 'wferfersghteghtehththghgwefrwe4fger', '04:05 13/05/2023', '4', '16', '313301983879', 'SUCCESS'),
(5, 'wferfersghteghtehththghgwefrwe4fger', '05:15 13/05/2023', '2', '18', '313328945223', 'SUCCESS'),
(6, 'wferfersghteghtehththghgwefrwe4fger', '05:29 13/05/2023', '3', '21', '313352977329', 'SUCCESS'),
(7, 'wferfersghteghtehththghgwefrwe4fger', '05:32 13/05/2023', '3', '24', '313352977329', 'SUCCESS'),
(8, 'wferfersghteghtehththghgwefrwe4fger', '05:33 13/05/2023', '2', '26', '313393963837', 'SUCCESS'),
(9, 'wferfersghteghtehththghgwefrwe4fger', '05:34 13/05/2023', '2', '28', '313303616269', 'SUCCESS'),
(10, 'wferfersghteghtehththghgwefrwe4fger', '05:44 13/05/2023', '2', '30', '313362480095', 'SUCCESS'),
(11, 'wferfersghteghtehththghgwefrwe4fger', '05:50 13/05/2023', '2', '32', '313331253918', 'SUCCESS');

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

--
-- Table structure for table `members_details`
--

CREATE TABLE `members_details` (
  `mem_key` int(11) NOT NULL,
  `member_key` text NOT NULL,
  `api_id` varchar(100) NOT NULL,
  `mem_id` varchar(200) DEFAULT NULL,
  `password` varchar(200) DEFAULT NULL,
  `txn_pin` varchar(200) DEFAULT NULL,
  `company_name` varchar(200) DEFAULT NULL,
  `wallet_balance` varchar(200) NOT NULL DEFAULT '0',
  `today_credit` varchar(100) NOT NULL DEFAULT '0',
  `today_transfer` varchar(100) NOT NULL DEFAULT '0',
  `transfer` varchar(100) NOT NULL DEFAULT '0',
  `business_name` varchar(255) DEFAULT NULL,
  `business_contact` varchar(20) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `created_date` varchar(200) DEFAULT NULL,
  `webhook_url` text DEFAULT NULL,
  `upiid` varchar(200) DEFAULT NULL,
  `kyc_status` varchar(100) NOT NULL DEFAULT 'No',
  `kyc_step` int(3) NOT NULL DEFAULT 0,
  `b_holder_name` varchar(255) DEFAULT NULL,
  `b_ac_no` varchar(30) DEFAULT NULL,
  `b_ifsc_code` varchar(20) DEFAULT NULL,
  `b_bank_name` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pancard` varchar(255) DEFAULT NULL,
  `agreement` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `members_details`
--

INSERT INTO `members_details` (`mem_key`, `member_key`, `api_id`, `mem_id`, `password`, `txn_pin`, `company_name`, `wallet_balance`, `today_credit`, `today_transfer`, `transfer`, `business_name`, `business_contact`, `email`, `created_date`, `webhook_url`, `upiid`, `kyc_status`, `kyc_step`, `b_holder_name`, `b_ac_no`, `b_ifsc_code`, `b_bank_name`, `aadhar`, `pancard`, `agreement`) VALUES
(1, 'wferfersghteghtehththghgwefrwe4fger', '852165', 'admin@gmail.com', '1234567890', NULL, 'Corplus tech', '32', '32', '0', '0', 'ITM', '9472774549', 'shivamraj853203@gmail.com', NULL, 'http://localhost/payment_getway/pic.php', 'ssmk786', 'No', 3, 'Shivam kumar', '9472774549', '9472774549', 'BOI', '168699717297681.png', '168699717281164.png', '168699717250697.pdf');

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

--
-- Table structure for table `money_transfer`
--

CREATE TABLE `money_transfer` (
  `money_key` int(11) NOT NULL,
  `member_key` text NOT NULL,
  `request_date` varchar(200) DEFAULT NULL,
  `amount` varchar(200) NOT NULL DEFAULT '0',
  `utr_number` varchar(200) NOT NULL DEFAULT '0',
  `ifsc_code` varchar(200) NOT NULL,
  `account_number` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  `pay_id` varchar(200) NOT NULL,
  `share_charge` varchar(200) NOT NULL,
  `avl_balance` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `money_transfer`
--

INSERT INTO `money_transfer` (`money_key`, `member_key`, `request_date`, `amount`, `utr_number`, `ifsc_code`, `account_number`, `status`, `pay_id`, `share_charge`, `avl_balance`) VALUES
(1, 'wferfersghteghtehththghgwefrwe4fger', '12:04 13/05/2023', '200', '02365465324', 'SBIN0017157', '37049309167', 'success', 'jhgefwhj673524', '-12', '1210');

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

--
-- Table structure for table `txn_history`
--

CREATE TABLE `txn_history` (
  `txn_key` int(11) NOT NULL,
  `project_key` text NOT NULL,
  `amount` varchar(200) NOT NULL DEFAULT '0',
  `avl_bal` varchar(200) NOT NULL,
  `txn_time` varchar(200) NOT NULL,
  `utr` varchar(200) NOT NULL,
  `upi_id` varchar(200) NOT NULL,
  `get_from` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL DEFAULT 'pending',
  `full_message` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `txn_history`
--

INSERT INTO `txn_history` (`txn_key`, `project_key`, `amount`, `avl_bal`, `txn_time`, `utr`, `upi_id`, `get_from`, `status`, `full_message`) VALUES
(6, 'wferfersghteghtehththghgwefrwe4fger', '2', '32', '05:48 13/05/2023', '313331253918', 'ssmk786', 'automatic', 'success', 'AX-KOTAKB|Received Rs.2.00 in your Kotak Bank AC X3394 from ssmk786@ibl on 13-05-23.Bal:0.00.UPI Ref:313331253918');

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

--
-- Table structure for table `upi_list`
--

CREATE TABLE `upi_list` (
  `upi_key` int(11) NOT NULL,
  `com_key` text NOT NULL,
  `upi_id` varchar(500) NOT NULL,
  `email_id` varchar(200) NOT NULL,
  `password` varchar(100) NOT NULL,
  `webhook` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `wallet_load_request`
--

CREATE TABLE `wallet_load_request` (
  `wallet_key` int(11) NOT NULL,
  `member_key` text NOT NULL,
  `txn_date` varchar(200) DEFAULT NULL,
  `request_amount` varchar(200) DEFAULT '0',
  `avl_balance` varchar(200) NOT NULL DEFAULT '0',
  `utr_number` varchar(200) DEFAULT NULL,
  `transfer_mood` varchar(200) DEFAULT NULL,
  `status` varchar(200) NOT NULL DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wallet_load_request`
--

INSERT INTO `wallet_load_request` (`wallet_key`, `member_key`, `txn_date`, `request_amount`, `avl_balance`, `utr_number`, `transfer_mood`, `status`) VALUES
(2, 'wferfersghteghtehththghgwefrwe4fger', '04:00 13/05/2023', '4', '8', '313356232577', 'IMPS', 'SUCCESS'),
(3, 'wferfersghteghtehththghgwefrwe4fger', '04:02 13/05/2023', '4', '12', '313317268949', 'IMPS', 'SUCCESS'),
(4, 'wferfersghteghtehththghgwefrwe4fger', '04:02 13/05/2023', '10', '12', '6578784111', 'IMPS', 'PENDING'),
(5, 'wferfersghteghtehththghgwefrwe4fger', '04:03 13/05/2023', '4', '12', '313379200823', 'IMPS', 'PENDING'),
(6, 'wferfersghteghtehththghgwefrwe4fger', '04:05 13/05/2023', '4', '16', '313301983879', 'IMPS', 'SUCCESS'),
(7, 'wferfersghteghtehththghgwefrwe4fger', '04:06 13/05/2023', '5000', '16', '657878453', 'IMPS', 'PENDING'),
(8, 'wferfersghteghtehththghgwefrwe4fger', '05:15 13/05/2023', '2', '18', '313328945223', 'IMPS', 'SUCCESS'),
(9, 'wferfersghteghtehththghgwefrwe4fger', '05:29 13/05/2023', '3', '21', '313352977329', 'IMPS', 'SUCCESS'),
(10, 'wferfersghteghtehththghgwefrwe4fger', '05:32 13/05/2023', '3', '24', '313352977329', 'IMPS', 'SUCCESS'),
(11, 'wferfersghteghtehththghgwefrwe4fger', '05:33 13/05/2023', '2', '26', '313393963837', 'IMPS', 'SUCCESS'),
(12, 'wferfersghteghtehththghgwefrwe4fger', '05:34 13/05/2023', '2', '28', '313303616269', 'IMPS', 'SUCCESS'),
(13, 'wferfersghteghtehththghgwefrwe4fger', '05:44 13/05/2023', '2', '30', '313362480095', 'IMPS', 'SUCCESS'),
(14, 'wferfersghteghtehththghgwefrwe4fger', '05:50 13/05/2023', '2', '32', '313331253918', 'IMPS', 'SUCCESS');

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

--
-- Table structure for table `webhook`
--

CREATE TABLE `webhook` (
  `web_key` int(11) NOT NULL,
  `company_key` text NOT NULL,
  `utr` varchar(100) NOT NULL,
  `upi` varchar(200) NOT NULL,
  `amount` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `account_report`
--
ALTER TABLE `account_report`
  ADD PRIMARY KEY (`account_key`);

--
-- Indexes for table `members_details`
--
ALTER TABLE `members_details`
  ADD PRIMARY KEY (`mem_key`);

--
-- Indexes for table `money_transfer`
--
ALTER TABLE `money_transfer`
  ADD PRIMARY KEY (`money_key`);

--
-- Indexes for table `txn_history`
--
ALTER TABLE `txn_history`
  ADD PRIMARY KEY (`txn_key`);

--
-- Indexes for table `upi_list`
--
ALTER TABLE `upi_list`
  ADD PRIMARY KEY (`upi_key`);

--
-- Indexes for table `wallet_load_request`
--
ALTER TABLE `wallet_load_request`
  ADD PRIMARY KEY (`wallet_key`);

--
-- Indexes for table `webhook`
--
ALTER TABLE `webhook`
  ADD PRIMARY KEY (`web_key`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `account_report`
--
ALTER TABLE `account_report`
  MODIFY `account_key` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

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

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

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

--
-- AUTO_INCREMENT for table `upi_list`
--
ALTER TABLE `upi_list`
  MODIFY `upi_key` int(11) NOT NULL AUTO_INCREMENT;

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

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
