Differential D18903 Diff 45363 resources/sql/autopatches/20180120.auth.03.vcsdata.sql

Changeset View

Standalone View

	INSERT INTO {$NAMESPACE}_auth.auth_password			INSERT INTO {$NAMESPACE}_auth.auth_password
	(objectPHID, phid, passwordType, passwordHash, isRevoked,			(objectPHID, phid, passwordType, passwordHash, isRevoked,
	dateCreated, dateModified)			dateCreated, dateModified)
	SELECT userPHID, '', 'vcs', passwordHash, 0, dateCreated, dateModified			SELECT userPHID, CONCAT('XVCS', id), 'vcs', passwordHash, 0,
				dateCreated, dateModified
	FROM {$NAMESPACE}_repository.repository_vcspassword;			FROM {$NAMESPACE}_repository.repository_vcspassword;
				epriestleyAuthorUnsubmitted Not Done Inline Actions There's a little bit of juggling here to make sure that the migration runs okay if the unique key on `phid` gets added sooner than we expect. This just gives each new password a unique value, then the followup migrations overwrite them with real PHIDs. epriestley: There's a little bit of juggling here to make sure that the migration runs okay if the unique…