Changeset 808 for trunk/install/phpwebgallery_structure.sql

Timestamp:

Aug 8, 2005, 10:52:19 PM (19 years ago)

Author:

plg

Message:

• 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 : $userforbidden_categories equals at least "-1" so that category_id NOT IN ($userforbidden_categories) can always be used.

• modification : user_forbidden table becomes user_cache so that not only restriction informations can be stored in this table.

File:

• trunk/install/phpwebgallery_structure.sql (modified) (3 diffs)

trunk/install/phpwebgallery_structure.sql

@@ -213 +213 @@
 
 --
--- Table structure for table `phpwebgallery_user_forbidden`
---
-
-DROP TABLE IF EXISTS `phpwebgallery_user_forbidden`;
-CREATE TABLE `phpwebgallery_user_forbidden` (
+-- Table structure for table `phpwebgallery_user_cache`
+--
+
+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',
@@ -236 +236 @@
 
 --
--- 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,
+-- Table structure for table `phpwebgallery_user_infos`
+--
+
+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',
@@ -258 +255 @@
   `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`)