User Tools

Site Tools


podoc:view_location_sql_view

Database View Description of "view_location"

Name

view_location

Description

Purpose

Schema

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;

History

Used first

Version 2.5

Used last

Still in use

Change history

= 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;
podoc/view_location_sql_view.txt · Last modified: 2007/04/20 16:16 by Luud