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

drop trigger if exists sorder_before_delete;
DELIMITER // 
create trigger sorder_before_delete after delete on dbr_sorder
    for each row begin
        delete from dbr_sorder_bd where sorder_id = old.id;
        delete from dbr_sales where sorder_id = old.id;
    END//
DELIMITER ;