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
Related sequences
Related indexes
None.
Related functions
None.
Related views
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 18:53 by Luud