서버 복구시 초기화

confluence링크
[http://10.10.1.149:8090/pages/viewpage.action?pageId=75554686#KSMART%EC%84%9C%EB%B9%84%EC%8A%A4%EC%84%A4%EC%B9%98%EA%B0%80%EC%9D%B4%EB%93%9C-%EA%B8%B0%EB%B3%B8IP%EB%A1%9C%EC%84%A4%EC%A0%95]

use klib_migration;
truncate t_boardpartang;
truncate t_cond_map;
truncate t_deploy_status;
truncate t_insp_cond_log;
truncate t_job;
truncate t_job_cond;
truncate t_job_file;
truncate t_job_log;
truncate t_job_tag_set;
truncate t_ocv_images;
truncate t_ocv_values;
truncate t_oddshape_images;
truncate t_package;
truncate t_part;
truncate t_trans_job;
truncate t_vendor;
truncate t_job_key;
truncate t_job_meta;
delete from t_insp_cond where insp_cond_nm not like 'Standards::Default_%';
delete from t_virtual_job where vir_id != '1000000001';
delete from klink.t_equi_stat;
delete from klink.t_equi_stat_log;
delete from kmng.t_dist_file where del_yn = 'Y';
delete from kmng.t_equi_param;
delete from kmng.t_log_admn_work;
delete from kmng.t_log_total;


truncate kspi.t_job;
truncate kspi.t_job_file;
truncate kspi.t_job_log;
truncate kspi.t_job_log_history;
truncate kspi.t_lib;
INSERT INTO kspi.t_lib VALUES ('PACKAGE', 'PkgMasterLibrary.xml', 'KY_INIT', '<kylibrary><headerinfo><fileinfo createdate="2015-10-22 16:25:51" modifydate="2015-10-22 16:25:51"/></headerinfo><packages packagecnt="1"><package name="U.Define"><librarys librarycnt="0"></librarys></package></packages><tables tablecnt="0"/></kylibrary>', 'afb50111d6da2efd5c7c62a05bd4dc0d', '2', '', 'kyadmin', '2016-04-10 18:01:18', '2016-11-14 14:31:49', '10.10.0.2', 'I') ON DUPLICATE KEY UPDATE MODF_DT=NOW();
INSERT INTO kspi.t_lib (`LIB_CD`, `LIB_NM`, `LIB_GROUP_NM`, `LIB_DATA`, `LIB_HASH`, `LIB_REVISION`, `MODF_ASST_SEQNO`, `MODF_ADMN_ID`, `WRIT_DT`, `MODF_DT`, `IP`, `DEL_YN`) VALUES
('DEFAULT', 'Default.pol', 'Default', '[DF]\r\nVOLUME_CHECK=True\r\nEXCESS_ERROR=170\r\nINSUFF_ERROR=50\r\nVOLUME_WARNING=20\r\nPOSITION_CHECK=True\r\nPOSITION_ERRORX=0.5\r\nPOSITION_ERRORY=0.5\r\nPOSITION_WARNING=0.01\r\nBRIDGE_CHECK=True\r\nBRIDGE_HEIGHT=80\r\nBRIDGE_LENGTH=200\r\nBRIDGE_DISTANCE=300\r\nSHAPE_CHECK=True\r\nSHAPE_MED=50\r\nSHAPE_MAX=180\r\nSHADOW_CHECK=False\r\nCOPLANARITY_CHECK=True\r\nCOPLANAR_VALUE=50\r\nHEIGHT_CHECK=False\r\nHEIGHT_U_ERROR=250\r\nHEIGHT_L_ERROR=50\r\nHEIGHT_WARNING=20\r\nHEIGHT_STENCIL=120\r\nDUAL_SIZE=0.35', '081815E68A96DB71BD12EBD12CC06496', '1', '', 'kyadmin', '2016-04-10 18:01:18', '2016-04-10 18:01:18', '10.10.0.2', 'N'),
('PART', 'MasterLibrary.xml', 'Default', '<kylibrary><headerinfo><fileinfo createdate="2015-10-22 16:25:51" modifydate="2015-10-22 16:25:51"/></headerinfo><packages packagecnt="1"><package name="U.Define"><librarys librarycnt="0"></librarys></package></packages><tables tablecnt="0"/></kylibrary>\r\n', '081815E68A96DB71BD12EBD12CC06496', '1', '', 'kyadmin', '2016-04-10 18:01:18', '2016-04-10 18:01:18', '10.10.0.2', 'N'),
('SIZE', 'SizePol.pol', 'Default', '[LIBINFO]\r\nTOTAL=0\r\nSTENCIL_HEIGHT=150\r\n', '081815E68A96DB71BD12EBD12CC06496', '1', '', 'kyadmin', '2016-04-10 18:01:18', '2016-04-10 18:01:18', '10.10.0.2', 'N'),
('DEFAULT', 'Default.pol', 'KY_INIT', '[DF]\r\nVOLUME_CHECK=True\r\nEXCESS_ERROR=170\r\nINSUFF_ERROR=50\r\nVOLUME_WARNING=20\r\nPOSITION_CHECK=True\r\nPOSITION_ERRORX=0.5\r\nPOSITION_ERRORY=0.5\r\nPOSITION_WARNING=0.01\r\nBRIDGE_CHECK=True\r\nBRIDGE_HEIGHT=80\r\nBRIDGE_LENGTH=200\r\nBRIDGE_DISTANCE=300\r\nSHAPE_CHECK=True\r\nSHAPE_MED=50\r\nSHAPE_MAX=180\r\nSHADOW_CHECK=False\r\nCOPLANARITY_CHECK=True\r\nCOPLANAR_VALUE=50\r\nHEIGHT_CHECK=False\r\nHEIGHT_U_ERROR=250\r\nHEIGHT_L_ERROR=50\r\nHEIGHT_WARNING=20\r\nHEIGHT_STENCIL=120\r\nDUAL_SIZE=0.35', '081815E68A96DB71BD12EBD12CC06496', '1', '', 'kyadmin', '2016-04-10 18:01:18', '2016-04-10 18:01:18', '10.10.0.2', 'Y'),
('PART', 'MasterLibrary.xml', 'KY_INIT', '<kylibrary><headerinfo><fileinfo createdate="2015-10-22 16:25:51" modifydate="2015-10-22 16:25:51"/></headerinfo><packages packagecnt="1"><package name="U.Define"><librarys librarycnt="0"></librarys></package></packages><tables tablecnt="0"/></kylibrary>\r\n', '081815E68A96DB71BD12EBD12CC06496', '1', '', 'kyadmin', '2016-04-10 18:01:18', '2016-04-10 18:01:18', '10.10.0.2', 'Y'),
('SIZE', 'SizePol.pol', 'KY_INIT', '[LIBINFO]\r\nTOTAL=0\r\nSTENCIL_HEIGHT=150\r\n', '081815E68A96DB71BD12EBD12CC06496', '1', '', 'kyadmin', '2016-04-10 18:01:18', '2016-04-10 18:01:18', '10.10.0.2', 'Y');
truncate kspi.t_lib_detail;
truncate kspi.t_lib_log;
truncate kspi.t_rtm_alarm;
truncate kspi.t_rtm_board;
truncate kspi.t_rtm_cpk;
truncate kspi.t_rtm_data;
truncate kspi.t_rtm_defect_data;
truncate kspi.t_rtm_defect_log;
truncate kspi.t_rtm_slide_bar;
truncate kspi.t_rtm_slide_yield;
truncate kspi.t_rtm_status;