changeset 6502:3b93f439e954 double-precision

Schema change: add new field 'source' to wst_columns, currently only for official lines
author Tom Gottfried <tom.gottfried@intevation.de>
date Fri, 28 Jun 2013 16:58:46 +0200
parents 5910ada51a9f
children 9daf7c9cf663
files backend/doc/schema/oracle.sql backend/doc/schema/postgresql.sql
diffstat 2 files changed, 2 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql	Thu Jun 27 18:08:41 2013 +0200
+++ b/backend/doc/schema/oracle.sql	Fri Jun 28 16:58:46 2013 +0200
@@ -325,6 +325,7 @@
     id                  NUMBER(38,0) NOT NULL,
     description         VARCHAR2(255),
     name                VARCHAR2(255) NOT NULL,
+    source              VARCHAR(256),
     position            NUMBER(38,0) NOT NULL DEFAULT 0,
     time_interval_id    NUMBER(38,0),
     wst_id              NUMBER(38,0) NOT NULL,
--- a/backend/doc/schema/postgresql.sql	Thu Jun 27 18:08:41 2013 +0200
+++ b/backend/doc/schema/postgresql.sql	Fri Jun 28 16:58:46 2013 +0200
@@ -201,6 +201,7 @@
     wst_id      int NOT NULL REFERENCES wsts(id) ON DELETE CASCADE,
     name        VARCHAR(256) NOT NULL,
     description VARCHAR(256),
+    source      VARCHAR(256),
     position    int NOT NULL DEFAULT 0,
 
     time_interval_id int REFERENCES time_intervals(id),

http://dive4elements.wald.intevation.org