BEGIN;

ALTER TABLE users ADD COLUMN "radius" boolean DEFAULT false;

UPDATE device SET layers = NULL WHERE vendor = 'netdisco';

UPDATE device SET layers = '00000000' WHERE layers IS NULL;

ALTER TABLE device ALTER layers SET DEFAULT '00000000';

COMMIT;