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 revisionPrevious revision
Next revision
Previous revision
podoc:photo_version_sql_table [2007/10/19 19:36] Luudpodoc:photo_version_sql_table [2007/10/19 20:02] (current) 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,
Line 36: Line 33:
 === Is referenced by other tables === === Is referenced by other tables ===
  
-  * [[imagemagick_composite_options sql table|imagemagick_composite_options]](photo_version) references identifier+  * <del>[[imagemagick_composite_options sql table|imagemagick_composite_options]](photo_version) references identifier</del> removed in 2.34 
 +  * [[photo_dupe sql table]](version) references identifier
  
 === Related sequences === === Related sequences ===
Line 123: 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