Eric, Your old entity PRODUCT_KEYWORD should exists with delegator/OFBiz entity name as OldProductKeyword. As you are upgrading then I think you would like to use new ProductKeyword entity with enhancement added. You have two options here as; - re-generate the contents and just run the generate keywords routine. - Or use the migrateProductKeyword service to migrate the data from OldProductKeyword to ProductKeyword entity you shared.
As a general practice, if any changes done in OFBiz entity then migrateEntityName service exists for resolving compatibility issue. Refer - https://cwiki.apache.org/confluence/display/OFBIZ/General+Entity+Overview#GeneralEntityOverview-DeprecatedEntities HTH! -- Rishi Solanki Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd. Direct: +91-9893287847 http://www.hotwaxsystems.com On Wed, Jan 13, 2016 at 6:29 PM, Heidi Dehaes - Olagos < [email protected]> wrote: > Hello, > > I upgraded from ofbiz version 11 to version 14.12 for the application > files. > However i did not upgrade the database. > > Now i see i don't have the new table "PRODUCT_KEYWORD_NEW". > > How can i upgrade the database with the new table without touching the > other tables? > > Can i do a simple "install" or will this delete the content of all the > other tables? > > > > <entity entity-name="ProductKeyword" table-name="PRODUCT_KEYWORD_NEW" > 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="keywordTypeId" type="id-ne"></field> > <field name="relevancyWeight" type="numeric"></field> > <field name="statusId" type="id-ne"></field> > <prim-key field="productId"/> > <prim-key field="keyword"/> > <prim-key field="keywordTypeId"/> > <relation type="one" fk-name="PROD_KWD_PROD_NEW" > rel-entity-name="Product"> > <key-map field-name="productId"/> > </relation> > <relation type="one" fk-name="PROD_KWD_TYPE" > rel-entity-name="Enumeration"> > <key-map field-name="keywordTypeId" rel-field-name="enumId"/> > </relation> > <relation type="one" fk-name="PROD_KWD_STTS" > rel-entity-name="StatusItem"> > <key-map field-name="statusId"/> > </relation> > <index name="PROD_KWD_KWD_NEW"> > <index-field name="keyword"/> > </index> > </entity> > > > Regards, > Eric > > Olagos bvba > Heidi Dehaes > Kerkstraat 34 > 2570 Duffel > Belgium > Tel. : 015/31 53 04 > GSM : 0485/22 35 80 > E-mail : [email protected] > http://www.olagos.eu > http://www.olagos.com > http://www.olagos.be > http://www.olagos.nl >
