diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 48a9b622..3d6aa8ad 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -2088,7 +2088,7 @@ CREATE TYPE portfolio AS ENUM('CASH', 'CLO', 'CURVE', 'GFS_HELPER_BUSINESS_UNIT' 'SERCGLLC__SERCGLLC', 'SERCGLTD__SERCGLTD', 'SER_TEST__SER_TEST', 'STRUCTURED', 'IR', 'TRANCHE'); -CREATE TYPE fund AS ENUM('SERCGLLC', 'SERCGLTD', 'SERCGMAST', 'SER_TEST', 'BRINKER', 'BOWDST') +CREATE TYPE fund AS ENUM('SERCGLLC', 'SERCGLTD', 'SERCGMAST', 'SER_TEST', 'BRINKER', 'BOWDST', 'LIMBO', 'ISOSEL') CREATE TYPE strategy AS ENUM( -- CLO portfolio @@ -3111,6 +3111,7 @@ CREATE TABLE trs ( trade_date date NOT NULL, effective_date date NOT NULL, maturity_date date NOT NULL, + settle_date date NOT NULL, funding_index cash_rate NOT NULL DEFAULT 'SOFRRATE'::cash_rate, buysell bool NOT NULL, underlying_security varchar(32) NOT NULL, |