ALTER TABLE `Ocorrencia` ADD (`OcorrenciaPermanente` BOOL NOT NULL DEFAULT 0);
ALTER TABLE `Ocorrencia` ALTER COLUMN `OcorrenciaPermanente` DROP DEFAULT;

CREATE TABLE `Obra` (`ObraCodigo` bigint NOT NULL AUTO_INCREMENT, `PessoaCodigo` bigint NOT NULL , `ObraQtdeFuncionarios` smallint NOT NULL , `ObraDataRegPrimFuncionario` date NOT NULL , `ObraEnderecoLogradouro` national varchar(120) NOT NULL , `ObraEnderecoNumero` national char(20) NOT NULL , `ObraEnderecoComplemento` national varchar(80) NOT NULL , `ObraEnderecoBairro` national varchar(120) NOT NULL , `ObraEnderecoCidade` national varchar(100) NOT NULL , `ObraEnderecoUF` national char(2) NOT NULL , `ObraEnderecoCEP` national char(10) NOT NULL , `ObraResponsavelNome` national varchar(80) NOT NULL , `ObraResponsavelTel` national char(20) NOT NULL , `ObraDataInicio` date NOT NULL , `ObraDataFim` date NOT NULL , `ObraAnotacoes` MEDIUMTEXT CHARACTER SET utf8 NOT NULL , PRIMARY KEY(`ObraCodigo`))  ENGINE=InnoDB;
CREATE INDEX `IOBRA1` ON `Obra` (`PessoaCodigo` );

ALTER TABLE `Obra` ADD CONSTRAINT `IOBRA1` FOREIGN KEY (`PessoaCodigo`) REFERENCES `Pessoa` (`PessoaCodigo`);