Differential D13513 Diff 32785 resources/sql/autopatches/20150701.herald.1.sql

Changeset View

Standalone View

				UPDATE {$NAMESPACE}_herald.herald_condition c
				JOIN {$NAMESPACE}_herald.herald_rule r
				ON c.ruleID = r.id
				SET c.fieldName = 'pholio.mock.name'
				WHERE r.contentType = 'HeraldPholioMockAdapter'
				AND c.fieldName = 'title';

				UPDATE {$NAMESPACE}_herald.herald_condition c
				JOIN {$NAMESPACE}_herald.herald_rule r
				ON c.ruleID = r.id
				SET c.fieldName = 'pholio.mock.description'
				WHERE r.contentType = 'HeraldPholioMockAdapter'
				AND c.fieldName = 'body';

				UPDATE {$NAMESPACE}_herald.herald_condition c
				JOIN {$NAMESPACE}_herald.herald_rule r
				ON c.ruleID = r.id
				SET c.fieldName = 'pholio.mock.author'
				WHERE r.contentType = 'HeraldPholioMockAdapter'
				AND c.fieldName = 'author';