/**Begin D:\pdm\PDM_UPGRADE_1.1\PDM_UPGRADE\pdm1\BDM_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_GOODSINFO_MATERIALNO') CREATE INDEX IDX_GOODSINFO_MATERIALNO ON T_BDM_GOODS_INFO_ITEM ( FMATERIALNO );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_GOODSINFO_MATERIALTYPE') CREATE INDEX IDX_GOODSINFO_MATERIALTYPE ON T_BDM_GOODS_INFO_ITEM ( FMATERIALTYPE );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_GOODSINFO_EXPENSEITEM') CREATE INDEX IDX_GOODSINFO_EXPENSEITEM ON T_BDM_GOODS_INFO_ITEM ( FEXPENSEITEM );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_GOODSINFO_MATERIALNAME') CREATE INDEX IDX_GOODSINFO_MATERIALNAME ON T_BDM_GOODS_INFO_ITEM ( FMATERIALNAME );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_GOODSINFO_MATERIALCODE') CREATE INDEX IDX_GOODSINFO_MATERIALCODE ON T_BDM_GOODS_INFO_ITEM ( FMODELNUMCODE );


/**End D:\pdm\PDM_UPGRADE_1.1\PDM_UPGRADE\pdm1\BDM_constraint.sql **/
