
  EXEC P_ALTERPK 'PK_HBSS_TRIALPERIODRESULT', 'T_HBSS_TRIALPERIODRESULT', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_TRIALPERIODRESULT') CREATE INDEX IDX_HBSS_TRIALPERIODRESULT ON T_HBSS_TRIALPERIODRESULT ( FNUMBER );


 EXEC P_ALTERPK 'PK_HBSS_TRIALPERIODRESULT_L', 'T_HBSS_TRIALPERIODRESULT_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HBSS_BLOODTYPE', 'T_HBSS_BLOODTYPE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_BLOODTYPE') CREATE INDEX IDX_HBSS_BLOODTYPE ON T_HBSS_BLOODTYPE ( FNUMBER );


 EXEC P_ALTERPK 'PK_HBSS_BLOODTYPE_L', 'T_HBSS_BLOODTYPE_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_HBSS_ADDRESSDETAIL', 'T_HBSS_ADDRESSDETAIL', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_ADDRESSDETAIL') CREATE INDEX IDX_HBSS_ADDRESSDETAIL ON T_HBSS_ADDRESSDETAIL ( FNUMBER );


 EXEC P_ALTERPK 'PK_HBSS_ADDRESSDETAIL_L', 'T_HBSS_ADDRESSDETAIL_L', 'FPKID', '1';

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