数据库初始化语句

----------------------------------------------
truncate table ZY_ZYH_DH;
truncate table ZY_TEMP_HZFY_STOP_TEMP;
truncate table ZY_TEMP_HZFY_STOP;
truncate table ZY_TEMP_FYFB;
truncate table ZY_TEMP_BLH;
truncate table ZY_SFDJ_TEMP_NEXT;
truncate table ZY_SFDJ_TEMP_MAIN;
truncate table ZY_NEXT_HZYJSB;
truncate table ZY_NEXT_HZJSB_ZF;
truncate table ZY_NEXT_HZJSB_XSEBH;
truncate table ZY_NEXT_HZJSB_KM;
truncate table ZY_NEXT_HZJSB;
truncate table ZY_NEXT_HZFYMX;
truncate table ZY_MAIN_ZYHZ_FYHZ;
truncate table ZY_MAIN_YSJSRY;
truncate table ZY_MAIN_XMDM;
truncate table ZY_MAIN_SFLR;
truncate table ZY_MAIN_RYDJ;
truncate table ZY_MAIN_KSSRTJ_MX;
truncate table ZY_MAIN_KSSRTJ;


----------------------------------------------
truncate table ZY_MAIN_ICD_MX;
truncate table ZY_MAIN_HZFYMX_YB;
truncate table ZY_MAIN_HZFYMX;
truncate table ZY_MAIN_HZFY;
truncate table ZY_MAIN_HFLR;
truncate table ZY_MAIN_BQCKD_CX;
truncate table ZY_JZ_TEMP;
truncate table ZY_JZ_DH_TEMP;
truncate table ZY_JZMX_ZF_TEMP;
truncate table ZY_JZMX_ZF;
truncate table ZY_JZMX_YJ_TEMP;
truncate table ZY_JZMX_YJ;
truncate table ZY_JZMX_FP_TEMP;
truncate table ZY_JZMX_FP;
truncate table ZY_JCD_DH;
truncate table ZY_HZFYMX_TEMP;
truncate table ZY_DH_TEMP;
truncate table ZY_CNEXT_YZZXJL;
truncate table ZY_CNEXT_JCDXX_WHD;

delete from ZY_JZ;
commit;

----------------------------------------------
truncate table ZY_CNEXT_JCDXX_LS;
truncate table ZY_CNEXT_JCDXX;
truncate table ZY_CNEXT_JCDSF_CL;
truncate table ZY_CNEXT_HZJSB_ZF;
truncate table ZY_CNEXT_HZJSB_XSEBH;
truncate table ZY_CNEXT_HZJSB_KM;
truncate table ZY_CNEXT_HZJSB;
truncate table ZY_CNEXT_HF;
truncate table ZY_CNEXT_CQYZ_CF;
truncate table ZY_CNEXT_CFXXB_YQY;
truncate table ZY_CNEXT_CFXXB_WQY;
truncate table ZY_CMAIN_ZGYS_ICU;
truncate table ZY_CMAIN_YY;
truncate table ZY_CMAIN_YSDESK;
truncate table ZY_CMAIN_YLZBTJ_JG;
truncate table ZY_CMAIN_XSELR_JBQKB;
truncate table ZY_CMAIN_XJYJ_TEMP;
truncate table ZY_CMAIN_XJYJ;
truncate table ZY_CMAIN_RY_CY_ZY_TJFX;
truncate table ZY_CMAIN_LSYZ;

delete from ZY_CMAIN_JCDXX_WHD;
commit;




----------------------------------------------
truncate table ZY_CMAIN_JCDXX_TEMP;

delete from ZY_CMAIN_JCDTF_HD;
delete from ZY_CMAIN_JCDTF;
delete from ZY_CMAIN_JCDHD;
delete from ZY_CMAIN_JCDXX;

delete from ZY_CMAIN_HZZYQKB_YE;
delete from ZY_CMAIN_HZZK;
delete from ZY_CMAIN_HZXZZGYS;
delete from ZY_CMAIN_HZJSB_TEMP;
delete from ZY_CMAIN_HZJSB;
delete from ZY_CMAIN_HZHLJBLOG;
delete from ZY_CMAIN_HZCYB;
delete from ZY_CMAIN_HZBLLOG;
delete from ZY_CMAIN_HFTY;
delete from ZY_CMAIN_HFTF;
delete from ZY_CMAIN_HFLR;
delete from ZY_CMAIN_FPDYB_TEMP;
delete from ZY_CMAIN_FPDYB;
delete from ZY_CMAIN_CYTZ;
delete from ZY_CMAIN_CWSYXX;

delete from ZY_CMAIN_CQYZ;
delete from ZY_CMAIN_CFSF_YQY;
delete from ZY_CMAIN_CFSF_WQY;
delete from ZY_CMAIN_CFFY;
delete from ZY_CMAIN_BYD;
delete from ZY_CF_DH

;
delete from ZYYS_YJSQDMX;


delete from ZY_CMAIN_HZZYQKB;
delete from ZY_HF_DH;
commit;
----------------------------------------------

truncate table YK_YPTK_TEMP;
truncate table YK_YPTJ_TEMP;
truncate table YK_YPTH_TEMP;
truncate table YK_YPRK_TEMP;
truncate table YK_YPBS_TEMP;
truncate table YK_TEMP_KCB;
truncate table YK_PHZ_HZPFJ_TEMP;
truncate table YK_PHZ_HZLSJ_TEMP;
truncate table YK_PHZ_HZJHJ_TEMP;
truncate table YK_PHZ_GYSHZPFJ_TEMP;
truncate table YK_PHZ_GYSHZLSJ_TEMP;
truncate table YK_PHZ_GYSHZJHJ_TEMP;
truncate table YK_PHZ_FLHZPFJ_TEMP;
truncate table YK_PHZ_FLHZLSJ_TEMP;


----------------------------------------------
truncate table YK_PHZ_FLHZJHJ_TEMP;
truncate table YK_MAIN_YPTJ;
truncate table YK_MAIN_YPRK;
truncate table YK_MAIN_YPFKMXZ_TEMP;
truncate table YK_MAIN_YPFKMXZ;
truncate table YK_MAIN_YPDZD;
truncate table YK_MAIN_YPBSMXZ;

delete from YK_CNEXT_YPTJMXZ_PFJ;
delete from YK_CNEXT_YPTJMXZ_LSJ;
delete from YK_CNEXT_YPTHMXZ;
delete from YK_CNEXT_YPSZMXDZD;
delete from YK_CNEXT_YPRKMXZ;
delete from YK_CNEXT_YPDZD_TEMP;
delete from YK_CNEXT_YPDZD;
delete from YK_CNEXT_YPCKMXZ;
delete from YK_CNEXT_YPBSMXZ;
delete from YK_CMAIN_YPTKMXZ;
delete from YK_CMAIN_YPTHMXZ;
delete from YK_CMAIN_YPRKMXZ;
delete from YK_CMAIN_YPFKMXZ;
delete from YK_CMAIN_YPFKJSB;


----------------------------------------------
delete from YK_CMAIN_YPDZD;
delete from YK_CMAIN_YPCKMXZ;
delete from YK_CMAIN_YPBSMXZ;
truncate table YK_CGJH_TEMP;
truncate table YF_TEMP_KCB;
truncate table YF_PRICE_KC;
truncate table YF_MAIN_YPTC;
truncate table YF_MAIN_YPDZD;
truncate table YF_MAIN_YPCGJH;
truncate table YF_MAIN_YPBSMXZ;
truncate table YF_MAIN_WQY_PD;
truncate table YF_MAIN_TYMXZ;
truncate table YF_MAIN_PDZT;
truncate table YF_MAIN_HZTJ;
truncate table YF_MAIN_GZLTJ;
truncate table YF_MAIN_BYD_ZT;
truncate table YF_KCXX_TEMP;
truncate table YF_GOOD_FX;
truncate table YF_FALSE_KCB;
delete from YF_CNEXT_YZJY;
delete from YF_CNEXT_YPTRTCMXZ;
commit;

----------------------------------------------
delete from YF_CNEXT_YPTKMXZ;
delete from YF_CNEXT_YPTJMXZ_LSJ;
delete from YF_CNEXT_YPTBSQ;
delete from YF_CNEXT_YPSZMXDZD;
delete from YF_CNEXT_YPDZD;
delete from YF_CNEXT_YPBSMXZ;
delete from YF_CMAIN_YZJY_JC;
delete from YF_CMAIN_YPTRTCMXZ_TR;
delete from YF_CMAIN_YPTRTCMXZ_TC;
delete from YF_CMAIN_YPTKMXZ;
delete from YF_CMAIN_YPTBSQ;
delete from YF_CMAIN_YPRKMXZ;
delete from YF_CMAIN_YPPHZ_TEMP;
delete from YF_CMAIN_YPDZD;
delete from YF_CMAIN_YPBSMXZ;
delete from YF_CMAIN_FYD_TEMP;
delete from YB_JBZD_DZ;
delete from XT_XH_JZ;
delete from XT_SYSTEM_DL;
delete from WJDM;


----------------------------------------------
truncate table TT_ZY_CMAIN_JCDHD_DH;
truncate table TT_ZY_CMAIN_HZZYQKB_YE_JE;
truncate table TT_ZY_CMAIN_CFSF_WQY_DH;
truncate table TT_ZY_CMAIN_CFFY_DH;
truncate table TT_ZYH_RQD_TEMP;
truncate table TT_ZYH_RQD;
truncate table TT_ZY

HF;
truncate table TT_ZYCF;
truncate table TT_YPTR;
truncate table TT_YPTC;
truncate table TT_YJHJ1;
truncate table TT_YJHJ;
truncate table TT_V_YP_FLDM;
truncate table TT_V_YFRK;
truncate table TT_V_RQ_LIST_OLAP;
truncate table TT_V_KSXMDM;


----------------------------------------------
truncate table TT_V_JSHZ;
truncate table TT_V_FYXX_JS_ZY;
truncate table TT_V_FYXX_JS_MZ;
truncate table TT_V_FYXX_JS_GH;
truncate table TT_V_FYXX_FSE_ZY;
truncate table TT_V_FYXX_FSE_MZ;
truncate table TT_V_FYXX_FSE_GH;
truncate table TT_V_FPDM;
truncate table TT_V_CWXMDM;
truncate table TT_TJPFJ;
truncate table TT_TJLSJ;
truncate table TT_TFCF;
truncate table TT_SQJY;
truncate table TT_SFXM_SFDJLR;
truncate table TT_SFXM;
truncate table TT_SFLRDH;
truncate table TT_SFCF;
truncate table TT_RKYW;
truncate table TT_JCDTFCL;
truncate table TT_JCDTF;
truncate table TT_JCDSFCL;


----------------------------------------------
truncate table TT_JCDSF;
truncate table TT_HZFYMX_CYJS;
truncate table TT_HFTY;
truncate table TT_HFTF;
truncate table TT_CKDH;
truncate table TT_CFFY_2;
truncate table TT_CFFY;
truncate table TT_BSDH;
truncate table TT_BQTK;
truncate table TT_BQTH;
truncate table TT_BQRK;
truncate table TT_BQKC;
truncate table TT_BQCK;
truncate table TT_BQBS;
truncate table TJ_ZY_YJ_MIR;
truncate table TJ_ZY_SFXM_SHOW;
truncate table TJ_ZY_SFXM_RESULT;
truncate table TJ_ZY_SFMX_MIR_DAY;
truncate table TJ_ZY_SFMX_MIR;
truncate table TJ_ZY_JS_MIR;
truncate table TJ_ZY_HZXX_MIR;


----------------------------------------------
truncate table TJ_ZY_HZXXJOB_SHOW;
truncate table TJ_ZY_CYRC_SHOW;
truncate table TJ_ZYHZ_TEMP;
truncate table TJ_ZYHZ_FYBL_SHOW;
truncate table TJ_ZXKSSFXM_SHOW;
truncate table TJ_ZXKSSFXM_MIR;
truncate table TJ_ZH_CZQX_MIR;
truncate table TJ_ZHQX_JOB_SHOW;
truncate table TJ_YS_LX_TEMP;
truncate table TJ_YL_LX_TEMP;
truncate table TJ_YLLB_GROUP;
truncate table TJ_YFFY_CNEXT_MIR;
truncate table TJ_YFFY_CMAIN_MIR;
truncate table TJ_XM_QUERY_CHOOSE;
truncate table TJ_TSXM_HZ_SHOW;
truncate table TJ_TSXM_CHOOSE;
truncate table TJ_TSSFXM_SHOW;
truncate table TJ_TSSFXM_JOB_SHOW;
truncate table TJ_TJXM_CHOOSE;
truncate table TJ_SFXM_SHOW;
truncate table TJ_SFXM_RESULT;


----------------------------------------------
truncate table TJ_SFXMINFO_SHOW;
truncate table TJ_SFXMINFO_MIR;
truncate table TJ_SFMX_TEMP;
truncate table TJ_SFMX_NEXT;
delete from TJ_SFMX_MAIN;
truncate table TJ_PRONAME_STATUS;
truncate table TJ_MZ_SFXM_SHOW;
truncate table TJ_MZ_SFXM_RESULT;
truncate table TJ_MZ_SFXM_MIR_LOG;
truncate table TJ_MZ_SFXM_MIR_DAY_LOG;
truncate table TJ_MZ_SFMX_NEXT_MIR;
truncate table TJ_MZ_SFMX_MIR_DAY;
truncate table TJ_MZ_SFMX_MIR;
truncate table TJ_MZYS_MXXM_MIR;
truncate table TJ_MZYS_MIR;
truncate table TJ_MZYS_JOB_SHOW;
truncate table TJ_MZHZ_SHOW;
truncate table TJ_MZHZFY_SHOW;
truncate table TJ_MZGH_HZXX_MIR;
truncate table TJ_MIR_

LOG;
truncate table TJ_MIR_CTRL;


----------------------------------------------
truncate table TJ_MAIN_MZ_FYQD;
truncate table TJ_MAIN_MZFYMX_CMAIN;
truncate table TJ_KW_KZT_MIR;
truncate table TJ_KW_JOB_SHOW;
truncate table TJ_KS_TS_TEMP;
truncate table TJ_GZL_TEMP;
truncate table TJ_GH_SFXM_SHOW;
truncate table TJ_GH_SFXM_RESULT;
truncate table TJ_GH_SFMX_MIR_DAY;
truncate table TJ_GH_SFMX_MIR;
truncate table TJ_GH_JOB_SHOW;
truncate table TJ_FYMX_KJKM;
truncate table TJ_FYMX_HSXM;
truncate table TJ_FYMX_FPXM;
truncate table TJ_FYHS_ZYKJ_DAY;
truncate table TJ_FYHS_ZYHS_DAY;
truncate table TJ_FYHS_ZYFP_DAY;
truncate table TJ_FYHS_MZKJ_DAY;
truncate table TJ_FYHS_MZHS_DAY;
truncate table TJ_FYHS_MZFP_DAY;
truncate table TJ_FYHS_GHKJ_DAY;


----------------------------------------------
truncate table TJ_FYHS_GHHS_DAY;
truncate table TJ_FYHS_GHFP_WD;
truncate table TJ_FYHS_GHFP_DAY;
truncate table TJ_FSE_TEMP;
truncate table TJ_EPMI_MIR2;
truncate table TJ_EPMI_MIR;
truncate table TJ_EPMI_JOB_SHOW;
truncate table TJ_CYHZ_JSXX_SHOW;
truncate table TJ_CYHZFY_SHOW;
truncate table TJ_CWHS_SHOW;
truncate table TJ_BRFY_MIR;
truncate table TEST_BLOB;
truncate table TEMP_ZYH;
truncate table TEMP_HZJZ;
truncate table TEMP_DATETABLE;
truncate table SSS_CMAIN_SHQR_FYD;


----------------------------------------------
delete from MZ_ZH_ZFJL;
delete from MZ_ZFFSJL_TEMP;
delete from MZ_YPDJ_STATUS;
delete from MZ_SFDJ_TEMP_NEXT;
delete from MZ_SFDJ_TEMP_MAIN;
delete from MZ_SFDJ_FP_PRINT_TEMP;
delete from MZ_SFDJ_FP_PRINT_NEXT_TEMP;
delete from MZ_SFDJ_FP_PRINT_NEXT;
delete from MZ_SFDJ_FP_PRINT_MAIN_ZF;
delete from MZ_SFDJ_FP_PRINT_MAIN;
delete from MZ_SFDJ_DH;
delete from MZ_JYLS_STATUS_TEMP;
delete from MZ_JYLS_STATUS;
delete from MZ_JYLS_DH;
delete from MZ_JCDSJ_STATUS;
delete from MZ_FPH_STATUS;
delete from MZ_DJ_STAUS_TEMP;
delete from MZ_CNEXT_JCDXX;
delete from MZ_CNEXT_CFXXB_YQY;
delete from MZ_CMAIN_JCDTFPZ;
delete from MZ_CMAIN_JCDTF;
delete from MZ_CMAIN_JCDTFSQ;


----------------------------------------------

delete from MZ_CMAIN_HFTY;
delete from MZ_CMAIN_HFTFPZ;
delete from MZ_CMAIN_HFTF;
delete from MZYS_ZZZC_MAIN;
delete from MZYS_ZZZC_DH;
delete from MZYS_ZCF_TEMP;
delete from MZYS_ZCF_NEXT;
delete from MZYS_ZCF_MAIN;
delete from MZYS_ZCF_DH;
delete from MZYS_XCF_TEMP;
delete from MZYS_XCF_PS_NEXT;
delete from MZYS_XCF_PS_DH;
delete from MZYS_XCF_NEXT;
delete from MZYS_XCF_MAIN;
delete from MZYS_XCF_DH;
delete from MZYS_JZ_MAIN;

----------------------------------------------
delete from MZYS_JZXX_ZD_NEXT;
delete from MZYS_JZXX_MAIN;
delete from MZYS_JZXX_BSLZT_NEXT;
delete from MZYS_JY_TEMP;
delete from MZYS_JY_PRINT_MAIN;
delete from MZYS_JY_PRINT_DH;
delete from MZYS_JY_NEXT;
delete from MZYS_JY_MAIN;
delete from MZYS_JY_DH;
delete from MZYS_JC_TEMP;
delete from MZYS_JC_PRINT_MAIN;
delete from MZYS_JC_PRINT_DH;
delete from MZYS_J

C_NEXT;
delete from MZYS_JC_MAIN;
delete from MZYS_JC_DH;
delete from MZYS_DMCF_DBJL;
delete from MZYS_DJLR_TEMP;
delete from MZYS_CZ_TEMP;
delete from MZYS_CZ_NEXT;
delete from MZYS_CZ_MAIN;
delete from MZYS_CZ_DH;

----------------------------------------------
delete from MZYS_CF_ZD_NEXT;
delete from MZYS_CF_PRINT_MAIN;
delete from MZYKT_ZH_TEMP;
delete from MZYKT_ZH_STATUS;
delete from MZYKT_ZH_QX_MAIN;
delete from MZYKT_ZH_QX_DH;
delete from MZYKT_ZH_JZ_HZ_NEXT;
delete from MZYKT_ZH_JZ_HZ_MAIN;
delete from MZYKT_ZH_JZMX_TEMP;
delete from MZYKT_ZH_JZMX;
delete from MZYKT_ZH_JZ;
delete from MZYKT_ZH_HZJZ_TEMP;
delete from MZYKT_ZH_CZ_MAIN_DH;
delete from MZYKT_ZH_CZ_MAIN;
delete from MZYKT_ZHWH_TEMP;
delete from MZYKT_ZHWH_NEXT;
delete from MZYKT_ZHWH_MAIN;
delete from MZYKT_ZHWH_DH;
delete from MZYKT_ZF_MAIN;
delete from MZYKT_ZF_DH;
delete from MZYKT_TK_MAIN;

delete from MZ_CMAIN_HFTF_SQ;

----------------------------------------------
delete from MZYKT_STATUS;
delete from MZYKT_QY_MAIN;
delete from MZYKT_MZH_STATUS;
delete from MZYKT_MMXG_TEMP;
delete from MZYKT_MMXG_MAIN;
delete from MZYKT_MMXG_DH;
delete from MZYKT_KYW_TEMP;
delete from MZYKT_HZJZ_DH;
delete from MZYKT_GS_MAIN;
delete from MZYKT_GRJZ_DH;
delete from MZYKT_GH_TH_MAIN;
delete from MZYKT_FK_MAIN;
delete from MZYKT_FK_DH;
delete from MZGH_TH_MAIN;
delete from MZGH_THPZ_MAIN;
delete from MZGH_HZXX_TEMP;
delete from MZGH_HZXX_MAIN;
delete from MZGH_FZ_MAIN;
delete from MZGH_FY_TEMP;
delete from MZGH_FY_NEXT;

----------------------------------------------
delete from MZGH_FY_MAIN;
delete from MZGH_FP_MAIN;
delete from MZGH_FPZF_MAIN;
delete from MZGH_CMAIN_ZPBMB;
delete from MZGH_CMAIN_MRPBB;
delete from MZDJ_HD_NEXT;
delete from MZDJ_HD_MAIN;
delete from HZTJ_TEMP_KSHSSRMX;
delete from HZTJ_OLAP_FSE_JS_FRAGMENT;
delete from HZTJ_OLAP_FSE_JS;
delete from HZTJ_OLAP_FSE_ALL_FRAGMENT;
delete from HZTJ_OLAP_FSE_ALL;
delete from GY_JYXMSF;
delete from GY_JCXMSF;
delete from GY_JCBW;
delete from GY_EPMI_TEMP;
delete from GY_EPMI_MAIN;
delete from GY_EPMI;
delete from GG_MAIN_CGJHD;

delete from MZ_CMAIN_JCDXX;
delete from MZ_CMAIN_CFFY;
delete from MZ_CMAIN_CFSF_YQY;

delete from MZGH_GH_MAIN;


----------------------------------------------
delete from GDZC_LR_TEMP;
delete from GDZC_LR_NEXT;
delete from GDZC_LR_MAIN;
delete from GDZC_LR_DH;
delete from GDZC_KP_TYPE;
delete from FZ_HJXX_MAIN;
delete from FZ_FZTZBHS;
delete from FZ_FZTGLDL;
delete from FZ_DZBRXX_MAIN;
delete from FZ_DL_STATUS;
delete from FZ_CNEXT_FZTGLDL;
delete from FZ_CMAIN_FZTGLDL;
delete from FPGL_ZLYW_DH;
delete from FPGL_YW_ZLFP;
delete from FPGL_YW_USE;
delete from FPGL_YW_HSFP;
delete from FPGL_YW_FPDJ;
delete from DZ_TK_TEMP;
delete from DZ_TK_NEXT;
delete from DZ_TK_MAIN;
delete from DZ_TK_DH;

----------------------------------------------
delete from DZ_TH_TEMP;
delete from DZ_TH_NEXT;
delete

from DZ_TH_MAIN;
delete from DZ_TH_DH;
delete from DZ_RK_TEMP;
delete from DZ_RK_NEXT;
delete from DZ_RK_MAIN;
delete from DZ_RK_DH;
delete from DZ_PRICE_STATUS;
delete from DZ_PRICE_HISTORY_TEMP;
delete from DZ_PRICE_HISTORY_NEXT;
delete from DZ_PRICE_HISTORY_MAIN;
delete from DZ_PRICE_DH;
delete from DZ_PD_TEMP;
delete from DZ_PD_NEXT;
delete from DZ_PD_MAIN;
delete from DZ_PD_DH;
delete from DZ_MAIN_WPDZD;
delete from DZ_KSQL_TEMP;
delete from DZ_KSQL_NEXT;
delete from DZ_KSQL_MAIN;

----------------------------------------------
delete from DZ_KSQL_DH;
delete from DZ_KC_TEMP_STATUS;
delete from DZ_KC_STATUS;
delete from DZ_JH_TEMP;
delete from DZ_JH_NEXT;
delete from DZ_JH_MAIN;
delete from DZ_JH_DH;
delete from DZ_DZD_NEXT;
delete from DZ_DZD_MAIN;
delete from DZ_DH_STATUS;
delete from DZ_CK_TEMP;
delete from DZ_CK_NEXT;
delete from DZ_CK_MAIN;
delete from DZ_CK_DH;
delete from DZ_BS_TEMP;
delete from DZ_BS_NEXT;
delete from DZ_BS_MAIN;
delete from DZ_BS_DH;
delete from CWTJ_TEMP_YSSRTJ;
commit;

---------------------------------------------