/**Begin C:\PDM_UPGRADE\PDM1\PUR_constraint.sql **/
 EXEC P_ALTERPK 'PK_PUR_CHECK_GROUP_CONFIG', 'T_PUR_CHECK_GROUP_CONFIG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PUR_CHECKGROUPCONFIG_FTIME') CREATE INDEX IDX_PUR_CHECKGROUPCONFIG_FTIME ON T_PUR_CHECK_GROUP_CONFIG ( FCREATETIME );


 EXEC P_ALTERPK 'PK_PUR_CHECK_MAPPING', 'T_PUR_CHECK_MAPPING', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX__PUR_CHECK_MAPPING') CREATE INDEX IDX__PUR_CHECK_MAPPING ON T_PUR_CHECK_MAPPING ( FSOURCEBILL ,FISENABLE );


 EXEC P_ALTERPK 'PK_PUR_CHECK_MFIXEDENTRY', 'T_PUR_CHECK_MFIXEDENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_PUR_CHECK_MFIXEDENTRY') CREATE INDEX IDX_PUR_CHECK_MFIXEDENTRY ON T_PUR_CHECK_MFIXEDENTRY ( FID ,FSEQ );



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