Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 1010:c1e00e1fe5c8 | 1011:302f800ba588 |
|---|---|
| 132 netzbetreiber character varying(50), | 132 netzbetreiber character varying(50), |
| 133 idf_netzbetreiber character varying(1), | 133 idf_netzbetreiber character varying(1), |
| 134 is_bmn boolean DEFAULT false, | 134 is_bmn boolean DEFAULT false, |
| 135 mailverteiler character varying(512), | 135 mailverteiler character varying(512), |
| 136 aktiv boolean DEFAULT false, | 136 aktiv boolean DEFAULT false, |
| 137 zust_mst_id character varying(5) | |
| 138 ); | 137 ); |
| 139 | 138 |
| 140 | 139 |
| 141 CREATE TABLE mess_stelle ( | 140 CREATE TABLE mess_stelle ( |
| 142 id character varying(5) PRIMARY KEY, | 141 id character varying(5) PRIMARY KEY, |
| 185 NO MAXVALUE | 184 NO MAXVALUE |
| 186 CACHE 1; | 185 CACHE 1; |
| 187 | 186 |
| 188 CREATE TABLE auth_lst_umw ( | 187 CREATE TABLE auth_lst_umw ( |
| 189 id integer PRIMARY KEY DEFAULT nextval('auth_lst_umw_id_seq'::regclass), | 188 id integer PRIMARY KEY DEFAULT nextval('auth_lst_umw_id_seq'::regclass), |
| 190 lst_id character varying(5), | 189 mst_id character varying(5), |
| 191 umw_id character varying(3) | 190 umw_id character varying(3) |
| 192 ); | 191 ); |
| 193 | 192 |
| 194 ALTER SEQUENCE auth_lst_umw_id_seq OWNED BY auth_lst_umw.id; | 193 ALTER SEQUENCE auth_lst_umw_id_seq OWNED BY auth_lst_umw.id; |
| 195 | 194 |
| 219 | 218 |
| 220 CREATE TABLE datensatz_erzeuger ( | 219 CREATE TABLE datensatz_erzeuger ( |
| 221 id integer PRIMARY KEY | 220 id integer PRIMARY KEY |
| 222 DEFAULT nextval('datensatz_erzeuger_id_seq'::regclass), | 221 DEFAULT nextval('datensatz_erzeuger_id_seq'::regclass), |
| 223 netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber, | 222 netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber, |
| 224 da_erzeuger_id character varying(2) NOT NULL, | 223 datensatz_erzeuger_id character varying(2) NOT NULL, |
| 225 mst_id character varying(5) NOT NULL REFERENCES mess_stelle, | 224 mst_id character varying(5) NOT NULL REFERENCES mess_stelle, |
| 226 bezeichnung character varying(120) NOT NULL, | 225 bezeichnung character varying(120) NOT NULL, |
| 227 letzte_aenderung timestamp without time zone, | 226 letzte_aenderung timestamp without time zone, |
| 228 UNIQUE(da_erzeuger_id, netzbetreiber_id) | 227 UNIQUE(da_erzeuger_id, netzbetreiber_id) |
| 229 ); | 228 ); |
| 474 | 473 |
| 475 CREATE TABLE messprogramm_kategorie ( | 474 CREATE TABLE messprogramm_kategorie ( |
| 476 id integer PRIMARY KEY | 475 id integer PRIMARY KEY |
| 477 DEFAULT nextval('messprogramm_kategorie_id_seq'::regclass), | 476 DEFAULT nextval('messprogramm_kategorie_id_seq'::regclass), |
| 478 netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber, | 477 netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber, |
| 479 mpl_id character varying(3) NOT NULL, | 478 code character varying(3) NOT NULL, |
| 480 bezeichnung character varying(120) NOT NULL, | 479 bezeichnung character varying(120) NOT NULL, |
| 481 letzte_aenderung timestamp without time zone, | 480 letzte_aenderung timestamp without time zone, |
| 482 UNIQUE(mpl_id, netzbetreiber_id) | 481 UNIQUE(mpl_id, netzbetreiber_id) |
| 483 ); | 482 ); |
| 484 CREATE TRIGGER letzte_aenderung_messprogramm_kategorie BEFORE UPDATE ON messprogramm_kategorie FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); | 483 CREATE TRIGGER letzte_aenderung_messprogramm_kategorie BEFORE UPDATE ON messprogramm_kategorie FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); |