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,

http://dive4elements.wald.intevation.org