BEGIN;
ALTER TABLE permissions ADD COLUMN pageable VARCHAR(3);
UPDATE permissions SET pageable = 'yes' WHERE pageable IS NULL;
ALTER TABLE permissions ALTER COLUMN pageable SET DEFAULT 'yes';
ALTER TABLE permissions ALTER COLUMN pageable SET NOT NULL;
ALTER TABLE permissions ADD CONSTRAINT permissions_pageable_check CHECK (pageable IN ('yes', 'no'));
COMMIT;

BEGIN;
ALTER TABLE role ADD COLUMN pageable VARCHAR(3);
UPDATE role SET pageable = 'yes' WHERE pageable IS NULL;
ALTER TABLE role ALTER COLUMN pageable SET DEFAULT 'yes';
ALTER TABLE role ALTER COLUMN pageable SET NOT NULL;
ALTER TABLE role ADD CONSTRAINT role_pageable_check CHECK (pageable IN ('yes', 'no'));
COMMIT;

