DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel01_log`$$

create trigger `dialer`.`tg_cel01_log` AFTER UPDATE on `dialer`.`Celurescate01`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate01_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate01_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel02_log`$$

create trigger `dialer`.`tg_cel02_log` AFTER UPDATE on `dialer`.`Celurescate02`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate02_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate02_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel03_log`$$

create trigger `dialer`.`tg_cel03_log` AFTER UPDATE on `dialer`.`Celurescate03`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate03_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate03_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel04_log`$$

create trigger `dialer`.`tg_cel04_log` AFTER UPDATE on `dialer`.`Celurescate04`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate04_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate04_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel05_log`$$

create trigger `dialer`.`tg_cel05_log` AFTER UPDATE on `dialer`.`Celurescate05`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate05_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate05_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel06_log`$$

create trigger `dialer`.`tg_cel06_log` AFTER UPDATE on `dialer`.`Celurescate06`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate06_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate06_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel07_log`$$

create trigger `dialer`.`tg_cel07_log` AFTER UPDATE on `dialer`.`Celurescate07`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate07_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate07_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel08_log`$$

create trigger `dialer`.`tg_cel08_log` AFTER UPDATE on `dialer`.`Celurescate08`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate08_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate08_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel09_log`$$

create trigger `dialer`.`tg_cel09_log` AFTER UPDATE on `dialer`.`Celurescate`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate09_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate09_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel10_log`$$

create trigger `dialer`.`tg_cel10_log` AFTER UPDATE on `dialer`.`Celurescate10`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate10_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate10_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel11_log`$$

create trigger `dialer`.`tg_cel11_log` AFTER UPDATE on `dialer`.`Celurescate11`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate11_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate11_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel12_log`$$

create trigger `dialer`.`tg_cel12_log` AFTER UPDATE on `dialer`.`Celurescate12`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate12_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate12_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel13_log`$$

create trigger `dialer`.`tg_cel13_log` AFTER UPDATE on `dialer`.`Celurescate13`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate13_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate13_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel14_log`$$

create trigger `dialer`.`tg_cel14_log` AFTER UPDATE on `dialer`.`Celurescate14`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate14_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate14_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel15_log`$$

create trigger `dialer`.`tg_cel15_log` AFTER UPDATE on `dialer`.`Celurescate15`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate15_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate15_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cel16_log`$$

create trigger `dialer`.`tg_cel16_log` AFTER UPDATE on `dialer`.`Celurescate16`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`CeluRescate16_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`CeluRescate16_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;


DELIMITER $$

DROP TRIGGER `dialer`.`tg_cen01_log`$$

create trigger `dialer`.`tg_cen01_log` AFTER UPDATE on `dialer`.`Centennial01`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`Centennial01_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`Centennial01_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cen02_log`$$

create trigger `dialer`.`tg_cen02_log` AFTER UPDATE on `dialer`.`Centennial02`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`Centennial02_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`Centennial02_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cen03_log`$$

create trigger `dialer`.`tg_cen03_log` AFTER UPDATE on `dialer`.`Centennial03`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`Centennial03_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`Centennial03_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;

DELIMITER $$

DROP TRIGGER `dialer`.`tg_cen04_log`$$

create trigger `dialer`.`tg_cen04_log` AFTER UPDATE on `dialer`.`Centennial04`
for each row BEGIN
 declare var varchar(2);
 if(select count(phone) from `dialer`.`Centennial04_log` where disposition = 12
 and subdispo in('VT','VA') AND PHONE = old.phone)= 0 then
 set var = "V";
 else
 set var = "NV";
 end if;
 INSERT  INTO `dialer`.`Centennial04_log`
 VALUES ('',new.id, new.phone, new.title,new.name,new.address,new.city,new.state,new.zip,new.oc,new.paidamt,new.paiddate,new.comments,new.countynum,
 new.tzl,new.tzh,new.attempts,new.pickups,new.abandons,new.disposition,new.agent,new.closerdispo,
 new.closer,new.subdispo,new.lastupdated,new.cb_datetime,new.wdayl,new.wdayh,new.satl,
 new.sath,new.sunl,new.sunh,new.holl,new.holh,"update", NOW(),CURRENT_USER(),var);
 ENd;
$$

DELIMITER ;