# search_index_requests

0 rows

### Description

Records requests for (re)indexing of specific contexts. Entries will be removed from this table when indexing of that context is complete. (This table is not used for normal time-based indexing of new content.)

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  |
contextid | BIGINT | 19 |  |  | null |  |
context.id | searinderequ_con2_fkR
| Context ID that has been requested for reindexing.
searcharea | VARCHAR | 255 |  |  |  |  |  | Set (e.g. 'forum-post') if a specific area is to be reindexed. Blank indicates all areas.
timerequested | BIGINT | 19 |  |  | null |  |  | Time at which this index update was requested.
partialarea | VARCHAR | 255 |  |  |  |  |  | If processing of this context partially completed, set to the area that needs processing next. Blank indicates not processed yet.
partialtime | BIGINT | 19 |  |  | null |  |  | If processing partially completed, set to the timestamp within the next area where processing should start. 0 indicates not processed yet.
indexpriority | BIGINT | 19 |  |  | null |  |  | Priority value so that important requests can be dealt with first; higher numbers are processed first

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
searinderequ_con_ix | Performance | Asc | contextid
searinderequ_indtim_ix | Performance | Asc/Asc | indexpriority + timerequested

### Relationships