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

START TRANSACTION;



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

--
-- Table structure for table `banksettings`
--

CREATE TABLE `banksettings` (
  `id` int(11) NOT NULL,
  `sitename` text NOT NULL,
  `siteemail` text NOT NULL,
  `sitelogo` text NOT NULL,
  `siteurl` text NOT NULL,
  `btc` text NOT NULL,
  `usdt` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `banksettings`
--

INSERT INTO `banksettings` (`id`, `sitename`, `siteemail`, `sitelogo`, `siteurl`, `btc`, `usdt`) VALUES
(1, 'Standard Sky Prime', 'support@standardskyprime.com', 'logo.png', 'https://standardskyprime.com/', 'btcjkksdewldkwe', 'usdtdnfwefkenw');

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

--
-- Table structure for table `deposithistory`
--

CREATE TABLE `deposithistory` (
  `id` int(11) NOT NULL,
  `username` text NOT NULL,
  `amount` text NOT NULL,
  `asset` text NOT NULL,
  `status` text NOT NULL DEFAULT 'Pending',
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `deposithistory`
--

INSERT INTO `deposithistory` (`id`, `username`, `amount`, `asset`, `status`, `date`) VALUES
(1, 'admin', '20000', 'btc', 'Pending', '2024-02-15 20:44:33'),
(2, 'admin', '20000', 'usdt', 'Pending', '2024-02-15 22:16:53');

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

--
-- Table structure for table `loans`
--

CREATE TABLE `loans` (
  `id` int(11) NOT NULL,
  `username` text NOT NULL,
  `loanpurpose` text NOT NULL,
  `loanamount` text NOT NULL,
  `status` text NOT NULL DEFAULT 'Pending',
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `loans`
--

INSERT INTO `loans` (`id`, `username`, `loanpurpose`, `loanamount`, `status`, `date`) VALUES
(1, 'admin', 'Buesiness', '123', 'Approved', '2024-02-15 19:54:55'),
(2, 'admin', 'Tuition', '778', 'Pending', '2024-02-15 22:33:43');

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

--
-- Table structure for table `support`
--

CREATE TABLE `support` (
  `id` int(11) NOT NULL,
  `username` text NOT NULL,
  `subject` text NOT NULL,
  `body` text NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `status` text NOT NULL DEFAULT 'In Progress'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `support`
--

INSERT INTO `support` (`id`, `username`, `subject`, `body`, `date`, `status`) VALUES
(1, 'admin', 'hew', 'fwe', '2024-02-16 00:51:22', 'In Progress'),
(2, 'admin', 'hew', 'fwe', '2024-02-16 00:52:01', 'In Progress'),
(3, 'admin', 'wedeew', 'ewdwex', '2024-02-16 00:52:14', 'In Progress');

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

--
-- Table structure for table `transferhistory`
--

CREATE TABLE `transferhistory` (
  `id` int(11) NOT NULL,
  `accountnumber` text NOT NULL,
  `amount` text NOT NULL,
  `bank` text NOT NULL,
  `bankname` text NOT NULL,
  `swift` text NOT NULL,
  `accname` text NOT NULL,
  `accphone` text NOT NULL,
  `accemail` text NOT NULL,
  `description` text NOT NULL,
  `username` text NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `status` text NOT NULL DEFAULT 'Pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transferhistory`
--

INSERT INTO `transferhistory` (`id`, `accountnumber`, `amount`, `bank`, `bankname`, `swift`, `accname`, `accphone`, `accemail`, `description`, `username`, `date`, `status`) VALUES
(1, '7836531250', '20000', '', '', '', '', '', '', 'qw', 'admin', '2024-02-16 02:29:48', 'Pending');

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

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

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

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

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

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

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

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

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

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

