Mercurial > gemma

changeset 4031:4bf1c8d91bac

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Import queue: Added a column to the tracking table to delete entries on stage done.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 23 Jul 2019 13:16:41 +0200
parents 040a5dc95eb9
children 2fcfae3daa7d
files schema/gemma.sql schema/updates/1007/01.delete-import-tracking.sql schema/version.sql
diffstat 3 files changed, 3 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Tue Jul 23 10:36:56 2019 +0200
+++ b/schema/gemma.sql	Tue Jul 23 13:16:41 2019 +0200
@@ -863,6 +863,7 @@
     CREATE TABLE track_imports (
         import_id int      NOT NULL REFERENCES imports(id)
             ON DELETE CASCADE,
+        deletion  bool     NOT NULL DEFAULT false,
         relation  regclass NOT NULL,
         key       int      NOT NULL,
         UNIQUE (relation, key)
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1007/01.delete-import-tracking.sql	Tue Jul 23 13:16:41 2019 +0200
@@ -0,0 +1,1 @@
+ALTER TABLE import.track_imports ADD COLUMN deletion bool NOT NULL DEFAULT false;
--- a/schema/version.sql	Tue Jul 23 10:36:56 2019 +0200
+++ b/schema/version.sql	Tue Jul 23 13:16:41 2019 +0200
@@ -1,1 +1,1 @@
-INSERT INTO gemma_schema_version(version) VALUES (1006);
+INSERT INTO gemma_schema_version(version) VALUES (1007);