diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/serenitasdb.sql | 4 |
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);
|