diff options
| -rw-r--r-- | sql/dawn.sql | 19 |
1 files changed, 12 insertions, 7 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index ec0d6ad9..da311088 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -894,16 +894,21 @@ CREATE TABLE swaption_marks( gamma float, vega float) -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'); +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'); CREATE TYPE fund AS ENUM('SERCGLLC', 'SERCGLTD', 'SERCGMAST', 'SER_TEST') -CREATE TYPE strategy AS ENUM('CLOCDSCSH', 'CLO_AAA', 'CLO_BB20', 'CLO_BBB', 'CSH_CASH', 'CSH_EXP', 'CSOCDSCSH', 'CSO_TRANCH', 'GFS_TRANSFER_HELPER', - 'HEDGE_CLO', 'HEDGE_CSO', 'HEDGE_MAC', 'HEDGE_MBS', 'HYCURVE', 'HYEQY', 'HYINX', 'HYMEZ', 'HYSNR', 'IGCDSCSH', - 'IGCURVE', 'IGCVECSH', 'IGEQY', 'IGINX', 'IGMEZ', 'IGOPTDEL', 'IGPAYER', 'IGSNR', 'IGTCDSCSH', 'LQD_TRANCH', - 'MACCDSCSH', 'MBSCDS', 'MBSCDSCSH', 'MTG_B4PR', 'MTG_FP', 'MTG_GOOD', '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') +CREATE TYPE strategy AS ENUM('CLOCDSCSH', 'CLO_AAA', 'CLO_BB20', 'CLO_BBB', 'CSH_CASH', + 'CSH_EXP', 'CSOCDSCSH', 'CSO_TRANCH', 'GFS_TRANSFER_HELPER', + 'HEDGE_CLO', 'HEDGE_CSO', 'HEDGE_MAC', 'HEDGE_MBS', 'HYCURVE', 'HYEQY', 'HYINX', + 'HYMEZ', 'HYSNR', 'IGCDSCSH', 'IGCURVE', 'IGCVECSH', 'IGEQY', 'IGINX', + 'IGMEZ', 'IGOPTDEL', 'IGPAYER', 'IGSNR', 'IGTCDSCSH', 'LQD_TRANCH', + 'MACCDSCSH', 'MBSCDS', 'MBSCDSCSH', 'MTG_B4PR', 'MTG_FP', 'MTG_GOOD', + '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') CREATE TABLE val_reports( custacctname text, |