Photo Organizer

view_random_photo

CREATE VIEW view_random_photo AS
  SELECT photo_version.small_image_path, photo_version.medium_image_path, photo_version.large_image_path
    FROM photo, photo_version
   WHERE photo.identifier=photo_version.photo
     AND photo.identifier=(SELECT CAST(random()*count_photos() AS INTEGER));

• photo
• photo_version

Version 2.5

Still in use

= Version 2.5 =

CREATE VIEW view_random_photo AS
  SELECT small_image_path, medium_image_path, large_image_path
    FROM photo
   WHERE photo.identifier=(SELECT CAST(random()*count_photos() AS INTEGER));

= Version 2.7 =

DROP VIEW view_random_photo;
 
CREATE VIEW view_random_photo AS
  SELECT photo_version.small_image_path, photo_version.medium_image_path, photo_version.large_image_path
    FROM photo, photo_version
   WHERE photo.identifier=photo_version.photo
     AND photo.identifier=(SELECT CAST(random()*count_photos() AS INTEGER));