All pastes #534222 Raw Edit

Assid

public text v1 · immutable
·published 2007-06-03 18:31 UTC
rendered paste body
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 ;