Table Creation Subscripts

The bizui_all_ddl.sql script executes a number of subscripts:

ATG Content Administration Table Creation Scripts

The bizui_all_ddl.sql script executes the following subscripts in order to create and configure database tables for ATG Content Administration:

Script file name

Description

internal_user_profile_ddl.sql

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

publishing_ddl.sql

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

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.

These scripts are located in:

<ATG10dir>/Publishing/base/sql/db_components/db-vendor

Business Control Center Table Creation Scripts

The bizui_all_ddl.sql script executes viewmapping_ddl.sql to create and configure the database tables required by the Business Control Center. This subscript creates tables that are used by the View Mapping framework.

This script is located in:

<ATG10dir>/BIZUI/sql/db_components/db-vendor

Copyright © 1997, 2012 Oracle and/or its affiliates. All rights reserved.

Legal Notices