diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 932ff603..1c9b131c 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -8,6 +8,7 @@ CREATE TYPE bond_strat AS ENUM('M_STR_MAV', 'M_STR_MEZZ', 'CSO_TRANCH', 'MTG_REPO', 'CRT_MI', "M_CSH_CASH", + "AUTO_SNR", 'AUTO_JNR' ); CREATE TYPE cds_strat AS ENUM('HEDGE_CSO', 'HEDGE_CLO', 'HEDGE_MAC', 'HEDGE_MBS', @@ -37,7 +38,7 @@ CREATE TYPE cash_strat AS ENUM('M_CSH_CASH', 'MBSCDSCSH', 'SER_IGCVECSH', 'HYINX', 'HEDGE_CLO', 'CVECSH'); CREATE TYPE asset_class AS ENUM('CSO', 'Subprime', 'CLO', 'Tranches', 'Futures', - 'Cash', 'FX', 'Cleared', 'CRT', 'TBILL'); + 'Cash', 'FX', 'Cleared', 'CRT', 'TBILL', 'AUTO'); CREATE TYPE action AS ENUM('NEW', 'UPDATE', 'CANCEL'); CREATE TYPE currency AS ENUM('USD', 'CAD', 'EUR', 'JPY', 'GBP'); @@ -2459,7 +2460,7 @@ CREATE TABLE beta( 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', - 'IR', 'TRANCHE'); + 'IR', 'TRANCHE', 'AUTOS'); CREATE TYPE fund AS ENUM('SERCGLLC', 'SERCGLTD', 'SERCGMAST', 'SER_TEST', 'BRINKER', 'BOWDST', 'LIMBO', 'ISOSEL', 'CRSE') @@ -2481,6 +2482,8 @@ CREATE TYPE strategy AS ENUM( 'HEDGE_MBS', 'MTG_B4PR', 'MTG_FP', 'MTG_GOOD', 'MTG_IO', 'MTG_LMG', 'MTG_REPO' 'MTG_PR', 'MTG_RW', 'MTG_SD', 'MTG_THRU', 'MBSCDS', 'MBSCDSCSH', 'CRT_LD', 'CRT_SD', 'CRT_LD_JNR', 'CRT_MI', 'IR_HEDGE', +-- AUTOS portfolio +'AUTOL_SNR', 'AUTOL_JNR', -- IG portfolio (deprecated) 'IGTCDSCSH', 'IGCURVE', 'IGEQY', 'IGINX', 'IGMEZ', 'IGSNR', -- HY portfolio (deprecated) @@ -2577,7 +2580,9 @@ CREATE TYPE strategy_dirty AS ENUM ( '*', 'CASH_BASIS', 'SOFR', - 'CRT_SD'); + 'CRT_SD', + 'AUTOL_SNR', + 'AUTOL_JNR',); CREATE TABLE valuation_reports( custacctname text, |