Author: rishi Date: Thu Sep 28 10:46:00 2017 New Revision: 1809971 URL: http://svn.apache.org/viewvc?rev=1809971&view=rev Log: Improvement: Missing FK constraints in OrderItem entity for ShoppingListItem (OFBIZ-9767). Added one-nofk relation from order item to shopping list item. Thanks Chandan Khandelwal for reporting and providing patch for issue.
Modified: ofbiz/ofbiz-framework/trunk/applications/datamodel/entitydef/order-entitymodel.xml Modified: ofbiz/ofbiz-framework/trunk/applications/datamodel/entitydef/order-entitymodel.xml URL: http://svn.apache.org/viewvc/ofbiz/ofbiz-framework/trunk/applications/datamodel/entitydef/order-entitymodel.xml?rev=1809971&r1=1809970&r2=1809971&view=diff ============================================================================== --- ofbiz/ofbiz-framework/trunk/applications/datamodel/entitydef/order-entitymodel.xml (original) +++ ofbiz/ofbiz-framework/trunk/applications/datamodel/entitydef/order-entitymodel.xml Thu Sep 28 10:46:00 2017 @@ -562,6 +562,10 @@ under the License. <key-map field-name="quoteId"/> <key-map field-name="quoteItemSeqId"/> </relation> + <relation type="one-nofk" fk-name="ORDER_ITEM_SLI" rel-entity-name="ShoppingListItem"> + <key-map field-name="shoppingListId"/> + <key-map field-name="shoppingListItemSeqId"/> + </relation> <relation type="one" fk-name="ORDER_ITEM_OGLA" title="Override" rel-entity-name="GlAccount"> <key-map field-name="overrideGlAccountId" rel-field-name="glAccountId"/> </relation>