Recover Your Password

Return to Product Support > Learning Center > Developer References > Creating Add-ons > Add-on Collections > Collection Installation File > Collection File SQLIndex Node

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 5/27/2021 3:03:28 PM