I highly suggest to let Spring automatically create this on first startup. Only as a backup, try using server-settings-dump.sql to manually create it
Table "public.linked_account"
Column | Type | Collation | Nullable | Default
--------------+------------------------+-----------+----------+--------------------------------------------
id | integer | | not null | nextval('linked_account_id_seq'::regclass)
last_updated | bigint | | |
discord | character varying(255) | | |
username | character varying(255) | | |
uuid | character varying(255) | | |
Indexes:
"linked_account_pkey" PRIMARY KEY, btree (id)
"linked_account_discord_key" UNIQUE CONSTRAINT, btree (discord)
"linked_account_username_key" UNIQUE CONSTRAINT, btree (username)
"linked_account_uuid_key" UNIQUE CONSTRAINT, btree (uuid)
There are 4 leaderboards (all_lb, ironman_lb, stranded_lb, and selected_lb) with identical schemas. The first 3 are self-explanatory. The last one is a cache that stores players' last played profile for automatic nickname updates, automatic roles claim, etc
Table "public.all_lb"
Column | Type | Collation | Nullable | Default
----------------------------------------------------------------+------------------+-----------+----------+---------
uuid | uuid | | not null |
username | text | | not null |
last_updated | bigint | | not null |
slayer | real | | |
skills | real | | |
catacombs_xp | real | | |
weight | real | | |
wolf | real | | |
zombie | real | | |
spider | real | | |
enderman | real | | |
alchemy_xp | real | | |
combat_xp | real | | |
fishing_xp | real | | |
farming_xp | real | | |
foraging_xp | real | | |
carpentry_xp | real | | |
mining_xp | real | | |
taming_xp | real | | |
social_xp | real | | |
enchanting_xp | real | | |
networth | real | | |
blaze | real | | |
lily_weight | real | | |
coins | real | | |
lily_slayer_weight | real | | |
level | real | | |
hotm | real | | |
cocoa_beans | real | | |
carrot | real | | |
cactus | real | | |
raw_chicken | real | | |
sugar_cane | real | | |
pumpkin | real | | |
wheat | real | | |
seeds | real | | |
mushroom | real | | |
raw_rabbit | real | | |
nether_wart | real | | |
mutton | real | | |
melon | real | | |
potato | real | | |
leather | real | | |
raw_porkchop | real | | |
feather | real | | |
lapis_lazuli | real | | |
redstone | real | | |
coal | real | | |
mycelium | real | | |
end_stone | real | | |
nether_quartz | real | | |
sand | real | | |
iron_ingot | real | | |
gemstone | real | | |
obsidian | real | | |
diamond | real | | |
cobblestone | real | | |
glowstone_dust | real | | |
gold_ingot | real | | |
gravel | real | | |
hard_stone | real | | |
mithril | real | | |
emerald | real | | |
red_sand | real | | |
ice | real | | |
sulphur | real | | |
netherrack | real | | |
ender_pearl | real | | |
slimeball | real | | |
magma_cream | real | | |
ghast_tear | real | | |
gunpowder | real | | |
rotten_flesh | real | | |
spider_eye | real | | |
bone | real | | |
blaze_rod | real | | |
string | real | | |
acacia_wood | real | | |
spruce_wood | real | | |
jungle_wood | real | | |
birch_wood | real | | |
oak_wood | real | | |
dark_oak_wood | real | | |
lily_pad | real | | |
prismarine_shard | real | | |
ink_sack | real | | |
raw_fish | real | | |
pufferfish | real | | |
clownfish | real | | |
raw_salmon | real | | |
magmafish | real | | |
prismarine_crystals | real | | |
clay | real | | |
sponge | real | | |
deaths | real | | |
deaths_void | real | | |
kills | real | | |
kills_emerald_slime | real | | |
auctions_bids | real | | |
auctions_highest_bid | real | | |
kills_zombie | real | | |
auctions_won | real | | |
auctions_bought_rare | real | | |
auctions_gold_spent | real | | |
kills_chicken | real | | |
deaths_zombie | real | | |
deaths_skeleton | real | | |
highest_crit_damage | real | | |
kills_skeleton | real | | |
kills_spider | real | | |
auctions_bought_uncommon | real | | |
kills_diamond_skeleton | real | | |
kills_diamond_zombie | real | | |
kills_zombie_villager | real | | |
kills_redstone_pigman | real | | |
kills_invisible_creeper | real | | |
kills_witch | real | | |
items_fished | real | | |
items_fished_normal | real | | |
kills_sea_walker | real | | |
kills_pond_squid | real | | |
items_fished_large_treasure | real | | |
kills_sea_guardian | real | | |
items_fished_treasure | real | | |
kills_unburried_zombie | real | | |
deaths_unburried_zombie | real | | |
kills_ruin_wolf | real | | |
kills_horseman_zombie | real | | |
kills_lapis_zombie | real | | |
deaths_fire | real | | |
kills_splitter_spider | real | | |
kills_weaver_spider | real | | |
kills_voracious_spider | real | | |
kills_splitter_spider_silverfish | real | | |
kills_jockey_shot_silverfish | real | | |
kills_dasher_spider | real | | |
kills_jockey_skeleton | real | | |
kills_spider_jockey | real | | |
kills_wither_skeleton | real | | |
deaths_wither_skeleton | real | | |
kills_fireball_magma_cube | real | | |
kills_rabbit | real | | |
kills_sheep | real | | |
end_race_best_time | real | | |
deaths_fall | real | | |
deaths_spider | real | | |
kills_pig | real | | |
kills_cow | real | | |
auctions_bought_epic | real | | |
kills_enderman | real | | |
kills_random_slime | real | | |
kills_respawning_skeleton | real | | |
auctions_created | real | | |
auctions_fees | real | | |
auctions_completed | real | | |
auctions_sold_common | real | | |
auctions_gold_earned | real | | |
kills_watcher | real | | |
kills_zealot_enderman | real | | |
kills_obsidian_wither | real | | |
kills_endermite | real | | |
deaths_unknown | real | | |
auctions_sold_epic | real | | |
kills_bat_pinata | real | | |
deaths_drowning | real | | |
kills_blaze | real | | |
auctions_sold_special | real | | |
kills_generator_ghast | real | | |
kills_old_wolf | real | | |
auctions_bought_common | real | | |
deaths_wolf | real | | |
kills_magma_cube | real | | |
kills_pigman | real | | |
kills_pack_spirit | real | | |
kills_howling_spirit | real | | |
kills_soul_of_the_alpha | real | | |
kills_night_respawning_skeleton | real | | |
auctions_sold_rare | real | | |
highest_critical_damage | double precision | | |
kills_sea_archer | real | | |
kills_zombie_deep | real | | |
kills_catfish | real | | |
kills_chicken_deep | real | | |
deaths_old_wolf | real | | |
auctions_sold_uncommon | real | | |
auctions_sold_legendary | real | | |
ender_crystals_destroyed | real | | |
kills_wise_dragon | real | | |
kills_unstable_dragon | real | | |
kills_strong_dragon | real | | |
kills_protector_dragon | real | | |
gifts_received | real | | |
gifts_given | real | | |
kills_liquid_hot_magma | real | | |
most_winter_snowballs_hit | real | | |
most_winter_damage_dealt | real | | |
most_winter_magma_damage_dealt | real | | |
deaths_player | real | | |
deaths_liquid_hot_magma | real | | |
deaths_magma_cube | real | | |
kills_night_squid | real | | |
deaths_sea_leech | real | | |
kills_old_dragon | real | | |
deaths_strong_dragon | real | | |
deaths_superior_dragon | real | | |
kills_sea_leech | real | | |
kills_brood_mother_spider | real | | |
kills_brood_mother_cave_spider | real | | |
auctions_no_bids | real | | |
kills_young_dragon | real | | |
kills_superior_dragon | real | | |
auctions_bought_legendary | real | | |
kills_cave_spider | real | | |
kills_player | real | | |
dungeon_hub_giant_mushroom_anything_no_return_best_time | real | | |
dungeon_hub_precursor_ruins_anything_no_return_best_time | real | | |
dungeon_hub_crystal_core_anything_no_return_best_time | real | | |
kills_zombie_grunt | real | | |
kills_skeleton_grunt | real | | |
kills_dungeon_respawning_skeleton | real | | |
kills_crypt_lurker | real | | |
kills_crypt_dreadlord | real | | |
kills_crypt_tank_zombie | real | | |
kills_scared_skeleton | real | | |
kills_diamond_guy | real | | |
deaths_lost_adventurer | real | | |
kills_crypt_souleater | real | | |
kills_skeleton_soldier | real | | |
kills_crypt_undead | real | | |
kills_watcher_summon_undead | real | | |
kills_bonzo_summon_undead | real | | |
kills_lost_adventurer | real | | |
deaths_blaze | real | | |
deaths_enderman | real | | |
deaths_lapis_zombie | real | | |
deaths_ruin_wolf | real | | |
deaths_emerald_slime | real | | |
deaths_weaver_spider | real | | |
deaths_dasher_spider | real | | |
deaths_diamond_zombie | real | | |
deaths_splitter_spider | real | | |
deaths_splitter_spider_silverfish | real | | |
deaths_redstone_pigman | real | | |
deaths_spider_jockey | real | | |
deaths_diamond_skeleton | real | | |
deaths_fireball_magma_cube | real | | |
deaths_zombie_deep | real | | |
deaths_watcher | real | | |
deaths_obsidian_wither | real | | |
deaths_endermite | real | | |
kills_generator_slime | real | | |
kills_slime | real | | |
kills_ghast | real | | |
deaths_generator_slime | real | | |
deaths_zealot_enderman | real | | |
deaths_old_dragon | real | | |
deaths_wise_dragon | real | | |
kills_forest_island_bat | real | | |
kills_magma_cube_boss | real | | |
deaths_magma_cube_boss | real | | |
kills_generator_magma_cube | real | | |
deaths_cave_spider | real | | |
kills_sea_witch | real | | |
kills_creeper | real | | |
kills_guardian_defender | real | | |
kills_deep_sea_protector | real | | |
deaths_water_hydra | real | | |
kills_water_hydra | real | | |
deaths_protector_dragon | real | | |
chicken_race_best_time | real | | |
kills_frozen_steve | real | | |
kills_frosty_the_snowman | real | | |
chicken_race_best_time_2 | real | | |
kills_guardian_emperor | real | | |
kills_skeleton_emperor | real | | |
kills_carrot_king | real | | |
kills_yeti | real | | |
deaths_yeti | real | | |
deaths_pack_spirit | real | | |
deaths_soul_of_the_alpha | real | | |
shredder_bait | real | | |
shredder_fished | real | | |
kills_grinch | real | | |
deaths_guardian_emperor | real | | |
auctions_bought_special | real | | |
foraging_race_best_time | real | | |
pet_milestone_sea_creatures_killed | real | | |
pet_milestone_ores_mined | real | | |
deaths_revenant_zombie | real | | |
kills_revenant_zombie | real | | |
dungeon_hub_crystal_core_no_pearls_no_return_best_time | real | | |
dungeon_hub_crystal_core_no_abilities_no_return_best_time | real | | |
kills_cellar_spider | real | | |
kills_sniper_skeleton | real | | |
deaths_watcher_summon_undead | real | | |
deaths_crypt_lurker | real | | |
kills_corrupted_protector | real | | |
deaths_skeleton_emperor | real | | |
kills_horseman_bat | real | | |
deaths_corrupted_protector | real | | |
dungeon_hub_precursor_ruins_no_pearls_no_return_best_time | real | | |
dungeon_hub_precursor_ruins_anything_with_return_best_time | real | | |
dungeon_hub_precursor_ruins_no_pearls_with_return_best_time | real | | |
kills_horseman_horse | real | | |
kills_dungeon_secret_bat | real | | |
kills_skeleton_master | real | | |
deaths_scarf_warrior | real | | |
kills_scarf_warrior | real | | |
kills_scarf_mage | real | | |
deaths_crypt_dreadlord | real | | |
deaths_skeleton_soldier | real | | |
kills_parasite | real | | |
deaths_scarf | real | | |
kills_lonely_spider | real | | |
deaths_scarf_mage | real | | |
kills_scarf_priest | real | | |
kills_blaze_higher_or_lower | real | | |
kills_zombie_soldier | real | | |
deaths_skeletor | real | | |
deaths_skeleton_grunt | real | | |
kills_scarf_archer | real | | |
deaths_crypt_souleater | real | | |
deaths_skeleton_master | real | | |
kills_dungeon_respawning_skeleton_skull | real | | |
deaths_trap | real | | |
kills_crypt_undead_pieter | real | | |
kills_crypt_undead_valentin | real | | |
kills_shadow_assassin | real | | |
kills_skeletor | real | | |
deaths_shadow_assassin | real | | |
deaths_deathmite | real | | |
kills_watcher_bonzo | real | | |
kills_professor_guardian_summon | real | | |
deaths_professor | real | | |
kills_zombie_knight | real | | |
deaths_professor_mage_guardian | real | | |
deaths_scared_skeleton | real | | |
kills_crypt_undead_christian | real | | |
deaths_diamond_guy | real | | |
dungeon_hub_giant_mushroom_no_pearls_no_return_best_time | real | | |
kills_crypt_undead_nicholas | real | | |
kills_crypt_undead_bernhard | real | | |
kills_crypt_undead_friedrich | real | | |
kills_crypt_undead_alexander | real | | |
kills_crypt_undead_marius | real | | |
kills_king_midas | real | | |
dungeon_hub_giant_mushroom_anything_with_return_best_time | real | | |
dungeon_hub_giant_mushroom_no_pearls_with_return_best_time | real | | |
dungeon_hub_crystal_core_anything_with_return_best_time | real | | |
dungeon_hub_crystal_core_no_pearls_with_return_best_time | real | | |
kills_deathmite | real | | |
deaths_suffocation | real | | |
deaths_young_dragon | real | | |
deaths_deep_sea_protector | real | | |
kills_tarantula_spider | real | | |
deaths_tarantula_spider | real | | |
most_winter_cannonballs_hit | real | | |
deaths_dungeon_respawning_skeleton | real | | |
deaths_professor_guardian_summon | real | | |
deaths_sniper_skeleton | real | | |
deaths_wither | real | | |
deaths_unstable_dragon | real | | |
deaths_generator_ghast | real | | |
dungeon_hub_giant_mushroom_no_abilities_no_return_best_time | real | | |
dungeon_hub_giant_mushroom_nothing_no_return_best_time | real | | |
deaths_pigman | real | | |
deaths_catfish | real | | |
deaths_guardian_defender | real | | |
dungeon_hub_crystal_core_nothing_no_return_best_time | real | | |
dungeon_hub_crystal_core_no_abilities_with_return_best_time | real | | |
dungeon_hub_crystal_core_nothing_with_return_best_time | real | | |
dungeon_hub_giant_mushroom_no_abilities_with_return_best_time | real | | |
dungeon_hub_giant_mushroom_nothing_with_return_best_time | real | | |
dungeon_hub_precursor_ruins_no_abilities_no_return_best_time | real | | |
dungeon_hub_precursor_ruins_nothing_no_return_best_time | real | | |
dungeon_hub_precursor_ruins_no_abilities_with_return_best_time | real | | |
dungeon_hub_precursor_ruins_nothing_with_return_best_time | real | | |
deaths_zombie_villager | real | | |
deaths_howling_spirit | real | | |
deaths_professor_archer_guardian | real | | |
deaths_sea_guardian | real | | |
deaths_respawning_skeleton | real | | |
deaths_jockey_shot_silverfish | real | | |
kills_headless_horseman | real | | |
deaths_king_midas | real | | |
kills_super_archer | real | | |
kills_crypt_witherskeleton | real | | |
kills_spirit_wolf | real | | |
kills_spirit_bull | real | | |
kills_spirit_rabbit | real | | |
kills_spirit_chicken | real | | |
kills_spirit_bat | real | | |
kills_spirit_sheep | real | | |
deaths_spirit_chicken | real | | |
kills_spirit_miniboss | real | | |
deaths_spirit_bat | real | | |
kills_super_tank_zombie | real | | |
kills_watcher_scarf | real | | |
deaths_spirit_wolf | real | | |
kills_thorn | real | | |
deaths_spirit_miniboss | real | | |
deaths_spirit_rabbit | real | | |
deaths_spirit_bull | real | | |
deaths_watcher_scarf | real | | |
deaths_watcher_guardian | real | | |
deaths_zombie_knight | real | | |
deaths_crypt_tank_zombie | real | | |
deaths_zombie_soldier | real | | |
deaths_super_archer | real | | |
deaths_watcher_bonzo | real | | |
deaths_lonely_spider | real | | |
deaths_crypt_undead | real | | |
mythos_burrows_dug_next | real | | |
mythos_burrows_dug_next_common | real | | |
mythos_burrows_dug_combat | real | | |
mythos_burrows_dug_combat_common | real | | |
mythos_kills | real | | |
kills_siamese_lynx | real | | |
kills_minos_hunter | real | | |
mythos_burrows_dug_treasure | real | | |
mythos_burrows_dug_treasure_common | real | | |
mythos_burrows_chains_complete | real | | |
mythos_burrows_chains_complete_common | real | | |
mythos_burrows_dug_next_uncommon | real | | |
mythos_burrows_dug_combat_uncommon | real | | |
kills_minotaur | real | | |
mythos_burrows_dug_treasure_uncommon | real | | |
mythos_burrows_chains_complete_uncommon | real | | |
mythos_burrows_dug_next_rare | real | | |
mythos_burrows_dug_combat_rare | real | | |
kills_gaia_construct | real | | |
deaths_gaia_construct | real | | |
mythos_burrows_dug_next_legendary | real | | |
mythos_burrows_dug_combat_legendary | real | | |
deaths_minos_champion | real | | |
deaths_minotaur | real | | |
mythos_burrows_dug_treasure_legendary | real | | |
mythos_burrows_chains_complete_legendary | real | | |
kills_minos_champion | real | | |
kills_minos_inquisitor | real | | |
mythos_burrows_dug_next_null | real | | |
mythos_burrows_dug_combat_null | real | | |
mythos_burrows_dug_treasure_rare | real | | |
mythos_burrows_chains_complete_rare | real | | |
mythos_burrows_dug_next_epic | real | | |
mythos_burrows_dug_treasure_epic | real | | |
mythos_burrows_dug_combat_epic | real | | |
mythos_burrows_chains_complete_epic | real | | |
mythos_burrows_dug_treasure_null | real | | |
mythos_burrows_chains_complete_null | real | | |
deaths_minos_inquisitor | real | | |
kills_nurse_shark | real | | |
kills_tiger_shark | real | | |
kills_great_white_shark | real | | |
kills_blue_shark | real | | |
deaths_great_white_shark | real | | |
kills_tentaclees | real | | |
deaths_livid_clone | real | | |
deaths_livid | real | | |
deaths_tentaclees | real | | |
deaths_bonzo_summon_undead | real | | |
deaths_professor_warrior_guardian | real | | |
auctions_bought_mythic | real | | |
kills_watcher_livid | real | | |
deaths_sadan_statue | real | | |
kills_zombie_commander | real | | |
kills_sadan_statue | real | | |
kills_sadan_giant | real | | |
kills_sadan_golem | real | | |
kills_skeletor_prime | real | | |
deaths_sadan_giant | real | | |
deaths_sadan_golem | real | | |
deaths_sadan | real | | |
kills_mimic | real | | |
deaths_siamese_lynx | real | | |
deaths_bonzo | real | | |
deaths_skeletor_prime | real | | |
kills_wraith | real | | |
kills_wither_gourd | real | | |
kills_scary_jerry | real | | |
kills_phantom_spirit | real | | |
kills_trick_or_treater | real | | |
kills_bat_spooky | real | | |
kills_batty_witch | real | | |
kills_witch_bat | real | | |
kills_scarecrow | real | | |
kills_nightmare | real | | |
kills_phantom_fisherman | real | | |
kills_werewolf | real | | |
kills_grim_reaper | real | | |
auctions_sold_mythic | real | | |
deaths_crypt_witherskeleton | real | | |
kills_zombie_lord | real | | |
deaths_wither_miner | real | | |
kills_wither_miner | real | | |
kills_wither_guard | real | | |
deaths_maxor | real | | |
deaths_wither_guard | real | | |
kills_skeleton_lord | real | | |
kills_watcher_giant_laser | real | | |
kills_watcher_giant_boulder | real | | |
kills_watcher_giant_diamond | real | | |
kills_necron_guard | real | | |
deaths_watcher_livid | real | | |
deaths_necron_guard | real | | |
kills_watcher_giant_bigfoot | real | | |
deaths_watcher_giant_bigfoot | real | | |
deaths_watcher_giant_boulder | real | | |
deaths_super_tank_zombie | real | | |
deaths_crushed | real | | |
deaths_armor_stand | real | | |
kills_mayor_jerry_green | real | | |
kills_mayor_jerry_blue | real | | |
kills_mayor_jerry_purple | real | | |
kills_mayor_jerry_golden | real | | |
kills_ice_walker | real | | |
kills_goblin | real | | |
deaths_caverns_ghost | real | | |
kills_goblin_knife_thrower | real | | |
kills_goblin_weakling_melee | real | | |
kills_goblin_weakling_bow | real | | |
kills_treasure_hoarder | real | | |
kills_goblin_creepertamer | real | | |
kills_goblin_battler | real | | |
kills_goblin_murderlover | real | | |
kills_caverns_ghost | real | | |
kills_goblin_creeper | real | | |
kills_goblin_golem | real | | |
kills_crystal_sentry | real | | |
kills_powder_ghast | real | | |
deaths_goblin_murderlover | real | | |
deaths_goblin_knife_thrower | real | | |
deaths_ice_walker | real | | |
deaths_crypt_undead_hypixel | real | | |
deaths_crypt_undead_flameboy101 | real | | |
deaths_goblin_weakling_bow | real | | |
kills_arachne_brood | real | | |
kills_arachne_keeper | real | | |
deaths_arachne | real | | |
kills_arachne | real | | |
deaths_arachne_brood | real | | |
deaths_arachne_keeper | real | | |
deaths_cellar_spider | real | | |
kills_master_sniper_skeleton | real | | |
kills_master_crypt_tank_zombie | real | | |
kills_master_zombie_grunt | real | | |
kills_master_crypt_lurker | real | | |
kills_master_scared_skeleton | real | | |
kills_master_skeleton_soldier | real | | |
kills_master_skeleton_grunt | real | | |
kills_master_crypt_souleater | real | | |
kills_master_dungeon_respawning_skeleton | real | | |
kills_master_lost_adventurer | real | | |
kills_master_crypt_dreadlord | real | | |
kills_master_cellar_spider | real | | |
kills_master_watcher_summon_undead | real | | |
deaths_master_watcher_summon_undead | real | | |
kills_master_bonzo_summon_undead | real | | |
deaths_master_bonzo | real | | |
deaths_spirit_sheep | real | | |
kills_master_crypt_undead | real | | |
kills_master_diamond_guy | real | | |
kills_master_skeleton_master | real | | |
deaths_master_scarf_archer | real | | |
kills_master_scarf_mage | real | | |
deaths_master_scarf | real | | |
kills_dante_goon | real | | |
kills_dante_slime_goon | real | | |
kills_rat | real | | |
kills_mushroom_cow | real | | |
kills_trapper_pig | real | | |
kills_trapper_chicken | real | | |
kills_trapper_sheep | real | | |
kills_trapper_cow | real | | |
kills_trapper_rabbit | real | | |
deaths_master_lost_adventurer | real | | |
deaths_zombie_grunt | real | | |
deaths_grim_reaper | real | | |
kills_oasis_sheep | real | | |
deaths_master_skeleton_soldier | real | | |
deaths_master_scarf_warrior | real | | |
kills_master_parasite | real | | |
kills_master_scarf_priest | real | | |
deaths_master_crypt_lurker | real | | |
kills_master_crypt_undead_bernhard | real | | |
kills_master_scarf_warrior | real | | |
kills_master_scarf_archer | real | | |
deaths_master_scarf_mage | real | | |
kills_master_skeletor | real | | |
deaths_master_skeletor | real | | |
kills_master_zombie_knight | real | | |
kills_master_zombie_soldier | real | | |
kills_master_lonely_spider | real | | |
deaths_master_watcher_bonzo | real | | |
kills_master_professor_guardian_summon | real | | |
deaths_master_professor_mage_guardian | real | | |
kills_master_super_tank_zombie | real | | |
kills_master_spirit_bat | real | | |
deaths_master_zombie_soldier | real | | |
deaths_master_livid_clone | real | | |
deaths_master_sniper_skeleton | real | | |
kills_master_watcher_bonzo | real | | |
deaths_master_spirit_bat | real | | |
deaths_master_spirit_sheep | real | | |
deaths_master_spirit_rabbit | real | | |
deaths_master_professor_guardian_summon | real | | |
kills_master_crypt_witherskeleton | real | | |
deaths_master_watcher_scarf | real | | |
kills_master_crypt_undead_pieter | real | | |
kills_master_spirit_wolf | real | | |
kills_master_spirit_rabbit | real | | |
kills_master_spirit_sheep | real | | |
kills_master_spirit_bull | real | | |
deaths_master_shadow_assassin | real | | |
deaths_master_spirit_chicken | real | | |
kills_master_tentaclees | real | | |
deaths_master_tentaclees | real | | |
kills_master_super_archer | real | | |
kills_master_shadow_assassin | real | | |
deaths_master_crypt_witherskeleton | real | | |
deaths_master_crypt_dreadlord | real | | |
deaths_master_skeleton_master | real | | |
deaths_master_zombie_knight | real | | |
deaths_master_livid | real | | |
deaths_master_crypt_souleater | real | | |
pumpkin_launcher_count | real | | |
kills_shrine_charged_creeper | real | | |
kills_shrine_skeleton_horseman | real | | |
deaths_master_diamond_guy | real | | |
deaths_master_dungeon_respawning_skeleton | real | | |
deaths_master_skeleton_grunt | real | | |
kills_oasis_rabbit | real | | |
kills_master_spirit_chicken | real | | |
kills_master_spirit_miniboss | real | | |
deaths_master_spirit_miniboss | real | | |
kills_voidling_fanatic | real | | |
kills_voidling_extremist | real | | |
deaths_voidling_extremist | real | | |
deaths_voidling_fanatic | real | | |
kills_voidling_enderman | real | | |
kills_thyst | real | | |
kills_sludge | real | | |
kills_automaton | real | | |
kills_key_guardian | real | | |
deaths_automaton | real | | |
kills_team_treasurite_viper | real | | |
kills_team_treasurite_sebastian | real | | |
kills_yog | real | | |
kills_goblin_flamethrower | real | | |
kills_team_treasurite_wendy | real | | |
kills_belle | real | | |
kills_fire_bat | real | | |
kills_worm | real | | |
kills_team_treasurite_grunt | real | | |
deaths_yog | real | | |
kills_silvo | real | | |
deaths_kalhuiki_tribe_man | real | | |
deaths_kalhuiki_tribe_woman | real | | |
kills_butterfly | real | | |
kills_cavitak | real | | |
deaths_sludge | real | | |
kills_trapped_sludge | real | | |
kills_team_treasurite_corleone | real | | |
kills_smog | real | | |
kills_vittomite | real | | |
kills_kalhuiki_elder | real | | |
kills_kalhuiki_tribe_man | real | | |
kills_kalhuiki_youngling | real | | |
kills_scatha | real | | |
deaths_master_crypt_tank_zombie | real | | |
kills_lava_pigman | real | | |
kills_lava_blaze | real | | |
kills_kalhuiki_tribe_woman | real | | |
deaths_zombie_commander | real | | |
deaths_entity | real | | |
kills_flaming_worm | real | | |
deaths_team_treasurite_corleone | real | | |
deaths_master_spirit_wolf | real | | |
kills_master_crypt_undead_valentin | real | | |
kills_master_crypt_undead_nicholas | real | | |
kills_master_crypt_undead_christian | real | | |
kills_master_crypt_undead_friedrich | real | | |
deaths_master_sadan_giant | real | | |
deaths_master_sadan_statue | real | | |
kills_master_skeletor_prime | real | | |
deaths_voracious_spider | real | | |
deaths_voidling_enderman | real | | |
total_pet_exp_gained | real | | |
highest_damage | double precision | | |
sea_creature_kills | real | | |
deaths_master_professor | real | | |
kills_water_worm | real | | |
kills_poisoned_water_worm | real | | |
deaths_goldor | real | | |
deaths_storm | real | | |
deaths_necron | real | | |
kills_master_sadan_statue | real | | |
deaths_master_skeletor_prime | real | | |
deaths_master_sadan_golem | real | | |
kills_master_mimic | real | | |
deaths_watcher_giant_diamond | real | | |
kills_master_crypt_undead_alexander | real | | |
kills_master_skeleton_lord | real | | |
kills_master_zombie_commander | real | | |
kills_master_wither_guard | real | | |
deaths_master_maxor | real | | |
kills_master_crypt_undead_marius | real | | |
deaths_master_super_archer | real | | |
kills_master_sadan_golem | real | | |
deaths_master_zombie_commander | real | | |
kills_master_wither_miner | real | | |
deaths_master_goldor | real | | |
kills_dive_ghast | real | | |
kills_intro_blaze | real | | |
kills_barbarian | real | | |
kills_fire_mage | real | | |
kills_charging_mushroom_cow | real | | |
kills_vanquisher | real | | |
kills_baby_magma_slug | real | | |
deaths_barbarians_guard | real | | |
kills_flaming_spider | real | | |
kills_magma_cube_rider | real | | |
kills_magma_slug | real | | |
kills_moogma | real | | |
kills_lava_leech | real | | |
deaths_barbarian_duke_x | real | | |
kills_dojo_knockback_zombie | real | | |
deaths_charging_mushroom_cow | real | | |
deaths_smoldering_blaze | real | | |
kills_fire_eel | real | | |
items_fished_trophy_fish | real | | |
kills_pyroclastic_worm | real | | |
kills_lava_flame | real | | |
kills_pig_rider | real | | |
kills_wither_spectre | real | | |
deaths_mage_outlaw | real | | |
deaths_magma_boss | real | | |
kills_magma_glare | real | | |
kills_unstable_magma | real | | |
kills_mage_skull | real | | |
kills_mage_outlaw | real | | |
deaths_ashfang | real | | |
kills_magma_boss | real | | |
deaths_magma_glare | real | | |
deaths_hellwisp | real | | |
kills_hellwisp | real | | |
deaths_unstable_magma | real | | |
kills_bezal | real | | |
kills_mutated_blaze | real | | |
deaths_bladesoul | real | | |
kills_bladesoul | real | | |
kills_wither_defender_guard | real | | |
kills_duelist_rollim | real | | |
deaths_kuudra_knocker | real | | |
kills_smoldering_blaze | real | | |
deaths_flare | real | | |
kills_barbarians_guard | real | | |
deaths_pyroclastic_worm | real | | |
deaths_pig_rider | real | | |
deaths_thunder | real | | |
kills_thunder | real | | |
deaths_moogma | real | | |
kills_livid_clone | real | | |
kills_livid | real | | |
kills_kuudra | real | | |
deaths_goliath_barbarian | real | | |
kills_ashfang_red_blaze | real | | |
deaths_kuudra_landmine | real | | |
deaths_kuudra_follower | real | | |
kills_barbarian_duke_x | real | | |
kills_matcho | real | | |
deaths_ashfang_red_blaze | real | | |
deaths_ashfang_blue_blaze | real | | |
kills_ashfang | real | | |
deaths_dive_ghast | real | | |
kills_flare | real | | |
deaths_lord_jawbus | real | | |
kills_pack_magma_cube | real | | |
kills_kada_knight | real | | |
kills_lord_jawbus | real | | |
deaths_magma_slug | real | | |
deaths_lava_flame | real | | |
deaths_master_wither_miner | real | | |
deaths_baby_magma_slug | real | | |
deaths_fire_eel | real | | |
kills_cinder_bat | real | | |
deaths_old_blaze | real | | |
kills_sadan | real | | |
deaths_lava_leech | real | | |
kills_taurus | real | | |
kills_bonzo | real | | |
deaths_ashfang_gray_blaze | real | | |
kills_inferno_blaze | real | | |
deaths_pig_zombie | real | | |
kills_old_blaze | real | | |
deaths_inferno_blaze | real | | |
deaths_wandering_blaze | real | | |
deaths_bezal | real | | |
glowing_mushrooms_broken | real | | |
kills_professor_archer_guardian | real | | |
kills_professor_priest_guardian | real | | |
kills_professor_mage_guardian | real | | |
kills_professor_warrior_guardian | real | | |
kills_professor | real | | |
kills_nest_endermite | real | | |
dragon_most_damage | real | | |
dragon_most_damage_unstable | real | | |
dragon_highest_rank | real | | |
dragon_highest_rank_unstable | real | | |
dragon_fastest_kill | real | | |
dragon_fastest_kill_unstable | real | | |
dragon_most_damage_protector | real | | |
dragon_highest_rank_protector | real | | |
dragon_fastest_kill_protector | real | | |
dragon_amount_summoned | real | | |
dragon_amount_summoned_protector | real | | |
dragon_summoning_eyes_contributed | real | | |
dragon_summoning_eyes_contributed_protector | real | | |
dragon_most_damage_wise | real | | |
dragon_highest_rank_wise | real | | |
dragon_fastest_kill_wise | real | | |
kills_zealot_bruiser | real | | |
dragon_amount_summoned_young | real | | |
dragon_summoning_eyes_contributed_young | real | | |
dragon_most_damage_young | real | | |
dragon_highest_rank_young | real | | |
dragon_fastest_kill_young | real | | |
deaths_giant | real | | |
dragon_fastest_kill_old | real | | |
summoning_eyes_collected | real | | |
deaths_aranya | real | | |
dragon_most_damage_strong | real | | |
dragon_fastest_kill_strong | real | | |
dragon_amount_summoned_wise | real | | |
dragon_summoning_eyes_contributed_wise | real | | |
dragon_most_damage_superior | real | | |
dragon_highest_rank_superior | real | | |
dragon_fastest_kill_superior | real | | |
dragon_highest_rank_strong | real | | |
dragon_amount_summoned_unstable | real | | |
dragon_summoning_eyes_contributed_unstable | real | | |
dragon_most_damage_old | real | | |
dragon_highest_rank_old | real | | |
deaths_omegagma | real | | |
deaths_magma_bacteria | real | | |
deaths_inferno_magma_cube | real | | |
kills_trapper_horse | real | | |
kills_master_bonzo | real | | |
kills_master_scarf | real | | |
kills_master_professor_priest_guardian | real | | |
kills_master_professor_warrior_guardian | real | | |
deaths_explosive_imp | real | | |
deaths_sea_walker | real | | |
deaths_generator_magma_cube | real | | |
deaths_wraith | real | | |
deaths_phantom_spirit | real | | |
deaths_scary_jerry | real | | |
deaths_phantom_fisherman | real | | |
deaths_witch_bat | real | | |
deaths_goblin_battler | real | | |
deaths_wither_gourd | real | | |
deaths_trick_or_treater | real | | |
kills_zombie_miner | real | | |
deaths_treasure_hoarder | real | | |
deaths_wither_defender_guard | real | | |
kills_ashfang_blue_blaze | real | | |
deaths_wither_spectre | real | | |
deaths_vanquisher | real | | |
deaths_zealot_bruiser | real | | |
dragon_amount_summoned_old | real | | |
dragon_summoning_eyes_contributed_old | real | | |
dragon_amount_summoned_superior | real | | |
dragon_summoning_eyes_contributed_superior | real | | |
dragon_amount_summoned_strong | real | | |
dragon_summoning_eyes_contributed_strong | real | | |
deaths_horseman_horse | real | | |
kills_chickzilla | real | | |
kills_ashfang_vehicle | real | | |
kills_nutcracker | real | | |
deaths_sea_witch | real | | |
kills_scarf | real | | |
deaths_mutated_blaze | real | | |
kills_crypt_undead_hypixel | real | | |
kills_crypt_undead_flameboy101 | real | | |
deaths_matcho | real | | |
deaths_fire_mage | real | | |
deaths_kada_chicken | real | | |
deaths_pack_magma_cube | real | | |
deaths_bal_boss | real | | |
kills_goliath_barbarian | real | | |
deaths_sea_archer | real | | |
deaths_creeper | real | | |
deaths_random_slime | real | | |
deaths_mimic | real | | |
deaths_zombie_lord | real | | |
deaths_master_watcher_guardian | real | | |
kills_master_watcher_scarf | real | | |
deaths_master_crypt_undead | real | | |
kills_master_king_midas | real | | |
deaths_master_dungeon_respawning_skeleton_skull | real | | |
deaths_master_super_tank_zombie | real | | |
deaths_master_sadan | real | | |
kills_master_sadan_giant | real | | |
kills_master_watcher_livid | real | | |
deaths_master_mimic | real | | |
deaths_master_crypt_undead_nitroholic_ | real | | |
deaths_master_watcher_livid | real | | |
deaths_master_deathmite | real | | |
deaths_master_lonely_spider | real | | |
deaths_master_king_midas | real | | |
deaths_master_storm | real | | |
kills_master_zombie_lord | real | | |
kills_master_wither_husk | real | | |
kills_master_necron_guard | real | | |
kills_master_wither_king_dragon | real | | |
deaths_master_wither_guard | real | | |
deaths_master_wither_king | real | | |
deaths_master_necron | real | | |
deaths_master_zombie_lord | real | | |
deaths_master_crypt_undead_hypixel | real | | |
kills_master_watcher_giant_diamond | real | | |
kills_master_watcher_giant_bigfoot | real | | |
kills_master_watcher_giant_boulder | real | | |
kills_master_watcher_giant_laser | real | | |
deaths_pulverized | real | | |
deaths_mages_guard | real | | |
deaths_chickzilla | real | | |
deaths_blight | real | | |
deaths_wither_sentry | real | | |
deaths_blazing_golem | real | | |
deaths_chaosmite | real | | |
deaths_kuudra_berserker | real | | |
kills_master_livid | real | | |
kills_master_livid_clone | real | | |
kills_crypt_undead_codename_b | real | | |
kills_crypt_undead_relenter | real | | |
kills_crypt_undead_sfarnham | real | | |
kills_crypt_undead_nitroholic_ | real | | |
kills_crypt_undead_likaos | real | | |
kills_crypt_undead_jayavarmen | real | | |
kills_crypt_undead_dctr | real | | |
kills_crypt_undead_connorlinfoot | real | | |
kills_crypt_undead_minikloon | real | | |
kills_crypt_undead_apunch | real | | |
kills_crypt_undead_bembo | real | | |
kills_crypt_undead_robitybobity | real | | |
kills_crypt_undead_agentk | real | | |
kills_crypt_undead_thorlon | real | | |
kills_crypt_undead_luckykessie | real | | |
kills_crypt_undead_williamtiger | real | | |
kills_crypt_undead_orangemarshall | real | | |
kills_crypt_undead_sylent | real | | |
kills_crypt_undead_externalizable | real | | |
kills_crypt_undead_plancke | real | | |
kills_crypt_undead_jamiethegeek | real | | |
kills_crypt_undead_ladybleu | real | | |
kills_crypt_undead_rezzus | real | | |
kills_crypt_undead_skyerzz | real | | |
kills_crypt_undead_bloozing | real | | |
kills_crypt_undead_erosemberg | real | | |
kills_crypt_undead_judg3 | real | | |
kills_crypt_undead_revengeee | real | | |
kills_crypt_undead_donpireso | real | | |
kills_crypt_undead_pjoke1 | real | | |
kills_crypt_undead_cecer | real | | |
kills_crypt_undead_chilynn | real | | |
deaths_watcher_giant_laser | real | | |
deaths_master_professor_archer_guardian | real | | |
deaths_master_professor_priest_guardian | real | | |
kills_master_deathmite | real | | |
deaths_master_crypt_undead_likaos | real | | |
kills_krondor_necromancer | real | | |
kills_mages_guard | real | | |
kills_master_sadan | real | | |
kills_duelist_kaus | real | | |
deaths_skeleton_lord | real | | |
kills_master_thorn | real | | |
deaths_master_crypt_undead_relenter | real | | |
deaths_master_crypt_undead_apunch | real | | |
deaths_master_crypt_undead_codename_b | real | | |
deaths_master_parasite | real | | |
deaths_team_treasurite_viper | real | | |
deaths_master_crypt_undead_dctr | real | | |
deaths_master_watcher_giant_diamond | real | | |
deaths_master_wither_king_dragon | real | | |
deaths_master_wither_husk | real | | |
deaths_master_watcher_giant_bigfoot | real | | |
deaths_master_watcher_giant_laser | real | | |
deaths_master_skeleton_lord | real | | |
deaths_frosty_the_snowman | real | | |
deaths_scarf_archer | real | | |
deaths_kill | real | | |
deaths_master_crypt_undead_donpireso | real | | |
kills_master_crypt_undead_sfarnham | real | | |
kills_master_crypt_undead_likaos | real | | |
kills_master_crypt_undead_nitroholic_ | real | | |
kills_master_crypt_undead_codename_b | real | | |
kills_master_crypt_undead_relenter | real | | |
kills_master_crypt_undead_minikloon | real | | |
kills_master_crypt_undead_apunch | real | | |
kills_master_crypt_undead_jayavarmen | real | | |
deaths_team_treasurite_wendy | real | | |
deaths_nutcracker | real | | |
deaths_master_bonzo_summon_undead | real | | |
deaths_krondor_necromancer | real | | |
deaths_ghast | real | | |
special_zealot_loot_collected | real | | |
kills_krondor_necromancer_summon | real | | |
kills_master_professor_archer_guardian | real | | |
kills_master_professor | real | | |
kills_master_professor_mage_guardian | real | | |
vampire | real | | |
pet_score | real | | |
fairy_souls | real | | |
minion_slots | real | | |
maxed_slayers | real | | |
maxed_collections | real | | |
healer_xp | real | | |
mage_xp | real | | |
berserk_xp | real | | |
archer_xp | real | | |
tank_xp | real | | |
mage_reputation | real | | |
barbarian_reputation | real | | |
skills_xp | real | | |
selected_class | real | | |
museum | real | | |
museum_hypixel | real | | |
cole_weight | real | | |
bestiary | real | | |
class_average | real | | |
gamemode | real | | |
emblem | real | | |
farming_cap | real | | |
dungeon_secrets | real | | |
runecrafting_xp | real | | |
Indexes:
"all_lb_pkey" PRIMARY KEY, btree (uuid)
"all_lb_networth_idx" btree (networth)
"all_lb_username_idx" gist (username gist_trgm_ops)
Used for tracking guilds for "/serverlb" command
Table "public.guild"
Column | Type | Collation | Nullable | Default
-----------------+-----------------------+-----------+----------+---------
guild_id | character varying(32) | | not null |
request_time | bigint | | not null |
members | jsonb | | not null |
request_discord | text | | not null |
guild_name | text | | not null |
Indexes:
"guild_pkey" PRIMARY KEY, btree (guild_id)
Used to cache JSON responses from the Hypixel API
Table "public.json_cache"
Column | Type | Collation | Nullable | Default
--------+------------------------+-----------+----------+---------
id | character varying(255) | | not null |
expiry | bigint | | not null |
data | jsonb | | not null |
Indexes:
"json_cache_pkey" PRIMARY KEY, btree (id)
Persistent cache for features like auction tracker, dungeon parties, etc
Table "public.json_storage"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
id | integer | | not null |
data | jsonb | | not null |
Indexes:
"json_storage_pkey" PRIMARY KEY, btree (id)
Storage for hastes
Table "public.haste"
Column | Type | Collation | Nullable | Default
--------+--------+-----------+----------+-------------------
id | uuid | | not null | gen_random_uuid()
expiry | bigint | | not null |
data | text | | not null |
Indexes:
"haste_pkey" PRIMARY KEY, btree (id)