Skip to content

Instantly share code, notes, and snippets.

@rohithBirdeye
Created June 29, 2020 02:11
Show Gist options
  • Save rohithBirdeye/be88f990cf1e33fa164d62fc0f246447 to your computer and use it in GitHub Desktop.
Save rohithBirdeye/be88f990cf1e33fa164d62fc0f246447 to your computer and use it in GitHub Desktop.
ALTER TABLE `bazaarify`.`staging_business`
CHANGE COLUMN `job_status` `job_status` ENUM('new', 'in_progress', 'succeed', 'signing_up_succeed', 'signing_up_failed', 'restricted_name_used', 'adding_user_succeed', 'adding_user_failed', 'updating_business_succeed', 'updating_business_failed', 'updating_entity_succeed', 'updating_entity_failed', 'finding_entity_succeed', 'finding_entity_failed', 'aggregating_entity_succeed', 'aggregating_entity_failed', 'aggregating_reviews_succeed', 'aggregating_reviews_failed', 'name_not_provided', 'zip_not_provided', 'invalid_business_type', 'enterprise_not_found', 'existing_competitor_account_mapping_succeed', 'phone_not_provided', 'invalid_timezone') CHARACTER SET 'utf8' COLLATE 'utf8_bin' NOT NULL ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment