- modification : less configuration parameters in administration

  screen. These parameters are move to include/config_default.inc.php.

- new : ability to add a single picture to caddie from picture.php

- new : contextual help, only a few pages are available.

- new : ability to delete users from admin/user_list

- modification : reorganization of configuration file

- new : configuration parameter use_exif_mapping

- improvement : MOD hidemail added to standard


git-svn-id: http://piwigo.org/svn/trunk@858 68402e56-0260-453c-a942-63ccdbb3a9ee

2 files changed, 9 insertions, 16 deletions

diff --git a/install/config.sql b/install/config.sql
index ba7e8875d..fa27ce1e3 100644
--- a/install/config.sql
+++ b/install/config.sql
@@ -1,17 +1,10 @@
 -- initial configuration for PhpWebGallery
 
-INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('prefix_thumbnail','TN-','thumbnails filename prefix');
-INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('mail_webmaster','','webmaster mail');
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('default_language','en_UK.iso-8859-1','Default gallery language');
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('default_template','default','Default gallery style');
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('default_maxwidth','','maximum width authorized for displaying images');
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('default_maxheight','','maximum height authorized for the displaying images');
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('nb_comment_page','10','number of comments to display on each page');
-INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('upload_maxfilesize','150','maximum filesize for the uploaded pictures');
-INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('upload_maxwidth','800','maximum width authorized for the uploaded images');
-INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('upload_maxheight','600','maximum height authorized for the uploaded images');
-INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('upload_maxwidth_thumbnail','150','maximum width authorized for the uploaded thumbnails');
-INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('upload_maxheight_thumbnail','100','maximum height authorized for the uploaded thumbnails');
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('log','false','keep an history of visits on your website');
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('comments_validation','false','administrators validate users comments before becoming visible');
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('comments_forall','false','even guest not registered can post comments');
diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql
index 28368df69..5d0bac12a 100644
--- a/install/phpwebgallery_structure.sql
+++ b/install/phpwebgallery_structure.sql
@@ -77,7 +77,7 @@ CREATE TABLE `phpwebgallery_config` (
 
 DROP TABLE IF EXISTS `phpwebgallery_favorites`;
 CREATE TABLE `phpwebgallery_favorites` (
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `image_id` mediumint(8) unsigned NOT NULL default '0',
   PRIMARY KEY  (`user_id`,`image_id`)
 ) TYPE=MyISAM;
@@ -170,7 +170,7 @@ CREATE TABLE `phpwebgallery_images` (
 
 DROP TABLE IF EXISTS `phpwebgallery_rate`;
 CREATE TABLE `phpwebgallery_rate` (
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `element_id` mediumint(8) unsigned NOT NULL default '0',
   `rate` tinyint(2) unsigned NOT NULL default '0',
   PRIMARY KEY  (`user_id`,`element_id`)
@@ -183,7 +183,7 @@ CREATE TABLE `phpwebgallery_rate` (
 DROP TABLE IF EXISTS `phpwebgallery_sessions`;
 CREATE TABLE `phpwebgallery_sessions` (
   `id` varchar(255) binary NOT NULL default '',
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `expiration` datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (`id`)
 ) TYPE=MyISAM;
@@ -206,7 +206,7 @@ CREATE TABLE `phpwebgallery_sites` (
 
 DROP TABLE IF EXISTS `phpwebgallery_user_access`;
 CREATE TABLE `phpwebgallery_user_access` (
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `cat_id` smallint(5) unsigned NOT NULL default '0',
   PRIMARY KEY  (`user_id`,`cat_id`)
 ) TYPE=MyISAM;
@@ -217,7 +217,7 @@ CREATE TABLE `phpwebgallery_user_access` (
 
 DROP TABLE IF EXISTS `phpwebgallery_user_cache`;
 CREATE TABLE `phpwebgallery_user_cache` (
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `need_update` enum('true','false') NOT NULL default 'true',
   `forbidden_categories` text,
   PRIMARY KEY  (`user_id`)
@@ -230,7 +230,7 @@ CREATE TABLE `phpwebgallery_user_cache` (
 DROP TABLE IF EXISTS `phpwebgallery_user_feed`;
 CREATE TABLE `phpwebgallery_user_feed` (
   `id` varchar(50) binary NOT NULL default '',
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `last_check` datetime default NULL,
   PRIMARY KEY  (`id`)
 ) TYPE=MyISAM;
@@ -241,7 +241,7 @@ CREATE TABLE `phpwebgallery_user_feed` (
 
 DROP TABLE IF EXISTS `phpwebgallery_user_group`;
 CREATE TABLE `phpwebgallery_user_group` (
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) NOT NULL default '0',
   `group_id` smallint(5) unsigned NOT NULL default '0',
   PRIMARY KEY  (`group_id`,`user_id`)
 ) TYPE=MyISAM;
@@ -252,7 +252,7 @@ CREATE TABLE `phpwebgallery_user_group` (
 
 DROP TABLE IF EXISTS `phpwebgallery_user_infos`;
 CREATE TABLE `phpwebgallery_user_infos` (
-  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `user_id` smallint(5) 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',
@@ -273,7 +273,7 @@ CREATE TABLE `phpwebgallery_user_infos` (
 
 DROP TABLE IF EXISTS `phpwebgallery_users`;
 CREATE TABLE `phpwebgallery_users` (
-  `id` smallint(5) unsigned NOT NULL auto_increment,
+  `id` smallint(5) NOT NULL auto_increment,
   `username` varchar(20) binary NOT NULL default '',
   `password` varchar(32) default NULL,
   `mail_address` varchar(255) default NULL,