Function: nornix_site.add_root_setting

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

Add or change root setting, returns success (0/1)

CREATE DEFINER=`root`@`localhost` FUNCTION `add_root_setting`(vClass VARCHAR(32), vAttribute
VARCHAR(48), vValue VARCHAR(255)) RETURNS int(11)
    MODIFIES SQL DATA
    COMMENT 'Add or change root setting, returns success (0/1)'
BEGIN
 DECLARE success INTEGER DEFAULT 1;
 DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' SET success = 0;
 REPLACE INTO nornix_root.rootsetting (`Class`, `Attribute`, `Value`)
 VALUES (vClass, vAttribute, vValue);
 RETURN success;
END