ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Deepak Dixit <deepak.di...@hotwaxsystems.com>
Subject Re: creation of one table
Date Thu, 05 May 2016 05:20:13 GMT
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 <rishisolankii@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.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
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message