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.
Related sequences
Related indexes
None.
Related functions
None.
Related views
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