crates/radicle/src/node/db/migrations/9.sql — heartwood

rad:z3gqcJUoA1n9HaHKufZs5FCSGazv5

Radicle Heartwood Protocol & Stack

.. 1.sql 2.sql 3.sql 4.sql 5.sql 6.sql 7.sql 8.sql 9.sql

-- every valid IPv6 textual representation (including `::`) contains
-- at least one `:`. So if the bracket-stripped inner part has no `:`, the value
-- can't be a real IPv6 address.
delete from addresses
where type = 'ipv6'
  and instr(value, '[') = 1
  and instr(value, ']:') > 1
  and instr(substr(value, 2, instr(value, ']:') - 2), ':') = 0;