API tools faq
paste
Advertisement
Guest User

evernuss

a guest
Apr 11th, 2018
64
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 136.40 KB | None | 0 0
raw download clone embed print report
  1. [info] 2018-04-10T21:47:57 4660 "Windows 10 (10.0)"
  2. [info] 2018-04-10T21:47:57 4660 "Evernus" "3.1"
  3. [warning] 2018-04-10T21:47:57 4660 QWinEventNotifier: Can only be used with threads started with QThread
  4. [warning] 2018-04-10T21:47:57 4660 QSslSocket: cannot resolve SSL_set_alpn_protos
  5. [warning] 2018-04-10T21:47:57 4660 QSslSocket: cannot resolve SSL_CTX_set_alpn_select_cb
  6. [warning] 2018-04-10T21:47:57 4660 QSslSocket: cannot resolve SSL_get0_alpn_selected
  7. [debug] 2018-04-10T21:47:58 4660 Switching language to "pt_BR"
  8. [debug] 2018-04-10T21:48:00 4660 Switching language to "en_US"
  9. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS characters (id BIGINT PRIMARY KEY,name TEXT NOT NULL,corporation_name TEXT NOT NULL,corporation_id BIGINT NOT NULL,race TEXT NOT NULL,bloodline TEXT NOT NULL,ancestry TEXT NOT NULL,gender TEXT NOT NULL,isk DOUBLE NOT NULL,corp_standing FLOAT NOT NULL,faction_standing FLOAT NOT NULL,trade_skill TINYINT NOT NULL,retail_skill TINYINT NOT NULL,wholesale_skill TINYINT NOT NULL,tycoon_skill TINYINT NOT NULL,marketing_skill TINYINT NOT NULL,procurement_skill TINYINT NOT NULL,daytrading_skill TINYINT NOT NULL,visibility_skill TINYINT NOT NULL,accounting_skill TINYINT NOT NULL,broker_relations_skill TINYINT NOT NULL,margin_trading_skill TINYINT NOT NULL,contracting_skill TINYINT NOT NULL,corporation_contracting_skill TINYINT NOT NULL,enabled TINYINT NOT NULL,brokers_fee FLOAT NULL,sell_brokers_fee FLOAT NULL,reprocessing_implant_bonus FLOAT NOT NULL,arkonor_processing TINYINT NOT NULL,bistot_processing TINYINT NOT NULL,crokite_processing TINYINT NOT NULL,dark_ochre_processing TINYINT NOT NULL,gneiss_processing TINYINT NOT NULL,hedbergite_processing TINYINT NOT NULL,hemorphite_processing TINYINT NOT NULL,ice_processing TINYINT NOT NULL,jaspet_processing TINYINT NOT NULL,kernite_processing TINYINT NOT NULL,mercoxit_processing TINYINT NOT NULL,omber_processing TINYINT NOT NULL,plagioclase_processing TINYINT NOT NULL,pyroxeres_processing TINYINT NOT NULL,reprocessing TINYINT NOT NULL,reprocessing_efficiency TINYINT NOT NULL,scordite_processing TINYINT NOT NULL,scrapmetal_processing TINYINT NOT NULL,spodumain_processing TINYINT NOT NULL,veldspar_processing TINYINT NOT NULL,manufacturing_time_implant_bonus FLOAT NOT NULL,industry TINYINT NOT NULL,advanced_industry TINYINT NOT NULL,advanced_small_ship_construction TINYINT NOT NULL,advanced_medium_ship_construction TINYINT NOT NULL,advanced_large_ship_construction TINYINT NOT NULL,avanced_industrial_ship_construction TINYINT NOT NULL,amarr_starship_engineering TINYINT NOT NULL,caldari_starship_engineering TINYINT NOT NULL,gallente_starship_engineering TINYINT NOT NULL,minmatar_starship_engineering TINYINT NOT NULL,electromagnetic_physics TINYINT NOT NULL,electronic_engineering TINYINT NOT NULL,graviton_physics TINYINT NOT NULL,high_energy_physics TINYINT NOT NULL,hydromagnetic_physics TINYINT NOT NULL,laser_physics TINYINT NOT NULL,mechanical_engineering TINYINT NOT NULL,molecular_engineering TINYINT NOT NULL,nuclear_physics TINYINT NOT NULL,plasma_physics TINYINT NOT NULL,quantum_physics TINYINT NOT NULL,rocket_science TINYINT NOT NULL,alpha_clone TINYINT NOT NULL)"
  10. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS asset_lists (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE)"
  11. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS asset_lists_characters_index ON asset_lists(character_id)"
  12. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS corp_asset_lists (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE)"
  13. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_asset_lists_characters_index ON corp_asset_lists(character_id)"
  14. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS items (id INTEGER PRIMARY KEY,asset_list_id INTEGER NOT NULL REFERENCES asset_lists(id) ON UPDATE CASCADE ON DELETE CASCADE,parent_id BIGINT NULL REFERENCES items(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,location_id BIGINT NULL,quantity INTEGER NOT NULL,raw_quantity INTEGER NOT NULL,custom_value NUMERIC NULL)"
  15. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS items_asset_lists_index ON items(asset_list_id)"
  16. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS corp_items (id INTEGER PRIMARY KEY,asset_list_id INTEGER NOT NULL REFERENCES corp_asset_lists(id) ON UPDATE CASCADE ON DELETE CASCADE,parent_id BIGINT NULL REFERENCES corp_items(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,location_id BIGINT NULL,quantity INTEGER NOT NULL,raw_quantity INTEGER NOT NULL,custom_value NUMERIC NULL)"
  17. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_items_corp_asset_lists_index ON corp_items(asset_list_id)"
  18. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS conquerable_stations (id INTEGER PRIMARY KEY,name TEXT NOT NULL,solar_system_id INTEGER NOT NULL)"
  19. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS conquerable_stations_solar_system ON conquerable_stations(solar_system_id)"
  20. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS wallet_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,balance DOUBLE NOT NULL)"
  21. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_snapshots_characters_index ON wallet_snapshots(character_id)"
  22. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_snapshots_timestamp ON wallet_snapshots(timestamp)"
  23. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS wallet_snapshots_character_timestamp ON wallet_snapshots(character_id, timestamp)"
  24. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS corp_wallet_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,corporation_id BIGINT NOT NULL,balance DOUBLE NOT NULL)"
  25. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_snapshots_timestamp ON corp_wallet_snapshots(timestamp)"
  26. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_wallet_snapshots_corporation_timestamp ON corp_wallet_snapshots(corporation_id, timestamp)"
  27. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS asset_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,balance DOUBLE NOT NULL)"
  28. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS asset_value_snapshots_characters_index ON asset_value_snapshots(character_id)"
  29. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS asset_value_snapshots_timestamp ON asset_value_snapshots(timestamp)"
  30. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS asset_value_snapshots_character_timestamp ON asset_value_snapshots(character_id, timestamp)"
  31. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS corp_asset_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,corporation_id BIGINT NOT NULL,balance DOUBLE NOT NULL)"
  32. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_asset_value_snapshots_corporation_timestamp ON corp_asset_value_snapshots(corporation_id, timestamp)"
  33. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS wallet_journal (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,timestamp DATETIME NOT NULL,first_party_id BIGINT NULL,second_party_id BIGINT NULL,first_party_type TEXT NULL,second_party_type TEXT NULL,extra_info_id BIGINT NULL,amount NUMERIC NULL,balance NUMERIC NULL,reason TEXT NULL,tax_receiver_id BIGINT NULL,tax_amount NUMERIC NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL,extra_info_type TEXT NULL,ref_type TEXT NULL)"
  34. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_characters_index ON wallet_journal(character_id)"
  35. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_timestamp ON wallet_journal(timestamp)"
  36. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_character_timestamp ON wallet_journal(character_id, timestamp)"
  37. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_character_timestamp_amount ON wallet_journal(character_id, timestamp, amount)"
  38. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_corporation_timestamp ON wallet_journal(corporation_id, timestamp)"
  39. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_corporation_timestamp_amount ON wallet_journal(corporation_id, timestamp, amount)"
  40. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS corp_wallet_journal (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL ,timestamp DATETIME NOT NULL,first_party_id BIGINT NULL,second_party_id BIGINT NULL,first_party_type TEXT NULL,second_party_type TEXT NULL,extra_info_id BIGINT NULL,amount NUMERIC NULL,balance NUMERIC NULL,reason TEXT NULL,tax_receiver_id BIGINT NULL,tax_amount NUMERIC NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL,extra_info_type TEXT NULL,ref_type TEXT NULL)"
  41. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_characters_index ON corp_wallet_journal(character_id)"
  42. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_timestamp ON corp_wallet_journal(timestamp)"
  43. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_character_timestamp ON corp_wallet_journal(character_id, timestamp)"
  44. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_character_timestamp_amount ON corp_wallet_journal(character_id, timestamp, amount)"
  45. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_corporation_timestamp ON corp_wallet_journal(corporation_id, timestamp)"
  46. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_corporation_timestamp_amount ON corp_wallet_journal(corporation_id, timestamp, amount)"
  47. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS external_orders (id BIGINT PRIMARY KEY,type TINYINT NOT NULL,type_id INTEGER NOT NULL,location_id BIGINT NOT NULL,solar_system_id INTEGER NOT NULL,region_id INTEGER NOT NULL,range INTEGER NOT NULL,update_time DATETIME NOT NULL,value DOUBLE NOT NULL,volume_entered INTEGER NOT NULL,volume_remaining INTEGER NOT NULL,min_volume INTEGER NOT NULL,issued DATETIME NOT NULL,duration INTEGER NOT NULL)"
  48. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_id ON external_orders(type_id)"
  49. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_id_region ON external_orders(type_id, region_id)"
  50. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS external_orders_solar_system ON external_orders(solar_system_id)"
  51. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS external_orders_region ON external_orders(region_id)"
  52. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS external_orders_update_time ON external_orders(update_time)"
  53. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id ON external_orders(type, type_id)"
  54. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id_location ON external_orders(type, type_id, location_id)"
  55. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id_solar_system ON external_orders(type, type_id, solar_system_id)"
  56. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id_region ON external_orders(type, type_id, region_id)"
  57. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS cache_timers (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type TINYINT NOT NULL,cache_until DATETIME NOT NULL,UNIQUE (character_id, type))"
  58. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS cache_timers_characters_index ON cache_timers(character_id)"
  59. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS update_timers (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type TINYINT NOT NULL,update_time DATETIME NOT NULL,UNIQUE (character_id, type))"
  60. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS update_timers_characters_index ON update_timers(character_id)"
  61. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS wallet_transactions (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,timestamp DATETIME NOT NULL,quantity INTEGER NOT NULL,type_id INTEGER NOT NULL,price NUMERIC NOT NULL,client_id BIGINT NOT NULL,location_id BIGINT NOT NULL,type TINYINT NOT NULL,journal_id BIGINT NOT NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL)"
  62. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_characters_index ON wallet_transactions(character_id)"
  63. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_type_id ON wallet_transactions(type_id)"
  64. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_type_id_character ON wallet_transactions(type_id, character_id)"
  65. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_timestamp ON wallet_transactions(timestamp)"
  66. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_character_timestamp_type ON wallet_transactions(character_id, timestamp, type)"
  67. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_character_timestamp_type_type_id ON wallet_transactions(character_id, timestamp, type, type_id)"
  68. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_ignored_timestamp ON wallet_transactions(ignored, timestamp)"
  69. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_character_ignored_timestamp ON wallet_transactions(character_id, ignored, timestamp)"
  70. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_corporation_timestamp_type ON wallet_transactions(corporation_id, timestamp, type)"
  71. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_corporation_timestamp_type_type_id ON wallet_transactions(corporation_id, timestamp, type, type_id)"
  72. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_corporation_ignored_timestamp ON wallet_transactions(corporation_id, ignored, timestamp)"
  73. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE TABLE IF NOT EXISTS corp_wallet_transactions (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL ,timestamp DATETIME NOT NULL,quantity INTEGER NOT NULL,type_id INTEGER NOT NULL,price NUMERIC NOT NULL,client_id BIGINT NOT NULL,location_id BIGINT NOT NULL,type TINYINT NOT NULL,journal_id BIGINT NOT NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL)"
  74. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_characters_index ON corp_wallet_transactions(character_id)"
  75. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_type_id ON corp_wallet_transactions(type_id)"
  76. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_type_id_character ON corp_wallet_transactions(type_id, character_id)"
  77. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_timestamp ON corp_wallet_transactions(timestamp)"
  78. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_character_timestamp_type ON corp_wallet_transactions(character_id, timestamp, type)"
  79. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_character_timestamp_type_type_id ON corp_wallet_transactions(character_id, timestamp, type, type_id)"
  80. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_ignored_timestamp ON corp_wallet_transactions(ignored, timestamp)"
  81. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_character_ignored_timestamp ON corp_wallet_transactions(character_id, ignored, timestamp)"
  82. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_corporation_timestamp_type ON corp_wallet_transactions(corporation_id, timestamp, type)"
  83. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_corporation_timestamp_type_type_id ON corp_wallet_transactions(corporation_id, timestamp, type, type_id)"
  84. [debug] 2018-04-10T21:48:00 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_corporation_ignored_timestamp ON corp_wallet_transactions(corporation_id, ignored, timestamp)"
  85. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS market_orders (id BIGINT PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,location_id INTEGER NOT NULL,volume_entered INTEGER NOT NULL,volume_remaining INTEGER NOT NULL,min_volume INTEGER NOT NULL,delta INTEGER NOT NULL DEFAULT 0,state TINYINT NOT NULL,type_id INTEGER NOT NULL,range INTEGER NOT NULL,account_key INTEGER NOT NULL,duration INTEGER NOT NULL,escrow NUMERIC NOT NULL,price NUMERIC NOT NULL,type TINYINT NOT NULL,issued DATETIME NOT NULL,first_seen DATETIME NOT NULL,last_seen DATETIME NULL,corporation_id BIGINT NOT NULL,notes TEXT NULL,custom_location_id INTEGER NULL,color_tag TEXT NULL)"
  86. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS market_orders_characters_index ON market_orders(character_id)"
  87. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS market_orders_state ON market_orders(state)"
  88. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_state ON market_orders(character_id, state)"
  89. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_type ON market_orders(character_id, type)"
  90. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_last_seen ON market_orders(character_id, last_seen)"
  91. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS market_orders_last_seen ON market_orders(last_seen)"
  92. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS market_orders_first_seen_last_seen_state ON market_orders(first_seen, last_seen, state)"
  93. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_first_seen_last_seen_state ON market_orders(character_id, first_seen, last_seen, state)"
  94. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS market_orders_corporation_type ON market_orders(corporation_id, type)"
  95. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS market_orders_corporation_last_seen ON market_orders(corporation_id, last_seen)"
  96. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS market_orders_corporation_first_seen_last_seen_state ON market_orders(corporation_id, first_seen, last_seen, state)"
  97. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS corp_market_orders (id BIGINT PRIMARY KEY,character_id BIGINT NOT NULL ,location_id INTEGER NOT NULL,volume_entered INTEGER NOT NULL,volume_remaining INTEGER NOT NULL,min_volume INTEGER NOT NULL,delta INTEGER NOT NULL DEFAULT 0,state TINYINT NOT NULL,type_id INTEGER NOT NULL,range INTEGER NOT NULL,account_key INTEGER NOT NULL,duration INTEGER NOT NULL,escrow NUMERIC NOT NULL,price NUMERIC NOT NULL,type TINYINT NOT NULL,issued DATETIME NOT NULL,first_seen DATETIME NOT NULL,last_seen DATETIME NULL,corporation_id BIGINT NOT NULL,notes TEXT NULL,custom_location_id INTEGER NULL,color_tag TEXT NULL)"
  98. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_characters_index ON corp_market_orders(character_id)"
  99. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_state ON corp_market_orders(state)"
  100. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_state ON corp_market_orders(character_id, state)"
  101. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_type ON corp_market_orders(character_id, type)"
  102. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_last_seen ON corp_market_orders(character_id, last_seen)"
  103. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_last_seen ON corp_market_orders(last_seen)"
  104. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_first_seen_last_seen_state ON corp_market_orders(first_seen, last_seen, state)"
  105. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_first_seen_last_seen_state ON corp_market_orders(character_id, first_seen, last_seen, state)"
  106. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_corporation_type ON corp_market_orders(corporation_id, type)"
  107. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_corporation_last_seen ON corp_market_orders(corporation_id, last_seen)"
  108. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_corporation_first_seen_last_seen_state ON corp_market_orders(corporation_id, first_seen, last_seen, state)"
  109. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS item_costs (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,cost NUMERIC NOT NULL)"
  110. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS item_costs_characters_index ON item_costs(character_id)"
  111. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS item_costs_type ON item_costs(type_id)"
  112. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS item_costs_character_type ON item_costs(character_id, type_id)"
  113. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS market_order_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,buy_value DOUBLE NOT NULL,sell_value DOUBLE NOT NULL)"
  114. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS market_order_value_snapshots_characters_index ON market_order_value_snapshots(character_id)"
  115. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS market_order_value_snapshots_timestamp ON market_order_value_snapshots(timestamp)"
  116. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS market_order_value_snapshots_character_timestamp ON market_order_value_snapshots(character_id, timestamp)"
  117. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS corp_market_order_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,corporation_id BIGINT NOT NULL,buy_value DOUBLE NOT NULL,sell_value DOUBLE NOT NULL)"
  118. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_market_order_value_snapshots_corporation_timestamp ON corp_market_order_value_snapshots(corporation_id, timestamp)"
  119. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS filter_texts (id INTEGER PRIMARY KEY,text TEXT NOT NULL UNIQUE)"
  120. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS order_scripts (id TEXT PRIMARY KEY,code TEXT NOT NULL)"
  121. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS favorite_items (id INTEGER PRIMARY KEY)"
  122. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS location_bookmarks (id INTEGER PRIMARY KEY,region_id INTEGER NOT NULL,solar_system_id INTEGER NOT NULL,station_id BIGINT NOT NULL,UNIQUE (region_id, solar_system_id, station_id))"
  123. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS contracts (id BIGINT PRIMARY KEY,issuer_id BIGINT NOT NULL,issuer_corp_id BIGINT NOT NULL,assignee_id BIGINT NOT NULL,acceptor_id BIGINT NOT NULL,start_station_id INTEGER NOT NULL,end_station_id INTEGER NOT NULL,type TINYINT NOT NULL,status TINYINT NOT NULL,title TEXT NOT NULL,for_corp TINYINT NOT NULL,availability TINYINT NOT NULL,issued DATETIME NOT NULL,expired DATETIME NOT NULL,accepted DATETIME NULL,completed DATETIME NULL,num_days INTEGER NOT NULL,price DOUBLE NOT NULL,reward DOUBLE NOT NULL,collateral DOUBLE NOT NULL,buyout DOUBLE NOT NULL,volume DOUBLE NOT NULL)"
  124. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS contracts_issuer ON contracts(issuer_id)"
  125. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS contracts_issuer_corp ON contracts(issuer_corp_id)"
  126. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS contracts_assignee ON contracts(assignee_id)"
  127. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS corp_contracts (id BIGINT PRIMARY KEY,issuer_id BIGINT NOT NULL,issuer_corp_id BIGINT NOT NULL,assignee_id BIGINT NOT NULL,acceptor_id BIGINT NOT NULL,start_station_id INTEGER NOT NULL,end_station_id INTEGER NOT NULL,type TINYINT NOT NULL,status TINYINT NOT NULL,title TEXT NOT NULL,for_corp TINYINT NOT NULL,availability TINYINT NOT NULL,issued DATETIME NOT NULL,expired DATETIME NOT NULL,accepted DATETIME NULL,completed DATETIME NULL,num_days INTEGER NOT NULL,price DOUBLE NOT NULL,reward DOUBLE NOT NULL,collateral DOUBLE NOT NULL,buyout DOUBLE NOT NULL,volume DOUBLE NOT NULL)"
  128. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_contracts_issuer ON corp_contracts(issuer_id)"
  129. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_contracts_issuer_corp ON corp_contracts(issuer_corp_id)"
  130. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS corp_contracts_assignee ON corp_contracts(assignee_id)"
  131. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS contract_items (id BIGINT PRIMARY KEY,contract_id BIGINT NOT NULL REFERENCES contracts(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,quantity BIGINT NOT NULL,included TINYINT NOT NULL)"
  132. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS corp_contract_items (id BIGINT PRIMARY KEY,contract_id BIGINT NOT NULL REFERENCES corp_contracts(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,quantity BIGINT NOT NULL,included TINYINT NOT NULL)"
  133. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS lmeve_tasks (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,activity TEXT NOT NULL,runs INTEGER NULL,runs_done INTEGER NULL,runs_completed INTEGER NULL,jobs_done INTEGER NULL,jobs_success INTEGER NULL,jobs_completed INTEGER NULL)"
  134. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS lmeve_tasks_characters_index ON lmeve_tasks(character_id)"
  135. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS citadels (id INTEGER PRIMARY KEY,name TEXT NOT NULL,solar_system_id INTEGER NOT NULL,region_id INTEGER NOT NULL,x REAL NOT NULL,y REAL NOT NULL,z REAL NOT NULL,last_seen DATETIME NOT NULL,first_seen DATETIME NOT NULL,type_id INTEGER NOT NULL,public INTEGER NOT NULL,ignored INTEGER NOT NULL)"
  136. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS citadels_region ON citadels(region_id)"
  137. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS region_type_presets (name TEXT PRIMARY KEY,types BLOB NOT NULL,regions BLOB NOT NULL)"
  138. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS region_station_presets (name TEXT PRIMARY KEY,src_station_id BIGINT NULL,dst_station_id BIGINT NULL,src_regions BLOB NOT NULL,dst_regions BLOB NOT NULL)"
  139. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS industry_manufacturing_setups (name TEXT PRIMARY KEY,data BLOB NOT NULL)"
  140. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE TABLE IF NOT EXISTS mining_ledger (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,date DATE NOT NULL,quantity INTEGER NOT NULL,solar_system_id INTEGER NOT NULL,type_id INTEGER NOT NULL)"
  141. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS mining_ledger_characters_index ON mining_ledger(character_id)"
  142. [debug] 2018-04-10T21:48:01 4660 SQL: "CREATE INDEX IF NOT EXISTS mining_ledger_character_date ON mining_ledger(character_id, date)"
  143. [debug] 2018-04-10T21:48:01 4660 Eve DB path: "C:/Games/evernus/x64/resources/eve.db"
  144. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT activityID FROM ramActivities WHERE activityName = ?"
  145. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT * FROM cache_timers"
  146. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT * FROM update_timers"
  147. [debug] 2018-04-10T21:48:01 4660 SQL: "DELETE FROM wallet_journal WHERE timestamp < ?"
  148. [debug] 2018-04-10T21:48:01 4660 SQL: "DELETE FROM wallet_transactions WHERE timestamp < ?"
  149. [debug] 2018-04-10T21:48:01 4660 SQL: "DELETE FROM market_orders WHERE last_seen < ?"
  150. [debug] 2018-04-10T21:48:01 4660 SQL: "DELETE FROM corp_market_orders WHERE last_seen < ?"
  151. [info] 2018-04-10T21:48:01 4660 Not updating core from 3.1
  152. [info] 2018-04-10T21:48:01 4660 Update db from 3.1
  153. [info] 2018-04-10T21:48:01 4660 No updates found.
  154. [info] 2018-04-10T21:48:01 4660 Checking for updates...
  155. [debug] 2018-04-10T21:48:01 4660 Fetching races
  156. [debug] 2018-04-10T21:48:01 4660 ESI request: QNetworkReplyHttpImpl(0x1640640af30) "/v1/universe/races/" : QMap()
  157. [debug] 2018-04-10T21:48:01 4660 Retries 3
  158. [debug] 2018-04-10T21:48:01 4660 Fetching bloodlines
  159. [debug] 2018-04-10T21:48:01 4660 ESI request: QNetworkReplyHttpImpl(0x1640640b250) "/v1/universe/bloodlines/" : QMap()
  160. [debug] 2018-04-10T21:48:01 4660 Retries 3
  161. [debug] 2018-04-10T21:48:01 4660 Fetching ancestries
  162. [debug] 2018-04-10T21:48:01 4660 ESI request: QNetworkReplyHttpImpl(0x1640640b430) "/v1/universe/ancestries/" : QMap()
  163. [debug] 2018-04-10T21:48:01 4660 Retries 3
  164. [warning] 2018-04-10T21:48:01 4660 QxtGlobalShortcut failed to unregister: ""
  165. [warning] 2018-04-10T21:48:01 4660 QxtGlobalShortcut failed to unregister: ""
  166. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  167. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  168. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  169. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  170. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  171. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  172. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  173. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  174. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  175. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  176. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  177. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  178. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  179. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  180. [debug] 2018-04-10T21:48:01 4660 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  181. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  182. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  183. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  184. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  185. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  186. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT solarSystemID, solarSystemName FROM mapSolarSystems WHERE regionID = ? ORDER BY solarSystemName"
  187. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  188. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  189. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  190. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  191. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  192. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  193. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  194. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  195. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  196. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  197. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  198. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  199. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  200. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  201. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  202. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  203. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  204. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT solarSystemID FROM mapDenormalize WHERE itemID = ?"
  205. [debug] 2018-04-10T21:48:02 4660 SQL: "SELECT * FROM citadels"
  206. [debug] 2018-04-10T21:48:03 4660 SQL: "SELECT * FROM invMarketGroups"
  207. [debug] 2018-04-10T21:48:03 4660 SQL: "SELECT * FROM invTypes WHERE published = 1 AND marketGroupID IS NOT NULL"
  208. [info] 2018-04-10T21:49:24 5172 "Windows 10 (10.0)"
  209. [info] 2018-04-10T21:49:24 5172 "Evernus" "3.1"
  210. [warning] 2018-04-10T21:49:24 5172 QWinEventNotifier: Can only be used with threads started with QThread
  211. [warning] 2018-04-10T21:49:24 5172 QSslSocket: cannot resolve SSL_set_alpn_protos
  212. [warning] 2018-04-10T21:49:24 5172 QSslSocket: cannot resolve SSL_CTX_set_alpn_select_cb
  213. [warning] 2018-04-10T21:49:24 5172 QSslSocket: cannot resolve SSL_get0_alpn_selected
  214. [debug] 2018-04-10T21:49:24 5172 Switching language to "en_US"
  215. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS characters (id BIGINT PRIMARY KEY,name TEXT NOT NULL,corporation_name TEXT NOT NULL,corporation_id BIGINT NOT NULL,race TEXT NOT NULL,bloodline TEXT NOT NULL,ancestry TEXT NOT NULL,gender TEXT NOT NULL,isk DOUBLE NOT NULL,corp_standing FLOAT NOT NULL,faction_standing FLOAT NOT NULL,trade_skill TINYINT NOT NULL,retail_skill TINYINT NOT NULL,wholesale_skill TINYINT NOT NULL,tycoon_skill TINYINT NOT NULL,marketing_skill TINYINT NOT NULL,procurement_skill TINYINT NOT NULL,daytrading_skill TINYINT NOT NULL,visibility_skill TINYINT NOT NULL,accounting_skill TINYINT NOT NULL,broker_relations_skill TINYINT NOT NULL,margin_trading_skill TINYINT NOT NULL,contracting_skill TINYINT NOT NULL,corporation_contracting_skill TINYINT NOT NULL,enabled TINYINT NOT NULL,brokers_fee FLOAT NULL,sell_brokers_fee FLOAT NULL,reprocessing_implant_bonus FLOAT NOT NULL,arkonor_processing TINYINT NOT NULL,bistot_processing TINYINT NOT NULL,crokite_processing TINYINT NOT NULL,dark_ochre_processing TINYINT NOT NULL,gneiss_processing TINYINT NOT NULL,hedbergite_processing TINYINT NOT NULL,hemorphite_processing TINYINT NOT NULL,ice_processing TINYINT NOT NULL,jaspet_processing TINYINT NOT NULL,kernite_processing TINYINT NOT NULL,mercoxit_processing TINYINT NOT NULL,omber_processing TINYINT NOT NULL,plagioclase_processing TINYINT NOT NULL,pyroxeres_processing TINYINT NOT NULL,reprocessing TINYINT NOT NULL,reprocessing_efficiency TINYINT NOT NULL,scordite_processing TINYINT NOT NULL,scrapmetal_processing TINYINT NOT NULL,spodumain_processing TINYINT NOT NULL,veldspar_processing TINYINT NOT NULL,manufacturing_time_implant_bonus FLOAT NOT NULL,industry TINYINT NOT NULL,advanced_industry TINYINT NOT NULL,advanced_small_ship_construction TINYINT NOT NULL,advanced_medium_ship_construction TINYINT NOT NULL,advanced_large_ship_construction TINYINT NOT NULL,avanced_industrial_ship_construction TINYINT NOT NULL,amarr_starship_engineering TINYINT NOT NULL,caldari_starship_engineering TINYINT NOT NULL,gallente_starship_engineering TINYINT NOT NULL,minmatar_starship_engineering TINYINT NOT NULL,electromagnetic_physics TINYINT NOT NULL,electronic_engineering TINYINT NOT NULL,graviton_physics TINYINT NOT NULL,high_energy_physics TINYINT NOT NULL,hydromagnetic_physics TINYINT NOT NULL,laser_physics TINYINT NOT NULL,mechanical_engineering TINYINT NOT NULL,molecular_engineering TINYINT NOT NULL,nuclear_physics TINYINT NOT NULL,plasma_physics TINYINT NOT NULL,quantum_physics TINYINT NOT NULL,rocket_science TINYINT NOT NULL,alpha_clone TINYINT NOT NULL)"
  216. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS asset_lists (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE)"
  217. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS asset_lists_characters_index ON asset_lists(character_id)"
  218. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS corp_asset_lists (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE)"
  219. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_asset_lists_characters_index ON corp_asset_lists(character_id)"
  220. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS items (id INTEGER PRIMARY KEY,asset_list_id INTEGER NOT NULL REFERENCES asset_lists(id) ON UPDATE CASCADE ON DELETE CASCADE,parent_id BIGINT NULL REFERENCES items(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,location_id BIGINT NULL,quantity INTEGER NOT NULL,raw_quantity INTEGER NOT NULL,custom_value NUMERIC NULL)"
  221. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS items_asset_lists_index ON items(asset_list_id)"
  222. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS corp_items (id INTEGER PRIMARY KEY,asset_list_id INTEGER NOT NULL REFERENCES corp_asset_lists(id) ON UPDATE CASCADE ON DELETE CASCADE,parent_id BIGINT NULL REFERENCES corp_items(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,location_id BIGINT NULL,quantity INTEGER NOT NULL,raw_quantity INTEGER NOT NULL,custom_value NUMERIC NULL)"
  223. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_items_corp_asset_lists_index ON corp_items(asset_list_id)"
  224. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS conquerable_stations (id INTEGER PRIMARY KEY,name TEXT NOT NULL,solar_system_id INTEGER NOT NULL)"
  225. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS conquerable_stations_solar_system ON conquerable_stations(solar_system_id)"
  226. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS wallet_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,balance DOUBLE NOT NULL)"
  227. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_snapshots_characters_index ON wallet_snapshots(character_id)"
  228. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_snapshots_timestamp ON wallet_snapshots(timestamp)"
  229. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS wallet_snapshots_character_timestamp ON wallet_snapshots(character_id, timestamp)"
  230. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS corp_wallet_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,corporation_id BIGINT NOT NULL,balance DOUBLE NOT NULL)"
  231. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_snapshots_timestamp ON corp_wallet_snapshots(timestamp)"
  232. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_wallet_snapshots_corporation_timestamp ON corp_wallet_snapshots(corporation_id, timestamp)"
  233. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS asset_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,balance DOUBLE NOT NULL)"
  234. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS asset_value_snapshots_characters_index ON asset_value_snapshots(character_id)"
  235. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS asset_value_snapshots_timestamp ON asset_value_snapshots(timestamp)"
  236. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS asset_value_snapshots_character_timestamp ON asset_value_snapshots(character_id, timestamp)"
  237. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS corp_asset_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,corporation_id BIGINT NOT NULL,balance DOUBLE NOT NULL)"
  238. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_asset_value_snapshots_corporation_timestamp ON corp_asset_value_snapshots(corporation_id, timestamp)"
  239. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS wallet_journal (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,timestamp DATETIME NOT NULL,first_party_id BIGINT NULL,second_party_id BIGINT NULL,first_party_type TEXT NULL,second_party_type TEXT NULL,extra_info_id BIGINT NULL,amount NUMERIC NULL,balance NUMERIC NULL,reason TEXT NULL,tax_receiver_id BIGINT NULL,tax_amount NUMERIC NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL,extra_info_type TEXT NULL,ref_type TEXT NULL)"
  240. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_characters_index ON wallet_journal(character_id)"
  241. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_timestamp ON wallet_journal(timestamp)"
  242. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_character_timestamp ON wallet_journal(character_id, timestamp)"
  243. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_character_timestamp_amount ON wallet_journal(character_id, timestamp, amount)"
  244. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_corporation_timestamp ON wallet_journal(corporation_id, timestamp)"
  245. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_corporation_timestamp_amount ON wallet_journal(corporation_id, timestamp, amount)"
  246. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS corp_wallet_journal (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL ,timestamp DATETIME NOT NULL,first_party_id BIGINT NULL,second_party_id BIGINT NULL,first_party_type TEXT NULL,second_party_type TEXT NULL,extra_info_id BIGINT NULL,amount NUMERIC NULL,balance NUMERIC NULL,reason TEXT NULL,tax_receiver_id BIGINT NULL,tax_amount NUMERIC NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL,extra_info_type TEXT NULL,ref_type TEXT NULL)"
  247. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_characters_index ON corp_wallet_journal(character_id)"
  248. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_timestamp ON corp_wallet_journal(timestamp)"
  249. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_character_timestamp ON corp_wallet_journal(character_id, timestamp)"
  250. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_character_timestamp_amount ON corp_wallet_journal(character_id, timestamp, amount)"
  251. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_corporation_timestamp ON corp_wallet_journal(corporation_id, timestamp)"
  252. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_corporation_timestamp_amount ON corp_wallet_journal(corporation_id, timestamp, amount)"
  253. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS external_orders (id BIGINT PRIMARY KEY,type TINYINT NOT NULL,type_id INTEGER NOT NULL,location_id BIGINT NOT NULL,solar_system_id INTEGER NOT NULL,region_id INTEGER NOT NULL,range INTEGER NOT NULL,update_time DATETIME NOT NULL,value DOUBLE NOT NULL,volume_entered INTEGER NOT NULL,volume_remaining INTEGER NOT NULL,min_volume INTEGER NOT NULL,issued DATETIME NOT NULL,duration INTEGER NOT NULL)"
  254. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_id ON external_orders(type_id)"
  255. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_id_region ON external_orders(type_id, region_id)"
  256. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS external_orders_solar_system ON external_orders(solar_system_id)"
  257. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS external_orders_region ON external_orders(region_id)"
  258. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS external_orders_update_time ON external_orders(update_time)"
  259. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id ON external_orders(type, type_id)"
  260. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id_location ON external_orders(type, type_id, location_id)"
  261. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id_solar_system ON external_orders(type, type_id, solar_system_id)"
  262. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id_region ON external_orders(type, type_id, region_id)"
  263. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS cache_timers (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type TINYINT NOT NULL,cache_until DATETIME NOT NULL,UNIQUE (character_id, type))"
  264. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS cache_timers_characters_index ON cache_timers(character_id)"
  265. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS update_timers (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type TINYINT NOT NULL,update_time DATETIME NOT NULL,UNIQUE (character_id, type))"
  266. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS update_timers_characters_index ON update_timers(character_id)"
  267. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS wallet_transactions (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,timestamp DATETIME NOT NULL,quantity INTEGER NOT NULL,type_id INTEGER NOT NULL,price NUMERIC NOT NULL,client_id BIGINT NOT NULL,location_id BIGINT NOT NULL,type TINYINT NOT NULL,journal_id BIGINT NOT NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL)"
  268. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_characters_index ON wallet_transactions(character_id)"
  269. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_type_id ON wallet_transactions(type_id)"
  270. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_type_id_character ON wallet_transactions(type_id, character_id)"
  271. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_timestamp ON wallet_transactions(timestamp)"
  272. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_character_timestamp_type ON wallet_transactions(character_id, timestamp, type)"
  273. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_character_timestamp_type_type_id ON wallet_transactions(character_id, timestamp, type, type_id)"
  274. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_ignored_timestamp ON wallet_transactions(ignored, timestamp)"
  275. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_character_ignored_timestamp ON wallet_transactions(character_id, ignored, timestamp)"
  276. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_corporation_timestamp_type ON wallet_transactions(corporation_id, timestamp, type)"
  277. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_corporation_timestamp_type_type_id ON wallet_transactions(corporation_id, timestamp, type, type_id)"
  278. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_corporation_ignored_timestamp ON wallet_transactions(corporation_id, ignored, timestamp)"
  279. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS corp_wallet_transactions (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL ,timestamp DATETIME NOT NULL,quantity INTEGER NOT NULL,type_id INTEGER NOT NULL,price NUMERIC NOT NULL,client_id BIGINT NOT NULL,location_id BIGINT NOT NULL,type TINYINT NOT NULL,journal_id BIGINT NOT NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL)"
  280. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_characters_index ON corp_wallet_transactions(character_id)"
  281. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_type_id ON corp_wallet_transactions(type_id)"
  282. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_type_id_character ON corp_wallet_transactions(type_id, character_id)"
  283. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_timestamp ON corp_wallet_transactions(timestamp)"
  284. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_character_timestamp_type ON corp_wallet_transactions(character_id, timestamp, type)"
  285. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_character_timestamp_type_type_id ON corp_wallet_transactions(character_id, timestamp, type, type_id)"
  286. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_ignored_timestamp ON corp_wallet_transactions(ignored, timestamp)"
  287. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_character_ignored_timestamp ON corp_wallet_transactions(character_id, ignored, timestamp)"
  288. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_corporation_timestamp_type ON corp_wallet_transactions(corporation_id, timestamp, type)"
  289. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_corporation_timestamp_type_type_id ON corp_wallet_transactions(corporation_id, timestamp, type, type_id)"
  290. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_corporation_ignored_timestamp ON corp_wallet_transactions(corporation_id, ignored, timestamp)"
  291. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS market_orders (id BIGINT PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,location_id INTEGER NOT NULL,volume_entered INTEGER NOT NULL,volume_remaining INTEGER NOT NULL,min_volume INTEGER NOT NULL,delta INTEGER NOT NULL DEFAULT 0,state TINYINT NOT NULL,type_id INTEGER NOT NULL,range INTEGER NOT NULL,account_key INTEGER NOT NULL,duration INTEGER NOT NULL,escrow NUMERIC NOT NULL,price NUMERIC NOT NULL,type TINYINT NOT NULL,issued DATETIME NOT NULL,first_seen DATETIME NOT NULL,last_seen DATETIME NULL,corporation_id BIGINT NOT NULL,notes TEXT NULL,custom_location_id INTEGER NULL,color_tag TEXT NULL)"
  292. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS market_orders_characters_index ON market_orders(character_id)"
  293. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS market_orders_state ON market_orders(state)"
  294. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_state ON market_orders(character_id, state)"
  295. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_type ON market_orders(character_id, type)"
  296. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_last_seen ON market_orders(character_id, last_seen)"
  297. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS market_orders_last_seen ON market_orders(last_seen)"
  298. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS market_orders_first_seen_last_seen_state ON market_orders(first_seen, last_seen, state)"
  299. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_first_seen_last_seen_state ON market_orders(character_id, first_seen, last_seen, state)"
  300. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS market_orders_corporation_type ON market_orders(corporation_id, type)"
  301. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS market_orders_corporation_last_seen ON market_orders(corporation_id, last_seen)"
  302. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS market_orders_corporation_first_seen_last_seen_state ON market_orders(corporation_id, first_seen, last_seen, state)"
  303. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS corp_market_orders (id BIGINT PRIMARY KEY,character_id BIGINT NOT NULL ,location_id INTEGER NOT NULL,volume_entered INTEGER NOT NULL,volume_remaining INTEGER NOT NULL,min_volume INTEGER NOT NULL,delta INTEGER NOT NULL DEFAULT 0,state TINYINT NOT NULL,type_id INTEGER NOT NULL,range INTEGER NOT NULL,account_key INTEGER NOT NULL,duration INTEGER NOT NULL,escrow NUMERIC NOT NULL,price NUMERIC NOT NULL,type TINYINT NOT NULL,issued DATETIME NOT NULL,first_seen DATETIME NOT NULL,last_seen DATETIME NULL,corporation_id BIGINT NOT NULL,notes TEXT NULL,custom_location_id INTEGER NULL,color_tag TEXT NULL)"
  304. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_characters_index ON corp_market_orders(character_id)"
  305. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_state ON corp_market_orders(state)"
  306. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_state ON corp_market_orders(character_id, state)"
  307. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_type ON corp_market_orders(character_id, type)"
  308. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_last_seen ON corp_market_orders(character_id, last_seen)"
  309. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_last_seen ON corp_market_orders(last_seen)"
  310. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_first_seen_last_seen_state ON corp_market_orders(first_seen, last_seen, state)"
  311. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_first_seen_last_seen_state ON corp_market_orders(character_id, first_seen, last_seen, state)"
  312. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_corporation_type ON corp_market_orders(corporation_id, type)"
  313. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_corporation_last_seen ON corp_market_orders(corporation_id, last_seen)"
  314. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_corporation_first_seen_last_seen_state ON corp_market_orders(corporation_id, first_seen, last_seen, state)"
  315. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS item_costs (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,cost NUMERIC NOT NULL)"
  316. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS item_costs_characters_index ON item_costs(character_id)"
  317. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS item_costs_type ON item_costs(type_id)"
  318. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS item_costs_character_type ON item_costs(character_id, type_id)"
  319. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS market_order_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,buy_value DOUBLE NOT NULL,sell_value DOUBLE NOT NULL)"
  320. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS market_order_value_snapshots_characters_index ON market_order_value_snapshots(character_id)"
  321. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS market_order_value_snapshots_timestamp ON market_order_value_snapshots(timestamp)"
  322. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS market_order_value_snapshots_character_timestamp ON market_order_value_snapshots(character_id, timestamp)"
  323. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS corp_market_order_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,corporation_id BIGINT NOT NULL,buy_value DOUBLE NOT NULL,sell_value DOUBLE NOT NULL)"
  324. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_market_order_value_snapshots_corporation_timestamp ON corp_market_order_value_snapshots(corporation_id, timestamp)"
  325. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS filter_texts (id INTEGER PRIMARY KEY,text TEXT NOT NULL UNIQUE)"
  326. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS order_scripts (id TEXT PRIMARY KEY,code TEXT NOT NULL)"
  327. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS favorite_items (id INTEGER PRIMARY KEY)"
  328. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS location_bookmarks (id INTEGER PRIMARY KEY,region_id INTEGER NOT NULL,solar_system_id INTEGER NOT NULL,station_id BIGINT NOT NULL,UNIQUE (region_id, solar_system_id, station_id))"
  329. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS contracts (id BIGINT PRIMARY KEY,issuer_id BIGINT NOT NULL,issuer_corp_id BIGINT NOT NULL,assignee_id BIGINT NOT NULL,acceptor_id BIGINT NOT NULL,start_station_id INTEGER NOT NULL,end_station_id INTEGER NOT NULL,type TINYINT NOT NULL,status TINYINT NOT NULL,title TEXT NOT NULL,for_corp TINYINT NOT NULL,availability TINYINT NOT NULL,issued DATETIME NOT NULL,expired DATETIME NOT NULL,accepted DATETIME NULL,completed DATETIME NULL,num_days INTEGER NOT NULL,price DOUBLE NOT NULL,reward DOUBLE NOT NULL,collateral DOUBLE NOT NULL,buyout DOUBLE NOT NULL,volume DOUBLE NOT NULL)"
  330. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS contracts_issuer ON contracts(issuer_id)"
  331. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS contracts_issuer_corp ON contracts(issuer_corp_id)"
  332. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS contracts_assignee ON contracts(assignee_id)"
  333. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS corp_contracts (id BIGINT PRIMARY KEY,issuer_id BIGINT NOT NULL,issuer_corp_id BIGINT NOT NULL,assignee_id BIGINT NOT NULL,acceptor_id BIGINT NOT NULL,start_station_id INTEGER NOT NULL,end_station_id INTEGER NOT NULL,type TINYINT NOT NULL,status TINYINT NOT NULL,title TEXT NOT NULL,for_corp TINYINT NOT NULL,availability TINYINT NOT NULL,issued DATETIME NOT NULL,expired DATETIME NOT NULL,accepted DATETIME NULL,completed DATETIME NULL,num_days INTEGER NOT NULL,price DOUBLE NOT NULL,reward DOUBLE NOT NULL,collateral DOUBLE NOT NULL,buyout DOUBLE NOT NULL,volume DOUBLE NOT NULL)"
  334. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_contracts_issuer ON corp_contracts(issuer_id)"
  335. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_contracts_issuer_corp ON corp_contracts(issuer_corp_id)"
  336. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS corp_contracts_assignee ON corp_contracts(assignee_id)"
  337. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS contract_items (id BIGINT PRIMARY KEY,contract_id BIGINT NOT NULL REFERENCES contracts(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,quantity BIGINT NOT NULL,included TINYINT NOT NULL)"
  338. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS corp_contract_items (id BIGINT PRIMARY KEY,contract_id BIGINT NOT NULL REFERENCES corp_contracts(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,quantity BIGINT NOT NULL,included TINYINT NOT NULL)"
  339. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS lmeve_tasks (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,activity TEXT NOT NULL,runs INTEGER NULL,runs_done INTEGER NULL,runs_completed INTEGER NULL,jobs_done INTEGER NULL,jobs_success INTEGER NULL,jobs_completed INTEGER NULL)"
  340. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS lmeve_tasks_characters_index ON lmeve_tasks(character_id)"
  341. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS citadels (id INTEGER PRIMARY KEY,name TEXT NOT NULL,solar_system_id INTEGER NOT NULL,region_id INTEGER NOT NULL,x REAL NOT NULL,y REAL NOT NULL,z REAL NOT NULL,last_seen DATETIME NOT NULL,first_seen DATETIME NOT NULL,type_id INTEGER NOT NULL,public INTEGER NOT NULL,ignored INTEGER NOT NULL)"
  342. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS citadels_region ON citadels(region_id)"
  343. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS region_type_presets (name TEXT PRIMARY KEY,types BLOB NOT NULL,regions BLOB NOT NULL)"
  344. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS region_station_presets (name TEXT PRIMARY KEY,src_station_id BIGINT NULL,dst_station_id BIGINT NULL,src_regions BLOB NOT NULL,dst_regions BLOB NOT NULL)"
  345. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS industry_manufacturing_setups (name TEXT PRIMARY KEY,data BLOB NOT NULL)"
  346. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE TABLE IF NOT EXISTS mining_ledger (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,date DATE NOT NULL,quantity INTEGER NOT NULL,solar_system_id INTEGER NOT NULL,type_id INTEGER NOT NULL)"
  347. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS mining_ledger_characters_index ON mining_ledger(character_id)"
  348. [debug] 2018-04-10T21:49:24 5172 SQL: "CREATE INDEX IF NOT EXISTS mining_ledger_character_date ON mining_ledger(character_id, date)"
  349. [debug] 2018-04-10T21:49:24 5172 Eve DB path: "C:/Games/evernus/x64/resources/eve.db"
  350. [debug] 2018-04-10T21:49:24 5172 SQL: "SELECT activityID FROM ramActivities WHERE activityName = ?"
  351. [debug] 2018-04-10T21:49:24 5172 SQL: "SELECT * FROM cache_timers"
  352. [debug] 2018-04-10T21:49:24 5172 SQL: "SELECT * FROM update_timers"
  353. [debug] 2018-04-10T21:49:24 5172 SQL: "DELETE FROM wallet_journal WHERE timestamp < ?"
  354. [debug] 2018-04-10T21:49:24 5172 SQL: "DELETE FROM wallet_transactions WHERE timestamp < ?"
  355. [debug] 2018-04-10T21:49:24 5172 SQL: "DELETE FROM market_orders WHERE last_seen < ?"
  356. [debug] 2018-04-10T21:49:24 5172 SQL: "DELETE FROM corp_market_orders WHERE last_seen < ?"
  357. [info] 2018-04-10T21:49:24 5172 Not updating core from 3.1
  358. [info] 2018-04-10T21:49:24 5172 Update db from 3.1
  359. [info] 2018-04-10T21:49:24 5172 No updates found.
  360. [info] 2018-04-10T21:49:24 5172 Checking for updates...
  361. [debug] 2018-04-10T21:49:24 5172 Fetching races
  362. [debug] 2018-04-10T21:49:24 5172 ESI request: QNetworkReplyHttpImpl(0x1e05555a580) "/v1/universe/races/" : QMap()
  363. [debug] 2018-04-10T21:49:24 5172 Retries 3
  364. [debug] 2018-04-10T21:49:24 5172 Fetching bloodlines
  365. [debug] 2018-04-10T21:49:24 5172 ESI request: QNetworkReplyHttpImpl(0x1e0555b31b0) "/v1/universe/bloodlines/" : QMap()
  366. [debug] 2018-04-10T21:49:24 5172 Retries 3
  367. [debug] 2018-04-10T21:49:24 5172 Fetching ancestries
  368. [debug] 2018-04-10T21:49:24 5172 ESI request: QNetworkReplyHttpImpl(0x1e0555b8b40) "/v1/universe/ancestries/" : QMap()
  369. [debug] 2018-04-10T21:49:24 5172 Retries 3
  370. [warning] 2018-04-10T21:49:24 5172 QxtGlobalShortcut failed to unregister: ""
  371. [warning] 2018-04-10T21:49:24 5172 QxtGlobalShortcut failed to unregister: ""
  372. [debug] 2018-04-10T21:49:24 5172 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  373. [debug] 2018-04-10T21:49:24 5172 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  374. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  375. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  376. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  377. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  378. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  379. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  380. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  381. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  382. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  383. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  384. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  385. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  386. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  387. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  388. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  389. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  390. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  391. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  392. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT solarSystemID, solarSystemName FROM mapSolarSystems WHERE regionID = ? ORDER BY solarSystemName"
  393. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  394. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  395. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  396. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  397. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  398. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  399. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  400. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  401. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  402. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  403. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  404. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  405. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  406. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  407. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  408. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  409. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  410. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT solarSystemID FROM mapDenormalize WHERE itemID = ?"
  411. [debug] 2018-04-10T21:49:25 5172 SQL: "SELECT * FROM citadels"
  412. [debug] 2018-04-10T21:49:26 5172 SQL: "SELECT * FROM invMarketGroups"
  413. [debug] 2018-04-10T21:49:26 5172 SQL: "SELECT * FROM invTypes WHERE published = 1 AND marketGroupID IS NOT NULL"
  414. [info] 2018-04-11T06:09:48 1548 "Windows 10 (10.0)"
  415. [info] 2018-04-11T06:09:48 1548 "Evernus" "3.1"
  416. [warning] 2018-04-11T06:09:48 1548 QWinEventNotifier: Can only be used with threads started with QThread
  417. [warning] 2018-04-11T06:09:48 1548 QSslSocket: cannot resolve SSL_set_alpn_protos
  418. [warning] 2018-04-11T06:09:48 1548 QSslSocket: cannot resolve SSL_CTX_set_alpn_select_cb
  419. [warning] 2018-04-11T06:09:48 1548 QSslSocket: cannot resolve SSL_get0_alpn_selected
  420. [debug] 2018-04-11T06:09:48 1548 Switching language to "en_US"
  421. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS characters (id BIGINT PRIMARY KEY,name TEXT NOT NULL,corporation_name TEXT NOT NULL,corporation_id BIGINT NOT NULL,race TEXT NOT NULL,bloodline TEXT NOT NULL,ancestry TEXT NOT NULL,gender TEXT NOT NULL,isk DOUBLE NOT NULL,corp_standing FLOAT NOT NULL,faction_standing FLOAT NOT NULL,trade_skill TINYINT NOT NULL,retail_skill TINYINT NOT NULL,wholesale_skill TINYINT NOT NULL,tycoon_skill TINYINT NOT NULL,marketing_skill TINYINT NOT NULL,procurement_skill TINYINT NOT NULL,daytrading_skill TINYINT NOT NULL,visibility_skill TINYINT NOT NULL,accounting_skill TINYINT NOT NULL,broker_relations_skill TINYINT NOT NULL,margin_trading_skill TINYINT NOT NULL,contracting_skill TINYINT NOT NULL,corporation_contracting_skill TINYINT NOT NULL,enabled TINYINT NOT NULL,brokers_fee FLOAT NULL,sell_brokers_fee FLOAT NULL,reprocessing_implant_bonus FLOAT NOT NULL,arkonor_processing TINYINT NOT NULL,bistot_processing TINYINT NOT NULL,crokite_processing TINYINT NOT NULL,dark_ochre_processing TINYINT NOT NULL,gneiss_processing TINYINT NOT NULL,hedbergite_processing TINYINT NOT NULL,hemorphite_processing TINYINT NOT NULL,ice_processing TINYINT NOT NULL,jaspet_processing TINYINT NOT NULL,kernite_processing TINYINT NOT NULL,mercoxit_processing TINYINT NOT NULL,omber_processing TINYINT NOT NULL,plagioclase_processing TINYINT NOT NULL,pyroxeres_processing TINYINT NOT NULL,reprocessing TINYINT NOT NULL,reprocessing_efficiency TINYINT NOT NULL,scordite_processing TINYINT NOT NULL,scrapmetal_processing TINYINT NOT NULL,spodumain_processing TINYINT NOT NULL,veldspar_processing TINYINT NOT NULL,manufacturing_time_implant_bonus FLOAT NOT NULL,industry TINYINT NOT NULL,advanced_industry TINYINT NOT NULL,advanced_small_ship_construction TINYINT NOT NULL,advanced_medium_ship_construction TINYINT NOT NULL,advanced_large_ship_construction TINYINT NOT NULL,avanced_industrial_ship_construction TINYINT NOT NULL,amarr_starship_engineering TINYINT NOT NULL,caldari_starship_engineering TINYINT NOT NULL,gallente_starship_engineering TINYINT NOT NULL,minmatar_starship_engineering TINYINT NOT NULL,electromagnetic_physics TINYINT NOT NULL,electronic_engineering TINYINT NOT NULL,graviton_physics TINYINT NOT NULL,high_energy_physics TINYINT NOT NULL,hydromagnetic_physics TINYINT NOT NULL,laser_physics TINYINT NOT NULL,mechanical_engineering TINYINT NOT NULL,molecular_engineering TINYINT NOT NULL,nuclear_physics TINYINT NOT NULL,plasma_physics TINYINT NOT NULL,quantum_physics TINYINT NOT NULL,rocket_science TINYINT NOT NULL,alpha_clone TINYINT NOT NULL)"
  422. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS asset_lists (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE)"
  423. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS asset_lists_characters_index ON asset_lists(character_id)"
  424. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS corp_asset_lists (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE)"
  425. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_asset_lists_characters_index ON corp_asset_lists(character_id)"
  426. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS items (id INTEGER PRIMARY KEY,asset_list_id INTEGER NOT NULL REFERENCES asset_lists(id) ON UPDATE CASCADE ON DELETE CASCADE,parent_id BIGINT NULL REFERENCES items(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,location_id BIGINT NULL,quantity INTEGER NOT NULL,raw_quantity INTEGER NOT NULL,custom_value NUMERIC NULL)"
  427. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS items_asset_lists_index ON items(asset_list_id)"
  428. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS corp_items (id INTEGER PRIMARY KEY,asset_list_id INTEGER NOT NULL REFERENCES corp_asset_lists(id) ON UPDATE CASCADE ON DELETE CASCADE,parent_id BIGINT NULL REFERENCES corp_items(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,location_id BIGINT NULL,quantity INTEGER NOT NULL,raw_quantity INTEGER NOT NULL,custom_value NUMERIC NULL)"
  429. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_items_corp_asset_lists_index ON corp_items(asset_list_id)"
  430. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS conquerable_stations (id INTEGER PRIMARY KEY,name TEXT NOT NULL,solar_system_id INTEGER NOT NULL)"
  431. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS conquerable_stations_solar_system ON conquerable_stations(solar_system_id)"
  432. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS wallet_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,balance DOUBLE NOT NULL)"
  433. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_snapshots_characters_index ON wallet_snapshots(character_id)"
  434. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_snapshots_timestamp ON wallet_snapshots(timestamp)"
  435. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS wallet_snapshots_character_timestamp ON wallet_snapshots(character_id, timestamp)"
  436. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS corp_wallet_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,corporation_id BIGINT NOT NULL,balance DOUBLE NOT NULL)"
  437. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_snapshots_timestamp ON corp_wallet_snapshots(timestamp)"
  438. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_wallet_snapshots_corporation_timestamp ON corp_wallet_snapshots(corporation_id, timestamp)"
  439. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS asset_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,balance DOUBLE NOT NULL)"
  440. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS asset_value_snapshots_characters_index ON asset_value_snapshots(character_id)"
  441. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS asset_value_snapshots_timestamp ON asset_value_snapshots(timestamp)"
  442. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS asset_value_snapshots_character_timestamp ON asset_value_snapshots(character_id, timestamp)"
  443. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS corp_asset_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,corporation_id BIGINT NOT NULL,balance DOUBLE NOT NULL)"
  444. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_asset_value_snapshots_corporation_timestamp ON corp_asset_value_snapshots(corporation_id, timestamp)"
  445. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS wallet_journal (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,timestamp DATETIME NOT NULL,first_party_id BIGINT NULL,second_party_id BIGINT NULL,first_party_type TEXT NULL,second_party_type TEXT NULL,extra_info_id BIGINT NULL,amount NUMERIC NULL,balance NUMERIC NULL,reason TEXT NULL,tax_receiver_id BIGINT NULL,tax_amount NUMERIC NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL,extra_info_type TEXT NULL,ref_type TEXT NULL)"
  446. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_characters_index ON wallet_journal(character_id)"
  447. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_timestamp ON wallet_journal(timestamp)"
  448. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_character_timestamp ON wallet_journal(character_id, timestamp)"
  449. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_character_timestamp_amount ON wallet_journal(character_id, timestamp, amount)"
  450. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_corporation_timestamp ON wallet_journal(corporation_id, timestamp)"
  451. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_corporation_timestamp_amount ON wallet_journal(corporation_id, timestamp, amount)"
  452. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS corp_wallet_journal (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL ,timestamp DATETIME NOT NULL,first_party_id BIGINT NULL,second_party_id BIGINT NULL,first_party_type TEXT NULL,second_party_type TEXT NULL,extra_info_id BIGINT NULL,amount NUMERIC NULL,balance NUMERIC NULL,reason TEXT NULL,tax_receiver_id BIGINT NULL,tax_amount NUMERIC NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL,extra_info_type TEXT NULL,ref_type TEXT NULL)"
  453. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_characters_index ON corp_wallet_journal(character_id)"
  454. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_timestamp ON corp_wallet_journal(timestamp)"
  455. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_character_timestamp ON corp_wallet_journal(character_id, timestamp)"
  456. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_character_timestamp_amount ON corp_wallet_journal(character_id, timestamp, amount)"
  457. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_corporation_timestamp ON corp_wallet_journal(corporation_id, timestamp)"
  458. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_corporation_timestamp_amount ON corp_wallet_journal(corporation_id, timestamp, amount)"
  459. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS external_orders (id BIGINT PRIMARY KEY,type TINYINT NOT NULL,type_id INTEGER NOT NULL,location_id BIGINT NOT NULL,solar_system_id INTEGER NOT NULL,region_id INTEGER NOT NULL,range INTEGER NOT NULL,update_time DATETIME NOT NULL,value DOUBLE NOT NULL,volume_entered INTEGER NOT NULL,volume_remaining INTEGER NOT NULL,min_volume INTEGER NOT NULL,issued DATETIME NOT NULL,duration INTEGER NOT NULL)"
  460. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_id ON external_orders(type_id)"
  461. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_id_region ON external_orders(type_id, region_id)"
  462. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS external_orders_solar_system ON external_orders(solar_system_id)"
  463. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS external_orders_region ON external_orders(region_id)"
  464. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS external_orders_update_time ON external_orders(update_time)"
  465. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id ON external_orders(type, type_id)"
  466. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id_location ON external_orders(type, type_id, location_id)"
  467. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id_solar_system ON external_orders(type, type_id, solar_system_id)"
  468. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id_region ON external_orders(type, type_id, region_id)"
  469. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS cache_timers (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type TINYINT NOT NULL,cache_until DATETIME NOT NULL,UNIQUE (character_id, type))"
  470. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS cache_timers_characters_index ON cache_timers(character_id)"
  471. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS update_timers (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type TINYINT NOT NULL,update_time DATETIME NOT NULL,UNIQUE (character_id, type))"
  472. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS update_timers_characters_index ON update_timers(character_id)"
  473. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS wallet_transactions (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,timestamp DATETIME NOT NULL,quantity INTEGER NOT NULL,type_id INTEGER NOT NULL,price NUMERIC NOT NULL,client_id BIGINT NOT NULL,location_id BIGINT NOT NULL,type TINYINT NOT NULL,journal_id BIGINT NOT NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL)"
  474. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_characters_index ON wallet_transactions(character_id)"
  475. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_type_id ON wallet_transactions(type_id)"
  476. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_type_id_character ON wallet_transactions(type_id, character_id)"
  477. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_timestamp ON wallet_transactions(timestamp)"
  478. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_character_timestamp_type ON wallet_transactions(character_id, timestamp, type)"
  479. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_character_timestamp_type_type_id ON wallet_transactions(character_id, timestamp, type, type_id)"
  480. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_ignored_timestamp ON wallet_transactions(ignored, timestamp)"
  481. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_character_ignored_timestamp ON wallet_transactions(character_id, ignored, timestamp)"
  482. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_corporation_timestamp_type ON wallet_transactions(corporation_id, timestamp, type)"
  483. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_corporation_timestamp_type_type_id ON wallet_transactions(corporation_id, timestamp, type, type_id)"
  484. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_corporation_ignored_timestamp ON wallet_transactions(corporation_id, ignored, timestamp)"
  485. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS corp_wallet_transactions (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL ,timestamp DATETIME NOT NULL,quantity INTEGER NOT NULL,type_id INTEGER NOT NULL,price NUMERIC NOT NULL,client_id BIGINT NOT NULL,location_id BIGINT NOT NULL,type TINYINT NOT NULL,journal_id BIGINT NOT NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL)"
  486. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_characters_index ON corp_wallet_transactions(character_id)"
  487. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_type_id ON corp_wallet_transactions(type_id)"
  488. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_type_id_character ON corp_wallet_transactions(type_id, character_id)"
  489. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_timestamp ON corp_wallet_transactions(timestamp)"
  490. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_character_timestamp_type ON corp_wallet_transactions(character_id, timestamp, type)"
  491. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_character_timestamp_type_type_id ON corp_wallet_transactions(character_id, timestamp, type, type_id)"
  492. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_ignored_timestamp ON corp_wallet_transactions(ignored, timestamp)"
  493. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_character_ignored_timestamp ON corp_wallet_transactions(character_id, ignored, timestamp)"
  494. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_corporation_timestamp_type ON corp_wallet_transactions(corporation_id, timestamp, type)"
  495. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_corporation_timestamp_type_type_id ON corp_wallet_transactions(corporation_id, timestamp, type, type_id)"
  496. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_corporation_ignored_timestamp ON corp_wallet_transactions(corporation_id, ignored, timestamp)"
  497. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS market_orders (id BIGINT PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,location_id INTEGER NOT NULL,volume_entered INTEGER NOT NULL,volume_remaining INTEGER NOT NULL,min_volume INTEGER NOT NULL,delta INTEGER NOT NULL DEFAULT 0,state TINYINT NOT NULL,type_id INTEGER NOT NULL,range INTEGER NOT NULL,account_key INTEGER NOT NULL,duration INTEGER NOT NULL,escrow NUMERIC NOT NULL,price NUMERIC NOT NULL,type TINYINT NOT NULL,issued DATETIME NOT NULL,first_seen DATETIME NOT NULL,last_seen DATETIME NULL,corporation_id BIGINT NOT NULL,notes TEXT NULL,custom_location_id INTEGER NULL,color_tag TEXT NULL)"
  498. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS market_orders_characters_index ON market_orders(character_id)"
  499. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS market_orders_state ON market_orders(state)"
  500. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_state ON market_orders(character_id, state)"
  501. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_type ON market_orders(character_id, type)"
  502. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_last_seen ON market_orders(character_id, last_seen)"
  503. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS market_orders_last_seen ON market_orders(last_seen)"
  504. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS market_orders_first_seen_last_seen_state ON market_orders(first_seen, last_seen, state)"
  505. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_first_seen_last_seen_state ON market_orders(character_id, first_seen, last_seen, state)"
  506. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS market_orders_corporation_type ON market_orders(corporation_id, type)"
  507. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS market_orders_corporation_last_seen ON market_orders(corporation_id, last_seen)"
  508. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS market_orders_corporation_first_seen_last_seen_state ON market_orders(corporation_id, first_seen, last_seen, state)"
  509. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS corp_market_orders (id BIGINT PRIMARY KEY,character_id BIGINT NOT NULL ,location_id INTEGER NOT NULL,volume_entered INTEGER NOT NULL,volume_remaining INTEGER NOT NULL,min_volume INTEGER NOT NULL,delta INTEGER NOT NULL DEFAULT 0,state TINYINT NOT NULL,type_id INTEGER NOT NULL,range INTEGER NOT NULL,account_key INTEGER NOT NULL,duration INTEGER NOT NULL,escrow NUMERIC NOT NULL,price NUMERIC NOT NULL,type TINYINT NOT NULL,issued DATETIME NOT NULL,first_seen DATETIME NOT NULL,last_seen DATETIME NULL,corporation_id BIGINT NOT NULL,notes TEXT NULL,custom_location_id INTEGER NULL,color_tag TEXT NULL)"
  510. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_characters_index ON corp_market_orders(character_id)"
  511. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_state ON corp_market_orders(state)"
  512. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_state ON corp_market_orders(character_id, state)"
  513. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_type ON corp_market_orders(character_id, type)"
  514. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_last_seen ON corp_market_orders(character_id, last_seen)"
  515. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_last_seen ON corp_market_orders(last_seen)"
  516. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_first_seen_last_seen_state ON corp_market_orders(first_seen, last_seen, state)"
  517. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_first_seen_last_seen_state ON corp_market_orders(character_id, first_seen, last_seen, state)"
  518. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_corporation_type ON corp_market_orders(corporation_id, type)"
  519. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_corporation_last_seen ON corp_market_orders(corporation_id, last_seen)"
  520. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_corporation_first_seen_last_seen_state ON corp_market_orders(corporation_id, first_seen, last_seen, state)"
  521. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS item_costs (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,cost NUMERIC NOT NULL)"
  522. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS item_costs_characters_index ON item_costs(character_id)"
  523. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS item_costs_type ON item_costs(type_id)"
  524. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS item_costs_character_type ON item_costs(character_id, type_id)"
  525. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS market_order_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,buy_value DOUBLE NOT NULL,sell_value DOUBLE NOT NULL)"
  526. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS market_order_value_snapshots_characters_index ON market_order_value_snapshots(character_id)"
  527. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS market_order_value_snapshots_timestamp ON market_order_value_snapshots(timestamp)"
  528. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS market_order_value_snapshots_character_timestamp ON market_order_value_snapshots(character_id, timestamp)"
  529. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS corp_market_order_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,corporation_id BIGINT NOT NULL,buy_value DOUBLE NOT NULL,sell_value DOUBLE NOT NULL)"
  530. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_market_order_value_snapshots_corporation_timestamp ON corp_market_order_value_snapshots(corporation_id, timestamp)"
  531. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS filter_texts (id INTEGER PRIMARY KEY,text TEXT NOT NULL UNIQUE)"
  532. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS order_scripts (id TEXT PRIMARY KEY,code TEXT NOT NULL)"
  533. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS favorite_items (id INTEGER PRIMARY KEY)"
  534. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS location_bookmarks (id INTEGER PRIMARY KEY,region_id INTEGER NOT NULL,solar_system_id INTEGER NOT NULL,station_id BIGINT NOT NULL,UNIQUE (region_id, solar_system_id, station_id))"
  535. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS contracts (id BIGINT PRIMARY KEY,issuer_id BIGINT NOT NULL,issuer_corp_id BIGINT NOT NULL,assignee_id BIGINT NOT NULL,acceptor_id BIGINT NOT NULL,start_station_id INTEGER NOT NULL,end_station_id INTEGER NOT NULL,type TINYINT NOT NULL,status TINYINT NOT NULL,title TEXT NOT NULL,for_corp TINYINT NOT NULL,availability TINYINT NOT NULL,issued DATETIME NOT NULL,expired DATETIME NOT NULL,accepted DATETIME NULL,completed DATETIME NULL,num_days INTEGER NOT NULL,price DOUBLE NOT NULL,reward DOUBLE NOT NULL,collateral DOUBLE NOT NULL,buyout DOUBLE NOT NULL,volume DOUBLE NOT NULL)"
  536. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS contracts_issuer ON contracts(issuer_id)"
  537. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS contracts_issuer_corp ON contracts(issuer_corp_id)"
  538. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS contracts_assignee ON contracts(assignee_id)"
  539. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS corp_contracts (id BIGINT PRIMARY KEY,issuer_id BIGINT NOT NULL,issuer_corp_id BIGINT NOT NULL,assignee_id BIGINT NOT NULL,acceptor_id BIGINT NOT NULL,start_station_id INTEGER NOT NULL,end_station_id INTEGER NOT NULL,type TINYINT NOT NULL,status TINYINT NOT NULL,title TEXT NOT NULL,for_corp TINYINT NOT NULL,availability TINYINT NOT NULL,issued DATETIME NOT NULL,expired DATETIME NOT NULL,accepted DATETIME NULL,completed DATETIME NULL,num_days INTEGER NOT NULL,price DOUBLE NOT NULL,reward DOUBLE NOT NULL,collateral DOUBLE NOT NULL,buyout DOUBLE NOT NULL,volume DOUBLE NOT NULL)"
  540. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_contracts_issuer ON corp_contracts(issuer_id)"
  541. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_contracts_issuer_corp ON corp_contracts(issuer_corp_id)"
  542. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS corp_contracts_assignee ON corp_contracts(assignee_id)"
  543. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS contract_items (id BIGINT PRIMARY KEY,contract_id BIGINT NOT NULL REFERENCES contracts(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,quantity BIGINT NOT NULL,included TINYINT NOT NULL)"
  544. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS corp_contract_items (id BIGINT PRIMARY KEY,contract_id BIGINT NOT NULL REFERENCES corp_contracts(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,quantity BIGINT NOT NULL,included TINYINT NOT NULL)"
  545. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS lmeve_tasks (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,activity TEXT NOT NULL,runs INTEGER NULL,runs_done INTEGER NULL,runs_completed INTEGER NULL,jobs_done INTEGER NULL,jobs_success INTEGER NULL,jobs_completed INTEGER NULL)"
  546. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS lmeve_tasks_characters_index ON lmeve_tasks(character_id)"
  547. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS citadels (id INTEGER PRIMARY KEY,name TEXT NOT NULL,solar_system_id INTEGER NOT NULL,region_id INTEGER NOT NULL,x REAL NOT NULL,y REAL NOT NULL,z REAL NOT NULL,last_seen DATETIME NOT NULL,first_seen DATETIME NOT NULL,type_id INTEGER NOT NULL,public INTEGER NOT NULL,ignored INTEGER NOT NULL)"
  548. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS citadels_region ON citadels(region_id)"
  549. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS region_type_presets (name TEXT PRIMARY KEY,types BLOB NOT NULL,regions BLOB NOT NULL)"
  550. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS region_station_presets (name TEXT PRIMARY KEY,src_station_id BIGINT NULL,dst_station_id BIGINT NULL,src_regions BLOB NOT NULL,dst_regions BLOB NOT NULL)"
  551. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS industry_manufacturing_setups (name TEXT PRIMARY KEY,data BLOB NOT NULL)"
  552. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE TABLE IF NOT EXISTS mining_ledger (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,date DATE NOT NULL,quantity INTEGER NOT NULL,solar_system_id INTEGER NOT NULL,type_id INTEGER NOT NULL)"
  553. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS mining_ledger_characters_index ON mining_ledger(character_id)"
  554. [debug] 2018-04-11T06:09:49 1548 SQL: "CREATE INDEX IF NOT EXISTS mining_ledger_character_date ON mining_ledger(character_id, date)"
  555. [debug] 2018-04-11T06:09:49 1548 Eve DB path: "C:/Games/evernus/x64/resources/eve.db"
  556. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT activityID FROM ramActivities WHERE activityName = ?"
  557. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT * FROM cache_timers"
  558. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT * FROM update_timers"
  559. [debug] 2018-04-11T06:09:49 1548 SQL: "DELETE FROM wallet_journal WHERE timestamp < ?"
  560. [debug] 2018-04-11T06:09:49 1548 SQL: "DELETE FROM wallet_transactions WHERE timestamp < ?"
  561. [debug] 2018-04-11T06:09:49 1548 SQL: "DELETE FROM market_orders WHERE last_seen < ?"
  562. [debug] 2018-04-11T06:09:49 1548 SQL: "DELETE FROM corp_market_orders WHERE last_seen < ?"
  563. [info] 2018-04-11T06:09:49 1548 Not updating core from 3.1
  564. [info] 2018-04-11T06:09:49 1548 Update db from 3.1
  565. [info] 2018-04-11T06:09:49 1548 No updates found.
  566. [info] 2018-04-11T06:09:49 1548 Checking for updates...
  567. [debug] 2018-04-11T06:09:49 1548 Fetching races
  568. [debug] 2018-04-11T06:09:49 1548 ESI request: QNetworkReplyHttpImpl(0x15fc37931d0) "/v1/universe/races/" : QMap()
  569. [debug] 2018-04-11T06:09:49 1548 Retries 3
  570. [debug] 2018-04-11T06:09:49 1548 Fetching bloodlines
  571. [debug] 2018-04-11T06:09:49 1548 ESI request: QNetworkReplyHttpImpl(0x15fc37c3ca0) "/v1/universe/bloodlines/" : QMap()
  572. [debug] 2018-04-11T06:09:49 1548 Retries 3
  573. [debug] 2018-04-11T06:09:49 1548 Fetching ancestries
  574. [debug] 2018-04-11T06:09:49 1548 ESI request: QNetworkReplyHttpImpl(0x15fc37c3b80) "/v1/universe/ancestries/" : QMap()
  575. [debug] 2018-04-11T06:09:49 1548 Retries 3
  576. [warning] 2018-04-11T06:09:49 1548 QxtGlobalShortcut failed to unregister: ""
  577. [warning] 2018-04-11T06:09:49 1548 QxtGlobalShortcut failed to unregister: ""
  578. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  579. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  580. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  581. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  582. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  583. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  584. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  585. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  586. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  587. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  588. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  589. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  590. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  591. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  592. [debug] 2018-04-11T06:09:49 1548 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  593. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  594. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  595. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  596. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  597. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  598. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT solarSystemID, solarSystemName FROM mapSolarSystems WHERE regionID = ? ORDER BY solarSystemName"
  599. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  600. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  601. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  602. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  603. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  604. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  605. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  606. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  607. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  608. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  609. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  610. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  611. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  612. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  613. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  614. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  615. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  616. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT solarSystemID FROM mapDenormalize WHERE itemID = ?"
  617. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT * FROM citadels"
  618. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT * FROM invMarketGroups"
  619. [debug] 2018-04-11T06:09:50 1548 SQL: "SELECT * FROM invTypes WHERE published = 1 AND marketGroupID IS NOT NULL"
  620. [info] 2018-04-11T13:05:46 13388 "Windows 10 (10.0)"
  621. [info] 2018-04-11T13:05:46 13388 "Evernus" "3.1"
  622. [warning] 2018-04-11T13:05:46 13388 QWinEventNotifier: Can only be used with threads started with QThread
  623. [warning] 2018-04-11T13:05:47 13388 QSslSocket: cannot resolve SSL_set_alpn_protos
  624. [warning] 2018-04-11T13:05:47 13388 QSslSocket: cannot resolve SSL_CTX_set_alpn_select_cb
  625. [warning] 2018-04-11T13:05:47 13388 QSslSocket: cannot resolve SSL_get0_alpn_selected
  626. [debug] 2018-04-11T13:05:47 13388 Switching language to "en_US"
  627. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS characters (id BIGINT PRIMARY KEY,name TEXT NOT NULL,corporation_name TEXT NOT NULL,corporation_id BIGINT NOT NULL,race TEXT NOT NULL,bloodline TEXT NOT NULL,ancestry TEXT NOT NULL,gender TEXT NOT NULL,isk DOUBLE NOT NULL,corp_standing FLOAT NOT NULL,faction_standing FLOAT NOT NULL,trade_skill TINYINT NOT NULL,retail_skill TINYINT NOT NULL,wholesale_skill TINYINT NOT NULL,tycoon_skill TINYINT NOT NULL,marketing_skill TINYINT NOT NULL,procurement_skill TINYINT NOT NULL,daytrading_skill TINYINT NOT NULL,visibility_skill TINYINT NOT NULL,accounting_skill TINYINT NOT NULL,broker_relations_skill TINYINT NOT NULL,margin_trading_skill TINYINT NOT NULL,contracting_skill TINYINT NOT NULL,corporation_contracting_skill TINYINT NOT NULL,enabled TINYINT NOT NULL,brokers_fee FLOAT NULL,sell_brokers_fee FLOAT NULL,reprocessing_implant_bonus FLOAT NOT NULL,arkonor_processing TINYINT NOT NULL,bistot_processing TINYINT NOT NULL,crokite_processing TINYINT NOT NULL,dark_ochre_processing TINYINT NOT NULL,gneiss_processing TINYINT NOT NULL,hedbergite_processing TINYINT NOT NULL,hemorphite_processing TINYINT NOT NULL,ice_processing TINYINT NOT NULL,jaspet_processing TINYINT NOT NULL,kernite_processing TINYINT NOT NULL,mercoxit_processing TINYINT NOT NULL,omber_processing TINYINT NOT NULL,plagioclase_processing TINYINT NOT NULL,pyroxeres_processing TINYINT NOT NULL,reprocessing TINYINT NOT NULL,reprocessing_efficiency TINYINT NOT NULL,scordite_processing TINYINT NOT NULL,scrapmetal_processing TINYINT NOT NULL,spodumain_processing TINYINT NOT NULL,veldspar_processing TINYINT NOT NULL,manufacturing_time_implant_bonus FLOAT NOT NULL,industry TINYINT NOT NULL,advanced_industry TINYINT NOT NULL,advanced_small_ship_construction TINYINT NOT NULL,advanced_medium_ship_construction TINYINT NOT NULL,advanced_large_ship_construction TINYINT NOT NULL,avanced_industrial_ship_construction TINYINT NOT NULL,amarr_starship_engineering TINYINT NOT NULL,caldari_starship_engineering TINYINT NOT NULL,gallente_starship_engineering TINYINT NOT NULL,minmatar_starship_engineering TINYINT NOT NULL,electromagnetic_physics TINYINT NOT NULL,electronic_engineering TINYINT NOT NULL,graviton_physics TINYINT NOT NULL,high_energy_physics TINYINT NOT NULL,hydromagnetic_physics TINYINT NOT NULL,laser_physics TINYINT NOT NULL,mechanical_engineering TINYINT NOT NULL,molecular_engineering TINYINT NOT NULL,nuclear_physics TINYINT NOT NULL,plasma_physics TINYINT NOT NULL,quantum_physics TINYINT NOT NULL,rocket_science TINYINT NOT NULL,alpha_clone TINYINT NOT NULL)"
  628. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS asset_lists (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE)"
  629. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS asset_lists_characters_index ON asset_lists(character_id)"
  630. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS corp_asset_lists (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE)"
  631. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_asset_lists_characters_index ON corp_asset_lists(character_id)"
  632. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS items (id INTEGER PRIMARY KEY,asset_list_id INTEGER NOT NULL REFERENCES asset_lists(id) ON UPDATE CASCADE ON DELETE CASCADE,parent_id BIGINT NULL REFERENCES items(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,location_id BIGINT NULL,quantity INTEGER NOT NULL,raw_quantity INTEGER NOT NULL,custom_value NUMERIC NULL)"
  633. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS items_asset_lists_index ON items(asset_list_id)"
  634. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS corp_items (id INTEGER PRIMARY KEY,asset_list_id INTEGER NOT NULL REFERENCES corp_asset_lists(id) ON UPDATE CASCADE ON DELETE CASCADE,parent_id BIGINT NULL REFERENCES corp_items(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,location_id BIGINT NULL,quantity INTEGER NOT NULL,raw_quantity INTEGER NOT NULL,custom_value NUMERIC NULL)"
  635. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_items_corp_asset_lists_index ON corp_items(asset_list_id)"
  636. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS conquerable_stations (id INTEGER PRIMARY KEY,name TEXT NOT NULL,solar_system_id INTEGER NOT NULL)"
  637. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS conquerable_stations_solar_system ON conquerable_stations(solar_system_id)"
  638. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS wallet_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,balance DOUBLE NOT NULL)"
  639. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_snapshots_characters_index ON wallet_snapshots(character_id)"
  640. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_snapshots_timestamp ON wallet_snapshots(timestamp)"
  641. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS wallet_snapshots_character_timestamp ON wallet_snapshots(character_id, timestamp)"
  642. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS corp_wallet_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,corporation_id BIGINT NOT NULL,balance DOUBLE NOT NULL)"
  643. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_snapshots_timestamp ON corp_wallet_snapshots(timestamp)"
  644. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_wallet_snapshots_corporation_timestamp ON corp_wallet_snapshots(corporation_id, timestamp)"
  645. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS asset_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,balance DOUBLE NOT NULL)"
  646. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS asset_value_snapshots_characters_index ON asset_value_snapshots(character_id)"
  647. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS asset_value_snapshots_timestamp ON asset_value_snapshots(timestamp)"
  648. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS asset_value_snapshots_character_timestamp ON asset_value_snapshots(character_id, timestamp)"
  649. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS corp_asset_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,corporation_id BIGINT NOT NULL,balance DOUBLE NOT NULL)"
  650. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_asset_value_snapshots_corporation_timestamp ON corp_asset_value_snapshots(corporation_id, timestamp)"
  651. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS wallet_journal (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,timestamp DATETIME NOT NULL,first_party_id BIGINT NULL,second_party_id BIGINT NULL,first_party_type TEXT NULL,second_party_type TEXT NULL,extra_info_id BIGINT NULL,amount NUMERIC NULL,balance NUMERIC NULL,reason TEXT NULL,tax_receiver_id BIGINT NULL,tax_amount NUMERIC NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL,extra_info_type TEXT NULL,ref_type TEXT NULL)"
  652. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_characters_index ON wallet_journal(character_id)"
  653. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_timestamp ON wallet_journal(timestamp)"
  654. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_character_timestamp ON wallet_journal(character_id, timestamp)"
  655. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_character_timestamp_amount ON wallet_journal(character_id, timestamp, amount)"
  656. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_corporation_timestamp ON wallet_journal(corporation_id, timestamp)"
  657. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_journal_corporation_timestamp_amount ON wallet_journal(corporation_id, timestamp, amount)"
  658. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS corp_wallet_journal (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL ,timestamp DATETIME NOT NULL,first_party_id BIGINT NULL,second_party_id BIGINT NULL,first_party_type TEXT NULL,second_party_type TEXT NULL,extra_info_id BIGINT NULL,amount NUMERIC NULL,balance NUMERIC NULL,reason TEXT NULL,tax_receiver_id BIGINT NULL,tax_amount NUMERIC NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL,extra_info_type TEXT NULL,ref_type TEXT NULL)"
  659. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_characters_index ON corp_wallet_journal(character_id)"
  660. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_timestamp ON corp_wallet_journal(timestamp)"
  661. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_character_timestamp ON corp_wallet_journal(character_id, timestamp)"
  662. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_character_timestamp_amount ON corp_wallet_journal(character_id, timestamp, amount)"
  663. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_corporation_timestamp ON corp_wallet_journal(corporation_id, timestamp)"
  664. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_journal_corporation_timestamp_amount ON corp_wallet_journal(corporation_id, timestamp, amount)"
  665. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS external_orders (id BIGINT PRIMARY KEY,type TINYINT NOT NULL,type_id INTEGER NOT NULL,location_id BIGINT NOT NULL,solar_system_id INTEGER NOT NULL,region_id INTEGER NOT NULL,range INTEGER NOT NULL,update_time DATETIME NOT NULL,value DOUBLE NOT NULL,volume_entered INTEGER NOT NULL,volume_remaining INTEGER NOT NULL,min_volume INTEGER NOT NULL,issued DATETIME NOT NULL,duration INTEGER NOT NULL)"
  666. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_id ON external_orders(type_id)"
  667. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_id_region ON external_orders(type_id, region_id)"
  668. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS external_orders_solar_system ON external_orders(solar_system_id)"
  669. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS external_orders_region ON external_orders(region_id)"
  670. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS external_orders_update_time ON external_orders(update_time)"
  671. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id ON external_orders(type, type_id)"
  672. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id_location ON external_orders(type, type_id, location_id)"
  673. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id_solar_system ON external_orders(type, type_id, solar_system_id)"
  674. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS external_orders_type_type_id_region ON external_orders(type, type_id, region_id)"
  675. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS cache_timers (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type TINYINT NOT NULL,cache_until DATETIME NOT NULL,UNIQUE (character_id, type))"
  676. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS cache_timers_characters_index ON cache_timers(character_id)"
  677. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS update_timers (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type TINYINT NOT NULL,update_time DATETIME NOT NULL,UNIQUE (character_id, type))"
  678. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS update_timers_characters_index ON update_timers(character_id)"
  679. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS wallet_transactions (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,timestamp DATETIME NOT NULL,quantity INTEGER NOT NULL,type_id INTEGER NOT NULL,price NUMERIC NOT NULL,client_id BIGINT NOT NULL,location_id BIGINT NOT NULL,type TINYINT NOT NULL,journal_id BIGINT NOT NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL)"
  680. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_characters_index ON wallet_transactions(character_id)"
  681. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_type_id ON wallet_transactions(type_id)"
  682. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_type_id_character ON wallet_transactions(type_id, character_id)"
  683. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_timestamp ON wallet_transactions(timestamp)"
  684. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_character_timestamp_type ON wallet_transactions(character_id, timestamp, type)"
  685. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_character_timestamp_type_type_id ON wallet_transactions(character_id, timestamp, type, type_id)"
  686. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_ignored_timestamp ON wallet_transactions(ignored, timestamp)"
  687. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_character_ignored_timestamp ON wallet_transactions(character_id, ignored, timestamp)"
  688. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_corporation_timestamp_type ON wallet_transactions(corporation_id, timestamp, type)"
  689. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_corporation_timestamp_type_type_id ON wallet_transactions(corporation_id, timestamp, type, type_id)"
  690. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS wallet_transactions_corporation_ignored_timestamp ON wallet_transactions(corporation_id, ignored, timestamp)"
  691. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS corp_wallet_transactions (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL ,timestamp DATETIME NOT NULL,quantity INTEGER NOT NULL,type_id INTEGER NOT NULL,price NUMERIC NOT NULL,client_id BIGINT NOT NULL,location_id BIGINT NOT NULL,type TINYINT NOT NULL,journal_id BIGINT NOT NULL,corporation_id BIGINT NOT NULL,ignored TINYINT NOT NULL)"
  692. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_characters_index ON corp_wallet_transactions(character_id)"
  693. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_type_id ON corp_wallet_transactions(type_id)"
  694. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_type_id_character ON corp_wallet_transactions(type_id, character_id)"
  695. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_timestamp ON corp_wallet_transactions(timestamp)"
  696. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_character_timestamp_type ON corp_wallet_transactions(character_id, timestamp, type)"
  697. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_character_timestamp_type_type_id ON corp_wallet_transactions(character_id, timestamp, type, type_id)"
  698. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_ignored_timestamp ON corp_wallet_transactions(ignored, timestamp)"
  699. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_character_ignored_timestamp ON corp_wallet_transactions(character_id, ignored, timestamp)"
  700. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_corporation_timestamp_type ON corp_wallet_transactions(corporation_id, timestamp, type)"
  701. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_corporation_timestamp_type_type_id ON corp_wallet_transactions(corporation_id, timestamp, type, type_id)"
  702. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_wallet_transactions_corporation_ignored_timestamp ON corp_wallet_transactions(corporation_id, ignored, timestamp)"
  703. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS market_orders (id BIGINT PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,location_id INTEGER NOT NULL,volume_entered INTEGER NOT NULL,volume_remaining INTEGER NOT NULL,min_volume INTEGER NOT NULL,delta INTEGER NOT NULL DEFAULT 0,state TINYINT NOT NULL,type_id INTEGER NOT NULL,range INTEGER NOT NULL,account_key INTEGER NOT NULL,duration INTEGER NOT NULL,escrow NUMERIC NOT NULL,price NUMERIC NOT NULL,type TINYINT NOT NULL,issued DATETIME NOT NULL,first_seen DATETIME NOT NULL,last_seen DATETIME NULL,corporation_id BIGINT NOT NULL,notes TEXT NULL,custom_location_id INTEGER NULL,color_tag TEXT NULL)"
  704. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS market_orders_characters_index ON market_orders(character_id)"
  705. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS market_orders_state ON market_orders(state)"
  706. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_state ON market_orders(character_id, state)"
  707. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_type ON market_orders(character_id, type)"
  708. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_last_seen ON market_orders(character_id, last_seen)"
  709. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS market_orders_last_seen ON market_orders(last_seen)"
  710. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS market_orders_first_seen_last_seen_state ON market_orders(first_seen, last_seen, state)"
  711. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS market_orders_character_first_seen_last_seen_state ON market_orders(character_id, first_seen, last_seen, state)"
  712. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS market_orders_corporation_type ON market_orders(corporation_id, type)"
  713. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS market_orders_corporation_last_seen ON market_orders(corporation_id, last_seen)"
  714. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS market_orders_corporation_first_seen_last_seen_state ON market_orders(corporation_id, first_seen, last_seen, state)"
  715. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS corp_market_orders (id BIGINT PRIMARY KEY,character_id BIGINT NOT NULL ,location_id INTEGER NOT NULL,volume_entered INTEGER NOT NULL,volume_remaining INTEGER NOT NULL,min_volume INTEGER NOT NULL,delta INTEGER NOT NULL DEFAULT 0,state TINYINT NOT NULL,type_id INTEGER NOT NULL,range INTEGER NOT NULL,account_key INTEGER NOT NULL,duration INTEGER NOT NULL,escrow NUMERIC NOT NULL,price NUMERIC NOT NULL,type TINYINT NOT NULL,issued DATETIME NOT NULL,first_seen DATETIME NOT NULL,last_seen DATETIME NULL,corporation_id BIGINT NOT NULL,notes TEXT NULL,custom_location_id INTEGER NULL,color_tag TEXT NULL)"
  716. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_characters_index ON corp_market_orders(character_id)"
  717. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_state ON corp_market_orders(state)"
  718. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_state ON corp_market_orders(character_id, state)"
  719. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_type ON corp_market_orders(character_id, type)"
  720. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_last_seen ON corp_market_orders(character_id, last_seen)"
  721. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_last_seen ON corp_market_orders(last_seen)"
  722. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_first_seen_last_seen_state ON corp_market_orders(first_seen, last_seen, state)"
  723. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_character_first_seen_last_seen_state ON corp_market_orders(character_id, first_seen, last_seen, state)"
  724. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_corporation_type ON corp_market_orders(corporation_id, type)"
  725. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_corporation_last_seen ON corp_market_orders(corporation_id, last_seen)"
  726. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_market_orders_corporation_first_seen_last_seen_state ON corp_market_orders(corporation_id, first_seen, last_seen, state)"
  727. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS item_costs (id INTEGER PRIMARY KEY ASC,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,cost NUMERIC NOT NULL)"
  728. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS item_costs_characters_index ON item_costs(character_id)"
  729. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS item_costs_type ON item_costs(type_id)"
  730. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS item_costs_character_type ON item_costs(character_id, type_id)"
  731. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS market_order_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,buy_value DOUBLE NOT NULL,sell_value DOUBLE NOT NULL)"
  732. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS market_order_value_snapshots_characters_index ON market_order_value_snapshots(character_id)"
  733. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS market_order_value_snapshots_timestamp ON market_order_value_snapshots(timestamp)"
  734. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS market_order_value_snapshots_character_timestamp ON market_order_value_snapshots(character_id, timestamp)"
  735. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS corp_market_order_value_snapshots (id INTEGER PRIMARY KEY ASC,timestamp DATETIME NOT NULL,corporation_id BIGINT NOT NULL,buy_value DOUBLE NOT NULL,sell_value DOUBLE NOT NULL)"
  736. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE UNIQUE INDEX IF NOT EXISTS corp_market_order_value_snapshots_corporation_timestamp ON corp_market_order_value_snapshots(corporation_id, timestamp)"
  737. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS filter_texts (id INTEGER PRIMARY KEY,text TEXT NOT NULL UNIQUE)"
  738. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS order_scripts (id TEXT PRIMARY KEY,code TEXT NOT NULL)"
  739. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS favorite_items (id INTEGER PRIMARY KEY)"
  740. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS location_bookmarks (id INTEGER PRIMARY KEY,region_id INTEGER NOT NULL,solar_system_id INTEGER NOT NULL,station_id BIGINT NOT NULL,UNIQUE (region_id, solar_system_id, station_id))"
  741. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS contracts (id BIGINT PRIMARY KEY,issuer_id BIGINT NOT NULL,issuer_corp_id BIGINT NOT NULL,assignee_id BIGINT NOT NULL,acceptor_id BIGINT NOT NULL,start_station_id INTEGER NOT NULL,end_station_id INTEGER NOT NULL,type TINYINT NOT NULL,status TINYINT NOT NULL,title TEXT NOT NULL,for_corp TINYINT NOT NULL,availability TINYINT NOT NULL,issued DATETIME NOT NULL,expired DATETIME NOT NULL,accepted DATETIME NULL,completed DATETIME NULL,num_days INTEGER NOT NULL,price DOUBLE NOT NULL,reward DOUBLE NOT NULL,collateral DOUBLE NOT NULL,buyout DOUBLE NOT NULL,volume DOUBLE NOT NULL)"
  742. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS contracts_issuer ON contracts(issuer_id)"
  743. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS contracts_issuer_corp ON contracts(issuer_corp_id)"
  744. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS contracts_assignee ON contracts(assignee_id)"
  745. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS corp_contracts (id BIGINT PRIMARY KEY,issuer_id BIGINT NOT NULL,issuer_corp_id BIGINT NOT NULL,assignee_id BIGINT NOT NULL,acceptor_id BIGINT NOT NULL,start_station_id INTEGER NOT NULL,end_station_id INTEGER NOT NULL,type TINYINT NOT NULL,status TINYINT NOT NULL,title TEXT NOT NULL,for_corp TINYINT NOT NULL,availability TINYINT NOT NULL,issued DATETIME NOT NULL,expired DATETIME NOT NULL,accepted DATETIME NULL,completed DATETIME NULL,num_days INTEGER NOT NULL,price DOUBLE NOT NULL,reward DOUBLE NOT NULL,collateral DOUBLE NOT NULL,buyout DOUBLE NOT NULL,volume DOUBLE NOT NULL)"
  746. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_contracts_issuer ON corp_contracts(issuer_id)"
  747. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_contracts_issuer_corp ON corp_contracts(issuer_corp_id)"
  748. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS corp_contracts_assignee ON corp_contracts(assignee_id)"
  749. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS contract_items (id BIGINT PRIMARY KEY,contract_id BIGINT NOT NULL REFERENCES contracts(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,quantity BIGINT NOT NULL,included TINYINT NOT NULL)"
  750. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS corp_contract_items (id BIGINT PRIMARY KEY,contract_id BIGINT NOT NULL REFERENCES corp_contracts(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,quantity BIGINT NOT NULL,included TINYINT NOT NULL)"
  751. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS lmeve_tasks (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,type_id INTEGER NOT NULL,activity TEXT NOT NULL,runs INTEGER NULL,runs_done INTEGER NULL,runs_completed INTEGER NULL,jobs_done INTEGER NULL,jobs_success INTEGER NULL,jobs_completed INTEGER NULL)"
  752. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS lmeve_tasks_characters_index ON lmeve_tasks(character_id)"
  753. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS citadels (id INTEGER PRIMARY KEY,name TEXT NOT NULL,solar_system_id INTEGER NOT NULL,region_id INTEGER NOT NULL,x REAL NOT NULL,y REAL NOT NULL,z REAL NOT NULL,last_seen DATETIME NOT NULL,first_seen DATETIME NOT NULL,type_id INTEGER NOT NULL,public INTEGER NOT NULL,ignored INTEGER NOT NULL)"
  754. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS citadels_region ON citadels(region_id)"
  755. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS region_type_presets (name TEXT PRIMARY KEY,types BLOB NOT NULL,regions BLOB NOT NULL)"
  756. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS region_station_presets (name TEXT PRIMARY KEY,src_station_id BIGINT NULL,dst_station_id BIGINT NULL,src_regions BLOB NOT NULL,dst_regions BLOB NOT NULL)"
  757. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS industry_manufacturing_setups (name TEXT PRIMARY KEY,data BLOB NOT NULL)"
  758. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE TABLE IF NOT EXISTS mining_ledger (id INTEGER PRIMARY KEY,character_id BIGINT NOT NULL REFERENCES characters(id) ON UPDATE CASCADE ON DELETE CASCADE,date DATE NOT NULL,quantity INTEGER NOT NULL,solar_system_id INTEGER NOT NULL,type_id INTEGER NOT NULL)"
  759. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS mining_ledger_characters_index ON mining_ledger(character_id)"
  760. [debug] 2018-04-11T13:05:48 13388 SQL: "CREATE INDEX IF NOT EXISTS mining_ledger_character_date ON mining_ledger(character_id, date)"
  761. [debug] 2018-04-11T13:05:48 13388 Eve DB path: "C:/Games/evernus/x64/resources/eve.db"
  762. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT activityID FROM ramActivities WHERE activityName = ?"
  763. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT * FROM cache_timers"
  764. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT * FROM update_timers"
  765. [debug] 2018-04-11T13:05:48 13388 SQL: "DELETE FROM wallet_journal WHERE timestamp < ?"
  766. [debug] 2018-04-11T13:05:48 13388 SQL: "DELETE FROM wallet_transactions WHERE timestamp < ?"
  767. [debug] 2018-04-11T13:05:48 13388 SQL: "DELETE FROM market_orders WHERE last_seen < ?"
  768. [debug] 2018-04-11T13:05:48 13388 SQL: "DELETE FROM corp_market_orders WHERE last_seen < ?"
  769. [info] 2018-04-11T13:05:48 13388 Not updating core from 3.1
  770. [info] 2018-04-11T13:05:48 13388 Update db from 3.1
  771. [info] 2018-04-11T13:05:48 13388 No updates found.
  772. [info] 2018-04-11T13:05:48 13388 Checking for updates...
  773. [debug] 2018-04-11T13:05:48 13388 Fetching races
  774. [debug] 2018-04-11T13:05:48 13388 ESI request: QNetworkReplyHttpImpl(0x1df11dfeff0) "/v1/universe/races/" : QMap()
  775. [debug] 2018-04-11T13:05:48 13388 Retries 3
  776. [debug] 2018-04-11T13:05:48 13388 Fetching bloodlines
  777. [debug] 2018-04-11T13:05:48 13388 ESI request: QNetworkReplyHttpImpl(0x1df11e17980) "/v1/universe/bloodlines/" : QMap()
  778. [debug] 2018-04-11T13:05:48 13388 Retries 3
  779. [debug] 2018-04-11T13:05:48 13388 Fetching ancestries
  780. [debug] 2018-04-11T13:05:48 13388 ESI request: QNetworkReplyHttpImpl(0x1df11dbd4d0) "/v1/universe/ancestries/" : QMap()
  781. [debug] 2018-04-11T13:05:48 13388 Retries 3
  782. [warning] 2018-04-11T13:05:48 13388 QxtGlobalShortcut failed to unregister: ""
  783. [warning] 2018-04-11T13:05:48 13388 QxtGlobalShortcut failed to unregister: ""
  784. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  785. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  786. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  787. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  788. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  789. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  790. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  791. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  792. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  793. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  794. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  795. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  796. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  797. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  798. [debug] 2018-04-11T13:05:48 13388 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  799. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  800. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  801. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  802. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT id, name FROM characters WHERE enabled != 0 ORDER BY name"
  803. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT text FROM filter_texts ORDER BY id DESC"
  804. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT solarSystemID, solarSystemName FROM mapSolarSystems WHERE regionID = ? ORDER BY solarSystemName"
  805. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  806. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  807. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  808. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  809. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  810. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  811. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  812. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  813. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  814. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  815. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  816. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  817. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  818. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  819. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  820. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  821. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT groupID FROM invGroups WHERE groupName = ?"
  822. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT solarSystemID FROM mapDenormalize WHERE itemID = ?"
  823. [debug] 2018-04-11T13:05:49 13388 SQL: "SELECT * FROM citadels"
  824. [debug] 2018-04-11T13:05:50 13388 SQL: "SELECT * FROM invMarketGroups"
  825. [debug] 2018-04-11T13:05:50 13388 SQL: "SELECT * FROM invTypes WHERE published = 1 AND marketGroupID IS NOT NULL"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!