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

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));