1 files changed, 20 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 14464c54..b407dad1 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -1766,7 +1766,26 @@ CREATE TABLE fcm_im(
        currency currency NOT NULL,
        amount float NOT NULL,
        PRIMARY KEY(date, account, currency)
-)
+);
+
+CREATE TABLE fcm_moneyline(
+       date date NOT NULL,
+       account text NOT NULL,
+       currency currency NOT NULL,
+       beginning_balance float NOT NULL,
+       cds_initial_coupon float NOT NULL,
+       cds_reset_to_par float NOT NULL,
+       pai float NOT NULL,
+       clearing_fees float NOT NULL,
+       transaction_fees float NOT NULL,
+       net_dep_withdraw float NOT NULL,
+       ending_balance float NOT NULL,
+       account_value_market float NOT NULL,
+       realized_pnl float NOT NULL,
+       current_im float NOT NULL,
+       current_excess_deficit float NOT NULL,
+       PRIMARY KEY (date, account, currency)
+);
 
 CREATE TABLE strategy_im(
        date date NOT NULL,