Mercurial > dive4elements > river
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 |
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,