log2

log2 — Clustered. Stores metadata about all journal entries. The actual content is stored in logtext2.

log2

Column name Type Null Default Description
journalid int unsigned   0 The userid of the user (such as a journal or community) in which the entry is being posted.
jitemid mediumint unsigned   0 The unique id number given to the entry.
posterid int unsigned   0 The user userid of the person that posted the entry.
eventtime datetime YES The time of the entry, supplied by the user / according to the user's system clock.
logtime datetime YES The time of the entry, when the entry was posted (and when LJ logged it to the database - here), according to the server's clock.
compressed char(1)   N Either "N" or "Y", depending on whether the metadata about the journal entry is compressed. Unimplemented. Always "N".
anum tinyint unsigned   0 The access number. A random number between 0 and 255 associated with the entry to form the jitemid.
security enum('public','private','usemask')   public The security level of the entry. "public" is viewable to all, "private" is for only the poster, and "usemask" does a bitwise calculation of the allowmask and the groupmask of the friend viewing it.
allowmask int unsigned   0 A bitmask to specify who can read the (non-public/non-private) entry. Bit 0 is for all friends (i.e., any defined friend can read it). Bits 1-30 are used for friendgroup2/friendgroups. Bit 31 is reserved.
replycount smallint unsigned YES The number of people that have replied to this entry.
year smallint   0 The year of the eventtime. Duplicated for an index.
month tinyint   0 The month of the eventtime. Duplicated for an index.
day tinyint   0 The day of the eventtime. Duplicated for an index.
rlogtime int unsigned   0  
revttime int unsigned   0  
Key name Type Column(s)
PRIMARY PRIMARY
journalid INDEX
posterid INDEX
revttime INDEX
rlogtime INDEX