subs

subs — Clustered. Stores metadata details about a user's ESN subscriptions. Please see also has_subs.

subs

Column name Type Null Default Description
userid int unsigned   0 The owner of the subscription.
subid int unsigned   0 The ESN subscription ID (domain type 'E') allocated by the LJ::alloc_user_counter function.
is_dirty tinyint unsigned YES One of either 1 (indexed), or NULL (not in index) - means we need to update the target's etypeid.
journalid int unsigned   0 The journal in which the event took place.
etypeid smallint unsigned   0  
arg1 int unsigned   0  
arg2 int unsigned   0  
ntypeid smallint unsigned   0 The notification type from the notifytypelist table.
createtime int unsigned   0 Unixtime.
expiretime int unsigned   0 Unixtime. Can be 0, to mean "never".
flags smallint unsigned   0  
Key name Type Column(s)
PRIMARY PRIMARY
etypeid INDEX
is_dirty INDEX