- // Note: this only works in MySQL 5.6, but this whole system is intended to only work in MySQL 5.6
- // Note: In MYSQL 8 the Tables have been renamed from INNODB_SYS_TABLES and INNODB_SYS_INDEXES to INNODB_TABLES and INNODB_INDEXES
- $innodbTable = "innodb_sys_tables";
- $innodbIndex = "innodb_sys_indexes";
- if (version_compare($mysqlVersion, '8.0', '>=')) {
- $innodbTable = "innodb_tables";
- $innodbIndex = "innodb_indexes";
- }
- $sql = "
- SELECT i.name as `index_name`
- FROM information_schema.$innodbTable t
- JOIN information_schema.$innodbIndex i USING (table_id)
- WHERE t.name = concat(database(),'/$table')
- AND i.name like '" . self::IDX_PREFIX . "%'
- ";
- $dao = CRM_Core_DAO::executeQuery($sql);