gotify / gotify/server

Database has no foreign key

Open
#667 2 comments 0 reactions 0 assignees View on GitHub
a:feature in:server
Dominant language
Go
Stars
15.9k
Forks
873
Avg merge
2d 22h
Merged PRs (30d)
6

Description

Hello,

Database has no foreign key :
![image](https://github.com/user-attachments/assets/0fe1d789-04f9-4fcc-9f4e-e1c19cdcbca3)

It could be possible to insert bad value on referenced key.

The attached script add foreign keys.
[Foreign Keys for gotify.zip](https://github.com/user-attachments/files/16267329/Foreign.Keys.for.gotify.zip)

After, the database structure will be :
![image](https://github.com/user-attachments/assets/bf1d3589-ff30-4f8f-aeee-457620229f03)

Best regards

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.