1 files changed, 5 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index ae6460d4..4b826031 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -49,7 +49,9 @@ CREATE TABLE bonds(id serial primary key,
        price float,
        accrued float,
        asset_class asset_class,
-       ticket text);
+       ticket text,
+       principal_payment float,
+       accrued_payment float);
 
 CREATE TABLE position(date date,
        identifier varchar(12) REFERENCES position_indicative(identifier)
@@ -74,13 +76,14 @@ CREATE TABLE securities(identifier varchar(12) PRIMARY KEY,
        isin varchar(12),
        description varchar(32),
        face_amount float,
+       maturity date,
        currency currency default 'USD',
        bbg_type bbg_type default 'Mtge',
        asset_class asset_class,
        paid_down date default 'Infinity')
 
 CREATE TABLE marks(date date,
-       identifier varchar(12),
+       identifier varchar(12) REFERENCES securities(identifier),
        price float,
        PRIMARY KEY(identifier, date));