Personally I have no need for this, but if it were done, I think would be better to use the w3t_DisplayNames table for this purpose.
A couple of columns could be added:
- D_Timestamp TIMESTAMP NOT NULL
- D_Pending CHAR(1) NOT NULL DEFAULT '1'
D_Timestamp, being of type TIMESTAMP, is automatically set to the current date/time when a row is inserted.
D_Pending would be '1' to indicate that that display name is currently awaiting approval or rejection, and '0' otherwise (historical information).
The existing functionality, as well as the new functionality requested in the previous two posts, would be available by doing the appropriate queries.