Photo Organizer

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;

• camera_type
• manufacturer

Version 2.5

Still in use

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