-- automatic insert of `PTR' when an `A' is inserted (JPM)

DELIMITER $$
CREATE TRIGGER dlz_dns_ptrrecords AFTER INSERT ON dns_records
FOR EACH ROW BEGIN
  IF (NEW.type = 'A') THEN
     -- data *must* contain an IPv4 Address
     INSERT INTO dns_ptrrecords (zone, host, ttl, type, data)
        VALUES (
           inarpa4(NEW.data),        -- 1.168.192.in-addr.arpa
           ip4octet(NEW.data),       -- 4
           NEW.ttl,                  -- copy ttl
           'PTR',                    -- PTR
           CONCAT_WS('.', NEW.host, CONCAT(NEW.zone, '.'))
         );
  END IF;
END $$
DELIMITER ;