Creating Database Tables for ATG Portal

The install file in the <ATG10dir>/Portal/install/database-vendor directory runs a set of scripts that create the required tables for the Portal Application Framework (PAF) and baseline gears.

Note: These scripts also create the tables for the Oracle ATG Web Commerce Adaptive Scenario Engine; you do not need to run the DAS, DPS, and DSS scripts separately. Note also that the install file uses the <ATG10dir>/Portal/install/minimal-data.xml file to create the minimum set of data structures necessary to run Oracle ATG Web Commerce Portal.

Use the following syntax to run the install file appropriate for your DBMS:

Note: Entering passwords as command line arguments entails some security risks. Do not enter passwords as command line arguments in situations where security is a top priority.

The table creation scripts for Oracle ATG Web Commerce Portal are located in the following directories:

<ATG10dir>/Portal/paf/sql/install/database-vendor
<ATG10dir>/Portal/gear_dir/sql/install/database-vendor

Note: These scripts use an Oracle ATG Web Commerce-specific JTDatasource and TransactionManager, and cannot be used with your application server’s data source or transaction manager.

Script name

Purpose

alert_ddl.sql

Creates tables for the Alerts Gear

bookmarks_ddl.sql

Creates tables for the Bookmarks Gear

calendar_ddl.sql

Creates tables for the Calendar Gear

communities_ddl.sql

Creates tables for the Communities Gear

discussion_ddl.sql

Creates tables for the Discussion Gear

docexch_ddl.sql

Creates tables for the Document Exchange Gear

membership_ddl.sql

Creates tables for storing membership requests

paf_mappers_ddl.sql

Creates tables used by sample mappers to record portal events

Portal_ddl.sql

Creates tables for the Portal Application Framework

poll_ddl.sql

Creates tables for the Poll Gear

profile_ddl.sql

Creates tables for storing profile data for personalized communities and pages

soapclient_ddl.sql

Creates tables for the Web Services Client Gear