diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 5bc02bdc..cdd66334 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1427,3 +1427,12 @@ CREATE TABLE tranche_marks( corr_detach float, index_duration float, PRIMARY KEY(date, id)) + + +CREATE TABLE fcm_im( + date date NOT NULL, + account text NOT NULL, -- REFERENCES accounts(cash_account) + currency currency NOT NULL, + amount float NOT NULL, + PRIMARY KEY(date, account, currency) +) |