podoc:view_random_photo_sql_view
Database View Description of "view_random_photo"
Name
view_random_photo
Description
Purpose
Schema
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));
Related tables
History
Used first
Version 2.5
Used last
Still in use
Change history
= 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));
podoc/view_random_photo_sql_view.txt · Last modified: 2007/04/23 14:19 by Luud