[Summary view] [Print] [Text view]

   1  ALTER TABLE `{$NAMESPACE}_project`.`project`
   2    MODIFY `phrictionSlug` varchar(128) binary;
   3  
   4  ALTER TABLE {$NAMESPACE}_repository.repository_path
   5    ADD COLUMN pathHash varchar(32) binary AFTER path;
   6  UPDATE {$NAMESPACE}_repository.repository_path SET pathHash = MD5(path);
   7  ALTER TABLE {$NAMESPACE}_repository.repository_path
   8    MODIFY pathHash varchar(32) binary not null,
   9    DROP KEY path,
  10    ADD UNIQUE KEY (pathHash);
  11  
  12  ALTER TABLE {$NAMESPACE}_user.user_sshkey
  13    ADD COLUMN keyHash varchar(32) binary AFTER keyBody;
  14  UPDATE {$NAMESPACE}_user.user_sshkey SET keyHash = MD5(keyBody);
  15  ALTER TABLE {$NAMESPACE}_user.user_sshkey
  16    MODIFY keyHash varchar(32) binary not null,
  17    DROP KEY keyBody,
  18    ADD UNIQUE KEY (keyHash);