Before you can use Merchandising with the Search add-on features (Search Merchandising and Faceted Search), you must create versioned database tables that support these features. For additional information, see the section Creating the Search Database Tables in the Installing ATG Search chapter of the ATG Search Installation and Configuration Guide.

To create the versioned Search tables on a production-ready database :run the following scripts:

<ATG10dir>/DAF/Search/versioned/sql/db_components/database-vendor/
versioned_refinement_ddl.sql

<ATG10dir>/DCS/Search/Versioned/sql/install/database-vendor/
dcs_search_versioned_ddl.sql

<ATG10dir>/DAF/Search/common/sql/db_components/database-vendor/
searchtesting_ddl.sql

For information about starting and working with the MySQL evaluation database, see MySQL Databases in the ATG Installation and Configuration Guide.