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/18 14:41] 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 56: 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 72: Line 82:
 = Version 2.33 = = Version 2.33 =
  
-<code>+<code sql>
 alter table location rename last_modifying_users to users; alter table location rename last_modifying_users to users;
  
Line 84: 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.1176907314.txt.gz · Last modified: 2007/04/18 14:41 by Luud