json_table asn/aut-num/prefixes [bg_cache]

CREATE OR REPLACE TABLE asn_prefixes ENGINE myisam as
SELECT k,r.*, cast(REGEXP_SUBSTR(k,'[0-9]+') AS UNSIGNED) asn FROM bg_cache a,

json_table(jdoc,'$.ipv4_prefixes[*]' COLUMNS (
prefix VARCHAR(18) path '$.prefix',
name VARCHAR(255) path '$.name',
description VARCHAR(255) path '$.description',
country_code VARCHAR(2) path '$.country_code',
-- has_parent boolean exists path '$.parent',
ip VARCHAR(15) path '$.ip',
parent_prefix VARCHAR(18) path '$.parent.prefix'

,rn  FOR ORDINALITY
 ) )r


 WHERE k LIKE 'asn/%/prefixes';
ALTER TABLE asn_prefixes ADD COLUMN i INT UNSIGNED DEFAULT INET_ATON(ip);
CREATE INDEX asn ON  asn_prefixes(ASn);
CREATE INDEX i ON  asn_prefixes(i);