Desenvolvimento Anibaltec

Categorias

Eventos e Gatilhos

-- --------------------------------------------------------

-- Servidor: 127.0.0.1

-- Versão do servidor: 5.6.47 - MySQL Community Server (GPL)

-- OS do Servidor: Win64

-- HeidiSQL Versão: 10.2.0.5599

-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET NAMES utf8 */;

/*!50503 SET NAMES utf8mb4 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Copiando estrutura para trigger lojas.Tr_acess_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_acess_Bd` BEFORE DELETE ON `acessos` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.login, ' da tabela acessos'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_ajes_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_ajes_Bd` BEFORE DELETE ON `ajestoq` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigo, ' ',old.descricao, ' da tabela ajestoq'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_band_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_band_Bd` BEFORE DELETE ON `bandeiras` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.cdopd, ' ',old.nmband, ' da tabela bandeiras'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_cadimp_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_cadimp_Bd` BEFORE DELETE ON `impressoras` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.marca, ' ', old.nserie, ' da tabela impressoras'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_caixa_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_caixa_Bd` BEFORE DELETE ON `caixa` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.oper, ' ',old.dtmov, ' da tabela caixa'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_cdemb_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_cdemb_Bd` BEFORE DELETE ON `embalagens` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codprod, ' unidade de compra ', old.undcmp, ' da tabela embalagens'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_celchip_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_celchip_Bd` BEFORE DELETE ON `celchip` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codprod, ' ',old.imei, ' da tabela celchip'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_cheqs_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_cheqs_Bd` BEFORE DELETE ON `cheques` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.numcheque, ' ',old.valor, ' da tabela cheques'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_cliente_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_cliente_Bd` BEFORE DELETE ON `cliente` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.chave, ' ',old.nomecliente, ' da tabela cliente'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_cnfcx_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_cnfcx_Bd` BEFORE DELETE ON `confcx` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.dtpg, ' valor em Dinheiro R$ ', old.cnfdin, ' da tabela confcx'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_compprd_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_compprd_Bd` BEFORE DELETE ON `composicao` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.coditem, ' DO PRODUTO PRINCIPAL ',old.codgrupo, ' da tabela composicao'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_condpg_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_condpg_Bd` BEFORE DELETE ON `condpagamento` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.chave, ' ',old.nome, ' da tabela condpagamento'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_contad_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_contad_Bd` BEFORE DELETE ON `contador` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.chave, ' ',old.nome, ' da tabela contador'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_contest_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_contest_Bd` BEFORE DELETE ON `contest` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.chave, ' ',old.notaf, ' da tabela contest'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_cte_Bi

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_cte_Bi` BEFORE INSERT ON `cte` FOR EACH ROW BEGIN DECLARE CodRam varchar(9); select concat(TIME_FORMAT(curtime(), '%H'), year(date_sub(Curdate(), interval 2006 year))) into CodRam from empresa limit 1; SET CodRam = Concat(CodRam, right(new.nrcte, 4)); SET new.cdram = CodRam; END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_cupatres_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_cupatres_Bd` BEFORE DELETE ON `cupatres` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigoitem, ' ', old.nserie, ' ', old.retorno, ' ', old.diavenda, ' da tabela cupatres'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_cupat_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_cupat_Bd` BEFORE DELETE ON `cupomatual` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigoitem, ' ', old.nserie, ' ', old.retorno, ' ', old.diavenda, ' da tabela cupomatual'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_depar_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_depar_Bd` BEFORE DELETE ON `departamentos` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.chave, ' ',old.nome, ' da tabela departamentos'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_diacor_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_diacor_Bd` BEFORE DELETE ON `diacorrente` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.login, ' ', old.impcaixa, ' ', old.dia, ' da tabela diacorrente'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_emp_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_emp_Bd` BEFORE DELETE ON `empresa` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.cgc, ' ',old.nomefantasia, ' da tabela empresa'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_extcnt_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_extcnt_Bd` BEFORE DELETE ON `extratoconta` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codcli, ' ', old.comprador, ' ', old.datacompra, ' ', old.valorcompra, ' da tabela extratoconta'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_extfrn_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_extfrn_Bd` BEFORE DELETE ON `extratofornecedor` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codforn, ' ', old.numtitulo, ' ', old.emissao, ' ', old.valorcompra, ' da tabela extratofornecedor'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_extpg_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_extpg_Bd` BEFORE DELETE ON `extratpg` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codcli, ' ', old.comprador, ' ', old.datacompra, ' ', old.valorcompra, ' da tabela extratpg'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_fatf_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_fatf_Bd` BEFORE DELETE ON `fatfisc` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codfisc, ' ', old.parc, ' ', old.numfat, ' ', old.valor, ' da tabela fatfisc'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_finf_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_finf_Bd` BEFORE DELETE ON `finafim` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.numcup, ' ', old.dtcomp, ' ', old.impcaixa, ' ', old.vlfina, ' ', old.descfina, ' da tabela finafim'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_forn_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_forn_Bd` BEFORE DELETE ON `fornecedor` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.chave, ' ',old.nome, ' da tabela fornecedor'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_frmpg_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_frmpg_Bd` BEFORE DELETE ON `finalizadora` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.retorno, ' ',old.nome, ' da tabela finalizadora'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_funcionario_Bu

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_funcionario_Bu` BEFORE UPDATE ON `funcionario` FOR EACH ROW BEGIN if(NEW.limitadsc = 'S') and ( (NEW.descdado >= NEW.nrdesc) or (curdate() > new.dtexpdesc)) then set new.ativo = 'N'; end if; END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_func_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_func_Bd` BEFORE DELETE ON `funcionario` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.chave, ' ',old.nome, ' da tabela funcionario'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_grddiv_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_grddiv_Bd` BEFORE DELETE ON `gradediv` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codpri, ' ', old.codfim, ' ', old.descricao, ' da tabela gradediv'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_grdit_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_grdit_Bd` BEFORE DELETE ON `gradeit` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigo, ' ', old.cor, ' ', old.taman, ' ', old.preco, ' da tabela gradeit'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_grdpr_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_grdpr_Bd` BEFORE DELETE ON `gradepr` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codpri, ' ', old.codsec, ' ', old.descsec, ' da tabela gradepr'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_grof_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_grof_Bd` BEFORE DELETE ON `grofert` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.grupo, ' ', old.prof, ' ', old.dtini, ' da tabela grofert'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_itavr_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_itavr_Bd` BEFORE DELETE ON `item_avaria` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigo, ' ', old.nome, ' ', old.qtde, ' ', old.situacao, ' da tabela item_avaria'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_itcnd_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_itcnd_Bd` BEFORE DELETE ON `itvc` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigo, ' ', old.numcond, ' ', old.qtde, ' ', old.dtvend, ' da tabela itvc'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_itcpcn_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_itcpcn_Bd` BEFORE DELETE ON `itcupcanc` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigoitem, ' ', old.nserie, ' ', old.diavenda, ' ', old.retorno, ' da tabela itcupcanc'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_item_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_item_Bd` BEFORE DELETE ON `item` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigo, ' ', old.descricao, ' ', old.unitario, ' ', old.codncm, ' da tabela item'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_itnf_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_itnf_Bd` BEFORE DELETE ON `item_nf` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codprod, ' ', old.codnf, ' ', old.qtde, ' ', old.dtemt, ' da tabela item_nf'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_itorc_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_itorc_Bd` BEFORE DELETE ON `item_orcamento` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.coditem, ' ', old.numorc, ' ', old.quant, ' ', old.diaped, ' da tabela item_orcamento'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_itpdcm_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_itpdcm_Bd` BEFORE DELETE ON `item_pedcomp` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.coditem, ' ', old.numpedido, ' ', old.quant, ' ', old.vltotal, ' da tabela item_pedcomp'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_itpd_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_itpd_Bd` BEFORE DELETE ON `item_pedido` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.coditem, ' ', old.numpedido, ' ', old.quant, ' ', old.diaped, ' da tabela item_pedido'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_itpro_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_itpro_Bd` BEFORE DELETE ON `it_protoc` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codprod, ' ', old.codprotoc, ' ', old.num_ped, ' ', old.qtde, ' da tabela it_protoc'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_itx_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_itx_Bd` BEFORE DELETE ON `itxml` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.cdprod, ' ', old.cdcad, ' ', old.numnf, ' ', old.nmprod, ' da tabela itxml'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_livcx2_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_livcx2_Bd` BEFORE DELETE ON `livrocx2` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.dtmov, ' ', old.valor, ' ', old.fina, ' ', old.numcx, ' da tabela livrocx2'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_livcx3_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_livcx3_Bd` BEFORE DELETE ON `livrocx3` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.dtmov, ' ', old.totven, ' ', old.saldo, ' ', old.subtot, ' da tabela livrocx3'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_livcx_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_livcx_Bd` BEFORE DELETE ON `livrocaixa` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.dia, ' ', old.valorrp, ' ', old.formpg, ' ', old.numcx, ' da tabela livrocaixa'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_livrocaixa_Bi

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_livrocaixa_Bi` BEFORE INSERT ON `livrocaixa` FOR EACH ROW BEGIN set new.recdia = new.dia; END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_log_Bi

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_log_Bi` BEFORE INSERT ON `logusu` FOR EACH ROW BEGIN SET @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); set new.host = @NNHOST; END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_log_Bu

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_log_Bu` BEFORE UPDATE ON `logusu` FOR EACH ROW BEGIN SET @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); set new.host = @NNHOST; END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_mapcom_Bi

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_mapcom_Bi` BEFORE INSERT ON `mapcom` FOR EACH ROW BEGIN IF(new.pocom < 0) THEN set NEW.pocom = -1 * new.pocom; set NEW.vlcom = -1 * new.vlcom; END IF; END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_mapc_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_mapc_Bd` BEFORE DELETE ON `mapcom` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.diaped, ' ', old.numped, ' ', old.vlvend, ' ', old.vlcom, ' da tabela mapcom'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_mdfe_Bi

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_mdfe_Bi` BEFORE INSERT ON `mdfe` FOR EACH ROW BEGIN DECLARE CodRam varchar(9); select concat(TIME_FORMAT(curtime(), '%H'), year(date_sub(Curdate(), interval 2006 year))) into CodRam from empresa limit 1; SET CodRam = Concat(CodRam, right(new.nrmdf, 4)); SET new.cdale = CodRam; END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_merc_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_merc_Bd` BEFORE DELETE ON `mercadoria` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.notaf, ' ', old.codigo, ' ', old.dtent, ' ', old.quant, ' da tabela mercadoria'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_mun_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_mun_Bd` BEFORE DELETE ON `municao` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.cdcli, ' ', old.codprod, ' ', old.dtgrav, ' ', old.qtadq, ' da tabela municao'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_ncm_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_ncm_Bd` BEFORE DELETE ON `ncm` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codncm, ' ', old.nomencm, ' da tabela ncm'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_nfcp_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_nfcp_Bd` BEFORE DELETE ON `nfecomp` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.nrnfe, ' ', old.nrchcomp, ' da tabela nfecomp'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_nfc_Bi

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_nfc_Bi` BEFORE INSERT ON `cupomatual` FOR EACH ROW BEGIN DECLARE NcmIt varchar(10); DECLARE CfopNf varchar(5); SELECT codncm INTO NcmIt FROM item where codigo = new.CodigoItem; if(substring(new.aliq, 1, 2) = '17') then set CfopNf = '5405'; else set CfopNf = '5102'; end if; SET new.ncm = NcmIt; SET new.local = CfopNf; END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_nfe_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_nfe_Bd` BEFORE DELETE ON `nfiscal` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.cdnfe, ' ', old.dtemissao, ' ', old.chvnfe,' da tabela nfiscal'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_nfisc_Bi

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_nfisc_Bi` BEFORE INSERT ON `nfiscal` FOR EACH ROW BEGIN DECLARE CodRam varchar(9); select concat(TIME_FORMAT(curtime(), '%s'), year(date_sub(Curdate(), interval 2006 year))) into CodRam from empresa limit 1; SET CodRam = Concat(CodRam, right(new.cdnfe, 4)); SET new.cdram = CodRam; END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_nvpr_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_nvpr_Bd` BEFORE DELETE ON `novo_preco` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigo, ' ', old.preco_atual, ' ', old.dt_alteracao,' da tabela novo_preco'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_ofpr_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_ofpr_Bd` BEFORE DELETE ON `ofertas` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigo, ' ', old.oferta, ' ', old.dtinicial,' da tabela ofertas'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_opbn_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_opbn_Bd` BEFORE DELETE ON `operband` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.cdcrt1, ' ', old.cdcrt2, ' ', old.cdband,' da tabela operband'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_orcam_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_orcam_Bd` BEFORE DELETE ON `orcamento` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.numpedido, ' ', old.dtpedido, ' ', old.precototal,' da tabela orcamento'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_pagam_Bi

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_pagam_Bi` BEFORE INSERT ON `pagamentos` FOR EACH ROW BEGIN DECLARE Nsunovo varchar(20); SET Nsunovo = NEW.cdnsu; if(length(Nsunovo) < 5) then SET Nsunovo = lpad(Nsunovo, 20, '0'); end if; SET NEW.cdnsu = Nsunovo; END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_pedcm_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_pedcm_Bd` BEFORE DELETE ON `pedido_comp` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.numpedido, ' ', old.dtpedido, ' ', old.precototal,' da tabela pedido_comp'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_pedido_Au

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_pedido_Au` AFTER UPDATE ON `pedido` FOR EACH ROW BEGIN update fatfisc f, pedido p set f.tppagam = p.tipopagam where (f.tppagam is null) and f.codfisc = p.numnf and length(p.numnf) > 3; END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_ped_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_ped_Bd` BEFORE DELETE ON `pedido` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.numpedido, ' ', old.dtpedido, ' ', old.precototal,' da tabela pedido'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_prot_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_prot_Bd` BEFORE DELETE ON `protoc` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigo, ' ', old.dtprot, ' ', old.nomecli, ' da tabela protoc'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_prqt_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_prqt_Bd` BEFORE DELETE ON `prqtd` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigo, ' ', old.prat, ' ', old.pr1, ' ', old.pr2, ' da tabela prqtd'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_reca_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_reca_Bd` BEFORE DELETE ON `recarga` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.nmoper, ' ', old.numcel, ' ', old.vlrecrg, ' ', old.dtrecrg, ' da tabela recarga'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_recib_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_recib_Bd` BEFORE DELETE ON `recibos` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.numrecibo, ' ', old.valor, ' ', old.tipo, ' da tabela recibos'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_req_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_req_Bd` BEFORE DELETE ON `requisicao` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codreq, ' ', old.tipo, ' ', old.dtreq, ' ', old.status, ' da tabela requisicao'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_rom_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_rom_Bd` BEFORE DELETE ON `romaneio` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codrom, ' ', old.dtrom, ' ', old.vlrom, ' ', old.status, ' da tabela romaneio'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_san_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_san_Bd` BEFORE DELETE ON `sangsup` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.tipo, ' ', old.dtsang, ' ', old.fina, ' ', old.valor, ' da tabela sangsup'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_simi_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_simi_Bd` BEFORE DELETE ON `similar` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codprim, ' ', old.codsim, ' ', old.codgrd, ' da tabela similar'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_soft_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_soft_Bd` BEFORE DELETE ON `softhouse` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.cnpjusu, ' ', old.nserie, ' ', old.numecf, ' da tabela softhouse'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_subc_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_subc_Bd` BEFORE DELETE ON `subcent` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codcent, ' ', old.subcod, ' ', old.nome, ' da tabela subcent'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_subs_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_subs_Bd` BEFORE DELETE ON `subsec` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigo, ' ', old.nome, ' da tabela subsec'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_tacr_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_tacr_Bd` BEFORE DELETE ON `tabcdret` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.cdret, ' ', old.descricao, ' da tabela tabcdret'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_tdcpan_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_tdcpan_Bd` BEFORE DELETE ON `tdcupant` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.numcupom, ' ', old.dtcompra, ' ', old.impcaixa, ' ', old.chvnfce, ' da tabela tdcupant'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_tdcpcn_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_tdcpcn_Bd` BEFORE DELETE ON `tdcupcanc` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.numcupom, ' ', old.dtcompra, ' ', old.impcaixa, ' ', old.quemcanc, ' da tabela tdcupcanc'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_tdcup_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_tdcup_Bd` BEFORE DELETE ON `todos_cupons` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.numcupom, ' ', old.dtcompra, ' ', old.impcaixa, ' ', old.chvnfce, ' da tabela todos_cupons'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_tdcup_Bi

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_tdcup_Bi` BEFORE INSERT ON `todos_cupons` FOR EACH ROW BEGIN DECLARE CodRam varchar(9); select concat(TIME_FORMAT(curtime(), '%s'), year(date_sub(Curdate(), interval 2006 year))) into CodRam from empresa limit 1; SET CodRam = Concat(CodRam, right(new.numcupom, 4)); SET new.cdram = CodRam; END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_tditr_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_tditr_Bd` BEFORE DELETE ON `tdit_req` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codreq, ' ', old.codigo, ' ', old.qtde, ' da tabela tdit_req'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_tran_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_tran_Bd` BEFORE DELETE ON `transp` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.cnpj, ' ', old.nome, ' da tabela transp'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_troit_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_troit_Bd` BEFORE DELETE ON `trocmercit` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.cdtr, ' ', old.codit, ' ', old.tipo, ' da tabela trocmercit'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_trom_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_trom_Bd` BEFORE DELETE ON `trocmerc` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.numtr, ' ', old.dttr, ' ', old.tppag, ' da tabela trocmerc'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_vend_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_vend_Bd` BEFORE DELETE ON `vendedores` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.codigo, ' ', old.nome, ' ', old.cpf, ' da tabela vendedores'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

-- Copiando estrutura para trigger lojas.Tr_vndcon_Bd

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_ENGINE_SUBSTITUTION';

DELIMITER //

CREATE TRIGGER `Tr_vndcon_Bd` BEFORE DELETE ON `vendcond` FOR EACH ROW BEGIN set @HOST = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID()); SET @NHOST = (IF (@HOST = 'localhost', 'localhost 127.0.0.1', (SELECT concat(host, ' ',ip) FROM performance_schema.host_cache WHERE host = (SELECT SUBSTRING_INDEX(host,': ',1) FROM information_schema.PROCESSLIST WHERE ID = CONNECTION_ID())))); SET @NNHOST = (IF (@NHOST IS NULL, @host, @NHOST)); insert into logusu set nmus = 'MYSQL', dtfeito = current_date, hrfeito = current_time, host = @NNHOST, acao = CONCAT(@NNHOST, ' EXCLUIU O REGISTRO ', old.numcond, ' ', old.codvend, ' ', old.status, ' ', old.dtvend, ' da tabela vendcond'); END//

DELIMITER ;

SET SQL_MODE=@OLDTMP_SQL_MODE;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;

/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

-- --------------------------------------------------------

-- Servidor: 127.0.0.1

-- Versão do servidor: 5.6.47 - MySQL Community Server (GPL)

-- OS do Servidor: Win64

-- HeidiSQL Versão: 10.2.0.5599

-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET NAMES utf8 */;

/*!50503 SET NAMES utf8mb4 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Copiando estrutura para evento lojas.EvOfbyDay

DELIMITER //

CREATE DEFINER=`root`@`localhost` EVENT `EvOfbyDay` ON SCHEDULE EVERY 1 MINUTE STARTS '2020-05-04 18:47:15' ON COMPLETION PRESERVE ENABLE DO BEGIN Call Oferbyday('SAI'); Call Oferbyday('ENT'); Call NovoPrIt(); END//

DELIMITER ;

-- Copiando estrutura para evento lojas.EvOfByHour

DELIMITER //

CREATE DEFINER=`root`@`localhost` EVENT `EvOfByHour` ON SCHEDULE EVERY 2 MINUTE STARTS '2017-12-27 10:43:32' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN Call OferRelHr(); END//

DELIMITER ;

-- Copiando estrutura para evento lojas.Ev_atCupAt

DELIMITER //

CREATE DEFINER=`root`@`localhost` EVENT `Ev_atCupAt` ON SCHEDULE EVERY 1 MINUTE STARTS '2017-12-27 10:44:12' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN Call AtDtLic(); END//

DELIMITER ;

-- Copiando estrutura para evento lojas.Ev_AtSol

DELIMITER //

CREATE DEFINER=`root`@`localhost` EVENT `Ev_AtSol` ON SCHEDULE EVERY 1 DAY STARTS '2020-05-04 18:56:25' ON COMPLETION PRESERVE ENABLE DO BEGIN update solaut set usuaut = 'MYSQL', jafoi = 'C', ipaut = 'localhost' where jafoi = 'N'; END//

DELIMITER ;

DROP TRIGGER IF EXISTS `logusu_impededelete`;

DELIMITER //

CREATE DEFINER=`root`@`localhost` TRIGGER `Tr_log_BD` BEFORE DELETE ON `logusu` FOR EACH ROW BEGIN

SIGNAL sqlstate '45001' set message_text = 'Bloqueado.';

END;

DELIMITER ;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;

/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;