===== Database View Description of "view_photo" =====

=== Name ===

view_photo

=== Description ===

=== Purpose ===

=== Schema ===

<code sql>
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;
</code>

=== Related tables ===

  * [[access_type sql table|access_type]]
  * [[photo sql table|photo]]
  * [[photo_dupe sql table|photo_dupe]]
  * [[photo_version sql table|photo_version]]

=== History ===

== Used first ==

Version 2.5

== Used last ==

Still in use

== Change history ==

= Version 2.5 =

<code sql>
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;
</code>

= Version 2.7 ==

<code sql>
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;
</code>