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

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`entry_lock`(vSelf INT)
BEGIN
/**
 * Lock the indicated entry
 * @vSelf params entry id
 */
	UPDATE `entry`
		SET lockerUserFk = account.myUser_getId(),
			locked = util.VN_NOW()
		WHERE id = vSelf;
END$$
DELIMITER ;