/**Begin D:\PDM_UPGRADE\PDM1\TCTB_constraint.sql **/
 EXEC P_ALTERPK 'PK_TCTB_TAX_PLAN', 'T_TCTB_TAX_PLAN', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCTB_TAX_PLAN' AND KSQL_INDNAME = 'IDX_TAX_PLAN_NUMBER') CREATE INDEX IDX_TAX_PLAN_NUMBER ON T_TCTB_TAX_PLAN ( FNUMBER );


 EXEC P_ALTERPK 'PK_TCTB_TAX_PLAN_L', 'T_TCTB_TAX_PLAN_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCTB_TAX_PLAN_L' AND KSQL_INDNAME = 'IDX_TCTB_TAX_PLAN_L_0') CREATE INDEX IDX_TCTB_TAX_PLAN_L_0 ON T_TCTB_TAX_PLAN_L ( FID ,FLOCALEID );



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