aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--sql/dawn.sql12
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');