D18781: Fix SQLite backend foregin key PRAGMAs

[Konrad Rzepecki]

konradr created this revision.
Herald added a project: KDE PIM.
Herald added a subscriber: kde-pim.
konradr requested review of this revision.

REVISION SUMMARY
  SQLite backend contain "PRAGMA foreign_key_check=OFF/ON" which ins't correct SQLite syntax.  Author intention was probably disengage key checking. In SQLlite this can be achieved be temporary deffer key check.  Correct syntax is in this case "PRAGMA defer_foreign_keys=ON/OFF".  This partial resolves bug 402229.
  
  BUG: 402229

REPOSITORY
  R165 Akonadi

REVISION DETAIL
  https://phabricator.kde.org/D18781

AFFECTED FILES
  autotests/server/dbtest_data/dbinit_sqlite
  autotests/server/dbtest_data/dbinit_sqlite_incremental
  src/server/storage/dbinitializer_p.cpp

To: konradr
Cc: kde-pim, dvasin, rodsevich, winterz, vkrause, mlaurent, knauss, dvratil
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20190206/edad4a82/attachment.html>