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