Function: nornix_site.update_site_resource

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

Update site resource data

CREATE DEFINER=`root`@`localhost` FUNCTION `update_site_resource`(vMimeTypeNo INTEGER, vName
VARCHAR(80),
 vData LONGBLOB, vDescription VARCHAR(255), vWidth INTEGER, vHeight INTEGER) RETURNS int(11)
    MODIFIES SQL DATA
    COMMENT 'Update site resource data'
BEGIN
 UPDATE siteresource r SET `Data` = vData, Description = vDescription, TS = NULL, `Width` = vWidth,
`Height` = vHeight
 WHERE r.MimeTypeNo = vMimeTypeNo AND r.Name = vName;
 RETURN 1;
END