/**Begin C:\PDM_UPGRADE\PDM1\SRM_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_SRM_MOBILEINSPECT', 'T_SRM_MOBILEINSPECT', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRM_MOBILEINSPECT_FBILLNO') CREATE INDEX IDX_SRM_MOBILEINSPECT_FBILLNO ON T_SRM_MOBILEINSPECT ( FBILLNO );


 EXEC P_ALTERPK 'PK_T_SRM_AUDITENTRYATT', 'T_SRM_AUDITENTRYATT', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_SRM_AUDITENTRYATT') CREATE INDEX IDX_T_SRM_AUDITENTRYATT ON T_SRM_AUDITENTRYATT ( FBASEDATAID );


 EXEC P_ALTERPK 'PK_T_SRM_INSPECTENTRY', 'T_SRM_INSPECTENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_T_SRM_INSPECTCATEGORY', 'T_SRM_INSPECTCATEGORY', 'FENTRYID', '1';

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



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