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

START TRANSACTION;



--
-- Database: `u940410601_1`
--

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

--
-- Table structure for table `accountholders`
--

CREATE TABLE `accountholders` (
  `id` int(11) NOT NULL,
  `account_no` int(11) NOT NULL,
  `balance` float NOT NULL,
  `salutation` text NOT NULL,
  `username` text NOT NULL,
  `name` text NOT NULL,
  `other_name` text NOT NULL,
  `surname` text NOT NULL,
  `phone` text NOT NULL,
  `email` text NOT NULL,
  `occupation` text NOT NULL,
  `gender` text NOT NULL,
  `m_status` text NOT NULL,
  `accounttype` text NOT NULL,
  `country` text NOT NULL,
  `state` text NOT NULL,
  `city` text NOT NULL,
  `address` text NOT NULL,
  `nokname` text NOT NULL,
  `noksurname` text NOT NULL,
  `nokemail` text NOT NULL,
  `nokphone` text NOT NULL,
  `nokrelationship` text NOT NULL,
  `nokoccupation` text NOT NULL,
  `nokaddress` text NOT NULL,
  `password` text NOT NULL,
  `pin` int(11) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  `status` varchar(12) NOT NULL DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `accountholders`
--

INSERT INTO `accountholders` (`id`, `account_no`, `balance`, `salutation`, `username`, `name`, `other_name`, `surname`, `phone`, `email`, `occupation`, `gender`, `m_status`, `accounttype`, `country`, `state`, `city`, `address`, `nokname`, `noksurname`, `nokemail`, `nokphone`, `nokrelationship`, `nokoccupation`, `nokaddress`, `password`, `pin`, `date`, `status`) VALUES
(1, 2147483647, 300, 'Mr', 'admin', 'nuel', 'Emman', 'Oluwaleye', '07069721268', 'oluwaleyeolufemi@gmail.com', 'Business man', 'male', 'married', '', 'US\\', 'Ondo', 'United States', 'Oluwole street\r\nOluwole street', 'Lasky', 'Richard', 'dubemgodwin1@gmail.com', '09058444200', 'ew', 'we', ' California\n', '123456', 1234, '0000-00-00 00:00:00', 'active'),
(2, 1985298217, 10000, 'Mr', 'lasky', 'richard', 'john', 'richard', '+13043147574', 'laskyrichard2@gmail.com', 'trading', 'male', 'married', 'savings', 'gb', 'North Carolina', '269B Yishun Street 22', 'ukss', 'lilly', 'laks', 'laskyrichard2@gmail.com', '', 'son', 'student', 'laksks', '12345678', 0, '2024-02-17 06:04:43', 'active');

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

--
-- 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 dumped tables
--

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

--
-- 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 dumped tables
--

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

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

