Mercurial > dive4elements > river
changeset 7739:44a9233c62eb
SCHEMA CHANGE: Add UUIDs to rivers.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 06 Feb 2014 13:22:10 +0100 (2014-02-06) |
parents | 1709c429818a |
children | 72d0cec59c78 69c8d33a05e8 6ff574778491 |
files | backend/doc/schema/oracle.sql backend/doc/schema/postgresql.sql |
diffstat | 2 files changed, 2 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql Tue Feb 04 11:08:57 2014 +0100 +++ b/backend/doc/schema/oracle.sql Thu Feb 06 13:22:10 2014 +0100 @@ -262,6 +262,7 @@ CREATE TABLE rivers ( id NUMBER(38,0) NOT NULL, + uuid CHAR(37 CHAR), official_number NUMBER(38,0), km_up NUMBER(38,0) DEFAULT 0 NOT NULL, name VARCHAR2(255) NOT NULL UNIQUE,
--- 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,