imagemagick_options
CREATE TABLE imagemagick_options ( identifier INTEGER NOT NULL PRIMARY KEY, preview_quality INTEGER, preview_colorspace VARCHAR(20), preview_gamma FLOAT, preview_sharpen_radius FLOAT, preview_sharpen_sigma FLOAT, preview_border_width INTEGER, preview_border_height INTEGER, preview_border_color VARCHAR(6), thumb_quality INTEGER, thumb_colorspace VARCHAR(20), thumb_gamma FLOAT, thumb_sharpen_radius FLOAT, thumb_sharpen_sigma FLOAT, thumb_border_width INTEGER, thumb_border_height INTEGER, thumb_border_color VARCHAR(6) preview_sharpen_threshold FLOAT, preview_sharpen_amount FLOAT, thumb_sharpen_threshold FLOAT, thumb_sharpen_amount FLOAT );
None.
None.
None.
None.
Version 2.11
Version 2.33
= Version 2.11 =
-- create image magick options table and populate it with exisiting sharpening values CREATE TABLE imagemagick_options ( identifier INTEGER NOT NULL PRIMARY KEY, preview_quality INTEGER, preview_colorspace VARCHAR(20), preview_gamma FLOAT, preview_sharpen_radius FLOAT, preview_sharpen_sigma FLOAT, preview_border_width INTEGER, preview_border_height INTEGER, preview_border_color VARCHAR(6), thumb_quality INTEGER, thumb_colorspace VARCHAR(20), thumb_gamma FLOAT, thumb_sharpen_radius FLOAT, thumb_sharpen_sigma FLOAT, thumb_border_width INTEGER, thumb_border_height INTEGER, thumb_border_color VARCHAR(6) );
= Version 2.29 =
ALTER TABLE imagemagick_options ADD preview_sharpen_threshold FLOAT; ALTER TABLE imagemagick_options ADD preview_sharpen_amount FLOAT; ALTER TABLE imagemagick_options ADD thumb_sharpen_threshold FLOAT; ALTER TABLE imagemagick_options ADD thumb_sharpen_amount FLOAT;
= Version 2.34 =
DROP TABLE imagemagick_options;
= Version 2.11 =
-- upload imagemagick table with values from preferences and defaults INSERT INTO imagemagick_options (identifier, preview_quality, preview_colorspace, preview_gamma, preview_sharpen_radius, preview_sharpen_sigma, preview_border_color, preview_border_width, preview_border_height, thumb_quality, thumb_colorspace, thumb_gamma, thumb_sharpen_radius, thumb_sharpen_sigma, thumb_border_color, thumb_border_width, thumb_border_height) SELECT identifier, 80 AS preview_quality, 'RGB' AS preview_colorspace, '1.0' AS preview_gamma, sharpen_image_radius AS preview_sharpen_radius, sharpen_image_sigma AS preview_sharpen_sigma, '000000' AS preview_border_color, 0 AS preview_border_width, 0 AS preview_border_height, 80 AS thumb_quality, 'RGB' AS thumb_colorspace, '1.0' AS thumb_gamma, sharpen_image_radius AS thumb_sharpen_radius, sharpen_image_sigma AS thumb_sharpen_sigma, '000000' AS thumb_border_color, 0 AS thumb_border_width, 0 AS thumb_border_height FROM preferences;
= Version 2.29 =
UPDATE imagemagick_options SET preview_sharpen_threshold = 0.05; UPDATE imagemagick_options SET thumb_sharpen_threshold = 0.00; UPDATE imagemagick_options SET preview_sharpen_amount = 1.7; UPDATE imagemagick_options SET thumb_sharpen_amount = 2.7;