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

--
--    Licensed Materials - Property of IBM
--    
--    BI and PM: HTS
--    
--    (c) Copyright IBM Corp. 2003, 2014.
--    
--    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