DELIMITER $$

DROP PROCEDURE IF EXISTS `proc_form_designerLoadByPrimaryKey`$$


CREATE PROCEDURE `proc_form_designerLoadByPrimaryKey`
(
p_form_id INT(11),
p_designer_id INT(11)
)
SQL SECURITY INVOKER
BEGIN

    SELECT
        form_id,
        designer_id
    FROM form_designer
    WHERE
        (form_id = p_form_id) AND
        (designer_id = p_designer_id)
;

END$$

DROP PROCEDURE IF EXISTS `proc_form_designerLoadAll`$$


CREATE PROCEDURE `proc_form_designerLoadAll`
()
SQL SECURITY INVOKER
BEGIN

    SELECT
        form_id,
        designer_id
    FROM form_designer;

END$$


-------------------------------------------
-- NO UPDATE Stored Procedure Generated    
-- All Columns are part of the Primary key
-------------------------------------------


DROP PROCEDURE IF EXISTS `proc_form_designerInsert`$$


CREATE PROCEDURE `proc_form_designerInsert`
(
p_form_id INT(11),
p_designer_id INT(11)
)
SQL SECURITY INVOKER
BEGIN
    DECLARE _NOW DATETIME;
    SET _NOW = NOW();
    INSERT
    INTO form_designer
    (
        form_id,
        designer_id
    )
    VALUES
    (
        p_form_id,
        p_designer_id
    );



END$$


DROP PROCEDURE IF EXISTS `proc_form_designerDelete`$$


CREATE PROCEDURE `proc_form_designerDelete`
(
    p_form_id INT(11),
    p_designer_id INT(11)
)
SQL SECURITY INVOKER
BEGIN

    DELETE
    FROM form_designer
    WHERE
        form_id = p_form_id AND
        designer_id = p_designer_id;

END$$


DELIMITER;$$




Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END$$
DROP PROCEDURE IF EXISTS `proc_form_designerLoadAll`$$
CREATE PROCEDURE `p' at line 1
(0 ms taken)

DELIMITER $$

DELIMITER $$;