gistfile1.txt

gemcutter_development=# \d versions
                                         Table "public.versions"
      Column       |            Type             |                       Modifiers
-------------------+-----------------------------+-------------------------------------------------------
 id                | integer                     | not null default nextval('versions_id_seq'::regclass)
 authors           | text                        |
 description       | text                        |
 number            | character varying(255)      |
 rubygem_id        | integer                     |
 built_at          | timestamp without time zone | not null
 updated_at        | timestamp without time zone | not null
 rubyforge_project | character varying(255)      |
 summary           | text                        |
 platform          | character varying(255)      |
 created_at        | timestamp without time zone |
 indexed           | boolean                     | default true
 prerelease        | boolean                     |
 position          | integer                     |
 latest            | boolean                     |
 full_name         | character varying(255)      |
 licenses          | character varying(255)      |
Indexes:
    "versions_pkey" PRIMARY KEY, btree (id)
    "index_versions_on_rubygem_id_and_number_and_platform" UNIQUE, btree (rubygem_id, number, platform)
    "index_versions_on_built_at" btree (built_at)
    "index_versions_on_created_at" btree (created_at)
    "index_versions_on_full_name" btree (full_name)
    "index_versions_on_indexed" btree (indexed)
    "index_versions_on_number" btree (number)
    "index_versions_on_position" btree ("position")
    "index_versions_on_prerelease" btree (prerelease)
    "index_versions_on_rubygem_id" btree (rubygem_id)