docs: def _get_indexes(self, schema, **kwargs):
          """return all the indexes for the given schema"""
          # http://www.sqlite.org/pragma.html#schema
          # http://www.mail-archive.com/sqlite-users@sqlite.org/msg22055.html
          # http://stackoverflow.com/questions/604939/
          ret = {}
          rs = self._query('PRAGMA index_list({})'.format(self._normalize_table_name(schema)), **kwargs)
          if rs:
              for r in rs:
                  iname = r['name']
                  ret.setdefault(iname, [])
                  indexes = self._query('PRAGMA index_info({})'.format(r['name']), **kwargs)
                  for idict in indexes:
                      ret[iname].append(idict['name'])
  
          return ret