User Tools

Site Tools


podoc:focal_length_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
podoc:focal_length_sql_table [2007/04/16 16:12] Luudpodoc:focal_length_sql_table [2007/04/20 14:27] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  create table focal_length ( +<code sql> 
-    identifier            integer not null primary key, +create table focal_length ( 
-    value                 varchar(10+  identifier            integer not null primary key, 
-  );+  value                 integer 
 +); 
 +</code> 
 + 
 +=== References tables === 
 + 
 +None. 
 + 
 +=== Is referenced by tables === 
 + 
 +  * [[lens_type sql table|lens_type]](max_focal_lengthreferences identifier 
 +  * [[lens_type sql table|lens_type]](min_focal_lengthreferences identifier 
 +  * [[photo_tech sql table|photo_tech]](focal_length) references identifier
  
 === Related sequences === === Related sequences ===
  
-  * [[ focal_length_id_sequence_sql_sequence | focal_length_id_sequence]]+  * [[focal_length_id_sequence_sql_sequence|focal_length_id_sequence]]
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +None.
  
 === Related views === === Related views ===
 +
 +  * [[view_lens sql view|view_lens]]
 +  * [[view_lens_type sql view|view_lens_type]]
  
 === History === === History ===
Line 40: Line 59:
 = Version 2.5 = = Version 2.5 =
  
-  ccreate table focal_length ( +<code sql> 
-    identifier            integer not null primary key, +create table focal_length ( 
-    value                 varchar(10) +  identifier            integer not null primary key, 
-  );+  value                 varchar(10) 
 +); 
 +</code> 
 + 
 += Version 2.32 = 
 + 
 +<code sql> 
 +-- Convert focal length from a varchar to an integer 
 +alter table focal_length add value_num integer; 
 +update focal_length set value_num = value::text::integer; 
 +alter table focal_length drop value; 
 +alter table focal_length rename value_num to value; 
 +</code>
  
 == Data change history == == Data change history ==
Line 49: Line 80:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 insert into focal_length values (nextval('focal_length_id_sequence'), '5'); insert into focal_length values (nextval('focal_length_id_sequence'), '5');
 insert into focal_length values (nextval('focal_length_id_sequence'), '6'); insert into focal_length values (nextval('focal_length_id_sequence'), '6');
Line 99: Line 130:
 = Version 2.32 = = Version 2.32 =
  
-<code>+<code sql>
 -- Add more focal lengths. -- Add more focal lengths.
 insert into focal_length values (nextval('focal_length_id_sequence'), 75); insert into focal_length values (nextval('focal_length_id_sequence'), 75);
Line 107: Line 138:
 = Version 2.33 = = Version 2.33 =
  
-<code>+<code sql>
 -- Add more focal lengths. -- Add more focal lengths.
 insert into focal_length values (nextval('focal_length_id_sequence'), 65); insert into focal_length values (nextval('focal_length_id_sequence'), 65);
podoc/focal_length_sql_table.1176739932.txt.gz · Last modified: 2007/04/16 16:12 by Luud