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

14 lines
266 B
MySQL
Raw Permalink Normal View History

DELIMITER $$
2024-08-20 08:06:10 +00:00
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`entry_unlock`(vSelf INT)
BEGIN
/**
* Unlock the indicated entry
* @vSelf params entry id
*/
UPDATE `entry`
SET lockerUserFk = NULL,
locked = NULL
WHERE id = vSelf;
END$$
DELIMITER ;