1 files changed, 10 insertions, 9 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index d643dc7a..15625f69 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -1239,20 +1239,21 @@ CREATE TYPE quote_firmness AS ENUM('FIRM', 'INDICATIVE');
 
 CREATE TABLE markit_quotes (
        quoteid int8 primary key,
-       asset_class markit_asset_class,
+       assetclass markit_asset_class,
        redcode text,
        ticker text, 
        maturity date,
        tenor tenor,
-       running_coupon int,
-       bid_spread float,
-       bid_upfront float,
-       bid_size float,
-       ask_spread float,
-       ask_upfront float,
-       ask_size float,
+       runningcoupon int,
+       bidconventionalspread float,
+       bidupfront float,
+       bidsize float,
+       askconventionalspread float,
+       askupfront float,
+       asksize float,
+       firmness quote_firmness,
        msg_id text,
        source text,
        quotedate timestamptz NULL,
-       quote_source varchar(4) NULL
+       quotesource varchar(4) NULL
        );
 \ No newline at end of file