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
);

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
);

= 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;
podoc/photo_version_sql_table.1176458470.txt.gz · Last modified: 2007/04/13 10:01 by Luud