User Tools

Site Tools


podoc:photo_version_sql_table

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
podoc:photo_version_sql_table [2007/04/20 11:55]
Luud
podoc:photo_version_sql_table [2007/10/19 20:02]
Luud
Line 17: Line 17:
   photo                 integer not null references photo(identifier),   photo                 integer not null references photo(identifier),
   master                char(1) check (master in ('t', 'f')),   master                char(1) check (master in ('t', 'f')),
-  small_image_path      varchar(500), 
-  medium_image_path     varchar(500), 
-  large_image_path      varchar(500), 
   date_of_creation      timestamp,   date_of_creation      timestamp,
   comment               text,   comment               text,
   original_image_name   varchar(500),   original_image_name   varchar(500),
   colorspace            integer not null,   colorspace            integer not null,
-  orientation           integer not null references orientations(identifier)+  orientation           integer not null references orientations(identifier),,¬†
 +  date_changed          timestamp without time zone
 ); );
 </code> </code>
Line 35: Line 33:
 === Is referenced by other tables === === Is referenced by other tables ===
  
-None.+  * [[photo_dupe sql table]](version) references identifier¬†
 +  * <del>[[imagemagick_composite_options sql table|imagemagick_composite_options]](photo_version) references identifier</del> removed in 2.34
  
 === Related sequences === === Related sequences ===
Line 44: Line 43:
  
   * [[photo_version_photo_idx sql index|photo_version_photo_idx]]   * [[photo_version_photo_idx sql index|photo_version_photo_idx]]
 +  * [[photo_version_photo sql index|photo_version_photo]]
  
 === Related functions === === Related functions ===
Line 99: Line 99:
 update photo_version set orientation = 1 where orientation is null; update photo_version set orientation = 1 where orientation is null;
 alter table photo_version alter orientation set not null; alter table photo_version alter orientation set not null;
 +</code>
 +
 += Version 2.34 =
 +
 +<code sql>
 +alter table photo_version add date_changed timestamp without time zone;
 </code> </code>
  
Line 115: Line 121:
 <code sql> <code sql>
 update photo_version set original_image_name = 'file'; update photo_version set original_image_name = 'file';
 +</code>
 +
 += Version 2.34 =
 +
 +<code sql>
 +alter table photo_version drop small_image_path;
 +alter table photo_version drop medium_image_path;
 +alter table photo_version drop large_image_path;
 </code> </code>
  
podoc/photo_version_sql_table.txt · Last modified: 2007/10/19 20:02 by Luud