Can I copy fields between different database versions

[jwinterton]

Hi roundcube community. Apologies if this has been covered elsewhere. I did search but found nowt.

Recently during an Ubuntu upgrade my roundcube installation was borked. Long story short I ended up wiping and re-installing 1.2.
I believe my old version was 0.9.5 (not 100% sure on that but if it helps in the system table the Roundcube Version was 2013011700).

My new install of 1.2.1 is working but I notice that all the user customisation is gone. That seems to live in the 'users' table in the 'preferences' field.
I note that in 1.2.1 there are a few new fields in this table (failed login etc) but others seem to be the same.

My question is has the format changed or can I safely cut and paste the common  fields from the old database to the new one - specifically the 'preferences' field but while I am about it how about all the fields in the users table?

Any help is much appreciated.
~J

[alec]

I guess you changed default_host in the config.

[jwinterton]

Hello Alec,
If you are asking what I think you are asking then the answer is no I did not change it. It is still the localhost.
J

[jwinterton]

OK if nobody can answer my question how about this one - is the database schema for the various versions published anywhere? Then I can answer my own question! Thanks.

[SKaero]

You can always check the git repo to go between versions. You can manually update the database, check out the upgrade guide: https://github.com/roundcube/roundcubemail/wiki/Upgrade