indexes

# File activerecord/lib/active_record/connection_adapters/sqlite3_adapter.rb, line 402
      def indexes(table_name, name = nil) #:nodoc:
        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