diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 6f613830..a91cfe0b 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -9,7 +9,7 @@ CREATE TYPE cds_strat AS ENUM('HEDGE_CSO', 'HEDGE_CLO', 'HEDGE_MAC', 'HEDGE_MBS' 'SER_HYMEZ', 'SER_HYEQY', 'SER_HYINX', 'SER_IGCURVE', 'MBSCDS', 'IGOPTDEL', 'HYOPTDEL', 'SER_ITRXCURVE'); -CREATE TYPE swaption_strat AS ENUM('IGPAYER', 'IGREC', 'HYPAYER', 'HYREC'); +CREATE TYPE swaption_strat AS ENUM('IGPAYER', 'IGREC', 'HYPAYER', 'HYREC', 'STEEP'); CREATE TYPE repo_strat AS ENUM(''); @@ -1088,7 +1088,8 @@ CREATE TABLE swaption_marks( CREATE TYPE portfolio AS ENUM('CASH', 'CLO', 'CURVE', 'GFS_HELPER_BUSINESS_UNIT', 'HEDGE_MAC', 'HY', 'IG', 'LQD_TRANCH', 'MORTGAGES', 'OPTIONS', - 'SERCGLLC__SERCGLLC', 'SERCGLTD__SERCGLTD', 'SER_TEST__SER_TEST', 'STRUCTURED'); + 'SERCGLLC__SERCGLLC', 'SERCGLTD__SERCGLTD', 'SER_TEST__SER_TEST', 'STRUCTURED', + 'IR'); CREATE TYPE fund AS ENUM('SERCGLLC', 'SERCGLTD', 'SERCGMAST', 'SER_TEST') @@ -1101,7 +1102,7 @@ CREATE TYPE strategy AS ENUM('CLOCDSCSH', 'CLO_AAA', 'CLO_BB20', 'CLO_BBB', 'CSH 'MTG_IO', 'MTG_LMG', 'MTG_PR', 'MTG_RW', 'MTG_SD', 'MTG_THRU', 'SERCGLLC__SERCGLLC', 'SERCGLTD__SERCGLTD', 'SERCGLTD__SERLTD_EXP', 'SER_TEST__SER_TEST', 'STR_MAV', 'STR_MEZZ', 'HYOPTDEL', 'HYPAYER', 'HYCDSCSH', - 'ITRXCURVE', 'ITRXCVCSH', 'IR', 'IR_CSH', 'IGREC') + 'ITRXCURVE', 'ITRXCVCSH', 'IR', 'IR_CSH', 'IGREC', 'STEEP', 'FLAT') CREATE TABLE valuation_reports( custacctname text, |