Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1046:434b46ead134 schema-update
Added unique constraint for probe.id_alt
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Fri, 09 Sep 2016 15:33:04 +0200 |
| parents | d77178ccbcbc |
| children |
comparison
equal
deleted
inserted
replaced
| 1043:1b9516c60a5a | 1046:434b46ead134 |
|---|---|
| 178 mpl_id integer REFERENCES stammdaten.messprogramm_kategorie, | 178 mpl_id integer REFERENCES stammdaten.messprogramm_kategorie, |
| 179 mpr_id integer REFERENCES messprogramm, | 179 mpr_id integer REFERENCES messprogramm, |
| 180 solldatum_beginn timestamp without time zone, | 180 solldatum_beginn timestamp without time zone, |
| 181 solldatum_ende timestamp without time zone, | 181 solldatum_ende timestamp without time zone, |
| 182 tree_modified timestamp without time zone DEFAULT now(), | 182 tree_modified timestamp without time zone DEFAULT now(), |
| 183 UNIQUE (mst_id, hauptproben_nr) | 183 UNIQUE (mst_id, hauptproben_nr, id_alt) |
| 184 ); | 184 ); |
| 185 CREATE TRIGGER letzte_aenderung_probe BEFORE UPDATE ON probe FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); | 185 CREATE TRIGGER letzte_aenderung_probe BEFORE UPDATE ON probe FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); |
| 186 CREATE TRIGGER tree_modified_probe BEFORE UPDATE ON probe FOR EACH ROW EXECUTE PROCEDURE update_tree_modified_probe(); | 186 CREATE TRIGGER tree_modified_probe BEFORE UPDATE ON probe FOR EACH ROW EXECUTE PROCEDURE update_tree_modified_probe(); |
| 187 | 187 |
| 188 | 188 |