The foreign key contstraint between AspNetUserLogins and AspNetUsers disappears after running the script.
The issue seems to be that the constraint is added to the wrong table:
"ALTER TABLE [dbo].[AspNetUserRoles] ADD CONSTRAINT [FK_AspNetUserLogins_AspNetUsers_UserId] FOREIGN KEY (UserId) REFERENCES [dbo].[AspNetUsers] ([Id])]"
The foreign key contstraint between AspNetUserLogins and AspNetUsers disappears after running the script.
The issue seems to be that the constraint is added to the wrong table:
"ALTER TABLE [dbo].[AspNetUserRoles] ADD CONSTRAINT [FK_AspNetUserLogins_AspNetUsers_UserId] FOREIGN KEY (UserId) REFERENCES [dbo].[AspNetUsers] ([Id])]"