www.gusucode.com > Elgg PHP开源SNS系统 V1.12.5源码程序 > elgg-1.12.5/engine/lib/upgrades/2013051700-1.8.15-add_missing_group_index-52a63a3a3ffaced2.php
<?php /** * Elgg 1.8.15 upgrade 2013051700 * add_missing_group_index * * Some Elgg sites are missing the groups_entity full text index on name and * description. This checks if it exists and adds it if it does not. */ $db_prefix = elgg_get_config('dbprefix'); $full_text_index_exists = false; $results = get_data("SHOW INDEX FROM {$db_prefix}groups_entity"); if ($results) { foreach ($results as $result) { if ($result->Index_type === 'FULLTEXT') { $full_text_index_exists = true; } } } if ($full_text_index_exists == false) { $query = "ALTER TABLE {$db_prefix}groups_entity ADD FULLTEXT name_2 (name, description)"; if (!update_data($query)) { elgg_log("Failed to add full text index to groups_entity table", 'ERROR'); } }