From 56234d02ad16ace826a42530d1e428a69368f60d Mon Sep 17 00:00:00 2001 From: Alexander Sulfrian Date: Wed, 16 May 2012 04:07:38 +0200 Subject: sql: update to version 19 (ts3-v3.0.5) --- sql/client_clear_traffic_stats.sql | 2 +- sql/client_update_stats.sql | 2 +- sql/create_pg/create_tables.sql | 18 +++++++++--------- sql/defaults.sql | 18 +++++++++++++++++- sql/update_18.sql | 2 +- 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; -- cgit v1.2.3