Explanation of 'oxuser' table columns

Can someone please help me with the explanations of these columns? What are their purpose? I didn’t find much help in column’s comments

OXUSTIDSTATUS
OXCREATE
OXREGISTER
OXTIMESTAMP
OXUPDATEKEY
OXUPDATEEXP

I’m using enterprise edition 5.2.11

Please have a look at:

OXUSTIDSTATUS could be an old value

Please have a look at the COMMENT of the statement.
OXCREATE datetime NOT NULL default ‘0000-00-00 00:00:00’ COMMENT ‘Creation time’,
OXREGISTER datetime NOT NULL default ‘0000-00-00 00:00:00’ COMMENT ‘Registration time’,
OXUPDATEKEY varchar( 32 ) NOT NULL default ‘’ COMMENT ‘Update key’,
OXUPDATEEXP int(11) NOT NULL default ‘0’ COMMENT ‘Update key expiration time’,
OXTIMESTAMP timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT ‘Timestamp’,

@KristianH I did looked at the comment first then posted here :slight_smile:
Actually “Update key expiration time” and “Update Key” wasn’t helping much that’s why i posted here

The oxupdateexp + oxupdatekey are for the password forget function.

1 Like

Thanks for the information :slight_smile: