mirror of
https://we.phorge.it/source/phorge.git
synced 2024-09-19 16:58:48 +02:00
24 lines
775 B
MySQL
24 lines
775 B
MySQL
|
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;
|