Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.sql @ 7743:a67bd7744827
Schema correction following yesterday's brain failure.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 07 Feb 2014 10:54:03 +0100 |
| parents | 69c8d33a05e8 |
| children | b8c6cb36607e |
comparison
equal
deleted
inserted
replaced
| 7742:869f54874c3c | 7743:a67bd7744827 |
|---|---|
| 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 model_uuid CHAR(37), | 15 model_uuid CHAR(36) UNIQUE, |
| 16 official_number int8, | 16 official_number int8, |
| 17 name VARCHAR(256) NOT NULL UNIQUE, | 17 name VARCHAR(256) NOT NULL UNIQUE, |
| 18 km_up BOOLEAN NOT NULL DEFAULT true, | 18 km_up BOOLEAN NOT NULL DEFAULT true, |
| 19 wst_unit_id int NOT NULL REFERENCES units(id) | 19 wst_unit_id int NOT NULL REFERENCES units(id) |
| 20 ); | 20 ); |