diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 55da89f3..67332464 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -92,7 +92,7 @@ CREATE TABLE bonds(id serial primary key, action action NOT NULL, folder bond_strat NOT NULL, custodian varchar(12) NOT NULL, - cashaccount varchar(10) NOT NULL, + cashaccount varchar(12) NOT NULL, cp_code varchar(12) NOT NULL REFERENCES counterparties(code) ON UPDATE CASCADE, trade_date date NOT NULL, settle_date date NOT NULL, @@ -124,7 +124,7 @@ CREATE TABLE cds(id serial primary key, portfolio portfolio NOT NULL, folder cds_strat NOT NULL, custodian varchar(12) NOT NULL, - cashaccount varchar(10) NOT NULL, + cashaccount varchar(12) NOT NULL, cp_code varchar(12) NOT NULL REFERENCES counterparties(code) ON UPDATE CASCADE, trade_date date NOT NULL, effective_date date NOT NULL, @@ -173,7 +173,7 @@ CREATE TABLE repo(id serial primary key, action action NOT NULL, folder bond_strat NOT NULL, custodian varchar(12) NOT NULL, - cashaccount varchar(10) NOT NULL, + cashaccount varchar(12) NOT NULL, cp_code varchar(12) NOT NULL REFERENCES counterparties(code) ON UPDATE CASCADE, trade_date date NOT NULL, settle_date date NOT NULL, @@ -210,7 +210,7 @@ CREATE TABLE swaptions(id serial PRIMARY KEY, portfolio portfolio NOT NULL, folder swaption_strat NOT NULL, custodian varchar(12) NOT NULL, - cashaccount varchar(10) NOT NULL, + cashaccount varchar(12) NOT NULL, cp_code varchar(12) NOT NULL REFERENCES counterparties(code) ON UPDATE CASCADE, swap_type swaption_type NOT NULL, trade_date date NOT NULL, @@ -246,7 +246,7 @@ CREATE TABLE capfloors ( "action" action NOT NULL, folder swaption_strat NOT NULL, custodian varchar(12) NOT NULL, - cashaccount varchar(10) NOT NULL, + cashaccount varchar(12) NOT NULL, cp_code varchar(12) NOT NULL REFERENCES counterparties(code) ON UPDATE CASCADE, "comments" varchar(100), floating_rate_index varchar(12) NOT NULL, @@ -284,7 +284,7 @@ CREATE TABLE futures ( "action" action NOT NULL, folder future_strat NOT NULL, custodian varchar(12) NOT NULL, - cashaccount varchar(10) NOT NULL, + cashaccount varchar(12) NOT NULL, cp_code varchar(12) NOT NULL, trade_date date NOT NULL, settle_date date NOT NULL, @@ -330,7 +330,7 @@ CREATE TABLE spots ( "action" action NOT NULL, folder spot_strat NOT NULL, custodian varchar(12) NOT NULL, - cashaccount varchar(10) NOT NULL, + cashaccount varchar(12) NOT NULL, cp_code varchar(12) NOT NULL, trade_date date NOT NULL, settle_date date NOT NULL, |