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.

• users(imagemagick_options) references identifier

• imagemagick_options_id_sequence

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;