Database schema changes from Version 7 to Version 8

Database tables and columns within the WebSphere Commerce Version 8.0 database schema can differ from the tables and columns in the database schema for WebSphere Commerce Version 7.

The database schema changes from WebSphere Commerce Version 7 to WebSphere Commerce Version 8.0 are grouped into the following categories:

Tables that are added since Version 7
Tables that are removed since Version 7
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 7

Tables added in WebSphere Commerce Version 8

Tables added with WebSphere Commerce Version 7 Feature Pack 8

CATGRPRULE

Tables added with WebSphere Commerce Version 7 Feature Pack 7

Tables added with WebSphere Commerce Version 7 Feature Pack 6

Tables added with WebSphere Commerce Version 7 Feature Pack 5

Tables added with WebSphere Commerce Version 7 Feature Pack 4

Tables added with WebSphere Commerce Version 7 Feature Pack 3

Tables added with WebSphere Commerce Version 7 Feature Pack 2

Tables added with WebSphere Commerce Version 7 Feature Pack 1

Tables added with WebSphere Commerce Version 7 Fix Pack 9

ORDAUDIT

Tables added with WebSphere Commerce Version 7 Fix Pack 7

PREVIEWTOKEN

Tables that are changed since Version 7

Tables that are changed with WebSphere Commerce Version 7 Fix Pack 7

Tables that are changed with WebSphere Commerce Version 7 Fix Pack 2

ATCHAST

Tables that are removed since Version 7

SRCHSTATS - Removed with WebSphere Commerce Version 7 Feature Pack 3

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 8

PAGELAYOUT.MANAGINGTOOL

Columns introduced with WebSphere Commerce Version 7 Feature Pack 7

Columns introduced with WebSphere Commerce Version 7 Feature Pack 6

Columns introduced with WebSphere Commerce Version 7 Fix Pack 9

Columns introduced with WebSphere Commerce Version 7 Fix Pack 8

Columns introduced with WebSphere Commerce Version 7 Fix Pack 7

ATTR.MERCHANDISABLE

Columns introduced with WebSphere Commerce Version 7 Fix Pack 6

Columns introduced with WebSphere Commerce Version 7 Fix Pack 5

Columns introduced with WebSphere Commerce Version 7 Fix Pack 3

CATCONFINF.CONFIGURATION

Columns introduced with WebSphere Commerce Version 7 Fix Pack 2

Tables that include changed columns

Columns that are changed with WebSphere Commerce Version 8

STAGLOG.STGFILTER - set data type to BIGINT

Columns that are changed with WebSphere Commerce Version 7 Feature Pack 7

PAGELAYOUT.PAGELAYOUTTYPE_ID - drop NOT NULL

Columns that are changed with WebSphere Commerce Version 7 Feature Pack 6

SRCHCONFEXT.LANGUAGE_ID - drop NOT NULL

Columns that are changed with WebSphere Commerce Version 7 Fix Pack 8

EMSPOT.NAME - set data type to VARCHAR(256)
EMSPOT.UP_NAME - set GENERATED ALWAYS AS (UPPER(NAME))
EMSPOT.UP_NAME - set data type to VARCHAR(256)
EMSPOT.UP_NAME - drop EXPRESSION
PPCPAYINST.ACCOUNTNUMBER - set data type to VARCHAR (512)

Columns that are changed with WebSphere Commerce Version 7 Fix Pack 7

COLLATERAL.NAME - set data type to VARCHAR (256)
COLLATERAL.UP_NAME - set data type to VARCHAR(256)
COLLATERAL.UP_NAME - drop EXPRESSION
COLLATERAL.UP_NAME - set GENERATED ALWAYS AS (UPPER(NAME))
COLLATERAL.URL - set data type to VARCHAR(1024)
SCHBRDCST.CLONEID - set data type to VARCHAR(256)

Columns that are changed with WebSphere Commerce Version 7 Fix Pack 5

ADDRESS.ADDRESS1 set data type to VARCHAR(256)
ADDRESS.ADDRESS2 set data type to VARCHAR(128)
ADDRESS.ADDRESS3 set data type to VARCHAR(128)
STADDRESS.ADDRESS1 set data type to VARCHAR(256)
STADDRESS.ADDRESS2 set data type to VARCHAR(128)
STADDRESS.ADDRESS3 set data type to VARCHAR(128)

Columns that are changed with WebSphere Commerce Version 7 Fix Pack 2

ATCHAST.UP_ATCHASTPATH drop EXPRESSION
ATCHAST.ATCHASTPATH set data type to VARCHAR(256)
ATCHAST.UP_ATCHASTPATH set data type to VARCHAR(256) and set GENERATED ALWAYS AS (UPPER(atchastpath))
DMTRIGSND.PERSONALIZATIONID set data type to VARCHAR(64)

Columns that are changed with WebSphere Commerce Version 7 Fix Pack 1

GRGFTREG.NAME set data type to VARCHAR(64)
GRGFTREG.DESCRIPTION set data type to VARCHAR(254)

Tables that include new or changed indexes

Indexes that are new or changed with WebSphere Commerce Version 8


Table	Action	Index name	Index	Uniqueness
PAGELAYOUT	Delete	I0001443	NAME + MEMBER_ID	Unique
	Delete	I0001444	NAME + STOREENT_ID	Unique
	Add	I0001443	NAME + MEMBER_ID + MANAGINGTOOL	Unique
	Add	I0001444	NAME + STOREENT_ID + MANAGINGTOOL	Unique
PLLOCSTATIC	Add	I0001523	PAGELAYOUT_ID	Unique
PLPROPERTY	Add	I0001524	NAME + VALUE + PAGELAYOUT_ID	Unique
PX_PROMOTION	Add	I0001525	STATUS + CDREQUIRED + TYPE + STARTDATE + ENDDATE	Non-unique

Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 8


Table	Action	Index name	Index	Uniqueness
CATGRPRULE	Add	I0001520	DMACTIVITY_ID	Non-unique

Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 7


Table	Action	Index name	Index	Uniqueness
EXPRESSION	Add	I0001517	TRADING_ID	Non-unique
EXPRESSION	Add	I0001518	CATFILTER_ID	Non-unique
PLLOCATION	Add	I0001496	PAGELAYOUT_ID + DMACTIVITY_ID	Unique
PLLOCATION	Add	I0001497	DMACTIVITY_ID	Non-unique
PLPAGE	Add	I0001492	ADMINNAME + MEMBER_ID	Unique
	Add	I0001493	ADMINNAME + STOREENT_ID	Unique
	Add	I0001494	STOREENT_ID + PAGELAYOUTTYPE_ID	Non-unique
	Add	I0001495	PAGELAYOUTTYPE_ID	Non-unique
PLSTOREWIDGET	Add	I0001512	PLWIDGETDEF_ID + STOREENT_ID	Unique
PLSTOREWIDGET	Add	I0001513	STOREENT_ID	Non-unique
PLTEMPLATEREL	Add	I0001509	TEMPLATE_ID	Non-unique
PLWIDGET	Add	I0001489	PAGELAYOUT_ID + ADMINNAME	Unique
PLWIDGET	Add	I0001514	PLWIDGETDEF_ID	Non-unique
PLWIDGETDEF	Add	I0001488	IDENTIFIER + STOREENT_ID	Unique
PLWIDGETDEF	Add	I0001511	STOREENT_ID	Non-unique
PLWIDGETNVP	Add	I0001491	NAME + VALUE + PLWIDGET_ID	Unique
PLWIDGETNVP	Add	I0001519	PLWIDGET_ID	Non-unique
PLWIDGETREL	Add	I0001516	PLWIDGET_ID_PARENT	Non-unique
PLWIDGETSLOT	Add	I0001490	PAGELAYOUT_ID + ADMINNAME	Unique
PLWIDGETSLOT	Add	I0001515	PLWIDGET_ID	Non-unique

Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 6


Table	Action	Index name	Index	Uniqueness
COLLIMGMAPAREA	Add	I0001485	COLLATERAL_ID + LANGUAGE_ID + COORDINATES	Unique
COLLIMGMAPAREA	Add	I0001486	LANGUAGE_ID	Non-unique
DMEMSPOTCOLLDEF	Add	I0001483	EMSPOT_ID + STOREENT_ID + COLLATERAL_ID	Unique
DMEMSPOTCOLLDEF	Add	I0001484	COLLATERAL_ID	Non-unique
PX_CDPOOL	Delete	I0001313	CODE + STORE_ID	Unique
PX_CDPOOL	Add	I0001313	CODE + STORE_ID + INTERNAL_ID	Unique
SRCHATTRDESC	Add	I0001487	LANGUAGE_ID	Non-unique
	Add	IPF00034	UP_DISPLAYNAME	Non-unique
	Add	IPF00035	UP_DESCRIPTION	Non-unique
SRCHPROPRELV	Add	I0001498	INDEXFIELD + CATGROUP_ID + STOREENT_ID + CATALOG_ID	Unique
	Add	I0001499	CATALOG_ID	Non-unique
	Add	I0001503	STOREENT_ID	Non-unique
	Add	I0001504	CATGROUP_ID + STOREENT_ID + CATALOG_ID	Non-unique

Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 5


Table	Action	Index name	Index	Uniqueness
ATTRDICTSRCHCONF	Add	I0001471	ATTR_ID	Non-unique
	Add	I0001472	ATTRTYPE_ID	Non-unique
	Add	I0001473	MASTERCATALOG_ID	Non-unique
CATENTDESCOVR	Add	I0001446	CATENTRY_ID + LANGUAGE_ID + CATOVRGRP_ID	Unique
	Add	I0001447	LANGUAGE_ID	Non-unique
	Add	I0001448	CATOVRGRP_ID	Non-unique
	Add	I0001449	CATENTRY_ID + CATOVRGRP_ID	Non-unique
	Add	IPF00031	UP_NAME	Non-unique
CATOVRGRP	Add	I0001450	IDENTIFIER + MEMBER_ID	Unique
	Add	I0001451	STOREENT_ID	Non-unique
		IPF00032	UP_IDENTIFIER	Non-unique
FACET	Add	I0001476	ATTR_ID	Non-unique
	Add	I0001477	SRCHATTR_ID	Non-unique
	Add	I0001478	STOREENT_ID + KEYWORD_SEARCH	Non-unique
FACETCATGRP	Add	I0001479	FACET_ID + CATGROUP_ID + STOREENT_ID	Unique
	Add	I0001480	STOREENT_ID	Non-unique
	Add	I0001481	CATGROUP_ID	Non-unique
FACETDESC	Add	I0001482	LANGUAGE_ID	Non-unique
FOLDER	Add	I0001453	PARENTFOLDER_ID + TYPE + IDENTIFIER + STOREENT_ID + MEMBER_ID +	Unique
	Add	I0001454	STOREENT_ID + IDENTIFIER	Non-unique
		IPF00033	UP_IDENTIFIER	Non-unique
FOLDERITEM	Add	I0001455	FOLDERITEMTYPE	Non-unique
	Add	I0001456	FOLDER_ID + FOLDERITEMTYPE + REFERENCE_ID	Unique
	Add	I0001461	STOREENT_ID	Non-unique
PAGELAYOUT	Add	I0001443	NAME + MEMBER_ID	Unique
	Add	I0001444	NAME + STOREENT_ID	Unique
	Add	I0001445	STOREENT_ID + PAGELAYOUTTYPE_ID	Not uniuqe
	Add	IPF00030	UP_NAME	Non-unique
SRCHATTR	Add	I0001474	INDEXTYPE	Non-unique
SRCHATTRPROP	Add	I0001475	PROPERTYNAME + PROPERTYVALUE	Non-unique
STORECATOVRGRP	Add	I0001452	STOREENT_ID	Non-unique
STOREDEFCAT	Add	I0001439	STOREENT_ID + CATALOG_ID	Non-unique
STOREDEFCAT	Add	I0001440	CATALOG_ID	Non-unique

Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 4


Table	Action	Index name	Index	Uniqueness
CLIENTLOCATION	Add	I0001438	MODIFICATIONTIME + CREATIONTIME	Non-unique
POIDESC	Add	I0001437	POINTOFINTEREST_ID + LANGUAGE_ID	Unique
POINTOFINTEREST	Add	I0001434	PROGRAM_ID + STORE_ID + IDENTIFIER	Unique
	Add	I0001435	PROGRAM_ID + STORE_ID + POITYPE + LATITUDE + LONGITUDE + ALTITUDE	Non-unique
	Add	I0001436	PROGRAM_ID + STORE_ID + POITYPE + REGION_ID + ZONE_ID + CELL_ID + POINT_ID	Unique

Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 3


Table	Action	Index name	Index	Uniqueness
CMEXTDATA	Add	I0001431	CMPRMYOBJ_ID	Non-unique
CMEXTDATA	Add	I0001432	ATTRIBUTENAME + ATTRIBUTEVALUE + CMPRMYOBJ_ID	Non-unique
CMPRMYOBJ	Add	I0001416	WORKSPACE + TASKGRP + NOUN + OBJECT_ID + STOREENT_ID	Unique
	Add	I0001418	STATUS + LASTUPDATE	Non-unique
	Add	I0001419	LASTUPDATE + NOUN + STOREENT_ID + WORKSPACE + ACTION + SOURCE	Non-unique
	Add	I0001427	NOUN + OBJECT_ID	Non-unique
	Add	I0001428	STOREENT_ID	Non-unique
OICONFIG	Add	I0001412	ORDERITEMS_ID	Unique
SEOPAGEDEF	Add	I0001409	PAGENAME + STOREENT_ID	Unique
SEOPAGEDEF	Add	I0001410	STOREENT_ID	Non-unique
SEOPAGEDEFDESC	Add	I0001411	LANGUAGE_ID	Non-unique
SEOPAGEDEFOVR	Add	I0001413	SEOPAGEDEF_ID + OBJECTTYPE + OBJECT_ID	Unique
SEOPAGEDEFSUBPARAM	Add	I0001415	STOREENT_ID	Non-unique
SEOREDIRECT	Add	I0001414	SEOURLKWD_ID_NEW	Non-unique
SEOREDIRECT	Add	I0001424	SEOURLKWD_ID_ORIG	Non-unique
SEOTOKENUSGTYPE	Add	I0001425	TOKENUSGTYPE + STOREENT_ID	Unique
SEOTOKENUSGTYPE	Add	I0001426	STOREENT_ID	Non-unique
SEOURL	Add	I0001429	TOKENVALUE + TOKENNAME + SEOURL_ID	Unique
SEOURLKEYWORD	Add	I0001417	URLKEYWORD + STOREENT_ID	Unique
	Add	I0001420	SEOURL_ID	Non-unique
	Add	I0001421	STOREENT_ID	Non-unique
	Add	I0001430	LANGUAGE_ID	Non-unique
	Add	I0001433	MOBILEURLKEYWORD + STOREENT_ID	Non-unique
SRCHCONFEXT	Add	I0001422	INDEXSCOPE + INDEXTYPE + LANGUAGE + INDEXSUBTYPE	Unique
SRCHCONFEXT	Add	I0001423	LANGUAGE_ID	Non-unique
SRCHSTAT	Add	I0001391	KEYWORD + LANGUAGE_ID + STOREENT_ID + KEYWORDCOUNT + LOGDATE + SEARCHCOUNT + SUGGESTION	Non-unique
SRCHSTAT	Add	I0001392	STOREENT_ID + LOGDATE	Non-unique
SRCHSTATS	Delete	I0001391		Non-unique
SRCHSTATS	Delete	I0001392	STOREENT_ID	Non-unique

Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 2


Table	Action	Index name	Index	Uniqueness
CATENTSUBS	Add	I0001358	SUBSCPTYPE_ID	Non-unique
CATFILTER	Add	I0001373	STOREENT_ID + IDENTIFIER + CATALOG_ID	Unique
	Add	I0001374	STOREENT_ID + CATALOG_ID	Non-unique
	Add	I0001375	CATALOG_ID	Non-unique
CFCATGROUP	Add	I0001379	CATFILTER_ID + CATGROUP_ID	Unique
CFCATGROUP	Add	I0001387	CATGROUP_ID	Non-unique
CFCOND	Add	I0001380	CFCONDGRP_ID	Non-unique
CFCOND	Add	I0001381	ATTR_ID	Non-unique
CFCONDGRP	Add	I0001378	CFCATGROUP_ID + IDENTIFIER	Unique
CFCONDVAL	Add	I0001382	CFCOND_ID	Non-unique
	Add	I0001383	ATTRVAL_ID	Non-unique
	Add	I0001394	LANGUAGE_ID	Non-unique
CFPRODUCTSET	Add	I0001376	CATFILTER_ID + PRODUCTSET_ID	Unique
	Add	I0001377	PRODUCTSET_ID	Non-unique
	Add	I0001395	CATFILTER_ID	Non-unique
CMFEEDLOG	Add	I0001390	FEED_ID + STOREENT_ID	Non-unique
CMFEEDLOG	Add	I0001393	FEED_ID + STOREENT_ID + FEEDRECORD_ID	Unique
DKOFFERADJMNT	Add	I0001407	KIT_ID	Non-unique
DKOFFERADJMNT	Add	I0001408	CATENTRY_ID	Non-unique
ORDERREL	Add	I0001354	PARENTORDER_ID + CHILDORDER_ID	Unique
	Add	I0001355	PARENTORDERITEM_ID + CHILDORDER_ID	Unique
	Add	I0001356	CHILDORDER_ID	Non-unique
PRCONSTANT	Add	I0001351	IDENTIFIER + STOREENT_ID	Unique
	Add	I0001352	STOREENT_ID	Non-unique
	Add	I0001353	TYPE	Non-unique
PRELEMENT	Add	I0001345	IDENTIFIER + PRICERULE_ID	Unique
	Add	I0001346	PRELETEMPLATE_ID + PRICERULE_ID	Non-unique
	Add	I0001347	PRICERULE_ID	Non-unique
PRELEMENTATTR	Add	I0001348	NAME + VALUE	Non-unique
PRELETEMPLATE	Add	I0001343	PRELETPLTGRP_ID + IDENTIFIER + STOREENT_ID	Unique
PRELETEMPLATE	Add	I0001344	STOREENT_ID	Non-unique
PREQENTRY	Add	I0001359	PREQUATION_ID	Non-unique
PREQENTRY	Add	I0001385	PREQENTRYTYPE_ID	Non-unique
PREQENTRYTYPE	Add	I0001386	IDENTIFIER	Unique
PREQUATION	Add	I0001349	IDENTIFIER + STOREENT_ID	Unique
PREQUATION	Add	I0001350	STOREENT_ID	Non-unique
PRICERULE	Add	I0001340	IDENTIFIER + STOREENT_ID	Unique
	Add	I0001341	STOREENT_ID	Non-unique
	Add	I0001342	TYPE	Non-unique
SRCHATTR	Add	I0001403	INDEXSCOPE + INDEXTYPE + IDENTIFIER	Unique
SRCHSTATS	Add	I0001391	SRCHTERM + STOREENT_ID	Unique
SRCHSTATS	Add	I0001392	STOREENT_ID	Non-unique
SRCHTERM	Add	I0001400	TERM	Non-unique
	Add	I0001401	TYPE	Non-unique
	Add	I0001402	SRCHTERMASSOC_ID	Non-unique
SRCHTERMASSOC	Add	I0001396	STOREENT_ID	Non-unique
	Add	I0001397	LANGUAGE_ID	Non-unique
	Add	I0001398	SCOPE	Non-unique
	Add	I0001399	STATUS	Non-unique
STORETPC	Add	I0001357	TRADEPOSCN_ID	Non-unique
STORETPC	Add	I0001388	STTPCUSG_ID	Non-unique
SUBSCRIPTION	Add	I0001360	CATENTRY_ID	Non-unique
	Add	I0001361	ORDERS_ID	Non-unique
	Add	I0001362	STOREENT_ID	Non-unique
	Add	I0001363	MEMBER_ID	Non-unique
	Add	I0001364	SUBSCPTYPE_ID	Non-unique
	Add	I0001365	SUBSCRTEMPLATE_ID	Non-unique
	Add	I0001384	ORDERITEMS_ID + ORDERS_ID	Unique
	Add	I0001404	FFMFREQ_UOM	Non-unique
	Add	I0001405	PAYMENTFREQ_UOM	Non-unique
	Add	I0001406	TIMEPERIOD_UOM	Non-unique
SUBSCRRENEW	Add	I0001372	SUBSCRIPTION_ID	Non-unique
SUBSCRSCHJOBS	Add	I0001371	SUBSCRIPTION_ID	Non-unique
SUBSCRSUSPEND	Add	I0001366	SUBSCRIPTION_ID + SUSPENDSTARTDATE	Unique
SUBSCRTEMPLATE	Add	I0001367	STOREENT_ID	Non-unique
	Add	I0001368	MEMBER_ID	Non-unique
	Add	I0001369	CATENTRY_ID	Non-unique
SUBSCRTMPLITEMLIST	Add	I0001370	CATENTRY_ID	Non-unique

Indexes that are new or changed with WebSphere Commerce Version 7 Feature Pack 1


Table	Action	Index name	Index	Uniqueness
DMRANKINGITEM	Add	I0001302	DMELEMENT_ID + STOREENT_ID + OBJECT_ID + GROUP_ID	Unique
DMRANKINGSTAT	Add	I0001303	STOREENT_ID + DMELEMENT_ID + GROUP_ID + TIMECREATED	Non-unique
FILEPROCREL	Add	I0001312	PROCESSFILE_ID	Non-unique
INSRULE	Add	I0001326	STOREENT_ID + NAME	Unique
INSRULECATENT	Add	I0001330	INSRULE_ID + CATENTRY_ID	Non-unique
INSRULECATENT	Add	I0001331	CATENTRY_ID	Non-unique
INSRULECATGRP	Add	I0001327	INSRULECATGRP_ID + INSRULE_ID	Non-unique
	Add	I0001328	INSRULE_ID	Non-unique
	Add	I0001329	CATGROUP_ID	Non-unique
INSRULECOND	Add	I0001333	INSRULE_ID	Non-unique
INSRULEINSOPT	Add	I0001334	INSRULE_ID	Non-unique
INSRULEINSOPT	Add	I0001335	CURRENCY	Non-unique
INSRULEPAYMTHD	Add	I0001332	INSRULEPAYMTHD	Non-unique
PROCESSFILE	Add	I0001311	MEMBER_ID	Non-unique
PX_CDPOOL	Add	I0001313	CODE + STORE_ID	Non-unique
PX_CDPOOL	Add	I0001314	STORE_ID	Non-unique
PX_CDPROMO	Add	I0001315	PX_CDPOOL_ID + PX_PROMOTION_ID	Unique
PX_CDPROMO	Add	I0001316	PX_PROMOTION_ID	Non-unique
PX_CDUSAGE	Add	I0001317	PX_CDPOOL_ID	Non-unique
	Add	I0001318	OWNER_ID	Non-unique
	Add	I0001319	ORDERS_ID	Non-unique
	Add	I0001320	STATUS	Non-unique
UPLOADFILE	Add	I0001308	UPLOADTYPE + STORE_ID + OBJECTID	Non-unique
	Add	I0001309	MEMBER_ID	Non-unique
	Add	I0001310	STORE_ID	Non-unique
WALLET	Add	I0001322	STOREENT_ID + MEMBER_ID + NAME	Unique
WALLET	Add	I0001323	MEMBER_ID	Non-unique
WALLETITEM	Add	I0001324	WALLET_ID + TYPE + NAME + CREATIONDATE	Non-unique
WIREL	Add	I0001325	WALLETITEM_ID_CHD	Non-unique

Indexes that are new or changed with WebSphere Commerce Version 7 Fix Pack 9


Table	Action	Index name	Index	Uniqueness
ADDRESS	Add	I0001521	EMAIL1	Non-unique
ORDAUDIT	Add	I0001522	TIMEPLACED	Non-unique

Indexes that are new or changed with WebSphere Commerce Version 7 Fix Pack 8


Table	Action	Index name	Index	Uniqueness
CONTRACT	Add	I0001510	FAMILY_ID	Non-unique

Indexes that are new or changed with WebSphere Commerce Version 7 Fix Pack 7


Table	Action	Index name	Index	Uniqueness
PREVIEWTOKEN	Add	I0001506	STOREENT_ID	Non-unique
PREVIEWTOKEN	Add	I0001507	ENDDATE + STATUS	Non-unique
ORDERS	Add	I0001508	STATUS + LASTUPDATE	Non-unique

Indexes that are new or changed with WebSphere Commerce Version 7 Fix Pack 6


Table	Action	Index name	Index	Uniqueness
ATTR	Add	I0001464	FACETABLE	Non-unique
ATTRDESC	Add	I0001465	LANGUAGE_ID	Non-unique
	Add	I0001466	ATTRTYPE_ID	Non-unique
	Add	I0001467	QTYUNIT_ID	Non-unique
ATTRVALDESC	Add	I0001468	LANGUAGE_ID	Non-unique
	Add	I0001469	ATTR_ID	Non-unique
	Add	I0001470	QTYUNIT_ID	Non-unique
CATENTRYATTR	Add	I0001462	ATTRVAL_ID	Non-unique
CATENTRYATTR	Add	I0001463	ATTR_ID	Non-unique
GEONODE	Delete	I0001215	IDENTIFIER	Unique
GEONODE	Add	I0001459	STOREENT_ID + IDENTIFIER	Unique
STLOC	Delete	I0001209	IDENTIFIER	Unique
STLOC	Add	I0001460	STOREENT_ID + IDENTIFIER	Unique

Indexes that are new or changed with WebSphere Commerce Version 7 Fix Pack 5


Table	Action	Index name	Index	Uniqueness
CMFTGTSKREL	Add	I0001441	CMFTASKGRP_ID	Non-unique
CMFWSTGREL	Add	I0001442	CMFTASKGRP_ID	Non-unique

No indexes are new or changed with WebSphere Commerce Version 7 Fix Pack 4

No indexes are new or changed with WebSphere Commerce Version 7 Fix Pack 3

No indexes are new or changed with WebSphere Commerce Version 7 Fix Pack 2

Indexes that are new or changed with WebSphere Commerce Version 7 Fix Pack 1


Table	Action	Index name	Index	Uniqueness
GRGFTREG	Delete	GR_INDEX2	POSTEVENTADDRESS_ID	Unique
	Add	GR_INDEX2	POSTEVENTADDRESS_ID	Non-unique
	Delete	GR_INDEX3	PREVENTADDRESS_ID	Unique
	Add	GR_INDEX3	PREVENTADDRESS_ID	Non-unique

Table relationships that are new or changed

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


Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
PLLOCSTATIC	PLLOCSTATIC_ID	Add	P_0033			Primary key
PLLOCSTATIC	PAGELAYOUT_ID	Add	F_3771	PAGELAYOUT	PAGELAYOUT_ID	Cascade
PLPROPERTY	PLPROPERTY_ID	Add	P_0034			Primary key
PLPROPERTY	PAGELAYOUT_ID	Add	F_3772	PAGELAYOUT	PAGELAYOUT_ID	Cascade

Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 8


Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
CATGRPRULE	CATGROUP_ID, DMACTIVITY_ID	Add	P_0031			Primary key
CATGRPRULE	CATGROUP_ID	Add	F_3770	CATGROUP	CATGROUP_ID	Cascade

Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 7


Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
EXPRESSION	EXPRESSION_ID	Add	P_0030			Primary key
	TRADING_ID	Add	F_3768	TRADING	TRADING_ID	Cascade
	CATFILTER_ID	Add	F_3769	CATFILTER	CATFILTER_ID	Cascade
PLLOCATION	PLLOCATION_ID	Add	P_0026			Primary key
	PAGELAYOUT_ID	Add	F_3760	PAGELAYOUT	PAGELAYOUT_ID	Cascade
	DMACTIVITY_ID	Add	F_3761	DMACTIVITY	DMACTIVITY_ID	Cascade
PLPAGE	PLPAGE_ID	Add	P_0025			Primary key
	PAGELAYOUTTYPE_ID	Add	F_3758	PAGELAYOUTTYPE	PAGELAYOUTTYPE_ID	Cascade
	STOREENT_ID	Add	F_3759	STOREENT	STOREENT_ID	Cascade
PLSTOREWIDGET	PLSTOREWIDGET_ID	Add	P_0020			Primary key
	PLWIDGETDEF_ID	Add	F_3749	PLWIDGETDEF	PLWIDGETDEF_ID	Cascade
	STOREENT_ID	Add	F_3750	STOREENT	STOREENT_ID	Cascade
PLTEMPLATEREL	PAGELAYOUT_ID	Add	P_0029			Primary key
	PAGELAYOUT_ID	Add	F_3766	PAGELAYOUT	PAGELAYOUT_ID	Cascade
	TEMPLATE_ID	Add	F_3767	PAGELAYOUT	PAGELAYOUT_ID	Cascade
PLWIDGET	PLWIDGET_ID	Add	P_0021			Primary key
	PLWIDGETDEF_ID	Add	F_3751	PLWIDGETDEF	PLWIDGETDEF_ID	Cascade
	PAGELAYOUT_ID	Add	F_3752	PAGELAYOUT	PAGELAYOUT_ID	Cascade
PLWIDGETDEF	PLWIDGETDEF_ID	Add	P_0018			Primary key
PLWIDGETDEF	STOREENT_ID	Add	F_3746	STOREENT	STOREENT_ID	Cascade
PLWIDGETDEFDESC	PLWIDGETDEF_ID, LANGUAGE_ID	Add	P_0019			Primary key
	PLWIDGETDEF_ID	Add	F_3747	PLWIDGETDEF	PLWIDGETDEF_ID	Cascade
	LANGUAGE_ID	Add	F_3748	LANGUAGE	LANGUAGE_ID	Cascade
PLWIDGETNVP	PLWIDGETNVP_ID	Add	P_0023			Primary key
PLWIDGETNVP	PLWIDGET_ID	Add	F_3755	PLWIDGET	PLWIDGET_ID	Cascade
PLWIDGETREL	PLWIDGET_ID_CHILD	Add	P_0024			Primary key
	PLWIDGET_ID_PARENT	Add	F_3756	PLWIDGET	PLWIDGET_ID	Cascade
	PLWIDGET_ID_CHILD	Add	F_3757	PLWIDGET	PLWIDGET_ID	Cascade
PLWIDGETSLOT	PLWIDGETSLOT_ID	Add	P_0022			Primary key
	PAGELAYOUT_ID	Add	F_3753	PAGELAYOUT	PAGELAYOUT_ID	Cascade
	PLWIDGET_ID	Add	F_3754	PLWIDGET	PLWIDGET_ID	Cascade

Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 6


Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
COLLIMGMAPAREA	COLLIMGMAPAREA_ID	Add	P_0016			Primary key
	COLLATERAL_ID	Add	F_3742	COLLATERAL	COLLATERAL_ID	Cascade
	LANGUAGE_ID	Add	F_3743	LANGUAGE	LANGUAGE_ID	Cascade
DMEMSPOTCOLLDEF	DMEMSPOTCOLLDEF_ID	Add	P_0015			Primary key
	EMSPOT_ID	Add	F_3740	EMSPOT	EMSPOT_ID	Cascade
	COLLATERAL_ID	Add	F_3741	COLLATERAL	COLLATERAL_ID	Cascade
FOLDER	PARENTFOLDER_ID	Delete	F_3739	FOLDER	FOLDER_ID	Cascade
SRCHATTRDESC	SRCHATTR_ID, LANGUAGE_ID	Add	P_0017			Primary key
	SRCHATTR_ID	Add	F_3744	SRCHATTR	SRCHATTR_ID	Cascade
	LANGUAGE_ID	Add	F_3745	LANGUAGE	LANGUAGE_ID	Cascade
SRCHPROPRELV	SRCHPROPRELV_ID	Add	P_0027			Primary key
	CATALOG_ID	Add	F_3762	CATALOG	CATALOG_ID	Cascade
	STOREENT_ID	Add	F_3763	STOREENT	STOREENT_ID	Cascade
	CATGROUP_ID	Add	F_3764	CATGROUP	CATGROUP_ID	Cascade

Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 5


Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
CATENTDESCOVR	CATENTDESCOVR_ID	Add	P_0006			Primary key
	CATENTRY_ID	Add	F_3721	CATENTRY	CATENTRY_ID	Cascade
	LANGUAGE_ID	Add	F_3722	LANGUAGE	LANGUAGE_ID	Cascade
	CATOVRGRP_ID	Add	F_3723	CATOVRGRP	CATOVRGRP_ID	Cascade
CATOVRGRP	CATOVRGRP_ID	Add	P_0007			Primary key
CATOVRGRP	STOREENT_ID	Add	F_3724	STOREENT	STOREENT_ID	Cascade
FACET	FACET_ID	Add	P_0012			Primary key
	ATTR_ID	Add	F_3732	ATTR	ATTR_ID	Cascade
	SRCHATTR_ID	Add	F_3733	SRCHATTR	SRCHATTR_ID	Cascade
FACETCATGRP	FACETCATGRP_ID	Add	P_0013			Primary key
	STOREENT_ID	Add	F_3734	STOREENT	STOREENT_ID	Cascade
	CATGROUP_ID	Add	F_3735	CATGROUP	CATGROUP_ID	Cascade
	FACET_ID	Add	F_3736	FACET	FACET_ID	Cascade
FACETDESC	FACET_ID + LANGUAGE_ID	Add	P_0014			Primary key
	FACET_ID	Add	F_3737	FACET	FACET_ID	Cascade
	LANGUAGE_ID	Add	F_3738	LANGUAGE	LANGUAGE_ID	Cascade
FOLDER	FOLDER_ID	Add	P_0009			Primary key
	STOREENT_ID	Add	F_3727	STOREENT	STOREENT_ID	Cascade
	PARENTFOLDER_ID	Add	F_3739	FOLDER	FOLDER_ID	Cascade
FOLDERITEM	FOLDERITEM_ID	Add	P_0010			Primary key
	STOREENT_ID	Add	F_3728	STOREENT	STOREENT_ID	Cascade
	FOLDER_ID	Add	F_3729	FOLDER	FOLDER_ID	Cascade
PAGELAYOUT	PAGELAYOUT_ID	Add	P_0005			Primary key
	PAGELAYOUTTYPE_ID	Add	F_3719	PAGELAYOUTTYPE	PAGELAYOUTTYPE_ID	Cascade
	STOREENT_ID	Add	F_3720	STOREENT	STOREENT_ID	Cascade
PAGELAYOUTTYPE	PAGELAYOUTTYPE_ID	Add	P_0003			Primary key
STORECATOVRGRP	CATOVRGRP_ID	Add	F_3726	CATOVRGRP	CATOVRGRP_ID	Cascade
	CATOVRGRP_ID + STOREENT_ID	Add	P_0008			Primary key
	STOREENT_ID	Add	F_3725	STOREENT	STOREENT_ID	Cascade
STOREDEFCAT	STOREDEFCAT_ID	Add	P_0001			Primary key
	CATALOG_ID	Add	F_3714	CATALOG	CATALOG_ID	Cascade
	STOREENT_ID	Add	F_3715	STOREENT	STOREENT_ID	Cascade
STOREPLTYPES	PAGELAYOUTTYPE_ID + STOREENT_ID	Add	P_0004			Primary key
	PAGELAYOUTTYPE_ID	Add	F_3717	PAGELAYOUTTYPE	PAGELAYOUTTYPE_ID	Cascade
	STOREENT_ID	Add	F_3718	STOREENT	STOREENT_ID	Cascade

Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 4


Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
CLIENTLOCATION	CLIENTLOCATION_ID	Add				Primary key
POIDESC	POIDESC_ID	Add				Primary key
POIDESC	POINTOFINTEREST_ID	Add	f_3713	POINTOFINTEREST	POINTOFINTEREST_ID	Cascade
POINTOFINTEREST	POINTOFINTEREST_ID	Add				Primary key
STORECONF	STOREENT_ID + NAME	Add	P_002			Primary key
STORECONF	STOREENT_ID	Add	F_3716	STOREENT	STOREENT_ID	Cascade

Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 3


Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
CMEXTDATA	CMEXTDATA_ID	Add				Primary key
CMEXTDATA	CMPRMYOBJ_ID	Add	F_3707	CMPRMYOBJ	CMPRMYOBJ_ID	Cascade
CMPRMYOBJ	CMPRMYOBJ_ID	Add				Primary key
OICONFIG	OICONFIG_ID	Add				Primary key
OICONFIG	ORDERITEMS_ID	Add	F_3712	ORDERITEMS	ORDERITEMS_ID	Cascade
SEOPAGEDEF	SEOPAGEDEF_ID	Add				Primary key
SEOPAGEDEF	STOREENT_ID	Add	F_3697	STOREENT	STOREENT_ID	Cascade
SEOPAGEDEFDESC	SEOPAGEDEF_ID + LANGUAGE_ID	Add				Primary key
	SEOPAGEDEF_ID	Add	F_3698	SEOPAGEDEF	SEOPAGEDEF_ID	Cascade
	LANGUAGE_ID	Add	F_3699	LANGUAGE	LANGUAGE_ID	Cascade
SEOPAGEDEFOVR	SEOPAGEDEFOVR_ID	Add				Primary key
SEOPAGEDEFOVR	SEOPAGEDEF_ID	Add	F_3700	SEOPAGEDEF	SEOPAGEDEF_ID	Cascade
SEOPAGEDEFSUBPARAM	SUBPARAMNAME + STOREENT_ID	Add				Primary key
SEOPAGEDEFSUBPARAM	STOREENT_ID	Add	F_3703	STOREENT	STOREENT_ID	Cascade
SEOREDIRECT	SEODIRECT_ID	Add				Primary key
	SEOURLKWD_ID_NEW	Add	F_3701	SEOURLKEYWORD	SEOURLKEYWORD_ID	Cascade
	SEOURLKWD_ID_ORIG	Add	F_3702	SEOURLKEYWORD	SEOURLKEWORD_ID	Cascade
SEOREDIRECTTRAFFIC	SEOREDIRECT_ID	Add				Primary key
SEOREDIRECTTRAFFIC	SEOREDIRECT_ID	Add	F_3708	SEOREDIRECT	SEOREDIRECT_ID	Cascade
SEOTOKENUSGTYPE	TOKENUSGTYPE_ID	Add				Primary key
SEOTOKENUSGTYPE	STOREENT_ID	Add	F_3711	STOREENT	STOREENT_ID	Cascade
SEOURL	SEOURL_ID	Add				Primary key
SEOURLKEYWORD	SEOURLKEYWORD_ID	Add				Primary key
	SEOURL_ID	Add	F_3704	SEOURL	SEOURL_ID	Cascade
	STOREENT_ID	Add	F_3705	STOREENT	STOREENT_ID	Cascade
	LANGUAGE_ID	Add	F_3706	LANGUAGE	LANGUAGE_ID	Cascade
SRCHCONFEXT	SRCHCONFEXT_ID	Add				Primary key
	LANGUAGE_ID	Add	F_3709	LANGUAGE	LANGUAGE_ID	Cascade
	INDEXTYPE + INDEXSCOPE	Add	F_3710	SRCHCONF	INDEXTYPE + INDEXSCOPE	Cascade
SRCHSTAT	SRCHSTAT_ID	Add				Primary key
SRCHSTATS	SRCHSTATS_ID	Delete				Primary key
SRCHSTATS	STOREENT_ID	Delete	F_3696	STOREENT	STOREENT_ID	Cascade

Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 2


Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
ATTRDICTSRCHCONF	MASTERCATALOG_ID	Add	F_3679	CATALOG	CATALOG_ID	Cascade
	ATTRDICTSRCHCNF_ID	Add				Primary key
	ATTR_ID	Add	F_3680	ATTR	ATTR_ID	Cascade
	ATTRTYPE_ID	Add	F_3681	ATTRTYPE	ATTRTYPE_ID	Cascade
CATENTSUBS	CATENTRY_ID	Add				Primary key
	CATENTRY_ID	Add	F_3644	CATENTRY	CATENTRY_ID	Cascade
	SUBSCPTYPE_ID	Add	F_3645	SUBSCPTYPE	SUBSCPTYPE_ID	Cascade
CATFLTDSC	CATFILTER_ID + LANGUAGE_ID	Add				Primary key
	CATFILTER_ID	Add	F_3664	CATFILTER	CATFILTER_ID	Cascade
	LANGUAGE_ID	Add	F_3665	LANGUAGE	LANGUAGE_ID	Cascade
CATFILTER	STOREENT_ID	Add	F_3663	STOREENT	STOREENT_ID	Primary key
	CATFILTER_ID	Add				Primary key
	CATALOG_ID	Add	F_3662	CATALOG	CATALOG_ID	Cascade
CFCATGROUP	CFCATGROUP_ID	Add				Primary key
	CATFILTER_ID	Add	F_3669	CATFILTER	CATFILTER_ID	Cascade
	CATGROUP_ID	Add	F_3674	CATGROUP	CATGROUP_ID	Cascade
CFCOND	CFCOND_ID	Add				Primary key
	ATTR_ID	Add	F_3670	ATTR	ATTR_ID	Cascade
	CFCONDGRP_ID	Add	F_3671	CFCONDGRP	CFCONDGRP_ID	Cascade
CFCONDGRP	CFCONDGRP_ID	Add				Primary key
CFCONDGRP	CFCATGROUP_ID	Add	F_3668	CFCATGROUP	CFCATGROUP_ID	Cascade
CFCONDVAL	CFCONDVAL_ID	Add				Primary key
	ATTRVAL_ID	Add	F_3672	ATTRVAL	ATTRVAL_ID	Cascade
	CFCOND_ID	Add	F_3673	CFCOND	CFCOND_ID	Cascade
	LANGUAGE_ID	Add	F_3685	LANGUAGE	LANGUAGE_ID	Cascade
CFPRODUCTSET	CFPRODUCTSET_ID	Add				Primary key
	CATFILTER_ID	Add	F_3666	CATFILTER	CATFILTER_ID	Cascade
	PRODUCTSET_ID	Add	F_3667	PRODUCTSET	PRODUCTSET_ID	Cascade
CLSATTRSRCHCONF	CLSATTRSRCHCONF_ID	Add				Primary key
	ATTRTYPE_ID	Add	F_3680	ATTRTYPE	ATTRTYPE_ID	Cascade
	MASTERCATALOG_ID	Add	F_3682	CATALOG	CATALOG_ID	Cascade
	LANGUAGE_ID	Add	F_3683	LANGUAGE	LANGUAGE_ID	Cascade
CMFEEDLOG	CMFEEDLOG_ID	Add				Primary key
CMFEEDLOG	STOREENT_ID	Add	F_3678	STOREENT	STOREENT_ID	Cascade
DKOFFERADJMNT	TRADEPOSCN_ID + KIT_ID + CATENTRY_ID	Add				Primary key
	TRADEPOSCN_ID	Add	F_3693	TRADEPOSCN	TRADEPOSCN_ID	Cascade
	KIT_ID	Add	F_3694	CATENTRY	CATENTRY_ID	Cascade
	CATENTRY_ID	Add	F_3695	CATENTRY	CATENTRY_ID	Cascade
ORDERREL	ORDERREL_ID	Add				Primary key
	PARENTORDER_ID	Add	F_3639	ORDERS	ORDERS_ID	Cascade
	CHILDORDER_ID	Add	F_3640	ORDERS	ORDERS_ID	Cascade
	PARENTORDERITEM_ID	Add	F_3641	ORDERITEMS	ORDERITEMS_ID	Cascade
PRCONSTANT	PRCONSTANT_ID	Add				Primary key
PRCONSTANT	STOREENT_ID	Add	f_3637	STOREENT	STOREENT_ID	Cascade
PRCONVALUE	PRCONSTANT_ID + CURRENCY	Add				Primary key
PRCONVALUE	PRCONSTANT_ID	Add	F_3638	PRCONSTANT	PRCONSTANT_ID	Cascade
PRELEMENT	PRELEMENT_ID	Add				Primary key
	PRICERULE_ID	Add	F_3633	PRICERULE	PRICERULE_ID	Cascade
	PRELETEMPLATE_ID	Add	F_3634	PRELETEMPLATE	PRELETEMPLATE_ID	Cascade
PRELEMENTATTR	PRELEMENT_ID + NAME + VALUE	Add				Primary key
PRELEMENTATTR	PRELEMENT_ID	Add	F_3635	PRELEMENT	PRELEMENT_ID	Cascade
PRELETEMPLATE	PRELETEMPLATE_ID	Add				Primary key
	PRELETPLTGRP_ID	Add	F_3631	PRELETPLTGRP	PRELETPLTGRP_ID	Cascade
	STOREENT_ID	Add	F_3632	STOREENT	STOREENT_ID	Cascade
PRELETPLTGRP	PRELETPLTGRP_ID	Add				Primary key
PREQENTRY	PREQENTRY_ID	Add				Primary key
	PREQUATION_ID	Add	F_3676	PREQUATION	PREQUATION_ID	Cascade
	PREQENTRYTYPE_ID	Add	F_3677	PREQENTRYTYPE	PREQENTRYTYPE_ID	Cascade
PREQENTRYTYPE	PREQENTRYTYPE_ID	Add				Primary key
PREQUATION	PREQUATION_ID	Add				Primary key
PREQUATION	STOREENT_ID	Add	F_3636	STOREENT	STOREENT_ID	Cascade
PRICERULE	PRICERULE_ID	Add				Primary key
PRICERULE	STOREENT_ID	Add	F_3630	STOREENT	STOREENT_ID	Cascade
SRCHATTR	SRCHATTR_ID	Add				Primary key
SRCHATTRPROP	SRCHATTR_ID + PROPERTYNAME	Add				Primary key
SRCHATTRPROP	SRCHATTR_ID	Add	F_3689	SRCHATTR	SRCHATTR_ID	Cascade
SRCHCONF	INDEXTYPE	Add				Primary key
SRCHSTATS	SRCHSTATS_ID	Add				Primary key
SRCHSTATS	STOREENT_ID	Add	F_3696	STOREENT	STOREENT_ID	Cascade
SRCHTERM	SRCHTERMASSOC_ID + TYPE + TERM	Add				Primary key
SRCHTERM	SRCHTERMASSOC_ID	Add	F_3688	SRCHTERMASSOC	SRCHTERMASSOC_ID	Cascade
SRCHTERMASSOC	SRCHTERMASSOC_ID	Add				Primary key
	STOREENT_ID	Add	F_3686	STOREENT	STOREENT_ID	Cascade
	LANGUAGE_ID	Add	F_3687	LANGUAGE	LANGUAGE_ID	Cascade
STORETPC	STOREENT_ID + TRADEPOSCN_ID + STTPCUSG_ID	Add				Primary key
	STOREENT_ID	Add	F_3642	STOREENT	STOREENT_ID	Cascade
	TRADEPOSCN_ID	Add	F_3643	TRADEPOSCN	TRADEPOSCN_ID	Cascade
	STTPCUSG_ID	Add	F_3675	STTPCUSG	STTPCUSG_ID	Cascade
STTPCUSG	STTPCUSG_ID	Add				Primary key
SUBSCPTYPE	SUBSCPTYPE_ID	Add				Primary key
SUBSCRIPTION	SUBSCRIPTION_ID	Add				Primary key
	CATENTRY_ID	Add	F_3646	CATENTRY	CATENTRY_ID	Cascade
	SUBSCPTYPE_ID	Add	F_3647	SUBSCPTYPE	SUBSCPTYPE_ID	Cascade
	ORDERITEMS_ID	Add	F_3648	ORDERITEMS	ORDERITEMS_ID	Cascade
	ORDERS_ID	Add	F_3649	ORDERS	ORDERS_ID	Cascade
	STOREENT_ID	Add	F_3650	STOREENT	STOREENT_ID	Cascade
	MEMBER_ID	Add	F_3651	MEMBER	MEMBER_ID	Cascade
	SUBSCRTEMPLATE_ID	Add	F_3652	SUBSCRTEMPLATE	SUBSCRTEMPLATE_ID	Cascade
	FFMFREQ_UOM	Add	F_3690	QTYUNIT	QTYUNIT_ID	Cascade
	PAYMENTFREQ_UOM	Add	F_3691	QTYUNIT	QTYUNIT_ID	Cascade
	TIMEPERIOD_UOM	Add	F_3692	QTYUNIT	QTYUNIT_ID	Cascade
SUBSCRRENEW	RENEWEDSUBSCR_ID + SUBSCRIPTION_ID	Add				Primary key
	RENEWEDSUBSCR_ID	Add	F_3660	SUBSCRIPTION	SUBSCRIPTION_ID	Cascade
	SUBSCRIPTION_ID	Add	F_3661	SUBSCRIPTION	SUBSCRIPTION_ID	Cascade
SUBSCRSCHJOBS	SCHEDULED_ID	Add				Primary key
SUBSCRSCHJOBS	SUBSCRIPTION_ID	Add	F_3659	SUBSCRIPTION	SUBSCRIPTION_ID	Cascade
SUBSCRSUSPEND	SUSPEND_ID	Add				Primary key
SUBSCRSUSPEND	SUBSCRIPTION_ID	Add	F_3653	SUBSCRIPTION	SUBSCRIPTION_ID	Cascade
SUBSCRTEMPLATE	SUBSCRTEMPLATE_ID	Add				Primary key
	STOREENT_ID	Add	F_3654	STOREENT	STOREENT_ID	Cascade
	MEMBER_ID	Add	F_3655	MEMBER	MEMBER_ID	Cascade
	CATENTRY_ID	Add	F_3656	CATENTRY	CATENTRY_ID	Cascade
SUBSCRTMPLITEMLIST	SUBSCRTEMPLATE_ID	Add				Primary key
	SUBSCRTEMPLATE_ID	Add	F_3657	SUBSCRTEMPLATE	SUBSCRTEMPLATE_ID	Cascade
	CATENTRY_ID	Add	F_3658	CATENTRY	CATENTRY_ID	Cascade

Table relationships that are new or changed with WebSphere Commerce Version 7 Feature Pack 1


Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
DMRANKINGITEM	DMRANKINGITEM_ID	Add				Primary key
DMRANKINGITEM	DMELEMENT_ID	Add	f_3595	DMELEMENT	DMELEMENT_ID	Cascade
DMRANKINGSTAT	DMRANKINGSTAT_ID	Add				Primary key
FILEPROCREL	UPLOADFILE_ID + PROCESSFILE_ID	Add				Primary key
	UPLOADFILE_ID	Add	f_3602	UPLOADFILE	UPLOADFILE_ID	Cascade
	PROCESSFILE_ID	Add	f_3603	PROCESSFILE	PROCESSFILE_ID	Cascade
INSRULE	INSRULE_ID	Add				Primary key
INSRULE	STOREENT_ID	Add	f_3618	STOREENT	STOREENT_ID	Cascade
INSRULECATENT	INSRULECATENT_ID	Add				Primary key
	INSRULE_ID	Add	f_3621	INSRULE	INSRULE_ID	Cascade
	CATENTRY_ID	Add	f_3622	CATENTRY	CATENTRY_ID	Cascade
INSRULECATGRP	INSRULECATGRP_ID	Add				Primary key
	CATGROUP_ID	Add	f_3620	CATGROUP	CATGROUP_ID	Cascade
	INSRULE_ID	Add	f_3619	INSRULE	INSRULE_ID	Cascade
INSRULECOND	INSRULECOND_ID	Add				Primary key
INSRULECOND	INSRULE_ID	Add	f_3624	INSRULE	INSRULE_ID	Cascade
INSRULEINSOPT	INSRULEINSOPT_ID	Add				Primary key
	INSRULE_ID	Add	f_3625	INSRULE	INSRULE_ID	Cascade
	CURRENCY	Add	f_3626	SETCURR	SETCCURR	Cascade
INSRULEPAYMTHD	INSRULEPAYMTHD_ID	Add				Primary key
INSRULEPAYMTHD	INSRULE_ID	Add	f_3623	INSRULE	INSRULE_ID	Cascade
PROCESSFILE	PROCESSFILE_ID	Add				Primary key
PROCESSFILE	MEMBER_ID	Add	f_3601	MEMBER	MEMBER_ID	Cascade
PX_CDPOOL	PX_CDPOOL_ID	Add				Primary key
PX_CDPOOL	STORE_ID	Add	f_3605	STORE	STORE_ID	Cascade
PX_CDPROMO	PX_CDPROMO_ID	Add				Primary key
	PX_PROMOTION_ID	Add	f_3606	PX_PROMOTION	PX_PROMOTION_ID	Cascade
	PX_CDPOOL_ID	Add	f_3607	PX_CDPOOL	PX_CDPOOL_ID	Cascade
PX_CDSPEC	PX_PROMOTION_ID	Add				Primary key
PX_CDSPEC	PX_PROMOTION_ID	Add	f_3604	PX_PROMOTION	PX_PROMOTION_ID	Cascade
PX_CDUSAGE	PX_CDUSAGE_ID	Add				Primary key
	PX_CDPOOL_ID	Add	f_3608	PX_CDPOOL	PX_CDPOOL_ID	Cascade
	OWNER_ID	Add	f_3609	USERS	USERS_ID	Cascade
	ORDERS_ID	Add	f_3610	ORDERS	ORDERS_ID	Cascade
UPLOADFILE	UPLOADFILE_ID	Add				Primary key
	MEMBER_ID	Add	f_3599	MEMBER	MEMBER_ID	Cascade
	STORE_ID	Add	f_3600	STORE	STORE_ID	Cascade
WALLET	WALLET_ID	Add				Primary key
	MEMBER_ID	Add	f_3613	MEMBER	MEMBER_ID	Cascade
	STOREENT_ID	Add	f_3614	STOREENT	STOREENT_ID	Cascade
WALLETITEM	WALLETITEM_ID	Add				Primary key
WALLETITEM	WALLET_ID	Add	f_3615	WALLET	WALLET_ID	Cascade
WIREL	WALLETITEM_ID_PNT + WALLETITEM_ID_CHD + TYPE	Add				Primary key
	WALLETITEM_ID_PNT	Add	f_3616	WALLETITEM	WALLETITEM_ID	Cascade
	WALLETITEM_ID_CHD	Add	f_3617	WALLETITEM	WALLETITEM_ID	Cascade

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


Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
ORDAUDIT	ORDERS_ID	Add	P_0032			Primary key

No table relationships are new or changed with WebSphere Commerce Version 7 Fix Pack 8

Table relationships that are new or changed with WebSphere Commerce Version 7 Fix Pack 7


Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
PREVIEWTOKEN	PREVIEWTOKEN_ID	Add	P_0028			Primary key
PREVIEWTOKEN	STOREENT_ID	Add	F_3765	STOREENT	STOREENT_ID	Cascade

Table relationships that are new or changed with WebSphere Commerce Version 7 Fix Pack 6


Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
GEONODE	STOREENT_ID	Add	F_3730	STOREENT	STOREENT_ID	Cascade
STLOC	STOREENT_ID	Add	F_3731	STOREENT	STOREENT_ID	Cascade

No table relationships are new or changed with WebSphere Commerce Version 7 Fix Pack 5

No table relationships are new or changed with WebSphere Commerce Version 7 Fix Pack 4

No table relationships are new or changed with WebSphere Commerce Version 7 Fix Pack 3

No table relationships are new or changed with WebSphere Commerce Version 7 Fix Pack 2

Table relationships that are new or changed with WebSphere Commerce Version 7 Fix Pack 1


Table	Column	Action	Constraint name	Foreign table	Foreign column	Constraint type
GRGFTREG	POSTEVENTADDRESS_ID	Delete	GRG_CONSTRAINT4	GRADDR	ADDRESS_ID	Cascade
GRRGSTRNT	PREEVENTADDRESS_ID	Delete	GRR_CONSTRAINT2	GRADDR	ADDRESS_ID	Cascade