-- 为用户表添加 disable 字段:0 可用,1 禁用,默认 0 ALTER TABLE `user` ADD COLUMN `disable` tinyint NOT NULL DEFAULT 0 COMMENT '0可用 1禁用' AFTER `inside`; -- 解除封禁示例:UPDATE `user` SET `disable` = 0 WHERE `id` = ?; -- 封禁用户示例:UPDATE `user` SET `disable` = 1 WHERE `id` = ?;