 EXEC P_ALTERPK 'PK_T_SEC_USERINFOCLEANSCHEME', 'T_SEC_USERINFOCLEANSCHEME', 'FID', '1';

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


 EXEC P_ALTERPK 'PK_T_SEC_USERINFOCLEANSCHEME_L', 'T_SEC_USERINFOCLEANSCHEME_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_SEC_USERINFOCLNSCHENTRY', 'T_SEC_USERINFOCLNSCHENTRY', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_T_SEC_USERCLEAN', 'T_SEC_USERCLEAN', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_SEC_USERCLEAN') CREATE INDEX IDX_T_SEC_USERCLEAN ON T_SEC_USERCLEAN ( FUSERINFOCLEANSCHEMEID );
