# frozen_string_literal: true

class SyncDevTablesCollationsWithProd < ActiveRecord::Migration[6.0]
  def up
    execute %(ALTER TABLE affiliate_credits CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE affiliate_partial_refunds CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE affiliates CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `destination_url` VARCHAR(2083) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE affiliates_links CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE asset_previews CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `attachment_file_name` VARCHAR(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `attachment_content_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `guid` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `oembed` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `attachment_meta` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE balance_transactions CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `issued_amount_currency` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `holding_amount_currency` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE balances CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `currency` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "usd", MODIFY `holding_currency` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "usd")
    execute %(ALTER TABLE bank_accounts CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `bank_number` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `account_number_last_four` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `account_holder_full_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "AchAccount", MODIFY `branch_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `account_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `stripe_bank_account_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `stripe_fingerprint` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `stripe_connect_account_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `country` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE banks CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `routing_number` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE base_variants CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "Variant", MODIFY `custom_sku` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `description` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE base_variants_product_files CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE base_variants_purchases CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE bins CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_bin` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `issuing_bank` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_level` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `iso_country_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `iso_country_a2` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `iso_country_a3` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `website` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `phone_number` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_brand` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE blocked_ips CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `ip_address` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE categories CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE comments CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `commentable_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `author_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `content` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `comment_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `json_data` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE credit_cards CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `stripe_customer_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `visual` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `stripe_fingerprint` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_country` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `stripe_card_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_bin` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_data_handling_mode` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `charge_processor_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `braintree_customer_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `funding_type` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `paypal_billing_agreement_id` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE credits CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE custom_domains CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `domain` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE delayed_emails CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `email_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE devices CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `token` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `app_version` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `device_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "ios" NOT NULL, MODIFY `app_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "consumer" NOT NULL)
    execute %(ALTER TABLE disputes CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `charge_processor_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `charge_processor_dispute_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `reason` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE dynamic_product_page_switch_assignments CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE dynamic_product_page_switches CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE failed_purchases CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `email` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `ip_address` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `stripe_fingerprint` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_country` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE followers CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `email` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `source` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE friendly_id_slugs CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `slug` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `sluggable_type` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `scope` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE gifts CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `gift_note` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `giftee_email` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `gifter_email` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE imported_customers CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `email` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE installment_events CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE installment_rules CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `time_period` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE installments CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `message` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `url` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `installment_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `json_data` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `call_to_action_text` VARCHAR(2083) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `call_to_action_url` VARCHAR(2083) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `cover_image_url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `slug` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE invites CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `receiver_email` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `invite_state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE large_sellers CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE licenses CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `serial` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `json_data` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE links CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `unique_permalink` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `url` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `preview_url` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `description` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `price_currency_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "usd", MODIFY `partner_source` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `upc_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `isrc_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `preview_file_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `preview_content_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `preview_guid` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `attachment_file_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `attachment_content_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `attachment_guid` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `preview_meta` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `attachment_meta` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `territory_restriction` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `preview_oembed` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `custom_receipt` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `custom_filetype` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `variants` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `filetype` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "link", MODIFY `filegroup` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "url", MODIFY `custom_permalink` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `common_color` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `webhook_url` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `custom_fields` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `custom_download_text` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `json_data` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `external_mapping_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE megaphone_states CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE merchant_accounts CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `acquirer_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `acquirer_merchant_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `charge_processor_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `charge_processor_merchant_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `json_data` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `relationship` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `country` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "US", MODIFY `currency` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "usd")
    execute %(ALTER TABLE messages CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `text` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `title` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE oauth_access_grants CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `token` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `redirect_uri` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `scopes` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE oauth_access_tokens CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `token` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `refresh_token` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `scopes` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE oauth_applications CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `uid` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `secret` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `redirect_uri` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `owner_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "User", MODIFY `icon_file_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `icon_content_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `icon_guid` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `scopes` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL DEFAULT "")
    execute %(ALTER TABLE offer_codes CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `currency_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE payment_options CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE payments CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `status_data` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `txn_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `unique_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `correlation_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `processor` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `payment_address` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `stripe_connect_account_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `stripe_transfer_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `stripe_internal_transfer_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `local_currency` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `currency` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "usd", MODIFY `json_data` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `failure_reason` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE payments_balances CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE preorder_links CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `attachment_guid` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `custom_filetype` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE preorders CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL)
    execute %(ALTER TABLE prices CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `currency` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "usd", MODIFY `recurrence` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE processed_audios CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `url` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE product_categorizations CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE product_files CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `url` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `filetype` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `filegroup` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `json_data` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `display_name` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE product_files_archives CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `product_files_archive_state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `url` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE product_files_files_archives CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE product_review_stats CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE product_reviews CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE product_taggings CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE profile_tags CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE purchase_sales_tax_infos CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `elected_country_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_country_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `ip_country_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `country_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `postal_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `ip_address` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `business_vat_id` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE recommended_purchase_infos CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `recommendation_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE recurring_services CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `type` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `json_data` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE refunds CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `json_data` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `status` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "succeeded", MODIFY `processor_refund_id` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE resource_subscriptions CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `resource_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `post_url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE service_charges CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `charge_cents_currency` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "usd", MODIFY `state` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_data_handling_mode` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_bin` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_type` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_country` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_zip_code` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `card_visual` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `charge_processor_id` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `charge_processor_fee_cents_currency` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "usd", MODIFY `charge_processor_transaction_id` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `charge_processor_fingerprint` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `charge_processor_card_id` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `charge_processor_status` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `charge_processor_error_code` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `json_data` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `error_code` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `browser_guid` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `ip_address` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `ip_country` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `ip_state` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `session_id` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `discount_code` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE shipments CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `ship_state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `tracking_number` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `carrier` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `tracking_url` VARCHAR(2083) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE shipping_destinations CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `country_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `json_data` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE skus_variants CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE stamped_pdfs CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `url` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE subscriptions CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE subtitle_files CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `url` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `language` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE tags CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `name` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `humanized_name` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE third_party_analytics CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `analytics_code` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE tos_agreements CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `ip` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE transcoded_videos CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `original_video_key` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `transcoded_video_key` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `transcoder_preset_key` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `job_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE user_categorizations CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE user_compliance_info CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `full_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `street_address` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `city` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `zip_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `country` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `telephone_number` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `vertical` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `json_data` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `business_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `business_street_address` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `business_city` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `business_state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `business_zip_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `business_country` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `business_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `dba` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `verticals` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `first_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `last_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `stripe_identity_document_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE user_compliance_info_requests CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `field_needed` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `json_data` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE users CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `email` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "", MODIFY `encrypted_password` VARCHAR(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "" NOT NULL, MODIFY `reset_password_token` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `current_sign_in_ip` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `last_sign_in_ip` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `payment_address` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `reset_hash` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `password_salt` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `confirmation_token` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `unconfirmed_email` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `provider` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `twitter_user_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `facebook_uid` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `currency_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "usd", MODIFY `custom_css` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `facebook_profile` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `bio` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `twitter_handle` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `username` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `profile_picture_url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `country` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `city` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `zip_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `street_address` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `profile_file_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `profile_content_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `profile_guid` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `profile_meta` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `fanpage` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `facebook_access_token` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `highlight_color` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `background_color` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `background_image_url` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `external_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `account_created_ip` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `twitter_oauth_token` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `twitter_oauth_secret` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `notification_endpoint` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `locale` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "en", MODIFY `admin_notes` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `google_analytics_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `timezone` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "Pacific Time (US & Canada)" NOT NULL, MODIFY `user_risk_state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `tos_violation_reason` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `kindle_email` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `json_data` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `page_layout` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `support_email` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `google_analytics_domains` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `recommendation_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT "same_creator_products" NOT NULL, MODIFY `theme` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `facebook_pixel_id` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `twitter_location` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `twitter_verified` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE variant_categories CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE versions CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `item_type` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `event` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `whodunnit` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `object` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `remote_ip` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `request_path` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  , MODIFY `request_uuid` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `object_changes` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE workflows CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `name` VARCHAR(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `workflow_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `json_data` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
    execute %(ALTER TABLE zip_tax_rates CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `tax_region_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `tax_region_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `zip_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, MODIFY `country` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL, MODIFY `json_data` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci)
  end
end
