2 drop trigger del_customer on customer;
3 drop trigger del_vendor on vendor;
4 drop function del_customer();
5 drop function del_vendor();
7 create function del_customer() returns opaque as '
9 delete from shipto where trans_id = old.id;
10 delete from customertax where customer_id = old.id;
11 delete from partscustomer where customer_id = old.id;
17 create trigger del_customer after delete on customer for each row execute procedure del_customer();
20 create function del_vendor() returns opaque as '
22 delete from shipto where trans_id = old.id;
23 delete from vendortax where vendor_id = old.id;
24 delete from partsvendor where vendor_id = old.id;
30 create trigger del_vendor after delete on vendor for each row execute procedure del_vendor();
33 update defaults set version = '2.4.2';