! ip needs to be bigint since Postgres doesn't support unsigned ints