Photo Organizer

photo_version

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

• photo_version_id_sequence

• view_photo
• view_random_photo

Version 2.7

Still in use

= 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.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;