BJh0ybUR

1CREATE TABLE IF NOT EXISTS `roles` (
2  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
3  `name` varchar(32) NOT NULL,
4  `description` varchar(255) NOT NULL,
5  PRIMARY KEY  (`id`),
6  UNIQUE KEY `uniq_name` (`name`)
7) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
8 
9INSERT INTO `roles` (`id`, `name`, `description`) VALUES(1, 'login', 'Login privileges, granted after account confirmation');
10INSERT INTO `roles` (`id`, `name`, `description`) VALUES(2, 'admin', 'Administrative user, has access to everything.');
11 
12CREATE TABLE IF NOT EXISTS `roles_users` (
13  `user_id` int(10) UNSIGNED NOT NULL,
14  `role_id` int(10) UNSIGNED NOT NULL,
15  PRIMARY KEY  (`user_id`,`role_id`),
16  KEY `fk_role_id` (`role_id`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8;
18 
19CREATE TABLE IF NOT EXISTS `users` (
20  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
21  `email` varchar(127) NOT NULL,
22  `username` varchar(32) NOT NULL DEFAULT '',
23  `password` char(50) NOT NULL,
24  `logins` int(10) UNSIGNED NOT NULL DEFAULT '0',
25  `last_login` int(10) UNSIGNED,
26  PRIMARY KEY  (`id`),
27  UNIQUE KEY `uniq_username` (`username`),
28  UNIQUE KEY `uniq_email` (`email`)
29) ENGINE=InnoDB  DEFAULT CHARSET=utf8;