ev_comp

CREATE TABLE ev_comp (
  identifier            integer NOT NULL PRIMARY KEY,
  value                 varchar(10)
);

None.

• photo_tech(ev_difference) references identifier
• photo_tech(exposure_comp) references identifier
• photo_tech(flash_comp) references identifier

• ev_comp_id_sequence

None.

None.

None.

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE ev_comp (
  identifier            integer NOT NULL PRIMARY KEY,
  value                 varchar(10)
);

= 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;