-- users channel_mutes
ALTER TABLE IF EXISTS users
ADD COLUMN IF NOT EXISTS channel_mutes TEXT DEFAULT '[]';

-- users is_deactivated
ALTER TABLE IF EXISTS users
ADD COLUMN IF NOT EXISTS is_deactivated INT DEFAULT 0;

-- apps storage_capacity
ALTER TABLE IF EXISTS apps
ADD COLUMN IF NOT EXISTS storage_capacity TEXT DEFAULT '"Tier1"';

-- letters replying_to
ALTER TABLE IF EXISTS letters
ADD COLUMN IF NOT EXISTS replying_to BIGINT DEFAULT 0;

-- communities is_forum
ALTER TABLE IF EXISTS communities
ADD COLUMN IF NOT EXISTS is_forum INT DEFAULT 0;

-- communities topics
ALTER TABLE IF EXISTS communities
ADD COLUMN IF NOT EXISTS topics TEXT DEFAULT '{}';

-- posts topic
ALTER TABLE IF EXISTS posts
ADD COLUMN IF NOT EXISTS topic BIGINT DEFAULT 0;

-- users ban_expire
ALTER TABLE IF EXISTS users
ADD COLUMN IF NOT EXISTS ban_expire BIGINT DEFAULT 0;

-- remove users seller_data
ALTER TABLE IF EXISTS users
DROP COLUMN IF EXISTS seller_data;

-- users coins
ALTER TABLE IF EXISTS users
ADD COLUMN IF NOT EXISTS coins INT DEFAULT 0;

-- requests data
ALTER TABLE IF EXISTS requests
ADD COLUMN IF NOT EXISTS data TEXT DEFAULT '"Null"';

-- users checkouts
ALTER TABLE IF EXISTS users
ADD COLUMN IF NOT EXISTS checkouts TEXT DEFAULT '[]';

-- products single_use
ALTER TABLE IF EXISTS products
ADD COLUMN IF NOT EXISTS single_use INT DEFAULT 1;

-- transfers source
ALTER TABLE IF EXISTS transfers
ADD COLUMN IF NOT EXISTS source TEXT DEFAULT '"General"';

-- products data
ALTER TABLE IF EXISTS products
ADD COLUMN IF NOT EXISTS data TEXT DEFAULT '';

-- users applied_configurations
ALTER TABLE IF EXISTS users
ADD COLUMN IF NOT EXISTS applied_configurations TEXT DEFAULT '[]';

-- products uploads
ALTER TABLE IF EXISTS products
ADD COLUMN IF NOT EXISTS uploads TEXT DEFAULT '{}';

-- users last_policy_consent
ALTER TABLE IF EXISTS users
ADD COLUMN IF NOT EXISTS last_policy_consent BIGINT DEFAULT 0;

-- letters likes
ALTER TABLE IF EXISTS letters
ADD COLUMN IF NOT EXISTS likes INT DEFAULT 0;

-- letters dislikes
ALTER TABLE IF EXISTS letters
ADD COLUMN IF NOT EXISTS dislikes INT DEFAULT 0;

-- users close_friends_stack
ALTER TABLE IF EXISTS users
ADD COLUMN IF NOT EXISTS close_friends_stack BIGINT DEFAULT 0;

-- stacks is_locked
ALTER TABLE IF EXISTS stacks
ADD COLUMN IF NOT EXISTS is_locked INT DEFAULT 0;

-- users missed_messages_count
ALTER TABLE IF EXISTS users
ADD COLUMN IF NOT EXISTS missed_messages_count INT DEFAULT 0;

-- users channel_mutes
ALTER TABLE IF EXISTS users
DROP COLUMN IF EXISTS channel_mutes;

-- guest_logs ip
ALTER TABLE IF EXISTS guest_logs
ADD COLUMN IF NOT EXISTS ip TEXT DEFAULT '';

-- posts views
ALTER TABLE IF EXISTS posts
ADD COLUMN IF NOT EXISTS views INT DEFAULT 0;

-- users views
ALTER TABLE IF EXISTS users
ADD COLUMN IF NOT EXISTS views INT DEFAULT 0;

-- users views
ALTER TABLE IF EXISTS users
ADD COLUMN IF NOT EXISTS shrimpcamp_link BIGINT DEFAULT 0;

-- users browser_session
ALTER TABLE IF EXISTS users DROP COLUMN IF EXISTS browser_session;

-- users coins
ALTER TABLE IF EXISTS users DROP COLUMN IF EXISTS coins;

-- users applied_configurations
ALTER TABLE IF EXISTS users DROP COLUMN IF EXISTS applied_configurations;

-- communities is_forge
ALTER TABLE IF EXISTS communities DROP COLUMN IF EXISTS is_forge;

-- communities is_open
ALTER TABLE IF EXISTS posts DROP COLUMN IF EXISTS is_open;
