move bot bans values back into users table
@@ -17,6 +17,7 @@ CREATE TABLE IF NOT EXISTS warnings (
CREATE TABLE IF NOT EXISTS users ( -- used for economy stuff
user_id BIGINT PRIMARY KEY, -- the discord user id / snowflake
+ bot_banned BOOLEAN NOT NULL DEFAULT false, -- whether the user is botbanned or not
emeralds BIGINT NOT NULL DEFAULT 0, -- the amount of emeralds the user has
vault_balance INT NOT NULL DEFAULT 0, -- the amount of emerald blocks in their vault
vault_max INT NOT NULL DEFAULT 1, -- the maximum amount of emerald blocks in their vault
@@ -26,10 +27,6 @@ CREATE TABLE IF NOT EXISTS users ( -- used for economy stuff
give_alert BOOLEAN NOT NULL DEFAULT true -- whether users should be alerted if someone gives them items or emeralds or not
);
-CREATE TABLE IF NOT EXISTS user_bans ( -- if a user exists here, they're bot-banned
- user_id BIGINT PRIMARY KEY
-);
-
CREATE TABLE IF NOT EXISTS items (
user_id BIGINT PRIMARY KEY REFERENCES users (user_id) ON DELETE CASCADE, -- the discord user id / snowflake
name VARCHAR(50) NOT NULL, -- the name of the item
