summaryrefslogtreecommitdiff
path: root/sql-ledger/sql/Pg-upgrade-2.3.9-2.4.2.sql
diff options
context:
space:
mode:
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 4e91e47..0000000
--- 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';
-