Database schema changes between from version 5.5 to version 5.6

This topic describes the database schema changes between WebSphere Commerce 5.5 and WebSphere Commerce 5.6. The changes are grouped into the following sections:

Tables added since version 5.5

BUSAUDIT
This table contains the WebSphere Commerce business auditing records captureed when the business auditing component is enabled.
CLCDPROMO
This table stores information about the relationship between the Calculation Framework and the promotion standalone infrastructure. Each calculation code matches one promotion in the PX_PROMOTION table.
EMLBADADDR
This table records information about users with invalid e-mail addresses. Each row corresponds to a user that has an invalid e-mail address.
EMLBOUNCED
Records information about bounced messages for e-mail activities. Each row corresponds to a bounced message for a particular recipient of a particular e-mail activity.
EMLCAMPREL
This table stores the relationship between an e-mail activity and a campaign. Each row represents the campaign to which the e-mail activity belongs.
EMLPOLICY
Stores bounce back e-mail retry policies.
EMLSTRPLCY
Stores the relationship between a store and a bounced e-mail retry policy.
ORDITPROMOCD
This contains promotion codes that were captured with an order for the orderitems in the order.
ORDPROMOCD
This table contains promotion codes captured for an order.
PAREQINFO
PX_COUPON
This table contains all of the coupons issued to individual customers.
PX_DYNATTR
This table contains the details about any dynamic attributes that belong to promotion entities, such as promotion groups, promotion policies, and others.
PX_GROUP
Contains the promotion groups for the site.
PX_GRPPOLICY
This table contains relationships between promotion groups and promotion policies.
PX_POLICY
This table contains promotion policies.
PX_PROMOARG
This table contains details about how promotions are applied to an order.
PX_PROMOPOLICY
Reserved for IBM internal use.
PX_PROMOTION
PX_PROMPROM
Reserved for IBM internal use.
PX_TEMPLATE
Reserved for IBM internal use.
PX_TPLTGRP
Reserved for IBM internal use.
PX_USAGE
This table contains statistics about promotion usage.

Tables containing new columns

CATENTRY
  • RANK
CATGROUP
  • RANK
CATTOGRP
  • CATALOG_ID_LINK
CONTRACT
  • FAMILY_ID
EMLPROMO
  • REPLYTO
OICOMPLIST
  • RFQPROD_ID
ORDITAX
  • TAXCGRY_DSC
RFQ
  • EXTRFQNUM
  • FIELD1
  • FIELD2
  • FIELD3
  • FIELD4
  • FIELD5
  • FIELD6
RFQPROD
  • PRICEADJUSTMENT
  • NEGOTIATIONTYPE
  • FIELD1
  • FIELD2
  • FIELD3
  • FIELD4
RFQRSP
  • EXTRFQRESPONSENUM
  • FIELD1
  • FIELD2
  • FIELD3
  • FIELD4
  • FIELD5
  • FIELD6
RFQRSPPROD
  • PRICEADJUSTMENT
  • FIELD1
  • FIELD2
  • FIELD3
  • FIELD4
TRDREFAMT
  • TRDREFAMT_ID

Deprecated tables

ACCCMDGRP
This table defines all commands and views that require access control and categorize them into different groups. This table is deprecated and is provided for backward compatibility only.
ACCCMDTYPE
This table defines all the valid ACCCMDTYPE_ID that can be used in the ACCCMDGRP table. This table is deprecated and is provided for backward compatibility only.
ACCCUSTEXC
This table excludes a command or view from a customer group for a specific owner. This table is deprecated and is provided for backward compatibility only.
ACCMBRGRP
This table is used to assign an administrative user to various access groups for a particular store owner. This table is deprecated and is provided for backward compatibility only.
ACORGPOL
This table enables an organization to be exempted from one or more of the template policies. This table is deprecated and is provided for backward compatibility only.
BILLITEMS
This table is deprecated and is provided for backward compatibility only.
BROADCAST
This table is deprecated and is provided for backward compatibility only.
BZRPENT
This table contains the data for a Brokat Repository Entry. This table reflects the directory structure of the Brokat repository. This table is deprecated and is provided for backward compatibility only.
BZRPENTAT
This table contains the data for the attributes for a Brokat repository item. This table is deprecated and is provided for backward compatibility only.
BZRPENTSTG
This table contains the data for the Brokat repository entry storage. This is a paged storage for Brokat repository item. This table is deprecated and is provided for backward compatibility only.
BZSVCSTA
This table indicates the last-known status of a rule service. Each row represents status reported by an application clone for a rule service. This table is deprecated and is provided for backward compatibility only.
CATPRDREL
This table is deprecated and is provided for backward compatibility only.
CMBITEMS
This table is deprecated and is provided for backward compatibility only.
DAEMON
This table is deprecated and is provided for backward compatibility only.
DBDELIVERY
This table is deprecated and is provided for backward compatibility only.
DBDTFREQ
This table is deprecated and is provided for backward compatibility only.
DBMEAS
This table is deprecated and is provided for backward compatibility only.
DBMEASFM
This table is deprecated and is provided for backward compatibility only.
DBTEMPLATE
This table is deprecated and is provided for backward compatibility only.
DBVIEW
This table is deprecated and is provided for backward compatibility only.
HMBITEMS
This table is deprecated and is provided for backward compatibility only.
INIRULEVAL
This table contains the data for an initial rule value. This table is deprecated and is provided for backward compatibility only.
LMSERVER
This table holds the LikeMinds server information. This table is deprecated and is provided for backward compatibility only.
MGPTRDPSCN
A row in this table associates a TradingPositionContainer with a MemberGroup. Task commands can use this relationship to restrict use of the TradingPositionContainer to members of certain MemberGroups. (See also the STOREMBRGP table.) This table is deprecated and is provided for backward compatibility only. Use TermAndCondition objects and Participant objects to limit the use of TradingPositionContainers to certain customers. See the TRADING, TERMCOND, and PARTICIPNT tables for current information.
MOPICONFIG
This table is deprecated and is provided for backward compatibility only.
MSALESVW
This table is deprecated and is provided for backward compatibility only.
NSLOG
This table is deprecated and is provided for backward compatibility only.
OIBTB
This table is deprecated and is provided for backward compatibility only.
PAYMTHD
This table is a site-wide table that lists all the Cashier profiles used in the store group. Each profile has a unique integer ID and a name. This table is deprecated and is provided for backward compatibility only.
PAYMTHDDSC
This table is a site-wide table that contains a short description of the Cashier profiles in each of the supported language. This table is deprecated and is provided for backward compatibility only.
PAYMTHDSUP
This table lists all the profiles supported by the Store or StoreGroup. This table is deprecated and is provided for backward compatibility only.
PKGITEMREL
This table holds the relationship between Packages, and the Items they contain. This table is deprecated and is provided for backward compatibility only.
REPORT
This table is deprecated and is provided for backward compatibility only.
RULEVALUE
This table contains the data for a rule value. This table is deprecated and is provided for backward compatibility only.
STBRCODES
This table is deprecated and is provided for backward compatibility only.
STBRWSER
This table is deprecated and is provided for backward compatibility only.
STCGRYDESC
This table is deprecated and is provided for backward compatibility only.
STCONF
This table is deprecated and is provided for backward compatibility only.
STDCNTRY
This table is deprecated and is provided for backward compatibility only.
STDOMAIN
This table is deprecated and is provided for backward compatibility only.
STERROR
This table is deprecated and is provided for backward compatibility only.
STFLNAME
This table is deprecated and is provided for backward compatibility only.
STMERCNF
This table is deprecated and is provided for backward compatibility only.

Tables containing deprecated columns

ACPOLICY
POLICYTYPE
ORGENTITY
MEMBER_ID
PVCBUFFER
PARAMETERS
PVCDEVMDL
MODELNAME
PVCDEVSPEC
SESSIONTYPE
STORECGRY
REMARK
TAXTYPE
SEQUENCE
TRADEPOSCN
FLAGS
USERPVCDEV
DEVICEIDENTIFIER
USERS
REGISTERTYPE

Tables containing changed columns

CATENTDESC LONGDESCRIPTION
CATENTDESC XMLDETAIL
CATGRPDESC NOTE
INITIATIVE RULE
INVOICE INVOICEXML
MBRGRPCOND CONDITIONS
MESSAGE CONTENT
MSGARCHIVE MESSAGE
MSGSTORE MESSAGE
MSGVIEW CONTENT
ORDPAYMTHD XMLDATA
PAYSUMMARY PAYSUMMARYXML
PRODUCTSET XMLDEFINITION
RLDISCOUNT RULEXML
TRDPSCNXML XMLDEFINITION

Feedback