From 02111b79be58a13f83dd0751839559488c7aed57 Mon Sep 17 00:00:00 2001 From: plegall Date: Tue, 12 Jun 2012 20:51:25 +0000 Subject: feature 2632: remove useless columns and config settings at gallery installation git-svn-id: http://piwigo.org/svn/trunk@15652 68402e56-0260-453c-a942-63ccdbb3a9ee --- install/config.sql | 14 -------------- install/piwigo_structure-mysql.sql | 7 ------- 2 files changed, 21 deletions(-) (limited to 'install') diff --git a/install/config.sql b/install/config.sql index 9e10291c5..b88607856 100644 --- 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 index 35a0cfe68..8f7c87009 100644 --- 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', -- cgit v1.2.3