User Tools

Site Tools


podoc:imagemagick_options_sql_table

Database Table Description of "imagemagick_options"

Name

imagemagick_options

Description

Purpose

Schema

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
);

References tables

None.

Is referenced by tables

  • users(imagemagick_options) references identifier

None.

None.

None.

History

Used first

Version 2.11

Used last

Version 2.33

Schema change history

= 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;
Data change history

= 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;
podoc/imagemagick_options_sql_table.txt · Last modified: 2007/10/19 14:53 by Luud