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/10/19 15:27] Luudpodoc:photo_sql_table [2007/10/31 15:43] (current) Luud
Line 34: Line 34:
   supplemental_category  text,   supplemental_category  text,
   web_statement          text,   web_statement          text,
-  date_added             timestamp without time zone+  date_added             timestamp without time zone
 +  date_changed           timestamp without time zone, 
 +  store_url              text, 
 +  comments               text
 ); );
 </code> </code>
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</del> removed in 2.34
   * [[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</del> removed in 2.34
   * [[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]]</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 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>
 +
 +<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.1192807644.txt.gz · Last modified: 2007/10/19 15:27 by Luud