- // Note: this only works in MySQL 5.6, but this whole system is intended to only work in MySQL 5.6
- $sql = "
- SELECT i.name as index_name
- FROM information_schema.innodb_sys_tables t
- JOIN information_schema.innodb_sys_indexes i USING (table_id)
- WHERE t.name = concat(database(),'/$table')
- AND i.name like '" . self::IDX_PREFIX . "%'
- ";
- $dao = CRM_Core_DAO::executeQuery($sql);