podoc:camera_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:camera_sql_table [2007/04/19 08:40] – Luud | podoc:camera_sql_table [2007/10/19 20:05] (current) – Luud | ||
---|---|---|---|
Line 15: | Line 15: | ||
=== Schema === | === Schema === | ||
- | | + | <code sql> |
- | identifier | + | create table camera ( |
- | type integer references camera_type(identifier), | + | identifier |
- | users | + | type integer references camera_type(identifier), |
- | serial_number | + | users |
- | date_of_purchase | + | serial_number |
- | purchased_new | + | date_of_purchase |
- | access_rights | + | purchased_new |
- | ); | + | access_rights |
+ | | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | === References tables === | ||
+ | |||
+ | * type references [[camera_type sql table|camera_type]](identifier) | ||
+ | * users references [[users sql table|users]](identifier) | ||
+ | * access_rights references [[access_type sql table|access_type]](identifier) | ||
+ | |||
+ | === Is referenced by tables === | ||
+ | |||
+ | * [[photo_tech sql table|photo_tech]](camera) references identifier | ||
=== Related sequences === | === Related sequences === | ||
Line 53: | Line 66: | ||
Still in use | Still in use | ||
- | == Change | + | == Schema change |
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | identifier | + | create table camera ( |
- | type integer references camera_type(identifier), | + | identifier |
- | users | + | type integer references camera_type(identifier), |
- | serial_number | + | users |
- | date_of_purchase | + | serial_number |
- | purchased_new | + | date_of_purchase |
- | access_rights | + | purchased_new |
- | ); | + | access_rights |
+ | ); | ||
+ | </ | ||
+ | |||
+ | = 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.txt · Last modified: 2007/10/19 20:05 by Luud