    # File lib/amalgalite/schema.rb, line 103
        def load_indexes( table )
          indexes = {}

          @db.prepare("SELECT name, sql FROM sqlite_master WHERE type ='index' and tbl_name = $name") do |idx_stmt|
            idx_stmt.execute( "$name" => table.name) do |idx_info|
              indexes[idx_info['name']] = Amalgalite::Index.new( idx_info['name'], idx_info['sql'], table )
            end
          end

          @db.execute("PRAGMA index_list( #{@db.quote(table.name)} );") do |idx_list|
            idx = indexes[idx_list['name']]

            # temporary indexes do not show up in the previous list
            if idx.nil? then
              idx = Amalgalite::Index.new( idx_list['name'], nil, table )
              indexes[idx_list['name']] = idx
            end

            idx.sequence_number = idx_list['seq']
            idx.unique          = Boolean.to_bool( idx_list['unique'] )

            @db.execute("PRAGMA index_info( #{@db.quote(idx.name)} );") do |col_info|
              idx.columns << table.columns[col_info['name']]
            end
          end
          return indexes
        end