aboutsummaryrefslogtreecommitdiffstats
path: root/sql/dawn.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/dawn.sql')
-rw-r--r--sql/dawn.sql9
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)
+)