CREATE TRIGGER `trigger_inserir_imovel` AFTER INSERT ON `property`
  FOR EACH ROW
begin
if NEW.typeProperty = 1 ||  NEW.typeProperty = 2 || NEW.typeProperty = 5 THEN
	INSERT INTO apartmentHousingFarm SET id=NEW.id; 
ELSEIF NEW.typeProperty = 3 THEN
    INSERT INTO land SET id=NEW.id;
ELSEIF NEW.typeProperty = 4  ||  NEW.typeProperty = 6 || NEW.typeProperty = 7 || NEW.typeProperty = 9 THEN
    INSERT INTO warehouseStoreOffice SET id=NEW.id;
ELSEIF NEW.typeProperty = 8 THEN
    INSERT INTO building SET id=NEW.id;
END IF;
END;