diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index e86c6fc2..46cc6325 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -109,7 +109,8 @@ CREATE TRIGGER dealid CREATE TABLE cds(id serial primary key, dealid varchar(28), lastupdate timestamptz DEFAULT now(), - action action, + action action NOT NULL, + portfolio portfolio NOT NULL, folder cds_strat NOT NULL, custodian varchar(12) NOT NULL, cashaccount varchar(10) NOT NULL, @@ -1240,7 +1241,7 @@ CREATE TABLE swaption_marks( CREATE TYPE portfolio AS ENUM('CASH', 'CLO', 'CURVE', 'GFS_HELPER_BUSINESS_UNIT', 'HEDGE_MAC', 'HY', 'IG', 'LQD_TRANCH', 'MORTGAGES', 'OPTIONS', 'SERCGLLC__SERCGLLC', 'SERCGLTD__SERCGLTD', 'SER_TEST__SER_TEST', 'STRUCTURED', - 'IR'); + 'IR', 'TRANCHE'); CREATE TYPE fund AS ENUM('SERCGLLC', 'SERCGLTD', 'SERCGMAST', 'SER_TEST') @@ -1248,7 +1249,7 @@ CREATE TYPE strategy AS ENUM( -- CLO portfolio 'CLOCDSCSH', 'CLO_AAA', 'CLO_BB20', 'CLO_BBB', 'HEDGE_CLO', -- TRANCHE portfolio -'HYEQY', 'HYMEZ', 'HYSNR', 'HYINX', 'IGEQY', 'IGMEZ', 'IGSNR', 'IGINX', +'HYEQY', 'HYMEZ', 'HYSNR', 'HYINX', 'IGEQY', 'IGMEZ', 'IGSNR', 'IGINX', 'BSPK', 'TCSH' -- CURVE portfolio 'IGCURVE', 'IGCVECSH', 'ITRXCURVE', 'ITRXCVCSH', 'HYCURVE', -- OPTIONS portfolio |