When you want to configure your database to work with ATG Business Commerce, configure the core ATG Commerce tables first, as described in Creating Tables for Core ATG Commerce. Then , you can create the ATG Business Commerce tables by running the b2bcommerce_ddl.sql
script from the following directory:
<ATG9dir>/B2BCommerce/sql/install/database-vendor
The b2bcommerce_ddl.sql
script executes subscripts in a particular order to create the schema used by the ATG Business Commerce product. Some subscripts are part of the core ATG Commerce product and are described in the Creating Tables for Core ATG Commerce section. The remaining subscripts are described in the table below. If necessary, you can run an individual subscript from the following directory:
<ATG9dir>/B2BCommerce/sql/db_components/
database-vendor
Script name | Description |
---|---|
| Creates tables for ATG Business Commerce order repository extensions |
| Creates tables for ATG Business Commerce product catalog extensions |
| Defines views for reporting |
| Creates tables for ATG Business Commerce profile extensions |
| Creates tables for the ATG Business Commerce contracts repository |
| Creates tables for the ATG Business Commerce invoice repository |
| Creates tables for ATG Business Commerce organization extensions |
Creating Motorprise Reference Application Tables
You can configure your database to work with the ATG Adaptive Scenario Engine, core ATG Commerce, ATG Business Commerce, and the Motorprise reference application by running a single script, motorpriseall_ddl.sql
, from the following directory:
<ATG9dir>/MotorpriseJSP/sql/install/
database-vendor
Alternatively, to configure just the database tables for the Motorprise reference application, run the motorprise_ddl.sql
script from the same directory.
The motorprise_ddl.sql
script is derived from the subscripts that are described in the Creating Tables for ATG Business Commerce section as well as other subscripts listed in the table below. If necessary, you can run these subscripts individually from the following directory:
<ATG9dir>/MotorpriseJSP/sql/db_components/
database-vendor
Script name | Purpose |
---|---|
| Creates tables for Motorprise profile extensions for authorization |
| Creates tables for Motorprise custom catalog extensions |
| Creates tables for Motorprise profile extensions for order details |
| Creates tables for the Motorprise product catalog extensions for German content |
| Creates tables for the Motorprise product catalog extensions for Japanese content |