Database schema changes from Version 8.0.1.0 to 8.0.2.0
Database tables and columns within the WebSphere Commerce Version 8.0.1.0 database schema can differ from the tables and columns in the database schema for WebSphere Commerce Version 8.0.2.0.
The database schema changes are grouped into the following categories:
New tables
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
Columns introduced 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 |
|---|---|---|---|---|
| CEDYNDISPCONF | Add | I0001536 | ATTRIBUTE + CEDYNDISPCTX_ID | Non-unique |
| Add | I0001537 | CEDYNDISPCTX_ID | Non-unique | |
| ORDEXTATTR | Add | I0001531 | NAME | Non-unique |
| Add | I0001532 | ORDERS_ID | Non-unique | |
| ORDITEMEXTATTR | Add | I0001533 | NAME | Non-unique |
| Add | I0001534 | ORDERITEMS_ID | Non-unique | |
| SRCH_CMDREG | Add | I0001540 | INTERFACENAME + TENANT_ID + STOREENT_ID | Non-unique |
| SRCH_COMPCONFIG | Add | I0001539 | TENANT_ID + COMP_ID + NAME | Non-unique |
| SRCH_KEYS | Add | I0001544 | SEQ_NAME | Non-unique |
| SRCH_SCHACTIVE | Add | I0001542 | SCSPREFSTART + SCSJOBNBR | Non-unique |
| SRCH_SCHBRDCST | Add | I0001541 | JOBREFNUM + CLONEID | Non-unique |
| SRCH_SCHSTATUS | Add | I0001543 | SCSPREFSTART + SCSJOBNBR | Non-unique |
| STAGLOG | Add | I0001538 | STGTABLE + STGPROCESSED + STGRFNBR + STGSTMP | Unique |
| USERREG | Add | I0001535 | IBMID | 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 |
|---|---|---|---|---|---|---|
| CEDYNDISPCONF | CEDYNDISPCONF_ID | Add | P_0042 | Primary key | ||
| CEDYNDISPCTX_ID | Add | F_3781 | CEDYNDISPCTX | CEDYNDISPCTX_ID | Cascade | |
| CEDYNDISPCTX | CEDYNDISPCTX_ID | Add | P_0041 | Primary key | ||
| CATGROUP_ID | Add | F_3779 | CATGROUP | CATGROUP_ID | Cascade | |
| STOREENT_ID | Add | F_3780 | STOREENT | STOREENT_ID | Cascade | |
| FILTER | FILTER_ID | Add | P_0040 | Primary key | ||
| ORDEXTATTR | ORDEXTATTR_ID | Add | P_0037 | Primary key | ||
| ORDERS_ID | Add | F_3777 | ORDERS | ORDERS_ID | Cascade | |
| ORDITEMEXTATTR | ORDITEMEXTATTR_ID | Add | P_0038 | Primary key | ||
| ORDERITEMS_ID | Add | F_3778 | ORDERITEMS | ORDERITEMS_ID | Cascade | |
| SRCH_CMDREG | SRCH_CMDREG_ID | Add | P_0044 | Primary key | ||
| SRCH_COMPCONFIG | SRCH_COMPCONFIG_ID | Add | P_0043 | Primary key | ||
| SRCH_KEYS | SRCH_KEYS_ID | Add | P_0050 | Primary key | ||
| SRCH_SCHACTIVE | SCSINSTREFNUM | Add | P_0045 | Primary key | ||
| SRCH_SCHBRDCST | SRCH_SCHBRDCST_ID | Add | P_0046 | Primary key | ||
| SRCH_SCHCONFIG | SCCJOBREFNUM | Add | P_0047 | Primary key | ||
| SRCH_SCHERRLOG | SCSINSTREFNUM | Add | P_0048 | Primary key | ||
| SRCH_SCHSTATUS | SCSINSTREFNUM | Add | P_0049 | Primary key | ||
| UECONFIG | UECONFIG_ID | Add | P_0039 | Primary key |