-- generated by export_tables.php on 2025-12-02 16:02:03
-- source: ip.sysfar.com.br/gtsyscon_gtsys -> table: gtsys_historicoitem_uf19

create table gtsys_historicoitem_uf19
(
  `codigo` int(11) NOT NULL AUTO_INCREMENT,
  `codigo_item` int(11) NOT NULL,
  `descricao` text COLLATE utf8mb4_unicode_ci,
  `DATA` date DEFAULT NULL,
  `hora` time DEFAULT NULL,
  PRIMARY KEY (`codigo`),
  CONSTRAINT `coditemfk_uf19` FOREIGN KEY (`codigo_item`) REFERENCES `gtsys_itens` (`codigo`)
)ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

create index codigo
    on gtsys_historicoitem_uf19 (codigo);

create index codigo_item
    on gtsys_historicoitem_uf19 (codigo_item);

