IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'generalSymptoms'
      AND Object_ID = Object_ID(N'pal_MedicalPatientHistory'))
BEGIN
ALTER TABLE pal_MedicalPatientHistory
    ADD generalSymptoms VARCHAR(500) NULL
END

IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'drugsTaken'
      AND Object_ID = Object_ID(N'pal_MedicalPatientHistory'))
BEGIN
ALTER TABLE pal_MedicalPatientHistory
    ADD drugsTaken VARCHAR(500) NULL
END




