Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: borro on April 21, 2016, 08:36:52 AM

Title: If i add some column to VM DB table what will happen with it after VM upgrade?
Post by: borro on April 21, 2016, 08:36:52 AM
Hello!

Please tell will VM upgrading(e.g. from 3.0.9 to some last stable release) erase additional field in some VM DB table if I will add it before the upgrade?
Title: Re: If i add some column to VM DB table what will happen with it after VM upgrade?
Post by: GJC Web Design on April 21, 2016, 09:19:26 AM
on an update I don't think so - the tables are not renewed
Title: Re: If i add some column to VM DB table what will happen with it after VM upgrade?
Post by: Milbo on April 21, 2016, 17:27:38 PM
The tables are updated, but removing of unknown fields is commented. So you can simple add a field to the table.
Title: Re: If i add some column to VM DB table what will happen with it after VM upgrade?
Post by: AH on April 22, 2016, 09:36:12 AM
As long as the field name is unique enough to never get used by VM    :P
Title: Re: If i add some column to VM DB table what will happen with it after VM upgrade?
Post by: franzpeter on April 22, 2016, 10:23:12 AM
Your columns will remain, but if you did set to index that column in the database, the index will get removed with every VM update and you need to recreate the index for that column.
Text only | Text with Images