The text_events Table

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.

Table 2-3: Columns in the text_events table

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.