User Tools

Site Tools


podoc:bulk_update_rule_sql_table

Database Table Description of "bulk_update_rule"

dropped in 2.32

Name

bulk_update_rule

Description

Purpose

Schema

CREATE TABLE bulk_update_rule (
  identifier             INTEGER NOT NULL PRIMARY KEY,
  users                  INTEGER NOT NULL REFERENCES users(identifier),
  rule_name              VARCHAR(300),
  regenerate_thumbnail   CHAR(1) CHECK (regenerate_thumbnail IN ('t', 'f')),
  regenerate_preview     CHAR(1) CHECK (regenerate_preview IN ('t', 'f')),
  title                  text,
  author                 text,
  keyword                text,
  headline               text,
  caption_writer         text,
  caption                text,
  category               VARCHAR(3),
  supplemental_category  text,
  credit                 text,
  copyright_statement    text,
  web_statement          text,
  instructions           text,
  SOURCE                 text,
  transmission_reference text,
  date_of_exposure       TIMESTAMP,
  access_rights          INTEGER,
  hide_original          CHAR(1) CHECK (hide_original IN ('t', 'f')),
  location               INTEGER REFERENCES location(identifier),
  camera                 INTEGER REFERENCES camera(identifier),
  camera_metering        INTEGER REFERENCES camera_metering(identifier),
  camera_program         INTEGER REFERENCES camera_program(identifier),
  lens                   INTEGER REFERENCES lens(identifier),
  focal_length           INTEGER REFERENCES focal_length(identifier),
  FILTER                 INTEGER REFERENCES FILTER(identifier),
  film                   INTEGER REFERENCES film(identifier),
  iso_override           INTEGER REFERENCES film_iso(identifier),
  aperture               INTEGER REFERENCES aperture(identifier),
  shutter                INTEGER REFERENCES shutter(identifier),
  exposure_comp          INTEGER REFERENCES ev_comp(identifier),
  ev_difference          INTEGER REFERENCES ev_comp(identifier),
  flash                  INTEGER REFERENCES flash(identifier),
  flash_mode             INTEGER REFERENCES flash_mode(identifier),
  flash_comp             INTEGER REFERENCES ev_comp(identifier),
  scanner                INTEGER REFERENCES scanner(identifier),
  scan_resolution        INTEGER REFERENCES scan_resolution(identifier),
  scan_bitdepth          INTEGER REFERENCES scan_bitdepth(identifier),
  scan_multiscan         INTEGER REFERENCES scan_multiscan(identifier),
  support                INTEGER REFERENCES support(identifier)
);

References tables

  • aperture references aperture(identifier)
  • camera references camera(identifier)
  • camera_metering references camera_metering(identifier)
  • camera_program references camera_program(identifier)
  • ev_difference references ev_comp(identifier)
  • exposure_comp references ev_comp(identifier)
  • flash references flash(identifier)
  • flash_comp references ev_comp(identifier)
  • flash_mode references flash_mode(identifier)
  • film references film(identifier)
  • filter references filter(identifier)
  • focal_length references focal_length(identifier)
  • lens references lens(identifier)
  • location references location(identifier)
  • iso_override references film_iso(identifier)
  • scan_bitdepth references scan_bitdepth(identifier)
  • scan_multiscan references scan_multiscan(identifier)
  • scan_resolution references scan_resolution(identifier)
  • scanner references scanner(identifier)
  • shutter references shutter(identifier)
  • support references support(identifier
  • users references users(identifier)

Is referenced by tables

None.

None.

None.

None.

History

Used first

Version 2.23

Used last

Version 2.31

Schema change history

= Version 2.23 =

CREATE TABLE bulk_update_rule (
  identifier             INTEGER NOT NULL PRIMARY KEY,
  users                  INTEGER NOT NULL REFERENCES users(identifier),
  rule_name              VARCHAR(300),
  regenerate_thumbnail   CHAR(1) CHECK (regenerate_thumbnail IN ('t', 'f')),
  regenerate_preview     CHAR(1) CHECK (regenerate_preview IN ('t', 'f')),
  title                  text,
  author                 text,
  keyword                text,
  headline               text,
  caption_writer         text,
  caption                text,     
  category               VARCHAR(3),
  supplemental_category  text,
  credit                 text,
  copyright_statement    text,
  web_statement          text,
  instructions           text,
  SOURCE                 text,
  transmission_reference text,
  date_of_exposure       TIMESTAMP,
  access_rights          INTEGER NOT NULL REFERENCES access_type(identifier),
  hide_original          CHAR(1) CHECK (hide_original IN ('t', 'f')),
  location               INTEGER REFERENCES location(identifier),
  camera                 INTEGER REFERENCES camera(identifier),
  camera_metering        INTEGER REFERENCES camera_metering(identifier),
  camera_program         INTEGER REFERENCES camera_program(identifier),
  lens                   INTEGER REFERENCES lens(identifier),
  focal_length           INTEGER REFERENCES focal_length(identifier),   
  FILTER                 INTEGER REFERENCES FILTER(identifier),
  film                   INTEGER REFERENCES film(identifier),
  iso_override           INTEGER REFERENCES film_iso(identifier),
  aperture               INTEGER REFERENCES aperture(identifier),       
  shutter                INTEGER REFERENCES shutter(identifier),
  exposure_comp          INTEGER REFERENCES ev_comp(identifier),
  ev_difference          INTEGER REFERENCES ev_comp(identifier),
  flash                  INTEGER REFERENCES flash(identifier),
  flash_mode             INTEGER REFERENCES flash_mode(identifier),
  flash_comp             INTEGER REFERENCES ev_comp(identifier),
  scanner                INTEGER REFERENCES scanner(identifier),
  scan_resolution        INTEGER REFERENCES scan_resolution(identifier),
  scan_bitdepth          INTEGER REFERENCES scan_bitdepth(identifier),
  scan_multiscan         INTEGER REFERENCES scan_multiscan(identifier),
  support                INTEGER REFERENCES support(identifier)
);

= Version 2.29 =

-- begin: drop access constraint on the bulk_update_rule
CREATE TABLE bulk_update_rule_temp AS SELECT * FROM bulk_update_rule;
 
DROP TABLE bulk_update_rule;
 
CREATE TABLE bulk_update_rule (
  identifier             INTEGER NOT NULL PRIMARY KEY,
  users                  INTEGER NOT NULL REFERENCES users(identifier),
  rule_name              VARCHAR(300),
  regenerate_thumbnail   CHAR(1) CHECK (regenerate_thumbnail IN ('t', 'f')),
  regenerate_preview     CHAR(1) CHECK (regenerate_preview IN ('t', 'f')),
  title                  text,
  author                 text,
  keyword                text,
  headline               text,
  caption_writer         text,
  caption                text,
  category               VARCHAR(3),
  supplemental_category  text,
  credit                 text,
  copyright_statement    text,
  web_statement          text,
  instructions           text,
  SOURCE                 text,
  transmission_reference text,
  date_of_exposure       TIMESTAMP,
  access_rights          INTEGER,
  hide_original          CHAR(1) CHECK (hide_original IN ('t', 'f')),
  location               INTEGER REFERENCES location(identifier),
  camera                 INTEGER REFERENCES camera(identifier),
  camera_metering        INTEGER REFERENCES camera_metering(identifier),
  camera_program         INTEGER REFERENCES camera_program(identifier),
  lens                   INTEGER REFERENCES lens(identifier),
  focal_length           INTEGER REFERENCES focal_length(identifier),
  FILTER                 INTEGER REFERENCES FILTER(identifier),
  film                   INTEGER REFERENCES film(identifier),
  iso_override           INTEGER REFERENCES film_iso(identifier),
  aperture               INTEGER REFERENCES aperture(identifier),
  shutter                INTEGER REFERENCES shutter(identifier),
  exposure_comp          INTEGER REFERENCES ev_comp(identifier),
  ev_difference          INTEGER REFERENCES ev_comp(identifier),
  flash                  INTEGER REFERENCES flash(identifier),
  flash_mode             INTEGER REFERENCES flash_mode(identifier),
  flash_comp             INTEGER REFERENCES ev_comp(identifier),
  scanner                INTEGER REFERENCES scanner(identifier),
  scan_resolution        INTEGER REFERENCES scan_resolution(identifier),
  scan_bitdepth          INTEGER REFERENCES scan_bitdepth(identifier),
  scan_multiscan         INTEGER REFERENCES scan_multiscan(identifier),
  support                INTEGER REFERENCES support(identifier)
);
 
INSERT INTO bulk_update_rule SELECT * FROM bulk_update_rule_temp;
DROP TABLE bulk_update_rule_temp;
-- end: drop users constraint on the submissions

= Version 2.32 =

-- Drop the bulk update table
DROP TABLE bulk_update_rule;
Data change history
podoc/bulk_update_rule_sql_table.txt · Last modified: 2007/04/20 11:46 by Luud