Author: jonesde
Date: Thu Dec 14 14:41:02 2006
New Revision: 487378
URL: http://svn.apache.org/viewvc?view=rev&rev=487378
Log:
Added WorkEffortKeyword entity, which is like the ProductKeyword entity and
intended to be used the same way; also added indexes on the keyword fields
which can hopefully be used sometimes to speed up queries on this, though not
always because of like and wildcards
Modified:
incubator/ofbiz/trunk/applications/product/entitydef/entitymodel.xml
incubator/ofbiz/trunk/applications/workeffort/entitydef/entitygroup.xml
incubator/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
Modified: incubator/ofbiz/trunk/applications/product/entitydef/entitymodel.xml
URL:
http://svn.apache.org/viewvc/incubator/ofbiz/trunk/applications/product/entitydef/entitymodel.xml?view=diff&rev=487378&r1=487377&r2=487378
==============================================================================
--- incubator/ofbiz/trunk/applications/product/entitydef/entitymodel.xml
(original)
+++ incubator/ofbiz/trunk/applications/product/entitydef/entitymodel.xml Thu
Dec 14 14:41:02 2006
@@ -2114,10 +2114,7 @@
<key-map field-name="productId"/>
</view-link>
</view-entity>
- <entity entity-name="ProductKeyword"
- package-name="org.ofbiz.product.product"
- never-cache="true"
- title="Product Keyword Entity">
+ <entity entity-name="ProductKeyword"
package-name="org.ofbiz.product.product" title="Product Keyword Entity"
never-cache="true">
<field name="productId" type="id-ne"></field>
<field name="keyword" type="short-varchar"></field>
<field name="relevancyWeight" type="numeric"></field>
@@ -2126,6 +2123,9 @@
<relation type="one" fk-name="PROD_KWD_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
+ <index name="PROD_KWD_KWD">
+ <index-field name="keyword"/>
+ </index>
</entity>
<entity entity-name="OldProductKeywordResult"
table-name="PRODUCT_KEYWORD_RESULT"
package-name="org.ofbiz.product.product"
Modified:
incubator/ofbiz/trunk/applications/workeffort/entitydef/entitygroup.xml
URL:
http://svn.apache.org/viewvc/incubator/ofbiz/trunk/applications/workeffort/entitydef/entitygroup.xml?view=diff&rev=487378&r1=487377&r2=487378
==============================================================================
--- incubator/ofbiz/trunk/applications/workeffort/entitydef/entitygroup.xml
(original)
+++ incubator/ofbiz/trunk/applications/workeffort/entitydef/entitygroup.xml Thu
Dec 14 14:41:02 2006
@@ -59,6 +59,7 @@
<entity-group group="org.ofbiz" entity="WorkEffortGoodStandardType" />
<entity-group group="org.ofbiz" entity="WorkEffortInventoryAssign" />
<entity-group group="org.ofbiz" entity="WorkEffortInventoryProduced" />
+ <entity-group group="org.ofbiz" entity="WorkEffortKeyword" />
<entity-group group="org.ofbiz" entity="WorkEffortNote" />
<entity-group group="org.ofbiz" entity="WorkEffortNoteAndData" />
<entity-group group="org.ofbiz" entity="WorkEffortPartyAssignByGroup" />
Modified:
incubator/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
URL:
http://svn.apache.org/viewvc/incubator/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml?view=diff&rev=487378&r1=487377&r2=487378
==============================================================================
--- incubator/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
(original)
+++ incubator/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml Thu
Dec 14 14:41:02 2006
@@ -623,6 +623,19 @@
<key-map field-name="inventoryItemId"/>
</relation>
</entity>
+ <entity entity-name="WorkEffortKeyword"
package-name="org.ofbiz.workeffort.workeffort" title="WorkEffort Keyword
Entity" never-cache="true">
+ <field name="workEffortId" type="id-ne"></field>
+ <field name="keyword" type="short-varchar"></field>
+ <field name="relevancyWeight" type="numeric"></field>
+ <prim-key field="workEffortId"/>
+ <prim-key field="keyword"/>
+ <relation type="one" fk-name="WEFF_KWD_WEFF"
rel-entity-name="WorkEffort">
+ <key-map field-name="workEffortId"/>
+ </relation>
+ <index name="WEFF_KWD_KWD">
+ <index-field name="keyword"/>
+ </index>
+ </entity>
<entity entity-name="WorkEffortNote"
package-name="org.ofbiz.workeffort.workeffort"
title="Work Effort Note Entity">
