1 files changed, 22 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index c6d1a865..3d29bdab 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -2776,3 +2776,25 @@ CREATE TABLE public.cds_submission (
 	CONSTRAINT cds_submission_pkey PRIMARY KEY (id),
 	CONSTRAINT cds_submission_allocation_id_fkey FOREIGN KEY (tradeid) REFERENCES public.cds(id) ON DELETE CASCADE
 );
+
+
+CREATE TABLE public.mtm_submissions (
+	ticketid text NOT NULL,
+	executed date NULL,
+	dealid text NOT NULL,
+	dealtype text NULL,
+	cp_code text NULL,
+	swaptype text NULL,
+	cpty_ref text NULL,
+	CONSTRAINT mtm_submissions_pk PRIMARY KEY (ticketid, dealid)
+);
+
+CREATE TABLE public.quantifi_bond_proxy (
+	product_name text NOT NULL,
+	trade_date date NOT NULL,
+	"asset_class" text NOT NULL,
+	"fund" public."fund" NOT NULL,
+	notional float8 NULL,
+	terminated bool NULL DEFAULT false,
+	CONSTRAINT quantifi_bond_proxy_pk PRIMARY KEY (product_name, trade_date, asset_class, fund)
+);
+\ No newline at end of file