podoc:location_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
podoc:location_sql_table [2007/04/19 09:16] – Luud | podoc:location_sql_table [2007/04/20 13:38] (current) – Luud | ||
---|---|---|---|
Line 11: | Line 11: | ||
=== Schema === | === Schema === | ||
- | < | + | < |
create table location ( -- location is the place the photo was taken | create table location ( -- location is the place the photo was taken | ||
identifier | identifier | ||
Line 26: | Line 26: | ||
</ | </ | ||
- | === References | + | === 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 = | ||
- | < | + | < |
create table location ( -- location is the place the photo was taken | create table location ( -- location is the place the photo was taken | ||
identifier | identifier | ||
Line 82: | Line 82: | ||
= Version 2.33 = | = Version 2.33 = | ||
- | < | + | < |
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 = | ||
- | < | + | < |
-- Ensure referential integrity with the locations. | -- Ensure referential integrity with the locations. | ||
insert into location (identifier, | insert into location (identifier, | ||
</ | </ | ||
podoc/location_sql_table.1176974177.txt.gz · Last modified: 2007/04/19 09:16 by Luud