...OT NULL DEFAULT '0', PRIMARY KEY (`mid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; #建立trigger 使用trigger来知道哪些帖子需要加入、更新、删除索引 CREATE TRIGGER imq AFTER INSERT ON pw_threads FOR EACH ROW insert into mq (tid, type) values(new.tid, 0); CREATE TRIGGER umq AFTER ...