diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 4b826031..890492b2 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -77,6 +77,12 @@ CREATE TABLE securities(identifier varchar(12) PRIMARY KEY, description varchar(32), face_amount float, maturity date, + floater boolean, + spread float, + coupon float, + frequency smallint, + first_coupon_date date, + pay_delay smallint, currency currency default 'USD', bbg_type bbg_type default 'Mtge', asset_class asset_class, |