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/04/20 14:07] – Luud | podoc:photo_sql_table [2007/10/31 15:43] (current) – Luud | ||
---|---|---|---|
Line 33: | Line 33: | ||
transmission_reference text, | transmission_reference text, | ||
supplemental_category | supplemental_category | ||
- | web_statement | + | web_statement |
+ | date_added | ||
+ | date_changed | ||
+ | store_url | ||
+ | comments | ||
); | ); | ||
</ | </ | ||
Line 48: | 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_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 | ||
+ | * [[rating sql table|rating]](photo) references identifier | ||
=== Related tables === | === Related tables === | ||
Line 62: | 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 172: | Line 180: | ||
-- This is called by the upgrade script -- | -- This is called by the upgrade script -- | ||
-- alter table photo drop keyword; | -- alter table photo drop keyword; | ||
+ | </ | ||
+ | |||
+ | = Version 2.34 = | ||
+ | |||
+ | <code sql> | ||
+ | -- Add a field to track when a photo was added | ||
+ | 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.1177078036.txt.gz · Last modified: 2007/04/20 14:07 by Luud