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
- Tables removed since version 5.5
- Deprecated tables
- Tables containing deprecated columns
- Tables containing new columns
- Tables containing changed columns
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
- Version 5.5: VARCHAR (4000) NULL
- Version 5.6: CLOB (1000000) NULL
- CATENTDESC XMLDETAIL
- Version 5.5: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- CATGRPDESC NOTE
- Version 5.5: LONG VARCHAR NULL
- Version 5.6: VARCHAR (4000) NULL
- INITIATIVE RULE
- Version 5.5: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- INVOICE INVOICEXML
- Version 5.5: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- MBRGRPCOND CONDITIONS
- Version 5.5: VARCHAR (8000) NULL
- Version 5.6: CLOB (1000000) NULL
- MESSAGE CONTENT
- Version 5.5: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- MSGARCHIVE MESSAGE
- Version 5.5: LONG VARCHAR NULL
- Version 5.6: BLOB (1000000) NULL
- MSGSTORE MESSAGE
- Version 5.5: LONG VARCHAR NULL
- Version 5.6: BLOB (1000000) NULL
- MSGVIEW CONTENT
- Version 5.5: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- ORDPAYMTHD XMLDATA
- Version 5.5: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- PAYSUMMARY PAYSUMMARYXML
- Version 5.5: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- PRODUCTSET XMLDEFINITION
- Version 5.5: LONG VARCHAR NULL
- Version 5.6: CLOB (1000000) NULL
- RLDISCOUNT RULEXML
- Version 5.5: LONG VARCHAR NOT NULL
- Version 5.6: CLOB (1000000) NULL
- TRDPSCNXML XMLDEFINITION
- Version 5.5: VARCHAR (16000) NULL
- Version 5.6: CLOB (1000000) NULL