log2 —
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| journalid | int unsigned | 0 | ||
| jitemid | mediumint unsigned auto_increment | |||
| posterid | int unsigned | 0 | ||
| eventtime | datetime | YES | ||
| logtime | datetime | YES | ||
| compressed | char(1) | N | ||
| anum | tinyint unsigned | 0 | ||
| security | enum('public','private','usemask') | public | ||
| allowmask | int unsigned | 0 | ||
| replycount | smallint unsigned | YES | ||
| year | smallint | 0 | ||
| month | tinyint | 0 | ||
| day | tinyint | 0 | ||
| rlogtime | int unsigned | 0 | ||
| revttime | int unsigned | 0 |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| journalid | INDEX | |
| logtime | INDEX | |
| posterid | INDEX | |
| revttime | INDEX | |
| rlogtime | INDEX | |
| year | INDEX |