/******************************************************************************/
/****                           Altering tables                            ****/
/******************************************************************************/
ALTER TABLE AGENDAMENTO
  ADD ACOMPANHANTE VARCHAR(45) /* COLLATE ISO8859_1 - default */;

ALTER TABLE AGENDAMENTO
  ADD LOCALESPERA VARCHAR(50) /* COLLATE ISO8859_1 - default */;

ALTER TABLE AGENDAMENTO
  ADD QUILOMETRAGEM INTEGER;

ALTER TABLE AGENDAMENTO
  ADD CODIGOPACIENTE VARCHAR(20) /* COLLATE ISO8859_1 - default */;

ALTER TABLE PACIENTES
  ADD COR VARCHAR(20) /* COLLATE ISO8859_1 - default */;

ALTER TABLE PACIENTES
  ADD SEXO VARCHAR(10) /* COLLATE ISO8859_1 - default */;


/******************************************************************************/
/****                           Creating indices                           ****/
/******************************************************************************/
CREATE INDEX AGENDAMENTO_IDX1
  ON AGENDAMENTO (CODIGOPACIENTE);


/******************************************************************************/
/****                          Altering triggers                           ****/
/******************************************************************************/
SET TERM ^ ;

ALTER TRIGGER TRIG_PACIENTE_AU
AS
begin
  if (NEW.CODIGO <> OLD.CODIGO) then
  BEGIN
     UPDATE EXAMESECONSULTAS SET PACIENTE = NEW.CODIGO WHERE PACIENTE = OLD.CODIGO;
     UPDATE ENCAMINHAMENTOS SET PACIENTE = NEW.CODIGO WHERE PACIENTE = OLD.CODIGO;
     UPDATE PROCENFERMAGEM SET PACIENTE = NEW.CODIGO WHERE PACIENTE = OLD.CODIGO;
     UPDATE SAIDADEMEDICAMENTOS SET PACIENTE = NEW.CODIGO WHERE PACIENTE = OLD.CODIGO;
     UPDATE PACIENTESCONVENIO SET PACIENTE = NEW.CODIGO WHERE PACIENTE = OLD.CODIGO;
     UPDATE AGENDAMENTO SET CODIGOPACIENTE = NEW.CODIGO WHERE CODIGOPACIENTE = OLD.CODIGO;
  END
end
^


SET TERM ; ^