1 files changed, 12 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index fe45f54b..d33b2ae4 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -3273,4 +3273,16 @@ CREATE TABLE citco_trs (
 	compound_avg_frequency "frequency" NOT NULL,
 	fixing_frequency "frequency" NOT NULL,
   committed bool NOT NULL default False
+);
+
+CREATE TYPE "citco_identifier" AS ENUM (
+	'trade', 'instrument', 'failed');
+
+
+CREATE TABLE citco_submission(
+       fname text not null,
+       identifier_type citco_identifier not null,
+       identifier text not null,
+       serenitas_id text not null,
+       submit_date timestamptz NOT NULL DEFAULT now()
 );
 \ No newline at end of file