/******************************************************************************
   NAME:       clean_out_allergies4X_arms.sql
   PURPOSE:    This script will remove all records from the allergies schema
   ADDITIONAL INFORMATION:

    
   REVISIONS:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.1        02/04/2008  M. Jacobsen      - Initial Release
   1.2        11/16/2012  M. Jacobsen      - comment out allergy_assessment table
   1.3        03/20/2013  M. Jacobsen      - uncomment allergy_assessment table
******************************************************************************/
    
-- Remove all entries from Allergies schema
delete from REACTION;
delete from DRUG_INGREDIENT;
delete from DRUG_CLASS;
delete from ALLERGY_COMMENT;
delete from ALLERGY_COMMENT_EVENT;
delete from ALLERGY_PRACT_PART;
delete from ALLERGY;
delete from ALLERGY_ASSESSMENT;

commit;

