Author: rishi
Date: Thu Sep 28 10:46:00 2017
New Revision: 1809971
URL:
http://svn.apache.org/viewvc?rev=1809971&view=revLog:
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>