From 46c5742f6b0e9f3dc26f7b4740a1acfd683781af Mon Sep 17 00:00:00 2001 From: Marcus Eggenberger Date: Thu, 21 Feb 2008 23:01:48 +0000 Subject: [PATCH] encore une fois... added missing sql queries :) --- src/core/SQL/SQLite/8/select_connected_networks.sql | 3 +++ src/core/SQL/SQLite/8/select_persistent_channels.sql | 3 +++ src/core/SQL/SQLite/8/update_buffer_persistent_channel.sql | 3 +++ src/core/SQL/SQLite/8/update_buffer_set_channel_key.sql | 3 +++ src/core/SQL/SQLite/8/update_network_connected.sql | 3 +++ .../SQL/SQLite/8/upgrade_000_alter_network_add_connected.sql | 2 ++ src/core/SQL/SQLite/8/upgrade_010_alter_buffer_add_key.sql | 2 ++ src/core/SQL/SQLite/8/upgrade_020_alter_buffer_add_joined.sql | 2 ++ .../8/upgrade_030_update_buffer_set_joined_for_channels.sql | 3 +++ src/core/SQL/SQLite/8/upgrade_999_version.sql | 3 +++ 10 files changed, 27 insertions(+) create mode 100644 src/core/SQL/SQLite/8/select_connected_networks.sql create mode 100644 src/core/SQL/SQLite/8/select_persistent_channels.sql create mode 100644 src/core/SQL/SQLite/8/update_buffer_persistent_channel.sql create mode 100644 src/core/SQL/SQLite/8/update_buffer_set_channel_key.sql create mode 100644 src/core/SQL/SQLite/8/update_network_connected.sql create mode 100644 src/core/SQL/SQLite/8/upgrade_000_alter_network_add_connected.sql create mode 100644 src/core/SQL/SQLite/8/upgrade_010_alter_buffer_add_key.sql create mode 100644 src/core/SQL/SQLite/8/upgrade_020_alter_buffer_add_joined.sql create mode 100644 src/core/SQL/SQLite/8/upgrade_030_update_buffer_set_joined_for_channels.sql create mode 100644 src/core/SQL/SQLite/8/upgrade_999_version.sql 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 index 00000000..a84d7f9b --- /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 index 00000000..6c1c10f5 --- /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 index 00000000..e75360a0 --- /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 index 00000000..803d6fd7 --- /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 index 00000000..0bd89de5 --- /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 index 00000000..ea60400f --- /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 index 00000000..ca71cabc --- /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 index 00000000..d0a18cdc --- /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 index 00000000..ad6d7576 --- /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 index 00000000..06d8b377 --- /dev/null +++ b/src/core/SQL/SQLite/8/upgrade_999_version.sql @@ -0,0 +1,3 @@ +UPDATE coreinfo +SET value = '8' +WHERE key = 'schemaversion' -- 2.20.1