1 files changed, 17 insertions, 0 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 7130b35a..994832e7 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -1286,6 +1286,23 @@ CREATE TABLE markit_bond_quotes (
        msg_id text,
        quotedate timestamptz NULL,
        quotesource text,
+       confidence int,
+       pricelevel float,
+       quote_type text
+       );
+
+CREATE TABLE markit_trs_quotes (
+       quoteid int8 primary key,
+       identifier text NOT NULL,
+       bidprice float,
+       askprice float, 
+       nav float,
+       ref float, 
+       firmness quote_firmness,
+       msg_id text NOT NULL,
+       maturity date NOT NULL,
+       quotedate timestamptz NOT NULL,
+       quotesource text NOT NULL,
        confidence int
        );