为solr数据更新创建trigger

515439429

DELIMITER |
CREATE TRIGGER messageinsert AFTER INSERT ON message
FOR EACH ROW BEGIN
INSERT INTO solrmonitor set mid= NEW.mid,flag=0;
END
|
DELIMITER ;
DELIMITER |
CREATE TRIGGER messageupdate AFTER UPDATE ON message
FOR EACH ROW BEGIN
INSERT IGNORE INTO solrmonitor set mid= NEW.mid;
UPDATE solrmonitor set last_modified = now(),flag=0 where mid= NEW.mid;
END
|
DELIMITER ;

DELIMITER |
CREATE TRIGGER messagedelete AFTER DELETE ON message
FOR EACH ROW BEGIN
INSERT IGNORE INTO solrmonitor set mid= OLD.mid,flag=1;
UPDATE solrmonitor set last_modified = now(),flag=1 where mid= OLD.mid;
END
|
DELIMITER ;