move votes out of leaderboards table to user table
@@ -13,7 +13,8 @@ CREATE TABLE IF NOT EXISTS users(
vault_bal int, -- amount of emerald BLOCKS which are currently in the vault
vault_max int, -- maximum amount of emerald BLOCKS which can be stored in the vault
health int, -- user health, out of 20
- votes int, -- total votes on sites like disbots.gg and top.gg
+ disbots_votes int, -- votes on disbots.gg
+ topgg_votes int, -- votes on top.gg
bot_banned bool -- is banned from using the bot
);
@@ -34,9 +35,7 @@ CREATE TABLE IF NOT EXISTS leaderboards(
uid bigint,
pillages int, -- number of pillages
pillages_amount bigint, -- number of pillaged emeralds
- mobs_killed bigint,
- topgg_votes int,
- disbots_votes int
+ mobs_killed bigint
);
CREATE TABLE IF NOT EXISTS warnings( -- moderation warnings
