Document Tree
Document Properties
Kbid
292Z15
Last Modified
23-Jun-2020
Added to KB
02-Sep-2019
Public Access
Everyone
Status
Online
Doc Type
Guidelines
Product
ICM 7.10
Guide - 7.10 Migration PO - Local Index and Constraint Changes

Table of Contents

Changes

The code generator has been changed. All PO-related indexes and constraints are generated on PO level instead of on cartridge level and have specific ones for the database type.

For instance the generator for the BasicProfilePO now generates the following files:

BasicProfilePO.dbconstraints.microsoft.ddl
BasicProfilePO.dbconstraints.oracle.ddl
BasicProfilePO.dbindex.microsoft.ddl
BasicProfilePO.dbindex.oracle.ddl

The custom generating section still needs to be located on cartridge level as before.

Example of dbconstraints.ddl in bc_dashboard_orm:

/*------------------------------------------------------------------------
                           custom constraints section
------------------------------------------------------------------------*/

-- //{{ constraints
EXEC staging_ddl.add_constraint('DASHBOARD','DASHBOARD_CO999','FOREIGN KEY (USERID) REFERENCES BASICPROFILE (UUID) INITIALLY DEFERRED DEFERRABLE DISABLE NOVALIDATE');
-- //}} constraints


To adapt the changes, you need to re-generate the code with an updated Intershop Studio. 

Disclaimer
The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.
The Intershop Knowledge Portal uses only technically necessary cookies. We do not track visitors or have visitors tracked by 3rd parties. Please find further information on privacy in the Intershop Privacy Policy and Legal Notice.
Home
Knowledge Base
Product Releases
Log on to continue
This Knowledge Base document is reserved for registered customers.
Log on with your Intershop Entra ID to continue.
Write an email to supportadmin@intershop.de if you experience login issues,
or if you want to register as customer.