DELIMITER $$
CREATE PROCEDURE `sp_createzone`(
IN zone varchar(255),
IN http varchar(255),
IN mx varchar(255)
)
BEGIN
declare zoneid int;

insert into soa (origin) values (zone);

set zoneid = last_insert_id();

insert into rr (zone, name, type, data, aux) values (zoneid,zone,'NS','ns1.spherelinx.com',0);

END$$
DELIMITER ;