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

b2b_order_ddl.sql

Creates tables for ATG Business Commerce order repository extensions

b2b_product_catalog_ddl.sql

Creates tables for ATG Business Commerce product catalog extensions

b2b_reporting_views.sql

Defines views for reporting

b2b_user_ddl.sql

Creates tables for ATG Business Commerce profile extensions

contracts_ddl.sql

Creates tables for the ATG Business Commerce contracts repository

invoice_ddl.sql

Creates tables for the ATG Business Commerce invoice repository

organization_ddl.sql

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:

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

b2b_auth_cc_ddl.sql

Creates tables for Motorprise profile extensions for authorization

b2b_custom_catalog_ddl.sql

Creates tables for Motorprise custom catalog extensions

b2b_user_orddet_ddl.sql

Creates tables for Motorprise profile extensions for order details

german_catalog_ddl.sql

Creates tables for the Motorprise product catalog extensions for German content

japanese_catalog_ddl.sql

Creates tables for the Motorprise product catalog extensions for Japanese content

 
loading table of contents...