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

/*pom_mftorderreport-工单汇报单--t_pom_mftorderreport-fbookdate*/	
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_POM_MFTORDERRP_BKD') 
CREATE INDEX IDX_POM_MFTORDERRP_BKD ON T_POM_MFTORDERREPORT ( FBOOKDATE );
	
/*pom_mftorder-生产工单--t_pom_mftorderentry- fbeginbookdate*/	
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_POM_MFTORDERET_BKD') 
CREATE INDEX IDX_POM_MFTORDERET_BKD ON T_POM_MFTORDERENTRY ( FBEGINBOOKDATE );


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