diff db_schema/stammdaten_schema.sql @ 1011:302f800ba588 schema-update

Renamed/Removed some columns.
author Raimund Renkert <raimund.renkert@intevation.de>
date Mon, 04 Jul 2016 11:25:40 +0200
parents 5efb32a41b24
children c739d08040d6
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql	Mon Jul 04 11:24:59 2016 +0200
+++ b/db_schema/stammdaten_schema.sql	Mon Jul 04 11:25:40 2016 +0200
@@ -134,7 +134,6 @@
     is_bmn boolean DEFAULT false,
     mailverteiler character varying(512),
     aktiv boolean DEFAULT false,
-    zust_mst_id character varying(5)
 );
 
 
@@ -187,7 +186,7 @@
 
 CREATE TABLE auth_lst_umw (
     id integer PRIMARY KEY DEFAULT nextval('auth_lst_umw_id_seq'::regclass),
-    lst_id character varying(5),
+    mst_id character varying(5),
     umw_id character varying(3)
 );
 
@@ -221,7 +220,7 @@
     id integer PRIMARY KEY
         DEFAULT nextval('datensatz_erzeuger_id_seq'::regclass),
     netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber,
-    da_erzeuger_id character varying(2) NOT NULL,
+    datensatz_erzeuger_id character varying(2) NOT NULL,
     mst_id character varying(5) NOT NULL REFERENCES mess_stelle,
     bezeichnung character varying(120) NOT NULL,
     letzte_aenderung timestamp without time zone,
@@ -476,7 +475,7 @@
     id integer PRIMARY KEY
         DEFAULT nextval('messprogramm_kategorie_id_seq'::regclass),
     netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber,
-    mpl_id character varying(3) NOT NULL,
+    code character varying(3) NOT NULL,
     bezeichnung character varying(120) NOT NULL,
     letzte_aenderung timestamp without time zone,
     UNIQUE(mpl_id, netzbetreiber_id)
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)