Database schema changes from Version 8 to Version 9
Database tables and columns within the HCL Commerce Version 9 database schema can differ from the tables and columns in the database schema for HCL Commerce Version 8.
The database schema changes from HCL Commerce
Version 8 to HCL Commerce Version 8.0 are
grouped into the following categories:
Tables that are added since Version 9
Tables added in HCL Commerce Version 9
Tables added with HCL Commerce Version 8 Mod
Pack 1
Tables added with HCL Commerce Version 8.0.2.0
Tables added with HCL Commerce Version 8 Mod
Pack 3
- No new tables added in this version,
Tables added with HCL Commerce Version 8 Mod
Pack 4
Tables that are changed since Version 9
No tables are changed in this version.
Tables that are removed since Version 9
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 HCL Commerce Version 9
- MSGARCHIVE.MSGDATECREATED
- MSGSTORE.MSGDATECREATED
- SCHSTATUS.SCSPROGRESS
- SCHSTATUS.SCSPROGRESSMSG
- SCHSTATUS.SCSREASONCODE
- SCHSTATUS.SCSLASTUPDATE
- SCHSTATUS.SCSPROGRESS
- SCHSTATUS.SCSREASONCODE
- SCHSTATUS.SCSPROGRESSMSG
- SRCH_SCHSTATUS.SCSPROGRESSMSG
- SRCH_SCHSTATUS.SCSPROGRESS
- SRCH_SCHSTATUS.SCSREASONCODE
- SRCH_SCHSTATUS.SCSACTLSTART
Columns introduced with HCL Commerce Version
8 Mod Pack 1
- No existing tables include new columns in this version.
Columns introduced with HCL Commerce Version 8.0.2.0
Columns introduced with HCL Commerce Version
8 Mod Pack 3
Columns introduced with HCL Commerce Version
8 Mod Pack 4
Tables that include changed columns
Columns that are changed with HCL Commerce
Version 9
- All tables in HCL Commerce Version 9 have
been altered to include a NOT NULL constraint to the OPTCOUNTER column. That is, for every
table:
ALTER TABLE table_name ALTER COLUMN optcounter SET NOT NULL;
Columns that are changed with HCL Commerce
Version 8 Mod Pack 1
- No existing tables include changed columns in this version.
Columns that are changed with HCL Commerce
Version 8.0.2.0
- No existing tables include changed columns in this version.
Columns that are changed with HCL Commerce
Version 8 Mod Pack 3
- No existing tables include changed columns in this version.
Columns that are changed with HCL Commerce
Version 8 Mod Pack 4
- KEYS.TABLENAME - SET DATA TYPE VARCHAR(30)
- KEYS.COLUMNNAME - SET DATA TYPE VARCHAR(30)
- STAGLOG.STGTABLE - SET DATA TYPE CHAR(30)
- STGMERTAB.TABNAME - SET DATA TYPE CHAR(30)
- STGMRSTTAB.COLNAME - SET DATA TYPE CHAR(30)
- STGMRSTTAB.TABNAME - SET DATA TYPE CHAR(30)
- STGSITETAB.TABNAME - SET DATA TYPE CHAR(30)
Tables that include new or changed indexes
Indexes that are new or changed with HCL Commerce Version 9
- No existing tables include changed indexes in this version.
Indexes that are new or changed with HCL Commerce Version 8 Mod Pack 1
| 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 |
Indexes that are new or changed with HCL Commerce Version 8.0.2.0
| 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 |
Indexes that are new or changed with HCL Commerce Version 8 Mod Pack 3
| Table | Action | Index name | Index | Uniqueness |
|---|---|---|---|---|
| CATGPENREL | Add | I0001546 | CATGROUP_ID + CATALOG_ID + CATENTRY_ID | Non-unique |
Indexes that are new or changed with HCL Commerce Version 8 Mod Pack 4
| Table | Action | Index name | Index | Uniqueness |
|---|---|---|---|---|
| CATENTRY_EXTERNAL_CONTENT_REL | Add | I0001551 | CATENTRY_ID + CONTENT_ID + CATOVRGRP_ID + LANGUAGE_ID | Unique |
| Add | I0001549 | CONTENT_ID | Non-unique | |
| Add | I0001550 | CATENTRY_ID | Non-unique | |
| CATGROUP_EXTERNAL_CONTENT_REL | Add | I0001554 | CATGROUP_ID + CONTENT_ID + CATOVRGRP_ID + LANGUAGE_ID | Unique |
| Add | I0001552 | CONTENT_ID | Non-unique | |
| Add | I0001553 | CATGROUP_ID | Non-unique | |
| EXTERNAL_CONTENT | Add | I0001547 | TYPE | Non-unique |
| EXTERNAL_CONTENT_ASSET | Add | I0001548 | CONTENT_ID | Non-unique |
Table relationships that are new or changed
Table relationships that are new or changed with HCL Commerce Version 9
- No table relationships are new or changed in this version.
Table relationships that are new or changed with HCL Commerce Version 8 Mod Pack 1
| 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 |
Table relationships that are new or changed with HCL Commerce Version 8.0.2.0
| 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 |
Table relationships that are new or changed with HCL Commerce Version 8 Mod Pack 3
- No table relationships are new or changed in this version.
Table relationships that are new or changed with HCL Commerce Version 8 Mod Pack 4
| Table | Column | Action | Constraint name | Foreign table | Foreign column | Constraint type |
|---|---|---|---|---|---|---|
| CATENTRY_EXTERNAL_CONTENT_REL | CE_EXTERNAL_CONTENT_REL_ID | Add | P_0054 | Primary key | ||
| CONTENT_ID | Add | F_3784 | EXTERNAL_CONTENT | CONTENT_ID | Cascade | |
| CATENTRY_ID | Add | F_3785 | CATENTRY | CATENTRY_ID | Cascade | |
| TYPE | Add | F_3786 | EXTERNAL_CONTENT_TYPE | IDENTIFIER | ||
| CATGROUP_EXTERNAL_CONTENT_REL | CG_EXTERNAL_CONTENT_REL_ID | Add | P_0055 | Primary key | ||
| CONTENT_ID | Add | F_3787 | EXTERNAL_CONTENT | CONTENT_ID | Cascade | |
| CATGROUP_ID | Add | F_3788 | CATGROUP | CATGROUP_ID | Cascade | |
| TYPE | Add | F_3789 | EXTERNAL_CONTENT_TYPE | IDENTIFIER | Cascade | |
| EXTERNAL_CONTENT | CONTENT_ID | Add | P_0052 | Primary key | ||
| TYPE | Add | F_3782 | EXTERNAL_CONTENT_TYPE | IDENTIFIER | Cascade | |
| EXTERNAL_CONTENT_ASSET | ASSETNAME, CONTENT_ID | Add | P_0053 | Primary key | ||
| CONTENT_ID | Add | F_3783 | EXTERNAL_CONTENT | CONTENT_ID | Cascade | |
| EXTERNAL_CONTENT_TYPE | IDENTIFIER | Add | P_0051 | Primary key |