consentFatima/mplus-fatima/script/drop_Oracle_Table_For_MPlus.sql

-- Hospital Table Drop
DROP TABLE MP_ACCESS_HISTORY; 
DROP TABLE MP_AGG_ACCESS; 
DROP TABLE MP_AGG_DAILY; 
DROP TABLE MP_AGG_HOURLY; 
DROP TABLE MP_AGG_PLATFORM; 
DROP TABLE MP_API_PARAM; 
DROP TABLE MP_API_HEADER; 
DROP TABLE MP_API; 
DROP TABLE MP_API_CATEGORY; 
DROP TABLE MP_I18N; 
DROP TABLE MP_MANAGER; 
DROP TABLE MP_TELNO; 
DROP TABLE MP_PUSH_FORM; 
DROP TABLE MP_MENU_PARAM;
DROP TABLE MP_MENU_AUTH;
DROP TABLE MP_MENU; 
DROP TABLE MP_EVENT_LOG; 
DROP TABLE MP_AGG_EVENT; 
DROP TABLE MP_INF_NURSE;

-- Common Table Drop
DROP TABLE MP_VERSION; 
DROP TABLE MNS_RECEIVER_DEVICE; 
DROP TABLE MNS_RECEIVER_RESULT; 
DROP TABLE MNS_RECEIVER; 
DROP TABLE MNS_CONTENTS_RESULT; 
DROP TABLE MNS_CONTENTS; 
DROP TABLE MP_USER_AGREEMENT; 
DROP TABLE MP_AGREEMENT; 
DROP TABLE MP_AGG_MSG; 
DROP TABLE MP_AGG_USER_AGE; 
DROP TABLE MP_AGG_USER_POSTNO;
DROP TABLE MP_AGG_USER_REGISTER; 
DROP TABLE MP_AGG_USER_TMP;
DROP TABLE MP_ZIPCODE;
DROP TABLE MP_MNS_MSGMAPPING;
DROP TABLE MP_HELPER_CONTENTS; 
DROP TABLE MP_INF_PUSH_MSG; 
DROP TABLE MP_PAYMENT_MASTER;
DROP TABLE MP_LOGIN_HISTORY;
DROP TABLE MP_ATTR;
DROP TABLE MP_ATTR_TYPE;
DROP TABLE MP_USER_ATTR; 
DROP TABLE MP_EXTRA_ATTR_USER; 
DROP TABLE MP_EXTRA_ATTR; 
DROP TABLE MP_AUTH_ATTR;
DROP TABLE MP_AUTH; 
DROP TABLE MP_USER_DEVICE;
DROP TABLE MP_PUBLIC_DEVICE;
DROP TABLE MP_USER;
DROP TABLE MP_DEMO_USER;

DROP SEQUENCE SEQ_MP_ACCESS_HISTORY_HS; 
DROP SEQUENCE SEQ_MP_AGG_ACCESS_AS; 
DROP SEQUENCE SEQ_MP_AGG_DAILY_DS; 
DROP SEQUENCE SEQ_MP_AGG_HOURLY_HS; 
DROP SEQUENCE SEQ_MP_AGG_PLATFORM_PS; 
DROP SEQUENCE SEQ_MP_API_AS; 
DROP SEQUENCE SEQ_MP_API_CATEGORY_CS; 
DROP SEQUENCE SEQ_MP_API_HEADER_HS; 
DROP SEQUENCE SEQ_MP_API_PARAM_PS; 
DROP SEQUENCE SEQ_MP_TELNO_TS; 
DROP SEQUENCE SEQ_MP_EVENT_LOG_LS; 
DROP SEQUENCE SEQ_MP_AGG_EVENT_AS; 
DROP SEQUENCE SEQ_MP_MENU_PARAM_SEQ_MPS; 
DROP SEQUENCE SEQ_MP_MENU_AUTH;
DROP SEQUENCE SEQ_MP_IF_NURSE_SEQ; 

DROP SEQUENCE SEQ_MNS_CONTENTS; 
DROP SEQUENCE SEQ_MP_AGREEMENT; 
DROP SEQUENCE SEQ_MP_USER_AGREEMENT_UA;  
DROP SEQUENCE SEQ_MP_AGG_MSG_MS; 
DROP SEQUENCE SEQ_MP_AGG_USER_AU; 
DROP SEQUENCE SEQ_MP_AGG_POSTNO_AP; 
DROP SEQUENCE SEQ_MP_USER_REGISTER_UR; 
DROP SEQUENCE SEQ_MP_ZIPCODE_ZC; 
DROP SEQUENCE SEQ_MP_HELPER_HS; 
DROP SEQUENCE SEQ_MP_INF_FORM_PUSH_PS; 
DROP SEQUENCE SEQ_MP_PAYMENT_MSG_PM; 
DROP SEQUENCE SEQ_MP_PAYMENT_ORDER_PO; 
DROP SEQUENCE SEQ_MP_LOGIN_HISTORY_LS; 
DROP SEQUENCE SEQ_MP_ATTR;
DROP SEQUENCE SEQ_MP_ATTR_TYPE;
DROP SEQUENCE SEQ_MP_USER_ATTR; 
DROP SEQUENCE SEQ_MP_EXTRA_ATTR; 
DROP SEQUENCE SEQ_MP_EXTRA_ATTR_USER; 
DROP SEQUENCE SEQ_MP_AUTH_ATTR;
DROP SEQUENCE SEQ_MP_AUTH;
DROP SEQUENCE SEQ_MP_USER_DEVICE;
DROP SEQUENCE SEQ_MP_PUBLIC_DEVICE;
DROP SEQUENCE SEQ_MP_USER_US;
COMMIT;