podoc:camera_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
podoc:camera_sql_table [2007/04/20 14:25] – Luud | podoc:camera_sql_table [2007/10/19 20:05] (current) – Luud | ||
---|---|---|---|
Line 23: | Line 23: | ||
date_of_purchase | date_of_purchase | ||
purchased_new | purchased_new | ||
- | access_rights | + | access_rights |
+ | ignore_comment | ||
); | ); | ||
</ | </ | ||
Line 65: | Line 66: | ||
Still in use | Still in use | ||
- | == Change | + | == Schema change |
= Version 2.5 = | = Version 2.5 = | ||
Line 81: | Line 82: | ||
</ | </ | ||
+ | = Version 2.34 = | ||
+ | |||
+ | <code sql> | ||
+ | -- Add a flag to ignore the camera' | ||
+ | |||
+ | alter table camera add ignore_comment boolean; | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | alter table camera alter ignore_comment set not null; | ||
+ | </ | ||
+ | |||
+ | == Data change history == | ||
+ | |||
+ | = Version 2.34 = | ||
+ | |||
+ | <code sql> | ||
+ | update camera set ignore_comment = ' | ||
+ | </ |
podoc/camera_sql_table.1177079155.txt.gz · Last modified: 2007/04/20 14:25 by Luud