subs — Clustered. Stores metadata details about a user's ESN subscriptions. Please see also has_subs.
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| userid | int unsigned |
|
The owner of the subscription. | |
| subid | int unsigned |
|
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 |
|
The journal in which the event took place. | |
| etypeid | smallint unsigned |
|
||
| arg1 | int unsigned |
|
||
| arg2 | int unsigned |
|
||
| ntypeid | smallint unsigned |
|
The notification type from the notifytypelist table. | |
| createtime | int unsigned |
|
Unixtime. | |
| expiretime | int unsigned |
|
Unixtime. Can be 0, to mean "never". | |
| flags | smallint unsigned |
|
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| etypeid | INDEX | |
| is_dirty | INDEX |