svn commit: r487378 - in /incubator/ofbiz/trunk/applications: product/entitydef/entitymodel.xml workeffort/entitydef/entitygroup.xml workeffort/entitydef/entitymodel.xml

[jonesde]

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">