userusage

userusage — Global. Stores record of when users did certain things.

userusage

Column name Type Null Default Description
userid int unsigned   0 Userid of user. One row in this table per user.
timecreate datetime   0000-00-00 00:00:00 When the user created their journal.
timeupdate datetime YES When the user last updated their journal.
timecheck datetime YES Usage information sufficient to tell us whether the accounts been used in the last year or month, even just for viewing. (Important so that if site ever does start to close old accounts, will know they're not closing active only-used-for-viewing accounts)
lastitemid int unsigned   0 Itemid of their last post (see log2)
Key name Type Column(s)
PRIMARY PRIMARY
timeupdate INDEX