code: protected Collection<String> getIndexesDroppingScripts()
     {
        Collection<String> scripts = new ArrayList<String>();
  
        scripts.add("DROP INDEX JCR_IDX_" + itemTableSuffix + "_PARENT_FK");
        scripts.add("DROP INDEX JCR_IDX_" + itemTableSuffix + "_PARENT");
        scripts.add("DROP INDEX JCR_IDX_" + itemTableSuffix + "_PARENT_NAME");
        scripts.add("DROP INDEX JCR_IDX_" + itemTableSuffix + "_PARENT_ID");
        scripts.add("DROP INDEX JCR_IDX_" + itemTableSuffix + "_N_ORDER_NUM");
        scripts.add("DROP INDEX JCR_IDX_" + itemTableSuffix + "_NAME");
        scripts.add("DROP INDEX JCR_IDX_" + valueTableSuffix + "_PROPERTY");
        scripts.add("DROP INDEX JCR_IDX_" + refTableSuffix + "_PROPERTY");
  
        return scripts;
     }
docs: {@inheritDoc}