<?php
/**
 * Add index to custom field. This method will not work as expected.
 * File Location: custom/Extension/modules/Contacts/Ext/Vardefs/index_external_id.php
 *
 */
$dictionary['Contact']['indices'][] = array(
	'name' => 'idx_external_id_c',
	'type' => 'index',
	'fields' => array(
		'external_id_c'
	)
);

/**
 * After running repair and rebuild we get the following SQL query to run
 * based on the new vardef
 */
 /* INDEXES */
 /*MISSING INDEX IN DATABASE - idx_external_id_c - index  ROW */

// ALTER TABLE contacts ADD INDEX idx_external_id_c (external_id_c);