Mercurial > dive4elements > river

diff flys-backend/doc/schema/oracle-spatial.sql @ 5121:e4cc9aebfcf1 dami
sensible constraints for dem-table
author: Tom Gottfried <tom@intevation.de>
date: Wed, 27 Feb 2013 19:44:08 +0100
parents: c4b28de753de
children: 5ba502e78e05
--- a/flys-backend/doc/schema/oracle-spatial.sql	Wed Feb 27 17:35:17 2013 +0100
+++ b/flys-backend/doc/schema/oracle-spatial.sql	Wed Feb 27 19:44:08 2013 +0100
@@ -141,7 +141,7 @@
     border_break    NUMBER(1) DEFAULT 0 NOT NULL,
     resolution      VARCHAR(16),
     description     VARCHAR(256),
-    path            VARCHAR(256)
+    path            VARCHAR(256) NOT NULL
 );
 CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW
     BEGIN
author	Tom Gottfried <tom@intevation.de>
date	Wed, 27 Feb 2013 19:44:08 +0100
parents	c4b28de753de
children	5ba502e78e05