Table nucleus_activation

When a new member registers, Nucleus doesn't allow that member to log in before his account is activated. This activation is done by sending out an activation link to the members email address. The nucleus_activation table keeps track of the activations that are in progress.

Column Name Type Default Description
vkey varchar(40) Activation key. This key needs to be passed to the member activation code. A typical key looks like this: 41cf637d4fbeeff954b4ca70b8bde9dd
vmember int(11) Member which needs to be activated.
vtime datetime Time at which activation key was generated. Each activation key is valid no longer than 2 days.
vtype varchar(15) Type of activation.
  • forgot: member forgot his password.
  • register: new member registration.
  • addresschange: member changed his e-mail address.
vextra varchar(128) Extra information. For an addresschange type of activation, this contains oldemailaddress/x with x either 0 or 1 and refering to the previous value of the mcanlogin field in the member table. (untill fully re-activated, a user cannot login)
SQL Table Reference