tNViq4AY

1CREATE TABLE IF NOT EXISTS `permissions` (
2  `bit` int(11) NOT NULL,
3  `description` varchar(255) NOT NULL,
4  PRIMARY KEY (`bit`),
5  UNIQUE KEY `description` (`description`)
6) ENGINE=InnoDB DEFAULT CHARSET=utf8;
7
8INSERT INTO `permissions` (`bit`, `description`) VALUES
9  (1, 'create'),
10  (2, 'read'),
11  (4, 'update'),
12  (8, 'delete');
13
14CREATE TABLE IF NOT EXISTS `users` (
15  `user_id` int(11) NOT NULL AUTO_INCREMENT,
16  `username` varchar(255) NOT NULL,
17  `permissions` int(11) NOT NULL,
18  PRIMARY KEY (`user_id`),
19  UNIQUE KEY `username` (`username`)
20) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
21
22INSERT INTO `users` (`user_id`, `username`, `permissions`) VALUES
23  (1, 'Admin', 15),
24  (2, 'Gino', 7),
25  (3, 'Pino', 3),
26  (4, 'Rino', 6);