mk6i-open-oscar-server/state/migrations/0002_hash_columns.up.sql

ALTER TABLE user
    RENAME COLUMN passHash TO strongMD5Pass;

ALTER TABLE user
    ADD COLUMN weakMD5Pass TEXT;

-- The cleartext passwords don't exist, so it's not possible to create weak MD5
-- hashes. Fill in the values with a placeholder value. The administrator will
-- require everyone to reset their passwords if they want to log in with AIM
-- 3.5 thru AIM4.7
UPDATE user
SET weakMD5Pass = strongMD5Pass;