User Tools

Site Tools


podoc:country_sql_table

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
podoc:country_sql_table [2007/04/19 08:46]
Luud
podoc:country_sql_table [2007/04/20 13:40] (current)
Luud
Line 15: Line 15:
 === Schema === === Schema ===
  
-  create table country ( +<code sql> 
-    identifier            integer not null primary key, +create table country ( 
-    code                  varchar(5), +  identifier            integer not null primary key, 
-    value                 varchar(40) +  code                  varchar(5), 
-  );+  value                 varchar(40) 
 +); 
 +</code> 
 + 
 +=== References tables === 
 + 
 +None. 
 + 
 +=== Is referenced by tables === 
 + 
 +  * [[contact_info sql table|contact_info]](country) references identifier 
 +  * [[location sql table|location]](country) references identifier
  
 === Related sequences === === Related sequences ===
Line 51: Line 62:
 = Version 2.5 = = Version 2.5 =
  
-  create table country ( +<code sql> 
-    identifier            integer not null primary key, +create table country ( 
-    code                  varchar(5), +  identifier            integer not null primary key, 
-    value                 varchar(40) +  code                  varchar(5), 
-  );+  value                 varchar(40) 
 +); 
 +</code>
  
 == Data change history == == Data change history ==
Line 61: Line 74:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 insert into country values (nextval('country_id_sequence'), 'ad', 'Andorra'); insert into country values (nextval('country_id_sequence'), 'ad', 'Andorra');
 insert into country values (nextval('country_id_sequence'), 'ae', 'United Arab Emirates'); insert into country values (nextval('country_id_sequence'), 'ae', 'United Arab Emirates');
podoc/country_sql_table.1176972386.txt.gz · Last modified: 2007/04/19 08:46 by Luud