aboutsummaryrefslogtreecommitdiffstats
path: root/sql/dawn.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/dawn.sql')
-rw-r--r--sql/dawn.sql14
1 files changed, 0 insertions, 14 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index cfa530fa..29acc883 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -3325,20 +3325,6 @@ CREATE TABLE trs (
globeop_id int null,
);
-
-CREATE TABLE 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" "portfolio" NULL,
- folder "strategy_dirty" NOT NULL,
- trade_date date NOT NULL,
- amount float8 NOT NULL,
- "currency" "currency" NOT NULL,
- "fund" "fund" NOT NULL DEFAULT 'BOWDST'::fund,
- cash_account text NOT NULL,
- CONSTRAINT strat_cash_realloc_un UNIQUE (folder, trade_date, amount, currency, fund, cash_account)
-);
-
CREATE TYPE "instrument_type" AS ENUM (
'IRS',
'CDS',