/**Begin C:\PDM_UPGRADE\PDM1\SRC_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_PROJECT_A_FSRCAPPLYID') CREATE INDEX IDX_SRC_PROJECT_A_FSRCAPPLYID ON T_SRC_PROJECT_A ( FSRCAPPLYID );

 EXEC P_ALTERPK 'PK_SRC_APPLYSUPPLIER', 'T_SRC_APPLYSUPPLIER', 'FENTRYID', '1';

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

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_APPLYSUPPLIER_FID') CREATE INDEX IDX_SRC_APPLYSUPPLIER_FID ON T_SRC_APPLYSUPPLIER ( FID );



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