User Tools

Site Tools


podoc:location_sql_table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
podoc:location_sql_table [2007/04/17 12:56] Luudpodoc:location_sql_table [2007/04/20 13:38] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-<code>+<code sql>
 create table location ( -- location is the place the photo was taken create table location ( -- location is the place the photo was taken
   identifier            integer not null primary key,   identifier            integer not null primary key,
Line 18: Line 18:
   country               integer references country(identifier),   country               integer references country(identifier),
   last_modified_date timestamp,   last_modified_date timestamp,
-  last_modifying_users  integer references users(identifier),+  users                 integer references users(identifier),
   city                  varchar(300),   city                  varchar(300),
   latitude              varchar(10),   latitude              varchar(10),
-  longitude             varchar(10)+  longitude             varchar(10)
 +  private               boolean not null
 ); );
-<code>+</code> 
 + 
 +=== References tables === 
 + 
 +  * country references [[country sql table|country]](identifier) 
 +  * state references [[state sql table|state]](identifier) 
 +  * users references [[users sql table|users]](identifier) 
 + 
 +=== Is referenced by tables === 
 + 
 +  * [[photo sql table|photo]](location) references identifier
  
 === Related sequences === === Related sequences ===
Line 30: Line 41:
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +  * [[number_of_location_references sql function|number_of_location_references]]
  
 === Related views === === Related views ===
 +
 +  * [[view_location sql view|view_location]]
  
 === History === === History ===
Line 49: Line 66:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 create table location ( -- location is the place the photo was taken create table location ( -- location is the place the photo was taken
   identifier            integer not null primary key,   identifier            integer not null primary key,
Line 61: Line 78:
   longitude             varchar(10)   longitude             varchar(10)
 ); );
 +</code>
 +
 += Version 2.33 =
 +
 +<code sql>
 +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;
 </code> </code>
  
Line 67: Line 94:
 = Version 2.31 = = Version 2.31 =
  
-<code>+<code sql>
 -- Ensure referential integrity with the locations. -- Ensure referential integrity with the locations.
 insert into location (identifier, place) values (0, 'Unknown'); insert into location (identifier, place) values (0, 'Unknown');
 </code> </code>
  
podoc/location_sql_table.1176814570.txt.gz · Last modified: 2007/04/17 12:56 by Luud