File manager - Edit - /home/custbahd/irungikitchen.com/admin/sql/custbahd_users.sql
Back
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 10, 2024 at 07:13 PM -- Server version: 10.6.19-MariaDB-cll-lve -- PHP Version: 8.1.28 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: `custbahd_irungi` -- -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `user_id` text NOT NULL, `user_name` varchar(255) NOT NULL, `user_email` varchar(255) NOT NULL, `user_phone` varchar(255) NOT NULL, `user_role` varchar(255) NOT NULL, `user_image` varchar(255) NOT NULL, `ban` varchar(255) NOT NULL, `ban_reason` text NOT NULL, `status` varchar(255) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `user_id`, `user_name`, `user_email`, `user_phone`, `user_role`, `user_image`, `ban`, `ban_reason`, `status`, `timestamp`) VALUES (1, 'Admin-1', 'Ian Muhumuza', 'ianmuhumuza@gmail.com', '785196012', 'Admin', '', '', '', 'Online', '2024-07-09 17:02:44'), (2, 'Admin-2', 'Sade Madonna', 'sm@gmail.com', '34678854567', 'Admin', '', '', '', 'Online', '2024-07-09 17:51:02'), (4, 'Admin-2', 'Saucerer M', 'sauce@gmail.comm', '123456', 'Admin', '', '', '', 'Online', '2024-07-19 21:43:06'), (5, 'Admin-3', 'Newman', 'new@yahoo.com', '123456', 'Admin', '', '', '', '', '2024-07-20 17:46:40'), (6, 'Admin-4', 'Mark Rwatangabo', 'rwatangabomarc@gmail.com', '0751876300', 'Admin', '', '', '', '', '2024-08-05 18:46:57'), (7, 'Admin-5', 'Linda Rwatangabo', 'linda.rwatangabo@gmail.com', '0775883574', 'Admin', '', '', '', 'Online', '2024-09-03 20:07:30'); -- -- Indexes for dumped tables -- -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; 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 */;
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 2.82 |
proxy
|
phpinfo
|
Settings