Upgrade Guide

Database Changes for SP3

This appendix includes details about WebLogic Portal Version 8.1 database changes for SP3. For information on previous releases, consult your support representative as needed.

If desired, you can preview the changes that will be made to schema objects during the database upgrade to Service Pack 3. To do so, review the file 81sp3_alter_table.sql for the DBMS in which you are interested. You can find this file in the specific folder for your specific DBMS and version in the path WL_HOME\portal\db\<dbms>\<version>. For example:

C:\bea813\weblogic81\portal\db\pointbase\44

Virtual Content Management

The following tables are new in SP3:

CMV_NODE
CMV_NODE_ASSIGNED_ROLE
CMV_NODE_VERSION
CMV_NODE_VERSION_PROPERTY
CMV_PROPERTY
CMV_VALUE

Refer to the .sql files prefixed "cmv_" in the directory WL_HOME/portal/db for your DBMS to review the DDL for the Virtual Content Management tables.

See the Data Dictionary for details about these new tables:

http://download.oracle.com/docs/cd/E13218_01/wlp/docs81/db/4Schemas.html

For Virtual Content Management a new column named LIFECYCLE_STATUS is included in the CM_NODE table. LIFECYCLE_STATUS identifies the lifecycle status (for example, In Progress, Published, and so on) for this node. The default for new or existing nodes is 4, Published.

See the file named 81sp3_alter_tables.sql under WL_HOME/portal/db for your DBMS to view the DDL for this column addition.

Web Services for Remote Portlets (WSRP)

The following tables are new in SP3:

PF_CONSUMER_PORTLETS
PF_CONSUMER_PROPERTIES
PF_CONSUMER_REGISTRY
PF_PRODUCER_PROPERTIES
PF_PRODUCER_REGISTRY
PF_PROXY_PORTLET_INSTANCE

See the Data Dictionary for details about these new tables:

http://download.oracle.com/docs/cd/E13218_01/wlp/docs81/db/4Schemas.html

See the .sql files prefixed "wsrp_" under WL_HOME/portal/db for your DBMS to view the DDL for the Web Services Remote Portals tables.

WebLogic Commerce Services (CMV)

The following changes occurred in SP3:

In the tables WLCS_SAVED_ITEM_LIST and WLCS_SECURITY, some existing columns were changed to NOT NULL and Primary Keys were added.
OLD_WLCS_SECURITY and OLD_WLCS_SAVED_ITEM_LIST tables were created for data retention and can be manually dropped following a successful upgrade.

See the file named 81sp3_alter_tables.sql under WL_HOME/portal/db for your DBMS to review the DDL for the above changes.

Portal Framework

The following changes were made for each DBMS that WebLogic Portal supports.

The following index was added: IX1_MARKUP_DEF ON PF_MARKUP_DEFINITION
The following view was added: VIEW PF_PORTLET_HIERARCHY_V
The following _LABEL columns were expanded from VARCHAR(40) to VARCHAR(80):

PF_BOOK_DEFINITION.BOOK_LABEL
PF_LOOK_AND_FEEL_DEFINITION.LOOK_FEEL_LABEL
PF_PAGE_DEFINITION.PAGE_LABEL

See the file named 81sp3_alter_tables.sql under WL_HOME/portal/db for your DBMS to review the DDL for the above changes and additions.