DELIMITER $$
CREATE PROCEDURE RecordTaskIO(
	IN In_SubjectId TEXT,
	IN In_DateTime_Start DATETIME,
	IN In_DateTime_Write DATETIME,
	IN In_TaskDuration TEXT,
	IN In_ClientTimeZone TEXT,
	IN In_Data TEXT
)
BEGIN
IF (SELECT COUNT(SubjectId) FROM TaskIO WHERE SubjectId=In_SubjectId)=0 THEN 
	INSERT INTO TaskIO (SubjectId, DateTime_Start, DateTime_Write, TaskDuration, ClientTimeZone, Data) VALUES (In_SubjectId, In_DateTime_Start, In_DateTime_Write, In_TaskDuration, In_ClientTimeZone, In_Data);
ELSE
	UPDATE TaskIO SET DateTime_Start = In_DateTime_Start, DateTime_Write = In_DateTime_Write, TaskDuration = In_TaskDuration, ClientTimeZone = In_ClientTimeZone, Data = In_Data WHERE SubjectId = In_SubjectId;
END IF;
END$$
DELIMITER ;