summaryrefslogtreecommitdiff
path: root/sql-ledger/sql/Pg-upgrade-2.3.9-2.4.2.sql
diff options
context:
space:
mode:
authorcvs2git <cvs2git>2006-08-23 22:25:40 +0000
committercvs2git <cvs2git>2006-08-23 22:25:40 +0000
commit58d093219cf60264550b8c34649d9f3190eda042 (patch)
tree10418dd70b52416a5f52da8e17d8e282d914595d /sql-ledger/sql/Pg-upgrade-2.3.9-2.4.2.sql
parent3ce7691203a7737406bf2d4442f7fd84b81f847e (diff)
This commit was manufactured by cvs2svn to create tagAFTER_FINAL_MASONIZE
'AFTER_FINAL_MASONIZE'.
Diffstat (limited to 'sql-ledger/sql/Pg-upgrade-2.3.9-2.4.2.sql')
-rw-r--r--sql-ledger/sql/Pg-upgrade-2.3.9-2.4.2.sql34
1 files changed, 0 insertions, 34 deletions
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';
-