MySql_Function.Location.sql

select 'CREATE FUNCTION insertLocationBE(...) RETURNS INT';
DROP FUNCTION IF EXISTS insertLocationBE;
DELIMITER '$';
	CREATE FUNCTION insertLocationBE(param_Name varchar(20), param_Author_ProfileID int, param_Subject varchar(512), param_Text text, param_LanguageCode varchar(3), param_AuthReadListID int, param_AuthWriteListID int, param_PCAuthReadListID int, param_PCAuthWriteListID int)
		RETURNS INT
	DETERMINISTIC
 	BEGIN
		DECLARE var_NewMTextID INT;
		set var_NewMTextID=(select insertMultimediaText(param_Author_ProfileID, param_Subject, param_Text, param_LanguageCode, param_AuthReadListID, param_AuthWriteListID, param_PCAuthReadListID, param_PCAuthWriteListID, 'LocationBE'));
		INSERT INTO losp_BE_location (Name, MTextID) VALUES (param_Name, var_NewMTextID);
		return var_NewMTextID;
 	END;
$
DELIMITER  ;