Function: nornix_site.delete_page_resource

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

delete specified page resource

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