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