| 9 | | * |
| 10 | | * Database table schemas: |
| 11 | | * <code sql> |
| 12 | | * CREATE TABLE IF NOT EXISTS `users` ( |
| 13 | | * `id` int(11) unsigned NOT NULL auto_increment, |
| 14 | | * `email` varchar(127) NOT NULL, |
| 15 | | * `username` varchar(32) NOT NULL default '', |
| 16 | | * `password` char(50) NOT NULL, |
| 17 | | * `logins` int(10) unsigned NOT NULL default '0', |
| 18 | | * PRIMARY KEY (`id`), |
| 19 | | * UNIQUE KEY `uniq_username` (`username`), |
| 20 | | * UNIQUE KEY `uniq_email` (`email`) |
| 21 | | * ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| 22 | | * |
| 23 | | * CREATE TABLE IF NOT EXISTS `roles` ( |
| 24 | | * `id` int(11) unsigned NOT NULL auto_increment, |
| 25 | | * `name` varchar(32) NOT NULL, |
| 26 | | * `description` varchar(255) NOT NULL, |
| 27 | | * PRIMARY KEY (`id`), |
| 28 | | * UNIQUE KEY `uniq_name` (`name`) |
| 29 | | * ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| 30 | | * |
| 31 | | * INSERT INTO `roles` (`id`, `name`, `description`) VALUES (1, 'login', 'Login access privileges'); |
| 32 | | * |
| 33 | | * CREATE TABLE IF NOT EXISTS `users_roles` ( |
| 34 | | * `user_id` int(10) unsigned NOT NULL, |
| 35 | | * `role_id` int(10) unsigned NOT NULL, |
| 36 | | * PRIMARY KEY (`user_id`,`role_id`) |
| 37 | | * ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| 38 | | * </code> |