ALTER TABLE roms
RENAME COLUMN sha1 TO sha1_old;

ALTER TABLE roms
ADD COLUMN sha1 VARCHAR(40);

UPDATE roms
SET sha1 = sha1_old;

ALTER TABLE roms
DROP COLUMN sha1_old;