Mercurial > gemma

diff schema/gemma.sql @ 1168:930fdd8b474f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Track successfull imports in a separate table to be able to remove them later.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 14 Nov 2018 12:23:10 +0100
parents dd4071019676
children c3955e3db074
line wrap: on
line diff
--- a/schema/gemma.sql	Wed Nov 14 12:12:00 2018 +0100
+++ b/schema/gemma.sql	Wed Nov 14 12:23:10 2018 +0100
@@ -539,4 +539,11 @@
     msg TEXT NOT NULL
 );
 
+CREATE TABLE waterway.track_imports (
+    import_id int      NOT NULL REFERENCES waterway.imports(id),
+    relation  regclass NOT NULL,
+    key       int      NOT NULL,
+    UNIQUE (relation, key)
+);
+
 COMMIT;