PATHFINDER - System Mapping Tool

pathfinder is an open source mapping tool for EVE ONLINE.

Setup and Bootstrapping

The following steps will guide you through the database bootstrapping/update process for PATHFINDER.

Information

Installation Pathfinder
Version v2.0.0
Package Fat-Free Framework 3.7.1-Release
Contact https://github.com/exodus4d
Repository https://github.com/exodus4d/pathfinder

Directories

config.ini
TEMP tmp/ 0755
CACHE folder=tmp/cache/ 0755
API_CACHE folder=tmp/cache/ 0755
LOGS logs/ 0755
UI public/ 0755
AUTOLOAD ./ 0777
FAVICON favicon/ 0755
HISTORY [optional] history/
CONFIG PATH [optional] conf/ app/

Server

Time 2026/04/24 00:10:17 - (UTC)
OS Linux
Host name 0053b8a938d5
Release name 6.8.0-110-generic
Version info #110-Ubuntu SMP PREEMPT_DYNAMIC Thu Mar 19 15:09:20 UTC 2026
Machine type x86_64
Document root /var/www/html
Port 443
Protocol - scheme HTTP/1.1 - https

Environment variables [optional]

required found
Git installed
Composer installed
NodeJs 12.2 missing
npm 6.13.4 missing

2 warning

Server
2

Requirements

required found
Server type apache
Server version 2.5 2.4.54
PHP interface type apache2handler
PHP 7.2 7.4.33
php_int_size 64-bit 64-bit

PHP extensions

PCRE 8.02 10.35
PDO installed installed
PDO_MYSQL installed installed
OpenSSL installed installed
XML installed installed
GD Library (for Image plugin) installed installed
cURL (for Web plugin) installed installed
Redis [optional] 3.0.0 6.3.0

LibEvent library [optional]

Event extension 2.3.0 missing
mod_rewrite enabled enabled
mod_headers enabled enabled

2 warning

PHP config php.ini

required found
exec() 1 1
memory_limit 128M 128
max_input_vars 3000 5000
max_execution_time 10 30
html_errors 0 1

Session

save_handler files
session.save_path
session.name pathfinder_session

1 warning

Environment
3

Configuration

ENVIRONMENT_CONFIG Config: app/environment.ini
BASE  
URL https://pf.eve.gamlok.com
DEBUG 0
CCP_SSO_URL https://login.eveonline.com
CCP_SSO_CLIENT_ID 72301e78afcb4e7990b48c___ [32]
CCP_SSO_SECRET_KEY eat_2jxNdxSSBKJSYJBxp7K6uYOABuBP2w___ [44]
CCP_SSO_DOWNTIME 11:00
CCP_ESI_URL https://esi.evetech.net
CCP_ESI_DATASOURCE tranquility
SMTP_HOST localhost
SMTP_PORT 25
SMTP_SCHEME TLS
SMTP_USER [missing]
SMTP_PASS [missing]
SMTP_FROM pathfinder@pf.eve.gamlok.com
SMTP_ERROR pathfinder@pf.eve.gamlok.com

Modules

Registration/Login enabled
Slack enabled
Discord enabled

Map Settings

private corporation alliance
Map lifetime (days) 60 99999 99999
Max. maps count/user 3 5 4
Map share limit/map 10 4 2
Max. systems count/map 50 100 100
Activity statistics enabled enabled disabled
History log files enabled enabled enabled
History log Slack disabled enabled enabled
Rally point poke Slack enabled enabled enabled
History log Discord disabled enabled enabled
Rally point poke Discord enabled enabled enabled
Rally point poke Email disabled disabled disabled

Settings

Pathfinder

DB driver mysql
DB host:port pathfinder-db:3306
DB name pathfinder
DB user pathfinder
DB pass c9f7e0a4d77485dbf1b51b6ccd0776e992b30e5f___ [48]
DB status connected (persistent)
required installed
DB version 5.7 8.0.46
default_storage_engine InnoDB InnoDB
character_set_server utf8mb4 utf8mb4
character_set_database utf8mb4 utf8mb4
character_set_client utf8mb4 utf8mb4
character_set_results utf8mb4 utf8mb4
character_set_connection utf8mb4 utf8mb4
collation_database utf8mb4_unicode_ci utf8mb4_unicode_ci
collation_connection utf8mb4_unicode_ci utf8mb4_unicode_ci
foreign_key_checks ON ON
innodb_file_per_table ON ON
wait_timeout 28800 28800
interactive_timeout 28800 28800

OK

Table exist charset
activity_log utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. year smallint 0 1 0
4. week tinyint 0 1 0
5. active tinyint(1) 0 1 0
6. characterId int 1 1 0
7. mapId int 1 1 0
8. mapCreate smallint 0 0 0
9. mapUpdate smallint 0 0 0
10. mapDelete smallint 0 0 0
11. systemCreate smallint 0 0 0
12. systemUpdate smallint 0 0 0
13. systemDelete smallint 0 0 0
14. connectionCreate smallint 0 0 0
15. connectionUpdate smallint 0 0 0
16. connectionDelete smallint 0 0 0
17. signatureCreate smallint 0 0 0
18. signatureUpdate smallint 0 0 0
19. signatureDelete smallint 0 0 0
foreign key
1. fk_activity_log___characterId___character___id
2. fk_activity_log___mapId___map___id
alliance utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. ticker varchar(128) 0 0 0
6. shared tinyint(1) 0 0 0
alliance_map utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. allianceId int 1 1 0
5. mapId int 1 1 0
foreign key
1. fk_alliance_map___allianceId___alliance___id
2. fk_alliance_map___mapId___map___id
character utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. lastLogin timestamp 1 1 0
4. active tinyint(1) 0 1 0
5. name varchar(128) 0 0 0
6. ownerHash varchar(128) 0 0 0
7. esiAccessToken varchar(255) 1 0 0
8. esiAccessTokenExpires timestamp 1 1 0
9. esiRefreshToken varchar(255) 1 0 0
10. esiScopes text 1 0 0
11. corporationId int 1 1 0
12. allianceId int 1 1 0
13. roleId int 0 1 0
14. cloneLocationId bigint 1 1 0
15. cloneLocationType varchar(128) 0 0 0
16. kicked timestamp 1 1 0
17. banned timestamp 1 1 0
18. shared tinyint(1) 0 0 0
19. logLocation tinyint(1) 0 0 0
20. selectLocation tinyint(1) 0 0 0
21. securityStatus float 0 0 0
foreign key
1. fk_character___corporationId___corporation___id
2. fk_character___allianceId___alliance___id
3. fk_character___roleId___role___id
character_authentication utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. characterId int 1 1 0
5. selector varchar(128) 0 1 1
6. token varchar(128) 0 1 0
7. expires timestamp 1 1 0
foreign key
1. fk_character_authentication___characterId___character___id
character_log utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. characterId int 1 1 1
5. systemId int 1 1 0
6. systemName varchar(128) 0 0 0
7. shipTypeId int 1 1 0
8. shipTypeName varchar(128) 0 0 0
9. shipId bigint 1 1 0
10. shipMass float 0 0 0
11. shipName varchar(128) 0 0 0
12. stationId int 1 1 0
13. stationName varchar(128) 0 0 0
14. structureTypeId int 1 1 0
15. structureTypeName varchar(128) 0 0 0
16. structureId bigint 1 1 0
17. structureName varchar(128) 0 0 0
foreign key
1. fk_character_log___characterId___character___id
character_map utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. characterId int 1 1 0
5. mapId int 1 1 0
foreign key
1. fk_character_map___characterId___character___id
2. fk_character_map___mapId___map___id
character_status utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. class varchar(128) 0 0 0
connection utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. createdCharacterId int 1 1 0
4. updatedCharacterId int 1 1 0
5. active tinyint(1) 0 1 0
6. mapId int 1 1 0
7. source int 1 1 0
8. target int 1 1 0
9. scope varchar(128) 0 0 0
10. type text 1 0 0
11. sourceEndpointType text 1 0 0
12. targetEndpointType text 1 0 0
13. eolUpdated timestamp 1 0 0
foreign key
1. fk_connection___createdCharacterId___character___id
2. fk_connection___updatedCharacterId___character___id
3. fk_connection___mapId___map___id
4. fk_connection___source___system___id
5. fk_connection___target___system___id
connection_log utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. connectionId int 1 1 0
5. record tinyint(1) 0 1 0
6. shipTypeId int 1 1 0
7. shipTypeName varchar(128) 0 0 0
8. shipMass float 0 0 0
9. characterId int 1 1 0
10. characterName varchar(128) 0 0 0
foreign key
1. fk_connection_log___connectionId___connection___id
connection_scope utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. label varchar(128) 0 0 0
6. connectorDefinition varchar(255) 0 0 0
corporation utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. ticker varchar(128) 0 0 0
6. memberCount int 0 0 0
7. shared tinyint(1) 0 0 0
8. isNPC tinyint(1) 0 0 0
corporation_map utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. corporationId int 1 1 0
5. mapId int 1 1 0
foreign key
1. fk_corporation_map___corporationId___corporation___id
2. fk_corporation_map___mapId___map___id
corporation_right utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. corporationId int 1 1 0
5. rightId int 1 1 0
6. roleId int 1 1 0
foreign key
1. fk_corporation_right___corporationId___corporation___id
2. fk_corporation_right___rightId___right___id
3. fk_corporation_right___roleId___role___id
corporation_structure utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. corporationId int 1 1 0
5. structureId int 1 1 0
foreign key
1. fk_corporation_structure___corporationId___corporation___id
2. fk_corporation_structure___structureId___structure___id
cron utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 1 1
4. handler varchar(255) 0 1 1
5. expr varchar(128) 0 0 0
6. isPaused tinyint(1) 0 0 0
7. lastExecStart decimal(18,6) 1 0 0
8. lastExecEnd decimal(18,6) 1 0 0
9. lastExecMemPeak float 1 0 0
10. lastExecState text 1 0 0
11. history text 1 0 0
map utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. createdCharacterId int 1 1 0
4. updatedCharacterId int 1 1 0
5. active tinyint(1) 0 1 0
6. scopeId int 1 1 0
7. typeId int 1 1 0
8. name varchar(128) 0 0 0
9. icon varchar(128) 0 0 0
10. deleteExpiredConnections tinyint(1) 0 0 0
11. deleteEolConnections tinyint(1) 0 0 0
12. persistentAliases tinyint(1) 0 0 0
13. persistentSignatures tinyint(1) 0 0 0
14. trackAbyssalJumps tinyint(1) 0 0 0
15. logActivity tinyint(1) 0 0 0
16. logHistory tinyint(1) 0 0 0
17. slackWebHookURL varchar(128) 0 0 0
18. slackUsername varchar(128) 0 0 0
19. slackIcon varchar(128) 0 0 0
20. slackChannelHistory varchar(128) 0 0 0
21. slackChannelRally varchar(128) 0 0 0
22. discordUsername varchar(128) 0 0 0
23. discordWebHookURLRally varchar(255) 0 0 0
24. discordWebHookURLHistory varchar(255) 0 0 0
foreign key
1. fk_map___createdCharacterId___character___id
2. fk_map___updatedCharacterId___character___id
3. fk_map___scopeId___map_scope___id
4. fk_map___typeId___map_type___id
map_scope utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. label varchar(128) 0 0 0
map_type utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. label varchar(128) 0 0 0
6. class varchar(128) 0 0 0
7. classTab varchar(128) 0 0 0
right utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 1 1
5. label varchar(128) 0 0 0
6. description varchar(512) 0 0 0
role utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. label varchar(128) 0 0 0
6. level int 1 1 0
7. style varchar(128) 0 0 0
structure utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. structureId int 1 1 0
5. corporationId int 1 1 0
6. systemId int 1 1 0
7. statusId int 1 1 0
8. name varchar(128) 0 0 0
9. description varchar(512) 0 0 0
foreign key
1. fk_structure___corporationId___corporation___id
2. fk_structure___statusId___structure_status___id
structure_status utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. label varchar(128) 0 0 0
6. class varchar(128) 0 0 0
system utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. createdCharacterId int 1 1 0
4. updatedCharacterId int 1 1 0
5. active tinyint(1) 0 1 0
6. mapId int 1 1 0
7. systemId int 1 1 0
8. alias varchar(128) 0 0 0
9. typeId int 1 1 0
10. statusId int 0 1 0
11. locked tinyint(1) 0 0 0
12. rallyUpdated timestamp 1 0 0
13. rallyPoke tinyint(1) 0 0 0
14. description text 1 0 0
15. posX int 0 0 0
16. posY int 0 0 0
foreign key
1. fk_system___createdCharacterId___character___id
2. fk_system___updatedCharacterId___character___id
3. fk_system___mapId___map___id
4. fk_system___typeId___system_type___id
5. fk_system___statusId___system_status___id
system_jumps utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. systemId int 1 1 1
5. lastUpdatedValue int 0 1 0
6. value1 int 0 0 0
7. value2 int 0 0 0
8. value3 int 0 0 0
9. value4 int 0 0 0
10. value5 int 0 0 0
11. value6 int 0 0 0
12. value7 int 0 0 0
13. value8 int 0 0 0
14. value9 int 0 0 0
15. value10 int 0 0 0
16. value11 int 0 0 0
17. value12 int 0 0 0
18. value13 int 0 0 0
19. value14 int 0 0 0
20. value15 int 0 0 0
21. value16 int 0 0 0
22. value17 int 0 0 0
23. value18 int 0 0 0
24. value19 int 0 0 0
25. value20 int 0 0 0
26. value21 int 0 0 0
27. value22 int 0 0 0
28. value23 int 0 0 0
29. value24 int 0 0 0
system_kills_factions utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. systemId int 1 1 1
5. lastUpdatedValue int 0 1 0
6. value1 int 0 0 0
7. value2 int 0 0 0
8. value3 int 0 0 0
9. value4 int 0 0 0
10. value5 int 0 0 0
11. value6 int 0 0 0
12. value7 int 0 0 0
13. value8 int 0 0 0
14. value9 int 0 0 0
15. value10 int 0 0 0
16. value11 int 0 0 0
17. value12 int 0 0 0
18. value13 int 0 0 0
19. value14 int 0 0 0
20. value15 int 0 0 0
21. value16 int 0 0 0
22. value17 int 0 0 0
23. value18 int 0 0 0
24. value19 int 0 0 0
25. value20 int 0 0 0
26. value21 int 0 0 0
27. value22 int 0 0 0
28. value23 int 0 0 0
29. value24 int 0 0 0
system_kills_pods utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. systemId int 1 1 1
5. lastUpdatedValue int 0 1 0
6. value1 int 0 0 0
7. value2 int 0 0 0
8. value3 int 0 0 0
9. value4 int 0 0 0
10. value5 int 0 0 0
11. value6 int 0 0 0
12. value7 int 0 0 0
13. value8 int 0 0 0
14. value9 int 0 0 0
15. value10 int 0 0 0
16. value11 int 0 0 0
17. value12 int 0 0 0
18. value13 int 0 0 0
19. value14 int 0 0 0
20. value15 int 0 0 0
21. value16 int 0 0 0
22. value17 int 0 0 0
23. value18 int 0 0 0
24. value19 int 0 0 0
25. value20 int 0 0 0
26. value21 int 0 0 0
27. value22 int 0 0 0
28. value23 int 0 0 0
29. value24 int 0 0 0
system_kills_ships utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. systemId int 1 1 1
5. lastUpdatedValue int 0 1 0
6. value1 int 0 0 0
7. value2 int 0 0 0
8. value3 int 0 0 0
9. value4 int 0 0 0
10. value5 int 0 0 0
11. value6 int 0 0 0
12. value7 int 0 0 0
13. value8 int 0 0 0
14. value9 int 0 0 0
15. value10 int 0 0 0
16. value11 int 0 0 0
17. value12 int 0 0 0
18. value13 int 0 0 0
19. value14 int 0 0 0
20. value15 int 0 0 0
21. value16 int 0 0 0
22. value17 int 0 0 0
23. value18 int 0 0 0
24. value19 int 0 0 0
25. value20 int 0 0 0
26. value21 int 0 0 0
27. value22 int 0 0 0
28. value23 int 0 0 0
29. value24 int 0 0 0
system_signature utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. createdCharacterId int 1 1 0
4. updatedCharacterId int 1 1 0
5. active tinyint(1) 0 1 0
6. systemId int 1 1 0
7. groupId int 0 1 0
8. typeId int 0 1 0
9. connectionId int 1 1 0
10. name varchar(128) 0 0 0
11. description varchar(512) 0 0 0
foreign key
1. fk_system_signature___createdCharacterId___character___id
2. fk_system_signature___updatedCharacterId___character___id
3. fk_system_signature___systemId___system___id
4. fk_system_signature___connectionId___connection___id
system_status utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. label varchar(128) 0 0 0
6. class varchar(128) 0 0 0
system_type utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
user utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 1 0
5. email varchar(128) 0 0 0
user_character utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. userId int 1 1 0
5. characterId int 1 1 1
foreign key
1. fk_user_character___userId___user___id
2. fk_user_character___characterId___character___id

OK

Setup tables Fix columns/keys

EVE-Online universe

DB driver mysql
DB host:port pathfinder-db:3306
DB name eve_universe
DB user pathfinder
DB pass c9f7e0a4d77485dbf1b51b6ccd0776e992b30e5f___ [48]
DB status connected (persistent)
required installed
DB version 5.7 8.0.46
default_storage_engine InnoDB InnoDB
character_set_server utf8mb4 utf8mb4
character_set_database utf8mb4 utf8mb4
character_set_client utf8mb4 utf8mb4
character_set_results utf8mb4 utf8mb4
character_set_connection utf8mb4 utf8mb4
collation_database utf8mb4_unicode_ci utf8mb4_unicode_ci
collation_connection utf8mb4_unicode_ci utf8mb4_unicode_ci
foreign_key_checks ON ON
innodb_file_per_table ON ON
wait_timeout 28800 28800
interactive_timeout 28800 28800

OK

Table exist charset
alliance utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. ticker varchar(128) 0 0 0
5. dateFounded datetime 1 0 0
6. factionId int 1 1 0
foreign key
1. fk_alliance___factionId___faction___id
category utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. published tinyint(1) 0 1 0
constellation utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. regionId int 1 1 0
5. x bigint 0 0 0
6. y bigint 0 0 0
7. z bigint 0 0 0
foreign key
1. fk_constellation___regionId___region___id
corporation utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. ticker varchar(128) 0 0 0
5. dateFounded datetime 1 0 0
6. memberCount int 0 0 0
7. isNPC tinyint(1) 0 0 0
8. factionId int 1 1 0
9. allianceId int 1 1 0
foreign key
1. fk_corporation___factionId___faction___id
2. fk_corporation___allianceId___alliance___id
dogma_attribute utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. displayName varchar(128) 1 0 0
5. description text 1 0 0
6. published tinyint(1) 1 0 0
7. stackable tinyint(1) 1 0 0
8. highIsGood tinyint(1) 1 0 0
9. defaultValue float 0 0 0
10. iconId int 1 0 0
11. unitId int 1 0 0
faction utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. description text 1 0 0
5. sizeFactor int 0 0 0
6. stationCount int 0 0 0
7. stationSystemCount int 0 0 0
faction_war_system utf8mb4
column exist type null I U
1. systemId int 1 1 1
2. ownerFactionId int 1 1 0
3. occupierFactionId int 1 1 0
4. contested varchar(128) 0 0 0
5. victoryPoints int 0 0 0
6. victoryPointsThreshold int 0 0 0
foreign key
1. fk_faction_war_system___systemId___system___id
2. fk_faction_war_system___ownerFactionId___faction___id
3. fk_faction_war_system___occupierFactionId___faction___id
group utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. published tinyint(1) 0 1 0
5. categoryId int 1 1 0
foreign key
1. fk_group___categoryId___category___id
planet utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. systemId int 1 1 0
5. typeId int 1 1 0
6. x bigint 0 0 0
7. y bigint 0 0 0
8. z bigint 0 0 0
foreign key
1. fk_planet___systemId___system___id
2. fk_planet___typeId___type___id
race utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. description text 1 0 0
5. factionId int 1 1 0
foreign key
1. fk_race___factionId___faction___id
region utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. description text 1 0 0
sovereignty_map utf8mb4
column exist type null I U
1. systemId int 1 1 1
2. factionId int 1 1 0
3. allianceId int 1 1 0
4. corporationId int 1 1 0
foreign key
1. fk_sovereignty_map___systemId___system___id
2. fk_sovereignty_map___factionId___faction___id
3. fk_sovereignty_map___allianceId___alliance___id
4. fk_sovereignty_map___corporationId___corporation___id
star utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. typeId int 1 1 0
5. age bigint 1 0 0
6. radius bigint 1 0 0
7. temperature int 1 0 0
8. luminosity float 1 0 0
9. spectralClass varchar(128) 1 0 0
foreign key
1. fk_star___typeId___type___id
stargate utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. systemId int 1 1 0
5. typeId int 1 1 0
6. destinationSystemId int 1 1 0
7. x bigint 0 0 0
8. y bigint 0 0 0
9. z bigint 0 0 0
foreign key
1. fk_stargate___systemId___system___id
2. fk_stargate___typeId___type___id
3. fk_stargate___destinationSystemId___system___id
station utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. systemId int 1 1 0
5. typeId int 1 1 0
6. corporationId int 1 1 0
7. raceId int 1 1 0
8. services text 1 0 0
9. x bigint 0 0 0
10. y bigint 0 0 0
11. z bigint 0 0 0
foreign key
1. fk_station___systemId___system___id
2. fk_station___typeId___type___id
3. fk_station___corporationId___corporation___id
4. fk_station___raceId___race___id
structure utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. systemId int 1 1 0
5. typeId int 1 1 0
6. x float 0 0 0
7. y float 0 0 0
8. z float 0 0 0
foreign key
1. fk_structure___systemId___system___id
2. fk_structure___typeId___type___id
system utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. constellationId int 1 1 0
5. starId int 1 1 0
6. security varchar(128) 1 0 0
7. trueSec float 0 0 0
8. securityStatus decimal(18,6) 0 0 0
9. securityClass varchar(128) 1 0 0
10. effect varchar(128) 1 0 0
11. x bigint 0 0 0
12. y bigint 0 0 0
13. z bigint 0 0 0
foreign key
1. fk_system___constellationId___constellation___id
2. fk_system___starId___star___id
system_neighbour utf8mb4
column exist type null I U
1. regionId int 1 1 0
2. constellationId int 1 1 0
3. systemId int 1 1 1
4. systemName varchar(128) 0 0 0
5. jumpNodes varchar(512) 0 0 0
6. trueSec decimal(18,6) 0 0 0
foreign key
1. fk_system_neighbour___regionId___region___id
2. fk_system_neighbour___constellationId___constellation___id
3. fk_system_neighbour___systemId___system___id
system_static utf8mb4
column exist type null I U
1. systemId int 1 1 0
2. typeId int 1 1 0
foreign key
1. fk_system_static___systemId___system___id
2. fk_system_static___typeId___type___id
type utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. description text 1 0 0
5. published tinyint(1) 0 1 0
6. radius float 0 0 0
7. volume float 0 0 0
8. capacity float 0 0 0
9. mass float 0 0 0
10. groupId int 1 1 0
11. marketGroupId int 0 1 0
12. packagedVolume float 0 0 0
13. portionSize int 0 0 0
14. graphicId int 0 1 0
foreign key
1. fk_type___groupId___group___id
type_attribute utf8mb4
column exist type null I U
1. typeId int 1 1 0
2. attributeId int 1 1 0
3. value float 0 0 0
foreign key
1. fk_type_attribute___typeId___type___id
2. fk_type_attribute___attributeId___dogma_attribute___id

OK

Setup tables Fix columns/keys

Database

Redis server

Redis can be used as Cache backend pathfinder.ini
Redis can be used as PHP Sessions handler php.ini

No Redis configuration found

Cache [optional]

  TCP-Socket (intern)

HOST [missing]
PORT [missing]
URI [missing]
timeout (seconds) 0.6
uptime

  Web-Socket

URI

INIT CONNECTION…

Socket configuration [optional]
5 2

  Configuration app/cron.ini

required found
LOG 1 1
CLI 1 1
WEB 0
SILENT 1

  Jobs

last
status name schedule start time exec. time mem. peak
cleanUpCharacterData @hourly
deactivateMapData @hourly
deleteAuthenticationData @downtime
deleteEolConnections @fiveMinutes
deleteExpiredCacheData @downtime
deleteExpiredConnections @hourly
deleteLogData @instant
deleteMapData @downtime
deleteSignatures @halfHour
deleteStatisticsData @weekly
importSystemData @halfPastHour
truncateMapHistoryLogFiles @halfHour
updateSovereigntyData @halfPastHour

Cronjob

  Import static data

count sub count
Wormholes data 0/130
 Import
Structures data 0/15 0/42
 Import
Ships data 0/49 0/561
 Import
Wormhole statics data 0/3772
 Import

   Build search index

Systems data index 0/0
 Clear  Build
Systems neighbour index 0/5201
 Clear  Build

  Filesystem cache 974.33KB

Temp dir tmp/ → 227.11KB
 Delete files
Cache dir tmp/cache/ → 747.22KB
 Delete files

  Cookies

Invalidate all Cookie data
 Clear authentication data

Administration
6