From 6e67f7db177ba29080722601c44af570154d2005 Mon Sep 17 00:00:00 2001 From: Alexander Sulfrian Date: Thu, 9 Oct 2014 00:37:36 +0200 Subject: sql: update to version 21 (ts3-v3.0.10.3) --- sql/ban_insert.sql | 6 ++++-- sql/complain_insert.sql | 2 +- sql/create_pg/create_tables.sql | 2 ++ sql/defaults.sql | 37 ++++++++++++++++++++++++++++++++++++- sql/update_20.sql | 1 + sql/update_21.sql | 1 + 6 files changed, 45 insertions(+), 4 deletions(-) create mode 100644 sql/update_20.sql create mode 100644 sql/update_21.sql (limited to 'sql') 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; -- cgit v1.2.3