/**Begin C:\PDM_UPGRADE\PDM1\SRC_constraint.sql **/
EXEC p_DropIdx 'IDX_SRC_PURLISTENTRY_BID', 'T_SRC_PURLISTENTRY';
EXEC p_DropIdx 'IDX_SRC_PURLISTENTRY_CID', 'T_SRC_PURLISTENTRY';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLISTENTRY_FPROID') CREATE INDEX IDX_SRC_PURLISTENTRY_FPROID ON T_SRC_PURLISTENTRY ( FPROJECTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLISTENTRY_FPACKID') CREATE INDEX IDX_SRC_PURLISTENTRY_FPACKID ON T_SRC_PURLISTENTRY ( FPACKAGEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLISTENTRY_FSUPID') CREATE INDEX IDX_SRC_PURLISTENTRY_FSUPID ON T_SRC_PURLISTENTRY ( FSUPPLIERID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PURLISTENTRY_FPURID') CREATE INDEX IDX_SRC_PURLISTENTRY_FPURID ON T_SRC_PURLISTENTRY ( FPURLISTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIDDOCENTRY_PPURID') CREATE INDEX IDX_SRC_BIDDOCENTRY_PPURID ON T_SRC_BIDDOCENTRY ( FPURLISTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_ENROLLSUPPLIER_FSUP') CREATE INDEX IDX_SRC_ENROLLSUPPLIER_FSUP ON T_SRC_ENROLLSUPPLIER ( FSUPPLIERID );


/**End C:\PDM_UPGRADE\PDM1\SRC_constraint.sql **/
