diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 9b53968d..cc8cc948 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3926,3 +3926,14 @@ BEGIN WHERE pfm.active; END $$ LANGUAGE plpgsql; + + +CREATE TABLE cash_balances ( + "date" date NOT NULL, + "fund" "fund" NULL, + account_name varchar NULL, + account_number varchar NOT NULL, + currency_code "currency" NOT NULL, + balance float8 NULL, + CONSTRAINT cash_balances_pkey PRIMARY KEY (date, account_number, currency_code) +); |