Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.9.0.1
- -- https://www.phpmyadmin.net/
- --
- -- Host: localhost:3306
- -- Generation Time: Feb 17, 2020 at 10:19 AM
- -- Server version: 5.7.29-cll-lve
- -- PHP Version: 7.3.6
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET AUTOCOMMIT = 0;
- 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: `natyradi_salvapassIT`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `groups`
- --
- CREATE TABLE `groups` (
- `id` int(11) NOT NULL,
- `name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
- `permissions` text COLLATE utf8_unicode_ci NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- --
- -- Dumping data for table `groups`
- --
- INSERT INTO `groups` (`id`, `name`, `permissions`) VALUES
- (1, 'Standard user', ''),
- (2, 'Administrator', '{\"admin\": 1}');
- -- --------------------------------------------------------
- --
- -- Table structure for table `users`
- --
- CREATE TABLE `users` (
- `id` int(11) NOT NULL,
- `username` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
- `email` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
- `password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
- `salt` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
- `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
- `joined` datetime NOT NULL,
- `group_id` int(11) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- -- --------------------------------------------------------
- --
- -- Table structure for table `users_session`
- --
- CREATE TABLE `users_session` (
- `id` int(11) NOT NULL,
- `user_id` int(11) NOT NULL,
- `hash` varchar(50) COLLATE utf8_unicode_ci NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `groups`
- --
- ALTER TABLE `groups`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `users`
- --
- ALTER TABLE `users`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `users_session`
- --
- ALTER TABLE `users_session`
- ADD PRIMARY KEY (`id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `groups`
- --
- ALTER TABLE `groups`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
- --
- -- AUTO_INCREMENT for table `users`
- --
- ALTER TABLE `users`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `users_session`
- --
- ALTER TABLE `users_session`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
- 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement