/**Begin C:\PDM_UPGRADE\sharepdmdir\sou\pdm1\SOU_constraint.sql **/
EXEC p_DropIdx 'IDX_BD_CENTRAL_ORG_TIME', 'T_BD_CENTRALPURCHASELIST';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BD_CENTRAL_ORG_TIME') CREATE INDEX IDX_BD_CENTRAL_ORG_TIME ON T_BD_CENTRALPURCHASELIST ( FCREATETIME ,FCREATEORGID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BD_CENTRAL_CATEGORY') CREATE INDEX IDX_BD_CENTRAL_CATEGORY ON T_BD_CENTRALPURCHASELIST ( FCATEGORYID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BD_CENTRAL_MATERIAL') CREATE INDEX IDX_BD_CENTRAL_MATERIAL ON T_BD_CENTRALPURCHASELIST ( FMATERIALID );


EXEC p_DropIdx 'IDX_BD_PURSTRATEGY_ORG_TIME', 'T_BD_PURSTRATEGY';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BD_PURSTRATEGY_TIME_ORG') CREATE INDEX IDX_BD_PURSTRATEGY_TIME_ORG ON T_BD_PURSTRATEGY ( FCREATETIME ,FCREATEORGID );

EXEC p_DropIdx 'IDX_BD_SRCSTRATEGY_ORG_TIME', 'T_BD_SRCSTRATEGY';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BD_SRCSTRATEGY_TIME_ORG') CREATE INDEX IDX_BD_SRCSTRATEGY_TIME_ORG ON T_BD_SRCSTRATEGY ( FCREATETIME ,FCREATEORGID );


/**End C:\PDM_UPGRADE\sharepdmdir\sou\pdm1\SOU_constraint.sql **/
