podoc:shutter_sql_table
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
podoc:shutter_sql_table [2007/04/12 12:07] – created Luud | podoc:shutter_sql_table [2007/04/20 14:36] (current) – Luud | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Database Table Description ===== | + | ===== Database Table Description |
=== Name === | === Name === | ||
+ | |||
+ | shutter | ||
=== Description === | === Description === | ||
Line 8: | Line 10: | ||
=== Schema === | === Schema === | ||
+ | |||
+ | <code sql> | ||
+ | create table shutter ( | ||
+ | identifier | ||
+ | value | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | === 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 | + | Version |
== Used last == | == Used last == | ||
Line 23: | Line 52: | ||
Still in use | Still in use | ||
- | == Change | + | == Schema change |
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | ... | + | create table shutter ( |
- | | + | identifier |
+ | value | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | = Data change history = | ||
+ | |||
+ | = Version 2.5 = | ||
+ | |||
+ | <code sql> | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | insert into shutter values (nextval(' | ||
+ | </ | ||
+ | |||
+ | = Version 2.6 = | ||
+ | |||
+ | <code sql> | ||
+ | -- remove the second mark from the shutter speeds | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | update shutter set value=' | ||
+ | </ |
podoc/shutter_sql_table.1176379661.txt.gz · Last modified: 2007/04/12 12:07 by Luud