User Tools

Site Tools


podoc:shutter_sql_table

This is an old revision of the document!


Database Table Description of "shutter"

Name

shutter

Description

Purpose

Schema

create table shutter (
  identifier            integer not null primary key,
  value                 varchar(10)
);

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.1176456076.txt.gz · Last modified: 2007/04/13 09:21 by Luud