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
Last revisionBoth sides next revision
podoc:photo_version_sql_table [2007/04/19 09:00] Luudpodoc:photo_version_sql_table [2007/10/19 20:02] Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-<code>+<code sql>
 create table photo_version ( create table photo_version (
   identifier            integer not null primary key,   identifier            integer not null primary key,
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>
  
-=== Related tables ===+=== References other tables ===
  
   * photo references [[photo sql table|photo]](identifier)   * photo references [[photo sql table|photo]](identifier)
   * orientation references [[orientations sql table|orientations]](identifier)   * orientation references [[orientations sql table|orientations]](identifier)
 +
 +=== Is referenced by other tables ===
 +
 +  * [[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 40: 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 65: Line 69:
 = Version 2.7 = = Version 2.7 =
  
-<code>+<code sql>
 create table photo_version ( create table photo_version (
   identifier            integer not null primary key,   identifier            integer not null primary key,
Line 81: Line 85:
 = Version 2.13 = = Version 2.13 =
  
-<code>+<code sql>
 alter table photo_version add column original_image_name varchar(500); alter table photo_version add column original_image_name varchar(500);
 </code> </code>
Line 87: Line 91:
 = Version 2.26 = = Version 2.26 =
  
-<code>+<code sql>
 alter table photo_version add column colorspace integer; alter table photo_version add column colorspace integer;
 update photo_version set colorspace = 1 where colorspace is null; update photo_version set colorspace = 1 where colorspace is null;
Line 95: 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 101: Line 111:
 = Version 2.7 = = Version 2.7 =
  
-<code>+<code sql>
 -- populate version control table -- populate version control table
 insert into photo_version insert into photo_version
Line 109: Line 119:
 = Version 2.13 = = Version 2.13 =
  
-<code>+<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