Mercurial > lada > lada-server
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)