sql: update to version 19 (ts3-v3.0.5)

5 files changed, 29 insertions, 13 deletions

diff --git a/sql/client_clear_traffic_stats.sql b/sql/client_clear_traffic_stats.sql
index f73e731..4989276 100644
--- a/sql/client_clear_traffic_stats.sql
+++ b/sql/client_clear_traffic_stats.sql
@@ -1 +1 @@
-update clients set client_month_upload= 0, client_month_download= 0 where server_id=:server_id:;
\ No newline at end of file
+update clients set client_month_upload= 0, client_month_download= 0 where server_id=:server_id:;
diff --git a/sql/client_update_stats.sql b/sql/client_update_stats.sql
index 5f66552..522bd27 100644
--- a/sql/client_update_stats.sql
+++ b/sql/client_update_stats.sql
@@ -1 +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
+update clients set client_lastconnected=:client_lastconnected:, client_totalconnections=client_totalconnections+1, client_lastip=:client_lastip: where client_id=:client_id:;
diff --git a/sql/create_pg/create_tables.sql b/sql/create_pg/create_tables.sql
index 9923c67..df69d38 100644
--- a/sql/create_pg/create_tables.sql
+++ b/sql/create_pg/create_tables.sql
@@ -34,10 +34,10 @@ CREATE TABLE clients (
   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_month_upload     NUMERIC(20) default 0,
+  client_month_download   NUMERIC(20) default 0,
+  client_total_upload     NUMERIC(20) default 0,
+  client_total_download   NUMERIC(20) default 0,
   client_lastip           text
 );
 CREATE INDEX index_clients_id ON clients (client_id);
@@ -159,14 +159,14 @@ CREATE TABLE servers (
   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
+  server_month_upload   NUMERIC(20) Default 0,
+  server_month_download NUMERIC(20) Default 0,
+  server_total_upload   NUMERIC(20) Default 0,
+  server_total_download NUMERIC(20) 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,
diff --git a/sql/defaults.sql b/sql/defaults.sql
index 6edf39b..e041719 100644
--- a/sql/defaults.sql
+++ b/sql/defaults.sql
@@ -7,7 +7,7 @@ insert into instance_properties (server_id, id, ident, value) values (0, 0, 'ser
 insert into instance_properties (server_id, id, ident, value) values (0, 0, 'serverinstance_template_serverdefault_group', '5');
 insert into instance_properties (server_id, id, ident, value) values (0, 0, 'serverinstance_template_channeladmin_group', '1');
 insert into instance_properties (server_id, id, ident, value) values (0, 0, 'serverinstance_template_channeldefault_group', '4');
-insert into instance_properties (server_id, id, ident, value) values (0, 0, 'serverinstance_permissions_version', '13');
+insert into instance_properties (server_id, id, ident, value) values (0, 0, 'serverinstance_permissions_version', '14');
 
 -- bindings
 insert into bindings (ip, type) values ('0.0.0.0', 0);
@@ -88,6 +88,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_neg
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_channel_modify_password', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_channel_modify_sortorder', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_channel_modify_topic', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_avatar_delete_other', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_ban_create', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_ban_delete', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_ban_delete_own', 1, 0, 0);
@@ -110,6 +111,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_neg
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_permissionoverview_own', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_permissionoverview_view', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_remoteaddress_view', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_request_talker', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_server_textmessage_send', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_set_flag_talker', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_client_skip_channelgroup_permissions', 1, 0, 0);
@@ -183,6 +185,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_neg
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_modify_port', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_modify_priority_speaker_dimm_modificator', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_modify_reserved_slots', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_modify_temporary_passwords', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_modify_weblist', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_modify_welcomemessage', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'b_virtualserver_notify_register', 1, 0, 0);
@@ -313,6 +316,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_neg
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_channel_needed_subscribe_power', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_channel_permission_modify_power', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_channel_subscribe_power', 100, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_avatar_delete_other', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_ban_create', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_ban_delete', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_ban_delete_own', 100, 0, 0);
@@ -361,6 +365,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_neg
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_poke_power', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_private_textmessage_power', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_remoteaddress_view', 100, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_request_talker', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_serverquery_view_power', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_server_textmessage_send', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_client_set_flag_talker', 100, 0, 0);
@@ -464,6 +469,8 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_neg
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_port', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_priority_speaker_dimm_modificator', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_reserved_slots', 100, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_temporary_passwords', 100, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_temporary_passwords_own', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_weblist', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_modify_welcomemessage', 100, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, 'i_needed_modify_power_virtualserver_notify_register', 100, 0, 0);
@@ -530,6 +537,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_channel_modify_password', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_channel_modify_sortorder', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_channel_modify_topic', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_avatar_delete_other', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_ban_create', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_ban_delete', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_ban_delete_own', 1, 0, 0);
@@ -552,6 +560,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_permissionoverview_own', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_permissionoverview_view', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_remoteaddress_view', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_request_talker', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_server_textmessage_send', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_set_flag_talker', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_client_skip_channelgroup_permissions', 1, 0, 0);
@@ -605,6 +614,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_modify_port', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_modify_priority_speaker_dimm_modificator', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_modify_reserved_slots', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_modify_temporary_passwords', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_modify_weblist', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_modify_welcomemessage', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'b_virtualserver_notify_register', 1, 0, 0);
@@ -729,6 +739,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_channel_needed_subscribe_power', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_channel_permission_modify_power', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_channel_subscribe_power', 75, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_avatar_delete_other', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_ban_create', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_ban_delete', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_ban_delete_own', 75, 0, 0);
@@ -777,6 +788,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_poke_power', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_private_textmessage_power', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_remoteaddress_view', 75, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_request_talker', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_serverquery_view_power', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_server_textmessage_send', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_client_set_flag_talker', 75, 0, 0);
@@ -859,6 +871,8 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_port', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_priority_speaker_dimm_modificator', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_reserved_slots', 75, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_temporary_passwords', 75, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_temporary_passwords_own', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_weblist', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_modify_welcomemessage', 75, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, 'i_needed_modify_power_virtualserver_notify_register', 75, 0, 0);
@@ -897,6 +911,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_client_offline_textmessage_send', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_client_permissionoverview_own', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_client_permissionoverview_view', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_client_request_talker', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_group_is_permanent', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_virtualserver_channelgroup_client_list', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, 'b_virtualserver_channelgroup_list', 1, 0, 0);
@@ -951,6 +966,7 @@ insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_ne
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'b_channel_join_temporary', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'b_client_channel_textmessage_send', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'b_client_info_view', 1, 0, 0);
+insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'b_client_request_talker', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'b_virtualserver_token_use', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'i_channel_create_modify_with_codec_latency_factor_min', 1, 0, 0);
 insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, 'i_channel_create_modify_with_codec_maxquality', 7, 0, 0);
diff --git a/sql/update_18.sql b/sql/update_18.sql
index efea9f1..7ae65d6 100644
--- a/sql/update_18.sql
+++ b/sql/update_18.sql
@@ -1 +1 @@
-ALTER TABLE clients ADD COLUMN client_lastip varchar(20);
\ No newline at end of file
+ALTER TABLE clients ADD COLUMN client_lastip text;