User Tools

Site Tools


podoc:shutter_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:shutter_sql_table [2007/04/13 09:21] Luudpodoc:shutter_sql_table [2007/04/20 14:36] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  create table shutter ( +<code sql> 
-    identifier            integer not null primary key, +create table shutter ( 
-    value                 varchar(10) +  identifier            integer not null primary key, 
-  );+  value                 varchar(10) 
 +); 
 +</code> 
 + 
 +=== References tables === 
 + 
 +None. 
 + 
 +=== Is referenced by tables === 
 + 
 +  * [[shutter_id_sequence sql sequence|shutter_id_sequence]]
  
 === Related sequences === === Related sequences ===
Line 21: Line 31:
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +None.
  
 === Related views === === Related views ===
 +
 +None.
  
 === History === === History ===
Line 40: Line 56:
 = Version 2.5 = = Version 2.5 =
  
-  create table shutter ( +<code sql> 
-    identifier            integer not null primary key, +create table shutter ( 
-    value                 varchar(10) +  identifier            integer not null primary key, 
-  );+  value                 varchar(10) 
 +); 
 +</code>
  
 = Data change history = = Data change history =
Line 49: Line 67:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 insert into shutter values (nextval('shutter_id_sequence'), '60'); insert into shutter values (nextval('shutter_id_sequence'), '60');
 insert into shutter values (nextval('shutter_id_sequence'), '30'); insert into shutter values (nextval('shutter_id_sequence'), '30');
Line 110: Line 128:
 = Version 2.6 = = Version 2.6 =
  
-<code>+<code sql>
 -- remove the second mark from the shutter speeds -- remove the second mark from the shutter speeds
 update shutter set value='60'     where identifier=1; update shutter set value='60'     where identifier=1;
Line 169: Line 187:
 update shutter set value='1/8000' where identifier=56; update shutter set value='1/8000' where identifier=56;
 </code> </code>
 +
podoc/shutter_sql_table.1176456076.txt.gz · Last modified: 2007/04/13 09:21 by Luud