Verify version of mysql.ddl

Document ID : KB000073225
Last Modified Date : 14/03/2018
Show Technical Document Details
Question:
In Preparation for upgrading to DevTest 10.2, the DBA notices that one of the files that's included and we're supposed to run is a bit dated. He'd just like it verified that this is indeed the correct version of this file to use for the upgrade to DevTest 10.2 - that's all. :) 

-rw-r--r-- 1 s057860 users 24611 Jul 19 2016 mysql.ddl
Answer:
As per our documentation for DevTest 10.2 we support these version of MySQL: 

""https://docops.ca.com/devtest-solutions/10-2/en/installing/preinstallation/system-requirements#SystemRequirements-DatabaseRequirements"" 

MySQL 5.5, 5.6, and 5.7 

The MySQL database must provide collation and characters set supporting UTF-8; double-byte characters are stored in the ACL and reporting tables. The default code page for the database must be UTF-8; it is not enough only to define your database as UTF-8. 

With a mysql.dll date of 2016, you are fine.