/**Begin D:\PDM_UPGRADE\PDM1\TCCIT_constraint.sql **/
 EXEC P_ALTERPK 'PK_TCCIT_OTHER_RULE', 'T_TCCIT_OTHER_RULE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_OTHER_RULE') CREATE INDEX IDX_TCCIT_OTHER_RULE ON T_TCCIT_OTHER_RULE ( FNUMBER );


 EXEC P_ALTERPK 'PK_TCCIT_OTHER_RULE_ENTRY', 'T_TCCIT_OTHER_RULE_ENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_TCCIT_OTHER_RULE_L', 'T_TCCIT_OTHER_RULE_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_OTHER_RULE_L_0') CREATE INDEX IDX_TCCIT_OTHER_RULE_L_0 ON T_TCCIT_OTHER_RULE_L ( FID ,FLOCALEID );


 EXEC P_ALTERPK 'PK_TCCIT_FDCTDYW_ACCDETAIL', 'T_TCCIT_FDCTDYW_ACCDETAIL', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_FDCTDYW_ACCDETA') CREATE INDEX IDX_TCCIT_FDCTDYW_ACCDETA ON T_TCCIT_FDCTDYW_ACCDETAIL ( FORGID ,FSKSSQQ ,FSKSSQZ );


 EXEC P_ALTERPK 'PK_TCCIT_FDCTDYW_MLE_SUM', 'T_TCCIT_FDCTDYW_MLE_SUM', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_FDCTDYW_MLE_SUM') CREATE INDEX IDX_TCCIT_FDCTDYW_MLE_SUM ON T_TCCIT_FDCTDYW_MLE_SUM ( FORGID ,FSKSSQQ ,FSKSSQZ );


 EXEC P_ALTERPK 'PK_TCCIT_FDCTDYW_NSTZ_SUM', 'T_TCCIT_FDCTDYW_NSTZ_SUM', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_FDCTDYW_NSTZ_SU') CREATE INDEX IDX_TCCIT_FDCTDYW_NSTZ_SU ON T_TCCIT_FDCTDYW_NSTZ_SUM ( FORGID ,FSKSSQQ ,FSKSSQZ );


 EXEC P_ALTERPK 'PK_TCCIT_DG_B105093_DET', 'T_TCCIT_DG_B105093_DET', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_B105093_DET') CREATE INDEX IDX_TCCIT_B105093_DET ON T_TCCIT_DG_B105093_DET ( FORGID ,FSKSSQQ ,FSKSSQZ );


 EXEC P_ALTERPK 'PK_TCCIT_DG_B105093MLE_SUM', 'T_TCCIT_DG_B105093MLE_SUM', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_B105093MLE_SUM') CREATE INDEX IDX_TCCIT_B105093MLE_SUM ON T_TCCIT_DG_B105093MLE_SUM ( FORGID ,FSKSSQQ ,FSKSSQZ );


 EXEC P_ALTERPK 'PK_TCCIT_DG_B105093TZ_SUM', 'T_TCCIT_DG_B105093TZ_SUM', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_B105093TZ_SUM') CREATE INDEX IDX_TCCIT_B105093TZ_SUM ON T_TCCIT_DG_B105093TZ_SUM ( FORGID ,FSKSSQQ ,FSKSSQZ );



/**End D:\PDM_UPGRADE\PDM1\TCCIT_constraint.sql **/
