User Tools

Site Tools


podoc:photo_sql_table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
podoc:photo_sql_table [2007/04/20 14:07] Luudpodoc:photo_sql_table [2007/10/31 15:43] (current) Luud
Line 33: Line 33:
   transmission_reference text,   transmission_reference text,
   supplemental_category  text,   supplemental_category  text,
-  web_statement          text+  web_statement          text, 
 +  date_added             timestamp without time zone, 
 +  date_changed           timestamp without time zone, 
 +  store_url              text, 
 +  comments               text
 ); );
 </code> </code>
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</del> removed in 2.34
   * [[photo_keywords sql table|photo_keywords]](photo) references identifier   * [[photo_keywords sql table|photo_keywords]](photo) references identifier
 +  * <del>[[photo_spooler sql table|photo_spooler]](photo) references identifier</del> removed in 2.34
 +  * [[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]]</del> removed in 2.34
   * [[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;
 +</code>
 +
 += 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>
 +
 +<code sql>
 +alter table photo add date_changed timestamp without time zone;
 +</code>
 +
 +<code sql>
 +--- Add a 'purcahse url' to photos.
 +alter table photo add store_url text;
 +</code>
 +
 +<code sql>
 +-- Add a comments column to the photos.
 +alter table photo add column comments text;
 </code> </code>
  
podoc/photo_sql_table.1177078036.txt.gz · Last modified: 2007/04/20 14:07 by Luud