diff options
| -rw-r--r-- | sql/dawn.sql | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 07ac59b9..960702af 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -28,7 +28,7 @@ CREATE TYPE cash_strat AS ENUM('M_CSH_CASH', 'MBSCDSCSH', 'SER_IGCVECSH', 'SER_ITRXCVCSH', 'CSOCDSCSH', 'IGCDSCSH', 'HYCDSCSH', 'CLOCDSCSH', 'IGTCDSCSH', 'MACCDSCSH', 'M_STR_MEZZ', 'IRDEVCSH', 'TCSH', 'COCSH', 'SER_ITRXCURVE', 'XCURVE', 'BSPK', 'SER_HYINX', 'IGOPTDEL', 'IGINX', - 'HEDGE_CLO', 'CVECSH'); + 'HYINX', 'HEDGE_CLO', 'CVECSH'); CREATE TYPE asset_class AS ENUM('CSO', 'Subprime', 'CLO', 'Tranches', 'Futures', 'Cash', 'FX', 'Cleared', 'CRT'); @@ -88,7 +88,9 @@ CREATE TABLE counterparties(code varchar(12) PRIMARY KEY, valuation_contact4 text, valuation_email4 text, notes text, - instructions text); + instructions text, + cash_counterparty boolean NOT NULL DEFAULT true, + cds_counterparty boolean NOT NULL DEFAULT false); CREATE INDEX ON counterparties(name); @@ -165,7 +167,8 @@ INSERT OR UPDATE OF faceamount, price, trade_date, - settle_date + settle_date, + accrued ON bonds FOR EACH ROW EXECUTE PROCEDURE notify_id(); |