Mercurial > gemma

comparison schema/gemma.sql @ 1547:d4b7a6d054cd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
1546:b83928a8fadb 1547:d4b7a6d054cd
539 FROM waterway.bottlenecks bn LEFT JOIN ( 539 FROM waterway.bottlenecks bn LEFT JOIN (
540 SELECT bottleneck_id, max(date_info) AS current FROM 540 SELECT bottleneck_id, max(date_info) AS current FROM
541 waterway.sounding_results 541 waterway.sounding_results
542 GROUP BY bottleneck_id) sr ON sr.bottleneck_id = bn.bottleneck_id 542 GROUP BY bottleneck_id) sr ON sr.bottleneck_id = bn.bottleneck_id
543 ORDER BY objnam 543 ORDER BY objnam
544
545 CREATE TABLE import_configuration (
546 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
547 username varchar NOT NULL
548 REFERENCES internal.user_profiles(username)
549 ON DELETE CASCADE
550 ON UPDATE CASCADE,
551 kind varchar NOT NULL,
552 cron varchar,
553 url varchar
554 )
544 ; 555 ;
545 556
546 -- Configure primary keys for geoserver views 557 -- Configure primary keys for geoserver views
547 INSERT INTO waterway.gt_pk_metadata VALUES ('waterway', 558 INSERT INTO waterway.gt_pk_metadata VALUES ('waterway',
548 'distance_marks_geoserver', 559 'distance_marks_geoserver',