diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 4c224eb6..a682cd23 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -753,8 +753,8 @@ CREATE TABLE terminations ( new_gtid int, fee_payment_date date NOT NULL, traded_level numeric(9, 5) NULL, - "deal_type" public."deal_type" NOT NULL, - "currency" public."currency" NOT NULL, + "deal_type" "deal_type" NOT NULL, + "currency" "currency" NOT NULL, delta_id int4 NULL, delta_alloc float8 NULL, cpty_id text null @@ -3213,8 +3213,8 @@ CREATE TABLE equityoptions ( globeop_id int4 NULL, underlyingshares int NOT NULL, CONSTRAINT equity_options2_pkey PRIMARY KEY (id), - CONSTRAINT equity_options2_cash_account_fkey FOREIGN KEY (cash_account) REFERENCES public.accounts2(cash_account) ON UPDATE CASCADE, - CONSTRAINT equity_options2_cp_code_fkey FOREIGN KEY (cp_code) REFERENCES public.counterparties(code) ON UPDATE CASCADE + CONSTRAINT equity_options2_cash_account_fkey FOREIGN KEY (cash_account) REFERENCES accounts2(cash_account) ON UPDATE CASCADE, + CONSTRAINT equity_options2_cp_code_fkey FOREIGN KEY (cp_code) REFERENCES counterparties(code) ON UPDATE CASCADE ); @@ -4131,7 +4131,7 @@ AS SELECT tranche_risk.date, CONSTRAINT isosel_accrued_pk PRIMARY KEY (period_end_date, "row", fund) ); -CREATE TABLE public.citco_reports ( +CREATE TABLE citco_reports ( subfund text NULL, trader text NULL, "prime_broker/clearing_broker" text NULL, @@ -4310,7 +4310,7 @@ CREATE TABLE public.citco_reports ( monthly_issue_income float8 NULL, yearly_issue_income float8 NULL, adjustment_date float8 NULL, - "fund" public."fund" NOT NULL, + "fund" "fund" NOT NULL, future_contract_value float8 NULL, future_contract_tick_size float8 NULL, bond_series_code text NULL, |