indexes

# File activerecord/lib/active_record/connection_adapters/sqlite3_adapter.rb, line 287
      def indexes(table_name, name = nil) #:nodoc:
        if name
          ActiveSupport::Deprecation.warn(            Passing name to #indexes is deprecated without replacement..squish)
        end

        exec_query("PRAGMA index_list(#{quote_table_name(table_name)})", "SCHEMA").map do |row|
          sql =             SELECT sql            FROM sqlite_master            WHERE name=#{quote(row['name'])} AND type='index'            UNION ALL            SELECT sql            FROM sqlite_temp_master            WHERE name=#{quote(row['name'])} AND type='index'
          index_sql = exec_query(sql).first["sql"]
          match = /\sWHERE\s+(.+)$/.match(index_sql)
          where = match[1] if match
          IndexDefinition.new(
            table_name,
            row["name"],
            row["unique"] != 0,
            exec_query("PRAGMA index_info('#{row['name']}')", "SCHEMA").map { |col|
              col["name"]
            }, nil, nil, where)
        end
      end