Photo Organizer

User Tools

Site Tools

Trace:
podoc:aperture_sql_table

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
podoc:aperture_sql_table [2007/04/20 11:30] – Luudpodoc:aperture_sql_table [2007/04/20 13:37] – Luud
Line 17: Line 17:
 === Schema === === Schema ===
  
-  create table aperture ( +<code sql> 
-    identifier            integer not null primary key, +create table aperture ( 
-    value                 varchar(10) +  identifier            integer not null primary key, 
-  ); +  value                 varchar(10) 
 +);  
 +</code>
  
 === 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
  
 === Related sequences === === Related sequences ===
Line 61: Line 64:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 create table aperture ( create table aperture (
   identifier            integer not null primary key,   identifier            integer not null primary key,
Line 70: Line 73:
 = Version 2.32 = = Version 2.32 =
  
-<code>+<code sql>
 -- 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 85:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 insert into aperture values (nextval('aperture_id_sequence'), '0.5'); insert into aperture values (nextval('aperture_id_sequence'), '0.5');
 insert into aperture values (nextval('aperture_id_sequence'), '0.75'); insert into aperture values (nextval('aperture_id_sequence'), '0.75');
podoc/aperture_sql_table.txt · Last modified: 2007/04/20 14:22 by Luud