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()