Mercurial > dive4elements > river
diff 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 |
line wrap: on
line diff
--- a/backend/doc/schema/postgresql.sql Tue Feb 04 11:08:57 2014 +0100 +++ b/backend/doc/schema/postgresql.sql Thu Feb 06 13:22:10 2014 +0100 @@ -12,6 +12,7 @@ CREATE TABLE rivers ( id int PRIMARY KEY NOT NULL, + uuid CHAR(37), official_number int8, name VARCHAR(256) NOT NULL UNIQUE, km_up BOOLEAN NOT NULL DEFAULT true,