diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 93 |
1 files changed, 89 insertions, 4 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 3df6427c..27218ff2 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -185,10 +185,14 @@ RETURN NEW; END $$ LANGUAGE plpgsql; -CREATE TABLE portfolio_folder_mapping( -folder strategy PRIMARY KEY, -portfolio portfolio NOT NULL -valid boolean NOT NULL); +CREATE TABLE portfolio_folder_mapping ( + folder "strategy_dirty" NOT NULL, + "portfolio" "portfolio" NOT NULL, + active bool NOT NULL DEFAULT true, + clean_folder text NULL, + CONSTRAINT portfolio_folder_mapping_pkey PRIMARY KEY (folder) +); + CREATE OR REPLACE TRIGGER portf BEFORE INSERT OR UPDATE OF @@ -2403,6 +2407,87 @@ CREATE TYPE strategy AS ENUM( -- LQD_TRANCH (deprecated) 'LQD_TRANCH') +CREATE TYPE public."strategy_dirty" AS ENUM ( + 'M_CLO_BB20', + 'M_CLO_AAA', + 'M_CLO_BBB', + 'M_MTG_IO', + 'M_MTG_THRU', + 'M_MTG_GOOD', + 'M_MTG_B4PR', + 'M_MTG_RW', + 'M_MTG_FP', + 'M_MTG_LMG', + 'M_MTG_SD', + 'M_MTG_PR', + 'M_MTG_CRT_SD', + 'CRT_LD', + 'CRT_LD_JNR', + 'MTG_REPO', + 'HEDGE_CSO', + 'HEDGE_CLO', + 'HEDGE_MAC', + 'HEDGE_MBS', + 'SER_IGSNR', + 'SER_IGMEZ', + 'SER_IGEQY', + 'SER_IGINX', + 'SER_HYSNR', + 'SER_HYMEZ', + 'SER_HYEQY', + 'SER_HYINX', + 'SER_IGCURVE', + 'MBSCDS', + 'IGOPTDEL', + 'HYOPTDEL', + 'SER_ITRXCURVE', + 'M_STR_MEZZ', + 'M_STR_MAV', + 'HYEQY', + 'HYMEZ', + 'HYSNR', + 'HYINX', + 'IGEQY', + 'IGMEZ', + 'IGSNR', + 'IGINX', + 'XOEQY', + 'XOMEZ', + 'XOINX', + 'EUEQY', + 'EUMEZ', + 'EUSNR', + 'EUINX', + 'BSPK', + 'XCURVE', + 'SER_HYCURVE', + 'IGPAYER', + 'IGREC', + 'HYPAYER', + 'HYREC', + 'STEEP', + 'FLAT', + 'DV01', + 'DELTAONE', + 'M_CSH_CASH', + 'M_CSH_EXP', + 'MBSCDSCSH', + 'SER_IGCVECSH', + 'SER_ITRXCVCSH', + 'CVECSH', + 'CSOCDSCSH', + 'IGCDSCSH', + 'HYCDSCSH', + 'CLOCDSCSH', + 'MACCDSCSH', + 'IRDEVCSH', + 'TCSH', + 'IGTCDSCSH', + 'COCSH', + '*', + 'CASH_BASIS', + 'CRT_SD'); + CREATE TABLE valuation_reports( custacctname text, endbookcost float, |