Skip navigation.
Downloads | Product Documentation | Support

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