diff options
Diffstat (limited to 'sql/quantifi.sql')
| -rw-r--r-- | sql/quantifi.sql | 14 |
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 |
