CREATE DEFINER=`b9f6484d5b6c03`@`%` PROCEDURE `sproc_add_activity`(
	in_createdBy int(11),
    in_startdate varchar(40),
    in_enddate varchar(40),
    in_name varchar(255),
    in_description varchar(255),
    in_responsibleUser int(11),
    in_alternativeLocation varchar(255),
    in_issuggestion tinyint(1),
    in_category int(11),
    in_resource int(11),
    in_challenger int(11),
    in_challenged int (11))
BEGIN
INSERT
	INTO `activity` (
		createdBy,
        startdate,
        enddate,
		name,
		description,
		responsibleUser,
		alternativeLocation,
        issuggestion,
		category,
		resource,
        challenger,
        challenged)
	VALUES(
    in_createdBy,
    str_to_date(in_startdate,'%Y-%m-%dT%H:%i:%s.%f'),
    str_to_date(in_enddate, '%Y-%m-%dT%H:%i:%s.%f'),
    in_name,
    in_description,
    in_responsibleUser,
    in_alternativeLocation,
    in_issuggestion,
    in_category,
    in_resource,
    in_challenger,
    in_challenged);

    /*select id, registrationdate, createdby, startdate, enddate, name, description, responsibleuser, alternativelocation, issuggestion, isactive, category, resource, alternative_location*/
    select *
    from activity
    where id = last_insert_id();


END