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