/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\POM_constraint.sql **/


/*im_mdc_mftmanuinbill-完工入库单--t_im_mdc_productinbill-fbookdate*/	
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_MDC_PRODUCTINB_BKD') 
CREATE INDEX IDX_IM_MDC_PRODUCTINB_BKD ON T_IM_MDC_PRODUCTINBILL ( FBOOKDATE );

/*im_mdc_omcmplinbill-委外完工入库单--t_im_mdc_omcmplinbill-fbookdate*/	
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_MDC_OMCMPLINB_BKD') 
CREATE INDEX IDX_IM_MDC_OMCMPLINB_BKD ON T_IM_MDC_OMCMPLINBILL ( FBOOKDATE );


/*im_mdc_mftproorder-生产领料单--t_im_mdc_mreqoutbill-fbookdate*/	
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_MDC_MREQOUTB_BKD') 
CREATE INDEX IDX_IM_MDC_MREQOUTB_BKD ON T_IM_MDC_MREQOUTBILL ( FBOOKDATE );
	
/*im_mdc_omoutbill-委外领料单--t_im_mdc_omoutbill-fbookdate*/	
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_IM_MDC_OMOUTB_BKD') 
CREATE INDEX IDX_IM_MDC_OMOUTB_BKD ON T_IM_MDC_OMOUTBILL ( FBOOKDATE );

/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\POM_constraint.sql **/