-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Feb 17, 2024 at 06:32 AM -- Server version: 10.11.6-MariaDB-cll-lve -- PHP Version: 7.2.34 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: `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; /*!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 */;