User Tools

Site Tools


podoc:shutter_sql_table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
podoc:shutter_sql_table [2007/04/12 12:07] – created Luudpodoc:shutter_sql_table [2007/04/20 14:36] (current) Luud
Line 1: Line 1:
-===== Database Table Description =====+===== Database Table Description of "shutter" =====
  
 === Name === === Name ===
 +
 +shutter
  
 === Description === === Description ===
Line 8: Line 10:
  
 === Schema === === Schema ===
 +
 +<code sql>
 +create table shutter (
 +  identifier            integer not null primary key,
 +  value                 varchar(10)
 +);
 +</code>
 +
 +=== References tables ===
 +
 +None.
 +
 +=== Is referenced by tables ===
 +
 +  * [[shutter_id_sequence sql sequence|shutter_id_sequence]]
  
 === Related sequences === === Related sequences ===
 +
 +  * [[shutter_id_sequence sql sequence|shutter_id_sequence]]
  
 === Related indexes === === Related indexes ===
 +
 +None.
 +
 +=== Related functions ===
 +
 +None.
 +
 +=== Related views ===
 +
 +None.
  
 === History === === History ===
Line 17: Line 46:
 == Used first == == Used first ==
  
-Verions 2.5+Version 2.5
  
 == Used last == == Used last ==
Line 23: Line 52:
 Still in use Still in use
  
-== Change history ==+== Schema change history ==
  
 = Version 2.5 = = Version 2.5 =
  
-  create table ... ( +<code sql> 
-    ...   +create table shutter ( 
-  );+  identifier            integer not null primary key, 
 +  value                 varchar(10) 
 +); 
 +</code> 
 + 
 += Data change history = 
 + 
 += Version 2.5 = 
 + 
 +<code sql> 
 +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'); 
 +</code> 
 + 
 += Version 2.6 = 
 + 
 +<code sql> 
 +-- 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; 
 +</code> 
podoc/shutter_sql_table.1176379661.txt.gz · Last modified: 2007/04/12 12:07 by Luud