lyggkj/gkaq/yjpt-java/trunk/resources/sql/init/table-drop.sql

drop table T_QLYG_INF_APPLY;
drop table T_QLYG_INF_APPLY_PROCESS;
drop table T_QLYG_INF_APPLY_RESULT;
drop table T_QLYG_INF_SUPBACK;
drop table T_QLYG_MONITOR_ALERT;
drop table T_QLYG_MONITOR_SUPERVISE;
drop table T_QLYG_MONITOR_SUPERVISE_REPLY;
drop table T_QLYG_MONITOR_SUPERVISE_RES;
drop table T_YJPT_AQPJJGXX;
drop table T_YJPT_AQSSSBXXXX;
drop table T_YJPT_AQSSZXYS;
drop table T_YJPT_AQXZPJBGBADJB;
drop table T_YJPT_BLOB;
drop table T_YJPT_BUTTON;
drop table T_YJPT_CCSJDWXHXPJBLHXNZB;
drop table T_YJPT_CG;
drop table T_YJPT_CURRENTNO;
drop table T_YJPT_DBRW;
drop table T_YJPT_DC;
drop table T_YJPT_FJB;
drop table T_YJPT_GG;
drop table T_YJPT_GGDM;
drop table T_YJPT_GG_VIEW;
drop table T_YJPT_GKAQPJJGSQBAB;
drop table T_YJPT_GKCCSS;
drop table T_YJPT_GKSSSB;
drop table T_YJPT_GKWHQY;
drop table T_YJPT_GKWXHWZYFZBLHHZ;
drop table T_YJPT_GKWXHWZYFZBL_FZ;
drop table T_YJPT_GKWXHWZYFZHZ;
drop table T_YJPT_GKWXHWZYFZNS;
drop table T_YJPT_GKXX;
drop table T_YJPT_GKXX_GKJTQK;
drop table T_YJPT_GKZBHJDWXYDYX;
drop table T_YJPT_GLZD;
drop table T_YJPT_GQ;
drop table T_YJPT_GQNWXYDJBAB;
drop table T_YJPT_GQNWXYXXQKB;
drop table T_YJPT_GQNWXYZBHJJBQK;
drop table T_YJPT_GQNWXYZBHJQK;
drop table T_YJPT_GQNWXYZLB;
drop table T_YJPT_GQ_MT;
drop table T_YJPT_GZTX;
drop table T_YJPT_JJXX;
drop table T_YJPT_JSFXXWH;
drop table T_YJPT_JSXMAQSC;
drop table T_YJPT_JYRBWXX;
drop table T_YJPT_JYRDRYXX;
drop table T_YJPT_JYRJCXX;
drop table T_YJPT_JYRWXHWZYCS;
drop table T_YJPT_JYRXX_BW;
drop table T_YJPT_JYRXX_CK;
drop table T_YJPT_JYRXX_DC;
drop table T_YJPT_JYRXX_NSB;
drop table T_YJPT_JZYJJYDWRYHZ;
drop table T_YJPT_LOG;
drop table T_YJPT_MEM;
drop table T_YJPT_MENU;
drop table T_YJPT_MT;
drop table T_YJPT_NORULE;
drop table T_YJPT_QSK;
drop table T_YJPT_ROLE;
drop table T_YJPT_ROLE_BUTTON;
drop table T_YJPT_ROLE_MENU;
drop table T_YJPT_ROLE_USER;
drop table T_YJPT_RYQKHZ;
drop table T_YJPT_RYQKHZ_ZS;
drop table T_YJPT_SGALGL;
drop table T_YJPT_SGALGL_WZDD;
drop table T_YJPT_TASK;
drop table T_YJPT_USER;
drop table T_YJPT_WORKING_CALENDAR;
drop table T_YJPT_WXHWGKZYRKZNSSQB;
drop table T_YJPT_WXHWGKZYSBD;
drop table T_YJPT_WXHWGKZYSBD_BG;
drop table T_YJPT_WXHWPMB;
drop table T_YJPT_YJJYNLJBQK;
drop table T_YJPT_YJJYZBXX;
drop table T_YJPT_YJPX;
drop table T_YJPT_YJWL;
drop table T_YJPT_YJWZ;
drop table T_YJPT_YJWZ_FLXX;
drop table T_YJPT_YJYA;
drop table T_YJPT_YJYABA;
drop table T_YJPT_YJYL;
drop table T_YJPT_YJYX;
drop table T_YJPT_YJZJK;
drop table T_YJPT_ZBHJJBQK;
drop table T_YJPT_ZC;
drop table T_YJPT_ZCYH;
drop table T_YJPT_ZDSGYHPCZGBA;
drop table T_YJPT_ZLBZJDHXPXX;
drop table T_YJPT_ZLBZZDWXYXX;
drop table T_YJPT_ZYWXYS;
drop table T_YJPT_ZYYJJYDW;
drop table T_YJPT_ZYYJJYDWRYHZ;
drop table T_YJPT_ZZJG;
drop table T_YJPT_WF_PROP;
drop table T_YJPT_GQNWXYDJBAB_FLOW;
drop table T_YJPT_GKWXHWZYFZBLHHZZB;
drop SEQUENCE SEQ_T_YJPT_JYRSHXX;

drop index ACT_IDX_BYTEAR_DEPL;
drop index ACT_IDX_EXE_PROCINST;
drop index ACT_IDX_EXE_PARENT;
drop index ACT_IDX_EXE_SUPER;
drop index ACT_IDX_TSKASS_TASK;
drop index ACT_IDX_TASK_EXEC;
drop index ACT_IDX_TASK_PROCINST;
drop index ACT_IDX_TASK_PROCDEF;
drop index ACT_IDX_VAR_EXE;
drop index ACT_IDX_VAR_PROCINST;
drop index ACT_IDX_VAR_BYTEARRAY;
drop index ACT_IDX_JOB_EXCEPTION;
drop index ACT_IDX_MODEL_SOURCE;
drop index ACT_IDX_MODEL_SOURCE_EXTRA;
drop index ACT_IDX_MODEL_DEPLOYMENT;

drop index ACT_IDX_EXEC_BUSKEY;
drop index ACT_IDX_TASK_CREATE;
drop index ACT_IDX_IDENT_LNK_USER;
drop index ACT_IDX_IDENT_LNK_GROUP;
drop index ACT_IDX_VARIABLE_TASK_ID;

alter table ACT_GE_BYTEARRAY drop CONSTRAINT ACT_FK_BYTEARR_DEPL;
alter table ACT_RU_EXECUTION drop CONSTRAINT ACT_FK_EXE_PROCINST;
alter table ACT_RU_EXECUTION drop CONSTRAINT ACT_FK_EXE_PARENT;
alter table ACT_RU_EXECUTION drop CONSTRAINT ACT_FK_EXE_SUPER;
alter table ACT_RU_EXECUTION drop CONSTRAINT ACT_FK_EXE_PROCDEF;
alter table ACT_RU_IDENTITYLINK drop CONSTRAINT ACT_FK_TSKASS_TASK;
alter table ACT_RU_IDENTITYLINK drop CONSTRAINT ACT_FK_ATHRZ_PROCEDEF;
alter table ACT_RU_TASK drop CONSTRAINT ACT_FK_TASK_EXE;
alter table ACT_RU_TASK drop CONSTRAINT ACT_FK_TASK_PROCINST;
alter table ACT_RU_TASK drop CONSTRAINT ACT_FK_TASK_PROCDEF;
alter table ACT_RU_VARIABLE drop CONSTRAINT ACT_FK_VAR_EXE;
alter table ACT_RU_VARIABLE drop CONSTRAINT ACT_FK_VAR_PROCINST;
alter table ACT_RU_VARIABLE drop CONSTRAINT ACT_FK_VAR_BYTEARRAY;
alter table ACT_RU_JOB drop CONSTRAINT ACT_FK_JOB_EXCEPTION;
alter table ACT_RU_EVENT_SUBSCR drop CONSTRAINT ACT_FK_EVENT_EXEC;
alter table ACT_RE_PROCDEF drop CONSTRAINT ACT_UNIQ_PROCDEF;
alter table ACT_RE_MODEL drop CONSTRAINT ACT_FK_MODEL_SOURCE;
alter table ACT_RE_MODEL drop CONSTRAINT ACT_FK_MODEL_SOURCE_EXTRA;
alter table ACT_RE_MODEL drop CONSTRAINT ACT_FK_MODEL_DEPLOYMENT;
    
drop index ACT_IDX_EVENT_SUBSCR_CONFIG_;
drop index ACT_IDX_EVENT_SUBSCR;
drop index ACT_IDX_ATHRZ_PROCEDEF;

drop table  ACT_GE_PROPERTY;
drop table  ACT_GE_BYTEARRAY;
drop table  ACT_RE_DEPLOYMENT;
drop table  ACT_RE_MODEL;
drop table  ACT_RE_PROCDEF;
drop table  ACT_RU_IDENTITYLINK;
drop table  ACT_RU_VARIABLE;
drop table  ACT_RU_TASK;
drop table  ACT_RU_EXECUTION;
drop table  ACT_RU_JOB;
drop table  ACT_RU_EVENT_SUBSCR;

drop index ACT_IDX_HI_PRO_INST_END;
drop index ACT_IDX_HI_PRO_I_BUSKEY;
drop index ACT_IDX_HI_ACT_INST_START;
drop index ACT_IDX_HI_ACT_INST_END;
drop index ACT_IDX_HI_DETAIL_PROC_INST;
drop index ACT_IDX_HI_DETAIL_ACT_INST;
drop index ACT_IDX_HI_DETAIL_TIME;
drop index ACT_IDX_HI_DETAIL_NAME;
drop index ACT_IDX_HI_DETAIL_TASK_ID;
drop index ACT_IDX_HI_PROCVAR_PROC_INST;
drop index ACT_IDX_HI_PROCVAR_NAME_TYPE;
drop index ACT_IDX_HI_ACT_INST_PROCINST;
drop index ACT_IDX_HI_IDENT_LNK_USER;
drop index ACT_IDX_HI_IDENT_LNK_TASK;
drop index ACT_IDX_HI_IDENT_LNK_PROCINST;

drop table ACT_HI_PROCINST;
drop table ACT_HI_ACTINST;
drop table ACT_HI_VARINST;
drop table ACT_HI_TASKINST;
drop table ACT_HI_DETAIL;
drop table ACT_HI_COMMENT;
drop table ACT_HI_ATTACHMENT;
drop table ACT_HI_IDENTITYLINK;