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 13:37] 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 25: Line 25:
 ); );
 </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 31: 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 ===
Line 52: 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 66: Line 80:
 </code> </code>
  
-== Data change history ==+Version 2.33 =
  
-= Version 2.31 = +<code sql>
- +
-<code> +
--- Ensure referential integrity with the locations. +
-insert into location (identifier, place) values (0, 'Unknown'); +
-</code> +
- +
-= Version 2.32 = +
- +
-<code>+
 alter table location rename last_modifying_users to users; alter table location rename last_modifying_users to users;
  
Line 83: Line 88:
 update location set private='f'; update location set private='f';
 alter table location alter private set not null; alter table location alter private set not null;
 +</code>
 +
 +== Data change history ==
 +
 += Version 2.31 =
 +
 +<code sql>
 +-- Ensure referential integrity with the locations.
 +insert into location (identifier, place) values (0, 'Unknown');
 </code> </code>
  
podoc/location_sql_table.1176817035.txt.gz · Last modified: 2007/04/17 13:37 by Luud