podoc:ev_comp_sql_table
Database Table Description of "ev_comp"
Name
ev_comp
Description
Purpose
Schema
CREATE TABLE ev_comp ( identifier INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10) );
References tables
None.
Is referenced by tables
- photo_tech(ev_difference) references identifier
- photo_tech(exposure_comp) references identifier
- photo_tech(flash_comp) references identifier
Related sequences
Related indexes
None.
Related functions
None.
Related views
None.
History
Used first
Version 2.5
Used last
Still in use
Schema change history
= Version 2.5 =
CREATE TABLE ev_comp ( identifier INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10) );
Data change history
= Version 2.5 =
INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-5'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-4.7'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-4.5'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-4.3'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-4'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-3.7'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-3.5'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-3.3'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-3'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-2.7'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-2.5'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-2.3'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-2'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-1.7'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-1.5'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-1.3'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-1'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-0.7'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-0.5'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '-0.3'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '0'); -- the missing values were added in 2.6 INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '1.3'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '1.5'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '1.7'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '2'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '2.3'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '2.5'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '2.7'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '3'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '3.3'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '3.5'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '3.7'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '4'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '4.3'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '4.5'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '4.7'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '5');
= Version 2.6 =
-- insert the missing ev_comp values INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '0.3'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '0.5'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '0.7'); INSERT INTO ev_comp VALUES (NEXTVAL('ev_comp_id_sequence'), '1');
-- reset ev compensation values so that they appear in the sequence they should UPDATE ev_comp SET VALUE='0.3' WHERE identifier=22; UPDATE ev_comp SET VALUE='0.5' WHERE identifier=23; UPDATE ev_comp SET VALUE='0.7' WHERE identifier=24; UPDATE ev_comp SET VALUE='1' WHERE identifier=25; UPDATE ev_comp SET VALUE='1.3' WHERE identifier=26; UPDATE ev_comp SET VALUE='1.5' WHERE identifier=27; UPDATE ev_comp SET VALUE='1.7' WHERE identifier=28; UPDATE ev_comp SET VALUE='2' WHERE identifier=29; UPDATE ev_comp SET VALUE='2.3' WHERE identifier=30; UPDATE ev_comp SET VALUE='2.5' WHERE identifier=31; UPDATE ev_comp SET VALUE='2.7' WHERE identifier=32; UPDATE ev_comp SET VALUE='3' WHERE identifier=33; UPDATE ev_comp SET VALUE='3.3' WHERE identifier=34; UPDATE ev_comp SET VALUE='3.5' WHERE identifier=35; UPDATE ev_comp SET VALUE='3.7' WHERE identifier=36; UPDATE ev_comp SET VALUE='4' WHERE identifier=37; UPDATE ev_comp SET VALUE='4.3' WHERE identifier=38; UPDATE ev_comp SET VALUE='4.5' WHERE identifier=39; UPDATE ev_comp SET VALUE='4.7' WHERE identifier=40; UPDATE ev_comp SET VALUE='5' WHERE identifier=41;
podoc/ev_comp_sql_table.txt · Last modified: 2007/04/20 14:24 by Luud