group.sql

ALTER TABLE hilo.group_medal ADD expire_at DATETIME DEFAULT null NULL COMMENT '过期时间';
CREATE INDEX expire_at USING BTREE ON hilo.group_medal (expire_at);

ALTER TABLE hilo.res_medal ADD attr_type TINYINT UNSIGNED DEFAULT 1 NOT NULL COMMENT '勋章类型1.个人2.房间';
update res_medal set attr_type = 2 where name like '%房间%';
update res_medal set attr_type = 2 where id in (select res_medal_id from group_medal);