aboutsummaryrefslogtreecommitdiffstats
path: root/sql/quantifi.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/quantifi.sql')
-rw-r--r--sql/quantifi.sql14
1 files changed, 13 insertions, 1 deletions
diff --git a/sql/quantifi.sql b/sql/quantifi.sql
index 2bce202d..9ed574bf 100644
--- a/sql/quantifi.sql
+++ b/sql/quantifi.sql
@@ -340,4 +340,16 @@ LEFT JOIN cdxtrancheut ct
END;
-$$ LANGUAGE plpgsql; \ No newline at end of file
+$$ LANGUAGE plpgsql;
+
+
+CREATE TABLE quantifi_submission(
+ id integer NOT NULL GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
+ uploadtime timestamptz,
+ filename text,
+ errors int,
+ warnings int,
+ successes int,
+ total int,
+ UNIQUE (uploadtime, filename)
+); \ No newline at end of file