Salt? How do I convert MD5 passwords?

I just did a clean install of RC2 (I was using beta 7 before) and noticed there is a new salt column in the profile table.  How do I convert MD5 passwords to leverage this new field?  Passwords aren't working after my data migration as I've been placing an empty string in the salt column.

FYI, I'm not migrating the users from Dolphin (it's another CMS) and my user passwords are stored as MD5.

Thanks...

First you run a SQL query on each of the member ids to generate a random salt.

UPDATE `Profiles` SET `Salt` = CONV(FLOOR(RAND()*99999999999999), 10, 36) WHERE `ID` =`memberidhere`


Then another SQL query to convert the current password. Make sure the origional MD5 password is in the password field first.


UPDATE `Profiles` SET `Password` = SHA1(CONCAT(`Password`, `Salt`)) WHERE `ID` =`memberidhere`

Thanks deano!  I was able to successfully implement this directly into my migration scripts.  Problem solved...