Database schema changes from Version 8 to Version 9

Database tables and columns within the WebSphere Commerce Version 9 database schema can differ from the tables and columns in the database schema for WebSphere Commerce Version 8. The database schema changes from WebSphere Commerce Version 8 to WebSphere Commerce Version 8.0 are grouped into the following categories:

• Tables that are added since Version 9

• Tables that are removed since Version 9

• Deprecated tables

• Tables that include new columns

• Tables that include changed columns

• Tables that include new or changed indexes

• Table relationships that are new or changed

Tables that are added since Version 9

Tables added in WebSphere Commerce Version 9

• ATTR_EXTERNAL_CONTENT_REL

• JOBSTATUS

• JOBSUMMARY

• SCHREPORT

• SRCH_SCHREPORT

• TI_DELTA_CATENTRY

• TI_DELTA_CATGROUP

• TI_DELTA_INVENTORY

Tables added with WebSphere Commerce Version 8 Mod Pack 1

• CEDISPCONF

• CEDISPCTX

Tables added with WebSphere Commerce Version 8.0.2.0

• CEDYNDISPCONF

• CEDYNDISPCTX

• FILTER

• ORDEXTATTR

• ORDITEMEXTATTR

• SRCH_CMDREG

• SRCH_COMPCONFIG

• SRCH_KEYS

• SRCH_SCHACTIVE

• SRCH_SCHBRDCST

• SRCH_SCHCONFIG

• SRCH_SCHERRLOG

• SRCH_SCHSTATUS

• UECONFIG

Tables added with WebSphere Commerce Version 8 Mod Pack 3

• No new tables added in this version,

Tables added with WebSphere 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 WebSphere 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 WebSphere Commerce Version 8 Mod Pack 1

• No existing tables include new columns in this version.

Columns introduced with WebSphere Commerce Version 8.0.2.0

• CEDISPCTX.DISPLAYMODE

• CEDISPCTX.FIELDID

• CEDISPCTX.LASTUPDATE

• KEYS.MULTIPLIER

• KEYS.NONSEQUENTIAL

• USERREG.IBMID

Columns introduced with WebSphere Commerce Version 8 Mod Pack 3

• CATGPENREL.FIELD1

• CATGPENREL.FIELD2

• CATGPENREL.FIELD3

• MBRGRP.ALLOWEXPORT

• MBRGRP.EXPORTALL

Columns introduced with WebSphere Commerce Version 8 Mod Pack 4

• SCHCONFIG.SCCDESCRIPTION

Tables that include changed columns

Columns that are changed with WebSphere Commerce Version 9

• All tables in WebSphere 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 WebSphere Commerce Version 8 Mod Pack 1

• No existing tables include changed columns in this version.

Columns that are changed with WebSphere Commerce Version 8.0.2.0

• No existing tables include changed columns in this version.

Columns that are changed with WebSphere Commerce Version 8 Mod Pack 3

• No existing tables include changed columns in this version.

Columns that are changed with WebSphere 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 WebSphere Commerce Version 9

• No existing tables include changed indexes in this version.

Indexes that are new or changed with WebSphere 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 WebSphere 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 WebSphere 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 WebSphere Commerce Version 8 Mod Pack 4

Table	Action	Index name	Index	Uniqueness
	Add	I0001551	CATENTRY_ID + CONTENT_ID + CATOVRGRP_ID + LANGUAGE_ID	Unique
	Add	I0001549	CONTENT_ID	Non-unique
	Add	I0001550	CATENTRY_ID	Non-unique
	Add	I0001554	CATGROUP_ID + CONTENT_ID + CATOVRGRP_ID + LANGUAGE_ID	Unique
	Add	I0001552	CONTENT_ID	Non-unique
	Add	I0001553	CATGROUP_ID	Non-unique
	Add	I0001547	TYPE	Non-unique
	Add	I0001548	CONTENT_ID	Non-unique

Table relationships that are new or changed

Table relationships that are new or changed with WebSphere Commerce Version 9

• No table relationships are new or changed in this version.

Table relationships that are new or changed with WebSphere 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 WebSphere 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 WebSphere Commerce Version 8 Mod Pack 3

• No table relationships are new or changed in this version.

Table relationships that are new or changed with WebSphere Commerce Version 8 Mod Pack 4

Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
	CE_EXTERNAL_CONTENT_REL_ID	Add	P_0054			Primary key
	CONTENT_ID	Add	F_3784		CONTENT_ID	Cascade
	CATENTRY_ID	Add	F_3785	CATENTRY	CATENTRY_ID	Cascade
	TYPE	Add	F_3786		IDENTIFIER
	CG_EXTERNAL_CONTENT_REL_ID	Add	P_0055			Primary key
	CONTENT_ID	Add	F_3787		CONTENT_ID	Cascade
	CATGROUP_ID	Add	F_3788	CATGROUP	CATGROUP_ID	Cascade
	TYPE	Add	F_3789		IDENTIFIER	Cascade
	CONTENT_ID	Add	P_0052			Primary key
	TYPE	Add	F_3782		IDENTIFIER	Cascade
	ASSETNAME, CONTENT_ID	Add	P_0053			Primary key
	CONTENT_ID	Add	F_3783		CONTENT_ID	Cascade
	IDENTIFIER	Add	P_0051			Primary key

Related concepts
WebSphere Commerce database schema