diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index e16e101b..cb1d4b9c 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -194,11 +194,13 @@ CREATE TABLE swaptions(id serial PRIMARY KEY, buysell bool NOT NULL, notional float NOT NULL, swaption_type swaption_type NOT NULL, + strike float NOT NULL, price float NOT NULL, expiration_date date NOT NULL, security_id varchar(12) NOT NULL, security_desc varchar(32) NOT NULL, maturity date NOT NULL, + currency currency NOT NULL, fixed_rate float NOT NULL); CREATE OR REPLACE FUNCTION auto_swaption_dealid() |