analytics/configuration/schemas/hts/db2/humanTaskService-dropScript.sql

--
--    Licensed Materials - Property of IBM
--    
--    BI and PM: HTS
--    
--    (c) Copyright IBM Corp. 2003, 2010.
--    
--    US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
--    

DROP TABLE  HTS_L_POST_TASKS;
DROP TABLE HTS_L_LOCNOTE_ESCTOPARTS;
DROP TABLE HTS_L_DEADLINE_ESCALATION;
DROP TABLE HTS_L_LOCNOTE_ESCHUMANROLES;
DROP TABLE HTS_L_ESCALATION_ESCHUMANROLES;
DROP TABLE HTS_L_TASK_READBY;
DROP TABLE HTS_L_TASK_THREAD;
DROP TABLE HTS_L_TASK_TASK;
DROP TABLE HTS_L_PRESEL_PRESDESC;
DROP TABLE HTS_L_TASK_PRESEL;
DROP TABLE HTS_L_TASK_UNSUBSCRIBE;
DROP TABLE HTS_L_TASKCLASS_DEADLINES;
DROP TABLE HTS_L_TASKCLASS_IMPORT;
DROP TABLE HTS_L_TASKCLASS_ESCALATION;
DROP TABLE HTS_L_TASKCLASS_PRESELDESC;
DROP TABLE HTS_L_TASKCLASS_PRESELNAME;
DROP TABLE HTS_L_TASKCLASS_PRESELSUBJ;
DROP TABLE HTS_L_TASKCLASS_PRESELPARAM;
DROP TABLE HTS_L_TASKCLASS_RENDERING;
DROP TABLE HTS_L_TASKCLASS_PURGECNSTR;
DROP TABLE HTS_L_TASKCLASS_PROPERTY;
DROP TABLE HTS_L_TASKCLASS_SUBSCRIBE;
DROP TABLE HTS_L_TASKUSER_DISPLAYNAME;

DROP TABLE HTS_ATTACHMENT;
DROP TABLE HTS_HUMANROLE;
DROP TABLE HTS_ESCALATION_TO_PART;
DROP TABLE HTS_ESCALATION_HUMANROLES;
DROP TABLE HTS_RENDERING;
DROP TABLE HTS_IMPORT;
DROP TABLE HTS_POST;
DROP TABLE HTS_THREAD;
DROP TABLE HTS_PRESENTATIONDESCRIPTION;
DROP TABLE HTS_PRESENTATIONELEMENTS;
DROP TABLE HTS_ESCALATION;
DROP TABLE HTS_LOCAL_NOTIFICATION;

DROP TABLE HTS_DEADLINE_INSTANCE;
DROP TABLE HTS_DEADLINE;
DROP TABLE HTS_FOLDER;
DROP TABLE HTS_TASK_READ_BY;
DROP TABLE HTS_UNSUBSCRIPTION;
DROP TABLE HTS_TASKSUBSCRIPTION;
DROP TABLE HTS_MESSAGE;
DROP TABLE HTS_TASK;

DROP TABLE HTS_CALLBACKPARAM;
DROP TABLE HTS_CALLBACK;
DROP TABLE HTS_USER_DISPLAY_NAME;
DROP TABLE HTS_TASKUSER;
DROP TABLE HTS_PRESENTATIONELEMENTS_NAME;
DROP TABLE HTS_PRESENTATIONELEMENTS_SUBJ;
DROP TABLE HTS_PRESENTATIONELEMENTS_DESC;
DROP TABLE HTS_PRESENTELEMENTS_PARAMS;
DROP TABLE HTS_TASK_PURGE_CONSTRAINT;
DROP TABLE HTS_TASKCLASS_PROPERTY;
DROP TABLE HTS_TASKCLASS;

DROP TABLE HTS_VERSION;