Hi Eric, Please refer entityengine.xml file, in the datasource section we have two option:
check-on-start="true" add-missing-on-start="true" Please make sure in your entityengie.xml file thee are set to true, this will automatically add new table and fields in table. Please note that - This only add new table and field, - If you made changes in composite primary key then you need to manually alter table form database. For more reference please refer following document: https://cwiki.apache.org/confluence/x/1IDfAg Thanks & Regards -- Deepak Dixit www.hotwaxsystems.com On Thu, May 5, 2016 at 10:23 AM, Rishi Solanki <rishisolan...@gmail.com> wrote: > 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 < > info.ola...@gmail.com> 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 : info.ola...@gmail.com > > http://www.olagos.eu > > http://www.olagos.com > > http://www.olagos.be > > http://www.olagos.nl > > >