/** 对表T_ER_EXPENSEDETAIL的字段 FEXPENSEITEMID、FHAPPENDATE 和 FREIMBURSER创建索引 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_EXPDETAIL_EXPITMEID') CREATE INDEX IDX_ER_EXPDETAIL_EXPITMEID ON T_ER_EXPENSEDETAIL ( FEXPENSEITEMID );

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_EXPDETAIL_HAPPENDATE') CREATE INDEX IDX_ER_EXPDETAIL_HAPPENDATE ON T_ER_EXPENSEDETAIL ( FHAPPENDATE );

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_EXPDETAIL_REIMBURSER') CREATE INDEX IDX_ER_EXPDETAIL_REIMBURSER ON T_ER_EXPENSEDETAIL ( FREIMBURSER );
