changeset 7741:69c8d33a05e8

SCHEMA CHANGE: renamed uuid-column to avoid collision with data type.
author Tom Gottfried <tom@intevation.de>
date Thu, 06 Feb 2014 15:04:29 +0100 (2014-02-06)
parents 44a9233c62eb
children 869f54874c3c
files backend/doc/schema/oracle.sql backend/doc/schema/postgresql.sql
diffstat 2 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql	Thu Feb 06 13:22:10 2014 +0100
+++ b/backend/doc/schema/oracle.sql	Thu Feb 06 15:04:29 2014 +0100
@@ -262,7 +262,7 @@
 
 CREATE TABLE rivers (
     id                  NUMBER(38,0) NOT NULL,
-    uuid                CHAR(37 CHAR),
+    model_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	Thu Feb 06 13:22:10 2014 +0100
+++ b/backend/doc/schema/postgresql.sql	Thu Feb 06 15:04:29 2014 +0100
@@ -12,7 +12,7 @@
 
 CREATE TABLE rivers (
     id              int PRIMARY KEY NOT NULL,
-    uuid            CHAR(37),
+    model_uuid      CHAR(37),
     official_number int8,
     name            VARCHAR(256)    NOT NULL UNIQUE,
     km_up           BOOLEAN         NOT NULL DEFAULT true,

http://dive4elements.wald.intevation.org