SET NAMES latin1;
SET character_set_results = NULL;
SHOW VARIABLES;
SHOW COLLATION;
update servers set ip_address = '192.168.6.110'   where id = 7;
update machines set last_ping = now() where server = 7;
update machines set alive = 1   where server = 7;
select server_messages.id, key_ - 1, value, reference,        servers.id, servers.name, servers.ip_address, servers.port   from server_messages     inner join messages_and_servers       on server_messages.id = messages_and_servers.message     inner join servers       on server_messages.source = servers.id   where messages_and_servers.server = 7;
SET autocommit=0;
delete from messages_and_servers   where message = 3 and server = 7;
delete from server_messages   using server_messages     left join messages_and_servers       on server_messages.id = messages_and_servers.message   where server_messages.id = 3     and messages_and_servers.message is null;
commit;
SET autocommit=1;
select servers.id, servers.name, servers.ip_address, servers.port,        services_provided.service - 1, services_provided.account   from services_provided     left join (select servers.id as id,        if(valid_machines.machine,           valid_machines.machine,           group_leaders.leader) as leader   from servers     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select if(groups.type = 1,           group_leaders.leader,           servers.id) as blacklister   from servers     cross join machines_and_groups       on servers.id = machines_and_groups.machine     left join groups       on machines_and_groups.group_ = groups.server     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select 7)         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_   where servers.id = 7     or (machines_and_groups.machine = 7         and groups.type = 1))         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null) as valid_machines       on servers.id = valid_machines.machine     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select if(groups.type = 1,           group_leaders.leader,           servers.id) as blacklister   from servers     cross join machines_and_groups       on servers.id = machines_and_groups.machine     left join groups       on machines_and_groups.group_ = groups.server     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select 7)         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_   where servers.id = 7     or (machines_and_groups.machine = 7         and groups.type = 1))         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_) as group_leaders       on servers.id = group_leaders.group_   where valid_machines.machine or group_leaders.leader) as leaders       on services_provided.provider = leaders.id     left join servers       on leaders.id = servers.id     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select if(groups.type = 1,           group_leaders.leader,           servers.id) as blacklister   from servers     cross join machines_and_groups       on servers.id = machines_and_groups.machine     left join groups       on machines_and_groups.group_ = groups.server     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select 7)         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_   where servers.id = 7     or (machines_and_groups.machine = 7         and groups.type = 1))         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on services_provided.dependency = group_leaders.group_   where services_provided.dependency = 7     or group_leaders.leader = 7;
SET autocommit=1;
select services_required.service - 1, services_required.account   from services_required     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select if(groups.type = 1,           group_leaders.leader,           servers.id) as blacklister   from servers     cross join machines_and_groups       on servers.id = machines_and_groups.machine     left join groups       on machines_and_groups.group_ = groups.server     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select 7)         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_   where servers.id = 7     or (machines_and_groups.machine = 7         and groups.type = 1))         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on services_required.dependency = group_leaders.group_   where services_required.dependency = 7     or group_leaders.leader = 7;
SET autocommit=1;
select servers.id, servers.name, servers.ip_address, servers.port   from machines_and_groups     inner join groups       on machines_and_groups.group_ = groups.server     inner join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select if(groups.type = 1,           group_leaders.leader,           servers.id) as blacklister   from servers     cross join machines_and_groups       on servers.id = machines_and_groups.machine     left join groups       on machines_and_groups.group_ = groups.server     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select 7)         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_   where servers.id = 7     or (machines_and_groups.machine = 7         and groups.type = 1))         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_     inner join servers       on group_leaders.leader = servers.id   where machines_and_groups.machine = 7    and groups.type = 1;
SET autocommit=1;
select server_messages.id, key_ - 1, value, reference,        servers.id, servers.name, servers.ip_address, servers.port   from server_messages     inner join messages_and_servers       on server_messages.id = messages_and_servers.message     inner join servers       on server_messages.source = servers.id   where messages_and_servers.server = 7;
SET autocommit=0;
delete from messages_and_servers   where message = 4 and server = 7;
commit;
SET autocommit=1;
select servers.id, servers.name, servers.ip_address, servers.port,        services_provided.service - 1, services_provided.account   from services_provided     left join (select servers.id as id,        if(valid_machines.machine,           valid_machines.machine,           group_leaders.leader) as leader   from servers     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select if(groups.type = 1,           group_leaders.leader,           servers.id) as blacklister   from servers     cross join machines_and_groups       on servers.id = machines_and_groups.machine     left join groups       on machines_and_groups.group_ = groups.server     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select 7)         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_   where servers.id = 7     or (machines_and_groups.machine = 7         and groups.type = 1))         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null) as valid_machines       on servers.id = valid_machines.machine     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select if(groups.type = 1,           group_leaders.leader,           servers.id) as blacklister   from servers     cross join machines_and_groups       on servers.id = machines_and_groups.machine     left join groups       on machines_and_groups.group_ = groups.server     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select 7)         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_   where servers.id = 7     or (machines_and_groups.machine = 7         and groups.type = 1))         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_) as group_leaders       on servers.id = group_leaders.group_   where valid_machines.machine or group_leaders.leader) as leaders       on services_provided.provider = leaders.id     left join servers       on leaders.id = servers.id     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select if(groups.type = 1,           group_leaders.leader,           servers.id) as blacklister   from servers     cross join machines_and_groups       on servers.id = machines_and_groups.machine     left join groups       on machines_and_groups.group_ = groups.server     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select 7)         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_   where servers.id = 7     or (machines_and_groups.machine = 7         and groups.type = 1))         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on services_provided.dependency = group_leaders.group_   where services_provided.dependency = 7     or group_leaders.leader = 7;
SET autocommit=1;
select services_required.service - 1, services_required.account   from services_required     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select if(groups.type = 1,           group_leaders.leader,           servers.id) as blacklister   from servers     cross join machines_and_groups       on servers.id = machines_and_groups.machine     left join groups       on machines_and_groups.group_ = groups.server     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select 7)         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_   where servers.id = 7     or (machines_and_groups.machine = 7         and groups.type = 1))         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on services_required.dependency = group_leaders.group_   where services_required.dependency = 7     or group_leaders.leader = 7;
SET autocommit=1;
select servers.id, servers.name, servers.ip_address, servers.port   from machines_and_groups     inner join groups       on machines_and_groups.group_ = groups.server     inner join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select if(groups.type = 1,           group_leaders.leader,           servers.id) as blacklister   from servers     cross join machines_and_groups       on servers.id = machines_and_groups.machine     left join groups       on machines_and_groups.group_ = groups.server     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select 7)         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_   where servers.id = 7     or (machines_and_groups.machine = 7         and groups.type = 1))         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_     inner join servers       on group_leaders.leader = servers.id   where machines_and_groups.machine = 7    and groups.type = 1;
SET autocommit=1;
select 1 from blacklist where listed = 7;
SET autocommit=0;
insert into server_messages (key_, value, reference, source)   values (2, 'o(com.ecovate.server.protocol.ServerMessage v(s(type) s(HELLO)))', 0, 7);
insert into messages_and_servers   (message, server)   select last_insert_id(), members.member     from (select servers.id as id,        if(valid_machines.machine,           valid_machines.machine,           group_members.member) as member   from servers     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select if(groups.type = 1,           group_leaders.leader,           servers.id) as blacklister   from servers     cross join machines_and_groups       on servers.id = machines_and_groups.machine     left join groups       on machines_and_groups.group_ = groups.server     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select 7)         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_   where servers.id = 7     or (machines_and_groups.machine = 7         and groups.type = 1))         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null) as valid_machines       on servers.id = valid_machines.machine     left join (select group_, valid_machines.machine as member   from machines_and_groups     cross join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select if(groups.type = 1,           group_leaders.leader,           servers.id) as blacklister   from servers     cross join machines_and_groups       on servers.id = machines_and_groups.machine     left join groups       on machines_and_groups.group_ = groups.server     left join (select group_, valid_machines.machine as leader   from machines_and_groups     left join (select machines.server as machine   from machines     left join blacklist       on blacklist.lister in (select 7)         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null               ) as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine   group by group_)       as group_leaders       on groups.server = group_leaders.group_   where servers.id = 7     or (machines_and_groups.machine = 7         and groups.type = 1))         and blacklist.listed = machines.server   where machines.alive and blacklist.listed is null)       as valid_machines       on machines_and_groups.machine = valid_machines.machine   where valid_machines.machine) as group_members       on servers.id = group_members.group_   where valid_machines.machine or group_members.member) as members     where members.id = 10;
commit;
SET autocommit=1;
select server_messages.id, key_ - 1, value, reference,        servers.id, servers.name, servers.ip_address, servers.port   from server_messages     inner join messages_and_servers       on server_messages.id = messages_and_servers.message     inner join servers       on server_messages.source = servers.id   where messages_and_servers.server = 7;
SET autocommit=0;
delete from messages_and_servers   where message = 4 and server = 7;
delete from messages_and_servers   where message = 5 and server = 7;
delete from messages_and_servers   where message = 6 and server = 7;
delete from server_messages   using server_messages     left join messages_and_servers       on server_messages.id = messages_and_servers.message   where server_messages.id = 4     and messages_and_servers.message is null;
delete from server_messages   using server_messages     left join messages_and_servers       on server_messages.id = messages_and_servers.message   where server_messages.id = 5     and messages_and_servers.message is null;
delete from server_messages   using server_messages     left join messages_and_servers       on server_messages.id = messages_and_servers.message   where server_messages.id = 6     and messages_and_servers.message is null;
commit;
SET autocommit=1;