# HG changeset patch # User Raimund Renkert # Date 1467615219 -7200 # Node ID 6a313cb77fdae29095f1df5ddf1d10498e966a81 # Parent 599bd9462e623bfa23709f25d31527cde60423a3 Renamed erzeuger to mst_id. diff -r 599bd9462e62 -r 6a313cb77fda db_schema/lada_schema.sql --- 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,