Differential D10603 Diff 25476 resources/sql/patches/065.sshkeys.sql

Changeset View

Standalone View

	CREATE TABLE {$NAMESPACE}_user.user_sshkey (			CREATE TABLE {$NAMESPACE}_user.user_sshkey (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,			id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	userPHID varchar(64) BINARY NOT NULL,			userPHID varchar(64) BINARY NOT NULL,
	key (userPHID),			key (userPHID),
	name varchar(255),			name varchar(255),
	keyType varchar(255),			keyType varchar(255),
	keyBody varchar(32768) BINARY,			keyBody LONGBLOB,
				btrahanUnsubmitted Not Done Inline Actions sneaking this in here? btrahan: sneaking this in here?
				epriestleyAuthorUnsubmitted Not Done Inline Actions When reapplying the patches with `--no-quickstart` (which normal users will never do), this patch failed, probably because of MySQL version differences. This makes it succeed; the column type will be adjusted later if necessary. epriestley: When reapplying the patches with `--no-quickstart` (which normal users will never do), this…
	unique key (keyBody(128)),			unique key (keyBody(128)),
	keyComment varchar(255),			keyComment varchar(255),
	dateCreated INT UNSIGNED NOT NULL,			dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL			dateModified INT UNSIGNED NOT NULL
	) ENGINE=InnoDB;			) ENGINE=InnoDB;