Files F18452681

115.prepareutf8.sql
No OneTemporary
Actions

Size

714 B

Referenced Files

None

Subscribers

None

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);

File Metadata

Mime Type: text/plain
Expires: Tue, May 26, 9:44 PM (1 d, 8 h)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1549835
Default Alt Text: 115.prepareutf8.sql (714 B)

Event Timeline