Differential D11116 Diff 26807 resources/sql/autopatches/20140211.dx.3.migsubscriptions.sql

Changeset View

Standalone View

	/* For `grep`: */			/* For `grep`: */

	/* PhabricatorEdgeConfig::TYPE_OBJECT_HAS_SUBSCRIBER = 21 */			/* PhabricatorObjectHasSubscriberEdgeType::EDGECONST = 21 */

	INSERT IGNORE INTO {$NAMESPACE}_differential.edge (src, type, dst, seq)			INSERT IGNORE INTO {$NAMESPACE}_differential.edge (src, type, dst, seq)
	SELECT rev.phid, 21, rel.objectPHID, rel.sequence			SELECT rev.phid, 21, rel.objectPHID, rel.sequence
	FROM {$NAMESPACE}_differential.differential_revision rev			FROM {$NAMESPACE}_differential.differential_revision rev
	JOIN {$NAMESPACE}_differential.differential_relationship rel			JOIN {$NAMESPACE}_differential.differential_relationship rel
	ON rev.id = rel.revisionID			ON rev.id = rel.revisionID
	WHERE relation = 'subd';			WHERE relation = 'subd';