1 files changed, 0 insertions, 19 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 2d920a12..fc3721a2 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -3697,15 +3697,6 @@ CREATE TABLE citco_trs (
 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()
-);
-
 CREATE TABLE citco_submission2(
        id integer NOT NULL GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
        identifier_type citco_identifier not null,
@@ -3716,16 +3707,6 @@ CREATE TABLE citco_submission2(
        UNIQUE (identifier_type, submit_date, process_date, citco_id)
 );
 
-CREATE TABLE citco_submission_status(
-       serenitas_id text not null,
-       action action not null,
-       identifier_type citco_identifier not null,
-       identifier text null,
-       committed bool not null default False,
-       submit_date timestamptz NOT NULL DEFAULT now()
-);
-
-
 CREATE table isda_agreement_dates(
   fund fund not null,
   counterparty text REFERENCES counterparties(code),