1 files changed, 2 insertions, 2 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 2660eab1..5b6f6990 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -197,7 +197,7 @@ CREATE TABLE IF NOT EXISTS RedPairMapping(
 CREATE TYPE curr AS ENUM('USD', 'EUR', 'JPY', 'GBP', 'CAD');
 CREATE TYPE sen AS ENUM('Senior', 'Subordinated');
 CREATE TYPE tier AS ENUM('SNRFOR', 'SECDOM', 'SUBLT2', 'PREFT1', 'JRSUBUT2');
-CREATE TYPE bbgSource AS ENUM('MSG1', 'CBIN', 'CBGN', 'MKIT');
+CREATE TYPE bbgSource AS ENUM('MSG1', 'CBIN', 'CBGN', 'MKIT', 'CMAN');
 CREATE TYPE DocClause AS ENUM('No Restructuring', 'Modified Modified Restructurin', 'Full Restructuring');
 CREATE TYPE tenor AS ENUM('6mo', '1yr', '2yr', '3yr', '4yr', '5yr', '7yr', '10yr');
 CREATE TYPE index_type AS ENUM('IG', 'HY', 'EU', 'LCDX', 'XO');
@@ -252,7 +252,7 @@ CREATE TABLE IF NOT EXISTS cds_quotes(
        RunningAsk float,
        Source bbgSource,
        Recovery float,
-       PRIMARY KEY(curve_ticker, Date));
+       PRIMARY KEY(curve_ticker, Date, Source));
 
 GRANT ALL ON cds_quotes TO serenitas_user;
 CREATE INDEX IF NOT EXISTS cds_quotes_date_index ON cds_quotes(date);