Collection File SQLIndex Node
To distribute a Database index with an add-on collection, use the SQLIndex node. You and add as many SQLIndex nodes as you need.
The following is an example that creates an index called ccVisitsRemoteNameLookup on the table ccVisits in the default DataSource. This index uses the fields RemoteName,ID, and Remote_Addr.
<SQLIndex IndexName="ccVisitsRemoteNameLookup" DataSourceName="Default" TableName="ccVisits" FieldNameList="RemoteName,ID,Remote_Addr" />
To store an SQLIndex node in the collection, use the Other XML field and include the entire line, just as it appears here.
This page was last reviewed Friday, February 26, 2010