1ALTER TABLE channel_members ADD COLUMN role TEXT;
2UPDATE channel_members SET role = CASE WHEN admin THEN 'admin' ELSE 'member' END;
3
4ALTER TABLE channels ADD COLUMN visibility TEXT NOT NULL DEFAULT 'members';