1 files changed, 6 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index 639ac249..e8c3739a 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -88,7 +88,8 @@ CREATE TABLE securities(identifier varchar(12) PRIMARY KEY,
        currency currency default 'USD',
        bbg_type bbg_type default 'Mtge',
        asset_class asset_class,
-       paid_down date default 'Infinity')
+       paid_down date default 'Infinity'
+       start_accrued_date date)
 
 CREATE TABLE marks(date date,
        identifier varchar(12) REFERENCES securities(identifier),
@@ -104,6 +105,10 @@ CREATE TABLE cashflow_history(
        coupon float,
        PRIMARY KEY (identifier, date));
 
+CREATE TABLE FX(date date PRIMARY KEY,
+       eurusd float,
+       cadusd float);
+
 CREATE OR REPLACE function list_marks(p_date date, include_unsettled boolean DEFAULT False)
 RETURNS TABLE(identifier varchar(12), price float) AS $$
 BEGIN