--
--    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
GO
DROP TABLE HTS_L_LOCNOTE_ESCTOPARTS
GO
DROP TABLE HTS_L_DEADLINE_ESCALATION
GO
DROP TABLE HTS_L_LOCNOTE_ESCHUMANROLES
GO
DROP TABLE HTS_L_ESCALATION_ESCHUMANROLES
GO
DROP TABLE HTS_L_TASK_READBY
GO
DROP TABLE HTS_L_TASK_THREAD
GO
DROP TABLE HTS_L_TASK_TASK
GO
DROP TABLE HTS_L_PRESEL_PRESDESC
GO
DROP TABLE HTS_L_TASK_PRESEL
GO
DROP TABLE HTS_L_TASK_UNSUBSCRIBE
GO
DROP TABLE HTS_L_TASKCLASS_DEADLINES
GO
DROP TABLE HTS_L_TASKCLASS_IMPORT
GO
DROP TABLE HTS_L_TASKCLASS_ESCALATION
GO
DROP TABLE HTS_L_TASKCLASS_PRESELDESC
GO
DROP TABLE HTS_L_TASKCLASS_PRESELNAME
GO
DROP TABLE HTS_L_TASKCLASS_PRESELSUBJ
GO
DROP TABLE HTS_L_TASKCLASS_PRESELPARAM
GO
DROP TABLE HTS_L_TASKCLASS_RENDERING
GO
DROP TABLE HTS_L_TASKCLASS_PURGECNSTR
GO
DROP TABLE HTS_L_TASKCLASS_PROPERTY
GO
DROP TABLE HTS_L_TASKCLASS_SUBSCRIBE
GO
DROP TABLE HTS_L_TASKUSER_DISPLAYNAME
GO

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

DROP TABLE HTS_DEADLINE_INSTANCE
GO
DROP TABLE HTS_DEADLINE

GO
DROP TABLE HTS_FOLDER
GO
DROP TABLE HTS_TASK_READ_BY
GO
DROP TABLE HTS_UNSUBSCRIPTION
GO
DROP TABLE HTS_TASKSUBSCRIPTION
GO
DROP TABLE HTS_MESSAGE
GO
DROP TABLE HTS_TASK
GO

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

DROP TABLE HTS_VERSION