Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.sql @ 7739:44a9233c62eb
SCHEMA CHANGE: Add UUIDs to rivers.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 06 Feb 2014 13:22:10 +0100 |
parents | dddf633fec05 |
children | 69c8d33a05e8 |
comparison
equal
deleted
inserted
replaced
7738:1709c429818a | 7739:44a9233c62eb |
---|---|
10 -- Gewaesser | 10 -- Gewaesser |
11 CREATE SEQUENCE RIVERS_ID_SEQ; | 11 CREATE SEQUENCE RIVERS_ID_SEQ; |
12 | 12 |
13 CREATE TABLE rivers ( | 13 CREATE TABLE rivers ( |
14 id int PRIMARY KEY NOT NULL, | 14 id int PRIMARY KEY NOT NULL, |
15 uuid CHAR(37), | |
15 official_number int8, | 16 official_number int8, |
16 name VARCHAR(256) NOT NULL UNIQUE, | 17 name VARCHAR(256) NOT NULL UNIQUE, |
17 km_up BOOLEAN NOT NULL DEFAULT true, | 18 km_up BOOLEAN NOT NULL DEFAULT true, |
18 wst_unit_id int NOT NULL REFERENCES units(id) | 19 wst_unit_id int NOT NULL REFERENCES units(id) |
19 ); | 20 ); |