``` CREATE TABLE `cmf_voice_even_wheat_log` ( `id` int(100) unsigned NOT NULL AUTO_INCREMENT, `voice_id` int(100) NOT NULL COMMENT '房间id', `user_id` int(100) NOT NULL COMMENT '连麦人id', `status` int(1) NOT NULL DEFAULT '1' COMMENT '0申请中1进行中2拒绝连麦3结束连麦', `location` int(2) NOT NULL DEFAULT '1' COMMENT '1-10排序的位置', `gift_earnings` int(100) NOT NULL DEFAULT '0' COMMENT '累计收益', `the_gift_earnings` int(100) NOT NULL DEFAULT '0' COMMENT '本次直播收益', `user_nickname` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL, `avatar` varchar(255) NOT NULL COMMENT '连麦人头像', `addtime` int(11) NOT NULL DEFAULT '0' COMMENT '开始时间', `endtime` int(11) NOT NULL DEFAULT '0' COMMENT '结束时间', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `user_id` (`user_id`), KEY `voice_id` (`voice_id`), KEY `addtime` (`addtime`) ) ENGINE=InnoDB AUTO_INCREMENT=51431 DEFAULT CHARSET=utf8 COMMENT='连麦记录表'; CREATE DEFINER=`root`@`%` TRIGGER `wheat_online_insert` AFTER INSERT ON `cmf_voice_even_wheat_log` FOR EACH ROW BEGIN if new.status = 1 then UPDATE cmf_voice SET cmf_voice.wheat_online_num = wheat_online_num+1 WHERE cmf_voice.id = new.voice_id; end if; END; CREATE DEFINER=`root`@`%` TRIGGER `wheat_online_update` AFTER UPDATE ON `cmf_voice_even_wheat_log` FOR EACH ROW BEGIN SET @cnt = (SELECT wheat_online_num FROM cmf_voice WHERE id = new.voice_id limit 1); if new.status = 1 then UPDATE cmf_voice SET cmf_voice.wheat_online_num = wheat_online_num+1 WHERE cmf_voice.id = new.voice_id; elseif @cnt > 0 and new.status > 1 and old.status = 1 then UPDATE cmf_voice SET cmf_voice.wheat_online_num = wheat_online_num-1 WHERE cmf_voice.id = new.voice_id; end if; END; ```