How to extend data model?

Hi there. thanks for provide such a great product!

I am doing a project that uses Vikunja to drive and automate some processes. I need to update the data model in some instances. For example, in our processes, the a task needs a list of external contacts with their name, role, phone, email, url, and maybe few more details. We also need summary/description for attachments and some flags to indicate if it is only for internal circulation. I am not sure how the Task struct in tasks.go or TaskAttachement struct is connected with database definition. If I update the structs, is there a process to update the databases?

I see the migration scripts only updates sqlite databases. I assume there is a way that mysql or postgres are getting updated but didn’t find the process. It would be great if someone can provide some guidance here.

You’re probably looking for this: Database Migrations

@kolaente. Thanks a lot for your response. This is exactly what I am looking for.

BTW, I have a security concern. Should I post in the community or we have special process to discuss security?

For security, there is a special process: Security