WebSphere Commerce Version 8.0.1.0

Database schema changes from Version 8 to Version 8 Mod Pack 1

Database tables and columns within the WebSphere Commerce Version 8 Mod Pack 1 database schema can differ from the tables and columns in the database schema for WebSphere Commerce Version 8.

New tables

New tables in this version:

Changed tables

No tables are changed in this version.

Removed tables

No tables are removed in this version.

Deprecated tables

For the list of deprecated database tables, see Deprecated tables and columns.

Tables that include new columns

No existing tables include new columns in this version.

Tables that include changed columns

No existing tables include changed columns in this version.

Tables that include new or changed indexes

Indexes that are new or changed in this version:
Table Action Index name Index Uniqueness
CEDISPCONF Add I0001527 CATENTRY_ID + PROPERTY + CEDISPCTX_ID Unique
Add I0001528 CEDISPCTX_ID Non-unique
CEDISPCTX Add I0001529 CATGROUP_ID + STOREENT_ID + STARTTIME Non-unique
Add I0001530 STOREENT_ID Non-unique

Table relationships that are new or changed

Table relationships that are new or changed in this version:
Table Column Action Constraint name Foreign table Foreign column Constraint type
CEDISPCONF CEDISPCONF_ID Add P_0035 Primary key
CATENTRY_ID Add F_3773 CATENTRY CATENTRY_ID Cascade
CEDISPCTX_ID Add F_3774 CEDISPCTX CEDISPCTX_ID Cascade
CEDISPCTX CEDISPCTX_ID Add P_0036 Primary key
CATGROUP_ID Add F_3775 CATGROUP CATGROUP_ID Cascade
STOREENT_ID Add F_3776 STOREENT STOREENT_ID Cascade