use provisioning;
set autocommit=0;

UPDATE voip_preferences SET expose_to_customer = 1 WHERE attribute in ('ncos_id', 'ncos_set_id');
UPDATE voip_preferences SET expose_to_subscriber = 1 WHERE attribute in ('ncos_id', 'ncos_set_id');

COMMIT;