Function: nornix_site.delete_theme_resource

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

delete specified theme resource

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