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

Reply via email to