podoc:photo_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:photo_sql_table [2007/10/19 15:27] – Luud | podoc:photo_sql_table [2007/10/31 15:43] (current) – Luud | ||
---|---|---|---|
Line 34: | Line 34: | ||
supplemental_category | supplemental_category | ||
web_statement | web_statement | ||
- | date_added | + | date_added |
+ | date_changed | ||
+ | store_url | ||
+ | comments | ||
); | ); | ||
</ | </ | ||
Line 49: | Line 52: | ||
* [[album_content sql table|album_content]](photo) references identifier | * [[album_content sql table|album_content]](photo) references identifier | ||
* [[photo_dupe sql table|photo_dupe]](photo) references identifier | * [[photo_dupe sql table|photo_dupe]](photo) references identifier | ||
- | * [[photo_item sql table|photo_item]](photo) references identifier | + | * <del>[[photo_item sql table|photo_item]](photo) references identifier</ |
* [[photo_keywords sql table|photo_keywords]](photo) references identifier | * [[photo_keywords sql table|photo_keywords]](photo) references identifier | ||
- | * [[photo_spooler sql table|photo_spooler]](photo) references identifier | + | * <del>[[photo_spooler sql table|photo_spooler]](photo) references identifier</ |
* [[photo_tech sql table|photo_tech]](photo) references identifier | * [[photo_tech sql table|photo_tech]](photo) references identifier | ||
* [[photo_version sql table|photo_version]](photo) references identifier | * [[photo_version sql table|photo_version]](photo) references identifier | ||
Line 66: | Line 69: | ||
=== Related indexes === | === Related indexes === | ||
- | * [[photo_id_idx sql index|photo_id_idx]] | + | * [[photo_folder sql index|photo_folder]] |
+ | * <del>[[photo_id_idx sql index|photo_id_idx]]</ | ||
* [[photo_users_idx sql index|photo_users_idx]] | * [[photo_users_idx sql index|photo_users_idx]] | ||
* [[photo_location_idx sql index|photo_location_idx]] | * [[photo_location_idx sql index|photo_location_idx]] | ||
Line 183: | Line 187: | ||
-- Add a field to track when a photo was added | -- Add a field to track when a photo was added | ||
alter table photo add date_added timestamp without time zone; | alter table photo add date_added timestamp without time zone; | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | alter table photo add date_changed timestamp without time zone; | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | --- Add a ' | ||
+ | alter table photo add store_url text; | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | -- Add a comments column to the photos. | ||
+ | alter table photo add column comments text; | ||
</ | </ | ||
podoc/photo_sql_table.1192807644.txt.gz · Last modified: 2007/10/19 15:27 by Luud