1 files changed, 19 insertions, 4 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 994832e7..d50bf2d7 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -1294,18 +1294,33 @@ CREATE TABLE markit_bond_quotes (
 CREATE TABLE markit_trs_quotes (
        quoteid int8 primary key,
        identifier text NOT NULL,
-       bidprice float,
-       askprice float, 
+       bidlevel float,
+       asklevel float, 
        nav float,
        ref float, 
        firmness quote_firmness,
        msg_id text NOT NULL,
-       maturity date NOT NULL,
+       maturity date,
        quotedate timestamptz NOT NULL,
        quotesource text NOT NULL,
-       confidence int
+       confidence int,
+       funding_benchmark text
        );
 
+CREATE TABLE markit_trs_quotes (
+       quoteid int8 primary key,
+       identifier text NOT NULL,
+       bidlevel float,
+       asklevel 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 );
+
 CREATE TABLE hyg_vol_data (
 	"date" date NOT NULL,
 	price float8 NULL,