diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index b81f8e56..4fcf451b 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -203,10 +203,10 @@ CREATE TABLE swaptions(id serial PRIMARY KEY, expiration_date date NOT NULL, initial_margin_percentage float, security_id varchar(12) NOT NULL, - security_desc varchar(32) NOT NULL, + security_desc varchar(32), maturity date NOT NULL, currency currency NOT NULL, - fixed_rate float NOT NULL, + fixed_rate float, termination_date date, termination_amount float, termination_cp varchar(12) REFERENCES counterparties(code) ON UPDATE CASCADE); |
