MySQL migrations to use LONGTEXT instead of TEXT

For example in https://gitlab.com/gitlab-org/gitlab-ce/issues/46530, we ran into an issue because TEXT datatype in MySQL is actually quite limited in size. The proposal is to use LONGTEXT for all future migration that introduce a :text column in MySQL.