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 that the text index was created on. |
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. Event Unread = 0. Event Read = 1. Event Succeeded = 2. Event Failed = 3. |
srvid |
Server ID of the Full-Text Search engine maintaining the collection. |
