Database schema changes between from version 5.4 to version 5.6

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

Tables added since version 5.4

ACPLGPDESC
This table stores locale specific information for the ACPOLGRP table.
ACPLGPSUBS
This table stores the association between access control policy groups and organizational entities. An organizational entity that is associated with a policy group is said to subscribe to that policy group. The access control policies belonging to that policy group will apply to that organization. An organization can subscribe to multiple policy groups and the same policy group can be subscribed to by multiple organizations.
ACPOLGPPOL
This table stores the association between access control policy groups and access control policies. An access control policy that belongs to a policy group will be applied to all the organizations that subscribe to that policy group.
ACPOLGRP
This table stores all the access control policy groups in the system. Each a row in this table represents a policy group.
ACPOLSUBGP
Reserved for IBM internal use.
APPLY_INIT
This table holds the results of the application of the mining model. The mining model is applied to information pertaining to campaign activities.
APPLY_MEMBER
This table contains the output from WebSphere Commerce Analyzer after the mining model is applied to members and the WebSphere Commerce Analyzer sample closed-loop script is run.
APPLY_RESULT
This table contains the result of a mining apply for contracts or accounts. This table is currently not used.
BUSAUDIT
This table contains the WebSphere Commerce business auditing records captureed when the business auditing component is enabled.
CACHEIVL
This table records changes to product or category information in the database. It can be populated by user-defined database triggers.
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.
CNTRSTORE
This table contains Store information for a Contract. The data is used to persist XML data needed by a contract to create a Store.
COLLABWS
This table stores collaborative workspace information.
CPEMAILMAP
This table stores the mapping between the coupon ID and the e-mail IDs of guest customers to whom specific coupon IDs were sent.
CPPMNACC
This table stores the number of times a coupon has been accepted from the coupon promotion by the guest customer identified by the e-mail ID. It also stores the number of times the customer has redeemed coupons from this promotion.
CPPMNCAT
This table contains the purchase conditions for a category-level promotion. If the purchase condition type in the CPPMN table was C, then this table is used to find out all of the items that are required for this coupon to be redeemed. There can be more than one category condition for a given promotion. All of the purchase conditions for a coupon are combined using the AND operator.
CWMEMBER
This table stores collaborative workspace member information.
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.
EMLCFG
This table stores the configuration information about the accounts used in support of e-mail activities. Each store can have one inbound (POP3) and one outbound (SMTP) server configured.
EMLGRPREL
This table stores the relationship between an e-mail activity and its target customer segment.
EMLMSG
This table stores e-mail message templates. Each row corresponds to an e-mail message template which can be used within an e-mail activity.
EMLPOLICY
Stores bounce back e-mail retry policies.
EMLPROMO
This table stores e-mail activities. Each row corresponds to an e-mail activity which is sent to a given customer profile.
EMLRCPTS
This table records the recipients of an e-mail activity.
EMLRPTEVTS
This table records e-mail events for each recipient of a particular e-mail activity. If a row does not exist for a recipient of an e-mail activity, the user has not yet caused an event.
EMLSTRPLCY
Stores the relationship between a store and a bounced e-mail retry policy.
EMLUSRRECV
This table stores whether the user prefers to receive e-mail activities or not.
FILEUPLOAD
This table contains the information of uploaded files.
MBRGRPDESC
This table contains locale specific information for the entries in the MBRGRP table.
MSALESVW
This table is deprecated and is provided for backward compatibility only.
MSGARCHIVE
This table stores sent messages (if ARCHIVEMSG = "1" is set for the message profile). The stored messages can be resent using the integrated GUI in the Administration Console.
MUSRTRVW
Reserved for IBM internal use.
NOTIFY
Reserved for IBM internal use.
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.
ORDQUOTREL
Each row of this table represents a relationship between a parent Order and a child Order.
PAREQINFO
PSETADJMNT
This table stores information on product set adjustments and shows which product set is referenced by a term and condition for a business policy.
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.
QUEUE
This table contains customer care queue records for each store.
QUEUECSR
This table contains customer care queue assignment records for Customer Service Representatives.
QUEUEDESC
Customer Care Queue description
REFKEYS
The table represents a foreign relationship between tables that does not already exist in the database.
REPDLVRY
This table describes how StoreEntities want their automated commerce reports to be delivered.
RFQCATEGRY
This table holds categories created in each RFQ.
RFQRSPEVAL
This table holds all the response product evaluations for the RFQ.
RFQRSPPARL
This table holds the relationship of the personalized attributes in the RFQ and the response.
RFQTARGET
This table holds the target stores for RFQs.
ROLEDESC
SEGMENTATION
This table defines data mining segments (or models) used with WebSphere Commerce Analyzer.
SEGMENTATION_REF
Descriptions of the WCA Data Mining segments
SHPMODCLCD
The relationship between the calculation code and the shipmode for shipping promotion use.
SMTPHOST
This table maintains a list of SMTP servers where WebSphere Commerce has successfully connected to in the past. Any entries in this table should represent a valid SMTP server name and port pair.
STCGRYDESC
This table is deprecated and is provided for backward compatibility only.
STOREREL
Each row of this table describes a relationship between stores.
STRELTYP
This table identifies all the store relationship types defined in WebSphere Commerce.
STRELTYPDS
This table describes all the store relationships defined in the STRELTYP table.
TCATTR
This table stores information about the terms and conditions attributes specified within a contract. This table stores the XML data required by a term and condition.
WSALESVW
Reserved for IBM internal use.
WUSRTRVW
Reserved for IBM internal use.

Tables containing new columns

ATTACHMENT
  • MARKFORDELETE
  • DESCRIPTION
  • FILENAME
  • FILESIZE
  • CREATEMETHOD
  • IMAGE1
  • IMAGE2
  • CONTENT
  • RESERVED
ATTRIBUTE
  • QTYUNIT_ID
  • GROUPNAME
  • NOTEINFO
  • MULTITYPE
ATTRVALUE
  • QTYUNIT_ID
  • ATTACHMENT_ID
CATENTRY
  • STARTDATE
  • ENDDATE
  • RANK
CATGROUP
  • RANK
CATGRPDESC
  • NOTE
CATGRPPS
  • USAGE
CATGRPREL
  • CATALOG_ID_LINK
CATGRPTPC
  • STORE_ID
CATTOGRP
  • CATALOG_ID_LINK
CLEANCONF
  • STATEMENTTYPE
CONTRACT
  • FAMILY_ID
CPPMN
  • NUMACPALLOWED
FFMCENTER
  • EXTFFMSTORENUM
  • INVENTORYOPFLAGS
INTVSCHED
  • STOREENT_ID
ITEMFFMCTR
  • RESTOCKTIME
MASSOCCECE
  • DATE1
  • STORE_ID
MASSOCGPGP
  • DATE1
  • STORE_ID
MSGSTORE
  • EXPIRY
  • TRANSPORT_ID
  • STOREENT_ID
OICOMPLIST
  • SUPPLIERDATA
  • SUPPLIERPARTNUMBER
  • RFQPROD_ID
ORDERITEMS
  • SUPPLIERDATA
  • SUPPLIERPARTNUMBER
  • AVAILQUANTITY
ORDERS
  • COMMENTS
  • NOTIFICATIONID
ORDISTAT
  • SUPPLIERDATA
  • ORDSTAT_ID
ORDITAX
  • TAXCGRY_DSC
ORDRELEASE
  • EXTORDNUM
  • EXTREF
ORDSTAT
  • OSCODE
ORGENTITY
  • STATUS
PATTRVALUE
  • ORDERITEMS_ID
  • MANDATORY
  • ATTACHMENT_ID
  • CHANGEABLE
  • RFQPROD_ID
  • RFQRSPPROD_ID
  • CORRELATIONGROUP
PROFILE
  • ARCHIVEMSG
RFQ
  • RULETYPE
  • TRACKNUMBER
  • VERSIONFLAGS
  • EXTRFQNUM
  • FIELD1
  • FIELD2
  • FIELD3
  • FIELD4
  • FIELD5
  • FIELD6
RFQPROD
  • RFQPROD_ID
  • RFQPRODNAME
  • RFQCATEGRY_ID
  • CHANGEABLE
  • PRICEADJUSTMENT
  • NEGOTIATIONTYPE
  • FIELD1
  • FIELD2
  • FIELD3
  • FIELD4
RFQRSP
  • VERSIONFLAGS
  • STORE_ID
  • PREVRSP
  • ACCEPTACTION
  • EXTRFQRESPONSENUM
  • FIELD1
  • FIELD2
  • FIELD3
  • FIELD4
  • FIELD5
  • FIELD6
RFQRSPPROD
  • RFQRSPPROD_ID
  • RFQPROD_ID
  • SKUGENFLAG
  • PRICEADJUSTMENT
  • FIELD1
  • FIELD2
  • FIELD3
  • FIELD4
SCHACTIVE
  • SCSPRIORITY
STADDRESS
  • URL
STORE
  • CRTDBYCNTR_ID
  • LASTUPDATESTATUS
STOREENT
  • MARKFORDELETE
TMPBOLIST
  • BASEITEM_ID
  • MARKFORDELETE
  • FORCEBACKORDER
TMPCMPLIST
  • BASEITEM_ID
  • MARKFORDELETE
TRADING
  • REFTRADING_ID
TRDREFAMT
  • TRDREFAMT_ID
USRTRAFFIC
  • STORE_ID
  • CATGROUP_ID
  • CATENTRY_ID

Tables removed since version 5.4

CACHLOG
This table records changes to product or category information in the database. CACHLOG is populated by the cachlog triggers. Refer to Cache invalidation triggers from the online help.
CATALGDESC
Reserved for IBM internal use.
CATEGRYREL
Reserved for IBM internal use.
ENUMDESC
This table contains language specific descriptions of enumerations used in the Catalog Manager Web Editor.
PRICE
Reserved for IBM internal use.
PRICEDESC
Reserved for IBM internal use.
PRODDSTATR
Reserved for IBM internal use.
WCCATDESC
Reserved for IBM internal use.
WCCATEGORY
Reserved for IBM internal use.
WCCATRTCAT
Reserved for IBM internal use.
WCCATSTORS
Reserved for IBM internal use.
WCMLANG
This table contains the current installed Language for the Catalog Manager Web Editor.
WCPRDCTPID
Reserved for IBM internal use.
WCPRDPRICE
Reserved for IBM internal use.
WCPRODCATP
Reserved for IBM internal use.
WCPRODDESC
Reserved for IBM internal use.
WCPRODSHIP
Reserved for IBM internal use.
WCPRODUCT
Reserved for IBM internal use.

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

ACACGPDESC DISPLAYNAME
ACACTDESC DISPLAYNAME
ACATTRDESC DISPLAYNAME
ACCOUNT COMMENTS
ACPOLDESC DISPLAYNAME
ACRELDESC DISPLAYNAME
ACRELGRP CONDITIONS
ACRESGPDES DISPLAYNAME
ACRESGRP CONDITIONS
ACRSCGDES DISPLAYNAME
BASEITMDSC LONGDESCRIPTION
BZRPENTSTG VALUE
CALCODEDSC LONGDESCRIPTION
CALMETHOD DESCRIPTION
CATALOGDSC LONGDESCRIPTION
CATCONFINF REFERENCE
CATCONFINF URL
CATENTDESC AUXDESCRIPTION1
CATENTDESC AUXDESCRIPTION2
CATENTDESC LONGDESCRIPTION
CATENTDESC NAME
CATENTDESC XMLDETAIL
CATGRPDESC LONGDESCRIPTION
CLEANCONF STATEMENT
COLLDESC MARKETINGTEXT
CONTRACT COMMENTS
CONTRLRULE RULETEXT
EMSPOT DEFAULTRULE
FFMCENTDS DESCRIPTION
FLDOMNDESC DESCRIPTION
FLOWDESC DESCRIPTION
FLTRANSDSC EVENTDESC
FLTYPEDESC DESCRIPTION
FORUM DESCRIPTION
FORUMMSG ACTREMARK
FORUMMSG MSGBODY
INITIATIVE RULE
INVOICE INVOICEXML
MBRATTRVAL STRINGVALUE
MBRGRPCOND CONDITIONS
MESSAGE CONTENT
MSGSTORE MESSAGE
MSGVIEW CONTENT
ORDPAYMTHD XMLDATA
PARTICIPNT INFORMATION
PARTROLEDS DESCRIPTION
PATTRVALUE TERMCOND_ID
PAYSTATUS SETSWAKEUPMSG
PAYSUMMARY PAYSUMMARYXML
POLICYDESC DESCRIPTION
POLICYDESC LONGDESCRIPTION
PRODUCTSET XMLDEFINITION
REFUNDMTHD RETURNXML
RFQPROD CATENTRY_ID
RFQRSPPROD CATENTRY_ID
RLDISCOUNT RULEXML
ROLE DESCRIPTION
RULECLSREG NAME
SETSTATUS SETSWAKEUPMSG
SHIPMODE TRACKINGURL
STAGLOG STGLDCOLS
STORE STATUS
STORECGRY NAME
STOREENTDS DESCRIPTION
TCDESC LONGDESCRIPTION
TCSUBTYPDS DESCRIPTION
TFTRENGDSC LONGDESCRIPTION
TRDDESC LONGDESCRIPTION
TRDPSCNXML XMLDEFINITION
TRDTYPEDSC DESCRIPTION
USERPROF DESCRIPTION
USRTRAFFIC PREVURL
USRTRAFFIC QUERYSTRING
USRTRAFFIC REFURL

Feedback