From e3e1796e7fc5cefb0ad16f3568a75a049ebe0f29 Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Sat, 24 Nov 2007 04:59:29 +0000
Subject: Adding hotfix for 1819483

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1896 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/fixes/transactions_pkey_repost.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 sql/fixes/transactions_pkey_repost.sql

(limited to 'sql/fixes')

diff --git a/sql/fixes/transactions_pkey_repost.sql b/sql/fixes/transactions_pkey_repost.sql
new file mode 100644
index 00000000..cc3935a6
--- /dev/null
+++ b/sql/fixes/transactions_pkey_repost.sql
@@ -0,0 +1,7 @@
+
+CREATE RULE ap_track_d AS ON DELETE TO ap DO ALSO DELETE FROM transactions 
+WHERE id = old.id AND table_name = 'ap';
+CREATE RULE ar_track_d AS ON DELETE TO ar DO ALSO DELETE FROM transactions 
+WHERE id = old.id AND table_name = 'ar';
+CREATE RULE gl_track_d AS ON DELETE TO ap DO ALSO DELETE FROM transactions 
+WHERE id = old.id AND table_name = 'gl';
-- 
cgit v1.2.3