File manager - Edit - /home/custbahd/irungikitchen.com/admin/sql/users.sql
Back
-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: May 30, 2023 at 07:05 PM -- Server version: 10.4.20-MariaDB -- PHP Version: 8.0.8 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: `mobi` -- -- -------------------------------------------------------- -- -- 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_company` varchar(255) NOT NULL, `user_image` varchar(255) NOT NULL, `ban` varchar(255) NOT NULL, `ban_reason` text NOT NULL, `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `user_id`, `user_name`, `user_email`, `user_phone`, `user_role`, `user_company`, `user_image`, `ban`, `ban_reason`, `timestamp`) VALUES (1, 'Seller-1', 'Ian Muhumuza', 'ianmuhumuza@gmail.com', '785196012', 'Seller', 'Custom Assist Inc.', 'seller/register/images/f51c1f0a-0073-4548-8e75-07ba3c282cd8.jpg', '1', 'Test', '2023-03-30 15:32:29'), (2, 'Seller-2', 'Newman Man', 'newman@g.com', '785196012', 'Seller', 'Newman Ltd', 'seller/register/images/fab0887d-7be0-472e-a609-6dd93a6e6a1e.jpg', '', '', '2023-03-30 19:12:04'), (3, 'Seller-3', 'The Saucerer', 'sauces@gmail.com', '785196012', 'Seller', 'MOBI', 'seller/register/images/be688b0c-d19a-4aa6-b4e6-24df6ee01e58.jpg', '', '', '2023-03-30 19:15:07'), (4, 'Buyer-1', 'Iann', 'ianmuhumuza@gmail.com', '785196012', 'Buyer', '', 'buyer/register/images/banner-01.png', '', '', '2023-04-13 14:42:26'), (5, 'Buyer-2', 'Sauces', 'sauces@gmail.com', '785196012', 'Buyer', '', 'buyer/register/images/20221205_151939_0002.png', '', '', '2023-04-13 15:27:02'), (6, 'Buyer-3', 'Newman Man', 'newman@g.com', '785196012', 'Buyer', '', 'buyer/register/images/20221208_165116_0001.png', '', '', '2023-05-05 21:35:27'), (7, 'Admin-1', 'Iann Muhumuza', 'ianmuhumuza@gmail.com', '785196012', 'Admin', '', 'admin/register/images/queens.jpg', '', '', '2023-05-22 13:44:59'), (8, 'Admin-2', 'Newman Man', 'newman@g.com', '785196012', 'Admin', '', 'admin/register/images/', '', '', '2023-05-22 16:02:09'), (9, 'Admin-3', 'Iann Muhumuza', 'ianmuhumuza@gmail.com', '785196012', 'Admin', '', 'admin/register/images/', '', '', '2023-05-22 16:06:16'); -- -- 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=10; 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: 0.64 |
proxy
|
phpinfo
|
Settings