VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: mfarooqi on May 24, 2017, 15:37:42 PM

Title: does VM update reverts the table structure?
Post by: mfarooqi on May 24, 2017, 15:37:42 PM
Hi,
I want to alter order history table. I did the same on my site's older version 1.1.9.
The reason I needed to alter that that "iaox0_virtuemart_order_histories" or whatever that name in 1.1.9 was, I wanted to save tracking number. The number that is issued from Fedex, or usps etc. I couldn't find any otherway to add custom field other than products.

So my question is... will any future update revert back the table structure, and remove all of my data? or my this table will remain in it's form including data.?

Thank you
Title: Re: does VM update reverts the table structure?
Post by: AH on May 24, 2017, 18:20:43 PM
Updates don't normally modify "new fields" but you cannot guarantee that it will not :-)

I put such things in the "comments" field in VM 1.5 the same field is available in  VM3 is "comments"

Title: Re: does VM update reverts the table structure?
Post by: mfarooqi on June 03, 2017, 13:52:56 PM
That is right to put things in comments, but comments usually contains a number of other informations too, so I use to put custom field which further I use to track things within my website for customers.

so doing only in comments is not so helpful unless (created with predefined rule).
Title: Re: does VM update reverts the table structure?
Post by: Milbo on June 06, 2017, 13:32:36 PM
Quite simple
The tableupdater updates all columns belonging to the vm core. So when you add a new column it keeps untouched! On purpose for people like you, so go ahead
Title: Re: does VM update reverts the table structure?
Post by: mfarooqi on June 11, 2017, 23:53:36 PM
Quote from: Milbo on June 06, 2017, 13:32:36 PM
Quite simple
The tableupdater updates all columns belonging to the vm core. So when you add a new column it keeps untouched! On purpose for people like you, so go ahead
:) Thanks ... that's professional way of engineering! I like it.  ;)