https://bugs.kde.org/show_bug.cgi?id=372312
--- Comment #8 from Kusi <k...@forum.titlis.org> ---
the new dbconfig.xml brings me quite a bit further, but no success yet.
Unfortunately, I've got a 10 years old sql db which probably degenerated a bit.
I need to resolve all foreign key violations (from which I have a bunch)
myself. Hopefully that doesn't happen anymore with the added constraints.
Thanks for that, btw!
As for your new xml: The following sequence cannot work, can it?
<statement mode="plain">
ALTER TABLE Albums
DROP FOREIGN KEY Albums_Images;
</statement>
<statement mode="plain">
ALTER TABLE Albums
ADD CONSTRAINT Albums_Images FOREIGN KEY (icon) REFERENCES Images (id) ON
DELETE SET NULL ON UPDATE CASCADE;
</statement>
You drop Albums_Images which didn't exist on a DK 4.14, right? At least for me,
I need DROP FOREIGN KEY IF EXISTS Albums_Images;
--
You are receiving this mail because:
You are watching all bug changes.
