Mercurial > dive4elements > river

diff backend/doc/schema/oracle.sql @ 7739:44a9233c62eb
SCHEMA CHANGE: Add UUIDs to rivers.
author: Tom Gottfried <tom@intevation.de>
date: Thu, 06 Feb 2014 13:22:10 +0100
parents: 28748bb1b676
children: 69c8d33a05e8
--- 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,
author	Tom Gottfried <tom@intevation.de>
date	Thu, 06 Feb 2014 13:22:10 +0100
parents	28748bb1b676
children	69c8d33a05e8