esl/MongooseIM — pull request #129 by IvanMartinez (2013-12-04 13:46:26+00:00)
Title: Change vcard.server and vcard_search.server to varchar(150)

The purpose of this change is to make the SQL script compatible with MySQL 5.1.70. Without this change the "CREATE TABLE vcard_search ..." query fails as follows:

ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

This is because this table's primary key is composed of the columns "lusername" and "server", resulting in a key that exceeds MySQL 5.1.70's length limitation. "varchar(150)" is the longest round number that I have tested succesfully.

The change is "vcard.server"'s type is to make it equal to "vcard_search.server".