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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_TCCIT_RULE_ACCHILD_1') CREATE INDEX IDX_T_TCCIT_RULE_ACCHILD_1 ON T_TCCIT_RULE_ACCHILD ( FENTRYID );


 EXEC P_ALTERPK 'PK_TCCIT_RULE_YJCHILD', 'T_TCCIT_RULE_YJCHILD', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_TCCIT_RULE_YJCHILD_1') CREATE INDEX IDX_T_TCCIT_RULE_YJCHILD_1 ON T_TCCIT_RULE_YJCHILD ( FENTRYID );


 EXEC P_ALTERPK 'PK_TCCIT_YJ_ASSETS_ACCDET', 'T_TCCIT_YJ_ASSETS_ACCDET', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_TCCIT_YJ_ASSETS_SUMMARY', 'T_TCCIT_YJ_ASSETS_SUMMARY', 'FID', '1';

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



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