podoc:view_camera_type_sql_view
Database View Description of "view_camera_type"
Name
view_camera_type
Description
Purpose
Schema
CREATE VIEW view_camera_type AS SELECT camera_type.identifier, manufacturer.name, model, variation, manufacturer.url, raw_icc_profile FROM camera_type, manufacturer WHERE camera_type.manufacturer = manufacturer.identifier ORDER BY manufacturer.name, model, variation;
Related tables
History
Used first
Version 2.5
Used last
Still in use
Change history
= Version 2.5 =
CREATE VIEW view_camera_type AS SELECT camera_type.identifier, manufacturer.name, model, variation, manufacturer.url FROM camera_type, manufacturer WHERE camera_type.manufacturer = manufacturer.identifier ORDER BY manufacturer.name, model, variation;
= Version 2.29 =
DROP VIEW view_camera_type; CREATE VIEW view_camera_type AS SELECT camera_type.identifier, manufacturer.name, model, variation, manufacturer.url, raw_icc_profile FROM camera_type, manufacturer WHERE camera_type.manufacturer = manufacturer.identifier ORDER BY manufacturer.name, model, variation;
podoc/view_camera_type_sql_view.txt · Last modified: 2007/04/20 15:39 by Luud