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