diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 5779b960..e05b904e 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3883,4 +3883,14 @@ SELECT id, price, maturity_date, settle_date -FROM trs JOIN counterparties ON cp_code = code) ORDER BY trade_date DESC, folder;
\ No newline at end of file +FROM trs JOIN counterparties ON cp_code = code) ORDER BY trade_date DESC, folder; + + +CREATE TRIGGER cash_account BEFORE +INSERT OR UPDATE OF + fund, + cp_code +ON + trs +FOR EACH ROW +EXECUTE PROCEDURE update_account('ISDA'); |
