better-testing

115.prepareutf8.sql
View Options

			ALTER TABLE `{$NAMESPACE}_project`.`project`
			MODIFY `phrictionSlug` varchar(128) binary;

			ALTER TABLE {$NAMESPACE}_repository.repository_path
			ADD COLUMN pathHash varchar(32) binary AFTER path;
			UPDATE {$NAMESPACE}_repository.repository_path SET pathHash = MD5(path);
			ALTER TABLE {$NAMESPACE}_repository.repository_path
			MODIFY pathHash varchar(32) binary not null,
			DROP KEY path,
			ADD UNIQUE KEY (pathHash);

			ALTER TABLE {$NAMESPACE}_user.user_sshkey
			ADD COLUMN keyHash varchar(32) binary AFTER keyBody;
			UPDATE {$NAMESPACE}_user.user_sshkey SET keyHash = MD5(keyBody);
			ALTER TABLE {$NAMESPACE}_user.user_sshkey
			MODIFY keyHash varchar(32) binary not null,
			DROP KEY keyBody,
			ADD UNIQUE KEY (keyHash);