1BEGIN;
2
3ALTER TABLE users ADD COLUMN "radius" boolean DEFAULT false;
4
5UPDATE device SET layers = NULL WHERE vendor = 'netdisco';
6
7UPDATE device SET layers = '00000000' WHERE layers IS NULL;
8
9ALTER TABLE device ALTER layers SET DEFAULT '00000000';
10
11COMMIT;
12