salix/db/routines/vn/procedures/zoneGeo_delete.sql

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`zoneGeo_delete`(vSelf INT)
BEGIN
/**
 * Deletes a node from the #zoneGeo table. Also sets a mark
 * to force the tree recalculation.
 *
 * @vSelf The node identifier
 */
	DELETE FROM zoneGeo WHERE id = vSelf;
	UPDATE zoneGeoRecalc SET isChanged = TRUE;
END$$
DELIMITER ;