Photo Organizer

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;

• access_type
• photo
• photo_dupe
• photo_version

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;