Mercurial > gemma

comparison wamos.sql @ 38:529319bc3c5b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Mark gauges table as placeholder.
author Tom Gottfried <tom@intevation.de>
date Fri, 04 May 2018 19:06:29 +0200
parents 6f273a649f08
children 830287983657
comparison
equal deleted inserted replaced
37:6f273a649f08 38:529319bc3c5b
39 rwdr double precision NOT NULL, 39 rwdr double precision NOT NULL,
40 EXCLUDE USING GIST (stretch WITH &&) 40 EXCLUDE USING GIST (stretch WITH &&)
41 ); 41 );
42 42
43 CREATE TABLE gauges ( 43 CREATE TABLE gauges (
44 location isrs PRIMARY KEY 44 location isrs PRIMARY KEY,
45 dummy_attrib varchar
46 -- TODO: add real gauge attributes (DRC 2.1.4)
45 ); 47 );
46 48
47 CREATE TABLE countries ( 49 CREATE TABLE countries (
48 country_code char(2) PRIMARY KEY -- ISO 3166 country code 50 country_code char(2) PRIMARY KEY -- ISO 3166 country code
49 -- A smallint PK would require even less disk space i.e. on the FK side. 51 -- A smallint PK would require even less disk space i.e. on the FK side.