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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCTB_TAXCALENDAR_LIST' AND KSQL_INDNAME = 'IDX_TCTB_CALENDAR_LIST_01') CREATE INDEX IDX_TCTB_CALENDAR_LIST_01 ON T_TCTB_TAXCALENDAR_LIST ( FBILLNO );


 EXEC P_ALTERPK 'PK_TCTB_TAXCALENDAR_RULE', 'T_TCTB_TAXCALENDAR_RULE', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_TCTB_TAXCALENDAR_RULE_L', 'T_TCTB_TAXCALENDAR_RULE_L', 'FPKID', '1';

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



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