--TCOMANDOSMANTENIMIENTO 05-6043
delete  from tcomandosmantenimiento WHERE CSUBSISTEMA='05' AND CTRANSACCION='6043';
delete TCOMANDOS where COMANDO='com.fitbank.term.maintenance.BlockNotificacion';
delete TCOMANDOSID where COMANDO='com.fitbank.term.maintenance.BlockNotificacion';

insert into TCOMANDOSID (COMANDO, TIPOCOMANDO) values ('com.fitbank.term.maintenance.BlockNotificacion', 'MAN');
insert into TCOMANDOS (COMANDO, TIPOCOMANDO, FHASTA, CIDIOMA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('com.fitbank.term.maintenance.BlockNotificacion', 'MAN', fncfhasta, 'ES', fncsysdate, 'Envia un correo electronico para confirmar el bloqueo de un deposito', 0);

insert into TCOMANDOSMANTENIMIENTO (CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, SCOMANDO, EVENTO, COMANDO, ORDEN, USACACHE, TIPOCOMANDO, ACTIVADO, CANALESEXCLUIDOS, PARAMETRO, VERSIONCONTROL, EJECUTADOPOR) values ('05', '6043', '01', 1, 'I', 'com.fitbank.term.validate.PermitTableBlocked', 1, '0', 'MAN', '1', null, null, 0, null);
insert into TCOMANDOSMANTENIMIENTO (CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, SCOMANDO, EVENTO, COMANDO, ORDEN, USACACHE, TIPOCOMANDO, ACTIVADO, CANALESEXCLUIDOS, PARAMETRO, VERSIONCONTROL, EJECUTADOPOR) values ('05', '6043', '01', 2, 'I', 'com.fitbank.processor.maintenance.MaintenanceProcessor', 2, '0', 'MAN', '1', null, null, 0, null);
insert into TCOMANDOSMANTENIMIENTO (CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, SCOMANDO, EVENTO, COMANDO, ORDEN, USACACHE, TIPOCOMANDO, ACTIVADO, CANALESEXCLUIDOS, PARAMETRO, VERSIONCONTROL, EJECUTADOPOR) values ('05', '6043', '01', 3, 'I', 'com.fitbank.term.maintenance.BlockNotificacion', 3, '0', 'MAN', '1', null, null, 0, null);
insert into TCOMANDOSMANTENIMIENTO (CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, SCOMANDO, EVENTO, COMANDO, ORDEN, USACACHE, TIPOCOMANDO, ACTIVADO, CANALESEXCLUIDOS, PARAMETRO, VERSIONCONTROL, EJECUTADOPOR) values ('05', '6043', '01', 4, 'I', 'com.fitbank.bpm.maintenance.MailNotificationSender', 4, '0', 'MAN', '1', null, null, 0, null);

--BATCH
delete from TSUBSISTEMAEVENTOSTRANSACCION where cevento='AUTOMATICUNLOCK';
delete from TSUBSISTEMAEVENTOS where cevento='AUTOMATICUNLOCK';
delete from TCODIGOSPROCESARID where CCODIGOPROCESAR='AUTOMATICUNLOCK';
delete from TSUBSISTEMAEVENTOSID where cevento='AUTOMATICUNLOCK';

delete from TSUBSISTEMAPROCESOS where COMANDO='com.fitbank.term.batch.process.acco.AutomaticUnlock';
delete from TCOMANDOS where COMANDO='com.fitbank.term.batch.process.acco.AutomaticUnlock';
delete from TCOMANDOSID where COMANDO='com.fitbank.term.batch.process.acco.AutomaticUnlock';

delete from TSUBSISTEMAPROCESOS where COMANDO='com.fitbank.term.batch.auxiliar.AutomaticUnlock';
delete from TCOMANDOS where COMANDO='com.fitbank.term.batch.auxiliar.AutomaticUnlock';
delete from TCOMANDOSID where COMANDO='com.fitbank.term.batch.auxiliar.AutomaticUnlock';

insert into TSUBSISTEMAEVENTOSID (CEVENTO, CSUBSISTEMA, CPERSONA_COMPANIA) values ('AUTOMATICUNLOCK', '05', 2);
insert into TSUBSISTEMAEVENTOS (CEVENTO, CSUBSISTEMA, CIDIOMA, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('AUTOMATICUNLOCK', '05', 'ES', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2008-05-22 15:35:43', 'Desbloqueo automatico', 0);
insert into TSUBSISTEMAEVENTOSTRANSACCION (CEVENTO, CSUBSISTEMA, CPERSONA_COMPANIA, FHASTA, FDESDE, CSUBSISTEMA_TRANSACCION, CTRANSACCION, VERSIONTRANSACCION, RUBRO, VERSIONCONTROL) values ('AUTOMATICUNLOCK', '05', 2, TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2009-09-07 16:29:51', '05', '6044', '01',null, 0);
insert into TCODIGOSPROCESARID (CCODIGOPROCESAR, CSUBSISTEMA) values ('AUTOMATICUNLOCK', '05');

--comando process acco
insert into TCOMANDOSID (COMANDO, TIPOCOMANDO, CLASE) values ('com.fitbank.term.batch.process.acco.AutomaticUnlock', 'BCH', null);
insert into TCOMANDOS (COMANDO, TIPOCOMANDO, FHASTA, CIDIOMA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('com.fitbank.term.batch.process.acco.AutomaticUnlock', 'BCH', TIMESTAMP '2999-12-31 00:00:00', 'ES', TIMESTAMP '2008-07-22 19:06:05', 'Realiza el desbloqueo automatico de valores bloqueados', 0);

insert into TSUBSISTEMAPROCESOS (CPERSONA_COMPANIA, CSUBSISTEMA, CSUBSISTEMA_TRANSACCION, CTRANSACCION, VERSIONTRANSACCION, COMANDO, TIPOCOMANDO, FHASTA, FDESDE, ORDENPROCESO, LLENATABLATEMPORAL, EJECUTAFECHAPROXIMA, ACTIVO, VERSIONCONTROL) values (2, '05', '01', '2000', '01', 'com.fitbank.term.batch.process.acco.AutomaticUnlock', 'BCH', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2011-06-28 15:40:58', 33, '0', '0', '1', 0);

--comando auxiliar
insert into TCOMANDOSID (COMANDO, TIPOCOMANDO, CLASE) values ('com.fitbank.term.batch.auxiliar.AutomaticUnlock', 'BCH', null);
insert into TCOMANDOS (COMANDO, TIPOCOMANDO, FHASTA, CIDIOMA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('com.fitbank.term.batch.auxiliar.AutomaticUnlock', 'BCH', TIMESTAMP '2999-12-31 00:00:00', 'ES', TIMESTAMP '2008-07-22 19:06:05', 'Realiza el desbloqueo automatico de valores bloqueados', 0);

insert into TSUBSISTEMAPROCESOS (CPERSONA_COMPANIA, CSUBSISTEMA, CSUBSISTEMA_TRANSACCION, CTRANSACCION, VERSIONTRANSACCION, COMANDO, TIPOCOMANDO, FHASTA, FDESDE, ORDENPROCESO, LLENATABLATEMPORAL, EJECUTAFECHAPROXIMA, ACTIVO, VERSIONCONTROL) values (2, '05', '01', '2000', '01', 'com.fitbank.term.batch.auxiliar.AutomaticUnlock', 'BCH', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2008-09-29 17:40:12', 32, '1', '0', '1', 0);