1 files changed, 9 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 750a9a98..4e1149c8 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -3450,6 +3450,15 @@ CREATE TABLE citco_submission(
        submit_date timestamptz NOT NULL DEFAULT now()
 );
 
+CREATE TABLE citco_submission2(
+       id integer NOT NULL GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
+       identifier_type citco_identifier not null,
+       citco_id text not null,
+       serenitas_id text not null,
+       submit_date timestamptz,
+       process_date timestamptz,
+       UNIQUE (identifier_type, submit_date, process_date, citco_id)
+);
 
 CREATE TABLE citco_submission_status(
        serenitas_id text not null,