summaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
authorAlexander Sulfrian <alexander@sulfrian.net>2014-10-09 00:37:36 +0200
committerAlexander Sulfrian <alexander@sulfrian.net>2014-10-09 00:43:34 +0200
commit6e67f7db177ba29080722601c44af570154d2005 (patch)
tree97e71febbe420b7cb69cb76c8c9e50610b247ee1 /sql
parentd03126200a1ed3db14ba06406a7a9f7309c44738 (diff)
downloadts3db_postgres-master.tar.gz
ts3db_postgres-master.tar.xz
ts3db_postgres-master.zip
sql: update to version 21 (ts3-v3.0.10.3)HEADmaster
Diffstat (limited to 'sql')
-rw-r--r--sql/ban_insert.sql6
-rw-r--r--sql/complain_insert.sql2
-rw-r--r--sql/create_pg/create_tables.sql2
-rw-r--r--sql/defaults.sql37
-rw-r--r--sql/update_20.sql1
-rw-r--r--sql/update_21.sql1
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;