USE provisioning;
SET autocommit=0;

ALTER TABLE autoprov_sync_parameters CHANGE COLUMN parameter_name parameter_name enum('sync_uri','sync_method','sync_params','security_handler','profile','cid','key');

DELETE FROM autoprov_sync_parameters WHERE bootstrap_method = 'redirect_snom' AND parameter_name = 'profile'; 

DELETE FROM autoprov_sync_parameters WHERE bootstrap_method = 'redirect_snom' AND parameter_name = 'product_family'; 

COMMIT;