[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 3.3.1.mysql.tpl

-- CRM-7127
ALTER TABLE civicrm_membership_type
    DROP FOREIGN KEY `FK_civicrm_membership_type_relationship_type_id`,
    DROP INDEX `FK_civicrm_membership_type_relationship_type_id`,
    CHANGE relationship_type_id relationship_type_id VARCHAR( 64 ) NULL DEFAULT NULL,
    CHANGE relationship_direction relationship_direction VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;

ALTER TABLE civicrm_membership_type
    ADD INDEX index_relationship_type_id(relationship_type_id);
Commit	Line	Data
6a488035 TO	1	-- CRM-7127
	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;
	7
	8	ALTER TABLE civicrm_membership_type
	9	ADD INDEX index_relationship_type_id(relationship_type_id);