The versioned versions of Commerce tables have additional columns to store data for versioned assets. Merchandising requires the versioned tables.
To create versioned Commerce tables and versioned catalog tables on a production-ready or evaluation database, run the following scripts:
<ATG10dir>/DCS/Versioned/sql/install/database-vendor/dcs_versioned_ddl.sql<ATG10dir>/DAF/Search/Index/sql/db_components/database-vendor/
search_ddl.sql
<ATG10dir>/DAF/Search/Versioned/sql/db_components/database-vendor/
versioned_search_site_ddl.sql
<ATG10dir>/DAF/Search/Routing/sql/db_components/database-vendor/
routing_ddl.sql
For information about starting and working with the MySQL evaluation database, see MySQL Databases in the ATG Installation and Configuration Guide.
