User Tools

Site Tools


podoc:camera_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
Next revision
Previous revision
podoc:camera_sql_table [2007/04/20 14:22]
Luud
podoc:camera_sql_table [2007/10/19 20:05] (current)
Luud
Line 23: Line 23:
   date_of_purchase      timestamp,   date_of_purchase      timestamp,
   purchased_new         char(1) check (purchased_new in ('t', 'f')),   purchased_new         char(1) check (purchased_new in ('t', 'f')),
-  access_rights         integer not null references access_type(identifier)+  access_rights         integer not null references access_type(identifier)
 +  ignore_comment        boolean not null
 ); );
 </code> </code>
Line 35: Line 36:
 === Is referenced by tables === === Is referenced by tables ===
  
-  * [[photo_tech sql table|photo_tech]](camera references) references identifier+  * [[photo_tech sql table|photo_tech]](camera) references identifier
  
 === Related sequences === === Related sequences ===
Line 65: Line 66:
 Still in use Still in use
  
-== Change history ==+== Schema change history ==
  
 = Version 2.5 = = Version 2.5 =
Line 81: Line 82:
 </code> </code>
  
 += Version 2.34 =
 +
 +<code sql>
 +-- Add a flag to ignore the camera's user comments
 +
 +alter table camera add ignore_comment boolean;
 +</code>
 +
 +<code sql>
 +alter table camera alter ignore_comment set not null;
 +</code>
 +
 +== Data change history ==
 +
 += Version 2.34 =
 +
 +<code sql>
 +update camera set ignore_comment = 'f';
 +</code>
podoc/camera_sql_table.1177078958.txt.gz · Last modified: 2007/04/20 14:22 by Luud