MariaDB [(none)]> SELECT * FROM information_schema.tables WHERE table_schema = 'entitlements_diffs' AND table_name = '_schema_changes'; +---------------+--------------------+-----------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------------+ | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT | +---------------+--------------------+-----------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------------+ | def | entitlements_diffs | _schema_changes | BASE TABLE | MyISAM | 10 | Dynamic | 10 | 69 | 692 | 281474976710655 | 2048 | 0 | NULL | 2018-03-07 08:10:23 | 2018-03-07 08:10:23 | NULL | latin1_swedish_ci | NULL | | | +---------------+--------------------+-----------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------------+ 1 row in set (0.00 sec) MariaDB [(none)]> SELECT * FROM information_schema.tables WHERE table_schema = 'entdata_utf8' AND table_name = 'corp_user_group_log'; +---------------+--------------+---------------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------------+ | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT | +---------------+--------------+---------------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------------+ | def | entdata_utf8 | corp_user_group_log | BASE TABLE | InnoDB | 10 | Compact | 65 | 252 | 16384 | 0 | 16384 | 0 | NULL | 2014-08-28 21:06:25 | NULL | NULL | utf8_general_ci | NULL | | | +---------------+--------------+---------------------+------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------------+ 1 row in set (0.00 sec) MariaDB [(none)]> SHOW CREATE TABLE `entitlements_diffs`.`_schema_changes`; +-----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | _schema_changes | CREATE TABLE `_schema_changes` ( `tblSchema` varchar(64) NOT NULL, `tblName` varchar(64) NOT NULL, `colName` varchar(64) NOT NULL, `colType` longtext NOT NULL, `afterCol` varchar(64) DEFAULT NULL, `defaultVal` longtext DEFAULT NULL, `diff_type` tinyint(2) NOT NULL, PRIMARY KEY (`tblSchema`,`tblName`,`colName`,`diff_type`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +-----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [(none)]> SHOW CREATE TABLE `entdata_utf8`.`corp_user_group_log`; +---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | corp_user_group_log | CREATE TABLE `corp_user_group_log` ( `user_group_id` int(10) unsigned NOT NULL, `contrib_id` varchar(11) NOT NULL, `contrib_comp_id` varchar(11) NOT NULL, `default_estimates` tinyint(2) unsigned DEFAULT 0 COMMENT 'Entitle estimates', `created_on` datetime NOT NULL, `log_date` datetime NOT NULL, PRIMARY KEY (`user_group_id`,`log_date`), KEY `contrib_comp_id` (`contrib_comp_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | +---------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)