encore une fois... added missing sql queries :)

diff --git a/src/core/SQL/SQLite/8/select_connected_networks.sql b/src/core/SQL/SQLite/8/select_connected_networks.sql
new file mode 100644 (file)
index 0000000..a84d7f9
--- /dev/null
+++ b/src/core/SQL/SQLite/8/select_connected_networks.sql
@@ -0,0 +1,3 @@
+SELECT networkid
+FROM network
+WHERE userid = :userid AND connected = 1

diff --git a/src/core/SQL/SQLite/8/select_persistent_channels.sql b/src/core/SQL/SQLite/8/select_persistent_channels.sql
new file mode 100644 (file)
index 0000000..6c1c10f
--- /dev/null
+++ b/src/core/SQL/SQLite/8/select_persistent_channels.sql
@@ -0,0 +1,3 @@
+SELECT buffername, key
+FROM buffer
+WHERE userid = :userid AND networkid = :networkid AND buffertype = 2

diff --git a/src/core/SQL/SQLite/8/update_buffer_persistent_channel.sql b/src/core/SQL/SQLite/8/update_buffer_persistent_channel.sql
new file mode 100644 (file)
index 0000000..e75360a
--- /dev/null
+++ b/src/core/SQL/SQLite/8/update_buffer_persistent_channel.sql
@@ -0,0 +1,3 @@
+UPDATE buffer
+SET joined = :joined
+WHERE userid = :userid AND networkid = :networkid AND buffercname = :buffercname AND buffertype = 2

diff --git a/src/core/SQL/SQLite/8/update_buffer_set_channel_key.sql b/src/core/SQL/SQLite/8/update_buffer_set_channel_key.sql
new file mode 100644 (file)
index 0000000..803d6fd
--- /dev/null
+++ b/src/core/SQL/SQLite/8/update_buffer_set_channel_key.sql
@@ -0,0 +1,3 @@
+UPDATE buffer
+SET key = :key
+WHERE userid = :userid AND networkid = :networkid AND buffercname = :buffercname AND buffertype = 2

diff --git a/src/core/SQL/SQLite/8/update_network_connected.sql b/src/core/SQL/SQLite/8/update_network_connected.sql
new file mode 100644 (file)
index 0000000..0bd89de
--- /dev/null
+++ b/src/core/SQL/SQLite/8/update_network_connected.sql
@@ -0,0 +1,3 @@
+UPDATE network
+SET connected = :connected
+WHERE userid = :userid AND networkid = :networkid

diff --git a/src/core/SQL/SQLite/8/upgrade_000_alter_network_add_connected.sql b/src/core/SQL/SQLite/8/upgrade_000_alter_network_add_connected.sql
new file mode 100644 (file)
index 0000000..ea60400
--- /dev/null
+++ b/src/core/SQL/SQLite/8/upgrade_000_alter_network_add_connected.sql
@@ -0,0 +1,2 @@
+ALTER TABLE network
+ADD COLUMN connected INTEGER NOT NULL DEFAULT 1

diff --git a/src/core/SQL/SQLite/8/upgrade_010_alter_buffer_add_key.sql b/src/core/SQL/SQLite/8/upgrade_010_alter_buffer_add_key.sql
new file mode 100644 (file)
index 0000000..ca71cab
--- /dev/null
+++ b/src/core/SQL/SQLite/8/upgrade_010_alter_buffer_add_key.sql
@@ -0,0 +1,2 @@
+ALTER TABLE buffer
+ADD COLUMN key TEXT

diff --git a/src/core/SQL/SQLite/8/upgrade_020_alter_buffer_add_joined.sql b/src/core/SQL/SQLite/8/upgrade_020_alter_buffer_add_joined.sql
new file mode 100644 (file)
index 0000000..d0a18cd
--- /dev/null
+++ b/src/core/SQL/SQLite/8/upgrade_020_alter_buffer_add_joined.sql
@@ -0,0 +1,2 @@
+ALTER TABLE buffer
+ADD COLUMN joined INTEGER NOT NULL DEFAULT 0

diff --git a/src/core/SQL/SQLite/8/upgrade_030_update_buffer_set_joined_for_channels.sql b/src/core/SQL/SQLite/8/upgrade_030_update_buffer_set_joined_for_channels.sql
new file mode 100644 (file)
index 0000000..ad6d757
--- /dev/null
+++ b/src/core/SQL/SQLite/8/upgrade_030_update_buffer_set_joined_for_channels.sql
@@ -0,0 +1,3 @@
+UPDATE buffer
+SET joined = 1
+WHERE buffertype = 2

diff --git a/src/core/SQL/SQLite/8/upgrade_999_version.sql b/src/core/SQL/SQLite/8/upgrade_999_version.sql
new file mode 100644 (file)
index 0000000..06d8b37
--- /dev/null
+++ b/src/core/SQL/SQLite/8/upgrade_999_version.sql
@@ -0,0 +1,3 @@
+UPDATE coreinfo
+SET value = '8'
+WHERE key = 'schemaversion'