CREATE TABLE nodeinterface_backup_20251229
    AS
        SELECT
            *
        FROM
            nodeinterface;

UPDATE nodeinterface
SET
    ipdataid = NULL
WHERE
    ipdataid NOT IN (
        SELECT
            ipdataid
        FROM
            ipdata
    )
    AND ipdataid IS NOT NULL;

UPDATE nodeinterface
SET
    ipdatav6id = NULL
WHERE
    ipdatav6id NOT IN (
        SELECT
            ipdataid
        FROM
            ip_data_v6
    )
    AND ipdatav6id IS NOT NULL;