CREATE TABLE `GXA0101` (`ConviteCodigo` bigint NOT NULL AUTO_INCREMENT, `EventoCodigo` bigint NOT NULL , `ConviteData` date NOT NULL , `ConviteFuncionarioCodigo` bigint NOT NULL , `ConviteNome` national varchar(120) NOT NULL , `ConviteCPF` national varchar(20) NOT NULL , `ConviteRG` national varchar(20) NOT NULL , `ConviteTipo` national char(20) NOT NULL , `ConvitePresenca` BOOL NOT NULL , `ConvitePresencaHora` datetime NOT NULL , `ConviteAutorizadoData` date NOT NULL , `ConviteAutorizadoQuem` national varchar(40) NOT NULL , `ConviteAutorizado` BOOL NOT NULL , `ConviteEmpresaCodigo` int NOT NULL , `ConviteEmpresaNome` national varchar(200) NOT NULL , `ConviteNascimento` date NOT NULL , `ConviteDiretor` national varchar(100) NOT NULL , `ConviteDHEntregaBrinde` datetime , `ConviteBairro` national varchar(100) NOT NULL , `ConviteCidade` national varchar(100) NOT NULL , PRIMARY KEY(`ConviteCodigo`))  ENGINE=InnoDB;
Run conversion program for table Convite;
DROP TABLE `Convite`;
RENAME TABLE `GXA0101` TO `Convite`;
CREATE INDEX `ICONVITE1` ON `Convite` (`EventoCodigo` );

ALTER TABLE `Convite` ADD CONSTRAINT `ICONVITE1` FOREIGN KEY (`EventoCodigo`) REFERENCES `Evento` (`EventoCodigo`);