2 ALTER TABLE civicrm_membership_type
3 DROP FOREIGN KEY `FK_civicrm_membership_type_relationship_type_id`,
4 DROP INDEX `FK_civicrm_membership_type_relationship_type_id`,
5 CHANGE relationship_type_id relationship_type_id VARCHAR( 64 ) NULL DEFAULT NULL,
6 CHANGE relationship_direction relationship_direction VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;
8 ALTER TABLE civicrm_membership_type
9 ADD INDEX index_relationship_type_id(relationship_type_id);