
 EXEC P_ALTERPK 'PK_HPDI_COLLATASKAPP', 'T_HPDI_COLLATASKAPP', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HPDI_COLLATASKAPP') CREATE INDEX IDX_HPDI_COLLATASKAPP ON T_HPDI_COLLATASKAPP ( FID ,FBASEDATAID );


 EXEC P_ALTERPK 'PK_HPDI_TASKCENTERAPP', 'T_HPDI_TASKCENTERAPP', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HPDI_TASKCENTERAPP') CREATE INDEX IDX_HPDI_TASKCENTERAPP ON T_HPDI_TASKCENTERAPP ( FID ,FBASEDATAID );


 EXEC P_ALTERPK 'PK_HPDI_SUMVBILLAPP', 'T_HPDI_SUMVBILLAPP', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HPDI_SUMVBILLAPP') CREATE INDEX IDX_HPDI_SUMVBILLAPP ON T_HPDI_SUMVBILLAPP ( FID ,FBASEDATAID );


 EXEC P_ALTERPK 'PK_HPDI_VERMULTASKCENTER', 'T_HPDI_VERMULTASKCENTER', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HPDI_VERMULTASKCENTER') CREATE INDEX IDX_HPDI_VERMULTASKCENTER ON T_HPDI_VERMULTASKCENTER ( FID ,FBASEDATAID );


 EXEC P_ALTERPK 'PK_HPDI_VERMULCOLLATASK', 'T_HPDI_VERMULCOLLATASK', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HPDI_VERMULCOLLATASK') CREATE INDEX IDX_HPDI_VERMULCOLLATASK ON T_HPDI_VERMULCOLLATASK ( FID ,FBASEDATAID );
