Moving Pg-upgrade* into sql/legacy directory

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@420 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 34 insertions, 0 deletions

diff --git a/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql b/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql
new file mode 100755
index 00000000..4e91e473
--- /dev/null
+++ b/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql
@@ -0,0 +1,34 @@
+--
+drop trigger del_customer on customer;
+drop trigger del_vendor on vendor;
+drop function del_customer();
+drop function del_vendor();
+--
+create function del_customer() returns opaque as '
+begin
+  delete from shipto where trans_id = old.id;
+  delete from customertax where customer_id = old.id;
+  delete from partscustomer where customer_id = old.id;
+  return NULL;
+end;
+' language 'plpgsql';
+-- end function
+--
+create trigger del_customer after delete on customer for each row execute procedure del_customer();
+-- end trigger
+--
+create function del_vendor() returns opaque as '
+begin
+  delete from shipto where trans_id = old.id;
+  delete from vendortax where vendor_id = old.id;
+  delete from partsvendor where vendor_id = old.id;
+  return NULL;
+end;
+' language 'plpgsql';
+-- end function
+-- 
+create trigger del_vendor after delete on vendor for each row execute procedure del_vendor();
+-- end trigger
+--
+update defaults set version = '2.4.2';
+