[Summary view] [Print] [Text view]

   1  UPDATE {$NAMESPACE}_auth.auth_sshkey
   2    SET name = '' WHERE name IS NULL;
   3  
   4  ALTER TABLE {$NAMESPACE}_auth.auth_sshkey
   5    CHANGE name name VARCHAR(255) COLLATE {$COLLATE_TEXT} NOT NULL;
   6  
   7  UPDATE {$NAMESPACE}_auth.auth_sshkey
   8    SET keyType = '' WHERE keyType IS NULL;
   9  
  10  ALTER TABLE {$NAMESPACE}_auth.auth_sshkey
  11    CHANGE keyType keyType VARCHAR(255) COLLATE {$COLLATE_TEXT} NOT NULL;
  12  
  13  UPDATE {$NAMESPACE}_auth.auth_sshkey
  14    SET keyBody = '' WHERE keyBody IS NULL;
  15  
  16  ALTER TABLE {$NAMESPACE}_auth.auth_sshkey
  17    CHANGE keyBody keyBody LONGTEXT COLLATE {$COLLATE_TEXT} NOT NULL;
  18  
  19  UPDATE {$NAMESPACE}_auth.auth_sshkey
  20    SET keyComment = '' WHERE keyComment IS NULL;
  21  
  22  ALTER TABLE {$NAMESPACE}_auth.auth_sshkey
  23    CHANGE keyComment keyComment VARCHAR(255) COLLATE {$COLLATE_TEXT} NOT NULL;