creation of one table

[Heidi Dehaes - Olagos]

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. :     [phone]
GSM :    0485/22 35 80
E-mail : [hidden email]
http://www.olagos.eu
http://www.olagos.com
http://www.olagos.be
http://www.olagos.nl

[Rishi Solanki]

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: [phone]
http://www.hotwaxsystems.com

On Wed, Jan 13, 2016 at 6:29 PM, Heidi Dehaes - Olagos <
[hidden email]> 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. :     [phone]
> GSM :    0485/22 35 80
> E-mail : [hidden email]
> http://www.olagos.eu
> http://www.olagos.com
> http://www.olagos.be
> http://www.olagos.nl
>

[Deepak Dixit-3]

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 <[hidden email]>
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: [phone]
> http://www.hotwaxsystems.com
>
> On Wed, Jan 13, 2016 at 6:29 PM, Heidi Dehaes - Olagos <
> [hidden email]> 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. :     [phone]
> > GSM :    0485/22 35 80
> > E-mail : [hidden email]
> > http://www.olagos.eu
> > http://www.olagos.com
> > http://www.olagos.be
> > http://www.olagos.nl
> >
>