view_location

CREATE VIEW view_location AS
  SELECT location.identifier, location.place, location.city,
         (SELECT value FROM state WHERE state.identifier=location.state) AS state,
         (SELECT value FROM country WHERE country.identifier=location.country) AS country,
         users, last_modified_date,
         latitude, longitude, private
    FROM location;

• location

Version 2.5

Still in use

= Version 2.5 =

CREATE VIEW view_location AS
  SELECT location.identifier, location.place, location.city,
         (SELECT value FROM state WHERE state.identifier=location.state) AS state,
         (SELECT value FROM country WHERE country.identifier=location.country) AS country,
         last_modifying_users, last_modified_date,
         latitude, longitude
    FROM location;

= Version 2.33 =

DROP VIEW view_location;
 
CREATE VIEW view_location AS
  SELECT location.identifier, location.place, location.city,
         (SELECT value FROM state WHERE state.identifier=location.state) AS state,
         (SELECT value FROM country WHERE country.identifier=location.country) AS country,
         users, last_modified_date,
         latitude, longitude, private
    FROM location;