salix/db/routines/util/functions/crypt.sql

16 lines
346 B
MySQL
Raw Permalink Normal View History

DELIMITER $$
CREATE OR REPLACE DEFINER=`root`@`localhost` FUNCTION `util`.`crypt`(vText VARCHAR(255), vKey VARCHAR(255))
RETURNS varchar(255) CHARSET utf8mb3 COLLATE utf8mb3_general_ci
NOT DETERMINISTIC
READS SQL DATA
BEGIN
DECLARE vResult VARCHAR(255);
CALL vn.crypt(vText, vKey, vResult);
RETURN vResult;
END$$
DELIMITER ;