feature 2632: remove useless columns and config settings at gallery i…

…nstallation git-svn-id: http://piwigo.org/svn/trunk@15652 68402e56-0260-453c-a942-63ccdbb3a9ee
Piwigo · Jun 12, 2012 · 02111b7 · 02111b7
1 parent 9ab3c71
commit 02111b7
Show file tree

Hide file tree

Showing 2 changed files with 0 additions and 21 deletions.
diff --git a/install/config.sql b/install/config.sql
@@ -55,20 +55,6 @@ INSERT INTO piwigo_config (param,value,comment) VALUES ('week_starts_on','monday
 INSERT INTO piwigo_config (param,value,comment) VALUES ('updates_ignored','a:3:{s:7:"plugins";a:0:{}s:6:"themes";a:0:{}s:9:"languages";a:0:{}}','Extensions ignored for update');
 INSERT INTO piwigo_config (param,value,comment) VALUES ('order_by','ORDER BY date_available DESC, file ASC, id ASC','default photo order');
 INSERT INTO piwigo_config (param,value,comment) VALUES ('order_by_inside_category','ORDER BY date_available DESC, file ASC, id ASC','default photo order inside category');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_websize_resize','false');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_websize_maxwidth','800');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_websize_maxheight','600');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_websize_quality','95');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_thumb_maxwidth','128');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_thumb_maxheight','96');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_thumb_quality','95');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_thumb_crop','false');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_thumb_follow_orientation','true');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_hd_keep','true');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_hd_resize','false');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_hd_maxwidth','2000');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_hd_maxheight','2000');
-INSERT INTO piwigo_config (param,value) VALUES ('upload_form_hd_quality','95');
 INSERT INTO piwigo_config (param,value) VALUES ('original_resize','false');
 INSERT INTO piwigo_config (param,value) VALUES ('original_resize_maxwidth','2016');
 INSERT INTO piwigo_config (param,value) VALUES ('original_resize_maxheight','2016');

diff --git a/install/piwigo_structure-mysql.sql b/install/piwigo_structure-mysql.sql
@@ -177,7 +177,6 @@ CREATE TABLE `piwigo_images` (
   `file` varchar(255) binary NOT NULL default '',
   `date_available` datetime NOT NULL default '0000-00-00 00:00:00',
   `date_creation` datetime default NULL,
-  `tn_ext` varchar(4) default '',
   `name` varchar(255) default NULL,
   `comment` text,
   `author` varchar(255) default NULL,
@@ -189,12 +188,8 @@ CREATE TABLE `piwigo_images` (
   `representative_ext` varchar(4) default NULL,
   `date_metadata_update` date default NULL,
   `rating_score` float(5,2) unsigned default NULL,
-  `has_high` enum('true') default NULL,
   `path` varchar(255) NOT NULL default '',
   `storage_category_id` smallint(5) unsigned default NULL,
-  `high_filesize` mediumint(9) unsigned default NULL,
-  `high_width` smallint(9) unsigned default NULL,
-  `high_height` smallint(9) unsigned default NULL,
   `level` tinyint unsigned NOT NULL default '0',
   `md5sum` char(32) default NULL,
   `added_by` smallint(5) NOT NULL default '0',
@@ -409,8 +404,6 @@ CREATE TABLE `piwigo_user_infos` (
   `nb_image_page` smallint(3) unsigned NOT NULL default '15',
   `status` enum('webmaster','admin','normal','generic','guest') NOT NULL default 'guest',
   `language` varchar(50) NOT NULL default 'en_UK',
-  `maxwidth` smallint(6) default NULL,
-  `maxheight` smallint(6) default NULL,
   `expand` enum('true','false') NOT NULL default 'false',
   `show_nb_comments` enum('true','false') NOT NULL default 'false',
   `show_nb_hits` enum('true','false') NOT NULL default 'false',