Hi, and sorry everyone. As this was a false positive, which isn’t as detrimental (although of course it can be), this was marked a ways back as something low priority, so wasn’t fixed.
I also missed all the follow-up replies, as I guess the forum doesn’t notify me due to a modification. My apologies for now knowing about this.
I’m going to have a gander, and see if I can fix. It is a bit tricky as Promises are used a lot when checking, and still not a high priority as it’s a false positive. For transparency, will update things here whether or not it’s fixed.
- fixed in development. will be out in production upon the next deploy.
- the table constraint needs to be
CREATE TABLE Actors_Movies (
FOREIGN KEY (actor_id) REFERENCES Actors,
FOREIGN KEY (movie_id) REFERENCES Movies