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
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
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.
Thanks for the information