Create ATG Content Administration Tables

This section describes how to create and configure the tables for the versioned database. For descriptions of the ATG Content Administration database tables, see Appendix A, Database Schema.

Note: If you run MS SQL Server, before running the scripts referenced in this section, make sure that you are the owner of the database and that its compatibility level is set to 80.

To install and configure database tables, run this global script:

<ATG2007.3dir>/BIZUI/sql/install/db-vendor/bizui_all_ddl.sql

This script installs all tables necessary to run ATG Content Administration and ATG Business Control Center, including tables for Adaptive Scenario Engine and ATG Portal.

For information on ATG Adaptive Scenario Engine and ATG Portals tables, see the discussion on configuring databases in the ATG Installation and Configuration Guide. You can find information here on the subscripts you can run to install only the tables required for these products, which are also subscripts execute by bizui_all_ddl.sql. If your product suite includes any ATG Applications, see your application’s manual to locate its creation scripts.

ATG Content Administration Database Creation Scripts

The bizui_all_ddl.sql script executes the following individual subscripts in order to create and configure the database tables for ATG Content Administration. A copy of each subscript is located in the <ATG2007.3dir>/Publishing/base/sql/db_components/db-vendor directory for the appropriate database.

File Name

Description

media_ddl.sql

Creates tables for storing media for ATG Content Administration.

publishing_ddl.sql

Creates tables for the /atg/epub/PublishingRepository, which stores process, and deployment topology information.

user_profile_ddl.sql

Creates tables for the extensions to the user profile specifically for ATG Content Administration.

versioned_file_repository_ddl.sql

Creates the tables for the /atg/epub/file/PublishingFileRepository, the versioned repository that is provided for storing file asset metadata.

versioned_process_data_ddl.sql

Creates the tables for the /atg/epub/process/ProcessDataRepository, the versioned repository that is provided for storing information about ATG Content Administration processes.

versionmanager_ddl.sql

Creates tables for storing versioning information.

workflow_ddl.sql

Creates tables for storing workflow information in the /atg/epub/PublishingRepository.

ATG Business Control Center Database Creation Scripts

The bizui_all_ddl.sql script executes viewmapping_ddl.sql to create and configure the database tables required by the ATG Business Control Center. A copy of this script exists in the <ATG2007.3dir>/BIZUI/sql/db_components/db-vendor directory. This subscript creates tables used by the View Mapping framework.

 
loading table of contents...