/**Begin D:\DBA\1.4\PDM_UPGRADE\PDM1\BCM_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_BCM_CHECKRECORDSUM', 'T_BCM_CHECKRECORDSUM', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_BCM_CHECKRECORDSUM' AND KSQL_INDNAME = 'IDX_BCM_CHECKRECORDSUM') CREATE INDEX IDX_BCM_CHECKRECORDSUM ON T_BCM_CHECKRECORDSUM ( FMODELID ,FENTITYID ,FSCENEID ,FYEARID ,FPERIODID );


 EXEC P_ALTERPK 'PK_T_BCM_CHECKRECORDSUMENT', 'T_BCM_CHECKRECORDSUMENT', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_BCM_CHECKRECORDSUMENT' AND KSQL_INDNAME = 'IDX_BCM_CHECKRECORDSUMENT') CREATE INDEX IDX_BCM_CHECKRECORDSUMENT ON T_BCM_CHECKRECORDSUMENT ( FID );


 EXEC P_ALTERPK 'PK_T_BCM_CHECKRECORDLINK', 'T_BCM_CHECKRECORDLINK', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_BCM_CHECKRECORDLINK' AND KSQL_INDNAME = 'IDX_BCM_CHECKRECORDLINK') CREATE INDEX IDX_BCM_CHECKRECORDLINK ON T_BCM_CHECKRECORDLINK ( FMODELID ,FCHECKRECORDSUMID ,FCHECKRECORDID );



/**End D:\DBA\1.4\PDM_UPGRADE\PDM1\BCM_constraint.sql **/
