We're updating the issue view to help you get more done. 

Restore string columns' empty default values removed by the UTF8MB4 upgrade

Description

In AO3-4056, we converted the database to UTF8MB4 encoding.

The second stage conversion script does this:

1 default = (column.default.blank?) ? '' : "DEFAULT \"#{column.default}\""

This means columns with DEFAULT '' lose that attribute. Let's add them back:

  • archive_faqs: slug

  • collections: icon_alt_text, icon_comment_text

  • invite_requests: simplified_email

  • languages: sortable_name

  • pseuds: icon_alt_text, icon_comment_text

  • skins: icon_alt_text

  • taggings: tagger_type, taggable_type

  • tags: name, sortable_name

Environment

None

Status

Assignee

redsummernight

Reporter

redsummernight

Roadmap

Misc

Priority

Medium

Affects versions

0.9.236

Fix versions

Components

BackEnd

Difficulty

Medium

Required Access Level

None

Milestone

Internal 0.9