core: Separate SQL current and upgrade scripts

[quassel.git] / src / core / SQL / SQLite / version / 15 / upgrade_000_fix_network.sql

diff --git a/src/core/SQL/SQLite/version/15/upgrade_000_fix_network.sql b/src/core/SQL/SQLite/version/15/upgrade_000_fix_network.sql
new file mode 100644 (file)
index 0000000..1831e73
--- /dev/null
+++ b/src/core/SQL/SQLite/version/15/upgrade_000_fix_network.sql
@@ -0,0 +1,7 @@
+UPDATE network
+SET userandomserver = length(replace(replace(replace(userandomserver,'true','1'), 'false', '0'), '0', '')),
+    useautoidentify = length(replace(replace(replace(useautoidentify,'true','1'), 'false', '0'), '0', '')),
+    useautoreconnect = length(replace(replace(replace(useautoreconnect,'true','1'), 'false', '0'), '0', '')),
+    unlimitedconnectretries = length(replace(replace(replace(unlimitedconnectretries,'true','1'), 'false', '0'), '0', '')),
+    rejoinchannels = length(replace(replace(replace(rejoinchannels,'true','1'), 'false', '0'), '0', '')),
+    connected = length(replace(replace(replace(connected,'true','1'), 'false', '0'), '0', ''))