/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\TCCIT_constraint.sql **/
 EXEC P_ALTERPK 'PK_TCCIT_TZ_A100000_1', 'T_TCCIT_TZ_A100000_1', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_TZ_A101010', 'T_TCCIT_TZ_A101010', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_TZ_A101020', 'T_TCCIT_TZ_A101020', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_TZ_A102010', 'T_TCCIT_TZ_A102010', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_TZ_A102020', 'T_TCCIT_TZ_A102020', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_TZ_A103000', 'T_TCCIT_TZ_A103000', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_TZ_A104000', 'T_TCCIT_TZ_A104000', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_TZ_NSTZ', 'T_TCCIT_TZ_NSTZ', 'FID', '0';

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


 EXEC P_ALTERPK 'PK_TCCIT_YEAR_RULE', 'T_TCCIT_YEAR_RULE', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_TCCIT_YEAR_RULE') CREATE  CLUSTERED INDEX IDX_TCCIT_YEAR_RULE ON T_TCCIT_YEAR_RULE ( FNUMBER );


 EXEC P_ALTERPK 'PK_TCCIT_YEAR_RULE_L', 'T_TCCIT_YEAR_RULE_L', 'FPKID', '0';

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



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