From 56234d02ad16ace826a42530d1e428a69368f60d Mon Sep 17 00:00:00 2001
From: Alexander Sulfrian <alexander@sulfrian.net>
Date: Wed, 16 May 2012 04:07:38 +0200
Subject: sql: update to version 19 (ts3-v3.0.5)

---
 sql/defaults.sql | 18 +++++++++++++++++-
 1 file changed, 17 insertions(+), 1 deletion(-)

(limited to 'sql/defaults.sql')

diff --git a/sql/defaults.sql b/sql/defaults.sql
index 6edf39b..e041719 100644
--- a/sql/defaults.sql
+++ b/sql/defaults.sql
@@ -7,7 +7,7 @@ insert into instance_properties (server_id, id, ident, value) values (0, 0, 'ser
 insert into instance_properties (server_id, id, ident, value) values (0, 0, 'serverinstance_template_serverdefault_group', '5');
 insert into instance_properties (server_id, id, ident, value) values (0, 0, 'serverinstance_template_channeladmin_group', '1');
 insert into instance_properties (server_id, id, ident, value) values (0, 0, 'serverinstance_template_channeldefault_group', '4');
-insert into instance_properties (server_id, id, ident, value) values (0, 0, 'serverinstance_permissions_version', '13');
+insert into instance_properties (server_id, id, ident, value) values (0, 0, 'serverinstance_permissions_version', '14');
 
 -- bindings
 insert into bindings (ip, type) values ('0.0.0.0', 0);
@@ -88,6 +88,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_neg
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_channel_modify_password', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_channel_modify_sortorder', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_channel_modify_topic', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_avatar_delete_other', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_ban_create', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_ban_delete', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_ban_delete_own', 1, 0, 0);
@@ -110,6 +111,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_neg
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_permissionoverview_own', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_permissionoverview_view', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_remoteaddress_view', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_request_talker', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_server_textmessage_send', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_set_flag_talker', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_skip_channelgroup_permissions', 1, 0, 0);
@@ -183,6 +185,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_neg
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_modify_port', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_modify_priority_speaker_dimm_modificator', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_modify_reserved_slots', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_modify_temporary_passwords', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_modify_weblist', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_modify_welcomemessage', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_notify_register', 1, 0, 0);
@@ -313,6 +316,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_neg
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_channel_needed_subscribe_power', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_channel_permission_modify_power', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_channel_subscribe_power', 100, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_avatar_delete_other', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_ban_create', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_ban_delete', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_ban_delete_own', 100, 0, 0);
@@ -361,6 +365,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_neg
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_poke_power', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_private_textmessage_power', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_remoteaddress_view', 100, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_request_talker', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_serverquery_view_power', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_server_textmessage_send', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_set_flag_talker', 100, 0, 0);
@@ -464,6 +469,8 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_neg
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_port', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_priority_speaker_dimm_modificator', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_reserved_slots', 100, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_temporary_passwords', 100, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_temporary_passwords_own', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_weblist', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_welcomemessage', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_notify_register', 100, 0, 0);
@@ -530,6 +537,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_channel_modify_password', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_channel_modify_sortorder', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_channel_modify_topic', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_avatar_delete_other', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_ban_create', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_ban_delete', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_ban_delete_own', 1, 0, 0);
@@ -552,6 +560,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_permissionoverview_own', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_permissionoverview_view', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_remoteaddress_view', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_request_talker', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_server_textmessage_send', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_set_flag_talker', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_skip_channelgroup_permissions', 1, 0, 0);
@@ -605,6 +614,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_modify_port', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_modify_priority_speaker_dimm_modificator', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_modify_reserved_slots', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_modify_temporary_passwords', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_modify_weblist', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_modify_welcomemessage', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_notify_register', 1, 0, 0);
@@ -729,6 +739,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_channel_needed_subscribe_power', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_channel_permission_modify_power', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_channel_subscribe_power', 75, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_avatar_delete_other', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_ban_create', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_ban_delete', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_ban_delete_own', 75, 0, 0);
@@ -777,6 +788,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_poke_power', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_private_textmessage_power', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_remoteaddress_view', 75, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_request_talker', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_serverquery_view_power', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_server_textmessage_send', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_set_flag_talker', 75, 0, 0);
@@ -859,6 +871,8 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_port', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_priority_speaker_dimm_modificator', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_reserved_slots', 75, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_temporary_passwords', 75, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_temporary_passwords_own', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_weblist', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_welcomemessage', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_notify_register', 75, 0, 0);
@@ -897,6 +911,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_client_offline_textmessage_send', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_client_permissionoverview_own', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_client_permissionoverview_view', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_client_request_talker', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_group_is_permanent', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_virtualserver_channelgroup_client_list', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_virtualserver_channelgroup_list', 1, 0, 0);
@@ -951,6 +966,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'b_channel_join_temporary', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'b_client_channel_textmessage_send', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'b_client_info_view', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'b_client_request_talker', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'b_virtualserver_token_use', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'i_channel_create_modify_with_codec_latency_factor_min', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'i_channel_create_modify_with_codec_maxquality', 7, 0, 0);
-- 
cgit v1.2.3

