20141107.ssh.7.colnull.sql
No OneTemporary
Actions

Size

775 B

Referenced Files

None

Subscribers

None

20141107.ssh.7.colnull.sql
View Options

	UPDATE {$NAMESPACE}_auth.auth_sshkey
	SET name = '' WHERE name IS NULL;

	ALTER TABLE {$NAMESPACE}_auth.auth_sshkey
	CHANGE name name VARCHAR(255) COLLATE {$COLLATE_TEXT} NOT NULL;

	UPDATE {$NAMESPACE}_auth.auth_sshkey
	SET keyType = '' WHERE keyType IS NULL;

	ALTER TABLE {$NAMESPACE}_auth.auth_sshkey
	CHANGE keyType keyType VARCHAR(255) COLLATE {$COLLATE_TEXT} NOT NULL;

	UPDATE {$NAMESPACE}_auth.auth_sshkey
	SET keyBody = '' WHERE keyBody IS NULL;

	ALTER TABLE {$NAMESPACE}_auth.auth_sshkey
	CHANGE keyBody keyBody LONGTEXT COLLATE {$COLLATE_TEXT} NOT NULL;

	UPDATE {$NAMESPACE}_auth.auth_sshkey
	SET keyComment = '' WHERE keyComment IS NULL;

	ALTER TABLE {$NAMESPACE}_auth.auth_sshkey
	CHANGE keyComment keyComment VARCHAR(255) COLLATE {$COLLATE_TEXT} NOT NULL;