When CREATING a table column using MyPHPAdmin there isn't a choice in the selection for SHA1, however when browsing the existing table entries, if I choose to edit a row then the option is there for SHA1, go figure.

I have found how to UPDATE my table password column to SHA1 but that will only effect the current rows.

MySQL column specs don't support function calls so; How can I get the password column to use SHA1 on newly added rows?