Function: nornix_site.add_new_document

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

Create new document with default content, returns DocNo

CREATE DEFINER=`root`@`localhost` FUNCTION `add_new_document`(vParSibNo INTEGER,
 vPathPart VARCHAR(45), vMenuName VARCHAR(80), vPageTitle VARCHAR(80),
 vAuthLevel INTEGER, vContentTypeNo INTEGER, vMode VARCHAR(24)) RETURNS int(11)
    MODIFIES SQL DATA
    COMMENT 'Create new document with default content, returns DocNo'
BEGIN
 DECLARE vDocumentNo INTEGER DEFAULT NULL;
 CASE vMode
  WHEN "LastChild" THEN
   SET vDocumentNo = add_new_document_as_last_child(vParSibNo, vPathPart, vMenuName, vPageTitle
,vAuthLevel);
  WHEN "BeforeSibling" THEN
   SET vDocumentNo = add_new_document_before_sibling(vParSibNo, vPathPart, vMenuName, vPageTitle
,vAuthLevel);
 END CASE;
 CALL add_new_content(vDocumentNo, vContentTypeNo);
 RETURN vDocumentNo;
END