diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 7 |
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 |