Photo Organizer

dcraw_options

A set of parameters we pass into the 'dcraw' RAW converter when processing images.

Users can customize the image processing parameters; this stores their settings.

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

None.

• users(dcraw_options) references identifier

• dcraw_options_id_sequence

None.

None.

None.

Version 2.21

Version 2.33

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

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