Mercurial > gemma
diff schema/gemma.sql @ 1547:d4b7a6d054cd
Add table to store import configuration.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Mon, 10 Dec 2018 15:55:10 +0100 |
parents | 6ad1f431bc85 |
children | 056a86b24be2 |
line wrap: on
line diff
--- a/schema/gemma.sql Mon Dec 10 15:31:27 2018 +0100 +++ b/schema/gemma.sql Mon Dec 10 15:55:10 2018 +0100 @@ -541,6 +541,17 @@ waterway.sounding_results GROUP BY bottleneck_id) sr ON sr.bottleneck_id = bn.bottleneck_id ORDER BY objnam + + CREATE TABLE import_configuration ( + id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, + username varchar NOT NULL + REFERENCES internal.user_profiles(username) + ON DELETE CASCADE + ON UPDATE CASCADE, + kind varchar NOT NULL, + cron varchar, + url varchar + ) ; -- Configure primary keys for geoserver views