DROP PROCEDURE order_delete;
DELIMITER //
CREATE PROCEDURE order_delete (i INT)
BEGIN
  /* Delete all references to an order number 'i' */
  delete from ps2_orders where id_order=i;
  delete from ps2_order_detail where id_order=i;
  delete from ps2_order_return where id_order=i;
  delete from ps2_order_slip where id_order=i;
  delete from ps2_order_history where id_order=i;
  /* maybe: insert into ps2_order_history set id_order=1, id_order_state=999 date_add=now(); */
END //
DELIMITER ;

/* SHOW PROCEDURE STATUS LIKE '%order%'; */