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 revisionPrevious revision
podoc:camera_sql_table [2007/04/20 14:25] Luudpodoc: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 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.1177079155.txt.gz · Last modified: 2007/04/20 14:25 by Luud