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.

Tables that are added since Version 9

Tables added with HCL Commerce Version 8 Mod Pack 1
Tables added with HCL Commerce Version 8 Mod Pack 3
  • No new tables added in this version,

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 with HCL Commerce Version 8 Mod Pack 1
  • No existing tables include new columns in this version.
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

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