Upgrading database of 0.3.1 to recent "default"

[Mads Kiilerich]

On 05/03/2016 09:09 PM, Konstantin Veretennicov wrote:
> I saw there were some indexes added on "default" post-0.3.1. When I
> ran "paster upgrade-db my.ini" for my 0.3.1 installation, as described
> in http://docs.kallithea-scm.org/en/latest/installation.html#upgrading-kallithea-from-python-package-index-pypi,
> it said "This database is already at the newest version" and I don't
> see any new indexes in the database (sqlite).
>
> Am I missing something or some changes are missing from "default" for
> indexes to get created?

There has not been any "important" changes. The changes has only been 
about optimizations and other improvements. I doubt you "need" them. 
Especially not if you are at a size where sqlite is enough.

Søren is looking into getting better database migration support with 
Alembic. A part of that should be to catch up these minor changes and 
old upgrade errors.

If you want it now, you can export your old data with data only (no 
schema changes), create a new empty database with Kallithea, and then 
import the old data in the new database. (There might be a few unused 
columns that you have to add and drop again.)

/Mads