User Tools

Site Tools


podoc:photo_version_sql_table

This is an old revision of the document!


Database Table Description of "photo_version"

Name

photo_version

Description

Purpose

Schema

create table photo_version (
  identifier            integer not null primary key,
  key                   integer not null,
  photo                 integer not null references photo(identifier),
  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,
  comment               text,
  original_image_name   varchar(500),
  colorspace            integer not null,
  orientation           integer not null references orientations(identifier)
);

History

Used first

Version 2.7

Used last

Still in use

Schema change history

= Version 2.7 =

create table photo_version (
  identifier            integer not null primary key,
  key                   integer not null,
  photo                 integer not null references photo(identifier),
  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,
  comment               text
);

= Version 2.13 =

alter table photo_version add column original_image_name varchar(500);

= Version 2.26 =

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;
Data change history

= Version 2.7 =

-- populate version control table
insert into photo_version
  select (nextval('photo_version_id_sequence')), 1, identifier, 't', small_image_path, medium_image_path, large_image_path, now(), '' from photo;

= Version 2.13 =

update photo_version set original_image_name = 'file';
podoc/photo_version_sql_table.1176901793.txt.gz · Last modified: 2007/04/18 13:09 by Luud