1 files changed, 13 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index c02d8ef0..9be60f2b 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -3132,4 +3132,17 @@ CREATE TABLE trs (
     compound_avg_frequency frequency NOT NULL,
     fixing_frequency frequency NOT NULL,
     cpty_id text NULL
+);
+
+
+CREATE TABLE public.strat_cash_realloc (
+	id int4 NOT NULL GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
+	dealid text NULL GENERATED ALWAYS AS ('STRATCSH'::text || id::text) STORED,
+  "portfolio" public."portfolio" NULL,
+	folder public."strategy_dirty" NOT NULL,
+  trade_date date NOT NULL,
+	amount float8 NOT NULL,
+	"currency" public."currency" NOT NULL,
+	"fund" public."fund" NOT NULL DEFAULT 'BOWDST'::fund,
+	cash_account text NOT NULL,
 );
 \ No newline at end of file