changed to syntax of 'ADD INDEX' to avoid problems when a text data type is indexed