Feature Pack 3

Application changes when you enable foundation

Enabling foundation makes changes to a number of files and database tables.

When you enable foundation:
  • Changes are made to the WebSphere Commerce EAR file
  • Changes are made to the database
  • A new WebSphere Application Server profile is created
  • A new WebSphere Application Server server is created
  • A new Solr JEE application is installed and configured under the new WebSphere Application Server server
For more information on the changes made to the WebSphere Commerce EAR file and the database, see:

Changes to the EAR file when foundation is enabled

The following changes occur:
  • No files are deleted from the WebSphere Commerce EAR file
  • Files are added to the WebSphere Commerce EAR file
  • No files are changed in the WebSphere Commerce EAR file
The following new files or modules are added to the EAR file after you enable foundation.
  • Catalog-ProductManagementLogic-FEP.jar
  • Catalog-Server-FEP.jar
  • Content-Server-FEP.jar
  • Contract-Server-FEP.jar
  • Enablement-BaseComponentsLogic-FEP.jar
  • Enablement-JCAConfiguratorConnector.rar
  • Enablement-JCAKickAppsConnector.rar
  • Enablement-RelationshipManagementLogic-FEP.jar
  • Foundation-Core-FEP.jar
  • Foundation-DataImport.jar
  • Foundation-DataLoad-FEP.jar
  • Foundation-Extension-FEP.jar
  • Foundation-Server-FEP.jar
  • GiftCenter-Client.jar
  • GiftCenter-DataObjects.jar
  • GiftCenter-Server.jar
  • GiftCenterServicesHTTPInterface.war
  • ILogJRules-Server.jar
  • ILogJRulesLogic.jar
  • Infrastructure-Client-FEP.jar
  • Infrastructure-Server-FEP.jar
  • Installment-Client.jar
  • Installment-DataObjects.jar
  • Installment-Server.jar
  • InstallmentServicesHTTPInterface.war
  • Marketing-Server-FEP.jar
  • Member-Server-FEP.jar
  • Order-Client-FEP.jar
  • Order-Server-FEP.jar
  • Price-Server-FEP.jar
  • Promotion-Server-FEP.jar
  • Rest.war
  • RestPreview.war
  • Search-Client.jar
  • Search-DataObjects.jar
  • Search-IndexSetup.jar
  • Search-Server.jar
  • SearchServicesHTTPInterface.war
  • SEO-BaseComponentLogic-FEP.jar
  • Subscription-Client.jar
  • Subscription-DataObjects.jar
  • Subscription-Server.jar
  • SubscriptionServicesHTTPInterface.war
  • Wallet-Client.jar
  • Wallet-CouponIntegrationLogic.jar
  • Wallet-DataObjects.jar
  • Wallet-Server.jar
  • WalletServicesHTTPInterface.war
  • CommerceAccelerator.war\javascript\tools\contract\PriceRuleDialog.js
  • CommerceAccelerator.war\tools\contract\B2CEsitePriceRule.jsp
  • CommerceAccelerator.war\WEB-INF\struts-config-pricerule-fep.xml
  • CommerceAccelerator.war\WEB-INF\struts-config-promotion-services-fep.xml
  • SiteAdministration.war\WEB-INF\struts-config-pricerule-fep2.xml
  • SiteAdministration.war\WEB-INF\struts-config-web-feed-fep.xml
  • Stores.war\WEB-INF\config\com.ibm.commerce.catalog-fep\get-data-config.xml
  • Stores.war\WEB-INF\config\com.ibm.commerce.giftcenter\get-data-config.xml
  • Stores.war\WEB-INF\config\com.ibm.commerce.infrastructure-fep\get-data-config.xml
  • Stores.war\WEB-INF\config\com.ibm.commerce.installment\get-data-config.xml
  • Stores.war\WEB-INF\config\com.ibm.commerce.installment\wc-installment-clientobjects.xml
  • Stores.war\WEB-INF\config\com.ibm.commerce.order-fep\get-data-config.xml
  • Stores.war\WEB-INF\config\com.ibm.commerce.price-fep\get-data-config.xml
  • Stores.war\WEB-INF\config\com.ibm.commerce.search\get-data-config.xml
  • Stores.war\WEB-INF\config\com.ibm.commerce.subscription\get-data-config.xml
  • Stores.war\WEB-INF\config\com.ibm.commerce.wallet\get-data-config.xml
  • Stores.war\WEB-INF\struts-config-catalog-fep.xml
  • Stores.war\WEB-INF\struts-config-giftcenter-services.xml
  • Stores.war\WEB-INF\struts-config-marketing-services-fep.xml
  • Stores.war\WEB-INF\struts-config-member-services-fep.xml
  • Stores.war\WEB-INF\struts-config-order-services-fep.xml
  • Stores.war\WEB-INF\struts-config-price-services-fep.xml
  • Stores.war\WEB-INF\struts-config-search-fep.xml
  • Stores.war\WEB-INF\struts-config-seo-fep.xml
  • Stores.war\WEB-INF\struts-config-subscription-services.xml
  • Stores.war\WEB-INF\struts-config-wallet-services.xml
  • Stores.war\UserRegistrationEmailActivateNotification.jsp
  • WebServicesRouter.war\component-services\ecore\com.ibm.commerce.giftcenter.facade.datatypes.ecore
  • WebServicesRouter.war\component-services\ecore\com.ibm.commerce.installment.facade.datatypes.ecore
  • WebServicesRouter.war\component-services\ecore\com.ibm.commerce.search.facade.datatypes.ecore
  • WebServicesRouter.war\component-services\ecore\com.ibm.commerce.subscription.facade.datatypes.ecore
  • WebServicesRouter.war\component-services\ecore\com.ibm.commerce.wallet.facade.datatypes.ecore
  • WebServicesRouter.war\component-services\ecore\GiftCenter.genmodel
  • WebServicesRouter.war\component-services\ecore\Installment.genmodel
  • WebServicesRouter.war\component-services\ecore\Search.genmodel
  • WebServicesRouter.war\component-services\ecore\Subscription.genmodel
  • WebServicesRouter.war\component-services\ecore\Wallet.genmodel
  • WebServicesRouter.war\component-services\wsdl\GiftCenterServices.wsdl
  • WebServicesRouter.war\component-services\wsdl\InstallmentServices.wsdl
  • WebServicesRouter.war\component-services\wsdl\SearchServices.wsdl
  • WebServicesRouter.war\component-services\wsdl\SubscriptionServices.wsdl
  • WebServicesRouter.war\component-services\wsdl\WalletServices.wsdl
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\AcknowledgeGiftList.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\AcknowledgeInstallmentRule.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\AcknowledgeSearchTermAssociation.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\AcknowledgeSubscription.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\AcknowledgeWallet.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\AcknowledgeWalletItem.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ChangeGiftList.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ChangeInstallmentRule.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ChangeSearchTermAssociation.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ChangeSubscription.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ChangeWallet.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ChangeWalletItem.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\GetCatalogEntryInstallmentPrice.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\GetGiftList.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\GetInstallmentRule.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\GetOrderInstallmentPrice.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\GetSearchTermAssociation.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\GetSubscription.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\GetWallet.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\GetWalletItem.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ProcessGiftList.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ProcessInstallmentRule.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ProcessSearchTermAssociation.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ProcessSubscription.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ProcessWallet.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ProcessWalletItem.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\RespondGiftList.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\RespondInstallmentRule.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\RespondSearchTermAssociation.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\RespondSubscription.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\RespondWallet.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\RespondWalletItem.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ShowCatalogEntryInstallmentPrice.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ShowGiftList.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ShowInstallmentRule.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ShowOrderInstallmentPrice.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ShowSearchTermAssociation.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ShowSubscription.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ShowWallet.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\ShowWalletItem.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\SyncWallet.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\BODs\SyncWalletItem.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\Resources\Components\InstallmentCommon.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\Resources\Nouns\CatalogEntryInstallmentPrice.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\Resources\Nouns\GiftList.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\Resources\Nouns\InstallmentRule.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\Resources\Nouns\OrderInstallmentPrice.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\Resources\Nouns\SearchTermAssociation.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\Resources\Nouns\Subscription.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\Resources\Nouns\Wallet.xsd
  • WebServicesRouter.war\component-services\xsd\OAGIS\9.0\Overlays\IBM\Commerce\Resources\Nouns\WalletItem.xsd
  • lib\apache-solr-core-1.4.0.jar
  • lib\apache-solr-solrj-1.4.0.jar
  • lib\commons-codec-1.3.jar
  • lib\commons-httpclient-3.1.jar
  • lib\httpclient-4.0.1.jar
  • lib\httpcore-4.0.1.jar
  • lib\ibm-wink-jaxrs-1.0.0.jar
  • lib\jsr311-api-1.0.jar
  • lib\slf4j-api-1.5.8.jar
  • lib\slf4j-jdk14-1.5.8.jar
  • properties\version\install\7.0.0.0\backup\componentmaps\componentmap.fep3.primary.xml
  • properties\version\install\7.0.0.0\backup\componentmaps\componentmap.foundation.ejbs.server.db2.xml
  • properties\version\install\7.0.0.0\backup\componentmaps\componentmap.foundation.ejbs.server.oracle.xml
  • properties\version\install\7.0.0.0\backup\componentmaps\componentmap.foundation.server.70.be.xml
  • properties\version\install\7.0.0.0\backup\componentmaps\componentmap.foundation.server.70.xml
  • properties\version\install\7.0.0.0\backup\foundation.ejbs.server.db2\files.list
  • properties\version\install\7.0.0.0\backup\foundation.ejbs.server.oracle\files.list
  • properties\version\install\7.0.0.0\backup\foundation.server.70\files.list
  • properties\version\install\7.0.0.0\backup\foundation.server.70.be\files.list
  • properties\version\install\7.0.0.0\backup\nif.componentmap.foundation.ejbs.server.db2\files.list
  • properties\version\install\7.0.0.0\backup\nif.componentmap.foundation.ejbs.server.oracle\files.list
  • properties\version\install\7.0.0.0\backup\nif.componentmap.foundation.server.70\files.list
  • properties\version\install\7.0.0.0\backup\nif.componentmap.foundation.server.70.be\files.list
  • properties\version\fep3.id.component
  • properties\version\FEP3.product
  • properties\version\foundation.ejbs.server.db2.component
  • properties\version\foundation.server.70.be.component
  • properties\version\foundation.server.70.component
  • properties\ExternalRuleEngineConfiguration.properties
  • properties\ILogJRulesConfiguration.properties
  • properties\UserRegistrationEmailActivateNotification.properties
  • properties\UserRegistrationEmailActivateNotification_de_DE.properties
  • properties\UserRegistrationEmailActivateNotification_en_US.properties
  • properties\UserRegistrationEmailActivateNotification_es_ES.properties
  • properties\UserRegistrationEmailActivateNotification_fr_FR.properties
  • properties\UserRegistrationEmailActivateNotification_it_IT.properties
  • properties\UserRegistrationEmailActivateNotification_ja_JP.properties
  • properties\UserRegistrationEmailActivateNotification_ko_KR.properties
  • properties\UserRegistrationEmailActivateNotification_pl_PL.properties
  • properties\UserRegistrationEmailActivateNotification_pt_BR.properties
  • properties\UserRegistrationEmailActivateNotification_ro_RO.properties
  • properties\UserRegistrationEmailActivateNotification_ru_RU.properties
  • properties\UserRegistrationEmailActivateNotification_zh_CN.properties
  • properties\UserRegistrationEmailActivateNotification_zh_TW.properties
  • xml\config\com.ibm.commerce.catalog\dataload\wc-dataload-env.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-dataload.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-AD-attribute-allowed-values.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-AD-attribute-and-allowed-values.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-description.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-entry-AD-attribute-relationship.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-entry-association.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-entry-ATP-inventory.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-entry-calculation-code.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-entry-component.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-entry-description.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-entry-descriptive-attribute-and-value.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-entry-inventory.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-entry-listprice-list.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-entry-offerprice.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-entry-parent-catalog-group.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-entry-parent-product.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-entry.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-filter-category.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-filter-catentry.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-filter-condition-group.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-filter-condition.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-filter.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-group-association.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-group-calculation-code.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-group-description.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-group-relationship.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog-group.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-catalog.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-product-defining-attribute-and-allowed-values.xml
  • xml\config\com.ibm.commerce.catalog\dataload\wc-loader-SKU-defining-attribute-value.xml
  • xml\config\com.ibm.commerce.catalog-fep\SDO.properties
  • xml\config\com.ibm.commerce.catalog-fep\wc-business-object-mediator.xml
  • xml\config\com.ibm.commerce.catalog-fep\wc-component.xml
  • xml\config\com.ibm.commerce.catalog-fep\wc-event.xml
  • xml\config\com.ibm.commerce.catalog-fep\wc-object-relational-metadata.xml
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-AttributeDictionaryAttribute-admin-get.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-AttributeDictionaryAttribute-get.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-AttributeDictionaryAttribute-update.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-CatalogEntry-admin-get-fep.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-CatalogEntry-get-fep.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-CatalogEntry-update-fep.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-CatalogFilter-admin-get.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-CatalogFilter-get.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-CatalogFilter-update.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-CatalogGroup-admin-get-fep.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-utilities-fep.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-utilities-fep1.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-utilities-fep2.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-query-utilities-fep3.tpl
  • xml\config\com.ibm.commerce.catalog-fep\wc-search.xml
  • xml\config\com.ibm.commerce.content-fep\wc-business-object-mediator.xml
  • xml\config\com.ibm.commerce.content-fep\wc-component.xml
  • xml\config\com.ibm.commerce.content-fep\wc-event.xml
  • xml\config\com.ibm.commerce.content-fep\wc-object-relational-metadata.xml
  • xml\config\com.ibm.commerce.content-fep\wc-query-ContentVersion-get.tpl
  • xml\config\com.ibm.commerce.content-fep\wc-query-ContentVersion-update.tpl
  • xml\config\com.ibm.commerce.content-fep\wc-query-FileUploadJob-get.tpl
  • xml\config\com.ibm.commerce.content-fep\wc-query-FileUploadJob-update.tpl
  • xml\config\com.ibm.commerce.content-fep\wc-query-utilities.tpl
  • xml\config\com.ibm.commerce.contract-fep\wc-component.xml
  • xml\config\com.ibm.commerce.foundation-fep\wc-component.xml
  • xml\config\com.ibm.commerce.foundation-fep\wc-config-mapping-registry.xml
  • xml\config\com.ibm.commerce.giftcenter\SDO.properties
  • xml\config\com.ibm.commerce.giftcenter\wc-business-context.xml
  • xml\config\com.ibm.commerce.giftcenter\wc-business-object-mediator.xml
  • xml\config\com.ibm.commerce.giftcenter\wc-component-client.xml
  • xml\config\com.ibm.commerce.giftcenter\wc-component.xml
  • xml\config\com.ibm.commerce.giftcenter\wc-GiftList-RuleValidator-ext.xml
  • xml\config\com.ibm.commerce.giftcenter\wc-GiftList-RuleValidator.xml
  • xml\config\com.ibm.commerce.giftcenter\wc-object-relational-metadata.xml
  • xml\config\com.ibm.commerce.giftcenter\wc-query-GiftList-get.tpl
  • xml\config\com.ibm.commerce.giftcenter\wc-query-GiftList-update.tpl
  • xml\config\com.ibm.commerce.giftcenter\wc-query-utilities.tpl
  • xml\config\com.ibm.commerce.infrastructure-fep\wc-admin-component.xml
  • xml\config\com.ibm.commerce.infrastructure-fep\wc-business-object-mediator.xml
  • xml\config\com.ibm.commerce.infrastructure-fep\wc-component.xml
  • xml\config\com.ibm.commerce.infrastructure-fep\wc-event.xml
  • xml\config\com.ibm.commerce.infrastructure-fep\wc-object-relational-metadata.xml
  • xml\config\com.ibm.commerce.infrastructure-fep\wc-query-OnlineStore-get.tpl
  • xml\config\com.ibm.commerce.infrastructure-fep\wc-query-OnlineStore-update.tpl
  • xml\config\com.ibm.commerce.infrastructure-fep\wc-query-OnlineStore-utilities.tpl
  • xml\config\com.ibm.commerce.installment\SDO.properties
  • xml\config\com.ibm.commerce.installment\wc-business-object-mediator.xml
  • xml\config\com.ibm.commerce.installment\wc-component-client.xml
  • xml\config\com.ibm.commerce.installment\wc-component.xml
  • xml\config\com.ibm.commerce.installment\wc-object-relational-metadata.xml
  • xml\config\com.ibm.commerce.installment\wc-query-InstallmentRule-get.tpl
  • xml\config\com.ibm.commerce.installment\wc-query-InstallmentRule-update.tpl
  • xml\config\com.ibm.commerce.installment\wc-query-utilities.tpl
  • xml\config\com.ibm.commerce.inventory-fep\wc-component.xml
  • xml\config\com.ibm.commerce.marketing\dataload\wc-dataload-env.xml
  • xml\config\com.ibm.commerce.marketing\dataload\wc-dataload.xml
  • xml\config\com.ibm.commerce.marketing\dataload\wc-loader-merchandising-association.xml
  • xml\config\com.ibm.commerce.marketing-fep\wc-business-object-mediator.xml
  • xml\config\com.ibm.commerce.marketing-fep\wc-component.xml
  • xml\config\com.ibm.commerce.marketing-fep\wc-object-relational-metadata.xml
  • xml\config\com.ibm.commerce.marketing-fep\wc-query-utilities-fep.tpl
  • xml\config\com.ibm.commerce.member-fep\wc-business-object-mediator.xml
  • xml\config\com.ibm.commerce.price\dataload\wc-dataload-env.xml
  • xml\config\com.ibm.commerce.price\dataload\wc-dataload.xml
  • xml\config\com.ibm.commerce.price\dataload\wc-loader-offer.xml
  • xml\config\com.ibm.commerce.price-fep\wc-admin-component.xml
  • xml\config\com.ibm.commerce.price-fep\wc-business-object-mediator.xml
  • xml\config\com.ibm.commerce.price-fep\wc-component.xml
  • xml\config\com.ibm.commerce.price-fep\wc-event.xml
  • xml\config\com.ibm.commerce.price-fep\wc-object-relational-metadata.xml
  • xml\config\com.ibm.commerce.price-fep\wc-query-PriceConstant-get.tpl
  • xml\config\com.ibm.commerce.price-fep\wc-query-PriceConstant-update.tpl
  • xml\config\com.ibm.commerce.price-fep\wc-query-PriceEquation-get.tpl
  • xml\config\com.ibm.commerce.price-fep\wc-query-PriceRule-get.tpl
  • xml\config\com.ibm.commerce.promotion-fep\template\CategoryPurchaseWithPurchasePercentOffPurchaseConditionTemplate.xsl
  • xml\config\com.ibm.commerce.promotion-fep\com.ibm.commerce.promotion.facade.server.config.PromotionComponentConfigurationImpl.xml
  • xml\config\com.ibm.commerce.promotion-fep\wc-admin-component.xml
  • xml\config\com.ibm.commerce.promotion-fep\wc-business-object-mediator.xml
  • xml\config\com.ibm.commerce.promotion-fep\wc-component.xml
  • xml\config\com.ibm.commerce.promotion-fep\wc-object-relational-metadata.xml
  • xml\config\com.ibm.commerce.promotion-fep\wc-query-Promotion-get-fep.tpl
  • xml\config\com.ibm.commerce.promotion-fep\wc-query-Promotion-update-fep.tpl
  • xml\config\com.ibm.commerce.search\SDO.properties
  • xml\config\com.ibm.commerce.search\wc-business-object-mediator.xml
  • xml\config\com.ibm.commerce.search\wc-component-client.xml
  • xml\config\com.ibm.commerce.search\wc-component.xml
  • xml\config\com.ibm.commerce.search\wc-object-relational-metadata.xml
  • xml\config\com.ibm.commerce.search\wc-query-SearchTermAssociation-get.tpl
  • xml\config\com.ibm.commerce.search\wc-query-SearchTermAssociation-update.tpl
  • xml\config\com.ibm.commerce.search\wc-query-utilities.tpl
  • xml\config\com.ibm.commerce.store-fep\wc-component.xml
  • xml\config\com.ibm.commerce.subscription\xsd\SubscriptionConfiguration.xsd
  • xml\config\com.ibm.commerce.subscription\com.ibm.commerce.subscription.facade.server.config.SubscriptionConfigurationImpl.xml
  • xml\config\com.ibm.commerce.subscription\SDO.properties
  • xml\config\com.ibm.commerce.subscription\wc-business-object-mediator.xml
  • xml\config\com.ibm.commerce.subscription\wc-component-client.xml
  • xml\config\com.ibm.commerce.subscription\wc-component.xml
  • xml\config\com.ibm.commerce.subscription\wc-object-relational-metadata.xml
  • xml\config\com.ibm.commerce.subscription\wc-query-Subscription-get.tpl
  • xml\config\com.ibm.commerce.subscription\wc-query-Subscription-update.tpl
  • xml\config\com.ibm.commerce.subscription\wc-query-Subscription-utilities.tpl
  • xml\config\com.ibm.commerce.wallet\SDO.properties
  • xml\config\com.ibm.commerce.wallet\wc-business-object-mediator.xml
  • xml\config\com.ibm.commerce.wallet\wc-component-client.xml
  • xml\config\com.ibm.commerce.wallet\wc-component.xml
  • xml\config\com.ibm.commerce.wallet\wc-object-relational-metadata.xml
  • xml\config\com.ibm.commerce.wallet\wc-query-Wallet-get.tpl
  • xml\config\com.ibm.commerce.wallet\wc-query-Wallet-update.tpl
  • xml\config\com.ibm.commerce.wallet\wc-query-WalletItem-get.tpl
  • xml\config\com.ibm.commerce.wallet\wc-query-WalletItem-update.tpl
  • xml\config\dataextract\logging.properties
  • xml\config\dataimport\buildindex-logging.properties
  • xml\config\dataimport\crawler-logging.properties
  • xml\config\dataimport\logging.properties
  • xml\config\dataload\URLEntries.properties
  • xml\config\dataload\wc-dataload.xml.template
  • xml\config\dataload\wc-loader-managedFile.xml
  • xml\config\dataload\wc-loader-staticContent.xml
  • xml\config\dataload\wc-loader-URLAttachment.xml
  • xml\config\payments\edp\groups\default\SPSPOffline\AVSRules.xml
  • xml\config\payments\edp\groups\default\SPSPOffline\CoreCancelOrderPaymentActions.xml
  • xml\config\payments\edp\groups\default\SPSPOffline\CoreEditActions.xml
  • xml\config\payments\edp\groups\default\SPSPOffline\CoreEditReversePaymentActions.xml
  • xml\config\payments\edp\groups\default\SPSPOffline\CorePaymentActions.xml
  • xml\config\seourlload\logging.properties
  • xml\config\xsd\wc-dataimport-preprocess.xsd
  • xml\config\xsd\wc-event.xsd
  • xml\config\xsd\wc-search.xsd
  • xml\config\xsd\wc-seo-url-pattern.xsd
  • xml\config\xsd\Web-Feed-config.xsd
  • xml\content-management\com.ibm.commerce.catalog.resource-managers-fep.xml
  • xml\content-management\com.ibm.commerce.installment.resource-managers-fep.xml
  • xml\content-management\com.ibm.commerce.marketing.resource-managers-fep.xml
  • xml\content-management\com.ibm.commerce.promotion.resource-managers-fep.xml
  • xml\content-management\com.ibm.commerce.search.resource-managers-fep.xml
  • xml\tools\contract\PriceRuleDialog.xml
  • xml\config\bi\biConfig.xml xml\config\com.ibm.commerce.order\wc-admin-component.xml xml\config\payments\edp\groups\default\PaymentMappings.xml
  • xml\config\payments\edp\groups\default\PaymentMethodConfigurations.xml xml\config\payments\ppc\plugins\SimpleOffline\SimpleOfflinePlugin.xml
  • xml\config\wc-attribute-masking.xml xml\config\wc-server.xml xml\tools\common\CommerceAcceleratorB2B.xml
  • xml\tools\common\CommerceAcceleratorB2C.xml xml\tools\common\CommerceAcceleratorBBB.xml xml\tools\common\CommerceAcceleratorBMH.xml
  • xml\tools\common\CommerceAcceleratorMHS.xml xml\tools\contract\resources.xml xml\trading\xml\DeploymentHostingContractBMH.xml
  • xml\trading\xml\DeploymentHostingContractMHS.xml xml\trading\xml\TCConfiguration.xml xml\trading\xml\TemplateHostingContractBMP.xml
  • xml\trading\xml\TemplateHostingContractBRP.xml xml\trading\xml\TemplateHostingContractMPS.xml xml\trading\xml\TemplateHostingContractRPS.xml
  • xml\trading\xml\TemplateHostingContractSPS.xml

Changes to the database when foundation is enabled

Changes to the listed database tables are performed by the SQL files in the WC_installdir\components\foundation\schema\fep3\ directory.

New tables

Enabling foundation creates the following new tables:
  • ATTRDICTSRCHCONF
  • CATENTSUBS
  • CATFILTER
  • CATFLTDSC
  • CFCATGROUP
  • CFCOND
  • CFCONDGRP
  • CFCONDVAL
  • CFPRODUCTSET
  • CLSATTRSRCHCONF
  • CMEXTDATA
  • CMFEEDLOG
  • CMPRMYOBJ
  • DKOFFERADJMNT
  • DMRANKINGITEM
  • DMRANKINGSTAT
  • FILEPROCREL
  • INSRULE
  • INSRULECATENT
  • INSRULECATGRP
  • INSRULECOND
  • INSRULEINSOPT
  • INSRULEPAYMTHD
  • OICONFIG
  • ORDERREL
  • PRCONSTANT
  • PRCONVALUE
  • PRELEMENT
  • PRELEMENTATTR
  • PRELETEMPLATE
  • PRELETPLTGRP
  • PREQENTRY
  • PREQENTRYTYPE
  • PREQUATION
  • PRICERULE
  • PROCESSFILE
  • PX_CDPOOL
  • PX_CDPROMO
  • PX_CDSPEC
  • PX_CDUSAGE
  • SEOPAGEDEF
  • SEOPAGEDEFDESC
  • SEOPAGEDEFOVR
  • SEOPAGEDEFSUBPARAM
  • SEOREDIRECT
  • SEOREDIRECTTRAFFIC
  • SEOTOKENUSGTYPE
  • SEOURL
  • SEOURLKEYWORD
  • SRCHATTR
  • SRCHATTRPROP
  • SRCHCONF
  • SRCHCONFEXT
  • SRCHSTAT
  • SRCHTERM
  • SRCHTERMASSOC
  • STORETPC
  • STTPCUSG
  • SUBSCPTYPE
  • SUBSCRIPTION
  • SUBSCRRENEW
  • SUBSCRSCHJOBS
  • SUBSCRSUSPEND
  • SUBSCRTEMPLATE
  • SUBSCRTMPLITEMLIST
  • UPLOADFILE
  • WALLET
  • WALLETITEM
  • WIREL

Existing tables

Enabling foundation does not alter any existing tables.

New indexes

Enabling creates the following indexes.
  • I0001302
  • I0001303
  • I0001308
  • I0001309
  • I0001310
  • I0001311
  • I0001312
  • I0001313
  • I0001314
  • I0001315
  • I0001316
  • I0001317
  • I0001318
  • I0001319
  • I0001320
  • I0001322
  • I0001323
  • I0001324
  • I0001325
  • I0001326
  • I0001327
  • I0001328
  • I0001329
  • I0001330
  • I0001331
  • I0001332
  • I0001333
  • I0001334
  • I0001335
  • I0001340
  • I0001341
  • I0001342
  • I0001343
  • I0001344
  • I0001345
  • I0001346
  • I0001347
  • I0001348
  • I0001349
  • I0001350
  • I0001351
  • I0001352
  • I0001353
  • I0001354
  • I0001355
  • I0001356
  • I0001357
  • I0001358
  • I0001359
  • I0001360
  • I0001361
  • I0001362
  • I0001363
  • I0001364
  • I0001365
  • I0001366
  • I0001367
  • I0001368
  • I0001369
  • I0001370
  • I0001371
  • I0001372
  • I0001373
  • I0001374
  • I0001375
  • I0001376
  • I0001377
  • I0001378
  • I0001379
  • I0001380
  • I0001381
  • I0001382
  • I0001383
  • I0001384
  • I0001385
  • I0001386
  • I0001387
  • I0001388
  • I0001390
  • I0001391
  • I0001392
  • I0001393
  • I0001394
  • I0001395
  • I0001396
  • I0001397
  • I0001398
  • I0001399
  • I0001400
  • I0001401
  • I0001402
  • I0001403
  • I0001404
  • I0001405
  • I0001406
  • I0001407
  • I0001408
  • I0001409
  • I0001410
  • I0001411
  • I0001412
  • I0001413
  • I0001414
  • I0001415
  • I0001416
  • I0001417
  • I0001418
  • I0001419
  • I0001420
  • I0001421
  • I0001422
  • I0001423
  • I0001424
  • I0001425
  • I0001426
  • I0001427
  • I0001428
  • I0001429
  • I0001430
  • I0001431
  • I0001432
  • I0001433

New triggers

Enabling foundation creates the following new triggers:
  • CIVD_HAP
  • CIVD_HAT
  • CIVD_HTA
  • CIVD_HTM
  • CIVD_PCO
  • CIVD_PEQ
  • CIVD_PRL
  • CIVD_SEK
  • CIVD_SER
  • CIVD_SEU
  • CIVD_STP
  • CIVI_HAP
  • CIVI_HAT
  • CIVI_HTA
  • CIVI_HTM
  • CIVI_PCO
  • CIVI_PEQ
  • CIVI_PRL
  • CIVI_SEK
  • CIVI_SER
  • CIVI_SEU
  • CIVI_STP
  • CIVU_HAP
  • CIVU_HAT
  • CIVU_HTA
  • CIVU_HTM
  • CIVU_PCO
  • CIVU_PEQ
  • CIVU_PRL
  • CIVU_SEK
  • CIVU_SER
  • CIVU_SEU
  • CIVU_STP
  • STAG1246
  • STAG1247
  • STAG1248
  • STAG1249
  • STAG1250
  • STAG1251
  • STAG1252
  • STAG1253
  • STAG1254
  • STAG1255
  • STAG1256
  • STAG1257
  • STAG1258
  • STAG1259
  • STAG1260
  • STAG1261
  • STAG1262
  • STAG1263
  • STAG1264
  • STAG1265
  • STAG1266
  • STAG1267
  • STAG1268
  • STAG1269
  • STAG1270
  • STAG1271
  • STAG1272
  • STAG1273
  • STAG1274
  • STAG1275
  • STAG1276
  • STAG1277
  • STAG1278
  • STAG1300
  • STAG1301
  • STAG1302
  • STAG1303
  • STAG1304
  • STAG1305
  • STAG1306
  • STAG1307
  • STAG1308
  • STAG1309
  • STAG1310
  • STAG1311
  • STAG1312
  • STAG1313
  • STAG1314
  • STAG1315
  • STAG1316
  • STAG1317
  • STAG1318
  • STAG1319
  • STAG1320
  • STAG1321
  • STAG1322
  • STAG1323
  • STAG1324
  • STAG1325
  • STAG1326
  • STAG1327
  • STAG1328
  • STAG1329
  • STAG1330
  • STAG1331
  • STAG1332
  • STAG1333
  • STAG1334
  • STAG1335
  • STAG1336
  • STAG1337
  • STAG1338
  • STAG1339
  • STAG1340
  • STAG1341
  • STAG1342
  • STAG1343
  • STAG1344
  • STAG1345
  • STAG1346
  • STAG1347
  • STAG1348
  • STAG1349
  • STAG1350
  • STAG1351
  • STAG1352
  • STAG1353
  • STAG1354
  • STAG1355
  • STAG1356
  • STAG1357
  • STAG1358
  • STAG1359
  • STAG1360
  • STAG1361
  • STAG1362
  • STAG1363
  • STAG1364
  • STAG1365
  • STAG1366
  • STAG1367
  • STAG1368
  • STAG1369
  • STAG1370
  • STAG1371
  • STAG1372
  • STAG1373
  • STAG1374
  • STAG1375
  • STAG1376
  • STAG1377
  • STAG1378
  • STAG1379
  • STAG1380
  • STAG1381
  • STAG1382
  • STAG1383
  • STAG1384
  • STAG1385
  • STAG1386
  • STAG1387
  • STAG1388
  • STAG1389
  • STAG1390
  • STAG1391
  • STAG1392
  • STAG1393
  • STAG1394
  • STAG1395
  • STAG1396
  • STAG1397
  • STAG1398
  • STAG1420
  • STAG1421
  • STAG1422

New keys

Enabling foundation creates the following keys:
  • F_3595
  • F_3599
  • F_3600
  • F_3601
  • F_3602
  • F_3603
  • F_3604
  • F_3605
  • F_3606
  • F_3607
  • F_3608
  • F_3609
  • F_3610
  • F_3613
  • F_3614
  • F_3615
  • F_3616
  • F_3617
  • F_3618
  • F_3619
  • F_3620
  • F_3621
  • F_3622
  • F_3623
  • F_3624
  • F_3625
  • F_3626
  • F_3630
  • F_3631
  • F_3632
  • F_3633
  • F_3634
  • F_3635
  • F_3636
  • F_3637
  • F_3638
  • F_3639
  • F_3640
  • F_3641
  • F_3642
  • F_3643
  • F_3644
  • F_3645
  • F_3646
  • F_3647
  • F_3648
  • F_3649
  • F_3650
  • F_3651
  • F_3652
  • F_3653
  • F_3654
  • F_3655
  • F_3656
  • F_3657
  • F_3658
  • F_3659
  • F_3660
  • F_3661
  • F_3662
  • F_3663
  • F_3664
  • F_3665
  • F_3666
  • F_3667
  • F_3668
  • F_3669
  • F_3670
  • F_3671
  • F_3672
  • F_3673
  • F_3674
  • F_3675
  • F_3676
  • F_3677
  • F_3678
  • F_3679
  • F_3680
  • F_3681
  • F_3682
  • F_3683
  • F_3684
  • F_3685
  • F_3686
  • F_3687
  • F_3688
  • F_3689
  • F_3690
  • F_3691
  • F_3692
  • F_3693
  • F_3694
  • F_3695
  • F_3697
  • F_3698
  • F_3699
  • F_3700
  • F_3701
  • F_3702
  • F_3703
  • F_3704
  • F_3705
  • F_3706
  • F_3707
  • F_3708
  • F_3709
  • F_3710
  • F_3711
  • F_3712