diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index cdfb3252..cc5b11a2 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -256,7 +256,7 @@ CREATE TABLE cds(id serial primary key, dealid varchar(28) UNIQUE, fund fund NOT NULL DEFAULT 'SERCGMAST', lastupdate timestamptz DEFAULT now(), - action action NOT NULL, + action action NOT NULL DEFAULT 'NEW', portfolio portfolio NOT NULL, folder cds_strat NOT NULL, custodian varchar(12) NOT NULL, @@ -266,11 +266,11 @@ CREATE TABLE cds(id serial primary key, effective_date date NOT NULL, maturity date NOT NULL, currency currency NOT NULL, - payment_rolldate bus_day_convention NOT NULL, + payment_rolldate bus_day_convention NOT NULL DEFAULT 'Following', notional float NOT NULL, fixed_rate float NOT NULL, - day_count day_count NOT NULL, - frequency smallint NOT NULL, + day_count day_count NOT NULL DEFAULT 'ACT/360', + frequency smallint NOT NULL DEFAULT 4, protection protection NOT NULL, security_id varchar(12) NOT NULL, security_desc varchar(32) NOT NULL, |