CREATE TABLE tbl2 
(
    id_note INT(11) NOT NULL AUTO_INCREMENT,
    note TINYTEXT NULL,
    PRIMARY KEY(id_note)
)ENGINE = InnoDB;

CREATE TABLE tbl1
(
    id INT(11) NOT NULL AUTO_INCREMENT,
    name VARCHAR(30) NOT NULL,
    id_note INT(11) NOT NULL,
    PRIMARY KEY(id),
    FOREIGN KEY(id_note) REFERENCES tbl2(id_note)
        ON DELETE CASCADE
        ON UPDARE CASCADE
)ENGINE = InnoDB;

DELIMITER //

CREATE PROCEDURE add (name VARCHAR(30), note TINYTEXT)
BEGIN
    INSERT IGNORE INTO tbl2 VALUES(NULL,note);
    DECLARE last_id INT(11);
    SELECT LAST_INSERT_ID() INTO last_id;
    INSERT IGNORE INTO tbl1 VALUES(NULL,name,last_id);
END
//