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
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 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 14:36 by Luud