No One
Actions

Authored By

	jcrespo
	Aug 30 2017, 9:36 AM

Size

1 KB

Referenced Files

None

Subscribers

None

View Options

	Before:

	CREATE TABLE civicrm_group_contact_cache (
	id int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
	group_id int(10) unsigned NOT NULL COMMENT 'FK to civicrm_group',
	contact_id int(10) unsigned NOT NULL COMMENT 'FK to civicrm_contact',
	PRIMARY KEY (id),
	UNIQUE KEY UI_contact_group (contact_id,group_id),
	KEY FK_civicrm_group_contact_cache_group_id (group_id),
	CONSTRAINT FK_civicrm_group_contact_cache_contact_id FOREIGN KEY (contact_id) REFERENCES civicrm_contact (id) ON DELETE CASCADE,
	CONSTRAINT FK_civicrm_group_contact_cache_group_id FOREIGN KEY (group_id) REFERENCES civicrm_group (id) ON DELETE CASCADE
	) ENGINE=InnoDB

	After:

	CREATE TABLE civicrm_group_contact_cache (
	group_id int(10) unsigned NOT NULL COMMENT 'FK to civicrm_group',
	contact_id int(10) unsigned NOT NULL COMMENT 'FK to civicrm_contact',
	PRIMARY KEY (group_id, contact_id),
	/* UNIQUE KEY UI_contact_group (contact_id,group_id), */
	KEY FK_civicrm_group_contact_cache_group_id (group_id),
	CONSTRAINT FK_civicrm_group_contact_cache_contact_id FOREIGN KEY (contact_id) REFERENCES civicrm_contact (id) ON DELETE CASCADE,
	CONSTRAINT FK_civicrm_group_contact_cache_group_id FOREIGN KEY (group_id) REFERENCES civicrm_group (id) ON DELETE CASCADE
	) ENGINE=InnoDB