Adding tables to Gogs

Gogs version: 0.11.91.0811
System: alpine:latest from Dockerfile in repo
Database: sqlite for testing - want to do this with Gogs so that I can migrate to mysql (Amazon Aurora) when I have some volume.

I would like to create 2 new tables in the Gogs database. One would have a foreign key of user.id, the other a foreign key of repository.id. I have created screens to interact with these tables under user.settings and repo.settings.

It looks like I need to create 1 migration and a model for each new table. Will my migration be run if I reinstall gogs? Is there a way to apply my migration manually?

Thanks for your help

Hi, if you just want to create two tables, use any GUI or CLI client to the SQLite would work.

I don’t know what is “screens” and “user.settings and repo.settings”?