User Tools

Site Tools


podoc:bulk_update_rule_sql_table

This is an old revision of the document!


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.1177069455.txt.gz · Last modified: 2007/04/20 11:44 by Luud