location

CREATE TABLE location ( -- location is the place the photo was taken
  identifier            integer NOT NULL PRIMARY KEY,
  place                 varchar(300),
  state                 integer REFERENCES state(identifier),
  country               integer REFERENCES country(identifier),
  last_modified_date 	timestamp,
  users                 integer REFERENCES users(identifier),
  city                  varchar(300),
  latitude              varchar(10),
  longitude             varchar(10),
  private               BOOLEAN NOT NULL
);

• country references country(identifier)
• state references state(identifier)
• users references users(identifier)

• photo(location) references identifier

• location_id_sequence

None.

• number_of_location_references

• view_location

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE location ( -- location is the place the photo was taken
  identifier            integer NOT NULL PRIMARY KEY,
  place                 varchar(300),
  state                 integer REFERENCES state(identifier),
  country               integer REFERENCES country(identifier),
  last_modified_date 	timestamp,
  last_modifying_users  integer REFERENCES users(identifier),
  city                  varchar(300),
  latitude              varchar(10),
  longitude             varchar(10)
);

= Version 2.33 =

ALTER TABLE location RENAME last_modifying_users TO users;
 
ALTER TABLE location ADD private BOOLEAN;
UPDATE location SET private='f';
ALTER TABLE location ALTER private SET NOT NULL;

= Version 2.31 =

-- Ensure referential integrity with the locations.
INSERT INTO location (identifier, place) VALUES (0, 'Unknown');