Running database scripts to enable Interact features

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 required columns to your tables.

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

dbType is the database type, such as sqlsvr for Microsoft™ SQL Server, ora for Oracle, or db2 for IBM® DB2®.

Feature Name	Feature Script	Run Against	Change
Global offers, offer suppression, and score override	Runtime environment installation directory:Interact_Home\ddl\acifeatures\aci_usrtab_dbType.sql	Your profile database (userProdDataSource)	Creates the DefaultOffers, UACI_BlackList, and UACI_ScoreOverride tables.
Scoring	Runtime environment installation directory:Interact_Home\ddl\acifeatures\aci_scoringfeature_dbType.sql	Score override tables in your profile database (userProdDataSource)	Adds the LikelihoodScore and AdjExploreScore columns.
Learning	Design time environment installation directoryInteract_Home\InteractDT\ddl\acifeatures\aci_lrnfeature_dbType.sql	Campaign database that contains your contact history tables	Adds the column RTSelectionMethod to the UA_DtlContactHist table. This script is also required by the reporting features provided by the optional Interact Reports Pack.