Hello,
Are there any DB schema changes in the VM database in the 3.2.x series?
I am asking because I plan to do a direct VM DB copy of products/orders/etc, from a local site using a slightly older VM 3.2.x version, to a remote site using a fairly recent release.
Any trouble expected?
Thanks
I think that main changes are about params in product_customfields, but field type have changed eg from varchar to text or text to varchar.
In the order items table the param is perhaps saved another way.
Just check the svn yourself, it is easy. http://dev.virtuemart.net/projects/virtuemart/repository/diff/branches/com_virtuemart.3.0.12.4/administrator/components/com_virtuemart/install/install.sql?utf8=%E2%9C%93&rev=9810&rev_to=9487
I set the maximum of any varchar to 15359, it is the biggest possible number. In future, any varchar which are not keys and are bigger than 1000 or so, will be mediumtext or so.
You can always just execute the table updater. So long it never failed, except when you downgrade with it, then you can get in trouble.