Reference > Database > WebSphere Commerce database tables > U
WebSphere Commerce database table: USERPWDHST
This table stores the previously used passwords of a registered user. Each row of the table represents a password that has previously been used by the user. When a user changes their password, the change password process checks that the new password does not match any values for that user.
Column Name Column Type Description USERPWDHST_ID BIGINT NOT NULL A unique primary key for this table. USERS_ID BIGINT NOT NULL ID for the registered user. Foreign key to the USERREG table. PREVLOGONPASSWORD BINARY NOT NULL The encrypted user logon password that has been previously used. SALT VARCHAR(254) The value that is appended to the password before hashing. PASSWORDCREATION TIMESTAMP NOT NULL The time that the password was created. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001105 USERS_ID+PASSWORDCREATION Unique Index SQL100520030444750 USERPWDHST_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3476 USERS_ID USERREG USERS_ID Cascade _vcc_freeselect_bottom_