Mercurial > gemma

comparison wamos.sql @ 99:3ad1c35b258f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add todo regarding PostGIS data type.
author Tom Gottfried <tom@intevation.de>
date Wed, 13 Jun 2018 22:40:51 +0200
parents d036e1bd5f00
children 3780a1afdc98
comparison
equal deleted inserted replaced
98:81a2b26bf16b 99:3ad1c35b258f
58 -- factor when there are many FKs pointing here. 58 -- factor when there are many FKs pointing here.
59 ); 59 );
60 60
61 CREATE TABLE wamos.responsibility_areas ( 61 CREATE TABLE wamos.responsibility_areas (
62 country char(2) PRIMARY KEY REFERENCES countries, 62 country char(2) PRIMARY KEY REFERENCES countries,
63 area geometry(POLYGON, 4326) 63 area geometry(POLYGON, 4326) --XXX: Should be geography (elsewhere too)
64 ); 64 );
65 65
66 CREATE TABLE wamos.language_codes ( 66 CREATE TABLE wamos.language_codes (
67 language_code varchar PRIMARY KEY 67 language_code varchar PRIMARY KEY
68 ); 68 );