IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SEC_USER_L_TRUENAME') CREATE INDEX IDX_SEC_USER_L_TRUENAME ON T_SEC_USER_L ( FTRUENAME ,FID );

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