ASMS数据库数据初始化

关于ASMS数据库数据初始化：
1. 业务信息系统部分，需清空如下：
TRUNCATE TABLE AIRCRAFTOPERATION_DIC ;
TRUNCATE TABLE CHECKITEMKEY ;
TRUNCATE TABLE DOCUMENTCATAGORY_DIC ;
TRUNCATE TABLE ENGINEERASSRE ;
TRUNCATE TABLE ICACHECKITEM ;
TRUNCATE TABLE ICACHECKLIST ;
TRUNCATE TABLE INCORPORATIONRECORDS ;
TRUNCATE TABLE MODIFICATION ;
TRUNCATE TABLE MAR ;
TRUNCATE TABLE MODIFICATION_COMPONENT ;
TRUNCATE TABLE MOFILE_MODIFI ;
TRUNCATE TABLE MOSOURCEFILE ;
TRUNCATE TABLE RECORDATT ;
TRUNCATE TABLE T_CE_CORRISONREPORTFORMS ;
TRUNCATE TABLE T_CE_CORROSIONEVALUATION ;
TRUNCATE TABLE T_CE_CORROSIONIMPROVEMENT ;
TRUNCATE TABLE T_CE_FILES ;
TRUNCATE TABLE T_CE_MEASURESTYLE ;
TRUNCATE TABLE T_COM_LOCATION ;
TRUNCATE TABLE T_COM_LOCATIONMSG ;
TRUNCATE TABLE T_COM_LOG ;
TRUNCATE TABLE T_COM_RECORD ;
TRUNCATE TABLE T_DTE_DTEEVALUATION ;
TRUNCATE TABLE T_DTE_DTEEVALUATIONJOBLIST ;
TRUNCATE TABLE T_DTE_DUEDATE ;
TRUNCATE TABLE T_DTE_FILES ;
TRUNCATE TABLE T_EE_AIRCRAFT ;
TRUNCATE TABLE T_EE_ATTACHMENT ;
TRUNCATE TABLE T_EE_COMPLIANCEFILE ;
TRUNCATE TABLE T_EE_COMPONENT ;
TRUNCATE TABLE T_EE_COMPONENTPOSITION ;
TRUNCATE TABLE T_EE_DATACHANGE ;
TRUNCATE TABLE T_EE_ECONOMICAPPROVED ;
TRUNCATE TABLE T_EE_ECONOMICEVALUATION ;
TRUNCATE TABLE T_EE_ECONOMICEVAPRICEOFMANHOUR ;

TRUNCATE TABLE T_EE_EEBASEINFO ;
TRUNCATE TABLE T_EE_ENGINEERINGAUDIT ;
TRUNCATE TABLE T_EE_EXECQK ;
TRUNCATE TABLE T_EE_IMPCOMPLIANCEFILEBASE ;
TRUNCATE TABLE T_EE_IMPCOMPLIANCEFILEPARA ;
TRUNCATE TABLE T_EE_PARA ;
TRUNCATE TABLE T_EE_RELATIONFILE ;
TRUNCATE TABLE T_EE_REVIEWON ;
TRUNCATE TABLE T_EE_SFAAIRCRAFT ;
TRUNCATE TABLE T_EE_SFACOMPONENT ;
TRUNCATE TABLE T_EE_SOURCEFILE ;
TRUNCATE TABLE T_EE_SOURCEFILECOMEFFEC ;
TRUNCATE TABLE T_EE_TIMELIMITCONDITION ;
TRUNCATE TABLE T_EE_TIMELIMITCONDITION_BDS ;
TRUNCATE TABLE T_EE_TIMELIMITOPERATE ;
TRUNCATE TABLE T_ER_AIRCRAFT ;
TRUNCATE TABLE T_ER_APPLICABLESERRIALNUM ;
TRUNCATE TABLE T_ER_ATTACHMENT ;
TRUNCATE TABLE T_ER_AUDIT ;
TRUNCATE TABLE T_ER_BASEINFOCOMPONENT ;
TRUNCATE TABLE T_ER_COMPLIANCEFILE ;
TRUNCATE TABLE T_ER_COMPONENT ;
TRUNCATE TABLE T_ER_DATACHANGE ;
TRUNCATE TABLE T_ER_ECONOMICAPPROVED ;
TRUNCATE TABLE T_ER_ECONOMICEVALUATION ;
TRUNCATE TABLE T_ER_ERBASEINFO ;
TRUNCATE TABLE T_ER_EXECQK ;
TRUNCATE TABLE T_ER_PARA ;
TRUNCATE TABLE T_ER_RELATIONCONDITION ;
TRUNCATE TABLE T_ER_RELATIONFILE ;
TRUNCATE TABLE T_ER_REVIEWCONDITION ;
TRUNCATE TABLE T_ER_SFAAIRCRAFT ;
TRUNCATE TABLE T_ER_SFACOMPONENT ;
TRUNCATE TABLE T_ER_SOURCEFILE ;
TRUNCATE TABLE T_ER_SUBCOMPONENT ;
TRUNCATE TABLE T_ER_TIMELIMITCONDITION ;
TRUNCATE TABLE T_ER_TIMELIMITCONDITION_BDS ;
TRUNCATE TABLE T_ER_USERRELATION ;
TRUNCATE TABLE T_MO_ATTACHMENT ;
TRUNCATE TABLE T_MOD_DRSEARCH ;
TRUNCATE TABLE T_MP_AMM_REF ;
TRUNCATE TABLE T_MP_APPLICABILITY ;
TRUNCATE TABLE T_MP_ATTACHMENT ;
TRUNCATE TABLE T_MP_ATTACHMENT_CONTENT ;
TRUNCATE TABLE T_MP_ITEM_GROUP ;
TRUNCATE TABLE T_MP_MAINTENANCE_PROGRAM ;
TRUNCATE TABLE T_MP_MAINTENANCE_PROGRAM_ITEM ;
TRUNCATE TABLE T_MP_MPHISTORY ;
TRUNCATE TABLE T_MP_MPIREPAIRASSESSMENT ;
TRUNCATE TABLE T_MP_MPREPAIRASSESSMENT ;
TRUNCATE TABLE T_MP_REPAIRAPPROVALFORMS ;
TRUNCATE TABLE T_MP_REPAIRAPPROVALHISTORY ;
TRUNCATE TABLE T_MP_REPAIRREPERT ;
TRUNCATE TABLE T_MP_REPAIRREPERTCOUNT ;
TRUNCATE TABLE T_MP_SOURCE_ITEM ;
TRUNCATE TABLE T_MP_SOURCE_ITEM_IMPORT ;
TRUNCATE TABLE T_MP_SOURCE_ITEM_IMPORTHIS ;
TRUNCATE TABLE T_MP_SOURCEFILE ;
TRUNCATE TABLE T_MP_TEMPREPAIRREPERT ;
TRUNCATE TABLE T_MP_USEFULL_PAGE_FORM ;
TRUNCATE TABLE T_OPERATING_LOG ;
TRUNCATE TABLE T_RELATION_ELEMENT_BUSINESS ;
TRUNCATE TABLE T_RM_CALLPOLICEBILL ;
TRUNCATE TABLE T_RM_HARM_WARN_RULE ;
TRUNCATE TABLE T_RM_MONITORFORNRC ;
TRUNCATE TABLE T_RM_REPORT ;
TRUNCATE TABLE T_RM_WARN_RULE_APPROVE ;
TRUNCATE TABLE T_SP_REPAIRINFO ;
TRUNCATE TABLE T_SP_WARNINGMONITOR ;
TRUNCATE TABLE T_SP_WARNINGREGULATION ;
TRUNCATE TABLE T_SR_ATTACHMENT ;
TRUNCATE TABLE T_SR_CONTACT ;
TRUNCATE TABLE T_SR_MESSAGE ;
TRUNCATE TABLE T_SR_OEM ;
TRUNCATE TABLE T_SR_SRCATALOGUEDATA ;
TRUNCATE TABLE T_SR_TASKLIST ;
TRUNCATE TABLE T_SR_USER ;
TRUNCATE TABLE T_STRUCTURALELEMENTS ;
TRUNCATE TABLE T_SX_ASSESSINFOS ;
TRUNCATE TABLE T_SX_CONSTRUCTINFOS ;
TRUNCATE TABLE T_SX_DAMAGEDASSESS ;
TRUNCATE TABLE T_SX_DAMAGEDETAILEDREMOVAL ;
TRUNCATE TABLE T_SX_DAMAGEINSPECTIONREMOVA ;
TRUNCATE TABLE T_SX_DAMAGELOCATION ;
TRUNCATE TABLE T_SX_DAMAGERECORDCARD ;
TRUNCATE TABLE T_SX_DAMAGEREMOVALSTAPE ;
TRUNCATE TABLE T_SX_DRCDAMAGECATAGORYTYPEDIC ;
TRUNCATE TABLE T_SX_DRCDAMAGESHAPDIC ;
TRUNCATE TABLE T_SX_DRCREASONS ;
TRUNCATE TABLE T_SX_ENGINEERINGAPPROVAL ;
TRUNCATE TABLE T_SX_EXPENDABLEPARTS ;
TRUNCATE TABLE T_SX_EXTERNALDAMAGEDANDREPAIR ;
TRUNCATE TABLE T_SX_FILES ;
TRUNCATE TABLE T_SX_IMPORTANTORCOMMONREPAIR ;
TRUNCATE TABLE T_SX_MATERIALS ;
TRUNCATE TABLE T_SX_NRC ;
TRUNCATE TABLE T_SX_OUTDTEVALUATION ;
TRUNCATE TABLE T_SX_PARTINFO ;
TRUNCATE TABLE T_SX_PATCHINFOS ;
TRUNCATE TABLE T_SX_REPAIRFASTENER ;
TRUNCATE TABLE T_SX_REPAIRFEEDBACK ;
TRUNCATE TABLE T_SX_REPAIRSOLUTIONSTEPS ;
TRUNCATE TABLE T_SX_ROTABLEEXCHANGE ;
TRUNCATE TABLE T_SX_TECHNICALDEVIATIONA ;
TRUNCATE TABLE T_SYS_MESSAGE ;
TRUNCATE TABLE T_TM_TASKDELAY ;
TRUNCATE TABLE T_TM_TASKS ;
TRUNCATE TABLE T_ZONE_CUSTOM ;

1. 三维模型数据，需清空marker和patch。
   脚本如下：

select * from asms3d_models_data a where a.uuid in( select t.uuid from ASMS3D_MODELS_PATH t where lower(t.filepath) like ‘%marker%’) for update;

select * from asms3d_models_data b where b.uuid in ( select t.uuid from ASMS3D_MODELS_PATH t where lower(t.filepath) like ‘%patch%’) for update;

select * from ASMS3D_MODELS_PATH t where lower(t.filepath) like ‘%patch%’ for update;

select * from ASMS3D_MODELS_PATH t where lower(t.filepath) like ‘%marker%’ for update;