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 revision Previous revision
podoc:shutter_sql_table [2007/04/19 04:53]
Luud
podoc:shutter_sql_table [2007/04/20 10: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 46: 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 55: 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 116: 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 175: 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.txt · Last modified: 2007/04/20 10:36 by Luud