Changeset 15652

Timestamp:

Jun 12, 2012, 10:51:25 PM (12 years ago)

Author:

plg

Message:

feature 2632: remove useless columns and config settings at gallery installation

Location:

trunk/install

Files:

• config.sql (modified) (1 diff)
• piwigo_structure-mysql.sql (modified) (3 diffs)

trunk/install/config.sql

@@ -56 +56 @@
 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');

trunk/install/piwigo_structure-mysql.sql

@@ -178 +178 @@
   `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,
@@ -190 +189 @@
   `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,
@@ -410 +405 @@
   `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',