
  EXEC P_ALTERPK 'PK_T_EB_ADAPTSCOPE', 'T_EB_ADAPTSCOPE', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EB_ADAPTSCOPE_P1') CREATE INDEX IDX_EB_ADAPTSCOPE_P1 ON T_EB_ADAPTSCOPE ( FID );

  EXEC P_ALTERPK 'PK_T_EB_FIXEDVALUE', 'T_EB_FIXEDVALUE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EB_FIXEDVALUE_P1') CREATE INDEX IDX_EB_FIXEDVALUE_P1 ON T_EB_FIXEDVALUE ( FMODELID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EB_FIXEDVALUE_P2') CREATE INDEX IDX_EB_FIXEDVALUE_P2 ON T_EB_FIXEDVALUE ( FBIZMODEL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EB_FIXEDVALUE_P3') CREATE INDEX IDX_EB_FIXEDVALUE_P3 ON T_EB_FIXEDVALUE ( FFIXEDTYPE );

  EXEC P_ALTERPK 'PK_T_EB_FIXEDVALUESETTING', 'T_EB_FIXEDVALUESETTING', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EB_FIXVALUESETTING_P1') CREATE INDEX IDX_EB_FIXVALUESETTING_P1 ON T_EB_FIXEDVALUESETTING ( FID );