Files
IM-server-new/broker/migrate/mysql/V21__add_friend_blocked.sql

3 lines
149 B
SQL
Executable File

alter table t_friend add column `_blacked` tinyint DEFAULT 0 COMMENT "0, normal; 1, blacked";
update t_friend set `_blacked` = 1 where `_state` = 2;