Upgrading from 6.1 to 6.2 fails to properly create the templateKey column in table ddmtemplate

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.10 EE GA1, 7.0.0 DXP SP1
• Fix Version/s: 6.2.X EE, 7.0.0 DXP FP22, 7.0.0 DXP SP4, 7.0.X EE, 7.0.4 CE GA5, Master
• Component/s: Dynamic Data Mapping > Upgrades
• Labels:
  • 62-ee-sp20
  • ee-ts
  • liferay-digital-enterprise-70-sp4
  • liferay-fixpack-de-22-7010
  • liferay-fixpack-portal-154-6210
• Branch Version/s:
  7.0.x, 6.2.x
• Backported to Branch:
  Committed
• Story Points: 1.5
• Fix Priority: 4
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/49759

Description
The upgradeProcess for dynamic data mapping for 6.2 does not properly create the templateKey column for table ddmtemplate.

Instead of creating a column type VARCHAR, STRING is used, which leads to selecting a BLOB/CLOB depending on the database being used. For the cause of MYSQL, column type LONGTEXT would be used.

The actual column type that should be created for column templateKey should be VARCHAR(75).

Steps to Reproduce

1. Start an instance of 6.1 with MYSQL as the database
2. Upgrade the 6.1 instance to 6.2
3. Upgrade the 6.2 instance to 7.0
4. Check the database table schema for ddmtemplate and look for column templateKey

Expected Result: templateKey column has a column type VARCHAR(75)
Actual Result: templateKey column has a column type LONGTEXT

Obs: To test on master you can run the upgrade direct from 6.1 to master. 

Reproduced on 62x: cb415314d33b316db280ac979729885fdd440112
Reproduced on master: 994e3a5a2d00917a01a0c99ee75e9d0fbf91c93e