File manager - Edit - /home/custbahd/cornerstoneassetmanagers.com/admin/counter/sql/counter.sql
Back
-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jun 27, 2023 at 07:13 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: `chatapp` -- -- -------------------------------------------------------- -- -- Table structure for table `messages` -- CREATE TABLE `messages` ( `msg_id` int(11) NOT NULL, `incoming_msg_id` int(255) NOT NULL, `outgoing_msg_id` int(255) NOT NULL, `msg` varchar(1000) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `user_id` int(255) NOT NULL, `fname` varchar(255) NOT NULL, `lname` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `img` varchar(255) NOT NULL, `status` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `user_id`, `fname`, `lname`, `email`, `password`, `img`, `status`) VALUES (1, 1210190712, 'Ian', 'Muhumuza', 'ianmuhumuza@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', '1686921350fab0887d-7be0-472e-a609-6dd93a6e6a1e.jpg', 'Active now'), (2, 420056036, 'The', 'Saucerer', 'sauces@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', '1686921406f51c1f0a-0073-4548-8e75-07ba3c282cd8.jpg', 'Active now'), (3, 1448436690, 'Mr.', 'Newman', 'newman@g.com', 'e10adc3949ba59abbe56e057f20f883e', '1686921602be688b0c-d19a-4aa6-b4e6-24df6ee01e58.jpg', 'Offline now'); -- -- Indexes for dumped tables -- -- -- Indexes for table `messages` -- ALTER TABLE `messages` ADD PRIMARY KEY (`msg_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `messages` -- ALTER TABLE `messages` MODIFY `msg_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; 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.01 |
proxy
|
phpinfo
|
Settings