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 databases 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
collaboration*	Compoze portlets
doc**	Document management
ds	Data synchronization
er**	Entitlement ruleset
p13n	WebLogic Portal Personalization
pf	WebLogic Portal Framework and Localization
portal**	WebLogic Portal 7.0
sample_cm	Content Management types data
sample_portal**	Sample Portal 7.0
wlcs	WebLogic Commerce Services
wps	WebLogic Portal Services

Table notes:

* Database object definitions for portlets from Compoze Software

** Database object definitions for WebLogic Portal 7.0 which has been retained for Compatibility Mode