DELIMITER $$
USE `mic_db_out`$$
DROP TRIGGER /*!50032 IF EXISTS */ `customerinfo_insert`$$
CREATE
/*!50017 DEFINER = 'admin'@'localhost' */
TRIGGER `customerinfo_insert` AFTER INSERT ON `t_customerinfo`
FOR EACH ROW BEGIN
DECLARE chn_exist INT(10);
INSERT INTO `mic_db_out`.`t_customerinfo_tmp`(
UID ,
SID ,
IMSI ,
IMEI ,
ICCID ,
OS ,
OSVersion ,
MEMORY ,
Sdcard ,
ModelName ,
BrandName ,
md5Value ,
SN ,
regTime ,
mac ,
Batch ,
WifiTraffic ,
MobileTraffic ,
Operator ,
ContactNum ,
Latitude ,
Longitude ,
SmsNum ,
Root ,
WifiLocation ,
SCellLocation
) VALUES(
NEW.UID ,
NEW.SID ,
NEW.IMSI ,
NEW.IMEI ,
NEW.ICCID ,
NEW.OS ,
NEW.OSVersion ,
NEW.MEMORY ,
NEW.Sdcard ,
NEW.ModelName ,
NEW.BrandName ,
NEW.md5Value ,
NEW.SN ,
NEW.regTime ,
NEW.mac ,
NEW.Batch ,
NEW.WifiTraffic ,
NEW.MobileTraffic ,
NEW.Operator ,
NEW.ContactNum ,
NEW.Latitude ,
NEW.Longitude ,
NEW.SmsNum ,
NEW.Root ,
NEW.WifiLocation ,
NEW.SCellLocation
);
SET chn_exist = (SELECT COUNT(*) FROM `mic_db_out`.t_channel WHERE Batch=NEW.Batch);
IF(chn_exist <= 0) THEN
INSERT INTO `mic_db_out`.`t_channel`(BrandName, ModelName, Batch) VALUES (NEW.BrandName, NEW.ModelName, NEW.Batch);
END IF;
END;
$$
DELIMITER ;
USE `mic_db_out`$$
DROP TRIGGER /*!50032 IF EXISTS */ `customerinfo_insert`$$
CREATE
/*!50017 DEFINER = 'admin'@'localhost' */
TRIGGER `customerinfo_insert` AFTER INSERT ON `t_customerinfo`
FOR EACH ROW BEGIN
DECLARE chn_exist INT(10);
INSERT INTO `mic_db_out`.`t_customerinfo_tmp`(
UID ,
SID ,
IMSI ,
IMEI ,
ICCID ,
OS ,
OSVersion ,
MEMORY ,
Sdcard ,
ModelName ,
BrandName ,
md5Value ,
SN ,
regTime ,
mac ,
Batch ,
WifiTraffic ,
MobileTraffic ,
Operator ,
ContactNum ,
Latitude ,
Longitude ,
SmsNum ,
Root ,
WifiLocation ,
SCellLocation
) VALUES(
NEW.UID ,
NEW.SID ,
NEW.IMSI ,
NEW.IMEI ,
NEW.ICCID ,
NEW.OS ,
NEW.OSVersion ,
NEW.MEMORY ,
NEW.Sdcard ,
NEW.ModelName ,
NEW.BrandName ,
NEW.md5Value ,
NEW.SN ,
NEW.regTime ,
NEW.mac ,
NEW.Batch ,
NEW.WifiTraffic ,
NEW.MobileTraffic ,
NEW.Operator ,
NEW.ContactNum ,
NEW.Latitude ,
NEW.Longitude ,
NEW.SmsNum ,
NEW.Root ,
NEW.WifiLocation ,
NEW.SCellLocation
);
SET chn_exist = (SELECT COUNT(*) FROM `mic_db_out`.t_channel WHERE Batch=NEW.Batch);
IF(chn_exist <= 0) THEN
INSERT INTO `mic_db_out`.`t_channel`(BrandName, ModelName, Batch) VALUES (NEW.BrandName, NEW.ModelName, NEW.Batch);
END IF;
END;
$$
DELIMITER ;