diff options
| -rw-r--r-- | python/Dawn/models.py | 12 | ||||
| -rw-r--r-- | sql/dawn.sql | 14 |
2 files changed, 13 insertions, 13 deletions
diff --git a/python/Dawn/models.py b/python/Dawn/models.py index 248a6dc7..705898b6 100644 --- a/python/Dawn/models.py +++ b/python/Dawn/models.py @@ -265,7 +265,7 @@ class BondDeal(db.Model): action = db.Column(ACTION, nullable=False) folder = db.Column(BOND_STRAT, nullable=False) custodian = db.Column(db.String(12), default="BAC", nullable=False) - cashaccount = db.Column(db.String(10), default="V0NSCLMAMB", nullable=False) + cashaccount = db.Column(db.String(12), default="V0NSCLMAMB", nullable=False) cp_code = db.Column( db.String(12), db.ForeignKey("counterparties.code"), @@ -333,7 +333,7 @@ class CDSDeal(db.Model): nullable=False, ) custodian = db.Column(db.String(12), default="NONE", nullable=False) - cashaccount = db.Column(db.String(10), default="V0NSCLMFCM", nullable=False) + cashaccount = db.Column(db.String(12), default="V0NSCLMFCM", nullable=False) cp_code = db.Column( db.String(12), db.ForeignKey("counterparties.code"), @@ -400,7 +400,7 @@ class RepoDeal(db.Model): action = db.Column(ACTION, nullable=False) folder = db.Column(CDS_STRAT, nullable=False) custodian = db.Column(db.String(12), default="SGFCM", nullable=False) - cashaccount = db.Column(db.String(10), default="V0NSCLMAMB", nullable=False) + cashaccount = db.Column(db.String(12), default="V0NSCLMAMB", nullable=False) cp_code = db.Column( db.String(12), db.ForeignKey("counterparties.code"), @@ -461,7 +461,7 @@ class SwaptionDeal(db.Model): portfolio = db.Column(PORTFOLIO, nullable=False) folder = db.Column(SWAPTION_STRAT, nullable=False) custodian = db.Column(db.String(12), default="NONE", nullable=False) - cashaccount = db.Column(db.String(10), default="V0NSCLMAMB", nullable=False) + cashaccount = db.Column(db.String(12), default="V0NSCLMAMB", nullable=False) cp_code = db.Column( db.String(12), db.ForeignKey("counterparties.code"), @@ -566,7 +566,7 @@ class SpotDeal(db.Model): action = db.Column(ACTION, nullable=False) folder = db.Column(SPOT_STRAT, nullable=False) custodian = db.Column(db.String(12), default="INTBR", nullable=False) - cashaccount = db.Column(db.String(10), default="IANSCLMAFU", nullable=False) + cashaccount = db.Column(db.String(12), default="IANSCLMAFU", nullable=False) cp_code = db.Column( db.String(12), db.ForeignKey("counterparties.code"), @@ -598,7 +598,7 @@ class CapFloorDeal(db.Model): action = db.Column(ACTION, nullable=False) folder = db.Column(SWAPTION_STRAT, nullable=False) custodian = db.Column(db.String(12), default="NONE", nullable=False) - cashaccount = db.Column(db.String(10), default="V0NSCLMAMB", nullable=False) + cashaccount = db.Column(db.String(12), default="V0NSCLMAMB", nullable=False) cp_code = db.Column( db.String(12), db.ForeignKey("counterparties.code"), 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, |