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,