DELIMITER $$

DROP PROCEDURE IF EXISTS `stw`.`stw_create_lead` $$
CREATE PROCEDURE `stw`.`stw_create_lead` (
          IN i_fname VARCHAR(45),
          IN i_email VARCHAR(255),
          IN i_area VARCHAR(45)
          )
BEGIN
    DECLARE v_maxid INT;

    SELECT MAX(lead_id) + 1 INTO v_maxid FROM stw_leads;

    IF (v_maxid IS NULL) THEN
      SELECT 1 INTO v_maxid;
    END IF

    INSERT INTO stw_leads VALUES (
        v_maxid,
        i_fname,
        i_email,
        NOW(),
        i_area
        );

END $$

DELIMITER ;