Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1013:48c07fc5d2d1 schema-update
Fixed column names in constraints.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Mon, 04 Jul 2016 11:46:20 +0200 |
| parents | c739d08040d6 |
| children | 6b204c617c1f |
comparison
equal
deleted
inserted
replaced
| 1012:c739d08040d6 | 1013:48c07fc5d2d1 |
|---|---|
| 476 DEFAULT nextval('messprogramm_kategorie_id_seq'::regclass), | 476 DEFAULT nextval('messprogramm_kategorie_id_seq'::regclass), |
| 477 netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber, | 477 netzbetreiber_id character varying(2) NOT NULL REFERENCES netz_betreiber, |
| 478 code character varying(3) NOT NULL, | 478 code character varying(3) NOT NULL, |
| 479 bezeichnung character varying(120) NOT NULL, | 479 bezeichnung character varying(120) NOT NULL, |
| 480 letzte_aenderung timestamp without time zone, | 480 letzte_aenderung timestamp without time zone, |
| 481 UNIQUE(mpl_id, netzbetreiber_id) | 481 UNIQUE(code, netzbetreiber_id) |
| 482 ); | 482 ); |
| 483 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(); |
| 484 | 484 |
| 485 ALTER SEQUENCE messprogramm_kategorie_id_seq | 485 ALTER SEQUENCE messprogramm_kategorie_id_seq |
| 486 OWNED BY messprogramm_kategorie.id; | 486 OWNED BY messprogramm_kategorie.id; |
| 824 ADD CONSTRAINT auth_labor_fkey FOREIGN KEY (labor_mst_id) REFERENCES mess_stelle(id); | 824 ADD CONSTRAINT auth_labor_fkey FOREIGN KEY (labor_mst_id) REFERENCES mess_stelle(id); |
| 825 | 825 |
| 826 | 826 |
| 827 | 827 |
| 828 ALTER TABLE ONLY auth_lst_umw | 828 ALTER TABLE ONLY auth_lst_umw |
| 829 ADD CONSTRAINT auth_lst_umw_lst_fkey FOREIGN KEY (lst_id) REFERENCES mess_stelle(id); | 829 ADD CONSTRAINT auth_lst_umw_lst_fkey FOREIGN KEY (mst_id) REFERENCES mess_stelle(id); |
| 830 | 830 |
| 831 | 831 |
| 832 | 832 |
| 833 ALTER TABLE ONLY auth_lst_umw | 833 ALTER TABLE ONLY auth_lst_umw |
| 834 ADD CONSTRAINT auth_lst_umw_umw_fkey FOREIGN KEY (umw_id) REFERENCES umwelt(id); | 834 ADD CONSTRAINT auth_lst_umw_umw_fkey FOREIGN KEY (umw_id) REFERENCES umwelt(id); |