useful-qry/function-in-db/triggers/item_before_delete.sql

drop trigger if exists item_before_delete;
DELIMITER // 
create trigger item_before_delete before delete on dbr_item
    for each row begin
        delete from dbr_item_thm where id = old.id;
        delete from pro_item_revsum where id = old.id;
    end
//
DELIMITER ;