change ip field to a varchar, since vera uses a hostname