server icon indicating copy to clipboard operation
server copied to clipboard

Database has no foreign key

Open xavier-GitHub76 opened this issue 1 year ago • 2 comments

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

xavier-GitHub76 avatar Jul 17 '24 14:07 xavier-GitHub76

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

jmattheis avatar Jul 20 '24 14:07 jmattheis

I agree with you. Thanks for your work.

xavier-GitHub76 avatar Jul 20 '24 18:07 xavier-GitHub76