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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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