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
podoc:location_sql_table [2007/04/19 09:16] 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 26: Line 26:
 </code> </code>
  
-=== References other tables ===+=== References tables ===
  
   * country references [[country sql table|country]](identifier)   * country references [[country sql table|country]](identifier)
Line 32: Line 32:
   * users references [[users sql table|users]](identifier)   * users references [[users sql table|users]](identifier)
  
-=== Is referenced by other tables ===+=== Is referenced by tables ===
  
   * [[photo sql table|photo]](location) references identifier   * [[photo sql table|photo]](location) references identifier
Line 66: 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 82: 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 94: 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.1176974177.txt.gz · Last modified: 2007/04/19 09:16 by Luud