Database schema changes from version 5.6 to version 6.0

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

Tables added since version 5.6


ATCHAST

This table holds the metadata for the attachment asset in the attachment target.


ATCHASTLG

This table holds the attachment asset to language relationship.


ATCHOBJTYP

This table holds the information about the types of business objects that are configured to have attachments. For example, attachments can be associated to CATALOG, CATGROUP, and CATENTRY business objects.


ATCHREL

This table holds the attachment relation between a business object and an attachment target.


ATCHRELDSC

This is a description table for an attachment relation.


ATCHRLUS

This table holds usage information for attachment relations. For example, an attachment can be a warranty document related to a product. In this case the usage is 'warranty'.


ATCHRLUSDS

This table holds the description of an attachment relation usage.


ATCHTGT

This table holds information about the target, which is used to hold a collection of assets, for use as an attachment target.


ATCHTGTDSC

This table holds the description of an attachment target.


BLKRSNCODE

Stores the various reason codes for which an Order may be blocked.


BLKRSNDESC

Holds Reason code description in different locales


BUSCHN

This table contains business channel information.


BUSCHNDESC

This table contains business channel descriptions for different locales.


BUSEVENT

The purpose of this table is to persist the event object so it can be later processed by those other applications that may want to participate in the event. The table will contain a sequence column where each 4K chunk of the XML will be stored in a separate record and can be pieced back based on a unique key and the sequence. One of the objectives of this table is to ensure that the data can be easy replicated using DB2 replication.


CALADJUST

A row in this table represents a calculation adjustment. A calculation adjustment is an adjustment created by a service representative to be applied to the calculation usage specified. Currently only shipping adjustments are supported.


CCOMMENT

This table contains information about a comment created by a user, user's organization, or comment Can be the user, the user's organization, or a customer service representative.


CMFILE

Contains the list of all the files that are content managed along with additional meta data.


CMFILEDIR

This table contains the directory structures for the content managed files. Reserved for IBM internal use.


CMFTASK

Holds the task information for workspaces


CMFTASKDSC

Holds the task description information for tasks in workspaces.


CMFTASKGRP

Holds the task group information for workspaces.


CMFTGCMT

Holds the task group comments for workspaces


CMFTGDSC

Holds the task group description information for workspaces.


CMFTGTSKREL

Holds the relationship between a task group and a task.


CMFTSKMBREL

Holds the task member-specific information.


CMFWKSPC

Holds workspace-specific information.


CMFWKSPCDSC

Holds workspace description-specific information.


CMFWSTGREL

Holds the relationship between a workspace and a task group.


CMLARGEFILE

Contains the physical bytes that makes up a particular managed file. This table contain only the contents of those files that are greater then 32K and have a storage type of 1 in the CMFILE table.


CMMETADATA

Records the business objects that have changed and the associated workspaces, task groups, and tasks that have made that change. This table will be used for resource locking and for determining the business objects that will be committed and published to production.


CMSMALLFILE

Contains the physical bytes that makes up a particular managed file. This table contains only the contents of those files that are less then or equal to 32K and have a storage type of 0 in the CMFILE table.


CMWORKSPACE

Contains a list of valid workspaces that may be assigned to an available schema pool.


CMWSSCHEMA

The association of the underlying database schemas that makes up the workspace along with the assigning the workspace to a workspace identifier.


CTXDATA

This table contains the data that associates with a particular activity.


CTXMGMT

This table contains the management information of each context service activity.


DKADJMNT

Stores adjustments to components within a specific dynamic kit.


DKOFFER

Stores prices of components within a dynamic kit


DKPDCCATENTREL

Contains relationships between predefined configurations and the dynamic kit catalog entries for which they are built.


DKPDCCOMPLIST

Contains the components within a predefined configuration.


DKPDCDESC

Contains the descriptions of predefined configurations.


DKPDCOFFERREL

Contains relationships between predefined configurations and the offers that price them.


DKPDCREL

Reserved for IBM internal use.


DKPREDEFCONF

Contains predefined configurations of dynamic kit catalog entries.


EDPATMPAY

Advanced orders Reserved for IBM internal use.


EDPATMREF

Advanced orders Reserved for IBM internal use.


EDPORDER

Advanced orders Reserved for IBM internal use.


EDPPAYHIST

Reserved for IBM internal use.


EDPPAYINST

Advanced orders Reserved for IBM internal use.


EDPREFINST

Advanced orders Reserved for IBM internal use.


EDPRELEASE

Advanced orders Reserved for IBM internal use.


EDPRELHIST

Reserved for IBM internal use.


EDPRMA

Advanced orders Reserved for IBM internal use.


EMLCONTENT

Stores the content of the e-mail template.


EMLMCREL

Stores the relationship between EMLMSG and EMLCONTENT table.


ESMAPOBJ

This table contains objects scheduled to E-Marketing Spot.


ESMAPTYP

This table contains object types that can be scheduled to E-Marketing Spot.


EXCHORDERS

IBM Internal Use Only.


EXPERIMENT

This table stores the definition of marketing experiments, which are used to measure the effectiveness of a web activity, and revise the activity if necessary in order to show the most effective marketing content to the targeted customer segment.


EXPLOG

This table records the relevant data of a recommendation event. It captures which marketing experiment was run, which experimental element was used, the e-Marketing Spot and what was recommended to the customer.


EXPRESULT

This table stores the randomly generated number, known as the experiment result, which is used to determine the control or test element to be used in the marketing experiment.


EXPSTATS

This table stores the statistics related to marketing experiments. The statistics include the number of impressions, the number of click-throughs, the number of orders generated by the display of the test element, and the total revenue associated with the orders.


EXPTYPE

This table stores all the available types of marketing experiment that a business user can choose.


GRADDR

This table stores address information for a gift registry.


GRANNHIST

This table stores a history of e-mail announcements sent regarding a gift registry. A registrant can send one or more announcements about their gift registry, and a history is stores in the database.


GRANNTMPLT

This table stores announcement e-mail template information. The registrant can select a template when sending an annoucement for a gift registry.


GREMLLIST

This table stores e-mail information used for gift registries, such as gift registry announcements


GRETDESC

This tables describes the event type for a gift registry.


GREVNTTYPE

This tables stores event information for a gift registry.


GREVTRMDLG

This table stores information about gift registry reminders.


GRGFTITM

This tables stores information about a gift registry item.


GRGFTREG

This table stores gift registry profile information.


GRPERATTR

This tables store personalization attributes for gift registry items, such as monogramming.


GRPURREC

This tables stores purchase record information, regarding items bought from a gift registry list.


GRREGRULE

This tables stores information about business rules for gift registries.


GRRGSTRNT

This table stores information about a gift registry registrant.


GRUSERAUTH

This table authenticates a user's access to view or edit a gift registry. A gift registrant or co-registrant can view and change gift registry information. A gift giver can view a gift registry list.


MERCHANT

No External description assigned yet


MERCHCONF

No External description assigned yet


MERCHCONFINFO

No External description assigned yet


OICOMPREL

Each row of this table defines an InventoryAdjustmentCode for a Store, or the Stores in a StoreGroup. Each code represents a reason for an InventoryAdjustment, such as broken, lost, or found.


OPSYSTEM

No External description assigned yet


ORDCHGRSN

No External description assigned yet


ORDCHGRSNDS

No External description assigned yet


ORDERBLK

Each row of this table defines an InventoryAdjustmentCode for a Store, or the Stores in a StoreGroup. Each code represents a reason for an InventoryAdjustment, such as broken, lost, or found.


ORDERHIST

No External description assigned yet


ORDERITEMGIFT

This table stores the relationship between an order item and a gift registry.


ORDITEMCONF

No External description assigned yet


ORDRLSTTLS

Store release level charges.


ORDUSERS

No External description assigned yet


PPCCREDIT

Advanced orders Reserved for IBM internal use.


PPCEXTDATA

Advanced orders Reserved for IBM internal use.


PPCPAYINST

Advanced orders Reserved for IBM internal use.


PPCPAYMENT

Advanced orders Reserved for IBM internal use.


PPCPAYTRAN

Advanced orders Reserved for IBM internal use.


PRCORSN

Price Override Reason - This table stores the reason the merchant needed to override a system calculated price.


PRCORSNDSC

Price Override Reason Description - This table stores the language-dependent description of the price override reason codes.


REPCUSTREL

This table defines the relationship between a customer service representative or team of representatives, and the customer or customer group that they are assigned to.


RMAITEMSERIAL

No External description assigned yet


ROLEASNPRM

Role Assignment Permission table. This table specifies the roles that users with a particular assigning role are able to assign to other users.


SHDCACRM

This table holds the relationship between the Scheduler Job ID and Initiative schedule ID. This relationship identifies which Job relates to which initiative schedule in order to modify the entry in the INTVSCHED table when an initiative schedule is updated or deleted.


SHIPINFO

This table is used to store two diffrent types of shipping information. Both sets of infomation will be passed in the generated PackSlip.xml file. The first set of infomation is to store shipping instructions. Only one set of shipping instructions will be captured for any order, address, and shipmode combination. The second set of infomation is to store a shipping carrier account number. A shipping carrier account number will be stored for any order and shipmode combination.


STORBLKRSN

Store level block reason code configuration. Used to configure whether a block reason code is turned on for a store and also configure whether this block reason code will generate ticklers.


STOREMERCH

No External description assigned yet


STQOTCFG

No External description assigned yet


TAGCLASS

Stores the relationship between a tag and the class name of the tag's implementation class.


TAGDISPLAY

Defines a display type. The JSP snippet is used to define the display format when the displayname is specified.


TAGDPLYREL

Stores the relationship between the TAGCLASS and TAGDISPLAY tables.


TICKLER

This table holds to-do items requiring actions to resolve.


TKLACTHIST

This table holds the history of actions that are performed on to-do items.


TKLRACTDSC

This table holds the description of actions that can be performed on to-do items.


TKLRACTION

This table holds the actions that can be performed on to-do items.


TKLRREASON

This table holds reasons for creating to-do items.


TKLRRSNDSC

This table holds description of reasons for creating to-do items.


WMMMAP

This table defines the mapping of member information between the WebSphere Commerce database and the Member Manager member repository (a database or an LDAP repository).

 

Tables containing new columns


ACCOUNT PRCPLCYPREF USEPRCPLCYPREF


BUSAUDIT WORKSPACE TASKGRP TASK ACTION


CALUSAGE STRELTYPNAMECFG STRELTYPNAMERT


CATENCALCD CALFLAGS


CATENTREL MANDATORY


CATENTRY AVAILABILITYDATE LASTORDERDATE ENDOFSERVICEDATE DISCONTINUEDATE


CATGPCALCD CALFLAGS


EMLMSG STATUS EMLBODYTYPE


EMSPOT USAGETYPE


FFMCENTER MAXNUMPICK PICKDELAYINMIN DROPSHIP RECEIPTQUANTITY


OICOMPLIST OICOMPREL_ID


ORCOMMENT ORDCHGRSN_ID SERVICEREP_ID BUSCHN_ID ORDERVERSION FIELD1 FIELD2 FIELD3


ORDERITEMS ISEXPEDITED REQUESTEDSHIPDATE TIECODE


ORDERS TYPE EDITOR_ID BUSCHN_ID SOURCEID EXPIREDATE BLOCKED OPSYSTEM_ID TRANSFERSTATUS BUYERPO_ID


ORDRELEASE FFMCENTER_ID ISEXPEDITED SHIPMODE_ID ADDRESS_ID MEMBER_ID STOREENT_ID


SITE EDITION VERSION RELEASE MOD FIXPACK


STAGLOG STGFILTER


STORE ALLOCATIONOFFSET MAXFOOFFSET INVENTORYOPFLAG BLOCKINGACTIVE BLKEXTASYNCH PERSISTENTSESSION ORDERHISTACTIVE INVENTORYSYSTEM


TMPCMPLIST OICOMPLIST_ID

 

Tables removed since version 5.6

INDEX

MAIN

URLREG

This table defines all the controller commands and their corresponding URI.

VIEWREG

This table defines the views.

 

Deprecated tables


ACCCMDGRP

This table defines all commands and views that require access control and categorizes 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.


BZSRVCFG

This table contains rule server configuration data. Each row represents a rule server. This table is deprecated and is provided for backward compatibility only.


BZSVCCFG

This table contains rule service configuration data. Each row represents a rule service configuration, including the rule server to which the service belongs. 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.


CATENTATTR

This table is deprecated and is provided for backward compatibility only. Attributes in this table should be migrated to the ATTRIBUTE and ATTRVALUE tables as descriptive attributes.


CATPRDREL

This table is deprecated and is provided for backward compatibility only.


CMBITEMS

This table is deprecated and is provided for backward compatibility only.


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. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.


CPITMAP

This table stores all of the items from the given (completed) order that were applicable to the selected coupon set. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.


CPOFFER

This table contains the promotions that are available to be shown to customers in their offer list. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.


CPPMN

This table gives the details of what a promotion is, and reference to its purchase, validity, and discount conditions. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.


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. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.


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. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.


CPPMNDESC

This table contains the language specific description of the promotion. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.


CPPMNDISC

This table contains the discount conditions for a promotion. Every coupon has exactly one calculation code. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.


CPPMNORD

This table contains the minimum purchase amount that must be in the shopping cart before this coupon is applicable. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.


CPPMNPROD

This table contains the purchase conditions for a promotion. If the purchase condition type in CPPMN table was "P", then this table is used to determine which items are required before this Coupon may be redeemed. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.


CPPMNVAL

Reserved for IBM internal use. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.


CPWALLET

This table contains the coupons that the user has accepted. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.


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.


ORDPAYMTHD

This table is deprecated and is provided for backward compatibility only. The Order Payment Method table contains order payment or refund methods selected for an order. It is also used to keep track of the actual amount charged or refunded against the order.


PAREQINFO

Reserved for IBM internal use. 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.


REFUNDMTHD

This table is deprecated and is provided for backward compatibility only.


REPORT

This table is deprecated and is provided for backward compatibility only.


RLDISCOUNT

This table defines the additional attributes of a promotion object for Blaze Rule Engine use. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.


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


PVCBUFFER

PARAMETERS


PVCDEVMDL

MODELNAME


PVCDEVSPEC

SESSIONTYPE


STORECGRY

REMARK


TAXTYPE

SEQUENCE


TRADEPOSCN

FLAGS


USERPVCDEV

DEVICEIDENTIFIER


USERS

REGISTERTYPE

 

Tables containing changed columns


ACACGPDESC DISPLAYNAME


ACACGPDESC DESCRIPTION


ACACTDESC DISPLAYNAME


ACACTDESC DESCRIPTION


ACPLGPDESC DISPLAYNAME


ACPLGPDESC DESCRIPTION


ACPOLDESC DISPLAYNAME


ACPOLDESC DESCRIPTION


ACRESGPDES DISPLAYNAME


ACRESGPDES DESCRIPTION


ACRSCGDES DISPLAYNAME


ACRSCGDES DESCRIPTION


ADDRESS ADDRESS1


ATTACHMENT CONTENT


BASEITEM PARTNUMBER


BUSAUDIT SIGNATURE


BUSAUDIT PARAMETERS


BUYSUPSEC BUYERLOGONPASSWORD


BUYSUPSEC SUPLOGONPASSWORD


CATENCALCD CALCODE_ID


CATENTDESC LONGDESCRIPTION


CATENTDESC XMLDETAIL


CATGPCALCD CALCODE_ID


CNTRSTORE STOREXML


EMLBADADDR REASONCODE1


EMLBADADDR REASONCODE2


EMLBOUNCED RETRYCOUNT


EMLBOUNCED MAXRETRYHIT


EMLCFG PASSWORD


EMLMSG JSPPATH


EMLRCPTS RECIPIENTS


FFMCENTDS DISPLAYNAME


ICMREGDESC TITLE


INITIATIVE RULE


INVOICE INVOICEXML


ITEMVERSN VERSIONNAME


MBRGRPCOND CONDITIONS


MESSAGE CONTENT


MSGARCHIVE MESSAGE


MSGSTORE MESSAGE


MSGVIEW CONTENT


ORCOMMENT COMMENTS


ORDERS STATUS


ORDPAYINFO VALUE


ORDPAYMTHD PAYDEVICE


ORDPAYMTHD XMLDATA


ORDRELEASE PACKSLIPXML


PAYSUMMARY PAYSUMMARYXML


PICKBATCH PICKSLIPXML


PRODUCTSET XMLDEFINITION


PX_DYNATTR XMLPARAM


PX_GROUP XMLPARAM


PX_POLICY XMLPARAM


PX_PROMOARG DETAIL


PX_PROMOTION XMLPARAM


REFKEYS TABLENAME


REFKEYS FKTABLE_NAME


REFKEYS FKCOLUMN_NAME


RLDISCOUNT RULEXML


RTNDNYDESC DESCRIPTION


RULECLSREG NAME


SCHERRORLOG SCSERROR


STAGLOG STGTABLE


STOREENTDS DISPLAYNAME


TCATTR XMLDEFINITION


TRDPSCNXML XMLDEFINITION


USERREG LOGONPASSWORD


WCSGBLDATA GLOBALDATA