podoc:focal_length_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:focal_length_sql_table [2007/04/17 13:10] – Luud | podoc:focal_length_sql_table [2007/04/20 14:27] (current) – Luud | ||
---|---|---|---|
Line 11: | Line 11: | ||
=== Schema === | === Schema === | ||
- | < | + | < |
create table focal_length ( | create table focal_length ( | ||
identifier | identifier | ||
Line 17: | Line 17: | ||
); | ); | ||
</ | </ | ||
+ | |||
+ | === References tables === | ||
+ | |||
+ | None. | ||
+ | |||
+ | === Is referenced by tables === | ||
+ | |||
+ | * [[lens_type sql table|lens_type]](max_focal_length) references identifier | ||
+ | * [[lens_type sql table|lens_type]](min_focal_length) references identifier | ||
+ | * [[photo_tech sql table|photo_tech]](focal_length) references identifier | ||
=== Related sequences === | === Related sequences === | ||
Line 23: | Line 33: | ||
=== Related indexes === | === Related indexes === | ||
+ | |||
+ | None. | ||
=== Related functions === | === Related functions === | ||
+ | |||
+ | None. | ||
=== Related views === | === Related views === | ||
- | * [[view_focal_length sql view|view_focal_length]] | ||
* [[view_lens sql view|view_lens]] | * [[view_lens sql view|view_lens]] | ||
* [[view_lens_type sql view|view_lens_type]] | * [[view_lens_type sql view|view_lens_type]] | ||
Line 46: | Line 59: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | < | + | < |
create table focal_length ( | create table focal_length ( | ||
identifier | identifier | ||
Line 55: | Line 68: | ||
= Version 2.32 = | = Version 2.32 = | ||
- | < | + | < |
-- Convert focal length from a varchar to an integer | -- Convert focal length from a varchar to an integer | ||
alter table focal_length add value_num integer; | alter table focal_length add value_num integer; | ||
Line 67: | Line 80: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | < | + | < |
insert into focal_length values (nextval(' | insert into focal_length values (nextval(' | ||
insert into focal_length values (nextval(' | insert into focal_length values (nextval(' | ||
Line 117: | Line 130: | ||
= Version 2.32 = | = Version 2.32 = | ||
- | < | + | < |
-- Add more focal lengths. | -- Add more focal lengths. | ||
insert into focal_length values (nextval(' | insert into focal_length values (nextval(' | ||
Line 125: | Line 138: | ||
= Version 2.33 = | = Version 2.33 = | ||
- | < | + | < |
-- Add more focal lengths. | -- Add more focal lengths. | ||
insert into focal_length values (nextval(' | insert into focal_length values (nextval(' |
podoc/focal_length_sql_table.1176815430.txt.gz · Last modified: 2007/04/17 13:10 by Luud