RE: [Arianne-general] MySQL structure overhaul...

[Andrew S. <ans...@mi...>]

> 
> Arianne Database
> 
>    - arianne_users
> 
>           - ID
>           - Username
>           - Email
>           - Profile
>           - CryptoScheme   (enum:  rsa  sha1  md5)
>           - SHA1
>           - MD5
>           - nRSA
>           - eRSA
> 

> - The password scheme is selected by the enum. So the next values
either
>   have nothing in it or the password crypt. No need for an extra
table.

just curious... the encrypted password is just binary data right? It
doesn't really matter what it is as long as the database stores the
crypto method. Why keep 3 or 4 different fields to represent the same
data?

andy