So I have this final regular expression to match a table:

public static function tables()
{
$pattern = '/(?<creationScript>CREATE\s+TABLE\s+`(?<tableName>\S+)`\s+';
$pattern .= '\((?<tableDefinition>([^;\/]+((COMMENT\s\'[^\']+((\'\')+[^\']*)*\')?[^;\/]+)*))\)';
$pattern .= '(?:\s+ENGINE=(?<engine>[^;\s]+))?\s*';
$pattern .= '(?:AUTO_INCREMENT=(?<autoIncrement>\d+))?\s*';
$pattern .= '(?:DEFAULT CHARSET=(?<defaultCharset>[^;\s]+))?\s*)';
$pattern .= '(?:COLLATE=.+?)?\s*';
$pattern .= '(?:\/\*.+?\*\/)?\s*';

And this is one table:
CREATE TABLE `jos_updates` (
`update_id` int(11) NOT NULL AUTO_INCREMENT,
`update_site_id` int(11) DEFAULT '0',
`extension_id` int(11) DEFAULT '0',
`name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
`description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
`element` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
`type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '',
`folder` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '',
`client_id` tinyint(3) DEFAULT '0',

As per my question, this is the original code from the author of php-mysql-diff, which matches above table

public static function tables()
{
$pattern = '/(?<creationScript>CREATE\s+TABLE\s+`(?<tableName>\S+)`\s+';
$pattern .= '\((?<tableDefinition>[^;\/]+)\)';
$pattern .= '(?:\s+ENGINE=(?<engine>[^;\s]+))?\s*';
$pattern .= '(?:AUTO_INCREMENT=(?<autoIncrement>\d+))?\s*';
$pattern .= '(?:DEFAULT CHARSET=(?<defaultCharset>[^;\s]+))?\s*)';
$pattern .= '(?:COLLATE=.+?)?\s*';
$pattern .= '(?:\/\*.+?\*\/)?\s*';

But not this one:

CREATE TABLE `jos_ucm_history` (
`version_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ucm_item_id` int(10) unsigned NOT NULL,
`ucm_type_id` int(10) unsigned NOT NULL,
`version_note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Optional version name',
`save_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`editor_user_id` int(10) unsigned NOT NULL DEFAULT '0',
`character_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of characters in this version.',