BEGIN;
alter table network add column purpose varchar(12);
update network set purpose = 'regular' where purpose is NULL;
alter table network alter column purpose set default 'regular';
alter table network alter column purpose set NOT NULL;
alter table network add constraint network_purpose_check CHECK (purpose IN ('regular', 'cloud', 'cloudbox'));
COMMIT;

