labtech
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
f_CWAESEncrypt
Parameters
Name
Type
Mode
encryptLevel
int
IN
encryptString
varchar(255)
IN
Definition
BEGIN DECLARE serverId VARCHAR(255); DECLARE encryptedOutput VARBINARY(255); IF encryptString IS NULL OR encryptString ='' THEN RETURN ''; END IF; SELECT `config`.`serverId` FROM `config` INTO serverId; SET encryptedOutput = AES_ENCRYPT(encryptString, serverId); IF encryptedOutput IS NULL THEN RETURN ''; END IF; RETURN encryptedOutput; END