sql: update to version 21 (ts3-v3.0.10.3)HEADmaster

6 files changed, 45 insertions, 4 deletions

diff --git a/sql/ban_insert.sql b/sql/ban_insert.sql
index 71b2c1e..76633eb 100644
--- a/sql/ban_insert.sql
+++ b/sql/ban_insert.sql
@@ -8,7 +8,8 @@ INSERT INTO bans
  ban_invoker_client_id,
  ban_invoker_uid,
  ban_invoker_name,
- ban_reason) 
+ ban_reason,
+ ban_hash)
 VALUES
 (:server_id:,
  :ban_ip:,
@@ -19,6 +20,7 @@ VALUES
  :ban_invoker_client_id:,
  :ban_invoker_uid:,
  :ban_invoker_name:,
- :ban_reason:)
+ :ban_reason:,
+ :ban_hash:)
 RETURNING
   ban_id AS last_inserted_id;
diff --git a/sql/complain_insert.sql b/sql/complain_insert.sql
index 13d78e5..3a0a361 100644
--- a/sql/complain_insert.sql
+++ b/sql/complain_insert.sql
@@ -1 +1 @@
-insert into complains (server_id, complain_from_client_id, complain_to_client_id, complain_message, complain_timestamp) values (:server_id:, :complain_from_client_id:, :complain_to_client_id:, :complain_message:, :complain_timestamp:);
\ No newline at end of file
+insert into complains (server_id, complain_from_client_id, complain_to_client_id, complain_message, complain_timestamp, complain_hash) values (:server_id:, :complain_from_client_id:, :complain_to_client_id:, :complain_message:, :complain_timestamp:, :complain_hash:);
diff --git a/sql/create_pg/create_tables.sql b/sql/create_pg/create_tables.sql
index df69d38..2e78dd3 100644
--- a/sql/create_pg/create_tables.sql
+++ b/sql/create_pg/create_tables.sql
@@ -197,6 +197,7 @@ CREATE TABLE complains (
   complain_from_client_id bigint,
   complain_to_client_id   bigint,
   complain_message        text,
+  complain_hash           text,
   complain_timestamp      bigint
 );
 CREATE INDEX index_complains_serverid ON complains (server_id);
@@ -213,6 +214,7 @@ CREATE TABLE bans (
   ban_invoker_uid         text,
   ban_invoker_name        text,
   ban_reason              text,
+  ban_hash                text,
   ban_enforcements        bigint Default 0
 );
 CREATE INDEX index_bans_serverid ON bans (server_id);
diff --git a/sql/defaults.sql b/sql/defaults.sql
index e041719..232c976 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', '14');
+insert into instance_properties (server_id, id, ident, value) values (0, 0, 'serverinstance_permissions_version', '19');
 
 -- bindings
 insert into bindings (ip, type) values ('0.0.0.0', 0);
@@ -48,10 +48,13 @@ 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, 1, 0, 'i_group_needed_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, 'b_channel_create_child', 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_create_modify_with_codec_celtmono48', 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_create_modify_with_codec_opusmusic', 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_create_modify_with_codec_opusvoice', 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_create_modify_with_codec_speex16', 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_create_modify_with_codec_speex32', 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_create_modify_with_codec_speex8', 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_create_permanent', 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_create_private', 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_create_semi_permanent', 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_create_temporary', 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_create_with_default', 1, 0, 0);
@@ -87,6 +90,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_parent', 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_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_temp_delete_delay', 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);
@@ -102,6 +106,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_delete_dbproperties', 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_ignore_antiflood', 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_ignore_bans', 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_ignore_sticky', 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_info_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_issue_client_query_command', 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_modify_dbproperties', 1, 0, 0);
@@ -165,6 +170,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_antiflood', 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_autostart', 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_channel_forced_silence', 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_channel_temp_delete_delay_default', 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_codec_encryption_mode', 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_complain', 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_default_channeladmingroup', 1, 0, 0);
@@ -210,6 +216,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_token_use', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 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, 2, 0, 'i_channel_create_modify_with_codec_maxquality', 10, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_channel_create_modify_with_temp_delete_delay', 86400, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_channel_delete_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_channel_description_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_channel_join_power', 100, 0, 0);
@@ -260,10 +267,15 @@ 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_create_modify_with_codec_celtmono48', 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_create_modify_with_codec_latency_factor_min', 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_create_modify_with_codec_maxquality', 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_create_modify_with_codec_opusmusic', 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_create_modify_with_codec_opusvoice', 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_create_modify_with_codec_speex16', 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_create_modify_with_codec_speex32', 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_create_modify_with_codec_speex8', 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_create_modify_with_force_password', 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_create_modify_with_temp_delete_delay', 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_create_permanent', 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_create_private', 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_create_semi_permanent', 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_create_temporary', 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_create_with_default', 100, 0, 0);
@@ -307,6 +319,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_modify_password', 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_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_modify_sortorder', 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_modify_temp_delete_delay', 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_modify_topic', 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_needed_delete_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_needed_description_view_power', 100, 0, 0);
@@ -334,8 +347,10 @@ 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_force_push_to_talk', 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_ignore_antiflood', 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_ignore_bans', 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_ignore_sticky', 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_info_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_is_priority_speaker', 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_is_sticky', 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_issue_client_query_command', 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_kick_from_channel_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_kick_from_server_power', 100, 0, 0);
@@ -449,6 +464,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_virtualserver_modify_antiflood', 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_autostart', 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_channel_forced_silence', 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_channel_temp_delete_delay_default', 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_codec_encryption_mode', 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_complain', 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_default_channeladmingroup', 100, 0, 0);
@@ -496,10 +512,13 @@ 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_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, 3, 0, 'b_channel_create_child', 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_create_modify_with_codec_celtmono48', 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_create_modify_with_codec_opusmusic', 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_create_modify_with_codec_opusvoice', 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_create_modify_with_codec_speex16', 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_create_modify_with_codec_speex32', 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_create_modify_with_codec_speex8', 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_create_permanent', 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_create_private', 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_create_semi_permanent', 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_create_temporary', 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_create_with_default', 1, 0, 0);
@@ -536,6 +555,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_parent', 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_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_temp_delete_delay', 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);
@@ -551,6 +571,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_delete_dbproperties', 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_ignore_antiflood', 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_ignore_bans', 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_ignore_sticky', 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_info_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_issue_client_query_command', 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_modify_dbproperties', 1, 0, 0);
@@ -594,6 +615,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_antiflood', 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_autostart', 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_channel_forced_silence', 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_channel_temp_delete_delay_default', 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_codec_encryption_mode', 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_complain', 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_default_channeladmingroup', 1, 0, 0);
@@ -633,6 +655,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_token_use', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 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, 3, 0, 'i_channel_create_modify_with_codec_maxquality', 10, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_channel_create_modify_with_temp_delete_delay', 86400, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_channel_delete_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_channel_description_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_channel_join_power', 75, 0, 0);
@@ -683,10 +706,15 @@ 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_create_modify_with_codec_celtmono48', 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_create_modify_with_codec_latency_factor_min', 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_create_modify_with_codec_maxquality', 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_create_modify_with_codec_opusmusic', 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_create_modify_with_codec_opusvoice', 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_create_modify_with_codec_speex16', 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_create_modify_with_codec_speex32', 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_create_modify_with_codec_speex8', 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_create_modify_with_force_password', 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_create_modify_with_temp_delete_delay', 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_create_permanent', 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_create_private', 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_create_semi_permanent', 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_create_temporary', 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_create_with_default', 75, 0, 0);
@@ -730,6 +758,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_modify_password', 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_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_modify_sortorder', 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_modify_temp_delete_delay', 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_modify_topic', 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_needed_delete_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_needed_description_view_power', 75, 0, 0);
@@ -757,8 +786,10 @@ 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_force_push_to_talk', 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_ignore_antiflood', 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_ignore_bans', 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_ignore_sticky', 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_info_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_is_priority_speaker', 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_is_sticky', 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_issue_client_query_command', 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_kick_from_channel_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_kick_from_server_power', 75, 0, 0);
@@ -851,6 +882,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_virtualserver_modify_antiflood', 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_autostart', 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_channel_forced_silence', 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_channel_temp_delete_delay_default', 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_codec_encryption_mode', 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_complain', 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_default_channeladmingroup', 75, 0, 0);
@@ -891,9 +923,11 @@ 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_token_use', 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_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, 4, 0, 'b_channel_create_child', 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_channel_create_modify_with_codec_opusvoice', 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_channel_create_modify_with_codec_speex16', 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_channel_create_modify_with_codec_speex32', 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_channel_create_modify_with_codec_speex8', 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_channel_create_private', 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_channel_create_semi_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_channel_create_temporary', 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_channel_create_with_description', 1, 0, 0);
@@ -953,6 +987,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, 'i_group_needed_member_add_power', 60, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'i_group_needed_member_remove_power', 60, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'i_group_needed_modify_power', 75, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'b_channel_create_modify_with_codec_opusvoice', 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_channel_create_modify_with_codec_speex16', 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_channel_create_modify_with_codec_speex8', 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_channel_create_temporary', 1, 0, 0);
diff --git a/sql/update_20.sql b/sql/update_20.sql
new file mode 100644
index 0000000..1a296ce
--- /dev/null
+++ b/sql/update_20.sql
@@ -0,0 +1 @@
+ALTER TABLE complains ADD COLUMN complain_hash text;
diff --git a/sql/update_21.sql b/sql/update_21.sql
new file mode 100644
index 0000000..3ef3a4c
--- /dev/null
+++ b/sql/update_21.sql
@@ -0,0 +1 @@
+ALTER TABLE bans ADD COLUMN ban_hash text;