Function: nornix_site.delete_site_resource

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

delete specified site resource

CREATE DEFINER=`root`@`localhost` FUNCTION `delete_site_resource`(vMimeTypeNo INTEGER, vName
VARCHAR(80)) RETURNS int(11)
    MODIFIES SQL DATA
    COMMENT 'delete specified site resource'
BEGIN
 DELETE FROM siteresource
 WHERE `MimeTypeNo` = vMimeTypeNo AND `Name` = vName;
 RETURN ROW_COUNT();
END