podoc:dcraw_options_sql_table
Database Table Description of "dcraw_options"
Name
dcraw_options
Description
A set of parameters we pass into the 'dcraw' RAW converter when processing images.
Purpose
Users can customize the image processing parameters; this stores their settings.
Schema
-- create dcraw options table CREATE TABLE dcraw_options ( identifier INTEGER NOT NULL PRIMARY KEY, gamma FLOAT, brightness FLOAT, white_balance VARCHAR(10) CHECK (white_balance IN ('camera', 'automatic')), bitdepth INTEGER CHECK (bitdepth IN (24, 48)) );
References tables
None.
Is referenced by tables
- users(dcraw_options) references identifier
Related sequences
Related indexes
None.
Related functions
None.
Related views
None.
History
Used first
Version 2.21
Used last
Version 2.33
Schema change history
= Version 2.21 =
-- create dcraw options table CREATE TABLE dcraw_options ( identifier INTEGER NOT NULL PRIMARY KEY, gamma FLOAT, brightness FLOAT, white_balance VARCHAR(10) CHECK (white_balance IN ('camera', 'automatic')), red_multiplier FLOAT, blue_multiplier FLOAT, bitdepth INTEGER CHECK (bitdepth IN (24, 48)) );
= Version 2.32 =
----- Eliminate red and blue multipliers from dcraw options ALTER TABLE dcraw_options DROP red_multiplier; ALTER TABLE dcraw_options DROP blue_multiplier;
= Version 2.34 =
DROP TABLE dcraw_options;
Data change history
= Version 2.21 =
INSERT INTO dcraw_options (identifier, gamma, brightness, white_balance, red_multiplier, blue_multiplier, bitdepth) SELECT imagemagick_options, 0.6, 1.0, 'automatic', 1.0, 1.0, 24 FROM users;
podoc/dcraw_options_sql_table.txt · Last modified: 2007/10/19 18:53 by Luud