CREATE TABLE `_rep_history` (
	`id_rep_history` INT(11) NOT NULL AUTO_INCREMENT,
	`change_date` DATETIME NULL DEFAULT NULL,
	`aff_row` INT(11) NULL DEFAULT NULL,
	`sql_cmd` LONGTEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`identification` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`table_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	PRIMARY KEY (`id_rep_history`) USING BTREE,
	INDEX `change_date` (`change_date`) USING BTREE,
	INDEX `table_name` (`table_name`, `id_rep_history`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=243932
;


CREATE TABLE `notificacao` (
	`id_notificacao` VARCHAR(50) NOT NULL COLLATE 'latin1_swedish_ci',
	`id_inc_notificacao` INT(11) NOT NULL AUTO_INCREMENT,
	`tabela` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`id_tabela` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`login` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`data` DATE NULL DEFAULT NULL,
	`hora` VARCHAR(10) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`acao` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`imagem` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`titulo` VARCHAR(250) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`msg` LONGTEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`link` LONGTEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`json_detalhes` LONGBLOB NULL DEFAULT NULL,
	PRIMARY KEY (`id_notificacao`) USING BTREE,
	INDEX `id_inc_notificacao` (`id_inc_notificacao`) USING BTREE,
	INDEX `idx_tabela` (`tabela`, `id_tabela`) USING BTREE,
	INDEX `idx_login_data_notific` (`login`, `data`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=104675
;



CREATE TABLE `lixeira` (
	`id_lixeira` VARCHAR(50) NOT NULL COLLATE 'latin1_swedish_ci',
	`tabela` VARCHAR(100) NOT NULL COLLATE 'latin1_swedish_ci',
	`model` VARCHAR(100) NOT NULL COLLATE 'latin1_swedish_ci',
	`id_referencia` VARCHAR(100) NOT NULL COLLATE 'latin1_swedish_ci',
	`ra_tipo_acao` VARCHAR(50) NOT NULL COLLATE 'latin1_swedish_ci',
	`data` DATE NOT NULL,
	`hora` VARCHAR(10) NOT NULL COLLATE 'latin1_swedish_ci',
	`dados` LONGBLOB NOT NULL,
	`usuario` VARCHAR(50) NOT NULL COLLATE 'latin1_swedish_ci',
	PRIMARY KEY (`id_lixeira`) USING BTREE,
	INDEX `tabela_id_referencia` (`tabela`, `id_referencia`, `data`, `hora`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;