Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ofbiz.apache.org
MIME-Version: 1.0
In-Reply-To: <CAOsL3JC3kr6Gt=V5cnAJe2kE6UKq0N6gJUDJ1OdgsDwszShw3A@mail.gmail.com>
References: <CAOsL3JC3kr6Gt=V5cnAJe2kE6UKq0N6gJUDJ1OdgsDwszShw3A@mail.gmail.com>
From: Rishi Solanki <rishisolankii@gmail.com>
Date: Thu, 5 May 2016 10:23:37 +0530
Message-ID: <CAM2w_=BxHBCbc4VEOOq8RZQd_KJGOMRa=nZxivYHcXHiMdkPWQ@mail.gmail.com>
Subject: Re: creation of one table
To: ofbizuser <user@ofbiz.apache.org>
Content-Type: multipart/alternative; boundary=001a1144fbec4078390532112141
archived-at: Thu, 05 May 2016 04:54:09 -0000

--001a1144fbec4078390532112141
Content-Type: text/plain; charset=UTF-8

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.olagos@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.olagos@gmail.com
> http://www.olagos.eu
> http://www.olagos.com
> http://www.olagos.be
> http://www.olagos.nl
>

--001a1144fbec4078390532112141--