Using Interact feature scripts

Several of the optional features available with Interact require changes to specific tables in your profile databases. Your Interact installation, both design environment and runtime environment, includes feature ddl scripts. These scripts add any specific columns required to your table.

To enable any of these features, run the appropriate script against the appropriate database or table.

dbType is the database type, for example sqlsvr for Microsoft™ SQL Server.

Feature Name	Feature Script	Run Against	Change
Global offers, offer suppression, and score override	Runtime environment installation directory\ddl\aci_usrtab_dbType.sql	Your profile database (userProdDataSource)	Creates the DefaultOffers, UACI_BlackList, and UACI_ScoreOverride tables.
Scoring	Runtime environment installation directory\ddl\acifeatures\aci_scoringfeature_dbType.sql	Score override tables in your profile database (userProdDataSource)	Adds the LikelihoodScore and AdjExploreScore columns.
Learning	Design environment installation directory\ddl\acifeatures\aci_lrnfeature_dbType.sql	Campaign database containing contact history tables	Adds the column RTSelectionMethod to the UA_DtlContactHist table.