Migration

This page applies to one upgrade only: v0.10.0. If you are installing LokalBoards now, or upgrading from v0.10.0 or later, you can skip it — the schema is kept up to date automatically, and every start applies whatever migrations are outstanding.

v0.10.0 removed the better-auth integration. Moving across it means rebuilding the database structure and resetting user passwords, because the old table layout cannot be migrated in place.

Database migration

It is recommend to export the data of your content tables (areas, attachments, boards, cards, comments, invitations & notifications). Then you should take a seperate export of the data of your user tables (account, apikey & user).

After that you can delete the tables of your database. On the next startup of LokalBoards it will create the new database structure.

Now you need to import the data. The content tables can be imported without any changes. At the user tables we removed some columns, you should remove those from your export before importing them again.

account: accessToken, refreshToken, idToken, accessTokenExpiresAt, refreshTokenExpiresAt, scope

user: username