@@ -0,0 +1,1409 @@
+package org.folio.rest.persist.ddlgen;%0A%0Aimport static org.hamcrest.CoreMatchers.containsString;%0Aimport static org.junit.Assert.*;%0A%0Aimport java.io.IOException;%0A%0Aimport org.folio.rest.tools.PomReader;%0Aimport org.folio.rest.tools.utils.ObjectMapperTool;%0Aimport org.folio.util.ResourceUtil;%0Aimport org.junit.Test;%0A%0Aimport freemarker.template.TemplateException;%0A%0Apublic class SchemaMakerTest %7B%0A  private String tidy(String s) %7B%0A    return s%0A        .replaceAll(%22-- %5B%5E%5Cn%5Cr%5D*%22, %22 %22)  // remove comment%0A        .replaceAll(%22%5B %5Cn%5Cr%5D+%22, %22 %22)     // merge multiple whitespace characters%0A        .replaceAll(%22 *%5C%5C( *%22, %22(%22)      // remove space before and after (%0A        .replaceAll(%22 *%5C%5C) *%22, %22)%22)      // remove space before and after )%0A        .replaceAll(%22;%22, %22;%5Cn%22);         // one line per sql statement%0A  %7D%0A%0A  @Test%0A  public void lowerUnaccentIndex() throws IOException, TemplateException %7B%0A    SchemaMaker schemaMaker = new SchemaMaker(%22harvard%22, %22circ%22, TenantOperation.CREATE,%0A        PomReader.INSTANCE.getVersion(), PomReader.INSTANCE.getRmbVersion());%0A%0A    String json = ResourceUtil.asString(%22templates/db_scripts/caseinsensitive.json%22);%0A    schemaMaker.setSchema(ObjectMapperTool.getMapper().readValue(json, Schema.class));%0A    assertThat(tidy(schemaMaker.generateDDL()), containsString(%0A        %22CREATE INDEX IF NOT EXISTS item_title_idx ON harvard_circ.item(lower(f_unaccent(jsonb-%3E%3E'title'))%22));%0A  %7D%0A%7D%0A

add SchemaMakerTest.java with lowerUnaccentIndex()