Manual:Log search table

The log_search table (added in ).

ls_field
The type of ID ('rev_id', 'log_id', 'ipb_id', 'target_author_id'; and according to tables.sql, 'rev timestamp' and 'username'.)

ls_value
The value of the ID (e.g. if ls_field is 'rev_id', then ls_value would contain the rev_id).

ls_log_id
Key to log_id

Versions
mysql> DESCRIBE log_search; +---+--+--+-+-+---+ +---+--+--+-+-+---+ +---+--+--+-+-+---+ 3 rows in set (0,10 sec)
 * Field    | Type             | Null | Key | Default | Extra |
 * ls_field | varbinary(32)    | NO   | PRI | NULL    |       |
 * ls_value | varchar(255)     | NO   | PRI | NULL    |       |
 * ls_log_id | int(10) unsigned | NO  | PRI | 0       |       |