User Tools

Site Tools


podoc:dcraw_options_sql_table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
podoc:dcraw_options_sql_table [2007/04/17 11:49] Luudpodoc:dcraw_options_sql_table [2007/10/19 18:53] (current) Luud
Line 6: Line 6:
  
 === Description === === Description ===
 +
 +A set of parameters we pass into the 'dcraw' RAW converter when processing images.
  
 === Purpose === === Purpose ===
 +
 +Users can customize the image processing parameters; this stores their settings.
  
 === Schema === === Schema ===
  
-<code>+<code sql>
 -- create dcraw options table -- create dcraw options table
 create table dcraw_options ( create table dcraw_options (
Line 18: Line 22:
   brightness              float,   brightness              float,
   white_balance           varchar(10) check (white_balance in ('camera', 'automatic')),   white_balance           varchar(10) check (white_balance in ('camera', 'automatic')),
-  red_multiplier          float, 
-  blue_multiplier         float, 
   bitdepth                integer check (bitdepth in (24, 48))   bitdepth                integer check (bitdepth in (24, 48))
 ); );
 </code> </code>
  
-=== Related tables ===+=== References tables === 
 + 
 +None. 
 + 
 +=== Is referenced by tables === 
 + 
 +  * [[users sql table|users]](dcraw_options) references identifier
  
 === Related sequences === === Related sequences ===
Line 31: Line 39:
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +None.
  
 === Related views === === Related views ===
 +
 +None.
  
 === History === === History ===
Line 44: Line 58:
 == Used last == == Used last ==
  
-Still in use+Version 2.33
  
 == Schema change history == == Schema change history ==
Line 50: Line 64:
 = Version 2.21 = = Version 2.21 =
  
-<code>+<code sql>
 -- create dcraw options table -- create dcraw options table
 create table dcraw_options ( create table dcraw_options (
Line 61: Line 75:
   bitdepth                integer check (bitdepth in (24, 48))   bitdepth                integer check (bitdepth in (24, 48))
 ); );
 +</code>
 +
 += Version 2.32 =
 +
 +<code sql>
 +----- Eliminate red and blue multipliers from dcraw options
 +alter table dcraw_options drop red_multiplier;
 +alter table dcraw_options drop blue_multiplier;
 +</code>
 +
 += Version 2.34 =
 +
 +<code sql>
 +DROP TABLE dcraw_options;
 </code> </code>
  
Line 67: Line 95:
 = Version 2.21 = = Version 2.21 =
  
-<code>+<code sql>
 insert into dcraw_options (identifier, gamma, brightness, white_balance, red_multiplier, blue_multiplier, bitdepth) 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;    select imagemagick_options, 0.6, 1.0, 'automatic', 1.0, 1.0, 24 from users;
 </code> </code>
  
podoc/dcraw_options_sql_table.1176810549.txt.gz · Last modified: 2007/04/17 11:49 by Luud