From 273884a65274e2688df1b2d3dc37103a46117772 Mon Sep 17 00:00:00 2001 From: plegall Date: Mon, 8 Aug 2005 20:52:19 +0000 Subject: - new : external authentication in another users table. Previous users table is divided between users (common properties with any web application) and user_infos (phpwebgallery specific informations). External table and fields can be configured. - modification : profile.php is not reachable through administration anymore (not useful). - modification : in profile.php, current password is mandatory only if user tries to change his password. Username can't be changed. - deletion : of obsolete functions get_user_restrictions, update_user_restrictions, get_user_all_restrictions, is_user_allowed, update_user - modification : $user['forbidden_categories'] equals at least "-1" so that category_id NOT IN ($user['forbidden_categories']) can always be used. - modification : user_forbidden table becomes user_cache so that not only restriction informations can be stored in this table. git-svn-id: http://piwigo.org/svn/trunk@808 68402e56-0260-453c-a942-63ccdbb3a9ee --- install/phpwebgallery_structure.sql | 30 ++++++++++++++++++++---------- 1 file changed, 20 insertions(+), 10 deletions(-) (limited to 'install') diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql index 9ca7af0a7..98e81b3e9 100644 --- a/install/phpwebgallery_structure.sql +++ b/install/phpwebgallery_structure.sql @@ -212,11 +212,11 @@ CREATE TABLE `phpwebgallery_user_access` ( ) TYPE=MyISAM; -- --- Table structure for table `phpwebgallery_user_forbidden` +-- Table structure for table `phpwebgallery_user_cache` -- -DROP TABLE IF EXISTS `phpwebgallery_user_forbidden`; -CREATE TABLE `phpwebgallery_user_forbidden` ( +DROP TABLE IF EXISTS `phpwebgallery_user_cache`; +CREATE TABLE `phpwebgallery_user_cache` ( `user_id` smallint(5) unsigned NOT NULL default '0', `need_update` enum('true','false') NOT NULL default 'true', `forbidden_categories` text, @@ -235,15 +235,12 @@ CREATE TABLE `phpwebgallery_user_group` ( ) TYPE=MyISAM; -- --- Table structure for table `phpwebgallery_users` +-- Table structure for table `phpwebgallery_user_infos` -- -DROP TABLE IF EXISTS `phpwebgallery_users`; -CREATE TABLE `phpwebgallery_users` ( - `id` smallint(5) unsigned NOT NULL auto_increment, - `username` varchar(20) binary NOT NULL default '', - `password` varchar(32) default NULL, - `mail_address` varchar(255) default NULL, +DROP TABLE IF EXISTS `phpwebgallery_user_infos`; +CREATE TABLE `phpwebgallery_user_infos` ( + `user_id` smallint(5) unsigned NOT NULL default '0', `nb_image_line` tinyint(1) unsigned NOT NULL default '5', `nb_line_page` tinyint(3) unsigned NOT NULL default '3', `status` enum('admin','guest') NOT NULL default 'guest', @@ -257,6 +254,19 @@ CREATE TABLE `phpwebgallery_users` ( `last_feed_check` datetime default NULL, `feed_id` varchar(50) binary default NULL, `registration_date` datetime NOT NULL default '0000-00-00 00:00:00', + UNIQUE KEY `user_infos_ui1` (`user_id`) +) TYPE=MyISAM; + +-- +-- Table structure for table `phpwebgallery_users` +-- + +DROP TABLE IF EXISTS `phpwebgallery_users`; +CREATE TABLE `phpwebgallery_users` ( + `id` smallint(5) unsigned NOT NULL auto_increment, + `username` varchar(20) binary NOT NULL default '', + `password` varchar(32) default NULL, + `mail_address` varchar(255) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_ui1` (`username`) ) TYPE=MyISAM; -- cgit v1.2.3