/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\TCCIT_constraint.sql **/
 EXEC P_ALTERPK 'PK_TCCIT_APPORTION_SJJT', 'T_TCCIT_APPORTION_SJJT', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCCIT_APPORTION_SJJT' AND KSQL_INDNAME = 'IDX_APP_ORG_QQ_QZ') CREATE INDEX IDX_APP_ORG_QQ_QZ ON T_TCCIT_APPORTION_SJJT ( FORGID ,FSKSSQQ ,FSKSSQZ );


 EXEC P_ALTERPK 'PK_TCCIT_RECOUP_DEF_SJJT', 'T_TCCIT_RECOUP_DEF_SJJT', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCCIT_RECOUP_DEF_SJJT' AND KSQL_INDNAME = 'IDX_RECOUP_ORG_QQ_QZ') CREATE INDEX IDX_RECOUP_ORG_QQ_QZ ON T_TCCIT_RECOUP_DEF_SJJT ( FORG ,FSKSSQQ ,FSKSSQZ );


 EXEC P_ALTERPK 'PK_TCCIT_YJ_QYYH_SUM_SJJT', 'T_TCCIT_YJ_QYYH_SUM_SJJT', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCCIT_YJ_QYYH_SUM_SJJT' AND KSQL_INDNAME = 'IDX_QYYH_ORG_QQ_QZ') CREATE INDEX IDX_QYYH_ORG_QQ_QZ ON T_TCCIT_YJ_QYYH_SUM_SJJT ( FORGID ,FSKSSQQ ,FSKSSQZ );


 EXEC P_ALTERPK 'PK_TCCIT_ZERORATING_SJJT', 'T_TCCIT_ZERORATING_SJJT', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCCIT_ZERORATING_SJJT' AND KSQL_INDNAME = 'IDX_ZERO_ORG_QQ_QZ') CREATE INDEX IDX_ZERO_ORG_QQ_QZ ON T_TCCIT_ZERORATING_SJJT ( FORGID ,FSKSSQQ ,FSKSSQZ );



/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\TCCIT_constraint.sql **/
