Procedure: nornix_site.update_document_levels

Information
DeterministicData accessMode
NOMODIFIES SQL DATA

Code

Set all documents to correct level

CREATE DEFINER=`root`@`localhost` PROCEDURE `update_document_levels`()
    MODIFIES SQL DATA
    COMMENT 'Set all documents to correct level'
BEGIN
 UPDATE document SET Level=get_document_level(`No`);
 SET @tempdocpath='';
END