summaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--sql/client_clear_traffic_stats.sql2
-rw-r--r--sql/client_update_stats.sql2
-rw-r--r--sql/create_pg/create_tables.sql18
-rw-r--r--sql/defaults.sql18
-rw-r--r--sql/update_18.sql2
5 files changed, 29 insertions, 13 deletions
diff --git a/sql/client_clear_traffic_stats.sql b/sql/client_clear_traffic_stats.sql
index 68158c9..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;
+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;