summaryrefslogtreecommitdiff
path: root/sql-ledger/sql/Pg-upgrade-2.3.9-2.4.2.sql
diff options
context:
space:
mode:
authorivan <ivan>2007-12-04 21:29:13 +0000
committerivan <ivan>2007-12-04 21:29:13 +0000
commit86b1b489a4ed2f9bc0cba6cafeab0d6eca5584dc (patch)
tree4a7a8893f6ad8bd86cf6c22e00cf19d9c70554f2 /sql-ledger/sql/Pg-upgrade-2.3.9-2.4.2.sql
parent948b8acdd4b9b3864342062d0c397a11f57c5700 (diff)
there's no reason this should still be hanging aroudn the tree
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';
-