News:

Support the VirtueMart project and become a member

Main Menu

VM DB changes in the 3.2.x series?

Started by EvanGR, August 09, 2018, 09:21:08 AM

Previous topic - Next topic

EvanGR

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

Studio 42

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.

Milbo

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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/