[[podoc:shutter_sql_table]]
Trace: » album_sql_table » files_sql_table » camera_sql_table » filter_sql_table » rating_sql_table » database_schemas » version_sql_table » support_sql_table » scanner_sql_table » shutter_sql_table
Show pagesourceOld revisions
Recent changesIndex

Photo Organizer

News

Documentation

Development

Misc

Photo Organizer Documentation

Installation

User Documentation

Developer Documentation

External documentation

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 10:36 by Luud
Show pagesourceOld revisions
Back to top
www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0