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) );
Related sequences
Related indexes
Related functions
Related views
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