view_photo
CREATE VIEW view_photo AS SELECT photo.identifier, caption, users, date_of_exposure, photo_dupe.date_of_creation, storage_location, storage_index, photo_version.small_image_path, photo_version.medium_image_path, photo_version.large_image_path, folder, (access_type.value) AS access_rights FROM photo, photo_dupe, photo_version, access_type WHERE photo.identifier = photo_version.photo AND photo.identifier = photo_dupe.photo AND photo.access_rights = access_type.identifier ORDER BY photo.identifier;
Version 2.5
Still in use
= Version 2.5 =
CREATE VIEW view_photo AS SELECT photo.identifier, caption, users, date_of_exposure, date_of_creation, storage_location, storage_index, small_image_path, medium_image_path, large_image_path, folder, (access_type.value) AS access_rights FROM photo, photo_dupe, access_type WHERE photo.identifier = photo_dupe.photo AND photo.access_rights = access_type.identifier ORDER BY photo.identifier;
= Version 2.7 ==
DROP VIEW view_photo; CREATE VIEW view_photo AS SELECT photo.identifier, caption, users, date_of_exposure, photo_dupe.date_of_creation, storage_location, storage_index, photo_version.small_image_path, photo_version.medium_image_path, photo_version.large_image_path, folder, (access_type.value) AS access_rights FROM photo, photo_dupe, photo_version, access_type WHERE photo.identifier = photo_version.photo AND photo.identifier = photo_dupe.photo AND photo.access_rights = access_type.identifier ORDER BY photo.identifier;