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) );
References other tables
- photo references photo(identifier)
- orientation references orientations(identifier)
Is referenced by other tables
Related sequences
Related indexes
Related functions
Related views
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.1176973877.txt.gz · Last modified: 2007/04/19 09:11 by Luud