-- ECR-049: WeChat identity + Java consult token on session

ALTER TABLE users ADD COLUMN IF NOT EXISTS wx_openid varchar(64) NULL;
ALTER TABLE users ADD COLUMN IF NOT EXISTS wx_unionid varchar(64) NULL;
ALTER TABLE users ADD COLUMN IF NOT EXISTS java_platform_user_id bigint NULL;

CREATE UNIQUE INDEX IF NOT EXISTS idx_users_wx_openid_unique
  ON users(wx_openid) WHERE wx_openid IS NOT NULL AND deleted_at IS NULL;

ALTER TABLE user_sessions ADD COLUMN IF NOT EXISTS java_access_token text NULL;