User Tools

Site Tools


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

None.

None.

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 14:53 by Luud