Each database containing tables for which there is a text index must contain an events table, which logs inserts, updates, and deletes to indexed columns. The name of this table is text_events. It is used to propagate updated data to the Verity collections.
The columns in the text_events table are described in Table 2-3.
Column name |
Description |
|---|---|
event_id |
IDENTITY column |
id |
ID of the row that was updated, inserted, or deleted |
tableid |
Name of the table that contains the row that was updated, inserted, or deleted |
columnid |
Name of the column on which the text index was created |
event_date |
Date and time of the update, insert, or delete |
event_type |
Type of update (update, insert, or delete) |
event_status |
Indicates whether the update, insert, or delete has been propagated to the collections.
|
srvid |
Server ID of the Enhanced Full-Text Search engine maintaining the collection |
