MySQL changes

on my machine using mysql 5.5 i can only get this to work when lowering the key length of each field to 200, i.e. `CREATE INDEX uk_3hqwl74jwjq0dksv2t4iqlptm  USING btree ON scim_address (country(200), region(200), locality(200), postalcode(200), streetaddress(200));`