-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 28, 2022 at 07:37 PM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 7.4.29

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: `cb_investdb`
--

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

--
-- Table structure for table `banktb`
--

CREATE TABLE `banktb` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `phone_no` varchar(255) NOT NULL,
  `trans_id` varchar(255) NOT NULL,
  `amount` int(11) NOT NULL,
  `profit_gain` int(11) NOT NULL,
  `status` varchar(255) NOT NULL,
  `duration` varchar(255) NOT NULL,
  `user_country` varchar(255) NOT NULL,
  `user_city` varchar(255) NOT NULL,
  `cur_date` varchar(255) NOT NULL,
  `cur_month` varchar(255) NOT NULL,
  `cur_year` varchar(255) NOT NULL,
  `curtime` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `banktb`
--

INSERT INTO `banktb` (`id`, `user_id`, `phone_no`, `trans_id`, `amount`, `profit_gain`, `status`, `duration`, `user_country`, `user_city`, `cur_date`, `cur_month`, `cur_year`, `curtime`) VALUES
(1, '1', '7888888888', '123', 300000, 1600, 'D', '30', '', '', '23', 'Jul', '2022', '16:45:06'),
(2, '1', '7888888888', '122', 600000, 1200, 'D', '30', '', '', '23', 'Jul', '2022', '21:07:23'),
(3, '1', '7888888888', '221', 300000, 0, 'W', '', '', '', '23', 'Jul', '2022', '21:40:36'),
(4, '1', '7888888888', '981', 0, 0, 'D', '150', '', '', '24', 'Jul', '2022', '22:03:36'),
(5, '3', '0783333333', '445', 300000, 0, 'D', '30', '', '', '26', 'Jul', '2022', '14:55:44');

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

--
-- Table structure for table `invest_usertb`
--

CREATE TABLE `invest_usertb` (
  `id` int(11) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `user_phone_no` varchar(255) NOT NULL,
  `user_password` varchar(255) NOT NULL,
  `user_county` varchar(255) NOT NULL,
  `user_city` varchar(255) NOT NULL,
  `cur_date` varchar(255) NOT NULL,
  `cur_month` varchar(255) NOT NULL,
  `cur_year` varchar(255) NOT NULL,
  `cur_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `invest_usertb`
--

INSERT INTO `invest_usertb` (`id`, `user_name`, `user_phone_no`, `user_password`, `user_county`, `user_city`, `cur_date`, `cur_month`, `cur_year`, `cur_time`) VALUES
(1, '', '7888888888', '666666', '', '', '20', 'Jul', '2022', '00:00:00'),
(2, '', '0758888777', '636363', '', '', '20', 'Jul', '2022', '20:05:20'),
(3, '', '0783333333', '444444', '', '', '20', 'Jul', '2022', '21:06:13'),
(4, '', '0796666666', '999999', '', '', '20', 'Jul', '2022', '21:18:50'),
(5, '', '0796666666', '999999', '', '', '20', 'Jul', '2022', '21:22:07');

--
-- Indexes for dumped tables
--

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `invest_usertb`
--
ALTER TABLE `invest_usertb`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
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 */;