Author: jleroux Date: Sat Sep 23 08:24:08 2017 New Revision: 1809375 URL: http://svn.apache.org/viewvc?rev=1809375&view=rev Log: Implemented: Missing foreign key constraint for fields userLoginId & userPrefGroupTypeId in UserPreference entity
UserPreference.userLoginId is related to UserLogin.userLoginId. UserPreference.userPrefGroupTypeId is related to UserPrefGroupType.userPrefGroupTypeId. (OFBIZ-9678) Thanks: Aditya Modified: ofbiz/ofbiz-framework/trunk/framework/common/entitydef/entitymodel.xml Modified: ofbiz/ofbiz-framework/trunk/framework/common/entitydef/entitymodel.xml URL: http://svn.apache.org/viewvc/ofbiz/ofbiz-framework/trunk/framework/common/entitydef/entitymodel.xml?rev=1809375&r1=1809374&r2=1809375&view=diff ============================================================================== --- ofbiz/ofbiz-framework/trunk/framework/common/entitydef/entitymodel.xml (original) +++ ofbiz/ofbiz-framework/trunk/framework/common/entitydef/entitymodel.xml Sat Sep 23 08:24:08 2017 @@ -639,6 +639,12 @@ under the License. <field name="userPrefDataType" type="id-long"><description>The java data type of this preference (empty = java.lang.String)</description></field> <prim-key field="userLoginId"/> <prim-key field="userPrefTypeId"/> + <relation type="one" fk-name="UP_User_Login" rel-entity-name="UserLogin"> + <key-map field-name="userLoginId"/> + </relation> + <relation type="one" fk-name="UP_User_Group_Type" rel-entity-name="UserPrefGroupType"> + <key-map field-name="userPrefGroupTypeId"/> + </relation> </entity> <entity entity-name="UserPrefGroupType"