First, create the core ATG Commerce tables and then refer to the sections that follow for information on configuring the database tables that are specific to the version of ATG Commerce you are using. To create the database tables for core ATG Commerce, run the dcs_ddl.sql
script from the following directory:
<ATG9dir>/DCS/sql/install/
database-vendor
The dcs_ddl.sql
script is derived from the subscripts listed in the table below. If necessary, you can run these subscripts individually from the following directory:
<ATG9dir>/DCS/sql/db_components/
database-vendor
Script name | Purpose |
---|---|
| Configures the schema for the ATG Commerce Claimable repository |
| Creates tables for ATG Commerce credit card profile extensions |
| Creates a table for handling shopping cart events |
| Creates tables for the ATG Commerce inventory system |
| Creates tables for the ATG Commerce purchase process |
| Defines the tables that contain order markers |
| Creates tables for price lists |
| Creates tables for the ATG Commerce product catalog |
| Creates tables for ATG Commerce pricing promotions |
| Defines views for reporting |
| Defines additional views for reporting |
| Defines additional views for reporting |
| Defines additional views for reporting |
| Creates tables for ATG Commerce Giftlist services |
| Creates tables for ATG Commerce promotion profile extensions |