From 39081f84a402aebb52d98a43e4675c90135cea9b Mon Sep 17 00:00:00 2001 From: Alexander Sulfrian Date: Wed, 7 Dec 2011 19:06:52 +0100 Subject: added sql files --- sql/ban_delete.sql | 1 + sql/ban_insert.sql | 22 + sql/ban_list.sql | 1 + sql/binding_delete.sql | 1 + sql/bindings_insert.sql | 6 + sql/bindings_list.sql | 1 + sql/channel_delete.sql | 6 + sql/channel_insert.sql | 6 + sql/channel_server_list.sql | 1 + sql/channel_update_parentid.sql | 3 + sql/client_clear_traffic_stats.sql | 1 + sql/client_count_by_serverid.sql | 1 + sql/client_delete.sql | 9 + sql/client_delete_prune.sql | 1 + sql/client_get.sql | 1 + sql/client_get_by_id.sql | 1 + sql/client_get_by_name_or_uid.sql | 3 + sql/client_get_by_serverid.sql | 1 + sql/client_get_by_serverid_limit.sql | 1 + sql/client_get_by_uid.sql | 1 + sql/client_insert.sql | 10 + sql/client_update_login_info.sql | 1 + sql/client_update_name.sql | 1 + sql/client_update_stats.sql | 1 + sql/client_update_traffic_stats.sql | 6 + sql/clientid_get_by_name_pw.sql | 2 + sql/clientid_get_by_name_pw_serverid.sql | 4 + sql/complain_delete.sql | 1 + sql/complain_delete_all.sql | 1 + sql/complain_get_by_serverid.sql | 1 + sql/complain_insert.sql | 1 + sql/create_pg/create_tables.sql | 239 +++++++ sql/create_pg/drop_tables.sql | 22 + sql/custom_delete_by_clientid.sql | 1 + sql/custom_get_by_id.sql | 1 + sql/custom_get_by_ident.sql | 1 + sql/custom_insert.sql | 10 + sql/defaults.sql | 1025 ++++++++++++++++++++++++++++ sql/group_delete.sql | 3 + sql/group_id_get_by_name.sql | 1 + sql/group_insert.sql | 1 + sql/group_member_delete.sql | 1 + sql/group_member_delete_by_groupid.sql | 1 + sql/group_member_detail_get_by_groupid.sql | 1 + sql/group_member_get.sql | 1 + sql/group_member_insert.sql | 1 + sql/group_members_get_by_groupid.sql | 1 + sql/group_members_get_by_id.sql | 1 + sql/group_members_get_by_serverid.sql | 1 + sql/group_rename.sql | 1 + sql/groups_get.sql | 1 + sql/groups_get_by_serverid.sql | 1 + sql/groups_get_by_serverid_type.sql | 1 + sql/info_delete.sql | 1 + sql/info_get_by_ident.sql | 1 + sql/info_insert.sql | 1 + sql/message_delete.sql | 1 + sql/message_get_by_clientid.sql | 1 + sql/message_get_unread_by_clientid.sql | 1 + sql/message_insert.sql | 1 + sql/message_list_by_clientid.sql | 1 + sql/message_update_flag.sql | 1 + sql/perm_delete_by_groupid.sql | 1 + sql/perm_delete_by_permid.sql | 1 + sql/perm_delete_by_serverid.sql | 13 + sql/perm_get_by_id.sql | 1 + sql/perm_get_by_serverid.sql | 1 + sql/perm_insert.sql | 1 + sql/perm_rename.sql | 5 + sql/perm_update_get_groups.sql | 1 + sql/properties_delete_by_id.sql | 1 + sql/properties_delete_by_string_id.sql | 1 + sql/properties_insert_by_id.sql | 1 + sql/properties_insert_by_string_id.sql | 1 + sql/properties_list_by_id.sql | 1 + sql/properties_list_by_string_id.sql | 1 + sql/server_clear_traffic_stats.sql | 1 + sql/server_delete.sql | 21 + sql/server_delete_get_qa_clients.sql | 1 + sql/server_get_byid.sql | 1 + sql/server_get_byport.sql | 1 + sql/server_insert.sql | 4 + sql/server_list.sql | 1 + sql/server_list_by_machine_id.sql | 1 + sql/server_snapshot_delete.sql | 18 + sql/server_snapshot_delete_failed.sql | 19 + sql/server_update_autostart.sql | 1 + sql/server_update_machine_id.sql | 1 + sql/server_update_port.sql | 1 + sql/server_update_traffic_stats.sql | 6 + sql/token_delete_by_key.sql | 1 + sql/token_get_by_key.sql | 1 + sql/token_insert.sql | 18 + sql/token_list.sql | 1 + sql/update_12.sql | 13 + sql/update_13.sql | 34 + sql/update_14.sql | 5 + sql/update_15.sql | 1 + sql/update_16.sql | 3 + sql/update_17.sql | 2 + sql/update_18.sql | 1 + sql/update_19.sql | 1 + sql/update_database_version.sql | 1 + sql/update_permissions_12.sql | 9 + 104 files changed, 1620 insertions(+) create mode 100644 sql/ban_delete.sql create mode 100644 sql/ban_insert.sql create mode 100644 sql/ban_list.sql create mode 100644 sql/binding_delete.sql create mode 100644 sql/bindings_insert.sql create mode 100644 sql/bindings_list.sql create mode 100644 sql/channel_delete.sql create mode 100644 sql/channel_insert.sql create mode 100644 sql/channel_server_list.sql create mode 100644 sql/channel_update_parentid.sql create mode 100644 sql/client_clear_traffic_stats.sql create mode 100644 sql/client_count_by_serverid.sql create mode 100644 sql/client_delete.sql create mode 100644 sql/client_delete_prune.sql create mode 100644 sql/client_get.sql create mode 100644 sql/client_get_by_id.sql create mode 100644 sql/client_get_by_name_or_uid.sql create mode 100644 sql/client_get_by_serverid.sql create mode 100644 sql/client_get_by_serverid_limit.sql create mode 100644 sql/client_get_by_uid.sql create mode 100644 sql/client_insert.sql create mode 100644 sql/client_update_login_info.sql create mode 100644 sql/client_update_name.sql create mode 100644 sql/client_update_stats.sql create mode 100644 sql/client_update_traffic_stats.sql create mode 100644 sql/clientid_get_by_name_pw.sql create mode 100644 sql/clientid_get_by_name_pw_serverid.sql create mode 100644 sql/complain_delete.sql create mode 100644 sql/complain_delete_all.sql create mode 100644 sql/complain_get_by_serverid.sql create mode 100644 sql/complain_insert.sql create mode 100644 sql/create_pg/create_tables.sql create mode 100644 sql/create_pg/drop_tables.sql create mode 100644 sql/custom_delete_by_clientid.sql create mode 100644 sql/custom_get_by_id.sql create mode 100644 sql/custom_get_by_ident.sql create mode 100644 sql/custom_insert.sql create mode 100644 sql/defaults.sql create mode 100644 sql/group_delete.sql create mode 100644 sql/group_id_get_by_name.sql create mode 100644 sql/group_insert.sql create mode 100644 sql/group_member_delete.sql create mode 100644 sql/group_member_delete_by_groupid.sql create mode 100644 sql/group_member_detail_get_by_groupid.sql create mode 100644 sql/group_member_get.sql create mode 100644 sql/group_member_insert.sql create mode 100644 sql/group_members_get_by_groupid.sql create mode 100644 sql/group_members_get_by_id.sql create mode 100644 sql/group_members_get_by_serverid.sql create mode 100644 sql/group_rename.sql create mode 100644 sql/groups_get.sql create mode 100644 sql/groups_get_by_serverid.sql create mode 100644 sql/groups_get_by_serverid_type.sql create mode 100644 sql/info_delete.sql create mode 100644 sql/info_get_by_ident.sql create mode 100644 sql/info_insert.sql create mode 100644 sql/message_delete.sql create mode 100644 sql/message_get_by_clientid.sql create mode 100644 sql/message_get_unread_by_clientid.sql create mode 100644 sql/message_insert.sql create mode 100644 sql/message_list_by_clientid.sql create mode 100644 sql/message_update_flag.sql create mode 100644 sql/perm_delete_by_groupid.sql create mode 100644 sql/perm_delete_by_permid.sql create mode 100644 sql/perm_delete_by_serverid.sql create mode 100644 sql/perm_get_by_id.sql create mode 100644 sql/perm_get_by_serverid.sql create mode 100644 sql/perm_insert.sql create mode 100644 sql/perm_rename.sql create mode 100644 sql/perm_update_get_groups.sql create mode 100644 sql/properties_delete_by_id.sql create mode 100644 sql/properties_delete_by_string_id.sql create mode 100644 sql/properties_insert_by_id.sql create mode 100644 sql/properties_insert_by_string_id.sql create mode 100644 sql/properties_list_by_id.sql create mode 100644 sql/properties_list_by_string_id.sql create mode 100644 sql/server_clear_traffic_stats.sql create mode 100644 sql/server_delete.sql create mode 100644 sql/server_delete_get_qa_clients.sql create mode 100644 sql/server_get_byid.sql create mode 100644 sql/server_get_byport.sql create mode 100644 sql/server_insert.sql create mode 100644 sql/server_list.sql create mode 100644 sql/server_list_by_machine_id.sql create mode 100644 sql/server_snapshot_delete.sql create mode 100644 sql/server_snapshot_delete_failed.sql create mode 100644 sql/server_update_autostart.sql create mode 100644 sql/server_update_machine_id.sql create mode 100644 sql/server_update_port.sql create mode 100644 sql/server_update_traffic_stats.sql create mode 100644 sql/token_delete_by_key.sql create mode 100644 sql/token_get_by_key.sql create mode 100644 sql/token_insert.sql create mode 100644 sql/token_list.sql create mode 100644 sql/update_12.sql create mode 100644 sql/update_13.sql create mode 100644 sql/update_14.sql create mode 100644 sql/update_15.sql create mode 100644 sql/update_16.sql create mode 100644 sql/update_17.sql create mode 100644 sql/update_18.sql create mode 100644 sql/update_19.sql create mode 100644 sql/update_database_version.sql create mode 100644 sql/update_permissions_12.sql (limited to 'sql') diff --git a/sql/ban_delete.sql b/sql/ban_delete.sql new file mode 100644 index 0000000..57e119f --- /dev/null +++ b/sql/ban_delete.sql @@ -0,0 +1 @@ +delete from bans where server_id=:server_id: and ban_id=:ban_id:; \ No newline at end of file diff --git a/sql/ban_insert.sql b/sql/ban_insert.sql new file mode 100644 index 0000000..5830891 --- /dev/null +++ b/sql/ban_insert.sql @@ -0,0 +1,22 @@ +INSERT INTO bans +(server_id, + ban_ip, + ban_name, + ban_uid, + ban_timestamp, + ban_length, + ban_invoker_client_id, + ban_invoker_uid, + ban_invoker_name, + ban_reason) +VALUES +(:server_id:, + :ban_ip:, + :ban_name:, + :ban_uid:, + :ban_timestamp:, + :ban_length:, + :ban_invoker_client_id:, + :ban_invoker_uid:, + :ban_invoker_name:, + :ban_reason:); \ No newline at end of file diff --git a/sql/ban_list.sql b/sql/ban_list.sql new file mode 100644 index 0000000..4f54e1e --- /dev/null +++ b/sql/ban_list.sql @@ -0,0 +1 @@ +select * from bans where server_id=:server_id:; diff --git a/sql/binding_delete.sql b/sql/binding_delete.sql new file mode 100644 index 0000000..bfeda06 --- /dev/null +++ b/sql/binding_delete.sql @@ -0,0 +1 @@ +delete from bindings where binding_id=:binding_id:; diff --git a/sql/bindings_insert.sql b/sql/bindings_insert.sql new file mode 100644 index 0000000..7820d56 --- /dev/null +++ b/sql/bindings_insert.sql @@ -0,0 +1,6 @@ +insert into bindings +( ip, + type) +VALUES +( :ip:, + :type:); diff --git a/sql/bindings_list.sql b/sql/bindings_list.sql new file mode 100644 index 0000000..0f51ff6 --- /dev/null +++ b/sql/bindings_list.sql @@ -0,0 +1 @@ +select * from bindings where type = :type:; diff --git a/sql/channel_delete.sql b/sql/channel_delete.sql new file mode 100644 index 0000000..f87412b --- /dev/null +++ b/sql/channel_delete.sql @@ -0,0 +1,6 @@ +delete from channels where channel_id=:channel_id:; +delete from channel_properties where id=:channel_id:; +delete from group_channel_to_client where server_id=:server_id: and id2=:channel_id:; +delete from perm_channel where server_id=:server_id: and id1=:channel_id:; +delete from perm_channel_clients where server_id=:server_id: and id1=:channel_id:; +delete from tokens where token_type=1 and token_id2=:channel_id:; \ No newline at end of file diff --git a/sql/channel_insert.sql b/sql/channel_insert.sql new file mode 100644 index 0000000..6218893 --- /dev/null +++ b/sql/channel_insert.sql @@ -0,0 +1,6 @@ +insert into channels +( server_id, + channel_parent_id ) +VALUES +( :server_id:, + :parent_id: ); diff --git a/sql/channel_server_list.sql b/sql/channel_server_list.sql new file mode 100644 index 0000000..124869e --- /dev/null +++ b/sql/channel_server_list.sql @@ -0,0 +1 @@ +select channel_id, channel_parent_id from channels where server_id=:server_id:; \ No newline at end of file diff --git a/sql/channel_update_parentid.sql b/sql/channel_update_parentid.sql new file mode 100644 index 0000000..0ed7201 --- /dev/null +++ b/sql/channel_update_parentid.sql @@ -0,0 +1,3 @@ +update channels + set channel_parent_id = :parent_id: + where channel_id = :channel_id: ; diff --git a/sql/client_clear_traffic_stats.sql b/sql/client_clear_traffic_stats.sql new file mode 100644 index 0000000..f73e731 --- /dev/null +++ b/sql/client_clear_traffic_stats.sql @@ -0,0 +1 @@ +update clients set client_month_upload= 0, client_month_download= 0 where server_id=:server_id:; \ No newline at end of file diff --git a/sql/client_count_by_serverid.sql b/sql/client_count_by_serverid.sql new file mode 100644 index 0000000..880b0f2 --- /dev/null +++ b/sql/client_count_by_serverid.sql @@ -0,0 +1 @@ +select count(*) as count from clients where server_id=:server_id:; diff --git a/sql/client_delete.sql b/sql/client_delete.sql new file mode 100644 index 0000000..c242940 --- /dev/null +++ b/sql/client_delete.sql @@ -0,0 +1,9 @@ +delete from clients where client_id=:client_id:; +delete from client_properties where id=:client_id:; +delete from messages where message_to_client_id=:client_id:; +delete from complains where complain_to_client_id=:client_id:; +delete from group_channel_to_client where id1=:client_id:; +delete from group_server_to_client where id1=:client_id:; +delete from perm_client where id1=:client_id:; +delete from perm_channel_clients where id2=:client_id:; +delete from custom_fields where client_id=:client_id:; \ No newline at end of file diff --git a/sql/client_delete_prune.sql b/sql/client_delete_prune.sql new file mode 100644 index 0000000..81ae6da --- /dev/null +++ b/sql/client_delete_prune.sql @@ -0,0 +1 @@ +select * from clients where not exists (select id1 from group_server_to_client where id1= clients.client_id) and client_lastconnected < :timestamp: and server_id != 0 limit 100; \ No newline at end of file diff --git a/sql/client_get.sql b/sql/client_get.sql new file mode 100644 index 0000000..347976e --- /dev/null +++ b/sql/client_get.sql @@ -0,0 +1 @@ +select * from clients where client_id=:client_id:; \ No newline at end of file diff --git a/sql/client_get_by_id.sql b/sql/client_get_by_id.sql new file mode 100644 index 0000000..f3f6d76 --- /dev/null +++ b/sql/client_get_by_id.sql @@ -0,0 +1 @@ +select * from clients where client_id=:client_id: and server_id=:server_id:; \ No newline at end of file diff --git a/sql/client_get_by_name_or_uid.sql b/sql/client_get_by_name_or_uid.sql new file mode 100644 index 0000000..5d361e4 --- /dev/null +++ b/sql/client_get_by_name_or_uid.sql @@ -0,0 +1,3 @@ +select * from clients where clients.server_id = :server_id: and +(client_unique_id like(:client_unique_id:) or +client_nickname like(:client_nickname:)) limit 50 \ No newline at end of file diff --git a/sql/client_get_by_serverid.sql b/sql/client_get_by_serverid.sql new file mode 100644 index 0000000..0047571 --- /dev/null +++ b/sql/client_get_by_serverid.sql @@ -0,0 +1 @@ +select * from clients where server_id=:server_id:; diff --git a/sql/client_get_by_serverid_limit.sql b/sql/client_get_by_serverid_limit.sql new file mode 100644 index 0000000..a10d88d --- /dev/null +++ b/sql/client_get_by_serverid_limit.sql @@ -0,0 +1 @@ +select * from clients where server_id=:server_id: limit :start:, :duration:; \ No newline at end of file diff --git a/sql/client_get_by_uid.sql b/sql/client_get_by_uid.sql new file mode 100644 index 0000000..03d8882 --- /dev/null +++ b/sql/client_get_by_uid.sql @@ -0,0 +1 @@ +select * from clients where client_unique_id = :client_unique_id: and server_id=:server_id:; \ No newline at end of file diff --git a/sql/client_insert.sql b/sql/client_insert.sql new file mode 100644 index 0000000..27d6c08 --- /dev/null +++ b/sql/client_insert.sql @@ -0,0 +1,10 @@ +insert into clients +( server_id, + client_unique_id, + client_nickname, + client_lastconnected) +VALUES +( :server_id:, + :client_unique_id:, + :client_nickname:, + :client_lastconnected:); diff --git a/sql/client_update_login_info.sql b/sql/client_update_login_info.sql new file mode 100644 index 0000000..a827302 --- /dev/null +++ b/sql/client_update_login_info.sql @@ -0,0 +1 @@ +update clients set client_login_name=:client_login_name:, client_login_password=:client_login_password: where client_id=:client_id: and server_id=:server_id:; \ No newline at end of file diff --git a/sql/client_update_name.sql b/sql/client_update_name.sql new file mode 100644 index 0000000..213a0f5 --- /dev/null +++ b/sql/client_update_name.sql @@ -0,0 +1 @@ +update clients set client_nickname=:client_nickname: where client_id=:client_id: and server_id=:server_id:; \ No newline at end of file diff --git a/sql/client_update_stats.sql b/sql/client_update_stats.sql new file mode 100644 index 0000000..5f66552 --- /dev/null +++ b/sql/client_update_stats.sql @@ -0,0 +1 @@ +update clients set client_lastconnected=:client_lastconnected:, client_totalconnections=client_totalconnections+1, client_lastip=:client_lastip: where client_id=:client_id:; \ No newline at end of file diff --git a/sql/client_update_traffic_stats.sql b/sql/client_update_traffic_stats.sql new file mode 100644 index 0000000..caf55c4 --- /dev/null +++ b/sql/client_update_traffic_stats.sql @@ -0,0 +1,6 @@ +update clients set + client_month_upload= client_month_upload + :upload:, + client_month_download= client_month_download + :download:, + client_total_upload= client_total_upload + :upload:, + client_total_download= client_total_download + :download: + where client_id=:client_id:; \ No newline at end of file diff --git a/sql/clientid_get_by_name_pw.sql b/sql/clientid_get_by_name_pw.sql new file mode 100644 index 0000000..cbc57ad --- /dev/null +++ b/sql/clientid_get_by_name_pw.sql @@ -0,0 +1,2 @@ +select * from clients where client_login_name = :client_login_name: + and client_login_password = :client_login_password:; \ No newline at end of file diff --git a/sql/clientid_get_by_name_pw_serverid.sql b/sql/clientid_get_by_name_pw_serverid.sql new file mode 100644 index 0000000..28e88e7 --- /dev/null +++ b/sql/clientid_get_by_name_pw_serverid.sql @@ -0,0 +1,4 @@ +select * from clients where client_login_name = :client_login_name: + and client_login_password = :client_login_password: + and server_id = :server_id: + \ No newline at end of file diff --git a/sql/complain_delete.sql b/sql/complain_delete.sql new file mode 100644 index 0000000..2307747 --- /dev/null +++ b/sql/complain_delete.sql @@ -0,0 +1 @@ +delete from complains where complain_from_client_id = :complain_from_client_id: and server_id = :server_id: and complain_to_client_id = :complain_to_client_id:; \ No newline at end of file diff --git a/sql/complain_delete_all.sql b/sql/complain_delete_all.sql new file mode 100644 index 0000000..d02dec1 --- /dev/null +++ b/sql/complain_delete_all.sql @@ -0,0 +1 @@ +delete from complains where server_id = :server_id: and complain_to_client_id = :complain_to_client_id:; \ No newline at end of file diff --git a/sql/complain_get_by_serverid.sql b/sql/complain_get_by_serverid.sql new file mode 100644 index 0000000..6fcb2ef --- /dev/null +++ b/sql/complain_get_by_serverid.sql @@ -0,0 +1 @@ +select * from complains where server_id = :server_id:; \ No newline at end of file diff --git a/sql/complain_insert.sql b/sql/complain_insert.sql new file mode 100644 index 0000000..13d78e5 --- /dev/null +++ b/sql/complain_insert.sql @@ -0,0 +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 diff --git a/sql/create_pg/create_tables.sql b/sql/create_pg/create_tables.sql new file mode 100644 index 0000000..9923c67 --- /dev/null +++ b/sql/create_pg/create_tables.sql @@ -0,0 +1,239 @@ +CREATE TABLE channel_properties ( + server_id bigint, + id bigint, + ident TEXT NOT NULL, + value TEXT +); +CREATE INDEX index_channel_properties_id ON channel_properties (id); +CREATE INDEX index_channel_properties_serverid ON channel_properties (server_id); + +CREATE TABLE channels ( + channel_id SERIAL PRIMARY KEY NOT NULL, + channel_parent_id bigint, + server_id bigint NOT NULL +); + +CREATE INDEX index_channels_id ON channels (channel_id); +CREATE INDEX index_channels_serverid ON channels (server_id); + +CREATE TABLE client_properties ( + server_id bigint, + id bigint, + ident text NOT NULL, + value text +); +CREATE INDEX index_client_properties_id ON client_properties (id); +CREATE INDEX index_client_properties_serverid ON client_properties (server_id); + +CREATE TABLE clients ( + client_id SERIAL PRIMARY KEY NOT NULL, + server_id bigint, + client_unique_id text, + client_nickname text, + client_login_name text UNIQUE, + client_login_password text, + client_lastconnected bigint, + client_totalconnections bigint default 0, + client_month_upload bigint default 0, + client_month_download bigint default 0, + client_total_upload bigint default 0, + client_total_download bigint default 0, + client_lastip text +); +CREATE INDEX index_clients_id ON clients (client_id); +CREATE INDEX index_clients_serverid ON clients (server_id); +CREATE INDEX index_clients_lastconnectedserverid ON clients (client_lastconnected, server_id); +CREATE INDEX index_clients_uid ON clients (client_unique_id, server_id); + +CREATE TABLE groups_channel ( + group_id SERIAL PRIMARY KEY NOT NULL, + server_id bigint NOT NULL, + name text NOT NULL, + type integer NOT NULL +); +CREATE INDEX index_groups_channel_id ON groups_channel (group_id); +CREATE INDEX index_groups_channel_serverid ON groups_channel (server_id); + +CREATE TABLE groups_server ( + group_id SERIAL PRIMARY KEY NOT NULL, + server_id bigint NOT NULL, + name text NOT NULL, + type integer NOT NULL +); +CREATE INDEX index_groups_server_id ON groups_server (group_id); +CREATE INDEX index_groups_server_serverid ON groups_server (server_id); + +CREATE TABLE group_server_to_client ( + group_id bigint NOT NULL, + server_id bigint NOT NULL, + id1 bigint NOT NULL, + id2 bigint NOT NULL +); +CREATE INDEX index_group_server_to_client_id ON group_server_to_client (group_id); +CREATE INDEX index_group_server_to_client_serverid ON group_server_to_client (server_id); +CREATE INDEX index_group_server_to_client_id1 ON group_server_to_client (id1); + +CREATE TABLE group_channel_to_client ( + group_id bigint NOT NULL, + server_id bigint NOT NULL, + id1 bigint NOT NULL, + id2 bigint NOT NULL +); +CREATE INDEX index_group_channel_to_client_id ON group_channel_to_client (group_id); +CREATE INDEX index_group_channel_to_client_serverid ON group_channel_to_client (server_id); +CREATE INDEX index_group_channel_to_client_id1 ON group_channel_to_client (id1); +CREATE INDEX index_group_channel_to_client_id2 ON group_channel_to_client (id2); + +CREATE TABLE perm_channel ( + server_id bigint NOT NULL, + id1 bigint NOT NULL, + id2 bigint NOT NULL, + perm_id text NOT NULL, + perm_value integer, + perm_negated integer, + perm_skip integer +); +CREATE INDEX index_perm_channel_serverid ON perm_channel (server_id); + +CREATE TABLE perm_channel_clients ( + server_id bigint NOT NULL, + id1 bigint NOT NULL, + id2 bigint NOT NULL, + perm_id text NOT NULL, + perm_value integer, + perm_negated integer, + perm_skip integer +); +CREATE INDEX index_perm_channel_clients_serverid ON perm_channel_clients (server_id); + +CREATE TABLE perm_channel_groups ( + server_id bigint NOT NULL, + id1 bigint NOT NULL, + id2 bigint NOT NULL, + perm_id text NOT NULL, + perm_value integer, + perm_negated integer, + perm_skip integer +); +CREATE INDEX index_perm_channel_groups_serverid ON perm_channel_groups (server_id); + +CREATE TABLE perm_client ( + server_id bigint NOT NULL, + id1 bigint NOT NULL, + id2 bigint NOT NULL, + perm_id text NOT NULL, + perm_value integer, + perm_negated integer, + perm_skip integer +); +CREATE INDEX index_perm_client_serverid ON perm_client (server_id); + +CREATE TABLE perm_server_group ( + server_id bigint NOT NULL, + id1 bigint NOT NULL, + id2 bigint NOT NULL, + perm_id text NOT NULL, + perm_value integer, + perm_negated integer, + perm_skip integer +); +CREATE INDEX index_perm_server_group_serverid ON perm_server_group (server_id); + +CREATE TABLE bindings ( + binding_id SERIAL PRIMARY KEY NOT NULL, + ip text NOT NULL, + type integer +); + +CREATE TABLE server_properties ( + server_id bigint, + id bigint, + ident text NOT NULL, + value text +); +CREATE INDEX index_server_properties_id ON server_properties (id); +CREATE INDEX index_server_properties_serverid ON server_properties (server_id); + +CREATE TABLE servers ( + server_id SERIAL PRIMARY KEY NOT NULL, + server_port bigint, + server_autostart bigint, + server_machine_id text, + server_month_upload bigint Default 0, + server_month_download bigint Default 0, + server_total_upload bigint Default 0, + server_total_download bigint Default 0 +); +CREATE INDEX index_servers_serverid ON servers (server_id); +CREATE INDEX index_servers_port ON servers (server_port); + +CREATE TABLE tokens ( + server_id bigint, + token_key text NOT NULL, + token_type integer, + token_id1 bigint, + token_id2 bigint, + token_created bigint, + token_description text, + token_customset text + ); + +CREATE TABLE messages ( + message_id SERIAL PRIMARY KEY NOT NULL, + server_id bigint, + message_from_client_id bigint, + message_from_client_uid text, + message_to_client_id bigint, + message_subject text, + message_msg text, + message_timestamp bigint, + message_flag_read integer default 0 +); +CREATE INDEX index_messages_serverid ON messages (server_id); +CREATE INDEX index_messages_msgidtoclid_read ON messages (message_to_client_id, message_flag_read); + +CREATE TABLE complains ( + server_id bigint, + complain_from_client_id bigint, + complain_to_client_id bigint, + complain_message text, + complain_timestamp bigint +); +CREATE INDEX index_complains_serverid ON complains (server_id); + +CREATE TABLE bans ( + ban_id SERIAL PRIMARY KEY NOT NULL, + server_id bigint, + ban_ip text, + ban_name text, + ban_uid text, + ban_timestamp bigint, + ban_length bigint, + ban_invoker_client_id bigint, + ban_invoker_uid text, + ban_invoker_name text, + ban_reason text, + ban_enforcements bigint Default 0 +); +CREATE INDEX index_bans_serverid ON bans (server_id); + +CREATE TABLE instance_properties ( + server_id bigint, + string_id text, + id bigint, + ident text NOT NULL, + value text +); +CREATE INDEX index_instance_properties_id ON instance_properties (id); +CREATE INDEX index_instance_properties_string_id ON instance_properties (string_id); +CREATE INDEX index_instance_properties_serverid ON instance_properties (server_id); + +CREATE TABLE custom_fields ( + server_id bigint, + client_id bigint, + ident text NOT NULL, + value text +); +CREATE INDEX index_custom_fields_serverid ON custom_fields (server_id); +CREATE INDEX index_custom_fields_client_id ON custom_fields (client_id); +CREATE INDEX index_custom_fields_ident ON custom_fields (ident); diff --git a/sql/create_pg/drop_tables.sql b/sql/create_pg/drop_tables.sql new file mode 100644 index 0000000..0383bb5 --- /dev/null +++ b/sql/create_pg/drop_tables.sql @@ -0,0 +1,22 @@ +DROP TABLE IF EXISTS channel_properties; +DROP TABLE IF EXISTS channels; +DROP TABLE IF EXISTS client_properties; +DROP TABLE IF EXISTS clients; +DROP TABLE IF EXISTS groups_channel; +DROP TABLE IF EXISTS groups_server; +DROP TABLE IF EXISTS group_server_to_client; +DROP TABLE IF EXISTS group_channel_to_client; +DROP TABLE IF EXISTS perm_channel; +DROP TABLE IF EXISTS perm_channel_clients; +DROP TABLE IF EXISTS perm_channel_groups; +DROP TABLE IF EXISTS perm_client; +DROP TABLE IF EXISTS perm_server_group; +DROP TABLE IF EXISTS bindings; +DROP TABLE IF EXISTS server_properties; +DROP TABLE IF EXISTS servers; +DROP TABLE IF EXISTS tokens; +DROP TABLE IF EXISTS messages; +DROP TABLE IF EXISTS complains; +DROP TABLE IF EXISTS bans; +DROP TABLE IF EXISTS instance_properties; +DROP TABLE IF EXISTS custom_fields; diff --git a/sql/custom_delete_by_clientid.sql b/sql/custom_delete_by_clientid.sql new file mode 100644 index 0000000..33ae794 --- /dev/null +++ b/sql/custom_delete_by_clientid.sql @@ -0,0 +1 @@ +delete from custom_fields where server_id=:server_id: and client_id=:client_id:; diff --git a/sql/custom_get_by_id.sql b/sql/custom_get_by_id.sql new file mode 100644 index 0000000..9c58954 --- /dev/null +++ b/sql/custom_get_by_id.sql @@ -0,0 +1 @@ +select * from custom_fields where server_id=:server_id: and client_id=:client_id:; \ No newline at end of file diff --git a/sql/custom_get_by_ident.sql b/sql/custom_get_by_ident.sql new file mode 100644 index 0000000..6954615 --- /dev/null +++ b/sql/custom_get_by_ident.sql @@ -0,0 +1 @@ +select * from custom_fields where server_id=:server_id: and ident=:ident: and value like(:pattern:); \ No newline at end of file diff --git a/sql/custom_insert.sql b/sql/custom_insert.sql new file mode 100644 index 0000000..fcaf570 --- /dev/null +++ b/sql/custom_insert.sql @@ -0,0 +1,10 @@ +insert into custom_fields +( server_id, + client_id, + ident, + value) +VALUES +( :server_id:, + :client_id:, + :ident:, + :value:); diff --git a/sql/defaults.sql b/sql/defaults.sql new file mode 100644 index 0000000..65ce451 --- /dev/null +++ b/sql/defaults.sql @@ -0,0 +1,1025 @@ +-- serverinstance properties +insert into instance_properties (server_id, id, ident, value) values (0, 0, "serverinstance_filetransfer_port", "30033"); +insert into instance_properties (server_id, id, ident, value) values (0, 0, "serverinstance_guest_serverquery_group", "1"); +insert into instance_properties (server_id, id, ident, value) values (0, 0, "serverinstance_max_download_total_bandwidth", "-1"); +insert into instance_properties (server_id, id, ident, value) values (0, 0, "serverinstance_max_upload_total_bandwidth", "-1"); +insert into instance_properties (server_id, id, ident, value) values (0, 0, "serverinstance_template_serveradmin_group", "3"); +insert into instance_properties (server_id, id, ident, value) values (0, 0, "serverinstance_template_serverdefault_group", "5"); +insert into instance_properties (server_id, id, ident, value) values (0, 0, "serverinstance_template_channeladmin_group", "1"); +insert into instance_properties (server_id, id, ident, value) values (0, 0, "serverinstance_template_channeldefault_group", "4"); +insert into instance_properties (server_id, id, ident, value) values (0, 0, "serverinstance_permissions_version", "13"); + +-- bindings +insert into bindings (ip, type) values ("0.0.0.0", 0); +insert into bindings (ip, type) values ("0.0.0.0", 1); +insert into bindings (ip, type) values ("0.0.0.0", 2); + +--default server properties +insert into server_properties (server_id, id, ident, value) values (0, 0, "virtualserver_name", "TeamSpeak ]I[ Server"); +insert into server_properties (server_id, id, ident, value) values (0, 0, "virtualserver_welcomemessage", "Welcome to TeamSpeak, check [URL]www.teamspeak.com[/URL] for latest information"); +insert into server_properties (server_id, id, ident, value) values (0, 0, "virtualserver_maxclients", "32"); +insert into server_properties (server_id, id, ident, value) values (0, 0, "virtualserver_max_download_total_bandwidth", "-1"); +insert into server_properties (server_id, id, ident, value) values (0, 0, "virtualserver_max_upload_total_bandwidth", "-1"); + +-- default servergroups +insert into groups_server (server_id, name, type) values (0, "Guest Server Query", 2); +insert into groups_server (server_id, name, type) values (0, "Admin Server Query", 2); +insert into groups_server (server_id, name, type) values (0, "Server Admin", 0); +insert into groups_server (server_id, name, type) values (0, "Normal", 0); +insert into groups_server (server_id, name, type) values (0, "Guest", 0); + +-- default channelgroups +insert into groups_channel (server_id, name, type) values (0, "Channel Admin", 0); +insert into groups_channel (server_id, name, type) values (0, "Operator", 0); +insert into groups_channel (server_id, name, type) values (0, "Voice", 0); +insert into groups_channel (server_id, name, type) values (0, "Guest", 0); + +-- adds a default serverquery user +insert into clients (server_id, client_unique_id, client_nickname, client_login_name, client_login_password, client_lastconnected, client_totalconnections) values (0, "serveradmin", "serveradmin", "serveradmin", "wedontwantanyoneloginshere", 0, 0); +insert into group_server_to_client (group_id, server_id, id1, id2) values (2, 0, 1, 0); + +/*BEGIN AUTOCODE*/ +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_serverinstance_help_view", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_serverinstance_version_view", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_serverquery_login", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_virtualserver_select", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_client_needed_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, 1, 0, "i_group_auto_update_type", 20, 0, 0); +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_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_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); +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_description", 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_maxclients", 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_maxfamilyclients", 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_needed_talk_power", 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_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_create_with_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_create_with_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_channel_delete_flag_force", 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_delete_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_delete_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_delete_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_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_channel_join_ignore_maxclients", 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_join_ignore_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_join_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_join_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_join_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_modify_codec", 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_codec_latency_factor", 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_codec_quality", 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_description", 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_make_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_channel_modify_make_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_modify_make_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_modify_make_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_modify_maxclients", 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_maxfamilyclients", 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_name", 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_needed_talk_power", 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_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_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_ban_create", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_ban_delete", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_ban_delete_own", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_ban_list", 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_channel_textmessage_send", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_complain_delete", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_complain_delete_own", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_complain_list", 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_create_modify_serverquery_login", 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_custom_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_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_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); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_modify_description", 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_own_description", 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_offline_textmessage_send", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_permissionoverview_own", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_permissionoverview_view", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_remoteaddress_view", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_server_textmessage_send", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_set_flag_talker", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_skip_channelgroup_permissions", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_use_channel_commander", 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_use_reserved_slot", 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_ft_ignore_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_ft_transfer_list", 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_group_is_permanent", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_icon_manage", 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_permission_modify_power_ignore", 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_serverinstance_binding_list", 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_serverinstance_help_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_serverinstance_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_serverinstance_log_add", 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_serverinstance_log_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_serverinstance_modify_querygroup", 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_serverinstance_modify_settings", 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_serverinstance_modify_templates", 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_serverinstance_permission_find", 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_serverinstance_permission_list", 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_serverinstance_stop", 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_serverinstance_textmessage_send", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_serverinstance_version_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_serverinstance_virtualserver_list", 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_serverquery_login", 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_change_machine_id", 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_change_template", 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_channelclient_permission_list", 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_channelgroup_client_list", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_channelgroup_create", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_channelgroup_delete", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_channelgroup_list", 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_channelgroup_permission_list", 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_channel_list", 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_channel_permission_list", 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_channel_search", 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_client_dbinfo", 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_client_dblist", 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_client_dbsearch", 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_client_list", 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_client_permission_list", 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_client_search", 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_connectioninfo_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_virtualserver_create", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_custom_search", 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_delete", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_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_virtualserver_join_ignore_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_virtualserver_log_add", 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_log_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_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_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); +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_channelgroup", 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_servergroup", 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_ft_quotas", 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_ft_settings", 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_hostbanner", 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_hostbutton", 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_hostmessage", 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_icon_id", 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_log_settings", 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_maxclients", 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_min_client_version", 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_name", 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_needed_identity_security_level", 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_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_virtualserver_modify_port", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_modify_priority_speaker_dimm_modificator", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_modify_reserved_slots", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_modify_weblist", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_modify_welcomemessage", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_notify_register", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_notify_unregister", 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_permission_find", 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_permission_reset", 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_select", 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_servergroup_client_list", 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_servergroup_create", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_servergroup_delete", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_servergroup_list", 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_servergroup_permission_list", 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_snapshot_create", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_snapshot_deploy", 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_start", 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_start_any", 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_stop", 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_stop_any", 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_token_add", 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_token_delete", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_token_list", 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_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_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); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_channel_max_depth", -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_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_channel_permission_modify_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_channel_subscribe_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_client_ban_max_bantime", -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_client_ban_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_client_complain_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_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_client_kick_from_server_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_client_max_channel_subscriptions", -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_client_max_clones_uid", 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_client_move_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_client_needed_ban_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_client_needed_complain_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_client_needed_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_client_needed_kick_from_server_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_client_needed_move_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_client_needed_permission_modify_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_client_needed_poke_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_client_needed_private_textmessage_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_client_needed_serverquery_view_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_client_permission_modify_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_client_poke_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_client_private_textmessage_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_client_serverquery_view_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_ft_directory_create_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_ft_file_browse_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_ft_file_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_ft_file_download_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_ft_file_rename_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_ft_file_upload_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_ft_quota_mb_download_per_client", -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_ft_quota_mb_upload_per_client", -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_group_auto_update_max_value", 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_group_auto_update_type", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_group_member_add_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_group_member_remove_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_group_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_group_needed_member_add_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_group_needed_member_remove_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_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, "i_icon_id", 500, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_max_icon_filesize", 8192, 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_child", 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_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_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_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_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); +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_description", 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_maxclients", 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_maxfamilyclients", 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_needed_talk_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_create_with_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_with_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_create_with_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_delete_flag_force", 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_delete_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_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_delete_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_delete_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_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_needed_modify_power_channel_group_inheritance_end", 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_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_channel_join_ignore_maxclients", 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_join_ignore_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_join_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_join_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_join_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_join_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_max_depth", 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_min_depth", 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_codec", 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_codec_latency_factor", 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_codec_quality", 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_description", 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_make_codec_encrypted", 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_make_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_channel_modify_make_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_modify_make_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_modify_make_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_modify_maxclients", 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_maxfamilyclients", 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_name", 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_needed_talk_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_parent", 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_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_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); +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_join_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_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_needed_permission_modify_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_channel_needed_subscribe_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_channel_permission_modify_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_channel_subscribe_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_ban_create", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_ban_delete", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_ban_delete_own", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_ban_list", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_ban_max_bantime", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_ban_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_channel_textmessage_send", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_complain_delete", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_complain_delete_own", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_complain_list", 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_complain_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_create_modify_serverquery_login", 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_custom_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_delete_dbproperties", 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_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_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_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); +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_max_avatar_filesize", 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_max_channel_subscriptions", 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_max_clones_uid", 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_max_idletime", 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_modify_dbproperties", 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_modify_description", 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_modify_own_description", 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_move_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_needed_ban_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_needed_complain_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_needed_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_needed_kick_from_server_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_needed_move_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_needed_permission_modify_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_needed_poke_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_needed_private_textmessage_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_needed_serverquery_view_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_needed_talk_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_needed_whisper_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_offline_textmessage_send", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_permission_modify_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_permissionoverview_own", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_permissionoverview_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_poke_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_private_textmessage_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_remoteaddress_view", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_serverquery_view_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_server_textmessage_send", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_set_flag_talker", 100, 0, 0); +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_skip_channelgroup_permissions", 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_talk_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_use_channel_commander", 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_use_reserved_slot", 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_whisper_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_ft_directory_create_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_ft_file_browse_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_ft_file_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_ft_file_download_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_ft_file_rename_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_ft_file_upload_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_ft_ignore_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_ft_needed_directory_create_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_ft_needed_file_browse_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_ft_needed_file_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_ft_needed_file_download_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_ft_needed_file_rename_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_ft_needed_file_upload_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_ft_quota_mb_download_per_client", 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_ft_quota_mb_upload_per_client", 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_ft_transfer_list", 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_group_auto_update_max_value", 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_group_auto_update_type", 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_group_is_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_group_member_add_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_group_member_remove_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_group_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_group_needed_member_add_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_group_needed_member_remove_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_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, "i_needed_modify_power_group_show_name_in_tree", 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_group_sort_id", 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_icon_id", 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_icon_manage", 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_max_icon_filesize", 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_permission_modify_power", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_permission_modify_power_ignore", 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_serverinstance_binding_list", 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_serverinstance_help_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_serverinstance_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_serverinstance_log_add", 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_serverinstance_log_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_serverinstance_modify_querygroup", 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_serverinstance_modify_settings", 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_serverinstance_modify_templates", 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_serverinstance_permission_find", 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_serverinstance_permission_list", 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_serverinstance_stop", 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_serverinstance_textmessage_send", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_serverinstance_version_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_serverinstance_virtualserver_list", 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_serverquery_login", 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_change_machine_id", 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_change_template", 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_channelclient_permission_list", 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_channelgroup_client_list", 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_channelgroup_create", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_channelgroup_delete", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_channelgroup_list", 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_channelgroup_permission_list", 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_channel_list", 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_channel_permission_list", 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_channel_search", 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_client_dbinfo", 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_client_dblist", 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_client_dbsearch", 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_client_list", 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_client_permission_list", 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_client_search", 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_connectioninfo_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_virtualserver_create", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_custom_search", 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_delete", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_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_virtualserver_join_ignore_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_virtualserver_log_add", 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_log_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_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_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); +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_channelgroup", 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_servergroup", 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_ft_quotas", 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_ft_settings", 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_hostbanner", 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_hostbutton", 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_hostmessage", 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_icon_id", 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_log_settings", 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_maxclients", 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_min_client_version", 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_name", 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_needed_identity_security_level", 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_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_virtualserver_modify_port", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_modify_priority_speaker_dimm_modificator", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_modify_reserved_slots", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_modify_weblist", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_modify_welcomemessage", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_notify_register", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_notify_unregister", 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_permission_find", 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_permission_reset", 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_select", 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_servergroup_client_list", 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_servergroup_create", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_servergroup_delete", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_servergroup_list", 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_servergroup_permission_list", 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_snapshot_create", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_snapshot_deploy", 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_start", 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_start_any", 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_stop", 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_stop_any", 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_token_add", 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_token_delete", 100, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_token_list", 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_token_use", 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_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_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_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); +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_description", 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_maxclients", 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_maxfamilyclients", 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_needed_talk_power", 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_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_create_with_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_create_with_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_channel_delete_flag_force", 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_delete_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_delete_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_delete_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_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_channel_join_ignore_maxclients", 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_join_ignore_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_join_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_join_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_join_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_modify_codec", 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_codec_latency_factor", 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_codec_quality", 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_description", 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_make_codec_encrypted", 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_make_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_channel_modify_make_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_modify_make_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_modify_make_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_modify_maxclients", 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_maxfamilyclients", 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_name", 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_needed_talk_power", 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_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_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_ban_create", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_ban_delete", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_ban_delete_own", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_ban_list", 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_channel_textmessage_send", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_complain_delete", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_complain_delete_own", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_complain_list", 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_create_modify_serverquery_login", 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_custom_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_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_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); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_modify_description", 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_own_description", 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_offline_textmessage_send", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_permissionoverview_own", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_permissionoverview_view", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_remoteaddress_view", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_server_textmessage_send", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_set_flag_talker", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_skip_channelgroup_permissions", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_use_channel_commander", 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_use_reserved_slot", 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_ft_ignore_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_ft_transfer_list", 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_group_is_permanent", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_icon_manage", 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_channelclient_permission_list", 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_channelgroup_client_list", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_channelgroup_create", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_channelgroup_delete", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_channelgroup_list", 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_channelgroup_permission_list", 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_channel_list", 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_channel_permission_list", 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_channel_search", 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_client_dbinfo", 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_client_dblist", 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_client_dbsearch", 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_client_list", 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_client_permission_list", 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_client_search", 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_connectioninfo_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_virtualserver_custom_search", 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_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_virtualserver_join_ignore_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_virtualserver_log_add", 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_log_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_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_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); +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_channelgroup", 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_servergroup", 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_ft_quotas", 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_ft_settings", 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_hostbanner", 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_hostbutton", 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_hostmessage", 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_icon_id", 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_log_settings", 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_maxclients", 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_min_client_version", 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_name", 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_needed_identity_security_level", 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_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_virtualserver_modify_port", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_modify_priority_speaker_dimm_modificator", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_modify_reserved_slots", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_modify_weblist", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_modify_welcomemessage", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_notify_register", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_notify_unregister", 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_permission_find", 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_servergroup_client_list", 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_servergroup_create", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_servergroup_delete", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_servergroup_list", 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_servergroup_permission_list", 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_start", 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_stop", 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_token_add", 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_token_delete", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_token_list", 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_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_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); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_channel_max_depth", 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_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_channel_permission_modify_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_channel_subscribe_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_client_ban_max_bantime", -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_client_ban_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_client_complain_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_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_client_kick_from_server_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_client_max_avatar_filesize", 200000, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_client_max_channel_subscriptions", -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_client_max_clones_uid", 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_client_move_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_client_needed_ban_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_client_needed_complain_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_client_needed_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_client_needed_kick_from_server_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_client_needed_move_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_client_needed_permission_modify_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_client_needed_serverquery_view_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_client_permission_modify_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_client_poke_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_client_private_textmessage_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_client_serverquery_view_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_client_talk_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_ft_directory_create_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_ft_file_browse_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_ft_file_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_ft_file_download_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_ft_file_rename_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_ft_file_upload_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_ft_quota_mb_download_per_client", -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_ft_quota_mb_upload_per_client", -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_group_auto_update_max_value", 45, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_group_auto_update_type", 45, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_group_member_add_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_group_member_remove_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_group_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_group_needed_member_add_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_group_needed_member_remove_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_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, 3, 0, "i_icon_id", 300, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_max_icon_filesize", 8192, 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_child", 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_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_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_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_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); +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_description", 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_maxclients", 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_maxfamilyclients", 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_needed_talk_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_create_with_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_with_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_create_with_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_delete_flag_force", 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_delete_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_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_delete_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_delete_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_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_needed_modify_power_channel_group_inheritance_end", 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_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_channel_join_ignore_maxclients", 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_join_ignore_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_join_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_join_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_join_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_join_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_max_depth", 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_min_depth", 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_codec", 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_codec_latency_factor", 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_codec_quality", 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_description", 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_make_codec_encrypted", 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_make_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_channel_modify_make_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_modify_make_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_modify_make_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_modify_maxclients", 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_maxfamilyclients", 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_name", 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_needed_talk_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_parent", 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_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_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); +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_join_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_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_needed_permission_modify_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_channel_needed_subscribe_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_channel_permission_modify_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_channel_subscribe_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_ban_create", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_ban_delete", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_ban_delete_own", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_ban_list", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_ban_max_bantime", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_ban_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_channel_textmessage_send", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_complain_delete", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_complain_delete_own", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_complain_list", 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_complain_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_create_modify_serverquery_login", 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_custom_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_delete_dbproperties", 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_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_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_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); +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_max_avatar_filesize", 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_max_channel_subscriptions", 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_max_clones_uid", 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_max_idletime", 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_modify_dbproperties", 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_modify_description", 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_modify_own_description", 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_move_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_needed_ban_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_needed_complain_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_needed_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_needed_kick_from_server_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_needed_move_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_needed_permission_modify_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_needed_poke_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_needed_private_textmessage_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_needed_serverquery_view_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_needed_talk_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_needed_whisper_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_offline_textmessage_send", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_permission_modify_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_permissionoverview_own", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_permissionoverview_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_poke_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_private_textmessage_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_remoteaddress_view", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_serverquery_view_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_server_textmessage_send", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_set_flag_talker", 75, 0, 0); +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_skip_channelgroup_permissions", 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_talk_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_use_channel_commander", 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_use_reserved_slot", 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_whisper_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_ft_directory_create_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_ft_file_browse_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_ft_file_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_ft_file_download_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_ft_file_rename_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_ft_file_upload_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_ft_ignore_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_ft_needed_directory_create_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_ft_needed_file_browse_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_ft_needed_file_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_ft_needed_file_download_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_ft_needed_file_rename_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_ft_needed_file_upload_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_ft_quota_mb_download_per_client", 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_ft_quota_mb_upload_per_client", 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_ft_transfer_list", 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_group_auto_update_type", 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_group_is_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_group_member_add_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_group_member_remove_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_group_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_group_needed_member_add_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_group_needed_member_remove_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_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, 3, 0, "i_needed_modify_power_group_show_name_in_tree", 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_group_sort_id", 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_icon_id", 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_icon_manage", 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_max_icon_filesize", 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_permission_modify_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_channelclient_permission_list", 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_channelgroup_client_list", 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_channelgroup_create", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_channelgroup_delete", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_channelgroup_list", 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_channelgroup_permission_list", 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_channel_list", 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_channel_permission_list", 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_channel_search", 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_client_dbinfo", 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_client_dblist", 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_client_dbsearch", 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_client_list", 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_client_permission_list", 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_client_search", 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_connectioninfo_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_virtualserver_custom_search", 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_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_virtualserver_join_ignore_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_virtualserver_log_add", 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_log_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_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_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); +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_channelgroup", 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_servergroup", 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_ft_quotas", 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_ft_settings", 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_hostbanner", 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_hostbutton", 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_hostmessage", 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_icon_id", 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_log_settings", 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_maxclients", 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_min_client_version", 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_name", 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_needed_identity_security_level", 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_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_virtualserver_modify_port", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_modify_priority_speaker_dimm_modificator", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_modify_reserved_slots", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_modify_weblist", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_modify_welcomemessage", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_notify_register", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_notify_unregister", 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_permission_find", 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_servergroup_client_list", 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_servergroup_create", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_servergroup_delete", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_servergroup_list", 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_servergroup_permission_list", 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_start", 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_stop", 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_token_add", 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_token_delete", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_token_list", 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_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_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_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); +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_maxclients", 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_maxfamilyclients", 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_needed_talk_power", 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_password", 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_topic", 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_info_view", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_channel_join_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_join_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_join_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_client_channel_textmessage_send", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 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, 4, 0, "b_client_offline_textmessage_send", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_client_permissionoverview_own", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_client_permissionoverview_view", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_group_is_permanent", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_virtualserver_channelgroup_client_list", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_virtualserver_channelgroup_list", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_virtualserver_channel_list", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_virtualserver_client_list", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_virtualserver_connectioninfo_view", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_virtualserver_info_view", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_virtualserver_servergroup_client_list", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_virtualserver_servergroup_list", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_virtualserver_token_use", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 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, 4, 0, "i_channel_create_modify_with_codec_maxquality", 7, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_channel_description_view_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_channel_join_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_channel_max_depth", 5, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_channel_modify_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_channel_subscribe_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_client_complain_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_client_max_avatar_filesize", 200000, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_client_max_channel_subscriptions", -1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_client_max_clones_uid", 2, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_client_needed_ban_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_client_needed_complain_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_client_needed_kick_from_channel_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_client_needed_kick_from_server_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_client_needed_move_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_client_needed_serverquery_view_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_client_poke_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_client_private_textmessage_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_ft_directory_create_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_ft_file_browse_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_ft_file_delete_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_ft_file_download_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_ft_file_rename_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_ft_file_upload_power", 50, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_ft_quota_mb_download_per_client", -1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_ft_quota_mb_upload_per_client", -1, 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_auto_update_type", 30, 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_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_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); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "b_channel_create_with_maxclients", 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_with_needed_talk_power", 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_with_password", 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_with_topic", 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_info_view", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "b_channel_join_permanent", 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_join_semi_permanent", 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_join_temporary", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "b_client_channel_textmessage_send", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "b_client_info_view", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "b_virtualserver_token_use", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_channel_create_modify_with_codec_latency_factor_min", 1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_channel_create_modify_with_codec_maxquality", 7, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_channel_max_depth", 0, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_client_max_avatar_filesize", 200000, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_client_max_channel_subscriptions", -1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_client_max_clones_uid", 0, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_client_needed_ban_power", 25, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_client_needed_kick_from_channel_power", 25, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_client_needed_kick_from_server_power", 25, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_client_needed_move_power", 25, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_client_needed_serverquery_view_power", 75, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_ft_file_browse_power", 25, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_ft_file_download_power", 25, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_ft_quota_mb_download_per_client", -1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_ft_quota_mb_upload_per_client", -1, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_group_auto_update_type", 15, 0, 0); +insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "i_group_needed_modify_power", 75, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_delete_flag_force", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_delete_semi_permanent", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_delete_temporary", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_modify_codec", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_modify_codec_latency_factor", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_modify_codec_quality", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_modify_description", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_modify_make_codec_encrypted", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_modify_make_temporary", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_modify_maxclients", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_modify_maxfamilyclients", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_modify_name", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_modify_needed_talk_power", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_modify_password", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_channel_modify_topic", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_client_set_flag_talker", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_client_use_channel_commander", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "b_group_is_permanent", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_channel_create_modify_with_codec_latency_factor_min", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_channel_delete_power", 50, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_channel_description_view_power", 50, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_client_kick_from_channel_power", 50, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_client_move_power", 50, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_client_needed_complain_power", 25, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_client_needed_kick_from_channel_power", 50, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_client_talk_power", 60, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_group_auto_update_type", 40, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_group_member_add_power", 50, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_group_member_remove_power", 50, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_group_needed_member_add_power", 50, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_group_needed_member_remove_power", 50, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_group_needed_modify_power", 75, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 1, 0, "i_icon_id", 100, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 2, 0, "b_client_set_flag_talker", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 2, 0, "b_group_is_permanent", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 2, 0, "i_client_needed_complain_power", 25, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 2, 0, "i_client_talk_power", 50, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 2, 0, "i_group_auto_update_type", 35, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 2, 0, "i_group_member_add_power", 30, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 2, 0, "i_group_member_remove_power", 30, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 2, 0, "i_group_needed_member_add_power", 30, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 2, 0, "i_group_needed_member_remove_power", 30, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 2, 0, "i_group_needed_modify_power", 75, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 2, 0, "i_icon_id", 200, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_group_is_permanent", 1, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_client_talk_power", 25, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_group_auto_update_type", 25, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_group_needed_member_add_power", 25, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_group_needed_member_remove_power", 25, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_group_needed_modify_power", 75, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_icon_id", 600, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_group_auto_update_type", 10, 0, 0); +insert into perm_channel_groups (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "i_group_needed_modify_power", 75, 0, 0); +/*END AUTOCODE*/ diff --git a/sql/group_delete.sql b/sql/group_delete.sql new file mode 100644 index 0000000..fa1444f --- /dev/null +++ b/sql/group_delete.sql @@ -0,0 +1,3 @@ +delete from :tablegroup: where group_id = :group_id:; +delete from :tableperms: where id1 = :group_id:; +delete from :tablemembers: where group_id = :group_id:; \ No newline at end of file diff --git a/sql/group_id_get_by_name.sql b/sql/group_id_get_by_name.sql new file mode 100644 index 0000000..266404c --- /dev/null +++ b/sql/group_id_get_by_name.sql @@ -0,0 +1 @@ +select * from :table: where server_id = :server_id: and name = :name: \ No newline at end of file diff --git a/sql/group_insert.sql b/sql/group_insert.sql new file mode 100644 index 0000000..0989111 --- /dev/null +++ b/sql/group_insert.sql @@ -0,0 +1 @@ +insert into :table: (server_id, name, type) values (:server_id:, :name:, :type:) diff --git a/sql/group_member_delete.sql b/sql/group_member_delete.sql new file mode 100644 index 0000000..cc2ce60 --- /dev/null +++ b/sql/group_member_delete.sql @@ -0,0 +1 @@ +delete from :table: where server_id = :server_id: and id1 = :id1: and id2 = :id2: and group_id = :group_id: \ No newline at end of file diff --git a/sql/group_member_delete_by_groupid.sql b/sql/group_member_delete_by_groupid.sql new file mode 100644 index 0000000..186ae93 --- /dev/null +++ b/sql/group_member_delete_by_groupid.sql @@ -0,0 +1 @@ +delete from :table: where server_id = :server_id: and group_id = :group_id: \ No newline at end of file diff --git a/sql/group_member_detail_get_by_groupid.sql b/sql/group_member_detail_get_by_groupid.sql new file mode 100644 index 0000000..dd58577 --- /dev/null +++ b/sql/group_member_detail_get_by_groupid.sql @@ -0,0 +1 @@ +select client_id, client_nickname, client_unique_id from :table:, clients where group_id = :group_id: and id1=client_id; \ No newline at end of file diff --git a/sql/group_member_get.sql b/sql/group_member_get.sql new file mode 100644 index 0000000..c2fb9fc --- /dev/null +++ b/sql/group_member_get.sql @@ -0,0 +1 @@ +select * from :table: where server_id = :server_id: and id1 = :id1: and id2 = :id2: and group_id = :group_id:; \ No newline at end of file diff --git a/sql/group_member_insert.sql b/sql/group_member_insert.sql new file mode 100644 index 0000000..200425d --- /dev/null +++ b/sql/group_member_insert.sql @@ -0,0 +1 @@ +insert into :table: (group_id, server_id, id1, id2) values (:group_id:, :server_id:, :id1:, :id2:); \ No newline at end of file diff --git a/sql/group_members_get_by_groupid.sql b/sql/group_members_get_by_groupid.sql new file mode 100644 index 0000000..c47a935 --- /dev/null +++ b/sql/group_members_get_by_groupid.sql @@ -0,0 +1 @@ +select * from :table: where group_id = :group_id: \ No newline at end of file diff --git a/sql/group_members_get_by_id.sql b/sql/group_members_get_by_id.sql new file mode 100644 index 0000000..de7e222 --- /dev/null +++ b/sql/group_members_get_by_id.sql @@ -0,0 +1 @@ +select * from :table: where server_id = :server_id: and :id_name: = :id: \ No newline at end of file diff --git a/sql/group_members_get_by_serverid.sql b/sql/group_members_get_by_serverid.sql new file mode 100644 index 0000000..688df73 --- /dev/null +++ b/sql/group_members_get_by_serverid.sql @@ -0,0 +1 @@ +select * from :table: where server_id = :server_id: \ No newline at end of file diff --git a/sql/group_rename.sql b/sql/group_rename.sql new file mode 100644 index 0000000..89f7787 --- /dev/null +++ b/sql/group_rename.sql @@ -0,0 +1 @@ +update :table: set name=:name: where group_id=:group_id: diff --git a/sql/groups_get.sql b/sql/groups_get.sql new file mode 100644 index 0000000..4417537 --- /dev/null +++ b/sql/groups_get.sql @@ -0,0 +1 @@ +select * from :table: \ No newline at end of file diff --git a/sql/groups_get_by_serverid.sql b/sql/groups_get_by_serverid.sql new file mode 100644 index 0000000..688df73 --- /dev/null +++ b/sql/groups_get_by_serverid.sql @@ -0,0 +1 @@ +select * from :table: where server_id = :server_id: \ No newline at end of file diff --git a/sql/groups_get_by_serverid_type.sql b/sql/groups_get_by_serverid_type.sql new file mode 100644 index 0000000..eec333e --- /dev/null +++ b/sql/groups_get_by_serverid_type.sql @@ -0,0 +1 @@ +select * from :table: where server_id = :server_id: and type = :type: \ No newline at end of file diff --git a/sql/info_delete.sql b/sql/info_delete.sql new file mode 100644 index 0000000..fff90ff --- /dev/null +++ b/sql/info_delete.sql @@ -0,0 +1 @@ +delete from info where ident = :ident:; \ No newline at end of file diff --git a/sql/info_get_by_ident.sql b/sql/info_get_by_ident.sql new file mode 100644 index 0000000..33f6349 --- /dev/null +++ b/sql/info_get_by_ident.sql @@ -0,0 +1 @@ +select * from info where ident = :ident:; \ No newline at end of file diff --git a/sql/info_insert.sql b/sql/info_insert.sql new file mode 100644 index 0000000..2cf7c51 --- /dev/null +++ b/sql/info_insert.sql @@ -0,0 +1 @@ +insert into info (ident, value) values (:ident:, :value:); \ No newline at end of file diff --git a/sql/message_delete.sql b/sql/message_delete.sql new file mode 100644 index 0000000..2b3a89c --- /dev/null +++ b/sql/message_delete.sql @@ -0,0 +1 @@ +delete from messages where message_id = :message_id: and server_id = :server_id: and message_to_client_id= :message_to_client_id:; diff --git a/sql/message_get_by_clientid.sql b/sql/message_get_by_clientid.sql new file mode 100644 index 0000000..ee0b70c --- /dev/null +++ b/sql/message_get_by_clientid.sql @@ -0,0 +1 @@ +select * from messages where message_id = :message_id: and server_id = :server_id: and message_to_client_id= :message_to_client_id:; diff --git a/sql/message_get_unread_by_clientid.sql b/sql/message_get_unread_by_clientid.sql new file mode 100644 index 0000000..e084dd8 --- /dev/null +++ b/sql/message_get_unread_by_clientid.sql @@ -0,0 +1 @@ +select count(*) as unread from messages where message_to_client_id= :message_to_client_id: and message_flag_read= 0; diff --git a/sql/message_insert.sql b/sql/message_insert.sql new file mode 100644 index 0000000..69f7ef2 --- /dev/null +++ b/sql/message_insert.sql @@ -0,0 +1 @@ +insert into messages (server_id, message_from_client_id, message_from_client_uid, message_to_client_id, message_subject, message_msg, message_timestamp) values (:server_id:, :message_from_client_id:, :message_from_client_uid:, :message_to_client_id:, :message_subject:, :message_msg:, :message_timestamp:) \ No newline at end of file diff --git a/sql/message_list_by_clientid.sql b/sql/message_list_by_clientid.sql new file mode 100644 index 0000000..b34f92e --- /dev/null +++ b/sql/message_list_by_clientid.sql @@ -0,0 +1 @@ +select * from messages where server_id = :server_id: and message_to_client_id= :message_to_client_id:; diff --git a/sql/message_update_flag.sql b/sql/message_update_flag.sql new file mode 100644 index 0000000..f7a3fc1 --- /dev/null +++ b/sql/message_update_flag.sql @@ -0,0 +1 @@ +update messages set message_flag_read=:message_flag_read: where message_id=:message_id: and server_id=:server_id: and message_to_client_id=:message_to_client_id: \ No newline at end of file diff --git a/sql/perm_delete_by_groupid.sql b/sql/perm_delete_by_groupid.sql new file mode 100644 index 0000000..89784e4 --- /dev/null +++ b/sql/perm_delete_by_groupid.sql @@ -0,0 +1 @@ +delete from :table: where server_id = :server_id: and id1 = :id1: \ No newline at end of file diff --git a/sql/perm_delete_by_permid.sql b/sql/perm_delete_by_permid.sql new file mode 100644 index 0000000..108ed3f --- /dev/null +++ b/sql/perm_delete_by_permid.sql @@ -0,0 +1 @@ +delete from :table: where server_id = :server_id: and id1 = :id1: and id2 = :id2: and perm_id = :perm_id: \ No newline at end of file diff --git a/sql/perm_delete_by_serverid.sql b/sql/perm_delete_by_serverid.sql new file mode 100644 index 0000000..49ffaed --- /dev/null +++ b/sql/perm_delete_by_serverid.sql @@ -0,0 +1,13 @@ +delete from perm_channel where server_id = :server_id:; +delete from perm_channel_clients where server_id = :server_id:; +delete from perm_channel_groups where server_id = :server_id:; +delete from perm_client where server_id = :server_id:; +delete from perm_server_group where server_id = :server_id:; +delete from group_channel_to_client where server_id = :server_id:; +delete from group_server_to_client where server_id = :server_id:; +delete from groups_channel where server_id = :server_id:; +delete from groups_server where server_id = :server_id:; +delete from tokens where server_id = :server_id:; +update client_properties set value = 0 where ident= "client_icon_id" and server_id= :server_id:; +update channel_properties set value = 0 where ident= "channel_icon_id" and server_id= :server_id:; +update server_properties set value = 0 where ident= "virtualserver_icon_id" and server_id= :server_id:; \ No newline at end of file diff --git a/sql/perm_get_by_id.sql b/sql/perm_get_by_id.sql new file mode 100644 index 0000000..09e5b2c --- /dev/null +++ b/sql/perm_get_by_id.sql @@ -0,0 +1 @@ +select * from :table: where id1 = :id1: \ No newline at end of file diff --git a/sql/perm_get_by_serverid.sql b/sql/perm_get_by_serverid.sql new file mode 100644 index 0000000..f6439f9 --- /dev/null +++ b/sql/perm_get_by_serverid.sql @@ -0,0 +1 @@ +select * from :table: where server_id = :server_id:; \ No newline at end of file diff --git a/sql/perm_insert.sql b/sql/perm_insert.sql new file mode 100644 index 0000000..b039846 --- /dev/null +++ b/sql/perm_insert.sql @@ -0,0 +1 @@ +insert into :table: (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (:server_id:, :id1:, :id2:, :perm_id:, :perm_value:, :perm_negated:, :perm_skip:) \ No newline at end of file diff --git a/sql/perm_rename.sql b/sql/perm_rename.sql new file mode 100644 index 0000000..6d0010a --- /dev/null +++ b/sql/perm_rename.sql @@ -0,0 +1,5 @@ +update perm_channel set perm_id = :new_perm_name: where perm_id = :old_perm_name:; +update perm_channel_clients set perm_id = :new_perm_name: where perm_id = :old_perm_name:; +update perm_channel_groups set perm_id = :new_perm_name: where perm_id = :old_perm_name:; +update perm_client set perm_id = :new_perm_name: where perm_id = :old_perm_name:; +update perm_server_group set perm_id = :new_perm_name: where perm_id = :old_perm_name:; \ No newline at end of file diff --git a/sql/perm_update_get_groups.sql b/sql/perm_update_get_groups.sql new file mode 100644 index 0000000..e3c96a8 --- /dev/null +++ b/sql/perm_update_get_groups.sql @@ -0,0 +1 @@ +select * from :table: where perm_id = "i_group_auto_update_type" and perm_value = :permvalue: \ No newline at end of file diff --git a/sql/properties_delete_by_id.sql b/sql/properties_delete_by_id.sql new file mode 100644 index 0000000..8da6f19 --- /dev/null +++ b/sql/properties_delete_by_id.sql @@ -0,0 +1 @@ +delete from :tablename: where id = :id: ; \ No newline at end of file diff --git a/sql/properties_delete_by_string_id.sql b/sql/properties_delete_by_string_id.sql new file mode 100644 index 0000000..dc797cc --- /dev/null +++ b/sql/properties_delete_by_string_id.sql @@ -0,0 +1 @@ +delete from :tablename: where string_id = :string_id: ; \ No newline at end of file diff --git a/sql/properties_insert_by_id.sql b/sql/properties_insert_by_id.sql new file mode 100644 index 0000000..8218986 --- /dev/null +++ b/sql/properties_insert_by_id.sql @@ -0,0 +1 @@ +insert into :tablename: ( server_id, id, ident, value) values (:server_id:, :id:, :ident:, :value:); \ No newline at end of file diff --git a/sql/properties_insert_by_string_id.sql b/sql/properties_insert_by_string_id.sql new file mode 100644 index 0000000..71ca5d5 --- /dev/null +++ b/sql/properties_insert_by_string_id.sql @@ -0,0 +1 @@ +insert into :tablename: ( server_id, id, ident, value, string_id) values (:server_id:, 0, :ident:, :value:, :string_id:); \ No newline at end of file diff --git a/sql/properties_list_by_id.sql b/sql/properties_list_by_id.sql new file mode 100644 index 0000000..6e5019e --- /dev/null +++ b/sql/properties_list_by_id.sql @@ -0,0 +1 @@ +select * from :tablename: where id = :id:; \ No newline at end of file diff --git a/sql/properties_list_by_string_id.sql b/sql/properties_list_by_string_id.sql new file mode 100644 index 0000000..c75e461 --- /dev/null +++ b/sql/properties_list_by_string_id.sql @@ -0,0 +1 @@ +select * from :tablename: where string_id = :string_id:; \ No newline at end of file diff --git a/sql/server_clear_traffic_stats.sql b/sql/server_clear_traffic_stats.sql new file mode 100644 index 0000000..a7aa6c8 --- /dev/null +++ b/sql/server_clear_traffic_stats.sql @@ -0,0 +1 @@ +update servers set server_month_upload= 0, server_month_download= 0 where server_machine_id=:machine_id: \ No newline at end of file diff --git a/sql/server_delete.sql b/sql/server_delete.sql new file mode 100644 index 0000000..e794721 --- /dev/null +++ b/sql/server_delete.sql @@ -0,0 +1,21 @@ +delete from group_server_to_client where id1 in (select client_id from clients where server_id = :server_id:); +delete from servers where server_id = :server_id:; +delete from server_properties where id = :server_id:; +delete from perm_channel where server_id = :server_id:; +delete from perm_channel_clients where server_id = :server_id:; +delete from perm_channel_groups where server_id = :server_id:; +delete from perm_client where server_id = :server_id:; +delete from perm_server_group where server_id = :server_id:; +delete from group_channel_to_client where server_id = :server_id:; +delete from group_server_to_client where server_id = :server_id:; +delete from groups_channel where server_id = :server_id:; +delete from groups_server where server_id = :server_id:; +delete from messages where server_id = :server_id:; +delete from complains where server_id = :server_id:; +delete from clients where server_id = :server_id:; +delete from client_properties where server_id = :server_id:; +delete from channels where server_id = :server_id:; +delete from channel_properties where server_id = :server_id:; +delete from bans where server_id = :server_id:; +delete from tokens where server_id = :server_id:; +delete from custom_fields where server_id = :server_id:; \ No newline at end of file diff --git a/sql/server_delete_get_qa_clients.sql b/sql/server_delete_get_qa_clients.sql new file mode 100644 index 0000000..bc7b983 --- /dev/null +++ b/sql/server_delete_get_qa_clients.sql @@ -0,0 +1 @@ +SELECT clients.client_id FROM group_server_to_client, clients WHERE group_server_to_client.id1 = clients.client_id and clients.server_id=:server_id: and group_server_to_client.server_id=0; \ No newline at end of file diff --git a/sql/server_get_byid.sql b/sql/server_get_byid.sql new file mode 100644 index 0000000..fb73d51 --- /dev/null +++ b/sql/server_get_byid.sql @@ -0,0 +1 @@ +select * from servers where server_id = :server_id:; \ No newline at end of file diff --git a/sql/server_get_byport.sql b/sql/server_get_byport.sql new file mode 100644 index 0000000..68068ba --- /dev/null +++ b/sql/server_get_byport.sql @@ -0,0 +1 @@ +select * from servers where server_port = :server_port:; \ No newline at end of file diff --git a/sql/server_insert.sql b/sql/server_insert.sql new file mode 100644 index 0000000..f63da57 --- /dev/null +++ b/sql/server_insert.sql @@ -0,0 +1,4 @@ +INSERT INTO servers +( server_autostart, server_port, server_machine_id) +VALUES +( :server_autostart:, :server_port:, :server_machine_id:); diff --git a/sql/server_list.sql b/sql/server_list.sql new file mode 100644 index 0000000..ae73811 --- /dev/null +++ b/sql/server_list.sql @@ -0,0 +1 @@ +select * from servers; \ No newline at end of file diff --git a/sql/server_list_by_machine_id.sql b/sql/server_list_by_machine_id.sql new file mode 100644 index 0000000..3a5a547 --- /dev/null +++ b/sql/server_list_by_machine_id.sql @@ -0,0 +1 @@ +select * from servers where server_machine_id= :server_machine_id:; \ No newline at end of file diff --git a/sql/server_snapshot_delete.sql b/sql/server_snapshot_delete.sql new file mode 100644 index 0000000..ff9e85c --- /dev/null +++ b/sql/server_snapshot_delete.sql @@ -0,0 +1,18 @@ +delete from server_properties where id = :server_id:; +delete from perm_channel where server_id = :server_id:; +delete from perm_channel_clients where server_id = :server_id:; +delete from perm_channel_groups where server_id = :server_id:; +delete from perm_client where server_id = :server_id:; +delete from perm_server_group where server_id = :server_id:; +delete from group_channel_to_client where server_id = :server_id:; +delete from group_server_to_client where server_id = :server_id:; +delete from groups_channel where server_id = :server_id:; +delete from groups_server where server_id = :server_id:; +delete from messages where server_id = :server_id:; +delete from clients where server_id = :server_id:; +delete from client_properties where server_id = :server_id:; +delete from channels where server_id = :server_id:; +delete from channel_properties where server_id = :server_id:; +delete from tokens where server_id = :server_id:; +delete from complains where server_id = :server_id:; +delete from custom_fields where server_id = :server_id:; \ No newline at end of file diff --git a/sql/server_snapshot_delete_failed.sql b/sql/server_snapshot_delete_failed.sql new file mode 100644 index 0000000..0c6c6f1 --- /dev/null +++ b/sql/server_snapshot_delete_failed.sql @@ -0,0 +1,19 @@ +delete from servers where server_id = :server_id:; +delete from server_properties where id = :server_id:; +delete from perm_channel where server_id = :server_id:; +delete from perm_channel_clients where server_id = :server_id:; +delete from perm_channel_groups where server_id = :server_id:; +delete from perm_client where server_id = :server_id:; +delete from perm_server_group where server_id = :server_id:; +delete from group_channel_to_client where server_id = :server_id:; +delete from group_server_to_client where server_id = :server_id:; +delete from groups_channel where server_id = :server_id:; +delete from groups_server where server_id = :server_id:; +delete from messages where server_id = :server_id:; +delete from clients where server_id = :server_id:; +delete from client_properties where server_id = :server_id:; +delete from channels where server_id = :server_id:; +delete from channel_properties where server_id = :server_id:; +delete from tokens where server_id = :server_id:; +delete from complains where server_id = :server_id:; +delete from custom_fields where server_id = :server_id:; \ No newline at end of file diff --git a/sql/server_update_autostart.sql b/sql/server_update_autostart.sql new file mode 100644 index 0000000..b9ce89b --- /dev/null +++ b/sql/server_update_autostart.sql @@ -0,0 +1 @@ +update servers set server_autostart= :server_autostart: where server_id=:server_id:; diff --git a/sql/server_update_machine_id.sql b/sql/server_update_machine_id.sql new file mode 100644 index 0000000..fc2e5f8 --- /dev/null +++ b/sql/server_update_machine_id.sql @@ -0,0 +1 @@ +update servers set server_machine_id= :server_machine_id: where server_id=:server_id:; diff --git a/sql/server_update_port.sql b/sql/server_update_port.sql new file mode 100644 index 0000000..f4ee4a5 --- /dev/null +++ b/sql/server_update_port.sql @@ -0,0 +1 @@ +update servers set server_port= :server_port: where server_id=:server_id:; diff --git a/sql/server_update_traffic_stats.sql b/sql/server_update_traffic_stats.sql new file mode 100644 index 0000000..ef6994a --- /dev/null +++ b/sql/server_update_traffic_stats.sql @@ -0,0 +1,6 @@ +update servers set + server_month_upload= server_month_upload + :upload:, + server_month_download= server_month_download + :download:, + server_total_upload= server_total_upload + :upload:, + server_total_download= server_total_download + :download: + where server_id=:server_id:; \ No newline at end of file diff --git a/sql/token_delete_by_key.sql b/sql/token_delete_by_key.sql new file mode 100644 index 0000000..66301e7 --- /dev/null +++ b/sql/token_delete_by_key.sql @@ -0,0 +1 @@ +delete from tokens where server_id=:server_id: and token_key=:token_key: \ No newline at end of file diff --git a/sql/token_get_by_key.sql b/sql/token_get_by_key.sql new file mode 100644 index 0000000..1ab66ff --- /dev/null +++ b/sql/token_get_by_key.sql @@ -0,0 +1 @@ +select * from tokens where server_id=:server_id: and token_key=:token_key: \ No newline at end of file diff --git a/sql/token_insert.sql b/sql/token_insert.sql new file mode 100644 index 0000000..8afab21 --- /dev/null +++ b/sql/token_insert.sql @@ -0,0 +1,18 @@ +insert into tokens +( server_id, + token_key, + token_type, + token_id1, + token_id2, + token_created, + token_description, + token_customset) +VALUES +( :server_id:, + :token_key:, + :token_type:, + :token_id1:, + :token_id2:, + :token_created:, + :token_description:, + :token_customset:); diff --git a/sql/token_list.sql b/sql/token_list.sql new file mode 100644 index 0000000..ec64b66 --- /dev/null +++ b/sql/token_list.sql @@ -0,0 +1 @@ +select * from tokens where server_id=:server_id: \ No newline at end of file diff --git a/sql/update_12.sql b/sql/update_12.sql new file mode 100644 index 0000000..17e553e --- /dev/null +++ b/sql/update_12.sql @@ -0,0 +1,13 @@ +CREATE TABLE custom_fields ( + server_id integer unsigned, + client_id integer unsigned, + ident varchar(100) NOT NULL, + value varchar(255) +); +CREATE INDEX index_custom_fields_serverid ON custom_fields (server_id); +CREATE INDEX index_custom_fields_client_id ON custom_fields (client_id); +CREATE INDEX index_custom_fields_ident ON custom_fields (ident); + +ALTER TABLE tokens ADD COLUMN token_created integer unsigned; +ALTER TABLE tokens ADD COLUMN token_description varchar(255); +ALTER TABLE tokens ADD COLUMN token_customset varchar(255); diff --git a/sql/update_13.sql b/sql/update_13.sql new file mode 100644 index 0000000..5d0767d --- /dev/null +++ b/sql/update_13.sql @@ -0,0 +1,34 @@ +update perm_channel set perm_id = "i_icon_id" where perm_id = "i_group_icon_id"; +update perm_channel set perm_id = "i_needed_modify_power_icon_id" where perm_id = "i_needed_modify_power_group_icon_id"; +update perm_channel set perm_id = "i_max_icon_filesize" where perm_id = "i_group_max_icon_filesize"; +update perm_channel set perm_id = "i_needed_modify_power_max_icon_filesize" where perm_id = "i_needed_modify_power_group_max_icon_filesize"; +update perm_channel set perm_id = "b_icon_manage" where perm_id = "b_group_icon_manage"; +update perm_channel set perm_id = "i_needed_modify_power_icon_manage" where perm_id = "i_needed_modify_power_group_icon_manage"; + +update perm_channel_clients set perm_id = "i_icon_id" where perm_id = "i_group_icon_id"; +update perm_channel_clients set perm_id = "i_needed_modify_power_icon_id" where perm_id = "i_needed_modify_power_group_icon_id"; +update perm_channel_clients set perm_id = "i_max_icon_filesize" where perm_id = "i_group_max_icon_filesize"; +update perm_channel_clients set perm_id = "i_needed_modify_power_max_icon_filesize" where perm_id = "i_needed_modify_power_group_max_icon_filesize"; +update perm_channel_clients set perm_id = "b_icon_manage" where perm_id = "b_group_icon_manage"; +update perm_channel_clients set perm_id = "i_needed_modify_power_icon_manage" where perm_id = "i_needed_modify_power_group_icon_manage"; + +update perm_channel_groups set perm_id = "i_icon_id" where perm_id = "i_group_icon_id"; +update perm_channel_groups set perm_id = "i_needed_modify_power_icon_id" where perm_id = "i_needed_modify_power_group_icon_id"; +update perm_channel_groups set perm_id = "i_max_icon_filesize" where perm_id = "i_group_max_icon_filesize"; +update perm_channel_groups set perm_id = "i_needed_modify_power_max_icon_filesize" where perm_id = "i_needed_modify_power_group_max_icon_filesize"; +update perm_channel_groups set perm_id = "b_icon_manage" where perm_id = "b_group_icon_manage"; +update perm_channel_groups set perm_id = "i_needed_modify_power_icon_manage" where perm_id = "i_needed_modify_power_group_icon_manage"; + +update perm_client set perm_id = "i_icon_id" where perm_id = "i_group_icon_id"; +update perm_client set perm_id = "i_needed_modify_power_icon_id" where perm_id = "i_needed_modify_power_group_icon_id"; +update perm_client set perm_id = "i_max_icon_filesize" where perm_id = "i_group_max_icon_filesize"; +update perm_client set perm_id = "i_needed_modify_power_max_icon_filesize" where perm_id = "i_needed_modify_power_group_max_icon_filesize"; +update perm_client set perm_id = "b_icon_manage" where perm_id = "b_group_icon_manage"; +update perm_client set perm_id = "i_needed_modify_power_icon_manage" where perm_id = "i_needed_modify_power_group_icon_manage"; + +update perm_server_group set perm_id = "i_icon_id" where perm_id = "i_group_icon_id"; +update perm_server_group set perm_id = "i_needed_modify_power_icon_id" where perm_id = "i_needed_modify_power_group_icon_id"; +update perm_server_group set perm_id = "i_max_icon_filesize" where perm_id = "i_group_max_icon_filesize"; +update perm_server_group set perm_id = "i_needed_modify_power_max_icon_filesize" where perm_id = "i_needed_modify_power_group_max_icon_filesize"; +update perm_server_group set perm_id = "b_icon_manage" where perm_id = "b_group_icon_manage"; +update perm_server_group set perm_id = "i_needed_modify_power_icon_manage" where perm_id = "i_needed_modify_power_group_icon_manage"; diff --git a/sql/update_14.sql b/sql/update_14.sql new file mode 100644 index 0000000..67a6159 --- /dev/null +++ b/sql/update_14.sql @@ -0,0 +1,5 @@ +CREATE INDEX index_group_server_to_client_id1 ON group_server_to_client (id1); +CREATE INDEX index_group_channel_to_client_id1 ON group_channel_to_client (id1); +CREATE INDEX index_group_channel_to_client_id2 ON group_channel_to_client (id2); +CREATE INDEX index_clients_lastconnectedserverid ON clients (client_lastconnected, server_id); +CREATE INDEX index_log_serverid_logid ON log (server_id, log_id); diff --git a/sql/update_15.sql b/sql/update_15.sql new file mode 100644 index 0000000..06e37b2 --- /dev/null +++ b/sql/update_15.sql @@ -0,0 +1 @@ +CREATE INDEX index_clients_uid ON clients (client_unique_id, server_id); diff --git a/sql/update_16.sql b/sql/update_16.sql new file mode 100644 index 0000000..0ffe4f7 --- /dev/null +++ b/sql/update_16.sql @@ -0,0 +1,3 @@ +ALTER TABLE instance_properties ADD COLUMN string_id varchar(255); +CREATE INDEX index_instance_properties_string_id ON instance_properties (string_id); +update instance_properties set string_id = "" \ No newline at end of file diff --git a/sql/update_17.sql b/sql/update_17.sql new file mode 100644 index 0000000..768aaef --- /dev/null +++ b/sql/update_17.sql @@ -0,0 +1,2 @@ +CREATE INDEX index_servers_port ON servers (server_port); +CREATE INDEX index_messages_msgidtoclid_read ON messages (message_to_client_id, message_flag_read); diff --git a/sql/update_18.sql b/sql/update_18.sql new file mode 100644 index 0000000..efea9f1 --- /dev/null +++ b/sql/update_18.sql @@ -0,0 +1 @@ +ALTER TABLE clients ADD COLUMN client_lastip varchar(20); \ No newline at end of file diff --git a/sql/update_19.sql b/sql/update_19.sql new file mode 100644 index 0000000..822cae1 --- /dev/null +++ b/sql/update_19.sql @@ -0,0 +1 @@ +DROP TABLE IF EXISTS log; diff --git a/sql/update_database_version.sql b/sql/update_database_version.sql new file mode 100644 index 0000000..697b819 --- /dev/null +++ b/sql/update_database_version.sql @@ -0,0 +1 @@ +update instance_properties set value = :value: where ident="serverinstance_database_version"; \ No newline at end of file diff --git a/sql/update_permissions_12.sql b/sql/update_permissions_12.sql new file mode 100644 index 0000000..9ddea98 --- /dev/null +++ b/sql/update_permissions_12.sql @@ -0,0 +1,9 @@ +update perm_server_group set perm_value = 20 where perm_id = 'i_group_auto_update_type' and perm_value = 0; +update perm_server_group set perm_value = 50 where perm_id = 'i_group_auto_update_type' and perm_value = 1; +update perm_server_group set perm_value = 45 where perm_id = 'i_group_auto_update_type' and perm_value = 2; +update perm_server_group set perm_value = 30 where perm_id = 'i_group_auto_update_type' and perm_value = 3; +update perm_server_group set perm_value = 15 where perm_id = 'i_group_auto_update_type' and perm_value = 4; +update perm_channel_groups set perm_value = 40 where perm_id = 'i_group_auto_update_type' and perm_value = 5; +update perm_channel_groups set perm_value = 35 where perm_id = 'i_group_auto_update_type' and perm_value = 6; +update perm_channel_groups set perm_value = 25 where perm_id = 'i_group_auto_update_type' and perm_value = 7; +update perm_channel_groups set perm_value = 10 where perm_id = 'i_group_auto_update_type' and perm_value = 8; \ No newline at end of file -- cgit v1.2.3