Mercurial > dive4elements > river
changeset 7743:a67bd7744827
Schema correction following yesterday's brain failure.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 07 Feb 2014 10:54:03 +0100 |
| parents | 869f54874c3c |
| children | 8abc86160959 |
| 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 15:05:29 2014 +0100 +++ b/backend/doc/schema/oracle.sql Fri Feb 07 10:54:03 2014 +0100 @@ -262,7 +262,7 @@ CREATE TABLE rivers ( id NUMBER(38,0) NOT NULL, - model_uuid CHAR(37 CHAR), + model_uuid CHAR(36 CHAR) UNIQUE, 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 15:05:29 2014 +0100 +++ b/backend/doc/schema/postgresql.sql Fri Feb 07 10:54:03 2014 +0100 @@ -12,7 +12,7 @@ CREATE TABLE rivers ( id int PRIMARY KEY NOT NULL, - model_uuid CHAR(37), + model_uuid CHAR(36) UNIQUE, official_number int8, name VARCHAR(256) NOT NULL UNIQUE, km_up BOOLEAN NOT NULL DEFAULT true,