Procedure: nornix_site.add_new_content

Information
DeterministicData accessMode
NOMODIFIES SQL DATA

Code

Insert deafult content in new content object

CREATE DEFINER=`root`@`localhost` PROCEDURE `add_new_content`(IN vDocumentNo INTEGER, IN
vContentTypeNo INTEGER)
    MODIFIES SQL DATA
    COMMENT 'Insert deafult content in new content object'
BEGIN
 INSERT INTO `content` (`DocumentNo`, `ContentTypeNo`, `Data`)
  VALUES (vDocumentNo, vContentTypeNo, (SELECT NewData FROM nornix_system.contenttype WHERE `No` =
vContentTypeNo));
END