X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=sql-ledger%2Fsql%2FPg-upgrade-2.3.9-2.4.2.sql;fp=sql-ledger%2Fsql%2FPg-upgrade-2.3.9-2.4.2.sql;h=0000000000000000000000000000000000000000;hp=4e91e473415a270df538b30c0417b5ba115b2abd;hb=86b1b489a4ed2f9bc0cba6cafeab0d6eca5584dc;hpb=948b8acdd4b9b3864342062d0c397a11f57c5700

diff --git a/sql-ledger/sql/Pg-upgrade-2.3.9-2.4.2.sql b/sql-ledger/sql/Pg-upgrade-2.3.9-2.4.2.sql
deleted file mode 100644
index 4e91e4734..000000000
--- a/sql-ledger/sql/Pg-upgrade-2.3.9-2.4.2.sql
+++ /dev/null
@@ -1,34 +0,0 @@
---
-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';
-