Database Administration Guide

WebLogic Portal DDL Modules

WebLogic Portal Database Definition Language (DDL) modules are provided in directories with the following format:

WL_HOME/portal/db/dbms_name/dbms_version

For example:

WL_HOME/portal/db/pointbase/44

WL_HOME/portal/db/oracle/817

WL_HOME/portal/db/oracle/9i

Note: The same WebLogic Portal DDL is used for both Oracle 8.1.7 and 9i databases as indicated by a readme.txt file in the oracle/9i directory.This directory naming structure offers the ability to have distinct DDL between DBMS versions.

Data inserts for bootstrap data that must be inserted into tables in each WebLogic Portal database are contained in the following:

WL_HOME/portal/db/data/required/xx_insert_system_required_data.sql

WebLogic Portal DDL is provided in files named as follows:

xx_create_fkeys.sql

xx_create_indexes.sql

xx_create_tables.sql

xx_create_triggers.sql

xx_create_views.sql

xx_drop_constraints.sql

xx_drop_fkeys.sql

xx_drop_indexes.sql

xx_drop_tables.sql

xx_drop_views.sql

where the xx is a prefix from the table below:

Prefix	Description
au	Anonymous user
bt	Behavior Tracking
cm	Content Management
cmv	Content Management Versioning
collaboration*	Compoze portlets
ds	Data synchronization
er	Entitlement Reference
p13n	WebLogic Portal Personalization
pf	WebLogic Portal Framework and Localization
sample_cm	Content Management types data
wlcs	WebLogic Commerce Services
wps	WebLogic Portal Services
wsrp	Web Services for Remote Portlets

* Database object definitions for portlets from Compoze Software