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/16 13:27] 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), 
 +  colorspace            integer not null, 
 +  orientation           integer not null references orientations(identifier),, 
 +  date_changed          timestamp without time zone
 ); );
 </code> </code>
  
-=== Related tables ===+=== References other tables ===
  
-  * [[photo sql table|photo]]+  * photo references [[photo sql table|photo]](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 34: Line 41:
  
 === Related indexes === === Related indexes ===
 +
 +  * [[photo_version_photo_idx sql index|photo_version_photo_idx]]
 +  * [[photo_version_photo sql index|photo_version_photo]]
  
 === Related functions === === Related functions ===
 +
 +  * [[count_photo_versions sql function|count_photo_versions]]
 +  * [[count_photo_versions_by_user sql function|count_photo_versions_by_user]]
  
 === Related views === === Related views ===
Line 56: 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 68: Line 81:
   comment               text   comment               text
 ); );
 +</code>
 +
 += Version 2.13 =
 +
 +<code sql>
 +alter table photo_version add column original_image_name varchar(500);
 +</code>
 +
 += Version 2.26 =
 +
 +<code sql>
 +alter table photo_version add column colorspace integer;
 +update photo_version set colorspace = 1 where colorspace is null;
 +alter table photo_version alter colorspace set not null;
 +
 +alter table photo_version add column orientation integer references orientations(identifier);
 +update photo_version set orientation = 1 where orientation is 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 74: 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 82: 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