User Tools

Site Tools


podoc:shutter_sql_table

Database Table Description of "shutter"

Name

shutter

Description

Purpose

Schema

CREATE TABLE shutter (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(10)
);

References tables

None.

Is referenced by tables

None.

None.

None.

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= Version 2.5 =

CREATE TABLE shutter (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  VALUE                 VARCHAR(10)
);

= Data change history =

= Version 2.5 =

INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '60');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '30');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '25');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '20');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '15');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '13');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '10');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '8');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '6');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '5');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '4');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '3');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '2.5');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '2');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '1.6');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '1.3');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '1');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '1.3');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '1.6');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '2.0');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '2.5');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '3');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '4');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '5');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '6');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '8');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '10');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '13');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '15');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '20');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '25');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '30');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '40');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '50');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '60');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '80');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '100');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '125');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '160');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '200');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '250');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '320');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '400');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '500');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '640');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '800');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '1000');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '1250');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '1600');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '2000');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '2500');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '3200');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '4000');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '5000');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '6400');
INSERT INTO shutter VALUES (NEXTVAL('shutter_id_sequence'), '8000');

= Version 2.6 =

-- remove the second mark from the shutter speeds
UPDATE shutter SET VALUE='60'     WHERE identifier=1;
UPDATE shutter SET VALUE='30'     WHERE identifier=2;
UPDATE shutter SET VALUE='25'     WHERE identifier=3;
UPDATE shutter SET VALUE='20'     WHERE identifier=4;
UPDATE shutter SET VALUE='15'     WHERE identifier=5;
UPDATE shutter SET VALUE='13'     WHERE identifier=6;
UPDATE shutter SET VALUE='10'     WHERE identifier=7;
UPDATE shutter SET VALUE='8'      WHERE identifier=8;
UPDATE shutter SET VALUE='6'      WHERE identifier=9;
UPDATE shutter SET VALUE='5'      WHERE identifier=10;
UPDATE shutter SET VALUE='4'      WHERE identifier=11;
UPDATE shutter SET VALUE='3'      WHERE identifier=12;
UPDATE shutter SET VALUE='2.5'    WHERE identifier=13;
UPDATE shutter SET VALUE='2'      WHERE identifier=14;
UPDATE shutter SET VALUE='1.6'    WHERE identifier=15;
UPDATE shutter SET VALUE='1.3'    WHERE identifier=16;
UPDATE shutter SET VALUE='1'      WHERE identifier=17;
UPDATE shutter SET VALUE='1/1.3'  WHERE identifier=18;
UPDATE shutter SET VALUE='1/1.6'  WHERE identifier=19;
UPDATE shutter SET VALUE='1/2.0'  WHERE identifier=20;
UPDATE shutter SET VALUE='1/2.5'  WHERE identifier=21;
UPDATE shutter SET VALUE='1/3'    WHERE identifier=22;
UPDATE shutter SET VALUE='1/4'    WHERE identifier=23;
UPDATE shutter SET VALUE='1/5'    WHERE identifier=24;
UPDATE shutter SET VALUE='1/6'    WHERE identifier=25;
UPDATE shutter SET VALUE='1/8'    WHERE identifier=26;
UPDATE shutter SET VALUE='1/10'   WHERE identifier=27;
UPDATE shutter SET VALUE='1/13'   WHERE identifier=28;
UPDATE shutter SET VALUE='1/15'   WHERE identifier=29;
UPDATE shutter SET VALUE='1/20'   WHERE identifier=30;
UPDATE shutter SET VALUE='1/25'   WHERE identifier=31;
UPDATE shutter SET VALUE='1/30'   WHERE identifier=32;
UPDATE shutter SET VALUE='1/40'   WHERE identifier=33;
UPDATE shutter SET VALUE='1/50'   WHERE identifier=34;
UPDATE shutter SET VALUE='1/60'   WHERE identifier=35;
UPDATE shutter SET VALUE='1/80'   WHERE identifier=36;
UPDATE shutter SET VALUE='1/100'  WHERE identifier=37;
UPDATE shutter SET VALUE='1/125'  WHERE identifier=38;
UPDATE shutter SET VALUE='1/160'  WHERE identifier=39;
UPDATE shutter SET VALUE='1/200'  WHERE identifier=40;
UPDATE shutter SET VALUE='1/250'  WHERE identifier=41;
UPDATE shutter SET VALUE='1/320'  WHERE identifier=42;
UPDATE shutter SET VALUE='1/400'  WHERE identifier=43;
UPDATE shutter SET VALUE='1/500'  WHERE identifier=44;
UPDATE shutter SET VALUE='1/640'  WHERE identifier=45;
UPDATE shutter SET VALUE='1/800'  WHERE identifier=46;
UPDATE shutter SET VALUE='1/1000' WHERE identifier=47;
UPDATE shutter SET VALUE='1/1250' WHERE identifier=48;
UPDATE shutter SET VALUE='1/1600' WHERE identifier=49;
UPDATE shutter SET VALUE='1/2000' WHERE identifier=50;
UPDATE shutter SET VALUE='1/2500' WHERE identifier=51;
UPDATE shutter SET VALUE='1/3200' WHERE identifier=52;
UPDATE shutter SET VALUE='1/4000' WHERE identifier=53;
UPDATE shutter SET VALUE='1/5000' WHERE identifier=54;
UPDATE shutter SET VALUE='1/6400' WHERE identifier=55;
UPDATE shutter SET VALUE='1/8000' WHERE identifier=56;
podoc/shutter_sql_table.txt · Last modified: 2007/04/20 10:36 by Luud