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

    
   REVISIONS:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.1        03/19/2012  M. Jacobsen      - Initial Release
******************************************************************************/

-- Remove all entries from health_adapter schema
DELETE FROM QUALIFIER;
DELETE FROM VITAL_SIGN;
DELETE FROM EXERCISE_ATTACHMENT;
DELETE FROM EXERCISE_JOURNAL;
DELETE FROM CONTACT_LOG_ATTACHMENT;
DELETE FROM CONTACT_LOG_JOURNAL;
DELETE FROM DIET_ATTACHMENT;
DELETE FROM DIET_JOURNAL;
DELETE FROM DAILY_EVENT_ATTACHMENT;
DELETE FROM DAILY_EVENT_JOURNAL;
DELETE FROM MOOD_ATTACHMENT;
DELETE FROM MOOD_JOURNAL;
DELETE FROM CALENDAR_EVENT;
DELETE FROM ASSESSMENT_TOTAL_SCORE;
DELETE FROM ASSESSMENT_DOCUMENT;
DELETE FROM GOAL_TRACKING;
DELETE FROM PAIN_ASSESSMENT;
DELETE FROM PAIN_REASSESSMENT;
DELETE FROM SKILL_TRACKING;
--DELETE FROM PAIN_QUALITY_TODAY;
--DELETE FROM PAIN_LOCATIONS;
--DELETE FROM TREATMENT;
DELETE FROM PAIN_EVENT;

commit;

