Mercurial > lada > lada-server
changeset 1007:6a313cb77fda schema-update
Renamed erzeuger to mst_id.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Mon, 04 Jul 2016 08:53:39 +0200 |
| parents | 599bd9462e62 |
| children | 17e9d1b2d471 |
| files | db_schema/lada_schema.sql |
| diffstat | 1 files changed, 3 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Mon Jul 04 08:52:13 2016 +0200 +++ b/db_schema/lada_schema.sql Mon Jul 04 08:53:39 2016 +0200 @@ -193,7 +193,7 @@ CREATE TABLE kommentar_p ( id serial PRIMARY KEY, - erzeuger character varying(5) NOT NULL, + mst_id character varying(5) NOT NULL, datum timestamp without time zone DEFAULT now(), text character varying(1024), probe_id integer NOT NULL REFERENCES probe ON DELETE CASCADE @@ -264,7 +264,7 @@ CREATE TABLE kommentar_m ( id serial PRIMARY KEY, - erzeuger character varying(5) NOT NULL, + mst_id character varying(5) NOT NULL, datum timestamp without time zone DEFAULT now(), text character varying(1024), messungs_id integer NOT NULL REFERENCES messung ON DELETE CASCADE @@ -299,7 +299,7 @@ CREATE TABLE status_protokoll ( id serial PRIMARY KEY, - erzeuger character varying(5) NOT NULL, + mst_id character varying(5) NOT NULL, datum timestamp without time zone DEFAULT now(), text character varying(1024), messungs_id integer NOT NULL REFERENCES messung ON DELETE CASCADE,