Did you ever find the right table?  I have looked all through them and can't locate it either. I need to change the setting for registration type from "none" to "public" so I can register a new name and then reset the host password.  I can't register on the site because there is no register option!  Can anyone tell me what table and field contains the registration type value?

Thanks.

I don't want to mod any of the encrypted data.. per se... I need to know the table and field that contains the registration verification type (I assume 0,1,2 or 3) so I can turn the registration link back on for a site.

I upgraded some sites to 4.3.5 but the web.configs were not updated properly with the previous validationkey and decryption keys and they are now gone.   I can copy the password and passwordsalt from a brand new user to the host account and get in that way to reset all the passwords properly but one site had it's registration set to none so I cannot register a new account.  I need to be able to set the registration option back to public so I can create a new account and either give it superuser privileges or reset the password with the new user data.  I'm looking for the registrationverificationtype field (or whatever it is called because I can find it) so I can do this.