zkxw/docs/sql/migrations/2026-10-23-oa-mention-view-grant-is-read.sql

-- OA「提到我的」未读：oa_instance_view_grant.is_read
-- 存量行置已读，避免上线后角标暴涨

ALTER TABLE `oa_instance_view_grant`
  ADD COLUMN `is_read` SMALLINT NOT NULL DEFAULT 0 COMMENT '是否已读 0未读 1已读' AFTER `granted_by`;

UPDATE `oa_instance_view_grant` SET `is_read` = 1 WHERE `del_flag` = 0;