search

gotify / server

A simple server for sending and receiving messages in real-time per WebSocket. (Includes a sleek web-ui)
https://gotify.net
Other
10.96k stars 615 forks source link

Database has no foreign key #667

Open xavier-GitHub76 opened 1 month ago

xavier-GitHub76 commented 1 month ago

Hello,

Database has no foreign key : image

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

The attached script add foreign keys. Foreign Keys for gotify.zip

After, the database structure will be : image

Best regards

jmattheis commented 1 month ago

I agree it would be more robust when there are foreign keys, but this is more of an improvement than a bug.

xavier-GitHub76 commented 1 month ago

I agree with you. Thanks for your work.