podoc:aperture_sql_table
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
podoc:aperture_sql_table [2007/04/20 07:30] Luud |
podoc:aperture_sql_table [2007/04/20 10:22] (current) Luud |
||
|---|---|---|---|
| Line 17: | Line 17: | ||
| === Schema === | === Schema === | ||
| - | | + | <code sql> |
| - | identifier | + | create table aperture ( |
| - | value | + | identifier |
| - | ); | + | value |
| + | ); | ||
| + | </ | ||
| === References tables === | === References tables === | ||
| Line 28: | Line 30: | ||
| === Is referenced by tables === | === Is referenced by tables === | ||
| - | None. | + | * [[lens_type sql table|lens_type]](max_aperture) references identifier |
| + | * [[lens_type sql table|lens_type]](min_aperture) references identifier | ||
| + | * [[photo_tech sql table|photo_tech]](aperture) references identifier | ||
| === Related sequences === | === Related sequences === | ||
| Line 61: | Line 65: | ||
| = Version 2.5 = | = Version 2.5 = | ||
| - | < | + | < |
| create table aperture ( | create table aperture ( | ||
| identifier | identifier | ||
| Line 70: | Line 74: | ||
| = Version 2.32 = | = Version 2.32 = | ||
| - | < | + | < |
| -- Convert aperture from a varchar to a numeric type | -- Convert aperture from a varchar to a numeric type | ||
| alter table aperture add value_num numeric; | alter table aperture add value_num numeric; | ||
| Line 82: | Line 86: | ||
| = Version 2.5 = | = Version 2.5 = | ||
| - | < | + | < |
| insert into aperture values (nextval(' | insert into aperture values (nextval(' | ||
| insert into aperture values (nextval(' | insert into aperture values (nextval(' | ||
podoc/aperture_sql_table.1177068659.txt.gz · Last modified: 2007/04/20 07:30 by Luud
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
